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