/// <summary> /// 登录 /// </summary> /// <param name="userName"></param> /// <param name="userPwd"></param> /// <returns></returns> public int Login(UserInfo userInfo) { //创建单个参数 SqlParameter para = new SqlParameter("@CountRow", SqlDbType.Int); //表名这个参数是输出参数 para.Direction = ParameterDirection.Output; //创建存储过程参数 SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@UserName", userInfo.UserName), new SqlParameter("@UserPwd", userInfo.UserPassword), para }; object obj = SqlDbHelper.ExecuteScalarByProc("sp_Login", parameters); int count = Convert.ToInt32(para.Value); if (count > 0) { return(count); } else { return(0); } //if (Convert.ToInt32(SqlDbHelper.ExecuteScalarByProc("sp_Login", parameters)) != 0) //{ // return 0; //} //else //{ // return 1; //} }