/// <summary>
/// 获取导出的数据
/// </summary>
/// <param name="user">查询条件</param>
/// <returns>数据</returns>
public DataTable GetExportData(SystemOperateLog log)
{
DataTable dt = null;
string sql = null;
List <DataParameter> parameters = new List <DataParameter>();
try
{
//构成查询语句
sql = this.GetQuerySql(log, ref parameters);
sql += " ORDER BY OPERATETIME DESC";
using (IDataSession session = AppDataFactory.CreateMainSession())
{
dt = session.GetTable(sql, parameters.ToArray());
dt.TableName = "SystemOperateLog";
}
return(dt);
}
catch (Exception ex)
{
throw;
}
}
/// <summary>
/// 获取导出的数据
/// </summary>
/// <param name="user">查询条件</param>
/// <returns>数据</returns>
public DataTable GetExportData(ProductInfo model)
{
DataTable dt = null;
string sql = null;
List <DataParameter> parameters = new List <DataParameter>();
try
{
//构成查询语句
sql = this.GetQuerySql(model, ref parameters);
using (IDataSession session = AppDataFactory.CreateMainSession())
{
dt = session.GetTable(sql, parameters.ToArray());
dt.TableName = "ProductInfo";
}
return(dt);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取质量追溯产品列表
/// </summary>
/// <param name="user">查询条件</param>
/// <returns>数据</returns>
public DataTable GetExportData(QualityTraceCondition condition)
{
DataTable dt = null;
string sql = null;
List <DataParameter> parameters = new List <DataParameter>();
try
{
//构成查询语句
sql = this.GetQuerySql(condition, ref parameters);
using (IDataSession session = AppDataFactory.CreateMainSession())
{
dt = session.GetTable(sql, parameters.ToArray());
dt.TableName = "T_FP_GoodInfo";
}
return(dt);
}
catch (Exception ex)
{
throw ex;
}
}
