//增加中表/底表数据 public QM_PROCESS_Util_Response addInspectionMBDatas(QM_PROCESS_Util_Param param) { QM_PROCESS_Util_Response response = new QM_PROCESS_Util_Response(); CV_QM_FIRSTCHECK_SN_QueryParam sn_param = new CV_QM_FIRSTCHECK_SN_QueryParam() { CurrentOrderID = param.WorkOrderID, IsNamePlate = param.IsNamePlate, LotID = param.sn, CurrentStep = param.Step //当前Step }; FirstCheckSnOrder snOrderInfo = api_QM_BO.getInspectionOrderStep(sn_param); if (string.IsNullOrEmpty(snOrderInfo.message)) { CV_QM_FIRSTCHECK_SN info = snOrderInfo.snOrder; info.Step = param.inspectSource == "4" ? null : info.Step;//成品抽检只是在包装工段 IList <CV_QM_PROCESSITEM> processItemList = cv_qm_processitem.GetEntitiesByOrderID(info.OrderID, param.inspectSource, info.Step); if (processItemList.Count() == 0) { response.message = "NG,无检验项信息"; } else { using (TransactionScope ts = new TransactionScope()) { if (param.isFirst) { log.Info("第一个SN,需要更新主表的MES工单和SAP订单"); //操作主表,更新MES工单和SAP订单,物料,产线 QM_PROCESS_TOP topUpdate = new QM_PROCESS_TOP() { KID = param.KID, //主键 WorkOrderID = info.OrderID, //MES工单 SapOrderID = info.SalesOrderID, //SAP订单 MaterielID = info.DefID, //物料 MaterielVer = info.DefVer, //物料版本 MaterielDescript = info.DefDescript, //物料描述 Step = info.Step, PlantID = info.PlanPlant, //工厂ID Plant = info.PlantName, //工厂 Workshop = info.DepartID, //车间 LineID = info.LineID, //产线ID ProdLine = info.LineName //产线 }; process_topbo.UpdateSome(topUpdate); //查询当前主表 response.top = process_topbo.GetEntity(param.KID.Value); } insertInspectionMiddle(param);//新增SN //获得中表主键 (主表KID,SN码) IList <QM_PROCESS_MIDDLE> middleQList = process_middlebo.GetByKIDSN(param.KID.Value, param.sn); //插入底表数据 foreach (CV_QM_PROCESSITEM cv_temp_inspection in processItemList) { //填充子表数据 QM_PROCESS_BOTTOM bottom = new QM_PROCESS_BOTTOM() { KLID = middleQList[0].KLID,//中表主键 Sequence = param.Sequence, SN = param.sn, MaterielID = param.isFirst ? info.DefID : param.MaterielID, ItemIndex = cv_temp_inspection.InforDetailID, Item = cv_temp_inspection.InspectItemDes, ItemStatus = "待检" }; if (!String.IsNullOrEmpty(cv_temp_inspection.InspectItemProperty) && cv_temp_inspection.InspectItemProperty == "1") { bottom.ItemProperty = "定性"; } else { bottom.ItemProperty = "定量"; } if (!String.IsNullOrEmpty(cv_temp_inspection.UpperLimit)) { bottom.Target = Convert.ToInt32(cv_temp_inspection.TargetValue); bottom.UpperBound = Convert.ToInt32(cv_temp_inspection.UpperLimit); bottom.LowerBound = Convert.ToInt32(cv_temp_inspection.LowerLimit); } process_bottombo.Insert(bottom); } //重新获得中表的数据 response.middleList = process_middlebo.GetByKid(param.KID.Value); ts.Complete(); } } } else { response.message = snOrderInfo.message; } return(response); }
public string addFirstCheck(AddFirstCheckRequest param) { string message = ""; Dictionary <string, string> dict = new Dictionary <string, string>(); dict.Add("PN", "SJ" + param.snOrderList[0].OrderID); DateTime now = SSGlobalConfig.Now; CV_QM_FIRSTCHECK_SN snOrder = param.snOrderList[0]; //先获得首检检验项 string SubBopID = null; if (snOrder.Step == "装配" || snOrder.Step == "检定" || snOrder.Step == "包装") { //查询step是否为包装或者装配,若是,则查询需加上subbopid SubBopID = snOrder.Step; } IList <CV_QM_PROCESSITEM> processItemList = _ICV_QM_PROCESSITEMBO.GetEntitiesByOrderID(snOrder.OrderID, "1", SubBopID);//首检InspectSource = 1 if (processItemList.Count() == 0) { message = "NG,无首检检验项信息"; } else { QM_PROCESS_TOP top = new QM_PROCESS_TOP() { Source = 1, SequenceStatus = "待检", SapOrderID = snOrder.SalesOrderID, //SAP订单 WorkOrderID = snOrder.OrderID, //MES工单 MinSampleSize = param.minSampleSize, //最小抽样数量 SampleQua = param.snOrderList.Count, //抽样数量 MaterielID = snOrder.DefID, //物料编码 MaterielVer = snOrder.DefVer, //物料版本 MaterielDescript = snOrder.DefDescript, //物料描述 PlantID = snOrder.PlanPlant, //工厂ID Plant = snOrder.PlantName, //工厂名称 Step = snOrder.Step, //工序 Workshop = snOrder.DepartID, //车间 LineID = snOrder.LineID, //产线ID ProdLine = snOrder.LineName, //产线名称 CreateBy = param.user, //创建者 CreateTime = now //创建时间 }; using (TransactionScope ts = new TransactionScope()) { top.Sequence = createCode("FirstInspectRule", dict);//首检单号 //创建首检单 _IQM_PROCESS_TOPBO.Insert(top); //获得刚创建的首检单 QM_PROCESS_TOP_QueryParam topParam = new QM_PROCESS_TOP_QueryParam() { Source = 1, Sequence = top.Sequence }; //查询KID top = _IQM_PROCESS_TOPBO.GetEntitiesByQueryParam(topParam)[0]; foreach (CV_QM_FIRSTCHECK_SN tmp in param.snOrderList) { QM_PROCESS_MIDDLE middle = new QM_PROCESS_MIDDLE() { KID = top.KID, Sequence = top.Sequence, SN = tmp.LotID, SNStatus = "待检" }; _IQM_PROCESS_MIDDLEBO.Insert(middle); } //查询KLID IList <QM_PROCESS_MIDDLE> middleList = _IQM_PROCESS_MIDDLEBO.GetByKid(top.KID.Value); //操作底表 foreach (QM_PROCESS_MIDDLE middleTmp in middleList) { foreach (CV_QM_PROCESSITEM item in processItemList) { QM_PROCESS_BOTTOM bottom = new QM_PROCESS_BOTTOM() { KLID = middleTmp.KLID, Sequence = middleTmp.Sequence, SN = middleTmp.SN, MaterielID = top.MaterielID, ItemIndex = item.InforDetailID, Item = item.InspectItemDes, ItemStatus = "待检", ItemProperty = item.InspectItemProperty.Equals("2") ? "定量" : "定性", }; if (!string.IsNullOrEmpty(item.TargetValue)) { bottom.Target = SafeConvert.ToDouble(item.TargetValue); } if (!string.IsNullOrEmpty(item.UpperLimit)) { bottom.UpperBound = SafeConvert.ToDouble(item.UpperLimit); } if (!string.IsNullOrEmpty(item.LowerLimit)) { bottom.LowerBound = SafeConvert.ToDouble(item.LowerLimit); } _IQM_PROCESS_BOTTOMBO.Insert(bottom); } } //创建预警信息 string cmd_altsql = string.Format(CultureInfo.InvariantCulture, firstAltSql, top.ProdLine, top.WorkOrderID, top.Sequence); DataTable dt = bscbo.GetDataTableBySql(cmd_altsql); if (dt.Rows.Count > 0) { //开始推送 PM_ALT_MESSAGE msg = alt_messagebo.GetEntity(SafeConvert.ToInt64(dt.Rows[0]["MsgPK"].ToString())); if (alt_bscbo.ExecuteNotify(msg)) { message = top.Sequence; ts.Complete(); } else { message = "NG,推送失败,请重新提交.."; } } } } return(message); }