public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { EmpTrans_REAL_Rpt rpt = new EmpTrans_REAL_Rpt(); rpt.Site = this.Site; return(rpt); }
private void glassButton2_Click(object sender, EventArgs e) { //string sort = ""; //if (radioButton1.Checked) //{ // sort = "Order by [NAME],[Date]"; //} //if (radioButton2.Checked) //{ // sort = "Order by [Card Number],[Transaction Date]"; //} //if (radioButton3.Checked) //{ // sort = "Order by [Transaction Date]"; //} //if (radioButton4.Checked) //{ // sort = "Order by Department,[Card Number],[Transaction Date]"; //} _cmd = new SqlCommand(); _cmd.Connection = frmMainForm._MasterCon; _cmd.CommandType = CommandType.StoredProcedure; _cmd.CommandText = "GET_REAL_TIME"; _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")+"'"; //_cmd.Parameters.Add("@DEP", SqlDbType.VarChar).Value = "'" + cmbDep.SelectedValue.ToString()+"'"; //_cmd.Parameters.Add("@CARD", SqlDbType.VarChar).Value = "'" + cmbEmployee.SelectedValue.ToString()+"'"; //_cmd.Parameters.Add("@LOC", SqlDbType.VarChar).Value = "'Cairo'"; //_cmd.Parameters.Add("@COM", SqlDbType.VarChar).Value = "'PhPC'"; _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"); _cmd.Parameters.Add("@DEP", SqlDbType.VarChar).Value = cmbDep.SelectedValue.ToString(); _cmd.Parameters.Add("@CARD", SqlDbType.VarChar).Value = cmbEmployee.SelectedValue.ToString(); _cmd.Parameters.Add("@LOC", SqlDbType.VarChar).Value = "Cairo"; _cmd.Parameters.Add("@COM", SqlDbType.VarChar).Value = "PhPC"; //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); /*_cmd = new SqlCommand(Str3 + sort, frmMainForm._MasterCon); * //Str = "select [Employee Name] ,[Card Number],[Transaction Date],Time,Place,Job,Department from VTransactions " + FilterString; * _cmd.CommandTimeout = 2000; * _da = new SqlDataAdapter(_cmd); * _Dt = new DataTable(); * _Dt.Reset(); * * _da.Fill(_Dt); */ ////////////////////////////////////////////////////// EmpTrans_REAL_Rpt EmpTransRpt = new EmpTrans_REAL_Rpt(); //EmpTransRptAr EmpTransRptAr = new EmpTransRptAr(); ///////////////////////////////////////////////////////////////////// frmReportViewer2 Viewer = new frmReportViewer2(); if (_Dt.Rows.Count == 0) { MessageBox.Show("Message_No_Records", "", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } ////////////////////////////////////////////////////// EmpTransRpt.Database.Tables["GET_REAL_TIME"].SetDataSource(_Dt); EmpTransRpt.SetParameterValue(EmpTransRpt.Parameter_From.ParameterFieldName, dtpDateFrom.Text); EmpTransRpt.SetParameterValue(EmpTransRpt.Parameter_To.ParameterFieldName, dtpDateTo.Text); Viewer.crystalReportViewer1.ReportSource = EmpTransRpt; Viewer.ShowDialog(); ////////////////////////////////////////////////////// ////////////////////////////////////////////////////// }