public string createroom(roomer rm)
{
db.updataroom(rm);
db.CreateXwspFile(rm.roomid.ToString());
db.UPdateXwspFile(rm.roomid.ToString(), id);
return(rm.roomid.ToString());
}//创建游戏房间
public static List <roomer> Roomchakan()//获取房间列表
{
string sql = "SELECT roomid, delay, type, number, houseowner FROM roomer";
q.OpenConnect();
SqlCommand com = new SqlCommand();
com.Connection = q.Connect;
com.CommandText = sql;
SqlDataReader jj = com.ExecuteReader();
List <roomer> vb = new List <roomer>();
while (jj.Read())
{
roomer n = new roomer();
n.roomid = int.Parse(jj["roomid"].ToString());
n.delay = jj["delay"].ToString();
n.type = jj["type"].ToString();
n.number = int.Parse(jj["number"].ToString());
n.houseowner = jj["houseowner"].ToString();
vb.Add(n);
}
jj.Close();
q.CloseConnect();
return(vb);
}
public static bool updataroom(roomer s)//房间的添加
{
string aql = "insert into roomer values(" + s.roomid + ",'" + s.delay + "','" + s.type + "'," + s.number + ",'" + s.houseowner + "')";
q.OpenConnect();
SqlCommand bn = new SqlCommand();
bn.CommandText = aql;
bn.Connection = q.Connect;
int vb = bn.ExecuteNonQuery();
q.CloseConnect();
if (vb > 0)
{
return(true);
}
else
{
return(false);
}
}
public static roomer TheRoomInformation(string roomid)
{
string da = " SELECT roomid,number,houseowner from [roomer] where roomid=@roomid";
q.OpenConnect();
SqlCommand com = new SqlCommand();
SqlParameter sp = new SqlParameter("@roomid", roomid);
com.Connection = q.Connect;
com.CommandText = da;
com.Parameters.Add(sp);
SqlDataReader jj = com.ExecuteReader();
roomer ro = new roomer();
while (jj.Read())
{
ro.roomid = int.Parse(jj["roomid"].ToString());
ro.number = int.Parse(jj["number"].ToString());
ro.houseowner = jj["houseowner"].ToString();
}
jj.Close();
q.CloseConnect();
return(ro);
}
