public void UpdateCustomerOrderDetail(Database database, CustomerOrderViewDTO data) { //InventoryTransactionDAO dao = new InventoryTransactionDAO(database); //InventoryTransactionDTO dto = dao.LoadByPK(null, TRANS_ID); CustomerOrderDDAO dao = new CustomerOrderDDAO(database); dao.UpdateWithoutPK(database, CustomerOrderViewDTO2CustomerOrderDDTO(data)); }
public void AddCustomerOrderDetail(Database database, List <CustomerOrderViewDTO> ListAdd) { //== Dispatcher Transaction Type. RunningNumberBIZ runningNumberBIZ = new RunningNumberBIZ(); for (int i = 0; i < ListAdd.Count; i++) { if (ListAdd[i].ORDER_DETAIL_NO.IsNull || ListAdd[i].ORDER_DETAIL_NO.Value == null || ListAdd[i].ORDER_DETAIL_NO.Value.ToString() == "") { // Generate new Transaction ID. NZString runningNo = runningNumberBIZ.GetCompleteRunningNo((NZString)"CUSTOMER_ORDER_DETAIL_NO", (NZString)"TB_CUSTOMER_ORDERD_TR"); ListAdd[i].ORDER_DETAIL_NO = runningNo; } // Add Inventory transaction. CustomerOrderDDAO dao = new CustomerOrderDDAO(database); ListAdd[i].CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD; ListAdd[i].CRT_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine; ListAdd[i].UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD; ListAdd[i].UPD_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine; if (dao.AddNewOrUpdate(database, CustomerOrderViewDTO2CustomerOrderDDTO(ListAdd[i])) <= 0) { throw new ValidateException("Insert failed. Data is missing, Please check your data."); } //data.TRANS_CLS = transType; // Start update stock. //UpdateInventoryOnhand(database, data, DataDefine.eOperationClass.Add); //if (data.TRANS_CLS == DataDefine.Convert2ClassCode(DataDefine.eTRANS_TYPE.Receiving)) //{ // dao.UpdatePOBalance(null, data, data.QTY.StrongValue); //} } }
public void DeleteCustomerOrderDetail(Database database, CustomerOrderViewDTO data) { CustomerOrderDDAO dao = new CustomerOrderDDAO(); dao.Delete(database, data.ORDER_NO.Value.ToString(), data.ORDER_DETAIL_NO); }
public List <CustomerOrderDDTO> LoadCustomerOrderDetail(String Order_No) { CustomerOrderDDAO dao = new CustomerOrderDDAO(CommonLib.Common.CurrentDatabase); return(dao.LoadAllDetail(null, Order_No)); }
public CustomerOrderDDTO LoadCustomerOrderDetail(String Order_No, NZString Order_Detail_No) { CustomerOrderDDAO dao = new CustomerOrderDDAO(CommonLib.Common.CurrentDatabase); return(dao.LoadByPK(null, Order_No, Order_Detail_No)); }