/// <summary>
/// 获取管理员
/// </summary>
/// <returns></returns>
public Admin SelectAdmin(string userName,string password)
{
Admin admin = new Admin();
string sql = "select * from Admin where Admin_Name=@Admin_Name and Admin_PassWord=@Admin_Password";
SqlParameter[] parms = new SqlParameter[2];
parms[0] = new SqlParameter("@Admin_Name", SqlDbType.VarChar, 50);
parms[0].Value = userName;
parms[1] = new SqlParameter("@Admin_Password", SqlDbType.VarChar, 150);
parms[1].Value = password;
DataTable dt = DataMake.DataTableRead(sql,parms);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
admin.Id = int.Parse(dt.Rows[i][0].ToString());
admin.AdminName = dt.Rows[i][1].ToString();
admin.AdminPassword = dt.Rows[i][2].ToString();
admin.AdminRemark = dt.Rows[i][3].ToString();
}
}
return admin;
}
/// <summary>
/// 获取所有管理员
/// </summary>
/// <returns></returns>
public List<Admin> SelectAdmins()
{
List<Admin> list = new List<Admin>();
Admin admin = new Admin();
string sql = "select * from Admin";
DataTable dt = DataMake.DataTableRead(sql);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
admin.Id = int.Parse(dt.Rows[i][0].ToString());
admin.AdminName = dt.Rows[i][1].ToString();
admin.AdminPassword = dt.Rows[i][2].ToString();
admin.AdminRemark = dt.Rows[i][3].ToString();
list.Add(admin);
}
}
return list;
}
