优化ERP下发库存/取货信息流程，添加记录表和header判断逻辑备用

kazelee

2025-06-09 fe3167683576e5dd943fd5acc52e713652365def

 api/DebugController.cs

@@ -267,16 +267,34 @@
                return "找不到对应的物料信息";
            }

            var task = db.Queryable<TN_Task>()
                .Where(t => t.S_CODE == model.TaskNo).First();

            if (cgDetail == null) {
                return "找不到对应的任务号";
            }

            cgDetail.F_QTY = model.Weight;
            task.F_WEIGHT = model.Weight;

            try {
                if (db.Updateable<TN_CG_Detail>(cgDetail).UpdateColumns(it => it.F_QTY)
                using (var tran = db.Ado.UseTran()) {
                    if (db.Updateable<TN_CG_Detail>(cgDetail).UpdateColumns(it => it.F_QTY)
                    .ExecuteCommand() <= 0) {
                    return "修改失败";
                }
                return "修改成功";
                        tran.RollbackTran();
                        return "修改失败";
                    }

                    if (db.Updateable<TN_Task>(task).UpdateColumns(it => it.F_WEIGHT).ExecuteCommand() <= 0) {
                        tran.RollbackTran();
                        return "修改失败";
                    }
                    tran.CommitTran();
                }
                LogHelper.Info($"模拟AGV传递物料重量：修改任务号{task.S_CODE}重量为{model.Weight}", "HosttoagvTask");
                return "修改成功";
            }

            catch (Exception ex) {

                return ex.Message;