C# MxWeiXinPF类代码示例

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

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

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