快乐的昕的电脑
2025-10-20 eca70603032ca5c41980854c346ffd57b01d3b59
同步更新MES_ORDER_STA的END_TIME
已修改1个文件
10 ■■■■■ 文件已修改
Services/MesInvItemBarcodesManager.cs 10 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
Services/MesInvItemBarcodesManager.cs
@@ -323,11 +323,19 @@
            .First();
        if (womdaaAfter != null && womdaaAfter.Daa011 >= womdaaAfter.Daa008)
        {
            var finishTime = DateTime.Now;
            Db.Updateable<Womdaa>()
                .SetColumns(x => x.Daa017 == DateTime.Now)
                .SetColumns(x => x.Daa017 == finishTime)
                .SetColumns(x => x.Daa018 == "完工")
                .Where(x => x.Daa001 == womdaaAfter.Daa001)
                .ExecuteCommand();
            // 同步更新MES_ORDER_STA的END_TIME
            Db.Updateable<object>()
                .AS("MES_ORDER_STA")
                .SetColumns("END_TIME", finishTime)
                .Where($"ORDER_NO = '{womdaaAfter.Daa001}'")
                .ExecuteCommand();
        }
        // 插入报工记录和条码记录