/// <summary> /// 界面分页列表 /// </summary> /// <param name="filter">筛选字段</param> /// <returns>分页列表</returns> /// <remarks>2015-10-9 王江 创建</remarks> public override Pager <CBTransferCargoConfig> GetTransferCargoConfigList(Model.Parameter.ParaTransferCargoConfigFilter filter) { string sqlSelect = @"m.sysno,m.applywarehousesysno,n.warehousename ApplyWarehouseName,m.deliverywarehousesysno,p.warehousename DeliveryWarehouseName,m.status, s.username CreateUserName,m.createddate,m.lastupdatedate,t.username UpdateUserName "; string sqlFrom = @"TransferCargoConfig m inner join whwarehouse n on m.applywarehousesysno=n.sysno left join whwarehouse p on m.deliverywarehousesysno=p.sysno left join SyUser s on m.createdby=s.sysno left join SyUser t on m.lastupdateby=t.sysno"; var parameters = new ArrayList(); System.Text.StringBuilder strWhere = new System.Text.StringBuilder("1=1"); if (filter.IsQueryPickingWarehouse) { strWhere.AppendFormat(" and m.sysno in (select min(sysno) from TransferCargoConfig t group by t.deliverywarehousesysno)"); } if (!string.IsNullOrWhiteSpace(filter.ApplyWarehouseName)) // 申请调货仓库名称 { strWhere.AppendFormat(" and n.warehousename=@ApplyWarehouseName", filter.ApplyWarehouseName); parameters.Add(filter.ApplyWarehouseName); } if (!string.IsNullOrWhiteSpace(filter.DeliveryWarehouseName)) // 配货仓库名称 { strWhere.AppendFormat(" and p.warehousename=@DeliveryWarehouseName", filter.DeliveryWarehouseName); parameters.Add(filter.DeliveryWarehouseName); } var pager = new Pager <CBTransferCargoConfig> { CurrentPage = filter.Id, PageSize = filter.PageSize }; using (var context = Context.UseSharedConnection(true)) { var results = context.Select <CBTransferCargoConfig>(sqlSelect) .From(sqlFrom) .AndWhere(strWhere.ToString()) .Parameters(parameters) .Paging(filter.Id, filter.PageSize) .OrderBy("m.SysNo desc") .QueryMany(); var count = context.Select <int>(@"count(*)") .From(sqlFrom) .AndWhere(strWhere.ToString()) .Parameters(parameters) .QuerySingle(); pager.Rows = results; pager.TotalRows = count; } return(pager); }
/// <summary> /// 界面分页列表 /// </summary> /// <param name="filter">筛选字段</param> /// <returns>分页列表</returns> /// <remarks>2015-10-9 王江 创建</remarks> public abstract Pager <CBTransferCargoConfig> GetTransferCargoConfigList(Model.Parameter.ParaTransferCargoConfigFilter filter);