/// <summary>
/// 獲取BIP Panel未分板數量
/// </summary>
/// <param name="PanelSn"></param>
/// <param name="DB"></param>
/// <param name="DBType"></param>
/// <returns></returns>
public int PanelNoBIPQty(string PanelSn, OleExec DB, DB_TYPE_ENUM DBType)
{
int NoBIPQty = 0;
string errMsg = string.Empty;
if (DBType.Equals(DB_TYPE_ENUM.Oracle))
{
string strsql = $@"select count(1) from r_sn where sn in (
select sn from r_panel_sn where panel = '{PanelSn}' )
and id = sn";
NoBIPQty = int.Parse(DB.ExecSelectOneValue(strsql).ToString());
}
else
{
errMsg = MESReturnMessage.GetMESReturnMessage("MES00000019", new string[] { DBType.ToString() });
throw new MESReturnMessage(errMsg);
}
return(NoBIPQty);
}
public int SetPanelInValid(string PanelNo, OleExec DB, DB_TYPE_ENUM DBType)
{
string strSql = string.Empty;
int result = 0;
string errMsg = string.Empty;
if (DBType.Equals(DB_TYPE_ENUM.Oracle))
{
strSql = $@"UPDATE R_SN SET VALID_FLAG='0',CURRENT_STATION='UNDO_LOADING' WHERE ID IN
(SELECT SN FROM R_PANEL_SN WHERE PANEL='{PanelNo}')";
result = DB.ExecSqlNoReturn(strSql, null);
}
else
{
errMsg = MESReturnMessage.GetMESReturnMessage("MES00000019", new string[] { DBType.ToString() });
throw new MESReturnMessage(errMsg);
}
return(result);
}