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;
}
