public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { WeightBarycenterCR rpt = new WeightBarycenterCR(); rpt.Site = this.Site; return rpt; }
private void WeightBarycenterForm_Load(object sender, EventArgs e) { //推模式 string sql = ""; if (flag == 0) { sql = "SELECT * FROM SP_SPOOL_TAB where DRAWINGNO='" + DrawingNo + "'and FLAG='Y' and ProjectId='" + ProjectId + "'"; } if (flag == 1) { sql = "SELECT * FROM SP_SPOOL_TAB where MODIFYDRAWINGNO='" + DrawingNo + "'and FLAG='Y' and ProjectId='" + ProjectId + "'and MODIFYDRAWINGNO is not null"; } 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 WeightBarycenterCR(); //cr.Load(Application.StartupPath + "CrystalReport1.rpt"); cr.SetDataSource(ds.Tables["sql"]); crystalReportViewer1.ReportSource = cr; SetArray(); xsum = weightcenter("XPOS"); ysum = weightcenter("YPOS"); zsum = weightcenter("ZPOS"); xpF[0] = paixu(xsum, xp, xpF, zp, zpF, SF, EF); //传递参数 ParameterFields drawparam = crystalReportViewer1.ParameterFieldInfo; ParameterField drawparamFrame = drawparam["DRAWING_MODIFY_NO"]; ParameterValues drawcurValues = drawparamFrame.CurrentValues; ParameterDiscreteValue discreteValued = new ParameterDiscreteValue(); discreteValued.Value = DrawingNo; drawcurValues.Add(discreteValued); ParameterFields paramFields = crystalReportViewer1.ParameterFieldInfo; ParameterField paramFrame = paramFields["肋位:"]; ParameterValues FcurValues = paramFrame.CurrentValues; ParameterDiscreteValue discreteValueF = new ParameterDiscreteValue(); discreteValueF.Value = xpF[0].ToString() + " " + Math.Round(minx, 2); FcurValues.Add(discreteValueF); ParameterField paramH = paramFields["高度:"]; ParameterValues HcurValues = paramH.CurrentValues; ParameterDiscreteValue discreteValueH = new ParameterDiscreteValue(); for (m = 1; m <= zpF.Count; m++) { zpF[m - 1] = paixu(zsum, zp, zpF, xp, xpF, SF, EF); if (Convert.ToDouble(xpF[m - 1].ToString().Substring(2)) >= Convert.ToDouble(SF[m - 1].ToString().Substring(2)) && Convert.ToDouble(xpF[m - 1].ToString().Substring(2)) <= Convert.ToDouble(EF[m].ToString().Substring(2))) { discreteValueH.Value = zpF[m - 1].ToString() + " " + Math.Round(minx, 2); break; } } HcurValues.Add(discreteValueH); ParameterField paramMiddle = paramFields["距舯:"]; ParameterValues McurValues = paramMiddle.CurrentValues; ParameterDiscreteValue discreteValueM = new ParameterDiscreteValue(); discreteValueM.Value = Math.Round(ysum, 2); McurValues.Add(discreteValueM); crystalReportViewer1.ParameterFieldInfo = paramFields; crystalReportViewer1.Refresh(); //ReplaceExportButton(); }
private void WeightBarycenterForm_Load(object sender, EventArgs e) { //推模式 string sql=""; if (flag == 0) { sql = "SELECT * FROM SP_SPOOL_TAB where DRAWINGNO='" + DrawingNo + "'and FLAG='Y' and ProjectId='" + ProjectId + "'"; } if (flag == 1) { sql = "SELECT * FROM SP_SPOOL_TAB where MODIFYDRAWINGNO='" + DrawingNo + "'and FLAG='Y' and ProjectId='" + ProjectId + "'and MODIFYDRAWINGNO is not null"; } 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 WeightBarycenterCR(); //cr.Load(Application.StartupPath + "CrystalReport1.rpt"); cr.SetDataSource(ds.Tables["sql"]); crystalReportViewer1.ReportSource = cr; SetArray(); xsum = weightcenter("XPOS"); ysum = weightcenter("YPOS"); zsum = weightcenter("ZPOS"); xpF[0] = paixu(xsum, xp, xpF, zp, zpF, SF, EF); //传递参数 ParameterFields drawparam = crystalReportViewer1.ParameterFieldInfo; ParameterField drawparamFrame = drawparam["DRAWING_MODIFY_NO"]; ParameterValues drawcurValues = drawparamFrame.CurrentValues; ParameterDiscreteValue discreteValued = new ParameterDiscreteValue(); discreteValued.Value = DrawingNo; drawcurValues.Add(discreteValued); ParameterFields paramFields = crystalReportViewer1.ParameterFieldInfo; ParameterField paramFrame = paramFields["肋位:"]; ParameterValues FcurValues = paramFrame.CurrentValues; ParameterDiscreteValue discreteValueF = new ParameterDiscreteValue(); discreteValueF.Value = xpF[0].ToString() + " " + Math.Round(minx, 2); FcurValues.Add(discreteValueF); ParameterField paramH = paramFields["高度:"]; ParameterValues HcurValues = paramH.CurrentValues; ParameterDiscreteValue discreteValueH = new ParameterDiscreteValue(); for (m = 1; m <= zpF.Count; m++) { zpF[m - 1] = paixu(zsum, zp, zpF, xp, xpF, SF, EF); if (Convert.ToDouble(xpF[m - 1].ToString().Substring(2)) >= Convert.ToDouble(SF[m - 1].ToString().Substring(2)) && Convert.ToDouble(xpF[m - 1].ToString().Substring(2)) <= Convert.ToDouble(EF[m].ToString().Substring(2))) { discreteValueH.Value = zpF[m - 1].ToString() + " " + Math.Round(minx, 2); break; } } HcurValues.Add(discreteValueH); ParameterField paramMiddle = paramFields["距舯:"]; ParameterValues McurValues = paramMiddle.CurrentValues; ParameterDiscreteValue discreteValueM = new ParameterDiscreteValue(); discreteValueM.Value = Math.Round(ysum, 2); McurValues.Add(discreteValueM); crystalReportViewer1.ParameterFieldInfo = paramFields; crystalReportViewer1.Refresh(); //ReplaceExportButton(); }