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); }