Beispiel #1
0
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public bool Update(Model.dt_manager model)
 {
     return(dal.Update(model));
 }
Beispiel #2
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(Model.dt_manager model)
        {
            StringBuilder             strSql     = new StringBuilder();
            Collection <SqlParameter> parameters = new Collection <SqlParameter>

                                                       ();
            SqlParameter parameter = null;
            int          count     = 0;

            strSql.Append("update [dt_manager] set ");
            parameter = new SqlParameter("@id",

                                         SqlDbType.Int, 4);
            parameter.Value = model.id;
            parameters.Add(parameter);



            if (model.is_lock_IsEdit)
            {
                strSql.Append(" is_lock = @is_lock,");
                parameter = new SqlParameter("@is_lock",

                                             SqlDbType.Int, 4);
                parameter.Value = model.is_lock;
                parameters.Add(parameter);
                count++;
            }



            if (model.add_time_IsEdit)
            {
                strSql.Append(" add_time = @add_time,");
                parameter = new SqlParameter("@add_time",

                                             SqlDbType.DateTime);
                parameter.Value = model.add_time;
                parameters.Add(parameter);
                count++;
            }



            if (model.wxNum_IsEdit)
            {
                strSql.Append(" wxNum = @wxNum,");
                parameter = new SqlParameter("@wxNum",

                                             SqlDbType.Int, 4);
                parameter.Value = model.wxNum;
                parameters.Add(parameter);
                count++;
            }



            if (model.agentId_IsEdit)
            {
                strSql.Append(" agentId = @agentId,");
                parameter = new SqlParameter("@agentId",

                                             SqlDbType.Int, 4);
                parameter.Value = model.agentId;
                parameters.Add(parameter);
                count++;
            }



            if (model.reg_ip_IsEdit)
            {
                strSql.Append(" reg_ip = @reg_ip,");
                parameter = new SqlParameter("@reg_ip",

                                             SqlDbType.NVarChar, 30);
                parameter.Value = model.reg_ip;
                parameters.Add(parameter);
                count++;
            }



            if (model.qq_IsEdit)
            {
                strSql.Append(" qq = @qq,");
                parameter = new SqlParameter("@qq",

                                             SqlDbType.NVarChar, 30);
                parameter.Value = model.qq;
                parameters.Add(parameter);
                count++;
            }



            if (model.province_IsEdit)
            {
                strSql.Append(" province = @province,");
                parameter = new SqlParameter("@province",

                                             SqlDbType.NVarChar, 200);
                parameter.Value = model.province;
                parameters.Add(parameter);
                count++;
            }



            if (model.city_IsEdit)
            {
                strSql.Append(" city = @city,");
                parameter = new SqlParameter("@city",

                                             SqlDbType.NVarChar, 200);
                parameter.Value = model.city;
                parameters.Add(parameter);
                count++;
            }



            if (model.county_IsEdit)
            {
                strSql.Append(" county = @county,");
                parameter = new SqlParameter("@county",

                                             SqlDbType.NVarChar, 500);
                parameter.Value = model.county;
                parameters.Add(parameter);
                count++;
            }



            if (model.remark_IsEdit)
            {
                strSql.Append(" remark = @remark,");
                parameter = new SqlParameter("@remark",

                                             SqlDbType.NVarChar, 1500);
                parameter.Value = model.remark;
                parameters.Add(parameter);
                count++;
            }



            if (model.role_id_IsEdit)
            {
                strSql.Append(" role_id = @role_id,");
                parameter = new SqlParameter("@role_id",

                                             SqlDbType.Int, 4);
                parameter.Value = model.role_id;
                parameters.Add(parameter);
                count++;
            }



            if (model.sort_id_IsEdit)
            {
                strSql.Append(" sort_id = @sort_id,");
                parameter = new SqlParameter("@sort_id",

                                             SqlDbType.Int, 4);
                parameter.Value = model.sort_id;
                parameters.Add(parameter);
                count++;
            }



            if (model.agentLevel_IsEdit)
            {
                strSql.Append(" agentLevel = @agentLevel,");
                parameter = new SqlParameter("@agentLevel",

                                             SqlDbType.Int, 4);
                parameter.Value = model.agentLevel;
                parameters.Add(parameter);
                count++;
            }



            if (model.SectionId_IsEdit)
            {
                strSql.Append(" SectionId = @SectionId,");
                parameter = new SqlParameter("@SectionId",

                                             SqlDbType.Int, 4);
                parameter.Value = model.SectionId;
                parameters.Add(parameter);
                count++;
            }



            if (model.Ext1_IsEdit)
            {
                strSql.Append(" Ext1 = @Ext1,");
                parameter = new SqlParameter("@Ext1",

                                             SqlDbType.VarChar, 50);
                parameter.Value = model.Ext1;
                parameters.Add(parameter);
                count++;
            }



            if (model.IsDelete_IsEdit)
            {
                strSql.Append(" IsDelete = @IsDelete,");
                parameter = new SqlParameter("@IsDelete",

                                             SqlDbType.TinyInt, 1);
                parameter.Value = model.IsDelete;
                parameters.Add(parameter);
                count++;
            }



            if (model.role_type_IsEdit)
            {
                strSql.Append(" role_type = @role_type,");
                parameter = new SqlParameter("@role_type",

                                             SqlDbType.Int, 4);
                parameter.Value = model.role_type;
                parameters.Add(parameter);
                count++;
            }



            if (model.user_name_IsEdit)
            {
                strSql.Append(" user_name = @user_name,");
                parameter = new SqlParameter("@user_name",

                                             SqlDbType.NVarChar, 100);
                parameter.Value = model.user_name;
                parameters.Add(parameter);
                count++;
            }



            if (model.password_IsEdit)
            {
                strSql.Append(" password = @password,");
                parameter = new SqlParameter("@password",

                                             SqlDbType.NVarChar, 100);
                parameter.Value = model.password;
                parameters.Add(parameter);
                count++;
            }



            if (model.salt_IsEdit)
            {
                strSql.Append(" salt = @salt,");
                parameter = new SqlParameter("@salt",

                                             SqlDbType.NVarChar, 20);
                parameter.Value = model.salt;
                parameters.Add(parameter);
                count++;
            }



            if (model.real_name_IsEdit)
            {
                strSql.Append(" real_name = @real_name,");
                parameter = new SqlParameter("@real_name",

                                             SqlDbType.NVarChar, 50);
                parameter.Value = model.real_name;
                parameters.Add(parameter);
                count++;
            }



            if (model.telephone_IsEdit)
            {
                strSql.Append(" telephone = @telephone,");
                parameter = new SqlParameter("@telephone",

                                             SqlDbType.NVarChar, 30);
                parameter.Value = model.telephone;
                parameters.Add(parameter);
                count++;
            }



            if (model.email_IsEdit)
            {
                strSql.Append(" email = @email,");
                parameter = new SqlParameter("@email",

                                             SqlDbType.NVarChar, 30);
                parameter.Value = model.email;
                parameters.Add(parameter);
                count++;
            }

            if (count > 0)
            {
                strSql.Remove(strSql.Length - 1, 1);
            }
            if (count == 0)
            {
                return(false);
            }
            strSql.Append(" where id=@id ");
            // 将参数泛形集合转传为数组
            SqlParameter[] args = new SqlParameter[parameters.Count];
            parameters.CopyTo(args, 0);
            int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), args);

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Beispiel #3
0
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public int  Add(Model.dt_manager model)
 {
     return(dal.Add(model));
 }
