コード例 #1
0
        //========================== GET ORDER COMPLETION JOURNAL FOR FACTORY ID ===========================================
        public static List<ViewPlanningJournal> GetOrderCompletionJournalForFactId(int factoryId)
        {

            var db = new IstokDoorsDBContext();

            db.usp_FillInValuesForOrderCompletionDropDownList();

            var dbOrderCompletionJournal = db.usp_FillInOrderCompletionJournalByFactoryId(factoryId);
             


            var myOrderCompletionJournalList = new List<ViewPlanningJournal>();

            foreach (var item in dbOrderCompletionJournal)
            {

                ViewPlanningJournal myViewPlnJrnl = new ViewPlanningJournal();

                myViewPlnJrnl.OrderId = item.OrderId;
                myViewPlnJrnl.FactoryId = item.FactoryId;
                myViewPlnJrnl.FactoryName = item.FactoryName;
                myViewPlnJrnl.OrderItemId = item.OrderItemId;
                myViewPlnJrnl.DoorId = item.DoorId;
                myViewPlnJrnl.Model = item.Model;
                myViewPlnJrnl.Color = item.Color;
                myViewPlnJrnl.CanvasSize = item.CanvasSize;
                myViewPlnJrnl.OrderedQuantity = item.OrderedQuantity;
                myViewPlnJrnl.FreetoAllocate = item.FreetoAllocate;
                myViewPlnJrnl.AllocateFromInventory = item.AllocateFromInventory??0;
                myViewPlnJrnl.ToBeManufacturedForOrder = item.ToBeManufacturedForOrder;
                myViewPlnJrnl.IsManufacturedForOrder = item.IsManufacturedForOrder; //needed for Order Completion DDL
                myViewPlnJrnl.LeftToBeManufacturedForOrder = item.LeftToBeManufacturedForOrder;
                myViewPlnJrnl.OrderItemIsDone = item.OrderItemIsDone;
                myViewPlnJrnl.AwaitingAllocationToOrders = item.AwaitingAllocationToOrders;
                myViewPlnJrnl.IsSelectedForProduction = item.IsSelectedForProduction;
                myViewPlnJrnl.AllocValueForDDList = item.AllocValueForDDList ?? 0; //needed for max Order Completion DDL
                myViewPlnJrnl.DropDownListItems =
                    ProjectMethods.GetValuesForOrderCompletionJournalDdL(item.AllocValueForDDList ?? 0,
                        item.IsManufacturedForOrder ?? 0);

                myOrderCompletionJournalList.Add(myViewPlnJrnl);

            }



            return myOrderCompletionJournalList;
        }