Ejemplo n.º 1
0
 public JsonResult Delete(string ID)
 {
     DeptRule rule = new DeptRule();
     try
     {
         return Json(rule.Delete(ID), JsonRequestBehavior.AllowGet);
     }
     catch
     {
     } return null;
 }
Ejemplo n.º 2
0
 public JsonResult AddDept(string PID, string DeptName)
 {
     string selectCode = "select max(code) from t_dept where PID = @PID";
     DeptRule rule = new DeptRule();
     string code = rule.GetDeptCode(selectCode, new string[] { "PID" }, new string[] { PID });
     string selectPCode = "select code from t_dept where ID = @ID";
     string PCode = rule.GetDeptCode(selectPCode, new string[] { "ID" }, new string[] { PID });
     if (string.IsNullOrEmpty(code))
         code = PCode + "0001";
     else
         code = code.Substring(0, code.Length - 4) + (Convert.ToInt32(code.Substring(code.Length - 4)) + 1).ToString().PadLeft(4, '0');
     string id = Guid.NewGuid().ToString().Replace("-", "");
     Dept dept = new Dept() { ID = id, PY = Pinyin.GetPinyin(DeptName), Status = 1, Code = code, PID = PID, Name = DeptName };
     rule.Add(dept);
     string sql = "select id,pid,name,code,status,case status when 0 then '在用' else '停用' end as statusName from t_dept where id=@ID";
     return Json(rule.GetDeptDynamic(sql, new string[] { "ID" }, new string[] { id }), JsonRequestBehavior.AllowGet);
 }
Ejemplo n.º 3
0
 public JsonResult GetAllDeptJson()
 {
     List<Dept> deptList = new DeptRule().GetModelList("");
     List<Object> result = new List<object>();
     foreach (Dept d in deptList)
     {
         if (string.IsNullOrEmpty(d.PID))
         {
             result.Add(new { Identifier = d.ID, Dept_Name = d.Name, Dept_Status = d.Status == 1 ? "正常" : "删除" });
         }
         else
         {
             result.Add(new { Identifier = d.ID, Dept_Name = d.Name, _parentId = d.PID, Dept_Status = d.Status == 1 ? "正常" : "删除" });
         }
     }
     Dictionary<string, object> json = new Dictionary<string, object>();
     json.Add("total", deptList.Count);
     json.Add("rows", result);
     return Json(json, JsonRequestBehavior.AllowGet);
 }
Ejemplo n.º 4
0
 public JsonResult Modify(Dept dept)
 {
     DeptRule rule = new DeptRule();
     try
     {
         if (rule.Update(dept.ID, dept.Name))
         {
             return GetDept(dept.ID);
         }
         else
         {
             throw new Exception();
         }
     }
     catch
     {
         return null;
     }
 }
Ejemplo n.º 5
0
 public JsonResult GetDeptList(Dept dept)
 {
     StringBuilder temp = new StringBuilder("select id,pid,name,code,status,case status when 0 then '在用' else '停用' end as statusName from t_dept where 1=1 ");
     if (dept != null)
     {
         if (!string.IsNullOrEmpty(dept.Code))
         {
             temp.Append(" and code like '" + dept.Code + "%'");
         }
         if (!string.IsNullOrEmpty(dept.ID))
         {
             temp.Append(" and ID = '" + dept.ID + "'");
         }
         if (string.IsNullOrEmpty(dept.PID))
         {
             temp.Append(" and PID is null");
         }
         else
         {
             temp.Append(" and pid = '" + dept.PID + "'");
         }
         if (!string.IsNullOrEmpty(dept.Name))
         {
             temp.Append(" and Name like '%" + dept.Name + "%'");
         }
         if (!string.IsNullOrEmpty(dept.PY))
         {
             temp.Append(" and NamePY like '%" + dept.PY + "%'");
         }
         temp.Append(" and status = " + dept.Status);
     }
     List<object> lists = new List<object>();
     lists = new DeptRule().GetDeptDynamicList(temp.ToString(), null, null);
     return Json(lists, JsonRequestBehavior.AllowGet);
 }
Ejemplo n.º 6
0
 public JsonResult GetDept(string ID)
 {
     StringBuilder temp = new StringBuilder("select id,pid,name,code,status,case status when 0 then '在用' else '停用' end as statusName from t_dept where ID=@ID");
     object o = new DeptRule().GetDeptDynamic(temp.ToString(), new string[] { "ID" }, new string[] { ID });
     return Json(o, JsonRequestBehavior.AllowGet);
 }