public void ModifyPassword(TS_OPERATOR oper)
{
PowerEntities db = EntitiesFactory.CreatePowerInstance();
OperController.AddOrModify(db, oper);
EntitiesFactory.SaveDb(db);
}
public static List <VS_POWER_MENU> GetPowerMenuList(PowerEntities db, string portalCode, string operCode)
{
var returnList = new List <VS_POWER_MENU>();
var roles = db.TS_OPER_ROLE.Where(p => p.OperCode == operCode && p.IsBeloneTo);
foreach (var role in roles)
{
var list = db.VS_POWER_MENU.Where(p => p.RoleCode == role.RoleCode && p.PortalCode == portalCode);
foreach (var menu in list)
{
var existMenu = returnList.SingleOrDefault(p => p.MenuCode == menu.MenuCode);
if (existMenu != null)
{
if (menu.IsVisible)
{
existMenu.IsVisible = true;
}
if (!menu.IsReadOnly)
{
existMenu.IsReadOnly = false;
}
}
else
{
returnList.Add(menu);
}
}
}
return(returnList);
}
private void btnLogin_Click(object sender, EventArgs e)
{
try
{
if (txtOperCode.Text == "")
{
MessageHelper.ShowError("请输入人员编号！");
txtOperCode.Focus();
return;
}
string operCode = txtOperCode.Text;
string password = EncryptHelper.Encrypt(txtPassword.Text);
using (PowerEntities db = EntitiesFactory.CreatePowerInstance())
{
var oper = OperController.CheckUser(db, operCode, password);
if (oper == null)
{
MessageHelper.ShowError("错误的用户名或密码，登录失败！");
txtOperCode.Focus();
txtOperCode.SelectAll();
}
else
{
this.DialogResult = DialogResult.OK;
GlobalVar.InitGlobalVar(db, oper);
}
}
}
catch (Exception ex)
{
MessageHelper.ShowError(ex);
}
}
public static List <TS_ROLE_NOTIFYTYPE> GetNotiFyTypeList(PowerEntities db, string portalCode, string operCode)
{
var returnList = new List <TS_ROLE_NOTIFYTYPE>();
var roles = db.TS_OPER_ROLE.Where(p => p.OperCode == operCode);
foreach (var role in roles)
{
var list = db.TS_ROLE_NOTIFYTYPE.Where(p => p.RoleCode == role.RoleCode && p.PortalCode == portalCode);
foreach (var item in list)
{
var exitItem = returnList.SingleOrDefault(p => p.NotifyType == item.NotifyType);
if (exitItem == null)
{
returnList.Add(item);
}
else
{
if (item.IsVisible)
{
exitItem.IsVisible = item.IsVisible;
}
}
}
}
return(returnList);
}
public static IList <TL_BASEDATA> GetList(PowerEntities db, DateTime beginTime, DateTime endTime)
{
var list = db.TL_BASEDATA.Where(p =>
p.LogTime >= beginTime &&
p.LogTime <= endTime
).OrderByDescending(p => p.UID).ToList();
return(list);
}
public TS_OPERATOR Login(string operCode, string password)
{
PowerEntities db = EntitiesFactory.CreatePowerInstance();
var oper = OperController.Login(db, operCode, password);
// if (oper != null) oper.State = LoginState.Online.ToString();
EntitiesFactory.SaveDb(db);
return(oper);
}
public static void InitGlobalVar(PowerEntities db, TS_OPERATOR oper)
{
Oper = oper;
DataStateStringList = Enum.GetNames(typeof(DataState)).ToList();
DeptList = DeptController.GetList(db);
RoleList = RoleController.GetList(db);
MenuList = MenuController.GetList(db);
PortalList = PortalControler.GetList(db);
OperList = OperController.GetList(db);
OperRoleList = OperRoleController.GetList(db);
}
public static void AddOrUpdate(PowerEntities db, TS_OPERATOR selectedData, TS_OPERATOR oper)
{
try
{
db.TS_OPERATOR.AddOrUpdate(p => p.OperCode, selectedData);
}
catch (DbEntityValidationException dbEx)
{
Console.WriteLine(dbEx.ToString());
throw;
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
try
{
if (txtOperCode.Text == "")
{
MessageHelper.ShowError("请输入人员编号！");
txtOperCode.Focus();
return;
}
TS_OPERATOR oper = new TS_OPERATOR();
string operCode = txtOperCode.Text;
string password = EncryptHelper.Encrypt(txtPassword.Text);
using (PowerEntities powerdb = EntitiesFactory.CreatePowerInstance())
{
oper = OperController.Login(powerdb, operCode, password);
if (oper == null)
{
MessageHelper.ShowError("错误的用户名或密码，登录失败！");
txtOperCode.Focus();
txtOperCode.SelectAll();
return;
}
this.DialogResult = DialogResult.OK;
//EntitiesFactory.SaveDb(powerdb);
GlobalVar.Oper = oper;
GlobalVar.PowerMenuList = PowerController.GetPowerMenuList(powerdb, GlobalVar.PortalCode,
oper.OperCode);
GlobalVar.NotifytypeList = PowerController.GetNotiFyTypeList(powerdb, GlobalVar.PortalCode,
oper.OperCode);
GlobalBuffer.FactoryCode = GlobalVar.Oper.DeptCode;
}
using (SpareEntities wmsdb = EntitiesFactory.CreateSpareInstance())
{
OperLogController.AddLog(wmsdb, LogType.Login, oper.OperName, operCode, "登录成功");
EntitiesFactory.SaveDb(wmsdb);
GlobalVar.InitGlobalVar(wmsdb, GlobalVar.Oper);
}
}
catch (WmsException ex)
{
MessageHelper.ShowInfo(ex.ToString());
}
catch (Exception ex)
{
var inner = ex.InnerException;
MessageHelper.ShowError((string.IsNullOrEmpty(inner?.Message)) ? ex : inner);
}
}
private void btnModify_Click(object sender, EventArgs e)
{
if (txtOldPwd.Text.Trim() == string.Empty)
{
MessageHelper.ShowInfo("原密码不能为空");
return;
}
if (txtNewPwd.Text.Trim() == string.Empty)
{
MessageHelper.ShowInfo("新密码不能为空");
return;
}
if (txtNewPwd.Text.Length < 6 || txtNewPwd.Text.Length > 20)
{
MessageHelper.ShowInfo("新密码长度应该在6到20位之间");
return;
}
if (txtNewPwd.Text != txtNewPwd2.Text)
{
MessageHelper.ShowInfo("两次输入的新密码不一致，请重新输入");
return;
}
string enOldPwd = EncryptHelper.Encrypt(txtOldPwd.Text);
if (enOldPwd != GlobalVar.Oper.OperPassword)
{
MessageHelper.ShowInfo("原密码输入错误");
return;
}
if (enOldPwd == txtNewPwd.Text)
{
MessageHelper.ShowInfo("新密码不能与原密码相同");
return;
}
string enNewPwd = EncryptHelper.Encrypt(txtNewPwd.Text);
GlobalVar.Oper.OperPassword = enNewPwd;
using (PowerEntities db = EntitiesFactory.CreatePowerInstance())
{
var oper_B = new TS_OPERATOR();
oper_B.OperCode = GlobalVar.Oper.OperCode;
oper_B.OperName = GlobalVar.Oper.OperName;
oper_B.OperPassword = GlobalVar.Oper.OperPassword;
OperController.AddOrModify(db, oper_B);
MessageHelper.ShowInfo("密码修改成功");
EntitiesFactory.SaveDb(db);
}
Close();
}
public static void AddOrModify(PowerEntities db, TS_OPERATOR oper)
{
db.TS_OPERATOR.AddOrUpdate(p => p.OperCode, oper);
// var op = db.TS_OPERATOR.SingleOrDefault(p => p.UID == oper.UID);
// if (op == null)
// db.TS_OPERATOR.CreateStockMove(oper);
// else
// {
// op.Name = oper.OperName;
// op.Password = oper.Password;
// op.Dept = oper.Dept;
// op.Role = oper.Role;
// op.State = oper.State;
// }
}
public static TL_BASEDATA Add(PowerEntities db, string dataType, string oldValue, string newValue, string operName, OperateType operateType)
{
var log = new TL_BASEDATA
{
OperName = operName,
LogTime = DateTime.Now,
LogType = operateType.ToString(),
DataType = dataType,
OldValue = oldValue,
NewValue = newValue,
};
db.TL_BASEDATA.Add(log);
return(log);
}
private void SetDetailGridDataSource(PowerEntities db, string roleCode)
{
var powerList = db.VS_POWER_MENU.AsNoTracking().Where(p => p.RoleCode == roleCode).ToList();
foreach (TA_MENU menu in _menuList)
{
var power =
powerList.SingleOrDefault(p => p.PortalCode == menu.PortalCode && p.MenuCode == menu.MenuCode);
if (power == null)
{
power = new VS_POWER_MENU
{
RoleCode = roleCode,
PortalCode = menu.PortalCode,
ParentCode = menu.ParentCode,
MenuCode = menu.MenuCode,
MenuText = menu.MenuText,
ControlType = menu.ControlType,
IsVisible = false,
IsReadOnly = false,
};
powerList.Add(power);
}
}
powerList = powerList.OrderBy(p => p.PortalCode).ThenBy(p => p.MenuCode).ToList();
gridDetail.PrimaryGrid.DataSource = new BindingList <VS_POWER_MENU>(powerList);
var list = db.TS_ROLE_NOTIFYTYPE.AsNoTracking().Where(p => p.RoleCode == roleCode).ToList();
foreach (var item in _notifyTypeList)
{
var power = list.SingleOrDefault(p => p.NotifyType == item.Value);
if (power == null)
{
power = new TS_ROLE_NOTIFYTYPE
{
RoleCode = roleCode,
PortalCode = "",
NotifyType = item.Value,
IsVisible = false,
};
list.Add(power);
}
}
gridNotifyType.PrimaryGrid.DataSource = new BindingList <TS_ROLE_NOTIFYTYPE>(list);
}
private void SetDetailGridDataSource(PowerEntities db, string operCode)
{
var operRoles = db.VS_OPER_ROLE.AsNoTracking().Where(p => p.OperCode == operCode).ToList();
foreach (TS_ROLE role in _roleList)
{
var operRole =
operRoles.SingleOrDefault(p => p.RoleCode == role.RoleCode);
if (operRole == null)
{
operRole = new VS_OPER_ROLE
{
OperCode = operCode,
RoleCode = role.RoleCode,
RoleName = role.RoleName,
Remark = role.Remark,
IsBeloneTo = false,
};
operRoles.Add(operRole);
}
}
operRoles = operRoles.OrderBy(p => p.RoleCode).ToList();
gridRole.PrimaryGrid.DataSource = new BindingList <VS_OPER_ROLE>(operRoles);
}
public static void Logout(PowerEntities db, string operName)
{
throw new NotImplementedException();
}
public static TS_OPERATOR CheckUser(PowerEntities db, string code, string password)
{
var oper = db.TS_OPERATOR.SingleOrDefault(p => p.OperCode == code && p.OperPassword == password);
return(oper);
}
public static void RemoveLocal(PowerEntities db, TL_BASEDATA log)
{
db.TL_BASEDATA.Local.Remove(log);
}
public static void InitGlobalVar(PowerEntities db)
{
InitGlobalVar(db, Oper);
}
public static List <TS_OPERATOR> GetList(PowerEntities db)
{
return(db.TS_OPERATOR.OrderBy(p => p.OperCode).ToList());
}
public static List <TS_DEPT> GetList(PowerEntities db)
{
return(db.TS_DEPT.OrderBy(p => p.DeptCode).ToList());
}
public static void Delete(PowerEntities db, TS_OPERATOR data, TS_OPERATOR oper)
{
db.Entry(data).State = EntityState.Deleted;
}
public static List <TA_MENU> GetList(PowerEntities db)
{
return(db.TA_MENU.OrderBy(p => p.MenuCode).ToList());
}
public static List <TS_ROLE> GetList(PowerEntities db)
{
return(db.TS_ROLE.OrderBy(p => p.RoleCode).ToList());
}
public static List <TS_PORTAL> GetList(PowerEntities db)
{
return(db.TS_PORTAL.OrderBy(p => p.PortalCode).ToList());
}
