/// <summary>
/// 查询用户分页列表
/// </summary>
/// <returns></returns>
public ActionResult GetList()
{
int pageIndex = WebUtil.GetFormValue <int>("pageIndex", 1);
int pageSize = WebUtil.GetFormValue <int>("pageSize", 10);
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 CompanyID = WebUtil.GetFormValue <string>("CompanyID", string.Empty);
PageInfo pageInfo = new PageInfo()
{
PageIndex = pageIndex, PageSize = pageSize
};
AdminProvider provider = new AdminProvider(CompanyID);
AdminEntity entity = new AdminEntity();
entity.UserCode = UserCode;
entity.UserName = UserName;
entity.RoleNum = RoleNum;
entity.DepartNum = DepartNum;
entity.CompanyID = CompanyID;
List <AdminEntity> listResult = provider.GetList(entity, ref pageInfo);
DataListResult <AdminEntity> result = new DataListResult <AdminEntity>()
{
Code = (int)EResponseCode.Success, PageInfo = pageInfo, Result = listResult, Message = "响应成功"
};
return(Content(JsonHelper.SerializeObject(result)));
}
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()));
}
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()));
}
