在DAL中的DBhelper添加方法
public class DB
{
private static string connstr = ConfigurationManager.ConnectionStrings["DB"].ConnectionString;
/// <summary>
/// 查询
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
public static DataTable select(string sql,params SqlParameter[] sqlParameters)
{
using (SqlDataAdapter adapter = new SqlDataAdapter(sql, connstr))
{
if (sqlParameters != null && sqlParameters.Count() > 0)
adapter.SelectCommand.Parameters.AddRange(sqlParameters);
using(DataTable table=new DataTable())
{
adapter.Fill(table);
return table;
}
}
}
public static SqlDataReader QueryReader (string sql,params SqlParameter[] sqlParameters)
{
SqlConnection conn = new SqlConnection(connstr);
using (SqlCommand comm = new SqlCommand(sql, conn))
{
if (sqlParameters != null && sqlParameters.Count() > 0)
comm.Parameters.AddRange(sqlParameters);
conn.Open();
return comm.ExecuteReader(CommandBehavior.CloseConnection);
}
}
然后再在User InfoDAL中修改复职,方法更简洁
public static UserInfo Select(string name, string pwd)
{
var sql = $"select * from UserInfo where name='{name}' and pwd='{pwd}'";
SqlParameter[] sqlParameter =
{
new SqlParameter("@name",name),
new SqlParameter("@pwd",pwd)
};
var reader = DB.QueryReader(sql, sqlParameter);
UserInfo user = null;
if (reader.Read())
{
user = new UserInfo()
{
Id = Convert.ToInt32(reader["Id"]),
Name = Convert.ToString(reader["Name"]),
Role = Convert.ToInt32(reader["Role"])
};
}
reader.Close();
return user;
}