using HH.Redis.ReisModel;
using HH.WMS.Common;
using HH.WMS.Entitys;
using HH.WMS.Entitys.Basic;
using HH.WMS.Entitys.Common;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace HH.WMS.DAL.InStock
{
    public class TN_WM_HKINDAL : DapperBaseDAL
    {
        #region 更新工单状态
        /// <summary>
        /// 更新工单状态
        /// </summary>
        /// <param name="woNo">单号</param>
        /// <param name="examineType">审批状态</param>
        /// <returns></returns>
        /// <History>[HANHE(XDL)] CREATED BY 2019-02-20</History>
        public OperateResult ExamineMst(string woNo, string examineType, RedisUserEntity userEntity, IDbTransaction trans)
        {
            OperateResult result = new OperateResult();

            StringBuilder strSql = new StringBuilder();
            strSql.Append(" UPDATE TN_WM_WORK_ORDER SET CN_S_STATUS=@CN_S_STATUS,CN_S_MODIFY=@CN_S_MODIFY,CN_S_MODIFY_BY=@CN_S_MODIFY_BY,CN_T_MODIFY=@CN_T_MODIFY WHERE CN_S_WO_NO=@CN_S_WO_NO");

            return result = ExecuteTranSql(strSql.ToString(), new
              {
                  CN_S_STATUS = examineType,
                  CN_S_WO_NO = woNo,
                  CN_S_MODIFY = userEntity.CN_S_LOGIN,
                  CN_S_MODIFY_BY = userEntity.CN_S_NAME,
                  CN_T_MODIFY = DateTime.Now
              }, trans);
        }

        #endregion

        #region 查询工单列表
        /// <summary>
        /// 查询工单列表
        /// </summary>
        /// <param name="searchModel">实体</param>
        /// <returns></returns>
        /// <History>[HANHE(XDL)] CREATED BY 2018-12-18</History>
        public OperateResult GetInOrderList(SearchModel searchModel)
        {
            var condition = searchModel.SearchCondition;
            string ConStr = "where 1=1 ";
            if (condition != null)
            {
                if (!string.IsNullOrEmpty(condition.CN_S_WO_NO.ToString()))
                {
                    ConStr = ConStr + " and CN_S_WO_NO like '%" + condition.CN_S_WO_NO + "%'";
                }
                string state = condition.CN_S_STATUS.ToString();
                if (!string.IsNullOrEmpty(state))
                {
                    if (state.IndexOf(",") > 0)
                    {
                        state = "'" + state.Replace(",", "','") + "'";
                        ConStr = ConStr + " and CN_S_STATUS in (" + state + ")";
                    }
                    else
                    {
                        ConStr = ConStr + " and CN_S_STATUS='" + state + "'";
                    }
                }
                if (!string.IsNullOrEmpty(condition.CN_T_START.ToString()))
                {
                    ConStr = ConStr + " and CN_T_CREATE >= '" + Util.ToStringInput(condition.CN_T_START) + " 00:00:00'";
                }
                if (!string.IsNullOrEmpty(condition.CN_T_END.ToString()))
                {
                    ConStr = ConStr + " and CN_T_CREATE <= '" + Util.ToStringInput(condition.CN_T_END) + " 23:59:59'";
                }

                if (!string.IsNullOrEmpty(condition.CN_S_LINE.ToString()))
                {
                    ConStr = ConStr + " and CN_S_LINE = '" + condition.CN_S_LINE + "'";
                }
            }
            string sql = @"(select * from TN_WM_WORK_ORDER ) T " + ConStr;

            OperateResult result = new OperateResult();

            return ExecutePagingResult(sql, searchModel.PageIndex, searchModel.PageSize, "", "");
        }
        #endregion

        #region 根据产线编号查询该产线正在执行中的工单信息
        /// <summary>
        /// 查询到货单列表
        /// </summary>
        /// <param name="searchModel">实体</param>
        /// <returns></returns>
        /// <History>[HANHE(XDL)] CREATED BY 2018-12-18</History>
        public List<TN_WM_WORK_ORDEREntity> GetOrderInfoByLine(string lineNo)
        {
            StringBuilder ConStr = new StringBuilder();
            ConStr.Append("where 1=1  ");

            if (!string.IsNullOrEmpty(lineNo))
            {
                ConStr.Append(" AND CN_S_LINE = '" + lineNo + "'");
            }
            ConStr.Append(" AND CN_S_STATUS = '执行中'");

            string sql = @"select * from TN_WM_WORK_ORDER " + ConStr.ToString();

            OperateResult result = new OperateResult();

            return ExecuteQuery<TN_WM_WORK_ORDEREntity>(sql, null);
        }
        #endregion

    }
}