public string GetGageLedgerDownloadURL(GageFilter Filter)
{
string excel_name = new GageServiceImpl().ExportGageLedgerToExcel(Filter);
if (excel_name != null)
{
return("http://192.168.9.49:8020/report/" + excel_name);
}
else
{
return(null);
}
}
public IEnumerable <Gage> SelectBy(GageFilter Filter)
{
List <Gage> result1 = Gage.CombineSelectByStatuses(Filter.Statuses);
List <Gage> result2 = Gage.RangeSelectByNextAdjustDate(Filter.NextAdjustDate);
List <Gage> result3 = Gage.CombineSelectByStandardAdjustType(Filter.StandardAdjustType);
if (result1 == null || result2 == null || result3 == null)
{
return(null);
}
result1 = result1.Where(a => result2.Exists(t => a.AssetID == t.AssetID)).ToList();
result1 = result1.Where(a => result3.Exists(t => a.AssetID == t.AssetID)).ToList();
IEnumerable <Gage> final_result = result1;
return(final_result.Count() == 0 ? null : final_result);
}
public string ExportGageLedgerToExcel(GageFilter Filter)
{
IEnumerable <Gage> Gages = SelectBy(Filter);
if (Gages != null)
{
List <Gage> asList = Gages.ToList();
Common.ConvertHelper.ListToTable(asList);
XLWorkbook wb = new XLWorkbook();
DataTable dt = Common.ConvertHelper.ListToTable(asList);
wb.Worksheets.Add(dt, "量具信息");
string CurDir = AppDomain.CurrentDomain.BaseDirectory + @"SaveDir\";
string excel_name = "gage_ledger_" + new Random().Next() + ".xlsx";
string filePath = CurDir + excel_name;
wb.SaveAs(filePath);
return(excel_name);
}
return(null);
}
public GageFilter GetFilterValue()
{
GageFilter FilterValue = GageFilter.GetFilterValue();
return(FilterValue);
}
public IEnumerable <Gage> SelectBy(GageFilter Filter)
{
IEnumerable <Gage> Gages = new GageServiceImpl().SelectBy(Filter);
return(Gages);
}
