private void enter_Click(object sender, RoutedEventArgs e) { string pwd1 = getPassWord(this.pb1); string pwd2 = getPassWord(this.pb2); if (pwd1 == "" || pwd2 == "") { MessageBox.Show("不能为空!"); } else if (pwd1 != pwd2) { MessageBox.Show("两次输入密码不同!"); pb1.Password = ""; pb2.Password = ""; } else if (pwd1.Length < 8) { MessageBox.Show("输入密码过短!"); pb1.Password = ""; pb2.Password = ""; } else if (JudgeEasility(pwd1)) { MessageBox.Show("密码太简单!"); pb1.Password = ""; pb2.Password = ""; } else { MySqlConnection con = Connect.Connection(); MySqlCommand command = new MySqlCommand(); command.Connection = con; command.CommandText = "update login set PassWord = '******' where UserId = '" + Connect.GetUser() + "';"; con.Open(); command.ExecuteNonQuery(); con.Close(); MessageBox.Show("更改成功!"); this.Close(); } }
//点击事件区域 //=================================================================================================================== private void Button_Click(object sender, RoutedEventArgs e) { var button = sender as Button; if (button.Background == System.Windows.Media.Brushes.Red) { MessageBox.Show("该座位已被预约!"); return; } if (!CanBook()) { MessageBox.Show("你已预约另一位置,不能再次预约!"); return; } string name = button.Name; string[] array = name.Split('_'); string row = array[1]; string column = array[2]; MySqlConnection con = Connect.Connection(); MySqlDataReader reader; MySqlCommand command; try { con.Open(); string cmd = "insert into seatbook values('" + row + "','" + column + "','" + Connect.GetUser() + "');"; command = new MySqlCommand(cmd, con); command.ExecuteNonQuery(); cmd = "select * from seatbook where x = '" + row + "' and y = '" + column + "'and UserId = '" + Connect.GetUser() + "';"; command = new MySqlCommand(cmd, con); reader = command.ExecuteReader(); if (reader.HasRows) { MessageBox.Show("预约成功!"); } reader.Close(); }catch (MySqlException ex) { MessageBox.Show(ex.Message); } con.Close(); ButtonBrush(); }
private void Cancel(object sender, MouseButtonEventArgs e)//右键点击取消 { var button = sender as Button; if (button.Background == System.Windows.Media.Brushes.Green) { return; } if (CanBook()) { MessageBox.Show("你无权取消该位置的预约!"); return; } string name = button.Name; string[] array = name.Split('_'); string row = array[1]; string column = array[2]; bool mark = false; MySqlConnection con = Connect.Connection(); MySqlDataReader reader; MySqlCommand command; try { con.Open(); string cmd = "select * from seatbook where x = '" + row + "' and y = '" + column + "'and UserId = '" + Connect.GetUser() + "';"; command = new MySqlCommand(cmd, con); reader = command.ExecuteReader(); if (reader.HasRows) { mark = true; } else { MessageBox.Show("你无权取消该位置的预约!"); } reader.Close(); if (mark) { cmd = "delete from seatbook where UserId = '" + Connect.GetUser() + "';"; command = new MySqlCommand(cmd, con); command.ExecuteNonQuery(); MessageBox.Show("取消预约成功!"); } } catch (MySqlException ex) { MessageBox.Show(ex.Message); } con.Close(); ButtonBrush(); }
private void borrow_Click(object sender, RoutedEventArgs e) { if (!IsHaveQual(num)) { MessageBox.Show("可借阅数目超过最大上限!"); return; } if (num == 0) { return; } string[] gather = new string[num]; for (int i = 0; i < num; i++) { gather[i] = this.list1.Items[i + 1].ToString(); } for (int i = 0; i < num; i++) { string[] array = gather[i].Split('|'); array[0] = array[0].Trim(); array[1] = array[1].Trim(); MySqlConnection con = Connect.Connection(); try { con.Open(); string cmd = "insert into borrow values ('" + array[0] + "','" + array[1] + "','" + Connect.GetUser() + "');"; MySqlCommand command = new MySqlCommand(cmd, con); command.ExecuteNonQuery(); MessageBox.Show("借阅成功!"); //string check = "select * from borrow where BookName = '" + array[0] + "' and Writer = '" + array[1] + "' and UserId = '" + Connect.GetUser() + "';"; //command = new MySqlCommand(check, con); //MySqlDataReader reader = command.ExecuteReader(); //if (reader.HasRows) //{ // MessageBox.Show("借阅成功!"); //} //else //{ // MessageBox.Show("借阅失败!"); // return; //} //reader.Close(); con.Close(); } catch (MySqlException ex) { MessageBox.Show(ex.Message); return; } } list1.Items.Clear(); List1AddHead(); num = 0; }
private bool IsHaveQual(int num) { MySqlConnection con = Connect.Connection(); bool result = false; string cmd = "select count(UserId) as 'cnt' from borrow where UserId = '" + Connect.GetUser() + "';"; try { con.Open(); MySqlCommand command = new MySqlCommand(cmd, con); MySqlDataReader reader = command.ExecuteReader(); int i = 0; if (reader.Read()) { i = Convert.ToInt32(reader["cnt"].ToString()); } if (i + num <= 3) { result = true; } con.Close(); reader.Close(); } catch (MySqlException ex) { MessageBox.Show(ex.Message); } return(result); }
}//向list1中加入图书数据 private void inquery_Click(object sender, RoutedEventArgs e) { string bookname = this.Bookname.Text.ToString().Trim(); string writer = this.Writer.Text.ToString().Trim(); string cmd = ""; MySqlConnection con = Connect.Connection(); if (bookname == "" && writer == "") { MessageBox.Show("请输入内容!"); return; } else if (bookname == "" && writer != "") { cmd = "select * from book where Writer like '%" + writer + "%"; } else if (writer == "" && bookname != "") { cmd = "select * from book where BookName like '%" + bookname + "%"; } else { cmd = "select * from book where BookName like '%" + bookname + "%' and Writer like '%" + writer + "%"; } cmd = cmd + "';"; try { con.Open(); MySqlCommand command = new MySqlCommand(cmd, con); MySqlDataReader reader = command.ExecuteReader(); list.Items.Clear(); AddHead(); string[] str = new string[5]; while (reader.Read()) { str[0] = reader["BookName"].ToString(); str[1] = reader["Writer"].ToString(); str[2] = reader["Page"].ToString(); str[3] = reader["Public"].ToString(); str[4] = reader["DefaultPrice"].ToString(); string sep1 = Formatting(str[0], 20); string sep2 = Formatting(str[1], 20); string sep3 = Formatting(str[2], 20); string sep4 = Formatting(str[3], 20); string sep5 = Formatting(str[4], 20); string strsub = sep1 + sep2 + sep3 + sep4 + sep5; this.list.Items.Add(strsub); } reader.Close(); } catch (MySqlException ex) { MessageBox.Show(ex.Message); } con.Close(); }
//点击事件 //============================================================================================================================== private void SelectPic_Click(object sender, RoutedEventArgs e) { OpenFileDialog openFile = new OpenFileDialog();//用来打开图片选择窗口 openFile.Filter = "JPEG|*.jpg"; openFile.DefaultExt = "jpg"; openFile.Multiselect = false;//不能多选 Image image = new Image();//将原本image的source储存起来; image.Source = this.Picture.Source; this.Picture.Source = null;//设置image的源文件为空; if (openFile.ShowDialog() == true) { Computer computer = new Computer(); //computer类,先引入microsoft.visualBasic,再using device; string path = "d:/libraryresource/Userpicture/"; bool ishave = false; //用来标记用户之前是否设置过图片; //获取原图片文件 MySqlConnection con = Connect.Connection(); string cmd = "select * from usermessage where UserId = '" + Connect.GetUser() + "';"; MySqlCommand command = new MySqlCommand(cmd, con); MySqlDataReader reader; con.Open(); reader = command.ExecuteReader(); reader.Read(); if (reader["Picture"].ToString() != null && reader["Picture"].ToString().Trim() != "") { string pic = reader["Picture"].ToString().Trim(); computer.FileSystem.RenameFile(path + pic, "midpic.jpg");//把原文件名设置为 midpic.jpg ishave = true; } con.Close(); reader.Close(); string type = System.IO.Path.GetExtension(openFile.FileName); string newname = Connect.GetUser() + type;//设置图片新的名字,以用户名命名 System.IO.File.Copy(openFile.FileName, System.IO.Path.Combine(@path, System.IO.Path.GetFileName(openFile.FileName))); string oldname = System.IO.Path.GetFileName(openFile.FileName); ////string oldpath = path + openFile.FileName; ////File.Move(oldpath, path + name); string oldnamepath = path + oldname; if (oldname != newname) { computer.FileSystem.RenameFile(oldnamepath, newname); } if (ishave == true)//如果之前有记录,不需要更新,图片的名字不变;如果没有,则向数据库插入对应的信息。 { computer.FileSystem.DeleteFile(path + "midpic.jpg"); } else { con.Open(); command.CommandText = "update usermessage set Picture = '" + newname + "' where UserId = '" + Connect.GetUser() + "';"; command.ExecuteNonQuery(); con.Close(); } //pack://SiteOfOrigin:,,,/ setImageSource("d:/libraryresource/Userpicture/" + newname); return; } else { this.Picture.Source = image.Source; return; } }
}//检查是否有有关该用户的信息记录 private void SetValues() { DeleteTextChange(); string picturePath = "d:/LibraryResource/UserPicture/";//pack://SiteOfOrigin:,,,/ MySqlConnection con = Connect.Connection(); string cmd = string.Format("select * from usermessage where UserId = '{0}';", Connect.GetUser().ToString()); MySqlDataReader reader; try { con.Open(); MySqlCommand command = new MySqlCommand(cmd, con); reader = command.ExecuteReader(); reader.Read(); this.NickName.Text = reader["NickName"].ToString(); this.Age.Text = reader["Age"].ToString(); this.College.Text = reader["College"].ToString(); this.Address.Text = reader["Address"].ToString(); this.Motto.Text = reader["Motto"].ToString(); this.Introduce.Text = reader["Introduce"].ToString(); string pictureName = reader["Picture"].ToString().Trim();//图片设置 if (pictureName != "" && pictureName != null) { picturePath += pictureName; //this.Picture.Source = new BitmapImage(new Uri(picturePath, UriKind.Absolute)); setImageSource(picturePath); } else { this.Picture.Source = new BitmapImage(new Uri("pack://SiteOfOrigin:,,,/d:/libraryresource/Userpicture/defaultpic.jpg", UriKind.Absolute)); } reader.Close(); } catch (MySqlException ex) { MessageBox.Show(ex.Message + "setvalues"); } con.Close(); AddTextChange(); return; }//设置所有文本框中的信息
//功能函数 //======================================================================================================================================= private void Init() { MySqlConnection con = Connect.Connection(); string cmd = "select * from UserMessage where UserId = '" + Connect.GetUser() + "';"; MySqlCommand command = new MySqlCommand(cmd, con); MySqlDataReader reader; bool isHave = true; try { con.Open(); reader = command.ExecuteReader(); reader.Read(); if (reader.HasRows) { isHave = false; } reader.Close(); if (isHave) { command.CommandText = "insert into UserMessage (UserId) values('" + Connect.GetUser() + "');"; command.ExecuteNonQuery(); } } catch (MySqlException ex) { MessageBox.Show(ex.Message + "Init"); } con.Close(); return; }//检查是否有有关该用户的信息记录
private void Submit_Click(object sender, RoutedEventArgs e) { SetEnabledFalse(); MySqlConnection con = Connect.Connection(); MySqlCommand command; TextBox textBox; string mark = ""; while (true) { if (ChangeNum == 0) { MessageBox.Show("更新完成!"); break; } con.Open(); for (int i = 0; i < 6; i++) { if (Havechanged[i] != null && Havechanged[i] != "") { mark = Havechanged[i]; Havechanged[i] = null; break; } } textBox = this.FindName(mark) as TextBox; string cmd = "update usermessage set " + textBox.Name.Trim() + " = '" + textBox.Text.ToString().Trim() + "' where UserId = '" + Connect.GetUser() + "';"; command = new MySqlCommand(cmd, con); command.ExecuteNonQuery(); con.Close(); ChangeNum--; } this.Change.IsEnabled = true; Havechanged = new string[6]; ChangeNum = 0; SetValues(); }