//设置报表
private void SetReport(String type)
{
this.ReportView1.ServerUrl = this.ReportURL;
ReportView1.Parameters = Acctrue.WM_WES.ReportingServices.ReportView.multiState.False;
ReportView1.DocMap = Acctrue.WM_WES.ReportingServices.ReportView.multiState.False;
ReportView1.Toolbar = Acctrue.WM_WES.ReportingServices.ReportView.multiState.True;
if (type == "0")
{
this.ReportView1.Visible = false;
string strPath = Server.MapPath("Reports");
DataSet ds = KCJG.GetZCMX(Request["FYDH"]);
DataSet ds2 = KCJG.GetZCMX2(Request["FYDH"]);
DataSet ds3 = KCJG.GetZCMX3(Request["FYDH"]);
DataSet ds4 = KCJG.GetGHXX(Request["FYDH"]);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0 && ds2 != null && ds2.Tables.Count > 0 && ds2.Tables[0].Rows.Count > 0 && ds3 != null && ds3.Tables.Count > 0 && ds3.Tables[0].Rows.Count > 0 && ds4 != null && ds4.Tables.Count > 0 && ds4.Tables[0].Rows.Count > 0)
{
this.ReportViewer1.LocalReport.ReportPath = strPath + "\\FYDList.rdlc";
ReportDataSource rds = new ReportDataSource("ZCMXDataSet_WMS_Bms_Inv_OutInfo", ds.Tables[0]);
ReportDataSource rds1 = new ReportDataSource("ZCMXDataSet_ghxx", ds4.Tables[0]);
ReportParameter rp = new ReportParameter("FYDH", Request["FYDH"]);
ReportParameter rp2 = new ReportParameter("CX", ds3.Tables[0].Rows[0]["cx"].ToString());
ReportParameter rp3 = new ReportParameter("CH", ds3.Tables[0].Rows[0]["cph"].ToString());
ReportParameter rp4 = new ReportParameter("CZY", ds2.Tables[0].Rows[0]["czy"].ToString());
ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp });
ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp2 });
ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp3 });
ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp4 });
ReportViewer1.LocalReport.DataSources.Add(rds);
ReportViewer1.LocalReport.DataSources.Add(rds1);
}
else
{
this.PrintfError("无任何数据！");
}
}
if (type == "1")
{
if (Common.IsOldData)
{
this.ReportView1.ReportPath = "/XGReportO/FYDRList";
}
else
{
this.ReportView1.ReportPath = "/XGReportC/FYDRList";
}
if (!string.IsNullOrEmpty(Request["FYDH"]))
{
ReportView1.SetParameter("FYDH", Request["FYDH"]);
}
if (!string.IsNullOrEmpty(Request["CK"]))
{
ReportView1.SetParameter("CK", Request["CK"]);
}
if (!string.IsNullOrEmpty(Request["KHH"]))
{
ReportView1.SetParameter("KHBM", Request["KHH"]);
}
if (!string.IsNullOrEmpty(Request["CPH"]))
{
ReportView1.SetParameter("CPH", Server.UrlEncode(Request["CPH"]));
}
if (!string.IsNullOrEmpty(Request["WLH"]))
{
ReportView1.SetParameter("WLH", Request["WLH"]);
}
if (!string.IsNullOrEmpty(Request["SX"]))
{
ReportView1.SetParameter("SX", Server.UrlEncode(Request["SX"]));
}
if (!string.IsNullOrEmpty(Request["TSXX"]))
{
ReportView1.SetParameter("pcinfo", Server.UrlEncode(Request["TSXX"]));
}
if (!string.IsNullOrEmpty(Request["PC"]))
{
ReportView1.SetParameter("PCH", Request["PC"]);
}
if (!string.IsNullOrEmpty(Request["PH"]))
{
ReportView1.SetParameter("PH", Request["PH"]);
}
if (!string.IsNullOrEmpty(Request["JMKH"]))
{
ReportView1.SetParameter("INDOORID", Request["JMKH"]);
}
if (!string.IsNullOrEmpty(Request["CMKH"]))
{
ReportView1.SetParameter("OUTDOORID", Request["CMKH"]);
}
if (!string.IsNullOrEmpty(Request["MIGG"]))
{
ReportView1.SetParameter("MIGG", Server.UrlEncode(Request["MIGG"]));
}
if (!string.IsNullOrEmpty(Request["MAGG"]))
{
ReportView1.SetParameter("MAGG", Server.UrlEncode(Request["MAGG"]));
}
if (!string.IsNullOrEmpty(Request["GG"]))
{
ReportView1.SetParameter("GG", Server.UrlEncode(Request["GG"]));
}
if (!string.IsNullOrEmpty(Request["YSLB"]))
{
ReportView1.SetParameter("YSLB", Request["YSLB"]);
}
if (!string.IsNullOrEmpty(Request["ZDR"]))
{
ReportView1.SetParameter("NCZDRY", Server.UrlEncode(Request["ZDR"]));
}
if (!string.IsNullOrEmpty(Request["BM"]))
{
ReportView1.SetParameter("NCBM", Request["BM"]);
}
if (!string.IsNullOrEmpty(Request["BM"]))
{
ReportView1.SetParameter("NCBM", Request["BM"]);
}
if (!string.IsNullOrEmpty(Request["STATUS"]))
{
ReportView1.SetParameter("STATUS", Request["STATUS"]);
}
if (!string.IsNullOrEmpty(Request["CSTATUS"]))
{
ReportView1.SetParameter("CSTATUS", Request["CSTATUS"]);
}
if (!string.IsNullOrEmpty(Request["ADD"]))
{
ReportView1.SetParameter("AimAdress", Server.UrlEncode(Request["ADD"]));
}
if (!string.IsNullOrEmpty(Request["SNCZDRQ"]))
{
ReportView1.SetParameter("SNCZDRQ", Request["SNCZDRQ"]);
}
if (!string.IsNullOrEmpty(Request["ENCZDRQ"]))
{
ReportView1.SetParameter("ENCZDRQ", Request["ENCZDRQ"]);
}
if (!string.IsNullOrEmpty(Request["SCKRQ"]))
{
ReportView1.SetParameter("SCKRQ", Request["SCKRQ"]);
}
if (!string.IsNullOrEmpty(Request["ECKRQ"]))
{
ReportView1.SetParameter("ECKRQ", Request["ECKRQ"]);
}
if (!string.IsNullOrEmpty(Request["SCZ_OTTime"]))
{
ReportView1.SetParameter("SCZ_OTTime", Request["SCZ_OTTime"]);
}
if (!string.IsNullOrEmpty(Request["ECZ_OTTime"]))
{
ReportView1.SetParameter("ECZ_OTTime", Request["ECZ_OTTime"]);
}
if (!string.IsNullOrEmpty(Request["SCZ_INTime"]))
{
ReportView1.SetParameter("SCZ_INTime", Request["SCZ_INTime"]);
}
if (!string.IsNullOrEmpty(Request["ECZ_INTime"]))
{
ReportView1.SetParameter("ECZ_INTime", Request["ECZ_INTime"]);
}
if (!string.IsNullOrEmpty(Request["sjsl"]))
{
ReportView1.SetParameter("sjsl", Request["sjsl"]);
}
}
if (type == "2")
{
this.ReportView1.Visible = false;
string strPath = Server.MapPath("Reports");
DataSet ds = KCJG.GetDJMX(Request["FYDH"]);
DataSet ds2 = KCJG.GetZCMX2(Request["FYDH"]);
DataSet ds3 = KCJG.GetZCMX3(Request["FYDH"]);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0 && ds2 != null && ds2.Tables.Count > 0 && ds2.Tables[0].Rows.Count > 0 && ds3 != null && ds3.Tables.Count > 0 && ds3.Tables[0].Rows.Count > 0)
{
this.ReportViewer1.LocalReport.ReportPath = strPath + "\\FYDDetails.rdlc";
ReportDataSource rds = new ReportDataSource("ZCMXDataSet_WMS_Bms_Inv_OutInfo", ds.Tables[0]);
ReportParameter rp = new ReportParameter("FYDH", Request["FYDH"]);
ReportParameter rp2 = new ReportParameter("CX", ds3.Tables[0].Rows[0]["cx"].ToString());
ReportParameter rp3 = new ReportParameter("CH", ds3.Tables[0].Rows[0]["cph"].ToString());
ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp });
ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp2 });
ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp3 });
ReportViewer1.LocalReport.DataSources.Add(rds);
}
else
{
this.PrintfError("无任何数据！");
}
}
if (type == "3")
{
this.ReportView1.Visible = false;
string strPath = Server.MapPath("Reports");
DataSet ds = KCJG.GetZCMX(Request["FYDH"]);
DataSet ds1 = KCJG.GetZCMX1(Request["FYDH"]);
DataSet ds2 = KCJG.GetZCMX2(Request["FYDH"]);
DataSet ds3 = KCJG.GetZCMX3(Request["FYDH"]);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0 && ds1 != null && ds1.Tables.Count > 0 && ds1.Tables[0].Rows.Count > 0 && ds2 != null && ds2.Tables.Count > 0 && ds2.Tables[0].Rows.Count > 0 && ds3 != null && ds3.Tables.Count > 0 && ds3.Tables[0].Rows.Count > 0)
{
this.ReportViewer1.LocalReport.ReportPath = strPath + "\\ZCMXReport.rdlc";
ReportDataSource rds = new ReportDataSource("ZCMXDataSet_WMS_Bms_Inv_OutInfo", ds.Tables[0]);
ReportDataSource rds1 = new ReportDataSource("ZCMXDataSet_v_fyd_details", ds1.Tables[0]);
ReportDataSource rds2 = new ReportDataSource("ZCMXDataSet_bwxx", ds2.Tables[0]);
ReportDataSource rds3 = new ReportDataSource("ZCMXDataSet_byxx", ds3.Tables[0]);
ReportParameter rp = new ReportParameter("fydh", Request["FYDH"]);
ReportParameter rp1 = new ReportParameter("khname", ds3.Tables[0].Rows[0]["khname"].ToString());
ReportParameter rp2 = new ReportParameter("cx", ds3.Tables[0].Rows[0]["cx"].ToString());
ReportParameter rp3 = new ReportParameter("ch", ds3.Tables[0].Rows[0]["cph"].ToString());
ReportParameter rp4 = new ReportParameter("czy", ds2.Tables[0].Rows[0]["czy"].ToString());
ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp });
ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp1 });
ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp2 });
ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp3 });
ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp4 });
ReportViewer1.LocalReport.DataSources.Add(rds1);
ReportViewer1.LocalReport.DataSources.Add(rds);
ReportViewer1.LocalReport.DataSources.Add(rds2);
ReportViewer1.LocalReport.DataSources.Add(rds3);
}
else
{
this.PrintfError("无任何数据！");
}
}
if (!string.IsNullOrEmpty(Request["ISWGDH"]))
{
ReportView1.SetParameter("ISWGDH", "true");
}
}
protected void drpType_SelectedIndexChanged(object sender, EventArgs e)
{
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.Reset();
if (this.drpType.SelectedIndex != 0)
{
string strPath = Server.MapPath("Reports");
if (this.drpType.SelectedIndex == 1)
{
DataSet ds = KCJG.GetXSP();
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
this.ReportViewer1.LocalReport.ReportPath = strPath + "\\SpReport.rdlc";
ReportDataSource rds = new ReportDataSource("SpDataSet_SpData", ds.Tables[0]);
ReportViewer1.LocalReport.DataSources.Add(rds);
}
else
{
this.PrintfError("无任何数据！");
}
}
if (this.drpType.SelectedIndex == 2)
{
DataSet ds = KCJG.GetKCJG();
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
this.ReportViewer1.LocalReport.ReportPath = strPath + "\\KCJGReport.rdlc";
ReportDataSource rds = new ReportDataSource("KCJGData_KCJG", ds.Tables[0]);
ReportViewer1.LocalReport.DataSources.Add(rds);
}
else
{
this.PrintfError("无任何数据！");
}
}
if (this.drpType.SelectedIndex == 3)
{
DataSet ds = KCJG.GetFSXJG();
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
this.ReportViewer1.LocalReport.ReportPath = strPath + "\\FSXReport.rdlc";
ReportDataSource rds = new ReportDataSource("FSXJGData_FSXData", ds.Tables[0]);
ReportViewer1.LocalReport.DataSources.Add(rds);
}
else
{
this.PrintfError("无任何数据！");
}
}
if (this.drpType.SelectedIndex == 4)
{
DataSet ds = KCJG.GetKLFX();
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
this.ReportViewer1.LocalReport.ReportPath = strPath + "\\KLReport.rdlc";
ReportDataSource rds = new ReportDataSource("KLDataSet_KLData", ds.Tables[0]);
ReportViewer1.LocalReport.DataSources.Add(rds);
}
else
{
this.PrintfError("无任何数据！");
}
}
}
ReportViewer1.LocalReport.Refresh();
}
