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