/// <summary> /// Select record of underlying in DB with korea name and name type(FM1, FM2 or Drop) /// </summary> /// <param name="koreaName"></param> /// <returns></returns> public static KoreaUnderlyingInfo SelectUnderlying(string koreaName, KoreaNameType type) { string condition = ""; if (type.Equals(KoreaNameType.KoreaName)) { condition = "where KoreaName =N'" + koreaName + "'"; } else if (type.Equals(KoreaNameType.KoreaNameForFM2)) { condition = "where KoreaNameFM2 =N'" + koreaName + "'or KoreaNameDrop =N'" + koreaName + "' or UnderlyingName =N'" + koreaName + "'"; } else if (type.Equals(KoreaNameType.KoreaNameForDrop)) { condition = "where KoreaNameFM2 =N'" + koreaName + "'or KoreaNameDrop =N'" + koreaName + "' or UnderlyingName =N'" + koreaName + "'"; } else { condition = "where KoreaNameFM2 =N'" + koreaName + "'or KoreaNameDrop =N'" + koreaName + "' or UnderlyingName =N'" + koreaName + "'"; } DataTable dt = ManagerBase.Select(ETI_KOREA_UNDERLYING_TABLE_NAME, new string[] { "*" }, condition); if (dt == null || dt.Rows.Count == 0) { return(null); } KoreaUnderlyingInfo underlying = new KoreaUnderlyingInfo(); DataRow dr = dt.Rows[0]; underlying.BNDUnderlying = Convert.ToString(dr["BNDUnderlying"]); underlying.BodyGroupCommonName = Convert.ToString(dr["BodyGroupCommonName"]); underlying.IDNDisplayNamePart = Convert.ToString(dr["IDNDisplayNamePart"]); underlying.KoreaName = Convert.ToString(dr["KoreaName"]); underlying.KoreaNameDrop = Convert.ToString(dr["KoreaNameDrop"]); underlying.KoreaNameFM2 = Convert.ToString(dr["KoreaNameFM2"]); underlying.NDATCUnderlyingTitle = Convert.ToString(dr["NDATCUnderlyingTitle"]); underlying.QACommonNamePart = Convert.ToString(dr["QACommonNamePart"]); underlying.UnderlyingName = Convert.ToString(dr["UnderlyingName"]); underlying.UnderlyingRIC = Convert.ToString(dr["UnderlyingRIC"]); underlying.ISIN = Convert.ToString(dr["ISIN"]); return(underlying); }
/// <summary> /// Select a record of Korea Issuer with Korea issuer code2 /// </summary> /// <param name="issuerCode2">Korea oissuer code2</param> /// <returns></returns> public static KoreaIssuerInfo SelectIssuerByIssuerCode2(string issuerCode2) { string condition = "where IssuerCode2 =N'" + issuerCode2 + "'"; DataTable dt = ManagerBase.Select(ETI_KOREA_ISSUER_TABLE_NAME, new string[] { "*" }, condition); if (dt == null || dt.Rows.Count == 0) { return(null); } KoreaIssuerInfo issuer = new KoreaIssuerInfo(); DataRow dr = dt.Rows[0]; issuer.KoreaIssuerName = Convert.ToString(dr["KoreaIssuerName"]); issuer.BodyGroupCommonName = Convert.ToString(dr["BodyGroupCommonName"]); issuer.IssuerCode2 = Convert.ToString(dr["IssuerCode2"]); issuer.IssuerCode4 = Convert.ToString(dr["IssuerCode4"]); issuer.IssuerCompanyName = Convert.ToString(dr["IssuerCompanyName"]); issuer.IssuerName5 = Convert.ToString(dr["IssuerName5"]); issuer.NDAIssuerOrgid = Convert.ToString(dr["NDAIssuerOrgid"]); issuer.NDATCIssuerTitle = Convert.ToString(dr["NDATCIssuerTitle"]); return(issuer); }
public static KoreaUnderlyingInfo SelectUnderlyingByISIN(string isin) { string condition = "where ISIN ='" + isin + "'"; DataTable dt = ManagerBase.Select(ETI_KOREA_UNDERLYING_TABLE_NAME, new string[] { "*" }, condition); if (dt == null || dt.Rows.Count == 0) { return(null); } KoreaUnderlyingInfo underlying = new KoreaUnderlyingInfo(); DataRow dr = dt.Rows[0]; underlying.BNDUnderlying = Convert.ToString(dr["BNDUnderlying"]); underlying.BodyGroupCommonName = Convert.ToString(dr["BodyGroupCommonName"]); underlying.IDNDisplayNamePart = Convert.ToString(dr["IDNDisplayNamePart"]); underlying.KoreaName = Convert.ToString(dr["KoreaName"]); underlying.KoreaNameDrop = Convert.ToString(dr["KoreaNameDrop"]); underlying.KoreaNameFM2 = Convert.ToString(dr["KoreaNameFM2"]); underlying.NDATCUnderlyingTitle = Convert.ToString(dr["NDATCUnderlyingTitle"]); underlying.QACommonNamePart = Convert.ToString(dr["QACommonNamePart"]); underlying.UnderlyingName = Convert.ToString(dr["UnderlyingName"]); underlying.UnderlyingRIC = Convert.ToString(dr["UnderlyingRIC"]); return(underlying); }
public static HKUnderlyingInfo SelectUnderlyingInfoByUnderlying(string underlying) { try { if ((underlying + string.Empty).Trim().Length == 0) { return(null); } string where = string.Format("where Underlying = '{0}'", underlying); DataTable dt = ManagerBase.Select(ETI_UNDERLYING_TABLE_NAME, new string[] { "*" }, where); if (dt == null || dt.Rows.Count <= 0) { return(null); } DataRow dr = dt.Rows[0]; HKUnderlyingInfo hkUnderlying = new HKUnderlyingInfo(); hkUnderlying.ID = Convert.ToString(dr["ID"]); hkUnderlying.Underlying = Convert.ToString(dr["Underlying"]); hkUnderlying.BCAST_REF = Convert.ToString(dr["BCAST_REF"]); hkUnderlying.INSTMOD_GN_TX20_6 = Convert.ToString(dr["INSTMOD_GN_TX20_6"]); hkUnderlying.INSTMOD_GN_TX20_7 = Convert.ToString(dr["INSTMOD_GN_TX20_7"]); hkUnderlying.INSTMOD_GN_TX20_12 = Convert.ToString(dr["INSTMOD_GN_TX20_12"]); hkUnderlying.INSTMOD_LONGLINK2 = Convert.ToString(dr["INSTMOD_LONGLINK2"]); hkUnderlying.INSTMOD_LONGLINK6 = Convert.ToString(dr["INSTMOD_LONGLINK6"]); hkUnderlying.INSTMOD_UNDERLYING = Convert.ToString(dr["INSTMOD_UNDERLYING"]); return(hkUnderlying); } catch (Exception) { return(null); } }