/// <summary> /// 得到一个对象实体 /// </summary> public XHD.Model.ecs_users GetModel(int user_id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select user_id,aite_id,email,user_name,is_user_name_checked,u_company,u_real_name,erp_custom_code,password,question,answer,sex,birthday,user_money,frozen_money,pay_points,rank_points,address_id,reg_time,last_login,last_time,last_ip,visit_count,user_rank,is_special,ec_salt,salt,parent_id,flag,alias,msn,qq,office_phone,home_phone,mobile_phone,is_validated,credit_line,passwd_question,passwd_answer,mediaUID,mediaID,user_market_area,admin_user_name,admin_user_id,admin_u_real_name,is_daifa,send_user_name,send_user_tel,send_user_company,send_user_address,user_from,user_beizhu,is_erp_archives,yes_invoiced_money,no_invoiced_money,aite_user_name,dakuan,dealer_id,main_user_id,user_status from ecs_users "); strSql.Append(" where user_id=@user_id"); MySqlParameter[] parameters = { new MySqlParameter("@user_id", MySqlDbType.Int32) }; parameters[0].Value = user_id; XHD.Model.ecs_users model = new XHD.Model.ecs_users(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(XHD.Model.ecs_users model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ecs_users("); strSql.Append("aite_id,email,user_name,is_user_name_checked,u_company,u_real_name,erp_custom_code,password,question,answer,sex,birthday,user_money,frozen_money,pay_points,rank_points,address_id,reg_time,last_login,last_time,last_ip,visit_count,user_rank,is_special,ec_salt,salt,parent_id,flag,alias,msn,qq,office_phone,home_phone,mobile_phone,is_validated,credit_line,passwd_question,passwd_answer,mediaUID,mediaID,user_market_area,admin_user_name,admin_user_id,admin_u_real_name,is_daifa,send_user_name,send_user_tel,send_user_company,send_user_address,user_from,user_beizhu,is_erp_archives,yes_invoiced_money,no_invoiced_money,aite_user_name,dakuan,dealer_id,main_user_id,user_status)"); strSql.Append(" values ("); strSql.Append("@aite_id,@email,@user_name,@is_user_name_checked,@u_company,@u_real_name,@erp_custom_code,@password,@question,@answer,@sex,@birthday,@user_money,@frozen_money,@pay_points,@rank_points,@address_id,@reg_time,@last_login,@last_time,@last_ip,@visit_count,@user_rank,@is_special,@ec_salt,@salt,@parent_id,@flag,@alias,@msn,@qq,@office_phone,@home_phone,@mobile_phone,@is_validated,@credit_line,@passwd_question,@passwd_answer,@mediaUID,@mediaID,@user_market_area,@admin_user_name,@admin_user_id,@admin_u_real_name,@is_daifa,@send_user_name,@send_user_tel,@send_user_company,@send_user_address,@user_from,@user_beizhu,@is_erp_archives,@yes_invoiced_money,@no_invoiced_money,@aite_user_name,@dakuan,@dealer_id,@main_user_id,@user_status)"); MySqlParameter[] parameters = { new MySqlParameter("@aite_id", MySqlDbType.Text), new MySqlParameter("@email", MySqlDbType.VarChar, 60), new MySqlParameter("@user_name", MySqlDbType.VarChar, 60), new MySqlParameter("@is_user_name_checked", MySqlDbType.Int32, 1), new MySqlParameter("@u_company", MySqlDbType.VarChar, 60), new MySqlParameter("@u_real_name", MySqlDbType.VarChar, 60), new MySqlParameter("@erp_custom_code", MySqlDbType.VarChar, 60), new MySqlParameter("@password", MySqlDbType.VarChar, 32), new MySqlParameter("@question", MySqlDbType.VarChar, 255), new MySqlParameter("@answer", MySqlDbType.VarChar, 255), new MySqlParameter("@sex", MySqlDbType.Int32, 1), new MySqlParameter("@birthday", MySqlDbType.Date), new MySqlParameter("@user_money", MySqlDbType.Decimal, 10), new MySqlParameter("@frozen_money", MySqlDbType.Decimal, 10), new MySqlParameter("@pay_points", MySqlDbType.Int32, 10), new MySqlParameter("@rank_points", MySqlDbType.Int32, 10), new MySqlParameter("@address_id", MySqlDbType.Int32, 8), new MySqlParameter("@reg_time", MySqlDbType.Int32, 10), new MySqlParameter("@last_login", MySqlDbType.Int32, 11), new MySqlParameter("@last_time", MySqlDbType.DateTime), new MySqlParameter("@last_ip", MySqlDbType.VarChar, 15), new MySqlParameter("@visit_count", MySqlDbType.Int32, 5), new MySqlParameter("@user_rank", MySqlDbType.Int32, 3), new MySqlParameter("@is_special", MySqlDbType.Int32, 3), new MySqlParameter("@ec_salt", MySqlDbType.VarChar, 10), new MySqlParameter("@salt", MySqlDbType.VarChar, 10), new MySqlParameter("@parent_id", MySqlDbType.Int32, 9), new MySqlParameter("@flag", MySqlDbType.Int32, 3), new MySqlParameter("@alias", MySqlDbType.VarChar, 60), new MySqlParameter("@msn", MySqlDbType.VarChar, 60), new MySqlParameter("@qq", MySqlDbType.VarChar, 20), new MySqlParameter("@office_phone", MySqlDbType.VarChar, 20), new MySqlParameter("@home_phone", MySqlDbType.VarChar, 20), new MySqlParameter("@mobile_phone", MySqlDbType.VarChar, 20), new MySqlParameter("@is_validated", MySqlDbType.Int32, 3), new MySqlParameter("@credit_line", MySqlDbType.Decimal, 10), new MySqlParameter("@passwd_question", MySqlDbType.VarChar, 50), new MySqlParameter("@passwd_answer", MySqlDbType.VarChar, 255), new MySqlParameter("@mediaUID", MySqlDbType.VarChar, 50), new MySqlParameter("@mediaID", MySqlDbType.Int32, 4), new MySqlParameter("@user_market_area", MySqlDbType.VarChar, 30), new MySqlParameter("@admin_user_name", MySqlDbType.VarChar, 30), new MySqlParameter("@admin_user_id", MySqlDbType.Int32, 11), new MySqlParameter("@admin_u_real_name", MySqlDbType.VarChar, 30), new MySqlParameter("@is_daifa", MySqlDbType.Int32, 2), new MySqlParameter("@send_user_name", MySqlDbType.VarChar, 30), new MySqlParameter("@send_user_tel", MySqlDbType.VarChar, 30), new MySqlParameter("@send_user_company", MySqlDbType.VarChar, 30), new MySqlParameter("@send_user_address", MySqlDbType.VarChar, 30), new MySqlParameter("@user_from", MySqlDbType.VarChar, 30), new MySqlParameter("@user_beizhu", MySqlDbType.Text), new MySqlParameter("@is_erp_archives", MySqlDbType.Int32, 1), new MySqlParameter("@yes_invoiced_money", MySqlDbType.Decimal, 10), new MySqlParameter("@no_invoiced_money", MySqlDbType.Decimal, 10), new MySqlParameter("@aite_user_name", MySqlDbType.VarChar, 60), new MySqlParameter("@dakuan", MySqlDbType.Decimal, 10), new MySqlParameter("@dealer_id", MySqlDbType.Int32, 11), new MySqlParameter("@main_user_id", MySqlDbType.Int32, 8), new MySqlParameter("@user_status", MySqlDbType.Int32, 1) }; parameters[0].Value = model.aite_id; parameters[1].Value = model.email; parameters[2].Value = model.user_name; parameters[3].Value = model.is_user_name_checked; parameters[4].Value = model.u_company; parameters[5].Value = model.u_real_name; parameters[6].Value = model.erp_custom_code; parameters[7].Value = model.password; parameters[8].Value = model.question; parameters[9].Value = model.answer; parameters[10].Value = model.sex; parameters[11].Value = model.birthday; parameters[12].Value = model.user_money; parameters[13].Value = model.frozen_money; parameters[14].Value = model.pay_points; parameters[15].Value = model.rank_points; parameters[16].Value = model.address_id; parameters[17].Value = model.reg_time; parameters[18].Value = model.last_login; parameters[19].Value = model.last_time; parameters[20].Value = model.last_ip; parameters[21].Value = model.visit_count; parameters[22].Value = model.user_rank; parameters[23].Value = model.is_special; parameters[24].Value = model.ec_salt; parameters[25].Value = model.salt; parameters[26].Value = model.parent_id; parameters[27].Value = model.flag; parameters[28].Value = model.alias; parameters[29].Value = model.msn; parameters[30].Value = model.qq; parameters[31].Value = model.office_phone; parameters[32].Value = model.home_phone; parameters[33].Value = model.mobile_phone; parameters[34].Value = model.is_validated; parameters[35].Value = model.credit_line; parameters[36].Value = model.passwd_question; parameters[37].Value = model.passwd_answer; parameters[38].Value = model.mediaUID; parameters[39].Value = model.mediaID; parameters[40].Value = model.user_market_area; parameters[41].Value = model.admin_user_name; parameters[42].Value = model.admin_user_id; parameters[43].Value = model.admin_u_real_name; parameters[44].Value = model.is_daifa; parameters[45].Value = model.send_user_name; parameters[46].Value = model.send_user_tel; parameters[47].Value = model.send_user_company; parameters[48].Value = model.send_user_address; parameters[49].Value = model.user_from; parameters[50].Value = model.user_beizhu; parameters[51].Value = model.is_erp_archives; parameters[52].Value = model.yes_invoiced_money; parameters[53].Value = model.no_invoiced_money; parameters[54].Value = model.aite_user_name; parameters[55].Value = model.dakuan; parameters[56].Value = model.dealer_id; parameters[57].Value = model.main_user_id; parameters[58].Value = model.user_status; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public XHD.Model.ecs_users DataRowToModel(DataRow row) { XHD.Model.ecs_users model = new XHD.Model.ecs_users(); if (row != null) { //model.user_id=row["user_id"].ToString(); if (row["aite_id"] != null) { model.aite_id = row["aite_id"].ToString(); } if (row["email"] != null) { model.email = row["email"].ToString(); } if (row["user_name"] != null) { model.user_name = row["user_name"].ToString(); } if (row["is_user_name_checked"] != null && row["is_user_name_checked"].ToString() != "") { model.is_user_name_checked = int.Parse(row["is_user_name_checked"].ToString()); } if (row["u_company"] != null) { model.u_company = row["u_company"].ToString(); } if (row["u_real_name"] != null) { model.u_real_name = row["u_real_name"].ToString(); } if (row["erp_custom_code"] != null) { model.erp_custom_code = row["erp_custom_code"].ToString(); } if (row["password"] != null) { model.password = row["password"].ToString(); } if (row["question"] != null) { model.question = row["question"].ToString(); } if (row["answer"] != null) { model.answer = row["answer"].ToString(); } if (row["sex"] != null && row["sex"].ToString() != "") { model.sex = int.Parse(row["sex"].ToString()); } if (row["birthday"] != null && row["birthday"].ToString() != "") { model.birthday = DateTime.Parse(row["birthday"].ToString()); } if (row["user_money"] != null && row["user_money"].ToString() != "") { model.user_money = decimal.Parse(row["user_money"].ToString()); } if (row["frozen_money"] != null && row["frozen_money"].ToString() != "") { model.frozen_money = decimal.Parse(row["frozen_money"].ToString()); } if (row["pay_points"] != null && row["pay_points"].ToString() != "") { model.pay_points = int.Parse(row["pay_points"].ToString()); } if (row["rank_points"] != null && row["rank_points"].ToString() != "") { model.rank_points = int.Parse(row["rank_points"].ToString()); } //model.address_id=row["address_id"].ToString(); if (row["reg_time"] != null && row["reg_time"].ToString() != "") { model.reg_time = int.Parse(row["reg_time"].ToString()); } if (row["last_login"] != null && row["last_login"].ToString() != "") { model.last_login = int.Parse(row["last_login"].ToString()); } if (row["last_time"] != null && row["last_time"].ToString() != "") { model.last_time = DateTime.Parse(row["last_time"].ToString()); } if (row["last_ip"] != null) { model.last_ip = row["last_ip"].ToString(); } if (row["visit_count"] != null && row["visit_count"].ToString() != "") { model.visit_count = int.Parse(row["visit_count"].ToString()); } if (row["user_rank"] != null && row["user_rank"].ToString() != "") { model.user_rank = int.Parse(row["user_rank"].ToString()); } if (row["is_special"] != null && row["is_special"].ToString() != "") { model.is_special = int.Parse(row["is_special"].ToString()); } if (row["ec_salt"] != null) { model.ec_salt = row["ec_salt"].ToString(); } if (row["salt"] != null) { model.salt = row["salt"].ToString(); } //model.parent_id=row["parent_id"].ToString(); if (row["flag"] != null && row["flag"].ToString() != "") { model.flag = int.Parse(row["flag"].ToString()); } if (row["alias"] != null) { model.alias = row["alias"].ToString(); } if (row["msn"] != null) { model.msn = row["msn"].ToString(); } if (row["qq"] != null) { model.qq = row["qq"].ToString(); } if (row["office_phone"] != null) { model.office_phone = row["office_phone"].ToString(); } if (row["home_phone"] != null) { model.home_phone = row["home_phone"].ToString(); } if (row["mobile_phone"] != null) { model.mobile_phone = row["mobile_phone"].ToString(); } if (row["is_validated"] != null && row["is_validated"].ToString() != "") { model.is_validated = int.Parse(row["is_validated"].ToString()); } if (row["credit_line"] != null && row["credit_line"].ToString() != "") { model.credit_line = decimal.Parse(row["credit_line"].ToString()); } if (row["passwd_question"] != null) { model.passwd_question = row["passwd_question"].ToString(); } if (row["passwd_answer"] != null) { model.passwd_answer = row["passwd_answer"].ToString(); } if (row["mediaUID"] != null) { model.mediaUID = row["mediaUID"].ToString(); } if (row["mediaID"] != null && row["mediaID"].ToString() != "") { model.mediaID = int.Parse(row["mediaID"].ToString()); } if (row["user_market_area"] != null) { model.user_market_area = row["user_market_area"].ToString(); } if (row["admin_user_name"] != null) { model.admin_user_name = row["admin_user_name"].ToString(); } if (row["admin_user_id"] != null && row["admin_user_id"].ToString() != "") { model.admin_user_id = int.Parse(row["admin_user_id"].ToString()); } if (row["admin_u_real_name"] != null) { model.admin_u_real_name = row["admin_u_real_name"].ToString(); } if (row["is_daifa"] != null && row["is_daifa"].ToString() != "") { model.is_daifa = int.Parse(row["is_daifa"].ToString()); } if (row["send_user_name"] != null) { model.send_user_name = row["send_user_name"].ToString(); } if (row["send_user_tel"] != null) { model.send_user_tel = row["send_user_tel"].ToString(); } if (row["send_user_company"] != null) { model.send_user_company = row["send_user_company"].ToString(); } if (row["send_user_address"] != null) { model.send_user_address = row["send_user_address"].ToString(); } if (row["user_from"] != null) { model.user_from = row["user_from"].ToString(); } if (row["user_beizhu"] != null) { model.user_beizhu = row["user_beizhu"].ToString(); } if (row["is_erp_archives"] != null && row["is_erp_archives"].ToString() != "") { model.is_erp_archives = int.Parse(row["is_erp_archives"].ToString()); } if (row["yes_invoiced_money"] != null && row["yes_invoiced_money"].ToString() != "") { model.yes_invoiced_money = decimal.Parse(row["yes_invoiced_money"].ToString()); } if (row["no_invoiced_money"] != null && row["no_invoiced_money"].ToString() != "") { model.no_invoiced_money = decimal.Parse(row["no_invoiced_money"].ToString()); } if (row["aite_user_name"] != null) { model.aite_user_name = row["aite_user_name"].ToString(); } if (row["dakuan"] != null && row["dakuan"].ToString() != "") { model.dakuan = decimal.Parse(row["dakuan"].ToString()); } if (row["dealer_id"] != null && row["dealer_id"].ToString() != "") { model.dealer_id = int.Parse(row["dealer_id"].ToString()); } //model.main_user_id=row["main_user_id"].ToString(); if (row["user_status"] != null && row["user_status"].ToString() != "") { model.user_status = int.Parse(row["user_status"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(XHD.Model.ecs_users model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ecs_users set "); strSql.Append("aite_id=@aite_id,"); strSql.Append("email=@email,"); strSql.Append("user_name=@user_name,"); strSql.Append("is_user_name_checked=@is_user_name_checked,"); strSql.Append("u_company=@u_company,"); strSql.Append("u_real_name=@u_real_name,"); strSql.Append("erp_custom_code=@erp_custom_code,"); strSql.Append("password=@password,"); strSql.Append("question=@question,"); strSql.Append("answer=@answer,"); strSql.Append("sex=@sex,"); strSql.Append("birthday=@birthday,"); strSql.Append("user_money=@user_money,"); strSql.Append("frozen_money=@frozen_money,"); strSql.Append("pay_points=@pay_points,"); strSql.Append("rank_points=@rank_points,"); strSql.Append("address_id=@address_id,"); strSql.Append("reg_time=@reg_time,"); strSql.Append("last_login=@last_login,"); strSql.Append("last_time=@last_time,"); strSql.Append("last_ip=@last_ip,"); strSql.Append("visit_count=@visit_count,"); strSql.Append("user_rank=@user_rank,"); strSql.Append("is_special=@is_special,"); strSql.Append("ec_salt=@ec_salt,"); strSql.Append("salt=@salt,"); strSql.Append("parent_id=@parent_id,"); strSql.Append("flag=@flag,"); strSql.Append("alias=@alias,"); strSql.Append("msn=@msn,"); strSql.Append("qq=@qq,"); strSql.Append("office_phone=@office_phone,"); strSql.Append("home_phone=@home_phone,"); strSql.Append("mobile_phone=@mobile_phone,"); strSql.Append("is_validated=@is_validated,"); strSql.Append("credit_line=@credit_line,"); strSql.Append("passwd_question=@passwd_question,"); strSql.Append("passwd_answer=@passwd_answer,"); strSql.Append("mediaUID=@mediaUID,"); strSql.Append("mediaID=@mediaID,"); strSql.Append("user_market_area=@user_market_area,"); strSql.Append("admin_user_name=@admin_user_name,"); strSql.Append("admin_user_id=@admin_user_id,"); strSql.Append("admin_u_real_name=@admin_u_real_name,"); strSql.Append("is_daifa=@is_daifa,"); strSql.Append("send_user_name=@send_user_name,"); strSql.Append("send_user_tel=@send_user_tel,"); strSql.Append("send_user_company=@send_user_company,"); strSql.Append("send_user_address=@send_user_address,"); strSql.Append("user_from=@user_from,"); strSql.Append("user_beizhu=@user_beizhu,"); strSql.Append("is_erp_archives=@is_erp_archives,"); strSql.Append("yes_invoiced_money=@yes_invoiced_money,"); strSql.Append("no_invoiced_money=@no_invoiced_money,"); strSql.Append("aite_user_name=@aite_user_name,"); strSql.Append("dakuan=@dakuan,"); strSql.Append("dealer_id=@dealer_id,"); strSql.Append("main_user_id=@main_user_id,"); strSql.Append("user_status=@user_status"); strSql.Append(" where user_id=@user_id"); MySqlParameter[] parameters = { new MySqlParameter("@aite_id", MySqlDbType.Text), new MySqlParameter("@email", MySqlDbType.VarChar, 60), new MySqlParameter("@user_name", MySqlDbType.VarChar, 60), new MySqlParameter("@is_user_name_checked", MySqlDbType.Int32, 1), new MySqlParameter("@u_company", MySqlDbType.VarChar, 60), new MySqlParameter("@u_real_name", MySqlDbType.VarChar, 60), new MySqlParameter("@erp_custom_code", MySqlDbType.VarChar, 60), new MySqlParameter("@password", MySqlDbType.VarChar, 32), new MySqlParameter("@question", MySqlDbType.VarChar, 255), new MySqlParameter("@answer", MySqlDbType.VarChar, 255), new MySqlParameter("@sex", MySqlDbType.Int32, 1), new MySqlParameter("@birthday", MySqlDbType.Int32), new MySqlParameter("@user_money", MySqlDbType.Decimal, 10), new MySqlParameter("@frozen_money", MySqlDbType.Decimal, 10), new MySqlParameter("@pay_points", MySqlDbType.Int32, 10), new MySqlParameter("@rank_points", MySqlDbType.Int32, 10), new MySqlParameter("@address_id", MySqlDbType.Int32, 8), new MySqlParameter("@reg_time", MySqlDbType.Int32, 10), new MySqlParameter("@last_login", MySqlDbType.Int32, 11), new MySqlParameter("@last_time", MySqlDbType.DateTime), new MySqlParameter("@last_ip", MySqlDbType.VarChar, 15), new MySqlParameter("@visit_count", MySqlDbType.Int32, 5), new MySqlParameter("@user_rank", MySqlDbType.Int32, 3), new MySqlParameter("@is_special", MySqlDbType.Int32, 3), new MySqlParameter("@ec_salt", MySqlDbType.VarChar, 10), new MySqlParameter("@salt", MySqlDbType.VarChar, 10), new MySqlParameter("@parent_id", MySqlDbType.Int32, 9), new MySqlParameter("@flag", MySqlDbType.Int32, 3), new MySqlParameter("@alias", MySqlDbType.VarChar, 60), new MySqlParameter("@msn", MySqlDbType.VarChar, 60), new MySqlParameter("@qq", MySqlDbType.VarChar, 20), new MySqlParameter("@office_phone", MySqlDbType.VarChar, 20), new MySqlParameter("@home_phone", MySqlDbType.VarChar, 20), new MySqlParameter("@mobile_phone", MySqlDbType.VarChar, 20), new MySqlParameter("@is_validated", MySqlDbType.Int32, 3), new MySqlParameter("@credit_line", MySqlDbType.Decimal, 10), new MySqlParameter("@passwd_question", MySqlDbType.VarChar, 50), new MySqlParameter("@passwd_answer", MySqlDbType.VarChar, 255), new MySqlParameter("@mediaUID", MySqlDbType.VarChar, 50), new MySqlParameter("@mediaID", MySqlDbType.Int32, 4), new MySqlParameter("@user_market_area", MySqlDbType.VarChar, 30), new MySqlParameter("@admin_user_name", MySqlDbType.VarChar, 30), new MySqlParameter("@admin_user_id", MySqlDbType.Int32, 11), new MySqlParameter("@admin_u_real_name", MySqlDbType.VarChar, 30), new MySqlParameter("@is_daifa", MySqlDbType.Int32, 2), new MySqlParameter("@send_user_name", MySqlDbType.VarChar, 30), new MySqlParameter("@send_user_tel", MySqlDbType.VarChar, 30), new MySqlParameter("@send_user_company", MySqlDbType.VarChar, 30), new MySqlParameter("@send_user_address", MySqlDbType.VarChar, 30), new MySqlParameter("@user_from", MySqlDbType.VarChar, 30), new MySqlParameter("@user_beizhu", MySqlDbType.Text), new MySqlParameter("@is_erp_archives", MySqlDbType.Int32, 1), new MySqlParameter("@yes_invoiced_money", MySqlDbType.Decimal, 10), new MySqlParameter("@no_invoiced_money", MySqlDbType.Decimal, 10), new MySqlParameter("@aite_user_name", MySqlDbType.VarChar, 60), new MySqlParameter("@dakuan", MySqlDbType.Decimal, 10), new MySqlParameter("@dealer_id", MySqlDbType.Int32, 11), new MySqlParameter("@main_user_id", MySqlDbType.Int32, 8), new MySqlParameter("@user_status", MySqlDbType.Int32, 1), new MySqlParameter("@user_id", MySqlDbType.Int32, 8) }; parameters[0].Value = model.aite_id; parameters[1].Value = model.email; parameters[2].Value = model.user_name; parameters[3].Value = model.is_user_name_checked; parameters[4].Value = model.u_company; parameters[5].Value = model.u_real_name; parameters[6].Value = model.erp_custom_code; parameters[7].Value = model.password; parameters[8].Value = model.question; parameters[9].Value = model.answer; parameters[10].Value = model.sex; parameters[11].Value = model.birthday; parameters[12].Value = model.user_money; parameters[13].Value = model.frozen_money; parameters[14].Value = model.pay_points; parameters[15].Value = model.rank_points; parameters[16].Value = model.address_id; parameters[17].Value = model.reg_time; parameters[18].Value = model.last_login; parameters[19].Value = model.last_time; parameters[20].Value = model.last_ip; parameters[21].Value = model.visit_count; parameters[22].Value = model.user_rank; parameters[23].Value = model.is_special; parameters[24].Value = model.ec_salt; parameters[25].Value = model.salt; parameters[26].Value = model.parent_id; parameters[27].Value = model.flag; parameters[28].Value = model.alias; parameters[29].Value = model.msn; parameters[30].Value = model.qq; parameters[31].Value = model.office_phone; parameters[32].Value = model.home_phone; parameters[33].Value = model.mobile_phone; parameters[34].Value = model.is_validated; parameters[35].Value = model.credit_line; parameters[36].Value = model.passwd_question; parameters[37].Value = model.passwd_answer; parameters[38].Value = model.mediaUID; parameters[39].Value = model.mediaID; parameters[40].Value = model.user_market_area; parameters[41].Value = model.admin_user_name; parameters[42].Value = model.admin_user_id; parameters[43].Value = model.admin_u_real_name; parameters[44].Value = model.is_daifa; parameters[45].Value = model.send_user_name; parameters[46].Value = model.send_user_tel; parameters[47].Value = model.send_user_company; parameters[48].Value = model.send_user_address; parameters[49].Value = model.user_from; parameters[50].Value = model.user_beizhu; parameters[51].Value = model.is_erp_archives; parameters[52].Value = model.yes_invoiced_money; parameters[53].Value = model.no_invoiced_money; parameters[54].Value = model.aite_user_name; parameters[55].Value = model.dakuan; parameters[56].Value = model.dealer_id; parameters[57].Value = model.main_user_id; parameters[58].Value = model.user_status; parameters[59].Value = model.user_id; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }