public static string getDefaultUserName(string strResultId) { DataTable dt = new DataTable(); dt.Columns.Add("UserId", typeof(string)); dt.Columns.Add("UserName", typeof(string)); TMisMonitorResultAppVo TMisMonitorResultAppVo = new TMisMonitorResultAppVo(); TMisMonitorResultAppVo.RESULT_ID = strResultId; DataTable objTable = new TMisMonitorResultAppLogic().SelectByTable(TMisMonitorResultAppVo); if (objTable.Rows.Count == 0) { return(DataTableToJson(dt)); } string strUserId = objTable.Rows[0]["HEAD_USERID"].ToString(); if (strUserId == "") { return(DataTableToJson(dt)); } //将获取用户ID信息转换成用户名称进行返回 string strUserName = new i3.BusinessLogic.Sys.General.TSysUserLogic().Details(strUserId).REAL_NAME; DataRow row = dt.NewRow(); row["UserId"] = strUserId; row["UserName"] = strUserName; dt.Rows.Add(row); return(DataTableToJson(dt)); }
public static string getDefaultUserExName(string strUserId) { if (strUserId.Trim() == "") { return(""); } List <string> list = strUserId.Split(',').ToList(); string strSumUserExName = ""; string spit = ""; foreach (string strUserExId in list) { string strUserName = new i3.BusinessLogic.Sys.General.TSysUserLogic().Details(strUserExId).REAL_NAME; strSumUserExName = strSumUserExName + spit + strUserName; spit = ","; } return(strSumUserExName); }
public static string getDefaultUserExName(string strResultId) { DataTable dt = new DataTable(); dt.Columns.Add("UserId", typeof(string)); dt.Columns.Add("UserName", typeof(string)); TMisMonitorResultAppVo TMisMonitorResultAppVo = new TMisMonitorResultAppVo(); TMisMonitorResultAppVo.RESULT_ID = strResultId; DataTable objTable = new TMisMonitorResultAppLogic().SelectByTable(TMisMonitorResultAppVo); if (objTable.Rows.Count == 0) { return(DataTableToJson(dt)); } string strUserExIds = objTable.Rows[0]["ASSISTANT_USERID"].ToString(); if (strUserExIds == "") { return(DataTableToJson(dt)); } List <string> list = strUserExIds.Split(',').ToList(); string strSumUserExName = ""; string spit = ""; foreach (string strUserExId in list) { string strUserName = new i3.BusinessLogic.Sys.General.TSysUserLogic().Details(strUserExId).REAL_NAME; strSumUserExName = strSumUserExName + spit + strUserName; spit = ","; } DataRow row = dt.NewRow(); row["UserId"] = strUserExIds; row["UserName"] = strSumUserExName; dt.Rows.Add(row); return(DataTableToJson(dt)); }
public string GetMenuByUserIDForLogin(string strUserID) { string strToJson = ""; DataTable dtUserMenu = null; TSysMenuVo menuvo = new TSysMenuVo(); menuvo.IS_DEL = "0"; menuvo.IS_USE = "1"; menuvo.IS_SHORTCUT = "0"; menuvo.MENU_TYPE = "Menu"; if (strUserID == "000000001") { dtUserMenu = new TSysMenuLogic().SelectByTable(menuvo); } else { menuvo.IS_HIDE = "0"; dtUserMenu = new TSysMenuLogic().GetMenuByUserID(menuvo, strUserID); } var user = new TSysUserLogic().SelectByObject(new TSysUserVo { ID = strUserID }); DataRow[] drlist = dtUserMenu.Select(" PARENT_ID='0'", "ORDER_ID ASC"); if (drlist.Length == 0) { return(""); } foreach (DataRow dr in drlist) { string strPID = dr["ID"].ToString(); string strMenuText = dr["MENU_TEXT"].ToString(); strToJson += strToJson.Length > 0 ? "," : ""; strToJson += "{"; strToJson += "\"id\":\"" + strPID + "\","; strToJson += "\"MenuName\":\"" + strMenuText + "\","; strToJson += "\"MenuID\":\"" + strPID + "\","; strToJson += "\"text\":\"" + strMenuText + "\","; strToJson += "\"MenuUrl\":null,"; strToJson += "\"MenuNo\":\"" + strPID + "\","; strToJson += "\"MenuParentNo\":null,"; DataRow[] drChileList = dtUserMenu.Select(" PARENT_ID='" + strPID + "'", "ORDER_ID ASC"); if (drChileList.Length > 0) { strToJson += "\"children\":["; for (int i = 0; i < drChileList.Length; i++) { DataRow drchild = drChileList[i]; if (i > 0) { strToJson += ","; } string strChildID = drchild["ID"].ToString(); string strChildMenuText = drchild["MENU_TEXT"].ToString(); string strChildMenuUrl = drchild["MENU_URL"].ToString(); strToJson += "{"; strToJson += "\"id\":\"" + strChildID + "\","; strToJson += "\"MenuName\":\"" + strChildMenuText + "\","; strToJson += "\"MenuID\":\"" + strChildID + "\","; strToJson += "\"text\":\"" + strChildMenuText + "\","; //strToJson += "\"MenuUrl\":\"" + strChildMenuUrl + "\","; strToJson += "\"MenuUrl\":\"" + AddUrlUserParams(strChildMenuUrl, user) + "\","; strToJson += "\"MenuNo\":\"" + strChildID + "\","; strToJson += "\"MenuParentNo\":\"" + strPID + "\""; strToJson += "}"; } strToJson += "]"; } strToJson += "}"; } return(strToJson); }