public static void InitData(data.importDS.importPriceRow row)
{
row.onDate = common.Consts.constNullDate;
row.stockExchange = "";
row.stockCode = "";
row.closePrice = 0;
row.volume = 0;
row.openPrice = 0;
row.highPrice = 0;
row.closePrice = 0;
}
public void UpdateData(data.importDS.importPriceRow row)
{
if (lastTime != row.onDate.Date)
{
Reset();
lastTime = row.onDate.Date;
}
data.baseDS.priceDataSumRow priceRow = GetData(row);
if (priceRow == null)
{
priceRow = priceSumTbl.NewpriceDataSumRow();
commonClass.AppLibs.InitData(priceRow);
priceRow.type = timeType;
priceRow.stockCode = row.stockCode;
priceRow.onDate = row.onDate.Date;
priceSumTbl.AddpriceDataSumRow(priceRow);
}
//Now only volume need to be processed
priceRow.volume = row.volume;
priceRow.highPrice = row.highPrice;
priceRow.lowPrice = row.lowPrice;
priceRow.openPrice = row.openPrice;
priceRow.closePrice = row.closePrice;
}
public static void GenPriceData(string stockCode)
{
DateTime dt = DateTime.Now;
decimal lastHighPrice = 0, lastLowPrice = 0, lastClosePrice = 0, lastOpenPrice = 0, lastVolume = 0;
data.baseDS.priceDataSumRow dayPriceRow = myDailyPrice.GetData(stockCode, dt);
if (dayPriceRow == null)
{
data.baseDS.priceDataRow priceRow = application.DbAccess.GetLastPriceData(stockCode);
lastHighPrice = priceRow.highPrice;
lastLowPrice = priceRow.lowPrice;
lastClosePrice = priceRow.closePrice;
lastOpenPrice = priceRow.openPrice;
lastVolume = 0;
}
else
{
lastHighPrice = dayPriceRow.highPrice;
lastLowPrice = dayPriceRow.lowPrice;
lastClosePrice = dayPriceRow.closePrice;
lastOpenPrice = dayPriceRow.openPrice;
lastVolume = dayPriceRow.volume;
}
priceDataTbl.Clear();
importPriceTbl.Clear();
data.importDS.importPriceRow importRow = importPriceTbl.NewimportPriceRow();
application.DbAccess.InitData(importRow);
decimal highPrice = lastHighPrice + lastHighPrice * (decimal)common.system.Random(-4, 5) / 100;
decimal lowPrice = lastLowPrice + lastLowPrice * (decimal)common.system.Random(-4, 5) / 100;
decimal closePrice = lastClosePrice + lastClosePrice * (decimal)common.system.Random(-5, 5) / 100;
importRow.openPrice = lastOpenPrice;
importRow.highPrice = Math.Max(lastHighPrice, highPrice);
if (lowPrice < importRow.highPrice)
{
importRow.lowPrice = lowPrice;
}
else
{
importRow.lowPrice = importRow.highPrice;
}
if (closePrice >= importRow.lowPrice && closePrice <= importRow.highPrice)
{
importRow.closePrice = closePrice;
}
else
{
importRow.closePrice = (importRow.lowPrice + importRow.highPrice) / 2;
}
importRow.volume = lastVolume + common.system.Random(0, 100);
importRow.onDate = dt;
importRow.stockCode = stockCode;
importPriceTbl.AddimportPriceRow(importRow);
imports.libs.AddImportPrice(importPriceTbl, priceDataTbl);
application.DbAccess.UpdateData(priceDataTbl);
// In VN culture : start of week is Monday (not Sunday)
imports.libs.AggregatePriceData(priceDataTbl, vnCulture, null);
myDailyPrice.UpdateData(importRow);
}
public data.baseDS.priceDataSumRow GetData(data.importDS.importPriceRow row)
{
return(FindAndCache(priceSumTbl, row.stockCode, timeType, row.onDate.Date));
}
/// <summary>
/// Import data from URL to tables : importPrice
/// The function also detect and add new companies to the database
/// </summary>
/// <param name="url">URL to get data</param>
/// <param name="priceMeta">meta describe the webpage structure</param>
/// <param name="stockExchangeCode">stock exchange code of imported data </param>
/// <param name="importPriceTbl"> where to store imported data </param>
private static data.importDS.importPriceDataTable GetPriceFromURL(DateTime updateTime, string url, importPriceMeta priceMeta, string marketCode)
{
data.importDS.importPriceDataTable importPriceTbl = new data.importDS.importPriceDataTable();
common.extSortedList mappingList = CreateMapping(priceMeta, importPriceTbl);
data.baseDS.priceDataRow priceDataRow;
// Get the URL specified
var webGet = new HtmlWeb();
var document = webGet.Load(url);
// Get <a> tags that have a href attribute and non-whitespace inner text
var linksOnPage = from item in document.DocumentNode.Descendants()
where item.Name == "td" && item.Attributes["id"] == null
select new
{
Text = item.InnerText
};
bool fError = false;
int igmoreRowCount = 0, columnCount = 0;
decimal val = 0;
data.importDS.importPriceRow importRow = null;
string stockCode;
foreach (var item in linksOnPage)
{
//Check whether to ignore some items at the first
if (++igmoreRowCount <= priceMeta.noRowIgnore)
{
continue;
}
if (fError)
{
break;
}
if (columnCount == priceMeta.startAtColId)
{
stockCode = item.Text.Trim();
importRow = importPriceTbl.NewimportPriceRow();
application.DbAccess.InitData(importRow);
importRow.onDate = updateTime;
importRow.stockCode = stockCode;
importRow.stockExchange = marketCode;
importRow.isTotalVolume = true;
columnCount++;
continue;
}
//Last column
if (columnCount == priceMeta.endAtColId)
{
if (importRow.closePrice > 0)
{
if (importRow.openPrice == 0)
{
priceDataRow = application.DbAccess.GetLastPriceData(importRow.stockCode);
if (priceDataRow == null)
{
importRow.openPrice = importRow.lowPrice;
}
else
{
importRow.openPrice = priceDataRow.closePrice;
}
}
importPriceTbl.AddimportPriceRow(importRow);
}
else
{
importRow.CancelEdit();
}
columnCount = 0;
continue;
}
object obj = mappingList.GetValue(columnCount.ToString());
if (obj != null)
{
val = 0; common.system.StrToDecimal(item.Text, libs.CultureInfoUS, out val);
importRow[(string)obj] = val;
}
columnCount++;
}
return(importPriceTbl);
}
public static void UpdateData(data.importDS.importPriceRow row)
{
importPriceTA.Update(row);
row.AcceptChanges();
}
