/*
* 根据书号借书
* 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!");
}
}
/*
* 根据书号借书
* 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");
}
}
