/// <summary> /// 更新一条数据 /// </summary> public bool Update(OS.Model.users.users model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update " + databaseprefix + "users set "); strSql.Append("group_id=@group_id,"); strSql.Append("user_name=@user_name,"); strSql.Append("password=@password,"); strSql.Append("salt=@salt,"); strSql.Append("email=@email,"); strSql.Append("nick_name=@nick_name,"); strSql.Append("avatar=@avatar,"); strSql.Append("sex=@sex,"); strSql.Append("birthday=@birthday,"); strSql.Append("telphone=@telphone,"); strSql.Append("mobile=@mobile,"); strSql.Append("qq=@qq,"); strSql.Append("address=@address,"); strSql.Append("safe_question=@safe_question,"); strSql.Append("safe_answer=@safe_answer,"); strSql.Append("amount=@amount,"); strSql.Append("point=@point,"); strSql.Append("exp=@exp,"); strSql.Append("status=@status,"); strSql.Append("reg_time=@reg_time,"); strSql.Append("reg_ip=@reg_ip,"); strSql.Append("universities=@universities,"); strSql.Append("professional=@professional,"); strSql.Append("membershipdues=@membershipdues,"); strSql.Append("goodat=@goodat,"); strSql.Append("workat=@workat,"); strSql.Append("industry=@industry"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@group_id", SqlDbType.Int, 4), new SqlParameter("@user_name", SqlDbType.NVarChar, 100), new SqlParameter("@password", SqlDbType.NVarChar, 100), new SqlParameter("@salt", SqlDbType.NVarChar, 20), new SqlParameter("@email", SqlDbType.NVarChar, 50), new SqlParameter("@nick_name", SqlDbType.NVarChar, 100), new SqlParameter("@avatar", SqlDbType.NVarChar, 255), new SqlParameter("@sex", SqlDbType.NVarChar, 20), new SqlParameter("@birthday", SqlDbType.DateTime), new SqlParameter("@telphone", SqlDbType.NVarChar, 50), new SqlParameter("@mobile", SqlDbType.NVarChar, 20), new SqlParameter("@qq", SqlDbType.NVarChar, 30), new SqlParameter("@address", SqlDbType.NVarChar, 255), new SqlParameter("@safe_question", SqlDbType.NVarChar, 255), new SqlParameter("@safe_answer", SqlDbType.NVarChar, 255), new SqlParameter("@amount", SqlDbType.Decimal, 5), new SqlParameter("@point", SqlDbType.Int, 4), new SqlParameter("@exp", SqlDbType.Int, 4), new SqlParameter("@status", SqlDbType.TinyInt, 1), new SqlParameter("@reg_time", SqlDbType.DateTime), new SqlParameter("@reg_ip", SqlDbType.NVarChar, 30), new SqlParameter("@universities", SqlDbType.NVarChar, 100), new SqlParameter("@professional", SqlDbType.NVarChar, 100), new SqlParameter("@membershipdues", SqlDbType.NVarChar, 100), new SqlParameter("@goodat", SqlDbType.NVarChar, 1000), new SqlParameter("@workat", SqlDbType.NVarChar, 1000), new SqlParameter("@industry", SqlDbType.NVarChar, 1000), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.group_id; parameters[1].Value = model.user_name; parameters[2].Value = model.password; parameters[3].Value = model.salt; parameters[4].Value = model.email; parameters[5].Value = model.nick_name; parameters[6].Value = model.avatar; parameters[7].Value = model.sex; parameters[8].Value = model.birthday; parameters[9].Value = model.telphone; parameters[10].Value = model.mobile; parameters[11].Value = model.qq; parameters[12].Value = model.address; parameters[13].Value = model.safe_question; parameters[14].Value = model.safe_answer; parameters[15].Value = model.amount; parameters[16].Value = model.point; parameters[17].Value = model.exp; parameters[18].Value = model.status; parameters[19].Value = model.reg_time; parameters[20].Value = model.reg_ip; parameters[21].Value = model.universities; parameters[22].Value = model.professional; parameters[23].Value = model.membershipdues; parameters[24].Value = model.goodat; parameters[25].Value = model.workat; parameters[26].Value = model.industry; parameters[27].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(OS.Model.users.users model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into " + databaseprefix + "users("); strSql.Append("group_id,user_name,password,salt,email,nick_name,avatar,sex,birthday,telphone,mobile,qq,address,safe_question,safe_answer,amount,point,exp,status,reg_time,reg_ip,universities,professional,membershipdues,goodat,workat,industry)"); strSql.Append(" values ("); strSql.Append("@group_id,@user_name,@password,@salt,@email,@nick_name,@avatar,@sex,@birthday,@telphone,@mobile,@qq,@address,@safe_question,@safe_answer,@amount,@point,@exp,@status,@reg_time,@reg_ip,@universities,@professional,@membershipdues,@goodat,@workat,@industry)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@group_id", SqlDbType.Int, 4), new SqlParameter("@user_name", SqlDbType.NVarChar, 100), new SqlParameter("@password", SqlDbType.NVarChar, 100), new SqlParameter("@salt", SqlDbType.NVarChar, 20), new SqlParameter("@email", SqlDbType.NVarChar, 50), new SqlParameter("@nick_name", SqlDbType.NVarChar, 100), new SqlParameter("@avatar", SqlDbType.NVarChar, 255), new SqlParameter("@sex", SqlDbType.NVarChar, 20), new SqlParameter("@birthday", SqlDbType.DateTime), new SqlParameter("@telphone", SqlDbType.NVarChar, 50), new SqlParameter("@mobile", SqlDbType.NVarChar, 20), new SqlParameter("@qq", SqlDbType.NVarChar, 30), new SqlParameter("@address", SqlDbType.NVarChar, 255), new SqlParameter("@safe_question", SqlDbType.NVarChar, 255), new SqlParameter("@safe_answer", SqlDbType.NVarChar, 255), new SqlParameter("@amount", SqlDbType.Decimal, 5), new SqlParameter("@point", SqlDbType.Int, 4), new SqlParameter("@exp", SqlDbType.Int, 4), new SqlParameter("@status", SqlDbType.TinyInt, 1), new SqlParameter("@reg_time", SqlDbType.DateTime), new SqlParameter("@reg_ip", SqlDbType.NVarChar, 30), new SqlParameter("@universities", SqlDbType.NVarChar, 100), new SqlParameter("@professional", SqlDbType.NVarChar, 100), new SqlParameter("@membershipdues", SqlDbType.NVarChar, 100), new SqlParameter("@goodat", SqlDbType.NVarChar, 1000), new SqlParameter("@workat", SqlDbType.NVarChar, 1000), new SqlParameter("@industry", SqlDbType.NVarChar, 1000) }; parameters[0].Value = model.group_id; parameters[1].Value = model.user_name; parameters[2].Value = model.password; parameters[3].Value = model.salt; parameters[4].Value = model.email; parameters[5].Value = model.nick_name; parameters[6].Value = model.avatar; parameters[7].Value = model.sex; parameters[8].Value = model.birthday; parameters[9].Value = model.telphone; parameters[10].Value = model.mobile; parameters[11].Value = model.qq; parameters[12].Value = model.address; parameters[13].Value = model.safe_question; parameters[14].Value = model.safe_answer; parameters[15].Value = model.amount; parameters[16].Value = model.point; parameters[17].Value = model.exp; parameters[18].Value = model.status; parameters[19].Value = model.reg_time; parameters[20].Value = model.reg_ip; parameters[21].Value = model.universities; parameters[22].Value = model.professional; parameters[23].Value = model.membershipdues; parameters[24].Value = model.goodat; parameters[25].Value = model.workat; parameters[26].Value = model.industry; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }