RFID图书管理方案计划系统程序源代码

.\登陆界面usingSystem;usingSystem.Collections.Generic;感谢阅读usingSystem.ComponentModel;谢谢阅读usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;谢谢阅读namespaceLabrary{publicpartialclassFormLogin:Form感谢阅读{publicFormLogin(){InitializeComponent();}<summary>验¨¦证¡è控?件t</summary><returns></returns>privateboolValidControl()感谢阅读{if(this.tbID.Text==""){MessageBox.Show("请填写用户名！ê?");this.tbID.Focus();感谢阅读returnfalse;}if(this.tbID.Text!="admin")谢谢阅读{if(!UserManage.ObjUser.IsHasID(All.dbo,this.tbID.Text))感谢阅读{MessageBox.Show("不存在此用户！ê?");感谢阅读this.tbID.Text="";this.tbID.Focus();returnfalse;}}if(this.tbID.Text!="admin")精品文档放心下载.\{UserManage.ObjUseruser=newUserManage.ObjUser(this.tbID.Text,All.dbo);精品文档放心下载if(user.PWD!=this.tbPWD.Text)谢谢阅读{MessageBox.Show("密码错误！ê?");感谢阅读this.tbPWD.Text="";this.tbPWD.Focus();returnfalse;}}else{if(this.tbPWD.Text!="123456")感谢阅读{MessageBox.Show("密码错误！");感谢阅读this.tbPWD.Text="";this.tbPWD.Focus();returnfalse;}}returntrue;}privatevoidgbtnCancel_Click(objectsender,EventArgse)谢谢阅读{this.Close();}privatevoidgbtnOK_Click(objectsender,EventArgse)精品文档放心下载{//如¨?果?验¨¦证¡è控?件t通ª¡§过yif(ValidControl()){if(this.tbID.Text!="admin")谢谢阅读{All.userLogin=newUserManage.ObjUser(this.tbID.Text,All.dbo);精品文档放心下载}else{All.userLogin=newUserManage.ObjUser(All.dbo);精品文档放心下载All.userLogin.ID="admin";谢谢阅读.\All.userLogin.Name="管理员";谢谢阅读}this.DialogResult=DialogResult.OK;谢谢阅读this.Close();}}}}主界面usingSystem;usingSystem.Collections.Generic;感谢阅读usingSystem.ComponentModel;谢谢阅读usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;感谢阅读namespaceLabrary{publicpartialclassFormMain:Form感谢阅读{publicconstintWM_USER=0x0400;谢谢阅读publicconstintWM_GETBUFFER_LOOP=WM_USER+2;感谢阅读privateRFID_dll.Readerrdr;精品文档放心下载privateRFID_dll.RFIDrfid;精品文档放心下载List<string>rfids=newList<string>();谢谢阅读intdirectionFlag=0;//1进；出?感谢阅读FormInAndOutfiao=newFormInAndOut();精品文档放心下载publicFormMain(){InitializeComponent();this.rdr=newRFID_dll.Reader();谢谢阅读//this.rfid=newRFID_dll.RFID(rdr);谢谢阅读}privatevoidFormMain_Load(objectsender,EventArgse)感谢阅读{.\Init();}<summary>初始化</summary>privatevoidInit()谢谢阅读{fiao.StartPosition=FormStartPosition.Manual;谢谢阅读//多窗体在不同时间显示Screen[]screens=Screen.AllScreens;谢谢阅读if(screens.Length==2){List<Screen>listScreen=newList<Screen>();精品文档放心下载foreach(ScreenscreeninScreen.AllScreens)感谢阅读{if(screen.Primary==false)谢谢阅读{listScreen.Add(screen);}}fiao.Location=listScreen[0].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);谢谢阅读//}}<summary>权限设置</summary>privatevoidSetPurview(){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(inti=0;i<All.userLogin.Purview.Count;i++)感谢阅读{stringpurview=All.userLogin.Purview[i];精品文档放心下载if(purview=="1"){this.图书管理¨ªToolStripMenuItem.Visible=true;感谢阅读}elseif(purview=="2"){this.办退卡¡§ToolStripMenuItem.Visible=true;精品文档放心下载}.\elseif(purview=="3"){this.借阅?ToolStripMenuItem.Visible=true;精品文档放心下载}elseif(purview=="4"){this.门禁ToolStripMenuItem.Visible=true;感谢阅读}}}}privatevoid用户管理¨ªToolStripMenuItem_Click(objectsender,EventArgse)谢谢阅读{UserManage.FormUserListful=newUserManage.FormUserList(All.conn);ful.ShowDialog();谢谢阅读}privatevoid修改密码?ToolStripMenuItem_Click(objectsender,EventArgse)谢谢阅读{UserManage.FormUserPwdfup=newUserManage.FormUserPwd(All.conn,All.userLogin);谢谢阅读fup.ShowDialog();}privatevoidtsbtnBookType_Click(objectsender,EventArgse)谢谢阅读{FormBookTypeListfbtl=newFormBookTypeList();谢谢阅读fbtl.ShowDialog();}privatevoidtsbtnBookAdd_Click(objectsender,EventArgse)感谢阅读{FormBookAddfba=newFormBookAdd();谢谢阅读fba.ShowDialog();}privatevoidtsbtnBookManage_Click(objectsender,EventArgse)精品文档放心下载{FormBookInfoListfbil=newFormBookInfoList();感谢阅读fbil.ShowDialog();}privatevoidtsbtnBookStatistics_Click(objectsender,EventArgse)感谢阅读.\{FormBookStatisticsfbs=newFormBookStatistics();精品文档放心下载fbs.ShowDialog();}privatevoid退ª?出?XToolStripMenuItem_Click(objectsender,EventArgse)谢谢阅读{this.Close();}privatevoidtsbtnCardAdd_Click(objectsender,EventArgse)精品文档放心下载{FormCardInfofci=newFormCardInfo(1,newObjCardInfo());fci.ShowDialog();感谢阅读}privatevoidtsbtnCardManage_Click(objectsender,EventArgse)谢谢阅读{FormCardListfcl=newFormCardList();感谢阅读fcl.ShowDialog();}privatevoidtsbtnAddTime_Click(objectsender,EventArgse)谢谢阅读{stringrfid=RfidOperate.GetCard();谢谢阅读if(rfid==""){MessageBox.Show("请把借阅卡放到桌面读写器上！");感谢阅读}else{if(ObjCardInfo.IsHas(rfid))感谢阅读{ObjCardInfooci=newObjCardInfo(rfid);谢谢阅读FormCardInfofci=newFormCardInfo(5,oci);感谢阅读fci.ShowDialog();}else{MessageBox.Show("没有此借阅卡信息");谢谢阅读}}}.\privatevoidtsbtnCardDelete_Click(objectsender,EventArgse)谢谢阅读{stringrfid=RfidOperate.GetCard();谢谢阅读if(rfid==""){MessageBox.Show("请把借阅卡到读写器上?");感谢阅读}else{if(ObjCardInfo.IsHas(rfid))谢谢阅读{ObjCardInfooci=newObjCardInfo(rfid);谢谢阅读intcount=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("没有此借阅信息?");感谢阅读}}}privatevoidtsbtnJie_Click(objectsender,EventArgse)谢谢阅读{FormBookJiefbj=newFormBookJie(1);感谢阅读fbj.ShowDialog();}privatevoidtsbtnHuan_Click(objectsender,EventArgse)感谢阅读.\{FormBookHuanfbh=newFormBookHuan();精品文档放心下载fbh.ShowDialog();}privatevoid图ª?书º¨¦管¨¹理¤¨ªToolStripMenuItem_Click(objectsender,EventArgse)感谢阅读{this.toolStrip1.Visible=true;感谢阅读this.toolStrip2.Visible=false;谢谢阅读this.toolStrip3.Visible=false;精品文档放心下载this.panel1.BackgroundImage=感谢阅读Image.FromFile(AppDomain.CurrentDomain.BaseDirectory+"\\pic\\1.jpg");精品文档放心下载}privatevoid退ª?办㨬卡¡§ToolStripMenuItem_Click(objectsender,EventArgse)精品文档放心下载{this.toolStrip1.Visible=false;谢谢阅读this.toolStrip2.Visible=true;精品文档放心下载this.toolStrip3.Visible=false;感谢阅读this.panel1.BackgroundImage=感谢阅读Image.FromFile(AppDomain.CurrentDomain.BaseDirectory+"\\pic\\2.jpg");感谢阅读}privatevoid借¨¨阅?ToolStripMenuItem_Click(objectsender,EventArgse)感谢阅读{this.toolStrip1.Visible=false;感谢阅读this.toolStrip2.Visible=false;感谢阅读this.toolStrip3.Visible=true;精品文档放心下载this.panel1.BackgroundImage=感谢阅读Image.FromFile(AppDomain.CurrentDomain.BaseDirectory+"\\pic\\3.jpg");精品文档放心下载}privatevoid门?禁?ToolStripMenuItem_Click(objectsender,EventArgse)精品文档放心下载{//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());精品文档放心下载//}}privatevoid注销²ToolStripMenuItem_Click(objectsender,EventArgse)谢谢阅读{All.userLogin=null;FormLoginfl=newFormLogin();谢谢阅读if(fl.ShowDialog()!=DialogResult.OK)感谢阅读{this.Close();}else{Init();}}privatevoid帮助¨²ToolStripMenuItem1_Click(objectsender,EventArgse)谢谢阅读{}privatevoid系统初始化¡¥CToolStripMenuItem_Click(objectsender,EventArgse)感谢阅读{if(MessageBox.Show("是否初始化数据库?","",MessageBoxButtons.YesNo)==DialogResult.Yes)谢谢阅读{All.dbo.excuteSql("deletefromlendtable");感谢阅读All.dbo.excuteSql("deletefrombookinfo");精品文档放心下载All.dbo.excuteSql("deletefrombooktype");精品文档放心下载All.dbo.excuteSql("deletefromlibrarycard");精品文档放心下载All.dbo.excuteSql("deletefromusertable");精品文档放心下载MessageBox.Show("初始化完成?");感谢阅读}}privatevoid关于ToolStripMenuItem_Click(objectsender,EventArgse)谢谢阅读{.\FormAboutfa=newFormAbout();感谢阅读fa.ShowDialog();}protectedoverridevoidDefWndProc(refSystem.Windows.Forms.Messagem)精品文档放心下载{if(m.Msg==WM_GETBUFFER_LOOP)谢谢阅读{//启动if(this.timer1.Tag.ToString()=="0")谢谢阅读{this.timer1.Start();this.timer1.Tag="1";}stringuid="";stringdirection="";boolpersonWithMultCard=false;rdr.GetLoopGetBufferData(m,refuid,refdirection,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(refm);}privatevoidtimer1_Tick(objectsender,EventArgse)谢谢阅读{if(this.directionFlag==1)精品文档放心下载{for(inti=0;i<this.rfids.Count;i++)精品文档放心下载{if(ObjCardInfo.IsHas(this.rfids[i]))谢谢阅读{ObjCardInfooci=newObjCardInfo(this.rfids[i]);谢谢阅读if(oci.IsOverTime()){SetMenJin("PicInOutTime");感谢阅读MenJinInit();return;}else{SetMenJin("PicIn");MenJinInit();return;}}}SetMenJin("PicInNoCard");MenJinInit();}elseif(this.directionFlag==2)谢谢阅读{for(inti=0;i<this.rfids.Count;i++)谢谢阅读{if(ObjBookInfo.IsHas(this.rfids[i]))感谢阅读{ObjBookInfoobi=newObjBookInfo(this.rfids[i]);精品文档放心下载if(obi.LendStatus=="为借出?")谢谢阅读{.\this.rdr.WarningOutput(false,false,true,false,false);感谢阅读SetMenJin("PicOut");MenJinInit();return;}}}MenJinInit();}}///<summary>///门禁初始化///</summary>privatevoidMenJinInit(){this.rfids.Clear();this.directionFlag=0;this.timer1.Tag="0";this.timer1.Stop();}privatevoidSetMenJin(stringmessage)感谢阅读{this.fiao.Controls.Clear();感谢阅读UserControlMenJinucmj=newUserControlMenJin(message);精品文档放心下载ucmj.Dock=DockStyle.Fill;谢谢阅读this.fiao.Controls.Add(ucmj);感谢阅读}privatevoidFormMain_FormClosing(objectsender,FormClosingEventArgse)感谢阅读{//this.rfid.StopInventory();谢谢阅读//this.rfid.CloseSerial();精品文档放心下载}}}图书统计usingSystem;.\usingSystem.Collections.Generic;精品文档放心下载usingSystem.ComponentModel;谢谢阅读usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;谢谢阅读namespaceLabrary{publicpartialclassFormBookStatistics:Form谢谢阅读{privateintboolShelf;publicFormBookStatistics()谢谢阅读{InitializeComponent();BindTreeView();this.boolShelf=0;BindListView("selectRFID,BookType_ID,Name,Author,LendStatus,BookShelffrom精品文档放心下载BookInfo");this.cboBookLendStatus.SelectedIndex=0;精品文档放心下载}privatevoidBindTreeView()感谢阅读{this.treeView1.Nodes.Clear();精品文档放心下载TreeNodenodeRoot=newTreeNode();精品文档放心下载nodeRoot.Text="全部书架¹";this.treeView1.Nodes.Add(nodeRoot);感谢阅读for(inti=0;i<4;i++)精品文档放心下载{TreeNodenodeChild=newTreeNode();感谢阅读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();}privatevoidBindListView(stringsql)精品文档放心下载{this.listView1.Items.Clear();精品文档放心下载this.listView1.Columns.Clear();感谢阅读string[]headerText=newstring[]{"标签,100","所属分类¤¨¤,100","书名,150","作者,80","借阅状态,80","所在书架,80"};谢谢阅读for(inti=0;i<headerText.Length;i++)谢谢阅读{ColumnHeaderheader=newColumnHeader();谢谢阅读stringheaderName=headerText[i].Split(',')[0];精品文档放心下载intheaderWidth=Convert.ToInt32(headerText[i].Split(',')[1]);感谢阅读header.Text=headerName;header.Width=headerWidth;感谢阅读this.listView1.Columns.Add(header);感谢阅读}DataTabledtb=All.dbo.getDataTable(sql);谢谢阅读for(inti=0;i<dtb.Rows.Count;i++)感谢阅读{ObjBookInfobookInfo=newObjBookInfo(dtb.Rows[i]["RFID"].ToString());感谢阅读ListViewItemitem=newListViewItem(newstring[]{bookInfo.RFID,谢谢阅读.\bookInfo.BookType.Name,bookInfo.Name,bookInfo.Author,bookInfo.LendStatus,bookInfo.BookShelf});精品文档放心下载this.listView1.Items.Add(item);精品文档放心下载}ListViewItemitemCount=newListViewItem(newstring[]{"统ª3计?","","","","",dtb.Rows.Count.ToString()+"本À?"});谢谢阅读this.listView1.Items.Add(itemCount);谢谢阅读}privatevoidtreeView1_NodeMouseClick(objectsender,TreeNodeMouseClickEventArgs精品文档放心下载e){if(e.Node.Text=="全部书架¨¹")感谢阅读{this.boolShelf=0;BindListView(string.Format("select精品文档放心下载RFID,BookType_ID,Name,Author,LendStatus,BookShelffromBookInfo"));感谢阅读}if(e.Node.Text=="第一书架¨¹")精品文档放心下载{this.boolShelf=1;BindListView(string.Format("select谢谢阅读RFID,BookType_ID,Name,Author,LendStatus,BookShelffromBookInfowhereBookShelf='1'"));感谢阅读}if(e.Node.Text=="第二书架¨¹")感谢阅读{this.boolShelf=2;BindListView(string.Format("select精品文档放心下载RFID,BookType_ID,Name,Author,LendStatus,BookShelffromBookInfowhereBookShelf='2'"));感谢阅读}if(e.Node.Text=="第三书架¨¹")感谢阅读{this.boolShelf=3;BindListView(string.Format("select感谢阅读RFID,BookType_ID,Name,Author,LendStatus,BookShelffromBookInfowhereBookShelf='3'"));感谢阅读}if(e.Node.Text=="第四书架¨¹")谢谢阅读{this.boolShelf=4;BindListView(string.Format("select谢谢阅读RFID,BookType_ID,Name,Author,LendStatus,BookShelffromBookInfowhereBookShelf='4'"));感谢阅读}.\}privatevoidtoolStripComboBox1_SelectedIndexChanged(objectsender,EventArgse)感谢阅读{if(this.boolShelf==0){if(this.cboBookLendStatus.SelectedIndex==0)感谢阅读{BindListView(string.Format("selectRFID,BookType_ID,Name,Author,LendStatus,BookShelffromBookInfo"));谢谢阅读}if(this.cboBookLendStatus.SelectedIndex==1)感谢阅读{BindListView(string.Format("select感谢阅读RFID,BookType_ID,Name,Author,LendStatus,BookShelffromBookInfowhereLendStatus='1'"));谢谢阅读}if(this.cboBookLendStatus.SelectedIndex==2)感谢阅读{BindListView(string.Format("select感谢阅读RFID,BookType_ID,Name,Author,LendStatus,BookShelffromBookInfowhereLendStatus='0'"));感谢阅读}}if(this.boolShelf>0){if(this.cboBookLendStatus.SelectedIndex==0)精品文档放心下载{BindListView(string.Format("select谢谢阅读RFID,BookType_ID,Name,Author,LendStatus,BookShelffromBookInfowhereBookShelf='{0}'",谢谢阅读this.boolShelf.ToString()));感谢阅读}if(this.cboBookLendStatus.SelectedIndex==1)感谢阅读{BindListView(string.Format("select精品文档放心下载RFID,BookType_ID,Name,Author,LendStatus,BookShelffromBookInfowhereBookShelf='{0}'and精品文档放心下载LendStatus='1'",this.boolShelf.ToString()));感谢阅读}if(this.cboBookLendStatus.SelectedIndex==2)谢谢阅读{BindListView(string.Format("select精品文档放心下载RFID,BookType_ID,Name,Author,LendStatus,BookShelffromBookInfowhereBookShelf='{0}'and谢谢阅读LendStatus='0'",this.boolShelf.ToString()));精品文档放心下载}}}.\}}借阅卡管理usingSystem;usingSystem.Collections.Generic;感谢阅读usingSystem.ComponentModel;感谢阅读usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;感谢阅读namespaceLabrary{publicpartialclassFormCardList:Form谢谢阅读{publicFormCardList(){InitializeComponent();SetListView();}privatevoidSetListView()感谢阅读{this.listView1.Items.Clear();谢谢阅读List<ObjCardInfo>listCard=ObjCardInfo.GetAllCard();for(inti=0;i<listCard.Count;i++){精品文档放心下载ObjCardInfooci=listCard[i];谢谢阅读ListViewItemitem=newListViewItem(oci.Rfid);感谢阅读item.Tag=oci;ListViewItem.ListViewSubItemsubitem1=newListViewItem.ListViewSubItem();谢谢阅读subitem1.Text=oci.Name;item.SubItems.Add(subitem1);谢谢阅读ListViewItem.ListViewSubItemsubitem2=newListViewItem.ListViewSubItem();感谢阅读subitem2.Text=oci.Sex;item.SubItems.Add(subitem2);感谢阅读.\ListViewItem.ListViewSubItemsubitem3=newListViewItem.ListViewSubItem();谢谢阅读subitem3.Text=oci.Brithday.ToString("yyyy年¨ºMM月?dd日¨?");item.SubItems.Add(subitem3);谢谢阅读ListViewItem.ListViewSubItemsubitem4=newListViewItem.ListViewSubItem();感谢阅读subitem4.Text=oci.SID;item.SubItems.Add(subitem4);谢谢阅读ListViewItem.ListViewSubItemsubitem5=newListViewItem.ListViewSubItem();感谢阅读subitem5.Text=oci.StartTime.ToString();精品文档放心下载item.SubItems.Add(subitem5);谢谢阅读ListViewItem.ListViewSubItemsubitem6=newListViewItem.ListViewSubItem();精品文档放心下载subitem6.Text=oci.EndTime.ToString();谢谢阅读item.SubItems.Add(subitem6);感谢阅读ListViewItem.ListViewSubItemsubitem7=newListViewItem.ListViewSubItem();精品文档放心下载subitem7.Text=oci.User.Name;感谢阅读item.SubItems.Add(subitem7);感谢阅读this.listView1.Items.Add(item);精品文档放心下载}}privatevoidSetListView(List<ObjCardInfo>listCard)谢谢阅读{this.listView1.Items.Clear();精品文档放心下载for(inti=0;i<listCard.Count;i++)精品文档放心下载{ObjCardInfooci=listCard[i];感谢阅读ListViewItemitem=newListViewItem(oci.Rfid);谢谢阅读item.Tag=oci;ListViewItem.ListViewSubItemsubitem1=newListViewItem.ListViewSubItem();谢谢阅读subitem1.Text=oci.Name;.\item.SubItems.Add(subitem1);精品文档放心下载ListViewItem.ListViewSubItemsubitem2=newListViewItem.ListViewSubItem();精品文档放心下载subitem2.Text=oci.Sex;item.SubItems.Add(subitem2);感谢阅读ListViewItem.ListViewSubItemsubitem3=newListViewItem.ListViewSubItem();感谢阅读subitem3.Text=oci.Brithday.ToString("yyyy年¨ºMM月?dd日¨?");item.SubItems.Add(subitem3);精品文档放心下载ListViewItem.ListViewSubItemsubitem4=newListViewItem.ListViewSubItem();感谢阅读subitem4.Text=oci.SID;item.SubItems.Add(subitem4);精品文档放心下载ListViewItem.ListViewSubItemsubitem5=newListViewItem.ListViewSubItem();感谢阅读subitem5.Text=oci.StartTime.ToString();感谢阅读item.SubItems.Add(subitem5);感谢阅读ListViewItem.ListViewSubItemsubitem6=newListViewItem.ListViewSubItem();精品文档放心下载subitem6.Text=oci.EndTime.ToString();感谢阅读item.SubItems.Add(subitem6);精品文档放心下载ListViewItem.ListViewSubItemsubitem7=newListViewItem.ListViewSubItem();感谢阅读subitem7.Text=oci.User.Name;精品文档放心下载item.SubItems.Add(subitem7);谢谢阅读this.listView1.Items.Add(item);精品文档放心下载}}privatevoidtsbtnExit_Click(objectsender,EventArgse)精品文档放心下载{this.Close();}privatevoidtsbtnInsert_Click(objectsender,EventArgse)感谢阅读{FormCardInfofci=newFormCardInfo(1,newObjCardInfo());谢谢阅读.\if(fci.ShowDialog()==DialogResult.OK)精品文档放心下载{SetListView();IsEnabled(false);}}privatevoidIsEnabled(boolEnabled)谢谢阅读{//this.tsbtnAddTime.Enabled=Enabled;谢谢阅读this.tsbtnUpdate.Enabled=Enabled;谢谢阅读this.tsbtnDelete.Enabled=Enabled;感谢阅读this.tsbtnRecord.Enabled=Enabled;谢谢阅读}privatevoidlistView1_SelectedIndexChanged(objectsender,EventArgse)感谢阅读{if(this.listView1.SelectedItems.Count>0)感谢阅读{IsEnabled(true);}else{IsEnabled(false);}}privatevoidtsbtnAddTime_Click(objectsender,EventArgse)精品文档放心下载{if(this.listView1.SelectedItems.Count>0)精品文档放心下载{ObjCardInfooci=this.listView1.SelectedItems[0].TagasObjCardInfo;FormCardInfofci=newFormCardInfo(5,oci);精品文档放心下载if(fci.ShowDialog()==DialogResult.OK)感谢阅读{SetListView();IsEnabled(false);}}}privatevoidtsbtnUpdate_Click(objectsender,EventArgse)谢谢阅读{if(this.listView1.SelectedItems.Count>0)感谢阅读.\{ObjCardInfooci=this.listView1.SelectedItems[0].TagasObjCardInfo;FormCardInfofci=newFormCardInfo(3,oci);谢谢阅读if(fci.ShowDialog()==DialogResult.OK)感谢阅读{SetListView();IsEnabled(false);}}}privatevoidtsbtnQuery_Click(objectsender,EventArgse)感谢阅读{if(this.tstbTj.Text!="")精品文档放心下载{if(IsNumber()){stringsql=string.Format("selectrfidfromlibrarycardwhererfidlike'%{0}%'orderbyendtimeasc",this.tstbTj.Text);感谢阅读SetListView(ObjCardInfo.GetAllCard(sql));精品文档放心下载}else{stringsql=string.Format("selectrfidfromlibrarycardwherenamelike'%{0}%'orderbyendtimeasc",this.tstbTj.Text);谢谢阅读SetListView(ObjCardInfo.GetAllCard(sql));谢谢阅读}}else{SetListView();}}privateboolIsNumber(){try{Convert.ToInt64(this.tstbTj.Text);精品文档放心下载returntrue;}catch{returnfalse;.\}}privatevoidtsbtnRecord_Click(objectsender,EventArgse)感谢阅读{if(this.listView1.SelectedItems.Count>0)精品文档放心下载{FormCardRecordfcr=newFormCardRecord(this.listView1.SelectedItems[0].TagasObjCardInfo);谢谢阅读fcr.ShowDialog();}}privatevoidtsbtnDelete_Click(objectsender,EventArgse)精品文档放心下载{if(this.listView1.SelectedItems.Count>0)精品文档放心下载{ObjCardInfooci=this.listView1.SelectedItems[0].TagasObjCardInfo;精品文档放心下载intcount=oci.NotReturnCount();谢谢阅读if(count==0){if(MessageBox.Show("是非决定退卡?","",MessageBoxButtons.YesNo)==感谢阅读DialogResult.Yes){oci.Delete();SetListView();IsEnabled(false);}}else{MessageBox.Show(oci.Name+"还1有®D"+count.ToString()+"本书未换精品文档放心下载不能退卡！ê?");}}}}}借阅卡信息usingSystem;usingSystem.Collections.Generic;感谢阅读.\usingSystem.ComponentModel;谢谢阅读usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;谢谢阅读namespaceLabrary{publicpartialclassFormCardInfo:Form谢谢阅读{ObjCardInfooci;intflag;publicFormCardInfo(){InitializeComponent();}publicFormCardInfo(intflag,ObjCardInfooci)精品文档放心下载{InitializeComponent();this.oci=oci;this.flag=flag;SetControl();Init();}privatevoidInit(){//续期if(this.flag==5){this.gbtnReadCard.Enabled=false;谢谢阅读this.tbName.Enabled=false;精品文档放心下载this.rbtn0.Enabled=false;精品文档放心下载this.rbtn1.Enabled=false;谢谢阅读this.dtpBrithday.Enabled=false;谢谢阅读this.tbSID.Enabled=false;精品文档放心下载this.dtpStartTime.Enabled=false;感谢阅读}}privatevoidSetControl(){.\this.tbRFID.Text=this.oci.Rfid;感谢阅读this.tbName.Text=this.oci.Name;精品文档放心下载if(this.oci.Sex=="男"){this.rbtn1.Checked=true;感谢阅读}else{this.rbtn0.Checked=false;感谢阅读}this.dtpBrithday.Value=this.oci.Brithday;精品文档放心下载this.tbSID.Text=this.oci.SID;精品文档放心下载this.dtpStartTime.Value=this.oci.StartTime;感谢阅读this.dtpEndTime.Value=this.oci.EndTime;感谢阅读if(this.flag!=1){this.tbUser.Text=this.oci.User.Name;谢谢阅读this.tbUser.Tag=this.oci.User;谢谢阅读}else{this.tbUser.Text=All.userLogin.Name;感谢阅读this.tbUser.Tag=All.userLogin;感谢阅读}}privateboolValidControl()谢谢阅读{if(this.tbRFID.Text=="")感谢阅读{MessageBox.Show("请读卡?");this.gbtnReadCard.Focus();感谢阅读returnfalse;}if(this.tbName.Text=="")感谢阅读{MessageBox.Show("请填写姓名?");精品文档放心下载this.tbName.Focus();returnfalse;}returntrue;}.\privatevoidGetControl(){this.oci.Rfid=this.tbRFID.Text;谢谢阅读this.oci.Name=this.tbName.Text;谢谢阅读if(this.rbtn0.Checked){this.oci.Sex="女?";}elseif(this.rbtn1.Checked)感谢阅读{this.oci.Sex="男D";}this.oci.Brithday=this.dtpBrithday.Value;精品文档放心下载this.oci.SID=this.tbSID.Text;精品文档放心下载this.oci.StartTime=this.dtpStartTime.Value;精品文档放心下载this.oci.EndTime=this.dtpEndTime.Value;谢谢阅读this.oci.User=this.tbUser.TagasUserManage.ObjUser;感谢阅读}privatevoidgbtnCancel_Click(objectsender,EventArgse)感谢阅读{this.Close();}privatevoidbtnReadCard_Click(objectsender,EventArgse)精品文档放心下载{}privatevoidgbtnOK_Click(objectsender,EventArgse)感谢阅读{if(ValidControl()){GetControl();if(this.flag==1){if(this.oci.IsHas()){MessageBox.Show("此借阅卡未退卡?");感谢阅读this.Close();}else{this.oci.Insert();.\this.DialogResult=DialogResult.OK;精品文档放心下载this.Close();}}elseif(this.flag==3){this.oci.Update();this.DialogResult=DialogResult.OK;谢谢阅读this.Close();}elseif(this.flag==4){}elseif(this.flag==5){this.oci.Update();this.DialogResult=DialogResult.OK;精品文档放心下载this.Close();}}}privatevoidgbtnReadCard_Click(objectsender,EventArgse)感谢阅读{stringrfidNumber= RfidOperate.GetRfid();谢谢阅读if(rfidNumber==""){MessageBox.Show("未读到借阅卡?");感谢阅读this.tbRFID.Text="";}else{this.tbRFID.Text=rfidNumber;感谢阅读}}}}借阅记录usingSystem;usingSystem.Collections.Generic;精品文档放心下载usingSystem.ComponentModel;感谢阅读.\usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;谢谢阅读namespaceLabrary{publicpartialclassFormCardRecord:Form精品文档放心下载{ObjCardInfooci;publicFormCardRecord(){InitializeComponent();}publicFormCardRecord(ObjCardInfooci)精品文档放心下载{InitializeComponent();this.oci=oci;this.Text=this.Text+"-"+this.oci.Name;精品文档放心下载SetListView();}privatevoidSetListView()谢谢阅读{stringsql=string.Format("selectbookinfo_rfid,lendtime,returntimefromlendtablewherelibrarycard_rfid='{0}'orderbylendtimedesc",this.oci.Rfid);精品文档放心下载DataTabledt=All.dbo.getDataTable(sql);精品文档放心下载for(inti=0;i<dt.Rows.Count;i++)感谢阅读{DataRowrow=dt.Rows[i];ListViewItemitem=newListViewItem();谢谢阅读ObjBookInfoobi=newObjBookInfo(row["bookinfo_rfid"].ToString());item.Text=obi.Name;精品文档放心下载ListViewItem.ListViewSubItemsubitem1=newListViewItem.ListViewSubItem();精品文档放心下载subitem1.Text=row["lendtime"].ToString();感谢阅读item.SubItems.Add(subitem1);感谢阅读ListViewItem.ListViewSubItemsubitem2=newListViewItem.ListViewSubItem();精品文档放心下载.\subitem2.Text=row["returntime"].ToString();精品文档放心下载item.SubItems.Add(subitem2);谢谢阅读listView1.Items.Add(item);感谢阅读}}privatevoidtsbtnExit_Click(objectsender,EventArgse)精品文档放心下载{this.Close();}}}图书管理usingSystem;usingSystem.Collections.Generic;精品文档放心下载usingSystem.ComponentModel;谢谢阅读usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;谢谢阅读namespaceLabrary{publicpartialclassFormBookInfoList:Form谢谢阅读{publicFormBookInfoList(){InitializeComponent();}privatevoidSetCboBookType()精品文档放心下载{stringsql="select*frombooktype";精品文档放心下载DataTabledt=All.dbo.getDataTable(sql);谢谢阅读this.tscboBookType.ComboBox.DataSource=dt;谢谢阅读this.tscboBookType.ComboBox.DisplayMember="Name";谢谢阅读this.tscboBookType.ComboBox.ValueMember="ID";感谢阅读}privatevoidSetListView()精品文档放心下载.\{this.listView1.Items.Clear();精品文档放心下载IsEnabled(false);List<ObjBookInfo>listBookInfo=谢谢阅读ObjBookInfo.GetAllBookInfo(Convert.ToInt32(this.tscboBookType.ComboBox.SelectedValue));感谢阅读for(inti=0;i<listBookInfo.Count;i++)精品文档放心下载{ObjBookInfoobi=listBookInfo[i];精品文档放心下载ListViewItemitem=newListViewItem();谢谢阅读item.Text=obi.RFID;item.Tag=obi;ListViewItem.ListViewSubItemsubLendStatus=newListViewItem.ListViewSubItem();精品文档放心下载subLendStatus.Text=obi.LendStatus;感谢阅读item.SubItems.Add(subLendStatus);感谢阅读ListViewItem.ListViewSubItemsubBookName=newListViewItem.ListViewSubItem();精品文档放心下载subBookName.Text=obi.Name;谢谢阅读item.SubItems.Add(subBookName);感谢阅读ListViewItem.ListViewSubItemsubPress=newListViewItem.ListViewSubItem();精品文档放心下载subPress.Text=obi.Press;精品文档放心下载item.SubItems.Add(subPress);精品文档放心下载ListViewItem.ListViewSubItemsubPrice=newListViewItem.ListViewSubItem();精品文档放心下载subPrice.Text=obi.Price;精品文档放心下载item.SubItems.Add(subPrice);感谢阅读ListViewItem.ListViewSubItemsubAddPerson=newListViewItem.ListViewSubItem();谢谢阅读subAddPerson.Text=obi.User.Name;精品文档放心下载item.SubItems.Add(subAddPerson);精品文档放心下载ListViewItem.ListViewSubItemsubAddTime=newListViewItem.ListViewSubItem();精品文档放心下载subAddTime.Text=obi.AddTime.ToString();感谢阅读item.SubItems.Add(subAddTime);精品文档放心下载.\this.listView1.Items.Add(item);精品文档放心下载}}privatevoidtsbtnExit_Click(objectsender,EventArgse)精品文档放心下载{this.Close();}privatevoidtscboBookType_DropDown(objectsender,EventArgse)精品文档放心下载{SetCboBookType();}privatevoidtscboBookType_DropDownClosed(objectsender,Eve