static public BindingList<DdChangeLogExt> GetChangeLogList( string targetTableName, int targetTableREF, int maxCount = 1000) { try { string sqlOrder = "Id desc"; string sqlWhere = string.Format("(Id != 1) and (FsaRevisionLogREF = 1)" + " and (TargetTableName = '{0}') and (TargetTableREF = '{1}')", targetTableName, targetTableREF); using (ASL.SQL.DBConnection cnx = DataStore.CloneDbConnection()) { DaChangeLog daChangeLog = new DaChangeLog(cnx); using (SqlDataReader reader = daChangeLog.GetReader(sqlWhere, sqlOrder)) { BindingList<DdChangeLogExt> list = new BindingList<DdChangeLogExt>(); while (reader.Read() && list.Count < maxCount) { DdChangeLog dd = DaChangeLog.LoadRow(reader); list.Add(new DdChangeLogExt(dd)); } return list; } } } catch (Exception exc) { System.Diagnostics.Debug.WriteLine(exc.ToString()); throw; } }
static public BindingList<DdChangeLogExt> GetChangeLogList( DateTime dateFrom, DateTime dateThru, bool includePreviousRevs, int maxCount = 1000) { try { string sqlOrder = "Id desc"; string sqlWhere = string.Format("(Id != 1) and " + "(Created >= '{0:MM/dd/yyyy}') and (Created <= '{1:MM/dd/yyyy}')", dateFrom.Date, dateThru.AddDays(1).Date); if (!includePreviousRevs) sqlWhere += " and (FsaRevisionLogREF = 1)"; using (ASL.SQL.DBConnection cnx = DataStore.CloneDbConnection()) { DaChangeLog daChangeLog = new DaChangeLog(cnx); using (SqlDataReader reader = daChangeLog.GetReader(sqlWhere, sqlOrder)) { BindingList<DdChangeLogExt> list = new BindingList<DdChangeLogExt>(); while (reader.Read() && list.Count < maxCount) { DdChangeLog dd = DaChangeLog.LoadRow(reader); list.Add(new DdChangeLogExt(dd)); } return list; } } } catch (Exception exc) { System.Diagnostics.Debug.WriteLine(exc.ToString()); throw; } }