辦公oa系統(tǒng)源碼相關數(shù)據(jù)庫存儲過程

/******************************************************************

表名：dt_addtosourcecontrol

時間：2011-3-2216:25:52

******************************************************************/

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_addtosourcecontrol_Exists]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_addtosourcecontrol_Exists]GO

--用途：是否已經(jīng)存在

--時間：2011-3-2216:25:52

CREATEPROCEDUREdt_addtosourcecontrol_Exists

AS

DECLARE@TempIDint

SELECT@TempID=count(1)FROMdt_addtosourcecontrolWHEREIF@TempID=0

RETURN0ELSE

RETURN1

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_addtosourcecontrol_ADD]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_addtosourcecontrol_ADD]GO

--用途：增加一條記錄

--時間：2011-3-2216:25:52

CREATEPROCEDUREdt_addtosourcecontrol_ADD

AS

INSERTINTOdt_addtosourcecontrol(

)VALUES(

)

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_addtosourcecontrol_Update]')andOBJECTPROPERTY(id

AS

UPDATEdt_addtosourcecontrolSETWHERE

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_addtosourcecontrol_Delete]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_addtosourcecontrol_Delete]GO

--用途：刪除一條記錄

--時間：2011-3-2216:25:52

CREATEPROCEDUREdt_addtosourcecontrol_Delete

AS

DELETEdt_addtosourcecontrolWHERE

GO

if exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[dt_addtosourcecontrol_GetModel]')andOBJECTPROPERTY(id,N'IsProcedure')

=1)

dropprocedure[dbo].[dt_addtosourcecontrol_GetModel]GO

--用途：得到實體對象的詳細信息

--時間：2011-3-2216:25:52

CREATEPROCEDUREdt_addtosourcecontrol_GetModel

AS

SELECT

FROMdt_addtosourcecontrolWHERE

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_addtosourcecontrol_GetList]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_addtosourcecontrol_GetList]GO

--用途：查詢記錄信息

--時間：2011-3-2216:25:52

CREATEPROCEDUREdt_addtosourcecontrol_GetListAS

SELECT

FROMdt_addtosourcecontrol

GO

/******************************************************************

表名：dt_addtosourcecontrol_u

時間：2011-3-2216:25:52

******************************************************************/

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_addtosourcecontrol_u_Exists]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_addtosourcecontrol_u_Exists]GO

--用途：是否已經(jīng)存在

--時間：2011-3-2216:25:52

CREATEPROCEDUREdt_addtosourcecontrol_u_Exists

AS

DECLARE@TempIDint

SELECT@TempID=count(1)FROMdt_addtosourcecontrol_uWHEREIF@TempID=0

RETURN0ELSE

RETURN1

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_addtosourcecontrol_u_ADD]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_addtosourcecontrol_u_ADD]GO

--用途：增加一條記錄

--時間：2011-3-2216:25:52

CREATEPROCEDUREdt_addtosourcecontrol_u_ADD

AS

INSERTINTOdt_addtosourcecontrol_u(

)VALUES(

)

GO

if exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[dt_addtosourcecontrol_u_Update]')andOBJECTPROPERTY(id

AS

UPDATEdt_addtosourcecontrol_uSETWHERE

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_addtosourcecontrol_u_Delete]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_addtosourcecontrol_u_Delete]GO

--用途：刪除一條記錄

--時間：2011-3-2216:25:52

CREATEPROCEDUREdt_addtosourcecontrol_u_Delete

AS

DELETEdt_addtosourcecontrol_uWHERE

GO

if exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[dt_addtosourcecontrol_u_GetModel]') and OBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_addtosourcecontrol_u_GetModel]GO

--用途：得到實體對象的詳細信息

--時間：2011-3-2216:25:52

CREATEPROCEDUREdt_addtosourcecontrol_u_GetModelAS

SELECT

FROMdt_addtosourcecontrol_uWHERE

GO

if exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[dt_addtosourcecontrol_u_GetList]')andOBJECTPROPERTY(id,N'IsProcedure')

=1)

dropprocedure[dbo].[dt_addtosourcecontrol_u_GetList]GO

--用途：查詢記錄信息

--時間：2011-3-2216:25:52

