/// <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);
}