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

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

教育系统应用

开发平台：

C#

Form_Customer.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_Customer 的摘要说明。
  11. /// </summary>
  12. public class Form_Customer : System.Windows.Forms.Form
  13. {
  14. private System.Windows.Forms.TextBox customeremail;
  15. private System.Windows.Forms.TextBox customersex;
  16. private System.Windows.Forms.TextBox customertelephone;
  17. private System.Windows.Forms.TextBox customeraddress;
  18. private System.Windows.Forms.TextBox customerinfo;
  19. private System.Windows.Forms.Label label5;
  20. private System.Windows.Forms.Label label4;
  21. private System.Windows.Forms.Label label3;
  22. private System.Windows.Forms.Label label2;
  23. private System.Windows.Forms.Label label1;
  24. private System.Windows.Forms.TextBox customername;
  25. private System.Windows.Forms.TextBox customerID;
  26. private System.Windows.Forms.Label label7;
  27. private System.Windows.Forms.Label label8;
  28. private System.Windows.Forms.ComboBox comboBox2;
  29. private System.Windows.Forms.Button butSearch;
  30. private System.Windows.Forms.ComboBox comboBox1;
  31. private System.Windows.Forms.Label label6;
  32. private System.Windows.Forms.Button butLast;
  33. private System.Windows.Forms.Button butFirst;
  34. private System.Windows.Forms.Button butNext;
  35. private System.Windows.Forms.Button butPrev;
  36. private System.Windows.Forms.Button butDelete;
  37. private System.Windows.Forms.Button butAdd;
  38. private System.Windows.Forms.Button butAlter;
  39. private System.Windows.Forms.Button AddOrder;
  40. private System.Windows.Forms.Button butLookOverOrders;
  41. private System.Windows.Forms.TextBox textForSearch;
  42. private System.Windows.Forms.Button butShowAll;
  43. /// <summary>
  44. /// 必需的设计器变量。
  45. /// </summary>
  46. private System.ComponentModel.Container components = null;
  48. public Form_Customer()
  49. {
  50. //
  51. // Windows 窗体设计器支持所必需的
  52. //
  53. InitializeComponent();
  55. //
  56. // TODO: 在 InitializeComponent 调用后添加任何构造函数代码
  57. //
  58. }
  60. /// <summary>
  61. /// 清理所有正在使用的资源。
  62. /// </summary>
  63. protected override void Dispose( bool disposing )
  64. {
  65. if( disposing )
  66. {
  67. if(components != null)
  68. {
  69. components.Dispose();
  70. }
  71. }
  72. base.Dispose( disposing );
  73. }
  75. #region Windows 窗体设计器生成的代码
  76. /// <summary>
  77. /// 设计器支持所需的方法 - 不要使用代码编辑器修改
  78. /// 此方法的内容。
  79. /// </summary>
  80. private void InitializeComponent()
  81. {
  82. System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(Form_Customer));
  83. this.customeremail = new System.Windows.Forms.TextBox();
  84. this.customersex = new System.Windows.Forms.TextBox();
  85. this.customertelephone = new System.Windows.Forms.TextBox();
  86. this.customeraddress = new System.Windows.Forms.TextBox();
  87. this.customerinfo = new System.Windows.Forms.TextBox();
  88. this.label5 = new System.Windows.Forms.Label();
  89. this.label4 = new System.Windows.Forms.Label();
  90. this.label3 = new System.Windows.Forms.Label();
  91. this.label2 = new System.Windows.Forms.Label();
  92. this.label1 = new System.Windows.Forms.Label();
  93. this.AddOrder = new System.Windows.Forms.Button();
  94. this.butLookOverOrders = new System.Windows.Forms.Button();
  95. this.customername = new System.Windows.Forms.TextBox();
  96. this.customerID = new System.Windows.Forms.TextBox();
  97. this.label7 = new System.Windows.Forms.Label();
  98. this.label8 = new System.Windows.Forms.Label();
  99. this.comboBox2 = new System.Windows.Forms.ComboBox();
  100. this.textForSearch = new System.Windows.Forms.TextBox();
  101. this.butSearch = new System.Windows.Forms.Button();
  102. this.comboBox1 = new System.Windows.Forms.ComboBox();
  103. this.label6 = new System.Windows.Forms.Label();
  104. this.butLast = new System.Windows.Forms.Button();
  105. this.butFirst = new System.Windows.Forms.Button();
  106. this.butNext = new System.Windows.Forms.Button();
  107. this.butPrev = new System.Windows.Forms.Button();
  108. this.butDelete = new System.Windows.Forms.Button();
  109. this.butAdd = new System.Windows.Forms.Button();
  110. this.butAlter = new System.Windows.Forms.Button();
  111. this.butShowAll = new System.Windows.Forms.Button();
  112. this.SuspendLayout();
  113. // 
  114. // customeremail
  115. // 
  116. this.customeremail.Location = new System.Drawing.Point(177, 216);
  117. this.customeremail.Name = "customeremail";
  118. this.customeremail.ReadOnly = true;
  119. this.customeremail.Size = new System.Drawing.Size(216, 21);
  120. this.customeremail.TabIndex = 23;
  121. this.customeremail.Text = "customere-mail";
  122. // 
  123. // customersex
  124. // 
  125. this.customersex.Location = new System.Drawing.Point(177, 184);
  126. this.customersex.Name = "customersex";
  127. this.customersex.ReadOnly = true;
  128. this.customersex.Size = new System.Drawing.Size(216, 21);
  129. this.customersex.TabIndex = 22;
  130. this.customersex.Text = "customersex";
  131. // 
  132. // customertelephone
  133. // 
  134. this.customertelephone.Location = new System.Drawing.Point(177, 152);
  135. this.customertelephone.Name = "customertelephone";
  136. this.customertelephone.ReadOnly = true;
  137. this.customertelephone.Size = new System.Drawing.Size(216, 21);
  138. this.customertelephone.TabIndex = 21;
  139. this.customertelephone.Text = "customertelephone";
  140. // 
  141. // customeraddress
  142. // 
  143. this.customeraddress.Location = new System.Drawing.Point(177, 120);
  144. this.customeraddress.Name = "customeraddress";
  145. this.customeraddress.ReadOnly = true;
  146. this.customeraddress.Size = new System.Drawing.Size(216, 21);
  147. this.customeraddress.TabIndex = 20;
  148. this.customeraddress.Text = "customeraddress";
  149. // 
  150. // customerinfo
  151. // 
  152. this.customerinfo.Location = new System.Drawing.Point(177, 88);
  153. this.customerinfo.Name = "customerinfo";
  154. this.customerinfo.ReadOnly = true;
  155. this.customerinfo.Size = new System.Drawing.Size(216, 21);
  156. this.customerinfo.TabIndex = 19;
  157. this.customerinfo.Text = "customerinfo";
  158. // 
  159. // label5
  160. // 
  161. this.label5.BackColor = System.Drawing.Color.Transparent;
  162. this.label5.Location = new System.Drawing.Point(80, 216);
  163. this.label5.Name = "label5";
  164. this.label5.Size = new System.Drawing.Size(65, 16);
  165. this.label5.TabIndex = 17;
  166. this.label5.Text = "E-mail";
  167. // 
  168. // label4
  169. // 
  170. this.label4.BackColor = System.Drawing.Color.Transparent;
  171. this.label4.Location = new System.Drawing.Point(80, 184);
  172. this.label4.Name = "label4";
  173. this.label4.Size = new System.Drawing.Size(65, 16);
  174. this.label4.TabIndex = 16;
  175. this.label4.Text = "客户性别";
  176. // 
  177. // label3
  178. // 
  179. this.label3.BackColor = System.Drawing.Color.Transparent;
  180. this.label3.Location = new System.Drawing.Point(80, 152);
  181. this.label3.Name = "label3";
  182. this.label3.Size = new System.Drawing.Size(65, 16);
  183. this.label3.TabIndex = 15;
  184. this.label3.Text = "联系电话";
  185. // 
  186. // label2
  187. // 
  188. this.label2.BackColor = System.Drawing.Color.Transparent;
  189. this.label2.Location = new System.Drawing.Point(80, 120);
  190. this.label2.Name = "label2";
  191. this.label2.Size = new System.Drawing.Size(65, 16);
  192. this.label2.TabIndex = 14;
  193. this.label2.Text = "客户地址";
  194. // 
  195. // label1
  196. // 
  197. this.label1.BackColor = System.Drawing.Color.Transparent;
  198. this.label1.Location = new System.Drawing.Point(80, 88);
  199. this.label1.Name = "label1";
  200. this.label1.Size = new System.Drawing.Size(65, 16);
  201. this.label1.TabIndex = 13;
  202. this.label1.Text = "客户信息";
  203. // 
  204. // AddOrder
  205. // 
  206. this.AddOrder.BackColor = System.Drawing.Color.Transparent;
  207. this.AddOrder.Location = new System.Drawing.Point(108, 272);
  208. this.AddOrder.Name = "AddOrder";
  209. this.AddOrder.Size = new System.Drawing.Size(64, 24);
  210. this.AddOrder.TabIndex = 26;
  211. this.AddOrder.Text = "添加订单";
  212. this.AddOrder.Click += new System.EventHandler(this.AddOrder_Click);
  213. // 
  214. // butLookOverOrders
  215. // 
  216. this.butLookOverOrders.BackColor = System.Drawing.Color.Transparent;
  217. this.butLookOverOrders.Location = new System.Drawing.Point(44, 272);
  218. this.butLookOverOrders.Name = "butLookOverOrders";
  219. this.butLookOverOrders.Size = new System.Drawing.Size(64, 24);
  220. this.butLookOverOrders.TabIndex = 25;
  221. this.butLookOverOrders.Text = "查看定单";
  222. this.butLookOverOrders.Click += new System.EventHandler(this.butLookOverOrders_Click);
  223. // 
  224. // customername
  225. // 
  226. this.customername.Location = new System.Drawing.Point(177, 56);
  227. this.customername.Name = "customername";
  228. this.customername.ReadOnly = true;
  229. this.customername.Size = new System.Drawing.Size(216, 21);
  230. this.customername.TabIndex = 33;
  231. this.customername.Text = "customername";
  232. // 
  233. // customerID
  234. // 
  235. this.customerID.Location = new System.Drawing.Point(177, 24);
  236. this.customerID.Name = "customerID";
  237. this.customerID.ReadOnly = true;
  238. this.customerID.Size = new System.Drawing.Size(216, 21);
  239. this.customerID.TabIndex = 32;
  240. this.customerID.Text = "customerID";
  241. // 
  242. // label7
  243. // 
  244. this.label7.BackColor = System.Drawing.Color.Transparent;
  245. this.label7.Location = new System.Drawing.Point(80, 56);
  246. this.label7.Name = "label7";
  247. this.label7.Size = new System.Drawing.Size(65, 16);
  248. this.label7.TabIndex = 31;
  249. this.label7.Text = "客户名称";
  250. // 
  251. // label8
  252. // 
  253. this.label8.BackColor = System.Drawing.Color.Transparent;
  254. this.label8.Location = new System.Drawing.Point(80, 24);
  255. this.label8.Name = "label8";
  256. this.label8.Size = new System.Drawing.Size(65, 16);
  257. this.label8.TabIndex = 30;
  258. this.label8.Text = "客户ID";
  259. // 
  260. // comboBox2
  261. // 
  262. this.comboBox2.Items.AddRange(new object[] {
  263.    "模糊",
  264.    "精确"});
  265. this.comboBox2.Location = new System.Drawing.Point(188, 312);
  266. this.comboBox2.MaxDropDownItems = 2;
  267. this.comboBox2.Name = "comboBox2";
  268. this.comboBox2.Size = new System.Drawing.Size(48, 20);
  269. this.comboBox2.TabIndex = 38;
  270. this.comboBox2.Text = "模糊";
  271. // 
  272. // textForSearch
  273. // 
  274. this.textForSearch.Location = new System.Drawing.Point(252, 312);
  275. this.textForSearch.Name = "textForSearch";
  276. this.textForSearch.Size = new System.Drawing.Size(96, 21);
  277. this.textForSearch.TabIndex = 37;
  278. this.textForSearch.Text = "";
  279. // 
  280. // butSearch
  281. // 
  282. this.butSearch.BackColor = System.Drawing.Color.Transparent;
  283. this.butSearch.Location = new System.Drawing.Point(364, 312);
  284. this.butSearch.Name = "butSearch";
  285. this.butSearch.Size = new System.Drawing.Size(64, 24);
  286. this.butSearch.TabIndex = 36;
  287. this.butSearch.Text = "查找客户";
  288. this.butSearch.Click += new System.EventHandler(this.butSearch_Click);
  289. // 
  290. // comboBox1
  291. // 
  292. this.comboBox1.Items.AddRange(new object[] {
  293.    "客户名称",
  294.    "E-mail"});
  295. this.comboBox1.Location = new System.Drawing.Point(100, 312);
  296. this.comboBox1.MaxDropDownItems = 2;
  297. this.comboBox1.Name = "comboBox1";
  298. this.comboBox1.Size = new System.Drawing.Size(80, 20);
  299. this.comboBox1.TabIndex = 35;
  300. this.comboBox1.Text = "客户名称";
  301. // 
  302. // label6
  303. // 
  304. this.label6.BackColor = System.Drawing.Color.Transparent;
  305. this.label6.Location = new System.Drawing.Point(44, 312);
  306. this.label6.Name = "label6";
  307. this.label6.Size = new System.Drawing.Size(56, 16);
  308. this.label6.TabIndex = 34;
  309. this.label6.Text = "查找方式";
  310. // 
  311. // butLast
  312. // 
  313. this.butLast.BackColor = System.Drawing.Color.Transparent;
  314. this.butLast.Location = new System.Drawing.Point(292, 344);
  315. this.butLast.Name = "butLast";
  316. this.butLast.Size = new System.Drawing.Size(56, 24);
  317. this.butLast.TabIndex = 42;
  318. this.butLast.Text = ">|";
  319. this.butLast.Click += new System.EventHandler(this.butLast_Click);
  320. // 
  321. // butFirst
  322. // 
  323. this.butFirst.BackColor = System.Drawing.Color.Transparent;
  324. this.butFirst.Location = new System.Drawing.Point(124, 344);
  325. this.butFirst.Name = "butFirst";
  326. this.butFirst.Size = new System.Drawing.Size(56, 24);
  327. this.butFirst.TabIndex = 41;
  328. this.butFirst.Text = "|<";
  329. this.butFirst.Click += new System.EventHandler(this.butFirst_Click);
  330. // 
  331. // butNext
  332. // 
  333. this.butNext.BackColor = System.Drawing.Color.Transparent;
  334. this.butNext.Location = new System.Drawing.Point(236, 344);
  335. this.butNext.Name = "butNext";
  336. this.butNext.Size = new System.Drawing.Size(56, 24);
  337. this.butNext.TabIndex = 40;
  338. this.butNext.Text = ">";
  339. this.butNext.Click += new System.EventHandler(this.butNext_Click);
  340. // 
  341. // butPrev
  342. // 
  343. this.butPrev.BackColor = System.Drawing.Color.Transparent;
  344. this.butPrev.Location = new System.Drawing.Point(180, 344);
  345. this.butPrev.Name = "butPrev";
  346. this.butPrev.Size = new System.Drawing.Size(56, 24);
  347. this.butPrev.TabIndex = 39;
  348. this.butPrev.Text = "<";
  349. this.butPrev.Click += new System.EventHandler(this.butPrev_Click);
  350. // 
  351. // butDelete
  352. // 
  353. this.butDelete.BackColor = System.Drawing.Color.Transparent;
  354. this.butDelete.Location = new System.Drawing.Point(300, 272);
  355. this.butDelete.Name = "butDelete";
  356. this.butDelete.Size = new System.Drawing.Size(64, 24);
  357. this.butDelete.TabIndex = 48;
  358. this.butDelete.Text = "删除";
  359. this.butDelete.Click += new System.EventHandler(this.butDelete_Click);
  360. // 
  361. // butAdd
  362. // 
  363. this.butAdd.BackColor = System.Drawing.Color.Transparent;
  364. this.butAdd.Location = new System.Drawing.Point(236, 272);
  365. this.butAdd.Name = "butAdd";
  366. this.butAdd.Size = new System.Drawing.Size(64, 24);
  367. this.butAdd.TabIndex = 47;
  368. this.butAdd.Text = "添加";
  369. this.butAdd.Click += new System.EventHandler(this.butAdd_Click);
  370. // 
  371. // butAlter
  372. // 
  373. this.butAlter.BackColor = System.Drawing.Color.Transparent;
  374. this.butAlter.Location = new System.Drawing.Point(172, 272);
  375. this.butAlter.Name = "butAlter";
  376. this.butAlter.Size = new System.Drawing.Size(64, 24);
  377. this.butAlter.TabIndex = 46;
  378. this.butAlter.Text = "修改";
  379. this.butAlter.Click += new System.EventHandler(this.butAlter_Click);
  380. // 
  381. // butShowAll
  382. // 
  383. this.butShowAll.BackColor = System.Drawing.Color.Transparent;
  384. this.butShowAll.Location = new System.Drawing.Point(364, 272);
  385. this.butShowAll.Name = "butShowAll";
  386. this.butShowAll.Size = new System.Drawing.Size(64, 24);
  387. this.butShowAll.TabIndex = 49;
  388. this.butShowAll.Text = "全部显示";
  389. this.butShowAll.Click += new System.EventHandler(this.butShowAll_Click);
  390. // 
  391. // Form_Customer
  392. // 
  393. this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
  394. this.BackgroundImage = ((System.Drawing.Image)(resources.GetObject("$this.BackgroundImage")));
  395. this.ClientSize = new System.Drawing.Size(472, 382);
  396. this.ControlBox = false;
  397. this.Controls.Add(this.butShowAll);
  398. this.Controls.Add(this.butDelete);
  399. this.Controls.Add(this.butAdd);
  400. this.Controls.Add(this.butAlter);
  401. this.Controls.Add(this.butLast);
  402. this.Controls.Add(this.butFirst);
  403. this.Controls.Add(this.butNext);
  404. this.Controls.Add(this.butPrev);
  405. this.Controls.Add(this.comboBox2);
  406. this.Controls.Add(this.textForSearch);
  407. this.Controls.Add(this.customername);
  408. this.Controls.Add(this.customerID);
  409. this.Controls.Add(this.customeremail);
  410. this.Controls.Add(this.customersex);
  411. this.Controls.Add(this.customertelephone);
  412. this.Controls.Add(this.customeraddress);
  413. this.Controls.Add(this.customerinfo);
  414. this.Controls.Add(this.butSearch);
  415. this.Controls.Add(this.comboBox1);
  416. this.Controls.Add(this.label6);
  417. this.Controls.Add(this.label7);
  418. this.Controls.Add(this.label8);
  419. this.Controls.Add(this.AddOrder);
  420. this.Controls.Add(this.butLookOverOrders);
  421. this.Controls.Add(this.label5);
  422. this.Controls.Add(this.label4);
  423. this.Controls.Add(this.label3);
  424. this.Controls.Add(this.label2);
  425. this.Controls.Add(this.label1);
  426. this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.None;
  427. this.Name = "Form_Customer";
  428. this.StartPosition = System.Windows.Forms.FormStartPosition.Manual;
  429. this.Text = "Form_Customer";
  430. this.Load += new System.EventHandler(this.Form_Customer_Load);
  431. this.ResumeLayout(false);
  433. }
  434. #endregion
  436. SQL sql;
  437. string oldcustomerID="";
  438. public static string CUSTOMERID="";
  439. public static string CUSTOMERNAME="";
  441. private void butLookOverOrders_Click(object sender, System.EventArgs e)
  442. {
  443. Form_Customer_LookOverOrders child=new Form_Customer_LookOverOrders();
  444. child.ShowDialog();
  445. }
  447. private void AddOrder_Click(object sender, System.EventArgs e)
  448. {
  449. if(customerID.Text!="")
  450. {
  451. Form_Customer_AddOrder child=new Form_Customer_AddOrder();
  452. child.ShowDialog();
  453. }
  454. else
  455. {
  456. MessageBox.Show("请先选择一个客户!","提示");
  457. }
  458. }
  460. public void show()
  461. {
  462. if(sql.rows.GetLength(0)!=0)
  463. {
  464. customerID.Text=sql.rows[sql.getPos(),0].ToString();
  465. customername.Text=sql.rows[sql.getPos(),1].ToString();
  466. customerinfo.Text=sql.rows[sql.getPos(),2].ToString();
  467. customeraddress.Text=sql.rows[sql.getPos(),3].ToString();
  468. customertelephone.Text=sql.rows[sql.getPos(),4].ToString();
  469. customersex.Text=sql.rows[sql.getPos(),5].ToString();
  470. customeremail.Text=sql.rows[sql.getPos(),6].ToString();
  471. }
  472. else
  473. {
  474. customerID.Text="";
  475. customername.Text="";
  476. customerinfo.Text="";
  477. customeraddress.Text="";
  478. customertelephone.Text="";
  479. customersex.Text="";
  480. customeremail.Text="";
  481. MessageBox.Show("无符合查询条件的结果!","提示");
  482. }
  483. CUSTOMERID=customerID.Text;
  484. CUSTOMERNAME=customername.Text;
  485. }
  487. private void Form_Customer_Load(object sender, System.EventArgs e)
  488. {
  489. sql=new SQL("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=图书管理系统数据库.mdb");
  490. sql.ExecuteSQL("select * from 客户信息表 order by customerID");
  491. show();
  492. }
  494. private void butFirst_Click(object sender, System.EventArgs e)
  495. {
  496. sql.pointToFirst();
  497. show();
  498. }
  500. private void butPrev_Click(object sender, System.EventArgs e)
  501. {
  502. sql.pointToPrev();
  503. show();
  504. }
  506. private void butNext_Click(object sender, System.EventArgs e)
  507. {
  508. sql.pointToNext();
  509. show();
  510. }
  512. private void butLast_Click(object sender, System.EventArgs e)
  513. {
  514. sql.pointToLast();
  515. show();
  516. }
  518. private void butAlter_Click(object sender, System.EventArgs e)
  519. {
  520. if(butAlter.Text=="修改")
  521. {
  522. butAlter.Text="更新";
  523. oldcustomerID=customerID.Text;
  524. customerID.ReadOnly=false;
  525. customername.ReadOnly=false;
  526. customerinfo.ReadOnly=false;
  527. customeraddress.ReadOnly=false;
  528. customertelephone.ReadOnly=false;
  529. customersex.ReadOnly=false;
  530. customeremail.ReadOnly=false;
  532. butAdd.Enabled=false;
  533. butDelete.Enabled=false;
  534. butFirst.Enabled=false;
  535. butPrev.Enabled=false;
  536. butNext.Enabled=false;
  537. butLast.Enabled=false;
  538. butSearch.Enabled=false;
  539. butLookOverOrders.Enabled=false;
  540. butShowAll.Enabled=false;
  541. AddOrder.Enabled=false;
  542. }
  543. else
  544. {
  545. if(sql.ExecuteSQL("update 客户信息表 set customerID='"+customerID.Text
  546. +"',customername='"+customername.Text
  547. +"',customerinfo='"+customerinfo.Text
  548. +"',customeraddress='"+customeraddress.Text
  549. +"',customertelephone='"+customertelephone.Text
  550. +"',customersex='"+customersex.Text
  551. +"',customeremail='"+customeremail.Text+"' where customerID='"+oldcustomerID+"'")
  552. ==false||
  553. sql.ExecuteSQL("update 客户订单信息表 set customerID='"+customerID.Text
  554. +"' where customerID='"+oldcustomerID+"'")
  555. ==false)
  556. {
  557. show();
  558. }
  559. else
  560. {
  561. CUSTOMERID=customerID.Text;
  562. CUSTOMERNAME=customername.Text;
  563. }
  564. customerID.ReadOnly=true;
  565. customername.ReadOnly=true;
  566. customerinfo.ReadOnly=true;
  567. customeraddress.ReadOnly=true;
  568. customertelephone.ReadOnly=true;
  569. customersex.ReadOnly=true;
  570. customeremail.ReadOnly=true;
  571. butAlter.Text="修改";
  573. butAdd.Enabled=true;
  574. butDelete.Enabled=true;
  575. butFirst.Enabled=true;
  576. butPrev.Enabled=true;
  577. butNext.Enabled=true;
  578. butLast.Enabled=true;
  579. butSearch.Enabled=true;
  580. butLookOverOrders.Enabled=true;
  581. AddOrder.Enabled=true;
  582. butShowAll.Enabled=true;
  583. }
  584. }
  586. private void butAdd_Click(object sender, System.EventArgs e)
  587. {
  588. try
  589. {
  590. if(butAdd.Text=="添加")
  591. {
  592. butAdd.Text="提交";
  593. customerID.Text="";
  594. customername.Text="";
  595. customerinfo.Text="";
  596. customeraddress.Text="";
  597. customertelephone.Text="";
  598. customersex.Text="";
  599. customeremail.Text="";
  600. customerID.ReadOnly=false;
  601. customername.ReadOnly=false;
  602. customerinfo.ReadOnly=false;
  603. customeraddress.ReadOnly=false;
  604. customertelephone.ReadOnly=false;
  605. customersex.ReadOnly=false;
  606. customeremail.ReadOnly=false;
  608. butAlter.Enabled=false;
  609. butDelete.Enabled=false;
  610. butFirst.Enabled=false;
  611. butPrev.Enabled=false;
  612. butNext.Enabled=false;
  613. butLast.Enabled=false;
  614. butSearch.Enabled=false;
  615. butLookOverOrders.Enabled=false;
  616. AddOrder.Enabled=false;
  617. butShowAll.Enabled=false;
  618. }
  619. else
  620. {
  621. if(sql.ExecuteSQL("insert into 客户信息表 values('"
  622. +customerID.Text+"','"+customername.Text+"','"+customerinfo.Text+"','"
  623. +customeraddress.Text+"','"+customertelephone.Text+"','"
  624. +customersex.Text+"','"+customeremail.Text+"')")
  625. ==false)
  626. {
  627. show();
  628. }
  629. else
  630. {
  631. CUSTOMERID=customerID.Text;
  632. CUSTOMERNAME=customername.Text;
  633. }
  634. customerID.ReadOnly=true;
  635. customername.ReadOnly=true;
  636. customerinfo.ReadOnly=true;
  637. customeraddress.ReadOnly=true;
  638. customertelephone.ReadOnly=true;
  639. customersex.ReadOnly=true;
  640. customeremail.ReadOnly=true;
  641. butAdd.Text="添加";
  643. butAlter.Enabled=true;
  644. butDelete.Enabled=true;
  645. butFirst.Enabled=true;
  646. butPrev.Enabled=true;
  647. butNext.Enabled=true;
  648. butLast.Enabled=true;
  649. butSearch.Enabled=true;
  650. butLookOverOrders.Enabled=true;
  651. AddOrder.Enabled=true;
  652. butShowAll.Enabled=true;
  653. }
  654. }
  655. catch(Exception e1)
  656. {
  657. MessageBox.Show(e1.Message);
  658. }
  659. }
  661. private void butDelete_Click(object sender, System.EventArgs e)
  662. {
  663. sql.ExecuteSQL("delete from 客户信息表 where customerID='"+customerID.Text+"'");
  664. show();
  665. }
  667. private void butSearch_Click(object sender, System.EventArgs e)
  668. {
  669. if(comboBox1.Text=="客户名称")
  670. {
  671. if(comboBox2.Text=="精确")
  672. {
  673. sql.ExecuteSQL("select * from 客户信息表 where customername='"+textForSearch.Text+"' order by customerID");
  674. show();
  675. }
  676. else
  677. {
  678. sql.ExecuteSQL("select * from 客户信息表 where customername like '%"+textForSearch.Text+"%' order by customerID");
  679. show();
  680. }
  681. }
  682. else
  683. {
  684. if(comboBox2.Text=="精确")
  685. {
  686. sql.ExecuteSQL("select * from 客户信息表 where customeremail='"+textForSearch.Text+"' order by customerID");
  687. show();
  688. }
  689. else
  690. {
  691. sql.ExecuteSQL("select * from 客户信息表 where customeremail like '%"+textForSearch.Text+"%' order by customerID");
  692. show();
  693. }
  694. }
  695. }
  697. private void butShowAll_Click(object sender, System.EventArgs e)
  698. {
  699. sql.ExecuteSQL("select * from 客户信息表 order by customerID");
  700. show();
  701. }
  702. }
  703. }