开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 行业应用 > 教育系统应用 > 查看源码
Form_Publisher.cs
资源名称：LibraryManagement.rar　[点击查看]
上传用户：chinapurv
上传日期：2014-03-12
资源大小：4870k
文件大小：18k
源码类别：

教育系统应用

开发平台：

C#

Form_Publisher.cs：源码内容
  1. using System;
  2. using System.Drawing;
  3. using System.Collections;
  4. using System.ComponentModel;
  5. using System.Windows.Forms;
  7. namespace 图书管理系统
  8. {
  9. /// <summary>
  10. /// Form_Publisher 的摘要说明。
  11. /// </summary>
  12. public class Form_Publisher : System.Windows.Forms.Form
  13. {
  14. private System.Windows.Forms.Label label1;
  15. private System.Windows.Forms.Label label2;
  16. private System.Windows.Forms.Label label3;
  17. private System.Windows.Forms.Label label4;
  18. private System.Windows.Forms.TextBox pressname;
  19. private System.Windows.Forms.TextBox presslinkman;
  20. private System.Windows.Forms.TextBox pressaddress;
  21. private System.Windows.Forms.TextBox presstelephone;
  22. private System.Windows.Forms.Button butPrev;
  23. private System.Windows.Forms.Button butNext;
  24. private System.Windows.Forms.Button butLast;
  25. private System.Windows.Forms.Button butFirst;
  26. private System.Windows.Forms.Button butShowAll;
  27. private System.Windows.Forms.Label label5;
  28. private System.Windows.Forms.ComboBox comboBox1;
  29. private System.Windows.Forms.ComboBox comboBox2;
  30. private System.Windows.Forms.Button butSearch;
  31. private System.Windows.Forms.Button butDelete;
  32. private System.Windows.Forms.Button butAdd;
  33. private System.Windows.Forms.Button butAlter;
  34. private System.Windows.Forms.Button butBookManagement;
  35. private System.Windows.Forms.TextBox textForSearch;
  36. /// <summary>
  37. /// 必需的设计器变量。
  38. /// </summary>
  39. private System.ComponentModel.Container components = null;
  41. public Form_Publisher()
  42. {
  43. //
  44. // Windows 窗体设计器支持所必需的
  45. //
  46. InitializeComponent();
  48. //
  49. // TODO: 在 InitializeComponent 调用后添加任何构造函数代码
  50. //
  51. }
  53. /// <summary>
  54. /// 清理所有正在使用的资源。
  55. /// </summary>
  56. protected override void Dispose( bool disposing )
  57. {
  58. if( disposing )
  59. {
  60. if(components != null)
  61. {
  62. components.Dispose();
  63. }
  64. }
  65. base.Dispose( disposing );
  66. }
  68. #region Windows 窗体设计器生成的代码
  69. /// <summary>
  70. /// 设计器支持所需的方法 - 不要使用代码编辑器修改
  71. /// 此方法的内容。
  72. /// </summary>
  73. private void InitializeComponent()
  74. {
  75. System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(Form_Publisher));
  76. this.label1 = new System.Windows.Forms.Label();
  77. this.label2 = new System.Windows.Forms.Label();
  78. this.label3 = new System.Windows.Forms.Label();
  79. this.label4 = new System.Windows.Forms.Label();
  80. this.pressname = new System.Windows.Forms.TextBox();
  81. this.presslinkman = new System.Windows.Forms.TextBox();
  82. this.pressaddress = new System.Windows.Forms.TextBox();
  83. this.presstelephone = new System.Windows.Forms.TextBox();
  84. this.butBookManagement = new System.Windows.Forms.Button();
  85. this.butPrev = new System.Windows.Forms.Button();
  86. this.butNext = new System.Windows.Forms.Button();
  87. this.butLast = new System.Windows.Forms.Button();
  88. this.butFirst = new System.Windows.Forms.Button();
  89. this.butShowAll = new System.Windows.Forms.Button();
  90. this.label5 = new System.Windows.Forms.Label();
  91. this.comboBox1 = new System.Windows.Forms.ComboBox();
  92. this.butSearch = new System.Windows.Forms.Button();
  93. this.textForSearch = new System.Windows.Forms.TextBox();
  94. this.comboBox2 = new System.Windows.Forms.ComboBox();
  95. this.butDelete = new System.Windows.Forms.Button();
  96. this.butAdd = new System.Windows.Forms.Button();
  97. this.butAlter = new System.Windows.Forms.Button();
  98. this.SuspendLayout();
  99. // 
  100. // label1
  101. // 
  102. this.label1.BackColor = System.Drawing.Color.Transparent;
  103. this.label1.Location = new System.Drawing.Point(72, 48);
  104. this.label1.Name = "label1";
  105. this.label1.Size = new System.Drawing.Size(112, 24);
  106. this.label1.TabIndex = 0;
  107. this.label1.Text = "出版社名称";
  108. // 
  109. // label2
  110. // 
  111. this.label2.BackColor = System.Drawing.Color.Transparent;
  112. this.label2.Location = new System.Drawing.Point(72, 96);
  113. this.label2.Name = "label2";
  114. this.label2.Size = new System.Drawing.Size(112, 24);
  115. this.label2.TabIndex = 1;
  116. this.label2.Text = "联系人姓名";
  117. // 
  118. // label3
  119. // 
  120. this.label3.BackColor = System.Drawing.Color.Transparent;
  121. this.label3.Location = new System.Drawing.Point(72, 144);
  122. this.label3.Name = "label3";
  123. this.label3.Size = new System.Drawing.Size(112, 24);
  124. this.label3.TabIndex = 2;
  125. this.label3.Text = "出版社地址";
  126. // 
  127. // label4
  128. // 
  129. this.label4.BackColor = System.Drawing.Color.Transparent;
  130. this.label4.Location = new System.Drawing.Point(72, 192);
  131. this.label4.Name = "label4";
  132. this.label4.Size = new System.Drawing.Size(112, 24);
  133. this.label4.TabIndex = 3;
  134. this.label4.Text = "联系电话";
  135. // 
  136. // pressname
  137. // 
  138. this.pressname.Location = new System.Drawing.Point(200, 48);
  139. this.pressname.Name = "pressname";
  140. this.pressname.ReadOnly = true;
  141. this.pressname.Size = new System.Drawing.Size(200, 21);
  142. this.pressname.TabIndex = 4;
  143. this.pressname.Text = "pressname";
  144. // 
  145. // presslinkman
  146. // 
  147. this.presslinkman.Location = new System.Drawing.Point(200, 96);
  148. this.presslinkman.Name = "presslinkman";
  149. this.presslinkman.ReadOnly = true;
  150. this.presslinkman.Size = new System.Drawing.Size(200, 21);
  151. this.presslinkman.TabIndex = 5;
  152. this.presslinkman.Text = "presslinkman";
  153. // 
  154. // pressaddress
  155. // 
  156. this.pressaddress.Location = new System.Drawing.Point(200, 136);
  157. this.pressaddress.Name = "pressaddress";
  158. this.pressaddress.ReadOnly = true;
  159. this.pressaddress.Size = new System.Drawing.Size(200, 21);
  160. this.pressaddress.TabIndex = 6;
  161. this.pressaddress.Text = "pressaddress";
  162. // 
  163. // presstelephone
  164. // 
  165. this.presstelephone.Location = new System.Drawing.Point(200, 192);
  166. this.presstelephone.Name = "presstelephone";
  167. this.presstelephone.ReadOnly = true;
  168. this.presstelephone.Size = new System.Drawing.Size(200, 21);
  169. this.presstelephone.TabIndex = 7;
  170. this.presstelephone.Text = "presstelephone";
  171. // 
  172. // butBookManagement
  173. // 
  174. this.butBookManagement.BackColor = System.Drawing.Color.Transparent;
  175. this.butBookManagement.Location = new System.Drawing.Point(312, 256);
  176. this.butBookManagement.Name = "butBookManagement";
  177. this.butBookManagement.Size = new System.Drawing.Size(104, 24);
  178. this.butBookManagement.TabIndex = 8;
  179. this.butBookManagement.Text = "书目信息管理";
  180. this.butBookManagement.Click += new System.EventHandler(this.butBookManagement_Click);
  181. // 
  182. // butPrev
  183. // 
  184. this.butPrev.BackColor = System.Drawing.Color.Transparent;
  185. this.butPrev.Location = new System.Drawing.Point(180, 344);
  186. this.butPrev.Name = "butPrev";
  187. this.butPrev.Size = new System.Drawing.Size(56, 24);
  188. this.butPrev.TabIndex = 9;
  189. this.butPrev.Text = "<";
  190. this.butPrev.Click += new System.EventHandler(this.butPrev_Click);
  191. // 
  192. // butNext
  193. // 
  194. this.butNext.BackColor = System.Drawing.Color.Transparent;
  195. this.butNext.Location = new System.Drawing.Point(236, 344);
  196. this.butNext.Name = "butNext";
  197. this.butNext.Size = new System.Drawing.Size(56, 24);
  198. this.butNext.TabIndex = 10;
  199. this.butNext.Text = ">";
  200. this.butNext.Click += new System.EventHandler(this.butNext_Click);
  201. // 
  202. // butLast
  203. // 
  204. this.butLast.BackColor = System.Drawing.Color.Transparent;
  205. this.butLast.Location = new System.Drawing.Point(292, 344);
  206. this.butLast.Name = "butLast";
  207. this.butLast.Size = new System.Drawing.Size(56, 24);
  208. this.butLast.TabIndex = 12;
  209. this.butLast.Text = ">|";
  210. this.butLast.Click += new System.EventHandler(this.butLast_Click);
  211. // 
  212. // butFirst
  213. // 
  214. this.butFirst.BackColor = System.Drawing.Color.Transparent;
  215. this.butFirst.Location = new System.Drawing.Point(124, 344);
  216. this.butFirst.Name = "butFirst";
  217. this.butFirst.Size = new System.Drawing.Size(56, 24);
  218. this.butFirst.TabIndex = 11;
  219. this.butFirst.Text = "|<";
  220. this.butFirst.Click += new System.EventHandler(this.butFirst_Click);
  221. // 
  222. // butShowAll
  223. // 
  224. this.butShowAll.BackColor = System.Drawing.Color.Transparent;
  225. this.butShowAll.Location = new System.Drawing.Point(224, 256);
  226. this.butShowAll.Name = "butShowAll";
  227. this.butShowAll.Size = new System.Drawing.Size(88, 24);
  228. this.butShowAll.TabIndex = 13;
  229. this.butShowAll.Text = "查看全部";
  230. this.butShowAll.Click += new System.EventHandler(this.butShowAll_Click);
  231. // 
  232. // label5
  233. // 
  234. this.label5.BackColor = System.Drawing.Color.Transparent;
  235. this.label5.Location = new System.Drawing.Point(36, 304);
  236. this.label5.Name = "label5";
  237. this.label5.Size = new System.Drawing.Size(56, 16);
  238. this.label5.TabIndex = 14;
  239. this.label5.Text = "查找方式";
  240. // 
  241. // comboBox1
  242. // 
  243. this.comboBox1.Items.AddRange(new object[] {
  244.    "出版社名称",
  245.    "联系电话"});
  246. this.comboBox1.Location = new System.Drawing.Point(108, 304);
  247. this.comboBox1.MaxDropDownItems = 2;
  248. this.comboBox1.Name = "comboBox1";
  249. this.comboBox1.Size = new System.Drawing.Size(88, 20);
  250. this.comboBox1.TabIndex = 15;
  251. this.comboBox1.Text = "出版社名称";
  252. // 
  253. // butSearch
  254. // 
  255. this.butSearch.BackColor = System.Drawing.Color.Transparent;
  256. this.butSearch.Location = new System.Drawing.Point(372, 304);
  257. this.butSearch.Name = "butSearch";
  258. this.butSearch.Size = new System.Drawing.Size(64, 24);
  259. this.butSearch.TabIndex = 16;
  260. this.butSearch.Text = "查找";
  261. this.butSearch.Click += new System.EventHandler(this.butSearch_Click);
  262. // 
  263. // textForSearch
  264. // 
  265. this.textForSearch.Location = new System.Drawing.Point(268, 304);
  266. this.textForSearch.Name = "textForSearch";
  267. this.textForSearch.Size = new System.Drawing.Size(96, 21);
  268. this.textForSearch.TabIndex = 17;
  269. this.textForSearch.Text = "";
  270. // 
  271. // comboBox2
  272. // 
  273. this.comboBox2.Items.AddRange(new object[] {
  274.    "模糊",
  275.    "精确"});
  276. this.comboBox2.Location = new System.Drawing.Point(212, 304);
  277. this.comboBox2.MaxDropDownItems = 2;
  278. this.comboBox2.Name = "comboBox2";
  279. this.comboBox2.Size = new System.Drawing.Size(48, 20);
  280. this.comboBox2.TabIndex = 18;
  281. this.comboBox2.Text = "模糊";
  282. // 
  283. // butDelete
  284. // 
  285. this.butDelete.BackColor = System.Drawing.Color.Transparent;
  286. this.butDelete.Location = new System.Drawing.Point(168, 256);
  287. this.butDelete.Name = "butDelete";
  288. this.butDelete.Size = new System.Drawing.Size(56, 24);
  289. this.butDelete.TabIndex = 48;
  290. this.butDelete.Text = "删除";
  291. this.butDelete.Click += new System.EventHandler(this.butDelete_Click);
  292. // 
  293. // butAdd
  294. // 
  295. this.butAdd.BackColor = System.Drawing.Color.Transparent;
  296. this.butAdd.Location = new System.Drawing.Point(112, 256);
  297. this.butAdd.Name = "butAdd";
  298. this.butAdd.Size = new System.Drawing.Size(56, 24);
  299. this.butAdd.TabIndex = 47;
  300. this.butAdd.Text = "添加";
  301. this.butAdd.Click += new System.EventHandler(this.butAdd_Click);
  302. // 
  303. // butAlter
  304. // 
  305. this.butAlter.BackColor = System.Drawing.Color.Transparent;
  306. this.butAlter.Location = new System.Drawing.Point(56, 256);
  307. this.butAlter.Name = "butAlter";
  308. this.butAlter.Size = new System.Drawing.Size(56, 24);
  309. this.butAlter.TabIndex = 46;
  310. this.butAlter.Text = "修改";
  311. this.butAlter.Click += new System.EventHandler(this.butAlter_Click);
  312. // 
  313. // Form_Publisher
  314. // 
  315. this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
  316. this.BackgroundImage = ((System.Drawing.Image)(resources.GetObject("$this.BackgroundImage")));
  317. this.ClientSize = new System.Drawing.Size(472, 382);
  318. this.ControlBox = false;
  319. this.Controls.Add(this.butDelete);
  320. this.Controls.Add(this.butAdd);
  321. this.Controls.Add(this.butAlter);
  322. this.Controls.Add(this.comboBox2);
  323. this.Controls.Add(this.textForSearch);
  324. this.Controls.Add(this.presstelephone);
  325. this.Controls.Add(this.pressaddress);
  326. this.Controls.Add(this.presslinkman);
  327. this.Controls.Add(this.pressname);
  328. this.Controls.Add(this.butSearch);
  329. this.Controls.Add(this.comboBox1);
  330. this.Controls.Add(this.label5);
  331. this.Controls.Add(this.butShowAll);
  332. this.Controls.Add(this.butLast);
  333. this.Controls.Add(this.butFirst);
  334. this.Controls.Add(this.butNext);
  335. this.Controls.Add(this.butPrev);
  336. this.Controls.Add(this.butBookManagement);
  337. this.Controls.Add(this.label4);
  338. this.Controls.Add(this.label3);
  339. this.Controls.Add(this.label2);
  340. this.Controls.Add(this.label1);
  341. this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.None;
  342. this.Name = "Form_Publisher";
  343. this.StartPosition = System.Windows.Forms.FormStartPosition.Manual;
  344. this.Text = "Form_Publisher";
  345. this.Load += new System.EventHandler(this.Form_Publisher_Load);
  346. this.ResumeLayout(false);
  348. }
  349. #endregion
  351. private void butBookManagement_Click(object sender, System.EventArgs e)
  352. {
  353. if(Pressname!="")
  354. {
  355. Form_Publisher_BookManagement child=new Form_Publisher_BookManagement();
  356. child.ShowDialog();
  357. }
  358. else
  359. {
  360. MessageBox.Show("还没有选择出版社!","提示");
  361. }
  362. }
  364. SQL sql;
  365. public static string Pressname;
  366. private void Form_Publisher_Load(object sender, System.EventArgs e)
  367. {
  368. sql=new SQL("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=图书管理系统数据库.mdb");
  369. sql.ExecuteSQL("select * from 出版社信息表 order by pressname");
  370. show();
  371. }
  373. public void show()
  374. {
  375. if(sql.rows.GetLength(0)!=0)
  376. {
  377. pressname.Text=sql.rows[sql.getPos(),0].ToString();
  378. presslinkman.Text=sql.rows[sql.getPos(),1].ToString();
  379. pressaddress.Text=sql.rows[sql.getPos(),2].ToString();
  380. presstelephone.Text=sql.rows[sql.getPos(),3].ToString();
  381. }
  382. else
  383. {
  384. pressname.Text="";
  385. presslinkman.Text="";
  386. pressaddress.Text="";
  387. presstelephone.Text="";
  388. MessageBox.Show("无符合查询条件的结果!","提示");
  389. }
  390. Pressname=pressname.Text;
  391. }
  393. private void butPrev_Click(object sender, System.EventArgs e)
  394. {
  395. sql.pointToPrev();
  396. show();
  397. }
  399. private void butNext_Click(object sender, System.EventArgs e)
  400. {
  401. sql.pointToNext();
  402. show();
  403. }
  405. private void butFirst_Click(object sender, System.EventArgs e)
  406. {
  407. sql.pointToFirst();
  408. show();
  409. }
  411. private void butLast_Click(object sender, System.EventArgs e)
  412. {
  413. sql.pointToLast();
  414. show();
  415. }
  417. string oldpressname;
  419. private void butAlter_Click(object sender, System.EventArgs e)
  420. {
  421. if(butAlter.Text=="修改")
  422. {
  423. butAlter.Text="更新";
  424. oldpressname=pressname.Text;
  425. pressname.ReadOnly =false;
  426. presslinkman.ReadOnly  =false;
  427. pressaddress.ReadOnly  =false;
  428. presstelephone.ReadOnly  =false;
  430. butAdd.Enabled=false;
  431. butDelete.Enabled=false;
  432. butFirst.Enabled=false;
  433. butPrev.Enabled=false;
  434. butNext.Enabled=false;
  435. butLast.Enabled=false;
  436. butShowAll.Enabled=false;
  437. butSearch.Enabled=false;
  438. butBookManagement.Enabled=false;
  439. }
  440. else
  441. {
  442. if(sql.ExecuteSQL("update 出版社信息表 set pressname='"+pressname.Text+"',presslinkman='"+presslinkman.Text+"',pressaddress='"+pressaddress.Text+"',presstelephone='"+presstelephone.Text+"' where pressname='"+oldpressname+"'")
  443. ==false)
  444. {
  445. show();
  446. }
  447. else
  448. {
  449. Pressname=pressname.Text;
  450. sql.ExecuteSQL("update 出版社图书信息表 set pressname='"+pressname.Text+"' where pressname='"+oldpressname+"'");
  451. }
  452. pressname.ReadOnly  =true;
  453. presslinkman.ReadOnly  =true;
  454. pressaddress.ReadOnly  =true;
  455. presstelephone.ReadOnly =true;
  456. butAlter.Text="修改";
  458. butAdd.Enabled=true;
  459. butDelete.Enabled=true;
  460. butFirst.Enabled=true;
  461. butPrev.Enabled=true;
  462. butNext.Enabled=true;
  463. butLast.Enabled=true;
  464. butShowAll.Enabled=true;
  465. butSearch.Enabled=true;
  466. butBookManagement.Enabled=true;
  467. }
  468. }
  470. private void butAdd_Click(object sender, System.EventArgs e)
  471. {
  472. if(butAdd.Text=="添加")
  473. {
  474. butAdd.Text="提交";
  475. pressname.Text="";
  476. presslinkman.Text="";
  477. pressaddress.Text="";
  478. presstelephone.Text="";
  479. pressname.ReadOnly =false;
  480. presslinkman.ReadOnly  =false;
  481. pressaddress.ReadOnly  =false;
  482. presstelephone.ReadOnly  =false;
  484. butAlter.Enabled=false;
  485. butDelete.Enabled=false;
  486. butFirst.Enabled=false;
  487. butPrev.Enabled=false;
  488. butNext.Enabled=false;
  489. butLast.Enabled=false;
  490. butShowAll.Enabled=false;
  491. butSearch.Enabled=false;
  492. butBookManagement.Enabled=false;
  493. }
  494. else
  495. {
  496. if(sql.ExecuteSQL("insert into 出版社信息表 values('"+pressname.Text+"','"+presslinkman.Text+"','"+pressaddress.Text+"','"+presstelephone.Text+"')")
  497. ==false)
  498. {
  499. show();
  500. }
  501. else
  502. {
  503. Pressname=pressname.Text;
  504. }
  505. pressname.ReadOnly  =true;
  506. presslinkman.ReadOnly  =true;
  507. pressaddress.ReadOnly  =true;
  508. presstelephone.ReadOnly =true;
  509. butAdd.Text="添加";
  511. butAlter.Enabled=true;
  512. butDelete.Enabled=true;
  513. butFirst.Enabled=true;
  514. butPrev.Enabled=true;
  515. butNext.Enabled=true;
  516. butLast.Enabled=true;
  517. butShowAll.Enabled=true;
  518. butSearch.Enabled=true;
  519. butBookManagement.Enabled=true;
  520. }
  521. }
  523. private void butDelete_Click(object sender, System.EventArgs e)
  524. {
  525. sql.ExecuteSQL("delete from 出版社信息表 where pressname='"+pressname.Text+"'");
  526. sql.ExecuteSQL("delete from 出版社图书信息表 where pressname='"+pressname.Text+"'");
  527. sql.pointToFirst();
  528. show();
  529. }
  531. private void butSearch_Click(object sender, System.EventArgs e)
  532. {
  533. if(comboBox1.Text=="出版社名称")
  534. {
  535. if(comboBox2.Text=="精确")
  536. {
  537. sql.ExecuteSQL("select * from 出版社信息表 where pressname='"+textForSearch.Text+"'");
  538. show();
  539. }
  540. else
  541. {
  542. sql.ExecuteSQL("select * from 出版社信息表 where pressname like '%"+textForSearch.Text+"%'");
  543. show();
  544. }
  545. }
  546. else
  547. {
  548. if(comboBox2.Text=="精确")
  549. {
  550. sql.ExecuteSQL("select * from 出版社信息表 where presstelephone='"+textForSearch.Text+"'");
  551. show();
  552. }
  553. else
  554. {
  555. sql.ExecuteSQL("select * from 出版社信息表 where presstelephone like '%"+textForSearch.Text+"%'");
  556. show();
  557. }
  558. }
  559. }
  561. private void butShowAll_Click(object sender, System.EventArgs e)
  562. {
  563. sql.ExecuteSQL("select * from 出版社信息表 order by pressname");
  564. show();
  565. }
  567. }
  568. }