Ejemplo n.º 1
0
 public static void Create(Db db, DbAudit a, DbAuditArgs arg)
 {
     TableAuditTypes auditType = db.GetTableAuditType(arg.Table.TableName);
     if(auditType == TableAuditTypes.Default)
         auditType = Db.DefaultTableAuditType;
     switch (auditType)
     {
         case TableAuditTypes.SharedTable:
             CreateAuditInShareTable(db, a, arg);
             break;
         case TableAuditTypes.StandaloneTable:
             CreateAuditStandaloneTable(db, a, arg);
             break;
     }
 }
Ejemplo n.º 2
0
        static void CreateAuditInShareTable(Db db, DbAudit a, DbAuditArgs arg)
        {
            Dictionary<string, object> dic = (Dictionary<string, object>)arg.Data;
            DbTable table = db.GetDbTable(typeof(DbAuditDetail));

            //assume newvalue and oldvalue are same size
            int maxValueSize = table.Fields["NEWVALUE"].Length;

            DataRow oldRow = null;
            if (arg.Action == ExecTypes.Update)
            {
                oldRow = db.SelectRow(arg.Table, dic);
            }

            INextIdProvider nextId = db.NextIdProvider;
            foreach (KeyValuePair<string, object> kvp in dic)
            {
                DbAuditDetail ad = new DbAuditDetail(a.Id);
                ad.Id = nextId.Get();
                ad.FieldName = kvp.Key;

                string newValue = GetValue(db, arg.Table, kvp.Key, kvp.Value, maxValueSize);

                switch (arg.Action)
                {
                    case ExecTypes.Insert:
                        ad.NewValue = newValue;
                        ad.Changed = false;
                        break;
                    case ExecTypes.Update:
                        ad.NewValue = newValue;

                        if (oldRow != null)
                        {
                            string oldValue = GetValue(db, arg.Table, kvp.Key, oldRow[kvp.Key], maxValueSize);
                            ad.OldValue = oldValue;
                            ad.Changed = !DbHelper.IsEqual(kvp.Value, oldRow[kvp.Key]);
                        }
                        break;
                    case ExecTypes.Delete:
                        ad.OldValue = newValue;
                        ad.Changed = false;
                        break;
                }

                db.Insert<DbAuditDetail>(ad);
            }
        }
Ejemplo n.º 3
0
        public static DbAudit Create(Db db, DbAuditArgs arg)
        {
            if (!db.IsAuditEnabled(arg.Table.TableName))
                return null;

            DbAudit a = new DbAudit();
            INextIdProvider nextId = db.NextIdProvider;
            if (nextId != null)
            {
                a.Id = nextId.Get();
            }
            a.Action = arg.Action.ToString();
            a.TableName = arg.Table.TableName;
            IUserInfoProvider userInfo = db.UserInfoProvider;
            if (userInfo != null)
            {
                a.UserName = userInfo.UserName;
                a.HostName = userInfo.HostName;
                a.IPAddress = userInfo.IPAddress;
                a.OSUser = userInfo.OSUser;
            }
            IFunctionInfoProvider funcInfo = db.FunctionInfoProvider;
            if (funcInfo != null)
            {
                a.FunctionId = funcInfo.Id;
            }

            if (arg.Data != null && !(arg.Data is Dictionary<string, object>))
            {
                a.Remarks = arg.Data.ToString();
            }
            else if(arg.Action == ExecTypes.Delete)
            {
                a.Remarks = arg.Sql;
            }

            db.Insert<DbAudit>(a);

            //details
            if (arg.Data is Dictionary<string, object>)
            {
                DbAuditDetail.Create(db, a, arg);
            }

            return a;
        }
Ejemplo n.º 4
0
 static void CreateAuditStandaloneTable(Db db, DbAudit a, DbAuditArgs arg)
 {
     switch (arg.Action)
     {
         case ExecTypes.Insert:
         case ExecTypes.Update:
         case ExecTypes.Delete:
             string historyTableName = String.Format("{0}_Audit", arg.Table.TableName);
             DbTable historyTable = db.GetDbTable(historyTableName);
             historyTable.DefaultAuditType = TableAuditTypes.None;
             Dictionary<string, object> dic = (Dictionary<string, object>)arg.Data;
             dic.Add(DbFieldNames.AuditId, a.Id);
             db.Insert(historyTable, dic);
             break;
     }
 }
Ejemplo n.º 5
0
 protected void DoAudit(DbAuditArgs arg)
 {
     DbAudit.Create(this, arg);
 }