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;
}
