예제 #1
0
        internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
        {
            if (reader == null || reader.IsClosed)
            {
                return;
            }

            this.pk_ID = reader.GetInt("id_SavedFiles_CSV");
            reader.GetString("originalFileName", this.originalFileName);   /*Optional 2*/
            this.savedfile_csv = reader.GetBytes("SavedFiles_CSV");
            reader.GetDateTime("FileCreationDate", this.FileCreationDate); /*Optional 4*/
            reader.GetString("FTP_Source", this.FTP_Source);               /*Optional 5*/
            reader.GetString("Status", this.Status);                       /*Optional 6*/
            reader.GetString("DividendIndex", this.DividendIndex);         /*Optional 7*/
            reader.GetString("Depositary", this.Depositary);               /*Optional 8*/
            reader.GetInt("DTC", this.DTC);                                /*Optional 9*/
            reader.GetDateTime("ProcessTime", this.ProcessTime);           /*Optional 10*/
            reader.GetString("ProcessedBy", this.ProcessedBy);             /*Optional 11*/
            reader.GetString("cpuFileName", this.cpuFileName);             /*Optional 12*/
            this.cpu_savedfile_csv = reader.GetBytes("cpuSavedFiles_CSV"); /*Optional 13*/
            reader.GetString("cpuStatus", this.cpuStatus);                 /*Optional 14*/
            reader.GetDateTime("cpuProcessTime", this.cpuProcessTime);     /*Optional 15*/
            reader.GetString("cpuProcessedBy", this.cpuProcessedBy);       /*Optional 16*/
            reader.GetString("OriginalSchema", this.OriginalSchema);       /*Optional 17*/
            reader.GetString("OriginalData", this.OriginalData);           /*Optional 18*/
            reader.GetDateTime("RecordDate", this.RecordDate);             /*Optional 19*/
            reader.GetString("Sender", this.Sender);                       /*Optional 20*/
            reader.GetString("CUSIP", this.CUSIP);                         /*Optional 21*/

            this.SyncWithDB();
        }
예제 #2
0
        internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
        {
            if (reader == null || reader.IsClosed)
            {
                return;
            }

            this.pk_ID = reader.GetInt("id_SavedFilesCustodianBalance");
            reader.GetString("originalFileName", this.originalFileName);/*Optional 2*/
            this.SavedFiles_XML_CB = reader.GetBytes("SavedFiles_XML_CB");
            reader.GetString("AnnouncementName", this.AnnouncementName);
            reader.GetString("AnnouncementSender", this.AnnouncementSender);
            reader.GetString("AnnouncementIdentifier", this.AnnouncementIdentifier);
            reader.GetString("AnnouncementDate", this.AnnouncementDate);
            reader.GetString("UniqueUniversalEventIdentifier", this.UniqueUniversalEventIdentifier);
            reader.GetString("SECURITY_IDENTIFIER_CUSIP", this.SECURITY_IDENTIFIER_CUSIP);
            reader.GetString("ISSUER_NAME", this.ISSUER_NAME);
            reader.GetString("ADR_RECORD_DATE", this.ADR_RECORD_DATE);
            reader.GetString("ADRBase", this.ADRBase);             /*Optional 12*/
            reader.GetString("OrdinaryShare", this.OrdinaryShare); /*Optional 13*/
            reader.GetString("source", this.source);
            reader.GetInt("processState", this.processState);
            reader.GetDateTime("WhenProcessed", this.WhenProcessed);     /*Optional 16*/
            reader.GetString("Processedby", this.Processedby);           /*Optional 17*/
            reader.GetBool("flgLock", this.flgLock);                     /*Optional 18*/
            reader.GetDateTime("WhenLocked_date", this.WhenLocked_date); /*Optional 19*/
            reader.GetString("LockedBy_userid", this.LockedBy_userid);   /*Optional 20*/
            reader.GetString("createdby", this.createdby);
            reader.GetDateTime("createddate", this.createddate);
            reader.GetInt("ID_GTS_SFTP_InputSITEs", this.ID_GTS_SFTP_InputSITEs);/*Optional 23*/

            this.SyncWithDB();
        }
