platestocklist.cpp

来自「这是一个工厂的生产线的仓库管理.有计划,实绩,库存等」· C++ 代码 · 共 191 行

#include "stdafx.h"
#include "PlateStockList.h"

using namespace FAP;

DataTable * PlateStockList::dtPlateCode(infClass *infTmp,DBBase *dBTMP)
{
	DataTable	*dtblTmp;
	DataSet		*dsetTmp;

	String		*strSQL	= "";
	strSQL		= String::Concat(strSQL,"select PRODUCT_CODE as PLATE_CODE");
	strSQL		= String::Concat(strSQL," from PARTS_MST where PARTS_NAME_C='铭牌'");
	//Concat factory code,line,and process no.
	//strSQL		= String::Concat(strSQL," and FACTORY_CODE='");
	//strSQL		= String::Concat(strSQL,sFactory);
	//strSQL		= String::Concat(strSQL,"' and LINE='");
	//strSQL		= String::Concat(strSQL,sLine);
	//strSQL		= String::Concat(strSQL,"' and PROCESS_NO='");
	//strSQL		= String::Concat(strSQL,sProcess);
	//strSQL		= String::Concat(strSQL,"'");

	//strSQL = String::Concat(strSQL,saLang[iLanguage]);不需要按语言选择。

	dBTMP->blnCnnOpen();
	dsetTmp = dBTMP->dSetSQL_Select(strSQL,S"TMP",0);
	dBTMP->blnCnnClose();
	try
	{
		dtblTmp = dsetTmp->Tables->Item[S"TMP"];
	}
	catch (Exception *) 
	{
		return NULL;		
	}
	return dtblTmp;
}

