学步园

1         /// <summary>
2         /// 校验用户
3         /// </summary>
4         /// <param name="user">用户信息</param>
5         /// <returns></returns>
6         public static int VerifyUser(clsUser user)
7          {
8             int iRet;
9             string sql = String.Format("EXECUTE VerifyUser @myVerifyReader OUTPUT,'{0}','{1}'",user.username,user.password); //执行的T-SQL串
10              SqlCommand scmd = new SqlCommand(sql, conn);
11              scmd.Parameters.Add(new SqlParameter("@myVerifyReader",SqlDbType.Int));
12              scmd.Parameters["@myVerifyReader"].Direction = ParameterDirection.Output;
13             //
14
15              DBOpen(conn);
16             //在返回值上有问题
17              scmd.ExecuteNonQuery();
18              iRet = (int)scmd.Parameters["@myVerifyReader"].Value;
19              DBClose(conn);
20             return iRet;
21          }