关于修改出入库单影响库存问题

登录

14:39 执行'修改出入库单'命令, 请求方式

OST, 用户:Administrator.
Forguncy.js?v=637390540436961851:1 参数:
Forguncy.js?v=637390540436961851:1 出入库单ID = 1
Forguncy.js?v=637390540436961851:1 出入库 = 6
Forguncy.js?v=637390540436961851:1 日期 = 44162
Forguncy.js?v=637390540436961851:1 类型 = 1
Forguncy.js?v=637390540436961851:1 客户ID = null
Forguncy.js?v=637390540436961851:1 其他出入库对象 = "CG-20201127-0001"
Forguncy.js?v=637390540436961851:1 联系人 = null
Forguncy.js?v=637390540436961851:1 联系电话 = null
Forguncy.js?v=637390540436961851:1 总金额 = 14040
Forguncy.js?v=637390540436961851:1 项目ID = null
Forguncy.js?v=637390540436961851:1 备注 = "由采购订单自动生成的入库单"
Forguncy.js?v=637390540436961851:1 详情表 = {"AddRows":[],"EditRows":[{"物品ID":1,"数量":90,"单价":156,"备注":null,"ID":1}],"DeleteRows":[]}
Forguncy.js?v=637390540436961851:1 创建参数物品ID = 1
Forguncy.js?v=637390540436961851:1 创建参数数量 = 90
Forguncy.js?v=637390540436961851:1 创建参数单价 = 156
Forguncy.js?v=637390540436961851:1 设置参数备注 = null
Forguncy.js?v=637390540436961851:1 创建参数 ID = 1
Forguncy.js?v=637390540436961851:1 事务命令
Forguncy.js?v=637390540436961851:1 检查是否盘点中
Forguncy.js?v=637390540436961851:1 设置参数命令 : 盘点中数量
Forguncy.js?v=637390540436961851:1 SELECT COUNT(*) FROM 盘点表 WHERE [是否结束] = 0
Forguncy.js?v=637390540436961851:1 创建参数盘点中数量 = 0
Forguncy.js?v=637390540436961851:1 条件
Forguncy.js?v=637390540436961851:1 判断: =盘点中数量大于 0 结果为 False
Forguncy.js?v=637390540436961851:1 数据表操作 : 更新出入库表
Forguncy.js?v=637390540436961851:1 UPDATE 出入库表 SET 日期 = 44162, 类型 = 1, 客户ID = null, 其他出入库对象 = 'CG-20201127-0001', 联系人 = null, 联系电话 = null, 总金额 = 14040, 项目ID = null, 备注 = '由采购订单自动生成的入库单' WHERE [ID] = 1
Forguncy.js?v=637390540436961851:1 如果原本为入库，反操作就是出库；如果原本为出库，反操作就是入库。用于删除，编辑详情。 : 设置参数命令 : 出入库反操作
Forguncy.js?v=637390540436961851:1 创建参数出入库反操作 = 5
Forguncy.js?v=637390540436961851:1 循环命令
Forguncy.js?v=637390540436961851:1 循环命令
Forguncy.js?v=637390540436961851:1 创建参数物品详情 = {"物品ID":1,"数量":90,"单价":156,"备注":null,"ID":1}
Forguncy.js?v=637390540436961851:1 设置参数命令 : 原物品详情
Forguncy.js?v=637390540436961851:1 SELECT  [物品ID], [数量] FROM 出入库详情表 WHERE [ID] = 1
Forguncy.js?v=637390540436961851:1 创建参数原物品详情 = {"物品ID":1,"数量":100.0}
Forguncy.js?v=637390540436961851:1 数据表操作 : 更新出入库详情表
Forguncy.js?v=637390540436961851:1 UPDATE 出入库详情表 SET 物品ID = 1, 数量 = 90, 单价 = 156, 备注 = null WHERE [ID] = 1
Forguncy.js?v=637390540436961851:1 修改物品库存
Forguncy.js?v=637390540436961851:1 创建参数物品ID = 1
Forguncy.js?v=637390540436961851:1 创建参数变更数 = 100
Forguncy.js?v=637390540436961851:1 创建参数出入库 = 5
Forguncy.js?v=637390540436961851:1 变更数小于0，更新失败 : 条件
Forguncy.js?v=637390540436961851:1 判断: =变更数小于 0 结果为 False
Forguncy.js?v=637390540436961851:1 条件
Forguncy.js?v=637390540436961851:1 判断: =变更数大于 0 结果为 True
Forguncy.js?v=637390540436961851:1 获取物品信息 : 设置参数命令 : 物品
Forguncy.js?v=637390540436961851:1 SELECT  [ID], [库存], [名称] FROM 物品表 WHERE [ID] = 1
Forguncy.js?v=637390540436961851:1 创建参数物品 = {"ID":1,"库存":100,"名称":"炭因子净颜双效卸妆啫喱"}
Forguncy.js?v=637390540436961851:1 如果是出库，检查库存是否充足 : 条件
Forguncy.js?v=637390540436961851:1 判断: (=出入库等于 =5 并且 =物品.库存小于 =变更数) 结果为 False
Forguncy.js?v=637390540436961851:1 更新库存 : 数据表操作 : 更新物品表
Forguncy.js?v=637390540436961851:1 UPDATE 物品表 SET 库存 = 200 WHERE [ID] = 1
Forguncy.js?v=637390540436961851:1 修改物品库存
Forguncy.js?v=637390540436961851:1 创建参数物品ID = 1
Forguncy.js?v=637390540436961851:1 创建参数变更数 = 90
Forguncy.js?v=637390540436961851:1 创建参数出入库 = 6
Forguncy.js?v=637390540436961851:1 变更数小于0，更新失败 : 条件
Forguncy.js?v=637390540436961851:1 判断: =变更数小于 0 结果为 False
Forguncy.js?v=637390540436961851:1 条件
Forguncy.js?v=637390540436961851:1 判断: =变更数大于 0 结果为 True
Forguncy.js?v=637390540436961851:1 获取物品信息 : 设置参数命令 : 物品
Forguncy.js?v=637390540436961851:1 SELECT  [ID], [库存], [名称] FROM 物品表 WHERE [ID] = 1
Forguncy.js?v=637390540436961851:1 创建参数物品 = {"ID":1,"库存":200,"名称":"炭因子净颜双效卸妆啫喱"}
Forguncy.js?v=637390540436961851:1 如果是出库，检查库存是否充足 : 条件
Forguncy.js?v=637390540436961851:1 判断: (=出入库等于 =5 并且 =物品.库存小于 =变更数) 结果为 False
Forguncy.js?v=637390540436961851:1 更新库存 : 数据表操作 : 更新物品表
Forguncy.js?v=637390540436961851:1 UPDATE 物品表 SET 库存 = 290 WHERE [ID] = 1
Forguncy.js?v=637390540436961851:1 循环命令
Forguncy.js?v=637390540436961851:1 根据出入库单修改采购单_已入库销售单_已出库
Forguncy.js?v=637390540436961851:1 创建参数采购销售单号 = CG-20201127-0001
Forguncy.js?v=637390540436961851:1 创建参数出入库类型 = 1
Forguncy.js?v=637390540436961851:1 条件
Forguncy.js?v=637390540436961851:1 判断: (=LEFT(采购销售单号,2) 等于 CG 并且 =出入库类型等于 1) 结果为 True
Forguncy.js?v=637390540436961851:1 更新采购单入库状态
Forguncy.js?v=637390540436961851:1 创建参数订单号 = CG-20201127-0001
Forguncy.js?v=637390540436961851:1 设置参数命令 : 采购详情
Forguncy.js?v=637390540436961851:1 SELECT  [物品ID], [采购数量] FROM 采购订单详情表 WHERE [采购订单ID]->[单号] = CG-20201127-0001
Forguncy.js?v=637390540436961851:1 创建参数采购详情 = [{"物品ID":1,"采购数量":100.0}]
Forguncy.js?v=637390540436961851:1 设置参数命令 : 已入库
Forguncy.js?v=637390540436961851:1 创建参数已入库 = 1
Forguncy.js?v=637390540436961851:1 逐一查看每个物品是否入库完成 : 循环命令
Forguncy.js?v=637390540436961851:1 创建参数 Item = {"物品ID":1,"采购数量":100.0}
Forguncy.js?v=637390540436961851:1 条件
Forguncy.js?v=637390540436961851:1 判断: =已入库等于 =1 结果为 True
Forguncy.js?v=637390540436961851:1 设置参数命令 : 出入库数量
Forguncy.js?v=637390540436961851:1 SELECT  [总数量] FROM 出入库详情表 WHERE ([出入库ID]->[其他出入库对象] = CG-20201127-0001 and [物品ID] = 1)
Forguncy.js?v=637390540436961851:1 创建参数出入库数量 = 90
Forguncy.js?v=637390540436961851:1 条件
Forguncy.js?v=637390540436961851:1 判断: =Item.采购数量大于 =出入库数量结果为 True
Forguncy.js?v=637390540436961851:1 设置参数命令 : 已入库
Forguncy.js?v=637390540436961851:1 设置参数已入库 = 0
Forguncy.js?v=637390540436961851:1 数据表操作 : 更新采购订单表
Forguncy.js?v=637390540436961851:1 UPDATE 采购订单表 SET 已入库 = 0 WHERE [单号] = CG-20201127-0001
Forguncy.js?v=637390540436961851:1 错误码: 0
Forguncy.js?v=637390540436961851:1 服务器'修改出入库单'命令执行结束, 用时:458.2533毫秒.服务器显示没有错，我也是按教程操作的，在修改和删除出入库单时，实际库存就不对了，
采购了100---入库100---物品库存为100；    修改入库单为90元，物品库存变成了290