private DataSet GetDs() { DataSet ds = new DataSet(); if (UserSecurity.HavingPrivilege(User.cur_user, "SPOOLWAREHOUSEUSERS")) { DataTable dtNest = User.NestPipeTab; //套料详表 dtNest.TableName = "Nest_Tab"; ds.Tables.Add(dtNest.Copy()); return(ds); } return(ds); }
private DataSet GetDs() { DataSet ds1 = new DataSet(); if (UserSecurity.HavingPrivilege(User.cur_user, "SPOOLWAREHOUSEUSERS")) { DataTable dtBaseCal = User.Gather; DataTable dtFlage = User.FlageTab; DataTable dtElbow = User.ElbowTab; DataTable dtSleeve = User.SleeveTab; DataTable dtOtherAttach = User.OtherAttach; dtBaseCal.TableName = "Gather"; dtFlage.TableName = "flage"; dtElbow.TableName = "elbow"; dtSleeve.TableName = "sleeve"; dtOtherAttach.TableName = "OtherAttach"; ds1.Tables.Add(dtBaseCal.Copy()); ds1.Tables.Add(dtOtherAttach.Copy()); ds1.Tables.Add(dtFlage.Copy()); ds1.Tables.Add(dtElbow.Copy()); ds1.Tables.Add(dtSleeve.Copy()); return(ds1); } else { DataTable dt = User.PipeTab; DataTable dt1 = User.PartTab; //ProjectMaterialDS ds = new ProjectMaterialDS(); dt.TableName = "pipe_tab"; dt1.TableName = "part_tab"; ds1.Tables.Add(dt.Copy()); ds1.Tables.Add(dt1.Copy()); return(ds1); } }
private void crystalReportViewer1_Load(object sender, EventArgs e) { DataSet ds = new DataSet(); ds = GetDs(); if (UserSecurity.HavingPrivilege(User.cur_user, "SPOOLWAREHOUSEUSERS")) { NestProjectMaterialRpt pmrpt = new NestProjectMaterialRpt(); pmrpt.SetDataSource(ds); crystalReportViewer1.ReportSource = pmrpt; } else { ProjectMaterialRpt pmrpt = new ProjectMaterialRpt(); pmrpt.SetDataSource(ds); crystalReportViewer1.ReportSource = pmrpt; } //crystalReportViewer1.DisplayGroupTree = false; ParameterFields paramFields = new ParameterFields(); ParameterField paramField1 = new ParameterField(); ParameterDiscreteValue discreteVal = new ParameterDiscreteValue(); // 第一个参数是具有多个值的离散参数。设置参数字段的名称,它必须和报表中的参数相符。 paramField1.ParameterFieldName = "kickoffdate"; // 设置离散值并将其传递给该参数。 discreteVal.Value = User.KickOffDate; paramField1.CurrentValues.Add(discreteVal); // 将该参数添加到参数字段集合。 paramFields.Add(paramField1); ParameterField paramField2 = new ParameterField(); ParameterDiscreteValue discreteVal2 = new ParameterDiscreteValue(); paramField2.ParameterFieldName = "TotalBaseLength"; discreteVal2.Value = User.TotalBaseLength; paramField2.CurrentValues.Add(discreteVal2); paramFields.Add(paramField2); ParameterField paramField5 = new ParameterField(); ParameterDiscreteValue discreteVal5 = new ParameterDiscreteValue(); paramField5.ParameterFieldName = "kickoffdateStart"; discreteVal5.Value = User.KickOffDate_start; paramField5.CurrentValues.Add(discreteVal5); paramFields.Add(paramField5); ParameterField paramField6 = new ParameterField(); ParameterDiscreteValue discreteVal6 = new ParameterDiscreteValue(); paramField6.ParameterFieldName = "kickoffdateEnd"; discreteVal6.Value = User.KickOffDate_end; paramField6.CurrentValues.Add(discreteVal6); paramFields.Add(paramField6); ParameterField paramField7 = new ParameterField(); ParameterDiscreteValue discreteVal7 = new ParameterDiscreteValue(); paramField7.ParameterFieldName = "TotalWeight"; discreteVal7.Value = User.PipeBaseTotalWeight; paramField7.CurrentValues.Add(discreteVal7); paramFields.Add(paramField7); crystalReportViewer1.ParameterFieldInfo = paramFields; }
private void NestingDetailViewer_Load(object sender, EventArgs e) { DataSet ds = new DataSet(); ds = GetDs(); if (UserSecurity.HavingPrivilege(User.cur_user, "SPOOLWAREHOUSEUSERS")) { NestingPipeRpt pmrpt = new NestingPipeRpt(); pmrpt.SetDataSource(ds); NestingDetailViewer.ReportSource = pmrpt; } ParameterFields paramFields = new ParameterFields(); ParameterField paramField1 = new ParameterField(); ParameterDiscreteValue discreteVal = new ParameterDiscreteValue(); paramField1.ParameterFieldName = "kickoffdate"; discreteVal.Value = User.KickOffDate; paramField1.CurrentValues.Add(discreteVal); paramFields.Add(paramField1); ParameterField paramField2 = new ParameterField(); ParameterDiscreteValue discreteVa2 = new ParameterDiscreteValue(); paramField2.ParameterFieldName = "Margin"; discreteVa2.Value = User.Margin; paramField2.CurrentValues.Add(discreteVa2); paramFields.Add(paramField2); ParameterField paramField3 = new ParameterField(); ParameterDiscreteValue discreteVal3 = new ParameterDiscreteValue(); paramField3.ParameterFieldName = "TotalBaseLength"; discreteVal3.Value = User.TotalBaseLength; paramField3.CurrentValues.Add(discreteVal3); paramFields.Add(paramField3); ParameterField paramField4 = new ParameterField(); ParameterDiscreteValue discreteVal4 = new ParameterDiscreteValue(); paramField4.ParameterFieldName = "PipeRatio"; discreteVal4.Value = User.PipeRatio; paramField4.CurrentValues.Add(discreteVal4); paramFields.Add(paramField4); ParameterField paramField5 = new ParameterField(); ParameterDiscreteValue discreteVal5 = new ParameterDiscreteValue(); paramField5.ParameterFieldName = "kickoffdateStart"; discreteVal5.Value = User.KickOffDate_start; paramField5.CurrentValues.Add(discreteVal5); paramFields.Add(paramField5); ParameterField paramField6 = new ParameterField(); ParameterDiscreteValue discreteVal6 = new ParameterDiscreteValue(); paramField6.ParameterFieldName = "kickoffdateEnd"; discreteVal6.Value = User.KickOffDate_end; paramField6.CurrentValues.Add(discreteVal6); paramFields.Add(paramField6); NestingDetailViewer.ParameterFieldInfo = paramFields; }