public static BanHang_ChiPhiChiTietCollection SelectAll()
        {
            var List = new BanHang_ChiPhiChiTietCollection();

            using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblBanHang_ChiPhiChiTiet_Select_SelectAll_linhnx"))
            {
                while (rd.Read())
                {
                    List.Add(getFromReader(rd));
                }
            }
            return(List);
        }
        public static BanHang_ChiPhiChiTietCollection SelectByBHCP(SqlConnection con, Int64 BHCP)
        {
            var List = new BanHang_ChiPhiChiTietCollection();
            var obj  = new SqlParameter[1];

            obj[0] = new SqlParameter("BHCP", BHCP);
            using (IDataReader rd = SqlHelper.ExecuteReader(con, CommandType.StoredProcedure, "sp_tblBanHang_ChiPhiChiTiet_Select_SelectByBHCP_linhnx", obj))
            {
                while (rd.Read())
                {
                    List.Add(getFromReader(rd));
                }
            }
            return(List);
        }