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);
}
}
