stockdeliverlist.cpp

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

	oQuantity->MappingName			= S"deliver_qty";
	oQuantity->HeaderText			= String::Concat(oInf->saG_StrArrayDeliverQuantity[iLanguage],S"      \0");
	oQuantity->Alignment			= HorizontalAlignment::Right;
	oQuantity->Width				= 100;
	oQuantity->NullText		        = S"";
	oQuantity->Format				= S"#,###";

	
	
	//oOriginName
	oOriginName						= new DataGridTextBoxColumn();
	oOriginName->MappingName		= S"Origin_Name";
	oOriginName->HeaderText			= String::Concat(S"           ",oInf->saG_StrArrayOriginName[iLanguage]);
	oOriginName->Alignment			= HorizontalAlignment::Left;
	oOriginName->Width				= 160;
	oOriginName->NullText		        =S"";
	
	//oOriginName
	oDestinationName				= new DataGridTextBoxColumn();
	oDestinationName->MappingName	= S"Destination_Name";
	oDestinationName->HeaderText	= String::Concat(S"           ",oInf->saG_StrArrayrDestinationName[iLanguage]);
	oDestinationName->Alignment		= HorizontalAlignment::Left;
	oDestinationName->Width			= 160;
	oDestinationName->NullText		=S"";
	
	oTableStyle->GridColumnStyles->Add(oDeliverYMD);
	oTableStyle->GridColumnStyles->Add(oStockYMD);
	oTableStyle->GridColumnStyles->Add(oProductCode);
	oTableStyle->GridColumnStyles->Add(oPartName);
	oTableStyle->GridColumnStyles->Add(oLotNumber);
	oTableStyle->GridColumnStyles->Add(oQuantity);
	oTableStyle->GridColumnStyles->Add(oOriginName);
	oTableStyle->GridColumnStyles->Add(oDestinationName);



	dataGridStockDeliverList->TableStyles->Add(oTableStyle);



}

void StockDeliverList::SetValueComboBoxLine(void)
{
	String* sCompare;
	String* saLine[]   = {S"'L001','L002'", S"L001", S"L002"};//l001 is r line ,l002 is v line
	if(insideRank==0)
	{
		
		sCompare=oDSet->Tables->Item[S"StockDeliverList_COST_MST"]->Rows->Item[0]->Item[S"LINE_CODE"]->ToString();
		if(sCompare->CompareTo(saLine[1])==0)
		{
			comboBoxLine->SelectedIndex=1;
			iLineIndex=1;
		}
		if(sCompare->CompareTo(saLine[2])==0)
		{
			comboBoxLine->SelectedIndex=2;
			iLineIndex=2;
		}
		comboBoxLine->Enabled=false;
	
	}
	else 
	{
		if (flag==false){

		}else{
			comboBoxLine->SelectedIndex = 0;
		}
	}


	/*String*		sSQL = S"";
	String*     temp=S"33";
	String*		saLangName[] = {S"NAME_C",S"NAME_J",S"NAME_E"};
	sSQL = S"select * from line_mst";
	oDataSet=oDB->dSetSQL_Select(sSQL, "DataTableLineMaster", 0);
	comboBoxLine->DataSource=oDataSet->Tables->Item["DataTableLineMaster"];//->DefaultView;Tables->Item[S"COST_MST"];
	comboBoxLine->DisplayMember = "LINE_NAME";
    comboBoxLine->ValueMember = "LINE_CODE";
	//comboBoxLine->Items->Add(temp)	;*/


}
void StockDeliverList::InitializeValueComboProcess(void)
{

	String *sSQL;
	sSQL = S"";
	String* saLang[]   = {S"C", S"J", S"E"};
	//String* saLine[]   = {S"'L001','L002'", S"'L001'", S"'L002'"}; //l001 is r line ,l002 is v line

	
	/// <summary>
	/// insideRank==0 means worker enter into system
	/// </summary>
	if(insideRank==0)
	{
		sSQL = String::Concat(sSQL,	S"select "														);
		sSQL = String::Concat(sSQL,	S"	PROCESS_NO, "												);
		sSQL = String::Concat(sSQL,	S"	LINE_CODE, "												);
		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"  PROCESS_NO='",sProcess,S"'"                              	);
	}
	else 
	{
		sSQL = String::Concat(sSQL,	S"select"														);
		sSQL = String::Concat(sSQL,	S"	PROCESS_NO, "												);
		sSQL = String::Concat(sSQL,	S"	LINE_CODE, "												);
		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[comboBoxLine->SelectedIndex], S") and"	);
		sSQL = String::Concat(sSQL,	S"	PROCESS_NO is not null"										);
		
		
		sSQL = String::Concat(sSQL, S" and sap_store_no like '9%'" );
	
	}


	oDSet = oDB->dSetSQL_Select(sSQL, S"StockDeliverList_COST_MST",0);
	/// <summary>
	///if not a worker login the system,add a all item into the first line of comboboxProcess
	/// </summary>
	if (insideRank!=0)
	{
		DataRow* drAll=oDSet->Tables->Item[S"StockDeliverList_COST_MST"]->NewRow();
/// <summary>
///acording to the chosen language version,add individual lan ver "all" item.  
///0 :china 1:jap 2english
/// </summary>
      switch (iLanguage)
	{
		case 0:  drAll->Item[S"NAME"] =S"全部";      break;
		case 1:  drAll->Item[S"NAME"] =S"全て";     break;
		case 2:  drAll->Item[S"NAME"] =S"ALL";     break;
        default:       break;
     }
		
		oDSet->Tables->Item[S"StockDeliverList_COST_MST"]->Rows->InsertAt(drAll,0);


		
		
	}//oDSet->Tables->Item[S"StockDeliverList_COST_MST"]->DefaultView->RowFilter=S"PROCESS_NO='MA01'";///String::Concat(S"PROCESS_NO='",sProcess,S"'");
	comboBoxProcess->DataSource    = oDSet->Tables->Item[S"StockDeliverList_COST_MST"]->DefaultView;
	comboBoxProcess->DisplayMember = S"NAME";
	comboBoxProcess->ValueMember   = S"PROCESS_NO";
	

}

void StockDeliverList::SetValueComboBoxShift(void)
{
	if (flag==false){

		}else{
    comboBoxShift->SelectedIndex = 0;
		}
}
void StockDeliverList::SetGridValueStockDeliverList(String* sProcess,String* sShift)
{  
	String* filter;
	filter=S"";
   if((insideRank!=0) && (comboBoxProcess->SelectedIndex==0))
   {
	   String* saLine[]   = {S"'L001','L002'", S"'L001'", S"'L002'"};
	   filter=String::Concat(filter,S"((Origin_LineCode IN (", saLine[comboBoxLine->SelectedIndex], S") )");
	   filter=String::Concat(filter,S" OR (Destination_LineCode IN (", saLine[comboBoxLine->SelectedIndex], S")))");
   }
   else
   {
		filter=String::Concat(filter,S"(origin_code='",sProcess,S"' OR destination_code='",sProcess,S"')");
   }

  
   filter=String::Concat(filter,S"  AND (shift IN (",sShift,S"))");	
	//dataGridStockDeliverList->DataSource = NULL;
			 // dataGridStockDeliverList->Refresh();
	oDataSet->Tables->Item[S"DataTableStockDeliverList"]->DefaultView->RowFilter=filter;

//dataGridStockDeliverList->DataSource = oDataSet->Tables->Item[S"DataTableStockDeliverList"]->DefaultView;


}
void StockDeliverList::SetValueComboProcess(String* sLineCode)
{
		String* filter;
		filter="";
		filter=String::Concat(filter,S"LINE_CODE IN (",sLineCode,S")");
/// <summary>
///let previous all item still display 
/// </summary>
		filter=String::Concat(filter,S"OR (NAME='全部' OR NAME='全て' OR NAME='ALL')");
		oDSet->Tables->Item[S"StockDeliverList_COST_MST"]->DefaultView->RowFilter=filter;
		SetGridValueStockDeliverList(comboBoxProcess->SelectedValue->ToString(),saShift[comboBoxShift->SelectedIndex]);
		//oDSet->Tables->Item[S"StockDeliverList_COST_MST"]->DefaultView->RowFilter=S"LINE_CODE IN ('L001')";
}