productplancheck.cpp

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

#include "StdAfx.h"
#include "ProductPlanCheck.h"

using namespace FAP;
using namespace System;
using namespace System::Globalization;


void ProductPlanCheck::InitProductPlanCheck()
{
	//Show Last Update
	GetLastUpdate();

	//Init ComboBox
	comboLine->SelectedIndex = 0;
	SetValueComboSection();
	comboSection->SelectedIndex = 0;

	//Init Grid
	InitGridPlan();
	//InitGridDetail();
}

void ProductPlanCheck::SetValueComboSection()
{
	String *sSQL;
	sSQL = S"";
	String* saLang[]   = {S"C", S"J", S"E"};
	String* saLine[]   = {S"'L001','L002'", S"'L001'", S"'L002'"};

	oDSet = new DataSet();
	sSQL = String::Concat(sSQL,	S"select"														);
	sSQL = String::Concat(sSQL,	S"	PROCESS_NO,"												);
	sSQL = String::Concat(sSQL,	S"	PROCESS_NO || ' ' || NAME_", saLang[iLanguage] ,S" as NAME ");
	sSQL = String::Concat(sSQL,	S"from"															);
	sSQL = String::Concat(sSQL,	S"	COST_MST "													);
	sSQL = String::Concat(sSQL,	S"where"														);
	sSQL = String::Concat(sSQL,	S"	LINE_CODE in (", saLine[comboLine->SelectedIndex], S") and"	);
	sSQL = String::Concat(sSQL,	S"	PROCESS_NO is not null"										);
	
	//Insert By KasenHOo @ 2005/12/02
	sSQL = String::Concat(sSQL, S" and sap_store_no like '9%'" );
	//End By KasenHOo @ 2005/12/02
	


	oDSet = oDB->dSetSQL_Select(sSQL, S"COST_MST", 0);
	comboSection->DataSource    = oDSet->Tables->Item[S"COST_MST"];
	comboSection->DisplayMember = S"NAME";
	comboSection->ValueMember   = S"PROCESS_NO";
}

void ProductPlanCheck::InitGridPlan(void)
{
	DataGridTextBoxColumn *oYMD;
	DataGridTextBoxColumn *oProductCode;
	DataGridTextBoxColumn *oProductName;
	DataGridTextBoxColumn *oLot;
	DataGridTextBoxColumn *oLine;
	DataGridTextBoxColumn *oQty;

	////////////////////////////////////////////////////////

	DataGridTextBoxColumn *oNameA;
	DataGridTextBoxColumn *oQTY_A;
	DataGridTextBoxColumn *oNameB;
	DataGridTextBoxColumn *oQTY_B;

	/////////////////////////////////////////////////////////

	//Insert By KasenHOo @ 2005/12/09
	//YMD
	oYMD                = new DataGridTextBoxColumn();;
	oYMD->MappingName	= S"YMD";
	String * strSpaces;
	if (iLanguage==0){strSpaces=S"     ";}
	if (iLanguage==1){strSpaces=S"      ";}
	if (iLanguage==2){strSpaces=S"     ";}


	oYMD->HeaderText	= String::Concat(strSpaces,oInf->saG_DateLetter[iLanguage]);
	oYMD->Alignment		= HorizontalAlignment::Left;
	oYMD->Width			= 100;
	oYMD->NullText		= S"";
	oYMD->Format		= S"yyyy-MM-dd";
	//End By KasenHOo @ 2005/12/09

	

	oDataSetPlan				= new DataSet();
	oTableStylePlan				= new DataGridTableStyle();
	oTableStylePlan->MappingName	= S"GridDataPlan";



	//ProductCode
	oProductCode				= new DataGridTextBoxColumn();
	oProductCode->MappingName	= S"PRODUCT_CODE";
	oProductCode->HeaderText	= String::Concat(strSpaces,oInf->saG_Code[iLanguage]);
	oProductCode->Alignment		= HorizontalAlignment::Left;
	oProductCode->Width			= 100;
	
	//add by kasenhoo@051105
	oProductCode->NullText		= S"";
	//end kasenhoo

	//ProductName
	oProductName				= new DataGridTextBoxColumn();
	oProductName->MappingName	= S"PRODUCT_NAME";
	oProductName->HeaderText	= S"";//oInf->saG_Name[iLanguage];
	oProductName->Alignment		= HorizontalAlignment::Center;
	oProductName->Width			= 0;//150;
		
	//ADD by kasenhoo @ 051108
	oProductName->NullText		= S"";
	//end kasenhoo

	//Lot
	oLot						= new DataGridTextBoxColumn();
	oLot->MappingName			= S"LOT";
	oLot->HeaderText			= String::Concat(S"     ",oInf->saG_Lot[iLanguage]);
	oLot->Alignment				= HorizontalAlignment::Left;
	oLot->Width					= 80;

	//add by kasenhoo@051105
	oLot->NullText		= S"";
	//end kasenhoo

	//Line
	oLine						= new DataGridTextBoxColumn();
	oLine->MappingName			= S"LINE_NAME";
	oLine->HeaderText			= S"";//oInf->saG_LineName[iLanguage];
	oLine->Alignment			= HorizontalAlignment::Center;
	oLine->Width				= 0;//50;

	//add by kasenhoo@051105
	oLine->NullText		= S"";
	//end kasenhoo

	//Product Qty
	oQty						= new DataGridTextBoxColumn();
	oQty->MappingName			= S"PRODUCT_QTY";
	oQty->HeaderText			= String::Concat(oInf->saG_ProdQTY[iLanguage],S"   \0");
	oQty->Alignment				= HorizontalAlignment::Right;
	oQty->Width					= 100;

	//add by kasenhoo@051105
	oQty->NullText		= S"";
	oQty->Format		= S"#,###";
	//end kasenhoo

	/////////////////////////////////////////////////////////////////////
	//NameB
	oNameB						= new DataGridTextBoxColumn();
	oNameB->MappingName			= S"NAME_B";
	//oNameB->HeaderText			= S"Shift B";
	oNameB->HeaderText			= S"";
	oNameB->Alignment			= HorizontalAlignment::Center;
	oNameB->Width				= 0;

	//add by kasenhoo@051105
	oNameB->NullText		= S"";
	//end kasenhoo

	//QTY_B
	oQTY_B						= new DataGridTextBoxColumn();
	oQTY_B->MappingName			= S"QTY_B";
	//oQTY_B->HeaderText			= S"QTY";
	oQTY_B->HeaderText			= S"";
	oQTY_B->Alignment			= HorizontalAlignment::Center;
	oQTY_B->Width				= 0;

	//add by kasenhoo@051105
	oQTY_B->NullText		= S"";
	//end kasenhoo

	String * shiftAB[]={S"勤务",S"シフト",S"Shift"};

	//NameA
	oNameA						= new DataGridTextBoxColumn();
	oNameA->MappingName			= S"NAME_A";
	oNameA->HeaderText			= shiftAB[iLanguage];//S"Shift A/B";
	oNameA->Alignment			= HorizontalAlignment::Center;
	oNameA->Width				= 50;

	//add by kasenhoo@051105
	oNameA->NullText		= S"";
	//end kasenhoo

	String * workerBanci[]={S"班",S"班",S"Team"};

	//QTY_A
	oQTY_A						= new DataGridTextBoxColumn();
	oQTY_A->MappingName			= S"QTY_A";
	oQTY_A->HeaderText			= workerBanci[iLanguage];//oInf->saPROShift[iLanguage];/*S"QTY";*/
	oQTY_A->Alignment			= HorizontalAlignment::Center;
	oQTY_A->Width				= 60;

	//add by kasenhoo@051105
	oQTY_A->NullText		= S"";
	//end kasenhoo
	//////////////////////////////////////////////////////////////////////
	
	oTableStylePlan->GridColumnStyles->Add(oYMD);
	oTableStylePlan->GridColumnStyles->Add(oProductCode);
	oTableStylePlan->GridColumnStyles->Add(oProductName);
	oTableStylePlan->GridColumnStyles->Add(oLot);
	oTableStylePlan->GridColumnStyles->Add(oLine);
	oTableStylePlan->GridColumnStyles->Add(oQty);

	/////////////////////////////////////////////////
		oTableStylePlan->GridColumnStyles->Add(oNameA);
		oTableStylePlan->GridColumnStyles->Add(oQTY_A);
		oTableStylePlan->GridColumnStyles->Add(oNameB);
		oTableStylePlan->GridColumnStyles->Add(oQTY_B);
	////////////////////////////////////////////////
	dataGridPlan->TableStyles->Add(oTableStylePlan);
}

