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; }