internal DB_insert Get_DBinsert()
{
DB_insert dbIns = new DB_insert(ESPsys.Get_cmdTP());
dbIns.AddValue("coi_code", this.coi_code.Value);
dbIns.AddValue("clearing_system_id", this.clearing_system_id.Value);
dbIns.AddValue("security_type_id", this.security_type_id.Value);
dbIns.AddValue("event_restriction_id", this.event_restriction_id.Value);
return(dbIns);
}
public static void Init_from_DB()
{
if ((DateTime.Now - ESPsys_master.lastUpdateTime).TotalHours < Utility.RefreshInterval)
{
return;
}
ESPsys_master.Reset();
DB_select selt = new DB_select(ESPsys.Get_cmdTP());
DB_reader reader = new DB_reader(selt, Utility.Get_ESP2_hDB());
while (reader.Read())
{
ESPsys esys = new ESPsys();
esys.Init_from_reader(reader);
ESPsys_master.coi_dic[esys.coi_code.Value] = esys;
}
reader.Close();
ESPsys_master.lastUpdateTime = DateTime.Now;
}
