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) { }