//void ProductPlanCheck::InitGridDetail(void)
//{
//	DataGridTextBoxColumn *oDate;
//	DataGridTextBoxColumn *oNameA;
//	DataGridTextBoxColumn *oQTY_A;
//	DataGridTextBoxColumn *oNameB;
//	DataGridTextBoxColumn *oQTY_B;
//
//	oDataSetDetail				= new DataSet();
//	oTableStyleDetail			= new DataGridTableStyle();
//	oTableStyleDetail->MappingName	= S"GridDataDetail";
//
//	//Date
//	oDate						= new DataGridTextBoxColumn();
//	oDate->MappingName			= S"YMD_DATE";
//	oDate->HeaderText			= oInf->saG_Code[iLanguage];
//	oDate->Alignment			= HorizontalAlignment::Center;
//	oDate->Width				= 90;
//	//add by kasenhoo@051105
//	oDate->NullText		= S"";
//	//end kasenhoo
//	
//
//	//NameB
//	oNameB						= new DataGridTextBoxColumn();
//	oNameB->MappingName			= S"NAME_B";
//	oNameB->HeaderText			= S"Shift B";
//	oNameB->Alignment			= HorizontalAlignment::Center;
//	oNameB->Width				= 100;
//
//	//add by kasenhoo@051105
//	oNameB->NullText		= S"";
//	//end kasenhoo
//
//	//QTY_B
//	oQTY_B						= new DataGridTextBoxColumn();
//	oQTY_B->MappingName			= S"QTY_B";
//	oQTY_B->HeaderText			= S"QTY";
//	oQTY_B->Alignment			= HorizontalAlignment::Center;
//	oQTY_B->Width				= 60;
//
//	//add by kasenhoo@051105
//	oQTY_B->NullText		= S"";
//	//end kasenhoo
//
//	//NameA
//	oNameA						= new DataGridTextBoxColumn();
//	oNameA->MappingName			= S"NAME_A";
//	oNameA->HeaderText			= S"Shift A";
//	oNameA->Alignment			= HorizontalAlignment::Center;
//	oNameA->Width				= 100;
//
//	//add by kasenhoo@051105
//	oNameA->NullText		= S"";