/// <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;
//}
}
