frmmodifyresult.cpp

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

#include "stdafx.h"
#include "frmModifyResult.h"
using namespace  FAP;
using namespace System::Data;
using namespace System::Data::OleDb;

void frmModifyResult::InitGrid(int intLang)
{

	DataGridTextBoxColumn *oColProudct;
	DataGridTextBoxColumn *oColProcess;
	DataGridTextBoxColumn *oColQty;
	DataGridTextBoxColumn *oColYmd;
	DataGridTextBoxColumn *oColLine;
	DataGridTextBoxColumn *oColShift;
	DataGridTextBoxColumn *oColTeam;
	DataGridTextBoxColumn *oColLot;


	DataGridTableStyle *oTableStyle;
	oTableStyle = new DataGridTableStyle();
	oTableStyle->MappingName = S"DD";
	
	//col product_code
	oColProudct = new DataGridTextBoxColumn();
	oColProudct->Alignment = HorizontalAlignment::Left;
	oColProudct->MappingName = S"product_code";
	oColProudct->HeaderText = String::Concat(S"            ",oInf->saG_Code[iLanguage]);
	oColProudct->Width = 160;
	oColProudct->ReadOnly = true;
	oColProudct->NullText = S"";

	//col process_no
	oColProcess = new DataGridTextBoxColumn();
	oColProcess->Alignment = HorizontalAlignment::Left;
	oColProcess->MappingName = S"process_no";
	oColProcess->HeaderText = String::Concat(S"         ",oInf->saG_StrArrayProcessName[iLanguage]);
	oColProcess->NullText = S"";
	oColProcess->Width = 120;
	oColProcess->ReadOnly = false;

	//col product_qty
	oColQty = new DataGridTextBoxColumn();
	oColQty->Alignment = HorizontalAlignment::Right;
	oColQty->MappingName = S"product_qty";
	oColQty->HeaderText = String::Concat(oInf->saG_ProdQTY[iLanguage],S"    \0");
	oColQty->NullText = S"";
	oColQty->Width = 120;
	oColQty->ReadOnly = false;
	oColQty->Format=S"#,###";

	//col product_ymd
	oColYmd = new DataGridTextBoxColumn();
	oColYmd->Alignment = HorizontalAlignment::Left;
	oColYmd->MappingName = S"product_ymd";
	oColYmd->HeaderText =  String::Concat(S"       ",oInf->saG_StocYMD[iLanguage]);
	oColYmd->NullText = S"";
	oColYmd->Width = 120;
	oColYmd->ReadOnly = false;
	oColYmd->Format=S"yyyy-MM-dd";

	//col product_line
	oColLine = new DataGridTextBoxColumn();
	oColLine->Alignment = HorizontalAlignment::Center;
	oColLine->MappingName = S"product_line";
	oColLine->HeaderText = oInf->saG_LineName[iLanguage];
	oColLine->NullText = S"";
	oColLine->Width = 100;
	oColLine->ReadOnly = false;

	//col product_shift
	String * sShift[]={S"勤务",S"シフト",S"Shift"};

	oColShift = new DataGridTextBoxColumn();
	oColShift->Alignment = HorizontalAlignment::Center;
	oColShift->MappingName = S"product_shift";
	oColShift->HeaderText = sShift[iLanguage];
	oColShift->NullText = S"";
	oColShift->Width = 100;
	oColShift->ReadOnly = false;


	//col product_team
	oColTeam = new DataGridTextBoxColumn();
	oColTeam->Alignment = HorizontalAlignment::Center;
	oColTeam->MappingName = S"product_team";
	oColTeam->HeaderText = oInf->saG_Team[iLanguage];
	oColTeam->NullText = S"";
	oColTeam->Width = 130;
	oColTeam->ReadOnly = false;

	//col product_lot
	oColLot = new DataGridTextBoxColumn();
	oColLot->Alignment = HorizontalAlignment::Left;
	oColLot->MappingName = S"product_lot";
	oColLot->HeaderText =  String::Concat(S"       ",oInf->saPROLot[iLanguage]);
	oColLot->NullText = S"";
	oColLot->Width = 100;
	oColLot->ReadOnly = false;

	oTableStyle->GridColumnStyles->Add(oColLot);
	oTableStyle->GridColumnStyles->Add(oColProudct);
	oTableStyle->GridColumnStyles->Add(oColProcess);	
	oTableStyle->GridColumnStyles->Add(oColQty);
	oTableStyle->GridColumnStyles->Add(oColYmd);
	oTableStyle->GridColumnStyles->Add(oColLine);
	oTableStyle->GridColumnStyles->Add(oColShift);	
	oTableStyle->GridColumnStyles->Add(oColTeam);


	GModifyResult->TableStyles->Add(oTableStyle);

	return;
}

