public static Admin_CE ToCE(AdminEntity item)
{
Admin_CE target = new Admin_CE();
target.ID=item.ID;
target.UserName=item.UserName;
target.PassWord=item.PassWord;
target.UserCode=item.UserCode;
target.RealName=item.RealName;
target.Email=item.Email;
target.Mobile=item.Mobile;
target.Phone=item.Phone;
target.CreateTime=item.CreateTime;
target.CreateIp=item.CreateIp;
target.CreateUser=item.CreateUser;
target.LoginCount=item.LoginCount;
target.Picture=item.Picture;
target.UpdateTime=item.UpdateTime;
target.IsDelete=item.IsDelete;
target.Status=item.Status;
target.DepartNum=item.DepartNum;
target.ParentCode=item.ParentCode;
target.RoleNum=item.RoleNum;
target.Remark=item.Remark;
return target;
}
/// <summary>
/// 删除
/// </summary>
/// <param name="userCode"></param>
/// <returns></returns>
public int Delete(string userCode)
{
AdminEntity entity = new AdminEntity();
entity.IsDelete = (int)EIsDelete.Deleted;
entity.IncludeIsDelete(true);
entity.Where(a => a.UserCode == userCode);
int line = this.Admin.Update(entity);
return line;
}
/// <summary>
/// 添加用户
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public int AddAdmin(AdminEntity entity)
{
entity.IsDelete = (int)EIsDelete.NotDelete;
entity.CreateTime = DateTime.Now;
entity.ParentCode = "";
entity.IncludeAll();
int line = this.Admin.Add(entity);
return line;
}
/// <summary>
/// 台帐报表
/// </summary>
/// <param name="entity"></param>
/// <param name="pageInfo"></param>
/// <returns></returns>
public List<InventoryBookEntity> GetList(InventoryBookEntity entity, ref PageInfo pageInfo)
{
entity.IncludeAll();
entity.OrderBy(a => a.ProductNum, EOrderBy.ASC);
AdminEntity adminEntity = new AdminEntity();
adminEntity.Include(a => new { UserName = a.UserName });
entity.Left<AdminEntity>(adminEntity, new Params<string, string>() { Item1 = "CreateUser", Item2 = "UserCode" });
int rowCount = 0;
List<InventoryBookEntity> listResult = this.InventoryBook.GetList(entity, pageInfo.PageSize, pageInfo.PageIndex, out rowCount);
pageInfo.RowCount = rowCount;
return listResult;
}
/// <summary>
/// 根据用户编号获得用户信息
/// </summary>
/// <param name="userCode"></param>
/// <returns></returns>
public AdminEntity GetAdmin(string userCode)
{
AdminEntity entity = new AdminEntity();
entity.Include(a => new { a.ID, a.UserCode, a.UserName, a.PassWord, a.Email, a.Phone, a.Mobile, a.RealName, a.RoleNum, a.DepartNum });
entity.Where(a => a.UserCode == userCode);
entity = this.Admin.GetSingle(entity);
return entity;
}
/// <summary>
/// 修改密码
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public int UpdatePwd(AdminEntity entity)
{
entity.Include(a => a.PassWord);
entity.Where(a => a.UserCode == entity.UserCode);
int line = this.Admin.Update(entity);
return line;
}
/// <summary>
/// 修改员工登录次数
/// </summary>
/// <param name="userName"></param>
/// <param name="passWord"></param>
/// <param name="loginCount"></param>
/// <returns></returns>
public int UpdateLoginCount(string userName, string passWord, int loginCount)
{
AdminEntity countEntity = new AdminEntity() { UserName = userName, PassWord = passWord };
countEntity.IncludeLoginCount(true);
countEntity.LoginCount = loginCount + 1;
countEntity.Where<AdminEntity>("UserName", ECondition.Eth).And<AdminEntity>("PassWord", ECondition.Eth);
int line = this.Admin.Update(countEntity);
return line;
}
/// <summary>
/// 修改
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public int Update(AdminEntity entity)
{
entity.Include(a => new { a.Phone, a.Email, a.Mobile, a.RealName, a.RoleNum, a.DepartNum, a.UserName, a.PassWord, a.UpdateTime });
entity.Where(a => a.UserCode == entity.UserCode);
int line = this.Admin.Update(entity);
return line;
}
/// <summary>
/// 登录
/// </summary>
/// <param name="userName"></param>
/// <param name="passWord"></param>
/// <returns></returns>
public AdminEntity Login(string userName, string passWord)
{
AdminEntity entity = new AdminEntity();
entity.IncludeAll();
entity.Where(a => a.UserName == userName).And(a => a.PassWord == passWord);
SysRoleEntity roleEntity = new SysRoleEntity();
roleEntity.Include("RoleName", "RoleName");
entity.Left<SysRoleEntity>(roleEntity, new Params<string, string>() { Item1 = "RoleNum", Item2 = "RoleNum" });
entity = this.Admin.GetSingle(entity);
if (entity != null)
{
AdminEntity admin = new AdminEntity();
admin.LoginCount = admin.LoginCount + 1;
admin.IncludeLoginCount(true);
admin.Where(a => a.UserCode == entity.UserCode);
this.Admin.Update(admin);
}
return entity;
}
/// <summary>
/// 检查用户名是否存在
/// </summary>
/// <param name="userName"></param>
/// <returns></returns>
public bool IsExist(string userName)
{
AdminEntity entity = new AdminEntity();
entity.Include(a => new { a.ID, a.UserCode, a.UserName, a.PassWord, a.Email, a.Phone, a.Mobile, a.RealName, a.RoleNum, a.DepartNum });
entity.Where(a => a.UserName == userName).And(a => a.IsDelete == (int)EIsDelete.NotDelete);
entity = this.Admin.GetSingle(entity);
if (entity.IsNotNull())
{
return true;
}
return false;
}
/// <summary>
/// 查询用户管理员分页
/// </summary>
/// <param name="entity"></param>
/// <param name="pageInfo"></param>
/// <returns></returns>
public List<AdminEntity> GetList(AdminEntity entity, ref PageInfo pageInfo)
{
entity.IncludeAll();
entity.OrderBy(a => a.ID, EOrderBy.DESC);
entity.Where(a => a.IsDelete == (int)EIsDelete.NotDelete);
SysRoleEntity roleEntity = new SysRoleEntity();
roleEntity.Include("RoleName", "RoleName");
entity.Left<SysRoleEntity>(roleEntity, new Params<string, string>() { Item1 = "RoleNum", Item2 = "RoleNum" });
SysDepartEntity departEntity = new SysDepartEntity();
departEntity.Include("DepartName", "DepartName");
entity.Left<SysDepartEntity>(departEntity, new Params<string, string>() { Item1 = "DepartNum", Item2 = "DepartNum" });
int rowCount = 0;
List<AdminEntity> listResult = this.Admin.GetList(entity, pageInfo.PageSize, pageInfo.PageIndex, out rowCount);
pageInfo.RowCount = rowCount;
return listResult;
}
public ActionResult ToExcel()
{
PageInfo pageInfo = new Git.Framework.DataTypes.PageInfo() { PageIndex = 1, PageSize = Int32.MaxValue };
string userCode = WebUtil.GetFormValue<string>("userCode", string.Empty);
string userName = WebUtil.GetFormValue<string>("userName", string.Empty);
string roleNum = WebUtil.GetFormValue<string>("roleNum", string.Empty);
string departNum = WebUtil.GetFormValue<string>("departNum", string.Empty);
AdminProvider provider = new AdminProvider();
AdminEntity entity = new AdminEntity();
if (!userCode.IsEmpty())
{
entity.Where("UserCode", ECondition.Like, userCode + "%");
}
if (!userName.IsEmpty())
{
entity.Where("UserName", ECondition.Like, userName + "%");
}
if (!roleNum.IsEmpty())
{
entity.And(a => a.RoleNum == roleNum);
}
if (!departNum.IsEmpty())
{
entity.And(a => a.DepartNum == departNum);
}
List<AdminEntity> listResult = provider.GetList(entity, ref pageInfo);
if (!listResult.IsNullOrEmpty())
{
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("用户名"));
dt.Columns.Add(new DataColumn("编号"));
dt.Columns.Add(new DataColumn("真名"));
dt.Columns.Add(new DataColumn("Email"));
dt.Columns.Add(new DataColumn("联系方式"));
dt.Columns.Add(new DataColumn("登录次数"));
dt.Columns.Add(new DataColumn("部门"));
dt.Columns.Add(new DataColumn("角色"));
foreach (AdminEntity t in listResult)
{
DataRow row = dt.NewRow();
row[0] = t.UserName;
row[1] = t.UserCode;
row[2] = t.RealName;
row[3] = t.Email;
row[4] = t.Mobile;
row[5] = t.LoginCount;
row[6] = t.DepartName;
row[7] = t.RoleName;
dt.Rows.Add(row);
}
string filePath = Server.MapPath("~/UploadFiles/");
if (!System.IO.Directory.Exists(filePath))
{
System.IO.Directory.CreateDirectory(filePath);
}
string filename = string.Format("员工管理{0}.xls", DateTime.Now.ToString("yyyyMMddHHmmss"));
NPOIExcel excel = new NPOIExcel("员工管理", "员工", System.IO.Path.Combine(filePath, filename));
excel.ToExcel(dt);
this.ReturnJson.AddProperty("Path", ("/UploadFiles/" + filename).Escape());
}
else
{
this.ReturnJson.AddProperty("d", "无数据导出!");
}
return Content(this.ReturnJson.ToString());
}
public ActionResult GetAdminList()
{
int pageIndex = WebUtil.GetFormValue<int>("pageIndex", 1);
int pageSize = WebUtil.GetFormValue<int>("pageSize", 15);
string userCode = WebUtil.GetFormValue<string>("userCode", string.Empty);
string userName = WebUtil.GetFormValue<string>("userName", string.Empty);
string roleNum = WebUtil.GetFormValue<string>("roleNum", string.Empty);
string departNum = WebUtil.GetFormValue<string>("departNum", string.Empty);
string search = WebUtil.GetFormValue<string>("search", string.Empty);
PageInfo pageInfo = new PageInfo() { PageIndex = pageIndex, PageSize = pageSize };
AdminProvider provider = new AdminProvider();
AdminEntity entity = new AdminEntity();
if (!search.IsEmpty())
{
entity.Where("UserCode", ECondition.Like, "%" + search + "%");
entity.Or("RealName", ECondition.Like, "%" + search + "%");
entity.Or("UserName", ECondition.Like, "%" + search + "%");
}
else
{
if (!userCode.IsEmpty())
{
entity.Where("UserCode", ECondition.Like, "%" + userCode + "%");
entity.Or("RealName", ECondition.Like, "%" + userCode + "%");
}
if (!userName.IsEmpty())
{
entity.Where("UserName", ECondition.Like, "%" + userName + "%");
}
if (!roleNum.IsEmpty())
{
entity.And(a => a.RoleNum == roleNum);
}
if (!departNum.IsEmpty())
{
entity.And(a => a.DepartNum == departNum);
}
}
List<AdminEntity> listResult = provider.GetList(entity, ref pageInfo);
string json = ConvertJson.ListToJson<AdminEntity>(listResult, "List");
this.ReturnJson.AddProperty("Data", new JsonObject(json));
this.ReturnJson.AddProperty("RowCount", pageInfo.RowCount);
return Content(this.ReturnJson.ToString());
}
