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));
}
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));
}
public JsonResult Delete(string ID)
{
DeptRule rule = new DeptRule();
try
{
return(Json(rule.Delete(ID), JsonRequestBehavior.AllowGet));
}
catch
{
} return(null);
}
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);
}
}
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));
}
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));
}