CREATEPROCEDUREdt_addtosourcecontrol_u_GetListAS

SELECT

FROMdt_addtosourcecontrol_u

GO

/******************************************************************

表名：dt_adduserobject

時間：2011-3-2216:25:52

******************************************************************/

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_adduserobject_Exists]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_adduserobject_Exists]GO

--用途：是否已經(jīng)存在

--時間：2011-3-2216:25:52

CREATEPROCEDUREdt_adduserobject_Exists

AS

DECLARE@TempIDint

SELECT@TempID=count(1)FROMdt_adduserobjectWHEREIF@TempID=0

RETURN0ELSE

RETURN1

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_adduserobject_ADD]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_adduserobject_ADD]GO

--用途：增加一條記錄

--時間：2011-3-2216:25:52

CREATEPROCEDUREdt_adduserobject_ADD

AS

INSERTINTOdt_adduserobject(

)VALUES(

)

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_adduserobject_Update]')andOBJECTPROPERTY(id

AS

UPDATEdt_adduserobjectSETWHERE

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_adduserobject_Delete]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_adduserobject_Delete]GO

--用途：刪除一條記錄

--時間：2011-3-2216:25:52

CREATEPROCEDUREdt_adduserobject_Delete

AS

DELETEdt_adduserobjectWHERE

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_adduserobject_GetModel]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_adduserobject_GetModel]GO

--用途：得到實體對象的詳細信息

--時間：2011-3-2216:25:52

CREATEPROCEDUREdt_adduserobject_GetModel

AS

SELECT

FROMdt_adduserobjectWHERE

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_adduserobject_GetList]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_adduserobject_GetList]GO

--用途：查詢記錄信息

--時間：2011-3-2216:25:52

CREATEPROCEDUREdt_adduserobject_GetListAS

SELECT

FROMdt_adduserobject

GO

/******************************************************************

表名：dt_adduserobject_vcs

時間：2011-3-2216:25:53

******************************************************************/

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_adduserobject_vcs_Exists]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_adduserobject_vcs_Exists]GO

--用途：是否已經(jīng)存在

--時間：2011-3-2216:25:53

CREATEPROCEDUREdt_adduserobject_vcs_Exists

AS

DECLARE@TempIDint

SELECT@TempID=count(1)FROMdt_adduserobject_vcsWHEREIF@TempID=0

RETURN0ELSE

RETURN1

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_adduserobject_vcs_ADD]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_adduserobject_vcs_ADD]GO

--用途：增加一條記錄

--時間：2011-3-2216:25:53

CREATEPROCEDUREdt_adduserobject_vcs_ADD

AS

INSERTINTOdt_adduserobject_vcs(

)VALUES(

)

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_adduserobject_vcs_Update]')andOBJECTPROPERTY(id

AS

UPDATEdt_adduserobject_vcsSETWHERE

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_adduserobject_vcs_Delete]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_adduserobject_vcs_Delete]GO

--用途：刪除一條記錄

--時間：2011-3-2216:25:53

CREATEPROCEDUREdt_adduserobject_vcs_Delete

AS

DELETEdt_adduserobject_vcsWHERE

GO

if exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[dt_adduserobject_vcs_GetModel]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_adduserobject_vcs_GetModel]GO

--用途：得到實體對象的詳細信息

--時間：2011-3-2216:25:53

CREATEPROCEDUREdt_adduserobject_vcs_GetModel

AS

SELECT

FROMdt_adduserobject_vcsWHERE

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_adduserobject_vcs_GetList]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_adduserobject_vcs_GetList]GO

--用途：查詢記錄信息

--時間：2011-3-2216:25:53

CREATEPROCEDUREdt_adduserobject_vcs_GetListAS

SELECT

FROMdt_adduserobject_vcs

GO

/******************************************************************

表名：dt_checkinobject

時間：2011-3-2216:25:53

******************************************************************/

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_checkinobject_Exists]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_checkinobject_Exists]GO

--用途：是否已經(jīng)存在

--時間：2011-3-2216:25:53

CREATEPROCEDUREdt_checkinobject_Exists

AS

DECLARE@TempIDint

SELECT@TempID=count(1)FROMdt_checkinobjectWHEREIF@TempID=0

