public SuccessResult DeleteById(int checkRecordId) { SuccessResult successResult = new SuccessResult(); successResult.Success = false; try { var objCheckRecord = new View_CheckRecordService().GetSugarQueryable(x => x.Id == checkRecordId).First(); var result = Db.Ado.UseTran(() => { Delete(checkRecordId); ProductService productService = new ProductService(); var objRecord = productService.GetSugarQueryable(x => x.ErpVoucherNo == objCheckRecord.ErpVoucherNo).First(); objRecord.QulityQty -= objCheckRecord.RecordQualityQty; productService.Update(objRecord); }); if (!result.IsSuccess) { throw new Exception(result.ErrorMessage); } successResult.Msg = "删除成功!"; successResult.Success = true; } catch (Exception ex) { successResult.Msg = ex.Message; } return(successResult); }
/// <summary> /// 根据生产单号获取订单数据 /// </summary> /// <returns></returns> public ActionResult GetModel(string orderNo) { SuccessResult successResult = new SuccessResult(); successResult.Success = false; try { //同步单据 string strMsg = ""; ParamaterFiled_DB PDB = new ParamaterFiled_DB(); PDB.GetVoucherNo(orderNo, ref strMsg, "1"); if (!string.IsNullOrEmpty(strMsg)) { successResult.Msg = strMsg; return(Json(successResult, JsonRequestBehavior.AllowGet)); } var product = new ProductService().GetList(x => x.ErpVoucherNo == orderNo).FirstOrDefault(); if (product == null) { successResult.Msg = "没有该订单!"; return(Json(successResult, JsonRequestBehavior.AllowGet)); } var records = new CheckRecordService().GetList(x => x.ProductOrderId == product.id); product.BackQualityQty = (records == null || records.Count() == 0) ? 0 : records.Sum(x => x.BackQualityQty); var orderNoQualityQty = new View_CheckRecordService().GetOrderNoQualityQty(orderNo); product.OrderNoQualityQty = orderNoQualityQty; successResult.Data = product; successResult.Success = true; } catch (Exception ex) { successResult.Msg = ex.Message; } return(Json(successResult, JsonRequestBehavior.AllowGet)); }
public SuccessResult Submit(string formJson, string orderId, string remark, string userNo) { SuccessResult successResult = new SuccessResult(); successResult.Success = false; try { ProductService productService = new ProductService(); var checkRecord = JsonConvert.DeserializeObject <T_CheckRecord>(formJson); var product = productService.GetById(Convert.ToInt32(orderId)); var records = new View_CheckRecordService() .GetSugarQueryable(x => x.ErpVoucherNo == product.ErpVoucherNo); var sumNoQualituQty = records.Sum(x => x.RecordNoQualityQty); var sumQualityQty = records.Sum(x => x.RecordQualityQty); var sumBackQualityQty = records.Sum(x => x.BackQualityQty); if (product.ProductQty == sumQualityQty && sumNoQualituQty - sumBackQualityQty == 0) { successResult.Msg = "该订单已检验完成,不能再检验!"; return(successResult); } if (checkRecord.BackQualityQty + sumBackQualityQty > sumNoQualituQty) { var shenyu = sumNoQualituQty - sumBackQualityQty; successResult.Msg = "复检合格数量 不能大于 订单不合格数量" + shenyu + ""; return(successResult); } var shengyu = product.ProductQty - (sumQualityQty + sumNoQualituQty); if (checkRecord.QualityQty + checkRecord.NoQualityQty > shengyu) { successResult.Msg = "合格数量+不合格数量不能大于 订单剩余数量" + shengyu + "!"; return(successResult); } T_CheckRecord queryData = new T_CheckRecord(); //一部/二部 queryData.Burning = checkRecord.Burning; queryData.WrongLabe = checkRecord.WrongLabe; queryData.Resistance = checkRecord.Resistance; queryData.WrongNumberControl = checkRecord.WrongNumberControl; queryData.DielectricStrength = checkRecord.DielectricStrength; queryData.GearBump = checkRecord.GearBump; queryData.AbnormalNoise = checkRecord.AbnormalNoise; queryData.BearingFailure = checkRecord.BearingFailure; queryData.InputPort = checkRecord.InputPort; queryData.OutPort = checkRecord.OutPort; queryData.MountingFlange = checkRecord.MountingFlange; queryData.InstallKeyway = checkRecord.InstallKeyway; queryData.InstallationShaftDiameter = checkRecord.InstallationShaftDiameter; queryData.InstallTheStop = checkRecord.InstallTheStop; queryData.BoltCenter = checkRecord.BoltCenter; queryData.NoLoad = checkRecord.NoLoad; queryData.RawMaterial = checkRecord.RawMaterial; queryData.Contour = checkRecord.Contour; queryData.SaveTime = DateTime.Now; queryData.ProductOrderId = Convert.ToInt32(orderId); //三部 queryData.Sensei = checkRecord.Sensei; queryData.Scratch = checkRecord.Scratch; queryData.Bruise = checkRecord.Bruise; queryData.Speckle = checkRecord.Speckle; queryData.DownEdge = checkRecord.DownEdge; queryData.Rust = checkRecord.Rust; queryData.MissedProcess = checkRecord.MissedProcess; queryData.Decibel = checkRecord.Decibel; queryData.Dot = checkRecord.Dot; queryData.Disaccord = checkRecord.Disaccord; queryData.Noise = checkRecord.Noise; queryData.CardPoint = checkRecord.CardPoint; queryData.ShaftTight = checkRecord.ShaftTight; queryData.Shake = checkRecord.Shake; queryData.OutputSize = checkRecord.OutputSize; queryData.InPutSize = checkRecord.InPutSize; queryData.NeglectedLoading = checkRecord.NeglectedLoading; queryData.NotInPlace = checkRecord.NotInPlace; queryData.Others = checkRecord.Others; queryData.Minute = checkRecord.Minute; queryData.Checker = userNo; queryData.Speed = checkRecord.Speed; queryData.Rotation = checkRecord.Rotation; queryData.Teams = checkRecord.Teams; queryData.BackQualityQty = checkRecord.BackQualityQty; queryData.QualityQty = checkRecord.QualityQty; queryData.NoQualityQty = checkRecord.NoQualityQty; var result = Db.Ado.UseTran(() => { Insert(queryData); product.QulityQty += Convert.ToDecimal(checkRecord.QualityQty); product.Remark = remark; productService.Update(product); }); if (!result.IsSuccess) { throw new Exception(result.ErrorMessage); } successResult.Msg = "保存成功!"; successResult.Success = true; } catch (Exception ex) { successResult.Msg = ex.Message; } return(successResult); }