/// <summary> /// 查询对账数据 /// </summary> /// <param name="filter">筛选条件</param> /// <returns></returns> /// <remarks>2014-8-21 朱成果 创建</remarks> public Pager <FnThirdpartyReconciliation> QueryReconciliation(Model.Parameter.ParaReconciliationFilter filter) { return(IFnThirdpartyReconciliationDao.Instance.Query(filter)); }
/// <summary> /// 查询数据 /// </summary> /// <param name="filter">筛选条件</param> /// <returns></returns> /// <remarks>2014-8-21 朱成果 创建</remarks> public override Pager <FnThirdpartyReconciliation> Query(Model.Parameter.ParaReconciliationFilter filter) { string selecttable = "FnThirdpartyReconciliation a"; var paras = new ArrayList(); var where = "1=1 "; int i = 0; if (filter.Source.HasValue) { where += " and a.Source=@p0p" + i; paras.Add(filter.Source.Value); i++; } if (filter.Status.HasValue) { where += " and a.Status=@p0p" + i; paras.Add(filter.Status.Value); i++; } if (filter.BeginDate.HasValue) { where += " and a.TradeDate>=@p0p" + i; paras.Add(filter.BeginDate.Value); i++; } if (!string.IsNullOrEmpty(filter.FnNo)) { where += " and a.FnNo=@p0p" + i; paras.Add(filter.FnNo); i++; } if (!string.IsNullOrEmpty(filter.TraderNo)) { where += " and charindex(a.TraderNo,@p0p" + i + ")>0"; paras.Add(filter.TraderNo); i++; } if (filter.EndDate.HasValue) { where += " and a.TradeDate<=@p0p" + i; paras.Add(filter.EndDate.Value); i++; } Pager <FnThirdpartyReconciliation> pager = new Pager <FnThirdpartyReconciliation>(); pager.CurrentPage = filter.Id; pager.PageSize = filter.PageSize; pager.TotalRows = Context.Select <int>("count(0)").From(selecttable) .Where(where) .Parameters(paras) .QuerySingle(); pager.Rows = Context.Select <FnThirdpartyReconciliation>("a.*") .From(selecttable) .Where(where) .Parameters(paras) .OrderBy("a.TradeDate asc") .Paging(filter.Id, filter.PageSize) .QueryMany(); return(pager); }