/// <summary>
/// 根据对象实体数据更新用户组信息
/// </summary>
/// <param name="group">用户组对象</param>
/// <returns>JsonResult</returns>
public JsonResult UpdateGroup(SYS_UserGroup group)
{
const string action = "6910FD14-5654-4CF0-B159-8FE1DF68619F";
var verify = new SessionVerify();
if (!verify.Compare(action))
{
return(verify.Result);
}
return(Update(group) ? verify.Result : verify.Result.DataBaseError());
}
/// <summary>
/// 根据对象实体数据新增一个用户组
/// </summary>
/// <param name="group">用户组对象</param>
/// <returns>JsonResult</returns>
public JsonResult AddGroup(SYS_UserGroup group)
{
const string action = "6E80210E-6F80-4FF7-8520-B602934D635C";
var verify = new SessionVerify();
if (!verify.Compare(action))
{
return(verify.Result);
}
var id = InsertData(verify.Basis.UserId, group);
return(id == null?verify.Result.DataBaseError() : verify.Result.Created());
}
/// <summary>
/// 根据对象实体数据更新用户组信息
/// </summary>
/// <param name="obj">用户组对象</param>
/// <returns>bool 是否更新成功</returns>
private bool Update(SYS_UserGroup obj)
{
const string sql = "update SYS_UserGroup set Name = @Name, Description = @Description where ID = @ID";
var parm = new[]
{
new SqlParameter("@ID", SqlDbType.UniqueIdentifier)
{
Value = obj.ID
},
new SqlParameter("@Name", obj.Name),
new SqlParameter("@Description", obj.Description)
};
return(SqlNonQuery(MakeCommand(sql, parm)) > 0);
}
/// <summary>
/// 根据对象实体数据新增一个用户组
/// </summary>
/// <param name="id">用户ID</param>
/// <param name="obj">用户组对象</param>
/// <returns>object 插入的用户组ID </returns>
private object InsertData(Guid id, SYS_UserGroup obj)
{
const string sql = "insert into SYS_UserGroup (Name, Description, CreatorUserId) select @Name, @Description, @CreatorUserId select ID From SYS_UserGroup where SN = SCOPE_IDENTITY()";
var parm = new[]
{
new SqlParameter("@Name", obj.Name),
new SqlParameter("@Description", obj.Description),
new SqlParameter("@CreatorUserId", SqlDbType.UniqueIdentifier)
{
Value = id
}
};
return(SqlScalar(MakeCommand(sql, parm)));
}
