//选中确定
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代表插入数据</param>
/// <returns></returns>
public static string sysBack(int i, Model.Back bc)
{
string str = "proc_BackInfoSave";
SqlParameter[] Parameter =
{
new SqlParameter("@num", SqlDbType.Int),
new SqlParameter("@BookID", SqlDbType.NVarChar),
new SqlParameter("@是否丢失", SqlDbType.NVarChar),
new SqlParameter("@损坏程度", SqlDbType.NVarChar),
new SqlParameter("@backvalue", SqlDbType.NVarChar, 300),
};
Parameter[0].Value = i;
Parameter[1].Value = bc.TbBackBookId;
Parameter[2].Value = bc.CbBackLost;
Parameter[3].Value = bc.CbBackDamage;
Parameter[4].Direction = ParameterDirection.Output;
SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, str, Parameter);
return(Convert.ToString(Parameter[4].Value.ToString()));
}
