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