空托修改

海波 张

2025-05-29 5b6a0b390fc0ca7a5519ad6fb9a27bbca80e3cad

 wms/TaskHelper.cs

@@ -58,6 +58,13 @@
        }


        internal static WmsWork GetWmsWork(string no) {
            var db = new SqlHelper<WmsWork>().GetInstance();
            return db.Queryable<WmsWork>().Where(it => it.S_CODE == no).First();
        }
      


        internal static WMSTask GetTaskByCntrCode(string cntrCode)
        {
            var db = new SqlHelper<WMSTask>().GetInstance();
@@ -877,8 +884,26 @@
                var db = new SqlHelper<object>().GetInstance();

                return db.Queryable<MesKtTask>().Where(a => a.Location_To==end && a.Status=="N").First();
        }

        internal static bool ChangeMesKtTask(MesKtTask kt)
        {

            var db = new SqlHelper<object>().GetInstance();
            kt.Status = "Y";
            return db.Updateable(kt).UpdateColumns(it => new {
                it.Status
            }).ExecuteCommand()>0;

            
        }

        internal static List<UnlimitedLoc> GetMesKtLoc()
        {

            var db = new SqlHelper<object>().GetInstance();

            return db.Queryable<UnlimitedLoc>().ToList();
        }
    }
}