C# webs_YueyxShop类代码示例

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(webs_YueyxShop.Model.ProductSEOBase model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into ProductSEOBase(");
            strSql.Append("p_ID,pseo_Title,pseo_Content,pseo_Keys,pseo_PicAlt,pseo_PicTitle)");
            strSql.Append(" values (");
            strSql.Append("@p_ID,@pseo_Title,@pseo_Content,@pseo_Keys,@pseo_PicAlt,@pseo_PicTitle)");
            SqlParameter[] parameters = {
                    new SqlParameter("@p_ID", SqlDbType.Int,4),
                    new SqlParameter("@pseo_Title", SqlDbType.NVarChar,20),
                    new SqlParameter("@pseo_Content", SqlDbType.NVarChar,300),
                    new SqlParameter("@pseo_Keys", SqlDbType.NVarChar,100),
                    new SqlParameter("@pseo_PicAlt", SqlDbType.NVarChar,50),
                    new SqlParameter("@pseo_PicTitle", SqlDbType.NVarChar,50)};
            parameters[0].Value = model.p_ID;
            parameters[1].Value = model.pseo_Title;
            parameters[2].Value = model.pseo_Content;
            parameters[3].Value = model.pseo_Keys;
            parameters[4].Value = model.pseo_PicAlt;
            parameters[5].Value = model.pseo_PicTitle;

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

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(webs_YueyxShop.Model.RolesInfo model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into RolesInfo(");
            strSql.Append("r_ID,r_MingCh,r_MiaoS,r_PaiX,r_CreatedOn,r_CreatedBy,r_StateCode,r_DeleteStateCode)");
            strSql.Append(" values (");
            strSql.Append("@r_ID,@r_MingCh,@r_MiaoS,@r_PaiX,@r_CreatedOn,@r_CreatedBy,@r_StateCode,@r_DeleteStateCode)");
            SqlParameter[] parameters = {
                    new SqlParameter("@r_ID", SqlDbType.UniqueIdentifier,16),
                    new SqlParameter("@r_MingCh", SqlDbType.NVarChar,20),
                    new SqlParameter("@r_MiaoS", SqlDbType.NVarChar,200),
                    new SqlParameter("@r_PaiX", SqlDbType.Int,4),
                    new SqlParameter("@r_CreatedOn", SqlDbType.DateTime),
                    new SqlParameter("@r_CreatedBy", SqlDbType.UniqueIdentifier,16),
                    new SqlParameter("@r_StateCode", SqlDbType.Int,4),
                    new SqlParameter("@r_DeleteStateCode", SqlDbType.Int,4)};
            parameters[0].Value = model.r_ID;
            parameters[1].Value = model.r_MingCh;
            parameters[2].Value = model.r_MiaoS;
            parameters[3].Value = model.r_PaiX;
            parameters[4].Value = model.r_CreatedOn;
            parameters[5].Value = model.r_CreatedBy;
            parameters[6].Value = model.r_StateCode;
            parameters[7].Value = model.r_DeleteStateCode;

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

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(webs_YueyxShop.Model.VipCollectionBase model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into VipCollectionBase(");
            strSql.Append("sku_ID,m_ID,vc_CreateOn,vc_IsDel)");
            strSql.Append(" values (");
            strSql.Append("@sku_ID,@m_ID,@vc_CreateOn,@vc_IsDel)");
            SqlParameter[] parameters = {
                    new SqlParameter("@sku_ID", SqlDbType.Int,4),
                    new SqlParameter("@m_ID", SqlDbType.Int,4),
                    new SqlParameter("@vc_CreateOn", SqlDbType.DateTime),
                    new SqlParameter("@vc_IsDel", SqlDbType.Bit,1)};
            parameters[0].Value = model.sku_ID;
            parameters[1].Value = model.m_ID;
            parameters[2].Value = model.vc_CreateOn;
            parameters[3].Value = model.vc_IsDel;

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

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(webs_YueyxShop.Model.SysLogBase model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into SysLogBase(");
            strSql.Append("sl_LeiX,sl_ShiJ,sl_DiZh,sl_MiaoSh,sl_LeiX_CaoZ)");
            strSql.Append(" values (");
            strSql.Append("@sl_LeiX,@sl_ShiJ,@sl_DiZh,@sl_MiaoSh,@sl_LeiX_CaoZ)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@sl_LeiX", SqlDbType.Int,4),
                    new SqlParameter("@sl_ShiJ", SqlDbType.DateTime),
                    new SqlParameter("@sl_DiZh", SqlDbType.VarChar,100),
                    new SqlParameter("@sl_MiaoSh", SqlDbType.NVarChar,500),
                    new SqlParameter("@sl_LeiX_CaoZ", SqlDbType.VarChar,30)};
            parameters[0].Value = model.sl_LeiX;
            parameters[1].Value = model.sl_ShiJ;
            parameters[2].Value = model.sl_DiZh;
            parameters[3].Value = model.sl_MiaoSh;
            parameters[4].Value = model.sl_LeiX_CaoZ;

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

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(webs_YueyxShop.Model.OrderStatusBase model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into OrderStatusBase(");
            strSql.Append("o_ID,o_Status,os_ModifyOn,os_IsDel)");
            strSql.Append(" values (");
            strSql.Append("@o_ID,@o_Status,@os_ModifyOn,@os_IsDel)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@o_ID", SqlDbType.Int,4),
                    new SqlParameter("@o_Status", SqlDbType.Int,4),
                    new SqlParameter("@os_ModifyOn", SqlDbType.DateTime),
                    new SqlParameter("@os_IsDel", SqlDbType.Bit,1)};
            parameters[0].Value = model.o_ID;
            parameters[1].Value = model.o_Status;
            parameters[2].Value = model.os_ModifyOn;
            parameters[3].Value = model.os_IsDel;

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

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(webs_YueyxShop.Model.ProductRecommendDetail model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into ProductRecommendDetail(");
            strSql.Append("prt_ID,p_ID,prd_Status,prd_IsDelete)");
            strSql.Append(" values (");
            strSql.Append("@prt_ID,@p_ID,@prd_Status,@prd_IsDelete)");
            SqlParameter[] parameters = {
                    new SqlParameter("@prt_ID", SqlDbType.Int,4),
                    new SqlParameter("@p_ID", SqlDbType.Int,4),
                    new SqlParameter("@prd_Status", SqlDbType.Bit,1),
                    new SqlParameter("@prd_IsDelete", SqlDbType.Bit,1)};
            parameters[0].Value = model.prt_ID;
            parameters[1].Value = model.p_ID;
            parameters[2].Value = model.prd_Status;
            parameters[3].Value = model.prd_IsDelete;

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

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(webs_YueyxShop.Model.vw_EmpRoleFun model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into vw_EmpRoleFun(");
            strSql.Append("f_BianM,f_ID,e_ID,r_ID)");
            strSql.Append(" values (");
            strSql.Append("@f_BianM,@f_ID,@e_ID,@r_ID)");
            SqlParameter[] parameters = {
                    new SqlParameter("@f_BianM", SqlDbType.VarChar,30),
                    new SqlParameter("@f_ID", SqlDbType.UniqueIdentifier,16),
                    new SqlParameter("@e_ID", SqlDbType.UniqueIdentifier,16),
                    new SqlParameter("@r_ID", SqlDbType.UniqueIdentifier,16)};
            parameters[0].Value = model.f_BianM;
            parameters[1].Value = Guid.NewGuid();
            parameters[2].Value = Guid.NewGuid();
            parameters[3].Value = Guid.NewGuid();

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

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(webs_YueyxShop.Model.ProductRecommendTypeBase model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into ProductRecommendTypeBase(");
            strSql.Append("prt_Name,prt_Title,prt_Status,prt_IsDelete,prt_Directions)");
            strSql.Append(" values (");
            strSql.Append("@prt_Name,@prt_Title,@prt_Status,@prt_IsDelete,@prt_Directions)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@prt_Name", SqlDbType.NVarChar,20),
                    new SqlParameter("@prt_Title", SqlDbType.NVarChar,200),
                    new SqlParameter("@prt_Status", SqlDbType.Bit,1),
                    new SqlParameter("@prt_IsDelete", SqlDbType.Bit,1),
                    new SqlParameter("@prt_Directions", SqlDbType.VarChar,200)};
            parameters[0].Value = model.prt_Name;
            parameters[1].Value = model.prt_Title;
            parameters[2].Value = model.prt_Status;
            parameters[3].Value = model.prt_IsDelete;
            parameters[4].Value = model.prt_Directions;

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

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(webs_YueyxShop.Model.ProductImgBase model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into ProductImgBase(");
            strSql.Append("sku_ID,pi_Url,pi_Type,pi_StatusCode,pi_IsDel)");
            strSql.Append(" values (");
            strSql.Append("@sku_ID,@pi_Url,@pi_Type,@pi_statuscode,@pi_isdel)");
            SqlParameter[] parameters = {
                    new SqlParameter("@sku_ID", SqlDbType.Int,4),
                    new SqlParameter("@pi_Url", SqlDbType.VarChar,100),
                    new SqlParameter("@pi_Type", SqlDbType.Bit),
                    new SqlParameter("@pi_statuscode", SqlDbType.Int,4),
                    new SqlParameter("@pi_isdel", SqlDbType.Bit)};
            parameters[0].Value = model.sku_ID;
            parameters[1].Value = model.pi_Url;
            parameters[2].Value = model.pi_Type;
            parameters[3].Value = model.pi_StatusCode;
            parameters[4].Value = model.pi_IsDel;

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

 /// <summary>
 /// 增加一条数据
 /// </summary>
 public bool Add(webs_YueyxShop.Model.OrderSKUDetail model)
 {
     StringBuilder strSql = new StringBuilder();
     strSql.Append("insert into OrderSKUDetail(");
     strSql.Append("sku_ID,o_ID,os_pCount,os_Price,os_IsGP,os_chima,os_yanse)");
     strSql.Append(" values (");
     strSql.Append("@sku_ID,@o_ID,@os_pCount,@os_Price,@os_IsGP,@os_chima,@os_yanse)");
     strSql.Append(";select @@IDENTITY");
     SqlParameter[] parameters = {
             new SqlParameter("@sku_ID", SqlDbType.Int,4),
             new SqlParameter("@o_ID", SqlDbType.Int,4),
             new SqlParameter("@os_pCount", SqlDbType.Int,4),
             new SqlParameter("@os_Price", SqlDbType.Decimal,5),
             new SqlParameter("@os_IsGP", SqlDbType.Bit,1),
             new SqlParameter("@os_chima", SqlDbType.VarChar,50),
             new SqlParameter("@os_yanse", SqlDbType.VarChar,50)};
     parameters[0].Value = model.sku_ID;
     parameters[1].Value = model.o_ID;
     parameters[2].Value = model.os_pCount;
     parameters[3].Value = model.os_Price;
     parameters[4].Value = model.os_IsGP;
     parameters[5].Value=model.os_chima;
     parameters[6].Value=model.os_yanse;
     object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
     if (obj == null)
     {
         return false;
     }
     else
     {
         return true;
     }
 }

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(webs_YueyxShop.Model.PaymentBase model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into PaymentBase(");
            strSql.Append("pay_Name,pay_Url,pay_IsDel,pay_isPhone)");
            strSql.Append(" values (");
            strSql.Append("@pay_Name,@pay_Url,@pay_IsDel,@pay_isPhone)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@pay_Name", SqlDbType.VarChar,20),
                    new SqlParameter("@pay_Url", SqlDbType.VarChar,30),
                    new SqlParameter("@pay_IsDel", SqlDbType.Bit,1),
                    new SqlParameter("@pay_isPhone", SqlDbType.Bit,1)};
            parameters[0].Value = model.pay_Name;
            parameters[1].Value = model.pay_Url;
            parameters[2].Value = model.pay_IsDel;
            parameters[3].Value = model.pay_isPhone;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
            if (obj == null)
            {
                return false;
            }
            else
            {
                return true;
            }
        }

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(webs_YueyxShop.Model.ProductConsultBase model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into ProductConsultBase(");
            strSql.Append("sku_ID,pc_CreatedOn,pc_Type,pc_Content,pc_CreatedBy,pc_StatusCode,pc_huifu,pc_IsDel)");
            strSql.Append(" values (");
            strSql.Append("@sku_ID,@pc_CreatedOn,@pc_Type,@pc_Content,@pc_CreatedBy,@pc_StatusCode,@pc_huifu,@pc_IsDel)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@sku_ID", SqlDbType.Int,4),
                    new SqlParameter("@pc_CreatedOn", SqlDbType.DateTime),
                    new SqlParameter("@pc_Type", SqlDbType.VarChar,30),
                    new SqlParameter("@pc_Content", SqlDbType.NVarChar,500),
                    new SqlParameter("@pc_CreatedBy", SqlDbType.Int,4),
                    new SqlParameter("@pc_StatusCode", SqlDbType.Int,4),
                    new SqlParameter("@pc_huifu", SqlDbType.Int,4),
                    new SqlParameter("@pc_IsDel", SqlDbType.Bit,1)};
            parameters[0].Value = model.sku_ID;
            parameters[1].Value = model.pc_CreatedOn;
            parameters[2].Value = model.pc_Type;
            parameters[3].Value = model.pc_Content;
            parameters[4].Value = model.pc_CreatedBy;
            parameters[5].Value = model.pc_StatusCode;
            parameters[6].Value = model.pc_huifu;
            parameters[7].Value = model.pc_IsDel;

            int obj = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);

            return obj;
        }

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(webs_YueyxShop.Model.ProductReplyBase model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into ProductReplyBase(");
            strSql.Append("pc_ID,pr_Content,pr_CreatedBy,pr_CreatedOn,pr_StatusCode,pr_IsDel)");
            strSql.Append(" values (");
            strSql.Append("@pc_ID,@pr_Content,@pr_CreatedBy,@pr_CreatedOn,@pr_StatusCode,@pr_IsDel)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@pc_ID", SqlDbType.Int,4),
                    new SqlParameter("@pr_Content", SqlDbType.NVarChar,500),
                    new SqlParameter("@pr_CreatedBy", SqlDbType.UniqueIdentifier,16),
                    new SqlParameter("@pr_CreatedOn", SqlDbType.DateTime),
                    new SqlParameter("@pr_StatusCode", SqlDbType.Int,4),
                    new SqlParameter("@pr_IsDel", SqlDbType.Bit,1)};
            parameters[0].Value = model.pc_ID;
            parameters[1].Value = model.pr_Content;
            parameters[2].Value = Guid.NewGuid();
            parameters[3].Value = model.pr_CreatedOn;
            parameters[4].Value = model.pr_StatusCode;
            parameters[5].Value = model.pr_IsDel;

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

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(webs_YueyxShop.Model.RejectionSKUDetail model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into RejectionSKUDetail(");
            strSql.Append("sku_ID,r_ID,rs_pCount)");
            strSql.Append(" values (");
            strSql.Append("@sku_ID,@r_ID,@rs_pCount)");
            SqlParameter[] parameters = {
                    new SqlParameter("@sku_ID", SqlDbType.Int,4),
                    new SqlParameter("@r_ID", SqlDbType.Int,4),
                    new SqlParameter("@rs_pCount", SqlDbType.Int,4)};
            parameters[0].Value = model.sku_ID;
            parameters[1].Value = model.r_ID;
            parameters[2].Value = model.rs_pCount;

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

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(webs_YueyxShop.Model.RegionBase model)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("insert into RegionBase(");
            strSql.Append("reg_Code,reg_PId,reg_Name)");
            strSql.Append(" values (");
            strSql.Append("@reg_Code,@reg_PId,@reg_Name)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@reg_Code", SqlDbType.Int,4),
                    new SqlParameter("@reg_PId", SqlDbType.Int,4),
                    new SqlParameter("@reg_Name", SqlDbType.VarChar,15)};
            parameters[0].Value = model.reg_Code;
            parameters[1].Value = model.reg_PId;
            parameters[2].Value = model.reg_Name;

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