protected void btnQuery_Click(object sender, ImageClickEventArgs e) { try { string strWhere = GetStrWhere(); DataSet ds = QTCKQuery.GetPrintDS(strWhere); this.grvPrintCKDMX.DataSource = ds; this.grvPrintCKDMX.DataBind(); } catch { this.PrintfError("查询出现错误"); return; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { BinddrpCK(); BinddrpCKLX(); BinddrpNCDJ(); BinddrpCYS(); BinddrpZDR(); BinddrpSHDW(); string strdate = DateTime.Now.ToShortDateString(); txtZDRQ1.Text = strdate; txtZDRQ2.Text = strdate; this.hidCKDH.Value = Request["CKDH"]; if (!string.IsNullOrEmpty(this.hidCKDH.Value)) { string CKDH = this.hidCKDH.Value.Trim(); DataSet ds = QTCKQuery.GetPrintDS("and CKDH = '" + CKDH + "'"); this.grvPrintCKDMX.DataSource = ds; this.grvPrintCKDMX.DataBind(); this.frameItem.Attributes["src"] = "PrintQTCKItem.aspx?CKDH=" + CKDH; } } }
//设置报表 private void SetReport() { this.ReportView1.ServerUrl = this.ReportURL; string Type = Request["TYPE"]; string hidCKDH = Request["hidCKDH"]; switch (Type) { case "0": if (Common.IsOldData) { this.ReportView1.ReportPath = "/XGReportO/ReportQTCK"; } else { this.ReportView1.ReportPath = "/XGReportC/ReportQTCK"; } break; case "1": if (Common.IsOldData) { this.ReportView1.ReportPath = "/XGReportO/ReportQTCKDJHJ"; } else { this.ReportView1.ReportPath = "/XGReportC/ReportQTCKDJHJ"; } break; case "2": if (Common.IsOldData) { this.ReportView1.ReportPath = "/XGReportO/ReportQTCKHJ"; } else { this.ReportView1.ReportPath = "/XGReportC/ReportQTCKHJ"; } break; } 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; switch (Type) { case "0": DataSet ds = QTCKQuery.GetPrintDS("and CKDH='" + hidCKDH + "'"); if (!string.IsNullOrEmpty(hidCKDH)) { ReportView1.SetParameter("CKDH", hidCKDH); } if (ds.Tables[0].Rows[0]["CPH"] != null) { ReportView1.SetParameter("CPH", Server.UrlEncode(ds.Tables[0].Rows[0]["CPH"].ToString())); } if (ds.Tables[0].Rows[0]["SHDW"] != null) { ReportView1.SetParameter("SHDW", Server.UrlEncode(ds.Tables[0].Rows[0]["SHDW"].ToString())); } if (ds.Tables[0].Rows[0]["ZDR"] != null) { ReportView1.SetParameter("ZDR", Server.UrlEncode(ds.Tables[0].Rows[0]["ZDR"].ToString())); } if (ds.Tables[0].Rows[0]["FYSJ"] != null) { ReportView1.SetParameter("FYRQ", ds.Tables[0].Rows[0]["FYSJ"].ToString()); } if (ds.Tables[0].Rows[0]["NCDJ"] != null) { ReportView1.SetParameter("NCDJ", ds.Tables[0].Rows[0]["NCDJ"].ToString()); } if (ds.Tables[0].Rows[0]["CYS"] != null) { ReportView1.SetParameter("CYS", Server.UrlEncode(ds.Tables[0].Rows[0]["CYS"].ToString())); } if (ds.Tables[0].Rows[0]["AimAdress"] != null) { ReportView1.SetParameter("MDD", Server.UrlEncode(ds.Tables[0].Rows[0]["AimAdress"].ToString())); } if (ds.Tables[0].Rows[0]["ZDRQ"] != null) { ReportView1.SetParameter("ZDRQ", ds.Tables[0].Rows[0]["ZDRQ"].ToString()); } if (ds.Tables[0].Rows[0]["CK"] != null) { ReportView1.SetParameter("CK", ds.Tables[0].Rows[0]["CK"].ToString()); } if (ds.Tables[0].Rows[0]["CKLX"] != null) { ReportView1.SetParameter("CKLX", Server.UrlEncode(ds.Tables[0].Rows[0]["CKLX"].ToString())); } break; case "1": if (!string.IsNullOrEmpty(Request["CKDH"])) { ReportView1.SetParameter("CKDH", Request["CKDH"]); } if (!string.IsNullOrEmpty(Request["CPH"])) { ReportView1.SetParameter("CPH", Request["CPH"]); } if (!string.IsNullOrEmpty(Request["ncdj"])) { ReportView1.SetParameter("ncdj", Request["ncdj"]); } if (!string.IsNullOrEmpty(Request["CKLX"])) { ReportView1.SetParameter("CKLX", Request["CKLX"]); } if (!string.IsNullOrEmpty(Request["CYS"])) { ReportView1.SetParameter("CYS", Request["CYS"]); } if (!string.IsNullOrEmpty(Request["CK"])) { ReportView1.SetParameter("CK", Request["CK"]); } if (!string.IsNullOrEmpty(Request["status"])) { ReportView1.SetParameter("status", Request["status"]); } if (!string.IsNullOrEmpty(Request["ZDR"])) { ReportView1.SetParameter("ZDR", Request["ZDR"]); } if (!string.IsNullOrEmpty(Request["SHDW"])) { ReportView1.SetParameter("SHDW", Request["SHDW"]); } if (!string.IsNullOrEmpty(Request["ZDRQfrom"])) { ReportView1.SetParameter("ZDRQfrom", Request["ZDRQfrom"]); } if (!string.IsNullOrEmpty(Request["ZDRQto"])) { ReportView1.SetParameter("ZDRQto", Request["ZDRQto"]); } break; case "2": if (!string.IsNullOrEmpty(Request["CKDH"])) { ReportView1.SetParameter("CKDH", Request["CKDH"]); } if (!string.IsNullOrEmpty(Request["CPH"])) { ReportView1.SetParameter("CPH", Request["CPH"]); } if (!string.IsNullOrEmpty(Request["ncdj"])) { ReportView1.SetParameter("ncdj", Request["ncdj"]); } if (!string.IsNullOrEmpty(Request["CKLX"])) { ReportView1.SetParameter("CKLX", Request["CKLX"]); } if (!string.IsNullOrEmpty(Request["CYS"])) { ReportView1.SetParameter("CYS", Request["CYS"]); } if (!string.IsNullOrEmpty(Request["CK"])) { ReportView1.SetParameter("CK", Request["CK"]); } if (!string.IsNullOrEmpty(Request["status"])) { ReportView1.SetParameter("status", Request["status"]); } if (!string.IsNullOrEmpty(Request["ZDR"])) { ReportView1.SetParameter("ZDR", Request["ZDR"]); } if (!string.IsNullOrEmpty(Request["SHDW"])) { ReportView1.SetParameter("SHDW", Request["SHDW"]); } if (!string.IsNullOrEmpty(Request["ZDRQfrom"])) { ReportView1.SetParameter("ZDRQfrom", Request["ZDRQfrom"]); } if (!string.IsNullOrEmpty(Request["ZDRQto"])) { ReportView1.SetParameter("ZDRQto", Request["ZDRQto"]); } break; } }