/// <summary>
/// 提货码及验证码分页查询
/// </summary>
/// <param name="pager">分页列表</param>
/// <param name="filter">筛选条件</param>
/// <returns>提货码及验证码分页</returns>
/// <remarks>2013-12-3 余勇 创建</remarks>
public override void GetPickUpSmsList(ref Pager <CBWhPickUpCode> pager, ParaWhPickUpCodeFilter filter)
{
string sqlField;
string sqlFrom;
var paras = new object[]
{
filter.MobilePhoneNumber, filter.MobilePhoneNumber
};
if (filter.SearchType == 1)
{
var quickSearchKeyword = filter.MobilePhoneNumber;
sqlFrom =
@"whpickupcode
where (@MobilePhoneNumber is null or MobilePhoneNumber=@MobilePhoneNumber)
and (@StockOutSysNo is null or StockOutSysNo=@StockOutSysNo)";
sqlField = "SysNo,MobilePhoneNumber,Code as Content,CreatedDate,20 as Status,StockOutSysNo";
//手机号
if (VHelper.ValidatorRule(new Rule_Mobile(quickSearchKeyword)).IsPass&& quickSearchKeyword.Length >= 11)
{
filter.StockOutSysNo = null;
}
//出库单号
else if (VHelper.ValidatorRule(new Rule_Number(quickSearchKeyword)).IsPass)
{
filter.StockOutSysNo = int.Parse(quickSearchKeyword);
filter.MobilePhoneNumber = null;
}
else
{
filter.StockOutSysNo = null;
filter.MobilePhoneNumber = null;
}
paras = new object[] { filter.MobilePhoneNumber, filter.StockOutSysNo };
}
else
{
sqlFrom =
@"ncsms
where @MobilePhoneNumber is null or MobilePhoneNumber=@MobilePhoneNumber";
sqlField = "SysNo,MobilePhoneNumber,SMSCONTENT as Content,CreatedDate,Status,'' as StockOutSysNo";
}
var dataList = Context.Select <CBWhPickUpCode>(sqlField).From(sqlFrom);
var dataCount = Context.Select <int>("count(0)").From(sqlFrom);
dataList.Parameter("MobilePhoneNumber", paras[0]);
dataList.Parameter("StockOutSysNo", paras[1]);
dataCount.Parameter("MobilePhoneNumber", paras[0]);
dataCount.Parameter("StockOutSysNo", paras[1]);
var totalRows = dataCount.QuerySingle();
List <CBWhPickUpCode> rows = dataList.OrderBy("CREATEDDATE desc").Paging(pager.CurrentPage, pager.PageSize).QueryMany();
pager.TotalRows = totalRows;
pager.Rows = rows;
}
/// <summary> /// 提货码及验证码分页查询 /// </summary> /// <param name="pager">分页列表</param> /// <param name="filter">筛选条件</param> /// <returns></returns> /// <remarks>2013-12-3 余勇 创建</remarks> public abstract void GetPickUpSmsList(ref Pager <CBWhPickUpCode> pager, ParaWhPickUpCodeFilter filter);
