public SCOperationLogCollection Load(IConnectiveSqlClause sqlClause) { SCOperationLogCollection result = null; VersionedObjectAdapterHelper.Instance.FillData(GetMappingInfo().TableName, sqlClause, this.GetConnectionName(), (view) => { result = new SCOperationLogCollection(); ORMapping.DataViewToCollection(result, view); }); return result; }
public SCOperationLogCollection Load(IConnectiveSqlClause sqlClause) { SCOperationLogCollection result = null; VersionedObjectAdapterHelper.Instance.FillData(GetMappingInfo().TableName, sqlClause, this.GetConnectionName(), (view) => { result = new SCOperationLogCollection(); ORMapping.DataViewToCollection(result, view); }); return(result); }
/// <summary> /// 注意,这个仅供首页显示使用。属性不全 /// </summary> /// <param name="count"></param> /// <returns></returns> public SCOperationLogCollection LoadRecentSummaryLog(int count) { string sql = "SELECT TOP " + count + " Subject,CreateTime FROM SC.OperationLog ORDER BY ID DESC"; SCOperationLogCollection result = new SCOperationLogCollection(); 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 SCOperationLog() { Subject = dr["Subject"].ToString(), CreateTime = (DateTime)dr["CreateTime"] }); } } } return result; }
/// <summary> /// 注意,这个仅供首页显示使用。属性不全 /// </summary> /// <param name="count"></param> /// <returns></returns> public SCOperationLogCollection LoadRecentSummaryLog(int count) { string sql = "SELECT TOP " + count + " Subject,CreateTime FROM SC.OperationLog ORDER BY ID DESC"; SCOperationLogCollection result = new SCOperationLogCollection(); 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 SCOperationLog() { Subject = dr["Subject"].ToString(), CreateTime = (DateTime)dr["CreateTime"] }); } } } return(result); }