Exemple #1
0
        public POContentGridViewModel(List <POContent> POContents,
                                      List <PurchaseItem> _items,
                                      IPurchaseRequestRepository PRRepository, //IPurchaseItemRepository PurchaseItemRepository
                                      ITaskRepository TaskRepository)
        {
            rows = new List <POContentGridRowModel>();
            string                 _eta;
            string                 _prNumber;
            List <Task>            _tasks = TaskRepository.Tasks.ToList();
            List <PurchaseRequest> _preqs = PRRepository.PurchaseRequests.ToList();

            foreach (POContent _poContent in POContents)
            {
                PurchaseItem _item = _items.Where(p => p.PurchaseItemID == _poContent.PurchaseItemID).FirstOrDefault() ?? new PurchaseItem(); // (PurchaseItemRepository.QueryByID(_poContent.PurchaseItemID) ?? new PurchaseItem());
                Task         _task = _tasks.Where(t => t.TaskID == _item.TaskID).FirstOrDefault() ?? new Task();                              //(TaskRepository.QueryByTaskID(_item.TaskID) ?? new Task());
                double       time;
                if (_task.TaskType == 1)
                {
                    time = Math.Round(_task.Time / (_task.R + _task.F) / 60, 2);
                }
                else //if (Task.TaskType == 4)
                {
                    time = Math.Round(_task.Time / (_task.Quantity) / 60, 2);
                }

                try
                {
                    PurchaseRequest _pr = _preqs.Where(p => p.PurchaseRequestID == _item.PurchaseRequestID).FirstOrDefault() ?? new PurchaseRequest();//PRRepository.GetByID(_item.PurchaseRequestID);
                    _eta      = _pr.DueDate.ToString("yyyy-MM-dd");
                    _prNumber = _pr.PurchaseRequestNumber;
                }
                catch
                {
                    _eta      = "";
                    _prNumber = "";
                }
                rows.Add(new POContentGridRowModel(_poContent, _item, _eta, _prNumber, time));
            }
            Page    = 1;
            Total   = POContents.Count();
            Records = 500;
        }
