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