/// <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());
}
