コード例 #1
0
        public static string GetTypeNameByCode(string type)
        {
            var rows = LookupTypeTable.AsEnumerable().Where(p => p.Field <string>("LOOKUP_CODE") == type).ToList();

            if (rows != null && rows.Count() > 0)
            {
                return(rows[0]["LOOKUP_NAME"].ToString());
            }
            return("");
        }
コード例 #2
0
        public static DataTable GetLookupTypesByCode(string code)
        {
            var       rows = LookupTypeTable.AsEnumerable().Where(p => p.Field <string>("APP_CODE") == code);
            DataTable dt   = new DataTable();

            dt.Columns.Add("LOOKUP_CODE");
            dt.Columns.Add("LOOKUP_NAME");
            if (rows != null && rows.Count() > 0)
            {
                foreach (var row in rows)
                {
                    DataRow dr = dt.NewRow();
                    dr["LOOKUP_CODE"] = row["LOOKUP_CODE"];
                    dr["LOOKUP_NAME"] = row["LOOKUP_NAME"];
                    dt.Rows.Add(dr);
                }
            }
            return(dt);
        }