void frmModifyResult::InitcmbTeam(int intLang)
{
	switch (intLang)
	{
		case 0: 
				cmbTeam->Items->Add(S"全部");
				cmbTeam->Items->Add(S"1班");
				cmbTeam->Items->Add(S"2班");
				cmbTeam->Items->Add(S"3班");

				cmbTeam1->Items->Add(S"1班");
				cmbTeam1->Items->Add(S"2班");
				cmbTeam1->Items->Add(S"3班");

				break;
		case 1: 
				cmbTeam->Items->Add(S"全部");
				cmbTeam->Items->Add(S"1班");
				cmbTeam->Items->Add(S"2班");
				cmbTeam->Items->Add(S"3班");

				cmbTeam1->Items->Add(S"1班");
				cmbTeam1->Items->Add(S"2班");
				cmbTeam1->Items->Add(S"3班");

	            break;
		case 2:
				cmbTeam->Items->Add(S"全部");
				cmbTeam->Items->Add(S"1班");
				cmbTeam->Items->Add(S"2班");
				cmbTeam->Items->Add(S"3班");

				cmbTeam1->Items->Add(S"1班");
				cmbTeam1->Items->Add(S"2班");
				cmbTeam1->Items->Add(S"3班");

		default:
				break;
	}

	return;
}
void frmModifyResult::InitcmbShift(int intLang)
{
	switch (intLang)
	{
		case 0: 
				cmbShift->Items->Add(S"全部");
				cmbShift->Items->Add(S"A勤");
				cmbShift->Items->Add(S"B勤");

				cmbShift1->Items->Add(S"A勤");
				cmbShift1->Items->Add(S"B勤");

				break;
		case 1: 
				cmbShift->Items->Add(S"全部");
				cmbShift->Items->Add(S"A勤");
				cmbShift->Items->Add(S"B勤");

				cmbShift1->Items->Add(S"A勤");
				cmbShift1->Items->Add(S"B勤");

	            break;
		case 2:
				cmbShift->Items->Add(S"全部");
				cmbShift->Items->Add(S"A勤");
				cmbShift->Items->Add(S"B勤");

				cmbShift1->Items->Add(S"A勤");
				cmbShift1->Items->Add(S"B勤");

		default:
				break;
	}

	return;
}

