当前位置: 首页>>代码示例>>C#>>正文

C# WechatBuilder类代码示例

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


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


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