Beispiel #1
0
        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())
            });
        }