| | |
| | | } |
| | | |
| | | |
| | | |
| | | /// <summary> |
| | | /// 根据类型查询 订单 |
| | | /// </summary> |
| | | /// <param name="orderId">订单编号</param> |
| | | /// <returns></returns> |
| | | public IEnumerable<EC_OrderBasic> GetOrderByPrintTypeId(int PrintTypeId) |
| | | { |
| | | |
| | | IList<EC_OrderBasic> result = _dataBase.SelectModel<EC_OrderBasic>(" * ", "EC_OrderBasic ", string.Format(" PrintTypeId = {0} and OrderState = 4 ", PrintTypeId)); |
| | | return result; |
| | | } |
| | | |
| | | |
| | | /// <summary> |
| | | /// 根据客户ID和订单支付状态获取订单列表 |
| | | /// </summary> |
| | |
| | | condition += " and a.CreateTime >= '" + StartCreatTime.Value + "' "; |
| | | |
| | | if (EndCreatTime != null) |
| | | condition += " and a.CreateTime =< '" + EndCreatTime.Value.AddDays(1) + "' "; |
| | | condition += " and a.CreateTime <= '" + EndCreatTime.Value.AddDays(1) + "' "; |
| | | |
| | | if (StartReturnTime != null) |
| | | condition += " and d.DeliverTime >= '" + StartReturnTime.Value + "' "; |