partsmst.cpp

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

#include "stdafx.h"
#include "PartsMst.h"

#include "DBBase.h" 

using namespace  FAP;
using namespace System::Data;
using namespace System::Data::OleDb;

void PartsMst::begin(void){
	abc=new String __gc *[12];
	switch(iLanguage){
	case 0:
		abc[0]=S"数据库连接失败！！";
        abc[1]=S"数据库存在相同的记录！！";
		abc[2]=S"数据新增成功！！";
		
		abc[3]=S"数据修改成功";
		
		abc[4]=S"确认要删除记录吗？？";
		abc[5]=S"删除文件";
		abc[6]=S"数据删除成功！";
       abc[7]=S"物料编码没有进行输入！！";
	   abc[8]=S"物料名称没有进行输入！！";
	   abc[9]=S"金额没有进行输入！！";
	   abc[10]=S"单位没有进行输入！！";
	break;

	case 1:abc[0]=S"データーベースへの接続が失敗しました！！";
        abc[1]=S"データベースの中で同じレコードが存在しています！！";
		abc[2]=S"データの増加が成功しました！！";
		abc[3]=S"データの修正が成功しました！！";
		abc[4]=S"このデータを削除してよろしいでしょうか？？";
		abc[5]=S"文件の削除";
		abc[6]=S"データの削除が成功しました！！";
      abc[7]=S"物料コードを入力してください！！";
	   abc[8]=S"物料名称を入力してください！！";
	   abc[9]=S"金額を入力してください！！";
	   abc[10]=S"単位を入力してください！！";
break;
case 2:abc[0]=S"Database Connection Fail！！";
        abc[1]=S"Same Record In The Database！！";
		abc[2]=S"Data Add Are Success！！";
		abc[3]=S"Data Edit Are Success！！";
		abc[4]=S"Really Delete Record？？";
		abc[5]=S"Delete File";
		abc[6]=S"Data Delete Success！！";
      abc[7]=S"Haven't Input Materiel Code！！";
	   abc[8]=S"Haven't Input Materiel Name！！";
	   abc[9]=S"Haven't Input Number Of Money！！";
	   abc[10]=S"Haven't Input Which Type Of Data To Be Operated！！";
break;
default :
	   abc[0]=S"数据库连接失败！！";
        abc[1]=S"数据库存在相同的记录！！";
		abc[2]=S"数据新增成功！！";
		
		abc[3]=S"数据修改成功";
		
		abc[4]=S"确认要删除记录吗？？";
		abc[5]=S"删除文件";
		abc[6]=S"数据删除成功！";
       abc[7]=S"物料编码没有进行输入！！";
	   abc[8]=S"物料名称没有进行输入！！";
	   abc[9]=S"金额没有进行输入！！";
	   abc[10]=S"单位没有进行输入！！";
break;
	}

}
void PartsMst::InitGridGPartsMst(void)
{
	DataGridTextBoxColumn *oProductCode;
	DataGridTextBoxColumn *oProductName;
	DataGridTextBoxColumn *oUNIT;
	DataGridTextBoxColumn *oRmb;
	DataGridTextBoxColumn *oSEQUENCENO;

	String * saparts_name;
	String * saparts_money;

		switch(iLanguage) {
		case 0:
			saparts_name = S"parts_name_c";			
			saparts_money = S"RMB";
			break;
		case 1:
			saparts_name = S"parts_name_j";
			saparts_money = S"YEN";
			break;
		case 2:
			saparts_name = S"parts_name_e";
			saparts_money = S"DOLLAR";
			break;
		default:
			saparts_name = S"parts_name_c";			
			saparts_money = S"RMB";
	}


	DataGridTableStyle *oTableStyle = new DataGridTableStyle();

	oTableStyle->MappingName	= S"dPartsMST";

	//ProductCode
	oProductCode				= new DataGridTextBoxColumn();
	oProductCode->MappingName	= S"PRODUCT_CODE";
	oProductCode->HeaderText	= oInf->sa_product[iLanguage];
	oProductCode->Alignment		= HorizontalAlignment::Center;
	oProductCode->Width			= 150;
	
	//add by kasenhoo@051105
	oProductCode->NullText		= S"";
	//end kasenhoo

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

	//unit
	oUNIT						= new DataGridTextBoxColumn();
	oUNIT->MappingName			= S"UNIT";
	oUNIT->HeaderText			= oInf->sa_UNIT[iLanguage];
	oUNIT->Alignment				= HorizontalAlignment::Center;
	oUNIT->Width					= 80;

	
	oUNIT->NullText		= S"";
	//end kasenhoo

	//money
	oRmb						= new DataGridTextBoxColumn();
	oRmb->MappingName			= saparts_money;
	oRmb->HeaderText			= oInf->sa_Money[iLanguage];
	oRmb->Alignment			= HorizontalAlignment::Center;
	oRmb->Width				= 100;

	
	oRmb->NullText		= S"";
	//end kasenhoo

	//Product Qty
	oSEQUENCENO						= new DataGridTextBoxColumn();
	oSEQUENCENO->MappingName			= S"SEQUENCE_no";
	oSEQUENCENO->HeaderText			= oInf->sa_SEQUENCE_no[iLanguage];
	oSEQUENCENO->Alignment				= HorizontalAlignment::Center;
	oSEQUENCENO->Width					= 200;

	//add by kasenhoo@051105
	oSEQUENCENO->NullText		= S"";
	//end kasenhoo
	
	oTableStyle->GridColumnStyles->Add(oProductCode);
	oTableStyle->GridColumnStyles->Add(oProductName);
	oTableStyle->GridColumnStyles->Add(oUNIT);
	oTableStyle->GridColumnStyles->Add(oRmb);
	oTableStyle->GridColumnStyles->Add(oSEQUENCENO);
	GPartsMst->TableStyles->Add(oTableStyle);
}

void PartsMst::setGridPartsMst(int intlanguage,int ilongt)
{

	String * sSQL;
	String * saparts_name;
	String * saparts_money;
	String * saparts_producttype1;
	String * saparts_producttype2;
	String * saparts_producttype3;

	
	switch(intlanguage) {
		case 0:
			saparts_name = S"parts_name_c";			
			saparts_money = S"RMB";
			saparts_producttype1=S"原材料";
			saparts_producttype2=S"半成品";
			saparts_producttype3=S"完成品";
			break;
		case 1:
			saparts_name = S"parts_name_j";
			saparts_money = S"YEN";
			saparts_producttype1=S"原材料";
			saparts_producttype2=S"半製品";
			saparts_producttype3=S"完成品";
			break;
		case 2:
			saparts_name = S"parts_name_e";
			saparts_money = S"DOLLAR";
			saparts_producttype1=S"Material";
			saparts_producttype2=S"Semifinished products";
			saparts_producttype3=S"Finished product";
			break;
		default:
			saparts_name = S"parts_name_c";			
			saparts_money = S"RMB";
			saparts_producttype1=S"原材料";
			saparts_producttype2=S"半成品";
			saparts_producttype3=S"完成品";
	}

	sSQL = S" ";
	sSQL = String::Concat(sSQL,S" Select product_code,",saparts_name,S",unit,",saparts_money,S",case SEQUENCE_NO when 3000 then '",saparts_producttype1,S"' when 7900 then '",saparts_producttype2,S"' when 7920 then '",saparts_producttype3, S"' end as SEQUENCE_NO from  parts_mst ");
	if (ilongt==1)
	{
		sSQL=String::Concat(sSQL,S" where ",saparts_name,S" like '%",txtproductname->Text,S"%'");
	}

	oDataSet=oDB->dSetSQL_Select(sSQL, "dPartsMST", 0);
	

	oDataView= oDataSet->Tables->Item[S"dPartsMST"]->DefaultView;
	oDataView->AllowNew	= false; 
	oDataView->AllowEdit= false; 
	
	GPartsMst->DataSource = oDataSet->Tables->Item[S"dPartsMST"]->DefaultView;

		
}

void PartsMst::InitComboxItem(void)
{
	if (iLanguage==0)
	{
		comproducttype->Items->Add(S"原材料");
		comproducttype->Items->Add(S"半成品");
		comproducttype->Items->Add(S"完成品");
	}
	else if(iLanguage==1)
	{
		comproducttype->Items->Add(S"原材料");
		comproducttype->Items->Add(S"半製品");
		comproducttype->Items->Add(S"完成品");
	}
	else if(iLanguage==2)
	{
		comproducttype->Items->Add(S"Material");
		comproducttype->Items->Add(S"Semifinished products");
		comproducttype->Items->Add(S"Finished product");
	}
		comproducttype->SelectedIndex=1;

	
}
void PartsMst::initcoll(void)
{
	txtproductname->Text=S"";
	txtproductcode->Text=S"";
	txtproname->Text=S"";
	txtunit->Text=S"";
	txtmoney->Text=S"";
	comproducttype->SelectedIndex=0;
				 
	txtproductcode->Enabled=false;
	txtproname->Enabled=false;
	txtunit->Enabled =false;
	txtmoney->Enabled = false;
	comproducttype->Enabled =false;
}

void PartsMst::initcoll1(void)
{
	txtproductname->Text=S"";
	txtproductcode->Text=S"";
	txtproname->Text=S"";
	txtunit->Text=S"";
	txtmoney->Text=S"";
	comproducttype->SelectedIndex=0;
				 
	txtproductcode->Enabled=true;
	txtproname->Enabled=true;
	txtunit->Enabled =true;
	txtmoney->Enabled = true;
	comproducttype->Enabled =true;
}

bool PartsMst::txtcheck(void)
{
	switch(iLanguage) {
		case 0:

				if (txtproductcode->Text->Trim()->CompareTo(S"") == 0 )
				{
					MessageBox::Show  (abc[7],S"Parts_mst",MessageBoxButtons::OK,MessageBoxIcon::Information);
					return false;
				}

				if (txtproname->Text->Trim()->CompareTo(S"") == 0 )
				{
					MessageBox::Show  (abc[8],S"Parts_mst",MessageBoxButtons::OK,MessageBoxIcon::Information);
					return false;
				}

				if (txtmoney->Text->Trim()->CompareTo(S"") == 0 )