예제 #3
0
        internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
        {
            if (reader == null || reader.IsClosed)
            {
                return;
            }

            this.pk_ID = reader.GetInt("id_SavedfilesRcvd");

            this.savedfile = reader.GetBytes("savedfile");
            reader.GetString("EventType", this.EventType);
            reader.GetString("DRWINIncomeEventID", this.DRWINIncomeEventID);                             /*Optional 4*/
            reader.GetString("cusip", this.cusip);                                                       /*Optional 5*/
            reader.GetString("ISIN", this.ISIN);                                                         /*Optional 6*/
            reader.GetString("originalFileName", this.originalFileName);                                 /*Optional 7*/
            reader.GetString("DepositaryName", this.DepositaryName);                                     /*Optional 8*/
            reader.GetDateTime("AnnouncementDate", this.AnnouncementDate);                               /*Optional 9*/
            reader.GetString("EventCompleteness", this.EventCompleteness);                               /*Optional 10*/
            reader.GetString("UniqueUniversalEventIdentifier", this.UniqueUniversalEventIdentifier);     /*Optional 11*/
            reader.GetBool("DepositoryReceiptSponsorIndicator", this.DepositoryReceiptSponsorIndicator); /*Optional 12*/
            reader.GetDateTime("PaymentDate", this.PaymentDate);                                         /*Optional 13*/
            reader.GetDateTime("RecordDate", this.RecordDate);                                           /*Optional 14*/
            reader.GetString("CountryOfIssue", this.CountryOfIssue);                                     /*Optional 15*/
            reader.GetString("ContextRefBase", this.ContextRefBase);                                     /*Optional 16*/
            reader.GetString("Source", this.Source);                                                     /*Optional 17*/
            reader.GetInt("processState", this.processState);
            reader.GetDateTime("WhenProcessed", this.WhenProcessed);                                     /*Optional 19*/
            reader.GetString("Processedby", this.Processedby);                                           /*Optional 20*/
            reader.GetBool("flgLock", this.flgLock);                                                     /*Optional 21*/
            reader.GetDateTime("WhenLocked_date", this.WhenLocked_date);                                 /*Optional 22*/
            reader.GetString("LockedBy_userid", this.LockedBy_userid);                                   /*Optional 23*/
            reader.GetString("createdby", this.createdby);
            reader.GetDateTime("createddate", this.createddate);
            reader.GetInt("AnnouncementIdentifier", this.AnnouncementIdentifier);                                                    /*Optional 26*/
            reader.GetBool("FirstFilerFlag", this.FirstFilerFlag);                                                                   /*Optional 27*/
            reader.GetString("UnderlyingSecurityIssuerCountryofIncorporation", this.UnderlyingSecurityIssuerCountryofIncorporation); /*Optional 28*/
            reader.GetInt("id_SavedFiles_CSV", this.id_SavedFiles_CSV);                                                              /*Optional 29*/
            reader.GetInt("DividendIndex", this.DividendIndex);                                                                      /*Optional 30*/
            reader.GetString("AnnouncementType", this.AnnouncementType);                                                             /*Optional 31*/
            reader.GetInt("ID_GTS_SFTP_InputSITEs", this.ID_GTS_SFTP_InputSITEs);                                                    /*Optional 32*/
            reader.GetInt("recNum", this.recNum);                                                                                    /*Optional 33*/
            reader.GetBool("flgEmailSent", this.flgEmailSent);                                                                       /*Optional 34*/
            reader.GetDateTime("EmailSentDate", this.EmailSentDate);                                                                 /*Optional 35*/

            this.SyncWithDB();
        }
예제 #4
0
파일: SPR_file.cs 프로젝트: huangss0/GTS0
        internal void Init_from_reader(HssUtility.SQLserver.DB_reader reader)
        {
            if (reader == null || reader.IsClosed)
            {
                return;
            }

            this.pk_ID = reader.GetInt("ID");
            reader.GetString("FileName", this.FileName);                 /*Optional 2*/
            reader.GetDateTime("CreateTime", this.CreateTime);           /*Optional 3*/
            this.FileBinary = reader.GetBytes("FileBinary");             /*Optional 4*/
            reader.GetString("CreateBy", this.CreateBy);                 /*Optional 5*/
            reader.GetInt("Status", this.Status);                        /*Optional 6*/
            reader.GetString("CUSIP", this.CUSIP);                       /*Optional 7*/
            reader.GetDateTime("RecordDate", this.RecordDate);           /*Optional 8*/
            reader.GetString("SecurityName", this.SecurityName);         /*Optional 9*/
            reader.GetDateTime("LastModifyAt", this.LastModifyAt);       /*Optional 10*/
            reader.GetString("LastModifyBy", this.LastModifyBy);         /*Optional 11*/
            reader.GetString("LastModifyAction", this.LastModifyAction); /*Optional 12*/

            this.SyncWithDB();
        }