//新增SN对应的数据
private QM_PROCESS_MIDDLE insertInspectionMiddle(QM_PROCESS_Util_Param param)
{
//新增中表数据
QM_PROCESS_MIDDLE middle = new QM_PROCESS_MIDDLE()
{
KID = param.KID,
Sequence = param.Sequence,//检验流水号
SN = param.sn,
SNStatus = "待检"
};
return(process_middlebo.Insert(middle));
}
//底表数据提交
public QM_PROCESS_MIDDLE bottomSubmitData(IList <CV_QM_PROCESS_BOTTOM> list)
{
int i = 0, len = list.Count;
bool badFlag = false;
DateTime now = SSGlobalConfig.Now;
QM_PROCESS_MIDDLE middle = null;
using (TransactionScope ts = new TransactionScope())
{
for (i = 0; i < len; i++)
{
CV_QM_PROCESS_BOTTOM cv_bottom = list[i];
if (cv_bottom.ItemResult.Equals("NG"))
{
badFlag = true;
}
QM_PROCESS_BOTTOM tmp = new QM_PROCESS_BOTTOM()
{
KDLID = cv_bottom.KDLID,
Value = cv_bottom.Value,
ItemResult = cv_bottom.ItemResult,
Abnormality = cv_bottom.AbnormalityCode,
SupAbnormality = cv_bottom.SupAbnormality,
Reason = cv_bottom.CauseCode,
SupReason = cv_bottom.SupReason,
ItemStatus = "已检"
};
process_bottombo.UpdateSome(tmp);
}
//更新中表
middle = new QM_PROCESS_MIDDLE()
{
KLID = list[0].KLID,
SNResult = badFlag ? "NG" : "OK",
SNStatus = "已检",
SNTime = now
};
process_middlebo.UpdateSome(middle);
ts.Complete();
}
return(middle);
}
public QM_PROCESS_MIDDLE bottomSubmit(IList <CV_QM_PROCESS_BOTTOM> list)
{
QM_PROCESS_MIDDLE middle = null;
Boolean flag = true;
DateTime now = SSGlobalConfig.Now;
using (TransactionScope ts = new TransactionScope())
{
foreach (CV_QM_PROCESS_BOTTOM bottom in list)
{
if (bottom.ItemResult == "NG")
{
flag = false;
}
QM_PROCESS_BOTTOM tmp = new QM_PROCESS_BOTTOM()
{
KDLID = bottom.KDLID,
Value = bottom.Value,
ItemResult = bottom.ItemResult,
Abnormality = bottom.AbnormalityCode,
Reason = bottom.CauseCode,
ItemStatus = "已检"
};
_IQM_PROCESS_BOTTOMBO.UpdateSome(tmp);
}
middle = new QM_PROCESS_MIDDLE()
{
KLID = list.First().KLID,
SNStatus = "已检",
SNResult = flag ? "OK" : "NG",
SNTime = now
};
_IQM_PROCESS_MIDDLEBO.UpdateSome(middle);
ts.Complete();
}
return(middle);
}
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);
}
