public HistoryImport GetResultImportList(HistoryQuery import, int action)
{
var result = new HistoryImport { HistoryItem = new List<ResultImport>(), PageInfo = new PageInfo() };
var cmd = new DataCommand("SearchImportData", new SqlCustomDbCommand());
var whereStr = new StringBuilder();
if (import.DeviceId == null || import.DeviceId==0)
{
if (!string.IsNullOrEmpty(import.ObjectId.ToString()))
{
whereStr.Append(string.Format(" and import.ObjectID={0}", import.ObjectId));
}
}
else
{
whereStr.Append(string.Format(" and import.ObjectID={0}", import.DeviceId));
}
if (!string.IsNullOrEmpty(import.Starttime.ToString()))
{
whereStr.Append(string.Format(" and import.Starttime>='{0}'", import.Starttime));
}
if (!string.IsNullOrEmpty(import.Endtime.ToString()))
{
whereStr.Append(string.Format(" and import.Starttime<='{0}'", import.Endtime));
}
if (!string.IsNullOrEmpty(import.ItemCode))
{
whereStr.Append(string.Format(" and import.ItemCode='{0}'", import.ItemCode));
}
if (!string.IsNullOrEmpty(import.DateUnit.ToString(CultureInfo.InvariantCulture)))
{
whereStr.Append(string.Format(" and import.MonthType={0}", import.DateUnit));
}
cmd.SetParameterValue("@action", action);
cmd.ReplaceParameterValue("#whereStr#", whereStr.ToString());
cmd.ReplaceParameterValue("#pagesize#",import.PaddingInfo.PageSize.ToString(CultureInfo.InvariantCulture));
cmd.ReplaceParameterValue("#pagenums#", ((import.PaddingInfo.Page - 1) * import.PaddingInfo.PageSize).ToString(CultureInfo.InvariantCulture));
result.HistoryItem = cmd.ExecuteEntityList<ResultImport>();
foreach (var item in result.HistoryItem)
{
item.ObjectName = GetObjectName(item.IsArea, item.ObjectId);
}
result.PageInfo.Total = (int)cmd.GetParameterValue("@Count");
return result;
}
/// <summary>
/// 显示导入的历史记录
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public HistoryImport GetResultImportList(HistoryQuery query)
{
var action = 0;
if (query.ObjectId != null)
{
action = 1;
}
var dataResult = _import.GetResultImportList(query,action);
try
{
dataResult.PageInfo.CuttrentPage = query.PaddingInfo.Page;
dataResult.PageInfo.Pages = dataResult.PageInfo.Total % query.PaddingInfo.PageSize == 0
? dataResult.PageInfo.Total / query.PaddingInfo.PageSize
: dataResult.PageInfo.Total / query.PaddingInfo.PageSize + 1;
dataResult.Success = true;
dataResult.ErrorMsg = string.Empty;
}
catch (Exception e)
{
dataResult.Success = false;
dataResult.ErrorMsg = e.Message;
}
return dataResult;
}
