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