Beispiel #4
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Insert(Model.dt_manager model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into [dt_manager](");
            strSql.Append("is_lock,add_time,wxNum,agentId,reg_ip,qq,province,city,county,remark,role_id,sort_id,agentLevel,SectionId,Ext1,IsDelete,role_type,user_name,password,salt,real_name,telephone,email");
            strSql.Append(") values (");
            strSql.Append("@is_lock,@add_time,@wxNum,@agentId,@reg_ip,@qq,@province,@city,@county,@remark,@role_id,@sort_id,@agentLevel,@SectionId,@Ext1,@IsDelete,@role_type,@user_name,@password,@salt,@real_name,@telephone,@email");
            strSql.Append(") ");
            strSql.Append(";select @@IDENTITY");
            SqlParameter[] parameters =
            {
                new SqlParameter("@is_lock",    SqlDbType.Int,          4),
                new SqlParameter("@add_time",   SqlDbType.DateTime),
                new SqlParameter("@wxNum",      SqlDbType.Int,          4),
                new SqlParameter("@agentId",    SqlDbType.Int,          4),
                new SqlParameter("@reg_ip",     SqlDbType.NVarChar,    30),
                new SqlParameter("@qq",         SqlDbType.NVarChar,    30),
                new SqlParameter("@province",   SqlDbType.NVarChar,   200),
                new SqlParameter("@city",       SqlDbType.NVarChar,   200),
                new SqlParameter("@county",     SqlDbType.NVarChar,   500),
                new SqlParameter("@remark",     SqlDbType.NVarChar,  1500),
                new SqlParameter("@role_id",    SqlDbType.Int,          4),
                new SqlParameter("@sort_id",    SqlDbType.Int,          4),
                new SqlParameter("@agentLevel", SqlDbType.Int,          4),
                new SqlParameter("@SectionId",  SqlDbType.Int,          4),
                new SqlParameter("@Ext1",       SqlDbType.VarChar,     50),
                new SqlParameter("@IsDelete",   SqlDbType.TinyInt,      1),
                new SqlParameter("@role_type",  SqlDbType.Int,          4),
                new SqlParameter("@user_name",  SqlDbType.NVarChar,   100),
                new SqlParameter("@password",   SqlDbType.NVarChar,   100),
                new SqlParameter("@salt",       SqlDbType.NVarChar,    20),
                new SqlParameter("@real_name",  SqlDbType.NVarChar,    50),
                new SqlParameter("@telephone",  SqlDbType.NVarChar,    30),
                new SqlParameter("@email",      SqlDbType.NVarChar, 30)
            };

            parameters[0].Value  = model.is_lock;
            parameters[1].Value  = model.add_time;
            parameters[2].Value  = model.wxNum;
            parameters[3].Value  = model.agentId;
            parameters[4].Value  = model.reg_ip;
            parameters[5].Value  = model.qq;
            parameters[6].Value  = model.province;
            parameters[7].Value  = model.city;
            parameters[8].Value  = model.county;
            parameters[9].Value  = model.remark;
            parameters[10].Value = model.role_id;
            parameters[11].Value = model.sort_id;
            parameters[12].Value = model.agentLevel;
            parameters[13].Value = model.SectionId;
            parameters[14].Value = model.Ext1;
            parameters[15].Value = model.IsDelete;
            parameters[16].Value = model.role_type;
            parameters[17].Value = model.user_name;
            parameters[18].Value = model.password;
            parameters[19].Value = model.salt;
            parameters[20].Value = model.real_name;
            parameters[21].Value = model.telephone;
            parameters[22].Value = model.email;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);

            if (obj == null)
            {
                return(0);
            }
            else
            {
                return(Convert.ToInt32(obj));
            }
        }