//------
        public static List <GiaGiayTonBDO> LayTatCa()
        {
            var parameters = new Dictionary <string, object>();

            var tblGIAY_IN_RUOT = CalcDbExecutor.ExecuteQuery("SELECT * FROM GIA_GIAY_TON");

            List <GiaGiayTonBDO> lst = new List <GiaGiayTonBDO>();

            foreach (DataRow row in tblGIAY_IN_RUOT.Rows)
            {
                lst.Add(new GiaGiayTonBDO
                {
                    MA_GIAY          = (string)row["MA_GIAY"],
                    TEN_GIAY         = (string)row["TEN_GIAY"],
                    GIA_GIAY_TON_KHO = (int)row["GIA_GIAY_TON_KHO"],
                    MUC_LOI_NHUAN    = (int)row["MUC_LOI_NHUAN"]
                });
            }

            return(lst);
        }
Example #2
0
        //========
        public static List <ToInDigiBDO> LayTatCa()
        {
            var parameters = new Dictionary <string, object>();

            var tblGIAY_IN_RUOT = CalcDbExecutor.ExecuteQuery("SELECT * FROM TO_IN_DIGI");

            List <ToInDigiBDO> lst = new List <ToInDigiBDO>();

            foreach (DataRow row in tblGIAY_IN_RUOT.Rows)
            {
                lst.Add(new ToInDigiBDO
                {
                    MA_TO_IN           = (string)row["MA_TO_IN"],
                    TEN_TO_IN          = (string)row["TEN_TO_IN"],
                    BHR                = (int)row["BHR"],
                    THOI_GIAN_CHUAN_BI = (int)row["THOI_GIAN_CHUAN_BI"],
                    TOC_DO             = (int)row["TOC_DO"],
                    PHI_CLICK          = (int)row["PHI_CLICK"]
                });
            }

            return(lst);
        }