public void DeleteCAqltype(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
T_C_AQLTYPE cAqultype = null;
OleExec sfcdb = null;
try
{
sfcdb = this.DBPools["SFCDB"].Borrow();
cAqultype = new T_C_AQLTYPE(sfcdb, DB_TYPE_ENUM.Oracle);
Row_C_AQLTYPE r = (Row_C_AQLTYPE)cAqultype.GetObjByID((Data["ID"].ToString()).Trim(), sfcdb);
string strRet = sfcdb.ExecSQL(r.GetDeleteString(DB_TYPE_ENUM.Oracle));
if (Convert.ToInt32(strRet) > 0)
{
StationReturn.Message = "刪除成功！！";
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.Data = "";
}
else
{
StationReturn.MessageCode = "MES00000036";
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.Data = "";
}
this.DBPools["SFCDB"].Return(sfcdb);
}
catch (Exception e)
{
this.DBPools["SFCDB"].Return(sfcdb);
throw e;
}
}
public void GetCAqltypeList(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
T_C_AQLTYPE AQLTYPE = null;
OleExec sfcdb = null;
try
{
sfcdb = this.DBPools["SFCDB"].Borrow();
AQLTYPE = new T_C_AQLTYPE(sfcdb, DB_TYPE_ENUM.Oracle);
List <string> list = AQLTYPE.GetAql(sfcdb);
if (list.Count > 0)
{
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.Data = list;
}
else
{
StationReturn.MessageCode = "MES00000036";
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.Data = "";
}
this.DBPools["SFCDB"].Return(sfcdb);
}
catch (Exception e)
{
this.DBPools["SFCDB"].Return(sfcdb);
throw e;
}
}
public void SelectCAqltype(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
T_C_AQLTYPE cSkuDetail = null;
OleExec sfcdb = null;
try
{
sfcdb = this.DBPools["SFCDB"].Borrow();
cSkuDetail = new T_C_AQLTYPE(sfcdb, DB_TYPE_ENUM.Oracle);
List <C_AQLTYPE> list = cSkuDetail.GetAqlBySkuno((Data["AQL_TYPE"].ToString()).Trim(), sfcdb);
if (list.Count > 0)
{
StationReturn.Message = "获取成功！！";
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.Data = list;
}
else
{
StationReturn.MessageCode = "MES00000036";
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.Data = "";
}
this.DBPools["SFCDB"].Return(sfcdb);
}
catch (Exception e)
{
this.DBPools["SFCDB"].Return(sfcdb);
throw e;
}
}
/// <summary>
/// OBA工站創建LOT,返回LOT信息
/// </summary>
/// <param name="user"></param>
/// <param name="packNo"></param>
/// <param name="DB"></param>
public R_LOT_STATUS CreateLotByPackno(User user, string packNo, OleExec DB)
{
T_R_PACKING tRPacking = new T_R_PACKING(DB, this.DBType);
Row_R_PACKING rowRPacking = tRPacking.GetRPackingByPackNo(DB, packNo);
PalletBase palletBase = new PalletBase(rowRPacking);
T_C_SKU tCSku = new T_C_SKU(DB, this.DBType);
T_R_LOT_STATUS tRLotStatus = new T_R_LOT_STATUS(DB, this.DBType);
T_C_AQLTYPE tCAqlType = new T_C_AQLTYPE(DB, this.DBType);
T_R_LOT_PACK tRLotPack = new T_R_LOT_PACK(DB, this.DBType);
T_C_SKU_AQL tCSkuAql = new T_C_SKU_AQL(DB, this.DBType);
C_SKU_AQL cSkuAql = tCSkuAql.GetSkuAql(DB, rowRPacking.SKUNO);
List <C_AQLTYPE> cAqlTypeList = tCAqlType.GetAqlTypeBySkunoAndLevel(rowRPacking.SKUNO, cSkuAql.DEFAULLEVEL, DB);
if (cAqlTypeList.Count == 0)
{
throw new Exception(MESDataObject.MESReturnMessage.GetMESReturnMessage("MSGCODE20180625165842",
new string[] { }));
}
Row_C_SKU rCSku = tCSku.GetSku(rowRPacking.SKUNO, DB, this.DBType);
Row_R_LOT_STATUS rowRLotStatus = (Row_R_LOT_STATUS)tRLotStatus.NewRow();
rowRLotStatus.ID = tRLotStatus.GetNewID(user.BU, DB, this.DBType);
rowRLotStatus.LOT_NO = SNMaker.SNmaker.GetNextSN("OBALOT", DB);
rowRLotStatus.SKUNO = rowRPacking.SKUNO;
rowRLotStatus.AQL_TYPE = cSkuAql.AQLTYPE;
rowRLotStatus.LOT_QTY = palletBase.GetSnCount(DB);
rowRLotStatus.REJECT_QTY = cAqlTypeList.Where(t => t.LOT_QTY > rowRLotStatus.LOT_QTY).OrderBy(t => t.LOT_QTY).Take(1).ToList <C_AQLTYPE>()[0].REJECT_QTY;
rowRLotStatus.SAMPLE_QTY = cAqlTypeList.Where(t => t.LOT_QTY > rowRLotStatus.LOT_QTY).OrderBy(t => t.LOT_QTY).Take(1).ToList <C_AQLTYPE>()[0].SAMPLE_QTY;
rowRLotStatus.SAMPLE_QTY = rowRLotStatus.SAMPLE_QTY > rowRLotStatus.LOT_QTY ? rowRLotStatus.LOT_QTY : rowRLotStatus.SAMPLE_QTY;
rowRLotStatus.PASS_QTY = 0;
rowRLotStatus.FAIL_QTY = 0;
rowRLotStatus.CLOSED_FLAG = "0";
rowRLotStatus.LOT_STATUS_FLAG = "0";
rowRLotStatus.SAMPLE_STATION = "OBA";
rowRLotStatus.AQL_LEVEL = cSkuAql.DEFAULLEVEL;
rowRLotStatus.LINE = "";
rowRLotStatus.EDIT_EMP = user.EMP_NO;
rowRLotStatus.EDIT_TIME = tRPacking.GetDBDateTime(DB);
Row_R_LOT_PACK rowRLotPack = (Row_R_LOT_PACK)tRLotPack.NewRow();
rowRLotPack.ID = tRLotPack.GetNewID(user.BU, DB, this.DBType);
rowRLotPack.LOTNO = rowRLotStatus.LOT_NO;
rowRLotPack.PACKNO = packNo;
rowRLotPack.EDIT_EMP = user.EMP_NO;
rowRLotPack.EDIT_TIME = rowRLotStatus.EDIT_TIME;
DB.ThrowSqlExeception = true;
DB.ExecSQL(rowRLotStatus.GetInsertString(this.DBType));
DB.ExecSQL(rowRLotPack.GetInsertString(this.DBType));
DB.ThrowSqlExeception = false;
return(rowRLotStatus.GetDataObject());
}
/// <summary>
/// OBA工站InLot,返回LOT信息
/// </summary>
/// <param name="user"></param>
/// <param name="packNo"></param>
/// <param name="DB"></param>
public R_LOT_STATUS ObaInLotByPackno(User user, R_LOT_STATUS rLotStatus, string packNo, string AqlLevel, OleExec DB)
{
T_R_PACKING tRPacking = new T_R_PACKING(DB, this.DBType);
Row_R_PACKING rowRPacking = tRPacking.GetRPackingByPackNo(DB, packNo);
PalletBase palletBase = new PalletBase(rowRPacking);
T_R_LOT_STATUS tRLotStatus = new T_R_LOT_STATUS(DB, this.DBType);
T_C_AQLTYPE tCAqlType = new T_C_AQLTYPE(DB, this.DBType);
T_R_LOT_PACK tRLotPack = new T_R_LOT_PACK(DB, this.DBType);
List <C_AQLTYPE> cAqlTypeList = tCAqlType.GetAqlTypeBySkunoAndLevel(rowRPacking.SKUNO, AqlLevel, DB);
Row_R_LOT_STATUS rowRLotStatus = (Row_R_LOT_STATUS)tRLotStatus.NewRow();
rowRLotStatus.ID = rLotStatus.ID;
rowRLotStatus.LOT_NO = rLotStatus.LOT_NO;
rowRLotStatus.SKUNO = rLotStatus.SKUNO;
rowRLotStatus.AQL_TYPE = rLotStatus.AQL_TYPE;
rowRLotStatus.LOT_QTY = rLotStatus.LOT_QTY + palletBase.GetSnCount(DB);
rowRLotStatus.REJECT_QTY = cAqlTypeList.Where(t => t.LOT_QTY > rowRLotStatus.LOT_QTY).OrderBy(t => t.LOT_QTY).Take(1).ToList <C_AQLTYPE>()[0].REJECT_QTY;
rowRLotStatus.SAMPLE_QTY = cAqlTypeList.Where(t => t.LOT_QTY > rowRLotStatus.LOT_QTY).OrderBy(t => t.LOT_QTY).Take(1).ToList <C_AQLTYPE>()[0].SAMPLE_QTY;
rowRLotStatus.SAMPLE_QTY = rowRLotStatus.SAMPLE_QTY > rowRLotStatus.LOT_QTY ? rowRLotStatus.LOT_QTY : rowRLotStatus.SAMPLE_QTY;
rowRLotStatus.PASS_QTY = rLotStatus.PASS_QTY;
rowRLotStatus.FAIL_QTY = rLotStatus.FAIL_QTY;
rowRLotStatus.CLOSED_FLAG = rLotStatus.CLOSED_FLAG;
rowRLotStatus.LOT_STATUS_FLAG = rLotStatus.LOT_STATUS_FLAG;
rowRLotStatus.SAMPLE_STATION = rLotStatus.SAMPLE_STATION;
rowRLotStatus.LINE = rLotStatus.LINE;
rowRLotStatus.AQL_LEVEL = AqlLevel;
rowRLotStatus.EDIT_EMP = user.EMP_NO;
rowRLotStatus.EDIT_TIME = tRPacking.GetDBDateTime(DB);
Row_R_LOT_PACK rowRLotPack = (Row_R_LOT_PACK)tRLotPack.NewRow();
rowRLotPack.ID = tRLotPack.GetNewID(user.BU, DB, this.DBType);
rowRLotPack.LOTNO = rowRLotStatus.LOT_NO;
rowRLotPack.PACKNO = packNo;
rowRLotPack.EDIT_EMP = user.EMP_NO;
rowRLotPack.EDIT_TIME = rowRLotStatus.EDIT_TIME;
DB.ThrowSqlExeception = true;
DB.ExecSQL(rowRLotStatus.GetUpdateString(this.DBType) + ";" + rowRLotPack.GetInsertString(this.DBType));
DB.ThrowSqlExeception = false;
return(rowRLotStatus.GetDataObject());
}
public void GetAllAqlName(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
T_C_AQLTYPE cAqultype = null;
OleExec sfcdb = null;
try
{
sfcdb = this.DBPools["SFCDB"].Borrow();
cAqultype = new T_C_AQLTYPE(sfcdb, DB_TYPE_ENUM.Oracle);
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.Data = cAqultype.GetAql(sfcdb);;
}
catch (Exception e)
{
throw e;
}
finally
{
this.DBPools["SFCDB"].Return(sfcdb);
}
}
public void AddCAqltype(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn)
{
T_C_AQLTYPE cAqultype = null;
OleExec sfcdb = null;
try
{
sfcdb = this.DBPools["SFCDB"].Borrow();
cAqultype = new T_C_AQLTYPE(sfcdb, DB_TYPE_ENUM.Oracle);
Row_C_AQLTYPE r = (Row_C_AQLTYPE)cAqultype.NewRow();
r.ID = cAqultype.GetNewID(this.BU, sfcdb);
r.AQL_TYPE = (Data["AQL_TYPE"].ToString()).Trim();
r.LOT_QTY = Convert.ToDouble((Data["LOT_QTY"].ToString()).Trim());
r.GL_LEVEL = (Data["GL_LEVEL"].ToString()).Trim();
r.SAMPLE_QTY = Convert.ToDouble((Data["SAMPLE_QTY"].ToString()).Trim());
r.ACCEPT_QTY = Convert.ToDouble((Data["ACCEPT_QTY"].ToString()).Trim());
r.REJECT_QTY = Convert.ToDouble((Data["REJECT_QTY"].ToString()).Trim());
r.EDIT_EMP = this.LoginUser.EMP_NO;
r.EDIT_TIME = GetDBDateTime();
string strRet = sfcdb.ExecSQL(r.GetInsertString(DB_TYPE_ENUM.Oracle));
if (Convert.ToInt32(strRet) > 0)
{
StationReturn.Message = "添加成功！！";
StationReturn.Status = StationReturnStatusValue.Pass;
StationReturn.Data = "";
}
else
{
StationReturn.MessageCode = "MES00000036";
StationReturn.Status = StationReturnStatusValue.Fail;
StationReturn.Data = "";
}
this.DBPools["SFCDB"].Return(sfcdb);
}
catch (Exception e)
{
this.DBPools["SFCDB"].Return(sfcdb);
throw e;
}
}
public static void CloseLot(MESPubLab.MESStation.MESStationBase Station, MESPubLab.MESStation.MESStationInput Input, List <MESDataObject.Module.R_Station_Action_Para> Paras)
{
DisplayOutPut Dis_LotNo = Station.DisplayOutput.Find(t => t.Name == "LOTNO");
MESStationInput Level = Station.Inputs.Find(t => t.DisplayName == "AQLLEVEL");
T_R_LOT_STATUS tRLotStatus = new T_R_LOT_STATUS(Station.SFCDB, Station.DBType);
Row_R_LOT_STATUS r = tRLotStatus.GetByLotNo(Dis_LotNo.Value.ToString(), Station.SFCDB);
if (r.LOT_NO == null || !r.CLOSED_FLAG.Equals("0"))
{
throw new Exception(MESReturnMessage.GetMESReturnMessage("MSGCODE20180528103627", new string[] { Dis_LotNo.Value.ToString() }));
}
try
{
//根據關閉時的AQL更新LotStatus
T_C_AQLTYPE tCAqlType = new T_C_AQLTYPE(Station.SFCDB, Station.DBType);
List <C_AQLTYPE> cAqlTypeList = tCAqlType.GetAqlTypeBySkunoAndLevel(r.SKUNO, Level.Value.ToString(), Station.SFCDB);
r.REJECT_QTY = cAqlTypeList.Where(t => t.LOT_QTY > r.LOT_QTY).OrderBy(t => t.LOT_QTY).Take(1).ToList <C_AQLTYPE>()[0].REJECT_QTY;
r.SAMPLE_QTY = cAqlTypeList.Where(t => t.LOT_QTY > r.LOT_QTY).OrderBy(t => t.LOT_QTY).Take(1).ToList <C_AQLTYPE>()[0].SAMPLE_QTY;
r.SAMPLE_QTY = r.SAMPLE_QTY > r.LOT_QTY ? r.LOT_QTY : r.SAMPLE_QTY;
r.CLOSED_FLAG = "1";
r.AQL_LEVEL = Level.Value.ToString();
r.EDIT_EMP = Station.LoginUser.EMP_NO;
Station.SFCDB.ThrowSqlExeception = true;
r.EDIT_TIME = tRLotStatus.GetDBDateTime(Station.SFCDB);
Station.SFCDB.ExecSQL(r.GetUpdateString(Station.DBType));
}
catch (Exception e)
{
throw new Exception(MESReturnMessage.GetMESReturnMessage("MSGCODE20180528105826", new string[] { Dis_LotNo.Value.ToString(), e.Message }));
}
finally { Station.SFCDB.ThrowSqlExeception = false; }
#region 清空界面信息
Station.StationSession.Clear();
Station.Inputs.Find(t => t.DisplayName == Paras[0].SESSION_TYPE).DataForUse.Clear();
Station.Inputs.Find(t => t.DisplayName == "AQLLEVEL").DataForUse.Clear();
#endregion
}
/// <summary>
/// 獲取批次抽樣數量
/// </summary>
/// <param name="Station"></param>
/// <param name="Input"></param>
/// <param name="Paras">1個參數,SKU 保存的位置</param>
public static void GetSampleQtyDataloader(MESPubLab.MESStation.MESStationBase Station, MESPubLab.MESStation.MESStationInput Input, List <MESDataObject.Module.R_Station_Action_Para> Paras)
{
Row_C_SKU_SAMPLE RLotSku;
Row_C_AQLTYPE RAqltype;
T_C_AQLTYPE QR = new T_C_AQLTYPE(Station.SFCDB, MESDataObject.DB_TYPE_ENUM.Oracle);
T_C_SKU_SAMPLE TR = new T_C_SKU_SAMPLE(Station.SFCDB, MESDataObject.DB_TYPE_ENUM.Oracle);
if (Paras.Count != 10)
{
throw new Exception(MESReturnMessage.GetMESReturnMessage("MES00000050"));
}
MESStationSession SessionSN = Station.StationSession.Find(t => t.MESDataType == Paras[0].SESSION_TYPE && t.SessionKey == Paras[0].SESSION_KEY);
MESStationSession SessionSKU = Station.StationSession.Find(t => t.MESDataType == Paras[1].SESSION_TYPE && t.SessionKey == Paras[1].SESSION_KEY);
MESStationSession SessionAQLTYPE = Station.StationSession.Find(t => t.MESDataType == Paras[2].SESSION_TYPE && t.SessionKey == Paras[2].SESSION_KEY);
MESStationSession SessionLotQTY = Station.StationSession.Find(t => t.MESDataType == Paras[3].SESSION_TYPE && t.SessionKey == Paras[3].SESSION_KEY);
MESStationSession SessionSAMPLEQTY = Station.StationSession.Find(t => t.MESDataType == Paras[4].SESSION_TYPE && t.SessionKey == Paras[4].SESSION_KEY);
MESStationSession SessionREJECTQTY = Station.StationSession.Find(t => t.MESDataType == Paras[5].SESSION_TYPE && t.SessionKey == Paras[5].SESSION_KEY);
MESStationSession SessionPassQty = Station.StationSession.Find(t => t.MESDataType == Paras[6].SESSION_TYPE && t.SessionKey == Paras[6].SESSION_KEY);
MESStationSession SessionFailQty = Station.StationSession.Find(t => t.MESDataType == Paras[7].SESSION_TYPE && t.SessionKey == Paras[7].SESSION_KEY);
MESStationSession SessionLotNewFlag = Station.StationSession.Find(t => t.MESDataType == Paras[8].SESSION_TYPE && t.SessionKey == Paras[8].SESSION_KEY);
MESStationSession SessionLotNo = Station.StationSession.Find(t => t.MESDataType == Paras[9].SESSION_TYPE && t.SessionKey == Paras[9].SESSION_KEY);
if (SessionSN == null)
{
//throw new Exception("请输入SN!");
throw new Exception(MESReturnMessage.GetMESReturnMessage("MES00000052", new string[] { Paras[0].SESSION_TYPE }));
}
SN ObjSN = (SN)SessionSN.Value;
//if (SessionSKU == null)
//{
// SessionSKU = new MESStationSession() { MESDataType = Paras[1].SESSION_TYPE, InputValue = Input.Value.ToString(), SessionKey = Paras[1].SESSION_KEY, ResetInput = Input };
// Station.StationSession.Add(SessionSKU);
//}
if (SessionAQLTYPE == null)
{
SessionAQLTYPE = new MESStationSession()
{
MESDataType = Paras[2].SESSION_TYPE, InputValue = Input.Value.ToString(), SessionKey = Paras[2].SESSION_KEY, ResetInput = Input
};
Station.StationSession.Add(SessionAQLTYPE);
}
if (SessionLotQTY == null)
{
SessionLotQTY = new MESStationSession()
{
MESDataType = Paras[3].SESSION_TYPE, InputValue = Input.Value.ToString(), SessionKey = Paras[3].SESSION_KEY, ResetInput = Input
};
Station.StationSession.Add(SessionLotQTY);
}
if (SessionSAMPLEQTY == null)
{
SessionSAMPLEQTY = new MESStationSession()
{
MESDataType = Paras[4].SESSION_TYPE, InputValue = Input.Value.ToString(), SessionKey = Paras[4].SESSION_KEY, ResetInput = Input
};
Station.StationSession.Add(SessionSAMPLEQTY);
}
if (SessionREJECTQTY == null)
{
SessionREJECTQTY = new MESStationSession()
{
MESDataType = Paras[5].SESSION_TYPE, InputValue = Input.Value.ToString(), SessionKey = Paras[5].SESSION_KEY, ResetInput = Input
};
Station.StationSession.Add(SessionREJECTQTY);
}
if (SessionPassQty == null)
{
SessionPassQty = new MESStationSession()
{
MESDataType = Paras[6].SESSION_TYPE, InputValue = Input.Value.ToString(), SessionKey = Paras[6].SESSION_KEY, ResetInput = Input
};
Station.StationSession.Add(SessionPassQty);
}
if (SessionFailQty == null)
{
SessionFailQty = new MESStationSession()
{
MESDataType = Paras[7].SESSION_TYPE, InputValue = Input.Value.ToString(), SessionKey = Paras[7].SESSION_KEY, ResetInput = Input
};
Station.StationSession.Add(SessionFailQty);
}
if (SessionLotNewFlag == null)
{
SessionLotNewFlag = new MESStationSession()
{
MESDataType = Paras[8].SESSION_TYPE, InputValue = Input.Value.ToString(), SessionKey = Paras[8].SESSION_KEY, ResetInput = Input
};
Station.StationSession.Add(SessionLotNewFlag);
}
if (SessionLotNo == null)
{
throw new MESReturnMessage(MESReturnMessage.GetMESReturnMessage("MES00000052", new string[] { Paras[9].SESSION_TYPE + Paras[9].SESSION_KEY }));
}
try
{
if ((string)SessionLotNewFlag.Value == "1")
{
if (Paras[1].VALUE.ToString() == "ALL")
{
RLotSku = TR.GetBySkuNo(Paras[1].VALUE.ToString(), ObjSN.NextStation, Station.SFCDB);
RAqltype = QR.GetByAqltype(RLotSku.AQL_TYPE, Station.SFCDB);
SessionAQLTYPE.Value = RAqltype.AQL_TYPE;
//Marked by LLF
//SessionLotQTY.Value = RAqltype.LOT_QTY;
//SessionSAMPLEQTY.Value = RAqltype.SAMPLE_QTY;
//SessionREJECTQTY.Value = RAqltype.REJECT_QTY;
}
else
{
RLotSku = TR.GetBySkuNo(ObjSN.SkuNo, ObjSN.NextStation, Station.SFCDB);
RAqltype = QR.GetByAqltype(RLotSku.AQL_TYPE, Station.SFCDB);
SessionAQLTYPE.Value = RAqltype.AQL_TYPE;
//Marked by LLF
//SessionLotQTY.Value = RAqltype.LOT_QTY;
//SessionSAMPLEQTY.Value = RAqltype.SAMPLE_QTY;
//SessionREJECTQTY.Value = RAqltype.REJECT_QTY;
}
SessionPassQty.Value = 0;
SessionFailQty.Value = 0;
SessionLotQTY.Value = 0;
SessionSAMPLEQTY.Value = 0;
SessionREJECTQTY.Value = 0;
}
else
{
SessionAQLTYPE.Value = ((LotNo)SessionLotNo.Value).AQL_TYPE;
SessionLotQTY.Value = ((LotNo)SessionLotNo.Value).LOT_QTY;
SessionSAMPLEQTY.Value = ((LotNo)SessionLotNo.Value).SAMPLE_QTY;
SessionREJECTQTY.Value = ((LotNo)SessionLotNo.Value).REJECT_QTY;
SessionPassQty.Value = ((LotNo)SessionLotNo.Value).PASS_QTY;
SessionFailQty.Value = ((LotNo)SessionLotNo.Value).FAIL_QTY;
}
//Station.AddMessage("MES00000104", new string[] { "AQLTYPE", RAqltype.AQL_TYPE, "LotQTY", RAqltype.LOT_QTY.ToString(), "SAMPLEQTY", RAqltype.SAMPLE_QTY.ToString(), "REJECTQTY", RAqltype.REJECT_QTY.ToString() }, MESPubLab.MESStation.MESReturnView.Station.StationMessageState.Message);
Station.AddMessage("MES00000104", new string[] { "AQLTYPE", SessionAQLTYPE.Value.ToString(), "LotQTY", SessionLotQTY.Value.ToString(), "SAMPLEQTY", SessionSAMPLEQTY.Value.ToString(), "REJECTQTY", SessionREJECTQTY.Value.ToString() }, MESPubLab.MESStation.MESReturnView.Station.StationMessageState.Message);
}
catch (Exception ex)
{
string msgCode = ex.Message;
throw ex;
}
}
/// <summary>
/// 檢查Pack狀態是否可以入OBA
/// </summary>
/// <param name="Station"></param>
/// <param name="Input"></param>
/// <param name="Paras"></param>
public static void CheckPackStatusInOba(MESPubLab.MESStation.MESStationBase Station, MESPubLab.MESStation.MESStationInput Input, List <MESDataObject.Module.R_Station_Action_Para> Paras)
{
DisplayOutPut Dis_LotNo = Station.DisplayOutput.Find(t => t.Name == "LOTNO");
DisplayOutPut Dis_SkuNo = Station.DisplayOutput.Find(t => t.Name == "SKUNO");
DisplayOutPut Dis_Ver = Station.DisplayOutput.Find(t => t.Name == "VER");
MESStationInput Level = Station.Inputs.Find(t => t.DisplayName == "AQLLEVEL");
MESStationSession packSession = Station.StationSession.Find(t => t.MESDataType == Paras[0].SESSION_TYPE && t.SessionKey == Paras[0].SESSION_KEY);
#region 用於界面上顯示的批次信息
R_LOT_STATUS rLotStatus = new R_LOT_STATUS();
List <R_LOT_PACK> rLotPackList = new List <R_LOT_PACK>();
List <string> cAqlLevel = new List <string>();
#endregion
T_R_PACKING t_r_packing = new T_R_PACKING(Station.SFCDB, Station.DBType);
//add by fgg 2018.6.28 卡棧板是否關閉，避免棧板還沒有關閉就拿去抽檢OBA，導致抽檢總數異常，進而導致OBA抽檢數量不對
if (!t_r_packing.CheckCloseByPackno(packSession.Value.ToString(), Station.SFCDB))
{
throw new Exception(MESReturnMessage.GetMESReturnMessage("MSGCODE20180611104338", new string[] { packSession.Value.ToString() }));
}
LotNo LotNo = new LotNo(Station.DBType);
T_R_LOT_PACK tRLotPack = new T_R_LOT_PACK(Station.SFCDB, Station.DBType);
rLotPackList = tRLotPack.GetRLotPackWithWaitClose(Station.SFCDB, packSession.Value.ToString());
List <R_LOT_STATUS> rLotStatusList = tRLotPack.GetRLotStatusWithWaitClose(Station.SFCDB, packSession.Value.ToString());
rLotStatus = rLotStatusList.Find(t => t.CLOSED_FLAG == "1");
if (rLotStatus != null)
{
throw new Exception(MESReturnMessage.GetMESReturnMessage("MSGCODE20180526181007", new string[] { packSession.Value.ToString() }));
}
else
{
rLotStatus = rLotStatusList.Find(t => t.CLOSED_FLAG == "0");
}
if (Dis_LotNo.Value.Equals(""))
{
#region 當前Lot為空=>檢查當前Pack無有效LOT?新建LOT:加載LOT;
if (rLotPackList.Count == 0)
{
rLotStatus =
LotNo.CreateLotByPackno(Station.LoginUser, packSession.Value.ToString(), Station.SFCDB);
rLotPackList.Add(
new R_LOT_PACK()
{
LOTNO = rLotStatus.LOT_NO, PACKNO = packSession.Value.ToString()
});
}
else
{
rLotStatus = rLotStatusList.Find(t => t.CLOSED_FLAG == "0");
}
#endregion
}
else
{
#region 當前Lot不為空=>PackNo與當前頁面LOT的機種版本是否一致?ReLoad LOT信息:Throw e;
T_R_PACKING tRPacking = new T_R_PACKING(Station.SFCDB, Station.DBType);
Row_R_PACKING rowRPacking = tRPacking.GetRPackingByPackNo(Station.SFCDB, packSession.Value.ToString());
if (!rowRPacking.SKUNO.Equals(Dis_SkuNo.Value.ToString()))
{
throw new Exception(MESReturnMessage.GetMESReturnMessage("MSGCODE20180526185434", new string[] { packSession.Value.ToString() }));
}
if (rLotPackList.Count == 0)
{
rLotStatus = LotNo.ObaInLotByPackno(Station.User, rLotStatus, packSession.Value.ToString(), Level.Value.ToString(), Station.SFCDB);
rLotPackList.Add(new R_LOT_PACK()
{
LOTNO = rLotStatus.LOT_NO, PACKNO = packSession.Value.ToString()
});
}
else
{
throw new Exception(MESReturnMessage.GetMESReturnMessage("MSGCODE20180526185618", new string[] { packSession.Value.ToString(), rLotStatus.LOT_NO }));
}
#endregion
}
#region 加載AQL等級
T_C_AQLTYPE tCAqlType = new T_C_AQLTYPE(Station.SFCDB, Station.DBType);
cAqlLevel = tCAqlType.GetAqlLevelByType(rLotStatus.AQL_TYPE, Station.SFCDB);
T_C_SKU_AQL tCSkuAql = new T_C_SKU_AQL(Station.SFCDB, Station.DBType);
C_SKU_AQL cSkuAql = tCSkuAql.GetSkuAql(Station.SFCDB, rLotStatus.SKUNO);
#endregion
#region 加載界面信息
MESStationSession lotNoSession = new MESStationSession()
{
MESDataType = Paras[2].SESSION_TYPE, InputValue = Input.Value.ToString(), SessionKey = Paras[2].SESSION_KEY, ResetInput = Input
};
MESStationSession skuNoSession = new MESStationSession()
{
MESDataType = Paras[3].SESSION_TYPE, InputValue = Input.Value.ToString(), SessionKey = Paras[3].SESSION_KEY, ResetInput = Input
};
MESStationSession aqlSession = new MESStationSession()
{
MESDataType = Paras[4].SESSION_TYPE, InputValue = Input.Value.ToString(), SessionKey = Paras[4].SESSION_KEY, ResetInput = Input
};
MESStationSession lotQtySession = new MESStationSession()
{
MESDataType = Paras[5].SESSION_TYPE, InputValue = Input.Value.ToString(), SessionKey = Paras[5].SESSION_KEY, ResetInput = Input
};
MESStationSession sampleQtySession = new MESStationSession()
{
MESDataType = Paras[6].SESSION_TYPE, InputValue = Input.Value.ToString(), SessionKey = Paras[6].SESSION_KEY, ResetInput = Input
};
MESStationSession RejectQtySession = new MESStationSession()
{
MESDataType = Paras[7].SESSION_TYPE, InputValue = Input.Value.ToString(), SessionKey = Paras[7].SESSION_KEY, ResetInput = Input
};
Station.StationSession.Clear();
Station.StationSession.Add(lotNoSession);
Station.StationSession.Add(skuNoSession);
Station.StationSession.Add(aqlSession);
Station.StationSession.Add(lotQtySession);
Station.StationSession.Add(sampleQtySession);
Station.StationSession.Add(RejectQtySession);
lotNoSession.Value = rLotStatus.LOT_NO;
skuNoSession.Value = rLotStatus.SKUNO;
aqlSession.Value = rLotStatus.AQL_TYPE;
lotQtySession.Value = rLotStatus.LOT_QTY;
sampleQtySession.Value = rLotStatus.SAMPLE_QTY;
RejectQtySession.Value = rLotStatus.REJECT_QTY;
MESStationInput s = Station.Inputs.Find(t => t.DisplayName == Paras[1].SESSION_TYPE);
s.DataForUse.Clear();
foreach (var VARIABLE in rLotPackList)
{
s.DataForUse.Add(VARIABLE.PACKNO);
}
MESStationInput l = Station.Inputs.Find(t => t.DisplayName == "AQLLEVEL");
l.DataForUse.Clear();
foreach (string VARIABLE in cAqlLevel)
{
l.DataForUse.Add(VARIABLE);
}
//設置默認等級
l.Value = cSkuAql.DEFAULLEVEL;
#endregion
}
