| | |
|---|
| | | } |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 删除外协订单 |
|---|
| | | /// </summary> |
|---|
| | | /// <param name="OrderId"></param> |
|---|
| | | /// <returns></returns> |
|---|
| | | public bool UpdateOldOrderSurplusPrintNum(int OrderId) |
|---|
| | | { |
|---|
| | | IList<SqlParameter> sqlParms = new List<SqlParameter>() |
|---|
| | | { |
|---|
| | | 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 ) "; |
|---|
| | | |
|---|
| | | try |
|---|
| | | { |
|---|
| | | _dataBase.ExecuteSql(sql, sqlParms.ToArray<SqlParameter>()); |
|---|
| | | } |
|---|
| | | catch (Exception ex) |
|---|
| | | { |
|---|
| | | throw ex; |
|---|
| | | } |
|---|
| | | return true; |
|---|
| | | } |
|---|
| | | |
|---|
| | | |
|---|
| | | /// <summary> |
|---|
| | | /// 分页查询 |
|---|
| | | /// </summary> |
|---|
| | | /// <param name="query">查询对象</param> |
|---|
