| | |
|---|
| | | /// <param name="MemberId"></param> |
|---|
| | | /// <returns></returns> |
|---|
| | | public IEnumerable<Model.EC_SpecialOrders> SelectModelPage(Infrastructure.Query.Pagination pagination, Guid MemberId, string PrintName, string |
|---|
| | | CustomName, string PSO_OrderNum, DateTime? beginTime, DateTime? endTime) |
|---|
| | | CustomName, string PSO_OrderNum, DateTime? beginTime, DateTime? endTime, string PSF_PressesDesk) |
|---|
| | | { |
|---|
| | | try |
|---|
| | | { |
|---|
| | |
|---|
| | | { |
|---|
| | | Condition += string.Format(" and PSO_OrderNum like '%{0}%'", PSO_OrderNum); |
|---|
| | | } |
|---|
| | | |
|---|
| | | if (!string.IsNullOrEmpty(PSF_PressesDesk)) |
|---|
| | | { |
|---|
| | | Condition += string.Format(" and a.[Keyid] not in ( select [SpecialOrderId] from [EC_SpecialForums] where [PSF_PressesDesk] = '{0}')", PSF_PressesDesk); |
|---|
| | | } |
|---|
| | | |
|---|
| | | return _dataBase.SelectModelPage<Model.EC_SpecialOrders>(pagination, " a.*,b.BuyerName as CustomName,b.DocumentName as PrintName ", " EC_SpecialOrders as a left join EC_OrderBasic as b on a.PO_OrderId = b.Keyid ", " PSO_OrderNum DESC ", " PSO_OrderNum DESC ", Condition); |
|---|
| | | } |
|---|