RETURN0ELSE

RETURN1

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_checkinobject_ADD]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_checkinobject_ADD]GO

--用途：增加一條記錄

--時間：2011-3-2216:25:53

CREATEPROCEDUREdt_checkinobject_ADD

AS

INSERTINTOdt_checkinobject(

)VALUES(

)

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_checkinobject_Update]')andOBJECTPROPERTY(id

AS

UPDATEdt_checkinobjectSETWHERE

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_checkinobject_Delete]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_checkinobject_Delete]GO

--用途：刪除一條記錄

--時間：2011-3-2216:25:53

CREATEPROCEDUREdt_checkinobject_Delete

AS

DELETEdt_checkinobjectWHERE

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_checkinobject_GetModel]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_checkinobject_GetModel]GO

--用途：得到實體對象的詳細信息

--時間：2011-3-2216:25:53

CREATEPROCEDUREdt_checkinobject_GetModel

AS

SELECT

FROMdt_checkinobjectWHERE

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_checkinobject_GetList]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_checkinobject_GetList]GO

--用途：查詢記錄信息

--時間：2011-3-2216:25:53

CREATEPROCEDUREdt_checkinobject_GetListAS

SELECT

FROMdt_checkinobject

GO

/******************************************************************

表名：dt_checkinobject_u

時間：2011-3-2216:25:53

******************************************************************/

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_checkinobject_u_Exists]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_checkinobject_u_Exists]GO

--用途：是否已經(jīng)存在

--時間：2011-3-2216:25:53

CREATEPROCEDUREdt_checkinobject_u_Exists

AS

DECLARE@TempIDint

SELECT@TempID=count(1)FROMdt_checkinobject_uWHEREIF@TempID=0

RETURN0ELSE

RETURN1

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_checkinobject_u_ADD]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_checkinobject_u_ADD]GO

--用途：增加一條記錄

--時間：2011-3-2216:25:53

CREATEPROCEDUREdt_checkinobject_u_ADD

AS

INSERTINTOdt_checkinobject_u(

)VALUES(

)

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_checkinobject_u_Update]')andOBJECTPROPERTY(id

AS

UPDATEdt_checkinobject_uSETWHERE

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_checkinobject_u_Delete]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_checkinobject_u_Delete]GO

--用途：刪除一條記錄

--時間：2011-3-2216:25:53

CREATEPROCEDUREdt_checkinobject_u_Delete

AS

DELETEdt_checkinobject_uWHERE

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_checkinobject_u_GetModel]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_checkinobject_u_GetModel]GO

--用途：得到實體對象的詳細信息

--時間：2011-3-2216:25:53

CREATEPROCEDUREdt_checkinobject_u_GetModel

AS

SELECT

FROMdt_checkinobject_uWHERE

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_checkinobject_u_GetList]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_checkinobject_u_GetList]GO

--用途：查詢記錄信息

--時間：2011-3-2216:25:53

CREATEPROCEDUREdt_checkinobject_u_GetListAS

SELECT

FROMdt_checkinobject_u

GO

/******************************************************************

表名：dt_checkoutobject

時間：2011-3-2216:25:53

******************************************************************/

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_checkoutobject_Exists]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_checkoutobject_Exists]GO

--用途：是否已經(jīng)存在

--時間：2011-3-2216:25:53

CREATEPROCEDUREdt_checkoutobject_Exists

AS

DECLARE@TempIDint

SELECT@TempID=count(1)FROMdt_checkoutobjectWHEREIF@TempID=0

RETURN0ELSE

RETURN1

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_checkoutobject_ADD]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_checkoutobject_ADD]GO

--用途：增加一條記錄

--時間：2011-3-2216:25:53

CREATEPROCEDUREdt_checkoutobject_ADD

AS

INSERTINTOdt_checkoutobject(

)VALUES(

)

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_checkoutobject_Update]')andOBJECTPROPERTY(id

AS

UPDATEdt_checkoutobjectSETWHERE

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_checkoutobject_Delete]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_checkoutobject_Delete]GO

--用途：刪除一條記錄

--時間：2011-3-2216:25:53

CREATEPROCEDUREdt_checkoutobject_Delete

