private void 我的借阅情况ToolStripMenuItem_Click(object sender, EventArgs e) { panel4.Visible = true; panel5.Visible = true; panel1.Visible = false; panel2.Visible = true; panel3.Visible = false; textBox6.Text = DateTime.Now.ToShortDateString().ToString(); Sql1 sqlHelper = new Sql1(); SqlConnection con = sqlHelper.GetConnection(); con.Open(); string strQuery1 = "select Borrow.Bid as 书籍编号, Borrow.Sid as 读者编号, Borrowtime as 借出时间 From Borrow,Reback Where Returntime='未还 ' and Borrow.Bid=Reback.Bid and Borrow.Sid=Reback.Sid and Borrow.Sid='" + str0 + "'"; string strQuery2 = "select Bid as 书籍编号, Sid as 读者编号, Returntime as 归还时间 from Reback Where Sid='" + str0 + "' and Returntime!='未还 '"; try { DataSet ds1 = sqlHelper.GetDataSet(strQuery1); DataTable dt1 = ds1.Tables[0]; dataGridView2.DataSource = dt1; DataSet ds2 = sqlHelper.GetDataSet(strQuery2); DataTable dt2 = ds2.Tables[0]; dataGridView3.DataSource = dt2; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void 借阅书籍ToolStripMenuItem_Click(object sender, EventArgs e) { panel3.Visible = true; panel2.Visible = true; panel1.Visible = false; panel4.Visible = false; panel5.Visible = false; textBox4.Text = DateTime.Now.ToShortDateString().ToString(); 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]; dataGridView1.DataSource = dt; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void 用户管理ToolStripMenuItem_Click(object sender, EventArgs e) { K = 1; panel1.Visible = false; panel4.Visible = true; panel6.Visible = false; panel5.Visible = false; Sql1 sqlHelper = new Sql1(); SqlConnection con = sqlHelper.GetConnection(); con.Open(); string strQuery = "select Sid as 学号, Sname as 姓名 from Students"; try { DataSet ds = sqlHelper.GetDataSet(strQuery); DataTable dt = ds.Tables[0]; dataGridView1.DataSource = dt; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button3_Click(object sender, EventArgs e) { //刷新显示 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]; dataGridView1.DataSource = dt; } catch (Exception ex) { MessageBox.Show(ex.Message); } textBox1.Text = null; textBox2.Text = null; textBox3.Text = null; comboBox1.Text = null; textBox5.Text = null; dateTimePicker1.Value = DateTime.Now; }
private void 书籍借阅管理ToolStripMenuItem_Click(object sender, EventArgs e) { K = 2; panel1.Visible = false; panel4.Visible = false; panel6.Visible = false; panel5.Visible = false; Sql1 sqlHelper = new Sql1(); SqlConnection con = sqlHelper.GetConnection(); con.Open(); string strQuery = "select Borrow.Bid as 书籍编号, Borrow.Sid as 读者编号, Borrowtime as 借出时间, Returntime as 归还时间 From Borrow, Reback Where Borrow.Bid=Reback.Bid"; try { DataSet ds = sqlHelper.GetDataSet(strQuery); DataTable dt = ds.Tables[0]; dataGridView1.DataSource = dt; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button1_Click(object sender, EventArgs e) { //查询书籍 //string strnum = comboBox1.Items[comboBox1.SelectedIndex].ToString(); string str = textBox1.Text.Trim(); string strQuery = "Select Bid as 书籍编号, Bname as 书名, Bpress as 出版社, Bstate as 状态, Bwriter as 作者, Bdate as 出版时间 From Books "; /*if (strnum.Length > 0) * { * strQuery += " And Btapy='" + strnum + "'"; * } */ if (str.Length > 0) { strQuery += " where Bname LIKE'%" + str + "%'"; } try { Sql1 sqlHelper = new Sql1(); DataSet ds = sqlHelper.GetDataSet(strQuery); DataTable dt = ds.Tables[0]; dataGridView1.DataSource = dt; if (dt.Rows.Count == 0) { MessageBox.Show("没有符合条件的记录", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { } } catch (Exception ex) { MessageBox.Show(ex.Message); } }