produceplan.h

Visual C++.net数据库开发经典案例

			this->btnImport->Location = System::Drawing::Point(176, 24);
			this->btnImport->Name = S"btnImport";
			this->btnImport->Size = System::Drawing::Size(104, 24);
			this->btnImport->TabIndex = 0;
			this->btnImport->Text = S"从需求计划导入";
			this->btnImport->Click += new System::EventHandler(this, btnImport_Click);
			// 
			// dgrdDemondPlan
			// 
			this->dgrdDemondPlan->AllowNavigation = false;
			this->dgrdDemondPlan->DataMember = S"";
			this->dgrdDemondPlan->Dock = System::Windows::Forms::DockStyle::Fill;
			this->dgrdDemondPlan->HeaderForeColor = System::Drawing::SystemColors::ControlText;
			this->dgrdDemondPlan->Location = System::Drawing::Point(304, 456);
			this->dgrdDemondPlan->Name = S"dgrdDemondPlan";
			this->dgrdDemondPlan->Size = System::Drawing::Size(504, 189);
			this->dgrdDemondPlan->TabIndex = 16;
			// 
			// ProduceDeleteSqlCmd
			// 
			this->ProduceDeleteSqlCmd->CommandText = S"DELETE FROM 主生产计划 WHERE (物料编号 = @物料编号) AND (年份 = @年份) AND (计划期 = @计划期)";
			this->ProduceDeleteSqlCmd->Connection = this->sqlConnection1;
			this->ProduceDeleteSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@物料编号", System::Data::SqlDbType::VarChar, 14, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"物料编号", System::Data::DataRowVersion::Original, 0));
			this->ProduceDeleteSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@年份", System::Data::SqlDbType::Int, 4, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"年份", System::Data::DataRowVersion::Original, 0));
			this->ProduceDeleteSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@计划期", System::Data::SqlDbType::Int, 4, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"计划期", System::Data::DataRowVersion::Original, 0));
			// 
			// ProduceInsertSqlCmd
			// 
			this->ProduceInsertSqlCmd->CommandText = S"INSERT INTO 主生产计划 (物料编号, 年份, 开始日期, 计划期, 结束日期, 期初库存, 需求数量, 生产单数量, MPS数量, 预计库存, 状态," 
				S" 备注) VALUES (@物料编号, @年份, @开始日期, @计划期, @结束日期, @期初库存, @需求数量, @生产单数量, @MPS数量, @预计库存" 
				S", @状态, @备注)";
			this->ProduceInsertSqlCmd->Connection = this->sqlConnection1;
			this->ProduceInsertSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@物料编号", System::Data::SqlDbType::VarChar, 14, S"物料编号"));
			this->ProduceInsertSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@年份", System::Data::SqlDbType::Int, 4, S"年份"));
			this->ProduceInsertSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@开始日期", System::Data::SqlDbType::Int, 4, S"开始日期"));
			this->ProduceInsertSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@计划期", System::Data::SqlDbType::Int, 4, S"计划期"));
			this->ProduceInsertSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@结束日期", System::Data::SqlDbType::Int, 4, S"结束日期"));
			this->ProduceInsertSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@期初库存", System::Data::SqlDbType::Decimal, 9, System::Data::ParameterDirection::Input, false, (System::Byte)15, (System::Byte)2, S"期初库存", System::Data::DataRowVersion::Current, 0));
			this->ProduceInsertSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@需求数量", System::Data::SqlDbType::Decimal, 9, System::Data::ParameterDirection::Input, false, (System::Byte)15, (System::Byte)2, S"需求数量", System::Data::DataRowVersion::Current, 0));
			this->ProduceInsertSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@生产单数量", System::Data::SqlDbType::Decimal, 9, System::Data::ParameterDirection::Input, false, (System::Byte)15, (System::Byte)2, S"生产单数量", System::Data::DataRowVersion::Current, 0));
			this->ProduceInsertSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@MPS数量", System::Data::SqlDbType::Decimal, 9, System::Data::ParameterDirection::Input, false, (System::Byte)15, (System::Byte)2, S"MPS数量", System::Data::DataRowVersion::Current, 0));
			this->ProduceInsertSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@预计库存", System::Data::SqlDbType::Decimal, 9, System::Data::ParameterDirection::Input, false, (System::Byte)15, (System::Byte)2, S"预计库存", System::Data::DataRowVersion::Current, 0));
			this->ProduceInsertSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@状态", System::Data::SqlDbType::VarChar, 10, S"状态"));
			this->ProduceInsertSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@备注", System::Data::SqlDbType::VarChar, 40, S"备注"));
			// 
			// sqlConnection1
			// 
			this->sqlConnection1->ConnectionString = S"workstation id=\"SKS-DD7828BA353\";packet size=4096;integrated security=SSPI;initia" 
				S"l catalog=mrpbook;persist security info=False";
			this->sqlConnection1->InfoMessage += new System::Data::SqlClient::SqlInfoMessageEventHandler(this, sqlConnection1_InfoMessage);
			// 
			// ProduceSelectSqlCmd
			// 
			this->ProduceSelectSqlCmd->Connection = this->sqlConnection1;
			// 
			// ProduceUpdateSqlCmd
			// 
			this->ProduceUpdateSqlCmd->CommandText = S"UPDATE 主生产计划 SET 物料编号 = @物料编号, 年份 = @年份, 开始日期 = @开始日期, 计划期 = @计划期, 结束日期 = @结束日期, " 
				S"期初库存 = @期初库存, 需求数量 = @需求数量, 生产单数量 = @生产单数量, MPS数量 = @MPS数量, 预计库存 = @预计库存, 状态 = @" 
				S"状态, 备注 = @备注";
			this->ProduceUpdateSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@物料编号", System::Data::SqlDbType::VarChar, 14, S"物料编号"));
			this->ProduceUpdateSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@年份", System::Data::SqlDbType::Int, 4, S"年份"));
			this->ProduceUpdateSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@开始日期", System::Data::SqlDbType::Int, 4, S"开始日期"));
			this->ProduceUpdateSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@计划期", System::Data::SqlDbType::Int, 4, S"计划期"));
			this->ProduceUpdateSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@结束日期", System::Data::SqlDbType::Int, 4, S"结束日期"));
			this->ProduceUpdateSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@期初库存", System::Data::SqlDbType::Decimal, 9, System::Data::ParameterDirection::Input, false, (System::Byte)15, (System::Byte)2, S"期初库存", System::Data::DataRowVersion::Current, 0));
			this->ProduceUpdateSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@需求数量", System::Data::SqlDbType::Decimal, 9, System::Data::ParameterDirection::Input, false, (System::Byte)15, (System::Byte)2, S"需求数量", System::Data::DataRowVersion::Current, 0));
			this->ProduceUpdateSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@生产单数量", System::Data::SqlDbType::Decimal, 9, System::Data::ParameterDirection::Input, false, (System::Byte)15, (System::Byte)2, S"生产单数量", System::Data::DataRowVersion::Current, 0));
			this->ProduceUpdateSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@MPS数量", System::Data::SqlDbType::Decimal, 9, System::Data::ParameterDirection::Input, false, (System::Byte)15, (System::Byte)2, S"MPS数量", System::Data::DataRowVersion::Current, 0));
			this->ProduceUpdateSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@预计库存", System::Data::SqlDbType::Decimal, 9, System::Data::ParameterDirection::Input, false, (System::Byte)15, (System::Byte)2, S"预计库存", System::Data::DataRowVersion::Current, 0));
			this->ProduceUpdateSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@状态", System::Data::SqlDbType::VarChar, 10, S"状态"));
			this->ProduceUpdateSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@备注", System::Data::SqlDbType::VarChar, 40, S"备注"));
			// 
			// DemandDeleteSqlCmd
			// 
			this->DemandDeleteSqlCmd->CommandText = S"DELETE FROM 主需求计划 WHERE (年份 = @Original_年份) AND (物料编号 = @Original_物料编号) AND (计划期 " 
				S"= @Original_计划期) AND (修改日期 = @Original_修改日期 OR @Original_修改日期 IS NULL AND 修改日期 I" 
				S"S NULL) AND (备注 = @Original_备注 OR @Original_备注 IS NULL AND 备注 IS NULL) AND (开始日期" 
				S" = @Original_开始日期 OR @Original_开始日期 IS NULL AND 开始日期 IS NULL) AND (状态 = @Origina" 
				S"l_状态) AND (结束日期 = @Original_结束日期 OR @Original_结束日期 IS NULL AND 结束日期 IS NULL) AND" 
				S" (编号 = @Original_编号 OR @Original_编号 IS NULL AND 编号 IS NULL) AND (记帐人 = @Original" 
				S"_记帐人 OR @Original_记帐人 IS NULL AND 记帐人 IS NULL) AND (需求数量 = @Original_需求数量)";
			this->DemandDeleteSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@Original_年份", System::Data::SqlDbType::Int, 4, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"年份", System::Data::DataRowVersion::Original, 0));
			this->DemandDeleteSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@Original_物料编号", System::Data::SqlDbType::VarChar, 14, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"物料编号", System::Data::DataRowVersion::Original, 0));
			this->DemandDeleteSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@Original_计划期", System::Data::SqlDbType::Int, 4, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"计划期", System::Data::DataRowVersion::Original, 0));
			this->DemandDeleteSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@Original_修改日期", System::Data::SqlDbType::Int, 4, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"修改日期", System::Data::DataRowVersion::Original, 0));
			this->DemandDeleteSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@Original_备注", System::Data::SqlDbType::VarChar, 40, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"备注", System::Data::DataRowVersion::Original, 0));
			this->DemandDeleteSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@Original_开始日期", System::Data::SqlDbType::Int, 4, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"开始日期", System::Data::DataRowVersion::Original, 0));
			this->DemandDeleteSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@Original_状态", System::Data::SqlDbType::VarChar, 10, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"状态", System::Data::DataRowVersion::Original, 0));
			this->DemandDeleteSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@Original_结束日期", System::Data::SqlDbType::Int, 4, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"结束日期", System::Data::DataRowVersion::Original, 0));
			this->DemandDeleteSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@Original_编号", System::Data::SqlDbType::VarChar, 14, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"编号", System::Data::DataRowVersion::Original, 0));
			this->DemandDeleteSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@Original_记帐人", System::Data::SqlDbType::VarChar, 10, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"记帐人", System::Data::DataRowVersion::Original, 0));
			this->DemandDeleteSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@Original_需求数量", System::Data::SqlDbType::Decimal, 9, System::Data::ParameterDirection::Input, false, (System::Byte)15, (System::Byte)2, S"需求数量", System::Data::DataRowVersion::Original, 0));
			// 
			// DemandInsertSqlCmd
			// 
			this->DemandInsertSqlCmd->CommandText = S"INSERT INTO 主需求计划(编号, 物料编号, 年份, 计划期, 开始日期, 结束日期, 需求数量, 记帐人, 修改日期, 状态, 备注) VALUES " 
				S"(@编号, @物料编号, @年份, @计划期, @开始日期, @结束日期, @需求数量, @记帐人, @修改日期, @状态, @备注); SELECT 编号, " 
				S"物料编号, 年份, 计划期, 开始日期, 结束日期, 需求数量, 记帐人, 修改日期, 状态, 备注 FROM 主需求计划 WHERE (年份 = @年份) A" 
				S"ND (物料编号 = @物料编号) AND (计划期 = @计划期)";
			this->DemandInsertSqlCmd->Connection = this->sqlConnection1;
			this->DemandInsertSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@编号", System::Data::SqlDbType::VarChar, 14, S"编号"));
			this->DemandInsertSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@物料编号", System::Data::SqlDbType::VarChar, 14, S"物料编号"));
			this->DemandInsertSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@年份", System::Data::SqlDbType::Int, 4, S"年份"));
			this->DemandInsertSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@计划期", System::Data::SqlDbType::Int, 4, S"计划期"));
			this->DemandInsertSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@开始日期", System::Data::SqlDbType::Int, 4, S"开始日期"));
			this->DemandInsertSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@结束日期", System::Data::SqlDbType::Int, 4, S"结束日期"));
			this->DemandInsertSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@需求数量", System::Data::SqlDbType::Decimal, 9, System::Data::ParameterDirection::Input, false, (System::Byte)15, (System::Byte)2, S"需求数量", System::Data::DataRowVersion::Current, 0));
			this->DemandInsertSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@记帐人", System::Data::SqlDbType::VarChar, 10, S"记帐人"));
			this->DemandInsertSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@修改日期", System::Data::SqlDbType::Int, 4, S"修改日期"));
			this->DemandInsertSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@状态", System::Data::SqlDbType::VarChar, 10, S"状态"));
			this->DemandInsertSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@备注", System::Data::SqlDbType::VarChar, 40, S"备注"));
			// 
			// DemandSelectSqlCmd
			// 
			this->DemandSelectSqlCmd->CommandText = S"SELECT 编号, 物料编号, 年份, 计划期, 开始日期, 结束日期, 需求数量, 记帐人, 修改日期, 状态, 备注 FROM 主需求计划";
			// 
			// DemandUpdateSqlCmd
			// 
			this->DemandUpdateSqlCmd->CommandText = S"UPDATE 主需求计划 SET 编号 = @编号, 物料编号 = @物料编号, 年份 = @年份, 计划期 = @计划期, 开始日期 = @开始日期, 结束日期" 
				S" = @结束日期, 需求数量 = @需求数量, 记帐人 = @记帐人, 修改日期 = @修改日期, 状态 = @状态, 备注 = @备注 WHERE (年份 =" 
				S" @Original_年份) AND (物料编号 = @Original_物料编号) AND (计划期 = @Original_计划期) AND (修改日期 =" 
				S" @Original_修改日期 OR @Original_修改日期 IS NULL AND 修改日期 IS NULL) AND (备注 = @Original_" 
				S"备注 OR @Original_备注 IS NULL AND 备注 IS NULL) AND (开始日期 = @Original_开始日期 OR @Origin" 
				S"al_开始日期 IS NULL AND 开始日期 IS NULL) AND (状态 = @Original_状态) AND (结束日期 = @Original_" 
				S"结束日期 OR @Original_结束日期 IS NULL AND 结束日期 IS NULL) AND (编号 = @Original_编号 OR @Orig" 
				S"inal_编号 IS NULL AND 编号 IS NULL) AND (记帐人 = @Original_记帐人 OR @Original_记帐人 IS NUL" 
				S"L AND 记帐人 IS NULL) AND (需求数量 = @Original_需求数量); SELECT 编号, 物料编号, 年份, 计划期, 开始日期, " 
				S"结束日期, 需求数量, 记帐人, 修改日期, 状态, 备注 FROM 主需求计划 WHERE (年份 = @年份) AND (物料编号 = @物料编号) AND" 
				S" (计划期 = @计划期)";
			this->DemandUpdateSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@编号", System::Data::SqlDbType::VarChar, 14, S"编号"));
			this->DemandUpdateSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@物料编号", System::Data::SqlDbType::VarChar, 14, S"物料编号"));
			this->DemandUpdateSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@年份", System::Data::SqlDbType::Int, 4, S"年份"));
			this->DemandUpdateSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@计划期", System::Data::SqlDbType::Int, 4, S"计划期"));
			this->DemandUpdateSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@开始日期", System::Data::SqlDbType::Int, 4, S"开始日期"));
			this->DemandUpdateSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@结束日期", System::Data::SqlDbType::Int, 4, S"结束日期"));
			this->DemandUpdateSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@需求数量", System::Data::SqlDbType::Decimal, 9, System::Data::ParameterDirection::Input, false, (System::Byte)15, (System::Byte)2, S"需求数量", System::Data::DataRowVersion::Current, 0));
			this->DemandUpdateSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@记帐人", System::Data::SqlDbType::VarChar, 10, S"记帐人"));
			this->DemandUpdateSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@修改日期", System::Data::SqlDbType::Int, 4, S"修改日期"));
			this->DemandUpdateSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@状态", System::Data::SqlDbType::VarChar, 10, S"状态"));
			this->DemandUpdateSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@备注", System::Data::SqlDbType::VarChar, 40, S"备注"));
			this->DemandUpdateSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@Original_年份", System::Data::SqlDbType::Int, 4, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"年份", System::Data::DataRowVersion::Original, 0));
			this->DemandUpdateSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@Original_物料编号", System::Data::SqlDbType::VarChar, 14, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"物料编号", System::Data::DataRowVersion::Original, 0));
			this->DemandUpdateSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@Original_计划期", System::Data::SqlDbType::Int, 4, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"计划期", System::Data::DataRowVersion::Original, 0));
			this->DemandUpdateSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@Original_修改日期", System::Data::SqlDbType::Int, 4, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"修改日期", System::Data::DataRowVersion::Original, 0));
			this->DemandUpdateSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@Original_备注", System::Data::SqlDbType::VarChar, 40, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"备注", System::Data::DataRowVersion::Original, 0));
			this->DemandUpdateSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@Original_开始日期", System::Data::SqlDbType::Int, 4, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"开始日期", System::Data::DataRowVersion::Original, 0));
			this->DemandUpdateSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@Original_状态", System::Data::SqlDbType::VarChar, 10, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"状态", System::Data::DataRowVersion::Original, 0));
			this->DemandUpdateSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@Original_结束日期", System::Data::SqlDbType::Int, 4, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"结束日期", System::Data::DataRowVersion::Original, 0));
			this->DemandUpdateSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@Original_编号", System::Data::SqlDbType::VarChar, 14, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"编号", System::Data::DataRowVersion::Original, 0));
			this->DemandUpdateSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@Original_记帐人", System::Data::SqlDbType::VarChar, 10, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"记帐人", System::Data::DataRowVersion::Original, 0));
			this->DemandUpdateSqlCmd->Parameters->Add(new System::Data::SqlClient::SqlParameter(S"@Original_需求数量", System::Data::SqlDbType::Decimal, 9, System::Data::ParameterDirection::Input, false, (System::Byte)15, (System::Byte)2, S"需求数量", System::Data::DataRowVersion::Original, 0));
			// 
			// ProducePlan
			// 
			this->AutoScaleBaseSize = System::Drawing::Size(6, 14);
			this->ClientSize = System::Drawing::Size(808, 645);
			this->Controls->Add(this->dgrdDemondPlan);
			this->Controls->Add(this->groupBox3);
			this->Controls->Add(this->groupBox1);
			this->Controls->Add(this->dgrdProducePlan);
			this->Controls->Add(this->groupBox2);
			this->Controls->Add(this->toolBar1);
			this->Name = S"ProducePlan";
			this->Text = S"主生产计划";
			this->Load += new System::EventHandler(this, ProducePlan_Load);
			this->groupBox1->ResumeLayout(false);
			this->groupBox2->ResumeLayout(false);
			(__try_cast<System::ComponentModel::ISupportInitialize *  >(this->dgrdProducePlan))->EndInit();
			this->groupBox3->ResumeLayout(false);
			(__try_cast<System::ComponentModel::ISupportInitialize *  >(this->dgrdDemondPlan))->EndInit();
			this->ResumeLayout(false);

		}		
