private void AllUserSelectForm_Load(object sender, EventArgs e)
{
dbsql db = new dbsql();
string query = "select * from D_User ";
DataTable userTable = db.ExecuteQuery(query);
ListViewTool.ShowDataInListView(userTable, UserListView);
}
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);
}
public UserInformationForm(string UserID)
{
InitializeComponent();
this.UserID = UserID;
IDlabel.Text = UserID;
dbsql db = new dbsql();
string query = "select U_Name from D_User WHERE U_ID=" + UserID;
DataTable userTable = db.ExecuteQuery(query);
NameLabel.Text = userTable.Rows[0][0].ToString();
query = "select Credit from D_User WHERE U_ID=" + UserID;
userTable = db.ExecuteQuery(query);
CreditLabel.Text = userTable.Rows[0][0].ToString();
query = "select * from User_Seat WHERE U_ID=" + UserID;
userTable = db.ExecuteQuery(query);
ListViewTool.ShowDataInListView(userTable, ReservationListView);
}