// Stock Exchange
public static databases.baseDS.stockExchangeRow AddStockExchange(databases.baseDS.stockExchangeDataTable tbl, string code)
{
databases.baseDS.stockExchangeRow stockExchangeRow = application.SysLibs.FindAndCache_StockExchange(code);
if (stockExchangeRow == null)
{
stockExchangeRow = tbl.NewstockExchangeRow();
databases.AppLibs.InitData(stockExchangeRow);
stockExchangeRow.code = code;
tbl.AddstockExchangeRow(stockExchangeRow);
databases.DbAccess.UpdateData(stockExchangeRow);
common.SysLog.WriteLog(" - Add stockExchange" + common.Consts.constTab + code);
}
return(stockExchangeRow);
}
public static databases.baseDS.stockExchangeRow UpdateData(databases.baseDS.stockExchangeRow row)
{
try
{
lock (myClient)
{
databases.baseDS.stockExchangeDataTable tbl = new databases.baseDS.stockExchangeDataTable();
tbl.ImportRow(row);
myClient.UpdateStockExchange(ref tbl);
row.AcceptChanges();
return tbl[0];
}
}
catch (Exception er)
{
if (OnError != null) OnError(er);
}
return null;
}
public void LoadDataDB()
{
databases.baseDS.stockExchangeDataTable tbl = new databases.baseDS.stockExchangeDataTable();
databases.DbAccess.LoadData(tbl);
this.DisplayMember = tbl.codeColumn.ColumnName;
this.ValueMember = tbl.codeColumn.ColumnName;
this.DataSource = tbl;
if (tbl.Count > 0) this.MaxDropDownItems = tbl.Count;
}
public bool UpdateStockExchange(ref databases.baseDS.stockExchangeDataTable stockExchangeTbl)
{
return(base.Channel.UpdateStockExchange(ref stockExchangeTbl));
}
public databases.baseDS.stockExchangeDataTable GetStockExchange()
{
try
{
databases.baseDS.stockExchangeDataTable tbl = new databases.baseDS.stockExchangeDataTable();
databases.DbAccess.LoadData(tbl);
return tbl;
}
catch (Exception ex)
{
WriteSysLogLocal("WS019", ex);
}
return null;
}
