RFID图书管理系统程序源代码.doc

登陆界面using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;namespace Labrary public partial class FormLogin : Form public FormLogin() InitializeComponent(); / / 验证控?件t / / private bool ValidControl() if (this.tbID.Text = ) MessageBox.Show(请填写用户名！?); this.tbID.Focus(); return false; if (this.tbID.Text != admin) if (!UserManage.ObjUser.IsHasID(All.dbo, this.tbID.Text) MessageBox.Show(不存在此用户！?); this.tbID.Text = ; this.tbID.Focus(); return false; if (this.tbID.Text != admin) UserManage.ObjUser user= new UserManage.ObjUser(this.tbID.Text, All.dbo); if (user.PWD != this.tbPWD.Text) MessageBox.Show(密码错误！?); this.tbPWD.Text = ; this.tbPWD.Focus(); return false; else if (this.tbPWD.Text != 123456) MessageBox.Show(密码错误！ ); this.tbPWD.Text = ; this.tbPWD.Focus(); return false; return true; private void gbtnCancel_Click(object sender, EventArgs e) this.Close(); private void gbtnOK_Click(object sender, EventArgs e) /如?果?验证控?件t通过y if (ValidControl() if (this.tbID.Text != admin) All.userLogin = new UserManage.ObjUser(this.tbID.Text, All.dbo); else All.userLogin = new UserManage.ObjUser(All.dbo); All.userLogin.ID = admin; All.userLogin.Name = 管理员; this.DialogResult = DialogResult.OK; this.Close(); 主界面using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;namespace Labrary public partial class FormMain : Form public const int WM_USER = 0x0400; public const int WM_GETBUFFER_LOOP = WM_USER + 2; private RFID_dll.Reader rdr; private RFID_dll.RFID rfid; List rfids = new List(); int directionFlag = 0;/1进；出? FormInAndOut fiao = new FormInAndOut(); public FormMain() InitializeComponent(); this.rdr = new RFID_dll.Reader(); /this.rfid = new RFID_dll.RFID(rdr); private void FormMain_Load(object sender, EventArgs e) Init(); / / 初始化 / private void Init() fiao.StartPosition = FormStartPosition.Manual; /多窗体在不同时间显示 Screen screens = Screen.AllScreens; if (screens.Length = 2) List listScreen = new List(); foreach (Screen screen in Screen.AllScreens) if (screen.Primary = false) listScreen.Add(screen); fiao.Location = listScreen0.WorkingArea.Location; SetMenJin(PicIn); fiao.Show(); /toolStripStatusLabel2显示登陆用户名? toolStripStatusLabel2.Text = All.userLogin.Name; this.panel1.BackgroundImage = null; /菜单栏全部显示? this.用?户管理ToolStripMenuItem.Visible = true; this.系统3初?始?化CToolStripMenuItem.Visible = true; this.应|用?模式?ToolStripMenuItem.Visible = true; this.图?书管理ToolStripMenuItem.Visible = true; this.退?办卡ToolStripMenuItem.Visible = true; this.借阅?ToolStripMenuItem.Visible = true; this.门?禁?ToolStripMenuItem.Visible = true; SetPurview(); this.toolStrip1.Visible = false; this.toolStrip2.Visible = false; this.toolStrip3.Visible = false; /rfid.OpenSerial(); /是?否?找到?门?禁?设备? /if (rfid.ChangeWorkModel(2) / / rfid.StartInventory(this.Handle.ToInt32(),2); / / / 权限设置 / private void SetPurview() if (All.userLogin.ID = admin) this.应|用?模式?ToolStripMenuItem.Visible = false; else this.用户管理ToolStripMenuItem.Visible = false; this.系统初始化CToolStripMenuItem.Visible = false; this.读书管理ToolStripMenuItem.Visible = false; this.退办卡ToolStripMenuItem.Visible = false; this.借阅ToolStripMenuItem.Visible = false; this.门禁?ToolStripMenuItem.Visible = false; for (int i = 0; i All.userLogin.Purview.Count; i+) string purview = All.userLogin.Purviewi; if (purview = 1) this.图书管理ToolStripMenuItem.Visible = true; else if (purview = 2) this.办退卡ToolStripMenuItem.Visible = true; else if (purview = 3) this.借阅?ToolStripMenuItem.Visible = true; else if (purview = 4) this.门禁ToolStripMenuItem.Visible = true; private void 用户管理ToolStripMenuItem_Click(object sender, EventArgs e) UserManage.FormUserList ful = new UserManage.FormUserList(All.conn); ful.ShowDialog(); private void 修改密码?ToolStripMenuItem_Click(object sender, EventArgs e) UserManage.FormUserPwd fup = new UserManage.FormUserPwd(All.conn, All.userLogin); fup.ShowDialog(); private void tsbtnBookType_Click(object sender, EventArgs e) FormBookTypeList fbtl = new FormBookTypeList(); fbtl.ShowDialog(); private void tsbtnBookAdd_Click(object sender, EventArgs e) FormBookAdd fba = new FormBookAdd(); fba.ShowDialog(); private void tsbtnBookManage_Click(object sender, EventArgs e) FormBookInfoList fbil = new FormBookInfoList(); fbil.ShowDialog(); private void tsbtnBookStatistics_Click(object sender, EventArgs e) FormBookStatistics fbs = new FormBookStatistics(); fbs.ShowDialog(); private void 退?出?XToolStripMenuItem_Click(object sender, EventArgs e) this.Close(); private void tsbtnCardAdd_Click(object sender, EventArgs e) FormCardInfo fci = new FormCardInfo(1, new ObjCardInfo(); fci.ShowDialog(); private void tsbtnCardManage_Click(object sender, EventArgs e) FormCardList fcl = new FormCardList(); fcl.ShowDialog(); private void tsbtnAddTime_Click(object sender, EventArgs e) string rfid = RfidOperate.GetCard(); if (rfid = ) MessageBox.Show(请把借阅卡放到桌面读写器上！); else if (ObjCardInfo.IsHas(rfid) ObjCardInfo oci = new ObjCardInfo(rfid); FormCardInfo fci = new FormCardInfo(5, oci); fci.ShowDialog(); else MessageBox.Show(没有此借阅卡信息); private void tsbtnCardDelete_Click(object sender, EventArgs e) string rfid = RfidOperate.GetCard(); if (rfid = ) MessageBox.Show(请把借阅卡到读写器上?); else if (ObjCardInfo.IsHas(rfid) ObjCardInfo oci = new ObjCardInfo(rfid); int count = oci.NotReturnCount(); if (count = 0) if (MessageBox.Show(是否决定退卡！?, , MessageBoxButtons.YesNo) = DialogResult.Yes) oci.Delete(); MessageBox.Show(退卡成功|！?); else MessageBox.Show(oci.Name + 还有一本 + count.ToString() + 本书未归还不能退卡?); else MessageBox.Show(没有此借阅信息?); private void tsbtnJie_Click(object sender, EventArgs e) FormBookJie fbj = new FormBookJie(1); fbj.ShowDialog(); private void tsbtnHuan_Click(object sender, EventArgs e) FormBookHuan fbh = new FormBookHuan(); fbh.ShowDialog(); private void 图?书管理ToolStripMenuItem_Click(object sender, EventArgs e) this.toolStrip1.Visible = true; this.toolStrip2.Visible = false; this.toolStrip3.Visible = false; this.panel1.BackgroundImage = Image.FromFile(AppDomain.CurrentDomain.BaseDirectory + pic1.jpg); private void 退?办卡ToolStripMenuItem_Click(object sender, EventArgs e) this.toolStrip1.Visible = false; this.toolStrip2.Visible = true; this.toolStrip3.Visible = false; this.panel1.BackgroundImage = Image.FromFile(AppDomain.CurrentDomain.BaseDirectory + pic2.jpg); private void 借阅?ToolStripMenuItem_Click(object sender, EventArgs e) this.toolStrip1.Visible = false; this.toolStrip2.Visible = false; this.toolStrip3.Visible = true; this.panel1.BackgroundImage = Image.FromFile(AppDomain.CurrentDomain.BaseDirectory + pic3.jpg); private void 门?禁?ToolStripMenuItem_Click(object sender, EventArgs e) /MenJinInit(); /this.toolStrip1.Visible = false; /this.toolStrip2.Visible = false; /this.toolStrip3.Visible = false; /this.panel1.BackgroundImage = null; /rfid.OpenSerial(); /是否找到门禁设备? /if (rfid.IsOpen) / / rfid.StartInventory(this.Handle.ToInt32(); / private void 注销ToolStripMenuItem_Click(object sender, EventArgs e) All.userLogin = null; FormLogin fl = new FormLogin(); if (fl.ShowDialog() != DialogResult.OK) this.Close(); else Init(); private void 帮助ToolStripMenuItem1_Click(object sender, EventArgs e) private void 系统初始化CToolStripMenuItem_Click(object sender, EventArgs e) if (MessageBox.Show(是否初始化数据库?, , MessageBoxButtons.YesNo) = DialogResult.Yes) All.dbo.excuteSql(delete from lendtable); All.dbo.excuteSql(delete from bookinfo); All.dbo.excuteSql(delete from booktype); All.dbo.excuteSql(delete from librarycard); All.dbo.excuteSql(delete from usertable); MessageBox.Show(初始化完成?); private void 关于ToolStripMenuItem_Click(object sender, EventArgs e) FormAbout fa = new FormAbout(); fa.ShowDialog(); protected override void DefWndProc(ref System.Windows.Forms.Message m) if (m.Msg = WM_GETBUFFER_LOOP) /启动 if (this.timer1.Tag.ToString() = 0) this.timer1.Start(); this.timer1.Tag = 1; string uid = ; string direction = ; bool personWithMultCard = false; rdr.GetLoopGetBufferData(m, ref uid, ref direction, ref personWithMultCard); if (uid != 0000000000000000) /进 if (direction = In) this.directionFlag = 1; this.rfids.Add(uid); /出 if (direction = Out) this.directionFlag = 2; this.rfids.Add(uid); if (uid = FFFFFFFFFFFFFFFF) base.DefWndProc(ref m); private void timer1_Tick(object sender, EventArgs e) if (this.directionFlag = 1) for (int i = 0; i this.rfids.Count; i+) if (ObjCardInfo.IsHas(this.rfidsi) ObjCardInfo oci = new ObjCardInfo(this.rfidsi); if (oci.IsOverTime() SetMenJin(PicInOutTime); MenJinInit(); return; else SetMenJin(PicIn); MenJinInit(); return; SetMenJin(PicInNoCard); MenJinInit(); else if (this.directionFlag = 2) for (int i = 0; i this.rfids.Count; i+) if (ObjBookInfo.IsHas(this.rfidsi) ObjBookInfo obi = new ObjBookInfo(this.rfidsi); if (obi.LendStatus = 为借出?) this.rdr.WarningOutput(false, false, true, false, false); SetMenJin(PicOut); MenJinInit(); return; MenJinInit(); / / 门禁初始化 / private void MenJinInit() this.rfids.Clear(); this.directionFlag = 0; this.timer1.Tag = 0; this.timer1.Stop(); private void SetMenJin(string message) this.fiao.Controls.Clear(); UserControlMenJin ucmj = new UserControlMenJin(message); ucmj.Dock = DockStyle.Fill; this.fiao.Controls.Add(ucmj); private void FormMain_FormClosing(object sender, FormClosingEventArgs e) /this.rfid.StopInventory(); /this.rfid.CloseSerial(); 图书统计using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;namespace Labrary public partial class FormBookStatistics : Form private int boolShelf; public FormBookStatistics() InitializeComponent(); BindTreeView(); this.boolShelf = 0; BindListView(select RFID,BookType_ID,Name,Author,LendStatus,BookShelf from BookInfo); this.cboBookLendStatus.SelectedIndex = 0; private void BindTreeView() this.treeView1.Nodes.Clear(); TreeNode nodeRoot = new TreeNode(); nodeRoot.Text = 全部书架; this.treeView1.Nodes.Add(nodeRoot); for (int i = 0; i 4; i+) TreeNode nodeChild = new TreeNode(); if (i = 0) nodeChild.Text = 第一书架; if (i = 1) nodeChild.Text = 第二书架; if (i = 2) nodeChild.Text = 第三书架; if (i = 3) nodeChild.Text = 第四书架; nodeRoot.Nodes.Add(nodeChild); nodeRoot.Expand(); private void BindListView(string sql) this.listView1.Items.Clear(); this.listView1.Columns.Clear(); string headerText = new string 标签,100, 所属分类,100, 书名,150, 作者,80, 借阅状态,80, 所在书架,80 ; for (int i = 0; i headerText.Length; i+) ColumnHeader header = new ColumnHeader(); string headerName = headerTexti.Split(,)0; int headerWidth = Convert.ToInt32(headerTexti.Split(,)1); header.Text = headerName; header.Width = headerWidth; this.listView1.Columns.Add(header); DataTable dtb = All.dbo.getDataTable(sql); for (int i = 0; i dtb.Rows.Count; i+) ObjBookInfo bookInfo = new ObjBookInfo(dtb.RowsiRFID.ToString(); ListViewItem item = new ListViewItem(new string bookInfo.RFID, bookInfo.BookType.Name, bookInfo.Name, bookInfo.Author, bookInfo.LendStatus, bookInfo.BookShelf ); this.listView1.Items.Add(item); ListViewItem itemCount = new ListViewItem(new string 统3计?, , , , , dtb.Rows.Count.ToString() + 本? ); this.listView1.Items.Add(it