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

源码开发语言/平台
当前位置：首页 > 源码/资料 > 行业应用 > 百货/超市行业 > 查看源码
Form1.cs
资源名称：csharpshop.rar　[点击查看]
上传用户：miknos
上传日期：2022-04-30
资源大小：802k
文件大小：65k
源码类别：

百货/超市行业

开发平台：

Visual C++

Form1.cs：源码内容
  1. using System;
  2. using System.Drawing;
  3. using System.Collections;
  4. using System.ComponentModel;
  5. using System.Windows.Forms;
  6. using System.Data;
  7. using System.Data.SqlClient;
  9. namespace supershop
  10. {
  12. /// <summary>
  13. /// Form1 的摘要说明。
  14. /// </summary>
  15. public class Form1 : System.Windows.Forms.Form
  16. {
  17. private System.Windows.Forms.StatusBar statusBar1;
  18. private System.Windows.Forms.MainMenu mainMenu1;
  19. private System.Windows.Forms.MenuItem menuItem1;
  20. private System.Data.SqlClient.SqlDataAdapter sqlDataAdapter1;
  21. private System.Data.SqlClient.SqlCommand sqlSelectCommand1;
  22. private System.Data.SqlClient.SqlCommand sqlInsertCommand1;
  23. private System.Windows.Forms.Label label1;
  24. private System.Windows.Forms.Label label2;
  25. private System.Windows.Forms.TextBox textBox1;
  26. private System.Windows.Forms.TextBox textBox2;
  27. private System.Windows.Forms.Button button1;
  28. private System.Windows.Forms.Button button2;
  29. private System.Data.SqlClient.SqlCommand sqlCommand1;
  30. private System.Windows.Forms.ListView listView1;
  31. private System.Data.OleDb.OleDbCommand oleDbSelectCommand1;
  32. private System.Data.OleDb.OleDbCommand oleDbInsertCommand1;
  33. private System.Data.OleDb.OleDbCommand oleDbUpdateCommand1;
  34. private System.Data.OleDb.OleDbCommand oleDbDeleteCommand1;
  35. private System.Data.OleDb.OleDbDataAdapter oleDbDataAdapter1;
  36. private System.Data.OleDb.OleDbConnection oleDbConnection1;
  37. private System.Data.OleDb.OleDbCommand oleDbCommand1;
  38. private System.Data.OleDb.OleDbDataAdapter oleDbDataAdapter2;
  39. private System.Data.OleDb.OleDbCommand oleDbSelectCommand2;
  40. private System.Data.OleDb.OleDbConnection oleDbConnection2;
  41. private System.Windows.Forms.ColumnHeader columnHeader1;
  42. private System.Windows.Forms.ColumnHeader columnHeader2;
  43. private System.Windows.Forms.ColumnHeader columnHeader3;
  44. private System.Windows.Forms.ColumnHeader columnHeader4;
  45. private supershop.DataSet1 dataSet11;
  46. private System.Data.SqlClient.SqlConnection myConnection;
  47. private System.Windows.Forms.ColumnHeader columnHeader5;
  48. private System.Windows.Forms.Button button3;
  49. private System.Windows.Forms.MenuItem menuItem2;
  50. private System.Windows.Forms.MenuItem menuItem3;
  51. private System.Windows.Forms.MenuItem menuItem4;
  52. private System.Windows.Forms.MenuItem menuItem5;
  53. private System.Windows.Forms.MenuItem menuItem6;
  54. private System.Windows.Forms.MenuItem menuItem7;
  55. private System.Windows.Forms.MenuItem menuItem8;
  56. private System.Windows.Forms.MenuItem menuItem9;
  57. private System.Windows.Forms.MenuItem menuItem10;
  58. private System.Windows.Forms.MenuItem menuItem11;
  59. private System.Windows.Forms.MenuItem menuItem12;
  60. private System.Windows.Forms.Panel panel1;
  61. private System.Windows.Forms.ListView listView2;
  62. private System.Windows.Forms.ColumnHeader columnHeader6;
  63. private System.Windows.Forms.ColumnHeader columnHeader7;
  64. private System.Windows.Forms.ColumnHeader columnHeader8;
  65. private System.Windows.Forms.GroupBox groupBox1;
  66. private System.Windows.Forms.Label label3;
  67. private System.Windows.Forms.Label label4;
  68. private System.Windows.Forms.Label label5;
  69. private System.Windows.Forms.ComboBox comboBox1;
  70. private System.Windows.Forms.Button button4;
  71. private System.Windows.Forms.Button button5;
  72. private System.Windows.Forms.Button button6;
  73. private System.Windows.Forms.ColumnHeader columnHeader9;
  74. private System.Windows.Forms.TextBox textBox3;
  75. private System.Windows.Forms.TextBox textBox4;
  76. private System.Windows.Forms.Panel panel2;
  77. private System.Windows.Forms.ListView listView3;
  78. private System.Windows.Forms.ColumnHeader columnHeader10;
  79. private System.Windows.Forms.ColumnHeader columnHeader11;
  80. private System.Windows.Forms.ColumnHeader columnHeader12;
  81. private System.Windows.Forms.ColumnHeader columnHeader13;
  82. private System.Windows.Forms.ColumnHeader columnHeader14;
  83. private System.Windows.Forms.ColumnHeader columnHeader15;
  84. private System.Windows.Forms.ColumnHeader columnHeader16;
  85. private System.Windows.Forms.GroupBox groupBox2;
  86. private System.Windows.Forms.Label label6;
  87. private System.Windows.Forms.Label label7;
  88. private System.Windows.Forms.Label label8;
  89. private System.Windows.Forms.Label label9;
  90. private System.Windows.Forms.Label label10;
  91. private System.Windows.Forms.TextBox textBox5;
  92. private System.Windows.Forms.TextBox textBox6;
  93. private System.Windows.Forms.TextBox textBox7;
  94. private System.Windows.Forms.TextBox textBox8;
  95. private System.Windows.Forms.TextBox textBox9;
  96. private System.Windows.Forms.GroupBox groupBox3;
  97. private System.Windows.Forms.Label label11;
  98. private System.Windows.Forms.TextBox textBox10;
  99. private System.Windows.Forms.Button button7;
  100. private System.Windows.Forms.Button button8;
  101. private System.Windows.Forms.Button button9;
  102. private System.Windows.Forms.Button button10;
  103. private System.Windows.Forms.Button button11;
  104. private System.Windows.Forms.ColumnHeader columnHeader17;
  105. private System.Data.SqlClient.SqlConnection myConnection2;
  106. private System.Windows.Forms.Label floglb;
  107. private System.Windows.Forms.Button button12;
  108. //要想在类未创建的时候引用必须将其设为static类型如下边的name
  109. public static string name;
  110. public static string isman;
  111. /// <summary>
  112. /// 必需的设计器变量。
  113. /// </summary>
  114. private System.ComponentModel.Container components = null;
  116. public Form1()
  117. {
  118. //
  119. // Windows 窗体设计器支持所必需的
  120. //
  121. InitializeComponent();
  123. //
  124. // TODO: 在 InitializeComponent 调用后添加任何构造函数代码
  125. //
  126. }
  128. /// <summary>
  129. /// 清理所有正在使用的资源。
  130. /// </summary>
  131. protected override void Dispose( bool disposing )
  132. {
  133. if( disposing )
  134. {
  135. if (components != null) 
  136. {
  137. components.Dispose();
  138. }
  139. }
  140. base.Dispose( disposing );
  141. }
  143. #region Windows 窗体设计器生成的代码
  144. /// <summary>
  145. /// 设计器支持所需的方法 - 不要使用代码编辑器修改
  146. /// 此方法的内容。
  147. /// </summary>
  148. private void InitializeComponent()
  149. {
  150. System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(Form1));
  151. this.statusBar1 = new System.Windows.Forms.StatusBar();
  152. this.mainMenu1 = new System.Windows.Forms.MainMenu();
  153. this.menuItem1 = new System.Windows.Forms.MenuItem();
  154. this.menuItem3 = new System.Windows.Forms.MenuItem();
  155. this.menuItem4 = new System.Windows.Forms.MenuItem();
  156. this.menuItem2 = new System.Windows.Forms.MenuItem();
  157. this.menuItem5 = new System.Windows.Forms.MenuItem();
  158. this.menuItem6 = new System.Windows.Forms.MenuItem();
  159. this.menuItem7 = new System.Windows.Forms.MenuItem();
  160. this.menuItem9 = new System.Windows.Forms.MenuItem();
  161. this.menuItem8 = new System.Windows.Forms.MenuItem();
  162. this.menuItem10 = new System.Windows.Forms.MenuItem();
  163. this.menuItem11 = new System.Windows.Forms.MenuItem();
  164. this.menuItem12 = new System.Windows.Forms.MenuItem();
  165. this.myConnection = new System.Data.SqlClient.SqlConnection();
  166. this.sqlDataAdapter1 = new System.Data.SqlClient.SqlDataAdapter();
  167. this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand();
  168. this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
  169. this.label1 = new System.Windows.Forms.Label();
  170. this.label2 = new System.Windows.Forms.Label();
  171. this.textBox1 = new System.Windows.Forms.TextBox();
  172. this.textBox2 = new System.Windows.Forms.TextBox();
  173. this.button1 = new System.Windows.Forms.Button();
  174. this.button2 = new System.Windows.Forms.Button();
  175. this.sqlCommand1 = new System.Data.SqlClient.SqlCommand();
  176. this.listView1 = new System.Windows.Forms.ListView();
  177. this.columnHeader1 = new System.Windows.Forms.ColumnHeader();
  178. this.columnHeader2 = new System.Windows.Forms.ColumnHeader();
  179. this.columnHeader3 = new System.Windows.Forms.ColumnHeader();
  180. this.columnHeader17 = new System.Windows.Forms.ColumnHeader();
  181. this.columnHeader4 = new System.Windows.Forms.ColumnHeader();
  182. this.columnHeader5 = new System.Windows.Forms.ColumnHeader();
  183. this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
  184. this.oleDbInsertCommand1 = new System.Data.OleDb.OleDbCommand();
  185. this.oleDbUpdateCommand1 = new System.Data.OleDb.OleDbCommand();
  186. this.oleDbDeleteCommand1 = new System.Data.OleDb.OleDbCommand();
  187. this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();
  188. this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
  189. this.oleDbCommand1 = new System.Data.OleDb.OleDbCommand();
  190. this.oleDbDataAdapter2 = new System.Data.OleDb.OleDbDataAdapter();
  191. this.oleDbSelectCommand2 = new System.Data.OleDb.OleDbCommand();
  192. this.oleDbConnection2 = new System.Data.OleDb.OleDbConnection();
  193. this.dataSet11 = new supershop.DataSet1();
  194. this.button3 = new System.Windows.Forms.Button();
  195. this.panel1 = new System.Windows.Forms.Panel();
  196. this.button6 = new System.Windows.Forms.Button();
  197. this.button5 = new System.Windows.Forms.Button();
  198. this.button4 = new System.Windows.Forms.Button();
  199. this.groupBox1 = new System.Windows.Forms.GroupBox();
  200. this.textBox4 = new System.Windows.Forms.TextBox();
  201. this.textBox3 = new System.Windows.Forms.TextBox();
  202. this.comboBox1 = new System.Windows.Forms.ComboBox();
  203. this.label5 = new System.Windows.Forms.Label();
  204. this.label4 = new System.Windows.Forms.Label();
  205. this.label3 = new System.Windows.Forms.Label();
  206. this.listView2 = new System.Windows.Forms.ListView();
  207. this.columnHeader9 = new System.Windows.Forms.ColumnHeader();
  208. this.columnHeader6 = new System.Windows.Forms.ColumnHeader();
  209. this.columnHeader7 = new System.Windows.Forms.ColumnHeader();
  210. this.columnHeader8 = new System.Windows.Forms.ColumnHeader();
  211. this.panel2 = new System.Windows.Forms.Panel();
  212. this.button11 = new System.Windows.Forms.Button();
  213. this.button10 = new System.Windows.Forms.Button();
  214. this.button9 = new System.Windows.Forms.Button();
  215. this.groupBox3 = new System.Windows.Forms.GroupBox();
  216. this.button8 = new System.Windows.Forms.Button();
  217. this.button7 = new System.Windows.Forms.Button();
  218. this.textBox10 = new System.Windows.Forms.TextBox();
  219. this.label11 = new System.Windows.Forms.Label();
  220. this.groupBox2 = new System.Windows.Forms.GroupBox();
  221. this.textBox9 = new System.Windows.Forms.TextBox();
  222. this.textBox8 = new System.Windows.Forms.TextBox();
  223. this.textBox7 = new System.Windows.Forms.TextBox();
  224. this.textBox6 = new System.Windows.Forms.TextBox();
  225. this.textBox5 = new System.Windows.Forms.TextBox();
  226. this.label10 = new System.Windows.Forms.Label();
  227. this.label9 = new System.Windows.Forms.Label();
  228. this.label8 = new System.Windows.Forms.Label();
  229. this.label7 = new System.Windows.Forms.Label();
  230. this.label6 = new System.Windows.Forms.Label();
  231. this.listView3 = new System.Windows.Forms.ListView();
  232. this.columnHeader10 = new System.Windows.Forms.ColumnHeader();
  233. this.columnHeader11 = new System.Windows.Forms.ColumnHeader();
  234. this.columnHeader12 = new System.Windows.Forms.ColumnHeader();
  235. this.columnHeader13 = new System.Windows.Forms.ColumnHeader();
  236. this.columnHeader14 = new System.Windows.Forms.ColumnHeader();
  237. this.columnHeader15 = new System.Windows.Forms.ColumnHeader();
  238. this.columnHeader16 = new System.Windows.Forms.ColumnHeader();
  239. this.myConnection2 = new System.Data.SqlClient.SqlConnection();
  240. this.floglb = new System.Windows.Forms.Label();
  241. this.button12 = new System.Windows.Forms.Button();
  242. ((System.ComponentModel.ISupportInitialize)(this.dataSet11)).BeginInit();
  243. this.panel1.SuspendLayout();
  244. this.groupBox1.SuspendLayout();
  245. this.panel2.SuspendLayout();
  246. this.groupBox3.SuspendLayout();
  247. this.groupBox2.SuspendLayout();
  248. this.SuspendLayout();
  249. // 
  250. // statusBar1
  251. // 
  252. this.statusBar1.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
  253. this.statusBar1.Location = new System.Drawing.Point(0, 361);
  254. this.statusBar1.Name = "statusBar1";
  255. this.statusBar1.Size = new System.Drawing.Size(728, 16);
  256. this.statusBar1.TabIndex = 0;
  257. this.statusBar1.PanelClick += new System.Windows.Forms.StatusBarPanelClickEventHandler(this.statusBar1_PanelClick);
  258. // 
  259. // mainMenu1
  260. // 
  261. this.mainMenu1.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
  262.   this.menuItem1,
  263.   this.menuItem2,
  264.   this.menuItem7,
  265.   this.menuItem8,
  266.   this.menuItem11});
  267. // 
  268. // menuItem1
  269. // 
  270. this.menuItem1.Index = 0;
  271. this.menuItem1.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
  272.   this.menuItem3,
  273.   this.menuItem4});
  274. this.menuItem1.Text = "系统管理";
  275. // 
  276. // menuItem3
  277. // 
  278. this.menuItem3.Index = 0;
  279. this.menuItem3.Text = "退出登录";
  280. this.menuItem3.Click += new System.EventHandler(this.menuItem3_Click);
  281. // 
  282. // menuItem4
  283. // 
  284. this.menuItem4.Index = 1;
  285. this.menuItem4.Text = "关闭系统";
  286. this.menuItem4.Click += new System.EventHandler(this.menuItem4_Click);
  287. // 
  288. // menuItem2
  289. // 
  290. this.menuItem2.Index = 1;
  291. this.menuItem2.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
  292.   this.menuItem5,
  293.   this.menuItem6});
  294. this.menuItem2.Text = "销售管理";
  295. // 
  296. // menuItem5
  297. // 
  298. this.menuItem5.Index = 0;
  299. this.menuItem5.Text = "销售商品";
  300. this.menuItem5.Click += new System.EventHandler(this.menuItem5_Click);
  301. // 
  302. // menuItem6
  303. // 
  304. this.menuItem6.Index = 1;
  305. this.menuItem6.Text = "销售历史";
  306. this.menuItem6.Click += new System.EventHandler(this.menuItem6_Click);
  307. // 
  308. // menuItem7
  309. // 
  310. this.menuItem7.Index = 2;
  311. this.menuItem7.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
  312.   this.menuItem9});
  313. this.menuItem7.Text = "商品管理";
  314. // 
  315. // menuItem9
  316. // 
  317. this.menuItem9.Index = 0;
  318. this.menuItem9.Text = "商品概况";
  319. this.menuItem9.Click += new System.EventHandler(this.menuItem9_Click);
  320. // 
  321. // menuItem8
  322. // 
  323. this.menuItem8.Index = 3;
  324. this.menuItem8.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
  325.   this.menuItem10});
  326. this.menuItem8.Text = "人事管理";
  327. // 
  328. // menuItem10
  329. // 
  330. this.menuItem10.Index = 0;
  331. this.menuItem10.Text = "人员安排";
  332. this.menuItem10.Click += new System.EventHandler(this.menuItem10_Click);
  333. // 
  334. // menuItem11
  335. // 
  336. this.menuItem11.Index = 4;
  337. this.menuItem11.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
  338.    this.menuItem12});
  339. this.menuItem11.Text = "关于";
  340. // 
  341. // menuItem12
  342. // 
  343. this.menuItem12.Index = 0;
  344. this.menuItem12.Text = "橙子超市管理系统1.0版";
  345. this.menuItem12.Click += new System.EventHandler(this.menuItem12_Click);
  346. // 
  347. // myConnection
  348. // 
  349. this.myConnection.ConnectionString = "workstation id=MICROSOFTPANG;packet size=4096;integrated security=SSPI;data sourc" +
  350. "e=MICROSOFTPANG;persist security info=False;initial catalog=supershop";
  351. // 
  352. // sqlDataAdapter1
  353. // 
  354. this.sqlDataAdapter1.InsertCommand = this.sqlInsertCommand1;
  355. this.sqlDataAdapter1.SelectCommand = this.sqlSelectCommand1;
  356. this.sqlDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
  357.   new System.Data.Common.DataTableMapping("Table", "production", new System.Data.Common.DataColumnMapping[] {
  358. new System.Data.Common.DataColumnMapping("pid", "pid"),
  359. new System.Data.Common.DataColumnMapping("pname", "pname"),
  360. new System.Data.Common.DataColumnMapping("price", "price"),
  361. new System.Data.Common.DataColumnMapping("totle", "totle")})});
  362. // 
  363. // sqlInsertCommand1
  364. // 
  365. this.sqlInsertCommand1.CommandText = "INSERT INTO production(pid, pname, price, totle) VALUES (@pid, @pname, @price, @t" +
  366. "otle); SELECT pid, pname, price, totle FROM production";
  367. this.sqlInsertCommand1.Connection = this.myConnection;
  368. this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@pid", System.Data.SqlDbType.Int, 4, "pid"));
  369. this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@pname", System.Data.SqlDbType.VarChar, 20, "pname"));
  370. this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@price", System.Data.SqlDbType.Int, 4, "price"));
  371. this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@totle", System.Data.SqlDbType.Int, 4, "totle"));
  372. // 
  373. // sqlSelectCommand1
  374. // 
  375. this.sqlSelectCommand1.CommandText = "SELECT production.* FROM production";
  376. this.sqlSelectCommand1.Connection = this.myConnection;
  377. // 
  378. // label1
  379. // 
  380. this.label1.Location = new System.Drawing.Point(0, 288);
  381. this.label1.Name = "label1";
  382. this.label1.Size = new System.Drawing.Size(48, 23);
  383. this.label1.TabIndex = 2;
  384. this.label1.Text = "货号：";
  385. // 
  386. // label2
  387. // 
  388. this.label2.Location = new System.Drawing.Point(160, 288);
  389. this.label2.Name = "label2";
  390. this.label2.Size = new System.Drawing.Size(48, 23);
  391. this.label2.TabIndex = 3;
  392. this.label2.Text = "数量：";
  393. // 
  394. // textBox1
  395. // 
  396. this.textBox1.Location = new System.Drawing.Point(48, 288);
  397. this.textBox1.Name = "textBox1";
  398. this.textBox1.TabIndex = 4;
  399. this.textBox1.Text = "";
  400. // 
  401. // textBox2
  402. // 
  403. this.textBox2.Location = new System.Drawing.Point(208, 288);
  404. this.textBox2.Name = "textBox2";
  405. this.textBox2.TabIndex = 5;
  406. this.textBox2.Text = "";
  407. // 
  408. // button1
  409. // 
  410. this.button1.Location = new System.Drawing.Point(432, 288);
  411. this.button1.Name = "button1";
  412. this.button1.TabIndex = 6;
  413. this.button1.Text = "确  认";
  414. this.button1.Visible = false;
  415. this.button1.Click += new System.EventHandler(this.button1_Click);
  416. // 
  417. // button2
  418. // 
  419. this.button2.Location = new System.Drawing.Point(624, 288);
  420. this.button2.Name = "button2";
  421. this.button2.TabIndex = 7;
  422. this.button2.Text = "统  计";
  423. this.button2.Visible = false;
  424. this.button2.Click += new System.EventHandler(this.button2_Click);
  425. // 
  426. // sqlCommand1
  427. // 
  428. this.sqlCommand1.Connection = this.myConnection;
  429. // 
  430. // listView1
  431. // 
  432. this.listView1.Columns.AddRange(new System.Windows.Forms.ColumnHeader[] {
  433. this.columnHeader1,
  434. this.columnHeader2,
  435. this.columnHeader3,
  436. this.columnHeader17,
  437. this.columnHeader4,
  438. this.columnHeader5});
  439. this.listView1.FullRowSelect = true;
  440. this.listView1.Location = new System.Drawing.Point(0, 16);
  441. this.listView1.Name = "listView1";
  442. this.listView1.Size = new System.Drawing.Size(728, 248);
  443. this.listView1.TabIndex = 8;
  444. this.listView1.View = System.Windows.Forms.View.Details;
  445. // 
  446. // columnHeader1
  447. // 
  448. this.columnHeader1.Text = "商品货号";
  449. this.columnHeader1.Width = 118;
  450. // 
  451. // columnHeader2
  452. // 
  453. this.columnHeader2.Text = "商品名称";
  454. this.columnHeader2.TextAlign = System.Windows.Forms.HorizontalAlignment.Center;
  455. this.columnHeader2.Width = 126;
  456. // 
  457. // columnHeader3
  458. // 
  459. this.columnHeader3.Text = "商品价格";
  460. this.columnHeader3.TextAlign = System.Windows.Forms.HorizontalAlignment.Center;
  461. this.columnHeader3.Width = 118;
  462. // 
  463. // columnHeader17
  464. // 
  465. this.columnHeader17.Text = "商品单位";
  466. this.columnHeader17.Width = 102;
  467. // 
  468. // columnHeader4
  469. // 
  470. this.columnHeader4.Text = "商品数量";
  471. this.columnHeader4.Width = 125;
  472. // 
  473. // columnHeader5
  474. // 
  475. this.columnHeader5.Text = "商品总价格";
  476. this.columnHeader5.Width = 134;
  477. // 
  478. // oleDbDataAdapter1
  479. // 
  480. this.oleDbDataAdapter1.DeleteCommand = this.oleDbDeleteCommand1;
  481. this.oleDbDataAdapter1.InsertCommand = this.oleDbInsertCommand1;
  482. this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;
  483. this.oleDbDataAdapter1.UpdateCommand = this.oleDbUpdateCommand1;
  484. // 
  485. // oleDbConnection1
  486. // 
  487. this.oleDbConnection1.ConnectionString = @"Integrated Security=SSPI;Packet Size=4096;Data Source=MICROSOFTPANG;Tag with column collation when possible=False;Initial Catalog=supershop;Use Procedure for Prepare=1;Auto Translate=True;Persist Security Info=False;Provider=""SQLOLEDB.1"";Workstation ID=MICROSOFTPANG;Use Encryption for Data=False";
  488. // 
  489. // oleDbDataAdapter2
  490. // 
  491. this.oleDbDataAdapter2.SelectCommand = this.oleDbSelectCommand2;
  492. // 
  493. // oleDbSelectCommand2
  494. // 
  495. this.oleDbSelectCommand2.CommandText = "SELECT FROM production";
  496. this.oleDbSelectCommand2.Connection = this.oleDbConnection2;
  497. // 
  498. // oleDbConnection2
  499. // 
  500. this.oleDbConnection2.ConnectionString = @"Integrated Security=SSPI;Packet Size=4096;Data Source=MICROSOFTPANG;Tag with column collation when possible=False;Initial Catalog=supershop;Use Procedure for Prepare=1;Auto Translate=True;Persist Security Info=False;Provider=""SQLOLEDB.1"";Workstation ID=MICROSOFTPANG;Use Encryption for Data=False";
  501. // 
  502. // dataSet11
  503. // 
  504. this.dataSet11.DataSetName = "DataSet1";
  505. this.dataSet11.Locale = new System.Globalization.CultureInfo("zh-CN");
  506. // 
  507. // button3
  508. // 
  509. this.button3.Location = new System.Drawing.Point(344, 288);
  510. this.button3.Name = "button3";
  511. this.button3.TabIndex = 9;
  512. this.button3.Text = "新建销售";
  513. this.button3.Click += new System.EventHandler(this.button3_Click);
  514. // 
  515. // panel1
  516. // 
  517. this.panel1.Controls.Add(this.button6);
  518. this.panel1.Controls.Add(this.button5);
  519. this.panel1.Controls.Add(this.button4);
  520. this.panel1.Controls.Add(this.groupBox1);
  521. this.panel1.Controls.Add(this.listView2);
  522. this.panel1.Location = new System.Drawing.Point(0, 0);
  523. this.panel1.Name = "panel1";
  524. this.panel1.Size = new System.Drawing.Size(728, 360);
  525. this.panel1.TabIndex = 10;
  526. this.panel1.Visible = false;
  527. // 
  528. // button6
  529. // 
  530. this.button6.Location = new System.Drawing.Point(624, 288);
  531. this.button6.Name = "button6";
  532. this.button6.TabIndex = 6;
  533. this.button6.Text = "删除帐户";
  534. this.button6.Click += new System.EventHandler(this.button6_Click);
  535. // 
  536. // button5
  537. // 
  538. this.button5.Location = new System.Drawing.Point(504, 288);
  539. this.button5.Name = "button5";
  540. this.button5.TabIndex = 5;
  541. this.button5.Text = "修改帐户";
  542. this.button5.Click += new System.EventHandler(this.button5_Click);
  543. // 
  544. // button4
  545. // 
  546. this.button4.Location = new System.Drawing.Point(376, 288);
  547. this.button4.Name = "button4";
  548. this.button4.TabIndex = 4;
  549. this.button4.Text = "添加帐户";
  550. this.button4.Click += new System.EventHandler(this.button4_Click);
  551. // 
  552. // groupBox1
  553. // 
  554. this.groupBox1.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) 
  555. | System.Windows.Forms.AnchorStyles.Left) 
  556. | System.Windows.Forms.AnchorStyles.Right)));
  557. this.groupBox1.Controls.Add(this.textBox4);
  558. this.groupBox1.Controls.Add(this.textBox3);
  559. this.groupBox1.Controls.Add(this.comboBox1);
  560. this.groupBox1.Controls.Add(this.label5);
  561. this.groupBox1.Controls.Add(this.label4);
  562. this.groupBox1.Controls.Add(this.label3);
  563. this.groupBox1.Location = new System.Drawing.Point(360, 16);
  564. this.groupBox1.Name = "groupBox1";
  565. this.groupBox1.Size = new System.Drawing.Size(352, 344);
  566. this.groupBox1.TabIndex = 3;
  567. this.groupBox1.TabStop = false;
  568. this.groupBox1.Text = "编辑区:";
  569. // 
  570. // textBox4
  571. // 
  572. this.textBox4.Location = new System.Drawing.Point(144, 72);
  573. this.textBox4.Name = "textBox4";
  574. this.textBox4.TabIndex = 7;
  575. this.textBox4.Text = "";
  576. // 
  577. // textBox3
  578. // 
  579. this.textBox3.Location = new System.Drawing.Point(144, 32);
  580. this.textBox3.Name = "textBox3";
  581. this.textBox3.TabIndex = 6;
  582. this.textBox3.Text = "";
  583. // 
  584. // comboBox1
  585. // 
  586. this.comboBox1.Items.AddRange(new object[] {
  587.    "管理人员",
  588.    "销售人员"});
  589. this.comboBox1.Location = new System.Drawing.Point(144, 112);
  590. this.comboBox1.Name = "comboBox1";
  591. this.comboBox1.Size = new System.Drawing.Size(112, 20);
  592. this.comboBox1.TabIndex = 5;
  593. // 
  594. // label5
  595. // 
  596. this.label5.Location = new System.Drawing.Point(32, 112);
  597. this.label5.Name = "label5";
  598. this.label5.TabIndex = 2;
  599. this.label5.Text = "帐号类型：";
  600. this.label5.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
  601. // 
  602. // label4
  603. // 
  604. this.label4.Location = new System.Drawing.Point(32, 72);
  605. this.label4.Name = "label4";
  606. this.label4.Size = new System.Drawing.Size(104, 23);
  607. this.label4.TabIndex = 1;
  608. this.label4.Text = "登录密码：";
  609. this.label4.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
  610. // 
  611. // label3
  612. // 
  613. this.label3.Location = new System.Drawing.Point(32, 32);
  614. this.label3.Name = "label3";
  615. this.label3.TabIndex = 0;
  616. this.label3.Text = "登录帐号：";
  617. this.label3.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
  618. // 
  619. // listView2
  620. // 
  621. this.listView2.Columns.AddRange(new System.Windows.Forms.ColumnHeader[] {
  622. this.columnHeader9,
  623. this.columnHeader6,
  624. this.columnHeader7,
  625. this.columnHeader8});
  626. this.listView2.FullRowSelect = true;
  627. this.listView2.GridLines = true;
  628. this.listView2.Location = new System.Drawing.Point(16, 16);
  629. this.listView2.Name = "listView2";
  630. this.listView2.Size = new System.Drawing.Size(328, 304);
  631. this.listView2.TabIndex = 2;
  632. this.listView2.View = System.Windows.Forms.View.Details;
  633. this.listView2.SelectedIndexChanged += new System.EventHandler(this.select);
  634. this.listView2.ItemCheck += new System.Windows.Forms.ItemCheckEventHandler(this.ifcheck);
  635. // 
  636. // columnHeader9
  637. // 
  638. this.columnHeader9.Text = "ID";
  639. // 
  640. // columnHeader6
  641. // 
  642. this.columnHeader6.Text = "登录帐号";
  643. this.columnHeader6.Width = 97;
  644. // 
  645. // columnHeader7
  646. // 
  647. this.columnHeader7.Text = "登录密码";
  648. this.columnHeader7.Width = 83;
  649. // 
  650. // columnHeader8
  651. // 
  652. this.columnHeader8.Text = "帐号类型";
  653. this.columnHeader8.Width = 84;
  654. // 
  655. // panel2
  656. // 
  657. this.panel2.Controls.Add(this.button11);
  658. this.panel2.Controls.Add(this.button10);
  659. this.panel2.Controls.Add(this.button9);
  660. this.panel2.Controls.Add(this.groupBox3);
  661. this.panel2.Controls.Add(this.groupBox2);
  662. this.panel2.Controls.Add(this.listView3);
  663. this.panel2.Location = new System.Drawing.Point(0, 0);
  664. this.panel2.Name = "panel2";
  665. this.panel2.Size = new System.Drawing.Size(728, 360);
  666. this.panel2.TabIndex = 11;
  667. this.panel2.Visible = false;
  668. // 
  669. // button11
  670. // 
  671. this.button11.Location = new System.Drawing.Point(640, 320);
  672. this.button11.Name = "button11";
  673. this.button11.TabIndex = 5;
  674. this.button11.Text = "修  改";
  675. this.button11.Click += new System.EventHandler(this.button11_Click);
  676. // 
  677. // button10
  678. // 
  679. this.button10.Location = new System.Drawing.Point(544, 320);
  680. this.button10.Name = "button10";
  681. this.button10.TabIndex = 4;
  682. this.button10.Text = "删  除";
  683. this.button10.Click += new System.EventHandler(this.button10_Click);
  684. // 
  685. // button9
  686. // 
  687. this.button9.Location = new System.Drawing.Point(448, 320);
  688. this.button9.Name = "button9";
  689. this.button9.TabIndex = 3;
  690. this.button9.Text = "添  加";
  691. this.button9.Click += new System.EventHandler(this.button9_Click);
  692. // 
  693. // groupBox3
  694. // 
  695. this.groupBox3.Controls.Add(this.button8);
  696. this.groupBox3.Controls.Add(this.button7);
  697. this.groupBox3.Controls.Add(this.textBox10);
  698. this.groupBox3.Controls.Add(this.label11);
  699. this.groupBox3.Location = new System.Drawing.Point(8, 232);
  700. this.groupBox3.Name = "groupBox3";
  701. this.groupBox3.Size = new System.Drawing.Size(424, 112);
  702. this.groupBox3.TabIndex = 2;
  703. this.groupBox3.TabStop = false;
  704. this.groupBox3.Text = "商品查询";
  705. this.groupBox3.Enter += new System.EventHandler(this.groupBox3_Enter);
  706. // 
  707. // button8
  708. // 
  709. this.button8.Location = new System.Drawing.Point(296, 64);
  710. this.button8.Name = "button8";
  711. this.button8.Size = new System.Drawing.Size(104, 23);
  712. this.button8.TabIndex = 3;
  713. this.button8.Text = "列出所有商品";
  714. this.button8.Click += new System.EventHandler(this.button8_Click);
  715. // 
  716. // button7
  717. // 
  718. this.button7.Location = new System.Drawing.Point(160, 64);
  719. this.button7.Name = "button7";
  720. this.button7.Size = new System.Drawing.Size(104, 23);
  721. this.button7.TabIndex = 2;
  722. this.button7.Text = "查    询";
  723. this.button7.Click += new System.EventHandler(this.button7_Click);
  724. // 
  725. // textBox10
  726. // 
  727. this.textBox10.Location = new System.Drawing.Point(160, 24);
  728. this.textBox10.Name = "textBox10";
  729. this.textBox10.Size = new System.Drawing.Size(248, 21);
  730. this.textBox10.TabIndex = 1;
  731. this.textBox10.Text = "";
  732. // 
  733. // label11
  734. // 
  735. this.label11.Location = new System.Drawing.Point(16, 24);
  736. this.label11.Name = "label11";
  737. this.label11.Size = new System.Drawing.Size(144, 23);
  738. this.label11.TabIndex = 0;
  739. this.label11.Text = "关键字（名称）：";
  740. this.label11.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
  741. // 
  742. // groupBox2
  743. // 
  744. this.groupBox2.Controls.Add(this.textBox9);
  745. this.groupBox2.Controls.Add(this.textBox8);
  746. this.groupBox2.Controls.Add(this.textBox7);
  747. this.groupBox2.Controls.Add(this.textBox6);
  748. this.groupBox2.Controls.Add(this.textBox5);
  749. this.groupBox2.Controls.Add(this.label10);
  750. this.groupBox2.Controls.Add(this.label9);
  751. this.groupBox2.Controls.Add(this.label8);
  752. this.groupBox2.Controls.Add(this.label7);
  753. this.groupBox2.Controls.Add(this.label6);
  754. this.groupBox2.Location = new System.Drawing.Point(432, 16);
  755. this.groupBox2.Name = "groupBox2";
  756. this.groupBox2.Size = new System.Drawing.Size(288, 200);
  757. this.groupBox2.TabIndex = 1;
  758. this.groupBox2.TabStop = false;
  759. this.groupBox2.Text = "编辑区";
  760. // 
  761. // textBox9
  762. // 
  763. this.textBox9.Location = new System.Drawing.Point(128, 168);
  764. this.textBox9.Name = "textBox9";
  765. this.textBox9.Size = new System.Drawing.Size(144, 21);
  766. this.textBox9.TabIndex = 9;
  767. this.textBox9.Text = "";
  768. // 
  769. // textBox8
  770. // 
  771. this.textBox8.Location = new System.Drawing.Point(128, 128);
  772. this.textBox8.Name = "textBox8";
  773. this.textBox8.Size = new System.Drawing.Size(144, 21);
  774. this.textBox8.TabIndex = 8;
  775. this.textBox8.Text = "";
  776. // 
  777. // textBox7
  778. // 
  779. this.textBox7.Location = new System.Drawing.Point(128, 96);
  780. this.textBox7.Name = "textBox7";
  781. this.textBox7.Size = new System.Drawing.Size(144, 21);
  782. this.textBox7.TabIndex = 7;
  783. this.textBox7.Text = "";
  784. // 
  785. // textBox6
  786. // 
  787. this.textBox6.Location = new System.Drawing.Point(128, 64);
  788. this.textBox6.Name = "textBox6";
  789. this.textBox6.Size = new System.Drawing.Size(144, 21);
  790. this.textBox6.TabIndex = 6;
  791. this.textBox6.Text = "";
  792. // 
  793. // textBox5
  794. // 
  795. this.textBox5.Location = new System.Drawing.Point(128, 32);
  796. this.textBox5.Name = "textBox5";
  797. this.textBox5.Size = new System.Drawing.Size(144, 21);
  798. this.textBox5.TabIndex = 5;
  799. this.textBox5.Text = "";
  800. // 
  801. // label10
  802. // 
  803. this.label10.Location = new System.Drawing.Point(16, 168);
  804. this.label10.Name = "label10";
  805. this.label10.TabIndex = 4;
  806. this.label10.Text = "库存：";
  807. this.label10.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
  808. // 
  809. // label9
  810. // 
  811. this.label9.Location = new System.Drawing.Point(16, 128);
  812. this.label9.Name = "label9";
  813. this.label9.TabIndex = 3;
  814. this.label9.Text = "货架：";
  815. this.label9.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
  816. // 
  817. // label8
  818. // 
  819. this.label8.Location = new System.Drawing.Point(16, 96);
  820. this.label8.Name = "label8";
  821. this.label8.TabIndex = 2;
  822. this.label8.Text = "单位：";
  823. this.label8.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
  824. // 
  825. // label7
  826. // 
  827. this.label7.Location = new System.Drawing.Point(16, 64);
  828. this.label7.Name = "label7";
  829. this.label7.TabIndex = 1;
  830. this.label7.Text = "单价：";
  831. this.label7.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
  832. // 
  833. // label6
  834. // 
  835. this.label6.Location = new System.Drawing.Point(16, 32);
  836. this.label6.Name = "label6";
  837. this.label6.TabIndex = 0;
  838. this.label6.Text = "名称：";
  839. this.label6.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
  840. // 
  841. // listView3
  842. // 
  843. this.listView3.Columns.AddRange(new System.Windows.Forms.ColumnHeader[] {
  844. this.columnHeader10,
  845. this.columnHeader11,
  846. this.columnHeader12,
  847. this.columnHeader13,
  848. this.columnHeader14,
  849. this.columnHeader15,
  850. this.columnHeader16});
  851. this.listView3.FullRowSelect = true;
  852. this.listView3.GridLines = true;
  853. this.listView3.Location = new System.Drawing.Point(8, 8);
  854. this.listView3.Name = "listView3";
  855. this.listView3.Size = new System.Drawing.Size(424, 208);
  856. this.listView3.TabIndex = 0;
  857. this.listView3.View = System.Windows.Forms.View.Details;
  858. this.listView3.SelectedIndexChanged += new System.EventHandler(this.v3select);
  859. // 
  860. // columnHeader10
  861. // 
  862. this.columnHeader10.Text = "编号";
  863. // 
  864. // columnHeader11
  865. // 
  866. this.columnHeader11.Text = "名称";
  867. // 
  868. // columnHeader12
  869. // 
  870. this.columnHeader12.Text = "单价";
  871. // 
  872. // columnHeader13
  873. // 
  874. this.columnHeader13.Text = "单位";
  875. // 
  876. // columnHeader14
  877. // 
  878. this.columnHeader14.Text = "货架号";
  879. // 
  880. // columnHeader15
  881. // 
  882. this.columnHeader15.Text = "库存";
  883. // 
  884. // columnHeader16
  885. // 
  886. this.columnHeader16.Text = "销量";
  887. // 
  888. // myConnection2
  889. // 
  890. this.myConnection2.ConnectionString = "workstation id=MICROSOFTPANG;packet size=4096;integrated security=SSPI;data sourc" +
  891. "e=MICROSOFTPANG;persist security info=False;initial catalog=supershop";
  892. // 
  893. // floglb
  894. // 
  895. this.floglb.Location = new System.Drawing.Point(608, 320);
  896. this.floglb.Name = "floglb";
  897. this.floglb.TabIndex = 12;
  898. this.floglb.Visible = false;
  899. // 
  900. // button12
  901. // 
  902. this.button12.Location = new System.Drawing.Point(528, 288);
  903. this.button12.Name = "button12";
  904. this.button12.TabIndex = 13;
  905. this.button12.Text = "删  除";
  906. this.button12.Visible = false;
  907. this.button12.Click += new System.EventHandler(this.button12_Click);
  908. // 
  909. // Form1
  910. // 
  911. this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
  912. this.ClientSize = new System.Drawing.Size(728, 377);
  913. this.Controls.Add(this.panel2);
  914. this.Controls.Add(this.panel1);
  915. this.Controls.Add(this.listView1);
  916. this.Controls.Add(this.button2);
  917. this.Controls.Add(this.button1);
  918. this.Controls.Add(this.textBox2);
  919. this.Controls.Add(this.textBox1);
  920. this.Controls.Add(this.label2);
  921. this.Controls.Add(this.label1);
  922. this.Controls.Add(this.statusBar1);
  923. this.Controls.Add(this.button3);
  924. this.Controls.Add(this.floglb);
  925. this.Controls.Add(this.button12);
  926. this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon")));
  927. this.Menu = this.mainMenu1;
  928. this.Name = "Form1";
  929. this.Text = "橙子超市管理系统";
  930. this.Load += new System.EventHandler(this.Form1_Load);
  931. ((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();
  932. this.panel1.ResumeLayout(false);
  933. this.groupBox1.ResumeLayout(false);
  934. this.panel2.ResumeLayout(false);
  935. this.groupBox3.ResumeLayout(false);
  936. this.groupBox2.ResumeLayout(false);
  937. this.ResumeLayout(false);
  939. }
  940. #endregion
  942. /// <summary>
  943. /// 应用程序的主入口点。
  944. /// </summary>
  945. [STAThread]
  946. static void Main() 
  947. {
  948. Application.Run(new Form1());
  950. }
  952. private void Form1_Load(object sender, System.EventArgs e)
  953. {
  954.     supershop2.Form2 f2=new supershop2.Form2();
  955. //f2.Visible=true;
  957. f2.ShowDialog();
  958. this.statusBar1.Text=name;
  959. if(isman=="no")
  960. {
  961. this.menuItem6.Enabled=false;
  962. this.menuItem7.Enabled=false;
  963.                 this.menuItem8.Enabled=false;
  964. }
  965. else
  966. {
  967. this.menuItem6.Enabled=true;
  968. this.menuItem7.Enabled=true;
  969. this.menuItem8.Enabled=true;
  970. }
  972. //this.Visible=false;
  973. }
  975. private void button1_Click(object sender, System.EventArgs e)
  976. {
  977. string pid=textBox1.Text;
  978. double solett=Convert.ToDouble(textBox2.Text);
  979. string ss="select * from production where pid="+pid+"";
  980. this.oleDbDataAdapter1.SelectCommand.CommandText=ss;
  981. this.oleDbDataAdapter1.SelectCommand.Connection=this.oleDbConnection1;
  982. //打开数据库连接
  983. this.oleDbConnection1.Open();
  984. System.Data.OleDb.OleDbDataReader MyReader=this.oleDbDataAdapter1.SelectCommand.ExecuteReader();
  986. this.listView1.View=View.Details;
  987. MyReader.Read();
  988. string pname,price;
  989. double kucun,soled;
  990. //kucun=MyReader.GetValue(5).ToString();
  991. //soled=MyReader.GetValue(6).ToString();
  993.             double allp;
  995. try
  996. {
  998. pname=MyReader.GetValue(1).ToString();
  999. price=MyReader.GetValue(2).ToString();
  1000. kucun=Convert.ToDouble(MyReader.GetValue(5).ToString())-Convert.ToDouble(textBox2.Text);
  1001. soled=Convert.ToDouble(MyReader.GetValue(6).ToString())+Convert.ToDouble(textBox2.Text);
  1002. allp=Convert.ToDouble(price) * solett;
  1003. allp=Math.Round(allp,2);
  1004. ListViewItem MyItem=new ListViewItem();
  1005. MyItem.Text=MyReader.GetValue(0).ToString();
  1006. for(int j=0;j<MyReader.FieldCount-4;j++)
  1007. MyItem.SubItems.Add(MyReader.GetValue(j+1).ToString());
  1008. /*int b=MyReader.GetInt32(3);
  1009. double c=a*b;
  1010. string ff=c.ToString();
  1011. MyItem.SubItems.Add(ff);*/
  1012. MyItem.SubItems.Add(textBox2.Text);
  1013.     MyItem.SubItems.Add(allp.ToString());
  1014. this.listView1.Items.Add(MyItem);
  1015. MyReader.Close();
  1016. this.oleDbConnection1.Close();
  1017. }
  1018. catch
  1019. {
  1020. MyReader.Close();
  1021. this.oleDbConnection1.Close();
  1022. MessageBox.Show(this,"商品不存在！");
  1023. return;
  1024. }
  1025. //for(int i=0;i<MyReader.FieldCount-1;i++)
  1026. //{
  1027. //this.listView1.Columns.Add(MyReader.GetName(i),100,HorizontalAlignment.Left);
  1028. //}
  1029. /*while(MyReader.Read())
  1030. {
  1031. ListViewItem MyItem=new ListViewItem();
  1032. MyItem.Text=MyReader.GetValue(0).ToString();
  1033. for(int j=0;j<MyReader.FieldCount-1;j++)
  1034. MyItem.SubItems.Add(MyReader.GetValue(j+1).ToString());
  1035. this.listView1.Items.Add(MyItem);
  1036. }*/
  1037. //关闭连接
  1038. //textBox1.Text=price.ToString();
  1039. this.oleDbConnection1.Close();
  1040. /*this.sqlConnection1.Open();
  1041. int solett=2;
  1042. float allp=2.0f;
  1043. string insert_soled="insert into soled(pid,pname,price,solett,allp)values("+pid+",""+pname+"","+price+","+solett+","+allp+")";
  1044. this.sqlCommand1.CommandText=insert_soled;
  1045.             this.sqlCommand1.Connection=this.sqlConnection1;
  1046. this.sqlCommand1.ExecuteNonQuery();
  1047. this.sqlConnection1.Close();
  1048. this.sqlDataAdapter1.Fill(this.dataSet11,"soled");*/
  1049. //SqlConnection myConnection;
  1051. //myConnection = new SqlConnection("server=(MICROSOFTPANG);database=supershop;Trusted_Connection=yes");*/
  1053.             //DateTimePicker NowTime = new DateTimePicker();
  1054. //string Now_Time=NowTime.Value.ToLongDateString().ToString();
  1055. //Now_Time+=NowTime.Value.ToLongTimeString().ToString();
  1056. string insertCmd = "insert into soled(pid,solett,allp,sallflog)values(@pid, @solett, @allp,@sallflog)";
  1058. SqlCommand myCommand = new SqlCommand(insertCmd, myConnection);
  1060. myCommand.Parameters.Add(new SqlParameter("@pid", SqlDbType.Int, 4));
  1061. myCommand.Parameters["@pid"].Value = pid;
  1063. //myCommand.Parameters.Add(new SqlParameter("@pname", SqlDbType.NVarChar, 20));
  1064. //myCommand.Parameters["@pname"].Value = pname;
  1066. //myCommand.Parameters.Add(new SqlParameter("@price", SqlDbType.Float, 8));
  1067. //myCommand.Parameters["@price"].Value = price;
  1069. myCommand.Parameters.Add(new SqlParameter("@solett", SqlDbType.Int, 4));
  1070. myCommand.Parameters["@solett"].Value = solett;
  1072. myCommand.Parameters.Add(new SqlParameter("@allp", SqlDbType.Float, 8));
  1073. myCommand.Parameters["@allp"].Value = allp;
  1075. myCommand.Parameters.Add(new SqlParameter("@sallflog", SqlDbType.Int, 4));
  1076. myCommand.Parameters["@sallflog"].Value = floglb.Text;
  1078. myCommand.Connection.Open();
  1080. try 
  1081. {
  1082. myCommand.ExecuteNonQuery();
  1083. myCommand.Connection.Close();
  1084. }
  1085. catch (SqlException ex)
  1086. {
  1087. MessageBox.Show("插入数据错误！ " + ex.Message.ToString());
  1088. myCommand.Connection.Close();
  1089. return;
  1090. }
  1091. string upprice="update production set kucun="+kucun+",soled="+soled+" where pid="+pid+"";
  1092. SqlCommand myCommand2 = new SqlCommand(upprice, myConnection);
  1093. myCommand2.Connection.Open();
  1094. try 
  1095. {
  1096. myCommand2.ExecuteNonQuery();
  1097. myCommand2.Connection.Close();
  1098. }
  1099. catch (SqlException ex)
  1100. {
  1101. MessageBox.Show("库存销售数据错误！ " + ex.Message.ToString());
  1102. myCommand2.Connection.Close();
  1103. return;
  1104. }
  1107. }
  1109. private void button3_Click(object sender, System.EventArgs e)
  1110. {
  1111. textBox1.Text="";
  1112. textBox2.Text="";
  1113. listView1.Items.Clear();
  1114. DateTimePicker NowTime = new DateTimePicker();
  1115. string Now_Time=NowTime.Value.ToLongDateString().ToString();
  1116. Now_Time+=NowTime.Value.ToLongTimeString().ToString();
  1117.         //string sname=statusBar1.Text;
  1118. //sname为登录人的姓名
  1119.  string sname=this.statusBar1.Text;
  1121. string insall="insert into slist (stime,sname)values(@stime,@sname)";
  1122. SqlCommand myCommand = new SqlCommand(insall, myConnection);
  1123. myCommand.Parameters.Add(new SqlParameter("@stime", SqlDbType.NVarChar, 30));
  1124. myCommand.Parameters["@stime"].Value = Now_Time;
  1126. myCommand.Parameters.Add(new SqlParameter("@sname", SqlDbType.NVarChar, 20));
  1127. myCommand.Parameters["@sname"].Value = sname;
  1128.             myCommand.Connection.Open();
  1129. ///////////////////////////
  1130. string slt="select sallid from slist where sname=@sname order by sallid desc";
  1131. SqlCommand myCommand2 = new SqlCommand(slt, myConnection2);
  1132. myCommand2.Parameters.Add(new SqlParameter("@sname", SqlDbType.NVarChar, 20));
  1133. myCommand2.Parameters["@sname"].Value = sname;
  1134. myCommand2.Connection.Open();
  1136. try 
  1137. {
  1138. myCommand.ExecuteNonQuery();
  1139. floglb.Text=myCommand2.ExecuteScalar().ToString();
  1140. button1.Visible=true;
  1141. button2.Visible=true;
  1142. button12.Visible=true;
  1143. myCommand.Connection.Close();
  1144. myCommand2.Connection.Close();
  1145. MessageBox.Show("新建销售成功!");
  1147. }
  1148. catch (SqlException ex)
  1149. {
  1150. myCommand.Connection.Close();
  1151.                 myCommand2.Connection.Close();
  1152. MessageBox.Show("新建销售错误！ " + ex.Message.ToString());
  1153. return;
  1154. }
  1158. }
  1160. private void menuItem4_Click(object sender, System.EventArgs e)
  1161. {
  1162. Application.Exit();
  1163. }
  1165. private void menuItem3_Click(object sender, System.EventArgs e)
  1166. {
  1167. panel2.Visible=false;
  1168. panel1.Visible=false;
  1169. this.Enabled=false;
  1170. supershop2.Form2 f2=new supershop2.Form2();
  1171. f2.ShowDialog();
  1172. this.statusBar1.Text=name;
  1174. this.Enabled=true;
  1175. if(isman=="no")
  1176. {
  1177. this.menuItem6.Enabled=false;
  1178. this.menuItem7.Enabled=false;
  1179. this.menuItem8.Enabled=false;
  1180. }
  1181. else
  1182. {
  1183. this.menuItem6.Enabled=true;
  1184. this.menuItem7.Enabled=true;
  1185. this.menuItem8.Enabled=true;
  1186. }
  1187. //this.Visible=false;
  1189. }
  1191. private void menuItem12_Click(object sender, System.EventArgs e)
  1192. {
  1193. Form3 f3=new Form3();
  1194. f3.Text="关于橙子";
  1195. f3.ShowDialog();
  1196. }
  1198. private void menuItem6_Click(object sender, System.EventArgs e)
  1199. {
  1200. Form4 f4=new Form4();
  1201. f4.ShowDialog();
  1202. }
  1204. private void menuItem10_Click(object sender, System.EventArgs e)
  1205. {
  1207. panel1.Visible=true;
  1208. panel2.Visible=false;
  1210. string str="select * from login";
  1211. this.oleDbDataAdapter1.SelectCommand.CommandText=str;
  1212. this.oleDbDataAdapter1.SelectCommand.Connection=this.oleDbConnection1;
  1213. //打开数据库连接
  1214. this.oleDbConnection1.Open();
  1215. System.Data.OleDb.OleDbDataReader MyReader=this.oleDbDataAdapter1.SelectCommand.ExecuteReader();
  1217. //this.listView1.View=View.Details;
  1219. try
  1220. {
  1222.     this.listView2.Items.Clear();
  1223. while(MyReader.Read())
  1224. {
  1225. ListViewItem MyItem=new ListViewItem();
  1226. MyItem.Text=MyReader.GetValue(0).ToString();
  1227. for(int j=0;j<MyReader.FieldCount-2;j++)
  1228. MyItem.SubItems.Add(MyReader.GetValue(j+1).ToString());
  1229. string flog=MyReader.GetValue(MyReader.FieldCount-1).ToString();
  1230. switch(flog)
  1231. {
  1232. case "yes":MyItem.SubItems.Add("管理人员");break;
  1233. case "no":MyItem.SubItems.Add("销售人员");break;
  1234. }
  1236. this.listView2.Items.Add(MyItem);
  1238. }
  1239. MyReader.Close();
  1240. this.oleDbConnection1.Close();
  1241. }
  1242. catch
  1243. {
  1244. MessageBox.Show(this,"帐户不存在！");
  1245. MyReader.Close();
  1246. this.oleDbConnection1.Close();
  1247. return;
  1248. }
  1250. }
  1252. private void menuItem5_Click(object sender, System.EventArgs e)
  1253. {
  1254. panel1.Visible=false;
  1255. panel2.Visible=false;
  1256. textBox1.Text="";
  1257. textBox2.Text="";
  1258. listView1.Items.Clear();
  1259.          
  1260. }
  1262. private void ifcheck(object sender, System.Windows.Forms.ItemCheckEventArgs e)
  1263. {
  1264. }
  1266. private void select(object sender, System.EventArgs e)
  1267. {
  1268. string j;
  1270. for(int i=this.listView2.SelectedItems.Count-1; i>=0;i--)
  1271. {
  1272. ListViewItem item = this.listView2.SelectedItems[i];
  1273. j=item.Text;
  1274. //j=this.listView2.Items.Add;
  1275. string str="select * from login where id="+j+"";
  1276. this.oleDbDataAdapter1.SelectCommand.CommandText=str;
  1277. this.oleDbDataAdapter1.SelectCommand.Connection=this.oleDbConnection1;
  1278. //打开数据库连接
  1279. this.oleDbConnection1.Open();
  1280. System.Data.OleDb.OleDbDataReader MyReader=this.oleDbDataAdapter1.SelectCommand.ExecuteReader();
  1281. MyReader.Read();
  1282. groupBox1.Text=MyReader.GetValue(0).ToString();
  1283. textBox3.Text=MyReader.GetValue(1).ToString();
  1284. textBox4.Text=MyReader.GetValue(2).ToString();
  1285. switch(MyReader.GetValue(3).ToString())
  1286. {
  1287. case "yes":comboBox1.Text="管理人员";break;
  1288. case "no":comboBox1.Text="销售人员";break;
  1289. }
  1291. MyReader.Close();
  1292. this.oleDbConnection1.Close();
  1293. }
  1296. }
  1298. private void button6_Click(object sender, System.EventArgs e)
  1299. {
  1300. ListViewItem item1 = this.listView2.SelectedItems[0];
  1301. //textBox3.Text=item1.Text;
  1302. for(int i=this.listView2.SelectedItems.Count-1; i>=0;i--)
  1303. {
  1304. ListViewItem item = this.listView2.SelectedItems[i];
  1305. this.listView2.Items.Remove(item);
  1306. string uflog=item.Text;
  1307. string deletesql="delete from login where id="+uflog+"";
  1308.                 SqlCommand myCommand = new SqlCommand(deletesql, myConnection);
  1309. myCommand.Connection.Open();
  1311. try 
  1312. {
  1313. myCommand.ExecuteNonQuery();
  1314. myCommand.Connection.Close();
  1315. MessageBox.Show("删除数据成功！ ");
  1316. }
  1317. catch (SqlException ex)
  1318. {
  1319. MessageBox.Show("删除数据错误！ " + ex.Message.ToString());
  1320. myCommand.Connection.Close();
  1321. return;
  1322. }
  1325. }
  1326.             
  1327. }
  1329. private void button5_Click(object sender, System.EventArgs e)
  1330. {
  1331. string pname,pwd,ismanage;
  1332. pname=textBox3.Text;
  1333. pwd=textBox4.Text;
  1334. switch(comboBox1.Text)
  1335. {
  1336. case"管理人员":ismanage="yes";break;
  1337. case"销售人员":ismanage="no";break;
  1338. default:
  1339. return;
  1340. }
  1341. string updatesql="update login set uname=@pname,pwd=@pwd,ismanage=@ismanage where id=@id";
  1342.  SqlCommand myCommand = new SqlCommand(updatesql, myConnection);
  1344. myCommand.Parameters.Add(new SqlParameter("@id", SqlDbType.NVarChar, 20));
  1345. myCommand.Parameters["@id"].Value = groupBox1.Text;
  1347. myCommand.Parameters.Add(new SqlParameter("@pname", SqlDbType.NVarChar, 20));
  1348. myCommand.Parameters["@pname"].Value = textBox3.Text;
  1350. myCommand.Parameters.Add(new SqlParameter("@pwd", SqlDbType.NVarChar, 20));
  1351. myCommand.Parameters["@pwd"].Value = textBox4.Text;
  1353. myCommand.Parameters.Add(new SqlParameter("@ismanage", SqlDbType.NVarChar, 3));
  1354. myCommand.Parameters["@ismanage"].Value = ismanage;
  1356. myCommand.Connection.Open();
  1358. try 
  1359. {
  1360. myCommand.ExecuteNonQuery();
  1361. //listView2.Select();
  1362. //listView2.Refresh();
  1363. MessageBox.Show("修改数据成功！ ");
  1364. myCommand.Connection.Close();
  1366. }
  1367. catch (SqlException ex)
  1368. {
  1369. MessageBox.Show("修改数据错误！ " + ex.Message.ToString());
  1370. myCommand.Connection.Close();
  1371. return;
  1372. }
  1373. string str="select * from login";
  1374. this.oleDbDataAdapter1.SelectCommand.CommandText=str;
  1375. this.oleDbDataAdapter1.SelectCommand.Connection=this.oleDbConnection1;
  1376. //打开数据库连接
  1377. this.oleDbConnection1.Open();
  1378. System.Data.OleDb.OleDbDataReader MyReader=this.oleDbDataAdapter1.SelectCommand.ExecuteReader();
  1380. //this.listView1.View=View.Details;
  1382. try
  1383. {
  1385. this.listView2.Items.Clear();
  1386. while(MyReader.Read())
  1387. {
  1388. ListViewItem MyItem=new ListViewItem();
  1389. MyItem.Text=MyReader.GetValue(0).ToString();
  1390. for(int j=0;j<MyReader.FieldCount-2;j++)
  1391. MyItem.SubItems.Add(MyReader.GetValue(j+1).ToString());
  1392. string flog=MyReader.GetValue(MyReader.FieldCount-1).ToString();
  1393. switch(flog)
  1394. {
  1395. case "yes":MyItem.SubItems.Add("管理人员");break;
  1396. case "no":MyItem.SubItems.Add("销售人员");break;
  1397. }
  1399. this.listView2.Items.Add(MyItem);
  1401. }
  1402. MyReader.Close();
  1403. this.oleDbConnection1.Close();
  1404. }
  1405. catch
  1406. {
  1407. MessageBox.Show(this,"帐户不存在！");
  1408. MyReader.Close();
  1409. this.oleDbConnection1.Close();
  1410. return;
  1411. }
  1414. }
  1416. private void button4_Click(object sender, System.EventArgs e)
  1417. {
  1420. string ismasage;
  1421. switch(comboBox1.Text)
  1422. {
  1423. case"管理人员":ismasage="yes";break;
  1424. case"销售人员":ismasage="no";break;
  1425. default:
  1426. return;
  1427. }
  1428. string insertsql="insert into login (uname,pwd,ismanage)values(@pname,@pwd,@ismanage)";
  1429. SqlCommand myCommand=new SqlCommand(insertsql,myConnection);
  1431. myCommand.Parameters.Add(new SqlParameter("@pname", SqlDbType.NVarChar, 20));
  1432. myCommand.Parameters["@pname"].Value = textBox3.Text;
  1434. myCommand.Parameters.Add(new SqlParameter("@pwd", SqlDbType.NVarChar, 20));
  1435. myCommand.Parameters["@pwd"].Value = textBox4.Text;
  1437. myCommand.Parameters.Add(new SqlParameter("@ismanage", SqlDbType.NVarChar, 3));
  1438. myCommand.Parameters["@ismanage"].Value = ismasage;
  1440. myCommand.Connection.Open();
  1442. try 
  1443. {
  1444. myCommand.ExecuteNonQuery();
  1445. //listView2.Select();
  1446. //listView2.Refresh();
  1447. myCommand.Connection.Close();
  1448. MessageBox.Show("插入数据成功！ ");
  1450. }
  1451. catch (SqlException ex)
  1452. {
  1453. MessageBox.Show("插入数据错误！ " + ex.Message.ToString());
  1454. myCommand.Connection.Close();
  1455. return;
  1456. }
  1457. string str="select * from login";
  1458. this.oleDbDataAdapter1.SelectCommand.CommandText=str;
  1459. this.oleDbDataAdapter1.SelectCommand.Connection=this.oleDbConnection1;
  1460. //打开数据库连接
  1461. this.oleDbConnection1.Open();
  1462. System.Data.OleDb.OleDbDataReader MyReader=this.oleDbDataAdapter1.SelectCommand.ExecuteReader();
  1464. //this.listView1.View=View.Details;
  1466. try
  1467. {
  1469. this.listView2.Items.Clear();
  1470. while(MyReader.Read())
  1471. {
  1472. ListViewItem MyItem=new ListViewItem();
  1473. MyItem.Text=MyReader.GetValue(0).ToString();
  1474. for(int j=0;j<MyReader.FieldCount-2;j++)
  1475. MyItem.SubItems.Add(MyReader.GetValue(j+1).ToString());
  1476. string flog=MyReader.GetValue(MyReader.FieldCount-1).ToString();
  1477. switch(flog)
  1478. {
  1479. case "yes":MyItem.SubItems.Add("管理人员");break;
  1480. case "no":MyItem.SubItems.Add("销售人员");break;
  1481. }
  1483. this.listView2.Items.Add(MyItem);
  1485. }
  1486. MyReader.Close();
  1487. this.oleDbConnection1.Close();
  1488. }
  1489. catch
  1490. {
  1491. MessageBox.Show(this,"帐户不存在！");
  1492. MyReader.Close();
  1493. this.oleDbConnection1.Close();
  1494. return;
  1495. }
  1498. }
  1500. private void menuItem9_Click(object sender, System.EventArgs e)
  1501. {
  1502. textBox10.Text="";
  1503. panel1.Visible=false;
  1504. panel2.Visible=true;
  1505. string production="select * from production";
  1506. this.oleDbDataAdapter1.SelectCommand.CommandText=production;
  1507. this.oleDbDataAdapter1.SelectCommand.Connection=this.oleDbConnection1;
  1508. //打开数据库连接
  1509. this.oleDbConnection1.Open();
  1510. System.Data.OleDb.OleDbDataReader MyReader2=this.oleDbDataAdapter1.SelectCommand.ExecuteReader();
  1512. //this.listView1.View=View.Details;
  1514. try
  1515. {
  1517. this.listView3.Items.Clear();
  1518. while(MyReader2.Read())
  1519. {
  1520. ListViewItem MyItem=new ListViewItem();
  1521. MyItem.Text=MyReader2.GetValue(0).ToString();
  1522. for(int j=0;j<MyReader2.FieldCount-1;j++)
  1523. MyItem.SubItems.Add(MyReader2.GetValue(j+1).ToString());
  1524. string flog=MyReader2.GetValue(MyReader2.FieldCount-1).ToString();
  1525. this.listView3.Items.Add(MyItem);
  1527. }
  1528. MyReader2.Close();
  1529. this.oleDbConnection1.Close();
  1530. }
  1531. catch
  1532. {
  1533. MessageBox.Show(this,"帐户不存在！");
  1534. MyReader2.Close();
  1535. this.oleDbConnection1.Close();
  1536. return;
  1537. } 
  1538. }
  1540. private void v3select(object sender, System.EventArgs e)
  1541. {
  1542. string j;
  1544. for(int i=this.listView3.SelectedItems.Count-1; i>=0;i--)
  1545. {
  1546. ListViewItem item = this.listView3.SelectedItems[i];
  1547. j=item.Text;
  1548. //j=this.listView2.Items.Add;
  1549. string str="select * from production where pid="+j+"";
  1550. this.oleDbDataAdapter1.SelectCommand.CommandText=str;
  1551. this.oleDbDataAdapter1.SelectCommand.Connection=this.oleDbConnection1;
  1552. //打开数据库连接
  1553. this.oleDbConnection1.Open();
  1554. System.Data.OleDb.OleDbDataReader MyReader=this.oleDbDataAdapter1.SelectCommand.ExecuteReader();
  1555. MyReader.Read();
  1556. groupBox2.Text=MyReader.GetValue(0).ToString();
  1557. textBox5.Text=MyReader.GetValue(1).ToString();
  1558. textBox6.Text=MyReader.GetValue(2).ToString();
  1559. textBox7.Text=MyReader.GetValue(3).ToString();
  1560. textBox8.Text=MyReader.GetValue(4).ToString();
  1561. textBox9.Text=MyReader.GetValue(5).ToString();
  1564. MyReader.Close();
  1565. this.oleDbConnection1.Close();
  1566. }
  1567. }
  1569. private void button7_Click(object sender, System.EventArgs e)
  1570. {
  1571. string pkey=textBox10.Text;
  1572. string selectp="select * from production where pname like '%"+pkey+"%'";
  1573. this.oleDbDataAdapter1.SelectCommand.CommandText=selectp;
  1574. this.oleDbDataAdapter1.SelectCommand.Connection=this.oleDbConnection1;
  1575. //打开数据库连接
  1576. this.oleDbConnection1.Open();
  1577. System.Data.OleDb.OleDbDataReader MyReader=this.oleDbDataAdapter1.SelectCommand.ExecuteReader();
  1578. this.listView3.Items.Clear();
  1580. try
  1581. {
  1584. while(MyReader.Read())
  1585. {
  1586. groupBox2.Text=MyReader.GetValue(0).ToString();
  1587. textBox5.Text=MyReader.GetValue(1).ToString();
  1588. textBox6.Text=MyReader.GetValue(2).ToString();
  1589. textBox7.Text=MyReader.GetValue(3).ToString();
  1590. textBox8.Text=MyReader.GetValue(4).ToString();
  1591. textBox9.Text=MyReader.GetValue(5).ToString();
  1592. ListViewItem MyItem=new ListViewItem();
  1593. MyItem.Text=MyReader.GetValue(0).ToString();
  1594. for(int j=0;j<MyReader.FieldCount-1;j++)
  1595. MyItem.SubItems.Add(MyReader.GetValue(j+1).ToString());
  1596. /*int b=MyReader.GetInt32(3);
  1597. double c=a*b;
  1598. string ff=c.ToString();
  1599. MyItem.SubItems.Add(ff);*/
  1600. //MyItem.SubItems.Add(textBox2.Text);
  1601. //MyItem.SubItems.Add(allp.ToString());
  1602.                 
  1603. this.listView3.Items.Add(MyItem);
  1604. }
  1605. MyReader.Close();
  1606. this.oleDbConnection1.Close();
  1607. }
  1608. catch
  1609. {
  1610. MessageBox.Show(this,"商品不存在！");
  1611. this.oleDbConnection1.Close();
  1612. return;
  1613. }
  1617. }
  1619. private void button8_Click(object sender, System.EventArgs e)
  1620. {
  1621.     textBox10.Text="";
  1622. string production="select * from production";
  1623. this.oleDbDataAdapter1.SelectCommand.CommandText=production;
  1624. this.oleDbDataAdapter1.SelectCommand.Connection=this.oleDbConnection1;
  1625. //打开数据库连接
  1626. this.oleDbConnection1.Open();
  1627. System.Data.OleDb.OleDbDataReader MyReader2=this.oleDbDataAdapter1.SelectCommand.ExecuteReader();
  1629. //this.listView1.View=View.Details;
  1631. try
  1632. {
  1634. this.listView3.Items.Clear();
  1635. while(MyReader2.Read())
  1636. {
  1637. ListViewItem MyItem=new ListViewItem();
  1638. MyItem.Text=MyReader2.GetValue(0).ToString();
  1639. for(int j=0;j<MyReader2.FieldCount-1;j++)
  1640. MyItem.SubItems.Add(MyReader2.GetValue(j+1).ToString());
  1641. string flog=MyReader2.GetValue(MyReader2.FieldCount-1).ToString();
  1642. this.listView3.Items.Add(MyItem);
  1644. }
  1645. MyReader2.Close();
  1646. this.oleDbConnection1.Close();
  1647. }
  1648. catch
  1649. {
  1650. MyReader2.Close();
  1651. this.oleDbConnection1.Close();
  1652. MessageBox.Show(this,"帐户不存在！");
  1654. } 
  1655. }
  1657. private void button9_Click(object sender, System.EventArgs e)
  1658. {
  1659. textBox10.Text="";
  1660. string insertCmd = "insert into production(pname,price,unit,huojia,kucun)values( @pname, @price, @unit, @huojia,@kucun)";
  1662. SqlCommand myCommand = new SqlCommand(insertCmd, myConnection);
  1664. myCommand.Parameters.Add(new SqlParameter("@pname", SqlDbType.NVarChar, 20));
  1665. myCommand.Parameters["@pname"].Value = textBox5.Text;
  1667. myCommand.Parameters.Add(new SqlParameter("@price", SqlDbType.Float, 8));
  1668. myCommand.Parameters["@price"].Value = textBox6.Text;
  1670. myCommand.Parameters.Add(new SqlParameter("@unit", SqlDbType.NVarChar, 3));
  1671. myCommand.Parameters["@unit"].Value = textBox7.Text;
  1674. myCommand.Parameters.Add(new SqlParameter("@huojia", SqlDbType.NVarChar, 3));
  1675. myCommand.Parameters["@huojia"].Value = textBox8.Text;
  1677. myCommand.Parameters.Add(new SqlParameter("@kucun", SqlDbType.Int, 4));
  1678. myCommand.Parameters["@kucun"].Value = textBox9.Text;
  1680. myCommand.Connection.Open();
  1682. try 
  1683. {
  1684. //this.menuItem9_Click(button9,e);
  1685. myCommand.ExecuteNonQuery();
  1686. MessageBox.Show("插入数据成功！ ");
  1687. }
  1688. catch (SqlException ex)
  1689. {
  1690. MessageBox.Show("插入数据错误！ " + ex.Message.ToString());
  1691. }
  1693. myCommand.Connection.Close();
  1694. string production="select * from production";
  1695. this.oleDbDataAdapter1.SelectCommand.CommandText=production;
  1696. this.oleDbDataAdapter1.SelectCommand.Connection=this.oleDbConnection1;
  1697. //打开数据库连接
  1698. this.oleDbConnection1.Open();
  1699. System.Data.OleDb.OleDbDataReader MyReader2=this.oleDbDataAdapter1.SelectCommand.ExecuteReader();
  1701. //this.listView1.View=View.Details;
  1703. try
  1704. {
  1706. this.listView3.Items.Clear();
  1707. while(MyReader2.Read())
  1708. {
  1709. ListViewItem MyItem=new ListViewItem();
  1710. MyItem.Text=MyReader2.GetValue(0).ToString();
  1711. for(int j=0;j<MyReader2.FieldCount-1;j++)
  1712. MyItem.SubItems.Add(MyReader2.GetValue(j+1).ToString());
  1713. string flog=MyReader2.GetValue(MyReader2.FieldCount-1).ToString();
  1714. this.listView3.Items.Add(MyItem);
  1716. }
  1717. MyReader2.Close();
  1718. this.oleDbConnection1.Close();
  1719. }
  1720. catch
  1721. {
  1722. MessageBox.Show(this,"帐户不存在！");
  1723. MyReader2.Close();
  1724. this.oleDbConnection1.Close();
  1725. return;
  1726. } 
  1727. }
  1729. private void button10_Click(object sender, System.EventArgs e)
  1730. {
  1731. ListViewItem item1 = this.listView3.SelectedItems[0];
  1732. //textBox3.Text=item1.Text;
  1733. for(int i=this.listView3.SelectedItems.Count-1; i>=0;i--)
  1734. {
  1735. ListViewItem item = this.listView3.SelectedItems[i];
  1736. this.listView3.Items.Remove(item);
  1737. string pflog=item.Text;
  1738. string deletesql="delete from production where pid="+pflog+"";
  1739. SqlCommand myCommand = new SqlCommand(deletesql, myConnection);
  1740. myCommand.Connection.Open();
  1742. try 
  1743. {
  1744. myCommand.ExecuteNonQuery();
  1745. MessageBox.Show("删除数据成功！ ");
  1746. }
  1747. catch (SqlException ex)
  1748. {
  1749. MessageBox.Show("删除数据错误！ " + ex.Message.ToString());
  1750. }
  1752. myCommand.Connection.Close();
  1753. }
  1754. }
  1756. private void button11_Click(object sender, System.EventArgs e)
  1757. {
  1758. string updatesql="update production set pname=@pname,price=@price,unit=@unit,huojia=@huojia,kucun=@kucun where pid=@pid";
  1759. SqlCommand myCommand = new SqlCommand(updatesql, myConnection);
  1761. myCommand.Parameters.Add(new SqlParameter("@pid", SqlDbType.Int, 4));
  1762. myCommand.Parameters["@pid"].Value = groupBox2.Text;
  1764. myCommand.Parameters.Add(new SqlParameter("@pname", SqlDbType.NVarChar, 20));
  1765. myCommand.Parameters["@pname"].Value = textBox5.Text;
  1767. myCommand.Parameters.Add(new SqlParameter("@price", SqlDbType.Real, 8));
  1768. myCommand.Parameters["@price"].Value = Convert.ToDouble(textBox6.Text.ToString());
  1770. myCommand.Parameters.Add(new SqlParameter("@unit", SqlDbType.NVarChar, 3));
  1771. myCommand.Parameters["@unit"].Value = textBox7.Text;
  1774. myCommand.Parameters.Add(new SqlParameter("@huojia", SqlDbType.NVarChar, 3));
  1775. myCommand.Parameters["@huojia"].Value = textBox8.Text;
  1777. myCommand.Parameters.Add(new SqlParameter("@kucun", SqlDbType.Int, 4));
  1778. myCommand.Parameters["@kucun"].Value = textBox9.Text;
  1780. myCommand.Connection.Open();
  1782. try 
  1783. {
  1784. myCommand.ExecuteNonQuery();
  1785. //listView2.Select();
  1786. //listView2.Refresh();
  1787. MessageBox.Show("修改数据成功！ ");
  1789. }
  1790. catch (SqlException ex)
  1791. {
  1792. MessageBox.Show("修改数据错误！ " + ex.Message.ToString());
  1793. }
  1795. myCommand.Connection.Close();
  1796. string pkey;
  1797. if(textBox10.Text!="")
  1798. {
  1799. pkey=textBox10.Text;
  1800. }
  1801. else
  1802. {
  1803. pkey=textBox5.Text;
  1804. }
  1805. string selectp="select * from production where pname like '%"+pkey+"%'";
  1806. this.oleDbDataAdapter1.SelectCommand.CommandText=selectp;
  1807. this.oleDbDataAdapter1.SelectCommand.Connection=this.oleDbConnection1;
  1808. //打开数据库连接
  1809. this.oleDbConnection1.Open();
  1810. System.Data.OleDb.OleDbDataReader MyReader=this.oleDbDataAdapter1.SelectCommand.ExecuteReader();
  1811. this.listView3.Items.Clear();
  1813. try
  1814. {
  1817. while(MyReader.Read())
  1818. {
  1819. groupBox2.Text=MyReader.GetValue(0).ToString();
  1820. textBox5.Text=MyReader.GetValue(1).ToString();
  1821. textBox6.Text=MyReader.GetValue(2).ToString();
  1822. textBox7.Text=MyReader.GetValue(3).ToString();
  1823. textBox8.Text=MyReader.GetValue(4).ToString();
  1824. textBox9.Text=MyReader.GetValue(5).ToString();
  1825. ListViewItem MyItem=new ListViewItem();
  1826. MyItem.Text=MyReader.GetValue(0).ToString();
  1827. for(int j=0;j<MyReader.FieldCount-1;j++)
  1828. MyItem.SubItems.Add(MyReader.GetValue(j+1).ToString());
  1829. /*int b=MyReader.GetInt32(3);
  1830. double c=a*b;
  1831. string ff=c.ToString();
  1832. MyItem.SubItems.Add(ff);*/
  1833. //MyItem.SubItems.Add(textBox2.Text);
  1834. //MyItem.SubItems.Add(allp.ToString());
  1835.                 
  1836. this.listView3.Items.Add(MyItem);
  1837. }
  1838. MyReader.Close();
  1839. this.oleDbConnection1.Close();
  1840. }
  1841. catch
  1842. {
  1843. MessageBox.Show(this,"商品不存在！");
  1844. this.oleDbConnection1.Close();
  1845. return;
  1846. }
  1847. }
  1849. private void button2_Click(object sender, System.EventArgs e)
  1850. {
  1851. string allprice="select sum(allp) from soled where sallflog=@flog";
  1852. SqlCommand myCommand = new SqlCommand(allprice, myConnection);
  1854.             myCommand.Parameters.Add("@flog",SqlDbType.Int, 4);
  1855. myCommand.Parameters["@flog"].Value=floglb.Text;
  1856. myCommand.Connection.Open();
  1857. try 
  1858. {
  1859. string money=myCommand.ExecuteScalar().ToString();
  1860. myCommand.Connection.Close();
  1861. button1.Visible=false;
  1862. button12.Visible=false;
  1864. MessageBox.Show("应收金额：" + money);
  1865. }
  1866. catch(SqlException ex)
  1867. {
  1868. MessageBox.Show("统计数据错误！ " + ex.Message.ToString());
  1869. myCommand.Connection.Close();
  1870. return;
  1871. }
  1873. }
  1875. private void button12_Click(object sender, System.EventArgs e)
  1876. {
  1877. ListViewItem item1 = this.listView1.SelectedItems[0];
  1878. //textBox3.Text=item1.Text;
  1879. for(int i=this.listView1.SelectedItems.Count-1; i>=0;i--)
  1880. {
  1881. ListViewItem item = this.listView1.SelectedItems[i];
  1882. this.listView1.Items.Remove(item);
  1883. string pid=item.Text;
  1884. string pflog=floglb.Text;
  1885. string deletesql="delete from soled where sallflog="+pflog+" and pid="+pid+"";
  1886. SqlCommand myCommand = new SqlCommand(deletesql, myConnection);
  1887. myCommand.Connection.Open();
  1889. try 
  1890. {
  1891. myCommand.ExecuteNonQuery();
  1892. MessageBox.Show("删除数据成功！ ");
  1893. myCommand.Connection.Close();
  1894. }
  1895. catch (SqlException ex)
  1896. {
  1897. MessageBox.Show("删除数据错误！ " + ex.Message.ToString());
  1898. return;
  1899. }
  1902. }
  1903. }
  1905. private void groupBox3_Enter(object sender, System.EventArgs e)
  1906. {
  1908. }
  1910. private void statusBar1_PanelClick(object sender, System.Windows.Forms.StatusBarPanelClickEventArgs e)
  1911. {
  1913. }
  1914. }
  1915. }