private void Init_schemaTable_dic() { if (this.schemaTable_dic != null) { return; } this.schemaTable_dic = new Dictionary <string, HashSet <string> >(StringComparer.OrdinalIgnoreCase); DB_select selt = new DB_select(TableSchema.Get_cmdTP()); DB_reader reader = null; try { reader = new DB_reader(selt, this); } catch (Exception ex) { Console.WriteLine("hssDB error 1: " + ex.ToString()); return; } while (reader.Read()) { TableSchema ts = new TableSchema(); ts.Init_from_reader(reader); if (!this.schemaTable_dic.ContainsKey(ts.TABLE_SCHEMA)) { HashSet <string> table_hs = new HashSet <string>(StringComparer.OrdinalIgnoreCase); this.schemaTable_dic[ts.TABLE_SCHEMA] = table_hs; } this.schemaTable_dic[ts.TABLE_SCHEMA].Add(ts.TABLE_NAME); } reader.Close(); }
internal void Init_from_reader(DB_reader reader) { if (reader == null || reader.IsClosed) { return; } this.TABLE_SCHEMA = reader.GetString("TABLE_SCHEMA"); this.TABLE_NAME = reader.GetString("TABLE_NAME"); }
internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader) { if (reader == null || reader.IsClosed) { return; } this.pk_ID = reader.GetInt("DTCModelMappingID"); reader.GetString("Country", this.Country); /*Optional 2*/ reader.GetString("Issue", this.Issue); /*Optional 3*/ reader.GetInt("RecordYear", this.RecordYear); /*Optional 4*/ reader.GetString("IncomeEvent", this.IncomeEvent); /*Optional 5*/ reader.GetInt("ModelNumber", this.ModelNumber); reader.GetDateTime("ADRRecordDate", this.ADRRecordDate); /*Optional 7*/ reader.GetDateTime("ORDPayDate", this.ORDPayDate); /*Optional 8*/ reader.GetInt("SecurityTypeID", this.SecurityTypeID); /*Optional 9*/ reader.GetDateTime("ADRRecordDate_End", this.ADRRecordDate_End); /*Optional 10*/ reader.GetBool("AtSourceSumFromDetails", this.AtSourceSumFromDetails); /*Optional 11*/ this.SyncWithDB(); }
/// <summary> /// Initialize object from DB /// </summary> public bool Init_from_DB() { if (this.DTCModelMappingID < 0) { return(false); } HssUtility.SQLserver.DB_select db_sel = new HssUtility.SQLserver.DB_select(DTCPositionModelNumber_Mapping.Get_cmdTP()); db_sel.tableName = "DTCPositionModelNumber_Mapping"; HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("DTCModelMappingID", HssUtility.General.RelationalOperator.Equals, this.DTCModelMappingID); db_sel.SetCondition(rela); bool res_flag = false; HssUtility.SQLserver.DB_reader reader = new HssUtility.SQLserver.DB_reader(db_sel, Utility.Get_DRWIN_hDB()); if (reader.Read()) { this.Init_from_reader(reader); res_flag = true; } reader.Close(); return(res_flag); }