Exemple #2
0
        public PurchaseItemGridViewModel(List <PurchaseItem> PurchaseItems,
                                         IPurchaseRequestRepository PurchaseRequestRepo,
                                         IQuotationRequestRepository QuotationRequestRepo,
                                         IPurchaseOrderRepository PurchaseOrderRepo,
                                         IUserRepository UserRepo,
                                         IPurchaseTypeRepository TypeRepo,
                                         IPurchaseItemRepository PurchaseItemRepo)
        {
            rows = new List <PurchaseItemGridRowModel>();
            List <PurchaseRequest>         _preqs   = PurchaseRequestRepo.PurchaseRequests.ToList();
            List <QuotationRequest>        _quoreqs = QuotationRequestRepo.QuotationRequests.ToList();
            List <PurchaseOrder>           _pos     = PurchaseOrderRepo.PurchaseOrders.ToList();
            List <User>                    _users   = UserRepo.Users.ToList();
            List <PurchaseType>            _types   = TypeRepo.PurchaseTypes.ToList();
            List <PurItemChangeDateRecord> _itemCDs = PurchaseItemRepo.PurItemChangeDateRecords.ToList();

            //List<PurchaseItem> _items = PurchaseItemRepo.PurchaseItems.ToList();

            foreach (PurchaseItem _item in PurchaseItems)
            {
                string _prNo, _qrNo, _poNo, _pocreateDate, _prcreDate;
                string _purchaseUser;
                #region region
                try
                {
                    if (_item.PurchaseRequestID > 0)
                    {
                        PurchaseRequest purRequest = _preqs.Where(p => p.PurchaseRequestID == _item.PurchaseRequestID).FirstOrDefault() ?? new PurchaseRequest(); //PurchaseRequestRepo.GetByID(_item.PurchaseRequestID);
                        _prNo      = purRequest.PurchaseRequestNumber;
                        _prcreDate = purRequest.CreateDate.ToString("yyyy-MM-dd HH:mm");
                    }
                    else
                    {
                        _prNo      = "";
                        _prcreDate = "";
                    }
                }
                catch
                {
                    _prNo      = "";
                    _prcreDate = "";
                }


                try
                {
                    if (_item.QuotationRequestID > 0)
                    {
                        _qrNo = (_quoreqs.Where(p => p.QuotationRequestID == _item.QuotationRequestID).FirstOrDefault() ?? new QuotationRequest()).QuotationNumber;//QuotationRequestRepo.GetByID(_item.QuotationRequestID).QuotationNumber;
                    }
                    else
                    {
                        _qrNo = "";
                    }
                }
                catch
                {
                    _qrNo = "";
                }


                try
                {
                    if (_item.PurchaseOrderID > 0)
                    {
                        _poNo         = (_pos.Where(p => p.PurchaseOrderID == _item.PurchaseOrderID).FirstOrDefault() ?? new PurchaseOrder()).PurchaseOrderNumber;//PurchaseOrderRepo.QueryByID(_item.PurchaseOrderID).PurchaseOrderNumber;
                        _pocreateDate = PurchaseOrderRepo.QueryByID(_item.PurchaseOrderID).CreateDate.ToString("yyyy-MM-dd HH:mm");
                    }
                    else
                    {
                        _poNo         = "";
                        _pocreateDate = "";
                    }
                }
                catch
                {
                    _poNo         = "";
                    _pocreateDate = "";
                }


                try
                {
                    if (_item.PurchaseUserID > 0)
                    {
                        _purchaseUser = (_users.Where(u => u.UserID == _item.PurchaseUserID).FirstOrDefault() ?? new User()).FullName;//UserRepo.GetUserByID(_item.PurchaseUserID).FullName;
                    }
                    else
                    {
                        _purchaseUser = "";
                    }
                }
                catch
                {
                    _purchaseUser = "";
                }

                string _purchaseType;
                try
                {
                    _purchaseType = (_types.Where(t => t.PurchaseTypeID == _item.PurchaseType && t.Enabled).FirstOrDefault() ?? new PurchaseType()).Name;//TypeRepo.QueryByID(_item.PurchaseType).Name;
                }
                catch
                {
                    _purchaseType = "";
                }

                string _requestUser;
                try
                {
                    if (_item.RequestUserID > 0)
                    {
                        _requestUser = (_users.Where(u => u.UserID == _item.RequestUserID).FirstOrDefault() ?? new User()).FullName;//UserRepo.GetUserByID(_item.RequestUserID).FullName;
                    }
                    else
                    {
                        _requestUser = "";
                    }
                }
                catch
                {
                    _requestUser = "";
                }
                #endregion
                string _htmlTitle = "";
                List <PurItemChangeDateRecord> _puritems = PurchaseItemRepo.GetPurItemChangeDateRecords(_itemCDs, _item.PurchaseItemID);
                if (_puritems.Count > 0)
                {
                    _htmlTitle = "<table><tr><th>调整后计划</th><th>调整人</th><th>调整时间</th></tr>";
                    foreach (var r in _puritems)
                    {
                        _htmlTitle = _htmlTitle + "<tr>";
                        _htmlTitle = _htmlTitle + "<td>" + ((r.PlanAJDate == new DateTime(1900, 1, 1) ? "-" : r.PlanAJDate.ToString("yyyy-MM-dd"))) + "</td>";
                        _htmlTitle = _htmlTitle + "<td>" + r.UserName.ToString() + "</td>";
                        _htmlTitle = _htmlTitle + "<td>" + ((r.CreDate == new DateTime(1900, 1, 1) ? "-" : r.CreDate.ToString("yyyy-MM-dd HH:mm"))) + "</td>";
                        _htmlTitle = _htmlTitle + "</tr>";
                    }
                    _htmlTitle = _htmlTitle + "</table>";
                }
                else
                {
                    _htmlTitle = "";
                }

                PurchaseItemGridRowModel _row = new PurchaseItemGridRowModel(_item, _prNo, _qrNo, _poNo, _purchaseUser, _purchaseType, _requestUser, _htmlTitle, _pocreateDate, _prcreDate);
                rows.Add(_row);
            }
            Records = PurchaseItems.Count();
        }
 public WorkHourController(ITaskRepository TaskRepository,
                           IPartRepository PartRepository,
                           IProjectRepository ProjectRepository,
                           IUserRepository UserRepository,
                           ICNCItemRepository CNCItemRepository,
                           IQCInfoRepository QCInfoRepository,
                           IWarehouseStockRepository WarehouseStockRepository,
                           IMachineRepository MachineRepository,
                           ICNCMachInfoRepository CNCMachInfoRepository,
                           ISteelGroupProgramRepository SteelGroupProgramRepository,
                           ISteelProgramRepository SteelProgramRepository,
                           IEDMSettingRepository EDMSettingRepository,
                           IEDMDetailRepository EDMDetailRepository,
                           IQCPointProgramRepository QCPointProgramRepository,
                           ISystemConfigRepository SystemConfigRepository,
                           IQCSteelPointRepository QCSteelPointRepository,
                           ISteelCAMDrawingRepository SteelCAMDrawingRepository,
                           ISteelDrawingCADPartRepository SteelDrawingCADPartRepository,
                           ICAMDrawingRepository CAMDrawingRepository,
                           IProjectPhaseRepository ProjectPhaseRepository,
                           IPOContentRepository POContentRepository,
                           IQCTaskRepository QCTaskRepository,
                           IQCCmmReportRepository QCCmmReportRepository,
                           IQCCmmFileSettingRepository QCCmmFileSettingRepository,
                           IPRContentRepository PRContentRepository,
                           IPurchaseRequestRepository PurchanseRequestRepository,
                           ICharmillRepository CharmillRepository,
                           IEDMTaskRecordRepository EDMTaskRepository,
                           IDepartmentRepository DepartmentRepository,
                           IMGSettingRepository MGSettingRepository,
                           IWEDMSettingRepository WEDMSettingRepository,
                           ITaskHourRepository TaskHourRepository,
                           IMachinesInfoRepository MachinesInfoRepository,
                           ITaskTypeRepository TaskTypeRepositroy,
                           IWH_WorkTypeRepository WorkTypeRepository)
 {
     _taskRepository                = TaskRepository;
     _partRepository                = PartRepository;
     _projectRepository             = ProjectRepository;
     _userRepository                = UserRepository;
     _cncItemRepository             = CNCItemRepository;
     _qcInfoRepository              = QCInfoRepository;
     _whStockRepository             = WarehouseStockRepository;
     _machineRepository             = MachineRepository;
     _machInfoRepository            = CNCMachInfoRepository;
     _steelGroupProgramRepository   = SteelGroupProgramRepository;
     _steelProgramRepository        = SteelProgramRepository;
     _edmSettingRepository          = EDMSettingRepository;
     _edmDetailRepository           = EDMDetailRepository;
     _qcPointProgramRepository      = QCPointProgramRepository;
     _systemConfigRepository        = SystemConfigRepository;
     _qcSteelPointRepository        = QCSteelPointRepository;
     _steelCAMDrawingRepository     = SteelCAMDrawingRepository;
     _steelDrawingCADPartRepository = SteelDrawingCADPartRepository;
     _camDrawingRepository          = CAMDrawingRepository;
     _projectPhaseRepository        = ProjectPhaseRepository;
     _poContentRepository           = POContentRepository;
     _qcTaskRepository              = QCTaskRepository;
     _qcCmmReportRepository         = QCCmmReportRepository;
     _qcCmmFileSettingRepository    = QCCmmFileSettingRepository;
     _prContentRepository           = PRContentRepository;
     _prRepository           = PurchanseRequestRepository;
     _charmillRepository     = CharmillRepository;
     _edmRecordRepository    = EDMTaskRepository;
     _departmentRepository   = DepartmentRepository;
     _mgSettingRepository    = MGSettingRepository;
     _wedmSettingRepository  = WEDMSettingRepository;
     _taskHourRepository     = TaskHourRepository;
     _machinesinfoRepository = MachinesInfoRepository;
     _taskTyprRepository     = TaskTypeRepositroy;
     _workTyprRepository     = WorkTypeRepository;
 }