private void br_refresh_Click(object sender, EventArgs e)
{
data_br.DataBindings.Clear();
data_br.DataSource = Borrow_ad.br_data();
br_select_choose.Text = "BorrowID";
br_choose.Text = "查询";
}
private void bk_refresh_Click(object sender, EventArgs e)
{
//bk_data.AutoGenerateColumns = false;
bk_data.DataBindings.Clear();
bk_data.DataSource = Borrow_ad.bk_data();
bk_data_format();
}
//------------------------------------------------returnbook---------------------------------------------------------
//添加借阅号快捷事件
private void tb_BorrowID_MouseDown(object sender, MouseEventArgs e)
{
String sql = "select count(*) from dbo.borrow";
int k = Convert.ToInt32(Borrow_ad.runsql(sql).Rows[0][0]) + 1;
tb_BorrowID.Text = string.Format("{0}", k);
Console.WriteLine(k);
}
private void bk_excute_btn_Click(object sender, EventArgs e)
{
string sql = string.Format("select * from dbo.book where {0} like '{1}'", bk_choose_btn.Text, bk_input.Text);
bk_data.DataBindings.Clear();
bk_data.DataSource = Borrow_ad.runsql(sql);
bk_data_format();
}
private void rd_excute_btn_Click(object sender, EventArgs e)
{
//rd_input rd_choose_btn
string sql = string.Format("select * from dbo.reader where {0} like '{1}'", rd_choose_btn.Text, rd_input.Text);
rd_data.DataBindings.Clear();
rd_data.DataSource = Borrow_ad.runsql(sql);
rd_data_format();
}
private void borrow_btn_Click(object sender, EventArgs e)
{
fill_borrow();
if (rb_borrow_bk.Checked == false)
{
rb_borrow_bk.Checked = true;
MessageBox.Show("请重新选择读者和书本", "qoq", MessageBoxButtons.OK);
}
DialogResult br_power = DialogResult.Cancel;
if (rd.rdStatus.Equals("有效") && bk.bkStatus.Equals("在馆"))
{
br_power = MessageBox.Show("可以借书，确定借阅？(Y?N)", "lol", MessageBoxButtons.OKCancel);
}
else if (rd.rdStatus.Equals("有效"))
{
MessageBox.Show("很抱歉书本不在馆，不能借阅", "qoq", MessageBoxButtons.OK);
}
else if (bk.bkStatus.Equals("在馆"))
{
MessageBox.Show("很抱歉读者证已失效，不能借阅", "qoq", MessageBoxButtons.OK);
}
if (br_power == DialogResult.OK)
{
string sql_canlendbk = string.Format("select dbo.ReaderType.CanLendQty from dbo.ReaderType where ReaderType.rdType = (select rdType from dbo.Reader where rdID = '{0}')", rd.rdID);
int rd_canlendbk = Convert.ToInt32(Reader_ad.rd_sel(sql_canlendbk));
string sql_allendbk = string.Format("select rdBorrowQty from dbo.reader where rdID = '{0}'", rd.rdID);
int rd_allendbk = Convert.ToInt32(Reader_ad.rd_sel(sql_allendbk));
if (rd_allendbk < rd_canlendbk)
{
bk.bkStatus = "借出"; //Book对象状态
rd.rdBorrowQty = string.Format("{0}", ++rd_allendbk); //Reader对象更改后书籍数量
if (Borrow_ad.run_insql(br, 0))
{
Reader_ad.run_insql(rd, 2); //更新读者已借书本数
Book_ad.run_insql(bk, 1); //更新Reader rd书本状态
MessageBox.Show(string.Format("\"{0}\"借阅\"{1}\"成功!", rd.rdName, bk.bkName), "lol", MessageBoxButtons.OK);
}
rd_refresh_Click(null, null);
bk_refresh_Click(null, null);
}
else
{
MessageBox.Show(string.Format("\"{0}\"借阅\"{1}\"失败!", rd.rdName, bk.bkName), "lol", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
br = new Borrow();// 清空borrow对象数据
}
//------------------------------------------------borrowbook---------------------------------------------------------
//------------------------------------------------returnbook---------------------------------------------------------
private void fill_borrow_b()
{
br.BorrowID = tb_BorrowID_b.Text;
br.bkID = tb_bkID_b.Text;
br.rdID = tb_rdID_b.Text;
DataRow dr = null;
if (br.BorrowID.Equals("") != true)
{
string sql = string.Format("select * from dbo.borrow where BorrowID = '{0}'", br.BorrowID);
br.bkID = dr["bkID"].ToString();
br.rdID = dr["rdID"].ToString();
}
else if (br.bkID.Equals("") != true)
{
string sql = string.Format("select * from dbo.borrow where bkID = '{0}'", br.bkID);
dr = Borrow_ad.runsql(sql).Rows[0];
br.BorrowID = dr["BorrowID"].ToString();
br.rdID = dr["rdID"].ToString();
}
else if (br.rdID.Equals("") != true)
{
string sql = string.Format("select * from dbo.borrow where rdID = '{0}'", br.rdID);
dr = Borrow_ad.runsql(sql).Rows[0];
br.bkID = dr["bkID"].ToString();
br.BorrowID = dr["BorrowID"].ToString();
}
else
{
return;
}
br.IdContinueTimes = dr["IdContinueTimes"].ToString();
br.ldDateOut = dr["ldDateOut"].ToString();
br.ldDateRetPlan = dr["ldDateRetPlan"].ToString();
br.OperatorLend = dr["OperatorLend"].ToString();
br.ldDateRetAct = tb_ldDateRetAct.Text;
br.IsHasReturn = true;
br.OperatorRet = admin.rdID;
DateTime rtd = Convert.ToDateTime(match(tb_ldDateRetAct.Text));
string sql_ldd = string.Format("Select ldDateOut from dbo.borrow where BorrowID = '{0}'", br.BorrowID);
DateTime ldd = Convert.ToDateTime(match(Borrow_ad.runsql(sql_ldd).Rows[0][0]));
br.ldOverDay = DateTime.Compare(rtd, ldd) > 0 ? rtd.Subtract(ldd).ToString() : "0";
}
//------------------------------------------------readerpanel---------------------------------------------------------
//------------------------------------------------borrowbook---------------------------------------------------------
private void fill_borrow()
{
br.BorrowID = tb_BorrowID.Text;
br.bkID = tb_bkID.Text;
br.rdID = tb_rdID.Text;
if (br.BorrowID.Equals("") == true || br.bkID.Equals("") == true || br.rdID.Equals("") == true)
{
return;
}
else
{
br.ldDateOut = tb_ldDateOut.Text;
br.IsHasReturn = false;
br.OperatorLend = admin.rdID;
string sql_lendday = string.Format("select dbo.ReaderType.CanLendDay from dbo.ReaderType where ReaderType.rdType = (select rdType from dbo.Reader where rdID = '{0}')", rd.rdID);
int ledday = Convert.ToInt32(Borrow_ad.runsql(sql_lendday).Rows[0][0]);
br.ldDateRetPlan = getdate(Convert.ToInt32(ledday));
//Console.WriteLine(br.ldDateRetPlan);
}
}
private void return_btn_Click(object sender, EventArgs e)
{
if (rb_return_bk.Checked == false)
{
rb_return_bk.Checked = true;
MessageBox.Show("请重新选择读者和书本", "qoq", MessageBoxButtons.OK);
}
else
{
fill_borrow_b();
if (br.BorrowID.Equals("") || br.bkID.Equals("") || br.rdID.Equals(""))
{
MessageBox.Show("请输入(借阅号 或 书本号 或 读者号)", "qoq", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
return;
}
DialogResult rt_power = DialogResult.Cancel;
rt_power = MessageBox.Show("可以还书，确定退还？(Y?N)", "lol", MessageBoxButtons.OKCancel);
if (rt_power == DialogResult.OK)
{
if (Borrow_ad.run_insql(br, 1))
{
bk.bkStatus = "在馆";
string sql_allendbk = string.Format("select rdBorrowQty from dbo.reader where rdID = '{0}'", rd.rdID);
int rd_allendbk = Convert.ToInt32(Reader_ad.rd_sel(sql_allendbk));
rd.rdBorrowQty = string.Format("{0}", --rd_allendbk);
Console.WriteLine(string.Format("{0}", --rd_allendbk));
Book_ad.run_insql(bk, 1); //更新Reader rd书本状态
Reader_ad.run_insql(rd, 2); //更新读者已借书本数
MessageBox.Show(string.Format("\"{0}\"退还\"{1}\"成功!", rd.rdName, bk.bkName), "lol", MessageBoxButtons.OK);
rd_refresh_Click(null, null);
bk_refresh_Click(null, null);
}
else
{
MessageBox.Show(string.Format("\"{0}\"退还\"{1}\"失败!", rd.rdName, bk.bkName), "lol", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
br = new Borrow();// 清空borrow对象数据
}
}
private void excutebtn_btn_Click(object sender, EventArgs e)
{
tbox2br();
string choose = br_choose.Text;
try
{
switch (choose)
{
case "插入": Borrow_ad.run_insql(br, 0); br_refresh_Click(null, null); MessageBox.Show("Success", "lol", MessageBoxButtons.OK); break;
case "更新": Borrow_ad.run_insql(br, 1); br_refresh_Click(null, null); MessageBox.Show("Success", "lol", MessageBoxButtons.OK); break;
case "删除": Borrow_ad.run_insql(br, 2); br_refresh_Click(null, null); MessageBox.Show("Success", "lol", MessageBoxButtons.OK); break;
case "查询": br_select(string.Format("select * from dbo.borrow where {0} like '{1}'", br_select_choose.Text, br_select_text.Text)); break;
}
}
catch
{
MessageBox.Show("Fail", "qoq", MessageBoxButtons.OK);
}
}
private void br_select(string sql)
{
data_br.DataBindings.Clear();
data_br.DataSource = Borrow_ad.runsql(sql);
}
private void data_br_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
br = Borrow_ad.Row2rd((data_br.CurrentRow.DataBoundItem as DataRowView).Row);
br2tbox(br);
}
private void rd_refresh_Click(object sender, EventArgs e)
{
rd_data.DataBindings.Clear();
rd_data.DataSource = Borrow_ad.rd_data();
rd_data_format();
}