| | |
| | | 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); |
| | |
| | | |
| | | if (!string.IsNullOrEmpty(OrderState)) |
| | | { |
| | | if (OrderState != "4") |
| | | { |
| | | Condition += " and a.OrderState = " + OrderState + " "; |
| | | } |
| | | else |
| | | { |
| | | Condition += " and a.OrderState in( 0,1 ) "; |
| | | } |
| | | } |
| | | else |
| | | { |
| | |
| | | Condition += " and b.shipAddress = '" + shipAddress + "'"; |
| | | |
| | | if (!string.IsNullOrEmpty(BuyerName)) |
| | | Condition += " and c.BuyerName like '%" + BuyerName + "%'"; |
| | | Condition += " and c.Keyid = '" + BuyerName + "'"; |
| | | |
| | | |
| | | if (!string.IsNullOrEmpty(createTimeStart)) |