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
|
}
|
}
|