public List <C_AQLTYPE> GetAqlTypeBySkuno(string skuno, OleExec DB)
{
List <C_AQLTYPE> aqls = new List <C_AQLTYPE>();
string sql = string.Empty;
DataTable dt = new DataTable("Allc_aqltype");
Row_C_AQLTYPE aqlsRow = (Row_C_AQLTYPE)NewRow();
if (this.DBType.Equals(DB_TYPE_ENUM.Oracle))
{
sql = $@" select b.* from c_sku a,c_aqltype b where a.aqltype=b.aql_type and a.skuno='{skuno}' ";
dt = DB.ExecSelect(sql, null).Tables[0];
foreach (DataRow dr in dt.Rows)
{
aqlsRow.loadData(dr);
aqls.Add(aqlsRow.GetDataObject());
}
}
else
{
string errMsg = MESReturnMessage.GetMESReturnMessage("MES00000019", new string[] { DBType.ToString() });
throw new MESReturnMessage(errMsg);
}
return(aqls);
}
public List <C_AQLTYPE> GetAqlBySkuno(string aqltype, OleExec DB)
{
List <C_AQLTYPE> aqls = new List <C_AQLTYPE>();
string sql = string.Empty;
DataTable dt = new DataTable("Allc_aqltype");
Row_C_AQLTYPE aqlsRow = (Row_C_AQLTYPE)NewRow();
if (this.DBType.Equals(DB_TYPE_ENUM.Oracle))
{
sql = $@" select * from c_aqltype where AQL_TYPE='{aqltype}' order by aql_type,gl_level,lot_qty asc ";
dt = DB.ExecSelect(sql, null).Tables[0];
foreach (DataRow dr in dt.Rows)
{
aqlsRow.loadData(dr);
aqls.Add(aqlsRow.GetDataObject());
}
}
else
{
string errMsg = MESReturnMessage.GetMESReturnMessage("MES00000019", new string[] { DBType.ToString() });
throw new MESReturnMessage(errMsg);
}
return(aqls);
}
