platestocklist.cpp

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

#include "StdAfx.h"
#include "PlateStockList.h"

bool FAP::PlateStockList::blnFillGrid(String * strProCode){

	DataSet * dSetTmp;

	DataTable * dTblTmp;

	String * strSQL;
 
	strSQL =  S"select Product_code,serial_start,SERIAL_END,LOT,PRO_YMD,USE_YMD from plate_data  ";

	strSQL = String::Concat(strSQL,S" where product_code = '", strProCode,S"'");
    
	if (!DBBPlateList->blnCnnOpen()){
		return false;
	}
	
	dSetTmp = DBBPlateList->dSetSQL_Select(strSQL,S"PlateStockList",0);

	dTblTmp = dSetTmp->Tables->Item[S"PlateStockList"];
	
//	dbGridLabel->SetDataBinding(dSetTmp,S"PlateData");
//
//	dbGridLabel->Refresh();

	dbGridLabel->DataSource = dTblTmp;
	
	DBBPlateList->blnCnnClose();


	return true;
}

void FAP::PlateStockList::IniComboBox(){

	DataSet * dSetTmp;

	String * strSQL;

	strSQL =  S"SELECT DISTINCT PRODUCT_CODE FROM PLATE_DATA";
	
	//strSQL =S"SELECT NAME_J FROM TEAM_MST";

	if (!DBBPlateList->blnCnnOpen()){
		return;
	}

	dSetTmp = DBBPlateList->dSetSQL_Select(strSQL,S"PlateData",0);

	try{
		cboProCode->DataSource = dSetTmp->Tables->Item[S"PlateData"];

		cboProCode->DisplayMember = S"PRODUCT_CODE";
	}
	catch (...) {
		
	}

	//cboProCode->DisplayMember = S"lot";

	//cboProCode->Refresh();
	__finally{
		DBBPlateList->blnCnnClose();
	}
}
	
void FAP::PlateStockList::InitGrid(int intLang ){
	//Product_code,serial_start,SERIAL_END,LOT,PRO_YMD,USE_YMD

	DataGridTextBoxColumn *oProduct_code;
	DataGridTextBoxColumn *oserial_start;
	DataGridTextBoxColumn *oSERIAL_END;
	DataGridTextBoxColumn *oLot;
	DataGridTextBoxColumn *oPRO_YMD;
	DataGridTextBoxColumn *oUse_Ymd;

	String *saLang[]= {S"C",S"J",S"E"};

	DataGridTableStyle *oTableStyle = new DataGridTableStyle();

	oTableStyle->MappingName		= S"PlateStockList";
	//oProduct_code
	oProduct_code	= new DataGridTextBoxColumn();
	oProduct_code->MappingName		= S"oProduct_code";
	oProduct_code->HeaderText		= infClsPlateList->saPrductName[intLang];
	oProduct_code->Alignment		= HorizontalAlignment::Center;
	oProduct_code->Width			= 200;
	oProduct_code->ReadOnly			= true;
	oProduct_code->NullText			=S"";

	//serial_start
	oserial_start		= new DataGridTextBoxColumn();
	oserial_start->MappingName		= S"serial_start";
	oserial_start->HeaderText		= infClsPlateList->saStartNo[intLang];
	oserial_start->Alignment		= HorizontalAlignment::Center;
	oserial_start->Width			= 80;
	oserial_start->ReadOnly			= true;
	oserial_start->NullText			=S"";

	//SERIAL_END
	oSERIAL_END				= new DataGridTextBoxColumn();
	oSERIAL_END->MappingName	= S"SERIAL_END";
	oSERIAL_END->HeaderText		= infClsPlateList->saEndNo[intLang];
	oSERIAL_END->Alignment		= HorizontalAlignment::Center;
	oSERIAL_END->Width			= 80;
	oSERIAL_END->ReadOnly		= true;
	oSERIAL_END->NullText		= S"";


	//LOT
	oLot				= new DataGridTextBoxColumn();
	oLot->MappingName	= S"LOT";
	oLot->HeaderText	= infClsPlateList->saLot[intLang];
	oLot->Alignment		= HorizontalAlignment::Center;
	oLot->Width			= 80;
	oLot->ReadOnly		= false;
	oLot->NullText		=S"";
	//oExistNum->Format	= 

	//PRO_YMD
	oPRO_YMD				= new DataGridTextBoxColumn();
	oPRO_YMD->MappingName	= S"PRO_YMD";
	oPRO_YMD->HeaderText	= infClsPlateList->saProductTime[intLang];
	oPRO_YMD->Alignment		= HorizontalAlignment::Center;
	oPRO_YMD->Width			= 180;
	oPRO_YMD->ReadOnly		= false;
	oPRO_YMD->NullText		= S"";
	//oPRO_YMD->Format		

	//USE_YMD
	oUse_Ymd				= new DataGridTextBoxColumn();
	oUse_Ymd->MappingName	= S"USE_YMD";
	oUse_Ymd->HeaderText	= infClsPlateList->saUseTime[intLang];
	oUse_Ymd->Alignment		= HorizontalAlignment::Center;
	oUse_Ymd->Width			= 180;
	oUse_Ymd->ReadOnly		= false;
	oUse_Ymd->NullText		= S"";
	

	oTableStyle->GridColumnStyles->Add(oProduct_code);
	oTableStyle->GridColumnStyles->Add(oLot);
	oTableStyle->GridColumnStyles->Add(oserial_start);
	oTableStyle->GridColumnStyles->Add(oSERIAL_END);
	oTableStyle->GridColumnStyles->Add(oPRO_YMD);
	oTableStyle->GridColumnStyles->Add(oUse_Ymd);

	dbGridLabel->TableStyles->Add(oTableStyle);

	
}