• 水晶报表参数构建和数据传入显示函数


      #region 参数构建
            private ParameterFields GetParameterFields(Dictionary<string,string > dicValue)
            {
                ParameterFields fields = new ParameterFields();

                foreach (string key in dicValue.Keys)
                {
                    fields.Add(this.CreateParameterField(key, dicValue[key]));
                }
                return fields;
            }
            private ParameterField CreateParameterField(string FieldName, object FieldValue)
            {
                ParameterField field = new ParameterField();
                ParameterDiscreteValue pvalue = new ParameterDiscreteValue();


                pvalue.Value = FieldValue;
                field.Name = FieldName;
                field.CurrentValues.Add(pvalue);
                field.AllowCustomValues = false;

                //返回参数字段
                return field;
            }
            #endregion
            #region 显示报表
            /// <summary>
            /// 显示报表
            /// </summary>
            /// <param name="formularFieldsValue">显示字段离散值</param>
            /// <param name="dicValue">参数键值对</param>
            /// <param name="reportData">报表数据</param>
            /// <param name="reportFile">报表文件</param>
            /// <param name="reportView">报表控件</param>
            public void ShowReport(string[] formularFieldsValue, Dictionary<string, string> dicValue, DataSet reportData, string reportFile, CrystalReportViewer reportView)
            {
                //使用报表对象加载报表
                ReportDocument myReport = new ReportDocument();        
                myReport.Load(reportFile);
                DataDefinition dataDefinition = myReport.DataDefinition;
                //获取数据对象中的公式字段集合
                string[] Text4formularFields = formularFieldsValue;           
                FormulaFieldDefinitions formularFields = dataDefinition.FormulaFields;
                for (int i = 0; i < formularFieldsValue.Length; i++)
                {
                    formularFields[i].Text = formularFieldsValue[i];
                }
                myReport.SetDataSource(reportData);
                reportView.ParameterFieldInfo = GetParameterFields(dicValue);
                reportView.ReportSource = myReport;

            }
            public void ShowReport(string[] formularFieldsValue, Dictionary<string, string> dicValue, DataTable reportData, string reportFile, CrystalReportViewer reportView)
            {
                //使用报表对象加载报表
                ReportDocument myReport = new ReportDocument();
                myReport.Load(reportFile);
                DataDefinition dataDefinition = myReport.DataDefinition;
                //获取数据对象中的公式字段集合
                string[] Text4formularFields = formularFieldsValue;
                FormulaFieldDefinitions formularFields = dataDefinition.FormulaFields;
                for (int i = 0; i < formularFieldsValue.Length; i++)
                {
                    formularFields[i].Text = formularFieldsValue[i];
                }
                myReport.SetDataSource(reportData);
                reportView.ParameterFieldInfo = GetParameterFields(dicValue);
                reportView.ReportSource = myReport;

            }
            public void ShowReport <T>(string[] formularFieldsValue, Dictionary<string, string> dicValue, List<T> reportData, string reportFile, CrystalReportViewer reportView)
            {
                //使用报表对象加载报表
                ReportDocument myReport = new ReportDocument();
                myReport.Load(reportFile);
                DataDefinition dataDefinition = myReport.DataDefinition;
                //获取数据对象中的公式字段集合
                string[] Text4formularFields = formularFieldsValue;
                FormulaFieldDefinitions formularFields = dataDefinition.FormulaFields;
                for (int i = 0; i < formularFieldsValue.Length; i++)
                {
                    formularFields[i].Text = formularFieldsValue[i];
                }
                myReport.SetDataSource(reportData);
                reportView.ParameterFieldInfo = GetParameterFields(dicValue);
                reportView.ReportSource = myReport;

            }
            #endregion

  • 相关阅读:
    ES6(四)字符串的扩展
    ES6(三)数组的扩展
    ES6(二) Destructuring-变量的解构赋值
    ES6(一) let and const
    canvas(七) 文字编写
    canvas(五)createPattern
    canvas(四) Gradient- demo
    canvas(三) star- demo
    jQuery之简单动画效果
    web开发小白之路
  • 原文地址:https://www.cnblogs.com/wanyuan8/p/2217467.html
Copyright © 2020-2023  润新知