📄 plateusedinput.cpp
字号:
#include "StdAfx.h"
#include "PlateUsedInput.h"
#include "DBBase.h"
using namespace System::Data;
using namespace System::Data::OleDb;
void FAP::PlateUsedInput::begin(void){
abc=new String __gc *[7];
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"登录成功！";
break;
case 1: abc[0]=S"部品マスターの中で、この部品が存在しません！！";
abc[1]=S"数字を入力してください！！";
abc[2]=S"入力した数量とシーケンスナンバーが合わないです！！";
abc[3]=S"生産実績の数が正確ではありません！！";
abc[4]=S"数量を入力してください！！";
abc[5]=S"更新失敗！！";
abc[6]=S"登録成功！！";
break;
case 2:abc[0]=S"Haven't Found This Product In Product Table！！";
abc[1]=S"Please Input Number！！";
abc[2]=S"Number Is Not Equal To Serial Number！！";
abc[3]=S"Practical Production Number Is Incorrect！！";
abc[4]=S"Number Can't Be Null！！";
abc[5]=S"Update Fail！！";
abc[6]=S"Input Success！！";
break;
default:
abc[0]=S"部品表中不存在此部件！！";
abc[1]=S"请输入数字！！";
abc[2]=S"数量不等于连续号码！！";
abc[3]=S"生产实际数量不正确！！";
abc[4]=S"数量不能为空！！";
abc[5]=S"更新失败！！";
abc[6]=S"登录成功！";
break;
}
}
bool FAP::PlateUsedInput::isNumber(String *strNumer)
{
for (int i=0;i<strNumer->Length;i++)
{
if(!System::Char::IsNumber(strNumer,i))
{
return false;
}
else
{
return true;
}
}
return true;
}
String *FAP::PlateUsedInput::strGetProName(String * strDelFromNo,int iLanguage,DBBase * DBbTmp)
{
System::Data::DataRow *dRowTmp;
String *strSQL;
String *strFdName;
switch(iLanguage)
{
case FapLan_EN:
strFdName = S"PARTS_NAME_e";
break;
case FapLan_JP:
strFdName = S"PARTS_NAME_j";
break;
case FapLan_CN:
strFdName = S"PARTS_NAME_C";
break;
default:
strFdName = S"PARTS_NAME_C";
}
if (DBbTmp->blnCnnOpen()==false) {
MessageBox::Show(S"Open Oracle Failed!!",S"Deliver",MessageBoxButtons::OK, MessageBoxIcon::Exclamation);
return S"";
}
strSQL = "";
strSQL = String::Concat(strSQL,S" Select ");
strSQL = String::Concat(strSQL,S" b.product_code, ");
strSQL = String::Concat(strSQL,strFdName,S"," );
strSQL = String::Concat(strSQL,S" a.lot as lot, ");
strSQL = String::Concat(strSQL,S" a.serial_start as serial_start, ");
strSQL = String::Concat(strSQL,S" a.serial_end as serial_end ");
strSQL = String::Concat(strSQL,S"from ");
strSQL = String::Concat(strSQL,S"PLATE_DATA a ");
strSQL = String::Concat(strSQL,S"left outer join PARTS_MST b on ");
strSQL = String::Concat(strSQL,S" a.product_code=b.product_code ");
strSQL = String::Concat(strSQL,S"Where ");
strSQL = String::Concat(strSQL,S" a.product_code= ",S"'",strDelFromNo,S"'" );
strSQL = String::Concat(strSQL,S" and a.USE_DIV=0 ");
dRowTmp = DBbTmp->dRowSQL_Select(strSQL);
try
{
DBbTmp->blnCnnClose ();
}
catch (...) {
return S"";
}
try
{
return String::Concat(Convert::ToString(dRowTmp->Item[strFdName]),S"/",Convert::ToString(dRowTmp->Item["lot"]),S"/",Convert::ToString(dRowTmp->Item["serial_start"]),S"/",Convert::ToString(dRowTmp->Item["serial_end"]));
//return Convert::ToString(dRowTmp->Item["lot"]);
}
catch (Exception *ex)
{
MessageBox::Show(ex->Message);
return S"";
}
return S"";
}
/*-----------------------------------------------------------------
返回LineCode
strSelectComLine 选择下拉框的字符
-------------------------------------------------------------------*/
String *FAP::PlateUsedInput::strGetLineName(String *strSelectComLine,DBBase * DBbTmp)
{
System::Data::DataRow *dRowTmp;
String *strSQL;
strSQL = "";
strSQL = String::Concat(strSQL,S" select ");
strSQL = String::Concat(strSQL,S" Line_code, ");
strSQL = String::Concat(strSQL,S" Line_name ");
strSQL = String::Concat(strSQL,S" from ");
strSQL = String::Concat(strSQL,S" Line_mst ");
strSQL = String::Concat(strSQL,S" where ");
strSQL = String::Concat(strSQL,S" line_name=",S"'",strSelectComLine,S"'" );
dRowTmp = DBbTmp->dRowSQL_Select(strSQL);
try
{
DBbTmp->blnCnnClose ();
}
catch (...) {
return S"";
}
try
{
return String::Concat(Convert::ToString(dRowTmp->Item["Line_code"]));
//return Convert::ToString(dRowTmp->Item["lot"]);
}
catch (Exception *ex)
{
MessageBox::Show(ex->Message);
return S"";
}
return S"";
}
/*----------------------------------------------
部品MST表里面是否有相同的数据
------------------------------------------------*/
bool FAP::PlateUsedInput::strGetPARTSMST(String * strDelFromNo,int iLanguage,DBBase * DBbTmp)
{
System::Data::DataRow *dRowTmp;
String *strSQL;
if (DBbTmp->blnCnnOpen()==false)
{
MessageBox::Show(S"Open Oracle Failed!!",S"Deliver",MessageBoxButtons::OK, MessageBoxIcon::Exclamation);
return false;
}
strSQL = "";
strSQL = String::Concat(strSQL,S" select ");
strSQL = String::Concat(strSQL,S" A.PARTS_NAME_C ");
strSQL = String::Concat(strSQL,S" from ");
strSQL = String::Concat(strSQL,S" PARTS_MST A ");
strSQL = String::Concat(strSQL,S" where ");
strSQL = String::Concat(strSQL,S" PRODUCT_CODE=",S"'",textProductName->Text,S"'" );
try
{
dRowTmp = DBbTmp->dRowSQL_Select(strSQL);
if (dRowTmp->IsNull(0)==true)
{
return false;
}
else
{
return true;
}
DBbTmp->blnCnnClose();
}
catch (...) {
return false;
}
try
{
return true;
}
catch (Exception *ex)
{
MessageBox::Show(ex->Message);
return false;
}
return true;
}
/*--------------------------------------
//判断生产实际数据是否有俩条相等的记录
(PRODUCT_RESULT_DATA)
return true 有
return false 无
----------------------------------------*/
bool FAP::PlateUsedInput::strGetPRODUCTRESULTDATA(String * strDelFromNo,int iLanguage,DBBase * DBbTmp)
{
System::Data::DataRow *dRowTmp;
String *strSQL;
if (DBbTmp->blnCnnOpen()==false)
{
MessageBox::Show(S"Open Oracle Failed!!",S"Deliver",MessageBoxButtons::OK, MessageBoxIcon::Exclamation);
return false;
}
strSQL = "";
strSQL = String::Concat(strSQL,S" select ");
strSQL = String::Concat(strSQL,S" A.PRODUCT_QTY ");
strSQL = String::Concat(strSQL,S" from ");
strSQL = String::Concat(strSQL,S" PRODUCT_RESULT_DATA A ");
strSQL = String::Concat(strSQL,S" where ");
strSQL = String::Concat(strSQL,S" PRODUCT_CODE=",S"'",textProductName->Text,S"'" );
strSQL = String::Concat(strSQL,S" and PRODUCT_QTY=",textQTY->Text );
dRowTmp = DBbTmp->dRowSQL_Select(strSQL);
try
{
DBbTmp->blnCnnClose();
}
catch (...) {
return false;
}
try
{
return true;
//return Convert::ToString(dRowTmp->Item["lot"]);
}
catch (Exception *ex)
{
MessageBox::Show(ex->Message);
return false;
}
return true;
}
/*--------------------------------------
//型号表里面(PLATE_DATA)是否有相同的连续号
return true 有
return false 无
----------------------------------------*/
bool FAP::PlateUsedInput::strGetPLATEDATA(String * strDelFromNo,int iLanguage,DBBase * DBbTmp)
{
return true;
}
bool FAP::PlateUsedInput::strUpdatePLATEDATA()
{
String * strSQL;
strSQL="";
strSQL = String::Concat(strSQL,S" Update ");
strSQL = String::Concat(strSQL,S" PLATE_DATA ");
strSQL = String::Concat(strSQL,S" Set ");
strSQL = String::Concat(strSQL,S" USE_DIV='1', ");
strSQL = String::Concat(strSQL,S" use_ymd=to_date(",S"'",SdayTime,S"',",S"'yyyy-mm-dd') ");
strSQL = String::Concat(strSQL,S" Where ");
strSQL = String::Concat(strSQL,S" PRODUCT_CODE=",S"'",textProductName->Text,S"'" );
strSQL = String::Concat(strSQL,S" and LINE_CODE=",S"'",strcombLine,S"'" );
strSQL = String::Concat(strSQL,S" and serial_start=",textSerialStart->Text );
strSQL = String::Concat(strSQL,S" and serial_end=",textSerialEnd->Text );
if (!DBBRstInExec->blnSQL_Execute(strSQL))
{
}
return true;
}
bool FAP::PlateUsedInput::strUpdatePRODUCTRESULTDATA()
{
String * strSQL;
strSQL="";
strSQL = String::Concat(strSQL,S" Update ");
strSQL = String::Concat(strSQL,S" PRODUCT_RESULT_DATA ");
strSQL = String::Concat(strSQL,S" Set ");
strSQL = String::Concat(strSQL,S" update_ymd=to_date(",S"'",SdayTime,S"',",S"'yyyy-mm-dd') ");
strSQL = String::Concat(strSQL,S" Where ");
strSQL = String::Concat(strSQL,S" PRODUCT_CODE=",S"'",textProductName->Text,S"'" );
strSQL = String::Concat(strSQL,S" and LINE_CODE=",S"'",strcombLine,S"'" );
strSQL = String::Concat(strSQL,S" and PRODUCT_QTY=",textQTY->Text );
strSQL = String::Concat(strSQL,S" and LOT=",textlot->Text );
if (!DBBRstInExec->blnSQL_Execute(strSQL))
{
}
return true;
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -