C# WechatBuilder类代码示例

OStack程序员社区-中国程序员成长平台 › 门户 › 编程› c#›C#教程

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

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

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

示例1: Update

		/// <summary>
		/// 更新一条数据
		/// </summary>
		public bool Update(WechatBuilder.Model.wx_ucard_sys model)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("update wx_ucard_sys set ");
			strSql.Append("[email protected],");
			strSql.Append("[email protected],");
			strSql.Append("[email protected],");
			strSql.Append("[email protected],");
			strSql.Append("[email protected]");
			strSql.Append(" where [email protected]");
			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),
					new SqlParameter("@id", SqlDbType.Int,4)};
			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;
			parameters[5].Value = model.id;

			int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
			if (rows > 0)
			{
				return true;
			}
			else
			{
				return false;
			}
		}

开发者ID:wujiang1984，项目名称:WechatBuilder，代码行数:37，代码来源:wx_ucard_sys.cs

示例2: Add

		/// <summary>
		/// 增加一条数据
		/// </summary>
		public int Add(WechatBuilder.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:wujiang1984，项目名称:WechatBuilder，代码行数:33，代码来源:wx_albums_sys.cs

示例3: Add

		/// <summary>
		/// 增加一条数据
		/// </summary>
		public int Add(WechatBuilder.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:wujiang1984，项目名称:WechatBuilder，代码行数:35，代码来源:wx_shop_sku.cs

示例4: Add

		/// <summary>
		/// 增加一条数据
		/// </summary>
		public int Add(WechatBuilder.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:wujiang1984，项目名称:WechatBuilder，代码行数:37，代码来源:wx_ucard_adver.cs

示例5: Update

		/// <summary>
		/// 更新一条数据
		/// </summary>
		public bool Update(WechatBuilder.Model.wx_dzpUsersTemp model)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("update wx_dzpUsersTemp set ");
			strSql.Append("[email protected],");
			strSql.Append("[email protected],");
			strSql.Append("[email protected],");
			strSql.Append("[email protected]");
			strSql.Append(" where [email protected]");
			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),
					new SqlParameter("@id", SqlDbType.Int,4)};
			parameters[0].Value = model.actId;
			parameters[1].Value = model.openid;
			parameters[2].Value = model.times;
			parameters[3].Value = model.createDate;
			parameters[4].Value = model.id;

			int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
			if (rows > 0)
			{
				return true;
			}
			else
			{
				return false;
			}
		}

开发者ID:wujiang1984，项目名称:WechatBuilder，代码行数:34，代码来源:wx_dzpUsersTemp.cs

示例6: Add

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

			object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
			if (obj == null)
			{
				return 0;
			}
			else
			{
				return Convert.ToInt32(obj);
			}
		}

开发者ID:wujiang1984，项目名称:WechatBuilder，代码行数:33，代码来源:wx_sq_piclist.cs

示例7: Add

		/// <summary>
		/// 增加一条数据
		/// </summary>
		public bool Add(WechatBuilder.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:wujiang1984，项目名称:WechatBuilder，代码行数:30，代码来源:wx_ucard_usercard.cs

示例8: Update

		/// <summary>
		/// 更新一条数据
		/// </summary>
		public bool Update(WechatBuilder.Model.wx_diancai_shop_setup model)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("update wx_diancai_shop_setup set ");
			strSql.Append("[email protected],");
			strSql.Append("[email protected],");
			strSql.Append("[email protected],");
			strSql.Append("[email protected],");
			strSql.Append("[email protected]");
			strSql.Append(" where [email protected]");
			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),
					new SqlParameter("@id", 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;
			parameters[5].Value = model.id;

			int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
			if (rows > 0)
			{
				return true;
			}
			else
			{
				return false;
			}
		}

开发者ID:wujiang1984，项目名称:WechatBuilder，代码行数:37，代码来源:wx_diancai_shop_setup.cs