void frmModifyResult::InitcmbLine(int intLang)
{
	switch (intLang)
	{
		case 0: 
				cmbLine->Items->Add(S"全部");
				cmbLine->Items->Add(S"R线");
				cmbLine->Items->Add(S"V线");

				cmbLine1->Items->Add(S"R线");
				cmbLine1->Items->Add(S"V线");

				break;
		case 1: 
				cmbLine->Items->Add(S"全部");
				cmbLine->Items->Add(S"R线");
				cmbLine->Items->Add(S"V线");

				cmbLine1->Items->Add(S"R线");
				cmbLine1->Items->Add(S"V线");

	            break;
		case 2:
				cmbLine->Items->Add(S"全部");
				cmbLine->Items->Add(S"R线");
				cmbLine->Items->Add(S"V线");

				cmbLine1->Items->Add(S"R线");
				cmbLine1->Items->Add(S"V线");

		default:
				break;
	}

	return;
}
String * frmModifyResult::strPLine(int imidex)
{
	String * psline;

	switch (imidex)
	{
		case 0: 
				psline=S"L001";
				break;
		case 1: 
				psline=S"L002";
	            break;
		default:
				break;
	}

	return psline;
}
String * frmModifyResult::strPshift(int imidex)
{
	String * psshift;
	switch (imidex)
	{
		case 0: 
				psshift=S"A";
				break;
		case 1: 
				psshift=S"B";
	            break;
		default:
				break;
	}
	return psshift;
}
String * frmModifyResult::strPTeam(int imidex)
{
	String * psteam;
	switch (imidex)
	{
		case 0: 
				psteam=S"1";
				break;
		case 1: 
				psteam=S"2";
	            break;
		case 2: 
				psteam=S"3";
	            break;
		default:
				break;
	}
	return psteam;

}
void frmModifyResult::setGridProudct(DBBase * DBTmp,int intLang,String * PsMMstart,String * PsMMEnd,int PsShift,int PsLine,int PsTeam)
{

	String * strSQL;
	DataSet*	oDataSet;
	DataView*	oDataView;


	strSQL = S"";
	strSQL = String::Concat(strSQL,S" select lot as product_lot,product_code as product_code,process_no as process_no,floor(product_qty) as product_qty,ymd as product_ymd,(case line_code when 'L001' then 'R' when 'L002' then 'V' end) as product_line,shift as product_shift,case team ");
	strSQL = String::Concat(strSQL," when 1 then ");
		strSQL = String::Concat(strSQL,S"'1",oInf->saG_Team[iLanguage],S"'");
		strSQL = String::Concat(strSQL," when 2 then ");
		strSQL = String::Concat(strSQL,S"'2",oInf->saG_Team[iLanguage],S"'");
		strSQL = String::Concat(strSQL," when 3 then ");
		strSQL = String::Concat(strSQL,S"'3",oInf->saG_Team[iLanguage],S"'");
		strSQL = String::Concat(strSQL," else '' end as product_team ");
	strSQL = String::Concat(strSQL,S" from product_result_data ");
	strSQL = String::Concat(strSQL,S" where ");
	strSQL = String::Concat(strSQL,S" ymd>=to_date('",PsMMstart,S"','yyyy-mm-dd') ");
	strSQL = String::Concat(strSQL,S" and ymd<=to_date('",PsMMEnd,S"','yyyy-mm-dd') ");
	//班次
	if (PsShift==0)
	{
		strSQL = String::Concat(strSQL,S"");
	}
	else if(PsShift==1)
	{
		strSQL = String::Concat(strSQL,S" and shift='A'");
	}
	else if(PsShift==2)
	{
		strSQL = String::Concat(strSQL,S" and shift='B'");
	}
	//生产线
	if (PsLine==0)
	{
		strSQL = String::Concat(strSQL,S"");
	}
	else if(PsLine==1)
	{
		strSQL = String::Concat(strSQL,S" and line_code='L001'");
	}
	else if(PsLine==2)
	{
		strSQL = String::Concat(strSQL,S" and line_code='L002'");
	}

	//组
	if (PsTeam==0)
	{
		strSQL = String::Concat(strSQL,S"");
	}
	else if(PsTeam==1)
	{
		strSQL = String::Concat(strSQL,S" and team='1'");
	}
	else if(PsTeam==2)
	{
		strSQL = String::Concat(strSQL,S" and team='2'");
	}
	else if(PsTeam==3)
	{
		strSQL = String::Concat(strSQL,S" and team='3'");
	}
	strSQL = String::Concat(strSQL,S" and product_code='",cmbproduct->Text,S"'");

	DBTmp->blnCnnOpen();

	oDataSet=DBTmp->dSetSQL_Select(strSQL,"DD", 0);
	
	oDataView= oDataSet->Tables->Item[S"DD"]->DefaultView;
	oDataView->AllowNew	= false; 
	oDataView->AllowEdit= false; 
	
	GModifyResult->DataSource = oDataSet->Tables->Item[S"DD"]->DefaultView;

	oDB->blnCnnClose();
	
}

bool frmModifyResult::EditGridoCell()
{
	DataGridCell oCell;
	String * StroCell;
	//DataGridCell oCell1;
	//DataGridCell oCell2;
	//DataGridCell oCell3;
	//dataGridCell oCell4;
	

	oCell = GModifyResult->CurrentCell;
	oCell.ColumnNumber=0;
	txtLot1->Text = GModifyResult->Item[oCell]->ToString();

	oCell.ColumnNumber=1;
	cmbproduct1->Text = GModifyResult->Item[oCell]->ToString();

	labproduct->Text=GModifyResult->Item[oCell]->ToString();

	oCell.ColumnNumber=3;
	txtQuantity->Text = GModifyResult->Item[oCell]->ToString();

	labqty->Text=GModifyResult->Item[oCell]->ToString();

	oCell.ColumnNumber=4;

	labYmd->Text =String::Format("{0:yyyy-MM-dd}",(GModifyResult->Item[oCell]));

	//labYmd->Text = GModifyResult->Item[oCell]->ToString();

	oCell.ColumnNumber=5;
	StroCell = GModifyResult->Item[oCell]->ToString();
	if (System::String::Equals(StroCell,"L001"))
	{
		StroCell=S"R线";