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

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

教育系统应用

开发平台：

C#

Form_Publisher_BookManagement_Buy.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_Buy 的摘要说明。
  11. /// </summary>
  12. public class Form_Publisher_BookManagement_Buy : System.Windows.Forms.Form
  13. {
  14. private System.Windows.Forms.Label label2;
  15. private System.Windows.Forms.Label label1;
  16. private System.Windows.Forms.Label label3;
  17. private System.Windows.Forms.Button butCommit;
  18. private System.Windows.Forms.Button butCancel;
  19. private System.Windows.Forms.TextBox AccountNumber;
  20. private System.Windows.Forms.TextBox bookISBN;
  21. private System.Windows.Forms.TextBox amount;
  22. private System.Windows.Forms.TextBox bookinprice;
  23. private System.Windows.Forms.Label label4;
  24. private System.Windows.Forms.TextBox bookoutprice;
  25. private System.Windows.Forms.Label label5;
  26. /// <summary>
  27. /// 必需的设计器变量。
  28. /// </summary>
  29. private System.ComponentModel.Container components = null;
  31. public Form_Publisher_BookManagement_Buy()
  32. {
  33. //
  34. // Windows 窗体设计器支持所必需的
  35. //
  36. InitializeComponent();
  38. //
  39. // TODO: 在 InitializeComponent 调用后添加任何构造函数代码
  40. //
  41. }
  43. /// <summary>
  44. /// 清理所有正在使用的资源。
  45. /// </summary>
  46. protected override void Dispose( bool disposing )
  47. {
  48. if( disposing )
  49. {
  50. if(components != null)
  51. {
  52. components.Dispose();
  53. }
  54. }
  55. base.Dispose( disposing );
  56. }
  58. #region Windows 窗体设计器生成的代码
  59. /// <summary>
  60. /// 设计器支持所需的方法 - 不要使用代码编辑器修改
  61. /// 此方法的内容。
  62. /// </summary>
  63. private void InitializeComponent()
  64. {
  65. System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(Form_Publisher_BookManagement_Buy));
  66. this.AccountNumber = new System.Windows.Forms.TextBox();
  67. this.amount = new System.Windows.Forms.TextBox();
  68. this.label2 = new System.Windows.Forms.Label();
  69. this.label1 = new System.Windows.Forms.Label();
  70. this.bookISBN = new System.Windows.Forms.TextBox();
  71. this.label3 = new System.Windows.Forms.Label();
  72. this.butCommit = new System.Windows.Forms.Button();
  73. this.butCancel = new System.Windows.Forms.Button();
  74. this.bookinprice = new System.Windows.Forms.TextBox();
  75. this.label4 = new System.Windows.Forms.Label();
  76. this.bookoutprice = new System.Windows.Forms.TextBox();
  77. this.label5 = new System.Windows.Forms.Label();
  78. this.SuspendLayout();
  79. // 
  80. // AccountNumber
  81. // 
  82. this.AccountNumber.Location = new System.Drawing.Point(162, 184);
  83. this.AccountNumber.Name = "AccountNumber";
  84. this.AccountNumber.Size = new System.Drawing.Size(208, 21);
  85. this.AccountNumber.TabIndex = 7;
  86. this.AccountNumber.Text = "";
  87. // 
  88. // amount
  89. // 
  90. this.amount.Cursor = System.Windows.Forms.Cursors.IBeam;
  91. this.amount.Location = new System.Drawing.Point(162, 144);
  92. this.amount.Name = "amount";
  93. this.amount.Size = new System.Drawing.Size(208, 21);
  94. this.amount.TabIndex = 6;
  95. this.amount.Text = "";
  96. // 
  97. // label2
  98. // 
  99. this.label2.BackColor = System.Drawing.Color.Transparent;
  100. this.label2.Location = new System.Drawing.Point(54, 184);
  101. this.label2.Name = "label2";
  102. this.label2.Size = new System.Drawing.Size(76, 24);
  103. this.label2.TabIndex = 5;
  104. this.label2.Text = "银行账号";
  105. // 
  106. // label1
  107. // 
  108. this.label1.BackColor = System.Drawing.Color.Transparent;
  109. this.label1.Location = new System.Drawing.Point(54, 144);
  110. this.label1.Name = "label1";
  111. this.label1.Size = new System.Drawing.Size(76, 24);
  112. this.label1.TabIndex = 4;
  113. this.label1.Text = "购买数量";
  114. // 
  115. // bookISBN
  116. // 
  117. this.bookISBN.Location = new System.Drawing.Point(162, 24);
  118. this.bookISBN.Name = "bookISBN";
  119. this.bookISBN.ReadOnly = true;
  120. this.bookISBN.Size = new System.Drawing.Size(208, 21);
  121. this.bookISBN.TabIndex = 9;
  122. this.bookISBN.Text = "bookISBN";
  123. // 
  124. // label3
  125. // 
  126. this.label3.BackColor = System.Drawing.Color.Transparent;
  127. this.label3.Location = new System.Drawing.Point(54, 24);
  128. this.label3.Name = "label3";
  129. this.label3.Size = new System.Drawing.Size(76, 24);
  130. this.label3.TabIndex = 8;
  131. this.label3.Text = "ISBN";
  132. // 
  133. // butCommit
  134. // 
  135. this.butCommit.BackColor = System.Drawing.Color.Transparent;
  136. this.butCommit.Location = new System.Drawing.Point(96, 232);
  137. this.butCommit.Name = "butCommit";
  138. this.butCommit.Size = new System.Drawing.Size(80, 24);
  139. this.butCommit.TabIndex = 10;
  140. this.butCommit.Text = "提交";
  141. this.butCommit.Click += new System.EventHandler(this.butCommit_Click);
  142. // 
  143. // butCancel
  144. // 
  145. this.butCancel.BackColor = System.Drawing.Color.Transparent;
  146. this.butCancel.Location = new System.Drawing.Point(248, 232);
  147. this.butCancel.Name = "butCancel";
  148. this.butCancel.Size = new System.Drawing.Size(80, 24);
  149. this.butCancel.TabIndex = 11;
  150. this.butCancel.Text = "取消";
  151. this.butCancel.Click += new System.EventHandler(this.butCancel_Click);
  152. // 
  153. // bookinprice
  154. // 
  155. this.bookinprice.Cursor = System.Windows.Forms.Cursors.IBeam;
  156. this.bookinprice.Location = new System.Drawing.Point(162, 64);
  157. this.bookinprice.Name = "bookinprice";
  158. this.bookinprice.ReadOnly = true;
  159. this.bookinprice.Size = new System.Drawing.Size(208, 21);
  160. this.bookinprice.TabIndex = 13;
  161. this.bookinprice.Text = "bookinprice";
  162. // 
  163. // label4
  164. // 
  165. this.label4.BackColor = System.Drawing.Color.Transparent;
  166. this.label4.Location = new System.Drawing.Point(54, 64);
  167. this.label4.Name = "label4";
  168. this.label4.Size = new System.Drawing.Size(76, 24);
  169. this.label4.TabIndex = 12;
  170. this.label4.Text = "购入价格";
  171. // 
  172. // bookoutprice
  173. // 
  174. this.bookoutprice.Cursor = System.Windows.Forms.Cursors.IBeam;
  175. this.bookoutprice.Location = new System.Drawing.Point(162, 104);
  176. this.bookoutprice.Name = "bookoutprice";
  177. this.bookoutprice.Size = new System.Drawing.Size(208, 21);
  178. this.bookoutprice.TabIndex = 15;
  179. this.bookoutprice.Text = "";
  180. // 
  181. // label5
  182. // 
  183. this.label5.BackColor = System.Drawing.Color.Transparent;
  184. this.label5.Location = new System.Drawing.Point(54, 104);
  185. this.label5.Name = "label5";
  186. this.label5.Size = new System.Drawing.Size(76, 24);
  187. this.label5.TabIndex = 14;
  188. this.label5.Text = "预定售价";
  189. // 
  190. // Form_Publisher_BookManagement_Buy
  191. // 
  192. this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
  193. this.BackgroundImage = ((System.Drawing.Image)(resources.GetObject("$this.BackgroundImage")));
  194. this.ClientSize = new System.Drawing.Size(424, 270);
  195. this.Controls.Add(this.bookoutprice);
  196. this.Controls.Add(this.bookinprice);
  197. this.Controls.Add(this.bookISBN);
  198. this.Controls.Add(this.AccountNumber);
  199. this.Controls.Add(this.amount);
  200. this.Controls.Add(this.label5);
  201. this.Controls.Add(this.label4);
  202. this.Controls.Add(this.butCancel);
  203. this.Controls.Add(this.butCommit);
  204. this.Controls.Add(this.label3);
  205. this.Controls.Add(this.label2);
  206. this.Controls.Add(this.label1);
  207. this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle;
  208. this.Name = "Form_Publisher_BookManagement_Buy";
  209. this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
  210. this.Text = "购入图书";
  211. this.Load += new System.EventHandler(this.Form_Publisher_BookManagement_Buy_Load);
  212. this.ResumeLayout(false);
  214. }
  215. #endregion
  217. SQL sql;
  218. private void Form_Publisher_BookManagement_Buy_Load(object sender, System.EventArgs e)
  219. {
  220. bookISBN.Text=Form_Publisher_BookManagement.BOOKISBN;
  221. bookinprice.Text=Form_Publisher_BookManagement.BOOKINPRICE;
  222. sql=new SQL("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=图书管理系统数据库.mdb");
  223. }
  225. private void butCommit_Click(object sender, System.EventArgs e)
  226. {
  227. try
  228. {
  229. int.Parse(amount.Text);
  230. }
  231. catch
  232. {
  233. MessageBox.Show("购买数量必须为整型数,提交失败!","提示");
  234. return;
  235. }
  236. if(amount.Text!=""&&AccountNumber.Text!="")
  237. {
  238. if(MessageBox.Show("确实要提交吗?","提示",MessageBoxButtons.YesNo)==DialogResult.Yes)
  239. {
  240. sql.ExecuteSQL("select * from 库存信息表 where bookISBN='"+bookISBN.Text+"'");
  241. if(sql.rows.GetLength(0)==0)
  242. {
  243. sql.ExecuteSQL("insert into 库存信息表 values('"+bookISBN.Text+"','"+Form_Publisher_BookManagement.PRESSNAME+"','"
  244. +Form_Publisher_BookManagement.BOOKNAME+"','"+Form_Publisher_BookManagement.BOOKINFO+"','"
  245. +Form_Publisher_BookManagement.BOOKPUBLISHDATE+"','"
  246. +Form_Publisher_BookManagement.BOOKINPRICE+"','"+bookoutprice.Text+"','"+amount.Text+"')");
  247. }
  248. else
  249. {
  250. sql.ExecuteSQL("update 库存信息表 set bookoutprice="+bookoutprice.Text+",bookquantity=bookquantity+"+amount.Text+" where bookISBN='"+bookISBN.Text+"'");
  251. }
  252. this.Close();
  253. }
  254. }
  255. }
  257. private void butCancel_Click(object sender, System.EventArgs e)
  258. {
  259. this.Close();
  260. }
  262. }
  263. }