internal void UpdateShipQTY(NZString OrderDetailNo, decimal QTY) { Database db = Common.CurrentDatabase.CreateNewDatabase(); try { db.KeepConnection = true; db.BeginTransaction(IsolationLevel.Serializable); ShipmentBIZ bizShipment = new ShipmentBIZ(); bizShipment.UpdateShipmentDetail(db, OrderDetailNo, QTY); db.Commit(); } catch { db.Rollback(); throw; } finally { if (db.DBConnectionState == ConnectionState.Open) { db.Close(); } } }
public void Save(ReturnEntryUIDM model, Common.eScreenMode Mode) { NZString m_EditSlipNo; DataTable m_OldReturn = new DataTable(); DataTable m_NewReturn = new DataTable(); ReturnBIZ bizReturn = new ReturnBIZ(); Database db = Common.CurrentDatabase.CreateNewDatabase(); try { db.KeepConnection = true; db.BeginTransaction(IsolationLevel.Serializable); ShipmentBIZ bizShipment = new ShipmentBIZ(); //bizShipment.AddShipmentEntry(dtoInvTrnsList); if (Mode != Common.eScreenMode.ADD) { m_EditSlipNo = model.SLIP_NO; m_OldReturn = bizReturn.Load_ReturnListEntry(m_EditSlipNo, false); } IssueEntryValidator val = new IssueEntryValidator(); CommonBizValidator commonVal = new CommonBizValidator(); //== 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 dtData = model.DATA_VIEW; DataTable dtUnChange = new DataTable(); DataTable dtAdd = new DataTable(); DataTable dtModify = new DataTable(); DataTable dtDelete = new DataTable(); //if (Mode == Common.eScreenMode.ADD || m_OldReturn.Rows.Count <= 0) //{ dtUnChange = dtData.GetChanges(DataRowState.Unchanged); dtAdd = dtData.GetChanges(DataRowState.Added); dtModify = dtData.GetChanges(DataRowState.Modified); dtDelete = dtData.GetChanges(DataRowState.Deleted); /*} * else * { * dtAdd = dtData.Clone(); * dtModify = dtData.Clone(); * dtDelete = dtData.Clone(); * * m_NewReturn = model.DATA_VIEW.Copy(); * m_NewReturn.AcceptChanges(); * * // Manage for Update and Delete * for (int i = 0; i < m_OldReturn.Rows.Count; i++) * { * string OrderDetailNo = Convert.ToString(m_OldReturn.Rows[i]["REF_SLIP_NO"]); * string ItemCd = Convert.ToString(m_OldReturn.Rows[i]["ITEM_CD"]); * * //decimal ShipQTY = Convert.ToDecimal(m_OldReturn.Rows[i]["SHIP_QTY"]); * //decimal RemainableQTY = Convert.ToDecimal(m_OldReturn.Rows[i]["RETURNABLE_QTY"]); * decimal ReturnQTY = Convert.ToDecimal(m_OldReturn.Rows[i]["RETURN_QTY"]); * * bool found_order_detail = false; * for (int j = 0; j < m_NewReturn.Rows.Count; j++) * { * * if (Convert.ToString(m_NewReturn.Rows[j]["REF_SLIP_NO"]) == OrderDetailNo * && Convert.ToString(m_NewReturn.Rows[j]["ITEM_CD"]) == ItemCd * && Convert.ToDecimal(m_NewReturn.Rows[j]["RETURN_QTY"]) != ReturnQTY) * { * found_order_detail = true; * * // Delete Old * DataRow row = dtDelete.NewRow(); * row["TRANS_ID"] = m_OldReturn.Rows[i]["TRANS_ID"]; * row["ITEM_CD"] = m_OldReturn.Rows[i]["ITEM_CD"]; * row["LOC_CD"] = m_OldReturn.Rows[i]["LOC_CD"]; * row["TRANS_DATE"] = m_OldReturn.Rows[i]["TRANS_DATE"]; * row["TRANS_CLS"] = m_OldReturn.Rows[i]["TRANS_CLS"]; * row["IN_OUT_CLS"] = m_OldReturn.Rows[i]["IN_OUT_CLS"]; * row["RETURN_QTY"] = m_OldReturn.Rows[i]["RETURN_QTY"]; * row["REF_SLIP_NO"] = OrderDetailNo; * dtDelete.Rows.Add(row); * * * if (Convert.ToString(m_NewReturn.Rows[j]["REF_SLIP_NO"]) == OrderDetailNo * && Convert.ToString(m_NewReturn.Rows[j]["ITEM_CD"]) == ItemCd) * { * dtAdd.ImportRow(m_NewReturn.Rows[j]); * } * * } * else if (Convert.ToString(m_NewReturn.Rows[j]["REF_SLIP_NO"]) == OrderDetailNo * && Convert.ToString(m_NewReturn.Rows[j]["ITEM_CD"]) == ItemCd * && Convert.ToDecimal(m_NewReturn.Rows[j]["RETURN_QTY"]) == ReturnQTY) * { * found_order_detail = true; * } * * // In update have remove order * if (j == m_NewReturn.Rows.Count - 1 && !found_order_detail) * { * // Delete Old * DataRow row = dtDelete.NewRow(); * row["TRANS_ID"] = m_OldReturn.Rows[i]["TRANS_ID"]; * row["ITEM_CD"] = m_OldReturn.Rows[i]["ITEM_CD"]; * row["LOC_CD"] = m_OldReturn.Rows[i]["LOC_CD"]; * row["TRANS_DATE"] = m_OldReturn.Rows[i]["TRANS_DATE"]; * row["TRANS_CLS"] = m_OldReturn.Rows[i]["TRANS_CLS"]; * row["IN_OUT_CLS"] = m_OldReturn.Rows[i]["IN_OUT_CLS"]; * row["RETURN_QTY"] = m_OldReturn.Rows[i]["RETURN_QTY"]; * row["REF_SLIP_NO"] = OrderDetailNo; * dtDelete.Rows.Add(row); * } * } * } * * // Manage for check add new order on update mode * for (int i = 0; i < m_NewReturn.Rows.Count; i++) * { * string OrderDetailNo = Convert.ToString(m_NewReturn.Rows[i]["REF_SLIP_NO"]); * string ItemCd = Convert.ToString(m_NewReturn.Rows[i]["ITEM_CD"]); * * //decimal ShipQTY = Convert.ToDecimal(m_NewReturn.Rows[i]["SHIP_QTY"]); * //decimal RemainableQTY = Convert.ToDecimal(m_NewReturn.Rows[i]["RETURNABLE_QTY"]); * decimal ReturnQTY = Convert.ToDecimal(m_NewReturn.Rows[i]["RETURN_QTY"]); * bool found_order_detail = false; * for (int j = 0; j < m_OldReturn.Rows.Count; j++) * { * * if (Convert.ToString(m_OldReturn.Rows[j]["REF_SLIP_NO"]) == OrderDetailNo * && Convert.ToString(m_OldReturn.Rows[j]["ITEM_CD"]) == ItemCd * && Convert.ToDecimal(m_OldReturn.Rows[j]["RETURN_QTY"]) != ReturnQTY) * { * found_order_detail = true; * } * * * // Not found old order in new order then add new order * if (j == m_OldReturn.Rows.Count - 1 && !found_order_detail) * { * if (Convert.ToString(m_NewReturn.Rows[i]["REF_SLIP_NO"]) == OrderDetailNo * && Convert.ToString(m_NewReturn.Rows[i]["ITEM_CD"]) == ItemCd) * { * dtAdd.ImportRow(m_NewReturn.Rows[i]); * } * } * } * } * }*/ InventoryBIZ biz = new InventoryBIZ(); List <InventoryTransactionDTO> listAdd = null; List <InventoryTransactionDTO> listUpdate = null; List <InventoryTransactionDTO> listDelete = null; List <InventoryTransactionDTO> listUnChange = null; //== Insert process. if (dtAdd != null && dtAdd.Rows.Count > 0) { listAdd = new List <InventoryTransactionDTO>(); listAdd = DTOUtility.ConvertDataTableToList <InventoryTransactionDTO>(dtAdd); RunningNumberBIZ runningNumberBIZ = new RunningNumberBIZ(); NZString runningNo_SLIP_NO = null; NZString runningNo_GROUP_TRANS_ID = null; if (model.SLIP_NO.IsNull || model.SLIP_NO.Value == "") { runningNo_SLIP_NO = runningNumberBIZ.GetCompleteRunningNo((NZString)"RETURN_NO", (NZString)"TB_INV_TRANS_TR"); } else { runningNo_SLIP_NO = model.SLIP_NO; } if (model.GROUP_TRANS_ID.IsNull) { runningNo_GROUP_TRANS_ID = runningNumberBIZ.GetCompleteRunningNo(new NZString(null, "TRAN_GROUP_ID"), new NZString(null, "TB_INV_TRANS_TR")); } else { runningNo_GROUP_TRANS_ID = model.SLIP_NO; } for (int i = 0; i < listAdd.Count; i++) { InventoryTransactionDTO dto = listAdd[i]; // มีการ Gen Running Number ของ NO_LOT_TRANS_ID ไว้แล้วใน InventoryBIZ FN: AddInventoryTransaction //NZString runningNo_LOT_TRANS_ID = runningNumberBIZ.GetCompleteRunningNo(new NZString(null, "TRAN_ID"), new NZString(null, "TB_INV_TRANS_TR")); // Copy ค่า Header จาก Model ไปยัง DTO แต่ละตัว AssignHeaderToDTO(model, dto, Mode); dto.SLIP_NO = runningNo_SLIP_NO; dto.GROUP_TRANS_ID = runningNo_GROUP_TRANS_ID; //dto.TRANS_ID = runningNo_LOT_TRANS_ID; dto.CRT_BY = Common.CurrentUserInfomation.UserCD; dto.CRT_MACHINE = Common.CurrentUserInfomation.Machine; dto.UPD_BY = Common.CurrentUserInfomation.UserCD; dto.UPD_MACHINE = Common.CurrentUserInfomation.Machine; listAdd[i] = dto; // check for lot no if ship type is SHIP //if (model.TRANS_CLS.StrongValue != DataDefine.Convert2ClassCode(DataDefine.eTRANS_TYPE.Shipment_Return)) // ValidateException.ThrowErrorItem(commonVal.CheckInputLot(dto.ITEM_CD, dto.LOC_CD, dto.LOT_NO, true)); } } //== Update process. if (dtModify != null && dtModify.Rows.Count > 0) { listUpdate = DTOUtility.ConvertDataTableToList <InventoryTransactionDTO>(dtModify); for (int i = 0; i < listUpdate.Count; i++) { InventoryTransactionDTO dto = listUpdate[i]; // 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; listUpdate[i] = dto; } } //== Update for Unchage กรณีที่ header เปลี่ยนแต่ส่วนของ Spread ไม่มีการเปลี่ยนแปลงต้องใช้ UnChanged ช่วย Update if (dtUnChange != null && dtUnChange.Rows.Count > 0) { listUnChange = DTOUtility.ConvertDataTableToList <InventoryTransactionDTO>(dtUnChange); if (listUpdate == null) { listUpdate = new List <InventoryTransactionDTO>(); } for (int i = 0; i < listUnChange.Count; i++) { InventoryTransactionDTO dto = listUnChange[i]; // 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; //dto.QTY.Value = 0; listUpdate.Add(dto); } } //== Delete process. if (dtDelete != null && dtDelete.Rows.Count > 0) { listDelete = DTOUtility.ConvertDataTableToList <InventoryTransactionDTO>(dtDelete); } bizReturn.SaveShipmentEntry(db, listAdd, listUpdate, listDelete); //if (Mode == Common.eScreenMode.EDIT) //{ // if (dtData != null && dtData.Rows.Count > 0) // { // listUpdate = DTOUtility.ConvertDataTableToList<InventoryTransactionDTO>(dtData); // for (int i = 0; i < listUpdate.Count; i++) // { // InventoryTransactionDTO dto = listUpdate[i]; // // 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; // DeliveryBIZ bizDelivery = new DeliveryBIZ(); // bizDelivery.UpdateReceiveHeader(db, listUpdate[i]); // } // } // //if (dtDelete != null && dtDelete.Rows.Count > 0) // //{ // // ShipmentEntryController ctlShip = new ShipmentEntryController(); // // for (int i = 0; i < dtDelete.Rows.Count; i++) // // { // // NZString strOrderDetailNo = dtDelete.Rows[i]["REF_SLIP_NO"].ToString().ToNZString(); // // decimal dQTY = Convert.ToDecimal(dtDelete.Rows[i]["QTY"]); // // if (dQTY == null || dQTY <= 0) continue; // // ctlShip.UpdateShipQTY(strOrderDetailNo, dQTY * -1); // // } // //} // //if (dtAdd != null && dtAdd.Rows.Count > 0) // //{ // // ShipmentEntryController ctlShip = new ShipmentEntryController(); // // for (int i = 0; i < dtAdd.Rows.Count; i++) // // { // // NZString strOrderDetailNo = dtAdd.Rows[i]["REF_SLIP_NO"].ToString().ToNZString(); // // decimal dQTY = Convert.ToDecimal(dtAdd.Rows[i]["QTY"]); // // if (dQTY == null || dQTY <= 0) continue; // // ctlShip.UpdateShipQTY(strOrderDetailNo, dQTY); // // } // //} //} //if (Mode == Common.eScreenMode.EDIT) //{ // if (dtAdd != null && dtAdd.Rows.Count > 0) // { // listUpdate = DTOUtility.ConvertDataTableToList<InventoryTransactionDTO>(dtAdd); // for (int i = 0; i < listUpdate.Count; i++) // { // InventoryTransactionDTO 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.UpdateReceiveHeader(db, dto); // biz.UpdateInventoryOnhand(db, dto, DataDefine.eOperationClass.Add); // } // } //} db.Commit(); } catch { db.Rollback(); throw; } finally { if (db.DBConnectionState == ConnectionState.Open) { db.Close(); } } }
internal DataTable LoadShipList(NZString SlipNo) { ShipmentBIZ bizShipment = new ShipmentBIZ(); return(bizShipment.LoadShipList(SlipNo)); }
internal NZString SaveShipmentEntry(ShipmentEntryUIDM model, Common.eScreenMode Mode, DataTable OldOrder, DataTable NewOrder, DataTable OldLot, DataTable NewLot) { Database db = Common.CurrentDatabase.CreateNewDatabase(); NZString SlipNo = new NZString(); try { db.KeepConnection = true; db.BeginTransaction(IsolationLevel.Serializable); //bizShipment.AddShipmentEntry(dtoInvTrnsList); ShipmentBIZ bizShipment = new ShipmentBIZ(); IssueEntryValidator val = new IssueEntryValidator(); CommonBizValidator commonVal = new CommonBizValidator(); //== 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 dtData = model.DATA_VIEW; DataTable dtAdd = new DataTable(); DataTable dtModify = new DataTable(); DataTable dtDelete = new DataTable(); if (Mode == Common.eScreenMode.ADD || OldOrder.Rows.Count <= 0) { dtAdd = dtData.GetChanges(DataRowState.Added); dtModify = dtData.GetChanges(DataRowState.Modified); dtDelete = dtData.GetChanges(DataRowState.Deleted); } else { dtAdd = dtData.Clone(); dtModify = dtData.Clone(); dtDelete = dtData.Clone(); // Manage for Update and Delete for (int i = 0; i < OldOrder.Rows.Count; i++) { string OrderDetailNo = Convert.ToString(OldOrder.Rows[i]["ORDER_DETAIL_NO"]); decimal ShipQTY = Convert.ToDecimal(OldOrder.Rows[i]["SHIP_QTY"]); string ItemCd = Convert.ToString(OldOrder.Rows[i]["ITEM_CD"]); bool found_order_detail = false; for (int j = 0; j < NewOrder.Rows.Count; j++) { if (Convert.ToString(NewOrder.Rows[j]["ORDER_DETAIL_NO"]) == OrderDetailNo && Convert.ToString(NewOrder.Rows[j]["ITEM_CD"]) == ItemCd && Convert.ToDecimal(NewOrder.Rows[j]["SHIP_QTY"]) != ShipQTY) { found_order_detail = true; // Delete Old for (int k = 0; k < OldLot.Rows.Count; k++) { if (Convert.ToString(OldLot.Rows[k]["REF_SLIP_NO"]) == OrderDetailNo && Convert.ToString(OldLot.Rows[k]["ITEM_CD"]) == ItemCd) { DataRow row = dtDelete.NewRow(); row["TRANS_ID"] = OldLot.Rows[k]["TRANS_ID"]; row["ITEM_CD"] = OldLot.Rows[k]["ITEM_CD"]; row["LOC_CD"] = OldLot.Rows[k]["LOC_CD"]; row["TRANS_DATE"] = OldLot.Rows[k]["TRANS_DATE"]; row["TRANS_CLS"] = OldLot.Rows[k]["TRANS_CLS"]; row["IN_OUT_CLS"] = OldLot.Rows[k]["IN_OUT_CLS"]; row["QTY"] = OldLot.Rows[k]["QTY"]; row["REF_SLIP_NO"] = OrderDetailNo; dtDelete.Rows.Add(row); } } //bizShipment.AddShipmentEntry(db, null, null, DTOUtility.ConvertDataTableToList<InventoryTransactionDTO>(dtDelete)); // Add New for (int l = 0; l < NewLot.Rows.Count; l++) { if (Convert.ToString(NewLot.Rows[l]["REF_SLIP_NO"]) == OrderDetailNo && Convert.ToString(NewLot.Rows[l]["ITEM_CD"]) == ItemCd) { dtAdd.ImportRow(NewLot.Rows[l]); } } } else if (Convert.ToString(NewOrder.Rows[j]["ORDER_DETAIL_NO"]) == OrderDetailNo && Convert.ToString(NewOrder.Rows[j]["ITEM_CD"]) == ItemCd && Convert.ToDecimal(NewOrder.Rows[j]["SHIP_QTY"]) == ShipQTY) { found_order_detail = true; bool diff_pack = false; for (int x = 0; x < NewLot.Rows.Count; x++) { bool check_same = false; string pack_no = Convert.ToString(NewLot.Rows[x]["PACK_NO"]); string lot_no = Convert.ToString(NewLot.Rows[x]["LOT_NO"]); for (int y = 0; y < OldLot.Rows.Count; y++) { if (Convert.ToString(OldLot.Rows[y]["REF_SLIP_NO"]) == OrderDetailNo && Convert.ToString(OldLot.Rows[y]["ITEM_CD"]) == ItemCd && Convert.ToString(OldLot.Rows[y]["PACK_NO"]) == pack_no && Convert.ToString(OldLot.Rows[y]["LOT_NO"]) == lot_no) { check_same = true; continue; } } if (!check_same) { diff_pack = !check_same; continue; } } if (diff_pack) { // Delete Old for (int k = 0; k < OldLot.Rows.Count; k++) { if (Convert.ToString(OldLot.Rows[k]["REF_SLIP_NO"]) == OrderDetailNo && Convert.ToString(OldLot.Rows[k]["ITEM_CD"]) == ItemCd) { DataRow row = dtDelete.NewRow(); row["TRANS_ID"] = OldLot.Rows[k]["TRANS_ID"]; row["ITEM_CD"] = OldLot.Rows[k]["ITEM_CD"]; row["LOC_CD"] = OldLot.Rows[k]["LOC_CD"]; row["TRANS_DATE"] = OldLot.Rows[k]["TRANS_DATE"]; row["TRANS_CLS"] = OldLot.Rows[k]["TRANS_CLS"]; row["IN_OUT_CLS"] = OldLot.Rows[k]["IN_OUT_CLS"]; row["QTY"] = OldLot.Rows[k]["QTY"]; row["REF_SLIP_NO"] = OrderDetailNo; dtDelete.Rows.Add(row); } } //bizShipment.AddShipmentEntry(db, null, null, DTOUtility.ConvertDataTableToList<InventoryTransactionDTO>(dtDelete)); // Add New for (int l = 0; l < NewLot.Rows.Count; l++) { if (Convert.ToString(NewLot.Rows[l]["REF_SLIP_NO"]) == OrderDetailNo && Convert.ToString(NewLot.Rows[l]["ITEM_CD"]) == ItemCd) { dtAdd.ImportRow(NewLot.Rows[l]); } } } } // In update have remove order if (j == NewOrder.Rows.Count - 1 && !found_order_detail) { for (int k = 0; k < OldLot.Rows.Count; k++) { if (Convert.ToString(OldLot.Rows[k]["REF_SLIP_NO"]) == OrderDetailNo && Convert.ToString(OldLot.Rows[k]["ITEM_CD"]) == ItemCd) { DataRow row = dtDelete.NewRow(); row["TRANS_ID"] = OldLot.Rows[k]["TRANS_ID"]; row["ITEM_CD"] = OldLot.Rows[k]["ITEM_CD"]; row["LOC_CD"] = OldLot.Rows[k]["LOC_CD"]; row["TRANS_DATE"] = OldLot.Rows[k]["TRANS_DATE"]; row["TRANS_CLS"] = OldLot.Rows[k]["TRANS_CLS"]; row["IN_OUT_CLS"] = OldLot.Rows[k]["IN_OUT_CLS"]; row["QTY"] = OldLot.Rows[k]["QTY"]; row["REF_SLIP_NO"] = OrderDetailNo; dtDelete.Rows.Add(row); } } } } } // Manage for check add new order on update mode for (int i = 0; i < NewOrder.Rows.Count; i++) { string OrderDetailNo = Convert.ToString(NewOrder.Rows[i]["ORDER_DETAIL_NO"]); string ItemCd = Convert.ToString(NewOrder.Rows[i]["ITEM_CD"]); bool found_order_detail = false; for (int j = 0; j < OldOrder.Rows.Count; j++) { if (Convert.ToString(OldOrder.Rows[j]["ORDER_DETAIL_NO"]) == OrderDetailNo && Convert.ToString(OldOrder.Rows[j]["ITEM_CD"]) == ItemCd) { found_order_detail = true; } // Not found old order in new order then add new order if (j == OldOrder.Rows.Count - 1 && !found_order_detail) { for (int l = 0; l < NewLot.Rows.Count; l++) { if (Convert.ToString(NewLot.Rows[l]["REF_SLIP_NO"]) == OrderDetailNo && Convert.ToString(NewLot.Rows[l]["ITEM_CD"]) == ItemCd) { dtAdd.ImportRow(NewLot.Rows[l]); } } } } } } InventoryBIZ biz = new InventoryBIZ(); List <InventoryTransactionDTO> listAdd = null; List <InventoryTransactionDTO> listUpdate = null; List <InventoryTransactionDTO> listDelete = null; //== Insert process. if (dtAdd != null && dtAdd.Rows.Count > 0) { listAdd = new List <InventoryTransactionDTO>(); listAdd = DTOUtility.ConvertDataTableToList <InventoryTransactionDTO>(dtAdd); RunningNumberBIZ runningNumberBIZ = new RunningNumberBIZ(); NZString runningNo_SLIP_NO = null; NZString runningNo_GROUP_TRANS_ID = null; if (model.SLIP_NO.IsNull || model.SLIP_NO.Value == "") { runningNo_SLIP_NO = runningNumberBIZ.GetCompleteRunningNo((NZString)"DELIVERY_SLIP_NO", (NZString)"TB_INV_TRANS_TR"); } else { runningNo_SLIP_NO = model.SLIP_NO; } SlipNo = runningNo_SLIP_NO; if (model.GROUP_TRANS_ID.IsNull) { runningNo_GROUP_TRANS_ID = runningNumberBIZ.GetCompleteRunningNo(new NZString(null, "TRAN_GROUP_ID"), new NZString(null, "TB_INV_TRANS_TR")); } else { runningNo_GROUP_TRANS_ID = model.SLIP_NO; } for (int i = 0; i < listAdd.Count; i++) { InventoryTransactionDTO dto = listAdd[i]; // มีการ Gen Running Number ของ NO_LOT_TRANS_ID ไว้แล้วใน InventoryBIZ FN: AddInventoryTransaction //NZString runningNo_LOT_TRANS_ID = runningNumberBIZ.GetCompleteRunningNo(new NZString(null, "TRAN_ID"), new NZString(null, "TB_INV_TRANS_TR")); // Copy ค่า Header จาก Model ไปยัง DTO แต่ละตัว AssignHeaderToDTO(model, dto); dto.SLIP_NO = runningNo_SLIP_NO; dto.GROUP_TRANS_ID = runningNo_GROUP_TRANS_ID; //dto.TRANS_ID = runningNo_LOT_TRANS_ID; dto.CRT_BY = Common.CurrentUserInfomation.UserCD; dto.CRT_MACHINE = Common.CurrentUserInfomation.Machine; dto.UPD_BY = Common.CurrentUserInfomation.UserCD; dto.UPD_MACHINE = Common.CurrentUserInfomation.Machine; listAdd[i] = dto; // check for lot no if ship type is SHIP //if (model.TRANS_CLS.StrongValue != DataDefine.Convert2ClassCode(DataDefine.eTRANS_TYPE.Shipment_Return)) // ValidateException.ThrowErrorItem(commonVal.CheckInputLot(dto.ITEM_CD, dto.LOC_CD, dto.LOT_NO, true)); } } //== Update process. if (dtModify != null && dtModify.Rows.Count > 0) { listUpdate = DTOUtility.ConvertDataTableToList <InventoryTransactionDTO>(dtModify); for (int i = 0; i < listUpdate.Count; i++) { InventoryTransactionDTO 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; listUpdate[i] = dto; } } //== Delete process. if (dtDelete != null && dtDelete.Rows.Count > 0) { listDelete = DTOUtility.ConvertDataTableToList <InventoryTransactionDTO>(dtDelete); } bizShipment.AddShipmentEntry(db, listAdd, listUpdate, listDelete); if (Mode == Common.eScreenMode.EDIT) { if (dtData != null && dtData.Rows.Count > 0) { listUpdate = DTOUtility.ConvertDataTableToList <InventoryTransactionDTO>(dtData); for (int i = 0; i < listUpdate.Count; i++) { InventoryTransactionDTO 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; DeliveryBIZ bizDelivery = new DeliveryBIZ(); bizDelivery.UpdateReceiveHeader(db, listUpdate[i]); } SlipNo = listUpdate[0].SLIP_NO; } //if (dtDelete != null && dtDelete.Rows.Count > 0) //{ // ShipmentEntryController ctlShip = new ShipmentEntryController(); // for (int i = 0; i < dtDelete.Rows.Count; i++) // { // NZString strOrderDetailNo = dtDelete.Rows[i]["REF_SLIP_NO"].ToString().ToNZString(); // decimal dQTY = Convert.ToDecimal(dtDelete.Rows[i]["QTY"]); // if (dQTY == null || dQTY <= 0) continue; // ctlShip.UpdateShipQTY(strOrderDetailNo, dQTY * -1); // } //} //if (dtAdd != null && dtAdd.Rows.Count > 0) //{ // ShipmentEntryController ctlShip = new ShipmentEntryController(); // for (int i = 0; i < dtAdd.Rows.Count; i++) // { // NZString strOrderDetailNo = dtAdd.Rows[i]["REF_SLIP_NO"].ToString().ToNZString(); // decimal dQTY = Convert.ToDecimal(dtAdd.Rows[i]["QTY"]); // if (dQTY == null || dQTY <= 0) continue; // ctlShip.UpdateShipQTY(strOrderDetailNo, dQTY); // } //} } //if (Mode == Common.eScreenMode.EDIT) //{ // if (dtAdd != null && dtAdd.Rows.Count > 0) // { // listUpdate = DTOUtility.ConvertDataTableToList<InventoryTransactionDTO>(dtAdd); // for (int i = 0; i < listUpdate.Count; i++) // { // InventoryTransactionDTO 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.UpdateReceiveHeader(db, dto); // biz.UpdateInventoryOnhand(db, dto, DataDefine.eOperationClass.Add); // } // } //} db.Commit(); return(SlipNo); } catch { db.Rollback(); throw; } finally { if (db.DBConnectionState == ConnectionState.Open) { db.Close(); } } }