C# ShowShop类代码示例

 /// <summary>
 /// 更新一条数据
 /// </summary>
 /// <param name="model"></param>
 /// <returns></returns>
 public void Amend(ShowShop.Model.Accessories.Leaveword model)
 {
     SqlParameter[] paras = (SqlParameter[])this.ValueParas(model);
     StringBuilder strSql = new StringBuilder();
     strSql.Append("update yxs_leaveword set ");
     strSql.Append("[type][email protected],");
     strSql.Append("[username][email protected],");
     strSql.Append("[telephone][email protected],");
     strSql.Append("[qq][email protected],");
     strSql.Append("[msn][email protected],");
     strSql.Append("[email][email protected],");
     strSql.Append("[title][email protected],");
     strSql.Append("[ip][email protected],");
     strSql.Append("[isreguser][email protected],");
     strSql.Append("[content][email protected],");
     strSql.Append("[adddate][email protected],");
     strSql.Append("[isread][email protected],");
     strSql.Append("[replycontent][email protected],");
     strSql.Append("[isreply][email protected],");
     strSql.Append("[replydate][email protected],");
     strSql.Append("[isauditing][email protected],");
     strSql.Append("[storeid][email protected],");
     strSql.Append("[address][email protected]");
     strSql.Append(" where [id][email protected] ");
     ChangeHope.DataBase.SQLServerHelper.ExecuteSql(strSql.ToString(), paras);
 }

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(ShowShop.Model.SystemInfo.MailSetting model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into yxs_MailSetting(");
            strSql.Append("SmtpServerIP,SmtpServerPort,MailId,MailPassword)");
            strSql.Append(" values (");
            strSql.Append("@SmtpServerIP,@SmtpServerPort,@MailId,@MailPassword)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@SmtpServerIP", SqlDbType.VarChar,50),
                    new SqlParameter("@SmtpServerPort", SqlDbType.Int,4),
                    new SqlParameter("@MailId", SqlDbType.VarChar,50),
                    new SqlParameter("@MailPassword", SqlDbType.VarChar,50)};
            parameters[0].Value = model.SmtpServerIP;
            parameters[1].Value = model.SmtpServerPort;
            parameters[2].Value = model.MailId;
            parameters[3].Value = model.MailPassword;

            object obj = ChangeHope.DataBase.SQLServerHelper.GetSingle(strSql.ToString(), parameters);
            if (obj == null)
            {
                return 1;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(ShowShop.Model.Admin.AdminLoginLog model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into Adminloginlog(");
            strSql.Append("AdminName,PassWord,LogininTime,LoginoutTime,LoginIP,HostComputerName,OperateNote)");
            strSql.Append(" values (");
            strSql.Append("@AdminName,@PassWord,@LogininTime,@LoginoutTime,@LoginIP,@HostComputerName,@OperateNote)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@AdminName", SqlDbType.NVarChar,50),
                    new SqlParameter("@PassWord", SqlDbType.VarChar,50),
                    new SqlParameter("@LogininTime", SqlDbType.DateTime),
                    new SqlParameter("@LoginoutTime", SqlDbType.DateTime),
                    new SqlParameter("@LoginIP", SqlDbType.VarChar,50),
                    new SqlParameter("@HostComputerName", SqlDbType.VarChar,50),
                    new SqlParameter("@OperateNote", SqlDbType.VarChar,4000)};
            parameters[0].Value = model.AdminName;
            parameters[1].Value = model.PassWord;
            parameters[2].Value = model.LoginInTime;
            parameters[3].Value = model.LoginOutTime;
            parameters[4].Value = model.LoginIp;
            parameters[5].Value = model.HostComputerName;
            parameters[6].Value = model.OperateNote;

            object obj = ChangeHope.DataBase.SQLServerHelper.GetSingle(strSql.ToString(), parameters);
            if (obj == null)
            {
                return 1;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }

 /// <summary>
 /// 更新一条数据
 /// </summary>
 /// <param name="model"></param>
 /// <returns></returns>
 public void Amend(ShowShop.Model.Accessories.Outofstock model)
 {
     SqlParameter[] paras = (SqlParameter[])this.ValueParas(model);
     StringBuilder strSql = new StringBuilder();
     strSql.Append("update yxs_outofstock set ");
     strSql.Append("[proid][email protected],");
     strSql.Append("[proclassandname][email protected],");
     strSql.Append("[addtime][email protected],");
     strSql.Append("[addip][email protected],");
     strSql.Append("[username][email protected],");
     strSql.Append("[issreguser][email protected],");
     strSql.Append("[telphone][email protected],");
     strSql.Append("[mobile][email protected],");
     strSql.Append("[qq][email protected],");
     strSql.Append("[email][email protected],");
     strSql.Append("[msn][email protected],");
     strSql.Append("[neednum][email protected],");
     strSql.Append("[content][email protected],");
     strSql.Append("[state][email protected],");
     strSql.Append("[isdeal][email protected],");
     strSql.Append("[dealtime][email protected],");
     strSql.Append("[dealremark][email protected]");
     strSql.Append(" where [email protected] ");
     ChangeHope.DataBase.SQLServerHelper.ExecuteSql(strSql.ToString(), paras);
 }

 public int Add(ShowShop.Model.Member.Integral model)
 {
     if (model.IntegralClass != 1)
        {
        model.OrderId = string.Empty;
        }
       return  dal.Add(model);
 }

 public int Add(ShowShop.Model.Product.ScanInfo model)
 {
     StringBuilder strSql = new StringBuilder();
     strSql.Append("insert into yxs_scaninfo( ");
     strSql.Append("uid,productId,scanTime) values ( ");
     strSql.Append("@uid,@productId,@scanTime )");
     SqlParameter[] parameters = (SqlParameter[])this.ValueParam(model);
     return ChangeHope.DataBase.SQLServerHelper.ExecuteSql(strSql.ToString(),parameters);
 }

 /// <summary>
 /// 增加一条数据
 /// </summary>
 public int Add(ShowShop.Model.Member.MemberAccount model)
 {
     StringBuilder strSql=new StringBuilder();
     strSql.Append("insert into yxs_memberaccount(");
     strSql.Append("UserType,UserGroup,UserId,PassWord,Signed,Question,Answer,Email,State,RegisterDate,RegisterIP,LastLoginDate,LastLoginIP,LoginTimes,Capital,Coupons,Points,PeriodOfValidity)");
     strSql.Append(" values (");
     strSql.Append("@UserType,@UserGroup,@UserId,@PassWord,@Signed,@Question,@Answer,@Email,@State,@RegisterDate,@RegisterIP,@LastLoginDate,@LastLoginIP,@LoginTimes,@Capital,@Coupons,@Points,@PeriodOfValidity)");
     strSql.Append(";select @@IDENTITY");
     SqlParameter[] parameters = {
             new SqlParameter("@UserType", SqlDbType.Int,4),
             new SqlParameter("@UserGroup", SqlDbType.Int,4),
             new SqlParameter("@UserId", SqlDbType.VarChar,50),
             new SqlParameter("@PassWord", SqlDbType.VarChar,50),
             new SqlParameter("@Signed", SqlDbType.VarChar,5000),
             new SqlParameter("@Question", SqlDbType.NVarChar,50),
             new SqlParameter("@Answer", SqlDbType.NVarChar,50),
             new SqlParameter("@Email", SqlDbType.VarChar,50),
             new SqlParameter("@State", SqlDbType.Int,4),
             new SqlParameter("@RegisterDate", SqlDbType.DateTime),
             new SqlParameter("@RegisterIP", SqlDbType.VarChar,50),
             new SqlParameter("@LastLoginDate", SqlDbType.DateTime),
             new SqlParameter("@LastLoginIP", SqlDbType.VarChar,50),
             new SqlParameter("@LoginTimes", SqlDbType.Int,4),
             new SqlParameter("@Capital", SqlDbType.Float,8),
             new SqlParameter("@Coupons", SqlDbType.Float,8),
             new SqlParameter("@Points", SqlDbType.Float,8),
             new SqlParameter("@PeriodOfValidity", SqlDbType.DateTime)};
     parameters[0].Value = model.UserType;
     parameters[1].Value = model.UserGroup;
     parameters[2].Value = model.UserId;
     parameters[3].Value = ChangeHope.Common.DEncryptHelper.Encrypt(model.PassWord, 1);
     parameters[4].Value = model.Signed;
     parameters[5].Value = model.Question;
     parameters[6].Value = model.Answer;
     parameters[7].Value = model.Email;
     parameters[8].Value = model.State;
     parameters[9].Value = model.RegisterDate;
     parameters[10].Value = model.RegisterIP;
     parameters[11].Value = model.LastLoginDate;
     parameters[12].Value = model.LastLoginIP;
     parameters[13].Value = model.LoginTimes;
     parameters[14].Value = model.Capital;
     parameters[15].Value = model.Coupons;
     parameters[16].Value = model.Points;
     parameters[17].Value = model.PeriodOfValidity;
     int obj = ChangeHope.DataBase.SQLServerHelper.ExecuteSql(strSql.ToString(), parameters);
     if (obj >0)
     {
         return obj;
     }
     else
     {
         return 0;
     }
 }

 public void AddOrUpdate(ShowShop.Model.SystemInfo.WebSetting model)
 {
     if (model.Id > 0)
     {
         Update(model);
     }
     else
     {
         Add(model);
     }
 }

 public int Add(ShowShop.Model.Member.Integral model)
 {
     StringBuilder strSql = new StringBuilder();
     strSql.Append("insert into [yxs_integral](");
     strSql.Append("userId,orderid,integralClass,origin,integral,gainDate,noteDate,noteName,remark,integralStatus) ");
     strSql.Append("values(");
     strSql.Append("@userId,@orderid,@integralClass,@origin,@integral,@gainDate,@noteDate,@noteName,@remark,@integralStatus )");
     SqlParameter[] parameters = (SqlParameter[])this.ValueParams(model);
     int count = 0;
     count = ChangeHope.DataBase.SQLServerHelper.ExecuteSql(strSql.ToString(),parameters);
     return count;
 }

 /// <summary>
 /// 更新一条数据
 /// </summary>
 public void Amend(ShowShop.Model.Order.OrderLeave model)
 {
     SqlParameter[] paras = (SqlParameter[])this.ValueParas(model);
     StringBuilder strSql = new StringBuilder();
     strSql.Append("update yxs_orderleave 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] ");
     ChangeHope.DataBase.SQLServerHelper.ExecuteSql(strSql.ToString(), paras);
 }

 /// <summary>
 /// 更新一条数据
 /// </summary>
 /// <param name="model"></param>
 /// <returns></returns>
 public void Amend(ShowShop.Model.Accessories.Collection model)
 {
     SqlParameter[] paras = (SqlParameter[])this.ValueParas(model);
     StringBuilder strSql = new StringBuilder();
     strSql.Append("update yxs_collection set ");
     strSql.Append("[collectiontype][email protected],");
     strSql.Append("[collectionid][email protected],");
     strSql.Append("[collectionname][email protected],");
     strSql.Append("[collectiondate][email protected],");
     strSql.Append("[collectionuid][email protected]");
     strSql.Append(" where [id][email protected] ");
     ChangeHope.DataBase.SQLServerHelper.ExecuteSql(strSql.ToString(), paras);
 }

 /// <summary>
 /// 新增数据
 /// </summary>
 /// <remarks></remarks>
 public int Add(ShowShop.Model.Product.ProductBrand model)
 {
     SqlParameter[] paras = (SqlParameter[])this.ValueParas(model);
     string sequel = "Insert into yxs_productbrand (name,sort) Values(@name,@sort) ;select @@IDENTITY ";
     object obj = ChangeHope.DataBase.SQLServerHelper.GetSingle(sequel, paras);
     if (obj == null)
     {
         return 0;
     }
     else
     {
         return Convert.ToInt32(obj);
     }
 }

        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(ShowShop.Model.Member.MemberRank model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into yxs_MemberRank(");
            strSql.Append("Name,LogoPic,Discount,MinScore,MaxScore,Priority,IsSpecial,IsShowPrice,Article,Product,ArticleAuditing,ProductAuditing,MaxMoney,UpgradeMoney,IsUpgrade)");
            strSql.Append(" values (");
            strSql.Append("@Name,@LogoPic,@Discount,@MinScore,@MaxScore,@Priority,@IsSpecial,@IsShowPrice,@Article,@Product,@ArticleAuditing,@ProductAuditing,@MaxMoney,@UpgradeMoney,@IsUpgrade)");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@Name", SqlDbType.NVarChar,50),
                    new SqlParameter("@LogoPic", SqlDbType.NVarChar,200),
                    new SqlParameter("@Discount", SqlDbType.Float,8),
                    new SqlParameter("@MinScore", SqlDbType.Float,8),
                    new SqlParameter("@MaxScore", SqlDbType.Float,8),
                    new SqlParameter("@Priority", SqlDbType.Int,4),
                    new SqlParameter("@IsSpecial", SqlDbType.Int,4),
                    new SqlParameter("@IsShowPrice", SqlDbType.Int,4),
                    new SqlParameter("@Article", SqlDbType.Int,4),
                    new SqlParameter("@Product", SqlDbType.Int,4),
                    new SqlParameter("@ArticleAuditing", SqlDbType.Int,4),
                    new SqlParameter("@ProductAuditing", SqlDbType.Int,4),
                    new SqlParameter("@MaxMoney", SqlDbType.Float,8),
                    new SqlParameter("@UpgradeMoney", SqlDbType.Float,8),
                    new SqlParameter("@IsUpgrade", SqlDbType.Int,4)};
            parameters[0].Value = model.Name;
            parameters[1].Value = model.LogoPic;
            parameters[2].Value = model.Discount;
            parameters[3].Value = model.MinScore;
            parameters[4].Value = model.MaxScore;
            parameters[5].Value = model.Priority;
            parameters[6].Value = model.IsSpecial;
            parameters[7].Value = model.IsShowPrice;
            parameters[8].Value = model.Article;
            parameters[9].Value = model.Product;
            parameters[10].Value = model.ArticleAuditing;
            parameters[11].Value = model.ProductAuditing;
            parameters[12].Value = model.MaxMoney;
            parameters[13].Value = model.UpgradeMoney;
            parameters[14].Value = model.IsUpgrade;

            object obj = ChangeHope.DataBase.SQLServerHelper.GetSingle(strSql.ToString(), parameters);
            if (obj == null)
            {
                return 1;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }

 /// <summary>
 /// 更新一条数据
 /// </summary>
 public void Amend(ShowShop.Model.Member.MailInfo model)
 {
     SqlParameter[] paras = (SqlParameter[])this.ValueParas(model);
     StringBuilder strSql = new StringBuilder();
     strSql.Append("update yxs_mailinfo set ");
     strSql.Append("[email protected],");
     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] ");
     ChangeHope.DataBase.SQLServerHelper.ExecuteSql(strSql.ToString(), paras);
 }

 /// <summary>
 /// 将一个持久化对象的修改保存到数据库, 并提供事务支持
 /// </summary>
 /// <remarks></remarks>
 public int Amend(ShowShop.Model.Product.ProductAuction model)
 {
     string sequel = "Update [yxs_productauction] set  ";
     sequel = sequel + "[auctionname] [email protected] ,[description] [email protected] ,[productid][email protected] ,[productname] [email protected] ,[starttime] [email protected] ,[endtime] [email protected] ,[price] [email protected],[pricerange] [email protected],[deposit] [email protected],[putoutid] [email protected],[putouttypeid][email protected]";
     sequel = sequel + UpdateWhereSequel;
     object obj = ChangeHope.DataBase.SQLServerHelper.ExecuteSql(sequel, (SqlParameter[])this.ValueParas(model));
     if (obj == null)
     {
         return 0;
     }
     else
     {
         return Convert.ToInt32(obj);
     }
 }