예제 #1
0
        public static List <OrderDetailsViewBO> GetOrders(string searchText, int LogcompanyID, string status, int coordinator, int distributor, int client, DateTime?selecteddate1, DateTime?selecteddate2, int distributorclientaddress)
        {
            using (IndicoEntities objContext = new IndicoEntities())
            {
                System.Data.Objects.ObjectParameter recCount = new System.Data.Objects.ObjectParameter("P_RecCount", typeof(int));
                List <OrderDetailsViewBO>           lst      = OrderDetailsViewBO.ToList(objContext.ViewOrderDetails(searchText, LogcompanyID, status, coordinator, distributor, client, selecteddate1, selecteddate2, distributorclientaddress));

                return(lst);
            }
        }
예제 #2
0
        public static List <OrderDetailsViewBO> GetWeeklyLessFiveItemOrders(DateTime?weekEndDate, string searchText, string OrderStatus, int sort, bool orderby, int set, int maxRows, out int total, string coordinator, string distributor, string client, int distributorclientaddress)
        {
            using (IndicoEntities objContext = new IndicoEntities())
            {
                System.Data.Objects.ObjectParameter recCount = new System.Data.Objects.ObjectParameter("P_RecCount", typeof(int));
                List <OrderDetailsViewBO>           lst      = OrderDetailsViewBO.ToList(objContext.GetWeeklyLessFiveItemOrders(weekEndDate, searchText, OrderStatus, sort, orderby, set, maxRows, recCount, coordinator, distributor, client, distributorclientaddress));
                total = (int)recCount.Value;

                return(lst);
            }
        }
예제 #3
0
        public static List <OrderDetailsViewBO> GetWeeklyHoldOrders(DateTime?weekEndDate, string searchText, string OrderStatus, string coordinator, string distributor, string client, int distributorclientaddress)
        {
            using (IndicoEntities objContext = new IndicoEntities())
            {
                // System.Data.Objects.ObjectParameter recCount = new System.Data.Objects.ObjectParameter("P_RecCount", typeof(int));
                List <OrderDetailsViewBO> lst = OrderDetailsViewBO.ToList(objContext.GetWeeklyHoldOrders(weekEndDate, searchText, OrderStatus, coordinator, distributor, client, distributorclientaddress));
                //total = (int)recCount.Value;

                return(lst);
            }
        }