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); }