private IdentityModel ConvertUser(MD.tbl_Common_User user)
{
if (user == null)
{
return(null);
}
var result = new IdentityModel();
var roleUser = user.tbl_Common_RoleUser.FirstOrDefault();
int roleId = roleUser == null ? 0 : roleUser.RoleId.Value;
var role = ctx.Role.Where(r => r.RoleId == roleId).FirstOrDefault();
result.Id = user.UserId.ToString();
result.LogonName = user.LogonName;
result.RoleId = roleId;
result.RoleName = role == null ? "" : role.Name;
result.RoleSelectList =
(from m in ctx.ModulePermissionDefine
join pi in ctx.RolePermissionConfig.DefaultIfEmpty() on m.ModuleId equals pi.ModuleId into inner
from p in inner.DefaultIfEmpty()
where (p.RoleId == roleId || p.RoleId == null)
select new RolePermission
{
Action = string.IsNullOrEmpty(m.Action) ? "index" : m.Action,
Area = m.Area ?? string.Empty,
Controller = m.Controller ?? string.Empty,
ModuleId = m.ModuleId,
IsAvailable = (m.Value & p.Value) == m.Value ? true : false
}).ToList();
MD.tbl_Common_UserOfGasStation userGas = ctx.UserOfGasStation.Where(m => m.UserId == user.UserId).FirstOrDefault();
return(result);
}
public bool UpdatePasswordDb(VM.UserInfoItem model)
{
MD.tbl_Common_User date = Ctx.tbl_Common_User.Where(c => c.UserId == model.UserId).FirstOrDefault();
date.Password = model.Password;
date.UpdatedBy = model.UpdatedBy;
date.UpdatedDate = DateTime.Now;
Ctx.SaveChanges();
return(true);
}
public bool UpdatePassword(IdentityModel model)
{
MD.tbl_Common_User date = Ctx.tbl_Common_User.Where(c => c.UserId.ToString() == model.Id).FirstOrDefault();
date.Password = model.PasswordHash;
date.UpdatedBy = model.UpdateBy;
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 bool UserUpdate(VM.UserInfoItem model)
{
MD.tbl_Common_User date = Ctx.tbl_Common_User.First(u => u.UserId == model.UserId);
date.UserName = model.UserName;
date.EmailAddress = model.EmailAddress;
date.UpdatedBy = model.UpdatedBy;
date.UpdatedDate = DateTime.Now;
Ctx.SaveChanges();
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 ResetPassword(string name, string emailTo)
{
MD.tbl_Common_User date = Ctx.tbl_Common_User.First(u => u.LogonName == name);
IPasswordPolicy Password = new RandomPassword();
string orginalPassword = Password.GeneratePassword();
date.Password = HashEncrypt.SHA512Encrypt(orginalPassword);
date.UpdatedBy = null;
date.UpdatedDate = null;
Ctx.SaveChanges();
//发送邮件
SendEmail(date, orginalPassword, "User_ResetPassword", emailTo);
return(true);
}
private void SendEmail(MD.tbl_Common_User model, string password, string emailTemplateName, string emailTo)
{
bool isSendEmailtoIIS = false;
var sendEmailInfo = new SendEmailInfo();
var email = Ctx.tbl_EmailTemplate.FirstOrDefault(t => t.Name == emailTemplateName);
string[] emailSendTo = { emailTo };
string url = string.Format("{0}/", EmailTemplateParam.GetHostName());
sendEmailInfo.mailSubject = email.EmailSubject.Replace(EmailTemplateParam.SystemName, EmailTemplateParam.SystemNameBasic);
sendEmailInfo.mailBody = email.EmailContent.Replace(EmailTemplateParam.UserDisplayName, model.UserName)
.Replace(EmailTemplateParam.URL, url)
.Replace(EmailTemplateParam.UserName, model.LogonName)
.Replace(EmailTemplateParam.Password, password)
.Replace("[DateTime]", DateTime.Now.ToString("yyyy年MM月dd日"));
//MailHelper.SendMail(emailSendTo, sendEmailInfo.mailSubject, sendEmailInfo.mailBody, 0, isSendEmailtoIIS, true);
}
public bool ResetPassword(int id, string userName)
{
MD.tbl_Common_User date = Ctx.tbl_Common_User.First(u => u.UserId == id);
if (date.Status == 1)
{
IPasswordPolicy Password = new RandomPassword();
string orginalPassword = Password.GeneratePassword();
date.Password = HashEncrypt.SHA512Encrypt(orginalPassword);
date.UpdatedBy = userName;
date.UpdatedDate = DateTime.Now;
Ctx.SaveChanges();
//发送邮件
//SendEmail(date, orginalPassword, "User_ResetPassword");
return(true);
}
else
{
return(false);
}
}
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);
}