工单管理更新

Ben Lin

2024-05-28 b71aee5943ac1164b5c89a3b4409077810fa9a23

工单管理更新

 Tiger.Api/Controllers/MES/MESController.BIZ_MES_WO.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,54 @@
using Microsoft.AspNetCore.Mvc;
using Rhea.Common;
using System.Threading.Tasks;
using Tiger.IBusiness;
using Tiger.Model;

namespace Tiger.Api.Controllers.MES
{
    public partial class MESController : ControllerBase
    {

        /// <summary>
        /// ä¿å­˜å·¥å•
        /// </summary>
        /// <param name="action"></param>
        /// <returns></returns>
        [HttpPost]
        [Route("api/[controller]/[action]")]
        public async Task<IActionResult> SaveMesWo([FromBody] ApiAction<BIZ_MES_WO> action)
        {
            ApiAction response = new();
            try
            {
                response = response.GetResponse(await DI.Resolve<IBIZ_MES_WO>().SaveMesWo(action.Data));
            }
            catch (System.Exception ex)
            {
                response = response.GetResponse().CatchExceptionWithLog(ex);
            }
            return Ok(response);
        }

        /// <summary>
        /// åˆ é™¤å·¥å•
        /// </summary>
        /// <param name="action"></param>
        /// <returns></returns>
        [HttpPost]
        [Route("api/[controller]/[action]")]
        public async Task<IActionResult> DeleteMesWo([FromBody] ApiAction action)
        {
            ApiAction response = new();
            try
            {
                response = response.GetResponse(await DI.Resolve<IBIZ_MES_WO>().DeleteMesWo(action.Data?.ToString()));
            }
            catch (System.Exception ex)
            {
                response = response.GetResponse().CatchExceptionWithLog(ex);
            }
            return Ok(response);
        }
    }
}

 Tiger.Business/MES/Biz.BIZ_MES_WO.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,100 @@
using Tiger.Model;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq.Expressions;
using System.Text;
using System.Threading.Tasks;
using Rhea.Common;
using System.Net;
using System.Linq;
using Newtonsoft.Json;
using Tiger.IBusiness;
using static Tiger.Business.Biz;
using Microsoft.AspNetCore.Http;

namespace Tiger.Business
{
    public partial class Biz
    {
        /// <summary>
        /// å·¥å•
        /// </summary>
        public partial class BizMesWo : IBIZ_MES_WO
        {
            /// <summary>
            /// ä¿å­˜
            /// </summary>
            /// <param name="wo"></param>
            /// <returns></returns>
            public async Task<ApiAction> SaveMesWo(BIZ_MES_WO wo)
            {
                var result = new ApiAction();
                try
                {
                    var _wo = Db.Queryable<BIZ_MES_WO>().Where(x=>x.ORDER_NO == wo.ORDER_NO).First();
                    if (_wo != null && _wo.STATUS!= (int)BIZ_MES_WO.STATUSs.Init)
                    {
                        result.IsSuccessed = false;
                        result.LocaleMsg = new($"工单已经存在且不是初始化状态，不能保存修改！"); 
                        return result;
                    }
                    var db = Db;
                    var dbTran = db.UseTran(() =>
                    {
                        var y = db.Storageable(wo)
                           .WhereColumns(t => new { t.ORDER_NO, t.GHOST_ROW })
                           .ToStorage();
                        y.AsInsertable.ExecuteCommand();
                        y.AsUpdateable.IgnoreColumns(x => x.ID).ExecuteCommand();
                    });
                    if (!dbTran.IsSuccess)
                    {
                        result.IsSuccessed = false;
                        result.Message = $"保存工单异常";
                    }
                }
                catch (Exception ex)
                {
                    result.CatchExceptionWithLog(ex, "保存工单异常");
                }
                return await Task.FromResult(result);
            }

            /// <summary>
            /// åˆ é™¤å·¥å•
            /// </summary>
            /// <param name="woId"></param>
            /// <returns></returns>
            public async Task<ApiAction> DeleteMesWo(string woId) {
                var result = new ApiAction();
                try
                {
                    //查询是否已经有工单在用
                    var _wo = Db.Queryable<BIZ_MES_WO>().Where(x => x.ID == woId).First();
                    if (_wo != null && _wo.STATUS != (int)BIZ_MES_WO.STATUSs.Init)
                    {
                        result.IsSuccessed = false;
                        result.LocaleMsg = new($"工单不是初始化状态，不能删除！");
                        return result;
                    }
                    var db = Db;
                    var dbTran = db.UseTran(() =>
                    {
                        db.Deleteable<BIZ_MES_WO>().Where(x => x.ID == woId).ExecuteCommand();
                    });
                    if (!dbTran.IsSuccess)
                    {
                        result.IsSuccessed = false;
                        result.LocaleMsg = new($"删除工单异常");
                    }
                }
                catch (Exception ex)
                {
                    result.CatchExceptionWithLog(ex, "删除工单异常");
                }
                return await Task.FromResult(result);
            }
        }
    }
}

 Tiger.IBusiness/MES/IBIZ_MES_WO.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,17 @@
using Rhea.Common;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Tiger.Model;

namespace Tiger.IBusiness
{
    public interface IBIZ_MES_WO
    {
        public Task<ApiAction> SaveMesWo(BIZ_MES_WO wo);
        public Task<ApiAction> DeleteMesWo(string woId);
    }
}

 Tiger.Model.Net/Entitys/MES/BIZ_MES_WO.cs

@@ -218,6 +218,18 @@
            [Description("已关闭")]
            Closed,
        }

        public enum ROUTE_STATUSs
        {
            [Description("待配置")]
            WaitSet,
            [Description("已配置")]
            Finish,
            [Description("取消")]
            Cancel,
            [Description("已关闭")]
            Closed,
        }
        #endregion

        #region å…¬å…±æ–¹æ³•