public Row_R_REPAIR_FAILCODE GetByFailCodeID(string _FailCodeID, OleExec DB)
{
string strsql = "";
if (DBType == DB_TYPE_ENUM.Oracle)
{
strsql = $@" select * from r_repair_failcode where ID='{_FailCodeID.Replace("'", "''")}' and REPAIR_FLAG='0' ";
DataSet res = DB.ExecSelect(strsql);
if (res.Tables[0].Rows.Count > 0)
{
Row_R_REPAIR_FAILCODE Ret = (Row_R_REPAIR_FAILCODE)this.GetObjByID(_FailCodeID, DB);
return(Ret);
}
else
{
return(null);
//string errMsg = MESReturnMessage.GetMESReturnMessage("MES00000007", new string[] { "FailCodeID:" + _FailCodeID });
// throw new MESReturnMessage(errMsg);
}
}
else
{
string errMsg = MESReturnMessage.GetMESReturnMessage("MES00000019", new string[] { DBType.ToString() });
throw new MESReturnMessage(errMsg);
}
}
public List <R_REPAIR_FAILCODE> CheckSNRepairFinishAction(OleExec sfcdb, string sn, string RepairMainID)
{
if (string.IsNullOrEmpty(sn) || string.IsNullOrEmpty(RepairMainID))
{
return(null);
}
DataTable dt = null;
Row_R_REPAIR_FAILCODE row_fail = null;
List <R_REPAIR_FAILCODE> repairFailCodes = new List <R_REPAIR_FAILCODE>();
string sql = $@" select *from r_repair_failcode where repair_main_id ='{RepairMainID}' and sn ='{sn}' and id not in (select repair_failcode_id from r_repair_action where sn='{sn}')";
if (DBType == DB_TYPE_ENUM.Oracle)
{
try
{
dt = sfcdb.ExecSelect(sql).Tables[0];
foreach (DataRow dr in dt.Rows)
{
row_fail = (Row_R_REPAIR_FAILCODE)this.NewRow();
row_fail.loadData(dr);
repairFailCodes.Add(row_fail.GetDataObject());
}
}
catch (Exception ex)
{
throw new MESReturnMessage(MESReturnMessage.GetMESReturnMessage("MES00000037", new string[] { ex.Message }));
}
}
else
{
throw new MESReturnMessage(MESReturnMessage.GetMESReturnMessage("MES00000019", new string[] { DBType.ToString() }));
}
return(repairFailCodes);
}
public List <R_REPAIR_FAILCODE> GetFailCodeBySN(OleExec sfcdb, string sn)
{
if (string.IsNullOrEmpty(sn))
{
return(null);
}
DataTable dt = null;
Row_R_REPAIR_FAILCODE row_fail = null;
List <R_REPAIR_FAILCODE> repairFailCodes = new List <R_REPAIR_FAILCODE>();
string sql = $@"select * from {TableName} where sn='{sn.Replace("'", "''")}' ";
if (DBType == DB_TYPE_ENUM.Oracle)
{
try
{
dt = sfcdb.ExecSelect(sql).Tables[0];
foreach (DataRow dr in dt.Rows)
{
row_fail = (Row_R_REPAIR_FAILCODE)this.NewRow();
row_fail.loadData(dr);
repairFailCodes.Add(row_fail.GetDataObject());
}
}
catch (Exception ex)
{
throw new MESReturnMessage(MESReturnMessage.GetMESReturnMessage("MES00000037", new string[] { ex.Message }));
}
}
else
{
throw new MESReturnMessage(MESReturnMessage.GetMESReturnMessage("MES00000019", new string[] { DBType.ToString() }));
}
return(repairFailCodes);
}