/* * 借阅信息的删除 */ private void btn_DelBorr_Click(object sender, EventArgs e) { string bkNum = null; string usrName = null; for (int i = 0; i < dataGridView1.Rows.Count; i++) { if (dataGridView1.Rows[i].Selected == true) { bkNum = dataGridView1.Rows[i].Cells[1].Value.ToString(); usrName = dataGridView1.Rows[i].Cells[2].Value.ToString(); } } Opertion bean = new Opertion(); Boolean ok = bean.BorrowDelete(bkNum, usrName); if (ok) { MessageBox.Show("dalete success!"); SqlConnection conn = new SqlConnection(constr); conn.Open(); string sqlstr = "select * from Borrow"; SqlDataAdapter da = new SqlDataAdapter(sqlstr, conn); DataSet ds = new DataSet(); da.Fill(ds); dataGridView1.DataSource = ds.Tables[0]; conn.Close(); } else { MessageBox.Show("error!"); } //this.dataGridView1.Update(); //this.btn_ReadAllBorrow_Click(this.SendToBack, this.Events); }
/* * 选中用户列表信息删除 */ private void btn_DelUser_Click(object sender, EventArgs e) { string num = null; string zhanghao = null; for (int i = 0; i < dataGridView1.Rows.Count; i++) { if (dataGridView1.Rows[i].Selected == true) { zhanghao = dataGridView1.Rows[i].Cells[0].Value.ToString(); num = dataGridView1.Rows[i].Cells[3].Value.ToString(); } } Console.WriteLine("num = " + num + "; zhanghao = " + zhanghao); Opertion bean = new Opertion(); Boolean ok = bean.UserDelete(zhanghao, num); if (ok) { MessageBox.Show("delete success!"); SqlConnection conn = new SqlConnection(constr); conn.Open(); string sqlstr = "select * from User1"; SqlDataAdapter da = new SqlDataAdapter(sqlstr, conn); DataSet ds = new DataSet(); da.Fill(ds); dataGridView1.DataSource = ds.Tables[0]; conn.Close(); } else { MessageBox.Show("error"); } }
private void btn_UpdateUsr_Click(object sender, EventArgs e) { string zhanghao = Denglu.UsrZhanghao; string xuehao = Denglu.UsrXuehao; usr = new Users(); Opertion bean = new Opertion(); Boolean ok = bean.ReadUsr(zhanghao, xuehao, usr); if (ok) { UsrZhanghao = usr.GetZhanghao(); UsrMima = usr.GetMima(); UsrName = usr.GetName(); UsrXuehao = usr.GetXuehao(); } MyUsr f_mus = new MyUsr(); f_mus.ShowDialog(); /* if(ok) * usr.ToString(); * else * MessageBox.Show("error!");*/ }
private void btn_Denglu_Click(object sender, EventArgs e) { //判定各种是否为空 if (txtbox_Zhanghao.Text.Trim() == string.Empty) { txtbox_Zhanghao.Focus(); } if (txtbox_Mima.Text.Trim() == string.Empty) { txtbox_Mima.Focus(); } string zhanghao = txtbox_Zhanghao.Text.Trim(); string mima = txtbox_Mima.Text.Trim(); Opertion bean = new Opertion(); if (rbtn_Yonghu.Checked) { if (txtbox_Xuehao.Text.Trim() == string.Empty) { txtbox_Xuehao.Focus(); } string xuehao = txtbox_Xuehao.Text.Trim(); Boolean ok = bean.pswCheck(zhanghao, mima, xuehao); if (ok) { //密码正确需要跳转页面到main MessageBox.Show("success!"); this.Hide(); /* ShowTest f_s = new ShowTest(); * f_s.Show();*/ f_m = new Main(); f_m.Show(); } else { MessageBox.Show("mima Error!"); } } else if (rbtn_Guanliyuan.Checked) { Boolean glyLog = bean.gylLogin(zhanghao, mima); if (glyLog) { //密码正确需要跳转页面到main MessageBox.Show("success!"); this.Hide(); f_gly = new Guanliyuan(); f_gly.Show(); } } }
/* * 选中用户列表信息删除 */ private void btn_DelUser_Click(object sender, EventArgs e) { string num = null; string zhanghao = null; for (int i = 0; i < dataGridView1.Rows.Count; i++) { if (dataGridView1.Rows[i].Selected == true) { zhanghao = dataGridView1.Rows[i].Cells[0].Value.ToString(); num = dataGridView1.Rows[i].Cells[3].Value.ToString(); } } Console.WriteLine("num = " + num + "; zhanghao = " + zhanghao); Opertion bean = new Opertion(); Boolean ok = bean.UserDelete(zhanghao, num); if (ok) { MessageBox.Show("delete success!"); } else { MessageBox.Show("error"); } }
private void btn_Zhuce_Click(object sender, EventArgs e) { //判定各种是否为空 if (txtbox_Zhanghao.Text.Trim() == string.Empty) { MessageBox.Show("账号不能为空!"); txtbox_Zhanghao.Focus(); } if (txtbox_Mima.Text.Trim() == string.Empty) { MessageBox.Show("密码不能为空!"); txtbox_Mima.Focus(); } if (txtbox_Mima2.Text.Trim() == string.Empty) { MessageBox.Show("请再次输入密码"); txtbox_Mima2.Focus(); } else { if (txtbox_Xuehao.Text.Trim() == string.Empty) { MessageBox.Show("学号不能为空!"); txtbox_Xuehao.Focus(); } else { if (txtbox_Name.Text.Trim() == string.Empty) { MessageBox.Show("姓名不能为空!"); txtbox_Name.Focus(); } else { string zhanghao = txtbox_Zhanghao.Text.Trim(); string mima1 = txtbox_Mima.Text.Trim(); string mima2 = txtbox_Mima2.Text.Trim(); string name = txtbox_Name.Text.Trim(); string xuehao = txtbox_Xuehao.Text.Trim(); if (mima1 != mima2) { MessageBox.Show("两次输入的密码不相等,请重输!"); txtbox_Mima2.Focus(); } Opertion bean = new Opertion(); if (bean.UserAdd(zhanghao, mima1, name, xuehao)) { MessageBox.Show("注册成功"); } else { MessageBox.Show("error注册失败!"); } } } } }
/* * 首先获取图书的信息,然后还书就是删除借书表的记录(这里需要书号,借阅人),然后改变图书的借出状态(书号) */ private void btn_backBook_Click(object sender, EventArgs e) { int flag = 0; string bkNum = null; string usrName = null; //获取图书的信息 for (int i = 0; i < dataGridView1.Rows.Count; i++) { if (dataGridView1.Rows[i].Selected == true) { bkNum = dataGridView1.Rows[i].Cells[1].Value.ToString(); usrName = dataGridView1.Rows[i].Cells[2].Value.ToString(); } } Opertion bean = new Opertion(); Boolean ok1 = bean.BorrowDelete(bkNum, usrName); if (ok1)//如果记录删除成功 { flag = 1; //MessageBox.Show("delete success !"); Boolean ok2 = bean.BkBuffUpdate(bkNum); if (ok2) { flag = 1; } else { flag = 0; } } else { flag = 0; } if (1 == flag) { MessageBox.Show("还书成功"); } else { MessageBox.Show("failed!"); } SqlConnection conn = new SqlConnection(constr); conn.Open(); string sqlstr = "select * from Borrow"; SqlDataAdapter da = new SqlDataAdapter(sqlstr, conn); DataSet ds = new DataSet(); da.Fill(ds); dataGridView1.DataSource = ds.Tables[0]; conn.Close(); }
/* * 根据书号借书 * select * from Books where Bnumber = '12345675546'; */ private void btn_js_Click(object sender, EventArgs e) { string sh = txtbox_num.Text.ToString(); Opertion bean = new Opertion(); Boolean ok = bean.Borrows(sh); if (ok) { MessageBox.Show("success!"); } else { MessageBox.Show("has borrowed!"); } }
/* * 提交修改 */ private void btn_tj_Click(object sender, EventArgs e) { int flag = Guanliyuan.UpdateFlag; if (flag == 1)//增加 { string name = txt_bkName.Text.Trim().ToString(); string number = txt_bkNum.Text.Trim().ToString(); string kind = cbb_bkKind.Text.Trim().ToString(); string auther = txtbkAuther.Text.Trim().ToString(); string buff = cbbox_bkBuff.Text.ToString(); Console.WriteLine("name = " + name + ",number =" + number + ",kind = " + kind + ",auther = " + auther + ".buff = " + buff); Opertion bean = new Opertion(); Boolean ok = bean.BookAdd(name, number, kind, buff, auther); if (ok) { MessageBox.Show("添加成功!"); } else { MessageBox.Show("error!"); } } else if (2 == flag)//修改 { string name = txt_bkName.Text.Trim().ToString(); string number = txt_bkNum.Text.Trim().ToString(); string kind = cbb_bkKind.Text.Trim().ToString(); string auther = txtbkAuther.Text.Trim().ToString(); string buff = cbbox_bkBuff.Text.ToString(); Console.WriteLine("name = " + name + ",number =" + number + ",kind = " + kind + ",auther = " + auther + ".buff = " + buff); Opertion bean = new Opertion(); Boolean ok = bean.BookUpdateByNumber(name, number, kind, buff, auther); if (ok) { MessageBox.Show("添加成功!"); } else { MessageBox.Show("error!"); } } }
/* * 根据书号借书 * select * from Books where Bnumber = '12345675546'; */ private void btn_js_Click(object sender, EventArgs e) { int flag = -1; string sh = txtbox_bkNum.Text.ToString(); Opertion bean = new Opertion(); Boolean ok1 = bean.Borrows(sh); if (ok1) { flag = 1; //MessageBox.Show("success!"); string bkName = bean.GetBkName(sh); Console.WriteLine("bkName = " + bkName); //DateTime.Now.ToString("yyyy-MM-dd"); // 2008-09-04 Boolean ok2 = bean.BorrowRecord(sh, bkName, DateTime.Now.ToString("yyyy-MM-dd"), usrName); if (ok2) { flag = 1; if (bean.BkBuffChange(sh)) { flag = 1; } else { flag = -1; } } else { flag = -1; } } else { flag = -1; } if (flag == 1) { MessageBox.Show("success"); } else { MessageBox.Show("error"); } }
private void btn_Zhuce_Click(object sender, EventArgs e) { string zhanghao = txtbox_Zhanghao.Text.Trim().ToString(); string mima = txtbox_Mima.Text.Trim().ToString(); string xuehao = txtbox_Xuehao.Text.Trim().ToString(); string name = txtbox_Name.Text.Trim().ToString(); Opertion bean = new Opertion(); Boolean ok = bean.UserChanges(zhanghao, mima, name, xuehao); if (ok) { MessageBox.Show("Update success!"); this.Close(); } else { MessageBox.Show("error"); } }
/* * 提交修改 */ private void btn_Update_Click(object sender, EventArgs e) { string bkName = txtbox_bkName.Text.Trim().ToString(); string bkNum = txtbox_bkNum.Text.Trim().ToString(); string usrName = txtbox_usrName.Text.Trim().ToString(); string data = txtbox_Data.Text.Trim().ToString(); Opertion bean = new Opertion(); Boolean ok = bean.BorrowUpdate(bkName, bkNum, data, usrName); if (ok) { MessageBox.Show("update success!~"); this.Close(); } else { MessageBox.Show("error"); } }
private void btn_Sousuo_Click(object sender, EventArgs e) { string zhanghao = Denglu.UsrZhanghao; string xuehao = Denglu.UsrXuehao; usr = new Users(); Opertion bean = new Opertion(); Boolean ok = bean.ReadUsr(zhanghao, xuehao, usr); if (ok) { UsrZhanghao = usr.GetZhanghao(); UsrMima = usr.GetMima(); UsrName = usr.GetName(); UsrXuehao = usr.GetXuehao(); } this.Hide(); f_ss = new Sousuo(); f_ss.Show(); }
/* * 删除指定行图书信息 */ private void btn_BkDelete_Click(object sender, EventArgs e) { string number = null; for (int i = 0; i < dataGridView1.Rows.Count; i++) { if (dataGridView1.Rows[i].Selected == true) { number = dataGridView1.Rows[i].Cells[1].Value.ToString(); } } Console.WriteLine("number = " + number); Opertion bean = new Opertion(); Boolean ok = bean.BookDelete(number); if (ok) { MessageBox.Show("delete success!"); } else { MessageBox.Show("error!"); } }
/* * 延长还书日期 */ private void btn_Longdata_Click(object sender, EventArgs e) { string bkNum = null; //图书的信息 for (int i = 0; i < dataGridView1.Rows.Count; i++) { if (dataGridView1.Rows[i].Selected == true) { bkNum = dataGridView1.Rows[i].Cells[1].Value.ToString(); //usrName = dataGridView1.Rows[i].Cells[2].Value.ToString(); } } if (bkNum != null) { Opertion bean = new Opertion(); Boolean ok = bean.LongerData(bkNum); if (ok) { MessageBox.Show("重借成功!"); SqlConnection conn = new SqlConnection(constr); conn.Open(); string sqlstr = "select * from Borrow"; SqlDataAdapter da = new SqlDataAdapter(sqlstr, conn); DataSet ds = new DataSet(); da.Fill(ds); dataGridView1.DataSource = ds.Tables[0]; conn.Close(); } } else { MessageBox.Show("未选中!"); } }