internal HssUtility.SQLserver.DB_insert Get_DBinsert() { HssUtility.SQLserver.DB_insert dbIns = new HssUtility.SQLserver.DB_insert(SavedFilesCustodianBalance.Get_cmdTP()); dbIns.AddValue("originalFileName", this.originalFileName);/*Optional 2*/ dbIns.AddValue("SavedFiles_XML_CB", this.SavedFiles_XML_CB); dbIns.AddValue("AnnouncementName", this.AnnouncementName.Value); dbIns.AddValue("AnnouncementSender", this.AnnouncementSender.Value); dbIns.AddValue("AnnouncementIdentifier", this.AnnouncementIdentifier.Value); dbIns.AddValue("AnnouncementDate", this.AnnouncementDate.Value); dbIns.AddValue("UniqueUniversalEventIdentifier", this.UniqueUniversalEventIdentifier.Value); dbIns.AddValue("SECURITY_IDENTIFIER_CUSIP", this.SECURITY_IDENTIFIER_CUSIP.Value); dbIns.AddValue("ISSUER_NAME", this.ISSUER_NAME.Value); dbIns.AddValue("ADR_RECORD_DATE", this.ADR_RECORD_DATE.Value); dbIns.AddValue("ADRBase", this.ADRBase); /*Optional 12*/ dbIns.AddValue("OrdinaryShare", this.OrdinaryShare); /*Optional 13*/ dbIns.AddValue("source", this.source.Value); dbIns.AddValue("processState", this.processState.Value); dbIns.AddValue("WhenProcessed", this.WhenProcessed); /*Optional 16*/ dbIns.AddValue("Processedby", this.Processedby); /*Optional 17*/ dbIns.AddValue("flgLock", this.flgLock); /*Optional 18*/ dbIns.AddValue("WhenLocked_date", this.WhenLocked_date); /*Optional 19*/ dbIns.AddValue("LockedBy_userid", this.LockedBy_userid); /*Optional 20*/ dbIns.AddValue("createdby", this.createdby.Value); dbIns.AddValue("createddate", this.createddate.Value); dbIns.AddValue("ID_GTS_SFTP_InputSITEs", this.ID_GTS_SFTP_InputSITEs);/*Optional 23*/ return(dbIns); }
internal HssUtility.SQLserver.DB_update Get_DBupdate() { if (!this.CheckValueChanges()) { return(null); } HssUtility.SQLserver.DB_update upd = new HssUtility.SQLserver.DB_update(SavedFilesCustodianBalance.Get_cmdTP()); if (this.originalFileName.ValueChanged) { upd.AddValue("originalFileName", this.originalFileName); } //if (this.SavedFiles_XML_CB.ValueChanged) upd.AddValue("SavedFiles_XML_CB", this.SavedFiles_XML_CB); if (this.AnnouncementName.ValueChanged) { upd.AddValue("AnnouncementName", this.AnnouncementName); } if (this.AnnouncementSender.ValueChanged) { upd.AddValue("AnnouncementSender", this.AnnouncementSender); } if (this.AnnouncementIdentifier.ValueChanged) { upd.AddValue("AnnouncementIdentifier", this.AnnouncementIdentifier); } if (this.AnnouncementDate.ValueChanged) { upd.AddValue("AnnouncementDate", this.AnnouncementDate); } if (this.UniqueUniversalEventIdentifier.ValueChanged) { upd.AddValue("UniqueUniversalEventIdentifier", this.UniqueUniversalEventIdentifier); } if (this.SECURITY_IDENTIFIER_CUSIP.ValueChanged) { upd.AddValue("SECURITY_IDENTIFIER_CUSIP", this.SECURITY_IDENTIFIER_CUSIP); } if (this.ISSUER_NAME.ValueChanged) { upd.AddValue("ISSUER_NAME", this.ISSUER_NAME); } if (this.ADR_RECORD_DATE.ValueChanged) { upd.AddValue("ADR_RECORD_DATE", this.ADR_RECORD_DATE); } if (this.ADRBase.ValueChanged) { upd.AddValue("ADRBase", this.ADRBase); } if (this.OrdinaryShare.ValueChanged) { upd.AddValue("OrdinaryShare", this.OrdinaryShare); } if (this.source.ValueChanged) { upd.AddValue("source", this.source); } if (this.processState.ValueChanged) { upd.AddValue("processState", this.processState); } if (this.WhenProcessed.ValueChanged) { upd.AddValue("WhenProcessed", this.WhenProcessed); } if (this.Processedby.ValueChanged) { upd.AddValue("Processedby", this.Processedby); } if (this.flgLock.ValueChanged) { upd.AddValue("flgLock", this.flgLock); } if (this.WhenLocked_date.ValueChanged) { upd.AddValue("WhenLocked_date", this.WhenLocked_date); } if (this.LockedBy_userid.ValueChanged) { upd.AddValue("LockedBy_userid", this.LockedBy_userid); } if (this.createdby.ValueChanged) { upd.AddValue("createdby", this.createdby); } if (this.createddate.ValueChanged) { upd.AddValue("createddate", this.createddate); } if (this.ID_GTS_SFTP_InputSITEs.ValueChanged) { upd.AddValue("ID_GTS_SFTP_InputSITEs", this.ID_GTS_SFTP_InputSITEs); } HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("id_SavedFilesCustodianBalance", HssUtility.General.RelationalOperator.Equals, this.pk_ID); upd.SetCondition(rela); return(upd); }
/// <summary> /// Initialize object from DB /// </summary> public bool Init_from_DB() { if (this.id_SavedFilesCustodianBalance < 0) { return(false); } HssUtility.SQLserver.DB_select db_sel = new HssUtility.SQLserver.DB_select(SavedFilesCustodianBalance.Get_cmdTP()); db_sel.tableName = "SavedFilesCustodianBalance"; HssUtility.SQLserver.SQL_relation rela = new HssUtility.SQLserver.SQL_relation("id_SavedFilesCustodianBalance", HssUtility.General.RelationalOperator.Equals, this.id_SavedFilesCustodianBalance); db_sel.SetCondition(rela); bool res_flag = false; HssUtility.SQLserver.DB_reader reader = new HssUtility.SQLserver.DB_reader(db_sel, Utility.Get_XBRL_hDB()); if (reader.Read()) { this.Init_from_reader(reader); res_flag = true; } reader.Close(); return(res_flag); }