public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { TotalPipeMaterialCR rpt = new TotalPipeMaterialCR(); rpt.Site = this.Site; return(rpt); }
private void TotalPipeMaterialForm_Load(object sender, EventArgs e) { // string sql = "SELECT * FROM fun_pipematerial_lsh where DRAWINGNO='" + DrawingNo + "' and projectid='" + ProjectNo + "'" + DTTZD + " order by material desc "; //string DBConfig_sql = "Data Source=oidsnew;User ID=plm;Password=123!feed;Unicode=True"; string sql = ""; if (Flag == 0) { sql = "SELECT * FROM fun_pipematerial_lsh where DRAWINGNO='" + DrawingNo + "' and projectid='" + ProjectNo + "' and modifydrawingno is null order by material desc "; } if (Flag == 1) { sql = "SELECT * FROM fun_pipematerial_lsh where MODIFYDRAWINGNO='" + DrawingNo + "' and projectid='" + ProjectNo + "' and modifydrawingno is not null order by material desc "; } DataSet ds = new DataSet(); OracleConnection sqlCon = new OracleConnection(DataAccess.OIDSConnStr); OracleCommand sqlCmd = new OracleCommand(sql, sqlCon); OracleDataAdapter sqlAd = new OracleDataAdapter(); sqlAd.SelectCommand = sqlCmd; sqlAd.Fill(ds, "sql"); cr = new TotalPipeMaterialCR(); cr.Load(Application.StartupPath + "CrystalReport1.rpt"); cr.SetDataSource(ds.Tables["sql"]); crystalReportViewer1.ReportSource = cr; //传递参数 ParameterFields paramFields = crystalReportViewer1.ParameterFieldInfo; ParameterField paramFrame = paramFields["drawingno"]; ParameterValues FcurValues = paramFrame.CurrentValues; ParameterDiscreteValue discreteValueF = new ParameterDiscreteValue(); discreteValueF.Value = DrawingNo; FcurValues.Add(discreteValueF); crystalReportViewer1.ParameterFieldInfo = paramFields; crystalReportViewer1.Refresh(); }
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { TotalPipeMaterialCR rpt = new TotalPipeMaterialCR(); rpt.Site = this.Site; return rpt; }