public SeatManageForm(string sid) { InitializeComponent(); this.sid = sid; SIDLabel.Text = sid; dbsql db = new dbsql(); string query; ListViewTool ListViewTool = new ListViewTool(); query = "select * from User_Seat WHERE S_ID=" + sid; DataTable userTable = db.ExecuteQuery(query); ListViewTool.ShowDataInListView(userTable, ReservationList); query = "select S_State from Seat WHERE S_ID=" + sid; DataTable temp = db.ExecuteQuery(query); if (temp.Rows[0][0].ToString() == "4") { MaintainLabel.Text = "正在维护"; maintain = true; } else { MaintainLabel.Text = "正常使用"; maintain = false; } }
private void PrintReservationList() { dbsql db = new dbsql(); string query; ListViewTool ListViewTool = new ListViewTool(); query = "select * from User_Seat"; DataTable userTable = db.ExecuteQuery(query); ListViewTool.ShowDataInListView(userTable, ReservationList); }