private void icoBtnPrint_Click(object sender, EventArgs e)
        {
            var cmdText = "";
            var unit    = "";

            if (cboLuaChon.SelectedValue.Equals("Month"))
            {
                cmdText = "select MONTH(NgayLap) as Unit, sum(TongTien) as Value From HOA_DON group by(MONTH(NgayLap))";
                unit    = "Tháng";
            }
            if (cboLuaChon.SelectedValue.Equals("Quarter"))
            {
                cmdText = "select datepart(QUARTER,NgayLap) as Unit, sum(TongTien) as Value From HOA_DON group by(datepart(QUARTER,NgayLap))";
                unit    = "Quý";
            }
            if (cboLuaChon.SelectedValue.Equals("Year"))
            {
                cmdText = "select YEAR(NgayLap) as Unit, sum(TongTien) as Value From HOA_DON group by(YEAR(NgayLap))";
                unit    = "Năm";
            }
            DataSet ds = GetData(cmdText);

            ClassReport.ReportDataDoanhThu dt  = new ClassReport.ReportDataDoanhThu();
            FormReport.ReportDoanhThu      Frm = new FormReport.ReportDoanhThu(unit);
            Frm.DataSource = ds.Tables["Data"];
            frmReportViewer Rpv = new frmReportViewer(Frm);

            Rpv.ShowDialog();
        }
Example #2
0
 public frmReportViewer(FormReport.ReportDoanhThu frm)
 {
     InitializeComponent();
     FormDT = frm;
     load();
 }