同步更新MES_ORDER_STA的END_TIME

快乐的昕的电脑

2025-10-20 eca70603032ca5c41980854c346ffd57b01d3b59

 Services/MesInvItemBarcodesManager.cs

@@ -317,6 +317,26 @@
            .Where(x => x.Daa001 == womdaa.Daa001)
            .ExecuteCommand();

        // 判断是否全部完工，若是则写入实际完工日期
        var womdaaAfter = Db.Queryable<Womdaa>()
            .Where(s => s.Daa001 == query.orderNo)
            .First();
        if (womdaaAfter != null && womdaaAfter.Daa011 >= womdaaAfter.Daa008)
        {
            var finishTime = DateTime.Now;
            Db.Updateable<Womdaa>()
                .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();
        }

        // 插入报工记录和条码记录
        return Db.Insertable(mesReporting)