Ejemplo n.º 1
0
        public static List <rptHDBanHangDTO> ReportPhieuDatMon(int maHD)
        {
            List <rptHDBanHangDTO> result = new List <rptHDBanHangDTO>();
            string query = "select MaHD,tblTaiKhoan.HoTen,NgayLapHD from tblHDBanHang,tblTaiKhoan where tblHDBanHang.TenTaiKhoan = tblTaiKhoan.TenTaiKhoan AND tblHDBanHang.MaHD = @MaHD";

            SqlParameter[] pars = new SqlParameter[1];
            pars[0] = new SqlParameter("MaHD", maHD);
            DataTable dt = DataProvider.ExecuteSelectQuery(query, pars);

            foreach (DataRow dr in dt.Rows)
            {
                rptHDBanHangDTO rptHDBanHang = new rptHDBanHangDTO();
                rptHDBanHang.MaHD      = Convert.ToInt32(dr["MaHD"]);
                rptHDBanHang.HoTen     = dr["HoTen"].ToString();
                rptHDBanHang.NgayLapHD = Convert.ToDateTime(dr["NgayLapHD"]);
                result.Add(rptHDBanHang);
            }
            return(result);
        }
Ejemplo n.º 2
0
        public static List <rptHDBanHangDTO> ReportLayDSHDBanHang()
        {
            List <rptHDBanHangDTO> result = new List <rptHDBanHangDTO>();
            string query = "select MaHD,tblTaiKhoan.HoTen,NgayLapHD,TongTien,TienCuaKH,TienThua,GhiChu from tblHDBanHang,tblTaiKhoan where tblHDBanHang.TenTaiKhoan = tblTaiKhoan.TenTaiKhoan";

            SqlParameter[] pars = new SqlParameter[0];
            DataTable      dt   = DataProvider.ExecuteSelectQuery(query, pars);

            foreach (DataRow dr in dt.Rows)
            {
                rptHDBanHangDTO rptHDBanHang = new rptHDBanHangDTO();
                rptHDBanHang.MaHD      = Convert.ToInt32(dr["MaHD"]);
                rptHDBanHang.HoTen     = dr["HoTen"].ToString();
                rptHDBanHang.NgayLapHD = Convert.ToDateTime(dr["NgayLapHD"]);
                rptHDBanHang.TongTien  = Convert.ToInt32(dr["TongTien"]);
                rptHDBanHang.TienCuaKH = Convert.ToInt32(dr["TienCuaKH"]);
                rptHDBanHang.TienThua  = Convert.ToInt32(dr["TienThua"]);
                rptHDBanHang.GhiChu    = dr["GhiChu"].ToString();
                result.Add(rptHDBanHang);
            }
            return(result);
        }