///
public bool ReturnBook(string username,string bookid) {
bool flag1, flag2, flag3; //更新书籍状况为未被借阅
string sql1 = \否' where BookID=@bookid\; flag1 = Execsql(sql1,MakeParam(\,bookid)); //更新读者借书量减少一
string sql2 = \ReaderID=@username\;
flag2 = Execsql(sql2,MakeParam(\,username));
string sql3 = \是' where BookID=@bookid1 \; flag3 = Execsql(sql3,MakeParam(\,bookid)); return flag1 && flag2 && flag3; }
///
///
public DataSet SelectBook(bool a,bool b,bool c,bool d,string name, string publish, string writer, string sort) {
string sql = \否'\; if (a) {
sql += \; }
if (b) {
sql += \; }
if (c) {
sql += \; }
if (d) {
sql += \; }
DataSet ds =
GetDataSet(sql,MakeParam(\,name),MakeParam(\,publish),MakeParam(\,writer),MakeParam(\,sort));
return ds; }
///
/// 查询个人借阅信息 ///
///
32
public DataSet SelectBorrow(string username,string group) {
string sql = \; DataSet ds;
if (group == \管理员\) {
sql = @\
BorrowBook.ReaderID,BorrowBook.BookID,BorrowBook.BorrowDate,BorrowBook.ReturnDate,BorrowBook.OutTime,
book.BookName,book.BookWriter,book.BookPublish,book.BookPrice,book.BookSort
from BorrowBook left join book on BorrowBook.BookID=book.BookID \; ds = GetDataSet(sql); } else {
sql = @\
BorrowBook.ReaderID,BorrowBook.BookID,BorrowBook.BorrowDate,BorrowBook.ReturnDate,BorrowBook.OutTime,
book.BookName,book.BookWriter,book.BookPublish,book.BookPrice,book.BookSort
from BorrowBook left join book on BorrowBook.BookID=book.BookID where ReaderID=@username\;
ds = GetDataSet(sql, MakeParam(\, username)); }
return ds; }
}
公共类 Global类代码：
class Global {
///
public static string username { get; set; }
///
public static string usergroup { get; set; }
}
附录2
登录界面代码
public partial class Login : Form {
public Login() {
InitializeComponent();
}
33
SQLHelper sqlHelper = new SQLHelper();
private void button2_Click(object sender, EventArgs e) {
System.Diagnostics.Process.Start(\); //调用系统软键盘 }
private void button1_Click(object sender, EventArgs e) {
if (comboBox1.SelectedIndex == -1) {
MessageBox.Show(\请选择登录类别！\); return; }
if (comboBox2.SelectedIndex == -1 || textBox2.Text == string.Empty) {
MessageBox.Show(\请将用户名和密码输入完整！\); return; } try {
DataSet ds = sqlHelper.CheckUser(comboBox2.Text, textBox2.Text, comboBox1.Text); if (ds.Tables[0].Rows.Count > 0) {
Global.username = comboBox2.Text; Global.usergroup = comboBox1.Text; this.Hide();
Main main = new Main(); main.Show(); } else {
MessageBox.Show(\用户名或密码错误！\); return; } }
catch (Exception ex) {
MessageBox.Show(ex.Message); return; } }
private void comboBox1_MouseClick(object sender, MouseEventArgs e) {
try {
comboBox1.Items.Clear();
DataSet ds = sqlHelper.GetGroup(); if (ds.Tables[0].Rows.Count > 0) {
foreach (DataRow dr in ds.Tables[0].Rows) {
comboBox1.Items.Add(dr[\].ToString()); } } }
catch (Exception ex)
34
{
MessageBox.Show(ex.Message); return; } }
private void button3_Click(object sender, EventArgs e) {
this.Close();
Application.Exit(); }
private void comboBox2_MouseClick(object sender, MouseEventArgs e) {
try {
comboBox2.Items.Clear();
DataSet ds = sqlHelper.GetUserID(comboBox1.Text); if (ds.Tables[0].Rows.Count > 0) {
foreach (DataRow dr in ds.Tables[0].Rows) {
comboBox2.Items.Add(dr[\].ToString()); } } }
catch (Exception ex) {
MessageBox.Show(ex.Message); return; } }
private void textBox2_KeyDown(object sender, KeyEventArgs e) {
if (e.KeyCode == Keys.Enter) {
button1_Click(sender,e); } } }
主窗口代码：
public partial class Main : Form {
public Main() {
InitializeComponent(); }
///
/// 判断某个窗体是否已经打开 ///
/// /// ///
public bool OnlyOpen(string MdiChildrenClassName, string funtion) {
//遍历每一个MDI子窗体实例
35
foreach (Form childFrm in this.MdiChildren) {
//若子窗体的类型与实参相同,则存在该类的实例 if (childFrm.Name == MdiChildrenClassName) {
//若该窗体被最小化了,则显将其恢复到原来状态
if (childFrm.WindowState != FormWindowState.Maximized) {
childFrm.WindowState = FormWindowState.Maximized; }
childFrm.Activate(); return true; } }
return false; }
private void 用户管理ToolStripMenuItem_Click(object sender, EventArgs e) {
if (!OnlyOpen(\, \用户信息维护\)) {
UserManage usermanage = new UserManage(); usermanage.MdiParent = this; usermanage.Show();
usermanage.WindowState = FormWindowState.Maximized; } }
private void 退出系统ToolStripMenuItem_Click(object sender, EventArgs e) {
Application.Exit(); }
private void Main_Load(object sender, EventArgs e) {
toolStripStatusLabel1.Text += Global.usergroup; toolStripStatusLabel3.Text += Global.username; timer1.Enabled = true;
if (Global.usergroup != \管理员\) {
人员信息管理ToolStripMenuItem.Enabled = false; 图书信息管理ToolStripMenuItem.Enabled = false; } }
private void timer1_Tick(object sender, EventArgs e) {
toolStripStatusLabel6.Text = DateTime.Now.ToString(\); }
private void 读者管理ToolStripMenuItem_Click(object sender, EventArgs e) {
if (!OnlyOpen(\, \读者信息维护\)) {
ReaderManage readermanage = new ReaderManage(); readermanage.MdiParent = this; readermanage.Show();
readermanage.WindowState = FormWindowState.Maximized;
36