C#存储过程Output返回参数方法调用类

OGeek|极客世界-中国程序员成长平台 › 门户 › 编程› Node.js›Node.js教程

原作者: [db:作者] 来自: [db:来源] 收藏邀请

存储过程：

create proc proc_GetUserID
@UserName nvarchar(50),@ID int output
as
begin
set @ID = (select ID from UserAccount where UserName = @UserName)
end

C#代码：

        private void GetUserID(string userName)
        {
            SqlParameter[] paras = new SqlParameter[2];
            paras[0] = new SqlParameter("@UserName", userName);
            paras[1] = new SqlParameter("@ID",SqlDbType.Int);
            paras[1].Direction = ParameterDirection.Output;
            object o = DataAccess.ExcuteNonQuery_Proc_Output("proc_GetUserID", paras, "@ID");
            if (o == null || o.ToString() == "")
            {
                this.Label1.Text = "没有这个用户名";
            }
            else
            {
                this.Label1.Text = o.ToString();
            }
        }

public class DataAccess
{
        public static object ExcuteNonQuery_Proc_Output(string procName, SqlParameter[] parameters,string outName)
        {
            SqlConnection conn = GetConnection();
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = procName;
            for (int i = 0; i < parameters.Length; i++)
            {
                cmd.Parameters.Add(parameters[i]);
            }
            conn.Open();
            int n = cmd.ExecuteNonQuery();
            object o = cmd.Parameters[outName].Value;
            conn.Close();
            return o;
        }
}