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