repos_deltae_auxiliary_tool/Source/OGCAssistTool/OGCAssistTool/TableInfo.h

#ifndef __TABLE_INFO__
#define __TABLE_INFO__

// 订单表;
typedef struct __TB_ORDER__
{
	std::string strOrder;
	int nMode;						// 0=离线模式;1=在线模式;
	std::string strDeltaEType;
	std::string strDeltaEValue;
	std::string strCreateTime;
}TB_ORDER, *LPTB_ORDER;

typedef struct __TB_SN__
{
	std::string strOrder;
	std::string strSN;
	std::string strLine;
	std::string strStartTime;
	std::string strFinishedTime;
	int nElapsed;
	int nTestResult;
	DOUBLE dDeltaAVGEValue;
	std::string strDetails;
}TB_SN, *LPTB_SN;

// 创建表;
#define _CREATE_ORDER_ "CREATE TABLE DebugOrders(\
OrderID TEXT(32) NOT NULL, \
DEType TEXT(8) NOT NULL, \
DEValue REAL NOT NULL, \
Mode INTEGER NOT NULL,\
CreateTime TimeStamp NOT NULL DEFAULT (datetime('now','localtime'))), \
PRIMARY KEY(OrderID));"

#define _CREATE_SN_ "CREATE TABLE DebugSN(\
OrderID TEXT(32) NOT NULL, \
SN TEXT(32) NOT NULL, \
Line TEXT(8) NOT NULL, \
StartTime DATETIME NOT NULL, \
FinishTime DATETIME NOT NULL, \
ElapsedTime INTEGER NOT NULL,\
TestResult INTEGER NOT NULL, \
DEAvgValue REAL NOT NULL, \
Outcome TEXT NOT NULL, \
PRIMARY KEY(SN));"

// 插入记录;
#define _INSERT_ORDER_ "INSERT INTO DebugOrders(OrderID, DEType, DEValue, Mode) VALUES()"
#define _INSERT_SN_ ""

// 更新表;
#define _UPDATE_ORDER_ ""
#define _UPDATE_SN_ ""

// 查询表;
#define _SELECT_ORDER_ "SELECT OrderID, DEType, DEValue, Mode, CreateTime FROM DebugOrders"
#define _SELECT_SN_ "SELECT OrderID, SN,Line,StartTime,FinishTime,ElapsedTime,TestResult,DEAvgValue,Outcome FROM DebugSN"

// 删除记录;
#define _DELETE_ORDER_ ""
#define _DELETE_SN_ ""

#endif