public RepairOrderVirtualTable(EBSVirtualReportTablesPackage package) : base(package) { //add columns this.Name = "RepairOrderTable"; this.Label = "EBS Repair Order Table"; this.Description = "EBS Repair Order Table"; addColumns(RepairOrder.getRepairOrderListSchema()); //add filters this.Columns.Add(new ReportColumn() { DataType = ReportColumnType.Integer, Label = "HiddenIncidentID", Name = "HiddenIncidentID", CanDisplay = false, CanFilter = true }); this.Columns.Add(new ReportColumn() { DataType = ReportColumnType.Integer, Label = "HiddenContactID", Name = "HiddenContactID", CanDisplay = false, CanFilter = true }); this.Columns.Add(new ReportColumn() { DataType = ReportColumnType.String, Label = "SR_DETAIL_LINK", Name = "SR_DETAIL_LINK", CanDisplay = true, CanFilter = false }); }
public EntitlementListVirtualTable(EBSVirtualReportTablesPackage package) : base(package) { this.Name = "EntitlementTable"; this.Label = "EBS Entitlement Table"; this.Description = "EBS Entitlement Table"; addColumns(Entitlement.getDetailedSchema()); //add filter this.Columns.Add(new ReportColumn() { DataType = ReportColumnType.Integer, Label = "HiddenInstanceId", Name = "HiddenInstanceId", CanDisplay = false, CanFilter = true }); this.Columns.Add(new ReportColumn() { DataType = ReportColumnType.String, Label = "HiddenValidateFlag", Name = "HiddenValidateFlag", CanDisplay = false, CanFilter = true }); }
public ItemListVirtualTable(EBSVirtualReportTablesPackage package) : base(package) { //add columns this.Name = "ItemTable"; this.Label = "EBS Item Table"; this.Description = "EBS Item Table"; addColumns(Item.getDetailedSchema()); //add filters this.Columns.Add(new ReportColumn() { DataType = ReportColumnType.String, Label = "HiddenSerialNumber", Name = "HiddenSerialNumber", CanDisplay = false, CanFilter = true }); this.Columns.Add(new ReportColumn() { DataType = ReportColumnType.Integer, Label = "HiddenContactOrgID", Name = "HiddenContactOrgID", CanDisplay = false, CanFilter = true }); this.Columns.Add(new ReportColumn() { DataType = ReportColumnType.String, Label = "HiddenActiveInstanceOnly", Name = "HiddenActiveInstanceOnly", CanDisplay = false, CanFilter = true }); }
public OrderMgmtHeaderVirtualTable(EBSVirtualReportTablesPackage package, ref IList <IReportTable> reportTables) : base(package) { this.Name = "OrderMgmtHeaderValTable"; this.Label = "EBS Order Mgmt Header Value Table"; this.Description = "EBS Order Mgmt Header Value Table"; // from generated proxy HEADER_VAL_REC APPSOE_ORDER_PUB_HX219471X29X254 orderHeader = new APPSOE_ORDER_PUB_HX219471X29X254(); addColumns(orderHeader.GetType()); //HEADER_VAL_REC has no ID, add one for report linking this.Columns.Add(new ReportColumn() { DataType = ReportColumnType.Integer, Label = "ID", Name = "ID", CanDisplay = true, CanFilter = true }); OutputParameters2 order = new OutputParameters2(); // add the order child tables foreach (PropertyInfo propertyInfo in order.GetType().GetProperties()) { if (propertyInfo.PropertyType.IsArray) { OrderMgmtGenericChildTable newTable = new OrderMgmtGenericChildTable(package, propertyInfo); reportTables.Add(newTable); } } }
public OrderMgmtHeaderVirtualTable(EBSVirtualReportTablesPackage package, ref IList<IReportTable> reportTables) : base(package) { this.Name = "OrderMgmtHeaderValTable"; this.Label = "EBS Order Mgmt Header Value Table"; this.Description = "EBS Order Mgmt Header Value Table"; // from generated proxy HEADER_VAL_REC APPSOE_ORDER_PUB_HX219471X29X254 orderHeader = new APPSOE_ORDER_PUB_HX219471X29X254(); addColumns(orderHeader.GetType()); //HEADER_VAL_REC has no ID, add one for report linking this.Columns.Add(new ReportColumn() { DataType = ReportColumnType.Integer, Label = "ID", Name = "ID", CanDisplay = true, CanFilter = true }); OutputParameters2 order = new OutputParameters2(); // add the order child tables foreach (PropertyInfo propertyInfo in order.GetType().GetProperties()) { if (propertyInfo.PropertyType.IsArray) { OrderMgmtGenericChildTable newTable = new OrderMgmtGenericChildTable(package, propertyInfo); reportTables.Add(newTable); } } }
// Build the columns schema dynamically based on Contact.getDetailSchema() public ContactDetailVirtualTable(EBSVirtualReportTablesPackage package) : base(package) { this.Name = "ContactDetailTable"; this.Label = "EBS Contact Detail Table"; this.Description = "EBS Contact Detail Table"; Dictionary<string, string> dictDetail = ContactModel.getDetailSchema(); addColumns(dictDetail); }
// Build the columns schema dynamically based on Contact.getDetailSchema() public ContactDetailVirtualTable(EBSVirtualReportTablesPackage package) : base(package) { this.Name = "ContactDetailTable"; this.Label = "EBS Contact Detail Table"; this.Description = "EBS Contact Detail Table"; Dictionary <string, string> dictDetail = ContactModel.getDetailSchema(); addColumns(dictDetail); }
public OrderHeaderByContactVirtualTable(EBSVirtualReportTablesPackage package) : base(package) { this.Name = "OrdersByContactVirtualTable"; this.Label = "EBS Order Header By Contact Table"; this.Description = "EBS Order Header By Contact Table"; // from generated proxy APPSOE_ORDER_CUST_ORX3349377X1X3 orderHeader = new APPSOE_ORDER_CUST_ORX3349377X1X3(); addColumns(orderHeader.GetType()); }
public RepairLogisticsVirtualTable(EBSVirtualReportTablesPackage package) : base(package) { this.Name = "RepairLogisticsTable"; this.Label = "EBS Repair Logistics Table"; this.Description = "EBS Repair Logistics Table"; addColumns(RepairLogistics.getRepairLogisticsListSchema()); //add filter this.Columns.Add(new ReportColumn() { DataType = ReportColumnType.Integer, Label = "HiddenRepairOrderID", Name = "HiddenRepairOrderID", CanDisplay = false, CanFilter = true }); }
/* Build the columns schema dynamically based on ServiceRequest.getDetailSchema() * and add one more column, HiddenSRconcatIncident_ID. * The reason is the Service Request List view has "Subject" as report linking * to this detail table, and it is based on this special column */ public SRdetailVirtualTable(EBSVirtualReportTablesPackage package) : base(package) { this.Name = "SRDetailTable"; this.Label = "EBS SR Detail Table"; this.Description = "EBS SR Detail Table"; Dictionary<string, string> dictSRDetail = ServiceRequest.getDetailSchema(); addColumns(dictSRDetail); // format is either SrID_ OR _IncidentID this.Columns.Add(new ReportColumn() { DataType = ReportColumnType.String, Label = "HiddenSRconcatIncident_ID", Name = "HiddenSRconcatIncident_ID", CanDisplay = true, CanFilter = true }); }
/* Build the columns schema dynamically based on ServiceRequest.getDetailSchema() * and add one more column, HiddenSRconcatIncident_ID. * The reason is the Service Request List view has "Subject" as report linking * to this detail table, and it is based on this special column */ public SRdetailVirtualTable(EBSVirtualReportTablesPackage package) : base(package) { this.Name = "SRDetailTable"; this.Label = "EBS SR Detail Table"; this.Description = "EBS SR Detail Table"; Dictionary <string, string> dictSRDetail = ServiceRequest.getDetailSchema(); addColumns(dictSRDetail); // format is either SrID_ OR _IncidentID this.Columns.Add(new ReportColumn() { DataType = ReportColumnType.String, Label = "HiddenSRconcatIncident_ID", Name = "HiddenSRconcatIncident_ID", CanDisplay = true, CanFilter = true }); }
public OrderMgmtGenericChildTable(EBSVirtualReportTablesPackage package, PropertyInfo tableInfo) : base(package) { this.Name = tableInfo.Name; this.Label = "EBS " + tableInfo.Name; this.Description = "EBS " + tableInfo.Name; addColumns(tableInfo.PropertyType.GetElementType()); /* _VAL_TBL has no HEADER_ID, add it * this filter for report linking */ if (this.Name.Contains("_VAL_TBL")) { this.Columns.Add(new ReportColumn() { DataType = ReportColumnType.Integer, Label = "HEADER_ID", Name = "HEADER_ID", CanDisplay = true, CanFilter = true }); } }
public SRlistVirtualTable(EBSVirtualReportTablesPackage package) : base(package) { this.Name = "SRlistTable"; this.Label = "EBS Service Request List Table"; this.Description = "EBS Service Request List Table"; this.Columns.Add(new ReportColumn() { DataType = ReportColumnType.Integer, Label = "SR ID", Name = "SrID", CanDisplay = true, CanFilter = true }); this.Columns.Add(new ReportColumn() { DataType = ReportColumnType.String, Label = "SR Number", Name = "SrNumber", CanDisplay = true, CanFilter = true }); this.Columns.Add(new ReportColumn() { DataType = ReportColumnType.Integer, Label = "Contact Party ID", Name = "ContactPartyID", CanDisplay = true, CanFilter = true }); this.Columns.Add(new ReportColumn() { DataType = ReportColumnType.String, Label = "Incident Reference", Name = "IncidentRef", CanDisplay = true, CanFilter = false }); this.Columns.Add(new ReportColumn() { DataType = ReportColumnType.String, Label = "Status", Name = "Status", CanDisplay = true, CanFilter = true }); this.Columns.Add(new ReportColumn() { DataType = ReportColumnType.String, Label = "Summary", Name = "Summary", CanDisplay = true }); this.Columns.Add(new ReportColumn() { DataType = ReportColumnType.DateTime, Label = "Created", Name = "Created", CanDisplay = true }); // format is either SrID_ OR _IncidentID this.Columns.Add(new ReportColumn() { DataType = ReportColumnType.String, Label = "HiddenSRconcatIncident_ID", Name = "HiddenSRconcatIncident_ID", CanDisplay = true, CanFilter = true }); }