public List<Plan> getClassPlan(string[] time)
{
List<Plan> list = new List<Plan>();
DataRowCollection dr = sqLcon.Query(@"SELECT * FROM `classroom` ,`plan` ,`smartcp` WHERE classroom.ClassroomId = smartcp.ClassroomId AND plan.PlanId = smartcp.PlanId AND `date` BETWEEN '" + time[0] + "' AND '" + time[1] + "' ", "plan");
foreach (DataRow dataRow in dr)
{
Plan plan = new Plan();
Classroom room = new Classroom();
room.Id = dataRow["ClassroomId"].ToString();
room.Name = dataRow["ClassroomName"].ToString();
room.Ip = dataRow["Ip"].ToString();
room.Port = ushort.Parse(dataRow["Port"].ToString());
plan.Room = room;
plan.Time = DateTime.Parse(dataRow["date"].ToString());
plan.One = int.Parse(dataRow["Plan12"].ToString());
plan.Two = int.Parse(dataRow["Plan34"].ToString());
plan.Three = int.Parse(dataRow["Plan56"].ToString());
plan.Four = int.Parse(dataRow["Plan78"].ToString());
plan.Five = int.Parse(dataRow["Plan912"].ToString());
list.Add(plan);
}
return list;
}
public List<Classroom> GetAllClassroomsIsNull()
{
List<Classroom> list = new List<Classroom>();
DataRowCollection dr = sqLcon.Query(@"SELECT * FROM `classroom` WHERE `Ip` IS NOT NULL AND `Port` IS NOT NULL ", "ClassRooM");
foreach (DataRow dataRow in dr)
{
Classroom classroom = new Classroom();
classroom.Id = dataRow["ClassroomId"].ToString();
classroom.Name = dataRow["ClassroomName"].ToString();
classroom.Ip = dataRow["Ip"].ToString();
classroom.Port = ushort.Parse(dataRow["Port"].ToString());
list.Add(classroom);
}
return list;
}
