Example #1
0
        public static InqDefineSource Get_InqDefineSource1(int top)
        {
            var iqr = new InqDefineSource("bcd");

            // Select
            iqr.AddField("FACTSAR", "CardCode");
            iqr.AddField("FACTSAR", "ItemCode");
            iqr.AddField("FACTSAR", "SlpCode");
            iqr.AddField("DimItem", "ItemName");
            iqr.AddField("DimItem", "ItmsGrpCod");
            iqr.AddField("DimItemGroup", "ItmsGrpNam");
            iqr.AddField("DimSalePerson", "SlpName");
            // Summary
            //iqr.AddSummary("FACTSAR", "Quantity", "SUM");
            //iqr.AddSummary("FACTSAR", "VatSum", "SUM");
            // Filter
            iqr.AddFilter(new InqFieldInfo("FACTSAR", "ItemCode", "NTEXT"), ">=", "2X3RT4-BLACK");
            iqr.AddFilter(new InqFieldInfo("FACTSAR", "ItemCode", "NTEXT"), "<=", "DD2-1G-800-NB");
            //iqr.AddFilter(iqr.Summaries[0], ">=", "0");

            foreach (var item in iqr.Fields)
            {
                item.OrderName = "ASC";
            }
            foreach (var item in iqr.Summaries)
            {
                item.Field.OrderName = "DESC";
            }
            return(iqr);
        }
Example #2
0
        public static InqDefineSource Get_InqDefineSource(int top)
        {
            var iqr = new InqDefineSource("abc");

            iqr.AddTblName("DimItem", "DimItemGroup", "DimSalePerson", "FACTSAR");
            // Select
            iqr.AddField("FACTSAR", "CardCode");
            iqr.AddField("FACTSAR", "ItemCode");
            iqr.AddField("FACTSAR", "SlpCode");
            iqr.AddField("DimItem", "ItemName");
            iqr.AddField("DimItem", "ItmsGrpCod");
            iqr.AddField("DimItemGroup", "ItmsGrpNam");
            iqr.AddField("DimSalePerson", "SlpName");
            // Summary
            iqr.AddSummary("FACTSAR", "Quantity", "SUM");
            iqr.AddSummary("FACTSAR", "VatSum", "SUM");
            // Filter
            iqr.AddFilter(new InqFieldInfo("FACTSAR", "ItemCode", "NTEXT"), ">=", "2X3RT4-BLACK");
            iqr.AddFilter(new InqFieldInfo("FACTSAR", "ItemCode", "NTEXT"), "<=", "DD2-1G-800-NB");
            iqr.AddFilter(iqr.Summaries[0], ">=", "0");
            //// Order By
            //iqr.AddOrder("FACTSAR", "VatSum_Sum", "DESC");
            //iqr.AddOrder("FACTSAR", "Quantity_Sum", "DESC");
            return(iqr);
        }
Example #3
0
 public static InqDefineSource Get_InqDefineSource(int top)
 {
     var iqr = new InqDefineSource("abc");
     iqr.AddTblName("DimItem", "DimItemGroup", "DimSalePerson", "FACTSAR");
     // Select
     iqr.AddField("FACTSAR", "CardCode");
     iqr.AddField("FACTSAR", "ItemCode");
     iqr.AddField("FACTSAR", "SlpCode");
     iqr.AddField("DimItem", "ItemName");
     iqr.AddField("DimItem", "ItmsGrpCod");
     iqr.AddField("DimItemGroup", "ItmsGrpNam");
     iqr.AddField("DimSalePerson", "SlpName");
     // Summary
     iqr.AddSummary("FACTSAR", "Quantity", "SUM");
     iqr.AddSummary("FACTSAR", "VatSum", "SUM");
     // Filter
     iqr.AddFilter(new InqFieldInfo("FACTSAR", "ItemCode", "NTEXT"), ">=", "2X3RT4-BLACK");
     iqr.AddFilter(new InqFieldInfo("FACTSAR", "ItemCode", "NTEXT"), "<=", "DD2-1G-800-NB");
     iqr.AddFilter(iqr.Summaries[0], ">=", "0");
     //// Order By
     //iqr.AddOrder("FACTSAR", "VatSum_Sum", "DESC");
     //iqr.AddOrder("FACTSAR", "Quantity_Sum", "DESC");
     return iqr;
 }
Example #4
0
        public static InqDefineSource Get_InqDefineSource1(int top)
        {
            var iqr = new InqDefineSource("bcd");
            // Select
            iqr.AddField("FACTSAR", "CardCode");
            iqr.AddField("FACTSAR", "ItemCode");
            iqr.AddField("FACTSAR", "SlpCode");
            iqr.AddField("DimItem", "ItemName");
            iqr.AddField("DimItem", "ItmsGrpCod");
            iqr.AddField("DimItemGroup", "ItmsGrpNam");
            iqr.AddField("DimSalePerson", "SlpName");
            // Summary
            //iqr.AddSummary("FACTSAR", "Quantity", "SUM");
            //iqr.AddSummary("FACTSAR", "VatSum", "SUM");
            // Filter
            iqr.AddFilter(new InqFieldInfo("FACTSAR", "ItemCode", "NTEXT"), ">=", "2X3RT4-BLACK");
            iqr.AddFilter(new InqFieldInfo("FACTSAR", "ItemCode", "NTEXT"), "<=", "DD2-1G-800-NB");
            //iqr.AddFilter(iqr.Summaries[0], ">=", "0");

            foreach (var item in iqr.Fields)
            {
                item.OrderName = "ASC";
            }
            foreach (var item in iqr.Summaries)
            {
                item.Field.OrderName = "DESC";
            }
            return iqr;
        }