/// <summary>
/// 创建用户并关联角色
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool InsertUsers(view_sys_user_role model)
{
var umodel = new sys_user();
umodel.User_ID = Guid.NewGuid().ToString();
umodel.User_CreateTime = DateTime.Now;
umodel.User_Email = model.User_Email;
umodel.User_IsDelete = 1;
umodel.User_LoginName = model.User_LoginName;
umodel.User_Name = model.User_Name;
umodel.User_Pwd = model.User_Pwd;
var result = _Sys_UserRepositoryS.Insert(umodel);
if (result > 0)
{
var urmodel = new sys_userrole();
urmodel.UserRole_CreateTime = DateTime.Now;
urmodel.UserRole_ID = Guid.NewGuid().ToString();
urmodel.UserRole_RoleID = model.Role_ID;
urmodel.UserRole_UserID = umodel.User_ID;
result = _Sys_UserRoleRepositoryS.Insert(urmodel);
if (result <= 0)
{
_Sys_UserRepositoryS.Delete(umodel);
}
}
return(result > 0);
}
public IActionResult AddSave(view_sys_user_role vmodel)
{
if (vmodel != null)
{
if (string.IsNullOrEmpty(vmodel.User_ID))
{
if (string.IsNullOrEmpty(vmodel.User_Name))
{
return(Json(new { code = 100, msg = "请输入用户名" }));
}
if (string.IsNullOrEmpty(vmodel.User_LoginName))
{
return(Json(new { code = 100, msg = "请输入登录名" }));
}
if (string.IsNullOrEmpty(vmodel.Role_ID))
{
return(Json(new { code = 100, msg = "请选择角色名称" }));
}
vmodel.User_ID = Guid.NewGuid().ToString();
vmodel.User_Pwd = Tools.MD5Encryption(vmodel.User_Pwd);
vmodel.User_CreateTime = DateTime.Now;
_UserService.InsertUsers(vmodel);
}
else
{
return(Json(new { code = 100, msg = "无效参数" }));
}
}
else
{
return(Json(new { code = 100, msg = "无效参数" }));
}
return(Json(new { code = 200, msg = "操作成功" }));
}
public IActionResult Save(view_sys_user_role vmodel)
{
if (vmodel != null)
{
if (string.IsNullOrEmpty(vmodel.User_Name))
{
throw new MessageBox("请输入用户名");
}
if (string.IsNullOrEmpty(vmodel.User_LoginName))
{
throw new MessageBox("请输入登录名");
}
if (string.IsNullOrEmpty(vmodel.User_ID) && string.IsNullOrEmpty(vmodel.User_Pwd))
{
throw new MessageBox("请输入登陆密码");
}
if (string.IsNullOrEmpty(vmodel.Role_ID))
{
throw new MessageBox("请选择角色名称");
}
if (string.IsNullOrEmpty(vmodel.User_ID))
{
vmodel.User_Pwd = Tools.MD5Encryption(vmodel.User_Pwd);
_sys_UserService.InsertUsers(vmodel);
}
else
{
var model = _sys_UserService.FindByClause(p => p.User_ID == vmodel.User_ID);
if (model != null)
{
if (!string.IsNullOrEmpty(vmodel.User_Pwd))
{
vmodel.User_Pwd = Tools.MD5Encryption(vmodel.User_Pwd);
}
_sys_UserService.UpdateUsers(vmodel);
}
else
{
throw new MessageBox("该用户不存在");
}
}
}
else
{
return(Json(new { status = 0, msg = "无效参数" }));
}
return(Json(new { status = 1, msg = "操作成功" }));
}
/// <summary>
/// 修改用户并修改关联角色
/// </summary>
/// <param name="u"></param>
/// <returns></returns>
public bool UpdateUsers(view_sys_user_role u)
{
var model = new sys_user();
model.User_ID = u.User_ID;
model.User_LoginName = u.User_LoginName;
model.User_Name = u.User_Name;
model.User_Pwd = u.User_Pwd;
model.User_Email = u.User_Email;
var result = _Sys_UserRepositoryS.Update(model, p => new { p.User_LoginName, p.User_Name, p.User_Pwd, p.User_Email, p.User_CreateTime });
if (result)
{
var rmodel = new sys_userrole();
rmodel.UserRole_ID = u.UserRole_ID;
rmodel.UserRole_RoleID = u.Role_ID;
rmodel.UserRole_UserID = u.User_ID;
_Sys_UserRoleRepositoryS.Update(rmodel, p => new { p.UserRole_RoleID, p.UserRole_UserID });
}
return(result);
}
public IActionResult EditSave(view_sys_user_role vmodel)
{
if (!string.IsNullOrEmpty(vmodel.User_ID))
{
if (string.IsNullOrEmpty(vmodel.User_Name))
{
return(Json(new { code = 100, msg = "请输入用户名" }));
}
if (string.IsNullOrEmpty(vmodel.User_LoginName))
{
return(Json(new { code = 100, msg = "请输入登录名" }));
}
if (string.IsNullOrEmpty(vmodel.Role_ID))
{
return(Json(new { code = 100, msg = "请选择角色名称" }));
}
var model = _view_sys_user_roleService.FindByClause(p => p.User_ID == vmodel.User_ID);
if (model != null)
{
if (!string.IsNullOrEmpty(vmodel.User_Pwd) && vmodel.User_Pwd != model.User_Pwd)
{
vmodel.User_Pwd = Tools.MD5Encryption(vmodel.User_Pwd);
}
else
{
vmodel.User_Pwd = model.User_Pwd;
}
_UserService.UpdateUsers(vmodel);
}
else
{
return(Json(new { code = 100, msg = "没有该用户" }));
}
}
else
{
return(Json(new { code = 100, msg = "参数无效" }));
}
return(Json(new { code = 200, msg = "操作成功" }));
}
/// <summary>
/// 删除数据
/// </summary>
/// <param name="entity">实体类</param>
/// <returns></returns>
public bool Delete(view_sys_user_role entity)
{
return(_view_sys_user_roleRepositoryS.Delete(entity));
}
/// <summary>
/// 更新实体数据
/// </summary>
/// <param name="entity"></param>
/// <param name="updateColumns">修改字段表达式树</param>
/// <returns></returns>
public bool Update(view_sys_user_role entity, Expression <Func <view_sys_user_role, object> > updateColumns)
{
return(_view_sys_user_roleRepositoryS.Update(entity, updateColumns));
}
/// <summary>
/// 更新实体数据
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public bool Update(view_sys_user_role entity)
{
return(_view_sys_user_roleRepositoryS.Update(entity));
}
/// <summary>
/// 写入实体数据
/// </summary>
/// <param name="entity">实体类</param>
/// <returns></returns>
public long Insert(view_sys_user_role entity)
{
return(_view_sys_user_roleRepositoryS.Insert(entity));
}
