using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using UAS_LabelMachine.Entity;

namespace UAS_LabelMachine.PublicMethod
{
    class LogicHandler
    {

        public static DataHelper dh = SystemInf.dh;

        public static void GetDataSQL(string iInoutno, string iText, out string oSQL)
        {
            oSQL = "";
            string[] param = new string[] { iInoutno, iText, oSQL };
            dh.CallProcedure("SP_GETDATASQL", ref param);
            oSQL = param[2];
        }

        public static void GetExportDataSQL(string iInoutno,string iCustCode,string iType, string iText, out string oSQL)
        {
            oSQL = "";
            string[] param = new string[] { iInoutno, iCustCode, iType, iText, oSQL };
            dh.CallProcedure("sp_getexportDataSql", ref param);
            oSQL = param[4];
        }

        public static void GetSinglePrintSQL( string iText, out string oSQL)
        {
            oSQL = "";
            string[] param = new string[] {iText, oSQL };
            dh.CallProcedure("sp_GetSinglePrintSQL", ref param);
            oSQL = param[1];
        }
    }
}