public NciTRoomInfo SetNciRoomInfo(SqlDataReader dr)
{
NciTRoomInfo room = new NciTRoomInfo();
room.Id = int.Parse(dr["Id"].ToString());
room.Times = dr["Times"].ToString();
room.Room1 = dr["Room1"].ToString();
room.Room2 = dr["Room2"].ToString();
room.Room3 = dr["Room3"].ToString();
room.Room4 = dr["Room4"].ToString();
room.Room5 = dr["Room5"].ToString();
room.Room6 = dr["Room6"].ToString();
room.Room7 = dr["Room7"].ToString();
return(room);
}
public List <NciTRoomInfo> GetNciRoomList(string srq, string erq)
{
List <NciTRoomInfo> roomlist = new List <NciTRoomInfo>();
NciTRoomInfo room = null;
try
{
string sql = string.Format("exec getRoom '{0}','{1}'", srq, erq);
SqlDataReader dr = opt.ExecReader(sql);
while (dr.Read())
{
room = opt.SetNciRoomInfo(dr);
roomlist.Add(room);
}
}
catch (Exception)
{
throw;
}
return(roomlist);
}