AS

DELETEdt_checkoutobjectWHERE

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_checkoutobject_GetModel]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_checkoutobject_GetModel]

GO

--用途：得到實體對象的詳細信息

--時間：2011-3-2216:25:53

CREATEPROCEDUREdt_checkoutobject_GetModel

AS

SELECT

FROMdt_checkoutobjectWHERE

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_checkoutobject_GetList]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_checkoutobject_GetList]GO

--用途：查詢記錄信息

--時間：2011-3-2216:25:53

CREATEPROCEDUREdt_checkoutobject_GetListAS

SELECT

FROMdt_checkoutobject

GO

/******************************************************************

表名：dt_checkoutobject_u

時間：2011-3-2216:25:54

******************************************************************/

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_checkoutobject_u_Exists]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_checkoutobject_u_Exists]GO

--用途：是否已經(jīng)存在

--時間：2011-3-2216:25:54

CREATEPROCEDUREdt_checkoutobject_u_Exists

AS

DECLARE@TempIDint

SELECT@TempID=count(1)FROMdt_checkoutobject_uWHEREIF@TempID=0

RETURN0ELSE

RETURN1

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_checkoutobject_u_ADD]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_checkoutobject_u_ADD]GO

--用途：增加一條記錄

--時間：2011-3-2216:25:54

CREATEPROCEDUREdt_checkoutobject_u_ADD

AS

INSERTINTOdt_checkoutobject_u(

)VALUES(

)

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_checkoutobject_u_Update]')andOBJECTPROPERTY(id

AS

UPDATEdt_checkoutobject_uSETWHERE

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_checkoutobject_u_Delete]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_checkoutobject_u_Delete]GO

--用途：刪除一條記錄

--時間：2011-3-2216:25:54

CREATEPROCEDUREdt_checkoutobject_u_Delete

AS

DELETEdt_checkoutobject_uWHERE

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_checkoutobject_u_GetModel]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_checkoutobject_u_GetModel]GO

--用途：得到實體對象的詳細信息

--時間：2011-3-2216:25:54

CREATEPROCEDUREdt_checkoutobject_u_GetModel

AS

SELECT

FROMdt_checkoutobject_uWHERE

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_checkoutobject_u_GetList]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_checkoutobject_u_GetList]GO

--用途：查詢記錄信息

--時間：2011-3-2216:25:54

CREATEPROCEDUREdt_checkoutobject_u_GetListAS

SELECT

FROMdt_checkoutobject_u

GO

/******************************************************************

表名：dt_disyoaerror

時間：2011-3-2216:25:54

******************************************************************/

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_disyoaerror_Exists]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_disyoaerror_Exists]GO

--用途：是否已經(jīng)存在

--時間：2011-3-2216:25:54

CREATEPROCEDUREdt_disyoaerror_Exists

AS

DECLARE@TempIDint

SELECT@TempID=count(1)FROMdt_disyoaerrorWHEREIF@TempID=0

RETURN0ELSE

RETURN1

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_disyoaerror_ADD]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_disyoaerror_ADD]GO

--用途：增加一條記錄

--時間：2011-3-2216:25:54

CREATEPROCEDUREdt_disyoaerror_ADD

AS

INSERTINTOdt_disyoaerror(

)VALUES(

)

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_disyoaerror_Update]')andOBJECTPROPERTY(id

AS

UPDATEdt_disyoaerrorSET

WHERE

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_disyoaerror_Delete]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_disyoaerror_Delete]GO

--用途：刪除一條記錄

--時間：2011-3-2216:25:54

CREATEPROCEDUREdt_disyoaerror_Delete

AS

DELETEdt_disyoaerrorWHERE

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_disyoaerror_GetModel]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_disyoaerror_GetModel]GO

--用途：得到實體對象的詳細信息

--時間：2011-3-2216:25:54

CREATEPROCEDUREdt_disyoaerror_GetModel

AS

SELECT

FROMdt_disyoaerrorWHERE

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_disyoaerror_GetList]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_disyoaerror_GetList]GO

--用途：查詢記錄信息

--時間：2011-3-2216:25:54

CREATEPROCEDUREdt_disyoaerror_GetListAS

SELECT

FROMdt_disyoaerror

GO

/******************************************************************

表名：dt_disyoaerror_u

時間：2011-3-2216:25:54

******************************************************************/

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_disyoaerror_u_Exists]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_disyoaerror_u_Exists]GO

--用途：是否已經(jīng)存在

--時間：2011-3-2216:25:54

CREATEPROCEDUREdt_disyoaerror_u_Exists

AS

DECLARE@TempIDint

SELECT@TempID=count(1)FROMdt_disyoaerror_uWHEREIF@TempID=0

RETURN0ELSE

RETURN1

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_disyoaerror_u_ADD]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_disyoaerror_u_ADD]GO

--用途：增加一條記錄

--時間：2011-3-2216:25:54

CREATEPROCEDUREdt_disyoaerror_u_ADD

AS

INSERTINTOdt_disyoaerror_u(

)VALUES(

)

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_disyoaerror_u_Update]')andOBJECTPROPERTY(id

AS

UPDATEdt_disyoaerror_uSETWHERE

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_disyoaerror_u_Delete]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_disyoaerror_u_Delete]GO

--用途：刪除一條記錄

--時間：2011-3-2216:25:54

CREATEPROCEDUREdt_disyoaerror_u_Delete

AS

DELETEdt_disyoaerror_uWHERE

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_disyoaerror_u_GetModel]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_disyoaerror_u_GetModel]GO

--用途：得到實體對象的詳細信息

--時間：2011-3-2216:25:54

CREATEPROCEDUREdt_disyoaerror_u_GetModel

AS

SELECT

FROMdt_disyoaerror_uWHERE

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_disyoaerror_u_GetList]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_disyoaerror_u_GetList]GO

--用途：查詢記錄信息

--時間：2011-3-2216:25:54

CREATEPROCEDUREdt_disyoaerror_u_GetListAS

SELECT

FROMdt_disyoaerror_u

GO

/******************************************************************

表名：dt_droppropertiesbyid

時間：2011-3-2216:25:54

******************************************************************/

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_droppropertiesbyid_Exists]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_droppropertiesbyid_Exists]GO

--用途：是否已經(jīng)存在

--時間：2011-3-2216:25:54

CREATEPROCEDUREdt_droppropertiesbyid_Exists

AS

DECLARE@TempIDint

SELECT@TempID=count(1)FROMdt_droppropertiesbyidWHEREIF@TempID=0

RETURN0ELSE

RETURN1

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_droppropertiesbyid_ADD]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_droppropertiesbyid_ADD]

GO

--用途：增加一條記錄

--時間：2011-3-2216:25:54

CREATEPROCEDUREdt_droppropertiesbyid_ADD

AS

INSERTINTOdt_droppropertiesbyid(

)VALUES(

)

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_droppropertiesbyid_Update]')andOBJECTPROPERTY(id

AS

UPDATEdt_droppropertiesbyidSETWHERE

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_droppropertiesbyid_Delete]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_droppropertiesbyid_Delete]GO

--用途：刪除一條記錄

--時間：2011-3-2216:25:54

CREATEPROCEDUREdt_droppropertiesbyid_Delete

AS

DELETEdt_droppropertiesbyidWHERE

GO

if exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[dt_droppropertiesbyid_GetModel]')andOBJECTPROPERTY(id,N'IsProcedure')

=1)

dropprocedure[dbo].[dt_droppropertiesbyid_GetModel]GO

--用途：得到實體對象的詳細信息

--時間：2011-3-2216:25:54

CREATEPROCEDUREdt_droppropertiesbyid_GetModel

AS

SELECT

FROMdt_droppropertiesbyidWHERE

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_droppropertiesbyid_GetList]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_droppropertiesbyid_GetList]GO

--用途：查詢記錄信息

--時間：2011-3-2216:25:54

CREATEPROCEDUREdt_droppropertiesbyid_GetListAS

SELECT

FROMdt_droppropertiesbyid

GO

/******************************************************************

表名：dt_dropuserobjectbyid

時間：2011-3-2216:25:55

******************************************************************/

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_dropuserobjectbyid_Exists]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_dropuserobjectbyid_Exists]GO

--用途：是否已經(jīng)存在

--時間：2011-3-2216:25:55

CREATEPROCEDUREdt_dropuserobjectbyid_Exists

AS

DECLARE@TempIDint

SELECT@TempID=count(1)FROMdt_dropuserobjectbyidWHEREIF@TempID=0

RETURN0ELSE

RETURN1

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_dropuserobjectbyid_ADD]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_dropuserobjectbyid_ADD]GO

--用途：增加一條記錄

--時間：2011-3-2216:25:55

CREATEPROCEDUREdt_dropuserobjectbyid_ADD

AS

INSERTINTOdt_dropuserobjectbyid(

)VALUES(

)

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_dropuserobjectbyid_Update]')andOBJECTPROPERTY(id

AS

UPDATEdt_dropuserobjectbyidSETWHERE

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_dropuserobjectbyid_Delete]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_dropuserobjectbyid_Delete]GO

--用途：刪除一條記錄

--時間：2011-3-2216:25:55

CREATEPROCEDUREdt_dropuserobjectbyid_Delete

AS

DELETEdt_dropuserobjectbyidWHERE

GO

if exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[dt_dropuserobjectbyid_GetModel]')andOBJECTPROPERTY(id,N'IsProcedure')

=1)

dropprocedure[dbo].[dt_dropuserobjectbyid_GetModel]GO

--用途：得到實體對象的詳細信息

--時間：2011-3-2216:25:55

CREATEPROCEDUREdt_dropuserobjectbyid_GetModel

AS

SELECT

FROMdt_dropuserobjectbyidWHERE

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_dropuserobjectbyid_GetList]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_dropuserobjectbyid_GetList]GO

--用途：查詢記錄信息

--時間：2011-3-2216:25:55

CREATEPROCEDUREdt_dropuserobjectbyid_GetListAS

SELECT

FROMdt_dropuserobjectbyid

GO

/******************************************************************

表名：dt_generateansiname

時間：2011-3-2216:25:55

******************************************************************/

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_generateansiname_Exists]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_generateansiname_Exists]GO

--用途：是否已經(jīng)存在

--時間：2011-3-2216:25:55

CREATEPROCEDUREdt_generateansiname_Exists

AS

DECLARE@TempIDint

SELECT@TempID=count(1)FROMdt_generateansinameWHEREIF@TempID=0

RETURN0ELSE

RETURN1

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_generateansiname_ADD]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_generateansiname_ADD]GO

--用途：增加一條記錄

--時間：2011-3-2216:25:55

CREATEPROCEDUREdt_generateansiname_ADD

AS

INSERTINTOdt_generateansiname(

)VALUES(

)

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_generateansiname_Update]')andOBJECTPROPERTY(id

AS

UPDATEdt_generateansinameSETWHERE

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_generateansiname_Delete]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_generateansiname_Delete]GO

--用途：刪除一條記錄

--時間：2011-3-2216:25:55

CREATEPROCEDUREdt_generateansiname_Delete

AS

DELETEdt_generateansinameWHERE

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_generateansiname_GetModel]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_generateansiname_GetModel]GO

--用途：得到實體對象的詳細信息

--時間：2011-3-2216:25:55

CREATEPROCEDUREdt_generateansiname_GetModel

AS

SELECT

FROMdt_generateansinameWHERE

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_generateansiname_GetList]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_generateansiname_GetList]GO

--用途：查詢記錄信息

--時間：2011-3-2216:25:55

CREATEPROCEDUREdt_generateansiname_GetList

AS

SELECT

FROMdt_generateansiname

GO

/******************************************************************

表名：dt_getobjwithprop

時間：2011-3-2216:25:55

******************************************************************/

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_getobjwithprop_Exists]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

dropprocedure[dbo].[dt_getobjwithprop_Exists]GO

--用途：是否已經(jīng)存在

--時間：2011-3-2216:25:55

CREATEPROCEDUREdt_getobjwithprop_Exists

AS

DECLARE@TempIDint

SELECT@TempID=count(1)FROMdt_getobjwithpropWHEREIF@TempID=0

RETURN0ELSE

RETURN1

GO

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[dt_getobjwithprop_ADD]')andOBJECTPROPERTY(id,N'IsProcedure')=1)

drop