public bool generateAgain(CV_PM_SMT_RECEIPE_DETAIL_QueryParam entitie)
{
if (rcpPK != null)
{
entitie.RcpPK = rcpPK;
}
IList <CV_PM_SMT_RECEIPE_DETAIL> cvDetailList = new List <CV_PM_SMT_RECEIPE_DETAIL>();
cvDetailList = cvReceipeDetailBO.GetEntities(entitie);
for (int i = 0; i < cvDetailList.Count; i++)
{
if (cvDetailList[i].CfmedLotID == null)
{
return(false);
}
}
PM_SMT_RECEIPE_SETUP Setup = new PM_SMT_RECEIPE_SETUP();
Setup.SetupPK = cvDetailList[0].SetupPK;
Setup.UpdatedOn = SSGlobalConfig.Now;
Setup.SetupStatus = 5;
ReceipeSetupBO.UpdateSome(Setup);
return(true);
}
public IList <CV_PM_SMT_RECEIPE_DETAIL> GetReceipeDetailEntities(PM_SMT_RECEIPE_QueryParam Entitie) //传入的参数是对象，用Post，不能用Get
{
if (Entitie == null)
{
return(null);
}
IList <PM_SMT_RECEIPE> listRe = new List <PM_SMT_RECEIPE>();
listRe = ReceipeBO.GetEntities(Entitie);
if (listRe.Count != 1)
{
return(null);
}
rcpPK = listRe[0].RcpPK;
IList <PM_SMT_RECEIPE_SETUP> setupList = new List <PM_SMT_RECEIPE_SETUP>();
PM_SMT_RECEIPE_SETUP_QueryParam qp = new PM_SMT_RECEIPE_SETUP_QueryParam();
qp.SetupID = Entitie.OrderID + "-" + Entitie.MachineID + "-" + Entitie.PcbSide;
qp.SetupName = Entitie.OrderID + "-" + Entitie.MachineID + "-" + Entitie.PcbSide;
qp.RcpPK = rcpPK;
setupList = ReceipeSetupBO.GetEntities(qp);
if (setupList.Count == 0)
{
PM_SMT_RECEIPE_SETUP setUp = new PM_SMT_RECEIPE_SETUP();
setUp.SetupName = qp.SetupName;
setUp.SetupID = qp.SetupID;
setUp.CreatedOn = SSGlobalConfig.Now;
setUp.CreatedBy = Entitie.UpdatedBy;
setUp.UpdatedOn = setUp.CreatedOn;
setUp.UpdatedBy = Entitie.UpdatedBy;
setUp.RcpPK = listRe[0].RcpPK;
setUp.SetupStatus = 1;
//添加..
ReceipeSetupBO.Insert(setUp);
}
CV_PM_SMT_RECEIPE_DETAIL_QueryParam CV_PM_SMT_ReceipeDetailSetup = new CV_PM_SMT_RECEIPE_DETAIL_QueryParam();
IList <CV_PM_SMT_RECEIPE_DETAIL> ReceipeDetailSetupList = new List <CV_PM_SMT_RECEIPE_DETAIL>();
//CV_PM_SMT_ReceipeDetailSetup.SetupName = qp.SetupName;
CV_PM_SMT_ReceipeDetailSetup.RcpPK = rcpPK;
// CV_PM_SMT_ReceipeDetailSetup.
ReceipeDetailSetupList = cvReceipeDetailBO.GetEntities(CV_PM_SMT_ReceipeDetailSetup);
return(ReceipeDetailSetupList);
}
public IList <CV_PM_SMT_RECEIPE_DETAIL> checkAgain(CV_PM_SMT_RECEIPE_DETAIL_QueryParam Entitie)
{
bool isFinishedAll = true;
IList <CV_PM_SMT_ReceipeDetailSetup> detaillist = new List <CV_PM_SMT_ReceipeDetailSetup>();
CV_MM_LOTS_EXT_QueryParam lotqp = new CV_MM_LOTS_EXT_QueryParam();
IList <CV_MM_LOTS_EXT> lotList = new List <CV_MM_LOTS_EXT>();
IList <CV_PM_SMT_RECEIPE_DETAIL> cvfourList = new List <CV_PM_SMT_RECEIPE_DETAIL>();
CV_PM_SMT_ReceipeDetailSetup_QueryParam sanQP = new CV_PM_SMT_ReceipeDetailSetup_QueryParam();
sanQP.Slot = Entitie.Slot;
sanQP.OrderID = Entitie.OrderID;
sanQP.MachineID = Entitie.MachineID;
sanQP.PcbSide = Entitie.PcbSide;
detaillist = CV_PM_SMT_ReceipeDetailSetupBO.GetEntities(sanQP);
////在视图中查
//lotqp.LotID = Entitie.LotID;
//lotqp.OrderID = Entitie.OrderID;
//lotList = CV_MM_LOTS_EXTBO.GetEntities(lotqp);
//if (lotList.Count == 0)
//{
// cvfourList.Clear();
// return cvfourList;
//}
//if (lotList[0].DefID != detaillist[0].MaterialID) //条码是否存在，必须由WMS导入MES
//{
// cvfourList.Clear();
// return cvfourList;
//}
LES_REQUEST_RECEIVE receive = new LES_REQUEST_RECEIVE();
receive.HutID = Entitie.LotID;
IList <LES_REQUEST_RECEIVE> detailPKList = receiveBO.GetEntities(receive);
if (detailPKList == null || detailPKList.Count == 0 || detailPKList[0].OrderID != Entitie.OrderID || detailPKList[0].MaterialID != detaillist[0].MaterialID)//核对工单、物料
{
cvfourList.Clear();
return(cvfourList);
}
receive.ReceivePK = detailPKList[0].ReceivePK;
//hutID对应的接料信息，调wms接口用
LESReceive lesReceive = new LESReceive();
lesReceive.HutID = receive.HutID;
lesReceive.DetailPK = Convert.ToInt32(detailPKList[0].DetailPK);
lesReceive.OperationTime = SSGlobalConfig.Now;
lesReceive.Operator = Entitie.UpdatedBy;
lesReceive.ReceivePK = (int)detailPKList[0].ReceivePK;
lesReceive.IsLastHut = Convert.ToBoolean(detailPKList[0].IsLastHut);
LES_REQUEST_DETAIL lesDetail = lesDetailBO.GetEntity(Convert.ToInt32(detailPKList[0].DetailPK));
if (lesDetail == null)
{
cvfourList.Clear();
return(cvfourList);
}
lesReceive.RequestPK = (int)lesDetail.RequestPK;
PM_SMT_RECEIPE_SETUP_DETAIL detail = new PM_SMT_RECEIPE_SETUP_DETAIL();
PM_SMT_RECEIPE_SETUP_DETAIL detailQP = new PM_SMT_RECEIPE_SETUP_DETAIL();
CV_PM_SMT_RECEIPE_DETAIL_QueryParam cvFourQP = new CV_PM_SMT_RECEIPE_DETAIL_QueryParam();
PM_SMT_RECEIPE_SETUP_DETAIL setDetail = new PM_SMT_RECEIPE_SETUP_DETAIL();
setDetail.DetailPK = detaillist[0].DetailPK;
//查询SetupDetailPK
IList <PM_SMT_RECEIPE_SETUP_DETAIL> listSet = setupDetailBO.GetEntities(setDetail);
if (listSet != null && listSet.Count != 0)
{
detail.SetupDetailPK = listSet[0].SetupDetailPK;
}
detail.DetailPK = detaillist[0].DetailPK;
detail.CfmedLotID = Entitie.CfmedLotID;
detail.SetupPK = detaillist[0].SetupPK;
detail.CfmedOperator = Entitie.UpdatedBy;
detailQP.SetupPK = detaillist[0].SetupPK;
detailQP.DetailPK = detaillist[0].DetailPK;
detailQP.CfmedLotID = Entitie.CfmedLotID;
//防止二次添加。
IList <PM_SMT_RECEIPE_SETUP_DETAIL> listCV = setupDetailBO.GetEntities(detailQP);
if (listCV != null && listCV.Count != 0 && detail.SetupDetailPK != null)
{
if (listCV[0].CfmedLotID == null)
{
// //调用存储过程
// string Sql = string.Format( //如果已存在会返回LocPK
// @"DECLARE @return_value int,
// @ReturnMessage nvarchar(1000)
//
// EXEC @return_value = [dbo].[CP_LES_CheckReceiveMaterial_1.18]
// @HutID = N'{0}',
// @LotID = N'{0}',
// @ReturnMessage = @ReturnMessage OUTPUT
//
// SELECT @ReturnMessage as N'@ReturnMessage'", Entitie.LotID);
// DataTable exelist = null;
// exelist = co_BSC_BO.GetDataTableBySql(Sql);
// string result = exelist.Rows[0][0].ToString();
// if (result!="OK") //realID校验不通过
// {
// return cvfourList;
// }
//调wms接口，二次核对同时接料
ReturnValue rv = new ReturnValue();
rv = API_WMS_BO.ReceiveMaterial(lesReceive);
if (rv.Success == false)
{
return(cvfourList);
}
//修改接料状态
string s = receiveBO.ModifyMaterialStatus(Entitie.UpdatedBy, Convert.ToInt32(receive.ReceivePK));
if (s.Contains("OK"))
{
detail.CfmedOperationTime = SSGlobalConfig.Now;
setupDetailBO.UpdateSome(detail);
}
}
}
cvFourQP.RcpPK = detaillist[0].RcpPK;
cvfourList = cvReceipeDetailBO.GetEntities(cvFourQP);
//检查是否扫描完毕。
for (int i = 0; i < cvfourList.Count; i++)
{
if (cvfourList[i].CfmedLotID == null)
{
isFinishedAll = false;
break;
}
}
if (!isFinishedAll)
{
PM_SMT_RECEIPE_SETUP Setup = new PM_SMT_RECEIPE_SETUP();
Setup.UpdatedBy = Entitie.UpdatedBy;
Setup.UpdatedOn = SSGlobalConfig.Now;
Setup.SetupPK = cvfourList[0].SetupPK;
Setup.SetupStatus = 4;
ReceipeSetupBO.UpdateSome(Setup);
}
return(cvfourList);
}
public IList <CV_PM_SMT_RECEIPE_DETAIL> GetScanningEntities(CV_PM_SMT_RECEIPE_DETAIL_QueryParam Entitie) //传入的参数是对象，用Post，不能用Get
{
bool isFinishedAll = true;
IList <CV_PM_SMT_ReceipeDetailSetup> setupList = new List <CV_PM_SMT_ReceipeDetailSetup>();
//CV_MM_LOTS_EXT_QueryParam lotQP = new CV_MM_LOTS_EXT_QueryParam();
//IList<CV_MM_LOTS_EXT> lotList = new List<CV_MM_LOTS_EXT>();
PM_SMT_RECEIPE_SETUP_DETAIL detailNew = new PM_SMT_RECEIPE_SETUP_DETAIL();
IList <CV_PM_SMT_RECEIPE_DETAIL> cvfourList = new List <CV_PM_SMT_RECEIPE_DETAIL>();
CV_PM_SMT_ReceipeDetailSetup_QueryParam setuoQP = new CV_PM_SMT_ReceipeDetailSetup_QueryParam();
setuoQP.Slot = Entitie.Slot;
setuoQP.OrderID = Entitie.OrderID;
setuoQP.MachineID = Entitie.MachineID;
setuoQP.PcbSide = Entitie.PcbSide;
setupList = CV_PM_SMT_ReceipeDetailSetupBO.GetEntities(setuoQP);
//根据lotID查询物料
//lotQP.LotID = Entitie.LotID;
//lotQP.OrderID = Entitie.OrderID;
// lotList = CV_MM_LOTS_EXTBO.GetEntities(lotQP);
//if (lotList == null || lotList.Count == 0)
//{
// cvfourList.Clear();
// return cvfourList;
//}
//if (lotList[0].DefID != setupList[0].MaterialID)
//{
// cvfourList.Clear();
// return cvfourList;
//}
LES_REQUEST_RECEIVE receive = new LES_REQUEST_RECEIVE();
receive.HutID = Entitie.LotID;//接料表中hutID(reelID)
IList <LES_REQUEST_RECEIVE> detailPKList = receiveBO.GetEntities(receive);
if (detailPKList == null || detailPKList.Count == 0 || detailPKList[0].OrderID != Entitie.OrderID || detailPKList[0].MaterialID != setupList[0].MaterialID)
{
cvfourList.Clear();
return(cvfourList);
}
//LES_REQUEST_DETAIL lesDetail = lesDetailBO.GetEntity(Convert.ToInt32(detailPKList[0].DetailPK));
//if (lesDetail == null || lesDetail.MaterialID != setupList[0].MaterialID)
//{
// cvfourList.Clear();
// return cvfourList;
//}
PM_SMT_RECEIPE_SETUP_DETAIL detailQP = new PM_SMT_RECEIPE_SETUP_DETAIL();
detailQP.SetupPK = setupList[0].SetupPK;
detailQP.DetailPK = setupList[0].DetailPK;
detailQP.LotID = Entitie.LotID;
//防止二次添加。
IList <PM_SMT_RECEIPE_SETUP_DETAIL> detailList = setupDetailBO.GetEntities(detailQP);
if (detailList == null || detailList.Count == 0)
{
detailNew.LotID = Entitie.LotID;
detailNew.SetupPK = setupList[0].SetupPK;
detailNew.DetailPK = setupList[0].DetailPK;
detailNew.Operator = Entitie.UpdatedBy;
detailNew.OperationTime = SSGlobalConfig.Now;
setupDetailBO.Insert(detailNew);
//sacnningNum++;
}
CV_PM_SMT_RECEIPE_DETAIL_QueryParam cvfourQP = new CV_PM_SMT_RECEIPE_DETAIL_QueryParam();
cvfourQP.RcpPK = setupList[0].RcpPK;
cvfourList = cvReceipeDetailBO.GetEntities(cvfourQP);
//检查是否扫描完毕。
for (int i = 0; i < cvfourList.Count; i++)
{
if (string.IsNullOrEmpty(cvfourList[i].LotID))
{
isFinishedAll = false;
break;
}
}
if (!isFinishedAll)
{
PM_SMT_RECEIPE_SETUP Setup = new PM_SMT_RECEIPE_SETUP();
Setup.UpdatedBy = Entitie.UpdatedBy;
Setup.UpdatedOn = SSGlobalConfig.Now;
Setup.SetupPK = cvfourList[0].SetupPK;
Setup.SetupStatus = 2; //1:已生成 2:一次核对中 3:一次核对完成 4:二次核对中 5:二次核对完成
ReceipeSetupBO.UpdateSome(Setup);
}
return(cvfourList);
}
