--[[
|
编码: WMS-19-01
|
名称: 容器货品明细-创建前
|
作者：HAN
|
日期：2025-1-29
|
|
级别：固定 (说明本段代码在项目中不太会变化)
|
|
函数： BeforeDataObjCreate
|
|
功能:
|
1）创建一个【容器货品明细】需要到【容器货品】表找一下这个物料是否存在，有存在合并数量，
|
不存在就要创建一个【容器货品】,并且把【容器货品】的ID作为 S_CG_ID 设置到【容器货品明细】
|
更改记录:
|
|
--]]
|
|
wms_base = require( "wms_base" )
|
|
function BeforeDataObjCreate ( strLuaDEID )
|
local nRet, strRetInfo
|
|
-- step1: 获取当前【容器货品明细】的关键信息
|
nRet, strRetInfo = mobox.getCurEditDataObjAttr( strLuaDEID, "S_CNTR_CODE","S_ITEM_CODE","N_ITEM_STATE","S_END_USER","F_QTY",
|
"S_ITEM_NAME","S_ITEM_SPEC","S_UOM","C_ITEM_MERGE")
|
if ( nRet ~= 0 ) then lua.Error( strLuaDEID, debug.getinfo(1), "获取当前编辑属性失败! "..strRetInfo ) end
|
local obj_attrs = json.decode( strRetInfo )
|
local cntr_code = obj_attrs[1].value
|
local item_code = obj_attrs[2].value
|
local item_state = lua.StrToNumber(obj_attrs[3].value)
|
local end_user = obj_attrs[4].value
|
local qty = lua.StrToNumber(obj_attrs[5].value)
|
local item_name = obj_attrs[6].value
|
local item_spec = obj_attrs[7].value
|
local uom = obj_attrs[8].value
|
local merge = obj_attrs[9].value
|
local cg_id = ''
|
|
if ( merge == 'Y') then
|
-- step2: 获取当前【容器货品】记录
|
local strCondition
|
strCondition = "S_CNTR_CODE='"..cntr_code.."' AND S_ITEM_CODE='"..item_code.."'"
|
nRet, strRetInfo = mobox.queryOneDataObjAttr(strLuaDEID, "Container_Good", strCondition, "S_ITEM_CODE" )
|
if (nRet ~= 0 ) then lua.Error( strLuaDEID, debug.getinfo(1), "获取【容器货品】信息失败! " .. strRetInfo ) end
|
if ( strRetInfo == '') then
|
-- 如果不存在【容器货品】就新建一个
|
local cntr_good = m3.AllocObject(strLuaDEID,"Container_Good")
|
local ret_info
|
|
cntr_good.cntr_no = cntr_code
|
cntr_good.item_code = item_code
|
cntr_good.item_name = item_name
|
cntr_good.item_spec = item_spec
|
cntr_good.uom = uom
|
cntr_good.qty = qty
|
|
nRet, ret_info = m3.CreateDataObj(strLuaDEID, cntr_good)
|
if ( nRet ~= 0 ) then lua.Error( strLuaDEID, debug.getinfo(1), 'mobox 创建【容器货品】对象失败!'..ret_info ) end
|
-- 获取创建成功的【容器货品】对象标识
|
cg_id = ret_info.id
|
else
|
local strSetAttr = ''
|
local ret_info = json.decode(strRetInfo)
|
cg_id = ret_info.id
|
-- 需要累计数量
|
strCondition = "S_ID = '"..cg_id.."'"
|
strSetAttr = "F_QTY = F_QTY + "..qty
|
nRet, strRetInfo = mobox.updateDataAttrByCondition( strLuaDEID, "Container_Good", strCondition, strSetAttr )
|
if ( nRet ~= 0 ) then lua.Error( strLuaDEID, debug.getinfo(1), "更新【容器货品】数量失败!"..strRetInfo ) end
|
end
|
end
|
|
-- 根据字典获取 N_LOCK_STATE 的货品状态
|
local item_state_name = wms_base.GetDictItemName( strLuaDEID, "WMS_ItemState", item_state )
|
|
local attr_value = {}
|
attr_value[1] = lua.KeyValueObj( "S_CG_ID", cg_id )
|
attr_value[2] = lua.KeyValueObj( "S_ITEM_STATE", item_state_name )
|
nRet, strRetInfo = mobox.setCurEditDataObjAttr( strLuaDEID, lua.table2str(attr_value) )
|
if ( nRet ~= 0 ) then lua.Error( strLuaDEID, debug.getinfo(1), "设置【容器货品明细】信息失败! "..strRetInfo ) end
|
end
|
