private void NewBtn_Click(object sender, EventArgs e) { if (firstIn == true && character == 0) { Button tempBtn = (Button)sender; TimeSelectForm TimeSelectForm = new TimeSelectForm(false, tempBtn.Text, uid); TimeSelectForm.Show(); this.Hide(); } else if (firstIn == false && character == 0) { Button tempBtn = (Button)sender; dbsql db = new dbsql(); string query; query = "insert into User_Seat values('" + tempBtn.Text + "','" + uid + "','" + start.ToString() + "','" + end.ToString() + "')"; int right = db.ExecuteUpdate(query); if (right == 3) { MessageBox.Show("预定成功!", "恭喜"); } this.Close(); } else { Button tempBtn = (Button)sender; SeatManageForm SeatManageForm = new SeatManageForm(tempBtn.Text); SeatManageForm.Show(); } }
private void StartButton_Click(object sender, EventArgs e) { dbsql db = new dbsql(); DataTable userTable; InputLegality check = new InputLegality(); if (!check.legality(IDtextBox.Text, -1)) { MessageBox.Show("仅可输入纯数字。", "警告"); IDtextBox.Text = ""; return; } if (IDtextBox.Text == "") { string query = "select * from D_User "; userTable = db.ExecuteQuery(query); ListViewTool.ShowDataInListView(userTable, UserListView); } else { string query = "select * from D_User WHERE U_ID LIKE '%" + IDtextBox.Text + "%'"; userTable = db.ExecuteQuery(query); ListViewTool.ShowDataInListView(userTable, UserListView); } }
private void ChangePassWordButton_Click(object sender, EventArgs e) { InputLegality check = new InputLegality(); if (!(check.legality(textBox1.Text, 6) && check.legality(textBox1.Text, 6))) { MessageBox.Show("请确保密码长度正确且为纯数字。", "请重试"); return; } if (textBox1.Text.CompareTo(textBox2.Text) != 0) { MessageBox.Show("请确保两次密码输入一致", "请重试"); return; } dbsql db = new dbsql(); string query = "UPDATE D_User SET Password ="******"WHERE U_ID=" + uid; int right = 0; right = db.ExecuteUpdate(query); if (right == 1) { MessageBox.Show("新密码是" + textBox1.Text + "\n请牢记新密码", "修改成功"); } this.Close(); }
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 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); }
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); }
private void ResetPasswordButton_Click(object sender, EventArgs e) { dbsql db = new dbsql(); string query = "UPDATE D_User SET Password = '******' WHERE U_ID=" + UserID; int right = 0; right = db.ExecuteUpdate(query); if (right == 1) { MessageBox.Show("重置密码为123456!", "修改成功"); } }
private void SignOffButton_Click(object sender, EventArgs e) //删除预约函数 { dbsql db = new dbsql(); string query = "DELETE FROM User_Seat WHERE U_ID =" + uid; int right = db.ExecuteUpdate(query); if (right == 3) { MessageBox.Show("强制删除预约成功", "成功"); } this.Close(); }
private void ClearButton_Click(object sender, EventArgs e) { dbsql db = new dbsql(); string query = "DELETE FROM User_Seat WHERE S_ID=" + sid; int right = db.ExecuteUpdate(query); if (right == 0) { MessageBox.Show("当前座位下无预约。", "失败"); return; } MessageBox.Show("所有预约已经被强制取消。", "成功"); }
private void AddFloorComboBoxItem() { dbsql db = new dbsql(); string query; for (int floorNumber = 1; floorNumber <= 10; floorNumber++) { query = "select S_ID from Seat where S_Floor =" + floorNumber + " "; if (db.ExecuteQuery(query).Rows.Count >= 1) { FloorComboBox.Items.Add("" + floorNumber); } } }
private void ConfirmButton_Click(object sender, EventArgs e) //按时间预定 { if (firstIn) //用户直接进入该窗口,尚未选择座位 { if (start <= System.DateTime.Now) //判读时间合法性 { MessageBox.Show("预约时间早于系统当前时间", "非法操作"); return; } FloorSelectForm FloorSelectForm = new FloorSelectForm(false, uid, start, end, 0); //打开新窗口,由用户选择该时间段空闲座位 FloorSelectForm.Show(); this.Hide(); } else //用户已经选择座位,才进入该窗口 { dbsql sql = new dbsql(); string que = "select * from User_Seat WHERE Star_Time<='" + end.ToString("yyyy-MM-dd hh:mm:ss") + "'and End_Time>=' " + end.ToString("yyyy-MM-dd hh:mm:ss") + "'AND S_ID =" + sid; //查询用户选定的座位在选定时间段内是否空闲 DataTable dt = new DataTable(); dt = sql.ExecuteQuery(que); if (dt != null && dt.Rows.Count > 0) //能找到,说明已经存在别人的预约 { MessageBox.Show("时间存在冲突", "警告"); return; } que = "select * from User_Seat WHERE End_Time>='" + start.ToString("yyyy-MM-dd hh:mm:ss") + "'and Star_Time<='" + start.ToString("yyyy-MM-dd hh:mm:ss") + "'and S_ID =" + sid; //查询用户选定的座位在选定时间段内是否空闲 dt = sql.ExecuteQuery(que); if (dt != null && dt.Rows.Count > 0) //能找到,说明已经存在别人的预约 { MessageBox.Show("时间存在冲突", "警告"); return; } que = "insert into User_Seat values('" + sid + "','" + uid + "','" + start.ToString() + "','" + end.ToString() + "')"; //向数据库中插入新的预约数据 int right = sql.ExecuteUpdate(que); if (right == 3) { MessageBox.Show("预定成功!", "恭喜"); //告知用户预约成功 } this.Close(); } }
public ReservationForm(string uid, string sid) { InitializeComponent(); this.sid = sid; this.uid = uid; SidLabel.Text = sid; UidLabel.Text = uid; dbsql db = new dbsql(); string query = "select Star_Time from User_Seat WHERE U_ID=" + uid + "AND S_ID=" + sid; DataTable userTable = db.ExecuteQuery(query); StartLabel.Text = userTable.Rows[0][0].ToString(); query = "select End_Time from User_Seat WHERE U_ID=" + uid + "AND S_ID=" + sid; userTable = db.ExecuteQuery(query); EndLabel.Text = userTable.Rows[0][0].ToString(); }
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); }
private void MaintainButton_Click(object sender, EventArgs e) { dbsql db = new dbsql(); string query; if (maintain) { query = "UPDATE Seat SET S_State = '1' WHERE S_ID=" + sid; int right = db.ExecuteUpdate(query); if (right == 1) { MessageBox.Show("座位已经恢复正常,开始投入使用", "成功"); } } else { query = "DELETE FROM User_Seat WHERE S_ID=" + sid; db.ExecuteUpdate(query); query = "UPDATE Seat SET S_State = '4' WHERE S_ID=" + sid; db.ExecuteUpdate(query); MessageBox.Show("座位已经准备维护,所有已存在的预约已经被强制取消。", "警告"); } }
private void AddSeatA() //动态绘制座位选择界面(以A区为例) { Label label = new Label(); //添加一个A区的LABEL label.Text = "A区"; label.Location = new Point(30, 5); this.MainPanel.Controls.Add(label); //将LABEL加入MainPanel string floor = FloorComboBox.SelectedItem.ToString(); dbsql db = new dbsql(); string query = "select * from Seat where S_Location = 1 AND S_Floor = " + floor; //查找全部的A区座位 DataTable seatTable = db.ExecuteQuery(query); //查找结果放入DataTab中le for (int i = 0; i < seatTable.Rows.Count; i++) //循环添加按钮 { Button btn = new Button(); btn.Parent = MainPanel; btn.Location = new Point(i * 110 + 30, 30); //每次添加新按钮较上次偏移一些位置 btn.Size = new Size(100, 30); btn.Text = seatTable.Rows[i][0].ToString(); bool thisNearWindow = false; //默认不靠窗 bool thisNearSocket = false; //默认没有插座 if (firstIn == false && character == 0) //如果学生在此之前已经选择了时间段,筛选该时间段空闲座位 { dbsql sql = new dbsql(); string que = "select * from User_Seat WHERE Star_Time<=" + end.ToShortDateString().ToString() + "and End_Time>= " + end.ToShortDateString().ToString() + "AND S_ID =" + btn.Text; DataTable dt = new DataTable(); dt = db.ExecuteQuery(que); if (dt != null && dt.Rows.Count > 0) { break; } que = "select * from User_Seat WHERE End_Time>=" + start.ToShortDateString().ToString() + "and Star_Time<=" + start.ToShortDateString().ToString() + "AND S_ID =" + btn.Text; dt = db.ExecuteQuery(que); if (dt != null && dt.Rows.Count > 0) { break; } } if (seatTable.Rows[i][4].ToString().CompareTo("1") == 0) //判断是否靠窗 { thisNearWindow = true; } if (seatTable.Rows[i][5].ToString().CompareTo("1") == 0) //判断是否有插座 { thisNearSocket = true; } if (nearWindow == true && thisNearWindow == false) //根据用户选择智能显示靠窗座位 { btn.Visible = false; } if (nearSocket == true && thisNearSocket == false) //根据用户选择智能显示有插座座位 btn.Visible = false; { btn.Click += NewBtn_Click; } this.MainPanel.Controls.Add(btn); //将按钮加入MainPanel btn.BackColor = Color.Transparent; } }
private void AddSeatD() { Label label = new Label(); label.Text = "D区"; label.Location = new Point(30, 275); this.MainPanel.Controls.Add(label); string floor = FloorComboBox.SelectedItem.ToString(); dbsql db = new dbsql(); string query = "select * from Seat where S_Location = 4 AND S_Floor = " + floor; DataTable seatTable = db.ExecuteQuery(query); for (int i = 0; i < seatTable.Rows.Count; i++) { Button btn = new Button(); btn.Parent = MainPanel; btn.Location = new Point(i * 110 + 30, 300); btn.Size = new Size(100, 30); btn.Text = seatTable.Rows[i][0].ToString(); bool thisNearWindow = false; bool thisNearSocket = false; if (firstIn == false && character == 0) { string que = "select * from User_Seat WHERE Star_Time<='" + end.ToString("yyyy-MM-dd hh:mm:ss") + "'and End_Time>=' " + end.ToString("yyyy-MM-dd hh:mm:ss") + "'AND S_ID =" + btn.Text; DataTable dt = new DataTable(); dt = db.ExecuteQuery(que); if (dt != null && dt.Rows.Count > 0) { break; } que = "select * from User_Seat WHERE End_Time>='" + start.ToString("yyyy-MM-dd hh:mm:ss") + "'and Star_Time<='" + start.ToString("yyyy-MM-dd hh:mm:ss") + "'and S_ID =" + btn.Text; dt = db.ExecuteQuery(que); if (dt != null && dt.Rows.Count > 0) { break; } } if (seatTable.Rows[i][4].ToString().CompareTo("1") == 0) { thisNearWindow = true; } if (seatTable.Rows[i][5].ToString().CompareTo("1") == 0) { thisNearSocket = true; } if (nearWindow == true && thisNearWindow == false) { btn.Visible = false; } if (nearSocket == true && thisNearSocket == false) { btn.Visible = false; } btn.Click += NewBtn_Click; this.MainPanel.Controls.Add(btn); btn.BackColor = Color.Transparent; } }