public static void LoadStockCode_ByWatchList(data.tmpDS.stockCodeDataTable stockCodeTbl, StringCollection codes)
{
StringCollection retList = new StringCollection();
StringCollection list;
data.tmpDS.stockCodeDataTable tmpTbl = new data.tmpDS.stockCodeDataTable();
data.baseDS.portfolioDataTable portfolioTbl = new data.baseDS.portfolioDataTable();
data.baseDS.portfolioRow portfolioRow;
for (int idx1 = 0; idx1 < codes.Count; idx1++)
{
portfolioRow = SysLibs.FindAndCache(portfolioTbl, codes[idx1]);
if (portfolioRow == null)
{
continue;
}
list = common.MultiValueString.String2List(portfolioRow.interestedStock);
if (list.Count <= 0)
{
continue;
}
tmpTbl.Clear();
LoadStockCode_ByCodeList(tmpTbl, list);
for (int idx2 = 0; idx2 < tmpTbl.Count; idx2++)
{
if (stockCodeTbl.FindBycode(tmpTbl[idx2].code) == null)
{
stockCodeTbl.ImportRow(tmpTbl[idx2]);
}
}
}
portfolioTbl.Dispose();
}
public static data.baseDS.portfolioRow GetPortfolio_DefaultStrategy()
{
string cacheKey = MakeCacheKey("SysPortfolio", "DefaultStrategy");
object obj = GetCache(cacheKey);
if (obj != null)
{
return((data.baseDS.portfolioRow)obj);
}
data.baseDS.portfolioRow row = null;
data.baseDS.portfolioDataTable tbl = myClient.GetPortfolio_ByType(AppTypes.PortfolioTypes.PortfolioDefaultStrategy);
if (tbl.Count == 0)
{
row = tbl.NewportfolioRow();
commonClass.AppLibs.InitData(row);
row.type = (byte)AppTypes.PortfolioTypes.PortfolioDefaultStrategy;
row.code = Consts.constNotMarkerNEW;
row.investorCode = commonClass.SysLibs.sysLoginCode;
tbl.AddportfolioRow(row);
myClient.UpdatePortfolio(ref tbl);
}
row = tbl[0];
AddCache(cacheKey, row);
return(row);
}
public static data.baseDS.portfolioRow UpdateData(data.baseDS.portfolioRow row)
{
data.baseDS.portfolioDataTable tbl = new data.baseDS.portfolioDataTable();
tbl.ImportRow(row);
myClient.UpdatePortfolio(ref tbl);
row.AcceptChanges();
return(tbl[0]);
}
public string GetSQL()
{
data.baseDS.portfolioDataTable portfolioTbl = new data.baseDS.portfolioDataTable();
data.baseDS.tradeAlertDataTable tradeAlertTbl = new data.baseDS.tradeAlertDataTable();
string condCmd = "";
condCmd += (condCmd == "" ? "" : " AND ") +
"(" + tradeAlertTbl.portfolioColumn.ColumnName +
" IN (" +
" SELECT " + portfolioTbl.codeColumn.ColumnName +
" FROM " + portfolioTbl.TableName +
" WHERE " + portfolioTbl.investorCodeColumn.ColumnName + "=N'" + commonClass.SysLibs.sysLoginCode + "'))";
if (dateRangeChk.Checked)
{
condCmd += (condCmd == "" ? "" : " AND ") +
"(" + tradeAlertTbl.onTimeColumn.ColumnName +
" BETWEEN '" + common.system.ConvertToSQLDateString(dateRange.frDate, false) + "' AND '" +
common.system.ConvertToSQLDateString(dateRange.toDate.AddDays(1).AddSeconds(-1), false) + "')";
}
if (statusChk.Checked)
{
condCmd += (condCmd == "" ? "" : " AND ") +
"(" + tradeAlertTbl.statusColumn.ColumnName + " & " + ((byte)statusCb.myValue).ToString() + ">0)";
}
if (portfolioChk.Checked)
{
condCmd += (condCmd == "" ? "" : " AND ") +
"(" + tradeAlertTbl.portfolioColumn.ColumnName + "=N'" + portfolioCb.myValue + "')";
}
if (strategyChk.Checked)
{
condCmd += (condCmd == "" ? "" : " AND ") +
"(" + tradeAlertTbl.strategyColumn.ColumnName + "=N'" + strategyCb.myValue + "')";
}
if (timeScaleChk.Checked)
{
condCmd += (condCmd == "" ? "" : " AND ") +
"(" + tradeAlertTbl.timeScaleColumn.ColumnName + "='" + timeScaleCb.myValue.Code + "')";
}
if (codeChk.Checked)
{
condCmd += (condCmd == "" ? "" : " AND ") +
"(" + tradeAlertTbl.stockCodeColumn.ColumnName + "=N'" + codeEd.Text.Trim() + "')";
}
string sqlCmd = "SELECT * FROM " + tradeAlertTbl.TableName +
(condCmd == "" ? "" : " WHERE " + condCmd) +
" ORDER BY " + tradeAlertTbl.onTimeColumn.ColumnName + " DESC";
return(sqlCmd);
}
public static data.baseDS.portfolioRow GetPortfolio_ByCode(string code)
{
data.baseDS.portfolioDataTable tbl = myClient.GetPortfolio_ByCode(code);
if (tbl.Count == 0)
{
return(null);
}
return(tbl[0]);
}
public static data.baseDS.portfolioRow GetPortfolio(string portfolioCode)
{
data.baseDS.portfolioDataTable tbl = portfolioTA.GetByCode(portfolioCode);
if (tbl.Count == 0)
{
return(null);
}
return(tbl[0]);
}
public string GetSQL()
{
string investorCode = commonClass.SysLibs.sysLoginCode;
data.baseDS.transactionsDataTable transactionsTbl = new data.baseDS.transactionsDataTable();
data.baseDS.stockCodeDataTable stockCodeTbl = new data.baseDS.stockCodeDataTable();
data.baseDS.portfolioDataTable portfolioTbl = new data.baseDS.portfolioDataTable();
string sqlCmd = "SELECT * FROM " + transactionsTbl.TableName;
string filter = "";
string portfolioCond = "";
if (investorCode.Trim() != "")
{
portfolioCond += (portfolioCond == "" ? "" : " AND ") +
portfolioTbl.investorCodeColumn.ColumnName + "=N'" + investorCode.Trim() + "'";
}
if (portfolioCond != "")
{
filter += (filter == "" ? "" : " AND ") +
transactionsTbl.portfolioColumn.ColumnName + " IN " + common.Consts.constCRLF +
"(SELECT " + portfolioTbl.codeColumn.ColumnName + " FROM " + portfolioTbl.TableName +
" WHERE " + portfolioCond + ")";
}
if (this.stockExchangeChk.Checked && this.stockExchangeCb.myValue != "")
{
filter += (filter == "" ? "" : " AND ") +
transactionsTbl.stockCodeColumn.ColumnName + " IN (SELECT " + stockCodeTbl.codeColumn.ColumnName +
" FROM " + stockCodeTbl.TableName + " WHERE " + stockCodeTbl.stockExchangeColumn.ColumnName + "=N'" + this.stockExchangeCb.myValue.Trim() + "')";
}
if (this.dateRangeChk.Checked && this.dateRange.GetDateRange())
{
filter += (filter == "" ? "" : " AND ") +
"(" + transactionsTbl.onTimeColumn.ColumnName +
" BETWEEN '" + common.system.ConvertToSQLDateString(this.dateRange.frDate) + "' AND '" +
common.system.ConvertToSQLDateString(this.dateRange.toDate) + "')";
}
if (this.stockCodeEd.Enabled && this.stockCodeEd.Text.Trim() != "")
{
filter += (filter == "" ? "" : " AND ") +
transactionsTbl.stockCodeColumn.ColumnName + " =N'" + this.stockCodeEd.Text.Trim() + "'";
}
if (portfolioChk.Checked && portfolioCb.myValue.Trim() != "")
{
filter += (filter == "" ? "" : " AND ") +
transactionsTbl.portfolioColumn.ColumnName + " =N'" + portfolioCb.myValue.Trim() + "'";
}
if (filter != "")
{
sqlCmd += " WHERE " + filter;
}
return(sqlCmd);
}
public void UpdatePortfolio(ref data.baseDS.portfolioDataTable tbl)
{
for (int idx = 0; idx < tbl.Count; idx++)
{
if (tbl[idx].code.Trim() == Consts.constNotMarkerNEW)
{
common.myAutoKeyInfo info = application.SysLibs.GetAutoKey(tbl.TableName, false);
tbl[idx].code = info.value.ToString().PadLeft(tbl.codeColumn.MaxLength, '0');
}
}
DbAccess.UpdateData(tbl);
}
public static data.baseDS.portfolioDataTable GetSystemWatchList()
{
string cacheKey = MakeCacheKey("SysWatchList", "List");
object obj = GetCache(cacheKey);
if (obj != null)
{
return((data.baseDS.portfolioDataTable)obj);
}
data.baseDS.portfolioDataTable tbl = myClient.GetPortfolio_ByType(AppTypes.PortfolioTypes.SysWatchList);
AddCache(cacheKey, tbl);
return(tbl);
}
public string GetSQL()
{
string investorCode = commonClass.SysLibs.sysLoginCode;
data.baseDS.transactionsDataTable transactionsTbl = new data.baseDS.transactionsDataTable();
data.baseDS.stockCodeDataTable stockCodeTbl = new data.baseDS.stockCodeDataTable();
data.baseDS.portfolioDataTable portfolioTbl = new data.baseDS.portfolioDataTable();
string sqlCmd = "SELECT * FROM " + transactionsTbl.TableName;
string filter = "";
string portfolioCond = "";
if (investorCode.Trim() != "")
{
portfolioCond +=(portfolioCond == "" ? "" : " AND ") +
portfolioTbl.investorCodeColumn.ColumnName + "=N'" + investorCode.Trim() + "'";
}
if (portfolioCond != "")
{
filter += (filter == "" ? "" : " AND ") +
transactionsTbl.portfolioColumn.ColumnName + " IN " + common.Consts.constCRLF +
"(SELECT " + portfolioTbl.codeColumn.ColumnName + " FROM " + portfolioTbl.TableName +
" WHERE " + portfolioCond + ")";
}
if (this.stockExchangeChk.Checked && this.stockExchangeCb.myValue != "")
{
filter += (filter == "" ? "" : " AND ") +
transactionsTbl.stockCodeColumn.ColumnName + " IN (SELECT " +stockCodeTbl.codeColumn.ColumnName +
" FROM " + stockCodeTbl.TableName + " WHERE " + stockCodeTbl.stockExchangeColumn.ColumnName + "=N'" + this.stockExchangeCb.myValue.Trim() + "')";
}
if (this.dateRangeChk.Checked && this.dateRange.GetDateRange())
{
filter += (filter == "" ? "" : " AND ") +
"("+ transactionsTbl.onTimeColumn.ColumnName +
" BETWEEN '" + common.system.ConvertToSQLDateString(this.dateRange.frDate) + "' AND '" +
common.system.ConvertToSQLDateString(this.dateRange.toDate) + "')";
}
if (this.stockCodeEd.Enabled && this.stockCodeEd.Text.Trim()!="")
{
filter += (filter == "" ? "" : " AND ") +
transactionsTbl.stockCodeColumn.ColumnName + " =N'" + this.stockCodeEd.Text.Trim() + "'";
}
if (portfolioChk.Checked && portfolioCb.myValue.Trim() != "")
{
filter += (filter == "" ? "" : " AND ") +
transactionsTbl.portfolioColumn.ColumnName + " =N'" + portfolioCb.myValue.Trim() + "'";
}
if (filter != "") sqlCmd += " WHERE " + filter;
return sqlCmd;
}
// Load stock list specified in the user's portfolio
protected void LoadPortfolioStock()
{
StringCollection stockList = new StringCollection();
TreeNode node;
data.baseDS.portfolioDataTable portfolioTbl = new data.baseDS.portfolioDataTable();
portfolioTbl.Clear();
myStockCodeTbl.Clear();
dataLibs.LoadPortfolioByInvestor(portfolioTbl, sysLibs.sysLoginCode, AppTypes.PortfolioTypes.Portfolio);
stockTV.Nodes.Clear();
DataView myStockView = new DataView(myStockCodeTbl);
data.baseDS.stockCodeRow stockRow;
myStockView.Sort = myStockCodeTbl.codeColumn.ColumnName;
StringCollection list = new StringCollection();
for (int idx1 = 0; idx1 < portfolioTbl.Count; idx1++)
{
node = stockTV.Nodes.Add(portfolioTbl[idx1].name);
list.Clear();
list.Add(portfolioTbl[idx1].code);
myStockCodeTbl.Clear();
if (portfolioTbl[idx1].type == (byte)AppTypes.PortfolioTypes.WatchList)
{
dataLibs.LoadStockCode_ByWatchList(myStockCodeTbl, list);
}
else
{
dataLibs.LoadStockCode_ByPortfolios(myStockCodeTbl, list);
}
stockList.Clear();
for (int idx2 = 0; idx2 < myStockView.Count; idx2++)
{
stockRow = (data.baseDS.stockCodeRow)myStockView[idx2].Row;
//Ignore duplicate stocks
if (stockList.Contains(stockRow.tickerCode))
{
continue;
}
stockList.Add(stockRow.tickerCode);
node.Nodes.Add(stockRow.tickerCode);
}
node.Text = node.Text + "(" + node.Nodes.Count.ToString() + ")";
node.ExpandAll();
}
}
public static data.baseDS.portfolioRow FindAndCache(data.baseDS.portfolioDataTable tbl, string code)
{
data.baseDS.portfolioRow row = tbl.FindBycode(code);
if (row != null)
{
return(row);
}
data.baseDSTableAdapters.portfolioTA dataTA = new data.baseDSTableAdapters.portfolioTA();
dataTA.ClearBeforeFill = false;
dataTA.FillByCode(tbl, code);
row = tbl.FindBycode(code);
if (row != null)
{
return(row);
}
return(null);
}
protected override void SaveData()
{
common.MultiValueString mvString = new common.MultiValueString();
data.baseDS.portfolioDataTable portfolioTbl = new data.baseDS.portfolioDataTable();
data.baseDS.portfolioDetailDataTable portfolioDataTbl;
portfolioTbl.Clear();
for (int portfolioIdx = 0; portfolioIdx < watchListLb.myCheckedValues.Count; portfolioIdx++)
{
data.baseDS.portfolioRow portfolioRow = DataAccess.Libs.GetPortfolio_ByCode(watchListLb.myCheckedValues[portfolioIdx]);
if (portfolioRow == null)
{
continue;
}
mvString.myFormatString = portfolioRow.interestedStock;
mvString.Add(codeEd.Text);
portfolioRow.interestedStock = mvString.myFormatString;
portfolioDataTbl = DataAccess.Libs.GetPortfolioDetail_ByCode(portfolioRow.code);
data.baseDS.portfolioDetailRow dataRow;
for (int idx = 0; idx < myStrategyCodes.Count; idx++)
{
dataRow = portfolioDataTbl.FindByportfoliocodesubCode(portfolioRow.code, this.codeEd.Text, this.myStrategyCodes[idx]);
if (dataRow == null)
{
dataRow = portfolioDataTbl.NewportfolioDetailRow();
commonClass.AppLibs.InitData(dataRow);
dataRow.portfolio = portfolioRow.code;
dataRow.code = codeEd.Text;
dataRow.subCode = this.myStrategyCodes[idx];
portfolioDataTbl.AddportfolioDetailRow(dataRow);
}
mvString.myFormatString = dataRow.data;
mvString.Add(timeScaleCb.myValue.Code);
dataRow.data = mvString.myFormatString;
}
DataAccess.Libs.UpdateData(portfolioRow);
DataAccess.Libs.UpdateData(portfolioDataTbl);
}
common.system.ShowMessage(Languages.Libs.GetString("dataSaved"));
}
// Load stock list specified in the user's portfolio
protected void LoadPortfolioStock()
{
StringCollection stockList = new StringCollection();
TreeNode node;
data.baseDS.portfolioDataTable portfolioTbl = new data.baseDS.portfolioDataTable();
portfolioTbl.Clear();
myStockCodeTbl.Clear();
dataLibs.LoadPortfolioByInvestor(portfolioTbl, sysLibs.sysLoginCode, AppTypes.PortfolioTypes.Portfolio);
stockTV.Nodes.Clear();
DataView myStockView = new DataView(myStockCodeTbl);
data.baseDS.stockCodeRow stockRow;
myStockView.Sort = myStockCodeTbl.codeColumn.ColumnName;
StringCollection list = new StringCollection();
for (int idx1 = 0; idx1 < portfolioTbl.Count; idx1++)
{
node = stockTV.Nodes.Add(portfolioTbl[idx1].name);
list.Clear();
list.Add(portfolioTbl[idx1].code);
myStockCodeTbl.Clear();
if (portfolioTbl[idx1].type == (byte)AppTypes.PortfolioTypes.WatchList)
dataLibs.LoadStockCode_ByWatchList(myStockCodeTbl, list);
else
dataLibs.LoadStockCode_ByPortfolios(myStockCodeTbl, list);
stockList.Clear();
for (int idx2 = 0; idx2 < myStockView.Count; idx2++)
{
stockRow = (data.baseDS.stockCodeRow)myStockView[idx2].Row;
//Ignore duplicate stocks
if (stockList.Contains(stockRow.tickerCode)) continue;
stockList.Add(stockRow.tickerCode);
node.Nodes.Add(stockRow.tickerCode);
}
node.Text = node.Text + "(" + node.Nodes.Count.ToString() + ")";
node.ExpandAll();
}
}
protected override void SaveData()
{
common.MultiValueString mvString = new common.MultiValueString();
data.baseDS.portfolioDataTable portfolioTbl = new data.baseDS.portfolioDataTable();
data.baseDS.portfolioDetailDataTable portfolioDataTbl;
portfolioTbl.Clear();
for (int portfolioIdx = 0; portfolioIdx < watchListLb.myCheckedValues.Count; portfolioIdx++)
{
data.baseDS.portfolioRow portfolioRow = DataAccess.Libs.GetPortfolio_ByCode(watchListLb.myCheckedValues[portfolioIdx]);
if (portfolioRow == null) continue;
mvString.myFormatString = portfolioRow.interestedStock;
mvString.Add(codeEd.Text);
portfolioRow.interestedStock = mvString.myFormatString;
portfolioDataTbl = DataAccess.Libs.GetPortfolioDetail_ByCode(portfolioRow.code);
data.baseDS.portfolioDetailRow dataRow;
for (int idx = 0; idx < myStrategyCodes.Count; idx++)
{
dataRow = portfolioDataTbl.FindByportfoliocodesubCode(portfolioRow.code, this.codeEd.Text, this.myStrategyCodes[idx]);
if (dataRow == null)
{
dataRow = portfolioDataTbl.NewportfolioDetailRow();
commonClass.AppLibs.InitData(dataRow);
dataRow.portfolio = portfolioRow.code;
dataRow.code = codeEd.Text;
dataRow.subCode = this.myStrategyCodes[idx];
portfolioDataTbl.AddportfolioDetailRow(dataRow);
}
mvString.myFormatString = dataRow.data;
mvString.Add(timeScaleCb.myValue.Code);
dataRow.data = mvString.myFormatString;
}
DataAccess.Libs.UpdateData(portfolioRow);
DataAccess.Libs.UpdateData(portfolioDataTbl);
}
common.system.ShowMessage(Languages.Libs.GetString("dataSaved"));
}
public data.baseDS.portfolioDataTable GetPortfolio_ByType(AppTypes.PortfolioTypes type)
{
data.baseDS.portfolioDataTable tbl = new data.baseDS.portfolioDataTable();
DbAccess.LoadData(tbl, type);
return(tbl);
}
public static void LoadPortfolioByInvestor(data.baseDS.portfolioDataTable tbl, string investorCode, AppTypes.PortfolioTypes type)
{
portfolioTA.ClearBeforeFill = false;
portfolioTA.FillByInvestorCodeAndTypeMask(tbl, investorCode, ((byte)type).ToString());
}
public static void LoadPortfolioByInvestor(data.baseDS.portfolioDataTable tbl, string investorCode)
{
portfolioTA.ClearBeforeFill = false;
portfolioTA.FillByInvestorCode(tbl, investorCode);
}
public static void UpdateData(data.baseDS.portfolioDataTable tbl)
{
portfolioTA.Update(tbl);
tbl.AcceptChanges();
}
public data.baseDS.portfolioDataTable GetPortfolio_ByCode(string code)
{
data.baseDS.portfolioDataTable tbl = new data.baseDS.portfolioDataTable();
DbAccess.LoadData(tbl, code);
return tbl;
}
public static void LoadData(data.baseDS.portfolioDataTable tbl, string code)
{
portfolioTA.ClearBeforeFill = false;
portfolioTA.FillByCode(tbl, code);
}
public string GetSQL()
{
data.baseDS.portfolioDataTable portfolioTbl = new data.baseDS.portfolioDataTable();
data.baseDS.tradeAlertDataTable tradeAlertTbl = new data.baseDS.tradeAlertDataTable();
string condCmd = "";
condCmd += (condCmd == "" ? "" : " AND ") +
"(" + tradeAlertTbl.portfolioColumn.ColumnName +
" IN (" +
" SELECT " + portfolioTbl.codeColumn.ColumnName +
" FROM " + portfolioTbl.TableName +
" WHERE " + portfolioTbl.investorCodeColumn.ColumnName + "=N'" + commonClass.SysLibs.sysLoginCode + "'))";
if (dateRangeChk.Checked)
condCmd += (condCmd == "" ? "" : " AND ") +
"(" + tradeAlertTbl.onTimeColumn.ColumnName +
" BETWEEN '" + common.system.ConvertToSQLDateString(dateRange.frDate,false) + "' AND '"+
common.system.ConvertToSQLDateString(dateRange.toDate.AddDays(1).AddSeconds(-1),false) + "')";
if (statusChk.Checked)
condCmd += (condCmd == "" ? "" : " AND ") +
"(" + tradeAlertTbl.statusColumn.ColumnName + " & " + ((byte)statusCb.myValue).ToString() + ">0)";
if (portfolioChk.Checked)
condCmd += (condCmd == "" ? "" : " AND ") +
"(" + tradeAlertTbl.portfolioColumn.ColumnName + "=N'" + portfolioCb.myValue + "')";
if (strategyChk.Checked)
condCmd += (condCmd == "" ? "" : " AND ") +
"(" + tradeAlertTbl.strategyColumn.ColumnName + "=N'" + strategyCb.myValue + "')";
if (timeScaleChk.Checked)
condCmd += (condCmd == "" ? "" : " AND ") +
"(" + tradeAlertTbl.timeScaleColumn.ColumnName + "='" + timeScaleCb.myValue.Code + "')";
if (codeChk.Checked)
condCmd += (condCmd == "" ? "" : " AND ") +
"(" + tradeAlertTbl.stockCodeColumn.ColumnName + "=N'" + codeEd.Text.Trim() + "')";
string sqlCmd = "SELECT * FROM " + tradeAlertTbl.TableName +
(condCmd == "" ? "" : " WHERE " + condCmd) +
" ORDER BY " + tradeAlertTbl.onTimeColumn.ColumnName + " DESC";
return sqlCmd;
}
public virtual void LoadData(string investorCode, bool checkedAll)
{
dataTbl = DataAccess.Libs.GetPortfolio_ByInvestorAndType(investorCode, this.WatchType);
this.Items.Clear();
for (int idx = 0; idx < dataTbl.Count; idx++)
this.Items.Add(new common.myComboBoxItem(dataTbl[idx].name.Trim(), dataTbl[idx].code.Trim()), checkedAll);
SaveItems();
}
public static void LoadData(data.baseDS.portfolioDataTable tbl, AppTypes.PortfolioTypes type)
{
portfolioTA.ClearBeforeFill = false;
portfolioTA.FillByTypeMask(tbl, ((byte)type).ToString());
}
public data.baseDS.portfolioDataTable GetPortfolio_ByInvestorAndType(string investorCode, AppTypes.PortfolioTypes type)
{
data.baseDS.portfolioDataTable tbl = new data.baseDS.portfolioDataTable();
DbAccess.LoadPortfolioByInvestor(tbl, investorCode, type);
return tbl;
}
public data.baseDS.portfolioDataTable GetPortfolio_ByInvestor(string investorCode)
{
data.baseDS.portfolioDataTable tbl = new data.baseDS.portfolioDataTable();
DbAccess.LoadPortfolioByInvestor(tbl, investorCode);
return tbl;
}
public data.baseDS.portfolioDataTable GetPortfolio_ByCode(string code)
{
data.baseDS.portfolioDataTable tbl = new data.baseDS.portfolioDataTable();
DbAccess.LoadData(tbl, code);
return(tbl);
}
public static data.baseDS.portfolioRow UpdateData(data.baseDS.portfolioRow row)
{
data.baseDS.portfolioDataTable tbl = new data.baseDS.portfolioDataTable();
tbl.ImportRow(row);
myClient.UpdatePortfolio(ref tbl);
row.AcceptChanges();
return tbl[0];
}
public data.baseDS.portfolioDataTable GetPortfolio_ByInvestor(string investorCode)
{
data.baseDS.portfolioDataTable tbl = new data.baseDS.portfolioDataTable();
DbAccess.LoadPortfolioByInvestor(tbl, investorCode);
return(tbl);
}
public void LoadData(string investorCode, bool AddAllItem)
{
data.baseDS.portfolioDataTable tbl = new data.baseDS.portfolioDataTable();
if (AddAllItem)
{
data.baseDS.portfolioRow row = tbl.NewportfolioRow();
commonClass.AppLibs.InitData(row);
row.investorCode = investorCode;
row.name = commonClass.Settings.sysString_All_Description;
row.code = commonClass.Settings.sysString_All_Code;
tbl.AddportfolioRow(row);
}
data.baseDS.portfolioDataTable tmpTbl = DataAccess.Libs.GetPortfolio_ByInvestor(investorCode);
for (int idx = 0; idx < tmpTbl.Count; idx++) tbl.ImportRow(tmpTbl[idx]);
this.DisplayMember = tbl.nameColumn.ColumnName;
this.ValueMember = tbl.codeColumn.ColumnName;
this.DataSource = tbl;
if (tbl.Count > 0) this.MaxDropDownItems = tbl.Count;
}
public static void LoadStockCode_ByWatchList(data.tmpDS.stockCodeDataTable stockCodeTbl, StringCollection codes)
{
StringCollection retList = new StringCollection();
StringCollection list;
data.tmpDS.stockCodeDataTable tmpTbl = new data.tmpDS.stockCodeDataTable();
data.baseDS.portfolioDataTable portfolioTbl = new data.baseDS.portfolioDataTable();
data.baseDS.portfolioRow portfolioRow;
for (int idx1 = 0; idx1 < codes.Count; idx1++)
{
portfolioRow = SysLibs.FindAndCache(portfolioTbl, codes[idx1]);
if (portfolioRow == null) continue;
list = common.MultiValueString.String2List(portfolioRow.interestedStock);
if (list.Count <= 0) continue;
tmpTbl.Clear();
LoadStockCode_ByCodeList(tmpTbl, list);
for (int idx2 = 0; idx2 < tmpTbl.Count; idx2++)
{
if (stockCodeTbl.FindBycode(tmpTbl[idx2].code)==null) stockCodeTbl.ImportRow(tmpTbl[idx2]);
}
}
portfolioTbl.Dispose();
}
public data.baseDS.portfolioDataTable GetPortfolio_ByType(AppTypes.PortfolioTypes type)
{
data.baseDS.portfolioDataTable tbl = new data.baseDS.portfolioDataTable();
DbAccess.LoadData(tbl, type);
return tbl;
}