1

czw

7 天以前 c97f5e8db6360135d481e933fdac5d3682057adc

 HH.WCS.QingXiNongfu/wms/TaskHelper.cs

@@ -1,4 +1,5 @@
using HH.WCS.QingXigongchang.dispatch;
using HH.WCS.QingXigongchang.process;
using HH.WCS.QingXigongchang.util;
using Newtonsoft.Json;
using SqlSugar;
@@ -17,13 +18,24 @@
            var date = DateTime.Now.ToString("yyMMdd");
            return $"TN{date}{id.ToString().PadLeft(4, '0')}";
        }
        internal static bool UpdateStatus(WMSTask task, string status)
        internal static bool UpdateStatus(WMSTask task, string status, CntrItemRel CntItem = null)
        {
            var res = false;
            var db = new SqlHelper<WMSTask>().GetInstance();
            task.S_B_STATE = status;
            db.Updateable(task).UpdateColumns(it => new { it.S_B_STATE }).ExecuteCommand();
            return res;
            if (CntItem != null)
            {
                task.S_ITEM_NAME = CntItem?.S_ITEM_NAME;
                task.S_ITEM_CODE = CntItem?.S_ITEM_CODE;
                task.S_B_STATE = status;
                db.Updateable(task).UpdateColumns(it => new { it.S_B_STATE, it.S_ITEM_NAME, it.S_ITEM_CODE }).ExecuteCommand();
                return res;
            }
            else
            {
                task.S_B_STATE = status;
                db.Updateable(task).UpdateColumns(it => new { it.S_B_STATE }).ExecuteCommand();
                return res;
            }
        }
        internal static bool UpdateInfo(WMSTask task, string sourceNo, string endBit, string status)
        {
@@ -105,7 +117,7 @@
            else if (endLoc.S_AREA_CODE == "YWLWJJB")
            {
                //查询任务表  要求是只能生成两个任务 起点库区为YWLWJJB  hh_plg  2025年6月9日 
                List<string> TaskState = new List<string>() { "完成", "取消" };
                List<string> TaskState = new List<string>() { "完成", "取消", "推送异常" };
                var TaskListNum = LocationHelper.GetList<WMSTask>(x => x.S_END_LAREA == "YWLWJJB" && !TaskState.Contains(x.S_B_STATE));
                if (TaskListNum.Count() >= 2)
                {
@@ -241,6 +253,21 @@
        {
            var db = new SqlHelper<object>().GetInstance();

            if (task.S_START_LOC == "YWLT1TSJCD-1" && task.N_START_LAYER == 2)
            {
                var _clrel = LocationHelper.GetLocCntrRel(task.S_START_LOC);

                if (_clrel != null)
                {
                    var sta = db.Queryable<Location>().Where(l => l.S_LOC_CODE == task.S_START_LOC).First();
                    if (sta.N_CURRENT_NUM > 0 && sta.S_LOCK_STATE == "无")
                    {
                        var sign = Settings.GetTimeStamp();
                        var res = TaskProcess.CreateTransport(sign, task.S_START_LOC, task.S_END_LOC, "原物料搬运-纸箱", new List<string> { _clrel.FirstOrDefault().S_CNTR_CODE }, sta.N_CURRENT_NUM, 1, 1, 60);
                    }
                }
            }

            if (task.S_END_LAREA == "YWLYLTKQ" || task.S_END_LAREA == "YWLTKKTQ")
            {
                //查询出库锁YWLWJJB