存储过程OUTPUT参数取法(原)

   示例:
插入一条记录,返回其记录号

 .net代码
1
    /// <summary>
        /// 插入新用户
        /// </summary>
        /// <param name="bean"></param>
        /// <returns>用户id</returns>
        public int Insert(MembersBean bean)
        {
            int flag = 1;
            SqlCommand cmd;

            cmd = new SqlCommand("InsertMember", Connection);
            cmd.CommandType = CommandType.StoredProcedure;
            //初始值变化
            cmd.Parameters.Add("@MemberId", bean.MemberId);
            cmd.Parameters.Add("@MemberName", bean.MemberName);
            //MD5加密
            //bean.MemberPassword = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(bean.MemberPassword, "MD5");
            cmd.Parameters.Add("@MemberPassword", bean.MemberPassword);
            cmd.Parameters.Add("@RealName", bean.RealName);
            cmd.Parameters.Add("@IdCard", bean.IdCard);
            cmd.Parameters.Add("@Phone", bean.Phone);
            cmd.Parameters.Add("@Address", bean.Address);
            cmd.Parameters.Add("@RegisterDateTime", bean.RegisterDateTime);
            cmd.Parameters.Add("@LastLoginDateTime", bean.LastLoginDateTime);
            cmd.Parameters.Add("@Percentage", bean.Percentage);
            cmd.Parameters.Add("@RoleId", bean.RoleId);
            cmd.Parameters.Add("@Locked", bean.Locked);
            cmd.Parameters.Add("@Vip", bean.Vip);
            cmd.Parameters.Add("@Question", bean.Question);
            cmd.Parameters.Add("@Answer", bean.Answer);
            cmd.Parameters.Add("@Money", bean.Money);
            cmd.Parameters.Add("@DisplayPreName", bean.DisplayPreName);
            cmd.Parameters.Add("@IdLink", bean.IdLink);
            cmd.Parameters.Add("@Fax", bean.Fax);
            cmd.Parameters.Add("@Website", bean.Website);
            cmd.Parameters.Add("@ContactPerson", bean.ContactPerson);
            cmd.Parameters.Add("@Remarks", bean.Remarks);
            cmd.Parameters.Add("@Email", bean.Email);
            cmd.Parameters.Add("@MasterMemberId", bean.MasterMemberId);

            cmd.Parameters["@MemberId"].Direction = ParameterDirection.Output;

            Connection.Open();
            cmd.ExecuteNonQuery();
            flag = Convert.ToInt32(cmd.Parameters["@MemberId"].Value.ToString());

            Connection.Close();

            return flag;

        }


2.存储过程代码
--region [dbo].[InsertMember]

------------------------------------------------------------------------------------------------------------------------
-- Generated By:  
-- Date Generated: 2007年2月5日
------------------------------------------------------------------------------------------------------------------------

CREATE PROCEDURE [dbo].[InsertMember]
 @MemberName nvarchar(50),
 @MemberPassword nvarchar(50),
 @RealName nvarchar(50),
 @IdCard nvarchar(20),
 @Phone nvarchar(30),
 @Address nvarchar(100),
 @Email nvarchar(50),
 @RegisterDateTime datetime,
 @LastLoginDateTime datetime,
 @Percentage float,
 @RoleId int,
 @Locked bit,
 @Vip bit,
 @Question nvarchar(100),
 @Answer nvarchar(100),
 @Money money,
 @DisplayPreName nvarchar(100),
 @IdLink nvarchar(500),
 @Fax nvarchar(50),
 @Website nvarchar(200),
 @ContactPerson nvarchar(50),
 @Remarks nvarchar(200),
 @MasterMemberId bigint,
 @MemberId bigint OUTPUT
AS

SET NOCOUNT ON

INSERT INTO [dbo].[Members] (
 [MemberName],
 [MemberPassword],
 [RealName],
 [IdCard],
 [Phone],
 [Address],
 [Email],
 [RegisterDateTime],
 [LastLoginDateTime],
 [Percentage],
 [RoleId],
 [Locked],
 [Vip],
 [Question],
 [Answer],
 [Money],
 [DisplayPreName],
 [IdLink],
 [Fax],
 [Website],
 [ContactPerson],
 [Remarks],
 [MasterMemberId]
) VALUES (
 @MemberName,
 @MemberPassword,
 @RealName,
 @IdCard,
 @Phone,
 @Address,
 @Email,
 @RegisterDateTime,
 @LastLoginDateTime,
 @Percentage,
 @RoleId,
 @Locked,
 @Vip,
 @Question,
 @Answer,
 @Money,
 @DisplayPreName,
 @IdLink,
 @Fax,
 @Website,
 @ContactPerson,
 @Remarks,
 @MasterMemberId
)

SET @MemberId = SCOPE_IDENTITY()

--endregion
GO