modelresultlist.h

这是一个工厂的生产线的仓库管理.有计划,实绩,库存等

#pragma once
#include "infClass.h"
#include "DBBase.h"

using namespace System;
using namespace System::ComponentModel;
using namespace System::Collections;
using namespace System::Windows::Forms;
using namespace System::Data;
using namespace System::Drawing;


namespace FAP
{
	/// <summary> 
	/// ModelResultList 偺奣梫
	///
	/// 寈崘 : 偙偺僋儔僗偺柤慜傪曄峏偡傞応崌丄偙偺僋儔僗偑埶懚偡傞偡傋偰偺 .resx 僼傽僀儖偵娭楢晅偗傜傟偨 
	///          儅僱乕僕 儕僜乕僗 僐儞僷僀儔 僣乕儖偵懳偟偰 'Resource File Name' 僾儘僷僥傿傪 
	///          曄峏偡傞昁梫偑偁傝傑偡丅偙偺曄峏傪峴傢側偄偲丄
	///          僨僓僀僫偲丄偙偺僼僅乕儉偵娭楢晅偗傜傟偨儘乕僇儔僀僘嵪傒儕僜乕僗偲偑丄
	///          惓偟偔憡屳偵棙梡偱偒側偔側傝傑偡丅
	/// </summary>
	public __gc class ModelResultList : public System::Windows::Forms::Form
	{
	public: 
		ModelResultList(void)
		{
			InitializeComponent();
		}
        
		ModelResultList(infClass *infClsTmp)
		{
			InitializeComponent();
			infClsRstInput = infClsTmp;
			DBBRstInput = new DBBase();
			DBBRstInExec = new DBBase();
			
			iLanguage	= infClsRstInput->intLang;
			sFactory	= infClsRstInput->strFactoryCode;
			sLine		= infClsRstInput->strLine;
			sProcess	= infClsRstInput->strProcess;
			iGroup		= infClsRstInput->intGroup;
			cShift		= infClsRstInput->strShift;

		}

	protected: 
		void Dispose(Boolean disposing)
		{
			if (disposing && components)
			{
				components->Dispose();
			}
			__super::Dispose(disposing);
		}
	private: System::Windows::Forms::ComboBox *  comboBox1;
	private: System::Windows::Forms::Label *  label1;
	private: System::Windows::Forms::Label *  label2;
	private: System::Windows::Forms::ComboBox *  comboBox2;
	private: System::Windows::Forms::Button *  button2;

	private: System::Windows::Forms::Label *  lbl_Title;
	private: System::Windows::Forms::Button *  button3;


		infClass * infClsRstInput;
		DBBase   * DBBRstInput;	//For SQL select
		DBBase   * DBBRstInExec; //For SQL Execute with transation
		String * sa_strlottmp;

		int 		iLanguage;
		String*		sFactory;
		String*		sLine;
		String*		sProcess;
		int 		iGroup;
		String*		cShift;
	public private: C1::Win::C1FlexGrid::C1FlexGrid *  GridResultList;

		String * vstrDateTime;

		bool CreateViewFAP(String * strFilename);

		String * vstrYMDHIS;

		String * pstrCsnPath;

		String __gc *saExcelRowCol[,];
		int myinteger;

	private:
		/// <summary>
		/// 昁梫側僨僓僀僫曄悢偱偡丅
		/// </summary>
		System::ComponentModel::Container* components;


		void InitGridgStyle(int);

		String * intDate();

		bool blnChkdev();

		void OutputExcel();

		DataTable * dtblGetCostms(infClass *infTmp,
											DBBase * dBTMP);

		/// <summary>
		/// 僨僓僀僫 僒億乕僩偵昁梫側儊僜僢僪偱偡丅偙偺儊僜僢僪偺撪梕傪
		/// 僐乕僪 僄僨傿僞偱曄峏偟側偄偱偔偩偝偄丅
		/// </summary>
		void InitializeComponent(void)
		{
			System::Resources::ResourceManager *  resources = new System::Resources::ResourceManager(__typeof(FAP::ModelResultList));
			this->comboBox1 = new System::Windows::Forms::ComboBox();
			this->label1 = new System::Windows::Forms::Label();
			this->label2 = new System::Windows::Forms::Label();
			this->comboBox2 = new System::Windows::Forms::ComboBox();
			this->button2 = new System::Windows::Forms::Button();
			this->lbl_Title = new System::Windows::Forms::Label();
			this->button3 = new System::Windows::Forms::Button();
			this->GridResultList = new C1::Win::C1FlexGrid::C1FlexGrid();
			(__try_cast<System::ComponentModel::ISupportInitialize *  >(this->GridResultList))->BeginInit();
			this->SuspendLayout();
			// 
			// comboBox1
			// 
			this->comboBox1->AccessibleDescription = resources->GetString(S"comboBox1.AccessibleDescription");
			this->comboBox1->AccessibleName = resources->GetString(S"comboBox1.AccessibleName");
			this->comboBox1->Anchor = (*__try_cast<__box System::Windows::Forms::AnchorStyles *  >(resources->GetObject(S"comboBox1.Anchor")));
			this->comboBox1->BackgroundImage = (__try_cast<System::Drawing::Image *  >(resources->GetObject(S"comboBox1.BackgroundImage")));
			this->comboBox1->Dock = (*__try_cast<__box System::Windows::Forms::DockStyle *  >(resources->GetObject(S"comboBox1.Dock")));
			this->comboBox1->Enabled = (*__try_cast<__box System::Boolean *  >(resources->GetObject(S"comboBox1.Enabled")));
			this->comboBox1->Font = (__try_cast<System::Drawing::Font *  >(resources->GetObject(S"comboBox1.Font")));
			this->comboBox1->ImeMode = (*__try_cast<__box System::Windows::Forms::ImeMode *  >(resources->GetObject(S"comboBox1.ImeMode")));
			this->comboBox1->IntegralHeight = (*__try_cast<__box System::Boolean *  >(resources->GetObject(S"comboBox1.IntegralHeight")));
			this->comboBox1->ItemHeight = (*__try_cast<__box System::Int32 *  >(resources->GetObject(S"comboBox1.ItemHeight")));
			this->comboBox1->Location = (*__try_cast<__box System::Drawing::Point *  >(resources->GetObject(S"comboBox1.Location")));
			this->comboBox1->MaxDropDownItems = (*__try_cast<__box System::Int32 *  >(resources->GetObject(S"comboBox1.MaxDropDownItems")));
			this->comboBox1->MaxLength = (*__try_cast<__box System::Int32 *  >(resources->GetObject(S"comboBox1.MaxLength")));
			this->comboBox1->Name = S"comboBox1";
			this->comboBox1->RightToLeft = (*__try_cast<__box System::Windows::Forms::RightToLeft *  >(resources->GetObject(S"comboBox1.RightToLeft")));
			this->comboBox1->Size = (*__try_cast<__box System::Drawing::Size *  >(resources->GetObject(S"comboBox1.Size")));
			this->comboBox1->TabIndex = (*__try_cast<__box System::Int32 *  >(resources->GetObject(S"comboBox1.TabIndex")));
			this->comboBox1->Text = resources->GetString(S"comboBox1.Text");
			this->comboBox1->Visible = (*__try_cast<__box System::Boolean *  >(resources->GetObject(S"comboBox1.Visible")));
			this->comboBox1->SelectedIndexChanged += new System::EventHandler(this, comboBox1_SelectedIndexChanged);
			// 
			// label1
			// 
			this->label1->AccessibleDescription = resources->GetString(S"label1.AccessibleDescription");
			this->label1->AccessibleName = resources->GetString(S"label1.AccessibleName");
			this->label1->Anchor = (*__try_cast<__box System::Windows::Forms::AnchorStyles *  >(resources->GetObject(S"label1.Anchor")));
			this->label1->AutoSize = (*__try_cast<__box System::Boolean *  >(resources->GetObject(S"label1.AutoSize")));
			this->label1->Dock = (*__try_cast<__box System::Windows::Forms::DockStyle *  >(resources->GetObject(S"label1.Dock")));
			this->label1->Enabled = (*__try_cast<__box System::Boolean *  >(resources->GetObject(S"label1.Enabled")));
			this->label1->Font = (__try_cast<System::Drawing::Font *  >(resources->GetObject(S"label1.Font")));
			this->label1->Image = (__try_cast<System::Drawing::Image *  >(resources->GetObject(S"label1.Image")));
			this->label1->ImageAlign = (*__try_cast<__box System::Drawing::ContentAlignment *  >(resources->GetObject(S"label1.ImageAlign")));
			this->label1->ImageIndex = (*__try_cast<__box System::Int32 *  >(resources->GetObject(S"label1.ImageIndex")));
			this->label1->ImeMode = (*__try_cast<__box System::Windows::Forms::ImeMode *  >(resources->GetObject(S"label1.ImeMode")));
			this->label1->Location = (*__try_cast<__box System::Drawing::Point *  >(resources->GetObject(S"label1.Location")));
			this->label1->Name = S"label1";
			this->label1->RightToLeft = (*__try_cast<__box System::Windows::Forms::RightToLeft *  >(resources->GetObject(S"label1.RightToLeft")));
			this->label1->Size = (*__try_cast<__box System::Drawing::Size *  >(resources->GetObject(S"label1.Size")));
			this->label1->TabIndex = (*__try_cast<__box System::Int32 *  >(resources->GetObject(S"label1.TabIndex")));
			this->label1->Text = resources->GetString(S"label1.Text");
			this->label1->TextAlign = (*__try_cast<__box System::Drawing::ContentAlignment *  >(resources->GetObject(S"label1.TextAlign")));
			this->label1->Visible = (*__try_cast<__box System::Boolean *  >(resources->GetObject(S"label1.Visible")));
			// 
			// label2
			// 
			this->label2->AccessibleDescription = resources->GetString(S"label2.AccessibleDescription");
			this->label2->AccessibleName = resources->GetString(S"label2.AccessibleName");
			this->label2->Anchor = (*__try_cast<__box System::Windows::Forms::AnchorStyles *  >(resources->GetObject(S"label2.Anchor")));
			this->label2->AutoSize = (*__try_cast<__box System::Boolean *  >(resources->GetObject(S"label2.AutoSize")));
			this->label2->Dock = (*__try_cast<__box System::Windows::Forms::DockStyle *  >(resources->GetObject(S"label2.Dock")));
			this->label2->Enabled = (*__try_cast<__box System::Boolean *  >(resources->GetObject(S"label2.Enabled")));
			this->label2->Font = (__try_cast<System::Drawing::Font *  >(resources->GetObject(S"label2.Font")));
			this->label2->Image = (__try_cast<System::Drawing::Image *  >(resources->GetObject(S"label2.Image")));
			this->label2->ImageAlign = (*__try_cast<__box System::Drawing::ContentAlignment *  >(resources->GetObject(S"label2.ImageAlign")));
			this->label2->ImageIndex = (*__try_cast<__box System::Int32 *  >(resources->GetObject(S"label2.ImageIndex")));
			this->label2->ImeMode = (*__try_cast<__box System::Windows::Forms::ImeMode *  >(resources->GetObject(S"label2.ImeMode")));
			this->label2->Location = (*__try_cast<__box System::Drawing::Point *  >(resources->GetObject(S"label2.Location")));
			this->label2->Name = S"label2";
			this->label2->RightToLeft = (*__try_cast<__box System::Windows::Forms::RightToLeft *  >(resources->GetObject(S"label2.RightToLeft")));
			this->label2->Size = (*__try_cast<__box System::Drawing::Size *  >(resources->GetObject(S"label2.Size")));
			this->label2->TabIndex = (*__try_cast<__box System::Int32 *  >(resources->GetObject(S"label2.TabIndex")));
			this->label2->Text = resources->GetString(S"label2.Text");
			this->label2->TextAlign = (*__try_cast<__box System::Drawing::ContentAlignment *  >(resources->GetObject(S"label2.TextAlign")));
			this->label2->Visible = (*__try_cast<__box System::Boolean *  >(resources->GetObject(S"label2.Visible")));
			// 
			// comboBox2
			// 
			this->comboBox2->AccessibleDescription = resources->GetString(S"comboBox2.AccessibleDescription");
			this->comboBox2->AccessibleName = resources->GetString(S"comboBox2.AccessibleName");
			this->comboBox2->Anchor = (*__try_cast<__box System::Windows::Forms::AnchorStyles *  >(resources->GetObject(S"comboBox2.Anchor")));
			this->comboBox2->BackgroundImage = (__try_cast<System::Drawing::Image *  >(resources->GetObject(S"comboBox2.BackgroundImage")));
			this->comboBox2->Dock = (*__try_cast<__box System::Windows::Forms::DockStyle *  >(resources->GetObject(S"comboBox2.Dock")));
			this->comboBox2->Enabled = (*__try_cast<__box System::Boolean *  >(resources->GetObject(S"comboBox2.Enabled")));
			this->comboBox2->Font = (__try_cast<System::Drawing::Font *  >(resources->GetObject(S"comboBox2.Font")));
			this->comboBox2->ImeMode = (*__try_cast<__box System::Windows::Forms::ImeMode *  >(resources->GetObject(S"comboBox2.ImeMode")));
			this->comboBox2->IntegralHeight = (*__try_cast<__box System::Boolean *  >(resources->GetObject(S"comboBox2.IntegralHeight")));
			this->comboBox2->ItemHeight = (*__try_cast<__box System::Int32 *  >(resources->GetObject(S"comboBox2.ItemHeight")));
			this->comboBox2->Location = (*__try_cast<__box System::Drawing::Point *  >(resources->GetObject(S"comboBox2.Location")));
			this->comboBox2->MaxDropDownItems = (*__try_cast<__box System::Int32 *  >(resources->GetObject(S"comboBox2.MaxDropDownItems")));