/// <summary> /// Get A95_1 產業別對應Ticker補登檔 /// </summary> /// <param name="bondNumber"></param> /// <returns></returns> public List <A95_1ViewModel> getA95_1(string bondNumber) { List <A95_1ViewModel> result = new List <A95_1ViewModel>(); using (IFRS9DBEntities db = new IFRS9DBEntities()) { result = db.Assessment_Sub_Kind_Ticker.AsNoTracking() .Where(x => x.Bond_Number == bondNumber, !bondNumber.IsNullOrWhiteSpace()) .AsEnumerable() .Select(x => new A95_1ViewModel() { Bond_Number = x.Bond_Number, Bloomberg_Ticker = x.Bloomberg_Ticker, Security_Des = x.Security_Des, Processing_Date = TypeTransfer.dateTimeNTimeSpanNToString(x.LastUpdate_Date, x.LastUpdate_Time), Processing_User = x.LastUpdate_User }) .ToList(); } return(result); }