예제 #1
0
        public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            FieldWiseCheckRollWages rpt = new FieldWiseCheckRollWages();

            rpt.Site = this.Site;
            return(rpt);
        }
예제 #2
0
        private void button1_Click(object sender, EventArgs e)
        {
            String strFieldCategory = "";

            if (cmbFieldType.SelectedValue.ToString() == "C")
            {
                strFieldCategory = "Capital Fields";
            }
            else if (cmbFieldType.SelectedValue.ToString() == "O")
            {
                strFieldCategory = "Other Fields";
            }
            else if (cmbFieldType.SelectedValue.ToString() == "R")
            {
                strFieldCategory = "Revenue Fields";
            }

            DataTable dt1 = new DataTable();
            DataSet   ds  = new DataSet();

            DataTable dt = myYear.getOpenCloseDates(Convert.ToInt32(cmbMonth.SelectedValue.ToString()), Convert.ToInt32(cmbYear.SelectedValue.ToString()));

            dt1 = myWage.FieldWiseCheckrollWages(Convert.ToDateTime(dt.Rows[0][0].ToString()), Convert.ToDateTime(dt.Rows[0][1].ToString()), cmbFieldType.SelectedValue.ToString());
            ds.Tables.Add(dt1);

            if (dt1.Rows.Count > 0)
            {
                ds.WriteXml("FieldWiseCheckrollWages.xml");
                FieldWiseCheckRollWages myReport = new FieldWiseCheckRollWages();
                myReport.SetDataSource(ds);

                ReportViewer myViewer = new ReportViewer();
                myReport.SetParameterValue("Company", FTSPayRollBL.Company.getCompanyName());
                myReport.SetParameterValue("Estate", "Estate : " + FTSPayRollBL.User.StrEstate);
                myReport.SetParameterValue("FieldType", "Field : " + strFieldCategory);
                myReport.SetParameterValue("Date", "Month of : " + cmbMonth.Text + " / " + cmbYear.Text);
                myViewer.crystalReportViewer1.ReportSource = myReport;
                myViewer.Show();
            }
            else
            {
                MessageBox.Show("No Data to Preview..!");
            }
        }