/// <summary>
/// 根据单位ID 获取单位下部门集合
/// </summary>
/// <param name="dwid">单位id</param>
/// <returns>部门集合</returns>
private static DataTable GetBmNodeBydw(string dwid)
{
var bll = new EDRS.BLL.XT_ZZJG_BMBM(request);
var sbwhere = new StringBuilder();
var objectValues = new object[1];
sbwhere.Append(" and FBMBM is null and SFSC = 'N' ");
sbwhere.Append(" and DWBM=:DWBM ");
objectValues[0] = dwid;
var ds = bll.GetList(sbwhere.ToString(), objectValues);
return(ds.Tables.Count > 0 ? ds.Tables[0] : new DataTable());
}
private static string DataTableToJson(DataTable dt)
{
var reJson = new StringBuilder();
reJson.Append("[");
if (dt != null && dt.Rows.Count > 0)
{
var dwbmbll = new EDRS.BLL.XT_ZZJG_DWBM(request);
var bmbmbll = new EDRS.BLL.XT_ZZJG_BMBM(request);
var jsbmbll = new EDRS.BLL.XT_QX_JSBM(request);
var dwMoldelist = dwbmbll.DataTableToList(dt);
foreach (var xtZzjgDwbm in dwMoldelist)
{
reJson.Append("{\"id\":\"" + xtZzjgDwbm.DWBM + "\",");
reJson.Append("\"text\":\"" + xtZzjgDwbm.DWMC + "\",");
reJson.Append("\"lx\":\"dw\"");
//获取当前单位下的子单位
dt = GetDwNode(xtZzjgDwbm.DWBM);
if (dt != null && dt.Rows.Count > 0)
{
reJson.Append(",\"state\":\"closed\",");
var childrenstr = DataTableToJson(dt);
reJson.Append("\"children\":" + childrenstr);
}
//获取当前单位下的部门
var bmdt = GetBmNodeBydw(xtZzjgDwbm.DWBM);
if (bmdt != null && bmdt.Rows.Count > 0)
{
var strBmJsons = ",\"children\":" + DataTableToBmJson(bmdt);
reJson.Append(strBmJsons);
}
reJson.Append("},");
}
}
var strjson = reJson.ToString();
strjson = strjson.Substring(0, strjson.Length - 1);
strjson += "]";
return(strjson);
}
/// <summary>
/// 根据部门父ID获取部门下子部门
/// </summary>
/// <param name="parentid">父部门ID</param>
/// <returns>子部门集合</returns>
private static DataTable GetBmNodeBybmParentid(string parentid)
{
var bll = new EDRS.BLL.XT_ZZJG_BMBM(request);
var sbwhere = new StringBuilder();
var objectValues = new object[1];
if (!string.IsNullOrWhiteSpace(parentid))
{
sbwhere.Append(" and FBMBM=:FBMBM ");
objectValues[0] = parentid;
}
sbwhere.Append(" and FBMBM is null and SFSC = 'N' ");
var ds = bll.GetList(sbwhere.ToString(), objectValues);
return(ds.Tables.Count > 0 ? ds.Tables[0] : new DataTable());
return(null);
}
private static string DataTableToBmJson(DataTable dt)
{
var reJson = new StringBuilder();
reJson.Append("[");
if (dt != null && dt.Rows.Count > 0)
{
var bmbmbll = new EDRS.BLL.XT_ZZJG_BMBM(request);
var jsbmbll = new EDRS.BLL.XT_QX_JSBM(request);
var bmMoldelist = bmbmbll.DataTableToList(dt);
foreach (var bmtemp in bmMoldelist)
{
reJson.Append("{\"id\":\"" + bmtemp.DWBM + "\",");
reJson.Append("\"text\":\"" + bmtemp.BMMC + "\",");
reJson.Append("\"lx\":\"bm\"");
//获取当前单位下的子单位
dt = GetBmNodeBybmParentid(bmtemp.BMBM);
if (dt != null && dt.Rows.Count > 0)
{
reJson.Append(",\"state\":\"closed\",");
var childrenstr = DataTableToBmJson(dt);
reJson.Append("\"children\":" + childrenstr);
}
//获取当前单位下的角色
var jsdt = GetJsNodeBybm(bmtemp.BMBM);
if (jsdt != null && jsdt.Rows.Count > 0)
{
var strJsJsons = ",\"children\":" + DataTableToJsJson(jsdt);
}
reJson.Append("},");
}
}
var strjson = reJson.ToString();
strjson = strjson.Substring(0, strjson.Length - 1);
strjson += "]";
return(strjson);
}
