public int WwdTriggerRun(string partNumber, int qty)
{
var proc = new OracleProcCall("wwd_trig_run");
proc.AddInputParameter("p_part_number", partNumber, 14);
proc.AddInputParameter("p_qty", qty);
var result = proc.AddOutputParameterInt("p_job_uid");
proc.Execute();
return(Convert.ToInt32(result.Value.ToString()));
}
public ComponentCount CountComponents(string part)
{
var proc = new OracleProcCall("count_components");
proc.AddInputParameter("p_part_number", part, 14);
var result1 = proc.AddOutputParameterInt("p_smt_components");
var result2 = proc.AddOutputParameterInt("p_pcb_components");
proc.Execute();
return(new ComponentCount
{
SmtComponents = Convert.ToInt32(result1.Value.ToString()),
PcbComponents = Convert.ToInt32(result2.Value.ToString())
});
}