public RoomControl GetRoomControlByIdAndDate(string classroomId, string date)
{
DataRowCollection dr = sqLcon.Query(@"SELECT * FROM roomplan WHERE ClassRoomId = '"+ classroomId +"' AND date = '"+ date +"'", "plan");
RoomControl roomControl = new RoomControl();
foreach (DataRow dataRow in dr)
{
roomControl.ClassroomId = dataRow["ClassroomId"].ToString();
roomControl.Date = DateTime.Parse(dataRow["date"].ToString());
roomControl.Plan12 = dataRow["Plan12"].ToString();
roomControl.Plan34 = dataRow["Plan34"].ToString();
roomControl.Plan56 = dataRow["Plan56"].ToString();
roomControl.Plan78 = dataRow["Plan78"].ToString();
roomControl.Plan912 = dataRow["Plan912"].ToString();
}
return roomControl;
}
private void SetPlanControl(RoomControl control)
{
}