| | |
| | | Condition += " and b.shipAddress = '" + shipAddress + "'"; |
| | | |
| | | if (!string.IsNullOrEmpty(BuyerName)) |
| | | Condition += " and c.BuyerName like '%" + BuyerName + "%'"; |
| | | Condition += " and c.Keyid = '" + BuyerName + "'"; |
| | | |
| | | |
| | | if (!string.IsNullOrEmpty(createTimeStart)) |
| | |
| | | { |
| | | new Criterion("", Condition), |
| | | |
| | | new Criterion("orderBy"," MakeTime desc ") |
| | | new Criterion("orderBy"," MakeTime ") |
| | | }; |
| | | query.Criteria = criterias; |
| | | return _ICoreDeliverOrderDAL.SelectModelPage(query, pa); |
| | |
| | | /// <param name="pa"></param> |
| | | /// <returns></returns> |
| | | public IEnumerable<CoreDeliverOrder> SelectModelPageLishi(Pagination pa, Guid FirmId, int? DriverId, string shipAddress, |
| | | string BuyerName, string createTimeStart, string createTimeEnd,string OrderState) |
| | | string BuyerName, string createTimeStart, string createTimeEnd,string OrderState,string shifou) |
| | | { |
| | | string Condition = " and b.FirmId ='" + FirmId + "' "; |
| | | |
| | | if (!string.IsNullOrEmpty(OrderState)) |
| | | { |
| | | Condition += " and a.OrderState = " + OrderState + " "; |
| | | if (OrderState != "4") |
| | | { |
| | | Condition += " and a.OrderState = " + OrderState + " "; |
| | | } |
| | | else |
| | | { |
| | | Condition += " and a.OrderState in( 0,1 ) "; |
| | | } |
| | | } |
| | | else |
| | | { |
| | | Condition += " and a.OrderState in( 0,1,2 ) "; |
| | | if (!string.IsNullOrEmpty(shifou)) |
| | | { |
| | | Condition += " and a.OrderState in( 0,1 ) "; |
| | | } |
| | | else |
| | | { |
| | | Condition += " and a.OrderState in( 0,1,2 ) "; |
| | | } |
| | | |
| | | |
| | | } |
| | | if (DriverId.HasValue) |
| | | { |
| | |
| | | Condition += " and b.shipAddress = '" + shipAddress + "'"; |
| | | |
| | | if (!string.IsNullOrEmpty(BuyerName)) |
| | | Condition += " and c.BuyerName like '%" + BuyerName + "%'"; |
| | | Condition += " and c.Keyid = '" + BuyerName + "'"; |
| | | |
| | | |
| | | if (!string.IsNullOrEmpty(createTimeStart)) |