//管理员信息集合，根据条件查询管理员信息
public List <Model.Administrator> GetAdministrator(string whereStr = null, int start = 1, int end = 10)
{
List <Model.Administrator> admin = new List <Model.Administrator>();
if (DBHelper.OpenConnection())
{
SqlDataReader dr = DBHelper.ExecReader("select * from [Administrator] where [State]=0 " + whereStr);
if (dr != null)
{
Model.Administrator ad = null;
while (dr.Read())
{
ad = new Administrator();
ad.Account = dr["Account"].ToString();
ad.AdminID = dr["AdminID"].ToString();
ad.AdminName = dr["AdminName"].ToString();
ad.APassword = dr["APassword"].ToString();
ad.Explains = dr["Explains"].ToString();
ad.State = (int)dr["State"];
admin.Add(ad);
}
dr.Close();
}
DBHelper.CloseConnection();
}
return(admin);
}
//查询宿舍日常管理信息
public List <Model.Management> GetManagementDAL(string where = null, int start = 1, int end = 10)
{
List <Model.Management> ma = new List <Model.Management>();
if (DBHelper.OpenConnection())
{
SqlDataReader dr = DBHelper.ExecReader(where);
if (dr != null)
{
while (dr.Read())
{
ma.Add(new Model.Management(dr["ManagementID"].ToString(), (int)dr["dormitoryID"], dr["Hygiene"] as string, dr["Inspectors"] as string, (DateTime)dr["ManagementTime"], dr["Explain"] as string, (int)dr["State"]));
}
}
DBHelper.CloseConnection();
}
return(ma);
}
//根据给定条件查询学员信息
public List <Model.Student> GetStudentDAL(string whereStr = null, int start = 1, int end = 10)
{
List <Model.Student> stu = new List <Model.Student>();
if (DBHelper.OpenConnection())
{
SqlDataReader dr = DBHelper.ExecReader(whereStr);
if (dr != null)
{
while (dr.Read())
{
stu.Add(new Model.Student(dr["StudentID"].ToString(), dr["StudentName"] as string, (int)dr["Age"], dr["Gender"] as string, (int)dr["dormitoryID"], dr["Place"] as string, (DateTime)dr["Accommodationtime"], (DateTime)dr["leavetime"], dr["Phone"] as string, dr["Explains"] as string, (int)dr["State"]));
}
}
DBHelper.CloseConnection();
}
return(stu);
}
//根据给定条件查询维修信息
public List <Model.Repair> GetRepairDAL(string whereStr = null, int start = 1, int end = 10)
{
List <Model.Repair> re = new List <Model.Repair>();
if (DBHelper.OpenConnection())
{
SqlDataReader dr = DBHelper.ExecReader(whereStr);
if (dr != null)
{
while (dr.Read())
{
re.Add(new Model.Repair(dr["RepairID"].ToString(), dr["RepairPerso"] as string, dr["RepairName"] as string, (int)dr["dormitoryID"], (DateTime)dr["RepairTime"], (DateTime)dr["HandleTime"], (int)dr["Count"], dr["HandlePerso"] as string, dr["Explain"] as string, (int)dr["State"]));
}
}
DBHelper.CloseConnection();
}
return(re);
}
//查询来访信息
public List <Model.Visiting> GetVisitingDAL(string where = null, int start = 1, int end = 10)
{
List <Model.Visiting> vis = new List <Model.Visiting>();
if (DBHelper.OpenConnection())
{
SqlDataReader dr = DBHelper.ExecReader(where);
if (dr != null)
{
while (dr.Read())
{
vis.Add(new Model.Visiting(dr["VisitingID"].ToString(), (int)dr["dormitoryID"], dr["VisitingName"] as string, (DateTime)dr["VisitingTime"], (DateTime)dr["LikaiTime"], (int)dr["State"]));
}
}
DBHelper.CloseConnection();
}
return(vis);
}
//查询宿舍信息
public List <Model.Dormitory> GetDormitoryDAL(string where = null, int start = 1, int end = 10)
{
List <Model.Dormitory> dor = new List <Model.Dormitory>();
if (DBHelper.OpenConnection())
{
SqlDataReader dr = DBHelper.ExecReader("select * from [Dormitory] where [State]=0 " + where + " ORDER BY dormitoryID");
if (dr != null)
{
while (dr.Read())
{
dor.Add(new Model.Dormitory((int)dr["DormitoryID"], dr["dormitoryGrade"] as string, (int)dr["dormitoryPerso"], (int)dr["dormitoryPrice"], dr["beds"] as string, dr["DormitoryBoos"] as string, dr["Explain"] as string, (int)dr["State"], dr["ISBN"] as string));
}
}
dr.Close();
DBHelper.CloseConnection();
}
return(dor);
}
