public ActionResult InsertAsync(SysAccountInfo entity)
{
entity.CreatorId = mLogin.Id.ToString();
//所有AJAX的结果，返回统一数据格式
var result = new AjaxResult();
try
{
var queryLogin = SysAccountInfoContract.CheckExists(m => m.Login.Equals(entity.Login) && m.IsDeleted == false);
var querySuName = SysAccountInfoContract.CheckExists(m => m.SuName.Equals(entity.SuName) && m.IsDeleted == false);
if (queryLogin)
{
result.Type = AjaxResultType.Error;
result.Content = "登录名已被使用";
}
else if (querySuName)
{
result.Type = AjaxResultType.Error;
result.Content = "员工已经存在";
}
else
{
var count = SysAccountInfoContract.Insert(entity);
if (count > 0)
{
result.Type = AjaxResultType.Success;
result.Content = "录入成功";
}
else
{
result.Type = AjaxResultType.Error;
result.Content = "录入失败";
}
}
}
catch (Exception ex)
{
result.Type = AjaxResultType.Error;
result.Content = "异常操作";
}
return(JsonEx(result));
}
/// <summary>
/// 修改信息
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public ActionResult EditAsync(SysAccountInfo entity)
{
var result = new AjaxResult();
try
{
var count = SysAccountInfoContract.UpdateDirect(d => d.Id == entity.Id, d =>
new SysAccountInfo
{
SuName = entity.SuName,
Position = entity.Position,
Role = entity.Role,
Phone = entity.Phone,
Identity = entity.Identity,
Email = entity.Email,
Explain = entity.Explain,
Login = entity.Login,
Password = entity.Password
});
if (count > 0)
{
result.Type = AjaxResultType.Success;
result.Content = "修改成功";
}
else
{
result.Type = AjaxResultType.Error;
result.Content = "修改失败";
}
}
catch
{
result.Type = AjaxResultType.Error;
result.Content = "异常操作";
}
return(JsonEx(result));
}
public AjaxResult <SysAccountInfo> GetSysAccountInfo(int managerid)
{
var user = db.WebSysManager.FirstOrDefault(m => m.ManagerId == managerid);
if (user == null)
{
user = new WebSysManager();
}
SysAccountInfo info = new SysAccountInfo()
{
IsSupper = user.IsSupper ?? 0,
ManagerEmail = user.ManagerEmail,
ManagerId = user.ManagerId,
ManagerRealname = user.ManagerRealname,
ManagerStatus = user.ManagerStatus ?? 0,
ManagerTel = user.ManagerTel,
ManagerName = user.ManagerName,
};
var roles = db.WebSysRole.ToList();
var userRoles = db.WebSysManagerRole.Where(m => m.ManagerId == user.ManagerId);
info.Roles = new List <RoleItemInfo>();
foreach (var role in roles)
{
RoleItemInfo addItem = new RoleItemInfo()
{
RoleID = role.RoleId,
RoleName = role.RoleName,
};
var userRole = userRoles.FirstOrDefault(m => m.RoleId == role.RoleId);
if (userRole != null)
{
addItem.Checked = 1;
}
info.Roles.Add(addItem);
}
return(new AjaxResult <SysAccountInfo>(info));
}
/// <summary>
/// 删除实体
/// </summary>
/// <param name="entity">实体对象</param>
/// <returns>操作影响的行数</returns>
public int Delete(SysAccountInfo entity)
{
return(Repository.Delete(entity));
}
/// <summary>
/// 插入实体
/// </summary>
/// <param name="entity">实体对象</param>
/// <returns>操作影响的行数</returns>
public int Insert(SysAccountInfo entity)
{
return(Repository.Insert(entity));
}
/// <summary>
/// 异步更新实体对象
/// </summary>
/// <param name="entity">更新后的实体对象</param>
/// <returns>操作影响的行数</returns>
public Task <int> UpdateAsync(SysAccountInfo entity)
{
return(Repository.UpdateAsync(entity));
}
/// <summary>
/// 异步插入实体
/// </summary>
/// <param name="entity">实体对象</param>
/// <returns>操作影响的行数</returns>
public Task <int> InsertAsync(SysAccountInfo entity)
{
return(Repository.InsertAsync(entity));
}
/// <summary>
/// 更新实体对象
/// </summary>
/// <param name="entity">更新后的实体对象</param>
/// <returns>操作影响的行数</returns>
public int Update(SysAccountInfo entity)
{
return(Repository.Update(entity));
}
public AjaxResult <Object> SaveAccountInfo(SysAccountInfo model)
{
if (string.IsNullOrEmpty(model.ManagerName))
{
return(new AjaxResult <Object>("请输入登录名"));
}
if (model.ManagerId == 0)
{
var userN = db.WebSysManager.FirstOrDefault(m => m.ManagerName == model.ManagerName);
if (userN != null)
{
return(new AjaxResult <Object>("该登录名已存在"));
}
}
using (var scope = new TransactionScope())
{
var user = db.WebSysManager.FirstOrDefault(m => m.ManagerId == model.ManagerId);
if (user == null)
{
Random rd = new Random();
string scal = rd.Next(10000, 99999).ToString();
user = new WebSysManager()
{
ManagerName = model.ManagerName,
IsSupper = model.IsSupper,
CreateTime = DateTime.Now,
UpdateTime = DateTime.Now,
ManagerEmail = model.ManagerEmail,
ManagerIsdel = 0,
ManagerPwd = Encrypt.MD5Encrypt(Encrypt.MD5Encrypt("123456") + scal),
ManagerScal = scal,
ManagerRealname = model.ManagerRealname,
ManagerStatus = model.ManagerStatus,
ManagerTel = model.ManagerTel
};
db.WebSysManager.Add(user);
db.SaveChanges();
}
else
{
user.IsSupper = model.IsSupper;
user.UpdateTime = DateTime.Now;
user.ManagerEmail = model.ManagerEmail;
user.ManagerRealname = model.ManagerRealname;
user.ManagerStatus = model.ManagerStatus;
user.IsSupper = model.IsSupper;
user.ManagerTel = model.ManagerTel;
db.SaveChanges();
}
//删除原先分配的角色
var dels = db.WebSysManagerRole.Where(m => m.ManagerId == user.ManagerId).ToList();
if (dels.Count > 0)
{
db.WebSysManagerRole.RemoveRange(dels);
}
if (model.Roles != null)
{
List <WebSysManagerRole> InSertRoles = new List <WebSysManagerRole>();
foreach (var item in model.Roles)
{
WebSysManagerRole addItem = new WebSysManagerRole()
{
ManagerId = user.ManagerId,
RoleId = item.RoleID,
};
InSertRoles.Add(addItem);
}
if (InSertRoles.Count > 0)
{
db.WebSysManagerRole.AddRange(InSertRoles);
db.SaveChanges();
}
}
scope.Complete();
}
return(new AjaxResult <Object>("帐号保存成功！", 0));
}
public JsonResult AccountSaveInfo(SysAccountInfo model)
{
var result = sysUserManager.SaveAccountInfo(model);
return(Json(result));
}
