Exemplo n.º 1
0
        public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            OvertimeDetailsEmpwiseSummary rpt = new OvertimeDetailsEmpwiseSummary();

            rpt.Site = this.Site;
            return(rpt);
        }
        private void btnOTEmpSummary_Click(object sender, EventArgs e)
        {
            DataSet ds          = new DataSet();
            String  strDivision = cmbDivision.SelectedValue.ToString();

            if (chkDivision.Checked)
            {
                strDivision = "%";
            }
            else
            {
                strDivision = cmbDivision.SelectedValue.ToString();
            }
            String strCropTypeOt = "%";
            String strParamCrop  = "All";

            if (chkAllCropsOt.Checked)
            {
                strCropTypeOt = "%";
                strParamCrop  = "All";
            }
            else
            {
                strCropTypeOt = cmbCropTypeOt.SelectedValue.ToString();
                strParamCrop  = FTSSettings.getNameByCode("CropType", Convert.ToInt32(cmbCropTypeOt.SelectedValue.ToString()));
            }

            DateTime Fromdate = Convert.ToDateTime(dtpFromDate.Value.Date.ToShortDateString());
            DateTime Todate   = Convert.ToDateTime(dtpToDate.Value.Date.ToShortDateString());

            ds = myReports.GetOvertimeDetails(strDivision, Fromdate, Todate, strCropTypeOt);
            if (ds.Tables[0].Rows.Count > 0)
            {
                ds.WriteXml("OvertimeDetails1.xml");
                OvertimeDetailsEmpwiseSummary myReportViewe = new OvertimeDetailsEmpwiseSummary();
                myReportViewe.SetDataSource(ds);
                myReportViewe.SetParameterValue("Estate", "Estate:" + myEstate.ListEstates().Rows[0][0].ToString() + " / DivisionID:" + cmbDivision.SelectedValue.ToString());
                myReportViewe.SetParameterValue("Date", "From: " + Fromdate.ToShortDateString() + "  To: " + Todate.ToShortDateString());
                myReportViewe.SetParameterValue("Company Name", FTSPayRollBL.Company.getCompanyName());
                myReportViewe.SetParameterValue("crop", strParamCrop);
                ReportViewer myReportViewer = new ReportViewer();
                myReportViewer.crystalReportViewer1.ReportSource = myReportViewe;
                myReportViewer.Show();
            }
            else
            {
                MessageBox.Show("No Data To Print", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }