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

            rpt.Site = this.Site;
            return(rpt);
        }
        public void ScheduleVisitToReport()
        {//GetCustDropingBuysNew()
            FeedIssueScheduleCR cusReport = new FeedIssueScheduleCR();

            try
            {
                DSReportFeedIssue VisitDataSet = db.FeedReqDateReport(_query);//Get report data from GPSCUStemp
                cusReport.SetDataSource(VisitDataSet);
                this.CRFeed.ReportSource = cusReport;

                TextObject yr = (TextObject)cusReport.ReportDefinition.Sections["Section5"].ReportObjects["TxtObjLogUser"];
                yr.Text = "[ Copyright \u00A9 " + DateTime.Now.Year.ToString() + " Delmo IT " + " PD : "
                          + DateTime.Now.ToString("dd/MM/yyyy") + " PT : " + DateTime.Now.ToString("hh:mm:ss tt")
                          + " Com : " + System.Environment.MachineName.ToString() + " UN : "
                          + Settings.Default.LastUser + " ]";
            }
            catch { MessageBox.Show("Error loading with the report...", "Report Error", MessageBoxButtons.OK, MessageBoxIcon.Error); }

            try
            {
                DataTable  table = db.FillReportHeader();
                DataRow    row   = table.Rows[0];
                TextObject heder = (TextObject)cusReport.ReportDefinition.Sections["Section1"].ReportObjects["TxtCRName"];
                heder.Text = row[0].ToString();
                TextObject heder2 = (TextObject)cusReport.ReportDefinition.Sections["Section1"].ReportObjects["TxtCrAddr"];
                heder2.Text = row[1].ToString();
                TextObject heder3 = (TextObject)cusReport.ReportDefinition.Sections["Section1"].ReportObjects["TxtCRTPNo"];
                heder3.Text = "Tel : " + row[2].ToString() + " / Fax : " + row[3].ToString();
                TextObject heder4 = (TextObject)cusReport.ReportDefinition.Sections["Section1"].ReportObjects["TxtCREmailWeb"];
                heder4.Text = "E-Mail : " + row[4].ToString() + " / Web Address : " + row[5].ToString();
                TextObject heder5 = (TextObject)cusReport.ReportDefinition.Sections["Section1"].ReportObjects["TxtHoLine"];
                heder5.Text = "Hot Line : 0774410500 / " + row[2].ToString();

                TextObject week = (TextObject)cusReport.ReportDefinition.Sections["Section1"].ReportObjects["TxtCRWeekName"];
                week.Text = "Week " + _week + " Input";
                TextObject headerTxt = (TextObject)cusReport.ReportDefinition.Sections["Section1"].ReportObjects["VisitHeader"];
                headerTxt.Text = @"Feed Issue Schedule For " + _date + " " + " " + _area + " Area";
            }
            catch
            { MessageBox.Show("Error loading with the report header...", "Report Error", MessageBoxButtons.OK, MessageBoxIcon.Error); }
            this.CRFeed.RefreshReport();
        }