internal DB_insert Get_DBinsert()
{
DB_insert dbIns = new DB_insert(DepositaryInfo.Get_cmdTP());
dbIns.AddValue("depositary_name", this.depositary_name.Value);
dbIns.AddValue("depositary_address1", this.depositary_address1.Value);
dbIns.AddValue("depositary_address2", this.depositary_address2.Value);
dbIns.AddValue("phone", this.phone.Value);
dbIns.AddValue("fax", this.fax.Value);
dbIns.AddValue("international_phone", this.international_phone.Value);
dbIns.AddValue("depositary_full_name", this.depositary_full_name.Value);
dbIns.AddValue("depositary_index", this.depositary_index.Value);
dbIns.AddValue("active", this.active.Value);
dbIns.AddValue("stamp_name", this.stamp_name.Value);
return(dbIns);
}
public static void Init_from_DB()
{
if ((DateTime.Now - DepositaryInfoMaster.lastUpdateTime).TotalHours < Utility.RefreshInterval)
{
return;
}
DepositaryInfoMaster.Reset();
DB_select selt = new DB_select(DepositaryInfo.Get_cmdTP());
DB_reader reader = new DB_reader(selt, Utility.Get_ESP2_hDB());
while (reader.Read())
{
DepositaryInfo depo = new DepositaryInfo();
depo.Init_from_reader(reader);
DepositaryInfoMaster.depo_list.Add(depo);
}
reader.Close();
DepositaryInfoMaster.lastUpdateTime = DateTime.Now;
}