using HH.WMS.Common;
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_ORDER_SORTING_RELDAL : DapperBaseDAL
    {
        #region 发货明细
        /// <summary>
        /// 发货明细
        /// </summary>
        /// <param name="opNo"></param>
        /// <param name="uniqueCode"></param>
        /// <returns></returns>
        public DataTable DeliverGoodsDetail(string opNo, string uniqueCode)
        {
            string sql = @"SELECT A.CN_S_OP_NO,A.CN_S_OP_TYPE,A.CN_S_CUSTOMER_NAME,A.CN_S_STATE,
B.CN_S_UNIQUE_CODE,B.CN_S_ITEM_CODE,B.CN_S_ITEM_NAME,B.CN_S_ITEM_STATE,B.CN_F_QUANTITY,B.CN_S_MEASURE_UNIT,B.CN_S_PACKING_UNIT,B.CN_F_PACKING_QTY FROM TN_WM_OUT_MST A,TN_WM_ORDER_SORTING_REL B
WHERE A.CN_S_OP_NO=B.CN_S_ORDER_NO AND B.CN_C_ISPACK='Y'";
            if (!string.IsNullOrEmpty(opNo))
            {
                sql += " AND  A.CN_S_OP_NO='" + Util.ToStringInput(opNo) + "'";
            }
            if (!string.IsNullOrEmpty(uniqueCode))
            {
                sql += " AND  B.CN_S_UNIQUE_CODE='" + Util.ToStringInput(uniqueCode) + "'";
            }
            return ExecuteDataTable(sql);
        }
        #endregion
    }
}