You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
40 lines
1011 B
40 lines
1011 B
#include "xhighstocks.h"
|
|
|
|
XHighStocks::XHighStocks(QObject *parent) : QObject(parent)
|
|
{
|
|
|
|
}
|
|
|
|
XHighStocks::~XHighStocks()
|
|
{
|
|
|
|
}
|
|
|
|
QString XHighStocks::toInsertSql(_HighStocksParam stock)
|
|
{
|
|
QString sql = QString("insert into highstocks (code, name, tradeDay,open,close,high,differRange,volumn,BLEMIND2,hpDateP,isHighRangeP) "
|
|
"SELECT '%1', '%2', '%3',%4,%5,%6,%7,%8,'%9','%10',%11 from DUAL where not exists(select code from highstocks where code = '%1' and tradeDay = '%3' and open = %4);")
|
|
.arg(stock.code)
|
|
.arg(stock.name)
|
|
.arg(stock.tradeDay)
|
|
.arg(stock.open)
|
|
.arg(stock.close)
|
|
.arg(stock.high)
|
|
.arg(stock.differRange)
|
|
.arg(stock.volumn)
|
|
.arg(stock.BLEMIND2)
|
|
.arg(stock.HpDateP)
|
|
.arg(stock.isHighRangeP);
|
|
return sql;
|
|
}
|
|
|
|
QString XHighStocks::toDeleteSql()
|
|
{
|
|
return "";
|
|
}
|
|
|
|
QString XHighStocks::toQuerySql()
|
|
{
|
|
return "";
|
|
}
|