/// <summary> /// An internal function to get the database parameters /// </summary> /// <returns>Parameter array</returns> private static OracleParameter[] GetAdapterParameters() { OracleParameter[] parms = OracleHelperParameterCache.GetCachedParameterSet(SQL_INSERT_DJNOISE,"INSERT:UPDATE"); if (parms == null) { parms = new OracleParameter[] { new OracleParameter(PARM_DEVID,OracleType.VarChar,19), new OracleParameter(PARM_DDATA,OracleType.VarChar,255), new OracleParameter(PARM_DBEGIN,OracleType.VarChar,255), new OracleParameter(PARM_DINTERVAL,OracleType.VarChar,255), new OracleParameter(PARM_DCOUNT,OracleType.VarChar,255), new OracleParameter(PARM_WARELESSOPEN,OracleType.VarChar,255), new OracleParameter(PARM_WARELESSCLOSE,OracleType.VarChar,255), new OracleParameter(PARM_CELL,OracleType.VarChar,255), new OracleParameter(PARM_SIGNAL,OracleType.VarChar,255), new OracleParameter(PARM_STATUS,OracleType.VarChar,255), new OracleParameter(PARM_UPTIME,OracleType.DateTime), new OracleParameter(PARM_LOGTIME,OracleType.DateTime) }; OracleHelperParameterCache.CacheParameterSet(SQL_INSERT_DJNOISE,"INSERT:UPDATE",parms); } return(parms); }
/// <summary> /// An internal function to get the database parameters /// </summary> /// <returns>Parameter array</returns> private static OracleParameter[] GetAdapterParameters() { OracleParameter[] parms = OracleHelperParameterCache.GetCachedParameterSet(SQL_SELECT_CFG_DEV, "SELECT"); if (parms == null) { parms = new OracleParameter[] { new OracleParameter(PARM_DEVID, OracleType.VarChar, 255) }; OracleHelperParameterCache.CacheParameterSet(SQL_SELECT_CFG_DEV, "SELECT", parms); } return(parms); }
/// <summary> /// An internal function to get the database parameters /// </summary> /// <returns>Parameter array</returns> private static OracleParameter[] GetDeviceStatusParameters() { OracleParameter[] parms = OracleHelperParameterCache.GetCachedParameterSet(SQL_UPDATE_ALARM_DEVICE_STATUS, "INSERT:UPDADAPTER"); if (parms == null) { parms = new OracleParameter[] { new OracleParameter(PARM_LASTTIME, OracleType.DateTime), new OracleParameter(PARM_STATUS, OracleType.Number, 1), new OracleParameter(PARM_DBID, OracleType.Number, 19) }; OracleHelperParameterCache.CacheParameterSet(SQL_UPDATE_ALARM_DEVICE_STATUS, "INSERT:UPDADAPTER", parms); } return(parms); }
/// <summary> /// An internal function to get the database parameters /// </summary> /// <returns>Parameter array</returns> private static OracleParameter[] GetAdapterParameters() { OracleParameter[] parms = OracleHelperParameterCache.GetCachedParameterSet(SQL_INSERT_NK_GX_VIBRATING_POSITION, "INSERT:UPDATE"); if (parms == null) { parms = new OracleParameter[] { new OracleParameter(PARM_DEVID, OracleType.NVarChar, 19), new OracleParameter(PARM_DISTANCE, OracleType.NVarChar, 255), new OracleParameter(PARM_VIBRATING, OracleType.NVarChar, 255), new OracleParameter(PARM_UPTIME, OracleType.DateTime), new OracleParameter(PARM_LOGTIME, OracleType.DateTime) }; OracleHelperParameterCache.CacheParameterSet(SQL_INSERT_NK_GX_VIBRATING_POSITION, "INSERT:UPDATE", parms); } return(parms); }
/// <summary> /// An internal function to get the database parameters /// </summary> /// <returns>Parameter array</returns> private static OracleParameter[] GetAdapterParameters() { OracleParameter[] parms = OracleHelperParameterCache.GetCachedParameterSet(SQL_INSERT_CASIC_PRESS, "INSERT:UPDATE"); if (parms == null) { parms = new OracleParameter[] { new OracleParameter(PARM_DEVID, OracleType.VarChar, 255), new OracleParameter(PARM_DDATA, OracleType.VarChar, 255), new OracleParameter(PARM_LOGTIME, OracleType.DateTime), new OracleParameter(PARM_UPTIME, OracleType.DateTime), new OracleParameter(PARM_CELL, OracleType.VarChar, 255), }; OracleHelperParameterCache.CacheParameterSet(SQL_INSERT_CASIC_PRESS, "INSERT:UPDATE", parms); } return(parms); }
/// <summary> /// An internal function to get the database parameters /// </summary> /// <returns>Parameter array</returns> private static OracleParameter[] GetAdapterParameters() { OracleParameter[] parms = OracleHelperParameterCache.GetCachedParameterSet(SQL_INSERT_WELLINFO, "INSERT:UPDATE"); if (parms == null) { parms = new OracleParameter[] { new OracleParameter(PARM_DEVID, OracleType.VarChar, 19), new OracleParameter(PARM_CELL, OracleType.VarChar, 255), new OracleParameter(PARM_DESCN, OracleType.VarChar, 255), new OracleParameter(PARM_STATUS, OracleType.VarChar, 255), new OracleParameter(PARM_LOGTIME, OracleType.DateTime) }; OracleHelperParameterCache.CacheParameterSet(SQL_INSERT_WELLINFO, "INSERT:UPDATE", parms); } return(parms); }
/// <summary> /// An internal function to get the database parameters /// </summary> /// <returns>Parameter array</returns> private static OracleParameter[] GetAdapterParameters() { OracleParameter[] parms = OracleHelperParameterCache.GetCachedParameterSet(SQL_INSERT_WS, "INSERT:UPDATE"); if (parms == null) { parms = new OracleParameter[] { new OracleParameter(PARM_DEVID, OracleType.VarChar, 255), new OracleParameter(PARM_UPTIME, OracleType.DateTime), new OracleParameter(PARM_CO, OracleType.VarChar, 255), new OracleParameter(PARM_O2, OracleType.VarChar, 255), new OracleParameter(PARM_H2S, OracleType.VarChar, 255), new OracleParameter(PARM_FIREGAS, OracleType.VarChar, 255) }; OracleHelperParameterCache.CacheParameterSet(SQL_INSERT_WS, "INSERT:UPDATE", parms); } return(parms); }
/// <summary> /// An internal function to get the database parameters /// </summary> /// <returns>Parameter array</returns> private static OracleParameter[] GetAdapterParameters() { OracleParameter[] parms = OracleHelperParameterCache.GetCachedParameterSet(SQL_INSERT_YL, "INSERT:UPDATE"); if (parms == null) { parms = new OracleParameter[] { new OracleParameter(PARM_SRCID, OracleType.VarChar, 255), new OracleParameter(PARM_DSTID, OracleType.VarChar, 255), new OracleParameter(PARM_CURMINUTEYULIANG, OracleType.VarChar, 255), new OracleParameter(PARM_FORMINUTEYULIANG, OracleType.VarChar, 255), new OracleParameter(PARM_TOTALYULIANG, OracleType.VarChar, 255), new OracleParameter(PARM_UPTIME, OracleType.Timestamp), new OracleParameter(PARM_LOGTIME, OracleType.DateTime), new OracleParameter(PARM_VALUE, OracleType.Double) }; OracleHelperParameterCache.CacheParameterSet(SQL_INSERT_YL, "INSERT:UPDATE", parms); } return(parms); }
/// <summary> /// An internal function to get the database parameters /// </summary> /// <returns>Parameter array</returns> private static OracleParameter[] GetAdapterParameters() { OracleParameter[] parms = OracleHelperParameterCache.GetCachedParameterSet(SQL_INSERT_FSHJ, "INSERT:UPDATE"); if (parms == null) { parms = new OracleParameter[] { new OracleParameter(PARM_DEVID, OracleType.NVarChar, 19), new OracleParameter(PARM_CELL, OracleType.NVarChar, 255), new OracleParameter(PARM_UNDER_TEMP1, OracleType.NVarChar, 255), new OracleParameter(PARM_UNDER_TEMP2, OracleType.NVarChar, 255), new OracleParameter(PARM_OUTTER_TEMP1, OracleType.NVarChar, 255), new OracleParameter(PARM_OUTTER_TEMP2, OracleType.NVarChar, 255), new OracleParameter(PARM_UNDER_VOL1, OracleType.NVarChar, 255), new OracleParameter(PARM_UNDER_VOL2, OracleType.NVarChar, 255), new OracleParameter(PARM_UNDER_VOL3, OracleType.NVarChar, 255), new OracleParameter(PARM_UNDER_VOL4, OracleType.NVarChar, 255), new OracleParameter(PARM_UNDER_VOL5, OracleType.NVarChar, 255), new OracleParameter(PARM_UNDER_VOL6, OracleType.NVarChar, 255), new OracleParameter(PARM_UNDER_WATER1, OracleType.NVarChar, 255), new OracleParameter(PARM_UNDER_WATER2, OracleType.NVarChar, 255), new OracleParameter(PARM_UNDER_WATER3, OracleType.NVarChar, 255), new OracleParameter(PARM_UNDER_WATER4, OracleType.NVarChar, 255), new OracleParameter(PARM_UNDER_WATER5, OracleType.NVarChar, 255), new OracleParameter(PARM_UNDER_WATER6, OracleType.NVarChar, 255), new OracleParameter(PARM_STATUS, OracleType.NVarChar, 255), new OracleParameter(PARM_UPTIME, OracleType.DateTime), new OracleParameter(PARM_LOGTIME, OracleType.DateTime) }; OracleHelperParameterCache.CacheParameterSet(SQL_INSERT_FSHJ, "INSERT:UPDATE", parms); } return(parms); }
/// <summary> /// An internal function to get the database parameters /// </summary> /// <returns>Parameter array</returns> private static OracleParameter[] GetAdapterParameters() { OracleParameter[] parms = OracleHelperParameterCache.GetCachedParameterSet(SQL_INSERT_RQ, "INSERT:UPDATE"); if (parms == null) { parms = new OracleParameter[] { new OracleParameter(PARM_ADDRESS, OracleType.VarChar, 255), new OracleParameter(PARM_INPRESS, OracleType.VarChar, 255), new OracleParameter(PARM_OUTPRESS, OracleType.VarChar, 255), new OracleParameter(PARM_FLOW, OracleType.VarChar, 255), new OracleParameter(PARM_STRENGTH, OracleType.VarChar, 255), new OracleParameter(PARM_TEMPERATURE, OracleType.VarChar, 255), new OracleParameter(PARM_CELL, OracleType.VarChar, 255), new OracleParameter(PARM_UPTIME, OracleType.DateTime), new OracleParameter(PARM_LOGTIME, OracleType.DateTime, 255) }; OracleHelperParameterCache.CacheParameterSet(SQL_INSERT_RQ, "INSERT:UPDATE", parms); } return(parms); }
/// <summary> /// An internal function to get the database parameters /// </summary> /// <returns>Parameter array</returns> private static OracleParameter[] GetAdapterParameters() { OracleParameter[] parms = OracleHelperParameterCache.GetCachedParameterSet(SQL_INSERT_RQGAS, "INSERT:UPDATE"); if (parms == null) { parms = new OracleParameter[] { new OracleParameter(PARM_DBID, OracleType.Number, 19), new OracleParameter(PARM_DEVID, OracleType.NVarChar, 19), new OracleParameter(PARM_LEAKDATA, OracleType.NVarChar, 255), new OracleParameter(PARM_INPRESS, OracleType.NVarChar, 255), new OracleParameter(PARM_OUTPRESS, OracleType.NVarChar, 255), new OracleParameter(PARM_TEMPGAS, OracleType.NVarChar, 255), new OracleParameter(PARM_TEMPROOM, OracleType.NVarChar, 255), new OracleParameter(PARM_CELLPOWER, OracleType.NVarChar, 255), new OracleParameter(PARM_RECORDTIME, OracleType.DateTime) }; OracleHelperParameterCache.CacheParameterSet(SQL_INSERT_RQGAS, "INSERT:UPDATE", parms); } return(parms); }
/// <summary> /// An internal function to get the database parameters /// </summary> /// <returns>Parameter array</returns> private static OracleParameter[] GetAdapterParameters() { OracleParameter[] parms = OracleHelperParameterCache.GetCachedParameterSet(SQL_INSERT_AD_SL_NOISE,"INSERT:UPDATE"); if (parms == null) { parms = new OracleParameter[] { new OracleParameter(PARM_SRCID,OracleType.VarChar,255), new OracleParameter(PARM_DSTID,OracleType.VarChar,255), new OracleParameter(PARM_DENSEDATA,OracleType.VarChar,255), new OracleParameter(PARM_CELL,OracleType.VarChar,255), new OracleParameter(PARM_SIGNAL,OracleType.VarChar,255), new OracleParameter(PARM_STATUS,OracleType.VarChar,255), new OracleParameter(PARM_UPTIME,OracleType.DateTime), new OracleParameter(PARM_LOGTIME,OracleType.DateTime), new OracleParameter(PARM_FREQUENCY,OracleType.VarChar,255) }; OracleHelperParameterCache.CacheParameterSet(SQL_INSERT_AD_SL_NOISE,"INSERT:UPDATE",parms); } return(parms); }
/// <summary> /// An internal function to get the database parameters /// </summary> /// <returns>Parameter array</returns> private static OracleParameter[] GetAdapterParameters() { /* * private const string PARM_DEVID = ":DEVCODE"; * private const string PARM_OPENCIRCUITPOTENTIAL = ":OPENCIRCUITPOTENTIAL"; * private const string PARM_INSULANCE = ":INSULANCE"; * private const string PARM_CORROSIONRATE = ":CORROSIONRATE"; * private const string PARM_POLARRESISTIVITY = ":POLARRESISTIVITY"; * private const string PARM_COCURRENTDENSITY = ":COCURRENTDENSITY"; * private const string PARM_CELL = ":CELL"; * private const string PARM_STATUS = ":STATUS"; * private const string PARM_UPTIME = ":UPTIME"; * private const string PARM_LOGTIME = ":LOGTIME"; * */ OracleParameter[] parms = OracleHelperParameterCache.GetCachedParameterSet(SQL_INSERT_ERROSION, "INSERT:UPDATE"); if (parms == null) { parms = new OracleParameter[] { new OracleParameter(PARM_DEVID, OracleType.NVarChar, 19), new OracleParameter(PARM_OPENCIRCUITPOTENTIAL, OracleType.NVarChar, 255), new OracleParameter(PARM_INSULANCE, OracleType.NVarChar, 255), new OracleParameter(PARM_CORROSIONRATE, OracleType.NVarChar, 255), new OracleParameter(PARM_POLARRESISTIVITY, OracleType.NVarChar, 255), new OracleParameter(PARM_COCURRENTDENSITY, OracleType.NVarChar, 255), new OracleParameter(PARM_CELL, OracleType.NVarChar, 255), new OracleParameter(PARM_STATUS, OracleType.NVarChar, 255), new OracleParameter(PARM_UPTIME, OracleType.DateTime), new OracleParameter(PARM_LOGTIME, OracleType.DateTime) }; OracleHelperParameterCache.CacheParameterSet(SQL_INSERT_ERROSION, "INSERT:UPDATE", parms); } return(parms); }
/// <summary> /// An internal function to get the database parameters /// </summary> /// <returns>Parameter array</returns> private static OracleParameter[] GetAdapterParameters() { OracleParameter[] parms = OracleHelperParameterCache.GetCachedParameterSet(SQL_INSERT_DJFLOW,"INSERT:UPDATE"); if (parms == null) { parms = new OracleParameter[] { new OracleParameter(PARM_DEVID,OracleType.VarChar,255), new OracleParameter(PARM_INSDATA,OracleType.VarChar,255), new OracleParameter(PARM_NETDATA,OracleType.VarChar,255), new OracleParameter(PARM_POSDATA,OracleType.VarChar,255), new OracleParameter(PARM_NEGDATA,OracleType.VarChar,255), new OracleParameter(PARM_SIGNAL,OracleType.VarChar,255), new OracleParameter(PARM_CELL,OracleType.VarChar,255), new OracleParameter(PARM_STATUS,OracleType.VarChar,255), new OracleParameter(PARM_UPTIME,OracleType.DateTime), new OracleParameter(PARM_LOGTIME,OracleType.DateTime) }; OracleHelperParameterCache.CacheParameterSet(SQL_INSERT_DJFLOW,"INSERT:UPDATE",parms); } return(parms); }