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