public static TWUnderlyingNameInfo GetByCode(string code)
{
if (string.IsNullOrEmpty(code))
{
return(null);
}
int codeNum;
if (!(int.TryParse(code, out codeNum)))
{
return(null);
}
string where = string.Format("where Code like '{0}.%'", code);
System.Data.DataTable dt = Select(ETI_TW_UNDERLYING_TABLE_NAME, new string[] { "*" }, where);
if (dt == null || dt.Rows.Count == 0)
{
return(null);
}
System.Data.DataRow dr = dt.Rows[0];
TWUnderlyingNameInfo info = new TWUnderlyingNameInfo();
info.ChineseChain = Convert.ToString(dr["ChineseChain"]);
info.EnglishDisplay = Convert.ToString(dr["EnglishDisplay"]);
info.OrganizationName = Convert.ToString(dr["OrganizationName"]);
info.UnderlyingRIC = Convert.ToString(dr["Code"]);
info.ChineseDisplay = Convert.ToString(dr["ChineseDisplay"]);
return(info);
}
public static int InsertNewUnderlying(TWUnderlyingNameInfo underlying)
{
if (underlying == null)
{
return(0);
}
string where = string.Format("where Code = '{0}'", underlying.UnderlyingRIC);
System.Data.DataTable dt = Select(ETI_TW_UNDERLYING_TABLE_NAME, new string[] { "*" }, where);
if (dt == null || dt.Rows.Count > 0)
{
return(0);
}
System.Data.DataRow dr = dt.NewRow();
dr["Code"] = underlying.UnderlyingRIC;
dr["OrganizationName"] = underlying.OrganizationName;
dr["EnglishDisplay"] = underlying.EnglishDisplay;
dr["ChineseDisplay"] = underlying.ChineseDisplay;
dr["ChineseChain"] = underlying.ChineseChain;
dt.Rows.Add(dr);
return(UpdateDbTable(dt, ETI_TW_UNDERLYING_TABLE_NAME));
}
public static TWUnderlyingNameInfo Prompt(string ric, string chineseDisplay, string underlyingCode)
{
UnderlyingAdd form = new UnderlyingAdd();
form.tbRIC.Text = ric;
form.tbUnderlyingCode.Text = underlyingCode;
form.tbChineseDisplay.Text = chineseDisplay;
form.ShowDialog();
if (form.DialogResult == System.Windows.Forms.DialogResult.OK)
{
string code = form.tbCode.Text.Trim();
string orgName = form.tbOrgName.Text.Trim();
string engName = form.tbEngName.Text.Trim();
string chineseChain = form.tbChineseChain.Text.Trim();
TWUnderlyingNameInfo underlying = new TWUnderlyingNameInfo();
underlying.UnderlyingRIC = code;
underlying.OrganizationName = orgName;
underlying.ChineseChain = chineseChain;
underlying.ChineseDisplay = chineseDisplay;
underlying.EnglishDisplay = engName;
return(underlying);
}
return(null);
}
public static TWUnderlyingNameInfo GetByRIC(string itemRIC)
{
using (SqlConnection conn = new SqlConnection(Config.ConnectionString))
{
if (conn.State != System.Data.ConnectionState.Open)
{
conn.Open();
}
using (SqlCommand comm = new SqlCommand())
{
comm.Connection = conn;
comm.CommandText = "select * from ETI_TW_UNDERLYING_NAME where UnderlyingRIC=" + itemRIC.Trim();
using (SqlDataReader dr = comm.ExecuteReader())
{
if (dr.HasRows && dr.Read())
{
TWUnderlyingNameInfo info = new TWUnderlyingNameInfo();
info.ChineseChain = Convert.ToString(dr["ChineseChain"]);
info.EnglishDisplay = Convert.ToString(dr["EnglishDisplay"]);
info.OrganizationName = Convert.ToString(dr["OrganizationName"]);
info.UnderlyingRIC = Convert.ToString(dr["Code"]);
info.ChineseDisplay = Convert.ToString(dr["ChineseDisplay"]);
return(info);
}
else
{
return(null);
//throw new Exception(string.Format("Cannot find TWUnderlyingNameInfo object with UnderlyingRIC: {0} in Table TWUnderlyingName", itemRIC));
}
}
}
}
}
