using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; namespace GB5Shared.DTO.Report { public class ReportViewFieldsDTO { #region PrivateMembers #region ReportViewFields private int reportviewfieldsid; //Id #region Report private int reportid; //Id private string reportname; //Name #endregion #region ReportView private int reportviewid; //Id private string reportviewname; //Name private byte reportviewpageformat; private byte reportviewpageorientation; private string reportvieworderbyfields; #endregion #region ReportVsFields private int reportvsfieldsid; //Id private string reportvsfieldsfieldname; private byte reportvsfieldsfieldtype; private byte reportvsfieldsobjectfieldtype; #endregion private Int16 reportviewfieldsslno; //SlNo private string reportviewfieldsfieldtitle; //FieldTitle private Int16 reportviewfieldsfieldwidth; //FieldWidth private byte reportviewfieldsisdisplay; //IsDisplay private byte reportviewfieldsismergecolumn; //IsMergeColumn private byte reportviewfieldsisgroupcolumn; //IsGroupcolumn private byte reportviewfieldsissubtotal; //IsSubTotal private byte reportviewfieldsisgrandtotal; //IsGrandTotal private string reportviewfieldscalformat; //CalFormat private Int16 reportviewfieldsdisplayslno; //DisplaySlNo private byte reportviewfieldsalignment; private byte reportviewfieldsdisplaytype = 0; private byte reportviewfieldsaggregationtype = 1; private byte reportviewfieldsiscolumntotal = 1; private byte reportviewfieldsisrowtotal = 1; private int reportviewfieldspivotlevel = 1; private byte reportviewfieldssuppressifempty = 1;//Default 1 --0 Yes 1 No private int dimensionfieldid = -1; private string dimensionfieldname; private int reportviewfieldsrowlevel = 0; private string reportvsfieldscomputeexpression; #endregion #endregion #region PublicMembers #region ReportViewFields public int ReportViewFieldsId { get { return reportviewfieldsid; } //Id set { reportviewfieldsid = value; } //Id } public int ReportViewFieldsRowLevel { get { return reportviewfieldsrowlevel; } set { reportviewfieldsrowlevel = value; } } #region Report public int ReportId { get { return reportid; } //Id set { reportid = value; } //Id } public string ReportName { get { return reportname; } //Name set { reportname = value; } //Name } #endregion #region ReportView public int ReportViewId { get { return reportviewid; } //Id set { reportviewid = value; } //Id } public string ReportViewName { get { return reportviewname; } //Name set { reportviewname = value; } //Name } public byte ReportViewPageFormat { get { return reportviewpageformat; } set { reportviewpageformat = value; } } public byte ReportViewPageOrientation { get { return reportviewpageorientation; } set { reportviewpageorientation = value; } } public string ReportViewOrderbyFields { get { return reportvieworderbyfields; } set { reportvieworderbyfields = value; } } #endregion #region Report public int ReportVsFieldsId { get { return reportvsfieldsid; } //Id set { reportvsfieldsid = value; } //Id } public string ReportVsFieldsFieldName { get { return reportvsfieldsfieldname; } set { reportvsfieldsfieldname = value; } } // Non-null/non-empty means this is a computed/derived field (MREPORTVSFIELDS.COMPUTEEXPRESSION) // -- evaluated per-row by GB5Shared/Export/ComputedFieldEvaluator.cs, not returned by the // report's own SQL/DAL. public string ReportVsFieldsComputeExpression { get { return reportvsfieldscomputeexpression; } set { reportvsfieldscomputeexpression = value; } } public byte ReportVsFieldsFieldType { get { return reportvsfieldsfieldtype; } set { reportvsfieldsfieldtype = value; } } public byte ReportVsFieldsObjectFieldType { get { return reportvsfieldsobjectfieldtype; } set { reportvsfieldsobjectfieldtype = value; } } #endregion public Int16 ReportViewFieldsSlNo { get { return reportviewfieldsslno; } //SlNo set { reportviewfieldsslno = value; } //SlNo } public string ReportViewFieldsFieldTitle { get { return reportviewfieldsfieldtitle; } //FieldTitle set { reportviewfieldsfieldtitle = value; } //FieldTitle } public Int16 ReportViewFieldsFieldWidth { get { return reportviewfieldsfieldwidth; } //FieldWidth set { reportviewfieldsfieldwidth = value; } //FieldWidth } public byte ReportViewFieldsIsDisplay { get { return reportviewfieldsisdisplay; } //IsDisplay set { reportviewfieldsisdisplay = value; } //IsDisplay } public byte ReportViewFieldsIsMergeColumn { get { return reportviewfieldsismergecolumn; } //IsMergeColumn set { reportviewfieldsismergecolumn = value; } //IsMergeColumn } public byte ReportViewFieldsIsGroupcolumn { get { return reportviewfieldsisgroupcolumn; } //IsGroupcolumn set { reportviewfieldsisgroupcolumn = value; } //IsGroupcolumn } public byte ReportViewFieldsIsSubTotal { get { return reportviewfieldsissubtotal; } //IsSubTotal set { reportviewfieldsissubtotal = value; } //IsSubTotal } public byte ReportViewFieldsIsGrandTotal { get { return reportviewfieldsisgrandtotal; } //IsGrandTotal set { reportviewfieldsisgrandtotal = value; } //IsGrandTotal } public string ReportViewFieldsCalFormat { get { return reportviewfieldscalformat; } //CalFormat set { reportviewfieldscalformat = value; } //CalFormat } public Int16 ReportViewFieldsDisplaySlNo { get { return reportviewfieldsdisplayslno; } //DisplaySlNo set { reportviewfieldsdisplayslno = value; } //DisplaySlNo } public byte ReportViewFieldsAlignment { get { return reportviewfieldsalignment; } set { reportviewfieldsalignment = value; } } public byte ReportViewFieldsDisplayType { get { return reportviewfieldsdisplaytype; } set { reportviewfieldsdisplaytype = value; } } public byte ReportViewFieldsAggregationType { get { return reportviewfieldsaggregationtype; } set { reportviewfieldsaggregationtype = value; } } public byte ReportViewFieldsIsColumnTotal { get { return reportviewfieldsiscolumntotal; } set { reportviewfieldsiscolumntotal = value; } } public byte ReportViewFieldsIsRowTotal { get { return reportviewfieldsisrowtotal; } set { reportviewfieldsisrowtotal = value; } } public int ReportViewFieldsPivotLevel { get { return reportviewfieldspivotlevel; } set { reportviewfieldspivotlevel = value; } } public byte ReportViewFieldsSuppressIfEmpty { get { return reportviewfieldssuppressifempty; } set { reportviewfieldssuppressifempty = value; } } public int DimensionFieldId { get { return dimensionfieldid; } set { dimensionfieldid = value; } } public string DimensionFieldName { get { return dimensionfieldname; } set { dimensionfieldname = value; } } #endregion #endregion } }