public List<CRoom> get_rooms(string state_str)
{
List<CRoom> rooms = new List<CRoom>();
SqlConnection sqlCn = null;
string cmd_str = "";
try
{
sqlCn = new SqlConnection(_con_str);
sqlCn.Open();
cmd_str = "Select * from [Room]";
if (state_str != null && state_str != "")
cmd_str += "where (" + state_str + ")";
SqlCommand cmdSelect = new SqlCommand(cmd_str, sqlCn);
using (SqlDataReader dr = cmdSelect.ExecuteReader())
{
while (dr.Read())
{
var room = new CRoom();
room.id = (int)dr["id"];
room.name = dr["name"].ToString();
room.population = (int)dr["population"];
room.openTime = dr["openTime"].ToString();
room.seat = dr["seat"].ToString();
room.systemId = dr["systemId"].ToString();
room.orderTime = dr["orderTime"].ToString();
room.menu = dr["menu"].ToString();
room.orderTechId = dr["orderTechId"].ToString();
room.techId = dr["techId"].ToString();
room.startTime = dr["startTime"].ToString();
room.serverTime = dr["serverTime"].ToString();
room.status = dr["status"].ToString();
room.note = dr["note"].ToString();
room.hintPlayed = dr["hintPlayed"].ToString();
room.reserveId = dr["reserveId"].ToString();
room.reserveTime = dr["reserveTime"].ToString();
room.selectId = dr["selectId"].ToString();
room.seatIds = dr["seatIds"].ToString();
rooms.Add(room);
}
}
}
catch (System.Exception e)
{
IOUtil.insert_file(DateTime.Now.ToString() + "=" + cmd_str);
BathClass.printErrorMsg(e.Message);
}
finally
{
close_connection(sqlCn);
}
return rooms;
}
/// <summary>
/// 获取房间号
/// </summary>
/// <param name="cmd_str"></param>
/// <returns></returns>
public CRoom get_Room(string cmd_str)
{
CRoom room = null;
SqlConnection sqlCn = null;
try
{
sqlCn = new SqlConnection(_con_str);
sqlCn.Open();
SqlCommand cmdSelect = new SqlCommand(cmd_str, sqlCn);
using (SqlDataReader dr = cmdSelect.ExecuteReader())
{
while (dr.Read())
{
room = new CRoom();
room.id = (int)dr["id"];
room.name = dr["name"].ToString();
room.seatIds = ToString(dr["seatIds"]);
break;
}
}
}
catch (System.Exception e)
{
//IOUtil.insert_file(e.Message);
//IOUtil.insert_file("method=execute_command,time=" + DateTime.Now.ToString() + ",cmd_str=" + cmd_str);
//BathClass.printErrorMsg(cmd_str);
IOUtil.insert_file(e.Message);
IOUtil.insert_file("time=" + DateTime.Now.ToString() + ",cmd_str=" + cmd_str);
IOUtil.insert_file("\n");
BathClass.printErrorMsg(e.Message);
}
finally
{
close_connection(sqlCn);
}
return room;
}