public void DeleteGroupTransaction(NZString OrderNo) { try { Common.CurrentDatabase.KeepConnection = true; Common.CurrentDatabase.BeginTransaction(); CustomerOrderBIZ biz = new CustomerOrderBIZ(); List <CustomerOrderViewDTO> dto = biz.LoadCustomerOrderEntry(OrderNo, false); biz.DeleteCustomerOrderHeader(Common.CurrentDatabase, dto); Common.CurrentDatabase.Commit(); } catch (Exception ex) { Common.CurrentDatabase.Rollback(); throw ex; } }
public CustomerOrderEntryUIDM LoadData(NZString orderNo) { CustomerOrderBIZ biz = new CustomerOrderBIZ(); CustomerOrderViewDTO ViewDTO = biz.LoadCustomerOrderHeader(orderNo, false); List <CustomerOrderViewDTO> listViewDTO = biz.LoadCustomerOrderEntry(orderNo, false); if (ViewDTO != null) { CustomerOrderEntryUIDM model = MapDTOToUIDM(ViewDTO); model.DATA_VIEW = DTOUtility.ConvertListToDataTable(listViewDTO); //== Ensure that data has not modified. model.DATA_VIEW.AcceptChanges(); return(model); } return(new CustomerOrderEntryUIDM()); }
private void OnDelete() { try { NZString OrderNo = new NZString(null, shtCustomerOrderList.GetValue(shtCustomerOrderList.ActiveRowIndex, (int)eColView.ORDER_NO)); NZString OrderDetailNo = new NZString(null, shtCustomerOrderList.GetValue(shtCustomerOrderList.ActiveRowIndex, (int)eColView.ORDER_DETAIL_NO)); MessageDialogResult dr = MessageDialog.ShowConfirmation(this, new Message(Messages.eConfirm.CFM9002.ToString()), MessageDialogButtons.YesNo); if (dr == MessageDialogResult.No) { return; } m_controller.DeleteItem(OrderNo, OrderDetailNo); // When detail row <= 0 then delete header row CustomerOrderBIZ biz = new CustomerOrderBIZ(); if (biz.LoadCustomerOrderEntry(OrderNo, false).Count <= 0) { biz.DeleteCustomerOrderHeader(Common.CurrentDatabase, OrderNo); } shtCustomerOrderList.RemoveRows(shtCustomerOrderList.ActiveRowIndex, 1); MessageDialog.ShowInformation(this, null, new Message(Messages.eInformation.INF9003.ToString()).MessageDescription); } catch (BusinessException err) { MessageDialog.ShowBusiness(this, err.Error.Message); err.Error.FocusOnControl(); } catch (ValidateException err) { MessageDialog.ShowBusiness(this, err.ErrorResults[0].Message); err.ErrorResults[0].FocusOnControl(); } catch (Exception err) { MessageDialog.ShowBusiness(this, err.Message); } }
public void DeleteItem(NZString OrderNo, NZString OrderDetailNo) { try { Common.CurrentDatabase.KeepConnection = true; Common.CurrentDatabase.BeginTransaction(); CustomerOrderBIZ biz = new CustomerOrderBIZ(); CustomerOrderViewDTO dtoDelItem = new CustomerOrderViewDTO(); dtoDelItem.ORDER_NO = OrderNo; dtoDelItem.ORDER_DETAIL_NO = OrderDetailNo; biz.DeleteCustomerOrderDetail(Common.CurrentDatabase, dtoDelItem); biz.UpdateCustomerHeaderTotal(Common.CurrentDatabase, dtoDelItem); Common.CurrentDatabase.Commit(); } catch (Exception ex) { Common.CurrentDatabase.Rollback(); throw ex; } }
private void LoadData(NZDateTime from, NZDateTime to, NZInt filterType) { if (dtPeriodBegin.NZValue.IsNull || dtPeriodEnd.NZValue.IsNull) { if (dtPeriodBegin.NZValue.IsNull && dtPeriodEnd.NZValue.IsNull) { MessageDialog.ShowBusiness(this, Message.LoadMessage(TKPMessages.eValidate.VLM0105.ToString(), new object[] { "Period date begin and Delivery date end" })); } else if (dtPeriodBegin.NZValue.IsNull) { MessageDialog.ShowBusiness(this, Message.LoadMessage(TKPMessages.eValidate.VLM0105.ToString(), new object[] { "Period date begin" })); } else { MessageDialog.ShowBusiness(this, Message.LoadMessage(TKPMessages.eValidate.VLM0105.ToString(), new object[] { "Period date end" })); } return; } CustomerOrderBIZ biz = new CustomerOrderBIZ(); DataTable dt = DTOUtility.ConvertListToDataTable <CustomerOrderViewDTO>(biz.LoadCustomerOrderList(from, to, filterType, false)); shtCustomerOrderList.RowCount = 0; shtCustomerOrderList.DataSource = null; m_dtAllData = dt; FindDataFromMemory(); CalculateTotal(); //List<InventoryTransactionViewDTO> list = m_controller.LoadReceivingList(from, to); ////DataTable dt = DTOUtility.ConvertListToDataTable(list); //m_dtAllData = DTOUtility.ConvertListToDataTable(list); //shtCustomerOrderList.RowCount = 0; //shtCustomerOrderList.DataSource = null; //FindDataFromMemory(); //shtView.DataSource = m_dtAllData; // CtrlUtil.SpreadUpdateColumnSorting(shtView); }
//public CustomerOrderEntryUIDM LoadData(NZString orderNo) //{ // CustomerOrderBIZ biz = new CustomerOrderBIZ(); // List<CustomerOrderViewDTO> listViewDTO = DTOUtility.ConvertDataTableToList<CustomerOrderViewDTO>(biz.LoadCustomerOrderEntry(orderNo, false)); // if (listViewDTO != null) // { // if (listViewDTO.Count > 0) // { // CustomerOrderEntryUIDM model = MapDTOToUIDM(listViewDTO[0]); // model.DATA_VIEW = DTOUtility.ConvertListToDataTable(listViewDTO); // //== Ensure that data has not modified. // model.DATA_VIEW.AcceptChanges(); // return model; // } // } // return new CustomerOrderEntryUIDM(); //} #region SaveData public void Save(CustomerOrderEntryUIDM model, Common.eScreenMode Mode) { try { Common.CurrentDatabase.KeepConnection = true; Common.CurrentDatabase.BeginTransaction(IsolationLevel.Serializable); CustomerOrderBIZ biz = new CustomerOrderBIZ(); #region Validate Data //== If data not has to processing. if (model.DATA_VIEW == null || model.DATA_VIEW.Rows.Count == 0) { ValidateException.ThrowErrorItem(new ErrorItem(null, TKPMessages.eValidate.VLM0055.ToString())); } DataTable dtNonDelete = model.DATA_VIEW.GetChanges(DataRowState.Unchanged | DataRowState.Added | DataRowState.Modified); List <CustomerOrderViewDTO> listData = DTOUtility.ConvertDataTableToList <CustomerOrderViewDTO>(dtNonDelete); #endregion DataTable dtData = model.DATA_VIEW.Copy(); DataTable dtAdd = dtData.GetChanges(DataRowState.Added); DataTable dtModify = dtData.GetChanges(DataRowState.Modified); DataTable dtDelete = dtData.GetChanges(DataRowState.Deleted); //ORDER_DETAIL_NO, //ITEM_CD, //ITEM_CD_BTN, //PART_NO, //ITEM_DELIVERY_DATE, //OLD_ITEM_DELIVERY_DATE, //QTY, //OLD_QTY, //PRICE, //AMOUNT, //PRICE_THB, //AMOUNT_THB // แก้บั๊ก GetChange แล้ว Data ไม่ถูกต้อง dtData.AcceptChanges(); if (dtModify != null && dtModify.Rows.Count > 0) { for (int i = 0; i < dtModify.Rows.Count; i++) { for (int j = 0; j < dtData.Rows.Count; j++) { if (Convert.ToString(dtModify.Rows[i]["ORDER_DETAIL_NO"]) == Convert.ToString(dtData.Rows[j]["ORDER_DETAIL_NO"])) { dtModify.Rows[i]["ITEM_CD"] = dtData.Rows[j]["ITEM_CD"]; dtModify.Rows[i]["PART_NO"] = dtData.Rows[j]["PART_NO"]; dtModify.Rows[i]["ITEM_DELIVERY_DATE"] = dtData.Rows[j]["ITEM_DELIVERY_DATE"]; dtModify.Rows[i]["QTY"] = dtData.Rows[j]["QTY"]; dtModify.Rows[i]["PRICE"] = dtData.Rows[j]["PRICE"]; dtModify.Rows[i]["AMOUNT"] = dtData.Rows[j]["AMOUNT"]; dtModify.Rows[i]["PRICE_THB"] = dtData.Rows[j]["PRICE_THB"]; dtModify.Rows[i]["AMOUNT_THB"] = dtData.Rows[j]["AMOUNT_THB"]; } } } } List <CustomerOrderViewDTO> listAdd = new List <CustomerOrderViewDTO>(); List <CustomerOrderViewDTO> listUpdate = new List <CustomerOrderViewDTO>(); List <CustomerOrderViewDTO> listDelete = new List <CustomerOrderViewDTO>(); //มีการปรับให้ทำคำสั่งทีละ set ของ add , update , delete เลย //ที่เริ่มจาก delete ก่อนเพราะ consumption จะได้มีการเอาไปใช้สำหรับตัวที่ add ได้เลย ไม่ต้องค้างไว้ lot หน้า //== Delete process. if (dtDelete != null && dtDelete.Rows.Count > 0) { listDelete = DTOUtility.ConvertDataTableToList <CustomerOrderViewDTO>(dtDelete); for (int i = 0; i < listDelete.Count; i++) { AssignHeaderToDTO(model, listDelete[i], Mode); } biz.SaveCustomerOrder(Common.CurrentDatabase, null, null, listDelete, Mode); // When detail row <= 0 then delete header row if ((dtAdd == null || dtAdd.Rows.Count == 0) && (dtModify == null || dtModify.Rows.Count == 0) && biz.LoadCustomerOrderEntry(listDelete[0].ORDER_NO, false).Count <= 0) { biz.DeleteCustomerOrderHeader(Common.CurrentDatabase, listDelete); } } //== Insert process. if (dtAdd != null && dtAdd.Rows.Count > 0) { listAdd = DTOUtility.ConvertDataTableToList <CustomerOrderViewDTO>(dtAdd); List <CustomerOrderViewDTO> listAddEachDetail = null; NZString runningNo = null; RunningNumberBIZ runningNumberBIZ = new RunningNumberBIZ(); if (model.ORDER_NO.IsNull) { runningNo = runningNumberBIZ.GetCompleteRunningNo((NZString)"CUSTOMER_ORDER_NO", (NZString)"TB_CUSTOMER_ORDERH_TR"); model.ORDER_NO = runningNo; // Insert Header AssignHeaderToDTO(model, listAdd[0], Mode); biz.AddCustomerOrderHeader(Common.CurrentDatabase, listAdd[0]); } else { runningNo = model.ORDER_NO; } listAddEachDetail = new List <CustomerOrderViewDTO>(); for (int i = 0; i < listAdd.Count; i++) { CustomerOrderViewDTO dto = listAdd[i]; // Copy ค่า Header จาก Model ไปยัง DTO แต่ละตัว AssignHeaderToDTO(model, dto, Mode); //dto.TRANS_ID = runningNumberBIZ.GetCompleteRunningNo(DataDefine.TRANS_ID.ToNZString(), DataDefine.TRANSACTION_TABLE_NAME.ToNZString()); //add header ใส่ list dto.CRT_BY = Common.CurrentUserInfomation.UserCD; dto.CRT_MACHINE = Common.CurrentUserInfomation.Machine; dto.UPD_BY = Common.CurrentUserInfomation.UserCD; dto.UPD_MACHINE = Common.CurrentUserInfomation.Machine; // Check all lines. listAddEachDetail.Add(dto); } biz.SaveCustomerOrder(Common.CurrentDatabase, listAddEachDetail, null, null, Mode); } //== Update process. if (dtModify != null && dtModify.Rows.Count > 0) { listUpdate = DTOUtility.ConvertDataTableToList <CustomerOrderViewDTO>(dtModify); List <CustomerOrderViewDTO> listUpdateDetail = new List <CustomerOrderViewDTO>(); for (int i = 0; i < listUpdate.Count; i++) { CustomerOrderViewDTO dto = listUpdate[i]; CustomerOrderBIZ bizCustomer = new CustomerOrderBIZ(); CustomerOrderDDTO dtoDDTO = bizCustomer.LoadCustomerOrderDetail(dto.ORDER_NO.StrongValue, dto.ORDER_DETAIL_NO); // Copy ค่า Header จาก Model ไปยัง DTO แต่ละตัว AssignHeaderToDTO(model, dto, Mode); dto.CRT_BY = Common.CurrentUserInfomation.UserCD; dto.CRT_MACHINE = Common.CurrentUserInfomation.Machine; dto.UPD_BY = Common.CurrentUserInfomation.UserCD; dto.UPD_MACHINE = Common.CurrentUserInfomation.Machine; //add header ใส่ list listUpdateDetail.Add(dto); } biz.SaveCustomerOrder(Common.CurrentDatabase, null, listUpdateDetail, null, Mode); } //Update Header for Edit Case //if (Mode == Common.eScreenMode.EDIT && dtData != null && dtData.Rows.Count > 0) //{ // listUpdate = DTOUtility.ConvertDataTableToList<CustomerOrderViewDTO>(dtData); // for (int i = 0; i < listUpdate.Count; i++) // { // CustomerOrderViewDTO dto = listUpdate[i]; // // Copy ค่า Header จาก Model ไปยัง DTO แต่ละตัว // AssignHeaderToDTO(model, dto); // dto.CRT_BY = Common.CurrentUserInfomation.UserCD; // dto.CRT_MACHINE = Common.CurrentUserInfomation.Machine; // dto.UPD_BY = Common.CurrentUserInfomation.UserCD; // dto.UPD_MACHINE = Common.CurrentUserInfomation.Machine; // biz.UpdateCustomerOrderHeader(Common.CurrentDatabase, dto); // } //} Common.CurrentDatabase.Commit(); } catch (Exception) { Common.CurrentDatabase.Rollback(); throw; } }