public IActionResult UsersUpt(UsersGL s)
{
var list = _bll.UsersGLUpt(s);
return(Ok(new { data = list, msg = list > 0 ? "修改成功" : "修改失败", state = list > 0 ? true : false }));
}
/// <summary>
/// 用户修改
/// </summary>
/// <param name="s"></param>
/// <returns></returns>z
public int UsersGLUpt(UsersGL s)
{
string sql = $"update UsersGL set Uname='{s.Uname}',Utel='{s.Utel}',UserTypeId='{s.UserTypeId}',States='{s.States}' where Uid={s.Uid}";
return(_db.ExecuteNonQuery(sql));
}
public IActionResult UsersAdd(UsersGL s)
{
var list = _bll.UsersGLAdd(s);
return(Ok(new { data = list, msg = list > 0?"添加成功":"添加失败", state = list > 0?true:false }));
}
/// <summary>
/// 用户添加
/// </summary>
/// <param name="s"></param>
/// <returns></returns>
public int UsersGLAdd(UsersGL s)
{
string sql = $"insert into UsersGL values ('{s.Uname}','{s.Utel}','{s.UserTypeId}','{s.States}')";
return(_db.ExecuteNonQuery(sql));
}
