private void mem_Load(object sender, EventArgs e) { if (string.IsNullOrEmpty(str0)) { } else { string strQuery1 = "Select Sname as 用户姓名 From Students Where Sid='" + str0 + "' "; string strQuery2 = "Select Spwd as 密码 From Students Where Sid='" + str0 + "' "; Sql1 sqlHelper = new Sql1(); SqlConnection con = sqlHelper.GetConnection(); SqlCommand cmd1 = new SqlCommand(strQuery1, con); SqlCommand cmd2 = new SqlCommand(strQuery2, con); con.Open(); id1 = (string)cmd1.ExecuteScalar(); id2 = (string)cmd2.ExecuteScalar(); textBox2.Text = id1; textBox3.Text = id2; } }
private void 书籍查询ToolStripMenuItem_Click(object sender, EventArgs e) { panel1.Visible = false; panel4.Visible = false; panel6.Visible = true; panel5.Visible = true; Sql1 sqlHelper = new Sql1(); SqlConnection con = sqlHelper.GetConnection(); con.Open(); string strQuery = "select Bid as 书籍编号, Bname as 书名, Bpress as 出版社, Bstate as 状态, Bwriter as 作者, Bdate as 出版时间 from Books"; try { DataSet ds = sqlHelper.GetDataSet(strQuery); DataTable dt = ds.Tables[0]; dataGridView6.DataSource = dt; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button2_Click(object sender, EventArgs e) { if (textBox2.Text == "" || textBox2.Text.Length > 10) { MessageBox.Show("请输入正确的书籍编号!"); } else { //借阅书籍 string str1 = textBox2.Text.Trim(); // 编号 string str2 = textBox4.Text.Trim(); // 时间 //检查是否可借 string strQuery = "Select Bstate From Books Where Bid='" + str1 + "' "; //检查该用户是否已借过该书 string strQuery0 = "Select Sid From Borrow Where Bid='" + str1 + "' AND Sid='" + str0 + "'"; //更新状态 string strUpdata = "Update Books Set Bstate='借出' Where Bid='" + str1 + "'AND Bid='" + str1 + "'"; //增加借阅记录 string strInsert2 = "Insert Into Borrow(Bid,Sid,Borrowtime) Values('" + str1 + "','" + str0 + "','" + str2 + "')"; //增加归还记录 string strInsert3 = "Insert Into Reback(Bid,Sid,Returntime) Values('" + str1 + "','" + str0 + "','未还')"; string strDelete = "Delete From Reback Where Sid='" + str0 + "' AND Bid='" + str1 + "'"; try { Sql1 sqlHelper = new Sql1(); SqlConnection con = sqlHelper.GetConnection(); SqlCommand cmd = new SqlCommand(strQuery, con); SqlCommand cmd2 = new SqlCommand(strQuery0, con); con.Open(); string id1 = (string)cmd.ExecuteScalar(); id1 = id1.Trim(); string id2 = (string)cmd2.ExecuteScalar(); if ((id1 == "可借") && (string.IsNullOrEmpty(id2))) { sqlHelper.OperateTb(strUpdata); sqlHelper.OperateTb(strInsert2); sqlHelper.OperateTb(strDelete); sqlHelper.OperateTb(strInsert3); MessageBox.Show("借阅成功"); 借阅书籍ToolStripMenuItem_Click(null, null);//刷新页面 textBox2.Text = null; textBox1.Text = null; } else if (id1 == "借出") // &&(string.IsNullOrEmpty(id2)) { MessageBox.Show("书已借出,借书失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else // if (!string.IsNullOrEmpty(id2)) { MessageBox.Show("已借阅过该书(不允许重复借阅)", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { MessageBox.Show("该书籍编号不存在!"); } } }
private void button1_Click(object sender, EventArgs e) // 登录 { string userid = textBox1.Text.Trim(); string userpw = textBox2.Text.Trim(); if (radioButton2.Checked == true) { try { Sql1 sqlHelper = new Sql1(); SqlConnection con = sqlHelper.GetConnection(); SqlCommand com = new SqlCommand("select Aid,Apwd from Administrators where Aid='" + userid + "' and Apwd='" + userpw + "'", con); SqlDataAdapter da = new SqlDataAdapter(com); DataSet ds = new DataSet(); int n = da.Fill(ds, "register"); if (n != 0) { Admin f = new Admin(); f.ShowDialog(); textBox1.Text = null; textBox2.Text = null; } else { MessageBox.Show("请输入正确的账号和密码!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); textBox2.Text = null; } } catch (Exception ex) { MessageBox.Show(ex.Message); } } else { try { Sql1 sqlHelper = new Sql1(); SqlConnection con = sqlHelper.GetConnection(); SqlCommand com = new SqlCommand("select Sid,Spwd from Students where Sid='" + userid + "' and Spwd='" + userpw + "'", con); SqlDataAdapter da = new SqlDataAdapter(com); DataSet ds = new DataSet(); int n = da.Fill(ds, "register"); if (n != 0) { Puser f = new Puser(); f.str0 = userid; f.ShowDialog(); textBox1.Text = null; textBox2.Text = null; } else { MessageBox.Show("请输入正确的账号和密码!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); textBox2.Text = null; } } catch (Exception ex) { MessageBox.Show(ex.Message); } } }
private void button2_Click(object sender, EventArgs e) { //修改书籍 DateTime dt = new DateTime(); dt = DateTime.Now; if (textBox1.Text.Trim() == "") { MessageBox.Show("请输入书籍编号!"); } else if (textBox2.Text.Trim() == "") { MessageBox.Show("请输入书名!"); } else if (textBox3.Text.Trim() == "") { MessageBox.Show("请输入出版社!"); } else if (comboBox1.Text.Trim() == "") { MessageBox.Show("请输入状态!"); } else if (textBox5.Text.Trim() == "") { MessageBox.Show("请输入作者!"); } else if (DateTime.Compare(dateTimePicker1.Value.Date, dt) > 0) { MessageBox.Show("日期超前,请选择正确日期!"); } else { string Bid = textBox1.Text.Trim(); string Bname = textBox2.Text.Trim(); string Bpress = textBox3.Text.Trim(); string Bstate = comboBox1.Text.Trim(); string Bwriter = textBox5.Text.Trim(); string Bdate = dateTimePicker1.Value.Date.ToShortDateString(); string strUpdata = "Update Books Set Bid='" + Bid + "',Bname='" + Bname + "',Bpress='" + Bpress + "',Bstate='" + Bstate + "',Bwriter='" + Bwriter + "',Bdate='" + Bdate + "' Where Bid='" + Bid + "'"; try { Sql1 sqlHelper = new Sql1(); SqlConnection con = sqlHelper.GetConnection(); con.Open(); SqlCommand com = new SqlCommand("select Bid from Books where Bid='" + Bid + "'", con); SqlDataReader sdr = com.ExecuteReader(); if (sdr.HasRows) { sqlHelper.OperateTb(strUpdata); MessageBox.Show("修改成功!"); 书籍管理ToolStripMenuItem_Click(null, null); } else { MessageBox.Show("修改失败!不存在该书籍"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } } }
private void button1_Click(object sender, EventArgs e) { //添加书籍 DateTime dt = new DateTime(); dt = DateTime.Now; if (textBox1.Text.Trim() == "") { MessageBox.Show("请输入书籍编号!"); } else if (textBox2.Text.Trim() == "") { MessageBox.Show("请输入书名!"); } else if (textBox3.Text.Trim() == "") { MessageBox.Show("请输入出版社!"); } else if (comboBox1.Text.Trim() == "") { MessageBox.Show("请输入状态!"); } else if (textBox5.Text.Trim() == "") { MessageBox.Show("请输入作者!"); } else if (DateTime.Compare(dateTimePicker1.Value.Date, dt) > 0) { MessageBox.Show("日期超前,请选择正确日期!"); } else { string Bid = textBox1.Text.Trim(); string Bname = textBox2.Text.Trim(); string Bpress = textBox3.Text.Trim(); string Bstate = comboBox1.Text.Trim(); string Bwriter = textBox5.Text.Trim(); string Bdate = dateTimePicker1.Value.Date.ToShortDateString(); string strInsert = "Insert Into Books(Bid,Bname,Bpress,Bstate,Bwriter,Bdate) Values('" + Bid + "','" + Bname + "','" + Bpress + "','" + Bstate + "','" + Bwriter + "','" + Bdate + "')"; //string strQuery1 = "Select Bstate as 状态 From Books Where Bstate='" + comboBox1.Text + "' "; Sql1 sqlHelper = new Sql1(); SqlConnection con = sqlHelper.GetConnection(); // SqlCommand cmd1 = new SqlCommand(strQuery1, con); con.Open(); // string id1 = (string)cmd1.ExecuteScalar(); try { //con.Open(); SqlCommand com = new SqlCommand("select Bid from Books where Bid='" + Bid + "'", con); SqlDataReader sdr = com.ExecuteReader(); if (sdr.HasRows) { MessageBox.Show("该书籍已存在!"); } else { int intResult = sqlHelper.OperateTb(strInsert); MessageBox.Show("成功添加" + intResult + "记录!"); 书籍管理ToolStripMenuItem_Click(null, null); } con.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } }