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

源码开发语言/平台
当前位置：首页 > 源码/资料 > 行业应用 > 企业管理 > 查看源码
MRPHistory.cs
资源名称：VCSDB.rar　[点击查看]
上传用户：hjieqiu
上传日期：2013-05-11
资源大小：16494k
文件大小：18k
源码类别：

企业管理

开发平台：

C#

MRPHistory.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. /// MRPHistory 的摘要说明。
  11. /// </summary>
  12. public class MRPHistory : System.Windows.Forms.Form
  13. {
  14. private System.Windows.Forms.GroupBox groupBox2;
  15. private System.Windows.Forms.DataGrid dataGrid1;
  16. private System.Windows.Forms.GroupBox groupBox1;
  17. private System.Windows.Forms.Label label6;
  18. private System.Windows.Forms.Button btnSearch;
  19. private System.Windows.Forms.Label label7;
  20. private System.Windows.Forms.Label label1;
  21. private System.Windows.Forms.TextBox txt1;
  22. private System.Windows.Forms.TextBox txt3;
  23. private System.Windows.Forms.TextBox txt2;
  24. private System.Data.SqlClient.SqlDataAdapter da1;
  25. private System.Data.SqlClient.SqlCommand sqlSelectCommand1;
  26. private System.Data.SqlClient.SqlConnection sqlConnection1;
  27. private 生产管理系统.DataSet3 dataSet31;
  28. private System.Data.DataView dataView1;
  29. private System.Windows.Forms.TextBox textBox1;
  30. private System.Windows.Forms.TextBox textBox2;
  31. private System.Windows.Forms.TextBox txt5;
  32. private System.Windows.Forms.TextBox txt4;
  33. private System.Windows.Forms.TextBox textBox3;
  34. private System.Windows.Forms.TextBox txt6;
  35. private System.Windows.Forms.Label label2;
  36. private System.Windows.Forms.Label label3;
  37. private System.Windows.Forms.Label label4;
  38. private System.Windows.Forms.Label label5;
  39. private System.Windows.Forms.Label label8;
  40. private System.Windows.Forms.Label label9;
  41. private System.Windows.Forms.TextBox textBox4;
  42. private System.Windows.Forms.TextBox textBox5;
  43. private System.Windows.Forms.TextBox textBox6;
  44. private System.Windows.Forms.Label label10;
  45. private System.Windows.Forms.Label label11;
  46. private System.Windows.Forms.Label label12;
  47. /// <summary>
  48. /// 必需的设计器变量。
  49. /// </summary>
  50. private System.ComponentModel.Container components = null;
  52. public MRPHistory()
  53. {
  54. //
  55. // Windows 窗体设计器支持所必需的
  56. //
  57. InitializeComponent();
  59. //
  60. // TODO: 在 InitializeComponent 调用后添加任何构造函数代码
  61. //
  62. }
  64. /// <summary>
  65. /// 清理所有正在使用的资源。
  66. /// </summary>
  67. protected override void Dispose( bool disposing )
  68. {
  69. if( disposing )
  70. {
  71. if(components != null)
  72. {
  73. components.Dispose();
  74. }
  75. }
  76. base.Dispose( disposing );
  77. }
  79. #region Windows 窗体设计器生成的代码
  80. /// <summary>
  81. /// 设计器支持所需的方法 - 不要使用代码编辑器修改
  82. /// 此方法的内容。
  83. /// </summary>
  84. private void InitializeComponent()
  85. {
  86. System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(MRPHistory));
  87. this.da1 = new System.Data.SqlClient.SqlDataAdapter();
  88. this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
  89. this.sqlConnection1 = new System.Data.SqlClient.SqlConnection();
  90. this.groupBox2 = new System.Windows.Forms.GroupBox();
  91. this.textBox1 = new System.Windows.Forms.TextBox();
  92. this.dataView1 = new System.Data.DataView();
  93. this.dataSet31 = new 生产管理系统.DataSet3();
  94. this.textBox2 = new System.Windows.Forms.TextBox();
  95. this.txt5 = new System.Windows.Forms.TextBox();
  96. this.txt4 = new System.Windows.Forms.TextBox();
  97. this.textBox3 = new System.Windows.Forms.TextBox();
  98. this.txt6 = new System.Windows.Forms.TextBox();
  99. this.label2 = new System.Windows.Forms.Label();
  100. this.label3 = new System.Windows.Forms.Label();
  101. this.label4 = new System.Windows.Forms.Label();
  102. this.label5 = new System.Windows.Forms.Label();
  103. this.label8 = new System.Windows.Forms.Label();
  104. this.label9 = new System.Windows.Forms.Label();
  105. this.textBox4 = new System.Windows.Forms.TextBox();
  106. this.textBox5 = new System.Windows.Forms.TextBox();
  107. this.textBox6 = new System.Windows.Forms.TextBox();
  108. this.label10 = new System.Windows.Forms.Label();
  109. this.label11 = new System.Windows.Forms.Label();
  110. this.label12 = new System.Windows.Forms.Label();
  111. this.dataGrid1 = new System.Windows.Forms.DataGrid();
  112. this.groupBox1 = new System.Windows.Forms.GroupBox();
  113. this.txt3 = new System.Windows.Forms.TextBox();
  114. this.label6 = new System.Windows.Forms.Label();
  115. this.btnSearch = new System.Windows.Forms.Button();
  116. this.txt2 = new System.Windows.Forms.TextBox();
  117. this.label7 = new System.Windows.Forms.Label();
  118. this.txt1 = new System.Windows.Forms.TextBox();
  119. this.label1 = new System.Windows.Forms.Label();
  120. this.groupBox2.SuspendLayout();
  121. ((System.ComponentModel.ISupportInitialize)(this.dataView1)).BeginInit();
  122. ((System.ComponentModel.ISupportInitialize)(this.dataSet31)).BeginInit();
  123. ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
  124. this.groupBox1.SuspendLayout();
  125. this.SuspendLayout();
  126. // 
  127. // da1
  128. // 
  129. this.da1.SelectCommand = this.sqlSelectCommand1;
  130. this.da1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
  131.   new System.Data.Common.DataTableMapping("Table", "mrp物料需求历史", new System.Data.Common.DataColumnMapping[] {
  132.    new System.Data.Common.DataColumnMapping("物料名称", "物料名称"),
  133.    new System.Data.Common.DataColumnMapping("发布编号", "发布编号"),
  134.    new System.Data.Common.DataColumnMapping("发布时间", "发布时间"),
  135.    new System.Data.Common.DataColumnMapping("物料编号", "物料编号"),
  136.    new System.Data.Common.DataColumnMapping("年份", "年份"),
  137.    new System.Data.Common.DataColumnMapping("计划期", "计划期"),
  138.    new System.Data.Common.DataColumnMapping("期初库存", "期初库存"),
  139.    new System.Data.Common.DataColumnMapping("毛需求", "毛需求"),
  140.    new System.Data.Common.DataColumnMapping("预计入库", "预计入库"),
  141.    new System.Data.Common.DataColumnMapping("预计出库", "预计出库"),
  142.    new System.Data.Common.DataColumnMapping("预计库存", "预计库存"),
  143.    new System.Data.Common.DataColumnMapping("净需求", "净需求"),
  144.    new System.Data.Common.DataColumnMapping("计划产出", "计划产出"),
  145.    new System.Data.Common.DataColumnMapping("计划投入", "计划投入")})});
  146. // 
  147. // sqlSelectCommand1
  148. // 
  149. this.sqlSelectCommand1.CommandText = "SELECT b.物料名称, a.发布编号, a.发布时间, a.物料编号, a.年份, a.计划期, a.期初库存, a.毛需求, a.预计入库, a.预计出库" +
  150. ", a.预计库存, a.净需求, a.计划产出, a.计划投入 FROM mrp物料需求历史 a INNER JOIN 物料主文件 b ON a.物料编号 = " +
  151. "b.物料编号";
  152. this.sqlSelectCommand1.Connection = this.sqlConnection1;
  153. // 
  154. // sqlConnection1
  155. // 
  156. this.sqlConnection1.ConnectionString = "workstation id=localhost;Integrated Security=SSPI;Database=mrpbook;";
  157. // 
  158. // groupBox2
  159. // 
  160. this.groupBox2.Controls.Add(this.textBox1);
  161. this.groupBox2.Controls.Add(this.textBox2);
  162. this.groupBox2.Controls.Add(this.txt5);
  163. this.groupBox2.Controls.Add(this.txt4);
  164. this.groupBox2.Controls.Add(this.textBox3);
  165. this.groupBox2.Controls.Add(this.txt6);
  166. this.groupBox2.Controls.Add(this.label2);
  167. this.groupBox2.Controls.Add(this.label3);
  168. this.groupBox2.Controls.Add(this.label4);
  169. this.groupBox2.Controls.Add(this.label5);
  170. this.groupBox2.Controls.Add(this.label8);
  171. this.groupBox2.Controls.Add(this.label9);
  172. this.groupBox2.Controls.Add(this.textBox4);
  173. this.groupBox2.Controls.Add(this.textBox5);
  174. this.groupBox2.Controls.Add(this.textBox6);
  175. this.groupBox2.Controls.Add(this.label10);
  176. this.groupBox2.Controls.Add(this.label11);
  177. this.groupBox2.Controls.Add(this.label12);
  178. this.groupBox2.Location = new System.Drawing.Point(0, 64);
  179. this.groupBox2.Name = "groupBox2";
  180. this.groupBox2.Size = new System.Drawing.Size(544, 120);
  181. this.groupBox2.TabIndex = 1;
  182. this.groupBox2.TabStop = false;
  183. // 
  184. // textBox1
  185. // 
  186. this.textBox1.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataView1, "年份"));
  187. this.textBox1.Enabled = false;
  188. this.textBox1.Location = new System.Drawing.Point(72, 56);
  189. this.textBox1.Name = "textBox1";
  190. this.textBox1.ReadOnly = true;
  191. this.textBox1.TabIndex = 72;
  192. this.textBox1.Text = "";
  193. // 
  194. // dataView1
  195. // 
  196. this.dataView1.Table = this.dataSet31.mrp物料需求历史;
  197. // 
  198. // dataSet31
  199. // 
  200. this.dataSet31.DataSetName = "DataSet3";
  201. this.dataSet31.Locale = new System.Globalization.CultureInfo("zh-CN");
  202. // 
  203. // textBox2
  204. // 
  205. this.textBox2.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataView1, "物料编号"));
  206. this.textBox2.Enabled = false;
  207. this.textBox2.Location = new System.Drawing.Point(72, 26);
  208. this.textBox2.Name = "textBox2";
  209. this.textBox2.ReadOnly = true;
  210. this.textBox2.TabIndex = 71;
  211. this.textBox2.Text = "";
  212. // 
  213. // txt5
  214. // 
  215. this.txt5.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataView1, "计划期"));
  216. this.txt5.Enabled = false;
  217. this.txt5.Location = new System.Drawing.Point(256, 56);
  218. this.txt5.Name = "txt5";
  219. this.txt5.ReadOnly = true;
  220. this.txt5.TabIndex = 74;
  221. this.txt5.Text = "";
  222. // 
  223. // txt4
  224. // 
  225. this.txt4.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataView1, "物料名称"));
  226. this.txt4.Enabled = false;
  227. this.txt4.Location = new System.Drawing.Point(256, 26);
  228. this.txt4.Name = "txt4";
  229. this.txt4.ReadOnly = true;
  230. this.txt4.TabIndex = 70;
  231. this.txt4.Text = "";
  232. // 
  233. // textBox3
  234. // 
  235. this.textBox3.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataView1, "期初库存"));
  236. this.textBox3.Enabled = false;
  237. this.textBox3.Location = new System.Drawing.Point(72, 88);
  238. this.textBox3.Name = "textBox3";
  239. this.textBox3.ReadOnly = true;
  240. this.textBox3.TabIndex = 69;
  241. this.textBox3.Text = "";
  242. // 
  243. // txt6
  244. // 
  245. this.txt6.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataView1, "毛需求"));
  246. this.txt6.Enabled = false;
  247. this.txt6.Location = new System.Drawing.Point(256, 88);
  248. this.txt6.Name = "txt6";
  249. this.txt6.ReadOnly = true;
  250. this.txt6.TabIndex = 73;
  251. this.txt6.Text = "";
  252. // 
  253. // label2
  254. // 
  255. this.label2.Location = new System.Drawing.Point(33, 61);
  256. this.label2.Name = "label2";
  257. this.label2.Size = new System.Drawing.Size(32, 16);
  258. this.label2.TabIndex = 66;
  259. this.label2.Text = "年份";
  260. // 
  261. // label3
  262. // 
  263. this.label3.Location = new System.Drawing.Point(18, 31);
  264. this.label3.Name = "label3";
  265. this.label3.Size = new System.Drawing.Size(56, 16);
  266. this.label3.TabIndex = 63;
  267. this.label3.Text = "物料编号";
  268. // 
  269. // label4
  270. // 
  271. this.label4.Location = new System.Drawing.Point(216, 62);
  272. this.label4.Name = "label4";
  273. this.label4.Size = new System.Drawing.Size(48, 16);
  274. this.label4.TabIndex = 67;
  275. this.label4.Text = "计划期";
  276. // 
  277. // label5
  278. // 
  279. this.label5.Location = new System.Drawing.Point(203, 30);
  280. this.label5.Name = "label5";
  281. this.label5.Size = new System.Drawing.Size(56, 16);
  282. this.label5.TabIndex = 65;
  283. this.label5.Text = "物料名称";
  284. // 
  285. // label8
  286. // 
  287. this.label8.Location = new System.Drawing.Point(16, 92);
  288. this.label8.Name = "label8";
  289. this.label8.Size = new System.Drawing.Size(56, 16);
  290. this.label8.TabIndex = 64;
  291. this.label8.Text = "期初库存";
  292. // 
  293. // label9
  294. // 
  295. this.label9.Location = new System.Drawing.Point(216, 93);
  296. this.label9.Name = "label9";
  297. this.label9.Size = new System.Drawing.Size(48, 16);
  298. this.label9.TabIndex = 68;
  299. this.label9.Text = "毛需求";
  300. // 
  301. // textBox4
  302. // 
  303. this.textBox4.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataView1, "预计库存"));
  304. this.textBox4.Enabled = false;
  305. this.textBox4.Location = new System.Drawing.Point(424, 56);
  306. this.textBox4.Name = "textBox4";
  307. this.textBox4.ReadOnly = true;
  308. this.textBox4.TabIndex = 74;
  309. this.textBox4.Text = "";
  310. // 
  311. // textBox5
  312. // 
  313. this.textBox5.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataView1, "预计出库"));
  314. this.textBox5.Enabled = false;
  315. this.textBox5.Location = new System.Drawing.Point(424, 26);
  316. this.textBox5.Name = "textBox5";
  317. this.textBox5.ReadOnly = true;
  318. this.textBox5.TabIndex = 70;
  319. this.textBox5.Text = "";
  320. // 
  321. // textBox6
  322. // 
  323. this.textBox6.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataView1, "净需求"));
  324. this.textBox6.Enabled = false;
  325. this.textBox6.Location = new System.Drawing.Point(424, 88);
  326. this.textBox6.Name = "textBox6";
  327. this.textBox6.ReadOnly = true;
  328. this.textBox6.TabIndex = 73;
  329. this.textBox6.Text = "";
  330. // 
  331. // label10
  332. // 
  333. this.label10.Location = new System.Drawing.Point(371, 62);
  334. this.label10.Name = "label10";
  335. this.label10.Size = new System.Drawing.Size(56, 16);
  336. this.label10.TabIndex = 67;
  337. this.label10.Text = "预计库存";
  338. // 
  339. // label11
  340. // 
  341. this.label11.Location = new System.Drawing.Point(373, 32);
  342. this.label11.Name = "label11";
  343. this.label11.Size = new System.Drawing.Size(56, 16);
  344. this.label11.TabIndex = 65;
  345. this.label11.Text = "预计出库";
  346. // 
  347. // label12
  348. // 
  349. this.label12.Location = new System.Drawing.Point(384, 96);
  350. this.label12.Name = "label12";
  351. this.label12.Size = new System.Drawing.Size(56, 16);
  352. this.label12.TabIndex = 68;
  353. this.label12.Text = "净需求";
  354. // 
  355. // dataGrid1
  356. // 
  357. this.dataGrid1.CaptionVisible = false;
  358. this.dataGrid1.DataMember = "";
  359. this.dataGrid1.DataSource = this.dataView1;
  360. this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
  361. this.dataGrid1.Location = new System.Drawing.Point(0, 192);
  362. this.dataGrid1.Name = "dataGrid1";
  363. this.dataGrid1.ReadOnly = true;
  364. this.dataGrid1.Size = new System.Drawing.Size(544, 224);
  365. this.dataGrid1.TabIndex = 2;
  366. // 
  367. // groupBox1
  368. // 
  369. this.groupBox1.Controls.Add(this.txt3);
  370. this.groupBox1.Controls.Add(this.label6);
  371. this.groupBox1.Controls.Add(this.btnSearch);
  372. this.groupBox1.Controls.Add(this.txt2);
  373. this.groupBox1.Controls.Add(this.label7);
  374. this.groupBox1.Controls.Add(this.txt1);
  375. this.groupBox1.Controls.Add(this.label1);
  376. this.groupBox1.Location = new System.Drawing.Point(0, 8);
  377. this.groupBox1.Name = "groupBox1";
  378. this.groupBox1.Size = new System.Drawing.Size(544, 56);
  379. this.groupBox1.TabIndex = 31;
  380. this.groupBox1.TabStop = false;
  381. // 
  382. // txt3
  383. // 
  384. this.txt3.Location = new System.Drawing.Point(440, 24);
  385. this.txt3.Name = "txt3";
  386. this.txt3.TabIndex = 7;
  387. this.txt3.Text = "";
  388. // 
  389. // label6
  390. // 
  391. this.label6.Location = new System.Drawing.Point(392, 27);
  392. this.label6.Name = "label6";
  393. this.label6.Size = new System.Drawing.Size(48, 16);
  394. this.label6.TabIndex = 5;
  395. this.label6.Text = "计划期";
  396. // 
  397. // btnSearch
  398. // 
  399. this.btnSearch.Image = ((System.Drawing.Image)(resources.GetObject("btnSearch.Image")));
  400. this.btnSearch.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
  401. this.btnSearch.Location = new System.Drawing.Point(16, 20);
  402. this.btnSearch.Name = "btnSearch";
  403. this.btnSearch.Size = new System.Drawing.Size(72, 24);
  404. this.btnSearch.TabIndex = 3;
  405. this.btnSearch.Text = " 搜索";
  406. this.btnSearch.Click += new System.EventHandler(this.btnSearch_Click);
  407. // 
  408. // txt2
  409. // 
  410. this.txt2.Location = new System.Drawing.Point(280, 24);
  411. this.txt2.Name = "txt2";
  412. this.txt2.TabIndex = 6;
  413. this.txt2.Text = "";
  414. // 
  415. // label7
  416. // 
  417. this.label7.Location = new System.Drawing.Point(248, 28);
  418. this.label7.Name = "label7";
  419. this.label7.Size = new System.Drawing.Size(32, 16);
  420. this.label7.TabIndex = 4;
  421. this.label7.Text = "年份";
  422. // 
  423. // txt1
  424. // 
  425. this.txt1.Location = new System.Drawing.Point(160, 24);
  426. this.txt1.Name = "txt1";
  427. this.txt1.Size = new System.Drawing.Size(80, 21);
  428. this.txt1.TabIndex = 6;
  429. this.txt1.Text = "";
  430. // 
  431. // label1
  432. // 
  433. this.label1.Location = new System.Drawing.Point(109, 27);
  434. this.label1.Name = "label1";
  435. this.label1.Size = new System.Drawing.Size(56, 16);
  436. this.label1.TabIndex = 4;
  437. this.label1.Text = "物料编号";
  438. // 
  439. // MRPHistory
  440. // 
  441. this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
  442. this.ClientSize = new System.Drawing.Size(552, 421);
  443. this.Controls.Add(this.dataGrid1);
  444. this.Controls.Add(this.groupBox2);
  445. this.Controls.Add(this.groupBox1);
  446. this.Name = "MRPHistory";
  447. this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
  448. this.Text = "【MRP历史查询】";
  449. this.Load += new System.EventHandler(this.MRPHistory_Load);
  450. this.groupBox2.ResumeLayout(false);
  451. ((System.ComponentModel.ISupportInitialize)(this.dataView1)).EndInit();
  452. ((System.ComponentModel.ISupportInitialize)(this.dataSet31)).EndInit();
  453. ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
  454. this.groupBox1.ResumeLayout(false);
  455. this.ResumeLayout(false);
  457. }
  458. #endregion
  460. //-------------根据输入数据查询MRP计算记录-------------
  461. private void btnSearch_Click(object sender, System.EventArgs e)
  462. {
  463. string strFilter="";
  465. if(txt1.Text.Trim() != "")//设置表的过滤条件
  466. strFilter += "物料编号 like '%" + txt1.Text.Trim() + "%' and ";
  467. if(txt2.Text.Trim() != "")
  468. strFilter += "年份= '" + txt2.Text.Trim() + "' and ";
  469. if(txt3.Text.Trim() != "")
  470. strFilter += "计划期='" + txt3.Text.Trim() + "' and ";
  472. if(strFilter != "")    // 存在查询条件
  473. strFilter = strFilter.Substring(0,strFilter.Length-5);
  475. dataView1.RowFilter=strFilter;
  476. }
  478. //--------------窗体创建时，读入全部数据---------------
  479. private void MRPHistory_Load(object sender, System.EventArgs e)
  480. {
  481. da1.Fill(dataSet31);
  482. }
  483. }
  484. }