private List<DdeKursAdvisor> GetAllAdvisors() { var advisors = new List<DdeKursAdvisor>(); Range excelRange = _xlWorkSheet.UsedRange; var valueArray = (object[,])excelRange.get_Value( XlRangeValueDataType.xlRangeValueDefault); int usdLength = KursProviderConfig.BASE_USD_ROW_END - KursProviderConfig.BASE_USD_ROW_START + 1; for (int i = 0; i < usdLength; i++) { var kurs = new Kurs { currency = valueArray[22 + i, 1].ToString().TrimEnd('='), bid = ConvertToDoubleTwoDecimal(valueArray[22 + i, 2]), ask = ConvertToDoubleTwoDecimal(valueArray[22 + i, 3]) }; var bidCell = string.Format("R{0}C2", KursProviderConfig.BASE_USD_ROW_START + i); var askCell = string.Format("R{0}C3", KursProviderConfig.BASE_USD_ROW_START + i); advisors.Add(new DdeKursAdvisor(kurs, bidCell, askCell)); } int idrLength = KursProviderConfig.BASE_IDR_ROW_END - KursProviderConfig.BASE_IDR_ROW_START + 1 ; for (int i = 0; i < idrLength; i++) { var kurs = new Kurs { currency = valueArray[44 + i, 1].ToString().TrimEnd('='), bid = ConvertToDoubleTwoDecimal(valueArray[44 + i, 2]), ask = ConvertToDoubleTwoDecimal(valueArray[44 + i, 3]) }; var bidCell = string.Format("R{0}C2", KursProviderConfig.BASE_IDR_ROW_START + i); var askCell = string.Format("R{0}C3", KursProviderConfig.BASE_IDR_ROW_START + i); advisors.Add(new DdeKursAdvisor(kurs, bidCell, askCell)); } return advisors; }
public DdeKursAdvisor(Kurs kurs, string bidCell, string askCell) { _kurs = kurs; _bidCell = bidCell; _askCell = askCell; }
public DdeKursAdvisor(string currency, string bidCell, string askCell) { _bidCell = bidCell; _askCell = askCell; _kurs = new Kurs {currency = currency}; }