优化货位绑定图片链接保存逻辑，删除不使用的代码

kazelee

1 天以前 6ed44f32c96a17fd10601a24c3c36ca1229bc89b

 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}");
                        }
@@ -286,15 +287,17 @@
                var bindLocCntList = new List<TN_Loc_Container>();
                foreach (var item in cntrs)
                {
                    bindLocCntList.Add(new TN_Loc_Container() { S_LOC_CODE = loc, S_CNTR_CODE = item });
                    // 补充逻辑：避免解绑导致的信息丢失 (N_LOCK_STATE与CG_Detail保持一致所以直接赋值就行；IMGURL货位移动了就删除，也很合理）
                    var cgDetail = db.Queryable<TN_CG_Detail>().Where(d => d.S_CNTR_CODE == item).First();
                    bindLocCntList.Add(new TN_Loc_Container() { S_LOC_CODE = loc, S_CNTR_CODE = item, S_IMG_URL = cgDetail?.S_EXT_ATTR5 ?? "", N_LOCK_STATE = cgDetail?.N_LOCK_STATE ?? 0 });
                }


                var log = JsonConvert.SerializeObject(bindLocCntList);

                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}");
                    }
@@ -516,11 +519,6 @@
    public class EmptyUnBindInfo
    {
        public string cntID { get; set; }//容器ID
    }

    public class CancleTaskInfo
    {
        public string taskNO { get; set; }//任务号
    }

    public class PDAFullInAreaInfo