reportrequest.cs

基于sqlserver2k,reporting service的扩展(auth,render,deliver==)应用（mssql,RS,AS,BI）

            public ReportRow this[int index] {
                get {
                    return ((ReportRow)(this.Rows[index]));
                }
            }
            
            public event ReportRowChangeEventHandler ReportRowChanged;
            
            public event ReportRowChangeEventHandler ReportRowChanging;
            
            public event ReportRowChangeEventHandler ReportRowDeleted;
            
            public event ReportRowChangeEventHandler ReportRowDeleting;
            
            public void AddReportRow(ReportRow row) {
                this.Rows.Add(row);
            }
            
            public ReportRow AddReportRow(string ID, string Name, string Description, string Path, string CreatedBy, System.DateTime CreatedDate, System.DateTime ExecutionTime, bool CustomParams, string SessionID, short ExecutionOption, string HistoryID, string ExportFormat, string DeviceSettings, bool RemoteCall) {
                ReportRow rowReportRow = ((ReportRow)(this.NewRow()));
                rowReportRow.ItemArray = new object[] {
                        ID,
                        Name,
                        Description,
                        Path,
                        CreatedBy,
                        CreatedDate,
                        ExecutionTime,
                        CustomParams,
                        SessionID,
                        ExecutionOption,
                        HistoryID,
                        ExportFormat,
                        DeviceSettings,
                        RemoteCall};
                this.Rows.Add(rowReportRow);
                return rowReportRow;
            }
            
            public System.Collections.IEnumerator GetEnumerator() {
                return this.Rows.GetEnumerator();
            }
            
            public override DataTable Clone() {
                ReportDataTable cln = ((ReportDataTable)(base.Clone()));
                cln.InitVars();
                return cln;
            }
            
            protected override DataTable CreateInstance() {
                return new ReportDataTable();
            }
            
            internal void InitVars() {
                this.columnID = this.Columns["ID"];
                this.columnName = this.Columns["Name"];
                this.columnDescription = this.Columns["Description"];
                this.columnPath = this.Columns["Path"];
                this.columnCreatedBy = this.Columns["CreatedBy"];
                this.columnCreatedDate = this.Columns["CreatedDate"];
                this.columnExecutionTime = this.Columns["ExecutionTime"];
                this.columnCustomParams = this.Columns["CustomParams"];
                this.columnSessionID = this.Columns["SessionID"];
                this.columnExecutionOption = this.Columns["ExecutionOption"];
                this.columnHistoryID = this.Columns["HistoryID"];
                this.columnExportFormat = this.Columns["ExportFormat"];
                this.columnDeviceSettings = this.Columns["DeviceSettings"];
                this.columnRemoteCall = this.Columns["RemoteCall"];
            }
            
            private void InitClass() {
                this.columnID = new DataColumn("ID", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnID);
                this.columnName = new DataColumn("Name", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnName);
                this.columnDescription = new DataColumn("Description", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnDescription);
                this.columnPath = new DataColumn("Path", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnPath);
                this.columnCreatedBy = new DataColumn("CreatedBy", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnCreatedBy);
                this.columnCreatedDate = new DataColumn("CreatedDate", typeof(System.DateTime), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnCreatedDate);
                this.columnExecutionTime = new DataColumn("ExecutionTime", typeof(System.DateTime), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnExecutionTime);
                this.columnCustomParams = new DataColumn("CustomParams", typeof(bool), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnCustomParams);
                this.columnSessionID = new DataColumn("SessionID", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnSessionID);
                this.columnExecutionOption = new DataColumn("ExecutionOption", typeof(short), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnExecutionOption);
                this.columnHistoryID = new DataColumn("HistoryID", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnHistoryID);
                this.columnExportFormat = new DataColumn("ExportFormat", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnExportFormat);
                this.columnDeviceSettings = new DataColumn("DeviceSettings", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnDeviceSettings);
                this.columnRemoteCall = new DataColumn("RemoteCall", typeof(bool), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnRemoteCall);
                this.columnID.AllowDBNull = false;
                this.columnName.AllowDBNull = false;
                this.columnPath.AllowDBNull = false;
                this.columnCreatedBy.AllowDBNull = false;
                this.columnCreatedDate.AllowDBNull = false;
                this.columnExecutionTime.AllowDBNull = false;
                this.columnCustomParams.AllowDBNull = false;
                this.columnExportFormat.AllowDBNull = false;
                this.columnExportFormat.DefaultValue = "HTML4.0";
                this.columnRemoteCall.AllowDBNull = false;
            }
            
            public ReportRow NewReportRow() {
                return ((ReportRow)(this.NewRow()));
            }
            
            protected override DataRow NewRowFromBuilder(DataRowBuilder builder) {
                return new ReportRow(builder);
            }
            
            protected override System.Type GetRowType() {
                return typeof(ReportRow);
            }
            
            protected override void OnRowChanged(DataRowChangeEventArgs e) {
                base.OnRowChanged(e);
                if ((this.ReportRowChanged != null)) {
                    this.ReportRowChanged(this, new ReportRowChangeEvent(((ReportRow)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowChanging(DataRowChangeEventArgs e) {
                base.OnRowChanging(e);
                if ((this.ReportRowChanging != null)) {
                    this.ReportRowChanging(this, new ReportRowChangeEvent(((ReportRow)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowDeleted(DataRowChangeEventArgs e) {
                base.OnRowDeleted(e);
                if ((this.ReportRowDeleted != null)) {
                    this.ReportRowDeleted(this, new ReportRowChangeEvent(((ReportRow)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowDeleting(DataRowChangeEventArgs e) {
                base.OnRowDeleting(e);
                if ((this.ReportRowDeleting != null)) {
                    this.ReportRowDeleting(this, new ReportRowChangeEvent(((ReportRow)(e.Row)), e.Action));
                }
            }
            
            public void RemoveReportRow(ReportRow row) {
                this.Rows.Remove(row);
            }
        }
        
        [System.Diagnostics.DebuggerStepThrough()]
        public class ReportRow : DataRow {
            
            private ReportDataTable tableReport;
            
            internal ReportRow(DataRowBuilder rb) : 
                    base(rb) {
                this.tableReport = ((ReportDataTable)(this.Table));
            }
            
            public string ID {
                get {
                    return ((string)(this[this.tableReport.IDColumn]));
                }
                set {
                    this[this.tableReport.IDColumn] = value;
                }
            }
            
            public string Name {
                get {
                    return ((string)(this[this.tableReport.NameColumn]));
                }
                set {
                    this[this.tableReport.NameColumn] = value;
                }
            }
            
            public string Description {
                get {
                    if (this.IsDescriptionNull()) {
                        return null;
                    }
                    else {
                        return ((string)(this[this.tableReport.DescriptionColumn]));
                    }
                }
                set {
                    this[this.tableReport.DescriptionColumn] = value;
                }
            }
            
            public string Path {
                get {
                    return ((string)(this[this.tableReport.PathColumn]));
                }
                set {
                    this[this.tableReport.PathColumn] = value;
                }
            }
            
            public string CreatedBy {
                get {
                    return ((string)(this[this.tableReport.CreatedByColumn]));
                }
                set {
                    this[this.tableReport.CreatedByColumn] = value;
                }
            }
            
            public System.DateTime CreatedDate {
                get {
                    return ((System.DateTime)(this[this.tableReport.CreatedDateColumn]));
                }
                set {
                    this[this.tableReport.CreatedDateColumn] = value;
                }
            }
            
            public System.DateTime ExecutionTime {
                get {
                    return ((System.DateTime)(this[this.tableReport.ExecutionTimeColumn]));
                }
                set {
                    this[this.tableReport.ExecutionTimeColumn] = value;
                }
            }
            
            public bool CustomParams {
                get {
                    return ((bool)(this[this.tableReport.CustomParamsColumn]));
                }
                set {
                    this[this.tableReport.CustomParamsColumn] = value;
                }
            }
            
            public string SessionID {
                get {
                    if (this.IsSessionIDNull()) {
                        return null;
                    }
                    else {
                        return ((string)(this[this.tableReport.SessionIDColumn]));
                    }
                }
                set {
                    this[this.tableReport.SessionIDColumn] = value;
                }
            }
            
            public short ExecutionOption {
                get {
                    try {
                        return ((short)(this[this.tableReport.ExecutionOptionColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("Cannot get value because it is DBNull.", e);
                    }
                }
                set {
                    this[this.tableReport.ExecutionOptionColumn] = value;
                }
            }
            
            public string HistoryID {
                get {
                    if (this.IsHistoryIDNull()) {
                        return null;
                    }
                    else {
                        return ((string)(this[this.tableReport.HistoryIDColumn]));
                    }
                }
                set {
                    this[this.tableReport.HistoryIDColumn] = value;
                }
            }
            
            public string ExportFormat {
                get {
                    return ((string)(this[this.tableReport.ExportFormatColumn]));
                }
                set {
                    this[this.tableReport.ExportFormatColumn] = value;
                }
            }
            
            public string DeviceSettings {
                get {
                    if (this.IsDeviceSettingsNull()) {
                        return null;
                    }
                    else {
                        return ((string)(this[this.tableReport.DeviceSettingsColumn]));
                    }
                }
                set {
                    this[this.tableReport.DeviceSettingsColumn] = value;