public static void Init_from_DB()
{
if ((DateTime.Now - DTC_model_master.lastUpdateTime).TotalHours < Utility.RefreshInterval)
{
return;
}
DTC_model_master.Reset();
DB_select selt = new DB_select(DTCPositionModelNumber_Mapping.Get_cmdTP());
DB_reader reader = new DB_reader(selt, Utility.Get_DRWIN_hDB());
while (reader.Read())
{
DTCPositionModelNumber_Mapping dm = new DTCPositionModelNumber_Mapping();
dm.Init_from_reader(reader);
DTC_model_master.mapping_dic[dm.ModelNumber.Value] = dm;
if (!DTC_model_master.country_dic.ContainsKey(dm.Country.Value))
{
List <DTCPositionModelNumber_Mapping> list = new List <DTCPositionModelNumber_Mapping>();
DTC_model_master.country_dic[dm.Country.Value] = list;
}
DTC_model_master.country_dic[dm.Country.Value].Add(dm);
}
reader.Close();
DTC_model_master.lastUpdateTime = DateTime.Now;
}
internal HssUtility.SQLserver.DB_update Get_DBupdate()
{
if (!this.CheckValueChanges())
{
return(null);
}
HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(DTCPositionModelNumber_Mapping.Get_cmdTP());
if (this.Country.ValueChanged)
{
upd.AddValue("Country", this.Country);
}
if (this.Issue.ValueChanged)
{
upd.AddValue("Issue", this.Issue);
}
if (this.RecordYear.ValueChanged)
{
upd.AddValue("RecordYear", this.RecordYear);
}
if (this.IncomeEvent.ValueChanged)
{
upd.AddValue("IncomeEvent", this.IncomeEvent);
}
if (this.ModelNumber.ValueChanged)
{
upd.AddValue("ModelNumber", this.ModelNumber);
}
if (this.ADRRecordDate.ValueChanged)
{
upd.AddValue("ADRRecordDate", this.ADRRecordDate);
}
if (this.ORDPayDate.ValueChanged)
{
upd.AddValue("ORDPayDate", this.ORDPayDate);
}
if (this.SecurityTypeID.ValueChanged)
{
upd.AddValue("SecurityTypeID", this.SecurityTypeID);
}
if (this.ADRRecordDate_End.ValueChanged)
{
upd.AddValue("ADRRecordDate_End", this.ADRRecordDate_End);
}
if (this.AtSourceSumFromDetails.ValueChanged)
{
upd.AddValue("AtSourceSumFromDetails", this.AtSourceSumFromDetails);
}
HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("DTCModelMappingID", HssUtility.General.RelationalOperator.Equals, this.pk_ID);
upd.SetCondition(rela);
return(upd);
}
public static DTCPositionModelNumber_Mapping GetMapping_country(string countryName, string secName, DateTime curr_dt, int secTypeID)
{
DTC_model_master.Init_from_DB();
if (string.IsNullOrEmpty(countryName))
{
return(null);
}
if (!DTC_model_master.country_dic.ContainsKey(countryName))
{
return(null);
}
List <DTCPositionModelNumber_Mapping> list = DTC_model_master.country_dic[countryName];
int i = 0, j = list.Count - 1;
while (i < j)//put the mapping with issue in front, quick sort
{
while (i < j && !string.IsNullOrEmpty(list[i].Issue.Value))
{
++i;
}
while (i < j && string.IsNullOrEmpty(list[j].Issue.Value))
{
--j;
}
DTCPositionModelNumber_Mapping temp = list[i];
list[i] = list[j];
list[j] = temp;
}
foreach (DTCPositionModelNumber_Mapping dm in list)
{
if (curr_dt < dm.ADRRecordDate.Value)
{
continue;
}
if (curr_dt > dm.ADRRecordDate_End.Value)
{
continue;
}
if (dm.SecurityTypeID.Value != secTypeID)
{
continue;
}
if (dm.CheckIssueMatch(secName))
{
return(dm);
}
}
return(null);
}
public DTCPositionModelNumber_Mapping GetCopy()
{
DTCPositionModelNumber_Mapping newEntity = new DTCPositionModelNumber_Mapping();
if (!this.Country.IsNull_flag)
{
newEntity.Country.Value = this.Country.Value;
}
if (!this.Issue.IsNull_flag)
{
newEntity.Issue.Value = this.Issue.Value;
}
if (!this.RecordYear.IsNull_flag)
{
newEntity.RecordYear.Value = this.RecordYear.Value;
}
if (!this.IncomeEvent.IsNull_flag)
{
newEntity.IncomeEvent.Value = this.IncomeEvent.Value;
}
if (!this.ModelNumber.IsNull_flag)
{
newEntity.ModelNumber.Value = this.ModelNumber.Value;
}
if (!this.ADRRecordDate.IsNull_flag)
{
newEntity.ADRRecordDate.Value = this.ADRRecordDate.Value;
}
if (!this.ORDPayDate.IsNull_flag)
{
newEntity.ORDPayDate.Value = this.ORDPayDate.Value;
}
if (!this.SecurityTypeID.IsNull_flag)
{
newEntity.SecurityTypeID.Value = this.SecurityTypeID.Value;
}
if (!this.ADRRecordDate_End.IsNull_flag)
{
newEntity.ADRRecordDate_End.Value = this.ADRRecordDate_End.Value;
}
if (!this.AtSourceSumFromDetails.IsNull_flag)
{
newEntity.AtSourceSumFromDetails.Value = this.AtSourceSumFromDetails.Value;
}
return(newEntity);
}
/// <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);
}
internal HssUtility.SQLserver.DB_insert Get_DBinsert()
{
HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(DTCPositionModelNumber_Mapping.Get_cmdTP());
dbIns.AddValue("Country", this.Country); /*Optional 2*/
dbIns.AddValue("Issue", this.Issue); /*Optional 3*/
dbIns.AddValue("RecordYear", this.RecordYear); /*Optional 4*/
dbIns.AddValue("IncomeEvent", this.IncomeEvent); /*Optional 5*/
dbIns.AddValue("ModelNumber", this.ModelNumber.Value);
dbIns.AddValue("ADRRecordDate", this.ADRRecordDate); /*Optional 7*/
dbIns.AddValue("ORDPayDate", this.ORDPayDate); /*Optional 8*/
dbIns.AddValue("SecurityTypeID", this.SecurityTypeID); /*Optional 9*/
dbIns.AddValue("ADRRecordDate_End", this.ADRRecordDate_End); /*Optional 10*/
dbIns.AddValue("AtSourceSumFromDetails", this.AtSourceSumFromDetails); /*Optional 11*/
return(dbIns);
}