public static rptCTHDBanHangDTO ReportLaySoLuongCTHDBH(int maHD) { rptCTHDBanHangDTO result = null; string query = "select MaHD,SUM(SoLuong)AS TongSoLuong from tblCTHDBanHang where MaHD = @MaHD group by MaHD"; SqlParameter[] pars = new SqlParameter[1]; pars[0] = new SqlParameter("@MaHD", maHD); DataTable dt = DataProvider.ExecuteSelectQuery(query, pars); foreach (DataRow dr in dt.Rows) { rptCTHDBanHangDTO rptCTHDBanHang = new rptCTHDBanHangDTO(); rptCTHDBanHang.MaHD = Convert.ToInt32(dr["MaHD"]); rptCTHDBanHang.TongSoLuong = Convert.ToInt32(dr["TongSoLuong"]); result = (rptCTHDBanHang); } return(result); }
public static List <rptCTHDBanHangDTO> ReportSubPhieuDatMon(int maHD) { List <rptCTHDBanHangDTO> result = new List <rptCTHDBanHangDTO>(); string query = "select tblCTHDBanHang.MaHD, tblMonAn.TenMon,tblCTHDBanHang.GhiChu, SoLuong from tblCTHDBanHang,tblMonAn, tblHDBanHang where tblCTHDBanHang.MaMon = tblMonAn.MaMon AND tblCTHDBanHang.MaHD= tblHDBanHang.MaHD AND tblCTHDBanHang.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) { rptCTHDBanHangDTO rptCTHDBanHang = new rptCTHDBanHangDTO(); rptCTHDBanHang.MaHD = Convert.ToInt32(dr["MaHD"]); rptCTHDBanHang.TenMon = dr["TenMon"].ToString(); rptCTHDBanHang.GhiChu = dr["GhiChu"].ToString(); rptCTHDBanHang.SoLuong = Convert.ToInt32(dr["SoLuong"]); result.Add(rptCTHDBanHang); } return(result); }
public void HienHDBanHang(int maHD) { List <rptHDBanHangDTO> lsHDBanHang = rptHDBanHangBUS.ReportLayHDBanHang(maHD); string tienMat = ""; string tienThua = ""; rpvBaoCao.LocalReport.ReportEmbeddedResource = s + "rptHDBanHang.rdlc"; rptCTHDBanHangDTO rptCTHD = rptCTHDBanHangBUS.ReportLaySoLuongCTHDBH(maHD); rpvBaoCao.LocalReport.SetParameters(new ReportParameter("paSoLuong", rptCTHD.TongSoLuong.ToString())); frmBanHang frmBH = new frmBanHang(); if (!string.IsNullOrEmpty(_tienMat) && !string.IsNullOrEmpty(_tienThua)) { tienMat = String.Format("{0:#,##0 VND}", _tienMat); tienThua = _tienThua; } rpvBaoCao.LocalReport.SetParameters(new ReportParameter("paTienMat", tienMat)); rpvBaoCao.LocalReport.SetParameters(new ReportParameter("paTienThua", tienThua)); rpvBaoCao.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(LocalReport_SubreportProcessing3); rpvBaoCao.LocalReport.DataSources.Add(new ReportDataSource("DSHDBanHang", lsHDBanHang)); rpvBaoCao.RefreshReport(); }