/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Dept model)
{
using (DBHelper db = DBHelper.Create())
{
db.Insert<Dept>(model);
}
}
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);
}
/// <summary>
/// 获得数据列表
/// </summary>
public List<Dept> DataTableToList(DataTable dt)
{
List<Dept> modelList = new List<Dept>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
Dept model;
for (int n = 0; n < rowsCount; n++)
{
model = new Dept();
if (dt.Rows[n]["ID"] != null && dt.Rows[n]["ID"].ToString() != "")
{
model.ID = dt.Rows[n]["ID"].ToString();
}
if (dt.Rows[n]["PID"] != null && dt.Rows[n]["PID"].ToString() != "")
{
model.PID = dt.Rows[n]["PID"].ToString();
}
if (dt.Rows[n]["Code"] != null && dt.Rows[n]["Code"].ToString() != "")
{
model.Code = dt.Rows[n]["Code"].ToString();
}
if (dt.Rows[n]["Name"] != null && dt.Rows[n]["Name"].ToString() != "")
{
model.Name = dt.Rows[n]["Name"].ToString();
}
if (dt.Rows[n]["PY"] != null && dt.Rows[n]["PY"].ToString() != "")
{
model.PY = dt.Rows[n]["PY"].ToString();
}
if (dt.Rows[n]["Status"] != null && dt.Rows[n]["Status"].ToString() != "")
{
model.Status = Convert.ToInt32(dt.Rows[n]["Status"].ToString());
}
modelList.Add(model);
}
}
return modelList;
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Dept model)
{
using (DBHelper db = DBHelper.Create())
{
db.Update<Dept>(model);
return true;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Dept model)
{
dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Dept model)
{
return dal.Update(model);
}
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 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);
}