private: System::Void ProducePlan_Load(System::Object *  sender, System::EventArgs *  e)
		{
			this->cmProduce = __try_cast<CurrencyManager*>(this->BindingContext->Item[this->ds->Tables->Item[S"主生产计划表"]]);
			this->DataBidings();
			this->dgrdProducePlan->DataSource = this->ds->Tables->Item[S"主生产计划表"];
			this->DataGridStateProduce();
			this->dgrdDemondPlan->DataSource = this->ds->Tables->Item[S"主需求计划表"];
			this->DataGridStateDemond();

			this->SetModify(false);
		}
		//------------------设置主生产计划表格样式----------------------
		void DataGridStateProduce()
		{
			DataGridTableStyle* ts = new DataGridTableStyle();
			DataGridNoActiveCellColumn* aTextColumn;
			ts->AlternatingBackColor = Color::LightGray;
			ts->MappingName = this->ds->Tables->Item[S"主生产计划表"]->TableName;

			int numCols = this->ds->Tables->Item[S"主生产计划表"]->Columns->Count;
			for(int i = 0;i < numCols;i++)
			{
				aTextColumn = new DataGridNoActiveCellColumn();
				aTextColumn->get_TextBox()->Enabled = false;
				aTextColumn->MappingName = this->ds->Tables->Item[S"主生产计划表"]->Columns->Item[i]->ColumnName;
				aTextColumn->HeaderText = this->ds->Tables->Item[S"主生产计划表"]->Columns->Item[i]->ColumnName;
				aTextColumn->NullText = S"";
				aTextColumn->Format = S"F";
				ts->GridColumnStyles->Add(aTextColumn);
			}
			this->dgrdProducePlan->TableStyles->Add(ts);			
		}
		//------------------设置主需求计划表格样式----------------------
		void DataGridStateDemond()
		{
			DataGridTableStyle* ts = new DataGridTableStyle();
			DataGridNoActiveCellColumn* aTextColumn;
			ts->AlternatingBackColor = Color::LightGray;
			ts->MappingName = this->ds->Tables->Item[S"主需求计划表"]->TableName;

			int numCols = this->ds->Tables->Item[S"主需求计划表"]->Columns->Count;
			for(int i = 0;i < numCols;i++)
			{
				aTextColumn = new DataGridNoActiveCellColumn();
				aTextColumn->get_TextBox()->Enabled = false;
				aTextColumn->MappingName = this->ds->Tables->Item[S"主需求计划表"]->Columns->Item[i]->ColumnName;
				aTextColumn->HeaderText = this->ds->Tables->Item[S"主需求计划表"]->Columns->Item[i]->ColumnName;
				aTextColumn->NullText = S"";
				ts->GridColumnStyles->Add(aTextColumn);
			}
			this->dgrdDemondPlan->TableStyles->Add(ts);			
		}
		//------------------设置数据绑定----------------------
        void DataBidings()
		{
			this->tBoxMaterialIDShow->DataBindings->Add("Text",this->ds->Tables->Item[S"主生产计划表"],"物料编号");
			this->tBoxMaterialName->DataBindings->Add("Text",this->ds->Tables->Item[S"主生产计划表"],"物料名称");
			this->tBoxYearShow->DataBindings->Add("Text",this->ds->Tables->Item[S"主生产计划表"],"年份");
			this->tBoxPlanDateShow->DataBindings->Add("Text",this->ds->Tables->Item[S"主生产计划表"],S"计划期");