protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
//记录页面使用次数
DB.RecordPageUseCount("Quality_TotalIndicator");
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;
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;
break;
}
else
{
day.Selected = false;
}
}
}
else
{
if (newdate)
{
CRVTundishTempRate.ResetReportPartNavigation();
newdate = false;
}
string strCurrentDate = ddlYear.SelectedValue.ToString() + "-" + ddlMonth.SelectedValue.ToString() + "-" + ddlDay.SelectedValue.ToString();
OracleConnection conn = DB.createConn();
OracleDataAdapter da = new OracleDataAdapter();
DataSet ds = new DataSet();
string strSQL = "";
try
{
conn.Open();
strSQL = "Select * from TQ_TOTAL_INDICATOR where LOGTIME = '" + strCurrentDate + "'";
da.SelectCommand = new OracleCommand(strSQL, conn);
da.Fill(ds, "TQ_TOTAL_INDICATOR");
string strFileName = this.Server.MapPath("").ToString() + "\\TotalIndicator.rpt";
rdt.Load(strFileName);
rdt.SetDataSource(ds);
CRVTundishTempRate.ReportSource = rdt;
CRVTundishTempRate.DataBind();
}
catch (Exception ee)
{
string strMessage = ee.Message.ToString();
}
finally
{
ds.Dispose();
conn.Close();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
//记录页面使用次数
DB.RecordPageUseCount("Quality_PlanSteelGradeTeam");
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;
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;
break;
}
else
{
day.Selected = false;
}
}
}
else
{
if (newdate)
{
CRVTundishTempRate.ResetReportPartNavigation();
newdate = false;
}
strCurrentDate = ddlYear.SelectedValue.ToString() + "-" + ddlMonth.SelectedValue.ToString() + "-" + ddlDay.SelectedValue.ToString();
strCurrentDate1 = ddlYear.SelectedValue.ToString() + "-" + ddlMonth.SelectedValue.ToString();
OracleConnection conn = DB.createConn();
OracleDataAdapter da = new OracleDataAdapter();
DataSet ds = new DataSet();
string strSQL = "";
try
{
if (newdate)
{
CRVTundishTempRate.ResetReportPartNavigation();
newdate = false;
}
conn.Open();
string j = Quality.SelectedValue.ToString();
if (j == "0")
{
strSQL = "Select * from TQ_PlanSteelGrade_Team where LOGTIME = '" + strCurrentDate + "' order by Plan_SteelGrade";
da.SelectCommand = new OracleCommand(strSQL, conn);
da.Fill(ds, "TQ_PlanSteelGrade_Team");
rdt.Load(this.Server.MapPath("").ToString() + "\\PlanSteelGradeTeam.rpt");
//rdt.PrintOptions.PrinterName = "Microsoft Office Document Image Writer";
rdt.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.PaperEsheet;
rdt.SetDataSource(ds);
CRVTundishTempRate.ReportSource = rdt;
CRVTundishTempRate.DataBind();
}
else if (j == "1")
{
strSQL = "Select * from TQ_PlanSteelGrade_Info where substr(LOGTIME,1,7) = '" + strCurrentDate1 + "' order by LOGTIME,Team";
da.SelectCommand = new OracleCommand(strSQL, conn);
da.Fill(ds, "TQ_PlanSteelGrade_Info");
rdt.Load(this.Server.MapPath("").ToString() + "\\PlanSteelGradeInfo.rpt");
//rdt.PrintOptions.PrinterName = "Microsoft Office Document Image Writer";
rdt.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.PaperEsheet;
rdt.SetDataSource(ds);
CRVTundishTempRate.ReportSource = rdt;
CRVTundishTempRate.DataBind();
}
else if (j == "2")
{
strSQL = "Select * from TQ_PlanSteelGrade_Ele where LOGTIME = '" + strCurrentDate + "' order by Plan_SteelGrade";
da.SelectCommand = new OracleCommand(strSQL, conn);
da.Fill(ds, "TQ_PlanSteelGrade_Ele");
string strFileName = this.Server.MapPath("").ToString() + "\\PlanSteelGradeEle.rpt ";
rdt.Load(strFileName);
//rdt.PrintOptions.PrinterName = "Microsoft Office Document Image Writer";
rdt.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.PaperEsheet;
rdt.SetDataSource(ds);
CRVTundishTempRate.ReportSource = rdt;
CRVTundishTempRate.DataBind();
}
}
catch (Exception ee)
{
Response.Write(ee.ToString());//"出错");
}
finally
{
ds.Dispose();
conn.Close();
}
}
}