/// <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;
}
