2022年系统源代码参照 .pdf

《2022年系统源代码参照 .pdf》由会员分享，可在线阅读，更多相关《2022年系统源代码参照 .pdf（18页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、namespace BookManage publicpartialclassfrmLogin : Form public frmLogin() InitializeComponent(); privatevoid btnLogin_Click(object sender, EventArgs e) / 验证通过if (Validate() string state = this .cboUserType.Text; int num; if (state.Equals(管理员 ) / 判断用户角色 num = 1; elseif (state.Equals(后台管理 ) num = 2; el

2、se num = 3; 名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 1 页，共 18 页 - - - - - - - - - / 定义查询语句string sql = string.Format( select * from userinfo where uname=0and upwd=1 and ustate=2, this .txName.Text.Trim(),this .txtPwd.Text.Trim(),num); DataSet ds = DataAccess.Ge

3、tDataSetBySql(sql); if (ds.Tables0.Rows.Count 0) MessageBox .Show( 登录成功 ); Constans .UserBookID = ds.Tables0.Rows0UBookID .ToString(); Constans .UserName = ds.Tables0.Rows0UName.ToString(); Constans .UserState = ds.Tables0.Rows0UState .ToString(); if (num=1) frmMain .result = DialogResult.OK; this .

4、Hide(); frmMain main = new frmMain (); main.ShowDialog(); elseif (num = 2) frmBookInStore store = new frmBookInStore(); store.ShowDialog(); else frmBookJY jy = new frmBookJY(); jy.ShowDialog(); else MessageBox .Show( 用户名或密码错误); privatevoid frmLogin_Load(object sender, EventArgs e) this .cboUserType.

5、SelectedIndex = 0; / 验证方法privatebool Vaildate() if ( this .txName.Text != string.Empty & this .txtPwd.Text != string.Empty) returntrue ; 名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 2 页，共 18 页 - - - - - - - - - else MessageBox .Show( 用户名或密码不能为空); returnfalse ; priv

6、atevoid btnCancle_Click(object sender, EventArgs e) this .Close(); namespace BookManage publicpartialclassfrmMain : Form publicstaticDialogResult result; public frmMain() InitializeComponent(); / 查询子窗体是否存在publicbool checkchildfrm(string childfrmname) foreach ( Form childFrm inthis .MdiChildren) if (

7、childFrm.Name = childfrmname) if (childFrm.WindowState = FormWindowState.Minimized) childFrm.WindowState = FormWindowState.Normal; 名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 3 页，共 18 页 - - - - - - - - - childFrm.Activate(); returntrue ; returnfalse ; / 用户登录菜单的事件处

8、理privatevoid用户登录 ToolStripMenuItem_Click(object sender, EventArgs e) / 检测该窗口是否处于打开状态if ( this .checkchildfrm(frmLogin) = true ) return ; / 窗口已经打开，返回frmLogin user = new frmLogin (); / 实例化登录窗体 user.ShowDialog(); / 登录窗体以模式对话框的方式的打开/ 判断是否登录成功，登录成功则启用相应的菜单和按钮if (result = DialogResult.OK) this .tsbtnAddBo

9、ok.Enabled = true ; this .mnuUpdateBook.Enabled = true ; this .mnuAddBook.Enabled = true ; / 登录按钮事件处理privatevoid tsbtnLogin_Click(object sender, EventArgs e) if ( this .checkchildfrm(frmLogin) = true ) return ; frmLogin user = new frmLogin (); user.ShowDialog(); if (result = DialogResult.OK) this .t

10、sbtnAddBook.Enabled = true ; this .mnuUpdateBook.Enabled = true ; this .mnuAddBook.Enabled = true ; / 图书查询按钮 Click 事件处理privatevoid tsbtnSearch_Click(object sender, EventArgs e) frmBookSearch frmbs = new frmBookSearch (); 名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第

11、 4 页，共 18 页 - - - - - - - - - frmbs.ShowDialog(); / 图书检索菜单 Click 事件处理privatevoid图书检索 ToolStripMenuItem_Click(object sender, EventArgs e) frmBookSearch frmbs = new frmBookSearch (); frmbs.ShowDialog(); / 图书入库菜单 Click 事件处理privatevoid图书入库 ToolStripMenuItem1_Click(object sender, EventArgs e) frmBookInSt

12、ore bookinstore = new frmBookInStore(); bookinstore.ShowDialog(); / 图书入库按钮 Click 事件处理privatevoid tsbtnAddBook_Click(object sender, EventArgs e) frmTsgx tsgx = new frmTsgx (); tsgx.ShowDialog(); / 图书更新菜单 Click 事件处理privatevoid图书修改 ToolStripMenuItem_Click(object sender, EventArgs e) frmTsgx tsgx = new

13、frmTsgx (); tsgx.ShowDialog(); / 图书借阅按钮事件处理privatevoid tsbtnIssue_Click(object sender, EventArgs e) frmBookJY bookjy = new frmBookJY(); bookjy.ShowDialog(); privatevoid tsbtnExit_Click(object sender, EventArgs e) Application.Exit(); privatevoid退出 ToolStripMenuItem1_Click(object sender, EventArgs e)

14、Application.Exit(); 名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 5 页，共 18 页 - - - - - - - - - privatevoid退出 ToolStripMenuItem_Click(object sender, EventArgs e) Application.Exit(); / 窗体载入时事件处理privatevoid FrmMain_Load( object sender, EventArgs e) /this.tsbtnAddBook.E

15、nabled = false; /this.mnuAddBook.Enabled = false; /this.mnuUpdateBook.Enabled = false; / 在关闭主窗体的同时，关闭整个系统privatevoid frmMain_FormClosed(object sender, FormClosedEventArgs e) Application.Exit(); privatevoid图书借阅 ToolStripMenuItem_Click(object sender, EventArgs e) frmBookJY bookJy = new frmBookJY(); bo

16、okJy.ShowDialog(); privatevoid图书归还 ToolStripMenuItem_Click(object sender, EventArgs e) frmBookReturn frmreturn = new frmBookReturn (); frmreturn.ShowDialog(); privatevoid注册 ToolStripMenuItem_Click(object sender, EventArgs e) frmUserZC zc = new frmUserZC(); zc.ShowDialog(); 名师资料总结 - - -精品资料欢迎下载 - - -

17、 - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 6 页，共 18 页 - - - - - - - - - namespace BookManage publicpartialclassfrmBookInStore : Form public frmBookInStore() InitializeComponent(); privatevoid BookInStore_Load(object sender, EventArgs e) DataSet Myds = DataAccess .GetDataSetBySql(select *

18、from BookInfo); DataTable table = Myds.Tables0; this .dataGridView1.DataSource = table; privatevoid btnExit_Click(object sender, EventArgs e) this .Close(); privatevoid btnInsert_Click(object sender, EventArgs e) string bookname = this .txtBookName.Text; string booktype = this .txtBookType.Text; str

19、ing author = this .txtAuthor.Text; string cbs = this .txtCBS.Text;/ 出版商int kc = Convert .ToInt32( this .txtKC.Text);/ 库存int kjysl =Convert .ToInt32( this .txtKJY.Text);/ 可借阅数量名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 7 页，共 18 页 - - - - - - - - - string sql = str

20、ing.Format( insert into BookInfo values(0,1,2,3,4,5), booktype,bookname, author, cbs, kc, kjysl); if ( DataAccess .UpdateDataTable(sql) MessageBox .Show( 添加成功！ , 提示 ); else MessageBox .Show( 添加失败！ , 提示 , MessageBoxButtons .OK); DataSet Myds = DataAccess .GetDataSetBySql(select * from BookInfo); Data

21、Table table=Myds.Tables0; this .dataGridView1.DataSource = table; publicbool Validate() returntrue ; namespace BookManage publicpartialclassfrmTsgx : Form public frmTsgx() 名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 8 页，共 18 页 - - - - - - - - - InitializeComponent

22、(); privatevoid btnClose_Click(object sender, EventArgs e) this .Close(); privatevoid frmTsgx_Load( object sender, EventArgs e) DataSet Myds = DataAccess .GetDataSetBySql(select * from BookInfo); DataTable table = Myds.Tables0; dataGridView1.DataSource = table; privatevoid dataGridView1_CellContentC

23、lick(object sender, DataGridViewCellEventArgse) int index = dataGridView1.CurrentCell.RowIndex; this .textBox1.Text = this .dataGridView1.Rowsindex.Cells0.Value.ToString().Trim();/ 图书编号this .textBox2.Text = this .dataGridView1.Rowsindex.Cells2.Value.ToString().Trim();/ 图书名称this .textBox3.Text = this

24、 .dataGridView1.Rowsindex.Cells1.Value.ToString().Trim();/ 图书类型this .textBox4.Text = this .dataGridView1.Rowsindex.Cells3.Value.ToString().Trim();/ 图书作者this .textBox5.Text = this .dataGridView1.Rowsindex.Cells4.Value.ToString().Trim();/ 出版商this .textBox6.Text = this .dataGridView1.Rowsindex.Cells5.V

25、alue.ToString().Trim();/ 库存this .textBox7.Text = this .dataGridView1.Rowsindex.Cells6.Value.ToString().Trim();/ 可借阅的数量 privatevoid btnUpdate_Click(object sender, EventArgs e) string bookname = textBox2.Text.ToString().Trim(); string booktype = textBox3.Text.ToString().Trim(); string bookauthor = tex

26、tBox4.Text.ToString().Trim(); string bookpublish = textBox5.Text.ToString().Trim(); int bookkc = Convert .ToInt32(textBox6.Text.Trim(); 名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 9 页，共 18 页 - - - - - - - - - int bookjysl = Convert .ToInt32(textBox7.Text.Trim(); s

27、tring sql = string.Format( update BookInfo set BookName=0,BookType=1,BookAuthor=2,BookPublish=3,BookKC=4,BookJYSL=5 where BookID=6 ,bookname,booktype,bookauthor,bookpublish,bookkc,bookjysl,Convert .ToInt32(textBox1.Text); if ( DataAccess .UpdateDataTable(sql) MessageBox .Show( 更新成功！ , 提示 , MessageBo

28、xButtons .OK); else MessageBox .Show( 更新失败！ , 提示 , MessageBoxButtons .OK); privatevoid btnSaveEdit_Click(object sender, EventArgs e) string sql = select * from BookInfo; DataSet ds = DataAccess .GetDataSetBySql(sql); DialogResult result = MessageBox.Show(您确实要将修改保存到数据库中吗？ , 操作提示 , MessageBoxButtons .

29、OKCancel, MessageBoxIcon.Question); if (result=DialogResult.OK) DataAccess .UpdateDataSet(ds,sql); MessageBox .Show( 保存成功！ ); dataGridView1.DataSource = DataAccess .GetDataSetBySql(sql).Tables0; 名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 10 页，共 18 页 - - - - - - -

30、 - - namespace BookManage publicpartialclassfrmBookSearch : Form public frmBookSearch() InitializeComponent(); privatevoid btnClose_Click(object sender, EventArgs e) this .Close(); privatevoid btnSearch_Click(object sender, EventArgs e) /string cbo1 = this.cboBookType.Text; string booktype = this .c

31、boType2.Text; string bookname = this .txtBookName.Text; string sql= select * from BookInfo where BookType=+booktype+ and BookName like % +bookname+ % ; DataSet Myds = DataAccess .GetDataSetBySql(sql); DataTable table = Myds.Tables0; this .dataGridView1.DataSource = table; privatevoid frmBookSearch_L

32、oad(object sender, EventArgs e) 名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 11 页，共 18 页 - - - - - - - - - DataSet Myds = DataAccess .GetDataSetBySql(select distinct BookType from BookInfo ); DataTable table = Myds.Tables0; for ( int i = 0; i table.Rows.Count; i+)

33、/this.cboBookType.Items.Add(table.Rowsi0.ToString().Trim(); this .cboType2.Items.Add(table.Rowsi0.ToString().Trim(); / this.cboBookType.SelectedIndex = 0; this .cboType2.SelectedIndex = 0; namespace BookManage publicpartialclassfrmBookReturn : Form public frmBookReturn() InitializeComponent(); priva

34、tevoid button2_Click(object sender, EventArgs e) this .Close(); 名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 12 页，共 18 页 - - - - - - - - - privatevoid btnSearch_Click(object sender, EventArgs e) string userbookid = textBox1.Text; string sql= string.Format( select *

35、 from IssueInfo where UserBookID=0,userbookid); DataSet Myds = DataAccess .GetDataSetBySql(sql); DataTable table = Myds.Tables0; dataGridView1.DataSource = table; privatevoid button1_Click(object sender, EventArgs e) DateTime time = Convert .ToDateTime( this .textBox9.Text); string bo = this .comboB

36、ox2.Text.ToString(); string sql = string.Format( update IssueInfo set ghDateTime=0,Bool=1 where IssID=2,time,bo,Convert .ToInt32(textBox15.Text); if ( DataAccess .UpdateDataTable(sql) MessageBox .Show( 还书成功！ , 提示 , MessageBoxButtons .OK); string sql2 = string.Format( update BookInfo set BookKC=BookK

37、C+1 where BookID=0 , Convert .ToInt32( this .textBox14.Text.ToString().Trim(); string sq = string.Format( update UserIssue set BookKC=BookKC-1 where UserBookID=0, this .textBox15.Text.ToString(); DataAccess .UpdateDataTable(sql2); DataAccess .UpdateDataTable(sq); else MessageBox .Show( 还书失败！ , 提示 ,

38、MessageBoxButtons .OK); privatevoid dataGridView1_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e) int index = dataGridView1.CurrentCell.RowIndex; this .textBox15.Text = this .dataGridView1.Rowsindex.Cells0.Value.ToString().Trim();/ 借阅编号this .textBox14.Text = this .dataGridView1.Rowsi

39、ndex.Cells1.Value.ToString().Trim();/ 借书证号this .textBox13.Text = 名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 13 页，共 18 页 - - - - - - - - - this .dataGridView1.Rowsindex.Cells2.Value.ToString().Trim();/ 用户名this .textBox12.Text = this .dataGridView1.Rowsindex.Cells3

40、.Value.ToString().Trim();/ 图书编号this .textBox11.Text = this .dataGridView1.Rowsindex.Cells4.Value.ToString().Trim();/ 图书名this .textBox10.Text = this .dataGridView1.Rowsindex.Cells5.Value.ToString().Trim();/ 借阅时间this .textBox9.Text = this .dataGridView1.Rowsindex.Cells6.Value.ToString().Trim();/ 归还时间

41、privatevoid frmBookReturn_Load(object sender, EventArgs e) this .comboBox2.SelectedIndex = 0; namespace BookManage publicpartialclassfrmBookJY : Form DataSet da = new DataSet (); public frmBookJY() InitializeComponent(); privatevoid btnExit_Click(object sender, EventArgs e) 名师资料总结 - - -精品资料欢迎下载 - -

42、- - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 14 页，共 18 页 - - - - - - - - - this .Close(); privatevoid frmBookJY_Load( object sender, EventArgs e) textBox1.Text = Constans .UserBookID; textBox2.Text = Constans .UserName; DataSet Myds = DataAccess .GetDataSetBySql(select * from IssueInfo); D

43、ataTable table = Myds.Tables0; dataGridView1.DataSource = table; da = DataAccess .GetDataSetBySql(select * from BookInfo); this .comboBox1.DataSource = da.Tables0; this .comboBox1.DisplayMember = BookName; this .comboBox1.ValueMember = BookID ; this .comboBox2.DataSource = da.Tables0; this .comboBox

44、2.DisplayMember = BookID ; this .comboBox2.ValueMember = BookID ; privatevoid btnJY_Click(object sender, EventArgs e) string userbookid = textBox1.Text.ToString(); string username = textBox2.Text.ToString(); string bookname = comboBox1.Text.ToString(); string bookid = comboBox2.Text.ToString(); Date

45、Time time = Convert .ToDateTime(textBox5.Text.ToString(); string con2 = server=(local);database=Book;Integrated Security=True ; SqlConnection conn = new SqlConnection (con2); string s = select BookKC from UserIssue where UserBookID=+userbookid+ ; SqlCommand command = new SqlCommand (s,conn); int j =

46、 0; /conn.Close(); conn.Open(); j = Convert .ToInt32(command.ExecuteScalar(); conn.Close(); if ( Convert .ToInt32(j) 0) string sql = string .Format( insert into IssueInfo(UserBookID,UserName,BookName,BookID,jyDateTime,Bool) values(0,1,2,3,4,否) , userbookid, username, bookname, bookid, time); if ( Da

47、taAccess .UpdateDataTable(sql) MessageBox .Show( 借阅成功！ ); stringsql2 = string.Format( update BookInfo set BookKC=BookKC-1 where BookID=0 , Convert .ToInt32( this .comboBox2.Text); stringsq = string.Format( update UserIssue set BookKC=BookKC+1 where UserBookID=0, userbookid); DataAccess .UpdateDataTa

48、ble(sql2); DataAccess .UpdateDataTable(sq); DataSet ds = DataAccess.GetDataSetBySql(select * from IssueInfo); DataTable table = ds.Tables0; dataGridView1.DataSource = table; else MessageBox .Show( 此书已借完 , 提示 ); else MessageBox .Show( 已借满本书 , 提示 ); privatevoid comboBox2_SelectedIndexChanged(object se

49、nder, EventArgs e) 名师资料总结 - - -精品资料欢迎下载 - - - - - - - - - - - - - - - - - - 名师精心整理 - - - - - - - 第 16 页，共 18 页 - - - - - - - - - foreach ( DataRow objRow in da.Tables0.Rows) if ( string.Compare(comboBox1.Text,objRowBookName.ToString(),true )=0) this .textBox3.Text = objRowBookAuthor .ToString(); thi

50、s .textBox4.Text = objRowBookPublish.ToString(); this .comboBox2.Text = objRowBookID .ToString(); namespace BookManage publicpartialclassfrmUserZC : Form public frmUserZC() InitializeComponent(); privatevoid button1_Click(object sender, EventArgs e) string username = textBox1.Text; string pwd = text