//选中确定
private void btnReadOK_Click(object sender, EventArgs e)
{
if (this.Text == "注销列表选择")
{
Model.BookId bi = new Model.BookId();
bi.TbBookID = dataGridViewRead[0, bsID.Position].Value.ToString().Trim();
IDevent(bi.TbBookID);
this.Close();
}
if (this.Text == "ISBN列表选择")
{
Model.BookId bi = new Model.BookId();
bi.TbISBN = dataGridViewRead[0, bsISBN.Position].Value.ToString().Trim();
ISBNevent(bi.TbISBN);
this.Close();
}
if (this.Text == "读者列表选择")
{
Model.BorrowInfo br = new Model.BorrowInfo();
br.TbBorrowReadId = dataGridViewRead[0, bsRead.Position].Value.ToString().Trim();
Readevent(br.TbBorrowReadId);
this.Close();
}
if (this.Text == "图书列表选择")
{
Model.BorrowInfo br = new Model.BorrowInfo();
br.TbBorrowBookId = dataGridViewRead[0, bsBook.Position].Value.ToString().Trim();
//委托事件传值
Bookevent(br.TbBorrowBookId);
//选择完成后 关闭当前窗体
this.Close();
}
if (this.Text == "图书编号列表选择")
{
Model.Back bc = new Model.Back();
bc.TbBackBookId = dataGridViewRead[0, bsBookID.Position].Value.ToString().Trim();
bc.CbBackDamage = dataGridViewRead["损坏程度", bsBookID.Position].Value.ToString().Trim();
BookIDevent(bc.TbBackBookId, bc.CbBackDamage);
this.Close();
}
}
/// <summary>
/// 借阅信息方法
/// </summary>
/// <param name="i">
/// 1代表借阅图书错（插入数据）
/// 2代表续借（修改数据）
/// </param>
/// <param name="bi">实例化对象</param>
/// <returns></returns>
public static string sysBorrow(int i, Model.BorrowInfo bi)
{
string str = "proc_BorrowInfoSave";
SqlParameter[] Parameter =
{
new SqlParameter("@num", SqlDbType.Int),
new SqlParameter("@学号", SqlDbType.NVarChar),
new SqlParameter("@BookID", SqlDbType.NVarChar),
new SqlParameter("@backvalue", SqlDbType.NVarChar, 30),
};
Parameter[0].Value = i;
Parameter[1].Value = bi.TbBorrowReadId;
Parameter[2].Value = bi.TbBorrowBookId;
Parameter[3].Direction = ParameterDirection.Output;
SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, str, Parameter);
return(Convert.ToString(Parameter[3].Value.ToString()));
}