void PlateStockList::initShowResultGrid()
{
	DataGridTextBoxColumn *oPlateName;
	DataGridTextBoxColumn *oSerNOStart;
	DataGridTextBoxColumn *oSerNOEnd;
	DataGridTextBoxColumn *oLot;
	DataGridTextBoxColumn *oProduceDayTime;
	DataGridTextBoxColumn *oUsedDayTime;

	String *strPlateName[]		= {S"品名",S"製品名",S"Product Name"};
	String *strSerNOStart[]		= {S"连续号开始",S"シリアル番号開始",S"Start Serial NO."};
	String *strSerNOEnd[]		= {S"连续号结尾",S"シリアル番号終了",S"End Serial NO."};
	String *strLot[]			= {S"批号",S"ロット",S"Lot"};
	String *strProduceDayTime[]	= {S"生产日时",S"生産日時",S"Produce Day Time"};
	String *strUsedDayTime[]	= {S"使用日时",S"使用日時",S"Used Day Time"};
	
	DataGridTableStyle *oTableStyle = new DataGridTableStyle();

	oTableStyle->MappingName	= S"PlateStockList";

	//oPlateName
	oPlateName					= new DataGridTextBoxColumn();
	oPlateName->MappingName		= S"PlateName";
	oPlateName->HeaderText		= strPlateName[iLanguage];
	oPlateName->Alignment		= HorizontalAlignment::Left;
	oPlateName->Width			= 200;
	oPlateName->ReadOnly		= true;
	oPlateName->NullText		= S"";

	//oSerNOStart
	oSerNOStart					= new DataGridTextBoxColumn();
	oSerNOStart->MappingName	= S"SerNOStart";
	oSerNOStart->HeaderText		= strSerNOStart[iLanguage];
	oSerNOStart->Alignment		= HorizontalAlignment::Left;
	oSerNOStart->Width			= 80;
	oSerNOStart->ReadOnly		= true;
	oSerNOStart->NullText		= S"";

	//oSerNOEnd
	oSerNOEnd					= new DataGridTextBoxColumn();
	oSerNOEnd->MappingName		= S"SerNOEnd";
	oSerNOEnd->HeaderText		= strSerNOEnd[iLanguage];
	oSerNOEnd->Alignment		= HorizontalAlignment::Left;
	oSerNOEnd->Width			= 80;
	oSerNOEnd->ReadOnly			= true;
	oSerNOEnd->NullText			= S"";

	//oLot
	oLot						= new DataGridTextBoxColumn();
	oLot->MappingName			= S"lot";
	oLot->HeaderText			= strLot[iLanguage];
	oLot->Alignment				= HorizontalAlignment::Left;
	oLot->Width					= 80;
	oLot->ReadOnly				= true;
	oLot->NullText				= S"";

	//oProduceDayTime
	oProduceDayTime					= new DataGridTextBoxColumn();
	oProduceDayTime->MappingName	= S"ProduceDayTime";
	oProduceDayTime->HeaderText		= strProduceDayTime[iLanguage];
	oProduceDayTime->Alignment		= HorizontalAlignment::Left;
	oProduceDayTime->Width			= 180;
	oProduceDayTime->ReadOnly		= true;
	oProduceDayTime->NullText		= S"";

	//oUsedDayTime
	oUsedDayTime					= new DataGridTextBoxColumn();
	oUsedDayTime->MappingName		= S"UsedDayTime";
	oUsedDayTime->HeaderText		= strUsedDayTime[iLanguage];
	oUsedDayTime->Alignment			= HorizontalAlignment::Left;
	oUsedDayTime->Width				= 180;
	oUsedDayTime->ReadOnly			= true;
	oUsedDayTime->NullText			= S"";

	oTableStyle->GridColumnStyles->Add(oPlateName);
	oTableStyle->GridColumnStyles->Add(oSerNOStart);
	oTableStyle->GridColumnStyles->Add(oSerNOEnd);
	oTableStyle->GridColumnStyles->Add(oLot);
	oTableStyle->GridColumnStyles->Add(oProduceDayTime);
	oTableStyle->GridColumnStyles->Add(oUsedDayTime);

	showResultGrid->TableStyles->Add(oTableStyle);

}
void PlateStockList::initDataShowResultGrid(String * strProductNo)
{
	/***********************************************/
	/*			    本模块是主要数据库操作		   */
	/***********************************************/
	DataSet *dSetTmp;
	DataTable *dTableTmp;
	String *strSQL;
	String * strPlateName[]={S"铭牌",S"銘盤",S"Plate"};
	strSQL=S"";
	//写SQL查询语句
	strSQL=String::Concat(strSQL,S"select '");
	//strSQL=String::Concat(strSQL,S"select a.product_code");
	strSQL=String::Concat(strSQL,strPlateName[iLanguage]);
	strSQL=String::Concat(strSQL,S"' as PlateName,a.serial_start as SerNOStart,a.serial_end as SerNOEnd,");
	strSQL=String::Concat(strSQL,S"a.factory_code,a.line_code,b.product_code||'G' as lot,");
	strSQL=String::Concat(strSQL,S"a.pro_ymd as ProduceDayTime,a.use_ymd as UsedDayTime from plate_data a ");
	strSQL=String::Concat(strSQL,S"left outer join part_composition b on a.product_code = b.parts_code where a.factory_code='");
	strSQL=String::Concat(strSQL,sFactory);
	//strSQL=String::Concat(strSQL,S"' AND a.line_code='");
	//strSQL=String::Concat(strSQL,sLine);
	strSQL=String::Concat(strSQL,S"' and a.product_code='");
	strSQL=String::Concat(strSQL,strProductNo);
	strSQL=String::Concat(strSQL,S"'");

	if (!dbPlateStockList->blnCnnOpen())
	{
		return;
	}
	
	try
	{
		dSetTmp = dbPlateStockList->dSetSQL_Select(strSQL,S"PlateStockList",0);
		dTableTmp = dSetTmp->Tables->Item[S"PlateStockList"];
	}

	catch (Exception *) 
	{
		return;
	}
	showResultGrid->DataSource = dTableTmp;
}

//String __gc * PlateStockList::strPlateName(String * strPlateCode,DBBase * DBbTmp)
//{
//	DataRow *dRowTmp;
//	String * strSQL;
//
//	String * saLang[]={S"C",S"J",S"E"};
//
//	strSQL=S"";
//	strSQL=String::Concat(strSQL,"select PARTS_NAME_");
//	strSQL=String::Concat(strSQL,saLang[iLanguage]);
//	strSQL=String::Concat(strSQL," as PlateName from parts_mst where product_code='");
//	strSQL=String::Concat(strSQL,strPlateCode->Trim());
//	strSQL=String::Concat(strSQL,"'");
//	try
//	{
//		DBbTmp->blnCnnOpen();
//		dRowTmp = DBbTmp->dRowSQL_Select(strSQL);
//		DBbTmp->blnCnnClose();
//	}
//	catch(Exception *)
//	{
//		return S"";
//	}
//	return Convert::ToString(dRowTmp->Item[S"PlateName"]);
//}