| | |
| | | { |
| | | new SqlParameter("@Keyid",OrderId) |
| | | }; |
| | | string sql = " Update [EC_OrderExtend] Set [SurplusPrintNum]=[PrintNum] where [Keyid] = (select [OrderId] from [OA_OrderWorkListRelation] where [RelationTargetId] = @Keyid and [RelationTypeId]=4 ) ;Update [EC_OrderBasic] Set [OrderState]=2 where [Keyid] = (select [OrderId] from [OA_OrderWorkListRelation] where [RelationTargetId] = @Keyid and [RelationTypeId]=4 ) "; |
| | | string sql = " Update [EC_OrderExtend] Set [SurplusPrintNum]=[PrintNum] where [Keyid] = (select [OrderId] from [OA_OrderWorkListRelation] where [RelationTargetId] = @Keyid and [RelationTypeId]=4 ) ;Update [EC_OrderBasic] Set [OrderState]=1 where [Keyid] = (select [OrderId] from [OA_OrderWorkListRelation] where [RelationTargetId] = @Keyid and [RelationTypeId]=4 ) "; |
| | | |
| | | try |
| | | { |
| | |
| | | } |
| | | IList<EC_OrderBasic> result = _dataBase.SelectModel<EC_OrderBasic>(" * ", "EC_OrderBasic ", string.Format(" Keyid = {0}", orderId)); |
| | | return null == result || result.Count < 1 ? null : result[0]; |
| | | } |
| | | |
| | | |
| | | |
| | | /// <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 or OrderState = 2 or OrderState = 3 )", PrintTypeId)); |
| | | return result; |
| | | } |
| | | |
| | | |
| | |
| | | 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 + "' "; |