| | |
| | | |
| | | |
| | | if (!string.IsNullOrEmpty(createTimeStart)) |
| | | Condition += " and DATEDIFF(day,a.[MakeTime],'" + createTimeStart + "')<=0 "; |
| | | Condition += " and DATEDIFF(day,a.[OverTime],'" + createTimeStart + "')<=0 "; |
| | | |
| | | if (!string.IsNullOrEmpty(createTimeEnd)) |
| | | Condition += " and DATEDIFF(day,a.[MakeTime],'" + createTimeEnd + "')>=0 "; |
| | | Condition += " and DATEDIFF(day,a.[OverTime],'" + createTimeEnd + "')>=0 "; |
| | | |
| | | |
| | | |
| | |
| | | { |
| | | new Criterion("", Condition), |
| | | |
| | | new Criterion("orderBy"," MakeTime desc ") |
| | | new Criterion("orderBy"," OverTime desc ") |
| | | }; |
| | | query.Criteria = criterias; |
| | | return _ICoreDeliverOrderDAL.SelectModelPage(query, pa); |