public PM_ALT_NOTI getAgentByAlertID()
{
try
{
IList <PM_ALT_NOTI> list = new List <PM_ALT_NOTI>();
list = pm_ALT_NOTIBO.GetEntityByAlertID(alertID);
if (list.Count > 0)
{
return(list[0]);
}
// Guid guid= (Guid)list[0].AgentGuid;
return(null);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 拼装树结构
/// </summary>
/// <param name="nodelist">组</param>
/// <param name="userList">人</param>
/// <returns></returns>
public IList <CV_DEPARTMENT_ROOT_QuaryParam> GetTree(IList <CV_PM_WECHAT_DEPARTMENT> deptlist, Guid alertID)
{
//所有部门
allDepts = DepToQuaryParam2(deptlist); //转换一下
//user被选中项
if (listNoti == null || listNoti.Count == 0)
{
listNoti = pm_ALT_NOTIBO.GetEntityByAlertID(alertID);
foreach (PM_ALT_NOTI noti in listNoti)
{
if (string.IsNullOrEmpty(strNotiGuids))
{
strNotiGuids = noti.UserGuid.ToString();
}
else
{
strNotiGuids = strNotiGuids + "," + noti.UserGuid.ToString();
}
}
}
//所有用户
if (allUsers == null || allUsers.Count == 0)
{
//allUsers = cv_PM_WECHAT_USER_DEPARTMENTBO.GetEntities();
string strUser = @"SELECT usrDept.UserGuid,usrDept.UserID,usrDept.Name,usrDept.EnglishName,DepartmentGuid,DepartmentID,DepartmentName,
CASE WHEN ISNULL(noti.UserID,'')='' THEN CAST(0 AS BIT) ELSE CAST(1 AS BIT) END AS IsLeader --借用此字段【是否选中】
FROM CV_PM_WECHAT_USER_DEPARTMENT usrDept
LEFT JOIN CV_PM_ALT_NOTI noti ON usrDept.UserGuid=noti.UserGuid AND noti.AlertID = '{0}'
WHERE 1=1 ";
strUser = string.Format(strUser, alertID);
DataTable dt = alt_BSC_BO.GetDataTableBySql(strUser);
ModelHandler <CV_PM_WECHAT_USER_DEPARTMENT> model = new ModelHandler <CV_PM_WECHAT_USER_DEPARTMENT>();
allUsers = model.FillModel(dt);
allUserQPList = UserToQuaryParam(allUsers);
}
IList <CV_DEPARTMENT_ROOT_QuaryParam> rootList = new List <CV_DEPARTMENT_ROOT_QuaryParam>();
IList <CV_DEPARTMENT_QuaryParam> childList = new List <CV_DEPARTMENT_QuaryParam>();
//IList<CV_USER_DEPARTMENT_QuaryParam> userListByDepid = new List<CV_USER_DEPARTMENT_QuaryParam>();
//IList<CV_DEPARTMENT_QuaryParam> userlistbyid = new List<CV_DEPARTMENT_QuaryParam>();
for (int i = 0; i < allDepts.Count; i++)
{
if (allDepts[i].ParentID == "0") //根节点，Holley
//if (allDepts[i].Name == "家电事业部") //根节点，Aux
{
//根节点（组）
//rootList.Add(nodeList2[i]);
//string ID = nodeList2[i].ID.ToString();
CV_DEPARTMENT_ROOT_QuaryParam root = allDepts[i];
root.expand = true;
rootList.Add(root);
//子节点(组)
childList = GetChildList(rootList[0], alertID);
break;
}
}
return(rootList);
}