public static List <T_BLK_CS> GetAll() { List <T_BLK_CS> lstCyc = new List <T_BLK_CS>(); var dtCyc = aa.GetDataTable($" select * from T_BLK_CS t ", "dt1"); if (dtCyc != null) { foreach (DataRow row in dtCyc.Rows) { lstCyc.Add(T_BLK_CS.DataRowToModel(row)); } } return(lstCyc); }
/// <summary> /// 得到一个对象实体 /// </summary> public static T_BLK_CS DataRowToModel(DataRow row) { T_BLK_CS model = new T_BLK_CS(); if (row != null) { if (row["F_ID"] != null && row["F_ID"].ToString() != "") { model.F_ID = int.Parse(row["F_ID"].ToString()); } if (row["F_BLKMC"] != null) { model.F_BLKMC = row["F_BLKMC"].ToString(); } if (row["F_BGGS"] != null) { model.F_BGGS = row["F_BGGS"].ToString(); } if (row["F_TABID"] != null) { model.F_TABID = row["F_TABID"].ToString(); } if (row["F_BBLC_FL"] != null) { model.F_BBLC_FL = row["F_BBLC_FL"].ToString(); } if (row["F_BSM"] != null) { model.F_BSM = row["F_BSM"].ToString(); } if (row["F_BLHMC"] != null) { model.F_BLHMC = row["F_BLHMC"].ToString(); } if (row["F_SF"] != null && row["F_SF"].ToString() != "") { model.F_SF = int.Parse(row["F_SF"].ToString()); } if (row["F_ZPS"] != null && row["F_ZPS"].ToString() != "") { model.F_ZPS = int.Parse(row["F_ZPS"].ToString()); } if (row["F_TBSID"] != null && row["F_TBSID"].ToString() != "") { model.F_TBSID = int.Parse(row["F_TBSID"].ToString()); } if (row["F_TBSMC"] != null) { model.F_TBSMC = row["F_TBSMC"].ToString(); } if (row["F_DJBGS"] != null) { model.F_DJBGS = row["F_DJBGS"].ToString(); } if (row["F_BBLX"] != null) { model.F_BBLX = row["F_BBLX"].ToString(); } if (row["F_BLHWS"] != null) { model.F_BLHWS = row["F_BLHWS"].ToString(); } } return(model); }