protected void Page_Load(object sender, EventArgs e) { dq_id = Request.QueryString["CQID"]; CR_NotContractOrder_DataSet DataSource1 = BingCQData(dq_id); ReportDataSource dss = new ReportDataSource(); dss.Name = "CR_NotContractOrder_DataSet_TBPM_ORDER_CHECKREQUEST"; dss.Value = DataSource1.Tables["TBPM_ORDER_CHECKREQUEST"]; this.rptView1.LocalReport.DataSources.Add(dss); this.rptView1.DataBind(); }
private CR_NotContractOrder_DataSet BingCQData(string dq_id) { string sqlText = "select DQ_ID,DQ_DATA,DQ_QKBM,DQ_BMNAME,DQ_QKR,DQ_USE,DQ_DDCODE,DQ_DDZJE,DQ_CSCODE,DQ_CSNAME,DQ_CSBANK,DQ_CSACCOUNT,DQ_AMOUNT,DQ_AMOUNTDX,DQ_ZFFS,DQ_BILLCODE,DQ_STATE,DQ_BMYJ,DQ_ZGLD,DQ_GSLD,DQ_CWSH,DQ_NOTE from TBPM_ORDER_CHECKREQUEST"; sqlText += " where DQ_ID='" + dq_id + "'"; CR_NotContractOrder_DataSet ds = new CR_NotContractOrder_DataSet(); SqlConnection sqlConn = new SqlConnection(); sqlConn.ConnectionString = DBCallCommon.GetStringValue("connectionStrings"); SqlDataAdapter sda = new SqlDataAdapter(sqlText, sqlConn); sda.Fill(ds, "TBPM_ORDER_CHECKREQUEST"); return(ds); }