RFID圖書(shū)管理系統(tǒng)程序源代碼.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(); / / 驗(yàn)證控?件t / / private bool ValidControl() if (this.tbID.Text = ) MessageBox.Show(請(qǐng)?zhí)顚懹脩裘?); 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(密碼錯(cuò)誤！?); this.tbPWD.Text = ; this.tbPWD.Focus(); return false; else if (this.tbPWD.Text != 123456) MessageBox.Show(密碼錯(cuò)誤！ ); 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) /如?果?驗(yàn)證控?件t通過(guò)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進(jìn)；出? 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; /多窗體在不同時(shí)間顯示 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.系統(tǒng)3初?始?化CToolStripMenuItem.Visible = true; this.應(yīng)|用?模式?ToolStripMenuItem.Visible = true; this.圖?書(shū)管理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(); /是?否?找到?門?禁?設(shè)備? /if (rfid.ChangeWorkModel(2) / / rfid.StartInventory(this.Handle.ToInt32(),2); / / / 權(quán)限設(shè)置 / private void SetPurview() if (All.userLogin.ID = admin) this.應(yīng)|用?模式?ToolStripMenuItem.Visible = false; else this.用戶管理ToolStripMenuItem.Visible = false; this.系統(tǒng)初始化CToolStripMenuItem.Visible = false; this.讀書(shū)管理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.圖書(shū)管理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(請(qǐng)把借閱卡放到桌面讀寫器上！); else if (ObjCardInfo.IsHas(rfid) ObjCardInfo oci = new ObjCardInfo(rfid); FormCardInfo fci = new FormCardInfo(5, oci); fci.ShowDialog(); else MessageBox.Show(沒(méi)有此借閱卡信息); private void tsbtnCardDelete_Click(object sender, EventArgs e) string rfid = RfidOperate.GetCard(); if (rfid = ) MessageBox.Show(請(qǐng)把借閱卡到讀寫器上?); 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() + 本書(shū)未歸還不能退卡?); else MessageBox.Show(沒(méi)有此借閱信息?); 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 圖?書(shū)管理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(); /是否找到門禁設(shè)備? /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 系統(tǒng)初始化CToolStripMenuItem_Click(object sender, EventArgs e) if (MessageBox.Show(是否初始化數(shù)據(jù)庫(kù)?, , 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 關(guān)于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) /啟動(dòng) 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) /進(jìn) 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(); 圖書(shū)統(tǒng)計(jì)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 = 全部書(shū)架; this.treeView1.Nodes.Add(nodeRoot); for (int i = 0; i 4; i+) TreeNode nodeChild = new TreeNod