添加CgDetail信息同步字段和锁状态字段，修改相关逻辑

kazelee

5 天以前 656f90b301ba307c909de4ee94b88af817adf0d8

 wms/LocationHelper.cs

@@ -221,7 +221,8 @@

                    using (var tran = db.Ado.UseTran())
                    {
                        if (db.Deleteable<TN_Loc_Container>().Where(it => cntrs.Contains(it.S_CNTR_CODE) && it.S_LOC_CODE == loc).ExecuteCommand() > 0)
                        if (db.Deleteable<TN_Loc_Container>().Where(it => cntrs.Contains(it.S_CNTR_CODE) && it.S_LOC_CODE == loc).ExecuteCommand() > 0 && 
                            db.Updateable<TN_CG_Detail>().SetColumns(d => d.S_LOC_CODE == null).Where(d => cntrs.Contains(d.S_CNTR_CODE)).ExecuteCommand() > 0) // ADD：补充针对PDA分拣
                        {
                            LogHelper.Info($"删除货位容器关系表成功，{log}");
                        }
@@ -294,7 +295,8 @@

                using (var tran = db.Ado.UseTran())
                {
                    if (db.Insertable<TN_Loc_Container>(bindLocCntList).ExecuteCommand() > 0)
                    if (db.Insertable<TN_Loc_Container>(bindLocCntList).ExecuteCommand() > 0 &&
                        db.Updateable<TN_CG_Detail>().SetColumns(d => d.S_LOC_CODE == loc).Where(d => cntrs.Contains(d.S_CNTR_CODE)).ExecuteCommand() > 0) // ADD：补充针对PDA分拣
                    {
                        LogHelper.Info($"插入货位容器关系表成功，{log}");
                    }