public List <AuditViewModel> GetAuditNo(GetAuditNo request) { if (null == request.id) { throw new Exception("参数异常"); } var _year = System.DateTime.Now.Year; using (var db = DbFactory.Open()) { if (request.typeid == null) { var builder = db.From <Model.Audit.Audit>(); builder.LeftJoin <Model.Audit.Audit, AuditDetails>((x, y) => x.ID == y.AuditID && y.AuditNums == request.nums.Value); builder.Where(x => x.Year == _year && x.ID == request.id); builder.OrderByDescending(w => w.TownAddTime); var rlist = db.Select <AuditViewModel>(builder); return(rlist); } else { var builder = db.From <AuditCounty>(); builder.LeftJoin <AuditCounty, AuditCountyDetails>((x, y) => x.ID == y.CountyID && y.AuditNums == request.nums.Value); builder.Where(x => x.Year == _year && x.ID == request.id); builder.OrderByDescending(w => w.CountyAddTime); var rlist = db.Select <AuditViewModel>(builder); return(rlist); } } }
public List <AuditViewModel> GET(GetAuditNo request) { return(AuditManager.GetAuditNo(request)); }