Exemple #1
0
        internal override string[] GetOutputValues(string snnumber, string[] fileContent)
        {
            var returnParams = OraDBUtil.ExecuteStoreProc(this.ProcedureName, SetStoreProcParams(snnumber, fileContent));

            string[] outputValues = GetOutputStringtoWrite(returnParams);
            return(outputValues);
        }
Exemple #2
0
        private string      Get_W_SECTION(DateTime dt)
        {
            var _time = DateTime.Now.ToString("HHmm");
            var s     =
                "Select WORK_SECTION WRKSec From SFIS1.C_WORK_DESC_T WHERE START_TIME <=:Time AND END_TIME >:Time AND LINE_NAME ='Default' AND SECTION_NAME = 'Default' AND SHIFT = '1'";
            var parameters = new Dictionary <string, object>();

            parameters.Add("Time", _time);
            var result = OraDBUtil.ExecuteSQL(s, parameters);

            parameters = null;
            return(result.ToString());
        }