/// <summary>
/// 根据日期获取数据
/// </summary>
/// <param name="date">日期</param>
/// <param name="loginName">登录用户</param>
/// <returns></returns>
public DataSet GetData(DateTime date, string loginName)
{
ICallDatabase dr = new CallDatabase();
dr.InitiCommand();
dr.CommandText = "select Login_Name,Result,ResultsDescribed,Creation_Date from [Log_Login] where DateDiff(day,Creation_Date,@Creation_Date)=0 And [Login_Name] like @Login_Name order by [Creation_Date] desc";
dr.AddParameters("Creation_Date", DbType.String, 20, date.ToString());
dr.AddParameters("Login_Name", DbType.String, 50, "%" + loginName + "%");
DataSet data = dr.DataList();
dr.Close();
dr.Dispose();
return(data);
}
protected virtual void Dispose(bool disposed)
{
//检查处置是否已经调用。
if (!m_disposed)
{
//如果处置等于true，处置所有被管理
//和非托管资源。
if (disposed)
{
dr.Dispose(); //释放用户表的数据库访问
}
//非托管资源
m_disposed = true;
}
}
/// <summary>
/// 根据主键来获取数据集
/// </summary>
/// <param name="id">主键</param>
/// <returns></returns>
public DataSet GetData(int id, out DataTable log_Contents_Data)
{
log_Contents_Data = new DataTable();
ICallDatabase dr = new CallDatabase();
dr.InitiCommand();
dr.CommandText = "select Login_Name,ModuleName,OperationType,Result,ResultsDescribed,Creation_Date from [Log_Operating] where Id=@Id ";
dr.AddParameters("Id", DbType.Int32, id);
DataSet data = dr.DataList();
dr.CommandText = "select Contents from [Log_Operating_Contents] where L_Id=@Id order by [No]";
log_Contents_Data = dr.DataList().Tables[0];
dr.Close();
dr.Dispose();
return(data);
}