public EditModelCSV GetPrevCsvGuid(string guid, EnumCsvType enumCsvType, string projectGuid, string asOfDate) { var sameTypeList = GetByCsvType(enumCsvType, projectGuid, asOfDate); var createTime = sameTypeList.Where(x => x.Guid == guid).FirstOrDefault().CreateTime; var prevModelCsv = sameTypeList.Where(x => x.CreateTime < createTime).OrderByDescending(x => x.CreateTime).FirstOrDefault(); if (prevModelCsv != null) { return(prevModelCsv); } ; return(null); }
public List <EditModelCSV> GetByCsvType(EnumCsvType csvType, string projectGuid, string asOfDate) { var querys = Select <TableEditModelCSV>("type", csvType.ToString()).Where(x => x.project_guid == projectGuid && x.asofdate == asOfDate).OrderByDescending(x => x.create_time); return(querys.ToList().ConvertAll(x => new EditModelCSV(x))); }