private SQLiteParameter[] GetSqlParameters()
{
List <SQLiteParameter> SqlParmColl = new List <SQLiteParameter>();
try
{
SqlParmColl.Add(CommonDB.AddSqlParm("@ID", ID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@DisplayID", DisplayID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@oIndex", oIndex, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Left", Left, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Right", Right, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Top", Top, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Bottom", Bottom, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@ButtonText", ButtonText, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@BackColor", BackColor.ToArgb(), DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Font", Font, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@FontColor", FontColor.ToArgb(), DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@NavigateTo", NavigateTo, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@IsTransparent", IsTransparent, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@LastRev", LastRev, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@CompiledExp", CompiledExp, DbType.Binary));
return(SqlParmColl.ToArray());
}
catch (SQLiteException Exc)
{
throw Exc;
}
}
private SQLiteParameter[] GetSqlParameters()
{
List <SQLiteParameter> SqlParmColl = new List <SQLiteParameter>();
try
{
SqlParmColl.Add(CommonDB.AddSqlParm("@VarNameID", VarNameID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@SampleTime", SampleTime, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@PointGroup", PointGroup, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@UNI", UNI, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@IRL", IRL, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@IRH", IRH, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@LL", LL, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@HH", HH, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@L", L, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@H", H, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@RTT", RTT, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@Interval", Interval, DbType.Int32));
return(SqlParmColl.ToArray());
}
catch (SQLiteException Exc)
{
throw Exc;
}
}
private SQLiteParameter[] GetSqlParameters()
{
List <SQLiteParameter> SqlParmColl = new List <SQLiteParameter>();
try
{
SqlParmColl.Add(CommonDB.AddSqlParm("@ID", ID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@DisplayID", DisplayID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@oIndex", oIndex, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@bBrush", bBrush, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@bPen", bPen, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@LogpenLopnColor", LogpenLopnColor, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@LogpenLopnStyle", LogpenLopnStyle, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@LogpenLopnWidthX", LogpenLopnWidthX, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@LogpenLopnWidthY", LogpenLopnWidthY, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@LogbrushLbColor", LogbrushLbColor, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@LogbrushLbHatch", LogbrushLbHatch, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@LogbrushLbStyle", LogbrushLbStyle, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Left", Left, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Top", Top, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Right", Right, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Bottom", Bottom, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@LastRev", LastRev, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@CompiledExp", CompiledExp, DbType.Binary));
SqlParmColl.Add(CommonDB.AddSqlParm("@validexpression", validexpression, DbType.Boolean));
return(SqlParmColl.ToArray());
}
catch (SQLiteException Exc)
{
throw Exc;
}
}
private SQLiteParameter[] GetSqlParameters()
{
List <SQLiteParameter> SqlParmColl = new List <SQLiteParameter>();
try
{
SqlParmColl.Add(CommonDB.AddSqlParm("@ModbusClientDataID", ModbusClientDataID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@MobusClientID", MobusClientID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@StaNo", StaNo, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@LinkName", LinkName, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@LinkType", LinkType, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@PortName", PortName, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@BaudRate", BaudRate, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@Parity", Parity, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@StopBit", StopBit, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@DataSize", DataSize, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@Redundant", Redundant, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@IP", IP, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@PortNumber", PortNumber, DbType.Int16));
return(SqlParmColl.ToArray());
}
catch (SQLiteException Exc)
{
throw Exc;
}
}
private SQLiteParameter[] GetSqlParameters()
{
List <SQLiteParameter> SqlParmColl = new List <SQLiteParameter>();
try
{
SqlParmColl.Add(CommonDB.AddSqlParm("@ModbusClientID", ModbusClientID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@ControllerID", ControllerID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@NoOfLink", NoOfLink, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@SlaveNo", SlaveNo, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@StaNo", StaNo, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@Placement", Placement, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@Dig1", Dig1, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@Dig2", Dig2, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@DigIndex1", DigIndex1, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@DigIndex2", DigIndex2, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@DigType1", DigType1, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@DigType2", DigType2, DbType.Int16));
return(SqlParmColl.ToArray());
}
catch (SQLiteException Exc)
{
throw Exc;
}
}
private SQLiteParameter[] GetSqlParameters()
{
List <SQLiteParameter> SqlParmColl = new List <SQLiteParameter>();
try
{
SqlParmColl.Add(CommonDB.AddSqlParm("@FBDBlockID", FBDBlockID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@UDFunctionID", UDFunctionID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@FunctionID", FunctionID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@FunctionName", FunctionName, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@VarpouID", VarpouID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@VarNameID", VarNameID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@PinName", PinName, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@VarType", VarType, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@InstanceName", InstanceName, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@Type", Type, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@X", X, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Y", Y, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@NoOfExtensiblePins", NoOfExtensiblePins, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Page", Page, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@ISObject", ISObject, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@IsExtendedProperty", IsExtendedProperty, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@ExtendedPropertyTXT", ExtendedPropertyTXT, DbType.String));
return(SqlParmColl.ToArray());
}
catch (SQLiteException Exc)
{
throw Exc;
}
}
private SQLiteParameter[] GetSqlParameters()
{
List<SQLiteParameter> SqlParmColl = new List<SQLiteParameter>();
try
{
SqlParmColl.Add(CommonDB.AddSqlParm("@ID", ID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@DisplayID", DisplayID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@oIndex", oIndex, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Points", Points, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@LineType", LineType, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@LastRev", LastRev, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@FillColor", FillColor, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@LineStyle", LineStyle, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@Lock", Lock, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@Visible", Visible, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@Expression", Expression, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@Action", Action, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@Layer", Layer, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Argument", Argument, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@CompiledExp", CompiledExp, DbType.Binary));
SqlParmColl.Add(CommonDB.AddSqlParm("@validexpression", validexpression, DbType.Boolean));
return SqlParmColl.ToArray();
}
catch (SQLiteException Exc)
{
throw Exc;
}
}
private SQLiteParameter[] GetSqlParameters()
{
List <SQLiteParameter> SqlParmColl = new List <SQLiteParameter>();
try
{
SqlParmColl.Add(CommonDB.AddSqlParm("@ADTextID", ADTextID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@SymbolStatusID", SymbolStatusID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@oIndex", oIndex, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@DlgType", DlgType, DbType.Byte));
SqlParmColl.Add(CommonDB.AddSqlParm("@DlgIndex", DlgIndex, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Left", Left, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Right", Right, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Top", Top, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Bottom", Bottom, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Format", Format, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Alignment", Alignment, DbType.Byte));
SqlParmColl.Add(CommonDB.AddSqlParm("@Font", Font, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@TextValueDefult", TextValueDefult, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@TextColorDefult", TextColorDefult.ToArgb(), DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@TextBlinkingDefult", TextBlinkingDefult, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@BorderColorDefult", BorderColorDefult.ToArgb(), DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@BorderBlinkingDefult", BorderBlinkingDefult, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@BorderWidthDefult", BorderWidthDefult, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@BackGroundColorDefult", BackGroundColorDefult.ToArgb(), DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@BackGroundBlinkingDefult", BackGroundBlinkingDefult, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@Orientation", Orientation, DbType.Int32));
return(SqlParmColl.ToArray());
}
catch (SQLiteException Exc)
{
throw Exc;
}
}
private SQLiteParameter[] GetSqlParameters()
{
List <SQLiteParameter> SqlParmColl = new List <SQLiteParameter>();
try
{
SqlParmColl.Add(CommonDB.AddSqlParm("@BitmapID", BitmapID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@BitmapName", BitmapName, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@SymbolStatusID", SymbolStatusID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@oIndex", oIndex, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@bBrush", bBrush, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@bPen", bPen, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@LogpenLopnColor", LogpenLopnColor, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@LogpenLopnStyle", LogpenLopnStyle, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@LogpenLopnWidthX", LogpenLopnWidthX, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@LogpenLopnWidthY", LogpenLopnWidthY, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@LogbrushLbColor", LogbrushLbColor, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@LogbrushLbHatch", LogbrushLbHatch, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@LogbrushLbStyle", LogbrushLbStyle, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@left", left, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@top", top, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@right", right, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@bottom", bottom, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Transparent", Transparent, DbType.Boolean));
return(SqlParmColl.ToArray());
}
catch (SQLiteException Exc)
{
throw Exc;
}
}
private SQLiteParameter[] GetSqlParameters()
{
List <SQLiteParameter> SqlParmColl = new List <SQLiteParameter>();
try
{
SqlParmColl.Add(CommonDB.AddSqlParm("@ModbusServerID", ModbusServerID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@ControllerID", ControllerID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@ModbusServerNo", ModbusServerNo, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@LinkName", LinkName, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@LinkNo", LinkNo, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@LinkType", LinkType, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@PortName", PortName, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@RedPortName", RedPortName, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@BaudRate", BaudRate, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@Parity", Parity, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@StopBit", StopBit, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@DataSize", DataSize, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@Redundant", Redundant, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@IP", IP, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@PortNumber", PortNumber, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@StaNo", StaNo, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@Placement", Placement, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@NoOfSlave", NoOfSlave, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@Timeout", Timeout, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@NoOfRetry", NoOfRetry, DbType.Int16));
return(SqlParmColl.ToArray());
}
catch (SQLiteException Exc)
{
throw Exc;
}
}
private SQLiteParameter[] GetSqlParameters()
{
List <SQLiteParameter> SqlParmColl = new List <SQLiteParameter>();
try
{
SqlParmColl.Add(CommonDB.AddSqlParm("@ID", ID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@DisplayID", DisplayID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@oIndex", oIndex, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@bFont", bFont, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@Hidable", Hidable, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@Font", Font, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@TextColor", TextColor.ToArgb(), DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Left", Left, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Top", Top, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Right", Right, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Bottom", Bottom, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Txt", Txt, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@FillColor", FillColor, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@lineStyle", lineStyle, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@Lock", Lock, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@Visible", Visible, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@Expression", Expression, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@Action", Action, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@Layer", Layer, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@CompiledExp", CompiledExp, DbType.Binary));
SqlParmColl.Add(CommonDB.AddSqlParm("@validexpression", validexpression, DbType.Boolean));
return(SqlParmColl.ToArray());
}
catch (SQLiteException Exc)
{
throw Exc;
}
}
private SQLiteParameter[] GetSqlParameters()
{
List <SQLiteParameter> SqlParmColl = new List <SQLiteParameter>();
try
{
SqlParmColl.Add(CommonDB.AddSqlParm("@STDBID", STDBID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@NAME", NAME, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@StaType", StaType, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@StaNo", StaNo, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@Sta_Dig", Sta_Dig, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@NoOfHW", NoOfHW, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@Hwno1", Hwno1, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@HW_Dig1", HW_Dig1, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Hwno2", Hwno2, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@HW_Dig2", HW_Dig2, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@NoOfIP", NoOfIP, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@IP1_1", IP1_1, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@IP1_1_Dig", IP1_1_Dig, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@IP1_2", IP1_2, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@IP1_2_Dig", IP1_2_Dig, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@IP2_1", IP2_1, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@IP2_1_Dig", IP2_1_Dig, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@IP2_2", IP2_2, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@IP2_2_Dig", IP2_2_Dig, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@ControllerID", ControllerID, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@DomainID", DomainID, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@TargetType", TargetType, DbType.Byte));
return(SqlParmColl.ToArray());
}
catch (SQLiteException Exc)
{
throw Exc;
}
}
private SQLiteParameter[] GetSqlParameters()
{
List <SQLiteParameter> SqlParmColl = new List <SQLiteParameter>();
try
{
SqlParmColl.Add(CommonDB.AddSqlParm("@ID", ID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@BitmapName", BitmapName, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@DisplayID", DisplayID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@oIndex", oIndex, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@left", left, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@top", top, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@right", right, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@bottom", bottom, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Transparent", Transparent, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@Rotation", Rotation, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@LockPosition", LockPosition, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@LockEdit", LockEdit, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@Layer", Layer, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@LastRev", LastRev, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@Action", Action, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@Expression", Expression, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@Argument", Argument, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@CompiledExp", CompiledExp, DbType.Binary));
SqlParmColl.Add(CommonDB.AddSqlParm("@validexpression", validexpression, DbType.Boolean));
return(SqlParmColl.ToArray());
}
catch (SQLiteException Exc)
{
throw Exc;
}
}
private SQLiteParameter[] GetSqlParameters()
{
List <SQLiteParameter> SqlParmColl = new List <SQLiteParameter>();
try
{
SqlParmColl.Add(CommonDB.AddSqlParm("@BoardName", BoardName, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@BoardID", BoardID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@ControllerID", ControllerID, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@oIndex", oIndex, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Description", Description, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@BoardGroup", BoardGroup, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Type", Type, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@SlotNo1", SlotNo1, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@SlotNo2", SlotNo2, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@IORackNumber1", IORackNumber1, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@IORackNumber2", IORackNumber2, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@BoardNo", BoardNo, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@ScanTime", ScanTime, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@MBA1", MBA1, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@MBA2", MBA2, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@Redundant", Redundant, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@VariableID_DIG", VariableID_DIG, DbType.Int32));
return(SqlParmColl.ToArray());
}
catch (SQLiteException Exc)
{
throw Exc;
}
}
private SQLiteParameter[] GetSqlParameters()
{
List <SQLiteParameter> SqlParmColl = new List <SQLiteParameter>();
try
{
SqlParmColl.Add(CommonDB.AddSqlParm("@ID", ID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@VarNameID", VarNameID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@UNI", UNI, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@FOR", FOR, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@IRL", IRL, DbType.Single));
SqlParmColl.Add(CommonDB.AddSqlParm("@IRH", IRH, DbType.Single));
SqlParmColl.Add(CommonDB.AddSqlParm("@LL", LL, DbType.Single));
SqlParmColl.Add(CommonDB.AddSqlParm("@HH", HH, DbType.Single));
SqlParmColl.Add(CommonDB.AddSqlParm("@L", L, DbType.Single));
SqlParmColl.Add(CommonDB.AddSqlParm("@H", H, DbType.Single));
SqlParmColl.Add(CommonDB.AddSqlParm("@InstrumentUnitsGrpID", InstrumentUnitsGrpID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@InstrumentUnitsID", InstrumentUnitsID, DbType.Int64));
return(SqlParmColl.ToArray());
}
catch (SQLiteException Exc)
{
throw Exc;
}
}
private SQLiteParameter[] GetSqlParameters()
{
List <SQLiteParameter> SqlParmColl = new List <SQLiteParameter>();
try
{
SqlParmColl.Add(CommonDB.AddSqlParm("@PolylineID", PolylineID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@SymbolStatusID", SymbolStatusID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@oIndex", oIndex, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@BorderBlinking", BorderBlinking, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@BorderColor1", BorderColor1.ToArgb(), DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@BorderColor2", BorderColor2.ToArgb(), DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@BorderWidth", BorderWidth, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@BorderDashStyle", BorderDashStyle, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@LinePaternScale", LinePaternScale, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Blinking", Blinking, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@FillColor11", FillColor11.ToArgb(), DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@FillColor12", FillColor12.ToArgb(), DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@FillColor21", FillColor21.ToArgb(), DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@FillColor22", FillColor22.ToArgb(), DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@FillType", FillType, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@LinearGradientBrush", LinearGradientBrush, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@HachStyle", HachStyle, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@HachColor", HachColor.ToArgb(), DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@NoPoints", NoPoints, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Type", Type, DbType.Int32));
return(SqlParmColl.ToArray());
}
catch (SQLiteException Exc)
{
throw Exc;
}
}
private SQLiteParameter[] GetSqlParameters()
{
List <SQLiteParameter> SqlParmColl = new List <SQLiteParameter>();
try
{
SqlParmColl.Add(CommonDB.AddSqlParm("@ID", ID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@SolutionID", SolutionID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@Name", Name, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@ParentID", ParentID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@Type", Type, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Description", Description, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@IsObject", IsObject, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@IsFolder", IsFolder, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@PropertyPath", PropertyPath, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@Argument", Argument, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@Visible", Visible, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@NoOfAvailable", NoOfAvailable, DbType.Int32));
return(SqlParmColl.ToArray());
}
catch (SQLiteException Exc)
{
throw Exc;
}
}
private SQLiteParameter[] GetSqlParameters()
{
List <SQLiteParameter> SqlParmColl = new List <SQLiteParameter>();
try
{
SqlParmColl.Add(CommonDB.AddSqlParm("@ID", ID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@DisplayID", DisplayID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@SymbolID", SymbolID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@oIndex", oIndex, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@DlgType", DlgType, DbType.Byte));
SqlParmColl.Add(CommonDB.AddSqlParm("@DlgIndex", DlgIndex, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Left", Left, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Top", Top, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Value", Value, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@Orientation", Orientation, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@Inverse", Inverse, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@ScaleX", ScaleX, DbType.Double));
SqlParmColl.Add(CommonDB.AddSqlParm("@ScaleY", ScaleY, DbType.Double));
SqlParmColl.Add(CommonDB.AddSqlParm("@HasLevel", HasLevel, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@Param", Param, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@ValueID", ValueID, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@ShowState", ShowState, DbType.Byte));
SqlParmColl.Add(CommonDB.AddSqlParm("@LastRev", LastRev, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@validexpression", validexpression, DbType.Boolean));
return(SqlParmColl.ToArray());
}
catch (SQLiteException Exc)
{
throw Exc;
}
}
private SQLiteParameter[] GetSqlParameters()
{
List <SQLiteParameter> SqlParmColl = new List <SQLiteParameter>();
try
{
SqlParmColl.Add(CommonDB.AddSqlParm("@ID", ID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@VarNameID", VarNameID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@Type", Type, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@AlarmGroupID", AlarmGroupID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@EnableTagID", EnableTagID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@EnableTagDirection", EnableTagDirection, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@EnableTagDelayOn", EnableTagDelayOn, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@EnableTagDealyOff", EnableTagDealyOff, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@DelayOn", DelayOn, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@DelayOff", DelayOff, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@SourceAlarmTagID", SourceAlarmTagID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@FirstOutGroupID", FirstOutGroupID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@hysteresis", hysteresis, DbType.Single));
SqlParmColl.Add(CommonDB.AddSqlParm("@UpperLevelGroupID", UpperLevelGroupID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@StatusBit", StatusBit, DbType.Int32));
return(SqlParmColl.ToArray());
}
catch (SQLiteException Exc)
{
throw Exc;
}
}
private SQLiteParameter[] GetSqlParameters()
{
List <SQLiteParameter> SqlParmColl = new List <SQLiteParameter>();
try
{
SqlParmColl.Add(CommonDB.AddSqlParm("@FunctionID", FunctionID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@FunctionName", FunctionName, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@SolutionID", SolutionID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@Description", Description, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@Type", Type, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@IsStandard", IsStandard, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@FunctionGroup", FunctionGroup, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Extensible", Extensible, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@IsFunction", IsFunction, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@Language", Language, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Overloaded", Overloaded, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@Width", Width, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Mode", Mode, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Status", Status, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@statement", statement, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@state", state, DbType.Int32));
return(SqlParmColl.ToArray());
}
catch (SQLiteException Exc)
{
throw Exc;
}
}
private SQLiteParameter[] GetSqlParameters()
{
List <SQLiteParameter> SqlParmColl = new List <SQLiteParameter>();
try
{
SqlParmColl.Add(CommonDB.AddSqlParm("@UserNameID", UserNameID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@SolutionID", SolutionID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@User_Name", User_Name, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@Description", Description, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@Pass_word", Pass_word, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@LogicExplorer", LogicExplorer, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@SystemExplorer", SystemExplorer, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@ReportExplorer", ReportExplorer, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@UserExplorer", UserExplorer, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@PlantStructureExplorer", PlantStructureExplorer, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@DisplayExplorer", DisplayExplorer, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@CanChangePassword", CanChangePassword, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@NerverExpire", NerverExpire, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@LastChangeDate", LastChangeDate, DbType.DateTime));
SqlParmColl.Add(CommonDB.AddSqlParm("@VlidityDays", VlidityDays, DbType.Int32));
return(SqlParmColl.ToArray());
}
catch (SQLiteException Exc)
{
throw Exc;
}
}
private SQLiteParameter[] GetSqlParameters()
{
List <SQLiteParameter> SqlParmColl = new List <SQLiteParameter>();
try
{
SqlParmColl.Add(CommonDB.AddSqlParm("@FBDPinConnectionID", FBDPinConnectionID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@pouID", pouID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@RightObjectID", RightObjectID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@LeftObjectID", LeftObjectID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@RightPinNo", RightPinNo, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@LeftPinNo", LeftPinNo, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@RightPinName", RightPinName, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@LeftPinName", LeftPinName, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@autodraw", autodraw, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@Page", Page, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@X0", X0, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Y0", Y0, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@X1", X1, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Y1", Y1, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@X2", X2, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Y2", Y2, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@X3", X3, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Y3", Y3, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@X4", X4, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Y4", Y4, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@X5", X5, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Y5", Y5, DbType.Int32));
return(SqlParmColl.ToArray());
}
catch (SQLiteException Exc)
{
throw Exc;
}
}
private SQLiteParameter[] GetSqlParameters()
{
List <SQLiteParameter> SqlParmColl = new List <SQLiteParameter>();
try
{
SqlParmColl.Add(CommonDB.AddSqlParm("@FP_ParaID", FP_ParaID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@FP_TypeID", FP_TypeID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@FP_Name", FP_Name, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@VarNameID1", VarNameID1, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@VarNameID2", VarNameID2, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@VarNameID3", VarNameID3, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@VarNameID4", VarNameID4, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@VarNameID5", VarNameID5, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@VarNameID6", VarNameID6, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@VarNameID7", VarNameID7, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@VarNameID8", VarNameID8, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@VarNameID9", VarNameID9, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@VarNameID10", VarNameID10, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@VarNameID11", VarNameID11, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@VarNameID12", VarNameID12, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@VarNameID13", VarNameID13, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@VarNameID14", VarNameID14, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@VarNameID15", VarNameID15, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@VarNameID16", VarNameID16, DbType.Int32));
return(SqlParmColl.ToArray());
}
catch (SQLiteException Exc)
{
throw Exc;
}
}
private SQLiteParameter[] GetSqlParameters()
{
List <SQLiteParameter> SqlParmColl = new List <SQLiteParameter>();
try
{
SqlParmColl.Add(CommonDB.AddSqlParm("@ControllerName", ControllerName, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@ControllerID", ControllerID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@SolutionID", SolutionID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@NodeNumber", NodeNumber, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@oIndex", oIndex, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Description", Description, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@Redundant", Redundant, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@TargetType", TargetType, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@NumberOfIORack", NumberOfIORack, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@DIGID", DIGID, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@HW1DIGID", HW1DIGID, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@HW2DIGID", HW2DIGID, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@IP1_1DIGID", IP1_1DIGID, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@IP1_2DIGID", IP1_2DIGID, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@IP2_1DIGID", IP2_1DIGID, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@IP2_2DIGID", IP2_2DIGID, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@type", type, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@redundantnet", redundantnet, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@NetNo", NetNo, DbType.Int32));
return(SqlParmColl.ToArray());
}
catch (SQLiteException Exc)
{
throw Exc;
}
}
private SQLiteParameter[] GetSqlParameters()
{
List <SQLiteParameter> SqlParmColl = new List <SQLiteParameter>();
try
{
SqlParmColl.Add(CommonDB.AddSqlParm("@PinID", PinID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@PinName", PinName, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@FunctionID", FunctionID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@Type", Type, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Reference", Reference, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@Class", Class, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@Extensible", Extensible, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@oIndex", oIndex, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Description", Description, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@InitializeValue", InitializeValue, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@EV_TXT", EV_TXT, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@EV_EBL", EV_EBL, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@Option", Option, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@FBDPossible", FBDPossible, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@STEdit", STEdit, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@PropertyType", PropertyType, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@ENUM_TEXT", ENUM_TEXT, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@popback", popback, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@pushback", pushback, DbType.Boolean));
return(SqlParmColl.ToArray());
}
catch (SQLiteException Exc)
{
throw Exc;
}
}
private SQLiteParameter[] GetSqlParameters()
{
List <SQLiteParameter> SqlParmColl = new List <SQLiteParameter>();
try
{
SqlParmColl.Add(CommonDB.AddSqlParm("@CHNID", CHNID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@CHN", CHN, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@VarNameID", VarNameID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@BoardID", BoardID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@Type", Type, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@INV", INV, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@PER", PER, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@OPD", OPD, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@AD0", AD0, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@AD1", AD1, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@EN0", EN0, DbType.Single));
SqlParmColl.Add(CommonDB.AddSqlParm("@EN1", EN1, DbType.Single));
SqlParmColl.Add(CommonDB.AddSqlParm("@FLT", FLT, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@DEB", DEB, DbType.Single));
return(SqlParmColl.ToArray());
}
catch (SQLiteException Exc)
{
throw Exc;
}
}
private SQLiteParameter[] GetSqlParameters()
{
List <SQLiteParameter> SqlParmColl = new List <SQLiteParameter>();
try
{
SqlParmColl.Add(CommonDB.AddSqlParm("@ID", ID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@DisplayID", DisplayID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@oIndex", oIndex, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@DlgType", DlgType, DbType.Byte));
SqlParmColl.Add(CommonDB.AddSqlParm("@DlgIndex", DlgIndex, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Left", Left, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Right", Right, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Top", Top, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Bottom", Bottom, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@ScanTime", ScanTime, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@ViewLable", ViewLable, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@Index", Index, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@BackColor", BackColor.ToArgb(), DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@TrendColor", TrendColor.ToArgb(), DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@TrendWidth", TrendWidth, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@Fill", Fill, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@Font", Font, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@FontColor", FontColor.ToArgb(), DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@LastRev", LastRev, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@CompiledExp", CompiledExp, DbType.Binary));
SqlParmColl.Add(CommonDB.AddSqlParm("@validexpression", validexpression, DbType.Boolean));
return(SqlParmColl.ToArray());
}
catch (SQLiteException Exc)
{
throw Exc;
}
}
private SQLiteParameter[] GetSqlParameters()
{
List <SQLiteParameter> SqlParmColl = new List <SQLiteParameter>();
try
{
SqlParmColl.Add(CommonDB.AddSqlParm("@SymbolStatusID", SymbolStatusID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@StatusNo", StatusNo, DbType.Byte));
SqlParmColl.Add(CommonDB.AddSqlParm("@SymbolID", SymbolID, DbType.Int64));
return(SqlParmColl.ToArray());
}
catch (SQLiteException Exc)
{
throw Exc;
}
}
private SQLiteParameter[] GetSqlParameters()
{
List <SQLiteParameter> SqlParmColl = new List <SQLiteParameter>();
try
{
SqlParmColl.Add(CommonDB.AddSqlParm("@ID", ID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@SolutionID", SolutionID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@GroupName", GroupName, DbType.String));
return(SqlParmColl.ToArray());
}
catch (SQLiteException Exc)
{
throw Exc;
}
}
private SQLiteParameter[] GetSqlParameters()
{
List <SQLiteParameter> SqlParmColl = new List <SQLiteParameter>();
try
{
SqlParmColl.Add(CommonDB.AddSqlParm("@ID", ID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@DisplayID", DisplayID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@oIndex", oIndex, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@DlgType", DlgType, DbType.Byte));
SqlParmColl.Add(CommonDB.AddSqlParm("@DlgIndex", DlgIndex, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Left", Left, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Right", Right, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Top", Top, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Bottom", Bottom, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Format", Format, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Alignment", Alignment, DbType.Byte));
SqlParmColl.Add(CommonDB.AddSqlParm("@TextValue", TextValue, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@TextValueID", TextValueID, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@TextColor", TextColor.ToArgb(), DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@TextBlinking", TextBlinking, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@Font", Font, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@UnitShow", UnitShow, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@UnitFont", UnitFont, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@UnitColor", UnitColor.ToArgb(), DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@UnitText", UnitText, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@isfix", isfix, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@Orientation", Orientation, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@LastRev", LastRev, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@LockPosition", LockPosition, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@LockEdit", LockEdit, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@Layer", Layer, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@FillColor", FillColor, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@LineStyle", LineStyle, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@Visible", Visible, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@Expression", Expression, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@Action", Action, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@Argument", Argument, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@CompiledExp", CompiledExp, DbType.Binary));
SqlParmColl.Add(CommonDB.AddSqlParm("@validexpression", validexpression, DbType.Boolean));
return(SqlParmColl.ToArray());
}
catch (SQLiteException Exc)
{
throw Exc;
}
}