示例9: Add

		/// <summary>
		/// 增加一条数据
		/// </summary>
		public bool Add(WechatBuilder.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:wujiang1984，项目名称:WechatBuilder，代码行数:36，代码来源:wx_payment_type.cs

示例10: Add

		/// <summary>
		/// 增加一条数据
		/// </summary>
		public int Add(WechatBuilder.Model.wx_wsite_setting model)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("insert into wx_wsite_setting(");
			strSql.Append("wId,wName,companyName,bgMusic,bgPic,bgDongHuaId,wCopyright,wBrief,remark,phone,addr,addrUrl,email,seo_title,seo_keywords,seo_desc,createDate,extInt,extStr,extStr2)");
			strSql.Append(" values (");
			strSql.Append("@wId,@wName,@companyName,@bgMusic,@bgPic,@bgDongHuaId,@wCopyright,@wBrief,@remark,@phone,@addr,@addrUrl,@email,@seo_title,@seo_keywords,@seo_desc,@createDate,@extInt,@extStr,@extStr2)");
			strSql.Append(";select @@IDENTITY");
			SqlParameter[] parameters = {
					new SqlParameter("@wId", SqlDbType.Int,4),
					new SqlParameter("@wName", SqlDbType.VarChar,500),
					new SqlParameter("@companyName", SqlDbType.VarChar,500),
					new SqlParameter("@bgMusic", SqlDbType.VarChar,800),
					new SqlParameter("@bgPic", SqlDbType.VarChar,800),
					new SqlParameter("@bgDongHuaId", SqlDbType.Int,4),
					new SqlParameter("@wCopyright", SqlDbType.VarChar,500),
					new SqlParameter("@wBrief", SqlDbType.VarChar,500),
					new SqlParameter("@remark", SqlDbType.VarChar,2000),
					new SqlParameter("@phone", SqlDbType.VarChar,200),
					new SqlParameter("@addr", SqlDbType.VarChar,1000),
					new SqlParameter("@addrUrl", SqlDbType.VarChar,1000),
					new SqlParameter("@email", SqlDbType.VarChar,200),
					new SqlParameter("@seo_title", SqlDbType.VarChar,500),
					new SqlParameter("@seo_keywords", SqlDbType.VarChar,500),
					new SqlParameter("@seo_desc", SqlDbType.VarChar,1000),
					new SqlParameter("@createDate", SqlDbType.DateTime),
					new SqlParameter("@extInt", SqlDbType.Int,4),
					new SqlParameter("@extStr", SqlDbType.VarChar,500),
					new SqlParameter("@extStr2", SqlDbType.VarChar,800)};
			parameters[0].Value = model.wId;
			parameters[1].Value = model.wName;
			parameters[2].Value = model.companyName;
			parameters[3].Value = model.bgMusic;
			parameters[4].Value = model.bgPic;
			parameters[5].Value = model.bgDongHuaId;
			parameters[6].Value = model.wCopyright;
			parameters[7].Value = model.wBrief;
			parameters[8].Value = model.remark;
			parameters[9].Value = model.phone;
			parameters[10].Value = model.addr;
			parameters[11].Value = model.addrUrl;
			parameters[12].Value = model.email;
			parameters[13].Value = model.seo_title;
			parameters[14].Value = model.seo_keywords;
			parameters[15].Value = model.seo_desc;
			parameters[16].Value = model.createDate;
			parameters[17].Value = model.extInt;
			parameters[18].Value = model.extStr;
			parameters[19].Value = model.extStr2;

			object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
			if (obj == null)
			{
				return 0;
			}
			else
			{
				return Convert.ToInt32(obj);
			}
		}

开发者ID:wujiang1984，项目名称:WechatBuilder，代码行数:63，代码来源:wx_wsite_setting.cs

