/// <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);