public JsonResult SaveDepartment(SYS_Department depmentItem)
{
if (depmentItem == null)
{
return(Json(new { result = "error", message = "部门数据不正确" }));
}
string errMsg = "";
if (depmentItem.ID == 0)
{
depmentItem.CreateTime = DateTime.Now;
//add
departmentBLL.AddDepartment(depmentItem, ref errMsg);
//Common.LogHelper.InsertLog(String.Format("新增部门,ID-{0}", depmentItem.ToString()), 44, "部门列表");
}
else
{
//edit
departmentBLL.EditDepartment(depmentItem, ref errMsg);
//Common.LogHelper.InsertLog(String.Format("编辑部门,ID-{0}", depmentItem.ToString()), 44, "部门列表");
}
var result = new { result = "ok", message = "操作成功" };
if (!string.IsNullOrEmpty(errMsg))
{
result = new { result = "error", message = errMsg };
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
private string CreateDeptNum(SYS_Department dept)
{
string actionCount = "01";
string deptNum = "DT";
SYS_Department parentMenu = null;
SYS_Department lastMenu = null;
using (HISDataEntities hisEntities = new HISDataEntities())
{
//查找上级菜单
parentMenu = hisEntities.SYS_Department.Where(o => o.ID == dept.ParentID).FirstOrDefault();
//查询菜单下最大编号不包括自己和已经删除的
lastMenu = hisEntities.SYS_Department.Where(o => o.ParentID == dept.ParentID).OrderByDescending(o => o.DepartmentNum).FirstOrDefault();
}
if (lastMenu != null)
{
var str = lastMenu.DepartmentNum.Substring(lastMenu.DepartmentNum.Length - 2, 2);
int number = Convert.ToInt32(str) + 1;
actionCount = number.ToString().PadLeft(2, '0');
}
if (parentMenu != null)
{
deptNum = parentMenu.DepartmentNum + actionCount;
return(deptNum);
}
return(deptNum + actionCount);
}
/// <summary>
/// 编辑部门
/// </summary>
/// <param name="department"></param>
/// <param name="errMsg"></param>
public void EditDepartment(SYS_Department department, ref string errMsg)
{
try
{
using (HISDataEntities appEntitys = new HISDataEntities())
{
SYS_Department editItem = appEntitys.SYS_Department.Where(o => o.ID == department.ID).FirstOrDefault();
if (editItem == null)
{
errMsg = "查无数据";
return;
}
editItem.DepartmentNum = department.DepartmentNum;
editItem.Department = department.Department;
//editItem.Disc = department.Disc;
editItem.ParentID = department.ParentID;
editItem.Flag = department.Flag;
appEntitys.SaveChanges();
}
}
catch (Exception e)
{
errMsg = e.Message;
}
}
/// <summary>
/// 添加部门
/// </summary>
/// <param name="department"></param>
/// <param name="errMsg"></param>
public void AddDepartment(SYS_Department department, ref string errMsg)
{
try
{
department.Flag = 1;
using (HISDataEntities appEntitys = new HISDataEntities())
{
if (department.ParentID == null)
{
department.ParentID = 0;
}
//检查部门编号和部门名称不能重复
var queryList = appEntitys.SYS_Department.Where(o => o.Department == department.Department || o.DepartmentNum == department.DepartmentNum);
if (queryList.Count() > 0)
{
errMsg = "部门名称或部门编号重复";
return;
}
department.DepartmentNum = CreateDeptNum(department);
appEntitys.SYS_Department.Add(department);
appEntitys.SaveChanges();
}
}
catch (Exception e)
{
errMsg = e.Message;
}
}
public ActionResult Dialog(int Id)
{
if (Id < 1)
{
SYS_Department dept = new SYS_Department()
{
DepartmentNum = "自动生成"
};
return(View(dept));
}
string errMsg = string.Empty;
SYS_Department department = departmentBLL.GetDepartmentByID(Id, ref errMsg);
if (!string.IsNullOrEmpty(errMsg))
{
return(View(new SYS_Department()));
}
return(View(department));
}
/// <summary>
/// 根据id 获取department
/// </summary>
/// <param name="id"></param>
/// <param name="errMsg"></param>
/// <returns></returns>
public SYS_Department GetDepartmentByID(int id, ref string errMsg)
{
try
{
using (HISDataEntities appEntitys = new HISDataEntities())
{
SYS_Department department = appEntitys.SYS_Department.Where(o => o.ID == id).FirstOrDefault();
if (department != null)
{
return(department);
}
errMsg = "查无数据";
return(null);
}
}
catch (Exception e)
{
errMsg = e.Message;
return(null);
}
}
/// <summary>
/// 删除部门
/// </summary>
/// <param name="departmentID"></param>
/// <param name="errMsg"></param>
public void DeleteDepartment(int departmentID, ref string errMsg)
{
try
{
using (HISDataEntities appEntitys = new HISDataEntities())
{
SYS_Department editItem = appEntitys.SYS_Department.Where(o => o.ID == departmentID).FirstOrDefault();
if (editItem == null)
{
errMsg = "查无数据";
return;
}
//标记删除
editItem.Flag = 0;
appEntitys.SaveChanges();
}
}
catch (Exception e)
{
errMsg = e.Message;
}
}
private Hashtable InitDepartmentGridChildren(List <SYS_Department> departmentList, SYS_Department item)
{
Hashtable ht = new Hashtable();
ht.Add("ID", item.ID);
ht.Add("Department", item.Department);
ht.Add("DepartmentNum", item.DepartmentNum);
//ht.Add("Disc", item.Disc);
ht.Add("Flag", item.Flag);
ht.Add("CreateTime", Convert.ToDateTime(item.CreateTime).ToString("yyyy-MM-dd HH:mm:ss"));
ht.Add("ParentID", item.ParentID);
var childrenList = departmentList.Where(o => o.ParentID == item.ID);
if (childrenList.Count() > 0)
{
List <Hashtable> htList = new List <Hashtable>();
foreach (SYS_Department childrenItem in childrenList)
{
Hashtable childrenHt = InitDepartmentGridChildren(departmentList, childrenItem);
htList.Add(childrenHt);
}
ht.Add("children", htList);
}
return(ht);
}