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();
}
