存储过程

fireworksloveyou 2007-12-03 08:07:14

/*功能：插入一条记录 */
ALTER Procedure [HH_OptLog_Insert]
(
@lngID bigint output,
@A1 nvarchar(40),
@sUnitCode nvarchar(40),
@UserAcc nvarchar(40),
@UserName nvarchar(40),
@optDate smalldatetime,
@optTime nvarchar(28),
@exitDate datetime,
@optType nvarchar(60),
@optRec nvarchar(40),
@ComputerName nvarchar(40)
)
as

insert into [OptLog]
(
A1,
sUnitCode,
UserAcc,
UserName,
optDate,
optTime,
exitDate,
optType,
optRec,
ComputerName
)
values
(
@A1,
@sUnitCode,
@UserAcc,
@UserName,
@optDate,
@optTime,
@exitDate,
@optType,
@optRec,
@ComputerName
)
SELECT @lngID = SCOPE_IDENTITY();
return @@Error

public int Add(Pisbs.Info.objects.OptLog model)
{
// model.ID = GetMaxId();
int rowsAffected;
SqlParameter[] parameters = {
new SqlParameter("@lngID", SqlDbType.BigInt,8),
new SqlParameter("@A1", SqlDbType.NVarChar),
new SqlParameter("@sUnitCode", SqlDbType.NVarChar),
new SqlParameter("@UserAcc", SqlDbType.NVarChar),
new SqlParameter("@UserName", SqlDbType.NVarChar),
new SqlParameter("@optDate", SqlDbType.SmallDateTime),
new SqlParameter("@optTime", SqlDbType.NVarChar),
new SqlParameter("@exitDate", SqlDbType.DateTime),
new SqlParameter("@optType", SqlDbType.NVarChar),
new SqlParameter("@optRec", SqlDbType.NVarChar),
new SqlParameter("@ComputerName", SqlDbType.NVarChar)};
parameters[0].Value = model.lngID;
parameters[1].Value = model.A1;
parameters[2].Value = model.sUnitCode;
parameters[3].Value = model.UserAcc;
parameters[4].Value = model.UserName;
parameters[5].Value = model.optDate;
parameters[6].Value = model.optTime;
parameters[7].Value = model.exitDate;
parameters[8].Value = model.optType;
parameters[9].Value = model.optRec;
parameters[10].Value = model.ComputerName;

return DbHelperSQL.RunProcedure("HH_OptLog_Insert", parameters, out rowsAffected);

}

public static int RunProcedure(string storedProcName, IDataParameter[] parameters, out int rowsAffected)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
int result;
connection.Open();
SqlCommand command = BuildIntCommand(connection, storedProcName, parameters);
rowsAffected = command.ExecuteNonQuery();
result = (int)command.Parameters["ReturnValue"].Value;
connection.Close();
return result;
}
}
=============================================================================================

SELECT @lngID = SCOPE_IDENTITY();
return @@Error 是什么意思

RunProcedure() 返回的到底是什么
rowsAffected 是个什么东西调用的时候也没给他值 ???????????????

...全文