水晶报表相关代码

来源：互联网发布：sql 安全策略编辑：程序博客网时间：2024/04/28 08:22

以下代码从网上各处搜罗过来以备不时之需

仅供自己学习之用

#region        //参数字段方法        public ParameterFields GetParameterFields()        {            ParameterFields fields = new ParameterFields();            //单位、部门、人员、日期范围参数            fields.Add(this.CreateParameterField("@Guid", proid.Text.Trim()));            //fields.Add(this.CreateParameterField("@barcode", dataGridView1.Rows[]));            fields.Add(this.CreateParameterField("@等级", comboBox2.Text));            //返回            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);            //返回参数字段            return field;        }               //水晶报表登陆代码        //private void LogonToReport(string server, string database, string ID, string password, CachedCrystalReport1 Report)        //{        //    TableLogOnInfo logonInfo = new TableLogOnInfo();        //    foreach (Table table in Report.Database.Tables)        //    {        //        logonInfo = table.LogOnInfo;        //        logonInfo.ConnectionInfo.ServerName = server;        //        logonInfo.ConnectionInfo.DatabaseName = database;        //        logonInfo.ConnectionInfo.UserID = ID;        //        logonInfo.ConnectionInfo.Password = password;        //        table.ApplyLogOnInfo(logonInfo);        //    }        //}        #endregion

0 0