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