获取工单模板变量

Ben Lin

2024-09-22 6f0a6b40e86e2024c218d1d38cbdc5515fb95209

获取工单模板变量

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

@@ -115,5 +115,47 @@
            }
            return Ok(response);
        }

        /// <summary>
        /// 更新工单模板变量
        /// </summary>
        /// <param name="action"></param>
        /// <returns></returns>
        [HttpPost]
        [Route("api/[controller]/[action]")]
        public async Task<IActionResult> AddOrEditLabelVarByWorkOrder([FromBody] ApiAction<BAS_LABEL_VAR_WO> action)
        {
            ApiAction response = new();
            try
            {
                response = response.GetResponse(await DI.Resolve<IBIZ_MES_WO>().AddOrEditLabelVarByWorkOrder(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> GetLabelVarByWorkOrder([FromBody] ApiAction<BizLabelVarWoInput> action)
        {
            ApiAction response = new();
            try
            {
                response = response.GetResponse(await DI.Resolve<IBIZ_MES_WO>().GetLabelVarByWorkOrder(action.Data));
            }
            catch (System.Exception ex)
            {
                response = response.GetResponse().CatchExceptionWithLog(ex);
            }
            return Ok(response);
        }
    }
}

 Tiger.Business.MES/BIZ/BIZ_MES_WO.cs

@@ -254,5 +254,78 @@
            }
            return result;
        }

        /// <summary>
        /// 工单模板变量修改
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        public async Task<ApiAction> AddOrEditLabelVarByWorkOrder(BAS_LABEL_VAR_WO input)
        {
            var result = new ApiAction();
            try
            {
                //保存前的判断
                if (input.WORK_ORDER.IsNullOrEmpty())
                {
                    result.IsSuccessed = false;
                    result.LocaleMsg = new($"工单号不能为空！");
                    return result;
                }

                var db = Biz.Db;
                var dbTran = db.UseTran(() =>
                {
                    var y = db.Storageable(input)
                       .WhereColumns(t => new { t.LABEL_ID, t.WORK_ORDER, t.VAR_NAME, t.GHOST_ROW })
                       .ToStorage();
                    y.AsInsertable.ExecuteCommand();
                    y.AsUpdateable.IgnoreColumns(x => x.ID).ExecuteCommand();
                });
                if (!dbTran.IsSuccess)
                {
                    result.IsSuccessed = false;
                    result.LocaleMsg = new($"更新工单模板变量异常");
                }
            }
            catch (Exception ex)
            {
                result.CatchExceptionWithLog(ex, "更新工单模板变量异常");
            }
            return await Task.FromResult(result);
        }

        /// <summary>
        /// 获取工单模板变量
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        public async Task<ApiAction<QueryAble<BAS_LABEL_VAR_WO>>> GetLabelVarByWorkOrder(BizLabelVarWoInput input)
        {
            var result = new ApiAction<QueryAble<BAS_LABEL_VAR_WO>>();
            try
            {
                QueryAble<BAS_LABEL_VAR_WO> query = new();
                if (input.WorkOrder.IsNullOrEmpty())
                {
                    result.IsSuccessed = false;
                    result.LocaleMsg = new($"工单号不能为空！");
                    return result;
                }
                query.page = await Biz.Db.Queryable<BAS_LABEL_VAR_WO>().Where(q=>q.WORK_ORDER.Equals(input.WorkOrder) && q.LABEL_ID.Equals(input.LabelId)).ToPageAsync(input.pageIndex, input.pageSize);
                query.Items = query.page.data;
                //如果不存在，则返回初始数据
                if (query.page.totals == 0) {
                    query.page = await Biz.Db.Queryable<BAS_LABEL_VAR_WO>().Where(q => SqlFunc.IsNullOrEmpty(q.WORK_ORDER) && q.LABEL_ID.Equals(input.LabelId)).ToPageAsync(input.pageIndex, input.pageSize);
                    query.Items = query.page.data;
                }
                result.Data = query;
            }
            catch (Exception ex)
            {
                result.CatchExceptionWithLog(ex, "获取工单模板变量异常");
            }
            return result;
        }
    }
}

 Tiger.IBusiness/MES/BIZ/IMES_WO.cs

@@ -18,5 +18,7 @@
        public Task<ApiAction> SaveMesBatchWo(SaveWoBatchInput input);
        public Task<ApiAction> UpdateWoStatus(BizMesWoInput input);
        public Task<ApiAction> UpdateWoBatchStatus(BizMesWoInput input);
        public Task<ApiAction> AddOrEditLabelVarByWorkOrder(BAS_LABEL_VAR_WO input);
        public Task<ApiAction<QueryAble<BAS_LABEL_VAR_WO>>> GetLabelVarByWorkOrder(BizLabelVarWoInput input);
    }
}

 Tiger.Model.Net/Entitys/MES/ParameterEntity/BizMesWoParameter.cs

@@ -14,4 +14,15 @@
        public int Status { get; set; }
        public int RouteStatus { get; set; }
    }

    public class BizLabelVarWoInput
    {
        public string WorkOrder { get; set; }
        public string LabelId { get; set; }
        public int draw { get; set; }

        public int pageIndex { get; set; }

        public int pageSize { get; set; }
    }
}