Exemple #1
0
        public object Insert(tCRICatalogRow pRow)
        {
            NewRow();

            Columns.sintObjectId  = pRow.sintObjectId;
            Columns.sintIdCl      = pRow.sintIdCl;
            Columns.vchIdMao      = pRow.vchIdMao;
            Columns.chrObjectType = pRow.chrObjectType;
            Columns.vchMatricule  = pRow.vchMatricule;
            Columns.intCreateDate = pRow.intCreateDate;
            Columns.intDeleteDate = pRow.intDeleteDate;
            Columns.dtmCreateDate = pRow.dtmCreateDate;
            Columns.dtmDeleteDate = pRow.dtmDeleteDate;
            Columns.dtmLoaded     = pRow.dtmLoaded;
            Columns.bitVisible    = pRow.bitVisible;

            object lResult = Apply(TConnectionSQL.ExecuteType.ExecuteScalar);

            return(lResult);
        }
Exemple #2
0
        public object Update(tCRICatalogRow pRow)
        {
            if (base.Eof() || (this.Columns.sintObjectId != pRow.sintObjectId))
            {
                GetDataByID(pRow.sintObjectId);
            }

            Columns.sintObjectId  = pRow.sintObjectId;
            Columns.sintIdCl      = pRow.sintIdCl;
            Columns.vchIdMao      = pRow.vchIdMao;
            Columns.chrObjectType = pRow.chrObjectType;
            Columns.vchMatricule  = pRow.vchMatricule;
            Columns.intCreateDate = pRow.intCreateDate;
            Columns.intDeleteDate = pRow.intDeleteDate;
            Columns.dtmCreateDate = pRow.dtmCreateDate;
            Columns.dtmDeleteDate = pRow.dtmDeleteDate;
            Columns.dtmLoaded     = pRow.dtmLoaded;
            Columns.bitVisible    = pRow.bitVisible;

            object lResult = Apply(TConnectionSQL.ExecuteType.ExecuteScalar);

            return(lResult);
        }