/// <summary> /// 新增部门 /// </summary> /// <returns></returns> public ActionResult Add() { string DepartName = WebUtil.GetFormValue <string>("DepartName"); string ParentNum = WebUtil.GetFormValue <string>("ParentNum"); string CompanyID = WebUtil.GetFormValue <string>("CompanyID"); string SnNum = WebUtil.GetFormValue <string>("SnNum"); SysDepartEntity entity = new SysDepartEntity(); entity.SnNum = SnNum; entity.DepartName = DepartName; entity.ChildCount = 0; entity.ParentNum = ParentNum; entity.Depth = 0; entity.IsDelete = (int)EIsDelete.NotDelete; entity.CreateTime = DateTime.Now; entity.CompanyID = CompanyID; DepartProvider provider = new DepartProvider(CompanyID); int line = provider.Add(entity); DataResult result = new DataResult(); 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 AddDepart([ModelBinder(typeof(JsonBinder <SysDepartEntity>))] SysDepartEntity entity) { DepartProvider provider = new DepartProvider(); int line = 0; if (entity.DepartNum.IsEmpty()) { entity.DepartNum = SequenceProvider.GetSequence(typeof(SysDepartEntity)); entity.IsDelete = (int)EIsDelete.NotDelete; entity.CreateTime = DateTime.Now; line = provider.Add(entity); } else { line = provider.UpdateDepart(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 GetPage() { string CompanyID = WebUtil.GetFormValue <string>("CompanyID"); int PageIndex = WebUtil.GetFormValue <int>("PageIndex", 1); int PageSize = WebUtil.GetFormValue <int>("PageSize", 10); string DepartName = WebUtil.GetFormValue <string>("DepartName", string.Empty); string ParentNum = WebUtil.GetFormValue <string>("ParentNum", string.Empty); SysDepartEntity entity = new SysDepartEntity(); entity.DepartName = DepartName; entity.ParentNum = ParentNum; PageInfo pageInfo = new PageInfo(); pageInfo.PageIndex = PageIndex; pageInfo.PageSize = PageSize; DepartProvider provider = new DepartProvider(CompanyID); List <SysDepartEntity> list = provider.GetList(entity, ref pageInfo); DataListResult <SysDepartEntity> result = new DataListResult <SysDepartEntity>() { Code = (int)EResponseCode.Success, Message = "响应成功", Result = list, PageInfo = pageInfo }; return(Content(JsonHelper.SerializeObject(result))); }
public ActionResult Delete(int id) { DepartProvider provider = new DepartProvider(); int line = provider.DeleteDepart(id); if (line > 0) { this.ReturnJson.AddProperty("d", "success"); } return(Content(this.ReturnJson.ToString())); }
/// <summary> /// 查询部门列表 /// </summary> /// <returns></returns> public ActionResult GetList() { string CompanyID = WebUtil.GetFormValue <string>("CompanyID"); DepartProvider provider = new DepartProvider(CompanyID); List <SysDepartEntity> list = provider.GetList(); DataListResult <SysDepartEntity> result = new DataListResult <SysDepartEntity>() { Code = (int)EResponseCode.Success, Message = "响应成功", Result = list }; return(Content(JsonHelper.SerializeObject(result))); }
public ActionResult ToExcel() { PageInfo pageInfo = new Git.Framework.DataTypes.PageInfo() { PageIndex = 1, PageSize = Int32.MaxValue }; string departName = WebUtil.GetFormValue <string>("departName", string.Empty); DepartProvider provider = new DepartProvider(); SysDepartEntity entity = new SysDepartEntity(); List <SysDepartEntity> list = provider.GetList(); List <SysDepartEntity> listResult = new List <SysDepartEntity>(); if (!list.IsNullOrEmpty()) { listResult = list.Where(a => a.DepartName.Contains(departName) || a.DepartNum.Contains(departName)).OrderByDescending(a => a.ID).ToList(); } 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("创建时间")); int count = 1; foreach (SysDepartEntity t in listResult) { DataRow row = dt.NewRow(); row[0] = count; row[1] = t.DepartNum; row[2] = t.DepartName; row[3] = t.CreateTime; count++; 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())); }
/// <summary> /// 查询部门信息 /// </summary> /// <returns></returns> public ActionResult Single() { string CompanyID = WebUtil.GetFormValue <string>("CompanyID"); string DepartNum = WebUtil.GetFormValue <string>("DepartNum"); DepartProvider provider = new DepartProvider(CompanyID); SysDepartEntity entity = provider.GetSingle(DepartNum); DataResult <SysDepartEntity> result = new DataResult <SysDepartEntity>() { Code = (int)EResponseCode.Success, Message = "响应成功", Result = entity }; return(Content(JsonHelper.SerializeObject(result))); }
/// <summary> /// 查询族谱路径 /// </summary> /// <returns></returns> public ActionResult GetParentList() { string CompanyID = WebUtil.GetFormValue <string>("CompanyID"); string SnNum = WebUtil.GetFormValue <string>("SnNum"); DepartProvider provider = new DepartProvider(CompanyID); List <SysDepartEntity> list = provider.GetParentList(SnNum); DataResult <List <SysDepartEntity> > dataResult = new DataResult <List <SysDepartEntity> >(); dataResult.Code = (int)EResponseCode.Success; dataResult.Message = "响应成功"; dataResult.Result = list; return(Content(JsonHelper.SerializeObject(dataResult))); }
public ActionResult DepartList(int pageIndex, int pageSize, string departName) { DepartProvider provider = new DepartProvider(); List <SysDepartEntity> list = provider.GetList(); List <SysDepartEntity> listResult = new List <SysDepartEntity>(); List <SysDepartEntity> returnList = new List <SysDepartEntity>(); if (!list.IsNullOrEmpty()) { listResult = list.Where(a => a.DepartName.Contains(departName) || a.DepartNum.Contains(departName)).ToList(); returnList = listResult.Skip((pageIndex - 1) * pageSize).Take(pageSize).OrderByDescending(a => a.ID).ToList(); } this.ReturnJson.AddProperty("Data", ConvertJson.ListToJson <SysDepartEntity>(returnList, "List")); this.ReturnJson.AddProperty("RowCount", listResult.Count); return(Content(this.ReturnJson.ToString())); }
/// <summary> /// 获得部门的下来列表 /// </summary> /// <param name="departNum"></param> /// <returns></returns> public static string GetDepartList(string departNum) { DepartProvider provider = new DepartProvider(); List <SysDepartEntity> list = provider.GetList(); StringBuilder sb = new StringBuilder(); string departTemplate = "<option value='{0}' {1}>{2}</option>"; sb.AppendFormat(departTemplate, "", "", "请选择部门"); if (!list.IsNullOrEmpty()) { foreach (SysDepartEntity depart in list) { sb.AppendFormat(departTemplate, depart.DepartNum, depart.DepartNum == departNum ? "selected='selected'" : string.Empty, depart.DepartName); } } return(sb.ToString()); }
public ActionResult AddDepart() { string departNum = WebUtil.GetQueryStringValue <string>("departNum"); if (departNum.IsEmpty()) { ViewBag.SysDepart = new SysDepartEntity(); return(View()); } else { DepartProvider provider = new DepartProvider(); SysDepartEntity entity = provider.GetDepartEntity(departNum); entity = entity == null ? new SysDepartEntity() : entity; ViewBag.SysDepart = entity; return(View()); } }
/// <summary> /// 删除部门 /// </summary> /// <returns></returns> public ActionResult Delete() { List <string> list = WebUtil.GetFormObject <List <string> >("List"); string CompanyID = WebUtil.GetFormValue <string>("CompanyID"); DepartProvider provider = new DepartProvider(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 BatchDel(string id) { DepartProvider provider = new DepartProvider(); string[] list = id.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); List <string> ls = new List <string>(); int line = 0; foreach (string t in list) { line += provider.DeleteDepart(Convert.ToInt32(t)); } if (line > 0) { this.ReturnJson.AddProperty("d", "success"); } else { this.ReturnJson.AddProperty("d", ""); } return(Content(this.ReturnJson.ToString())); }
/// <summary> /// 查询分页 /// </summary> /// <param name="pageInfo"></param> /// <returns></returns> public List <StorageEntity> GetList(StorageEntity entity, ref PageInfo pageInfo) { List <StorageEntity> listSource = GetList(); if (listSource.IsNullOrEmpty()) { return(null); } int rowCount = 0; List <StorageEntity> listResult = listSource; if (!entity.StorageNum.IsEmpty()) { listResult = listResult.Where(a => a.StorageNum.Contains(entity.StorageNum)).ToList(); } if (!entity.StorageName.IsEmpty()) { listResult = listResult.Where(a => a.StorageName.Contains(entity.StorageName)).ToList(); } if (entity.StorageType > 0) { listResult = listResult.Where(item => item.StorageType == entity.StorageType).ToList(); } if (entity.IsDefault > -1) { listResult = listResult.Where(a => a.IsDefault == entity.IsDefault).ToList(); } if (entity.IsForbid > -1) { listResult = listResult.Where(a => a.IsForbid == entity.IsForbid).ToList(); } if (entity.Status > 0) { listResult = listResult.Where(a => a.Status == entity.Status).ToList(); } if (!entity.Remark.IsEmpty()) { listResult = listResult.Where(a => a.Remark.Contains(entity.Remark)).ToList(); } if (entity.DepartNum.IsNotEmpty()) { DepartProvider departProvider = new DepartProvider(this.CompanyID); List <SysDepartEntity> listDepart = departProvider.GetChildList(entity.DepartNum); listDepart = listDepart.IsNull() ? new List <SysDepartEntity>() : listDepart; listResult = listResult.Where(item => listDepart.Exists(depart => depart.SnNum == item.DepartNum)).ToList(); } if (entity.CreateUser.IsNotEmpty()) { listResult = listResult.Where(item => item.CreateUser == entity.CreateUser).ToList(); } if (entity.Contact.IsNotEmpty()) { listResult = listResult.Where(item => item.Contact.Contains(entity.Contact)).ToList(); } if (entity.Address.IsNotEmpty()) { listResult = listResult.Where(item => item.Address.Contains(entity.Address)).ToList(); } if (entity.Phone.IsNotEmpty()) { listResult = listResult.Where(item => item.Phone.Contains(entity.Phone)).ToList(); } rowCount = listResult.Count(); pageInfo.RowCount = rowCount; return(listResult.Skip((pageInfo.PageIndex - 1) * pageInfo.PageSize).Take(pageInfo.PageSize).ToList()); }