public IHttpActionResult YMBZList(PBE_STDVACCINE info)
{
using (ZDSYYC db = new ZDSYYC())
{
var sql = "select t1.DAYS, t1.vaccine,t1.qty,t2.name VARIETY from PBE_STDVACCINE t1 join PBE_VACCINE t2 on( t1.vaccine = t2.code )";
var query = db.ExecuteSqlToList <PBE_STDVACCINE>(sql).ToList();
return(Succeed(query));
}
}
public IHttpActionResult ProjectAll(PBE_PROJECT info)
{
using (ZDSYYC db = new ZDSYYC())
{
if (info.USER1 == "admin")
{
var sql = "select user1 from PBE_PROJECT t";
var query = db.ExecuteSqlToList <PBE_PROJECT>(sql).ToList().Count();
return(Succeed(query));
}
else
{
var sql = "select user1 from PBE_PROJECT t where t.user1 = '" + info.USER1 + "'";
var query = db.ExecuteSqlToList <PBE_PROJECT>(sql).ToList().Count();
return(Succeed(query));
}
}
}
public IHttpActionResult ProjectList(PBE_PROJECT info)
{
decimal startNUM = info.INDAY * info.OUTDAY - info.OUTDAY;
decimal endNUM = startNUM + info.OUTDAY;
using (ZDSYYC db = new ZDSYYC())
{
if (info.USER1 == "admin")
{
var sql = "select tt.* ,rownum INDAY from(select user1,project,inwgt,outday,outwgt,pigletqty,indate,cullingrate,perfectrate,noperfrate,noperfwgtrate,noperfpricerate,adjustfee from PBE_PROJECT t order by project) tt";
var query = db.ExecuteSqlToList <PBE_PROJECT>(sql);
query = query.Where(s => s.INDAY > startNUM & s.INDAY <= endNUM).ToList();
return(Succeed(query));
}
else
{
var sql = "select tt.* ,rownum INDAY from(select user1,project,inwgt,outday,outwgt,pigletqty,indate,cullingrate,perfectrate,noperfrate,noperfwgtrate,noperfpricerate,adjustfee from PBE_PROJECT t where " +
" t.user1 = '" + info.USER1 + "'order by project) tt";
var query = db.ExecuteSqlToList <PBE_PROJECT>(sql);
query = query.Where(s => s.INDAY > startNUM & s.INDAY <= endNUM).ToList();
return(Succeed(query));
}
}
}
public IHttpActionResult ProjectDetail(PBE_PROJECT info)
{
using (ZDSYYC db = new ZDSYYC())
{
var query1 = db.PBE_VACCINECOST.AsQuery().Where(w => w.PROJECT == info.PROJECT).ToList(); //疫苗标准
var query2 = db.PBE_FEEDCOST.AsQuery().Where(w => w.PROJECT == info.PROJECT).ToList(); //饲料标准
var sql = "select user1,project,inday,inwgt,outday,outwgt,pigletqty,indate,cullingrate,perfectrate,noperfrate,noperfwgtrate,noperfpricerate,adjustfee from PBE_PROJECT t where t.project = '" + info.PROJECT + "'";
var query3 = db.ExecuteSqlToList <PBE_PROJECT>(sql).ToList();
var query4 = db.PBE_MEDICINECOST.AsQuery().Where(w => w.PROJECT == info.PROJECT).ToList(); //药品标准
var query5 = db.PBE_PIGLETCOST.AsQuery().Where(w => w.PROJECT == info.PROJECT).ToList(); //猪苗标准
var query6 = db.PBE_PIGMARKETPRICE.AsQuery().Where(w => w.PROJECT == info.PROJECT).ToList(); //种猪标准
var query = new { ymlist = query1, sllist = query2, rllist = query3, yplist = query4, zmlist = query5, zzlist = query6 };
return(Succeed(query));
}
}
