//选中确定 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())); }