public IHttpActionResult AddYieldCheck([FromBody] WvYieldCheckBindingModel yieldCheck)
{
if (yieldCheck == null)
{
return(NotFound());
}
var addYield = new peAppWvYieldCheck()
{
inputdate = yieldCheck.inputdate.AsDateTime(),
inputclass = yieldCheck.inputclass,
name1 = yieldCheck.name1,
name2 = yieldCheck.name2,
name3 = yieldCheck.name3,
machineno = yieldCheck.machineno,
gfno = yieldCheck.gfno,
itemname = yieldCheck.itemname.Substring(5),// 截取“加产 - ”后的字符串写入数据库
value1 = yieldCheck.value1,
value2 = yieldCheck.value2,
Audit = "待审",
remark = yieldCheck.Remark,
WorkerType = yieldCheck.WorkerType
};
wvmDb.peAppWvYieldChecks.Add(addYield);
wvmDb.SaveChanges();
return(Ok());
}
public IHttpActionResult GetYieldCheck([FromUri] string name, string WorkerType)
{
var query =
@"
SELECT DISTINCT c.Id ,
c.inputdate ,
c.inputclass ,
d.name as name1,
e.name as name2,
f.name as name3,
c.machineno ,
c.gfno ,
c.itemname ,
c.value1 ,
c.value2 ,
c.Audit ,
c.remark ,
c.input_time ,
c.WorkerType FROM dbo.peAppWvYieldCheck c
left join peAppWvWorker d on c.name1=d.cardno
left join peAppWvWorker e on c.name2=e.cardno
left join peAppWvWorker f on c.name3=f.cardno
where c.inputclass IN (SELECT DISTINCT g.class FROM dbo.peAppWvWorker AS g WHERE g.name=@p0) AND c.WorkerType=@p1 AND d.factory IN (SELECT g.factory FROM dbo.peAppWvWorker AS g WHERE g.name=@p0) and c.name1 like 'GET%'
";
List <peAppWvYieldCheck> yieldCheckQuery =
wvmDb.Database.SqlQuery <peAppWvYieldCheck>(query, name, WorkerType).ToList();
List <WvYieldCheckBindingModel> rtnList = new List <WvYieldCheckBindingModel>();
foreach (var y in yieldCheckQuery)
{
var yield = new WvYieldCheckBindingModel
{
Id = y.Id,
inputdate = y.inputdate.ToString("yyyy-MM-dd"), // 修改为date类型
inputclass = y.inputclass,
name1 = y.name1,
name2 = y.name2,
name3 = y.name3,
machineno = y.machineno,
gfno = y.gfno,
itemname = y.itemname,
value1 = y.value1 - y.value2,// 加产正数，减产负数
value2 = y.value2,
Audit = y.Audit,
WorkerType = y.WorkerType
};
rtnList.Add(yield);
}
return(Json(rtnList));
}
