欧美性猛交XXXX免费看蜜桃,成人网18免费韩国,亚洲国产成人精品区综合,欧美日韩一区二区三区高清不卡,亚洲综合一区二区精品久久

打開(kāi)APP
userphoto
未登錄

開(kāi)通VIP,暢享免費電子書(shū)等14項超值服

開(kāi)通VIP
C# 存儲過(guò)程用法【C#存儲過(guò)程使用流程、實(shí)例】
1、實(shí)體類(lèi):Model
2、接口類(lèi):IDAL
using System;
using System.Collections.Generic;
using System.Data;

namespace isports.IDAL
{
    public interface IAdmin
    {
            DataSet sp_getInitDevice(string key, int flage);

        /// <summary>
        /// 設置愛(ài)動(dòng)卡管理員權限
        /// </summary>
        /// <param name="roleid"></param>
        /// <param name="popedom"></param>
        /// <param name="userid"></param>
        /// <param name="userip"></param>
        /// <param name="result"></param>
        /// <param name="msg"></param>
        void sp_setCardPopedom(int roleid, string popedom, int userid, string userip, out int result, out string msg);
        /// <summary>
        /// 在線(xiàn)時(shí)長(cháng)達到時(shí),添加會(huì )員卡路里
        /// </summary>
        /// <param name="userid">用戶(hù)ID</param>
        /// <param name="iminutes">在線(xiàn)時(shí)長(cháng)</param>
        /// <param name="userip">用戶(hù)IP</param>
    }
}
3、繼承類(lèi):BLL
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using isports.Common;
using isports.IDAL;
using isports.Model;

namespace isports.BLL
{
    public class Admin : IAdmin
    {
        NBear.Data.Gateway gw;
        public Admin()
        {
            gw = Common.Fetch.GetWay();
        }
            /// <summary>
        /// 獲取教練/場(chǎng)館頭像
        /// </summary>
        /// <param name="id"></param>
        /// <param name="flag"></param>
        /// <returns></returns>
        public DataSet getpic(int id, int flag)
        {
            object[] objOut = new object[] { 0, "" };
            DataSet ds = null;
            try
            {
                ds = gw.ExecuteProcedure("sp_UpdatePic", new string[] { "@id", "@flag", "@url" }
                    , new object[] { id, flag, "" }
                    , new string[] { }, new DbType[] { DbType.Int32 }, out objOut);
                //int.TryParse(string.Format("{0}", objOut[0]), out pageno);

            }
            catch (Exception ex)
            {
                ds = null;
                //pageno = 0;
            }
            return ds;
        }
        /// <summary>
        /// 修改教練以及場(chǎng)館頭像
        /// </summary>
        /// <param name="id">教練/場(chǎng)館id</param>
        /// <param name="picUrl">圖片地址</param>
        /// <param name="flag">1.場(chǎng)館0.教練</param>
        /// <param name="result"></param>
        public void updatepic(int id, string picUrl, int flag, out int result)
        {
            object[] objOut = new object[] { 0, "" };
            try
            {
                gw.ExecuteProcedureNonQuery("sp_UpdatePic", new string[] { "@id", "@flag", "@url" }, new object[] { id, flag, picUrl },
                    new string[] { }, new DbType[] { }, out objOut);
                result = 0;
            }
            catch
            {
                result = 1;

         
    }
}
4、常用類(lèi):Common
5、ajax
  #region 注冊用戶(hù)
        private void createuser()
        {
            string email = Fetch.Get("email");
            string password = Fetch.Get("password");
            string mobile = Fetch.Get("mobile");
            string temp = password.Substring(0, password.Length - 6);
            int regfrom = 0;
            string question = Fetch.Get("cardid");
            string rettype = Fetch.Get("regtype");
            string answer = Fetch.Get("answer");
            string userip = Page.Request.UserHostAddress;
            int result = 0;
            string msg = string.Empty;
            iuser.regUser("", temp, rettype, mobile, email, regfrom, userip, question, answer, out result, out msg);
            string itemp = result.ToString() + "@" + msg;
            password = password.Substring(0, 6);
            password = Common.Text.MD5(password);
            DataSet ds = iuser.sp_login(email, password, Fetch.UserIp, out result, out msg);
            if (ds != null && ds.Tables.Count > 0)
            {
                DataTable dt = ds.Tables[0];
                commonfunction.SaveLoginCookie(dt.Rows[0]);
            }
            Response.Write(itemp);//打印值
            Response.End();

        }
        #endregion
本站僅提供存儲服務(wù),所有內容均由用戶(hù)發(fā)布,如發(fā)現有害或侵權內容,請點(diǎn)擊舉報。
打開(kāi)APP,閱讀全文并永久保存 查看更多類(lèi)似文章
猜你喜歡
類(lèi)似文章
為ASP.NET封裝的SQL數據庫訪(fǎng)問(wèn)類(lèi)
獲取IP地址,由IP地址獲得用戶(hù)地理位置
C# 利用log4net 把日志寫(xiě)入到數據庫
java調用存儲過(guò)程實(shí)現批量入庫
利用OleDb方式對DataSet 和 Excel 數據快速導入導出
數據庫連接類(lèi),繼承自PDO
更多類(lèi)似文章 >>
生活服務(wù)
分享 收藏 導長(cháng)圖 關(guān)注 下載文章
綁定賬號成功
后續可登錄賬號暢享VIP特權!
如果VIP功能使用有故障,
可點(diǎn)擊這里聯(lián)系客服!

聯(lián)系客服

欧美性猛交XXXX免费看蜜桃,成人网18免费韩国,亚洲国产成人精品区综合,欧美日韩一区二区三区高清不卡,亚洲综合一区二区精品久久