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

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

教育系统应用

开发平台：

C#

Form_Publisher_BookManagement.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_BookManagemant 的摘要说明。
  11. /// </summary>
  12. public class Form_Publisher_BookManagement : System.Windows.Forms.Form
  13. {
  14. private System.Windows.Forms.Label label4;
  15. private System.Windows.Forms.Label label3;
  16. private System.Windows.Forms.Label label2;
  17. private System.Windows.Forms.Label label1;
  18. private System.Windows.Forms.TextBox bookpublishdate;
  19. private System.Windows.Forms.TextBox bookinfo;
  20. private System.Windows.Forms.TextBox bookname;
  21. private System.Windows.Forms.TextBox bookISBN;
  22. private System.Windows.Forms.Label label6;
  23. private System.Windows.Forms.Button butLast;
  24. private System.Windows.Forms.Button butFirst;
  25. private System.Windows.Forms.Button butNext;
  26. private System.Windows.Forms.Button butPrev;
  27. private System.Windows.Forms.Label label5;
  28. private System.Windows.Forms.Button butSearch;
  29. private System.Windows.Forms.Button butAll;
  30. private System.Windows.Forms.Button butThisYear;
  31. private System.Windows.Forms.Button butThisQuarter;
  32. private System.Windows.Forms.Button butBuy;
  33. private System.Windows.Forms.Button butAdd;
  34. private System.Windows.Forms.Button butAlter;
  35. private System.Windows.Forms.Button butDelete;
  36. private System.Windows.Forms.TextBox pressname;
  37. private System.Windows.Forms.Label label7;
  38. private System.Windows.Forms.TextBox bookinprice;
  39. private System.Windows.Forms.TextBox textForSearch;
  40. /// <summary>
  41. /// 必需的设计器变量。
  42. /// </summary>
  43. private System.ComponentModel.Container components = null;
  45. public Form_Publisher_BookManagement()
  46. {
  47. //
  48. // Windows 窗体设计器支持所必需的
  49. //
  50. InitializeComponent();
  52. //
  53. // TODO: 在 InitializeComponent 调用后添加任何构造函数代码
  54. //
  55. }
  57. /// <summary>
  58. /// 清理所有正在使用的资源。
  59. /// </summary>
  60. protected override void Dispose( bool disposing )
  61. {
  62. if( disposing )
  63. {
  64. if(components != null)
  65. {
  66. components.Dispose();
  67. }
  68. }
  69. base.Dispose( disposing );
  70. }
  72. #region Windows 窗体设计器生成的代码
  73. /// <summary>
  74. /// 设计器支持所需的方法 - 不要使用代码编辑器修改
  75. /// 此方法的内容。
  76. /// </summary>
  77. private void InitializeComponent()
  78. {
  79. System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(Form_Publisher_BookManagement));
  80. this.bookpublishdate = new System.Windows.Forms.TextBox();
  81. this.bookinfo = new System.Windows.Forms.TextBox();
  82. this.bookname = new System.Windows.Forms.TextBox();
  83. this.bookISBN = new System.Windows.Forms.TextBox();
  84. this.label4 = new System.Windows.Forms.Label();
  85. this.label3 = new System.Windows.Forms.Label();
  86. this.label2 = new System.Windows.Forms.Label();
  87. this.label1 = new System.Windows.Forms.Label();
  88. this.bookinprice = new System.Windows.Forms.TextBox();
  89. this.label6 = new System.Windows.Forms.Label();
  90. this.butAll = new System.Windows.Forms.Button();
  91. this.butThisYear = new System.Windows.Forms.Button();
  92. this.butThisQuarter = new System.Windows.Forms.Button();
  93. this.butBuy = new System.Windows.Forms.Button();
  94. this.butLast = new System.Windows.Forms.Button();
  95. this.butFirst = new System.Windows.Forms.Button();
  96. this.butNext = new System.Windows.Forms.Button();
  97. this.butPrev = new System.Windows.Forms.Button();
  98. this.textForSearch = new System.Windows.Forms.TextBox();
  99. this.label5 = new System.Windows.Forms.Label();
  100. this.butSearch = new System.Windows.Forms.Button();
  101. this.butAdd = new System.Windows.Forms.Button();
  102. this.butAlter = new System.Windows.Forms.Button();
  103. this.butDelete = new System.Windows.Forms.Button();
  104. this.pressname = new System.Windows.Forms.TextBox();
  105. this.label7 = new System.Windows.Forms.Label();
  106. this.SuspendLayout();
  107. // 
  108. // bookpublishdate
  109. // 
  110. this.bookpublishdate.Location = new System.Drawing.Point(196, 152);
  111. this.bookpublishdate.Name = "bookpublishdate";
  112. this.bookpublishdate.ReadOnly = true;
  113. this.bookpublishdate.Size = new System.Drawing.Size(200, 21);
  114. this.bookpublishdate.TabIndex = 15;
  115. this.bookpublishdate.Text = "bookpublishdate";
  116. // 
  117. // bookinfo
  118. // 
  119. this.bookinfo.Location = new System.Drawing.Point(196, 120);
  120. this.bookinfo.Name = "bookinfo";
  121. this.bookinfo.ReadOnly = true;
  122. this.bookinfo.Size = new System.Drawing.Size(200, 21);
  123. this.bookinfo.TabIndex = 14;
  124. this.bookinfo.Text = "bookinfo";
  125. // 
  126. // bookname
  127. // 
  128. this.bookname.Location = new System.Drawing.Point(196, 88);
  129. this.bookname.Name = "bookname";
  130. this.bookname.ReadOnly = true;
  131. this.bookname.Size = new System.Drawing.Size(200, 21);
  132. this.bookname.TabIndex = 13;
  133. this.bookname.Text = "bookname";
  134. // 
  135. // bookISBN
  136. // 
  137. this.bookISBN.Location = new System.Drawing.Point(196, 56);
  138. this.bookISBN.Name = "bookISBN";
  139. this.bookISBN.ReadOnly = true;
  140. this.bookISBN.Size = new System.Drawing.Size(200, 21);
  141. this.bookISBN.TabIndex = 12;
  142. this.bookISBN.Text = "bookISBN";
  143. // 
  144. // label4
  145. // 
  146. this.label4.BackColor = System.Drawing.Color.Transparent;
  147. this.label4.Location = new System.Drawing.Point(68, 152);
  148. this.label4.Name = "label4";
  149. this.label4.Size = new System.Drawing.Size(112, 16);
  150. this.label4.TabIndex = 11;
  151. this.label4.Text = "出版日期";
  152. // 
  153. // label3
  154. // 
  155. this.label3.BackColor = System.Drawing.Color.Transparent;
  156. this.label3.Location = new System.Drawing.Point(68, 120);
  157. this.label3.Name = "label3";
  158. this.label3.Size = new System.Drawing.Size(112, 16);
  159. this.label3.TabIndex = 10;
  160. this.label3.Text = "图书简介";
  161. // 
  162. // label2
  163. // 
  164. this.label2.BackColor = System.Drawing.Color.Transparent;
  165. this.label2.Location = new System.Drawing.Point(68, 88);
  166. this.label2.Name = "label2";
  167. this.label2.Size = new System.Drawing.Size(112, 16);
  168. this.label2.TabIndex = 9;
  169. this.label2.Text = "图书名称";
  170. // 
  171. // label1
  172. // 
  173. this.label1.BackColor = System.Drawing.Color.Transparent;
  174. this.label1.Location = new System.Drawing.Point(68, 56);
  175. this.label1.Name = "label1";
  176. this.label1.Size = new System.Drawing.Size(112, 16);
  177. this.label1.TabIndex = 8;
  178. this.label1.Text = "ISBN号";
  179. // 
  180. // bookinprice
  181. // 
  182. this.bookinprice.Location = new System.Drawing.Point(196, 184);
  183. this.bookinprice.Name = "bookinprice";
  184. this.bookinprice.ReadOnly = true;
  185. this.bookinprice.Size = new System.Drawing.Size(200, 21);
  186. this.bookinprice.TabIndex = 18;
  187. this.bookinprice.Text = "bookinprice";
  188. // 
  189. // label6
  190. // 
  191. this.label6.BackColor = System.Drawing.Color.Transparent;
  192. this.label6.Location = new System.Drawing.Point(68, 184);
  193. this.label6.Name = "label6";
  194. this.label6.Size = new System.Drawing.Size(112, 16);
  195. this.label6.TabIndex = 16;
  196. this.label6.Text = "图书售价";
  197. // 
  198. // butAll
  199. // 
  200. this.butAll.BackColor = System.Drawing.Color.Transparent;
  201. this.butAll.Location = new System.Drawing.Point(360, 240);
  202. this.butAll.Name = "butAll";
  203. this.butAll.Size = new System.Drawing.Size(56, 24);
  204. this.butAll.TabIndex = 35;
  205. this.butAll.Text = "全部";
  206. this.butAll.Click += new System.EventHandler(this.butAll_Click);
  207. // 
  208. // butThisYear
  209. // 
  210. this.butThisYear.BackColor = System.Drawing.Color.Transparent;
  211. this.butThisYear.Location = new System.Drawing.Point(304, 240);
  212. this.butThisYear.Name = "butThisYear";
  213. this.butThisYear.Size = new System.Drawing.Size(56, 24);
  214. this.butThisYear.TabIndex = 32;
  215. this.butThisYear.Text = "今年";
  216. this.butThisYear.Click += new System.EventHandler(this.butThisYear_Click);
  217. // 
  218. // butThisQuarter
  219. // 
  220. this.butThisQuarter.BackColor = System.Drawing.Color.Transparent;
  221. this.butThisQuarter.Location = new System.Drawing.Point(248, 240);
  222. this.butThisQuarter.Name = "butThisQuarter";
  223. this.butThisQuarter.Size = new System.Drawing.Size(56, 24);
  224. this.butThisQuarter.TabIndex = 31;
  225. this.butThisQuarter.Text = "本季度";
  226. this.butThisQuarter.Click += new System.EventHandler(this.butThisQuarter_Click);
  227. // 
  228. // butBuy
  229. // 
  230. this.butBuy.BackColor = System.Drawing.Color.Transparent;
  231. this.butBuy.Location = new System.Drawing.Point(40, 240);
  232. this.butBuy.Name = "butBuy";
  233. this.butBuy.Size = new System.Drawing.Size(64, 24);
  234. this.butBuy.TabIndex = 30;
  235. this.butBuy.Text = "购入图书";
  236. this.butBuy.Click += new System.EventHandler(this.butBuy_Click);
  237. // 
  238. // butLast
  239. // 
  240. this.butLast.BackColor = System.Drawing.Color.Transparent;
  241. this.butLast.Location = new System.Drawing.Point(280, 312);
  242. this.butLast.Name = "butLast";
  243. this.butLast.Size = new System.Drawing.Size(48, 24);
  244. this.butLast.TabIndex = 39;
  245. this.butLast.Text = ">|";
  246. this.butLast.Click += new System.EventHandler(this.butLast_Click);
  247. // 
  248. // butFirst
  249. // 
  250. this.butFirst.BackColor = System.Drawing.Color.Transparent;
  251. this.butFirst.Location = new System.Drawing.Point(136, 312);
  252. this.butFirst.Name = "butFirst";
  253. this.butFirst.Size = new System.Drawing.Size(48, 24);
  254. this.butFirst.TabIndex = 38;
  255. this.butFirst.Text = "|<";
  256. this.butFirst.Click += new System.EventHandler(this.butFirst_Click);
  257. // 
  258. // butNext
  259. // 
  260. this.butNext.BackColor = System.Drawing.Color.Transparent;
  261. this.butNext.Location = new System.Drawing.Point(232, 312);
  262. this.butNext.Name = "butNext";
  263. this.butNext.Size = new System.Drawing.Size(48, 24);
  264. this.butNext.TabIndex = 37;
  265. this.butNext.Text = ">";
  266. this.butNext.Click += new System.EventHandler(this.butNext_Click);
  267. // 
  268. // butPrev
  269. // 
  270. this.butPrev.BackColor = System.Drawing.Color.Transparent;
  271. this.butPrev.Location = new System.Drawing.Point(184, 312);
  272. this.butPrev.Name = "butPrev";
  273. this.butPrev.Size = new System.Drawing.Size(48, 24);
  274. this.butPrev.TabIndex = 36;
  275. this.butPrev.Text = "<";
  276. this.butPrev.Click += new System.EventHandler(this.butPrev_Click);
  277. // 
  278. // textForSearch
  279. // 
  280. this.textForSearch.Location = new System.Drawing.Point(176, 280);
  281. this.textForSearch.Name = "textForSearch";
  282. this.textForSearch.Size = new System.Drawing.Size(152, 21);
  283. this.textForSearch.TabIndex = 40;
  284. this.textForSearch.Text = "在此输入图书名称";
  285. // 
  286. // label5
  287. // 
  288. this.label5.BackColor = System.Drawing.Color.Transparent;
  289. this.label5.Location = new System.Drawing.Point(72, 280);
  290. this.label5.Name = "label5";
  291. this.label5.Size = new System.Drawing.Size(96, 16);
  292. this.label5.TabIndex = 41;
  293. this.label5.Text = "按图书名称查找";
  294. // 
  295. // butSearch
  296. // 
  297. this.butSearch.BackColor = System.Drawing.Color.Transparent;
  298. this.butSearch.Location = new System.Drawing.Point(336, 280);
  299. this.butSearch.Name = "butSearch";
  300. this.butSearch.Size = new System.Drawing.Size(48, 24);
  301. this.butSearch.TabIndex = 42;
  302. this.butSearch.Text = "查找图书";
  303. this.butSearch.Click += new System.EventHandler(this.butSearch_Click);
  304. // 
  305. // butAdd
  306. // 
  307. this.butAdd.BackColor = System.Drawing.Color.Transparent;
  308. this.butAdd.Location = new System.Drawing.Point(152, 240);
  309. this.butAdd.Name = "butAdd";
  310. this.butAdd.Size = new System.Drawing.Size(48, 24);
  311. this.butAdd.TabIndex = 44;
  312. this.butAdd.Text = "添加";
  313. this.butAdd.Click += new System.EventHandler(this.butAdd_Click);
  314. // 
  315. // butAlter
  316. // 
  317. this.butAlter.BackColor = System.Drawing.Color.Transparent;
  318. this.butAlter.Location = new System.Drawing.Point(104, 240);
  319. this.butAlter.Name = "butAlter";
  320. this.butAlter.Size = new System.Drawing.Size(48, 24);
  321. this.butAlter.TabIndex = 43;
  322. this.butAlter.Text = "修改";
  323. this.butAlter.Click += new System.EventHandler(this.butAlter_Click);
  324. // 
  325. // butDelete
  326. // 
  327. this.butDelete.BackColor = System.Drawing.Color.Transparent;
  328. this.butDelete.Location = new System.Drawing.Point(200, 240);
  329. this.butDelete.Name = "butDelete";
  330. this.butDelete.Size = new System.Drawing.Size(48, 24);
  331. this.butDelete.TabIndex = 45;
  332. this.butDelete.Text = "删除";
  333. this.butDelete.Click += new System.EventHandler(this.butDelete_Click);
  334. // 
  335. // pressname
  336. // 
  337. this.pressname.Location = new System.Drawing.Point(196, 24);
  338. this.pressname.Name = "pressname";
  339. this.pressname.ReadOnly = true;
  340. this.pressname.Size = new System.Drawing.Size(200, 21);
  341. this.pressname.TabIndex = 47;
  342. this.pressname.Text = "pressname";
  343. // 
  344. // label7
  345. // 
  346. this.label7.BackColor = System.Drawing.Color.Transparent;
  347. this.label7.Location = new System.Drawing.Point(68, 24);
  348. this.label7.Name = "label7";
  349. this.label7.Size = new System.Drawing.Size(112, 16);
  350. this.label7.TabIndex = 46;
  351. this.label7.Text = "出版社";
  352. // 
  353. // Form_Publisher_BookManagement
  354. // 
  355. this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
  356. this.BackgroundImage = ((System.Drawing.Image)(resources.GetObject("$this.BackgroundImage")));
  357. this.ClientSize = new System.Drawing.Size(464, 348);
  358. this.Controls.Add(this.pressname);
  359. this.Controls.Add(this.textForSearch);
  360. this.Controls.Add(this.bookinprice);
  361. this.Controls.Add(this.bookpublishdate);
  362. this.Controls.Add(this.bookinfo);
  363. this.Controls.Add(this.bookname);
  364. this.Controls.Add(this.bookISBN);
  365. this.Controls.Add(this.label7);
  366. this.Controls.Add(this.butDelete);
  367. this.Controls.Add(this.butAdd);
  368. this.Controls.Add(this.butAlter);
  369. this.Controls.Add(this.butSearch);
  370. this.Controls.Add(this.label5);
  371. this.Controls.Add(this.butLast);
  372. this.Controls.Add(this.butFirst);
  373. this.Controls.Add(this.butNext);
  374. this.Controls.Add(this.butPrev);
  375. this.Controls.Add(this.butAll);
  376. this.Controls.Add(this.butThisYear);
  377. this.Controls.Add(this.butThisQuarter);
  378. this.Controls.Add(this.butBuy);
  379. this.Controls.Add(this.label6);
  380. this.Controls.Add(this.label4);
  381. this.Controls.Add(this.label3);
  382. this.Controls.Add(this.label2);
  383. this.Controls.Add(this.label1);
  384. this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle;
  385. this.Name = "Form_Publisher_BookManagement";
  386. this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
  387. this.Text = "出版社书目信息管理";
  388. this.Load += new System.EventHandler(this.Form_Publisher_BookManagement_Load);
  389. this.ResumeLayout(false);
  391. }
  392. #endregion
  394. private void butBuy_Click(object sender, System.EventArgs e)
  395. {
  396. if(bookISBN.Text!="")
  397. {
  398. Form_Publisher_BookManagement_Buy child=new Form_Publisher_BookManagement_Buy();
  399. child.ShowDialog();
  400. }
  401. else 
  402. {
  403. MessageBox.Show("请先选择一本图书!","提示");
  404. }
  405. }
  407. SQL sql;
  408. string oldbookISBN="";
  409. public static string BOOKISBN="";
  410. public static string PRESSNAME="";
  411. public static string BOOKNAME="";
  412. public static string BOOKINFO="";
  413. public static string BOOKPUBLISHDATE="";
  414. public static string BOOKINPRICE="";
  415. private string oldbookpublishdate;
  416. public void show()
  417. {
  418. if(sql.rows.GetLength(0)!=0)
  419. {
  420. bookISBN.Text=sql.rows[sql.getPos(),0].ToString();
  421. bookname.Text=sql.rows[sql.getPos(),2].ToString();
  422. bookinfo.Text=sql.rows[sql.getPos(),3].ToString();
  423. bookpublishdate.Text=sql.rows[sql.getPos(),4].ToString();
  424. bookinprice.Text=sql.rows[sql.getPos(),5].ToString();
  425. }
  426. else
  427. {
  428. bookISBN.Text="";
  429. bookname.Text="";
  430. bookinfo.Text="";
  431. bookpublishdate.Text="";
  432. bookinprice.Text="";
  433. MessageBox.Show("无符合查询条件的结果!","提示");
  434. }
  435. BOOKISBN=bookISBN.Text;
  436. PRESSNAME=pressname.Text;
  437. BOOKNAME=bookname.Text;
  438. BOOKINFO=bookinfo.Text;
  439. BOOKPUBLISHDATE=bookpublishdate.Text;
  440. BOOKINPRICE=bookinprice.Text;
  441. }
  443. private void Form_Publisher_BookManagement_Load(object sender, System.EventArgs e)
  444. {
  445. pressname.Text=Form_Publisher.Pressname;
  446. sql=new SQL("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=图书管理系统数据库.mdb");
  447. sql.ExecuteSQL("select * from 出版社图书信息表 where pressname='"+pressname.Text+"'");
  448. show();
  449. }
  451. private void butFirst_Click(object sender, System.EventArgs e)
  452. {
  453. sql.pointToFirst();
  454. show();
  455. }
  457. private void butPrev_Click(object sender, System.EventArgs e)
  458. {
  459. sql.pointToPrev();
  460. show();
  461. }
  463. private void butNext_Click(object sender, System.EventArgs e)
  464. {
  465. sql.pointToNext();
  466. show();
  467. }
  469. private void butLast_Click(object sender, System.EventArgs e)
  470. {
  471. sql.pointToLast();
  472. show();
  473. }
  475. private void butAlter_Click(object sender, System.EventArgs e)
  476. {
  477. if(butAlter.Text=="修改")
  478. {
  479. butAlter.Text="更新";
  480. oldbookISBN=bookISBN.Text;
  481. oldbookpublishdate=bookpublishdate.Text;
  482. bookISBN.ReadOnly =false;
  483. bookname.ReadOnly  =false;
  484. bookinfo.ReadOnly  =false;
  485. bookpublishdate.ReadOnly  =false;
  486. bookinprice.ReadOnly  =false;
  488. butAdd.Enabled=false;
  489. butDelete.Enabled=false;
  490. butFirst.Enabled=false;
  491. butPrev.Enabled=false;
  492. butNext.Enabled=false;
  493. butLast.Enabled=false;
  494. butSearch.Enabled=false;
  495. butBuy.Enabled=false;
  496. butThisQuarter.Enabled=false;
  497. butThisYear.Enabled=false;
  498. butAll.Enabled=false;
  499. }
  500. else
  501. {
  502. if(STR.IsDate(bookpublishdate.Text)==true)
  503. {
  504. if(sql.ExecuteSQL("update 出版社图书信息表 set bookISBN='"+bookISBN.Text+"',pressname='"+pressname.Text+"',bookname='"+bookname.Text+"',bookinfo='"+bookinfo.Text+"',bookpublishdate='"+bookpublishdate.Text+"',bookinprice='"+bookinprice.Text+"' where bookISBN='"+oldbookISBN+"'")
  505. ==false)
  506. {
  507. show();
  508. }
  509. }
  510. else
  511. {
  512. MessageBox.Show("时间格式错误!","提示");
  513. bookpublishdate.Text=oldbookpublishdate;
  514. }
  515. bookISBN.ReadOnly =true;
  516. bookname.ReadOnly  =true;
  517. bookinfo.ReadOnly  =true;
  518. bookpublishdate.ReadOnly  =true;
  519. bookinprice.ReadOnly =true;
  520. butAlter.Text="修改";
  522. butAdd.Enabled=true;
  523. butDelete.Enabled=true;
  524. butFirst.Enabled=true;
  525. butPrev.Enabled=true;
  526. butNext.Enabled=true;
  527. butLast.Enabled=true;
  528. butSearch.Enabled=true;
  529. butBuy.Enabled=true;
  530. butThisQuarter.Enabled=true;
  531. butThisYear.Enabled=true;
  532. butAll.Enabled=true;
  533. }
  534. }
  536. private void butAdd_Click(object sender, System.EventArgs e)
  537. {
  538. if(butAdd.Text=="添加")
  539. {
  540. butAdd.Text="提交";
  541. bookISBN.Text="";
  542. bookname.Text="";
  543. bookinfo.Text="";
  544. bookpublishdate.Text="";
  545. bookinprice.Text="";
  546. bookISBN.ReadOnly =false;
  547. bookname.ReadOnly  =false;
  548. bookinfo.ReadOnly  =false;
  549. bookpublishdate.ReadOnly  =false;
  550. bookinprice.ReadOnly  =false;
  552. butAlter.Enabled=false;
  553. butDelete.Enabled=false;
  554. butFirst.Enabled=false;
  555. butPrev.Enabled=false;
  556. butNext.Enabled=false;
  557. butLast.Enabled=false;
  558. butSearch.Enabled=false;
  559. butBuy.Enabled=false;
  560. butThisQuarter.Enabled=false;
  561. butThisYear.Enabled=false;
  562. butAll.Enabled=false;
  563. }
  564. else
  565. {
  566. if(STR.IsDate(bookpublishdate.Text)==true)
  567. {
  568. if(sql.ExecuteSQL("insert into 出版社图书信息表 values('"+bookISBN.Text+"','"+pressname.Text+"','"+bookname.Text+"','"+bookinfo.Text+"','"+bookpublishdate.Text+"','"+bookinprice.Text+"')")
  569. ==false)
  570. {
  571. show();
  572. }
  573. }
  574. else
  575. {
  576. MessageBox.Show("时间格式错误!","提示");
  577. show();
  578. }
  579. bookISBN.ReadOnly =true;
  580. bookname.ReadOnly  =true;
  581. bookinfo.ReadOnly  =true;
  582. bookpublishdate.ReadOnly  =true;
  583. bookinprice.ReadOnly  =true;
  584. butAdd.Text="添加";
  586. butAlter.Enabled=true;
  587. butDelete.Enabled=true;
  588. butFirst.Enabled=true;
  589. butPrev.Enabled=true;
  590. butNext.Enabled=true;
  591. butLast.Enabled=true;
  592. butSearch.Enabled=true;
  593. butBuy.Enabled=true;
  594. butThisQuarter.Enabled=true;
  595. butThisYear.Enabled=true;
  596. butAll.Enabled=true;
  597. }
  598. }
  600. private void butDelete_Click(object sender, System.EventArgs e)
  601. {
  602. sql.ExecuteSQL("delete from 出版社图书信息表 where bookISBN='"+bookISBN.Text+"'");
  603. show();
  604. }
  606. private void butThisQuarter_Click(object sender, System.EventArgs e)
  607. {
  608. int month=System.DateTime.Now.Month;
  609. int space=(3-month%3)%3;
  610. string min=System.DateTime.Now.Year.ToString()+STR.add0(Convert.ToString(month+space-2))+"00";
  611. string max=System.DateTime.Now.Year.ToString()+STR.add0(Convert.ToString(month+space))+"99";
  612. sql.ExecuteSQL("select * from 出版社图书信息表 where bookpublishdate>'"+min+"' and bookpublishdate<'"+max+"'");
  613. show();
  614. }
  616. private void butThisYear_Click(object sender, System.EventArgs e)
  617. {
  618. string min=System.DateTime.Now.Year.ToString()+"0000";
  619. string max=System.DateTime.Now.Year.ToString()+"9999";
  620. sql.ExecuteSQL("select * from 出版社图书信息表 where bookpublishdate>'"+min+"' and bookpublishdate<'"+max+"'");
  621. show();
  622. }
  624. private void butAll_Click(object sender, System.EventArgs e)
  625. {
  626. sql.ExecuteSQL("select * from 出版社图书信息表 where pressname='"+pressname.Text+"'");
  627. show();
  628. }
  630. private void butSearch_Click(object sender, System.EventArgs e)
  631. {
  632. sql.ExecuteSQL("select * from 出版社图书信息表 where bookname='"+textForSearch.Text+"'");
  633. show();
  634. }
  635. }
  636. }