public AUOperationLogCollection Load(IConnectiveSqlClause sqlClause) { AUOperationLogCollection result = null; AUCommon.DoDbAction(() => { VersionedObjectAdapterHelper.Instance.FillData(GetMappingInfo().TableName, sqlClause, this.GetConnectionName(), (view) => { result = new AUOperationLogCollection(); ORMapping.DataViewToCollection(result, view); }); }); return(result); }
public AUOperationLogCollection Load(IConnectiveSqlClause sqlClause) { AUOperationLogCollection result = null; AUCommon.DoDbAction(() => { VersionedObjectAdapterHelper.Instance.FillData(GetMappingInfo().TableName, sqlClause, this.GetConnectionName(), (view) => { result = new AUOperationLogCollection(); ORMapping.DataViewToCollection(result, view); }); }); return result; }
/// <summary> /// 注意,这个仅供首页显示使用。属性不全 /// </summary> /// <param name="count"></param> /// <returns></returns> public AUOperationLogCollection LoadRecentSummaryLog(int count) { string sql = "SELECT TOP " + count + " Subject,CreateTime FROM SC.OperationLog ORDER BY ID DESC"; AUOperationLogCollection result = new AUOperationLogCollection(); using (DbContext context = DbContext.GetContext(this.GetConnectionName())) { Database db = DatabaseFactory.Create(context); using (var dr = db.ExecuteReader(System.Data.CommandType.Text, sql)) { while (dr.Read()) { result.Add(new AUOperationLog() { Subject = dr["Subject"].ToString(), CreateTime = (DateTime)dr["CreateTime"] }); } } } return(result); }
/// <summary> /// 注意,这个仅供首页显示使用。属性不全 /// </summary> /// <param name="count"></param> /// <returns></returns> public AUOperationLogCollection LoadRecentSummaryLog(int count) { string sql = "SELECT TOP " + count + " Subject,CreateTime FROM SC.OperationLog ORDER BY ID DESC"; AUOperationLogCollection result = new AUOperationLogCollection(); using (DbContext context = DbContext.GetContext(this.GetConnectionName())) { Database db = DatabaseFactory.Create(context); using (var dr = db.ExecuteReader(System.Data.CommandType.Text, sql)) { while (dr.Read()) { result.Add(new AUOperationLog() { Subject = dr["Subject"].ToString(), CreateTime = (DateTime)dr["CreateTime"] }); } } } return result; }