protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { //记录页面使用次数 //DB.RecordPageUseCount("Plant_PageUseCount"); OracleConnection conn = DB.createConn(); try { OracleDataAdapter da = new OracleDataAdapter(); if (newdate) { CrystalReportViewer1.ResetReportPartNavigation(); newdate = false; } conn.Open(); DataSet ds = new DataSet(); string strSQL = "Select * from PAGE_USE_COUNT ORDER BY PAGE_NAME"; da.SelectCommand = new OracleCommand(strSQL, conn); da.Fill(ds, "PAGE_USE_COUNT"); rdt.Load(this.Server.MapPath("").ToString() + "\\PageUseCount.rpt"); rdt.SetDataSource(ds); CrystalReportViewer1.ReportSource = rdt; CrystalReportViewer1.DataBind(); ds.Dispose(); } catch (Exception ee) { Response.Write(ee.ToString());//"出错"); } finally { conn.Close(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { //记录页面使用次数 DB.RecordPageUseCount("Quality_frmPlantDaily"); date1 = "1910-01"; newdate = false; int CurrentYear = Convert.ToInt32(DateTime.Now.Year); int i; for (i = CurrentYear - 5; i <= CurrentYear; i++) { ListItem Year = new ListItem(); Year.Text = Convert.ToString(i); Year.Value = Convert.ToString(i); if (i == CurrentYear) { Year.Selected = true; } else { Year.Selected = false; } ddlYear.Items.Add(Year); //EndYear.Items.Add(Year); } string CurrentDate = Convert.ToString(DateTime.Now.Month); if (CurrentDate.Length == 1) { CurrentDate = "0" + CurrentDate; } foreach (ListItem Month in ddlMonth.Items) { if (Month.Text == CurrentDate) { Month.Selected = true; ddlMonth.Text = Month.Text; //EndMonth.Text = Month.Text; break; } else { Month.Selected = false; } } AddDate(sender, e); CurrentDate = Convert.ToString(DateTime.Now.Day); if (CurrentDate.Length == 1) { CurrentDate = "0" + CurrentDate; } foreach (ListItem day in ddlDay.Items) { if (day.Text == CurrentDate) { day.Selected = true; ddlDay.Text = day.Text; //EndDay.Text = day.Text; break; } else { day.Selected = false; } } } else { date1 = ddlYear.SelectedValue.ToString() + '-' + ddlMonth.SelectedValue.ToString() + '-' + ddlDay.SelectedValue.ToString(); string strCurrentDate = date1; OracleConnection conn = DB.createConn(); try { OracleDataAdapter da = new OracleDataAdapter(); if (newdate) { CrystalReportViewer1.ResetReportPartNavigation(); newdate = false; } conn.Open(); string strSQL = "Select * from TQ_LF_INDICATOR where LOGTIME = '" + strCurrentDate + "' order by Team"; da.SelectCommand = new OracleCommand(strSQL, conn); DataSet ds = new DataSet(); da.Fill(ds, "TQ_LF_INDICATOR"); strSQL = "Select * from TQ_BOF_VARSTEEL_INDICATOR where LOGTIME = '" + strCurrentDate + "'order by Team"; da.SelectCommand = new OracleCommand(strSQL, conn); da.Fill(ds, "TQ_BOF_VARSTEEL_INDICATOR"); strSQL = "Select * from TQ_RH_INDICATOR where LOGTIME = '" + strCurrentDate + "' order by Team"; da.SelectCommand = new OracleCommand(strSQL, conn); da.Fill(ds, "TQ_RH_INDICATOR"); rdt.Load(this.Server.MapPath("").ToString() + "\\rptPlantDaily.rpt"); //rdt.PrintOptions.PrinterName = "Microsoft Office Document Image Writer"; rdt.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.PaperEsheet; rdt.SetDataSource(ds); CrystalReportViewer1.ReportSource = rdt; CrystalReportViewer1.DataBind(); ds.Dispose(); } catch (Exception ee) { Response.Write(ee.ToString());//"出错"); } finally { conn.Close(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { //记录页面使用次数 DB.RecordPageUseCount("BOF_Iron_Weight"); date1 = "1910-01"; newdate = false; int CurrentYear = Convert.ToInt32(DateTime.Now.Year); int i; for (i = CurrentYear - 5; i <= CurrentYear; i++) { ListItem Year = new ListItem(); Year.Text = Convert.ToString(i); Year.Value = Convert.ToString(i); if (i == CurrentYear) { Year.Selected = true; } else { Year.Selected = false; } ddlYear.Items.Add(Year); } string CurrentDate = Convert.ToString(DateTime.Now.Month); if (CurrentDate.Length == 1) { CurrentDate = "0" + CurrentDate; } foreach (ListItem Month in ddlMonth.Items) { if (Month.Text == CurrentDate) { Month.Selected = true; ddlMonth.Text = Month.Text; //EndMonth.Text = Month.Text; break; } else { Month.Selected = false; } } } else { strCurrentDate = ddlYear.SelectedValue.ToString() + '-' + ddlMonth.SelectedValue.ToString(); OracleConnection conn = DB.createConn(); OracleDataAdapter da = new OracleDataAdapter(); DataSet ds = new DataSet(); string strSQL = ""; try { if (newdate) { CrystalReportViewer1.ResetReportPartNavigation(); newdate = false; } conn.Open(); string j = Quality.SelectedValue.ToString(); if (j == "0") { strSQL = "Select * from TS_IN_IRON_ELE_WEIGHT where substr(LOGTIME,1,7) = '" + strCurrentDate + "' order by LOGTIME"; da.SelectCommand = new OracleCommand(strSQL, conn); da.Fill(ds, "TS_IN_IRON_ELE_WEIGHT"); strSQL = "Select * from VIEW_TS_IN_IRON_WEIGHT where LOGTIME = '" + strCurrentDate + "' order by LOGTIME "; da.SelectCommand = new OracleCommand(strSQL, conn); da.Fill(ds, "VIEW_TS_IN_IRON_WEIGHT"); rdt.Load(this.Server.MapPath("").ToString() + "\\Iron_In_Weight.rpt"); //rdt.PrintOptions.PrinterName = "Microsoft Office Document Image Writer"; rdt.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.PaperA4; rdt.SetDataSource(ds); CrystalReportViewer1.ReportSource = rdt; CrystalReportViewer1.DataBind(); } else { strSQL = "Select * from TS_OutIron where substr(LOGTIME,1,7) = '" + strCurrentDate + "' order by LogTime,Shift"; da.SelectCommand = new OracleCommand(strSQL, conn); da.Fill(ds, "TS_OutIron"); rdt.Load(this.Server.MapPath("").ToString() + "\\\\OutIron.rpt"); //rdt.PrintOptions.PrinterName = "Microsoft Office Document Image Writer"; rdt.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.PaperA3; rdt.SetDataSource(ds); CrystalReportViewer1.ReportSource = rdt; CrystalReportViewer1.DataBind(); } } catch (Exception ee) { Response.Write(ee.ToString());//"出错"); } finally { ds.Dispose(); conn.Close(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { //记录页面使用次数 //DB.RecordPageUseCount("Plant_TEST_AUGUST1ST"); date1 = "1910-01"; newdate = false; int CurrentYear = Convert.ToInt32(DateTime.Now.Year); int i; for (i = CurrentYear - 5; i <= CurrentYear; i++) { ListItem Year = new ListItem(); Year.Text = Convert.ToString(i); Year.Value = Convert.ToString(i); if (i == CurrentYear) { Year.Selected = true; } else { Year.Selected = false; } ddlYear.Items.Add(Year); //EndYear.Items.Add(Year); } string CurrentDate = Convert.ToString(DateTime.Now.Month); if (CurrentDate.Length == 1) { CurrentDate = "0" + CurrentDate; } foreach (ListItem Month in ddlMonth.Items) { if (Month.Text == CurrentDate) { Month.Selected = true; ddlMonth.Text = Month.Text; //EndMonth.Text = Month.Text; break; } else { Month.Selected = false; } } AddDate(sender, e); CurrentDate = Convert.ToString(DateTime.Now.Day); if (CurrentDate.Length == 1) { CurrentDate = "0" + CurrentDate; } foreach (ListItem day in ddlDay.Items) { if (day.Text == CurrentDate) { day.Selected = true; ddlDay.Text = day.Text; //EndDay.Text = day.Text; break; } else { day.Selected = false; } } } else { date1 = ddlYear.SelectedValue.ToString() + '-' + ddlMonth.SelectedValue.ToString() + '-' + ddlDay.SelectedValue.ToString(); string strCurrentDate = date1; OracleConnection conn = DB.createConn(); try { OracleDataAdapter da = new OracleDataAdapter(); if (newdate) { CrystalReportViewer1.ResetReportPartNavigation(); newdate = false; } conn.Open(); DataSet ds = new DataSet(); string strSQL = "Select * from TP_ALLOY_COST where LOGTIME='" + strCurrentDate + "'and MONTH_FLAG=" + ddalloy_cost.SelectedValue + " ORDER BY shift,team,bofid, steelgrade_type ,steelgrade,alloy_order"; da.SelectCommand = new OracleCommand(strSQL, conn); da.Fill(ds, "TP_ALLOY_COST"); rdt.Load(this.Server.MapPath("").ToString() + "\\alloy_cost.rpt"); rdt.SetDataSource(ds); CrystalReportViewer1.ReportSource = rdt; CrystalReportViewer1.DataBind(); ds.Dispose(); } catch (Exception ee) { Response.Write(ee.ToString());//"出错"); } finally { conn.Close(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { //记录页面使用次数 DB.RecordPageUseCount("BOF_Cost_Ladle"); date1 = "1910-01"; newdate = false; int CurrentYear = Convert.ToInt32(DateTime.Now.Year); int i; for (i = CurrentYear - 5; i <= CurrentYear; i++) { ListItem Year = new ListItem(); Year.Text = Convert.ToString(i); Year.Value = Convert.ToString(i); if (i == CurrentYear) { Year.Selected = true; } else { Year.Selected = false; } ddlYear.Items.Add(Year); //EndYear.Items.Add(Year); } string CurrentDate = Convert.ToString(DateTime.Now.Month); if (CurrentDate.Length == 1) { CurrentDate = "0" + CurrentDate; } foreach (ListItem Month in ddlMonth.Items) { if (Month.Text == CurrentDate) { Month.Selected = true; ddlMonth.Text = Month.Text; //EndMonth.Text = Month.Text; break; } else { Month.Selected = false; } } AddDate(sender, e); CurrentDate = Convert.ToString(DateTime.Now.Day); if (CurrentDate.Length == 1) { CurrentDate = "0" + CurrentDate; } foreach (ListItem day in ddlDay.Items) { if (day.Text == CurrentDate) { day.Selected = true; ddlDay.Text = day.Text; //EndDay.Text = day.Text; break; } else { day.Selected = false; } } } else { date1 = ddlYear.SelectedValue.ToString() + '-' + ddlMonth.SelectedValue.ToString() + '-' + ddlDay.SelectedValue.ToString(); string strCurrentDate = date1; int iLadleType = Convert.ToInt16(ddlLadleType.SelectedValue); int iPriceType = Convert.ToInt16(ddlPriceType.SelectedValue); OracleConnection conn = DB.createConn(); try { OracleDataAdapter da = new OracleDataAdapter(); if (newdate) { CrystalReportViewer1.ResetReportPartNavigation(); newdate = false; } conn.Open(); DataSet ds = new DataSet(); string strSQL = "Select * from TS_COST_LADLE where LOGTIME = '" + strCurrentDate + "' and LADLETYPE = " + iLadleType + " order by logtime"; da.SelectCommand = new OracleCommand(strSQL, conn); da.Fill(ds, "TS_COST_LADLE"); //报表类型 string strRptRoute = ""; string strRptDisplay = ""; if (iLadleType == 1) { strRptDisplay = "常规钢包"; } if (iLadleType == 2) { strRptDisplay = "50T精练钢包"; } if (iLadleType == 3) { strRptDisplay = "80T精练钢包"; } if (iPriceType == 1) { strRptRoute = "Cost_Ladle_N.rpt"; strRptDisplay += "最新成本"; } if (iPriceType == 2) { strRptRoute = "Cost_Ladle_M.rpt"; strRptDisplay += "月成本"; } if (iPriceType == 3) { strRptRoute = "Cost_Ladle_Y.rpt"; strRptDisplay += "年成本"; } rdt.Load(this.Server.MapPath("").ToString() + "\\\\" + strRptRoute); rdt.SetDataSource(ds); CrystalReportViewer1.ReportSource = rdt; CrystalReportViewer1.DataBind(); rdt.SetParameterValue("LadleName_New", strRptDisplay); ds.Dispose(); } catch (Exception ee) { Response.Write(ee.ToString());//"出错"); } finally { conn.Close(); } } }