public bool setInfo([FromBody] JObject json) { try { string[] skill = new string[1] { json["skill"].ToString() }; string[] honor = new string[1] { json["honor"].ToString() }; Cook.Model.users model = new Cook.Model.users(); model.name = json["name"].ToString(); model.sex = json["sex"].ToString(); model.skill = skill; model.honor = honor; model.introdice = json["introdice"].ToString(); model.email = json["Email"].ToString(); model.address = json["address"].ToString(); string token = HttpContext.Current.Request.Headers["Authorization"].ToString(); Cook.BLL.users user = new Cook.BLL.users(); return(user.setinfo(model, token)); } catch (Exception) { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public override bool Add(Cook.Model.users model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into users("); strSql.Append("name,sex,type,url,bg,pagebg,henchman,follow,skill,honor,email,phone,address,introdice,status,id)"); strSql.Append(" values ("); strSql.Append("@name,@sex,@type,@url,@bg,@pagebg,@henchman,@follow,@skill,@honor,@email,@phone,@address,@introdice,@status,@id)"); //strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@name", SqlDbType.NVarChar, 20), new SqlParameter("@sex", SqlDbType.Char, 2), new SqlParameter("@type", SqlDbType.Char, 1), new SqlParameter("@url", SqlDbType.VarChar, -1), new SqlParameter("@bg", SqlDbType.VarChar, -1), new SqlParameter("@pagebg", SqlDbType.VarChar, -1), new SqlParameter("@henchman", SqlDbType.Int, 4), new SqlParameter("@follow", SqlDbType.Int, 4), new SqlParameter("@skill", SqlDbType.NVarChar, 200), new SqlParameter("@honor", SqlDbType.NVarChar, -1), new SqlParameter("@email", SqlDbType.VarChar, 50), new SqlParameter("@phone", SqlDbType.NVarChar, 20), new SqlParameter("@address", SqlDbType.NVarChar, 100), new SqlParameter("@introdice", SqlDbType.NVarChar, 200), new SqlParameter("@status", SqlDbType.Char, 1), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.name; parameters[1].Value = model.sex; parameters[2].Value = model.type; parameters[3].Value = model.url; parameters[4].Value = model.bg; parameters[5].Value = model.pagebg; parameters[6].Value = model.henchman; parameters[7].Value = model.follow; parameters[8].Value = model.skill; parameters[9].Value = model.honor; parameters[10].Value = model.email; parameters[11].Value = model.phone; parameters[12].Value = model.address; parameters[13].Value = model.introdice; parameters[14].Value = model.status; parameters[15].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
//修改用户信息 public bool setinfo(Cook.Model.users model, int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("update users set "); strSql.Append("name=@name,"); strSql.Append("sex=@sex,"); strSql.Append("skill=@skill,"); strSql.Append("honor=@honor,"); strSql.Append("email=@email,"); strSql.Append("address=@address,"); strSql.Append("introdice=@introdice"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@name", SqlDbType.NVarChar, 20), new SqlParameter("@sex", SqlDbType.Char, 2), new SqlParameter("@skill", SqlDbType.NVarChar, 200), new SqlParameter("@honor", SqlDbType.NVarChar, -1), new SqlParameter("@email", SqlDbType.VarChar, 50), new SqlParameter("@address", SqlDbType.NVarChar, 100), new SqlParameter("@introdice", SqlDbType.NVarChar, 200), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.name; parameters[1].Value = model.sex; parameters[2].Value = model.skill[0]; parameters[3].Value = model.honor[0]; parameters[4].Value = model.email; parameters[5].Value = model.address; parameters[6].Value = model.introdice; parameters[7].Value = id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public override Cook.Model.users DataRowToModel(DataRow row) { Cook.Model.users model = new Cook.Model.users(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["name"] != null) { model.name = row["name"].ToString(); } if (row["sex"] != null) { model.sex = row["sex"].ToString(); } if (row["type"] != null) { model.type = row["type"].ToString(); } if (row["url"] != null) { model.url = row["url"].ToString(); } if (row["bg"] != null) { model.bg = row["bg"].ToString(); } if (row["pagebg"] != null) { model.pagebg = row["pagebg"].ToString(); } if (row["henchman"] != null && row["henchman"].ToString() != "") { model.henchman = int.Parse(row["henchman"].ToString()); } if (row["follow"] != null && row["follow"].ToString() != "") { model.follow = int.Parse(row["follow"].ToString()); } if (row["skill"] != null) { model.skill = getArr(row["skill"].ToString()); } if (row["honor"] != null) { model.honor = getArr(row["honor"].ToString()); } if (row["email"] != null) { model.email = row["email"].ToString(); } if (row["phone"] != null) { model.phone = row["phone"].ToString(); } if (row["address"] != null) { model.address = row["address"].ToString(); } if (row["introdice"] != null) { model.introdice = row["introdice"].ToString(); } if (row["status"] != null) { model.status = row["status"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public override bool Update(Cook.Model.users model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update users set "); strSql.Append("name=@name,"); strSql.Append("sex=@sex,"); strSql.Append("type=@type,"); strSql.Append("url=@url,"); strSql.Append("bg=@bg,"); strSql.Append("pagebg=@pagebg,"); strSql.Append("henchman=@henchman,"); strSql.Append("follow=@follow,"); strSql.Append("skill=@skill,"); strSql.Append("honor=@honor,"); strSql.Append("email=@email,"); strSql.Append("phone=@phone,"); strSql.Append("address=@address,"); strSql.Append("introdice=@introdice,"); strSql.Append("status=@status"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@name", SqlDbType.NVarChar, 20), new SqlParameter("@sex", SqlDbType.Char, 2), new SqlParameter("@type", SqlDbType.Char, 1), new SqlParameter("@url", SqlDbType.VarChar, -1), new SqlParameter("@bg", SqlDbType.VarChar, -1), new SqlParameter("@pagebg", SqlDbType.VarChar, -1), new SqlParameter("@henchman", SqlDbType.Int, 4), new SqlParameter("@follow", SqlDbType.Int, 4), new SqlParameter("@skill", SqlDbType.NVarChar, 200), new SqlParameter("@honor", SqlDbType.NVarChar, -1), new SqlParameter("@email", SqlDbType.VarChar, 50), new SqlParameter("@phone", SqlDbType.NVarChar, 20), new SqlParameter("@address", SqlDbType.NVarChar, 100), new SqlParameter("@introdice", SqlDbType.NVarChar, 200), new SqlParameter("@status", SqlDbType.Char, 1), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.name; parameters[1].Value = model.sex; parameters[2].Value = model.type; parameters[3].Value = model.url; parameters[4].Value = model.bg; parameters[5].Value = model.pagebg; parameters[6].Value = model.henchman; parameters[7].Value = model.follow; parameters[8].Value = model.skill; parameters[9].Value = model.honor; parameters[10].Value = model.email; parameters[11].Value = model.phone; parameters[12].Value = model.address; parameters[13].Value = model.introdice; parameters[14].Value = model.status; parameters[15].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }