• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    迪恩网络公众号

C# MxWeiXinPF类代码示例

原作者: [db:作者] 来自: [db:来源] 收藏 邀请

本文整理汇总了C#中MxWeiXinPF的典型用法代码示例。如果您正苦于以下问题:C# MxWeiXinPF类的具体用法?C# MxWeiXinPF怎么用?C# MxWeiXinPF使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。



MxWeiXinPF类属于命名空间,在下文中一共展示了MxWeiXinPF类的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的C#代码示例。

示例1: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(MxWeiXinPF.Model.wx_vote_result model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into wx_vote_result(");
            strSql.Append("baseid,itemid,openId,createDate)");
            strSql.Append(" values (");
            strSql.Append("@baseid,@itemid,@openId,@createDate)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@baseid", SqlDbType.Int,4),
                    new SqlParameter("@itemid", SqlDbType.Int,4),
                    new SqlParameter("@openId", SqlDbType.VarChar,200),
                    new SqlParameter("@createDate", SqlDbType.DateTime)};
            parameters[0].Value = model.baseid;
            parameters[1].Value = model.itemid;
            parameters[2].Value = model.openId;
            parameters[3].Value = model.createDate;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
开发者ID:yi724926089,项目名称:MyWx,代码行数:31,代码来源:wx_vote_result.cs


示例2: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(MxWeiXinPF.Model.wx_shop_catalog_attribute model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into wx_shop_catalog_attribute(");
            strSql.Append("wid,catalogId,aName,aType,aValue,createDate,sort_id)");
            strSql.Append(" values (");
            strSql.Append("@wid,@catalogId,@aName,@aType,@aValue,@createDate,@sort_id)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@wid", SqlDbType.Int,4),
                    new SqlParameter("@catalogId", SqlDbType.Int,4),
                    new SqlParameter("@aName", SqlDbType.VarChar,100),
                    new SqlParameter("@aType", SqlDbType.Int,4),
                    new SqlParameter("@aValue", SqlDbType.VarChar,2000),
                    new SqlParameter("@createDate", SqlDbType.DateTime),
                    new SqlParameter("@sort_id", SqlDbType.Int,4)};
            parameters[0].Value = model.wid;
            parameters[1].Value = model.catalogId;
            parameters[2].Value = model.aName;
            parameters[3].Value = model.aType;
            parameters[4].Value = model.aValue;
            parameters[5].Value = model.createDate;
            parameters[6].Value = model.sort_id;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
开发者ID:yi724926089,项目名称:MyWx,代码行数:37,代码来源:wx_shop_catalog_attribute.cs


示例3: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(MxWeiXinPF.Model.wx_diancai_shop_setup model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into wx_diancai_shop_setup(");
            strSql.Append("wid,unionManage,unionTel,createDate,shopid)");
            strSql.Append(" values (");
            strSql.Append("@wid,@unionManage,@unionTel,@createDate,@shopid)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@wid", SqlDbType.Int,4),
                    new SqlParameter("@unionManage", SqlDbType.VarChar,500),
                    new SqlParameter("@unionTel", SqlDbType.VarChar,100),
                    new SqlParameter("@createDate", SqlDbType.DateTime),
                    new SqlParameter("@shopid", SqlDbType.Int,4)};
            parameters[0].Value = model.wid;
            parameters[1].Value = model.unionManage;
            parameters[2].Value = model.unionTel;
            parameters[3].Value = model.createDate;
            parameters[4].Value = model.shopid;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
开发者ID:yi724926089,项目名称:MyWx,代码行数:33,代码来源:wx_diancai_shop_setup.cs


示例4: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(MxWeiXinPF.Model.wx_sjb_users model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into wx_sjb_users(");
            strSql.Append("wid,openid,uName,tel,succTimes,failTimes)");
            strSql.Append(" values (");
            strSql.Append("@wid,@openid,@uName,@tel,@succTimes,@failTimes)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@wid", SqlDbType.Int,4),
                    new SqlParameter("@openid", SqlDbType.VarChar,300),
                    new SqlParameter("@uName", SqlDbType.VarChar,100),
                    new SqlParameter("@tel", SqlDbType.VarChar,30),
                    new SqlParameter("@succTimes", SqlDbType.Int,4),
                    new SqlParameter("@failTimes", SqlDbType.Int,4)};
            parameters[0].Value = model.wid;
            parameters[1].Value = model.openid;
            parameters[2].Value = model.uName;
            parameters[3].Value = model.tel;
            parameters[4].Value = model.succTimes;
            parameters[5].Value = model.failTimes;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
开发者ID:yi724926089,项目名称:MyWx,代码行数:35,代码来源:wx_sjb_users.cs


示例5: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(MxWeiXinPF.Model.wx_xt_user model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into wx_xt_user(");
            strSql.Append("bId,openid,uName,phone,pNum,createDate)");
            strSql.Append(" values (");
            strSql.Append("@bId,@openid,@uName,@phone,@pNum,@createDate)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@bId", SqlDbType.Int,4),
                    new SqlParameter("@openid", SqlDbType.VarChar,200),
                    new SqlParameter("@uName", SqlDbType.VarChar,100),
                    new SqlParameter("@phone", SqlDbType.VarChar,100),
                    new SqlParameter("@pNum", SqlDbType.Int,4),
                    new SqlParameter("@createDate", SqlDbType.DateTime)};
            parameters[0].Value = model.bId;
            parameters[1].Value = model.openid;
            parameters[2].Value = model.uName;
            parameters[3].Value = model.phone;
            parameters[4].Value = model.pNum;
            parameters[5].Value = model.createDate;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
开发者ID:yi724926089,项目名称:MyWx,代码行数:35,代码来源:wx_xt_user.cs


示例6: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(MxWeiXinPF.Model.wx_ucard_adver model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into wx_ucard_adver(");
            strSql.Append("wid,adverName,picUrl,linkUrl,isShow,sort_id,createDate)");
            strSql.Append(" values (");
            strSql.Append("@wid,@adverName,@picUrl,@linkUrl,@isShow,@sort_id,@createDate)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@wid", SqlDbType.Int,4),
                    new SqlParameter("@adverName", SqlDbType.VarChar,50),
                    new SqlParameter("@picUrl", SqlDbType.VarChar,800),
                    new SqlParameter("@linkUrl", SqlDbType.VarChar,200),
                    new SqlParameter("@isShow", SqlDbType.Bit,1),
                    new SqlParameter("@sort_id", SqlDbType.Int,4),
                    new SqlParameter("@createDate", SqlDbType.DateTime)};
            parameters[0].Value = model.wid;
            parameters[1].Value = model.adverName;
            parameters[2].Value = model.picUrl;
            parameters[3].Value = model.linkUrl;
            parameters[4].Value = model.isShow;
            parameters[5].Value = model.sort_id;
            parameters[6].Value = model.createDate;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
开发者ID:yi724926089,项目名称:MyWx,代码行数:37,代码来源:wx_ucard_adver.cs


示例7: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(MxWeiXinPF.Model.wx_ucard_sys model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into wx_ucard_sys(");
            strSql.Append("wid,tradeTel,tradeContent,cardType,createDate)");
            strSql.Append(" values (");
            strSql.Append("@wid,@tradeTel,@tradeContent,@cardType,@createDate)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@wid", SqlDbType.Int,4),
                    new SqlParameter("@tradeTel", SqlDbType.VarChar,50),
                    new SqlParameter("@tradeContent", SqlDbType.VarChar,1500),
                    new SqlParameter("@cardType", SqlDbType.Int,4),
                    new SqlParameter("@createDate", SqlDbType.DateTime)};
            parameters[0].Value = model.wid;
            parameters[1].Value = model.tradeTel;
            parameters[2].Value = model.tradeContent;
            parameters[3].Value = model.cardType;
            parameters[4].Value = model.createDate;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
开发者ID:yi724926089,项目名称:MyWx,代码行数:33,代码来源:wx_ucard_sys.cs


示例8: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(MxWeiXinPF.Model.wx_albums_sys model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into wx_albums_sys(");
            strSql.Append("wid,bannerPic,code,typeId,typeName)");
            strSql.Append(" values (");
            strSql.Append("@wid,@bannerPic,@code,@typeId,@typeName)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@wid", SqlDbType.Int,4),
                    new SqlParameter("@bannerPic", SqlDbType.VarChar,1000),
                    new SqlParameter("@code", SqlDbType.VarChar,500),
                    new SqlParameter("@typeId", SqlDbType.Int,4),
                    new SqlParameter("@typeName", SqlDbType.VarChar,500)};
            parameters[0].Value = model.wid;
            parameters[1].Value = model.bannerPic;
            parameters[2].Value = model.code;
            parameters[3].Value = model.typeId;
            parameters[4].Value = model.typeName;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
开发者ID:yi724926089,项目名称:MyWx,代码行数:33,代码来源:wx_albums_sys.cs


示例9: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(MxWeiXinPF.Model.wx_payment_type model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into wx_payment_type(");
            strSql.Append("id,typeCode,typeName,remark,sort_id,img_url,api_path)");
            strSql.Append(" values (");
            strSql.Append("@id,@typeCode,@typeName,@remark,@sort_id,@img_url,@api_path)");
            SqlParameter[] parameters = {
                    new SqlParameter("@id", SqlDbType.Int,4),
                    new SqlParameter("@typeCode", SqlDbType.VarChar,30),
                    new SqlParameter("@typeName", SqlDbType.VarChar,100),
                    new SqlParameter("@remark", SqlDbType.VarChar,1500),
                    new SqlParameter("@sort_id", SqlDbType.Int,4),
                    new SqlParameter("@img_url", SqlDbType.VarChar,800),
                    new SqlParameter("@api_path", SqlDbType.VarChar,100)};
            parameters[0].Value = model.id;
            parameters[1].Value = model.typeCode;
            parameters[2].Value = model.typeName;
            parameters[3].Value = model.remark;
            parameters[4].Value = model.sort_id;
            parameters[5].Value = model.img_url;
            parameters[6].Value = model.api_path;

            int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
开发者ID:yi724926089,项目名称:MyWx,代码行数:36,代码来源:wx_payment_type.cs


示例10: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(MxWeiXinPF.Model.wx_shop_catalog model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into wx_shop_catalog(");
            strSql.Append("wid,cTitle,remark,sort_id,createDate)");
            strSql.Append(" values (");
            strSql.Append("@wid,@cTitle,@remark,@sort_id,@createDate)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@wid", SqlDbType.Int,4),
                    new SqlParameter("@cTitle", SqlDbType.VarChar,4000),
                    new SqlParameter("@remark", SqlDbType.VarChar,2000),
                    new SqlParameter("@sort_id", SqlDbType.Int,4),
                    new SqlParameter("@createDate", SqlDbType.DateTime)};
            parameters[0].Value = model.wid;
            parameters[1].Value = model.cTitle;
            parameters[2].Value = model.remark;
            parameters[3].Value = model.sort_id;
            parameters[4].Value = model.createDate;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
开发者ID:yi724926089,项目名称:MyWx,代码行数:33,代码来源:wx_shop_catalog.cs


示例11: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(MxWeiXinPF.Model.wx_shop_productAttr_value model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into wx_shop_productAttr_value(");
            strSql.Append("attributeId,productId,paValue)");
            strSql.Append(" values (");
            strSql.Append("@attributeId,@productId,@paValue)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@attributeId", SqlDbType.Int,4),
                    new SqlParameter("@productId", SqlDbType.Int,4),
                    new SqlParameter("@paValue", SqlDbType.VarChar,4000)};
            parameters[0].Value = model.attributeId;
            parameters[1].Value = model.productId;
            parameters[2].Value = model.paValue;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
开发者ID:yi724926089,项目名称:MyWx,代码行数:29,代码来源:wx_shop_productAttr_value.cs


示例12: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(MxWeiXinPF.Model.wx_dzpUsersTemp model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into wx_dzpUsersTemp(");
            strSql.Append("actId,openid,times,createDate)");
            strSql.Append(" values (");
            strSql.Append("@actId,@openid,@times,@createDate)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@actId", SqlDbType.Int,4),
                    new SqlParameter("@openid", SqlDbType.VarChar,100),
                    new SqlParameter("@times", SqlDbType.Int,4),
                    new SqlParameter("@createDate", SqlDbType.DateTime)};
            parameters[0].Value = model.actId;
            parameters[1].Value = model.openid;
            parameters[2].Value = model.times;
            parameters[3].Value = model.createDate;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
开发者ID:yi724926089,项目名称:MyWx,代码行数:31,代码来源:wx_dzpUsersTemp.cs


示例13: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(MxWeiXinPF.Model.wx_yy_result model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into wx_yy_result(");
            strSql.Append("formId,openid,cName,cId,userResult,createDate)");
            strSql.Append(" values (");
            strSql.Append("@formId,@openid,@cName,@cId,@userResult,@createDate)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@formId", SqlDbType.Int,4),
                    new SqlParameter("@openid", SqlDbType.VarChar,100),
                    new SqlParameter("@cName", SqlDbType.VarChar,100),
                    new SqlParameter("@cId", SqlDbType.Int,4),
                    new SqlParameter("@userResult", SqlDbType.VarChar,2000),
                    new SqlParameter("@createDate", SqlDbType.DateTime)};
            parameters[0].Value = model.formId;
            parameters[1].Value = model.openid;
            parameters[2].Value = model.cName;
            parameters[3].Value = model.cId;
            parameters[4].Value = model.userResult;
            parameters[5].Value = model.createDate;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
开发者ID:yi724926089,项目名称:MyWx,代码行数:35,代码来源:wx_yy_result.cs


示例14: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(MxWeiXinPF.Model.pre_common_district model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into pre_common_district(");
            strSql.Append("id,name,level,upid)");
            strSql.Append(" values (");
            strSql.Append("@id,@name,@level,@upid)");
            SqlParameter[] parameters = {
                    new SqlParameter("@id", SqlDbType.Int,4),
                    new SqlParameter("@name", SqlDbType.NVarChar,255),
                    new SqlParameter("@level", SqlDbType.Int,4),
                    new SqlParameter("@upid", SqlDbType.Int,4)};
            parameters[0].Value = model.id;
            parameters[1].Value = model.name;
            parameters[2].Value = model.level;
            parameters[3].Value = model.upid;

            int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
开发者ID:yi724926089,项目名称:MyWx,代码行数:30,代码来源:pre_common_district.cs


示例15: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(MxWeiXinPF.Model.wx_shop_sku model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into wx_shop_sku(");
            strSql.Append("productId,sku,stock,price,attributeValue,attributeId)");
            strSql.Append(" values (");
            strSql.Append("@productId,@sku,@stock,@price,@attributeValue,@attributeId)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@productId", SqlDbType.Int,4),
                    new SqlParameter("@sku", SqlDbType.VarChar,16),
                    new SqlParameter("@stock", SqlDbType.Int,4),
                    new SqlParameter("@price", SqlDbType.Float,8),
                    new SqlParameter("@attributeValue", SqlDbType.VarChar,500),
                    new SqlParameter("@attributeId", SqlDbType.Int,4)};
            parameters[0].Value = model.productId;
            parameters[1].Value = model.sku;
            parameters[2].Value = model.stock;
            parameters[3].Value = model.price;
            parameters[4].Value = model.attributeValue;
            parameters[5].Value = model.attributeId;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
开发者ID:yi724926089,项目名称:MyWx,代码行数:35,代码来源:wx_shop_sku.cs


示例16: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(MxWeiXinPF.Model.wx_xt_photo model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into wx_xt_photo(");
            strSql.Append("bId,pName,pUrl,remark,seq)");
            strSql.Append(" values (");
            strSql.Append("@bId,@pName,@pUrl,@remark,@seq)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@bId", SqlDbType.Int,4),
                    new SqlParameter("@pName", SqlDbType.VarChar,200),
                    new SqlParameter("@pUrl", SqlDbType.VarChar,1000),
                    new SqlParameter("@remark", SqlDbType.VarChar,1000),
                    new SqlParameter("@seq", SqlDbType.Int,4)};
            parameters[0].Value = model.bId;
            parameters[1].Value = model.pName;
            parameters[2].Value = model.pUrl;
            parameters[3].Value = model.remark;
            parameters[4].Value = model.seq;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
开发者ID:yi724926089,项目名称:MyWx,代码行数:33,代码来源:wx_xt_photo.cs


示例17: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(MxWeiXinPF.Model.wx_diancai_caipin_category model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into wx_diancai_caipin_category(");
            strSql.Append("shopid,sortid,categoryName,miaoshu,isStart,createDate)");
            strSql.Append(" values (");
            strSql.Append("@shopid,@sortid,@categoryName,@miaoshu,@isStart,@createDate)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@shopid", SqlDbType.Int,4),
                    new SqlParameter("@sortid", SqlDbType.Int,4),
                    new SqlParameter("@categoryName", SqlDbType.VarChar,100),
                    new SqlParameter("@miaoshu", SqlDbType.VarChar,100),
                    new SqlParameter("@isStart", SqlDbType.Bit,1),
                    new SqlParameter("@createDate", SqlDbType.DateTime)};
            parameters[0].Value = model.shopid;
            parameters[1].Value = model.sortid;
            parameters[2].Value = model.categoryName;
            parameters[3].Value = model.miaoshu;
            parameters[4].Value = model.isStart;
            parameters[5].Value = model.createDate;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
开发者ID:yi724926089,项目名称:MyWx,代码行数:35,代码来源:wx_diancai_caipin_category.cs


示例18: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(MxWeiXinPF.Model.wx_ucard_usercard model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into wx_ucard_usercard(");
            strSql.Append("id,uid,sid,addDate)");
            strSql.Append(" values (");
            strSql.Append("@id,@uid,@sid,@addDate)");
            SqlParameter[] parameters = {
                    new SqlParameter("@id", SqlDbType.Int,4),
                    new SqlParameter("@uid", SqlDbType.Int,4),
                    new SqlParameter("@sid", SqlDbType.Int,4),
                    new SqlParameter("@addDate", SqlDbType.DateTime)};
            parameters[0].Value = model.id;
            parameters[1].Value = model.uid;
            parameters[2].Value = model.sid;
            parameters[3].Value = model.addDate;

            int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
开发者ID:yi724926089,项目名称:MyWx,代码行数:30,代码来源:wx_ucard_usercard.cs


示例19: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(MxWeiXinPF.Model.wx_ggkAwardItem model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into wx_ggkAwardItem(");
            strSql.Append("actId,jxName,jpName,jpNum,jpRealNum,sort_id,createDate)");
            strSql.Append(" values (");
            strSql.Append("@actId,@jxName,@jpName,@jpNum,@jpRealNum,@sort_id,@createDate)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@actId", SqlDbType.Int,4),
                    new SqlParameter("@jxName", SqlDbType.VarChar,50),
                    new SqlParameter("@jpName", SqlDbType.VarChar,200),
                    new SqlParameter("@jpNum", SqlDbType.Int,4),
                    new SqlParameter("@jpRealNum", SqlDbType.Int,4),
                    new SqlParameter("@sort_id", SqlDbType.Int,4),
                    new SqlParameter("@createDate", SqlDbType.DateTime)};
            parameters[0].Value = model.actId;
            parameters[1].Value = model.jxName;
            parameters[2].Value = model.jpName;
            parameters[3].Value = model.jpNum;
            parameters[4].Value = model.jpRealNum;
            parameters[5].Value = model.sort_id;
            parameters[6].Value = model.createDate;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
开发者ID:yi724926089,项目名称:MyWx,代码行数:37,代码来源:wx_ggkAwardItem.cs


示例20: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(MxWeiXinPF.Model.wx_sq_heimd model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into wx_sq_heimd(");
            strSql.Append("aid,openid,createDate,remark)");
            strSql.Append(" values (");
            strSql.Append("@aid,@openid,@createDate,@remark)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@aid", SqlDbType.Int,4),
                    new SqlParameter("@openid", SqlDbType.VarChar,100),
                    new SqlParameter("@createDate", SqlDbType.DateTime),
                    new SqlParameter("@remark", SqlDbType.VarChar,500)};
            parameters[0].Value = model.aid;
            parameters[1].Value = model.openid;
            parameters[2].Value = model.createDate;
            parameters[3].Value = model.remark;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
            if (obj == null)
            {
                return 0;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
开发者ID:yi724926089,项目名称:MyWx,代码行数:31,代码来源:wx_sq_heimd.cs



注:本文中的MxWeiXinPF类示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。


鲜花

握手

雷人

路过

鸡蛋
该文章已有0人参与评论

请发表评论

全部评论

专题导读
上一篇:
C# MyAggregateRoot类代码示例发布时间:2022-05-24
下一篇:
C# MvxValueEventArgs类代码示例发布时间:2022-05-24
热门推荐
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服(服务时间 9:00~18:00)

在线QQ客服
地址:深圳市南山区西丽大学城创智工业园
电邮:jeky_zhao#qq.com
移动电话:139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap