From 0d2da4a2507a5a8d34bf7f736727917d791df0d2 Mon Sep 17 00:00:00 2001
From: mrDarker <mr.darker@163.com>
Date: 星期三, 14 五月 2025 14:48:31 +0800
Subject: [PATCH] 1. 添加数据库事务提交，减少频繁执行 SQL 写操作
---
SourceCode/Bond/Servo/CJobDataS.cpp | 459 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 457 insertions(+), 2 deletions(-)
diff --git a/SourceCode/Bond/Servo/CJobDataS.cpp b/SourceCode/Bond/Servo/CJobDataS.cpp
index cc07f63..0c9de03 100644
--- a/SourceCode/Bond/Servo/CJobDataS.cpp
+++ b/SourceCode/Bond/Servo/CJobDataS.cpp
@@ -1,8 +1,12 @@
#include "stdafx.h"
#include "CJobDataS.h"
+#include "ToolUnits.h"
namespace SERVO {
+#define JOBDATAS_SIZE (256 * 2)
+#define ENABLE_JOBDATAS_RAWDATA TRUE
+
CJobDataS::CJobDataS()
{
m_nCassetteSequenceNo = 0;
@@ -25,11 +29,19 @@
m_nSourceSlotNo = 0;
m_nTargetPortNo = 0;
m_nTargetSlotNo = 0;
+ m_pRawData = nullptr;
+ if (ENABLE_JOBDATAS_RAWDATA) {
+ m_pRawData = new char[JOBDATAS_SIZE];
+ serialize(m_pRawData, JOBDATAS_SIZE);
+ }
}
CJobDataS::~CJobDataS()
{
-
+ if (m_pRawData != nullptr) {
+ delete[] m_pRawData;
+ m_pRawData = nullptr;
+ }
}
int CJobDataS::getCassetteSequenceNo()
@@ -94,12 +106,138 @@
std::string& CJobDataS::getGlass2Id()
{
- return m_strGlass1Id;
+ return m_strGlass2Id;
}
void CJobDataS::setGlass2Id(const char* pszId)
{
m_strGlass2Id = pszId;
+ }
+
+ int CJobDataS::getJobType()
+ {
+ return m_nJobType;
+ }
+
+ void CJobDataS::setJobType(int type)
+ {
+ m_nJobType = type;
+ }
+
+ int CJobDataS::getMaterialsType()
+ {
+ return m_nMaterialsType;
+ }
+
+ void CJobDataS::setMaterialsType(int type)
+ {
+ m_nMaterialsType = type;
+ }
+
+ int CJobDataS::getProductType()
+ {
+ return m_nProductType;
+ }
+
+ void CJobDataS::setProductType(int type)
+ {
+ m_nProductType = type;
+ }
+
+ int CJobDataS::getDummyType()
+ {
+ return m_nDummyType;
+ }
+
+ void CJobDataS::setDummyType(int type)
+ {
+ m_nDummyType = type;
+ }
+
+ int CJobDataS::getSkipFlag()
+ {
+ return m_nSkipFlag;
+ }
+
+ void CJobDataS::setSkipFlag(int flag)
+ {
+ m_nSkipFlag = flag;
+ }
+
+ int CJobDataS::getProcessFlag()
+ {
+ return m_nProcessFlag;
+ }
+
+ void CJobDataS::setProcessFlag(int flag)
+ {
+ m_nProcessFlag = flag;
+ }
+
+ int CJobDataS::getProcessResonCode()
+ {
+ return m_nProcessResonCode;
+ }
+
+ void CJobDataS::setProcessResonCode(int code)
+ {
+ m_nProcessResonCode = code;
+ }
+
+ int CJobDataS::getLastGlassFlag()
+ {
+ return m_nLastGlassFlag;
+ }
+
+ void CJobDataS::setLastGlassFlag(int flag)
+ {
+ m_nLastGlassFlag = flag;
+ }
+
+ int CJobDataS::getFirstGlassFlag()
+ {
+ return m_nFirstGlassFlag;
+ }
+
+ void CJobDataS::setFirstGlassFlag(int flag)
+ {
+ m_nFirstGlassFlag = flag;
+ }
+
+ int CJobDataS::getQTime(int index)
+ {
+ if (0 <= index && index <= 2) {
+ return m_nQTime[index];
+ }
+
+ return 0;
+ }
+
+ void CJobDataS::setQTime(int index, int time)
+ {
+ if (0 <= index && index <= 2) {
+ m_nQTime[index] = time;
+ }
+ }
+
+ int CJobDataS::getQTimeOverFlag()
+ {
+ return m_nQTimeOverFlag;
+ }
+
+ void CJobDataS::setQTimeOverFlag(int flag)
+ {
+ m_nQTimeOverFlag = flag;
+ }
+
+ int CJobDataS::getMasterRecipe()
+ {
+ return m_nMasterRecipe;
+ }
+
+ void CJobDataS::setMasterRecipe(int recipe)
+ {
+ m_nMasterRecipe = recipe;
}
std::string& CJobDataS::getProductRecipeId()
@@ -201,4 +339,321 @@
{
m_nTargetSlotNo = no;
}
+
+ int CJobDataS::serialize(char* pszBuffer, int nBufferSize)
+ {
+ if (nBufferSize < 256 * 2) return -1;
+
+ int index = 0;
+ memcpy(&pszBuffer[index], &m_nCassetteSequenceNo, sizeof(short));
+ index += sizeof(short);
+
+ memcpy(&pszBuffer[index], &m_nJobSequenceNo, sizeof(short));
+ index += sizeof(short);
+
+ int strLen = min(40, (int)m_strLotId.size());
+ memcpy(&pszBuffer[index], m_strLotId.c_str(), strLen);
+ index += 40;
+
+ strLen = min(20, (int)m_strProductId.size());
+ memcpy(&pszBuffer[index], m_strProductId.c_str(), strLen);
+ index += 20;
+
+ strLen = min(20, (int)m_strOperationId.size());
+ memcpy(&pszBuffer[index], m_strOperationId.c_str(), strLen);
+ index += 20;
+
+ strLen = min(20, (int)m_strGlass1Id.size());
+ memcpy(&pszBuffer[index], m_strGlass1Id.c_str(), strLen);
+ index += 20;
+
+ strLen = min(20, (int)m_strGlass2Id.size());
+ memcpy(&pszBuffer[index], m_strGlass2Id.c_str(), strLen);
+ index += 20;
+
+ memcpy(&pszBuffer[index], &m_nJobType, sizeof(short));
+ index += sizeof(short);
+
+ memcpy(&pszBuffer[index], &m_nMaterialsType, sizeof(short));
+ index += sizeof(short);
+
+ memcpy(&pszBuffer[index], &m_nProductType, sizeof(short));
+ index += sizeof(short);
+
+ memcpy(&pszBuffer[index], &m_nDummyType, sizeof(short));
+ index += sizeof(short);
+
+ memcpy(&pszBuffer[index], &m_nSkipFlag, sizeof(int));
+ index += sizeof(int);
+
+ memcpy(&pszBuffer[index], &m_nProcessFlag, sizeof(int));
+ index += sizeof(int);
+
+ memcpy(&pszBuffer[index], &m_nProcessResonCode, sizeof(short));
+ index += sizeof(short);
+
+ memcpy(&pszBuffer[index], &m_nLastGlassFlag, sizeof(short));
+ index += sizeof(short);
+
+ memcpy(&pszBuffer[index], &m_nFirstGlassFlag, sizeof(short));
+ index += sizeof(short);
+
+ memcpy(&pszBuffer[index], &m_nLastGlassFlag, sizeof(short));
+ index += sizeof(short);
+
+ memcpy(&pszBuffer[index], &m_nQTime[0], sizeof(short));
+ index += sizeof(short);
+
+ memcpy(&pszBuffer[index], &m_nQTime[1], sizeof(short));
+ index += sizeof(short);
+
+ memcpy(&pszBuffer[index], &m_nQTime[2], sizeof(short));
+ index += sizeof(short);
+
+ memcpy(&pszBuffer[index], &m_nQTimeOverFlag, sizeof(short));
+ index += sizeof(short);
+
+ memcpy(&pszBuffer[index], &m_nMasterRecipe, sizeof(short));
+ index += sizeof(short);
+
+ strLen = min(10, (int)m_strProductRecipeId.size());
+ memcpy(&pszBuffer[index], m_strProductRecipeId.c_str(), strLen);
+ index += 10;
+
+ strLen = min(10, (int)m_strPCode.size());
+ memcpy(&pszBuffer[index], m_strPCode.c_str(), strLen);
+ index += 10;
+
+ strLen = min(10, (int)m_strUseType.size());
+ memcpy(&pszBuffer[index], m_strUseType.c_str(), strLen);
+ index += 10;
+
+ strLen = min(80, (int)m_strPanelMeasure.size());
+ memcpy(&pszBuffer[index], m_strPanelMeasure.c_str(), strLen);
+ index += 80;
+
+ memcpy(&pszBuffer[index], &m_nMode, sizeof(short));
+ index += sizeof(short);
+
+ memcpy(&pszBuffer[index], &m_nSlotUnitSelectFlag, sizeof(short));
+ index += sizeof(short);
+
+ memcpy(&pszBuffer[index], &m_nSourcePortNo, sizeof(short));
+ index += sizeof(short);
+
+ memcpy(&pszBuffer[index], &m_nSourceSlotNo, sizeof(short));
+ index += sizeof(short);
+
+ memcpy(&pszBuffer[index], &m_nTargetPortNo, sizeof(short));
+ index += sizeof(short);
+
+ memcpy(&pszBuffer[index], &m_nTargetSlotNo, sizeof(short));
+ index += sizeof(short);
+
+ return 256 * 2;
+ }
+
+ int CJobDataS::unserialize(const char* pszBuffer, int nBufferSize)
+ {
+ if (nBufferSize < 256 * 2) return -1;
+
+ int index = 0;
+ memcpy(&m_nCassetteSequenceNo, &pszBuffer[index], sizeof(short));
+ index += sizeof(short);
+
+ memcpy(&m_nJobSequenceNo, &pszBuffer[index], sizeof(short));
+ index += sizeof(short);
+
+ CToolUnits::convertString(&pszBuffer[index], 40, m_strLotId);
+ index += 40;
+
+ CToolUnits::convertString(&pszBuffer[index], 20, m_strProductId);
+ index += 20;
+
+ CToolUnits::convertString(&pszBuffer[index], 20, m_strOperationId);
+ index += 20;
+
+ CToolUnits::convertString(&pszBuffer[index], 20, m_strGlass1Id);
+ index += 20;
+
+ CToolUnits::convertString(&pszBuffer[index], 20, m_strGlass2Id);
+ index += 20;
+
+ memcpy(&m_nJobType, &pszBuffer[index], sizeof(short));
+ index += sizeof(short);
+
+ memcpy(&m_nMaterialsType, &pszBuffer[index], sizeof(short));
+ index += sizeof(short);
+
+ memcpy(&m_nProductType, &pszBuffer[index], sizeof(short));
+ index += sizeof(short);
+
+ memcpy(&m_nDummyType, &pszBuffer[index], sizeof(short));
+ index += sizeof(short);
+
+ memcpy(&m_nSkipFlag, &pszBuffer[index], sizeof(int));
+ index += sizeof(int);
+
+ memcpy(&m_nProcessFlag, &pszBuffer[index], sizeof(int));
+ index += sizeof(int);
+
+ memcpy(&m_nProcessResonCode, &pszBuffer[index], sizeof(short));
+ index += sizeof(short);
+
+ memcpy(&m_nLastGlassFlag, &pszBuffer[index], sizeof(short));
+ index += sizeof(short);
+
+ memcpy(&m_nFirstGlassFlag, &pszBuffer[index], sizeof(short));
+ index += sizeof(short);
+
+ memcpy(&m_nQTime[0], &pszBuffer[index], sizeof(short));
+ index += sizeof(short);
+
+ memcpy(&m_nQTime[1], &pszBuffer[index], sizeof(short));
+ index += sizeof(int);
+
+ memcpy(&m_nQTime[2], &pszBuffer[index], sizeof(int));
+ index += sizeof(short);
+
+ memcpy(&m_nQTimeOverFlag, &pszBuffer[index], sizeof(short));
+ index += sizeof(short);
+
+ memcpy(&m_nMasterRecipe, &pszBuffer[index], sizeof(short));
+ index += sizeof(short);
+
+ CToolUnits::convertString(&pszBuffer[index], 10, m_strProductRecipeId);
+ index += 10;
+
+ CToolUnits::convertString(&pszBuffer[index], 10, m_strProductRecipeId);
+ index += 10;
+
+ CToolUnits::convertString(&pszBuffer[index], 10, m_strProductRecipeId);
+ index += 10;
+
+ CToolUnits::convertString(&pszBuffer[index], 80, m_strProductRecipeId);
+ index += 80;
+
+ memcpy(&m_nMode, &pszBuffer[index], sizeof(short));
+ index += sizeof(short);
+
+ memcpy(&m_nSlotUnitSelectFlag, &pszBuffer[index], sizeof(short));
+ index += sizeof(short);
+
+ memcpy(&m_nSourcePortNo, &pszBuffer[index], sizeof(short));
+ index += sizeof(short);
+
+ memcpy(&m_nSourceSlotNo, &pszBuffer[index], sizeof(short));
+ index += sizeof(short);
+
+ memcpy(&m_nTargetPortNo, &pszBuffer[index], sizeof(short));
+ index += sizeof(short);
+
+ memcpy(&m_nTargetSlotNo, &pszBuffer[index], sizeof(short));
+ index += sizeof(short);
+
+
+ // 缓存原始数据
+ if (m_pRawData != nullptr) {
+ memcpy(m_pRawData, pszBuffer, JOBDATAS_SIZE);
+ }
+
+
+ return 256 * 2;
+ }
+
+ void CJobDataS::getAttributeVector(CAttributeVector& attrubutes, int beginWeight)
+ {
+ unsigned int weight = beginWeight;
+ std::string strTemp;
+
+ attrubutes.addAttribute(new CAttribute("CassetteSequenceNo",
+ std::to_string(getCassetteSequenceNo()).c_str(), "", weight++));
+
+ attrubutes.addAttribute(new CAttribute("JobSequenceNo",
+ std::to_string(getJobSequenceNo()).c_str(), "", weight++));
+
+ attrubutes.addAttribute(new CAttribute("LotId",
+ getLotId().c_str(), "", weight++));
+
+ attrubutes.addAttribute(new CAttribute("ProductId",
+ getProductId().c_str(), "", weight++));
+
+ attrubutes.addAttribute(new CAttribute("OperationId",
+ getOperationId().c_str(), "", weight++));
+
+ attrubutes.addAttribute(new CAttribute("Glass1Id",
+ getGlass1Id().c_str(), "", weight++));
+
+ attrubutes.addAttribute(new CAttribute("Glass2Id",
+ getGlass2Id().c_str(), "", weight++));
+
+ attrubutes.addAttribute(new CAttribute("JobType",
+ std::to_string(getJobType()).c_str(), "", weight++));
+
+ attrubutes.addAttribute(new CAttribute("MaterialsType",
+ std::to_string(getMaterialsType()).c_str(), "", weight++));
+
+ attrubutes.addAttribute(new CAttribute("ProductType",
+ std::to_string(getProductType()).c_str(), "", weight++));
+
+ attrubutes.addAttribute(new CAttribute("DummyType",
+ std::to_string(getDummyType()).c_str(), "", weight++));
+
+ attrubutes.addAttribute(new CAttribute("SkipFlag",
+ std::to_string(getSkipFlag()).c_str(), "", weight++));
+
+ attrubutes.addAttribute(new CAttribute("ProcessFlag",
+ std::to_string(getProcessFlag()).c_str(), "", weight++));
+
+ attrubutes.addAttribute(new CAttribute("ProcessResonCode",
+ std::to_string(getProcessResonCode()).c_str(), "", weight++));
+
+ attrubutes.addAttribute(new CAttribute("LastGlassFlag",
+ std::to_string(getLastGlassFlag()).c_str(), "", weight++));
+
+ attrubutes.addAttribute(new CAttribute("FirstGlassFlag",
+ std::to_string(getFirstGlassFlag()).c_str(), "", weight++));
+
+ attrubutes.addAttribute(new CAttribute("QTime1",
+ std::to_string(getQTime(0)).c_str(), "", weight++));
+
+ attrubutes.addAttribute(new CAttribute("QTime2",
+ std::to_string(getQTime(1)).c_str(), "", weight++));
+
+ attrubutes.addAttribute(new CAttribute("QTime3",
+ std::to_string(getQTime(2)).c_str(), "", weight++));
+
+ attrubutes.addAttribute(new CAttribute("QTimeOverFlag",
+ std::to_string(getQTimeOverFlag()).c_str(), "", weight++));
+
+ attrubutes.addAttribute(new CAttribute("MasterRecipe",
+ std::to_string(getMasterRecipe()).c_str(), "", weight++));
+
+ attrubutes.addAttribute(new CAttribute("ProductRecipeId",
+ getProductRecipeId().c_str(), "", weight++));
+
+ attrubutes.addAttribute(new CAttribute("PCode",
+ getPCode().c_str(), "", weight++));
+
+ attrubutes.addAttribute(new CAttribute("UseType",
+ getUseType().c_str(), "", weight++));
+
+ attrubutes.addAttribute(new CAttribute("PanelMeasure",
+ getPanelMeasure().c_str(), "", weight++));
+
+ attrubutes.addAttribute(new CAttribute("SlotUnitSelectFlag",
+ std::to_string(getSlotUnitSelectFlag()).c_str(), "", weight++));
+
+ attrubutes.addAttribute(new CAttribute("SourcePortNo",
+ std::to_string(getSourcePortNo()).c_str(), "", weight++));
+
+ attrubutes.addAttribute(new CAttribute("SourceSlotNo",
+ std::to_string(getSourceSlotNo()).c_str(), "", weight++));
+
+ attrubutes.addAttribute(new CAttribute("TargetPortNo",
+ std::to_string(getTargetPortNo()).c_str(), "", weight++));
+
+ attrubutes.addAttribute(new CAttribute("TargetSlotNo",
+ std::to_string(getTargetSlotNo()).c_str(), "", weight++));
+ }
}
--
Gitblit v1.9.3