private void btnSend_Click(object sender, EventArgs e) { if (AccessOperation.Exists("Select * From Login where UserName = '******'") == false) { MessageBox.Show("该用户不存在!"); txtUser.Text = ""; txtEmail.Text = ""; return; } if (AccessOperation.Exists("Select * From Login where UserName = '******' and Email = '" + txtEmail.Text + "'") == false) { MessageBox.Show("邮箱未与该用户绑定!"); txtEmail.Text = ""; return; } try { string sendName = "*****@*****.**"; string sendPass = "******"; string reciveName = txtEmail.Text; string title = "电影爱好者平台验证码"; Random rd = new Random(); code1 = rd.Next(100000, 999999); string content = code1.ToString(); SendEmail(sendName, sendPass, reciveName, title, content, "smtp.qq.com"); timer1.Start(); t = 60; } catch { MessageBox.Show("验证码发送失败!"); } }
private void btnYes_Click(object sender, EventArgs e) { Regex pattern_password = new Regex(@"[\da-zA-Z0-9]{6,15}"); if (!pattern_password.IsMatch(txtUser.Text)) { MessageBox.Show("密码应为6到15位字母或数字!"); txtPs1.Text = ""; txtPs2.Text = ""; return; } if (!txtPs1.Text.Equals(txtPs2.Text)) { MessageBox.Show("两次输入的新密码不同!"); txtPs1.Text = ""; txtPs2.Text = ""; return; } try { AccessOperation.ExecuteNonQuery("Update [Login] Set [Password]='" + txtPs1.Text + "' Where [UserName]='" + txtUser.Text + "'"); MessageBox.Show("密码更改成功!"); this.Hide(); new Login().Show(); } catch { MessageBox.Show("未知错误未能更新密码!"); } }
private void textChanged(object sender, EventArgs e) { if (sender.Equals(cbUser)) { labelUser.Visible = cbUser.Text.Length < 1; string s = ""; try { s = AccessOperation.ExecuteScalar("Select Image From Messages where UserName = '******'").ToString(); } catch { Bitmap bmp = new Bitmap("timg.jpg"); pictureBox1.Image = bmp; } if (s != "") { if (File.Exists("D://image//" + s + ".bmp")) { Bitmap bmp = new Bitmap("D://image//" + s + ".bmp"); pictureBox1.Image = bmp; } else { Bitmap bmp = new Bitmap("timg.jpg"); pictureBox1.Image = bmp; } } } else if (sender.Equals(txtPwd)) { labelPwd.Visible = txtPwd.Text.Length < 1; } }
private void btnSave_Click(object sender, EventArgs e) { Bitmap bmp = new Bitmap(pictureBox1.Image, pictureBox1.Width, pictureBox1.Height); Graphics g = Graphics.FromImage(bmp); //检查是否存在文件夹 string subPath = "D://image"; if (false == System.IO.Directory.Exists(subPath)) { //创建pic文件夹 System.IO.Directory.CreateDirectory(subPath); } try { bmp.Save("D://image//" + strFilePath + ".bmp", System.Drawing.Imaging.ImageFormat.Bmp); Bitmap bmps = new Bitmap("D://image//" + strFilePath + ".bmp"); pictureBox1.Image = bmps; AccessOperation.ExecuteNonQuery("Update [Messages] Set [Image]='" + strFilePath + "' Where [UserName]='" + username + "'"); } catch { MessageBox.Show("保存失败(尝试更改文件名后上传)"); return; } MessageBox.Show("保存成功!"); }
public UserMessages(string u) { InitializeComponent(); username = u; UserName.Text = u; btnSave.Enabled = false; txtSign.Text = AccessOperation.ExecuteScalar("Select Sign From Messages Where UserName='******'").ToString(); try { s = AccessOperation.ExecuteScalar("Select Image From Messages Where UserName='******'").ToString(); } catch { s = ""; } try { Bitmap bmp = new Bitmap("D://image//" + s + ".bmp"); pictureBox1.Image = bmp; } catch { Bitmap bmp = new Bitmap("timg.jpg"); pictureBox1.Image = bmp; } txtSign2.Text = txtSign.Text; txtName.Text = AccessOperation.ExecuteScalar("Select RealName From Messages Where UserName='******'").ToString(); txtOld.Text = AccessOperation.ExecuteScalar("Select Old From Messages Where UserName='******'").ToString(); cbSex.Text = AccessOperation.ExecuteScalar("Select Sex From Messages Where UserName='******'").ToString(); cbStyle.Text = AccessOperation.ExecuteScalar("Select Style From Messages Where UserName='******'").ToString(); DataSet myDataSet = AccessOperation.Query("Select * From Record Where UserName='******'", "Record"); dataGridView1.DataSource = myDataSet.Tables["Record"]; }
private void btnSave_Click(object sender, EventArgs e) { try { //MessageBox.Show(""); AccessOperation.ExecuteNonQuery("Insert Into [Record] ([Movie], [UserName], [Link]) VALUES('" + MovieName + "', '" + username + "', '" + textBox1.Text + "')"); MessageBox.Show("收藏成功!"); } catch { MessageBox.Show("收藏失败!"); } }
private void btnDelete_Click(object sender, EventArgs e) { if (movies != "") { AccessOperation.ExecuteNonQuery("Delete * From Record Where Movie = '" + movies + "' and UserName='******'"); MessageBox.Show("删除成功!"); DataSet myDataSet = AccessOperation.Query("Select * From Record Where UserName='******'", "Record"); dataGridView1.DataSource = myDataSet.Tables["Record"]; } else { MessageBox.Show("未选中行!"); } }
private void btnSavemessage_Click(object sender, EventArgs e) { try { AccessOperation.ExecuteNonQuery("Insert Into [Messages] ([UserName], [RealName], [Sign],[Sex],[Old],[Style]) VALUES('" + username + "', '" + txtName.Text + "', '" + txtSign2.Text + "','" + cbSex.Text + "','" + txtOld.Text + "','" + cbStyle.Text + "')"); MessageBox.Show("信息插入成功!"); this.Hide(); new Login().Show(); } catch { MessageBox.Show("信息插入失败(未知错误)!"); } }
private void btnSavemessage_Click(object sender, EventArgs e) { try { AccessOperation.ExecuteNonQuery("Update Messages Set Sex='" + cbSex.Text + "' Where UserName='******'"); AccessOperation.ExecuteNonQuery("Update Messages Set Sign='" + txtSign2.Text + "' Where UserName='******'"); AccessOperation.ExecuteNonQuery("Update Messages Set Old='" + txtOld.Text + "' Where UserName='******'"); AccessOperation.ExecuteNonQuery("Update Messages Set RealName='" + txtName.Text + "' Where UserName='******'"); AccessOperation.ExecuteNonQuery("Update Messages Set Style='" + cbStyle.Text + "' Where UserName='******'"); MessageBox.Show("信息更新成功,界面主题会在下次开启本软件时更新!"); skinEngine1.SkinFile = @"Skins\" + AccessOperation.ExecuteScalar("Select Style From Messages Where UserName='******'").ToString(); } catch { MessageBox.Show("信息更新失败(未知错误)!"); } }
public Login() { InitializeComponent(); this.skinEngine1.SkinFile = @"Skins\Calmness.ssk"; try { OleDbDataReader reader = AccessOperation.ExecuteReader("Select UserName From UsedUser"); List <string> list = new List <string>(); while (reader.Read()) { list.Add(reader.GetString(0)); } cbUser.DataSource = list; } catch { MessageBox.Show("数据库无法打开!"); Application.Exit(); } }
private void btnPost_Click(object sender, EventArgs e) { if (AccessOperation.Exists("Select * From Login where Password = '******' and UserName = '******'") == false) { MessageBox.Show("原密码错误!"); txtps1.Text = ""; txtps2.Text = ""; txtps3.Text = ""; return; } if (txtps1.Text == "" || txtps2.Text == "" || txtps3.Text == "") { MessageBox.Show("更改密码所需信息不能为空!"); return; } Regex pattern_password = new Regex(@"[\da-zA-Z0-9]{6,15}"); if (!pattern_password.IsMatch(txtps2.Text)) { MessageBox.Show("密码应为6到15位字母或数字!"); txtps2.Text = ""; txtps3.Text = ""; return; } if (!txtps2.Text.Equals(txtps3.Text)) { MessageBox.Show("两次输入的新密码不同!"); txtps2.Text = ""; txtps3.Text = ""; return; } try { AccessOperation.ExecuteNonQuery("Update [Login] Set [Password]='" + txtps2.Text + "' Where [UserName]='" + username + "'"); MessageBox.Show("修改完成!"); }catch { MessageBox.Show("修改失败!"); } }
private void btnLogin_Click(object sender, EventArgs e) { if (txtPwd.Text.Length == 0 || cbUser.Text.Length == 0) { MessageBox.Show("用户名或密码不能为空!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (AccessOperation.Exists("Select * From Login where UserName='******'") == false) { MessageBox.Show("用户不存在!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (AccessOperation.Exists("Select * From Login where Password = '******' and UserName = '******'") == false) { MessageBox.Show("密码错误!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (AccessOperation.Exists("Select * From Login where Password = '******' and UserName = '******'")) { username = cbUser.Text; MessageBox.Show("欢迎使用电影爱好者平台!"); if (!AccessOperation.Exists("Select * From UsedUser where UserName = '******'")) { try { AccessOperation.ExecuteNonQuery("Insert Into [UsedUser] VALUES('" + cbUser.Text + "')"); }catch { MessageBox.Show("未能插入本次登陆记录"); } } this.Hide(); this.skinEngine1.SkinFile = @"Skins\" + AccessOperation.ExecuteScalar("Select Style From Messages where UserName = '******'"); new Main(username).Show(); return; } }
public Main(string u) { InitializeComponent(); //MessageBox.Show(skin); //MessageBox.Show(skinEngine1.SkinFile); this.username = u; UserName.Text = u; try { txtSign.Text = AccessOperation.ExecuteScalar("Select Sign From Messages Where UserName='******'").ToString(); }catch (Exception ex) { MessageBox.Show(ex.ToString()); } try { string s = AccessOperation.ExecuteScalar("Select Image From Messages Where UserName='******'").ToString(); Bitmap bmp = new Bitmap("D://image//" + s + ".bmp"); pictureBox1.Image = bmp; } catch { Bitmap bmp = new Bitmap("timg.jpg"); pictureBox1.Image = bmp; } LvHot.Columns.Add("片名", 178, HorizontalAlignment.Center); LvHot.Columns.Add("时间", 65, HorizontalAlignment.Center); LvHot.Columns.Add("评分", 65, HorizontalAlignment.Center); LvHot.Columns.Add("时长", 114, HorizontalAlignment.Center); LvHot.Columns.Add("产地", 94, HorizontalAlignment.Center); LvHot.Columns.Add("演员", 315, HorizontalAlignment.Center); LvHot.BeginUpdate(); cn.smallfunny.web.model_movies[] HotMovies = null; try { HotMovies = Movies.Message(); } catch { MessageBox.Show("初始化失败!"); this.Hide(); new Login().Show(); return; } for (int i = 0; i < HotMovies.Length; i++) { ListViewItem item = new ListViewItem(); HotLinks[i] = HotMovies[i].Link; item.Text = HotMovies[i].Name; item.SubItems.Add(HotMovies[i].Times); item.SubItems.Add(HotMovies[i].Rate); item.SubItems.Add(HotMovies[i].Duration); item.SubItems.Add(HotMovies[i].Place); item.SubItems.Add(HotMovies[i].Actor); LvHot.Items.Add(item); } LvHot.EndUpdate(); }
private void btnRegister_Click(object sender, EventArgs e) { Regex pattern_email = new Regex(@"^[A-Za-z\d]+([-_.][A-Za-z\d]+)*@([A-Za-z\d]+[-.])+[A-Za-z\d]{2,4}$"); Regex pattern_username = new Regex(@"[\da-zA-Z0-9]{2,10}"); Regex pattern_password = new Regex(@"[\da-zA-Z0-9]{6,15}"); if (txtUser.Text.Length == 0) { MessageBox.Show("用户名不能为空!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (txtEmail.Text.Length == 0) { MessageBox.Show("邮箱不能为空!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (txtPwd.Text.Length == 0) { MessageBox.Show("密码不能为空!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (AccessOperation.Exists("Select * From Login where UserName='******'") != false) { MessageBox.Show("用户名重复!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); txtUser.Text = ""; return; } if (!pattern_username.IsMatch(txtUser.Text)) { MessageBox.Show("用户名应为2到10位字母或数字!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); txtUser.Text = ""; return; } if (AccessOperation.Exists("Select * From Login where Email='" + txtEmail.Text + "'")) { MessageBox.Show("邮箱已使用!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); txtEmail.Text = ""; return; } if (!pattern_email.IsMatch(txtEmail.Text)) { MessageBox.Show("邮箱格式错误!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); txtEmail.Text = ""; return; } if (!pattern_password.IsMatch(txtUser.Text)) { MessageBox.Show("密码应为6到15位字母或数字!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); txtPwd.Text = ""; txtRepeat.Text = ""; return; } if (txtRepeat.Text.Equals(txtPwd.Text) == false) { MessageBox.Show("密码两次输入不相同!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); txtPwd.Text = ""; txtRepeat.Text = ""; return; } AccessOperation.ExecuteNonQuery("Insert Into [Login] ([UserName], [Password], [Email]) VALUES('" + txtUser.Text + "', '" + txtPwd.Text + "', '" + txtEmail.Text + "')"); MessageBox.Show("注册成功!"); this.Hide(); new InputMessages(txtUser.Text).Show(); return; }