void ShowRPTDetail() { DateTime selected_row_date = Convert.ToDateTime(gridView1.GetFocusedRowCellValue("Ngay_Chungtu")); DateTime dtNgay_Batdau = new DateTime(selected_row_date.Year, selected_row_date.Month, selected_row_date.Day, 0, 0, 0); DateTime dtNgay_Ketthuc = new DateTime(selected_row_date.Year, selected_row_date.Month, selected_row_date.Day, 23, 59, 59); DataSet ds_Collection2 = objReportServices.RptWare_SoQTM_ByKhohanghoa( dtNgay_Batdau, dtNgay_Ketthuc, gridView1.GetFocusedRowCellValue("Ma_Kho_Hanghoa")).ToDataSet(); DataSet ds_Sotien_Ton = objReportServices.RptWare_SoQTM_GetTon(dtNgay_Batdau, dtNgay_Ketthuc).ToDataSet(); Datasets.Ds_RptWare_SoQTM DsRpt = new Ecm.Reports.Datasets.Ds_RptWare_SoQTM(); try { foreach (DataRow row in ds_Collection2.Tables[0].Rows) { DsRpt.Tables[0].ImportRow(row); } } catch (Exception ex) { #if DEBUG MessageBox.Show(ex.Message); #endif } RptWare_SoQTM.xrLblNgay.Text = lblNgay_Batdau.Text + " " + string.Format("{0:dd/MM/yyyy }", dtNgay_Batdau) + " * " + lblNgay_Ketthuc.Text + " " + string.Format("{0:dd/MM/yyyy }", dtNgay_Ketthuc) + " * Khu vực: " + gridView1.GetFocusedRowCellDisplayText("Ma_Kho_Hanghoa"); RptWare_SoQTM.xrcellSotien_Tondk.Text = string.Format("{0:#,#}", ds_Sotien_Ton.Tables[0].Rows[0]["Sotien_Tondk"]); RptWare_SoQTM.xrcel_Sotien_Tonck.Text = string.Format("{0:#,#}", ds_Sotien_Ton.Tables[0].Rows[0]["Sotien_Tonck"]); RptWare_SoQTM.DataSource = DsRpt; RptWare_SoQTM.CreateDocument(); this.printControl1.PrintingSystem = RptWare_SoQTM.PrintingSystem; }
public override bool PerformQuery() { System.Collections.Hashtable hashtableControls = new System.Collections.Hashtable(); hashtableControls.Add(dtNgay_Batdau, lblNgay_Batdau.Text); hashtableControls.Add(dtNgay_Ketthuc, lblNgay_Ketthuc.Text); //hashtableControls.Add(lookUpEditCuahang_Ban, lblCuahang_Ban.Text); if (!GoobizFrame.Windows.MdiUtils.Validator.CheckNullFields(hashtableControls)) { return(false); } if (!GoobizFrame.Windows.MdiUtils.Validator.CheckDate(dtNgay_Batdau, dtNgay_Ketthuc)) { return(false); } XtraReports.Rptware_SoQTM RptWare_SoQTM = new Ecm.Reports.XtraReports.Rptware_SoQTM(); this.Report = RptWare_SoQTM; DataSet ds_Collection = objReportServices.RptWare_SoQTM(dtNgay_Batdau.DateTime, dtNgay_Ketthuc.DateTime, null).ToDataSet(); DataSet ds_Sotien_Ton = objReportServices.RptWare_SoQTM_GetTon(dtNgay_Batdau.DateTime, dtNgay_Ketthuc.DateTime).ToDataSet(); Datasets.Ds_RptWare_SoQTM DsRpt = new Ecm.Reports.Datasets.Ds_RptWare_SoQTM(); try { foreach (DataRow row in ds_Collection.Tables[0].Rows) { DsRpt.Tables[0].ImportRow(row); } } catch (Exception ex) { #if DEBUG MessageBox.Show(ex.Message); #endif } RptWare_SoQTM.xrLblNgay.Text = lblNgay_Batdau.Text + " " + string.Format("{0:dd/MM/yyyy }", dtNgay_Batdau.DateTime) + " " + lblNgay_Ketthuc.Text + " " + string.Format("{0:dd/MM/yyyy }", dtNgay_Ketthuc.DateTime); RptWare_SoQTM.xrcellSotien_Tondk.Text = string.Format("{0:#,#}", ds_Sotien_Ton.Tables[0].Rows[0]["Sotien_Tondk"]); RptWare_SoQTM.xrcel_Sotien_Tonck.Text = string.Format("{0:#,#}", ds_Sotien_Ton.Tables[0].Rows[0]["Sotien_Tonck"]); RptWare_SoQTM.DataSource = DsRpt; RptWare_SoQTM.CreateDocument(); this.printControl1.PrintingSystem = RptWare_SoQTM.PrintingSystem; return(base.PerformQuery()); }