/*
* 借阅信息的删除
*/
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("未选中！");
}
}
