public static KoreaCodeMapInfo SelectOneYearCode(int year)
{
string condition = string.Format(" where Type = {0} and Name = '{1}'", (int)KoreaCodeMapType.Year, year);
DataTable dt = Select(ETI_KOREA_CODEMAP_TABLE_NAME, new string[] { "*" }, condition);
if (dt == null || dt.Rows.Count == 0)
{
return(null);
}
KoreaCodeMapInfo codeMap = new KoreaCodeMapInfo();
DataRow dr = dt.Rows[0];
codeMap.Name = Convert.ToString(dr["Name"]).Trim();
codeMap.Code = Convert.ToString(dr["Code"]).Trim();
return(codeMap);
}
// public static Hashset
public static List <KoreaCodeMapInfo> SelectCodeMapByType(KoreaCodeMapType codeType)
{
string condition = string.Format(" where Type = '{0}'", (int)codeType);
DataTable dt = Select(ETI_KOREA_CODEMAP_TABLE_NAME, new string[] { "*" }, condition);
if (dt == null || dt.Rows.Count == 0)
{
return(null);
}
List <KoreaCodeMapInfo> codeMap = new List <KoreaCodeMapInfo>();
foreach (DataRow dr in dt.Rows)
{
KoreaCodeMapInfo codeItem = new KoreaCodeMapInfo();
codeItem.Name = Convert.ToString(dr["Name"]).Trim();
codeItem.Code = Convert.ToString(dr["Code"]).Trim();
codeItem.Type = codeType;
codeMap.Add(codeItem);
}
return(codeMap);
}