/// <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 AddUser([ModelBinder(typeof(JsonBinder <AdminEntity>))] AdminEntity entity)
{
AdminProvider provider = new AdminProvider();
entity.UpdateTime = DateTime.Now;
int line = 0;
if (entity.UserCode.IsEmpty())
{
bool isExist = provider.IsExist(entity.UserName);
if (isExist)
{
this.ReturnJson.AddProperty("d", "该用户名已经存在！");
return(Content(this.ReturnJson.ToString()));
}
entity.UserCode = SequenceProvider.GetSequence(typeof(AdminEntity));
line = provider.AddAdmin(entity);
}
else
{
line = provider.Update(entity);
}
if (line > 0)
{
this.ReturnJson.AddProperty("d", "success");
}
else
{
this.ReturnJson.AddProperty("d", "");
}
return(Content(this.ReturnJson.ToString()));
}
/// <summary>
/// 编辑用户
/// </summary>
/// <returns></returns>
public ActionResult Edit()
{
DataResult result = new DataResult();
AdminEntity entity = WebUtil.GetFormObject <AdminEntity>("Entity");
string CompanyID = WebUtil.GetFormValue <string>("CompanyID", string.Empty);
entity.CompanyID = CompanyID;
if (entity.IsNull())
{
result.Code = (int)EResponseCode.Exception;
result.Message = "新增用户信息为空";
return(Content(JsonHelper.SerializeObject(result)));
}
AdminProvider provider = new AdminProvider(CompanyID);
int line = provider.Update(entity);
if (line > 0)
{
result.Code = (int)EResponseCode.Success;
result.Message = "用户编辑成功";
}
else
{
result.Code = (int)EResponseCode.Exception;
result.Message = "用户编辑失败";
}
return(Content(JsonHelper.SerializeObject(result)));
}
public ActionResult AccountSetting()
{
AdminProvider provider = new AdminProvider();
AdminEntity entity = provider.GetAdmin(this.LoginUser.UserCode);
ViewBag.RoleList = BaseHelper.GetRoleList(this.LoginUser.RoleNum);
ViewBag.DepartList = BaseHelper.GetDepartList(this.LoginUser.DepartNum);
ViewBag.Admin = entity;
return(View());
}
/// <summary>
/// 修改密码
/// </summary>
/// <returns></returns>
public ActionResult UpdatePass()
{
string CompanyID = WebUtil.GetFormValue <string>("CompanyID");
string UserNum = WebUtil.GetFormValue <string>("UserNum");
string OldPass = WebUtil.GetFormValue <string>("OldPass");
string NewPass = WebUtil.GetFormValue <string>("NewPass");
AdminProvider provider = new AdminProvider(CompanyID);
DataResult result = provider.UpdatePwd(UserNum, OldPass, NewPass);
return(Content(JsonHelper.SerializeObject(result)));
}
/// <summary>
/// 根据工号扫描
/// </summary>
/// <returns></returns>
public ActionResult Scan()
{
string CompanyID = WebUtil.GetFormValue <string>("CompanyID");
string UserCode = WebUtil.GetFormValue <string>("UserCode");
AdminProvider provider = new AdminProvider(CompanyID);
AdminEntity entity = provider.Scan(UserCode);
DataResult <AdminEntity> result = new DataResult <AdminEntity>()
{
Code = (int)EResponseCode.Success, Message = "响应成功", Result = entity
};
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 Delete(string userCode)
{
AdminProvider provider = new AdminProvider();
int line = provider.Delete(userCode);
if (line > 0)
{
this.ReturnJson.AddProperty("d", "success");
}
else
{
this.ReturnJson.AddProperty("d", "");
}
return(Content(this.ReturnJson.ToString()));
}
/// <summary>
/// 管理员修改密码
/// </summary>
/// <returns></returns>
public ActionResult AdminEditPass()
{
string UserNum = WebUtil.GetFormValue <string>("UserNum", string.Empty);
string NewPass = WebUtil.GetFormValue <string>("NewPass", string.Empty);
string ConfirmPass = WebUtil.GetFormValue <string>("ConfirmPass", string.Empty);
string CompanyID = WebUtil.GetFormValue <string>("CompanyID");
DataResult dataResult = new DataResult();
if (UserNum.IsEmpty())
{
dataResult.Code = (int)EResponseCode.Exception;
dataResult.Message = "该非法操作已经被禁止";
return(Content(JsonHelper.SerializeObject(dataResult)));
}
if (NewPass.IsEmpty())
{
dataResult.Code = (int)EResponseCode.Exception;
dataResult.Message = "新密码不能为空";
return(Content(JsonHelper.SerializeObject(dataResult)));
}
if (NewPass != ConfirmPass)
{
dataResult.Code = (int)EResponseCode.Exception;
dataResult.Message = "密码和确认密码不一致";
return(Content(JsonHelper.SerializeObject(dataResult)));
}
AdminProvider provider = new AdminProvider(CompanyID);
int line = provider.AdminEditPass(UserNum, NewPass);
if (line > 0)
{
dataResult.Code = (int)EResponseCode.Success;
dataResult.Message = "修改成功";
}
else
{
dataResult.Code = (int)EResponseCode.Exception;
dataResult.Message = "修改失败";
}
return(Content(JsonHelper.SerializeObject(dataResult)));
}
/// <summary>
/// 删除用户
/// </summary>
/// <returns></returns>
public ActionResult Delete()
{
List <string> list = WebUtil.GetFormObject <List <string> >("List");
string CompanyID = WebUtil.GetFormValue <string>("CompanyID");
AdminProvider provider = new AdminProvider(CompanyID);
int line = provider.Delete(list);
DataResult result = new DataResult();
if (line > 0)
{
result.Code = (int)EResponseCode.Success;
result.Message = string.Format("部门删除成功,受影响行数{0}行", line);
}
else
{
result.Code = (int)EResponseCode.Exception;
result.Message = "部门删除失败";
}
return(Content(JsonHelper.SerializeObject(result)));
}
public ActionResult ChangePwd(string currentPassword, string passWord)
{
AdminProvider provider = new AdminProvider();
AdminEntity entity = provider.Login(this.LoginUser.UserName, currentPassword);
int line = 0;
if (entity.IsNotNull())
{
entity.PassWord = passWord;
line = provider.UpdatePwd(entity);
}
if (line > 0)
{
this.ReturnJson.AddProperty("d", "success");
}
else
{
this.ReturnJson.AddProperty("d", "");
}
return(Content(this.ReturnJson.ToString()));
}
/// <summary>
/// 登录
/// 1000: 登录成功
/// 1001: 登录失败
/// 1002: 验证码过期
/// 1003：验证码错误
/// </summary>
/// <param name="userName"></param>
/// <param name="passWord"></param>
/// <returns></returns>
public ActionResult Login(string userName, string passWord, string code)
{
//string valCode=SessionHelper.Get("ValCode");
//if (valCode.IsEmpty())
//{
// return Content("1002");
//}
//if (valCode.ToLower()!=code.ToLower())
//{
// return Content("1003");
//}
AdminProvider provider = new AdminProvider();
AdminEntity entity = provider.Login(userName, passWord);
if (entity != null)
{
this.LoginUser = entity;
provider.UpdateLoginCount(entity.UserName, entity.PassWord, entity.LoginCount);
return(Content("1000"));
}
return(Content("1001"));
}
public ActionResult BatchDel(string userCode)
{
AdminProvider provider = new AdminProvider();
string[] list = userCode.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
List <string> ls = new List <string>();
int line = 0;
foreach (string t in list)
{
line += provider.Delete(t);
}
if (line > 0)
{
this.ReturnJson.AddProperty("d", "success");
}
else
{
this.ReturnJson.AddProperty("d", "");
}
return(Content(this.ReturnJson.ToString()));
}
/// <summary>
/// 查询数据集
/// </summary>
/// <param name="entity"></param>
/// <param name="list"></param>
/// <returns></returns>
public DataSet GetDataSource(ReportsEntity entity, List <ReportParamsEntity> list, int orderType, string orderNum)
{
DataSet ds = null;
if (entity.ReportType == (int)EReportType.Report)
{
ds = this.Reports.GetDataSource(entity, list);
}
else
{
if (orderType == (int)EReportType.InBill)
{
Bill <InStorageEntity, InStorDetailEntity> bill = new InStorageOrder(this.CompanyID);
ds = bill.GetPrint(orderNum);
}
else if (orderType == (int)EReportType.OutBill)
{
Bill <OutStorageEntity, OutStoDetailEntity> bill = new OutStorageOrder(this.CompanyID);
ds = bill.GetPrint(orderNum);
}
else if (orderType == (int)EReportType.User)
{
AdminProvider provider = new AdminProvider(this.CompanyID);
ds = provider.GetPrint(orderNum);
}
}
if (ds != null)
{
foreach (DataTable table in ds.Tables)
{
if (table.Rows.Count == 0)
{
DataRow row = table.NewRow();
table.Rows.Add(row);
}
}
}
return(ds);
}
/// <summary>
/// 用户登录
/// </summary>
/// <returns></returns>
public ActionResult Login()
{
string UserName = WebUtil.GetFormValue <string>("UserName", string.Empty);
string PassWord = WebUtil.GetFormValue <string>("PassWord", string.Empty);
string CompanyID = WebUtil.GetFormValue <string>("CompanyID", string.Empty);
AdminProvider provider = new AdminProvider(CompanyID);
AdminEntity entity = provider.Login(UserName, PassWord);
DataResult <AdminEntity> dataResult = new DataResult <AdminEntity>();
if (entity == null)
{
dataResult.Code = (int)EResponseCode.Exception;
dataResult.Message = "用户名或密码错误";
}
else
{
dataResult.Code = (int)EResponseCode.Success;
dataResult.Message = "响应成功";
dataResult.Result = entity;
}
return(Content(JsonHelper.SerializeObject(dataResult)));
}
public ActionResult AddUser()
{
string userCode = WebUtil.GetQueryStringValue <string>("userCode");
if (userCode.IsEmpty())
{
ViewBag.RoleList = BaseHelper.GetRoleList(string.Empty);
ViewBag.DepartList = BaseHelper.GetDepartList(string.Empty);
ViewBag.Admin = new AdminEntity();
return(View());
}
else
{
AdminProvider provider = new AdminProvider();
AdminEntity entity = provider.GetAdmin(userCode);
entity = entity == null ? new AdminEntity() : entity;
ViewBag.RoleList = BaseHelper.GetRoleList(entity.RoleNum);
ViewBag.DepartList = BaseHelper.GetDepartList(entity.DepartNum);
entity.RoleName = this.LoginUser.RoleName;
ViewBag.Admin = entity;
return(View());
}
}
/// <summary>
/// 查询产品类别分页
/// </summary>
/// <param name="entity"></param>
/// <param name="pageInfo"></param>
/// <returns></returns>
public List <ProductCategoryEntity> GetList(ProductCategoryEntity entity, ref PageInfo pageInfo)
{
entity.IncludeAll();
entity.Where(a => a.IsDelete == (int)EIsDelete.NotDelete);
entity.OrderBy(a => a.ID, EOrderBy.DESC);
int rowCount = 0;
List <ProductCategoryEntity> list = this.ProductCategory.GetList(entity, pageInfo.PageSize, pageInfo.PageIndex, out rowCount);
pageInfo.RowCount = rowCount;
if (!list.IsNullOrEmpty())
{
AdminProvider adminProvider = new AdminProvider();
foreach (ProductCategoryEntity item in list)
{
if (!item.CreateUser.IsEmpty())
{
AdminEntity admin = adminProvider.GetAdmin(item.CreateUser);
item.CreateUser = admin.IsNotNull() ? admin.UserName : item.CreateUser;
}
}
}
return(list);
}
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 async Task <bool> DeleteApplicationAsync(string applicationName)
{
var adminProvider = new AdminProvider(_url, _apiKey);
return(await adminProvider.DeleteApplication(applicationName));
}
public async Task <bool> ApplicationExists(string name)
{
var adminProvider = new AdminProvider(_url, _apiKey);
return(await adminProvider.ApplicationExists(name));
}
public async Task <bool> UpdateApplicationAsync(string applicationName, string newApplicationName, string description)
{
var adminProvider = new AdminProvider(_url, _apiKey);
return(await adminProvider.UpdateApplication(applicationName, newApplicationName, description));
}
public async Task <SettingsApplication[]> GetApplications()
{
var adminProvider = new AdminProvider(_url, _apiKey);
return(await adminProvider.Applications());
}
public async Task <ApiKey> GetApiKey(string applicationName, string apiKeyName)
{
var adminProvider = new AdminProvider(_url, _apiKey);
return(await adminProvider.GetApiKey(applicationName, apiKeyName));
}
public async Task <bool> ApiKeyExists(string applicationName, string apiKeyName)
{
var adminProvider = new AdminProvider(_url, _apiKey);
return(await adminProvider.ApiKeyExists(applicationName, apiKeyName));
}
public async Task <ApiKey> CreateApiKey(string applicationName, ApiKey key)
{
var adminProvider = new AdminProvider(_url, _apiKey);
return(await adminProvider.CreateApiKey(applicationName, key));
}
