示例#1
0
        public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            SummaryRpt rpt = new SummaryRpt();

            rpt.Site = this.Site;
            return(rpt);
        }
示例#2
0
        private void glassButton1_Click(object sender, EventArgs e)
        {
            _cmd                = new SqlCommand();
            _cmd.Connection     = frmMainForm._MasterCon;
            _cmd.CommandType    = CommandType.StoredProcedure;
            _cmd.CommandText    = "GET_NUM_HOURS";
            _cmd.CommandTimeout = 2000;
            _cmd.Parameters.Add("@FROMDATE", SqlDbType.VarChar).Value = dtpDateFrom.Value.ToString("yyyy/MM/dd");
            _cmd.Parameters.Add("@TODATE", SqlDbType.VarChar).Value   = dtpDateTo.Value.ToString("yyyy/MM/dd");
            //Str = "select CARD,NAME,JOB,Department,DATE,[Enter Time],[Exit Time],[WORK HOURS] from VTransaction_IN_OUT_FINAL " + FilterString;
            _da = new SqlDataAdapter(_cmd);
            _Dt = new DataTable();
            _Dt.Reset();
            _da.Fill(_Dt);

            //////////////////////////////////////////////////////


            /////////////////////////////////////////////////////////////////////

            frmReportViewer2 Viewer = new frmReportViewer2();

            //if (_Dt.Rows.Count == 0)
            //{
            //    MessageBox.Show("Message_No_Records", "", MessageBoxButtons.OK, MessageBoxIcon.Information);

            //    return;
            //}
            SummaryRpt Rpt = new SummaryRpt();

            Rpt.Database.Tables["GET_NUM_HOURS;1"].SetDataSource(_Dt);
            Rpt.SetParameterValue(Rpt.Parameter_From.ParameterFieldName, dtpDateFrom.Text);
            Rpt.SetParameterValue(Rpt.Parameter_To.ParameterFieldName, dtpDateTo.Text);
            Rpt.SetParameterValue(Rpt.Parameter_FROMDATE.ParameterFieldName, dtpDateFrom.Value.ToString("yyyy/MM/dd"));
            Rpt.SetParameterValue(Rpt.Parameter_TODATE.ParameterFieldName, dtpDateFrom.Value.ToString("yyyy/MM/dd"));
            Viewer.crystalReportViewer1.ReportSource = Rpt;
            Viewer.ShowDialog();
        }