private void LoadMstLocalGroup()
{
try
{
string sql = string.Format(MV.SQL.S_MST_LOCAL_GROUP_INFO);
DataTable dt = new DataTable();
if (MV.DbManager.Fill(sql, dt) < 0)
{
MakeLog(string.Format("[{0}] - {1}", System.Reflection.MethodBase.GetCurrentMethod().Name, string.Format("현장 그룹 정보 로딩실패.")));
MakeLog(string.Format("[{0}] - {1} \n{2}", System.Reflection.MethodBase.GetCurrentMethod().Name, sql, MV.DbManager.GetErrorMsg()));
}
ListLocalGroupInfo.Clear();
foreach (DataRow dr in dt.Rows)
{
LocalGroupInfo info = new LocalGroupInfo();
info.id = dr["ID"].ToString();
info.parent_id = dr["PARENT_ID"].ToString();
info.name = dr["NAME"].ToString();
info.level = dr["LEVEL"].ToString();
info.local_type = dr["LOCAL_TYPE"].ToString();
ListLocalGroupInfo.Add(info);
}
}
catch (Exception ex)
{
MakeLog(string.Format("[{0}] - {1}", System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message.Replace("'", "")));
}
}
public LocalGroupInfo GetLocalGroupInfo(string id)
{
LocalGroupInfo info = null;
if (ListLocalGroupInfo.Count <= 0)
{
return(info);
}
info = ListLocalGroupInfo.Find(p => p.id == id);
return(info);
}
