//Audit Trail methods

        //Evaluates Initialize when->Reading record formulas specified at the data access layer
        protected virtual void AreaNotesRecord_ReadRecord(Object sender, System.EventArgs e)
        {
            //Apply Initialize->Reading record formula only if validation is successful.
            AreaNotesRecord AreaNotesRec = (AreaNotesRecord)sender;

            if (AreaNotesRec != null && !AreaNotesRec.IsReadOnly)
            {
            }
        }
        //Evaluates Initialize when->Updating formulas specified at the data access layer
        protected virtual void AreaNotesRecord_UpdatingRecord(Object sender, System.ComponentModel.CancelEventArgs e)
        {
            //Apply Initialize->Updating formula only if validation is successful.
            AreaNotesRecord AreaNotesRec = (AreaNotesRecord)sender;

            Validate_Updating();
            if (AreaNotesRec != null && !AreaNotesRec.IsReadOnly)
            {
                AreaNotesRec.Parse(EvaluateFormula("UserID()", this, null), AreaNotesTable.UpdatedBy);
                AreaNotesRec.Parse(EvaluateFormula("Today()", this, null), AreaNotesTable.UpdatedOn);
            }
        }
示例#3
0
        /// <summary>
        /// This is a shared function that can be used to get a AreaNotesRecord record using a where and order by clause.
        /// </summary>
        public static AreaNotesRecord GetRecord(BaseFilter join, string where, OrderBy orderBy)
        {
            SqlFilter whereFilter = null;

            if (where != null && where.Trim() != "")
            {
                whereFilter = new SqlFilter(where);
            }

            ArrayList recList = AreaNotesTable.Instance.GetRecordList(join, whereFilter, null, orderBy, BaseTable.MIN_PAGE_NUMBER, BaseTable.MIN_BATCH_SIZE);

            AreaNotesRecord rec = null;

            if (recList.Count > 0)
            {
                rec = (AreaNotesRecord)recList[0];
            }

            return(rec);
        }