public void add(CommodityBasic c)
{
if (!cbList.Contains(c))
{
cbList.Add(c);
}
}
/*public static void updateWarrantUnderlying() {
* loadCommodityData();
* refreshCommodityBasics();
* }*/
public static CommodityBasicList GetCommodityBasics()
{
CommodityBasicList cBL = new CommodityBasicList();
try {
string sql = "SELECT [股票代號], [股票名稱], isNull([上市上櫃],'1') 市場, IsNull([公司名稱], '') 公司名稱, IsNull([統一編號], '00000000') 統一編號 FROM [上市櫃公司基本資料] WHERE ";
List <string> datas = new List <string>();
//DataView dv = DeriLib.Util.ExecSqlQry("SELECT WRTCAN_CMONEY_ID FROM [V_CANDIDATE] ORDER BY WRTCAN_CMONEY_ID", LoginSet.warrantSysSqlConnString);
DataTable dv = MSSQL.ExecSqlQry("SELECT WRTCAN_CMONEY_ID FROM [CANDIDATE] WHERE WRTCAN_DATE = (select max(WRTCAN_DATE) from [WAFT].[dbo].[CANDIDATE]) ORDER BY WRTCAN_CMONEY_ID", LoginSet.warrantSysSqlConnString);//V_CANDIDATE
string cStr = "";
foreach (DataRow dr in dv.Rows)
{
cStr += "'" + dr["WRTCAN_CMONEY_ID"].ToString() + "',";
}
if (cStr.Length > 0)
{
cStr = cStr.Substring(0, cStr.Length - 1);
}
sql += "[股票代號] IN (" + cStr + ") ORDER BY [股票代號]";
ADODB.Recordset rs = cn.CMExecute(ref arg, srvLocation, cnPort, sql);
for (; !rs.EOF; rs.MoveNext())
{
string cid = Convert.ToString(rs.Fields["股票代號"].Value);
string cnm = Convert.ToString(rs.Fields["股票名稱"].Value);
string mktN = Convert.ToString(rs.Fields["市場"].Value);
string mkt = "";
if (mktN == "1")
{
mkt = "TSE";
}
else if (mktN == "2")
{
mkt = "OTC";
}
else
{
mkt = "";
}
string uid = Convert.ToString(rs.Fields["統一編號"].Value);
string fnm = Convert.ToString(rs.Fields["公司名稱"].Value);
if (uid != null && cid != null && cnm != null && mkt != null && fnm != null && uid != "00000000" && uid != "0" && uid != "" && !datas.Contains(uid))
{
CommodityBasic b = new CommodityBasic(cid, cnm, mkt, uid, fnm);
datas.Add(uid);
cBL.add(b);
}
}
} catch (Exception ex) {
MessageBox.Show("GetCommodityBasics" + ex.Message);
//GlobalVar.errProcess.Add(1, "[CMoneyWork_getCommodityBasics][" + ex.Message + "][" + ex.StackTrace + "]");
}
return(cBL);
}
public CommodityBasic getByUnifiedID(string id)
{
CommodityBasic basic = null;
foreach (CommodityBasic cb in cbList)
{
if (cb.unifiedID == id)
{
basic = cb;
break;
}
}
return(basic);
}