using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace HH.WMS.DAL.OutStock
{
   public class TN_WM_REDUCE_INVENTORYDAL:DapperBaseDAL
    {
        #region 查询数据，返回数据集合
        //根据出库单号获取数据集合
        /// <summary>
        /// 根据出库单号获取数据
        /// </summary>
        /// <param name="opNo">出库单号</param>
        /// <returns></returns>
        public DataTable GetReduceData(string opNo)
        {
            StringBuilder sbStr = new StringBuilder();
            DataTable dt = new DataTable();

            sbStr.Append(" SELECT MST.CN_S_OP_TYPE,");
            sbStr.Append("(SELECT TOP 1 CN_S_OPERATION_CODE FROM  DBO.TN_WM_OPERATION_TYPE TY WHERE TY.CN_S_OPERATION_NAME=MST.CN_S_OP_TYPE ) CN_S_OPERATION_CODE,");
            sbStr.Append(" DTL.CN_S_OWNER,MST.CN_S_STOCK_CODE,DTL.CN_S_LOT_CODE,DTL.* ");
            sbStr.Append(" FROM TN_WM_REDUCE_INVENTORY_DTL DTL LEFT JOIN TN_WM_REDUCE_INVENTORY_MST MST ");
            sbStr.Append(" ON DTL.CN_S_OP_NO =MST.CN_S_OP_NO  ");
            sbStr.Append(" WHERE CN_S_OP_CLASS='出库订单' ");

            if (!string.IsNullOrEmpty(opNo))
            {
                sbStr.Append(" AND CN_S_FROM_NO='" + opNo + "'	");
            }
            else
            {
                return dt;
            }
            return ExecuteDataTable(sbStr.ToString());
        }
        #endregion

    }
}