From 16d2162a833cebeae72c363962917bb9da8145ef Mon Sep 17 00:00:00 2001 From: 杨前锦 <1010338399@qq.com> Date: 星期五, 06 六月 2025 17:34:47 +0800 Subject: [PATCH] 福建佳通优化 --- HH.WCS.Mobox3/HH.WCS.Mobox3.FJJT/wms/ContainerHelper.cs | 20 ++++---------------- 1 files changed, 4 insertions(+), 16 deletions(-) diff --git a/HH.WCS.Mobox3/HH.WCS.Mobox3.FJJT/wms/ContainerHelper.cs b/HH.WCS.Mobox3/HH.WCS.Mobox3.FJJT/wms/ContainerHelper.cs index 7b5c805..c07bb91 100644 --- a/HH.WCS.Mobox3/HH.WCS.Mobox3.FJJT/wms/ContainerHelper.cs +++ b/HH.WCS.Mobox3/HH.WCS.Mobox3.FJJT/wms/ContainerHelper.cs @@ -79,31 +79,21 @@ return res; }*/ - internal static bool AddCntr(string cntrCode ,int detallCount = 1) + internal static bool AddCntr(string cntrCode ,int detallCount = 0) { var res = false; var db = new SqlHelper<object>().GetInstance(); var TN_Container = new Container { S_CODE = cntrCode ,N_DETAIL_COUNT = detallCount }; try { - db.BeginTran(); var container = db.Queryable<Container>().Where(a => a.S_CODE.Trim() == cntrCode).First(); if (container == null) { - db.Insertable<Container>(TN_Container).ExecuteCommand(); + res = db.Insertable<Container>(TN_Container).ExecuteCommand() > 0; } - else - { - container.N_DETAIL_COUNT = detallCount; - container.N_E_STATE = 0; - db.Updateable(container).ExecuteCommand(); - } - db.CommitTran(); - res = true; } catch (Exception ex) { - db.RollbackTran(); WMSHelper.addAlarmRecord("绯荤粺閿欒", "楂�, $"娣诲姞瀹瑰櫒閿欒锛岄敊璇師鍥狅細{ex.Message}"); throw new BusinessException($"娣诲姞瀹瑰櫒閿欒锛岄敊璇師鍥狅細{ex.Message}"); } @@ -322,17 +312,15 @@ /// /// </summary> /// <param name="cntrCode"></param> - /// <param name="state">鎵樼洏寮傚父鐘舵� 0.榛樿 1.WCS璇荤爜寮傚父 2.AGV璇荤爜鍣ㄨ鐮佸紓甯�/param> - /// <param name="errMsg">寮傚父淇℃伅</param> + /// <param name="state">鎵樼洏寮傚父鐘舵� 0.姝e父 1.寮傚父</param> /// <returns></returns> - internal static bool UpdateCntrState(string cntrCode, int state ,string errMsg) { + internal static bool UpdateCntrState(string cntrCode, int state) { var res = false; var db = new SqlHelper<object>().GetInstance(); var models = db.Queryable<Container>().Where(a => a.S_CODE.Trim() == cntrCode).ToList(); if (models.Count > 0) { models.ForEach(a => { a.N_E_STATE = state; - a.S_ERR_DESC = errMsg; db.Updateable(a).UpdateColumns(it => new { it.N_E_STATE,it.S_ERR_DESC }).ExecuteCommand(); }); res = true; -- Gitblit v1.9.1