using HH.WMS.Entitys; 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.OutStock { public class TN_WM_WAVE_MSTDAL : DapperBaseDAL { #region 保存物流 /// /// 保存物流 /// /// /// public OperateResult SaveWayBill(object param) { string sql = @"UPDATE TN_WM_OUT_MST SET CN_S_LOGISTICS_FLAG=@CN_S_LOGISTICS_FLAG,CN_S_LOGISTICS_NAME=@CN_S_LOGISTICS_NAME,CN_S_WAYBILL_NO=@CN_S_WAYBILL_NO,CN_S_FORWARDING_WAY=@CN_S_FORWARDING_WAY WHERE CN_S_OP_NO=@CN_S_OP_NO"; return ExecuteTranSql(sql, param, null); } #endregion #region 波次列表 /// /// 波次列表 /// /// /// /// public OperateResult WaveList(SearchModel searchModel) { string sql = @"( SELECT (SELECT COUNT(1) FROM TN_WM_WAVE_DTL WHERE CN_S_WAVE_NO=wavemst.CN_S_WAVE_NO) OUT_NUM, * FROM TN_WM_WAVE_MST wavemst) t"; return ExecutePagingResult(sql, searchModel.PageIndex, searchModel.PageSize); } #endregion //public DataTable OutOfStockList(dynamic where) //{ // string sql = @"SELECT a.*,b.CN_S_CUSTOMER_NAME FROM TN_WM_B_OOS_BILL_REG a,TN_WM_OUT_MST b WHERE a.CN_S_FROM_NO = b.CN_S_OP_NO "; // if (!string.IsNullOrEmpty(itemCode)) // { // sql += " AND a.CN_S_ITEM_CODE like'%" + itemCode + "%'"; // } // if (!string.IsNullOrEmpty(outNo)) // { // sql += " AND a.CN_S_FROM_NO like'%" + outNo + "%'"; // } // if (!string.IsNullOrEmpty(customerName)) // { // sql += " AND b.CN_S_CUSTOMER_NAME like'%" + customerName + "%'"; // } // if (!string.IsNullOrEmpty(state)) // { // sql += " AND a.CN_S_STATE ='" + state + "'"; // } // if (!string.IsNullOrEmpty(opStartDate)) // { // sql += " AND a.CN_T_OP_DATE >='" + opStartDate + "'"; // } // if (!string.IsNullOrEmpty(opEndDate)) // { // sql += " AND a.CN_T_OP_DATE <'" + opEndDate + "'"; // } //} } }