//public void get_Reports() //{ // ds = objserver.GetDateset("select * from EfficiencyReports"); // ReportDataSource rds = new ReportDataSource("DataSet1_EfficiencyReports", ds.Tables[0]); // if (ds.Tables[0].Rows.Count > 0) // { // LocalReport lr = null; // DataSet ds1 = new DataSet(); // ReportViewer1.ProcessingMode = ProcessingMode.Local; // lr = ReportViewer1.LocalReport; // lr.ReportPath = "Reports/Efficiency.rdlc"; // ReportViewer1.LocalReport.DataSources.Clear(); // ReportViewer1.LocalReport.DataSources.Add(rds); // ReportViewer1.LocalReport.Refresh(); // } // else // { // LocalReport lr = null; // lr = ReportViewer1.LocalReport; // lr.ReportPath = "Reports/Efficiency.rdlc"; // ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Record Not Found');", true); // ReportViewer1.LocalReport.DataSources.Clear(); // ReportViewer1.LocalReport.DataSources.Add(rds); // ReportViewer1.LocalReport.Refresh(); // } //} //public void Showdatewise() //{ // DBServer db = new DBServer(); // DataSet ds = new DataSet(); // DateTime dt = Convert.ToDateTime(txt_from_date.Value); // db.fromdate = txt_from_date.Value; // db.todate = txt_to_date.Value; // ds = db.ViewAllEfficiencyReportsdatetime(db); // ReportDataSource rds = new ReportDataSource("DataSet1_EfficiencyReports", ds.Tables[0]); // if (ds.Tables[0].Rows.Count > 0) // { // LocalReport lr = null; // DataSet ds1 = new DataSet(); // ReportViewer1.ProcessingMode = ProcessingMode.Local; // lr = ReportViewer1.LocalReport; // lr.ReportPath = "Reports/Efficiency.rdlc"; // ReportViewer1.LocalReport.DataSources.Clear(); // ReportViewer1.LocalReport.DataSources.Add(rds); // ReportViewer1.LocalReport.Refresh(); // } // else // { // LocalReport lr = null; // lr = ReportViewer1.LocalReport; // lr.ReportPath = "Reports/Efficiency.rdlc"; // ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Record Not Found');", true); // ReportViewer1.LocalReport.DataSources.Clear(); // ReportViewer1.LocalReport.DataSources.Add(rds); // ReportViewer1.LocalReport.Refresh(); // } //} ////protected void btn_datewise_Click(object sender, EventArgs e) ////{ //// Showdatewise(); ////} ////protected void btn_viewall_Click(object sender, EventArgs e) ////{ //// get_Reports(); ////} //protected void img_results_Click(object sender, ImageClickEventArgs e) //{ // DBServer db = new DBServer(); // DataSet ds = new DataSet(); // ds = db.ViewAllEfficiency(ddl_partno.Value.ToString(), ddl_operation.Value.ToString(), txt_from_date.Value.ToString(), txt_to_date.Value.ToString()); // ReportDataSource rds = new ReportDataSource("DataSet1_EfficiencyReports", ds.Tables[0]); // if (ds.Tables[0].Rows.Count > 0) // { // LocalReport lr = null; // DataSet ds1 = new DataSet(); // ReportViewer1.ProcessingMode = ProcessingMode.Local; // lr = ReportViewer1.LocalReport; // lr.ReportPath = "Reports/Efficiency.rdlc"; // ReportViewer1.LocalReport.DataSources.Clear(); // ReportViewer1.LocalReport.DataSources.Add(rds); // ReportViewer1.LocalReport.Refresh(); // } // else // { // LocalReport lr = null; // lr = ReportViewer1.LocalReport; // lr.ReportPath = "Reports/Efficiency.rdlc"; // ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Record Not Found');", true); // ReportViewer1.LocalReport.DataSources.Clear(); // ReportViewer1.LocalReport.DataSources.Add(rds); // ReportViewer1.LocalReport.Refresh(); // } //} protected void img_view_Click(object sender, ImageClickEventArgs e) { string partno, operation, type, fromdate, todate, shift; partno = ddl_partno.Value.ToString(); operation = ddl_operation.Value.ToString(); type = ddl_type.Value.ToString(); fromdate = txt_fromdate.Value.ToString(); todate = txt_todate.Value.ToString(); shift = ddl_shift.Value.ToString(); lock (thisLock) { try { if (type == "1") { Response.Redirect("DMTRptFrm.aspx?Type=" + type + "&Partno=" + partno + "&Operation=" + operation + "&fromdate=" + fromdate + "&todate=" + todate + "&Shift=" + shift); } if (type == "2") { DBServer db = new DBServer(); DataSet ds = new DataSet(); ds = db.viewpageloadresulteffiency(partno, operation, fromdate, todate, shift); ReportDataSource rds = new ReportDataSource("DataSet1_EfficiencyReports", ds.Tables[0]); if (ds.Tables[0].Rows.Count > 0) { LocalReport lr = null; DataSet ds1 = new DataSet(); ReportViewer1.ProcessingMode = ProcessingMode.Local; lr = ReportViewer1.LocalReport; lr.ReportPath = "Reports/Efficiency.rdlc"; ReportViewer1.LocalReport.DataSources.Clear(); ReportViewer1.LocalReport.DataSources.Add(rds); ReportViewer1.LocalReport.Refresh(); } else { LocalReport lr = null; lr = ReportViewer1.LocalReport; lr.ReportPath = "Reports/Efficiency.rdlc"; ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Record Not Found');", true); ReportViewer1.LocalReport.DataSources.Clear(); ReportViewer1.LocalReport.DataSources.Add(rds); ReportViewer1.LocalReport.Refresh(); } } } catch (Exception ex) { ExceptionLogging.SendExcepToDB(ex); } if (type == "3") { Response.Redirect("~/QualityGrid/ViewQChart.aspx?Type=" + type + "&Partno=" + partno + "&Operation=" + operation + "&fromdate=" + fromdate + "&todate=" + todate + "&Shift=" + shift); } } }
public void showpageloadresult(string partno, string operation, string fromdate, string todate, string shift) { lock (thisLock) { try { DBServer db = new DBServer(); DataSet ds = new DataSet(); ds = db.viewpageloadresulteffiency(partno, operation, fromdate, todate, shift); ReportDataSource rds = new ReportDataSource("DataSet1_EfficiencyReports", ds.Tables[0]); if (ds.Tables[0].Rows.Count > 0) { LocalReport lr = null; DataSet ds1 = new DataSet(); ReportViewer1.ProcessingMode = ProcessingMode.Local; lr = ReportViewer1.LocalReport; lr.ReportPath = "Reports/Efficiency.rdlc"; ReportViewer1.LocalReport.DataSources.Clear(); ReportViewer1.LocalReport.DataSources.Add(rds); ReportViewer1.LocalReport.Refresh(); } else { LocalReport lr = null; lr = ReportViewer1.LocalReport; lr.ReportPath = "Reports/Efficiency.rdlc"; ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Record Not Found');", true); ReportViewer1.LocalReport.DataSources.Clear(); ReportViewer1.LocalReport.DataSources.Add(rds); ReportViewer1.LocalReport.Refresh(); } } catch (Exception ex) { ExceptionLogging.SendExcepToDB(ex); } } }