示例#1
0
        public static List <object> AddLog(string id, string Order, bool Dummy)
        {
            List <object>  result   = new List <object>();
            QuerySelectPDA q        = new QuerySelectPDA();
            string         BrLog    = "Select a.* from BrLog a where a.idBr=" + id + " Order by " + Order;
            string         BrLogDet = "Select * from BrLogDet where idlog=" + id + " Order by IdLogDet";

            if (Dummy)
            {
                q.Select(BrLog);
                List <DataRows> lst = q.GetRows();
                foreach (DataRows rows in lst)
                {
                    BrLog log = new BrLog();
                    log.LogType    = rows.FieldByName("LogType");
                    log.TableName  = rows.FieldByName("TableName");
                    log.TableDescr = rows.FieldByName("TableDescr");
                    log.RunDate    = rows.FieldByName("Rundate");
                    log.IdLog      = rows.FieldByName("idLog");
                    //log.ValueOld = rows.FieldByName("ValueOld");
                    //log.ValueNew = rows.FieldByName("ValueNew");
                    //
                    //log.FieldName = rows.FieldByName("FieldName");
                    //log.FieldDescr = rows.FieldByName("FieldDescr");
                    //if (log.ValueOld.TrimEnd(',', '0') != log.ValueNew.TrimEnd(',', '0'))
                    result.Add(log);
                }
            }
            else
            {
                q.Select(BrLogDet);
                List <DataRows> lst = q.GetRows();
                foreach (DataRows rows in lst)
                {
                    BrLogDet log = new BrLogDet();
                    log.FieldName  = rows.FieldByName("FieldName");
                    log.FieldDescr = rows.FieldByName("FieldDescr");
                    log.ValueOld   = rows.FieldByName("ValueOld");
                    log.ValueNew   = rows.FieldByName("ValueNew");
                    if (log.ValueOld.TrimEnd(',', '0') != log.ValueNew.TrimEnd(',', '0'))
                    {
                        result.Add(log);
                    }
                }
            }
            return(result);
        }
示例#2
0
 public static List<object> AddLog(string id, string Order, bool Dummy)
 {
     List<object> result = new List<object>();
     QuerySelectPDA q = new QuerySelectPDA();
     string BrLog = "Select a.* from BrLog a where a.idBr=" + id + " Order by " + Order;
     string BrLogDet = "Select * from BrLogDet where idlog=" + id + " Order by IdLogDet";
     if (Dummy)
     {
         q.Select(BrLog);
         List<DataRows> lst = q.GetRows();
         foreach (DataRows rows in lst)
         {
             BrLog log = new BrLog();
             log.LogType = rows.FieldByName("LogType");
             log.TableName = rows.FieldByName("TableName");
             log.TableDescr = rows.FieldByName("TableDescr");
             log.RunDate = rows.FieldByName("Rundate");
             log.IdLog = rows.FieldByName("idLog");
             //log.ValueOld = rows.FieldByName("ValueOld");
             //log.ValueNew = rows.FieldByName("ValueNew");
             //
             //log.FieldName = rows.FieldByName("FieldName");
             //log.FieldDescr = rows.FieldByName("FieldDescr");
             //if (log.ValueOld.TrimEnd(',', '0') != log.ValueNew.TrimEnd(',', '0'))
             result.Add(log);
         }
     }
     else
     {
         q.Select(BrLogDet);
         List<DataRows> lst = q.GetRows();
         foreach (DataRows rows in lst)
         {
             BrLogDet log = new BrLogDet();
             log.FieldName = rows.FieldByName("FieldName");
             log.FieldDescr = rows.FieldByName("FieldDescr");
             log.ValueOld = rows.FieldByName("ValueOld");
             log.ValueNew = rows.FieldByName("ValueNew");
             if (log.ValueOld.TrimEnd(',', '0') != log.ValueNew.TrimEnd(',', '0'))
             { result.Add(log); }
         }
     }
     return result;
 }