internal override string[] GetOutputValues(string snnumber, string[] fileContent) { var returnParams = OraDBUtil.ExecuteStoreProc(this.ProcedureName, SetStoreProcParams(snnumber, fileContent)); string[] outputValues = GetOutputStringtoWrite(returnParams); return(outputValues); }
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()); }