大神们,帮帮忙啊,必须声明标量变量 "@username"
源代码using System;
using System.Collections.Generic;
using System.Text;
using Model;
using System.Data;
using System.Data.SqlClient;
namespace DAL
{
public class UserService
{
//声明SQL语句变量,方便使用
private const string sql = "select * from tb_Admin where username=@username and password=@password";
//实例化模型
private User FillModel(SqlDataReader reader)
{
User admin = new User();
admin.Id = Convert.ToInt32(reader["Id"]);
admin.UserName1 = reader.GetString(1);
admin.PassWord1 = reader.GetString(2);
return admin;
}
//查询方法,查询管理员的账号和密码
public User adminlogin(User login)
{
SqlParameter[] param ={new SqlParameter("@username",login.UserName1),
new SqlParameter("@password",login.PassWord1)};
using (SqlDataReader reader = SQLHelper.ExecuteReader(SQLHelper.strCon, CommandType.Text, sql))
{
User result = null;
try
{
if (reader != null)
{
if (reader.Read())
{
result = FillModel(reader);
}
}
}
catch (Exception)
{
}
finally
{
reader.Close();
}
return result;
}
}
}
}