示例11: Add

		/// <summary>
		/// 增加一条数据
		/// </summary>
		public int Add(WechatBuilder.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:wujiang1984，项目名称:WechatBuilder，代码行数:33，代码来源:wx_diancai_shop_setup.cs

示例12: Update

        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(WechatBuilder.Model.wx_diancai_blacklist model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update wx_diancai_blacklist set ");
            strSql.Append("[email protected],");
            strSql.Append("[email protected],");
            strSql.Append("[email protected],");
            strSql.Append("[email protected],");
            strSql.Append("[email protected]");
            strSql.Append(" where [email protected]");
            SqlParameter[] parameters = {
					new SqlParameter("@openid", SqlDbType.VarChar,300),
					new SqlParameter("@blackName", SqlDbType.VarChar,100),
					new SqlParameter("@blackDate", SqlDbType.DateTime),
					new SqlParameter("@createDate", SqlDbType.DateTime),
					new SqlParameter("@shopid", SqlDbType.Int,4),
					new SqlParameter("@id", SqlDbType.Int,4)};
            parameters[0].Value = model.openid;
            parameters[1].Value = model.blackName;
            parameters[2].Value = model.blackDate;
            parameters[3].Value = model.createDate;
            parameters[4].Value = model.shopid;
            parameters[5].Value = model.id;

            int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }

开发者ID:wujiang1984，项目名称:WechatBuilder，代码行数:37，代码来源:wx_diancai_blacklist.cs

示例13: Add

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(WechatBuilder.Model.wx_diancai_blacklist model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into wx_diancai_blacklist(");
            strSql.Append("openid,blackName,blackDate,createDate,shopid)");
            strSql.Append(" values (");
            strSql.Append("@openid,@blackName,@blackDate,@createDate,@shopid)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
					new SqlParameter("@openid", SqlDbType.VarChar,300),
					new SqlParameter("@blackName", SqlDbType.VarChar,100),
					new SqlParameter("@blackDate", SqlDbType.DateTime),
					new SqlParameter("@createDate", SqlDbType.DateTime),
					new SqlParameter("@shopid", SqlDbType.Int,4)};
            parameters[0].Value = model.openid;
            parameters[1].Value = model.blackName;
            parameters[2].Value = model.blackDate;
            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:wujiang1984，项目名称:WechatBuilder，代码行数:33，代码来源:wx_diancai_blacklist.cs

示例14: Add

		/// <summary>
		/// 增加一条数据
		/// </summary>
		public int Add(WechatBuilder.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:wujiang1984，项目名称:WechatBuilder，代码行数:35，代码来源:wx_xt_user.cs

示例15: Update

		/// <summary>
		/// 更新一条数据
		/// </summary>
		public bool Update(WechatBuilder.Model.wx_vote_result model)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("update wx_vote_result set ");
			strSql.Append("[email protected],");
			strSql.Append("[email protected],");
			strSql.Append("[email protected],");
			strSql.Append("[email protected]");
			strSql.Append(" where [email protected]");
			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),
					new SqlParameter("@id", SqlDbType.Int,4)};
			parameters[0].Value = model.baseid;
			parameters[1].Value = model.itemid;
			parameters[2].Value = model.openId;
			parameters[3].Value = model.createDate;
			parameters[4].Value = model.id;

			int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
			if (rows > 0)
			{
				return true;
			}
			else
			{
				return false;
			}
		}

开发者ID:wujiang1984，项目名称:WechatBuilder，代码行数:34，代码来源:wx_vote_result.cs

示例16: Add

		/// <summary>
		/// 增加一条数据
		/// </summary>
		public int Add(WechatBuilder.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:wujiang1984，项目名称:WechatBuilder，代码行数:35，代码来源:wx_diancai_caipin_category.cs

示例17: Add

		/// <summary>
		/// 增加一条数据
		/// </summary>
		public int Add(WechatBuilder.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:wujiang1984，项目名称:WechatBuilder，代码行数:37，代码来源:wx_shop_catalog_attribute.cs

示例18: Add

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

			object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
			if (obj == null)
			{
				return 0;
			}
			else
			{
				return Convert.ToInt32(obj);
			}
		}

开发者ID:wujiang1984，项目名称:WechatBuilder，代码行数:35，代码来源:wx_ucard_notice.cs

示例19: Update

		/// <summary>
		/// 更新一条数据
		/// </summary>
		public bool Update(WechatBuilder.Model.wx_sq_piclist model)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("update wx_sq_piclist set ");
			strSql.Append("[email protected],");
			strSql.Append("[email protected],");
			strSql.Append("[email protected],");
			strSql.Append("[email protected],");
			strSql.Append("[email protected]");
			strSql.Append(" where [email protected]");
			SqlParameter[] parameters = {
					new SqlParameter("@aid", SqlDbType.Int,4),
					new SqlParameter("@openid", SqlDbType.VarChar,100),
					new SqlParameter("@picUrl", SqlDbType.VarChar,800),
					new SqlParameter("@createDate", SqlDbType.DateTime),
					new SqlParameter("@hasShenghe", SqlDbType.Bit,1),
					new SqlParameter("@id", SqlDbType.Int,4)};
			parameters[0].Value = model.aid;
			parameters[1].Value = model.openid;
			parameters[2].Value = model.picUrl;
			parameters[3].Value = model.createDate;
			parameters[4].Value = model.hasShenghe;
			parameters[5].Value = model.id;

			int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
			if (rows > 0)
			{
				return true;
			}
			else
			{
				return false;
			}
		}

开发者ID:wujiang1984，项目名称:WechatBuilder，代码行数:37，代码来源:wx_sq_piclist.cs

示例20: Add

		/// <summary>
		/// 增加一条数据
		/// </summary>
		public int Add(WechatBuilder.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:wujiang1984，项目名称:WechatBuilder，代码行数:29，代码来源:wx_shop_productAttr_value.cs

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

鲜花

握手

雷人

路过

鸡蛋

该文章已有0人参与评论

请发表评论

全部评论

专题导读

More+

10-27 六六分期app的软件客服如何联系？(六六分期

11-06 可心卡盟:win10系统火狐flash插件崩溃怎么

11-06 亲亲特价:怎么删除回收站图标

11-06 济南大学虚拟社区:鲁大师节能降温的具体办

11-06 xlueops.exe:无线网络安装向导

11-06 女斗合众国:win7系统cf与主机连接不稳定怎

11-06 0xc000022-[cf烟雾头]cf怎么调烟雾头

11-06 qizideyouhuo:应用程序无法正常启动0xc0000

11-06 ipz-185:win7系统vcf文件怎么打开

11-06 傻哥蹦迪:win10系统s4怎么打开usb调试

11-06 八神浩树gtaste:回收站清空了怎么恢复

11-06 妖尾之黑色守护:win10系统电脑没有1440x900

11-06 校园至尊魔王小说:win7系统浏览网页时字体

11-06 女斗合众国:win10系统访问共享文件夹提示请

11-06 tokyo hot n0654:恢复win7系统默认字体一招

11-06 雨酷仙境:设置win7系统转移临时文件夹腾出

11-06 阿穆纳伊之杖:win7系统开始菜单在右边还原

11-06 tunespotting:win10系统火狐flash插件总是

11-06 甘尔葛分析师：计谋网站seo关键词暴涨有什

11-06 蔡贵霖: 计谋网站seo关键词暴涨有什么秘密

11-06 博益网首页:ao3网页版进入不了解决方法

11-06 漏斗子专栏: 网站数据分析小白易懂精华篇

11-06 见证双虹怎么做:win7系统开启telnet命令的

11-06 颾狐蝶蜋:系统资源不足无法完成请求的服务

11-06 国光中学校歌:提交网站到alexa查询详细步骤

11-06 西安有情天:静态网页和动态网页的区别

11-06 红木雅尚斋:外部链接构造对网站的好处

11-06 前官礼遇：防止域名劫持–增强域安全性的10

11-06 密传二转答案: 中文分词算法有哪些

11-06 金泉家园邮编:百度快照劫持的表现及应对方

C# Docking.AutoHideStripSkin类代码示例发布时间：2022-05-24

C# Web_Language_Enum类代码示例发布时间：2022-05-24

剪的笔顺,诠释剪的笔画,认识剪的部首

1 六六分期app的软件客服如何联系？(六六分期

六六分期app的软件客服如何联系？不知道吗？加qq群【895510560】即可！标题：六六分期

阅读：19157|2023-10-27

2 可心卡盟:win10系统火狐flash插件崩溃怎么

今天小编告诉大家如何处理win10系统火狐flash插件总是崩溃的问题，可能很多用户都不知

阅读：9981|2022-11-06

3 亲亲特价:怎么删除回收站图标

今天小编告诉大家如何对win10系统删除桌面回收站图标进行设置，可能很多用户都不知道

阅读：8320|2022-11-06

4 济南大学虚拟社区:鲁大师节能降温的具体办

今天小编告诉大家如何对win10系统电脑设置节能降温的设置方法，想必大家都遇到过需要

阅读：8690|2022-11-06

5 xlueops.exe:无线网络安装向导

我们在使用xp系统的过程中,经常需要对xp系统无线网络安装向导设置进行设置，可能很多

阅读：8632|2022-11-06

6 女斗合众国:win7系统cf与主机连接不稳定怎

今天小编告诉大家如何处理win7系统玩cf老是与主机连接不稳定的问题，可能很多用户都不

阅读：9649|2022-11-06

7 0xc000022-[cf烟雾头]cf怎么调烟雾头

电脑对日常生活的重要性小编就不多说了，可是一旦碰到win7系统设置cf烟雾头的问题，很

阅读：8615|2022-11-06

8 qizideyouhuo:应用程序无法正常启动0xc0000

我们在日常使用电脑的时候，有的小伙伴们可能在打开应用的时候会遇见提示应用程序无法

阅读：7994|2022-11-06

9 ipz-185:win7系统vcf文件怎么打开

今天小编告诉大家如何对win7系统打开vcf文件进行设置，可能很多用户都不知道怎么对win

阅读：8647|2022-11-06

10 傻哥蹦迪:win10系统s4怎么打开usb调试

今天小编告诉大家如何对win10系统s4开启USB调试模式进行设置，可能很多用户都不知道怎

阅读：7530|2022-11-06

客服电话

电子邮件

C# WechatBuilder类代码示例

示例1: Update

示例2: Add

示例3: Add

示例4: Add

示例5: Update

示例6: Add

示例7: Add

示例8: Update

示例9: Add

示例10: Add

示例11: Add

示例12: Update

示例13: Add

示例14: Add

示例15: Update

示例16: Add

示例17: Add

示例18: Add

示例19: Update

示例20: Add

请发表评论

全部评论

上一篇：

下一篇：

喝醉了怎么解酒最快

PacktPublishing/Python-Machine-Learning-

sussillo/hfopt-matlab: A parallel, cpu-b

鲁东大学一米网:Win7系统USB驱动器RAM的操

emersion/go-ostatus: An OStatus library

剪的笔顺,诠释剪的笔画,认识剪的部首

六六分期app的软件客服如何联系？(六六分期

florent37/ViewAnimator: A fluent Android

florent37/Shrine-MaterialDesign2: implem

CVE-2020-36276

SimpleSoftwareIO/simple-sms: Send and re

关于我们

产品与服务

解决方案

139-2527-9053