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