| | |
|---|
| | | |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 全部查询 |
|---|
| | | /// </summary> |
|---|
| | | /// <param name="query"></param> |
|---|
| | | /// <returns></returns> |
|---|
| | | public IEnumerable<Model.CoreDeliverOrderItem> GetDeliverModelsByplanOrderid(int planorderkeyid) |
|---|
| | | { |
|---|
| | | return _dataBase.SelectModel<Model.CoreDeliverOrderItem>(" a.*,b.[OrderId] as PlanOrderId,b.[MakeTime],b.[OrderState] ", " [CoreDeliverOrderItem] a Inner Join [CoreDeliverOrder] as b On(a.[OrderID]=b.[id] ) Inner Join [CoreCmsPlanOrder] as c On(b.[OrderID]=c.[id] ) ", " c.[id] = " + planorderkeyid + " and b.[OrderState] in (0,1) ") as IList<Model.CoreDeliverOrderItem>;//执行查询 |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 分页查询 |
|---|
| | | /// </summary> |
|---|
| | | /// <param name="query"></param> |
|---|
