添加看板获取货位状态接口, 修复容器插入, 货位容器绑定货位字段未更新的问题

kazelee

1 天以前 505e0d47a72f51b0dc4dc315f8fce36cc73abc89

 api/DebugController.cs

@@ -202,7 +202,7 @@
                var cntrListToUpdate = new List<TN_Container>();
                var cntrListToInsert = new List<TN_Container>();
                foreach (var cntr in result) {
                    var oldCntr = cntrList.Where(c => c.S_CODE == cntr.S_CNTR_CODE).First();
                    var oldCntr = cntrList.Where(c => c.S_CODE == cntr.S_CNTR_CODE).FirstOrDefault();
                    if (oldCntr == null) {
                        cntrListToUpdate.Add(new TN_Container { S_CODE = cntr.S_CNTR_CODE, N_DETAIL_COUNT = cntr.Count });
                    }
@@ -231,6 +231,28 @@

            return "success";
        }

        [HttpPost]

        public string RefreshCgDetail() {
            var db = new SqlHelper<object>().GetInstance();
            try {
                var locCntrRelList = db.Queryable<TN_Loc_Container>().ToList();
                var cgDetailList = db.Queryable<TN_CG_Detail>().ToList();
                cgDetailList.ForEach(d => {
                    var locCntrRel = locCntrRelList.Where(c => c.S_CNTR_CODE == d.S_CNTR_CODE).FirstOrDefault();
                    if (locCntrRel != null) {
                        d.S_LOC_CODE = locCntrRel.S_LOC_CODE;
                    }
                });

                var res = db.Updateable(cgDetailList).UpdateColumns(it => new { it.S_LOC_CODE }).ExecuteCommand();
                return $"{res}";
            }
            catch (Exception ex) {
                return ex.Message;
            }
        }
    }

    public class CntrCodeCountResult {