Exemple #1
0
        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);
        }
Exemple #2
0
        /// <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);
        }