using HH.WMS.Entitys;
|
using HH.WMS.Entitys.Basic;
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
using HH.WMS.Entitys.Common;
|
using HH.WMS.Common;
|
using System.Data;
|
|
namespace HH.WMS.DAL.Basic
|
{
|
public class TN_WM_LOT_INFODAL:DapperBaseDAL
|
{
|
public OperateResult GetLotList(int pageIndex, int pageSize)
|
{
|
string sql = @"(select * from TN_WM_LOT_INFO) T ";
|
|
OperateResult result = new OperateResult();
|
|
return ExecutePagingResult(sql, pageIndex, pageSize, "", "");
|
}
|
|
public DataTable GetLotList(SearchModel searchModel,out long total)
|
{
|
var condition = searchModel.SearchCondition;
|
string sql = " select * from TN_WM_LOT_INFO where 1=1 ";
|
string ConStr = "";
|
if (condition != null)
|
{
|
if (!string.IsNullOrEmpty(condition.CN_S_LOT_CODE.ToString()))
|
{
|
ConStr = ConStr + " and CN_S_LOT_CODE like '%" + Util.ToStringInput(condition.CN_S_LOT_CODE) + "%'";
|
}
|
if (!string.IsNullOrEmpty(condition.CN_S_VENDOR_NO.ToString()))
|
{
|
ConStr = ConStr + " and CN_S_VENDOR_NO like '%" + Util.ToStringInput(condition.CN_S_VENDOR_NO) + "%'";
|
}
|
}
|
if (!string.IsNullOrEmpty(ConStr))
|
{
|
sql = sql + ConStr;
|
}
|
OperateResult result = new OperateResult();
|
//DataTable dt = new DataTable();
|
//if (!isExport)
|
//{
|
return ExecutePagingData(" (" + sql + ") t ", searchModel.PageIndex, searchModel.PageSize, out total, "", "");
|
//}
|
//else
|
//{
|
// total = 0;//无效
|
// return ExecuteDataTable(sql, "");
|
//}
|
|
}
|
}
|
}
|
