// 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; }