/// <summary> /// 사용자정보조회 및 팀리스트 생성 /// </summary> /// <param name="id"></param> /// <returns></returns> private ArrayList GetClientInfo(string id) { ArrayList objlist = new ArrayList(); Client cl = null; List<string> team_list = new List<string>(); Dictionary<string, List<string>> TeamTable = new Dictionary<string, List<string>>(); DataTable dt = new DataTable(); try { string TeamString = "M|"; string query = "select u.user_id, u.user_nm, u.team_nm, c.com_nm, u.com_cd from t_user as u, t_company as c where u.com_cd=c.com_cd"; dt = DoQuery(query, null); if (dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { string dbid = row["user_id"].ToString(); string name = row["user_nm"].ToString(); string team = row["team_nm"].ToString(); string com_nm = row["com_nm"].ToString(); string com_cd = row["com_cd"].ToString(); if (com_cd.Equals(configCtrl.CompanyCode)) { if (id.Equals(dbid)) { cl = new Client(id, name, team, "", com_nm, com_cd); } lock (TeamNameList) { TeamNameList[dbid] = team; LogWrite("TeamNameList[" + dbid + "] = " + team); } string minfo = null; minfo = dbid + "!" + name; string tname = team; List<string> temp = null; if (TeamTable.Count > 0) { if (TeamTable.ContainsKey(tname)) { TeamTable[tname].Add(minfo); } else { temp = new List<string>(); temp.Add(minfo); TeamTable[tname] = temp; } } else { temp = new List<string>(); temp.Add(minfo); TeamTable[tname] = temp; } } } } LogWrite("팀리스트 생성 시작!"); foreach (var de in TeamTable) { if (de.Value != null) { string teamstr = de.Key; List<string> temp = de.Value; foreach (string str in temp) { teamstr += "|" + str; } team_list.Add(TeamString + teamstr); LogWrite(TeamString + teamstr); } } LogWrite("팀리스트 생성 완료!"); } catch (Exception ex) { LogWrite(ex.ToString()); } objlist.Add(cl); objlist.Add(team_list); return objlist; }
/// <summary> /// 사용자정보조회 및 팀리스트 생성 /// </summary> /// <param name="id"></param> /// <returns></returns> private ArrayList getClientInfo(string id) { Hashtable parameters = new Hashtable(); ArrayList objlist = new ArrayList(); Client cl = null; ArrayList team_list = new ArrayList(); Hashtable TeamTable = new Hashtable(); MySqlDataReader dr = null; try { string TeamString = "M|"; string query = "select u.user_id, u.user_nm, u.team_nm, c.com_nm, u.com_cd from t_user as u, t_company as c where u.com_cd=c.com_cd"; dr = DoQuery(query, null); if (dr.HasRows) { while (dr.Read()) { string dbid = dr.GetString(0); string name = dr.GetString(1); string team = dr.GetString(2); string com_nm = dr.GetString(3); string com_cd = dr.GetString(4); if (com_cd.Equals(this.com_code)) { if (id.Equals(dbid)) { cl = new Client(id, name, team, "", com_nm, com_cd); } lock (TeamNameList) { TeamNameList[dbid] = team; logWrite("TeamNameList[" + dbid + "] = " + team); } string minfo = null; minfo = dr.GetString(0) + "!" + dr.GetString(1); string tname = dr.GetString(2); ArrayList temp = null; if (TeamTable.Count > 0) { if (TeamTable.ContainsKey(tname)) { temp = (ArrayList)TeamTable[tname]; temp.Add(minfo); TeamTable[tname] = temp; } else { temp = new ArrayList(); temp.Add(minfo); TeamTable[tname] = temp; } } else { temp = new ArrayList(); temp.Add(minfo); TeamTable[tname] = temp; } } } } logWrite("팀리스트 생성 시작!"); foreach (DictionaryEntry de in TeamTable) { if (de.Value != null) { string teamstr = (string)de.Key; ArrayList temp = (ArrayList)de.Value; foreach (string str in temp) { teamstr += "|" + str; } team_list.Add(TeamString + teamstr); logWrite(TeamString + teamstr); } } logWrite("팀리스트 생성 완료!"); } catch (Exception ex) { logWrite(ex.ToString()); } finally { dr.Close(); } objlist.Add(cl); objlist.Add(team_list); return objlist; }