📄 mrphistory.cs
字号:
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
namespace 生产管理系统
{
/// <summary>
/// MRPHistory 的摘要说明。
/// </summary>
public class MRPHistory : System.Windows.Forms.Form
{
private System.Windows.Forms.GroupBox groupBox2;
private System.Windows.Forms.DataGrid dataGrid1;
private System.Windows.Forms.GroupBox groupBox1;
private System.Windows.Forms.Label label6;
private System.Windows.Forms.Button btnSearch;
private System.Windows.Forms.Label label7;
private System.Windows.Forms.Label label1;
private System.Windows.Forms.TextBox txt1;
private System.Windows.Forms.TextBox txt3;
private System.Windows.Forms.TextBox txt2;
private System.Data.SqlClient.SqlDataAdapter da1;
private System.Data.SqlClient.SqlCommand sqlSelectCommand1;
private System.Data.SqlClient.SqlConnection sqlConnection1;
private 生产管理系统.DataSet3 dataSet31;
private System.Data.DataView dataView1;
private System.Windows.Forms.TextBox textBox1;
private System.Windows.Forms.TextBox textBox2;
private System.Windows.Forms.TextBox txt5;
private System.Windows.Forms.TextBox txt4;
private System.Windows.Forms.TextBox textBox3;
private System.Windows.Forms.TextBox txt6;
private System.Windows.Forms.Label label2;
private System.Windows.Forms.Label label3;
private System.Windows.Forms.Label label4;
private System.Windows.Forms.Label label5;
private System.Windows.Forms.Label label8;
private System.Windows.Forms.Label label9;
private System.Windows.Forms.TextBox textBox4;
private System.Windows.Forms.TextBox textBox5;
private System.Windows.Forms.TextBox textBox6;
private System.Windows.Forms.Label label10;
private System.Windows.Forms.Label label11;
private System.Windows.Forms.Label label12;
/// <summary>
/// 必需的设计器变量。
/// </summary>
private System.ComponentModel.Container components = null;
public MRPHistory()
{
//
// Windows 窗体设计器支持所必需的
//
InitializeComponent();
//
// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
//
}
/// <summary>
/// 清理所有正在使用的资源。
/// </summary>
protected override void Dispose( bool disposing )
{
if( disposing )
{
if(components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}
#region Windows 窗体设计器生成的代码
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(MRPHistory));
this.da1 = new System.Data.SqlClient.SqlDataAdapter();
this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlConnection1 = new System.Data.SqlClient.SqlConnection();
this.groupBox2 = new System.Windows.Forms.GroupBox();
this.textBox1 = new System.Windows.Forms.TextBox();
this.dataView1 = new System.Data.DataView();
this.dataSet31 = new 生产管理系统.DataSet3();
this.textBox2 = new System.Windows.Forms.TextBox();
this.txt5 = new System.Windows.Forms.TextBox();
this.txt4 = new System.Windows.Forms.TextBox();
this.textBox3 = new System.Windows.Forms.TextBox();
this.txt6 = new System.Windows.Forms.TextBox();
this.label2 = new System.Windows.Forms.Label();
this.label3 = new System.Windows.Forms.Label();
this.label4 = new System.Windows.Forms.Label();
this.label5 = new System.Windows.Forms.Label();
this.label8 = new System.Windows.Forms.Label();
this.label9 = new System.Windows.Forms.Label();
this.textBox4 = new System.Windows.Forms.TextBox();
this.textBox5 = new System.Windows.Forms.TextBox();
this.textBox6 = new System.Windows.Forms.TextBox();
this.label10 = new System.Windows.Forms.Label();
this.label11 = new System.Windows.Forms.Label();
this.label12 = new System.Windows.Forms.Label();
this.dataGrid1 = new System.Windows.Forms.DataGrid();
this.groupBox1 = new System.Windows.Forms.GroupBox();
this.txt3 = new System.Windows.Forms.TextBox();
this.label6 = new System.Windows.Forms.Label();
this.btnSearch = new System.Windows.Forms.Button();
this.txt2 = new System.Windows.Forms.TextBox();
this.label7 = new System.Windows.Forms.Label();
this.txt1 = new System.Windows.Forms.TextBox();
this.label1 = new System.Windows.Forms.Label();
this.groupBox2.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dataView1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dataSet31)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
this.groupBox1.SuspendLayout();
this.SuspendLayout();
//
// da1
//
this.da1.SelectCommand = this.sqlSelectCommand1;
this.da1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "mrp物料需求历史", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("物料名称", "物料名称"),
new System.Data.Common.DataColumnMapping("发布编号", "发布编号"),
new System.Data.Common.DataColumnMapping("发布时间", "发布时间"),
new System.Data.Common.DataColumnMapping("物料编号", "物料编号"),
new System.Data.Common.DataColumnMapping("年份", "年份"),
new System.Data.Common.DataColumnMapping("计划期", "计划期"),
new System.Data.Common.DataColumnMapping("期初库存", "期初库存"),
new System.Data.Common.DataColumnMapping("毛需求", "毛需求"),
new System.Data.Common.DataColumnMapping("预计入库", "预计入库"),
new System.Data.Common.DataColumnMapping("预计出库", "预计出库"),
new System.Data.Common.DataColumnMapping("预计库存", "预计库存"),
new System.Data.Common.DataColumnMapping("净需求", "净需求"),
new System.Data.Common.DataColumnMapping("计划产出", "计划产出"),
new System.Data.Common.DataColumnMapping("计划投入", "计划投入")})});
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT b.物料名称, a.发布编号, a.发布时间, a.物料编号, a.年份, a.计划期, a.期初库存, a.毛需求, a.预计入库, a.预计出库" +
", a.预计库存, a.净需求, a.计划产出, a.计划投入 FROM mrp物料需求历史 a INNER JOIN 物料主文件 b ON a.物料编号 = " +
"b.物料编号";
this.sqlSelectCommand1.Connection = this.sqlConnection1;
//
// sqlConnection1
//
this.sqlConnection1.ConnectionString = "workstation id=localhost;packet size=4096;user id=sa;data source=NICOLAS;persist security info=False;initial catalog=mrpbook;";
//
// groupBox2
//
this.groupBox2.Controls.Add(this.textBox1);
this.groupBox2.Controls.Add(this.textBox2);
this.groupBox2.Controls.Add(this.txt5);
this.groupBox2.Controls.Add(this.txt4);
this.groupBox2.Controls.Add(this.textBox3);
this.groupBox2.Controls.Add(this.txt6);
this.groupBox2.Controls.Add(this.label2);
this.groupBox2.Controls.Add(this.label3);
this.groupBox2.Controls.Add(this.label4);
this.groupBox2.Controls.Add(this.label5);
this.groupBox2.Controls.Add(this.label8);
this.groupBox2.Controls.Add(this.label9);
this.groupBox2.Controls.Add(this.textBox4);
this.groupBox2.Controls.Add(this.textBox5);
this.groupBox2.Controls.Add(this.textBox6);
this.groupBox2.Controls.Add(this.label10);
this.groupBox2.Controls.Add(this.label11);
this.groupBox2.Controls.Add(this.label12);
this.groupBox2.Location = new System.Drawing.Point(0, 64);
this.groupBox2.Name = "groupBox2";
this.groupBox2.Size = new System.Drawing.Size(544, 120);
this.groupBox2.TabIndex = 1;
this.groupBox2.TabStop = false;
//
// textBox1
//
this.textBox1.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataView1, "年份"));
this.textBox1.Enabled = false;
this.textBox1.Location = new System.Drawing.Point(72, 56);
this.textBox1.Name = "textBox1";
this.textBox1.ReadOnly = true;
this.textBox1.TabIndex = 72;
this.textBox1.Text = "";
//
// dataView1
//
this.dataView1.Table = this.dataSet31.mrp物料需求历史;
//
// dataSet31
//
this.dataSet31.DataSetName = "DataSet3";
this.dataSet31.Locale = new System.Globalization.CultureInfo("zh-CN");
//
// textBox2
//
this.textBox2.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataView1, "物料编号"));
this.textBox2.Enabled = false;
this.textBox2.Location = new System.Drawing.Point(72, 26);
this.textBox2.Name = "textBox2";
this.textBox2.ReadOnly = true;
this.textBox2.TabIndex = 71;
this.textBox2.Text = "";
//
// txt5
//
this.txt5.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataView1, "计划期"));
this.txt5.Enabled = false;
this.txt5.Location = new System.Drawing.Point(256, 56);
this.txt5.Name = "txt5";
this.txt5.ReadOnly = true;
this.txt5.TabIndex = 74;
this.txt5.Text = "";
//
// txt4
//
this.txt4.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataView1, "物料名称"));
this.txt4.Enabled = false;
this.txt4.Location = new System.Drawing.Point(256, 26);
this.txt4.Name = "txt4";
this.txt4.ReadOnly = true;
this.txt4.TabIndex = 70;
this.txt4.Text = "";
//
// textBox3
//
this.textBox3.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataView1, "期初库存"));
this.textBox3.Enabled = false;
this.textBox3.Location = new System.Drawing.Point(72, 88);
this.textBox3.Name = "textBox3";
this.textBox3.ReadOnly = true;
this.textBox3.TabIndex = 69;
this.textBox3.Text = "";
//
// txt6
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -