using HH.WMS.Entitys;
using HH.WMS.Entitys.Basic;
/********************************************************************************

** auth： DBS

** date： 2018/12/12 15:43:01

** desc： 尚未编写描述

** Ver.:  V1.0.0

*********************************************************************************/
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace HH.WMS.DAL.Basic
{
    public class TN_WM_PRINT_TASKDAL:DapperBaseDAL
    {
        #region 更新打印任务标识
        /// <summary>
        /// 更新打印任务标识
        /// </summary>
        /// <param name="guids">打印任务guid,多个用逗号隔开</param>
        /// <returns></returns>
        /// <History>[Hanhe(DBS)] created  2018/12/13</History>
        public OperateResult UpdatePrintFlag(string guids)
        {
            string sql = "update TN_WM_PRINT_TASK set CN_C_IS_PRINTED='Y' where CN_GUID in('"+guids.Replace(",","','")+"')";

            return ExecuteTranSql(sql,null,null);
        }
        #endregion

        #region 查询打印任务
        /// <summary>
        /// 查询打印任务
        /// </summary>
        /// <param name="mac">机器MAC地址</param>
        /// <param name="isHistory">是否查询已打印记录(Y/N)</param>
        /// <param name="key">模糊搜索的打印任务</param>
        /// <param name="startDate">开始时间</param>
        /// <param name="endDate">结束时间</param>
        /// <returns></returns>
        /// <History>[Hanhe(DBS)] created  2018/12/12</History>
        public List<TN_WM_PRINT_TASKEntity> GetList(string mac, string isHistory, string key, string startDate, string endDate)
        {
            string sql = "select * from TN_WM_PRINT_TASK where CN_S_MAC=@CN_S_MAC and CN_C_IS_PRINTED=@CN_C_IS_PRINTED ";
            if (!string.IsNullOrEmpty(startDate))
                sql += " and CN_T_CREATE >='" + startDate+"'";
            if (!string.IsNullOrEmpty(endDate))
                sql += " and CN_T_CREATE <='"+endDate+"'";
            sql += "  and CN_S_CONTENT like @CN_S_CONTENT";
            return ExecuteQuery <TN_WM_PRINT_TASKEntity>(sql, new
            { 
                CN_S_MAC =mac,
                CN_C_IS_PRINTED = isHistory,
                CN_S_CONTENT= "%"+key+"%"
            });
        }
        #endregion
    }
}