private List <UserMgrModel> qryUserData(UserMgrModel userMgrModel) { CodeUserDao codeUserDao = new CodeUserDao(); List <UserMgrModel> rows = codeUserDao.qryUserMgr(userMgrModel); using (DB_INTRAEntities db = new DB_INTRAEntities()) { OaEmpDao oaEmpDao = new OaEmpDao(); for (int i = 0; i < rows.Count; i++) { rows[i] = oaEmpDao.getUserOaData(rows[i], db); Dictionary <string, string> userNameMap = new Dictionary <string, string>(); if (!"".Equals(StringUtil.toString(rows[i].cCrtUserID))) { if (!"".Equals(rows[i].cCrtUserID)) { if (!userNameMap.ContainsKey(rows[i].cCrtUserID)) { userNameMap = oaEmpDao.qryUsrName(userNameMap, rows[i].cCrtUserID, db); } rows[i].cCrtUserID = rows[i].cCrtUserID + " " + userNameMap[rows[i].cCrtUserID]; } } if (!"".Equals(StringUtil.toString(rows[i].cUpdUserID))) { if (!"".Equals(rows[i].cUpdUserID)) { if (!userNameMap.ContainsKey(rows[i].cUpdUserID)) { userNameMap = oaEmpDao.qryUsrName(userNameMap, rows[i].cUpdUserID, db); } rows[i].cUpdUserID = rows[i].cUpdUserID + " " + userNameMap[rows[i].cUpdUserID]; } } if (!"".Equals(StringUtil.toString(rows[i].apprUid))) { if (!"".Equals(rows[i].apprUid)) { if (!userNameMap.ContainsKey(rows[i].apprUid)) { userNameMap = oaEmpDao.qryUsrName(userNameMap, rows[i].apprUid, db); } rows[i].apprUid = rows[i].apprUid + " " + userNameMap[rows[i].apprUid]; } } if (!"".Equals(StringUtil.toString(rows[i].frezzeUid))) { if (!"".Equals(rows[i].frezzeUid)) { if (!userNameMap.ContainsKey(rows[i].frezzeUid)) { userNameMap = oaEmpDao.qryUsrName(userNameMap, rows[i].frezzeUid, db); } rows[i].frezzeUid = rows[i].frezzeUid + " " + userNameMap[rows[i].frezzeUid]; } } } } bool bcUserName = StringUtil.isEmpty(userMgrModel.cUserName); if (!bcUserName) { rows = rows.Where(x => x.cUserName == userMgrModel.cUserName).ToList(); } return(rows); }