this.txtbID.Text = \; this.txtbName.Text = \; this.txtbPic.Text = \; this.txtbPrice.Text = \; this.txtbType.Text = \; }

private void btnClose_Click(object sender, EventArgs e) { this.Close(); }}}

附录D 图书借阅功能实现代码

using System;

using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text;

using System.Windows.Forms; namespace BookManage

{ public partial class frmIssueBook : Form { DataSet da;

public frmIssueBook() { nitializeComponent(); }

private void frmIssueBook_Load(object sender, EventArgs e) { DataSet ds = DataAccess.GetDataSetBySql(\BookInfo.BookID,BookName,IssUBookID,IssDateTime from

IssueInfo,BookInfo where BookInfo.BookID=IssueInfo.BookID\); this.dgvIssInfo.DataSource = ds.Tables[0];

da = DataAccess.GetDataSetBySql(\); this.cboBookName.DataSource = da.Tables[0]; this.cboBookName.DisplayMember = \; this.cboBookName.ValueMember = \; }

private void btnExit_Click(object sender, EventArgs e) { this.Close(); }

private void cboBookName_SelectedIndexChanged(object sender, EventArgs e)

{ foreach (DataRow objRow in da.Tables[0].Rows) { if (string.Compare(cboBookName.Text, objRow[\].ToString(), true) == 0)

{ this.txtBookAccessCode.Text =

24

objRow[\].ToString();

this.txtAuthor.Text = objRow[\].ToString(); }}}

private void btnIssueBook_Click(object sender, EventArgs e) { int bookid =

Convert.ToInt32(this.cboBookName.SelectedValue);

int issid = Convert.ToInt32(this.txtIssID.Text); DateTime date =

Convert.ToDateTime(this.dateTimePicker1.Text);

string sql = string.Format(\values({0},{1},'{2}')\, bookid, issid, date); if (DataAccess.UpdateDataTable(sql)) { MessageBox.Show(\借阅成功\); }

DataSet data = DataAccess.GetDataSetBySql(\BookInfo.BookID,BookName,IssUBookID,IssDateTime from

IssueInfo,BookInfo where BookInfo.BookID=IssueInfo.BookID\); this.dgvIssInfo.DataSource = data.Tables[0]; }}}

25

参考文献

1 刘丽霞 等编著,零基础学 C#3.0. 北京：机械工业出版社，2009.3

2 刘辉 等编著,零基础学 SQL Server 2005. 北京：机械工业出版社，2008.1

26