public IList <CV_POM_ORDER_EXT> getPomOrder(string orderID, string lineID) { CV_POM_ORDER_EXT_QueryParam pomOrder = new CV_POM_ORDER_EXT_QueryParam(); IList <CV_POM_ORDER_EXT> list = new List <CV_POM_ORDER_EXT>(); if (orderID != null) { pomOrder.PomOrderID = orderID; pomOrder.LineID = lineID; list = VPomOrderBo.GetEntities(pomOrder); return(list); } return(list); }
//增加中表/底表数据 public QM_PROCESS_Util_Response addFQCInspectionMBDatas(QM_PROCESS_Util_Param param) { QM_PROCESS_Util_Response response = new QM_PROCESS_Util_Response(); //判断SN对应的工单是否为同一个 //查询sn对应的工单 MM_LOTS_EXT pOM_SN_GENERATION = new MM_LOTS_EXT() { LotID = param.sn, }; IList <MM_LOTS_EXT> mm_lot_exts = lot_extbo.GetByQueryParam(pOM_SN_GENERATION); log.Info("addFQCInspectionMBDatas--->" + mm_lot_exts.Count); if (mm_lot_exts.Count == 0) { response.message = param.sn + "不存在对应的MES工单"; } else if (mm_lot_exts.Count > 1) { response.message = param.sn + "对应多个MES工单"; } else { string mesOrderID = mm_lot_exts[0].OrderID; log.Info("param.mesOrderID-->" + param.WorkOrderID); log.Info("mesOrderID-->" + mesOrderID); if (!String.IsNullOrEmpty(mesOrderID) && !String.IsNullOrEmpty(param.WorkOrderID) && !mesOrderID.Equals(param.WorkOrderID)) { response.message = param.sn + "对应的MES工单不一致"; } else { log.Info("sapOrderID-->" + param.SapOrderID); //根据MES工单和SAP订单去获得物料信息,工厂产线信息 CV_POM_ORDER_EXT_QueryParam ext_param = new CV_POM_ORDER_EXT_QueryParam() { PomOrderID = mesOrderID }; IList <CV_POM_ORDER_EXT> cv_order_exts = cv_pom_order_extbo.GetEntities(ext_param); log.Info("cv_order_ext.Count-->" + cv_order_exts.Count); if (cv_order_exts.Count == 0) { response.message = "MES工单'" + mesOrderID + "'不存在对应的数据(物料信息/产线信息)"; } else { //从中间表取数据 CV_PLM_BOP_INSPECTION_DETAIL cv_temp_inspection_param = new CV_PLM_BOP_INSPECTION_DETAIL() { SalesOrderID = cv_order_exts[0].SalesOrderID, SalesOrderSequence = cv_order_exts[0].SalesOrderSeq }; IList <CV_PLM_BOP_INSPECTION_DETAIL> cv_temp_inspections = cv_temp_inspectionbo.getEntities(cv_temp_inspection_param); log.Info("SN对应的检验项数据数为-->" + cv_temp_inspections.Count); if (cv_temp_inspections.Count == 0) { response.message = "该SN号没有FQC检验项数据"; } else { //获得 using (TransactionScope ts = new TransactionScope()) { if (param.isFirst) { log.Info("第一个SN,需要更新主表的MES工单和SAP订单"); //需要更新主表的MES工单和SAP订单 log.Info("sapOrderID-->" + cv_order_exts[0].SapOrderID); //操作主表,更新MES工单和SAP订单,物料,产线 QM_PROCESS_TOP topUpdate = new QM_PROCESS_TOP() { KID = param.KID, //主键 WorkOrderID = mesOrderID, //MES工单 SapOrderID = cv_order_exts[0].SapOrderID, //SAP订单 MaterielID = cv_order_exts[0].DefID, //物料 MaterielVer = cv_order_exts[0].DefVer, //物料版本 MaterielDescript = cv_order_exts[0].DefDescript, //物料描述 Plant = cv_order_exts[0].PlanPlant, //工厂 Workshop = cv_order_exts[0].WorkshopName, //车间 ProdLine = cv_order_exts[0].LineName //产线 }; process_topbo.UpdateSome(topUpdate); //查询当前主表 response.top = process_topbo.GetEntity(param.KID.Value); //string topSql = "update " + QM_PROCESS_TOP_DB + " set WorkOrderID = '" + mesOrderID + "' ,SapOrderID = '" + response.sapOrderID + // "' ,MaterielID = '" + cv_order_ext[0].DefID + "' ,MaterielVer = '" + cv_order_ext[0].DefVer + "' ,MaterielDescript = '" + cv_order_ext[0].DefDescript + // "' ,Plant = '" + cv_order_ext[0].PlanPlant + "' ,Workshop = '" + cv_order_ext[0].WorkshopName + "' ,ProdLine = '" + cv_order_ext[0].LineName + // "' where sequence = '" + param.Sequence + "'"; //操作中表 //string middleSql = "insert into " + QM_PROCESS_MIDDLE_DB + " (KID,Sequence,SN,SNStatus) values( " + param.KID // + ", '" + param.Sequence + " ', '" + param.sn + "','待检')"; } insertFQCInspectionMiddle(param);//新增SN //插入底表数据 foreach (CV_PLM_BOP_INSPECTION_DETAIL cv_temp_inspection in cv_temp_inspections) { //填充子表数据 QM_PROCESS_BOTTOM bottom = new QM_PROCESS_BOTTOM() { KLID = 11,//中表主键 Sequence = param.Sequence, SN = param.sn, MaterielID = param.isFirst ? cv_order_exts[0].DefID : param.WorkOrderID, ItemIndex = cv_temp_inspection.InforDetailID, Item = cv_temp_inspection.InspectItemDes, ItemProperty = cv_temp_inspection.InspectItemProperty, ItemStatus = "待检", }; 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(); } } } } } return(response); }