public IHttpActionResult Puttiqclog(long id, tiqclog tiqclog) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != tiqclog.id) { return(BadRequest()); } db.Entry(tiqclog).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!tiqclogExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult Gettiqclog(long id) { tiqclog tiqclog = db.tiqclog.Find(id); if (tiqclog == null) { return(NotFound()); } return(Ok(tiqclog)); }
public IHttpActionResult Posttiqclog(tiqclog tiqclog) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.tiqclog.Add(tiqclog); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = tiqclog.id }, tiqclog)); }
public IHttpActionResult Deletetiqclog(long id) { tiqclog tiqclog = db.tiqclog.Find(id); if (tiqclog == null) { return(NotFound()); } db.tiqclog.Remove(tiqclog); db.SaveChanges(); return(Ok(tiqclog)); }
public IHttpActionResult SaveIQC(dynamic para) { //处理submaindata //dynamic[] submainAry = new List<dynamic>().ToArray(); List <dynamic> submainList = new List <dynamic>(); for (int i = 0; i < para.subform.Count; i++) { submainList.Add(JarrayToDynamic(para.subform[i])); } //处理mainformdata dynamic mainformdata = JarrayToDynamic(para.mainform); //var d = JsonConvert.DeserializeObject<Dictionary<string, dynamic>>(mainformdata); //tiqclog iqclogdata =(tiqclog)mainformdata; using (var context = new DBModel()) { using (var dbContextTransaction = context.Database.BeginTransaction()) { try { //insert mianformdata var iqclog = new tiqclog { incomingno = (string)mainformdata.txtIncomingNo, inspectiontime = Convert.ToDateTime(mainformdata.txtInspectionTime), supplycompany = (string)mainformdata.ddlSupply, materialtype = (string)mainformdata.ddlMaterialType, pinmin = (string)mainformdata.txtPinmin, thinkness = Convert.ToInt32(mainformdata.txtThinkness), width = Convert.ToInt32(mainformdata.txtWidth), length = Convert.ToInt32(mainformdata.txtLength), incomingqty = Convert.ToInt32(mainformdata.txtDeliveryQty), createuser = para.userid.ToString(), result = Convert.ToInt16(para.result) == 1 ? true : false }; context.tiqclogs.Add(iqclog); context.SaveChanges(); long detailtableid = iqclog.id; long tempid; string templot; tempid = detailtableid; templot = (string)mainformdata.txtIncomingNo; //insert subformdata foreach (var item in submainList) { //var iqcdetaillog = new tiqcdetaillog(); foreach (KeyValuePair <string, object> kvp in item) { string tempsublot; int tempno; string result; //tempsublot = kvp.Value.ToString(); tempno = Convert.ToInt32(Regex.Replace(kvp.Key.ToString(), @"[^\d.\d]", "")); //var detailresult = db.tiqcdetailresultlogs.SingleOrDefault(e => e.id == tempid && e.lot == templot && e.no == tempno); var a = kvp; if (kvp.Key.ToString().Contains("Result")) { //var resultresult = db.tiqcdetailresultlogs.SingleOrDefault(e => e.id == tempid && e.lot == templot && e.no == tempno); //if (detailresult != null) //{ // detailresult.result = kvp.Value.ToString(); //} //else { var iqcdetailresultlog = new tiqcdetailresultlog { id = tempid, lot = templot, //进料单号 paraid = kvp.Key.ToString(), //检验类型 result = kvp.Value.ToString(), //检验结果 no = tempno //第几个批次 }; context.tiqcdetailresultlogs.Add(iqcdetailresultlog); } //context.SaveChanges(); } //保存抽检子批次号 else if (kvp.Key.ToString().Contains("txtLot")) { ////===================批次已经记录============================ //if (detailresult != null) //{ // detailresult.sublot = tempsublot; //} //else //===============批次还没记录============================ //{ // var iqcdetailresultlog = new tiqcdetailresultlog // { // id = tempid, // lot = templot, // //paraid = kvp.Key.ToString(), // sublot = kvp.Value.ToString(), // no = tempno // }; // context.tiqcdetailresultlogs.Add(iqcdetailresultlog); //} //context.SaveChanges(); } //保存检验内容 else { var iqcdetaillog = new tiqcdetaillog { id = detailtableid, lot = (string)mainformdata.txtIncomingNo, paratype = kvp.Key.ToString(), paraid = kvp.Value.ToString(), parasubtype = Regex.Replace(kvp.Key.ToString(), @"[^\d.\d]", ""), }; context.tiqcdetaillogs.Add(iqcdetaillog); } } context.SaveChanges(); // insert sublot into db foreach (KeyValuePair <string, object> kvp in item) { //保存抽检子批次号 if (kvp.Key.ToString().Contains("txtLot")) { int tempno = Convert.ToInt32(Regex.Replace(kvp.Key.ToString(), @"[^\d.\d]", "")); var res = context.tiqcdetaillogs.Where(a => a.id == tempid && a.parasubtype == tempno.ToString() && a.lot == templot).ToList(); res.ForEach(a => a.sublot = kvp.Value.ToString()); var detailres = context.tiqcdetailresultlogs.Where(a => a.id == tempid && a.lot == templot && a.no == tempno).ToList(); detailres.ForEach(a => a.sublot = kvp.Value.ToString()); } context.SaveChanges(); } } dbContextTransaction.Commit(); } catch (Exception ex) { dbContextTransaction.Rollback(); return(Json(new { result = "fail", msg = "" })); } } } //dynamic formdata = new ExpandoObject(); //var dic = (IDictionary<string, object>)formdata; ////遍历json数组 //foreach (var item in para) //{ // string name= item.name.ToString(); // //formdata.add() // dic.Add(item.name.ToString(), item.value.ToString()); //} //formdata.txtInspectionTime = "2018-9-23"; //var res = para[0]["value"]; //bool boolres= TestWithReflection(formdata, "txtInspectionTime"); return(Json(new { result = "success", msg = "" })); }