public SyncFromDepartmentToMain GetSyncData(bool IsSubmitPeriod,DateTime lastSyncTime) { // Save the end of period // select 5 day nearest var sync = new SyncFromDepartmentToMain(); // find unconfirm department stock ObjectCriteria deptTempCrit = new ObjectCriteria(); //deptTempCrit.AddEqCriteria("DelFlg", CommonConstants.DEL_FLG_NO); IList deptTempList = DepartmentStockTempDAO.FindAll(null); sync.DepartmentStockTempList = deptTempList; // find timeline IList departmentTimelineList = DepartmentTimelineDAO.FindAll(null); // find po IList poList = PurchaseOrderDAO.FindAll(null); // find po detail foreach (PurchaseOrder po in poList) { var criteria = new ObjectCriteria(); criteria.AddEqCriteria("PurchaseOrderDetailPK.PurchaseOrderId", po.PurchaseOrderPK.PurchaseOrderId); po.PurchaseOrderDetails = PurchaseOrderDetailDAO.FindAll(criteria); } // find stock history ObjectCriteria incrementalCrit = new ObjectCriteria(); incrementalCrit.AddGreaterOrEqualsCriteria("CreateDate", lastSyncTime); IList stockHistoryList = DepartmentStockHistoryDAO.FindAll(incrementalCrit); // find dept stock out IList deptStockOutList = DepartmentStockOutDAO.FindAll(incrementalCrit); // find dept stock out detail foreach (DepartmentStockOut so in deptStockOutList) { var criteria = new ObjectCriteria(); criteria.AddEqCriteria("DepartmentStockOut.DepartmentStockOutPK.StockOutId", so.DepartmentStockOutPK.StockOutId); so.DepartmentStockOutDetails = DepartmentStockOutDetailDAO.FindAll(criteria); } // find dept stock IList deptStock = DepartmentStockDAO.FindAll(null); // find return PO IList returnPoList = ReturnPoDAO.FindAll(null); // dept restock in /*var crit = new ObjectCriteria(); crit.AddEqCriteria("StockInType", (long) 1);*/ //IList deptReStockInList = DepartmentStockInDAO.FindAll(crit); IList deptStockInList = DepartmentStockInDAO.FindAll(incrementalCrit); foreach (DepartmentStockIn si in deptStockInList) { var criteria = new ObjectCriteria(); criteria.AddEqCriteria("DepartmentStockIn.DepartmentStockInPK.StockInId", si.DepartmentStockInPK.StockInId); si.DepartmentStockInDetails = DepartmentStockInDetailDAO.FindAll(criteria); } sync.DepartmentStockOutList = deptStockOutList; sync.DepartmentStockHistoryList = stockHistoryList; sync.DepartmentStockList = deptStock; sync.PurchaseOrderList = poList; sync.ReturnPoList = returnPoList; sync.DepartmentStockInList = deptStockInList; sync.DepartmentTimelineList = departmentTimelineList; // get money info sync.EmployeeMoneyList = EmployeeMoneyDAO.FindAll(null); sync.DepartmentCostList = DepartmentCostDAO.FindAll(null); // end period confirmation //DepartmentTimeline timeline = new DepartmentTimeline(); return sync; }