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("@FBDPinConnectionID", FBDPinConnectionID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@UDFunctionID", UDFunctionID, 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("@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("@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("@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("@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("@DisplayID", DisplayID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@oIndex", oIndex, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Points", Points, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@NoPoints", NoPoints, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@LineType", LineType, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@LastRev", LastRev, DbType.Boolean));
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("@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("@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("@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("@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("@Width", Width, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Height", Height, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@RoundnessX", RoundnessX, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@RoundnessY", RoundnessY, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Type", Type, 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("@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("@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;
}
}
private SQLiteParameter[] GetSqlParameters()
{
List <SQLiteParameter> SqlParmColl = new List <SQLiteParameter>();
try
{
SqlParmColl.Add(CommonDB.AddSqlParm("@ID", ID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@EquipmentName", EquipmentName, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@PlantStructureID", PlantStructureID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@Description", Description, 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("@VarNameID", VarNameID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@Text0", Text0, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@Text1", Text1, 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("@FunctionID", FunctionID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@FunctionType", FunctionType, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Status", Status, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@oIndex", oIndex, DbType.Int32));
return(SqlParmColl.ToArray());
}
catch (SQLiteException Exc)
{
throw Exc;
}
}
private SQLiteParameter[] GetSqlParameters()
{
List <SQLiteParameter> SqlParmColl = new List <SQLiteParameter>();
try
{
SqlParmColl.Add(CommonDB.AddSqlParm("@UserAccessID", UserAccessID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@UserGroupID", UserGroupID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@ControllerID", ControllerID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@OWSAccessLevel", OWSAccessLevel, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@CommandAccessLevel", CommandAccessLevel, 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("@SourceVarID", SourceVarID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@SourceNodeNo", SourceNodeNo, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@DestinationVarID", DestinationVarID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@DestinationNodeID", DestinationNodeID, DbType.Int16));
return(SqlParmColl.ToArray());
}
catch (SQLiteException Exc)
{
throw Exc;
}
}
private SQLiteParameter[] GetSqlParameters()
{
List <SQLiteParameter> SqlParmColl = new List <SQLiteParameter>();
try
{
SqlParmColl.Add(CommonDB.AddSqlParm("@GroupName", GroupName, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@Description", Description, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@ENGAccess", ENGAccess, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@EWSAccessLevel", EWSAccessLevel, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@GroupNameID", GroupNameID, DbType.Int64));
return(SqlParmColl.ToArray());
}
catch (SQLiteException Exc)
{
throw Exc;
}
}
private SQLiteParameter[] GetSqlParameters()
{
List <SQLiteParameter> SqlParmColl = new List <SQLiteParameter>();
try
{
SqlParmColl.Add(CommonDB.AddSqlParm("@PointsPolylineID", PointsPolylineID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@PolylineID", PolylineID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@oIndex", oIndex, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@PtX", PtX, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@PtY", PtY, 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("@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("@UserGroupID", UserGroupID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@StartupDisplay", StartupDisplay, 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("@UnitName", UnitName, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@GroupID", GroupID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@ConversionFactor", ConversionFactor, DbType.Double));
SqlParmColl.Add(CommonDB.AddSqlParm("@ConversionIntercept", ConversionIntercept, DbType.Double));
SqlParmColl.Add(CommonDB.AddSqlParm("@Base", Base, DbType.Boolean));
return(SqlParmColl.ToArray());
}
catch (SQLiteException Exc)
{
throw Exc;
}
}
private SQLiteParameter[] GetSqlParameters()
{
List <SQLiteParameter> SqlParmColl = new List <SQLiteParameter>();
try
{
SqlParmColl.Add(CommonDB.AddSqlParm("@GroupName", GroupName, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@ModbusServerDataGroupID", ModbusServerDataGroupID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@ModbusServerDataID", ModbusServerDataID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@Start", Start, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@Len", Len, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@CycleTime", CycleTime, 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("@SolutionID", SolutionID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@Name", Name, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@Type", Type, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Description", Description, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@Extension", Extension, 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("@SolitionID", SolitionID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@Txt", Txt, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@Bit", Bit, DbType.Int32));
SqlParmColl.Add(CommonDB.AddSqlParm("@Decsription", Decsription, DbType.String));
SqlParmColl.Add(CommonDB.AddSqlParm("@Readonly", Readonly, 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("@ModbusClientID", ModbusClientID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@VarNameID", VarNameID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@Number", Number, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@Type", Type, DbType.Byte));
SqlParmColl.Add(CommonDB.AddSqlParm("@Multiplier", Multiplier, DbType.Byte));
SqlParmColl.Add(CommonDB.AddSqlParm("@ReadOnly", ReadOnly, DbType.Boolean));
return(SqlParmColl.ToArray());
}
catch (SQLiteException Exc)
{
throw Exc;
}
}
private SQLiteParameter[] GetSqlParameters()
{
List<SQLiteParameter> SqlParmColl = new List<SQLiteParameter>();
try
{
SqlParmColl.Add(CommonDB.AddSqlParm("@ModbusServerDataID", ModbusServerDataID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@ModbusServerID", ModbusServerID, DbType.Int64));
SqlParmColl.Add(CommonDB.AddSqlParm("@StaNo", StaNo, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@ReadFC", ReadFC, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@WriteFC", WriteFC, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@SlaveNo", SlaveNo, DbType.Int16));
SqlParmColl.Add(CommonDB.AddSqlParm("@Checkback", Checkback, DbType.Boolean));
SqlParmColl.Add(CommonDB.AddSqlParm("@ChangeOnly", ChangeOnly, DbType.Boolean));
return SqlParmColl.ToArray();
}
catch (SQLiteException Exc)
{
throw Exc;
}
}
