public ActionResult Edit(tblUser_Sys collection)
{
ReturnMessage RM = new ReturnMessage(false);
if (ModelState.IsValid)
{
try
{
var query =
BusinessContext.tblUser_Sys.GetList(
Query.And(Query <tblUser_Sys> .EQ(t => t.LoginName, collection.LoginName),
Query <tblUser_Sys> .NE(t => t.Rid, collection.Rid)));
if (query.Count > 0)
{
RM.Message = "登录名已被占用";
}
else
{
tblUser_Sys old =
BusinessContext.tblUser_Sys.Get(Query <tblUser_Sys> .EQ(t => t.Rid, collection.Rid));
RM.IsSuccess = BusinessContext.tblUser_Sys.Update(collection);
if (RM.IsSuccess)
{
OperateLogHelper.Edit <tblUser_Sys>(collection, old);
var list =
BusinessContext.tblUser_Roles.GetList(Query <tblUser_Roles> .EQ(t => t.LoginName,
collection.LoginName)).Where(p => p.Role_Id == collection.DefaultRoleId).ToList();
if (list != null && list.Count > 0)
{
tblUser_Roles role = list[0];
role.IsDefault = true;
role.Role_Id = collection.DefaultRoleId;
tblUser_Roles old_Roles = BusinessContext.tblUser_Roles.Get(Query <tblUser_Roles> .EQ(t => t.Rid, role.Rid));
BusinessContext.tblUser_Roles.Update(role);
OperateLogHelper.Edit <tblUser_Roles>(role, old_Roles);
}
else
{
tblUser_Roles role = new tblUser_Roles();
role.IsDefault = true;
role.LoginName = collection.LoginName;
role.Role_Id = collection.DefaultRoleId;
BusinessContext.tblUser_Roles.Add(role);
OperateLogHelper.Create <tblUser_Roles>(role);
}
}
}
}
catch (Exception ex)
{
RM.Message = ex.Message;
}
}
return(Json(RM));
}
public ActionResult Edit(tblUser_Sys collection)
{
ReturnMessage RM = new ReturnMessage(false);
if (ModelState.IsValid)
{
try
{
var query = BusinessContext.tblUser_Sys.GetModelList(String.Format("LoginName='{0}' and TblRcdId<>{1}", collection.LoginName, collection.TblRcdId));
if (query.Count > 0)
{
RM.Message = "登录名已被占用";
}
else
{
tblUser_Sys old = BusinessContext.tblUser_Sys.GetModel(collection.TblRcdId);
RM.IsSuccess = BusinessContext.tblUser_Sys.Update(collection);
if (RM.IsSuccess)
{
OperateLogHelper.Edit <tblUser_Sys>(collection, old);
var list = BusinessContext.tblUser_Roles.GetModelList("LoginName='" + collection.LoginName + "'").Where(p => p.Role_Id == collection.DefaultRoleId).ToList();
if (list != null && list.Count > 0)
{
tblUser_Roles role = list[0];
role.IsDefault = true;
role.Role_Id = collection.DefaultRoleId;
tblUser_Roles old_Roles = BusinessContext.tblUser_Roles.GetModel(role.TblRcdId);
BusinessContext.tblUser_Roles.Update(role);
OperateLogHelper.Edit <tblUser_Roles>(role, old_Roles);
}
else
{
tblUser_Roles role = new tblUser_Roles();
role.IsDefault = true;
role.LoginName = collection.LoginName;
role.Role_Id = collection.DefaultRoleId;
BusinessContext.tblUser_Roles.Add(role);
OperateLogHelper.Create <tblUser_Roles>(role);
}
}
}
}
catch (Exception ex)
{
RM.Message = ex.Message;
}
}
return(Json(RM));
}
public ActionResult Create(tblUser_Sys collection, string IsContinue = "0")
{
ReturnMessage RM = new ReturnMessage(false);
try
{
if (collection.UserPwd == "" || string.IsNullOrEmpty(collection.UserPwd))
{
//默认密码MD5加密
collection.UserPwd = Md5.Encode("123456");
}
//根据登录名称查询是否已经存在,
var query =
BusinessContext.tblUser_Sys.Get(Query <tblUser_Sys> .EQ(t => t.LoginName, collection.LoginName));
if (query != null)
{
RM.Message = "登录名已被占用";
}
else
{
//添加用户,并返回数据库ID,保存操作日志
var res = BusinessContext.tblUser_Sys.Add(collection);
RM.IsSuccess = res;
if (RM.IsSuccess)
{
//collection.Rid = Rid;
tblUser_Roles tblUser_Roles = new tblUser_Roles();
tblUser_Roles.Role_Id = collection.DefaultRoleId;
tblUser_Roles.LoginName = collection.LoginName;
tblUser_Roles.IsDefault = true;
BusinessContext.tblUser_Roles.Add(tblUser_Roles);
OperateLogHelper.Create <tblUser_Roles>(tblUser_Roles);
OperateLogHelper.Create <tblUser_Sys>(collection);
//IsContinue 为1时保存并继续
RM.IsContinue = IsContinue == "1";
}
}
}
catch (Exception ex)
{
RM.Message = ex.Message;
}
return(Json(RM));
}
internal static void Edit <T1>(tblUser_Sys collection, tblUser_Roles old)
{
throw new NotImplementedException();
}
