private void InThongKeCR_Load(object sender, EventArgs e)
{
if (data != null)
{
if (nhapkhau)
{
ThongKeNhap rpt = new ThongKeNhap();
rpt.SetDataSource(data);
rpt.SetParameterValue("NhanVienTruc", user.Field <string>("HOTEN"));
rpt.SetParameterValue("NgayBatDau", begin);
rpt.SetParameterValue("NgayKetThuc", end);
rpt.SetParameterValue("TongTien", 0);
crystalReportViewer1.ReportSource = rpt;
crystalReportViewer1.Refresh();
}
else
{
ThongKeXuat rpt = new ThongKeXuat();
rpt.SetDataSource(data);
rpt.SetParameterValue("NhanVienTruc", user.Field <string>("HOTEN"));
rpt.SetParameterValue("NgayBatDau", begin);
rpt.SetParameterValue("NgayKetThuc", end);
rpt.SetParameterValue("TongTien", 0);
crystalReportViewer1.ReportSource = rpt;
crystalReportViewer1.Refresh();
}
}
}
public List <ThongKeNhap> getThongKeNhap(DateTime d1, DateTime d2)
{
List <ThongKeNhap> ls = new List <ThongKeNhap>();
string query = String.Format("EXEC dbo.PB_ThongKeNhap @frist = '{0}',@second = '{1}'", d1.ToString("yyyy-MM-dd"), d2.ToString("yyyy-MM-dd"));
// string query = "EXEC dbo.PB_getThongKeTiem @first = '2020-01-21',@sencond = '2020-04-21'";
DataTable data = DataProvider.Instance.ExcuteQuery(query);
foreach (DataRow item in data.Rows)
{
ThongKeNhap tk = new ThongKeNhap(item);
ls.Add(tk);
}
return(ls);
}