96 lines
2.7 KiB
Transact-SQL
96 lines
2.7 KiB
Transact-SQL
set nocount on;
|
||
set xact_abort on;
|
||
|
||
/* 03仓充电桩：仅允许更新指定的两个货位节点。 */
|
||
begin try
|
||
begin transaction;
|
||
|
||
if
|
||
(
|
||
select count(*)
|
||
from dbo.bas_cargo_space with (updlock, holdlock)
|
||
where warehouse_id = N'03'
|
||
and cargo_space_id in (N'03060501', N'03060502')
|
||
) <> 2
|
||
throw 51020, N'03仓充电桩货位不存在或数量异常。', 1;
|
||
|
||
update dbo.bas_cargo_space
|
||
set status = N'10',
|
||
the_type_name = N'充电桩',
|
||
cargo_space_name = concat(
|
||
right(N'00' + convert(nvarchar(2), the_platoon), 2), N'排',
|
||
right(N'00' + convert(nvarchar(2), the_column), 2), N'列',
|
||
right(N'00' + convert(nvarchar(2), the_floor), 2), N'层-充电桩'
|
||
),
|
||
group_coding_no = null,
|
||
group_coding = null,
|
||
this_cargo_area = null
|
||
where warehouse_id = N'03'
|
||
and cargo_space_id in (N'03060501', N'03060502');
|
||
|
||
declare @updated_count int = @@rowcount;
|
||
if @updated_count <> 2
|
||
throw 51021, N'03仓充电桩更新数量异常。', 1;
|
||
|
||
if not exists
|
||
(
|
||
select 1
|
||
from dbo.sys_dict_data
|
||
where dict_type = N'bas_cargo_space_status'
|
||
and dict_value = N'10'
|
||
)
|
||
begin
|
||
insert into dbo.sys_dict_data
|
||
(
|
||
dict_sort, dict_label, dict_value, dict_type,
|
||
css_class, list_class, is_default, status,
|
||
create_by, create_time, update_by, update_time, remark
|
||
)
|
||
values
|
||
(
|
||
10, N'充电桩', N'10', N'bas_cargo_space_status',
|
||
null, N'info', N'N', N'0',
|
||
N'admin', getdate(), N'', null, N'03仓充电桩节点'
|
||
);
|
||
end
|
||
else
|
||
begin
|
||
update dbo.sys_dict_data
|
||
set dict_label = N'充电桩',
|
||
dict_sort = 10,
|
||
status = N'0',
|
||
remark = N'03仓充电桩节点',
|
||
update_by = N'admin',
|
||
update_time = getdate()
|
||
where dict_type = N'bas_cargo_space_status'
|
||
and dict_value = N'10';
|
||
end;
|
||
|
||
if exists
|
||
(
|
||
select 1
|
||
from dbo.bas_cargo_space
|
||
where cargo_space_id in (N'03060501', N'03060502')
|
||
and
|
||
(
|
||
warehouse_id <> N'03'
|
||
or status <> N'10'
|
||
or the_type_name <> N'充电桩'
|
||
or group_coding is not null
|
||
)
|
||
)
|
||
throw 51022, N'03仓充电桩结果校验失败。', 1;
|
||
|
||
commit transaction;
|
||
end try
|
||
begin catch
|
||
if xact_state() <> 0
|
||
rollback transaction;
|
||
throw;
|
||
end catch;
|
||
|
||
select cargo_space_id, cargo_space_name, status, the_type_name, group_coding
|
||
from dbo.bas_cargo_space
|
||
where cargo_space_id in (N'03060501', N'03060502')
|
||
order by cargo_space_id;
|