Ejemplo n.º 1
0
 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;
 }
Ejemplo n.º 2
0
 private void SetPlanControl(RoomControl control)
 {
     
 }