public bool UpdateUserRole(string allSelectList, int currRoleId, string deleteUserIds, string logonName)
{
if (allSelectList != null)
{
string[] selectId = allSelectList.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
for (int i = 0; i < selectId.Length; i++)
{
if (selectId[i] != "")
{
int num = Convert.ToInt32(selectId[i].ToString().Trim());
if (Ctx.tbl_Common_RoleUser.Where(m => m.UserId == num).Count() == 0)
{
MD.tbl_Common_RoleUser roleUser = new MD.tbl_Common_RoleUser();
roleUser.UserId = num;
roleUser.RoleId = currRoleId;
roleUser.CreatedDate = DateTime.Now;
roleUser.CreatedBy = logonName;
Ctx.tbl_Common_RoleUser.Add(roleUser);
Ctx.SaveChanges();
}
else
{
MD.tbl_Common_RoleUser date = Ctx.tbl_Common_RoleUser.First(u => u.UserId == num);
date.RoleId = currRoleId;
date.IsDeleted = false;
date.UpdatedBy = logonName;
date.UpdatedDate = DateTime.Now;
Ctx.SaveChanges();
}
}
}
}
if (deleteUserIds != null)
{
string[] delectId = deleteUserIds.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
for (int i = 0; i < delectId.Length; i++)
{
if (delectId[i] != "")
{
int num = Convert.ToInt32(delectId[i].ToString().Trim());
MD.tbl_Common_RoleUser date = Ctx.tbl_Common_RoleUser.First(u => u.UserId == num);
date.RoleId = null;
date.IsDeleted = true;
date.UpdatedBy = logonName;
date.UpdatedDate = DateTime.Now;
Ctx.SaveChanges();
}
}
}
return(true);
}
public bool Update(VM.UserInfoItem model)
{
MD.tbl_Common_User date = Ctx.tbl_Common_User.First(u => u.UserId == model.UserId);
date.UserName = model.UserName;
date.LogonName = model.LogonName;
if (model.StrStatus.ToString() == UserStatus.Normal.strValue)
{
date.Status = UserStatus.Normal.intValue;
}
else
{
date.Status = UserStatus.Disable.intValue;
}
date.DomainAccount = model.DomainAccount;
date.EmailAddress = model.EmailAddress;
date.UpdatedBy = model.UpdatedBy;
date.UpdatedDate = DateTime.Now;
//Ctx.SaveChanges();
//修改公司关系
updateUserOfCompany(date.UserId, model.UserCompanyValue, model.UpdatedBy);
//UpdateUserCompany(model.UserCompanyValue, date.UserId, model.UpdatedBy);
Ctx.SaveChanges();
//修改 角色
if (Ctx.tbl_Common_RoleUser.Where(m => m.UserId == model.UserId).Count() == 0)
{
MD.tbl_Common_RoleUser roleUser = new MD.tbl_Common_RoleUser();
roleUser.RoleId = model.RoleId.Value;
roleUser.UserId = date.UserId;
roleUser.CreatedDate = DateTime.Now;
roleUser.CreatedBy = model.UpdatedBy;
//roleUser.UpdatedDate = DateTime.Now;
//roleUser.UpdatedBy = model.UpdatedBy;
Ctx.tbl_Common_RoleUser.Add(roleUser);
Ctx.SaveChanges();
}
else
{
MD.tbl_Common_RoleUser roleUser = Ctx.tbl_Common_RoleUser.First(m => m.UserId == model.UserId);
roleUser.RoleId = model.RoleId.Value;
roleUser.IsDeleted = false;
roleUser.UpdatedDate = DateTime.Now;
roleUser.UpdatedBy = model.UpdatedBy;
Ctx.SaveChanges();
}
updateUserOfGasStation(date.UserId, model.UserGasStationValue, model.UpdatedBy);
return(true);
}
//public List<SelectListItem> GetAllGasStationSelectList()
//{
// var allGasStation = (from gasStation in Ctx.tbl_Gs_GasStationInfo
// where gasStation.IsDelete != true
// select new SelectListItem
// {
// Text = gasStation.Name,
// Value = gasStation.GasStationId.ToString(),
// Selected = true
// });
// return allGasStation.ToList();
//}
public bool Create(VM.UserInfoItem model)
{
MD.tbl_Common_User date = new MD.tbl_Common_User();
date.UserName = model.UserName;
date.LogonName = model.LogonName;
//model.StatusList.First().
if (model.StrStatus.ToString() == UserStatus.Normal.strValue)
{
date.Status = UserStatus.Normal.intValue;
}
else
{
date.Status = UserStatus.Disable.intValue;
}
date.DomainAccount = model.DomainAccount;
date.EmailAddress = model.EmailAddress;
date.CreatedDate = DateTime.Now;
date.CreatedBy = model.CreatedBy;
date.UpdatedDate = DateTime.Now;
date.UpdatedBy = model.UpdatedBy;
//生成密码
//IPasswordPolicy Password = new RandomPassword();
//string orginalPassword = Password.GeneratePassword();
//date.Password = HashEncrypt.SHA512Encrypt(orginalPassword);
date.Password = model.Password;
Ctx.tbl_Common_User.Add(date);
//生成角色关系
MD.tbl_Common_RoleUser roleUser = new MD.tbl_Common_RoleUser();
roleUser.RoleId = model.RoleId.Value;
roleUser.UserId = date.UserId;
roleUser.CreatedDate = DateTime.Now;
roleUser.CreatedBy = model.CreatedBy;
//roleUser.UpdatedDate = DateTime.Now;
//roleUser.UpdatedBy = model.UpdatedBy;
Ctx.tbl_Common_RoleUser.Add(roleUser);
Ctx.SaveChanges();
//生成公司关系
updateUserOfCompany(roleUser.UserId, model.UserCompanyValue, model.CreatedBy);
//生成 气站关系
// updateUserOfGasStation(roleUser.UserId, model.UserGasStationValue, model.CreatedBy);
//发送邮件
//if(date.Status==1)
// SendEmail(date, orginalPassword, "User_New");
return(true);
}
public bool Delete(int id, string userName)
{
MD.tbl_Common_User date = Ctx.tbl_Common_User.First(u => u.UserId == id);
date.IsDeleted = true;
date.UpdatedBy = userName;
date.UpdatedDate = DateTime.Now;
Ctx.SaveChanges();
MD.tbl_Common_RoleUser roleUser = Ctx.tbl_Common_RoleUser.First(u => u.UserId == id);
roleUser.IsDeleted = true;
roleUser.UpdatedBy = userName;
roleUser.UpdatedDate = DateTime.Now;
Ctx.SaveChanges();
var userOfGasItem = Ctx.tbl_Common_UserOfGasStation.Where(u => u.IsDeleted != true && u.UserId == id);
foreach (var userOfGas in userOfGasItem)
{
userOfGas.IsDeleted = true;
userOfGas.UpdatedBy = userName;
userOfGas.UpdatedDate = DateTime.Now;
}
Ctx.SaveChanges();
var userOfCompanyItem = Ctx.tbl_Common_UserOfCompany.Where(u => u.IsDeleted != true && u.UserId == id);
foreach (var userOfCompany in userOfCompanyItem)
{
userOfCompany.IsDeleted = true;
userOfCompany.UpdatedBy = userName;
userOfCompany.UpdatedDate = DateTime.Now;
}
Ctx.SaveChanges();
return(true);
}
