大家对一下代码作下评价（1个快10年开发经验的高手)
--==========================AgSerItem存储过程：INSERT=========================
alter PROCEDURE p_AgSerItem_INSERT
(
@AgreeID int,
@SerID int,
@AirPortID int,
@AirClass int,
@RhumbID int,
@UnitID int,
@MUnitID int,
@CoinID int,
@UserID int,
@SP money,
@MUP money,
@UP money,
@CDate datetime,
@UDate datetime,
@FC float,
@SC float,
@IsValid bit,
@AirNo varchar(25),
@AirType varchar(25)
)
AS
BEGIN
SET XACT_ABORT ON
BEGIN TRANSACTION
DECLARE @PRIMARYKEYID INT
SET @PRIMARYKEYID=0
INSERT AgSerItem([AgreeID],[SerID],[AirPortID],[AirClass],[RhumbID],[UnitID],[MUnitID],[CoinID],[UserID],[SP],[MUP],[UP],[CDate],[UDate],[FC],[SC],[IsValid],[AirNo],[AirType]) VALUES (@AgreeID,@SerID,@AirPortID,@AirClass,@RhumbID,@UnitID,@MUnitID,@CoinID,@UserID,@SP,@MUP,@UP,@CDate,@UDate,@FC,@SC,@IsValid,@AirNo,@AirType) SELECT @PRIMARYKEYID=@@IDENTITY
IF @@ERROR <> 0
BEGIN
Rollback TRANSACTION--回滚
Return 0--操作失败
END
COMMIT TRANSACTION
Return @PRIMARYKEYID
End
go


--==========================AgSerItem存储过程：UPDATE=========================
alter PROCEDURE p_AgSerItem_UPDATE
(
@AgSerID int,
@AgreeID int,
@SerID int,
@AirPortID int,
@AirClass int,
@RhumbID int,
@UnitID int,
@MUnitID int,
@CoinID int,
@UserID int,
@SP money,
@MUP money,
@UP money,
@CDate datetime,
@UDate datetime,
@FC float,
@SC float,
@IsValid bit,
@AirNo varchar(25),
@AirType varchar(25)
)
AS
BEGIN
SET XACT_ABORT ON
BEGIN TRANSACTION
UPDATE AgSerItem SET [AgreeID]=@AgreeID,[SerID]=@SerID,[AirPortID]=@AirPortID,[AirClass]=@AirClass,[RhumbID]=@RhumbID,[UnitID]=@UnitID,[MUnitID]=@MUnitID,[CoinID]=@CoinID,[UserID]=@UserID,[SP]=@SP,[MUP]=@MUP,[UP]=@UP,[CDate]=@CDate,[UDate]=@UDate,[FC]=@FC,[SC]=@SC,[IsValid]=@IsValid,[AirNo]=@AirNo,[AirType]=@AirType WHERE [AgSerID]=@AgSerID
IF @@ERROR <> 0
BEGIN
Rollback TRANSACTION--回滚
Return 0--操作失败
END
COMMIT TRANSACTION
Return 1
End
go


--==========================AgSerItem存储过程：Delete=========================

alter PROCEDURE p_AgSerItem_Delete
(
@AgSerID int
)
AS
BEGIN
SET XACT_ABORT ON
BEGIN TRANSACTION
DECLARE @PRIMARYKEYID INT
SET @PRIMARYKEYID=0
DELETE AgSerItem WHERE [AgSerID]=@AgSerID
IF @@ERROR <> 0
BEGIN
Rollback TRANSACTION--回滚
Return 0--操作失败
END
COMMIT TRANSACTION
Return @PRIMARYKEYID
End
go
[解决办法]

引用:

时间不能说明问题，
正如有些人到老也不明白中午的太阳跟早上的太阳有什么区别一样，
一个人做事如果不专注，不总结，
做再长时间也是混混!

正解，

反正我看得那个代码写的乱七八糟的！
没有一个层次性，
都不知除了你，还有谁可以看得懂，

但高手与 代码难度是两码事 ，
高手写的代码都是层次分明的，了是一目了然，
对待越复杂的问题，越是如此！

这样才可以构建更复杂多变的系统！