#include "PartPosBean.h"



PartPosBean::PartPosBean()
	:m_JobId("")
	,m_PartId(0)
	,m_XOffset(0.0f)
	,m_YOffset(0.0f)
	,m_RotateAngle(0.0f)
	,m_Radians(0.0f)
	,m_PartCenterX(0.0f)
	,m_PartCenterY(0.0f)
	
{
	m_SelectDataPoint1[0] = 0.0f;
	m_SelectDataPoint1[1] = 0.0f;
	m_SelectDataPoint2[0] = 0.0f;
	m_SelectDataPoint2[1] = 0.0f;
	m_SelectImagePoint1[0] = 0.0f;
	m_SelectImagePoint1[1] = 0.0f;
	m_SelectImagePoint2[0] = 0.0f;
	m_SelectImagePoint2[1] = 0.0f;
}


PartPosBean::~PartPosBean()
{
}

void PartPosBean::CreateIfNoExist(SQLite::Database* db)
{
	if (db == nullptr)return;
	if (db->tableExists(CONFIG_NAME))return;
	char buffer[1024];
	string createsql = "CREATE TABLE IF NOT EXISTS %s(%s VARCHAR(128),%s INTEGER,%s REAL,%s REAL,%s REAL)";
	sprintf_s(buffer, sizeof(buffer), createsql.c_str(),
		CONFIG_NAME.c_str(),
		FIELD_JOB_ID.c_str(),
		FIELD_PART_ID.c_str(),
		FIELD_X_OFFSET.c_str(),
		FIELD_Y_OFFSET.c_str(),
		FIELD_ROTATE_ANGLE.c_str()
	);
	db->exec(buffer);

	sprintf_s(buffer, sizeof(buffer), "CREATE INDEX IF NOT EXISTS idx_%s_%s ON %s (%s)",
		CONFIG_NAME.c_str(),
		FIELD_JOB_ID.c_str(),
		CONFIG_NAME.c_str(),
		FIELD_JOB_ID.c_str()
	);
	db->exec(buffer);

}

const string PartPosBean::CONFIG_NAME="PartPosCfg";
const string PartPosBean::FIELD_JOB_ID="JobId";
const string PartPosBean::FIELD_PART_ID="PartId";
const string PartPosBean::FIELD_X_OFFSET="XOffset";
const string PartPosBean::FIELD_Y_OFFSET="YOffset";
const string PartPosBean::FIELD_ROTATE_ANGLE="RotateAngle";