private void radioButton3_CheckedChanged(object sender, EventArgs e)
{
//string sql = "select *from borrowinfo";
//ConnDb conn1 = new ConnDb();
//infoDisplay.DataSource = conn1.query(sql).Tables[0];
this.comboBox1.Items.Clear();
if (this.radioButton3.Checked) {
this.comboBox1.Items.Add("书籍名称");
this.comboBox1.Items.Add("书编编号");
this.comboBox1.Items.Add("借阅者");
}
dataGridView1.DataSource = null;
dataGridView1.Rows.Clear();
dataGridView1.Columns.Clear();
dataGridView1.ReadOnly = true;
DataSet ds = new DataSet();
string sql = "Select * from borrowinfo";
ConnDb conn1 = new ConnDb();
ds = conn1.query(sql);
dataGridView1.DataSource = ds.Tables[0];
}
private void button1_Click(object sender, EventArgs e)
{
//bool valid = true;
if (radioButton1.Checked == true) {
//string sql
string value_1 = "'" + dataGridView1.Rows[dataGridView1.Rows.Count - 2].Cells[0].Value.ToString() + "'";
string value_2 = "'" + dataGridView1.Rows[dataGridView1.Rows.Count - 2].Cells[1].Value.ToString() + "'";
string value_3 = "'" + dataGridView1.Rows[dataGridView1.Rows.Count - 2].Cells[2].Value.ToString() + "'";
string value_4 = "'" + dataGridView1.Rows[dataGridView1.Rows.Count - 2].Cells[3].Value.ToString() + "'";
string value_5 = "'" + dataGridView1.Rows[dataGridView1.Rows.Count - 2].Cells[4].Value.ToString() + "'";
string value_6 = "'" + dataGridView1.Rows[dataGridView1.Rows.Count - 2].Cells[5].Value.ToString() + "'";
string value_7 = "'" + dataGridView1.Rows[dataGridView1.Rows.Count - 2].Cells[6].Value.ToString() + "'";
string value_8 = "'" + dataGridView1.Rows[dataGridView1.Rows.Count - 2].Cells[7].Value.ToString() + "'";
string value = value_1 + "," + value_2 + "," + value_3 + "," + value_4 + "," + value_5 + "," + value_6 +","+ value_7 + "," + value_8;
string sql_in = "INSERT INTO book VALUES" + "(" + value + ")";//将datagridview行抽取成sql语句
/*for (int i = 0; i < dataGridView1.Rows.Count-2; i++) {
if (dataGridView1.Rows[dataGridView1.Rows.Count - 2].Cells[0].Value.ToString().Equals(dataGridView1.Rows[i].Cells[0].Value.ToString()))
{
MessageBox.Show("输入数据错误，请重新编辑");
sql_in = "select * from book";
valid = false;
}
}
*/
//if (valid == true)
try
{
ConnDb conn_2 = new ConnDb();
conn_2.update(sql_in);
dataGridView1.DataSource = null;//刷新datagridview
dataGridView1.Rows.Clear();
dataGridView1.Columns.Clear();
DataSet ds = new DataSet();
string sql = "Select * from book";
ConnDb conn1 = new ConnDb();
ds = conn1.query(sql);
dataGridView1.DataSource = ds.Tables[0];
}
catch (Exception e5) {
MessageBox.Show("输入数据错误，请重新编辑("+e5.Message+")");
}
}
if (radioButton2.Checked == true) {
string value_1 = "'" + dataGridView1.Rows[dataGridView1.Rows.Count - 2].Cells[0].Value.ToString() + "'";
string value_2 = "'" + dataGridView1.Rows[dataGridView1.Rows.Count - 2].Cells[1].Value.ToString() + "'";
string value_3 = "'" + dataGridView1.Rows[dataGridView1.Rows.Count - 2].Cells[2].Value.ToString() + "'";
string value_4 = "'" + dataGridView1.Rows[dataGridView1.Rows.Count - 2].Cells[3].Value.ToString() + "'";
//string value_5 = "'" + dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells[4].Value.ToString();
//string value_6 = "'" + dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells[5].Value.ToString();
string value = value_1 + "," + value_2 + "," + value_3 + "," + value_4;
string sql_in = "INSERT INTO [user] VALUES" + "(" + value + ")" + ";";
/*for (int i = 0; i < dataGridView1.Rows.Count - 2; i++)
{
if (dataGridView1.Rows[dataGridView1.Rows.Count - 2].Cells[0].Value.ToString().Equals(dataGridView1.Rows[i].Cells[0].Value.ToString()))
{
MessageBox.Show("输入数据错误，请重新编辑");
sql_in = "select * from [user]";
valid = false;
}
}*/
//if (valid == true)
try
{
ConnDb conn_2 = new ConnDb();
conn_2.update(sql_in);
dataGridView1.DataSource = null;//刷新datagridview
dataGridView1.Rows.Clear();
dataGridView1.Columns.Clear();
DataSet ds = new DataSet();
string sql = "Select * from [user]";
ConnDb conn1 = new ConnDb();
ds = conn1.query(sql);
dataGridView1.DataSource = ds.Tables[0];
}
catch (Exception e4) {
MessageBox.Show("输入数据错误，请重新编辑("+e4.Message+")");
}
//string sql
}
if (radioButton3.Checked == true) {
//string sql
}
}
private void radioButton2_CheckedChanged(object sender, EventArgs e)
{
//string sql = "select *from [user]";
//ConnDb conn1 = new ConnDb();
//infoDisplay.DisplayMember = "unum,uname";
//infoDisplay.DataSource = conn1.query(sql).Tables[0];
this.comboBox1.Items.Clear();
if (this.radioButton2.Checked) {
this.comboBox1.Items.Add("读者编号");
this.comboBox1.Items.Add("读者姓名");
}
dataGridView1.DataSource = null;
dataGridView1.Rows.Clear();
dataGridView1.Columns.Clear();
DataSet ds = new DataSet();
string sql = "Select * from [user]";
ConnDb conn1 = new ConnDb();
ds = conn1.query(sql);
dataGridView1.DataSource = ds.Tables[0];
}
private void radioButton1_CheckedChanged(object sender, EventArgs e)
{
this.comboBox1.Items.Clear();
if (this.radioButton1.Checked) {
this.comboBox1.Items.Add("书籍编号");
this.comboBox1.Items.Add("书籍名称");
this.comboBox1.Items.Add("作者");
this.comboBox1.Items.Add("出版社");
this.comboBox1.Items.Add("分类");
this.comboBox1.Items.Add("借阅状态");
}
//string sql = "select *from book";
//ConnDb conn1 = new ConnDb();
//infoDisplay.DataSource = conn1.query(sql).Tables[0];
dataGridView1.DataSource = null;
dataGridView1.Rows.Clear();
dataGridView1.Columns.Clear();
DataSet ds = new DataSet();
string sql = "Select bnum 图序号,bname 图书名,bwriter 作者,bpulisher 出版社,btmpublished 出版日期,bclass 类型,bsum 总数,bkejie 是否可借 from book";
ConnDb conn1 = new ConnDb();
ds = conn1.query(sql);
dataGridView1.DataSource=ds.Tables[0];
}
private void button4_Click(object sender, EventArgs e)
{
if (radioButton1.Checked == true)
{
string key = dataGridView1.CurrentRow.Cells[0].Value.ToString();
string value_1 = "'" + dataGridView1.CurrentRow.Cells[0].Value.ToString() + "'";
string value_2 = "'" + dataGridView1.CurrentRow.Cells[1].Value.ToString() + "'";
string value_3 = "'" + dataGridView1.CurrentRow.Cells[2].Value.ToString() + "'";
string value_4 = "'" + dataGridView1.CurrentRow.Cells[3].Value.ToString() + "'";
string value_5 = "'" + dataGridView1.CurrentRow.Cells[4].Value.ToString() + "'";
string value_6 = "'" + dataGridView1.CurrentRow.Cells[5].Value.ToString() + "'";
string value_7 = "'" + dataGridView1.CurrentRow.Cells[6].Value.ToString() + "'";
string value_8 = "'" + dataGridView1.CurrentRow.Cells[7].Value.ToString() + "'";
string sql_up = "UPDATE book SET " + "bname =" + value_2 + "," + "bwriter =" + value_3 + "," + "bpulisher =" + value_4 + "," +"btmpublished"+value_5+ "bclass =" + value_6 + "," +"bsum"+value_7+ "bkejie =" + value_8 + "WHERE bnum=" + "'" + dataGridView1.CurrentRow.Cells[0].Value.ToString() + "'" + ";";
ConnDb conn_up = new ConnDb();
conn_up.update(sql_up);
dataGridView1.DataSource = null;//刷新datagridview
dataGridView1.Rows.Clear();
dataGridView1.Columns.Clear();
DataSet ds = new DataSet();
string sql = "Select * from book";
ConnDb conn1 = new ConnDb();
ds = conn1.query(sql);
dataGridView1.DataSource = ds.Tables[0];
}
if (radioButton2.Checked == true) {
string key = dataGridView1.CurrentRow.Cells[0].Value.ToString();
string value_1 = "'" + dataGridView1.CurrentRow.Cells[0].Value.ToString() + "'";
string value_2 = "'" + dataGridView1.CurrentRow.Cells[1].Value.ToString() + "'";
string value_3 = "'" + dataGridView1.CurrentRow.Cells[2].Value.ToString() + "'";
string value_4 = "'" + dataGridView1.CurrentRow.Cells[3].Value.ToString() + "'";
string sql_up = "UPDATE [user] SET " + "uname =" + value_2 + "," + "upasswd =" + value_3 + "," + "ubrwalready ="+value_4+" WHERE bnum=" + "'" + dataGridView1.CurrentRow.Cells[0].Value.ToString() + "'" + ";";
ConnDb conn_up = new ConnDb();
conn_up.update(sql_up);
dataGridView1.DataSource = null;//刷新datagridview
dataGridView1.Rows.Clear();
dataGridView1.Columns.Clear();
DataSet ds = new DataSet();
string sql = "Select * from [user]";
ConnDb conn1 = new ConnDb();
ds = conn1.query(sql);
dataGridView1.DataSource = ds.Tables[0];
}
if (radioButton3.Checked == true) {
string key = dataGridView1.CurrentRow.Cells[0].Value.ToString();
string value_1 = "'" + dataGridView1.CurrentRow.Cells[0].Value.ToString() + "'";
string value_2 = "'" + dataGridView1.CurrentRow.Cells[1].Value.ToString() + "'";
string value_3 = "'" + dataGridView1.CurrentRow.Cells[2].Value.ToString() + "'";
string value_4 = "'" + dataGridView1.CurrentRow.Cells[3].Value.ToString() + "'";
string value_5 = "'" + dataGridView1.CurrentRow.Cells[4].Value.ToString() + "'";
string sql_up = "UPDATE borrowinfo SET " + "tmbrw" + value_3 + "tmlimit" + value_5 + "WHERE bnum=" + "'" + dataGridView1.CurrentRow.Cells[1].Value.ToString() + "' and unum='" + dataGridView1.CurrentRow.Cells[0].Value.ToString() + "';";
ConnDb conn_up = new ConnDb();
conn_up.update(sql_up);
dataGridView1.DataSource = null;//刷新datagridview
dataGridView1.Rows.Clear();
dataGridView1.Columns.Clear();
DataSet ds = new DataSet();
string sql = "Select * from borrowinfo";
ConnDb conn1 = new ConnDb();
ds = conn1.query(sql);
dataGridView1.DataSource = ds.Tables[0];
}
}
private void button3_Click(object sender, EventArgs e)
{
if (radioButton1.Checked == true) {
if (comboBox1.SelectedIndex==0) {
//searchbox.Text = "请输入要查询的书籍编号";
string bianhao = searchbox.Text;
string sql = "select * from book where bnum =" + "'"+bianhao+"%'";
ConnDb conn2 = new ConnDb();
DataSet ds = new DataSet();
ds = conn2.query(sql);
dataGridView1.DataSource = null;
dataGridView1.Rows.Clear();
dataGridView1.Columns.Clear();
dataGridView1.DataSource = ds.Tables[0];
}
if (comboBox1.SelectedIndex == 1) {
//searchbox.Text = "请输入要查询的书籍名称";
string mingchen = searchbox.Text;
string sql = "select * from book where bname="+"'"+mingchen+"%'";
ConnDb conn2 = new ConnDb();
DataSet ds = new DataSet();
ds = conn2.query(sql);
dataGridView1.DataSource = null;
dataGridView1.Rows.Clear();
dataGridView1.Columns.Clear();
dataGridView1.DataSource = ds.Tables[0];
}
if (comboBox1.SelectedIndex == 2) {
//searchbox.Text = "请输入要查询的作者";
string zuozhe = searchbox.Text;
string sql = "select * from book where bwriter="+"'"+zuozhe+"%'";
ConnDb conn2 = new ConnDb();
DataSet ds = new DataSet();
ds = conn2.query(sql);
dataGridView1.DataSource = null;
dataGridView1.Rows.Clear();
dataGridView1.Columns.Clear();
dataGridView1.DataSource = ds.Tables[0];
}
if (comboBox1.SelectedIndex == 3) {
//searchbox.Text = "请输入要查询的出版社";
string chubanshe = searchbox.Text;
string sql = "select * from book where bpulisher="+"'"+chubanshe+"%'";
ConnDb conn2 = new ConnDb();
DataSet ds = new DataSet();
ds = conn2.query(sql);
dataGridView1.DataSource = null;
dataGridView1.Rows.Clear();
dataGridView1.Columns.Clear();
dataGridView1.DataSource = ds.Tables[0];
}
if (comboBox1.SelectedIndex == 4) {
// searchbox.Text = "请输入要查询的分类";
string fenlei = searchbox.Text;
string sql = "select * from book where bclass ="+"'"+fenlei+"%'";
ConnDb conn2 = new ConnDb();
DataSet ds = new DataSet();
ds = conn2.query(sql);
dataGridView1.DataSource = null;
dataGridView1.Rows.Clear();
dataGridView1.Columns.Clear();
dataGridView1.DataSource = ds.Tables[0];
}
if (comboBox1.SelectedIndex == 5) {
//searchbox.Text = "请输入书籍状态：0不可借/1可借";
string zhuangtai = searchbox.Text;
string sql = "select * from book where bkejie="+"'"+zhuangtai+"'";
ConnDb conn2 = new ConnDb();
DataSet ds = new DataSet();
ds = conn2.query(sql);
dataGridView1.DataSource = null;
dataGridView1.Rows.Clear();
dataGridView1.Columns.Clear();
dataGridView1.DataSource = ds.Tables[0];
}
}
if(radioButton2.Checked==true){
if (comboBox1.SelectedIndex == 0)
{
//searchbox.Text = "请输入要查询的读者编号";
string bianhao = searchbox.Text;
string sql = "select * from [user] where unum="+"'"+bianhao+"'";
ConnDb conn2 = new ConnDb();
DataSet ds = new DataSet();
ds = conn2.query(sql);
dataGridView1.DataSource = null;
dataGridView1.Rows.Clear();
dataGridView1.Columns.Clear();
dataGridView1.DataSource = ds.Tables[0];
}
if (comboBox1.SelectedIndex == 1) {
//searchbox.Text = "请输入要查询的读者姓名";
string xingming = searchbox.Text;
string sql = "select * from [user] where uname="+"'"+xingming+"'";
ConnDb conn2 = new ConnDb();
DataSet ds = new DataSet();
ds = conn2.query(sql);
dataGridView1.DataSource = null;
dataGridView1.Rows.Clear();
dataGridView1.Columns.Clear();
dataGridView1.DataSource = ds.Tables[0];
}
}
if (radioButton3.Checked == true) {
if (comboBox1.SelectedIndex == 0) {
//searchbox.Text = "请输入借阅信息的书名";
string shuming = searchbox.Text;
string sql = "select * from borrowinfo where bname=" + "'"+shuming+"'" ;
ConnDb conn2 = new ConnDb();
DataSet ds = new DataSet();
ds = conn2.query(sql);
dataGridView1.DataSource = null;
dataGridView1.Rows.Clear();
dataGridView1.Columns.Clear();
dataGridView1.DataSource = ds.Tables[0];
}
if (comboBox1.SelectedIndex == 1) {
//searchbox.Text = "请输入借阅信息的书籍编号";
string bianhao = searchbox.Text;
string sql = "select * from borrowinfo where bnum="+"'"+bianhao+"'";
ConnDb conn2 = new ConnDb();
DataSet ds = new DataSet();
ds = conn2.query(sql);
dataGridView1.DataSource = null;
dataGridView1.Rows.Clear();
dataGridView1.Columns.Clear();
dataGridView1.DataSource = ds.Tables[0];
}
if (comboBox1.SelectedIndex == 2) {
//searchbox.Text = "请输入借阅者姓名";
string jieyuezhe = searchbox.Text;
string sql = "select * from borrowinfo where uname="+"'"+jieyuezhe+"'";
ConnDb conn2 = new ConnDb();
DataSet ds = new DataSet();
ds = conn2.query(sql);
dataGridView1.DataSource = null;
dataGridView1.Rows.Clear();
dataGridView1.Columns.Clear();
dataGridView1.DataSource = ds.Tables[0];
}
}
}
private void button2_Click(object sender, EventArgs e)
{
if (radioButton1.Checked == true)
{
if (MessageBox.Show("确定删除此记录?", "", MessageBoxButtons.OKCancel) == DialogResult.OK)
{ //delete
string key = this.dataGridView1.CurrentRow.Cells[0].Value.ToString();//获取当前光标所在行的主键
string KEY = "'" + key + "'";
string sql_del = "delete from book where bnum=" + KEY;
ConnDb conn_del = new ConnDb();
conn_del.update(sql_del);
MessageBox.Show("删除成功!");
dataGridView1.DataSource = null;
dataGridView1.Rows.Clear();
dataGridView1.Columns.Clear();
DataSet ds = new DataSet();
string sql = "Select bnum 图序号,bname 图书名,bwriter 作者,bpulisher 出版社,btmpublished 出版日期,bclass 类型,bsum 总数,bkejie 是否可借 from book";
ConnDb conn1 = new ConnDb();
ds = conn1.query(sql);
dataGridView1.DataSource = ds.Tables[0];
//string sql
}
}
if (radioButton2.Checked == true)
{
if (MessageBox.Show("确定删除此记录?", "确认信息", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
//delete
string key = this.dataGridView1.CurrentRow.Cells[0].Value.ToString();
string KEY = "'" + key + "'";
string sql_del = "delete from [user] where unum=" + KEY;
ConnDb conn_del = new ConnDb();
conn_del.update(sql_del);
MessageBox.Show("删除成功!");
dataGridView1.DataSource = null;
dataGridView1.Rows.Clear();
dataGridView1.Columns.Clear();
DataSet ds = new DataSet();
string sql = "Select * from [user]";
ConnDb conn1 = new ConnDb();
ds = conn1.query(sql);
dataGridView1.DataSource = ds.Tables[0];
//string sql
}
}
if (radioButton3.Checked == true)
{
MessageBox.Show("您无权修改此记录");
//string key = this.dataGridView1.CurrentRow.Cells[0].Value.ToString();
//string KEY = "'" + key + "'";
//string sql_del = "delete from borrowinfo where =" + KEY;
// ConnDb conn_del = new ConnDb();
// conn_del.update(sql_del);
//string sql
}
}
