public static tmpDS.dataVarrianceDataTable GetTopPriceVarrianceOfUser(DateTime beforeDate, string timeScaleCode, string userCode, int topN)
{
tmpDS.interestedCodeDataTable interestedCodeTbl = new tmpDS.interestedCodeDataTable();
DbAccess.LoadData(interestedCodeTbl, userCode);
tmpDS.dataVarrianceDataTable tmpDataTbl = GetPriceVarriance(beforeDate, timeScaleCode);
tmpDS.dataVarrianceRow dataRow;
DataView dataView = new DataView(tmpDataTbl);
dataView.Sort = tmpDataTbl.percentColumn + " DESC";
tmpDS.dataVarrianceDataTable dataTbl = new tmpDS.dataVarrianceDataTable();
for (int idx1 = 0, idx2 = 0; idx1 < dataView.Count && idx2 < topN; idx1++)
{
if (interestedCodeTbl.FindBycode((dataView[idx1].Row as tmpDS.dataVarrianceRow).code) == null)
{
continue;
}
dataRow = dataTbl.NewdataVarrianceRow();
dataRow.code = (dataView[idx1].Row as tmpDS.dataVarrianceRow).code;
dataRow.value = (dataView[idx1].Row as tmpDS.dataVarrianceRow).value;
dataRow.percent = (dataView[idx1].Row as tmpDS.dataVarrianceRow).percent;
dataTbl.AdddataVarrianceRow(dataRow);
idx2++;
}
return(dataTbl);
}
public static tmpDS.dataVarrianceDataTable GetTopPriceVarrianceOfUser(DateTime beforeDate, string timeScaleCode, string userCode, int topN)
{
tmpDS.interestedCodeDataTable interestedCodeTbl = new tmpDS.interestedCodeDataTable();
DbAccess.LoadData(interestedCodeTbl, userCode);
tmpDS.dataVarrianceDataTable tmpDataTbl = GetPriceVarriance(beforeDate, timeScaleCode);
tmpDS.dataVarrianceRow dataRow;
DataView dataView = new DataView(tmpDataTbl);
dataView.Sort = tmpDataTbl.percentColumn + " DESC";
tmpDS.dataVarrianceDataTable dataTbl = new tmpDS.dataVarrianceDataTable();
for (int idx1 = 0, idx2 = 0; idx1 < dataView.Count && idx2 < topN; idx1++)
{
if (interestedCodeTbl.FindBycode((dataView[idx1].Row as tmpDS.dataVarrianceRow).code) == null) continue;
dataRow = dataTbl.NewdataVarrianceRow();
dataRow.code = (dataView[idx1].Row as tmpDS.dataVarrianceRow).code;
dataRow.value = (dataView[idx1].Row as tmpDS.dataVarrianceRow).value;
dataRow.percent = (dataView[idx1].Row as tmpDS.dataVarrianceRow).percent;
dataTbl.AdddataVarrianceRow(dataRow);
idx2++;
}
return dataTbl;
}
public static void LoadData(tmpDS.interestedCodeDataTable tbl, string investorCode)
{
interestedCodeTA.ClearBeforeFill = false;
interestedCodeTA.FillByInvestor(tbl, investorCode);
}
