drop table #temp insert into ot_supervise (supervise_sysId,taxi_sysId,supervise_co,supervise_position,supervise_time,iseligible,superviser,driver_info_sysid, isdriverbook,driverbook,isfleecheck,fleecheck, iscertificate,certificate,isdamage,damage, istaxidamage,taxidamage,isseat,seat, isdirty,dirty,isad,ad,isfence,fence, islight,light,ispause,pause,issign,sign, isbanner,banner,isleasebanner,leasebanner, ispubbanner,pubbanner,isother,other, isworkclothes,workclothes,isspeaker, speaker,ispunish,punish,isterm,term, deal_content,manage_flag,manager_code, sum,manage_time,reason,manage_content,is_violation,is_corpdeal) values (@newId,@taxi_sysId,@supervise_co,@supervise_position,@supervise_time,@iseligible,@superviser,@driver_info_sysid, @isdriverbook,@driverbook,@isfleecheck,@fleecheck, @iscertificate,@certificate,@isdamage,@damage, @istaxidamage,@taxidamage,@isseat,@seat, @isdirty,@dirty,@isad,@ad,@isfence,@fence, @islight,@light,@ispause,@pause,@issign,@sign, @isbanner,@banner,@isleasebanner,@leasebanner, @ispubbanner,@pubbanner,@isother,@other, @isworkclothes,@workclothes,@isspeaker, @speaker,@ispunish,@punish,@isterm,@term, @deal_content,@manage_flag,@manager_code, @sum,@manage_time,@reason,@manage_content,@is_violation,@is_corpdeal) if @@error<>0 goto ErrorHead COMMIT TRANSACTION set @returninfo=@newid; end return ErrorHead: set @returninfo='2'; ROLLBACK TRANSACTION GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO
GO
SET ANSI_NULLS ON
GO
/****** Object: Stored Procedure dbo.p_supervise_insert Script Date: 2004-5-9 16:25:48 ******/
ALTER PROCEDURE p_ot_supervise_add
@taxi_sysid nvarchar (16) ,
@supervise_co nvarchar (30) ,
@supervise_position nvarchar (30) ,
@supervise_time datetime ,
@iseligible char (1) ,
@superviser nvarchar (20) ,
@driver_info_sysid nvarchar (16) ,
@isdriverbook char (1) ,
@driverbook nvarchar (100) ,
@isfleecheck char (1) ,
@fleecheck nvarchar (100) ,
@iscertificate char (1) ,
@certificate nvarchar (100) ,
@isdamage char (1) ,
@damage nvarchar (100) ,
@istaxidamage char (1) ,
@taxidamage nvarchar (100) ,
@isseat char (1) ,
@seat nvarchar (100) ,
@isdirty char (1) ,
@dirty nvarchar (100) ,
@isad char (1) ,
@ad nvarchar (100) ,
@isfence char (1) ,
@fence nvarchar (100) ,
@islight char (1) ,
@light nvarchar (100) ,
@ispause char (1) ,
@pause nvarchar (100) ,
@issign char (1) ,
@sign nvarchar (100) ,
@isbanner char (1) ,
@banner nvarchar (100) ,
@isleasebanner char (1) ,
@leasebanner nvarchar (100) ,
@ispubbanner char (1) ,
@pubbanner nvarchar (100) ,
@isother char (1) ,
@other nvarchar (100) ,
@isspeaker char (1) ,
@speaker nvarchar (100) ,
@isworkclothes char (1) ,
@workclothes nvarchar (100) ,
@ispunish char (1) ,
@punish numeric(10, 2) ,
@isterm char (1) ,
@term nvarchar (100) ,
@deal_content nvarchar (500) ,
@manage_flag char (1) ,
@manager_code nvarchar (16) ,
@sum nvarchar (50) ,
@manage_time datetime,
@reason nvarchar (500) ,
@manage_content nvarchar (500) ,
@is_violation char (1) ,
@is_corpdeal char (1) ,
@returninfo nvarchar(16) output
AS
declare
@newId nvarchar(16)begin
BEGIN TRANSACTION
--取得最大的编号
create table #temp(a varchar(100))
insert #temp exec dbo.p_getTableMaxId 'ot_supervise'
select @newid=a from #temp
drop table #temp
insert into ot_supervise
(supervise_sysId,taxi_sysId,supervise_co,supervise_position,supervise_time,iseligible,superviser,driver_info_sysid,
isdriverbook,driverbook,isfleecheck,fleecheck,
iscertificate,certificate,isdamage,damage,
istaxidamage,taxidamage,isseat,seat,
isdirty,dirty,isad,ad,isfence,fence,
islight,light,ispause,pause,issign,sign,
isbanner,banner,isleasebanner,leasebanner,
ispubbanner,pubbanner,isother,other,
isworkclothes,workclothes,isspeaker,
speaker,ispunish,punish,isterm,term,
deal_content,manage_flag,manager_code,
sum,manage_time,reason,manage_content,is_violation,is_corpdeal)
values (@newId,@taxi_sysId,@supervise_co,@supervise_position,@supervise_time,@iseligible,@superviser,@driver_info_sysid,
@isdriverbook,@driverbook,@isfleecheck,@fleecheck,
@iscertificate,@certificate,@isdamage,@damage,
@istaxidamage,@taxidamage,@isseat,@seat,
@isdirty,@dirty,@isad,@ad,@isfence,@fence,
@islight,@light,@ispause,@pause,@issign,@sign,
@isbanner,@banner,@isleasebanner,@leasebanner,
@ispubbanner,@pubbanner,@isother,@other,
@isworkclothes,@workclothes,@isspeaker,
@speaker,@ispunish,@punish,@isterm,@term,
@deal_content,@manage_flag,@manager_code,
@sum,@manage_time,@reason,@manage_content,@is_violation,@is_corpdeal)
if @@error<>0 goto ErrorHead
COMMIT TRANSACTION
set @returninfo=@newid;
end
return
ErrorHead:
set @returninfo='2';
ROLLBACK TRANSACTION
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO