create
PROCEDURE
[
dbo
]
.
[
P_Form_Control_Info_Add
]
@TypeName varchar ( 20 ),
@Description varchar ( 50 ),
@CtlColSpan int ,
@Sort int ,
@SourceID int ,
@FieldID int ,
@TableID int
AS
if @SourceID = 0
begin
INSERT INTO T_Form_Control_Info (
[ TypeName ] ,
[ Description ] ,
[ CtlColSpan ] ,
[ Sort ] ,
[ FieldID ] ,
[ TableID ]
) VALUES (
@TypeName ,
@Description ,
@CtlColSpan ,
@Sort ,
@FieldID ,
@TableID
)
end
else
begin
INSERT INTO T_Form_Control_Info (
[ TypeName ] ,
[ Description ] ,
[ CtlColSpan ] ,
[ Sort ] ,
[ SourceID ] ,
[ FieldID ] ,
[ TableID ]
) VALUES (
@TypeName ,
@Description ,
@CtlColSpan ,
@Sort ,
@SourceID ,
@FieldID ,
@TableID
)
end
return SCOPE_IDENTITY ()
@TypeName varchar ( 20 ),
@Description varchar ( 50 ),
@CtlColSpan int ,
@Sort int ,
@SourceID int ,
@FieldID int ,
@TableID int
AS
if @SourceID = 0
begin
INSERT INTO T_Form_Control_Info (
[ TypeName ] ,
[ Description ] ,
[ CtlColSpan ] ,
[ Sort ] ,
[ FieldID ] ,
[ TableID ]
) VALUES (
@TypeName ,
@Description ,
@CtlColSpan ,
@Sort ,
@FieldID ,
@TableID
)
end
else
begin
INSERT INTO T_Form_Control_Info (
[ TypeName ] ,
[ Description ] ,
[ CtlColSpan ] ,
[ Sort ] ,
[ SourceID ] ,
[ FieldID ] ,
[ TableID ]
) VALUES (
@TypeName ,
@Description ,
@CtlColSpan ,
@Sort ,
@SourceID ,
@FieldID ,
@TableID
)
end
return SCOPE_IDENTITY ()