using HH.WCS.JingyuNongfu.util;
using SqlSugar;
using System;
using System.Collections.Generic;

namespace HH.WCS.JingyuNongfu.wms
{
    /// <summary>
    /// 工单 相关表的读写
    /// </summary>
    public class MESHelper
    {
        static MESHelper()
        {
        }

        /// <summary>
        /// 查询工单
        /// </summary>
        /// <param name="lineNo"></param>
        /// <returns></returns>
        public static WorkOrder GetWorkOrder(string lineNo)
        {
            var order = new SqlHelper<WorkOrder>().Get(a => a.S_PLineNo == lineNo && (a.S_WorkState == "执行中"), a => a.T_CREATE, true);
            return order;
        }
        public static WorkOrder3 GetWorkOrderdsj(string lineNo)
        {
            var order = new SqlHelper<WorkOrder3>().Get(a => a.S_PLineNo == lineNo && (a.S_WorkState == "执行中"), a => a.T_CREATE, true);
            return order;
        }
        /// <summary>
        /// 查询工单
        /// </summary>
        /// <param name="lineNo"></param>
        /// <returns></returns>
        public static WorkOrder GetWorkOrderN(string lineNo)
        {
            var order = new SqlHelper<WorkOrder>().Get(a => a.S_PLineNo == lineNo && (a.S_WorkState == "执行中" && a.S_UsingNow.Trim() == "N"), a => a.T_CREATE, true);
            return order;
        }
        /// <summary>
        /// 查询审核的工单
        /// </summary>
        /// <param name="lineNo"></param>
        /// <returns></returns>
        public static WorkOrder GetWorkOrderVerify(string lineNo)
        {
            var order = new SqlHelper<WorkOrder>().Get(a => a.S_PLineNo == lineNo && a.S_WorkState == "审核中", a => a.T_CREATE, true);
            return order;
        }
        public static WorkOrder GetWorkOrderByOrderNo(string orderNo)
        {
            var order = new SqlHelper<WorkOrder>().Get(a => a.S_WorkNo == orderNo);
            return order;
        }
        internal static bool UpdateWorkOrderAutoCompleteFalse(WorkOrder workOrder)
        {
            var db = new SqlHelper<object>().GetInstance();
            workOrder.S_AutoComplete = "否";
            return db.Updateable(workOrder).UpdateColumns(it => new { it.S_AutoComplete }).ExecuteCommand() > 0;
        }
       

        /// <summary>
        /// 查找成品工单
        /// </summary>
        /// <param name="lineNo"></param>
        /// <returns></returns>
        public static WorkOrder1 GetWorkOrder1(string lineNo)
        {
            var order = new SqlHelper<WorkOrder1>().Get(a => a.S_PLineNo.Trim() == lineNo && a.S_WorkState.Trim() == "执行中", a => a.T_CREATE, true);
            return order;
        }

        /// <summary>
        /// 按成品工单号查找成品工单
        /// </summary>
        /// <param name="lineNo"></param>
        /// <returns></returns>
        public static WorkOrder1 GetWorkByWorkno(string lineNo)
        {
            var order = new SqlHelper<WorkOrder1>().Get(a => a.S_WorkNo.Trim() == lineNo && a.S_WorkState.Trim() == "执行中", a => a.T_CREATE, true);
            return order;
        }
    }
}