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