private void AddSQLParameter(VistaDBSQLQuery query)
{
VistaDBType vdbType;
foreach(VistaDBParameter vp in Parameters)
{
vdbType = vp.VistaDBType;
if( vp.Value == null || vp.Value == DBNull.Value )
{
query.SetParamNull(vp.ParameterName, vdbType);
}
else
{
switch(vdbType)
{
case VistaDBType.Character:
query.SetParameter(vp.ParameterName, VistaDBType.Character, (string)vp.Value);
break;
case VistaDBType.Date:
query.SetParameter(vp.ParameterName, VistaDBType.Date, (DateTime)vp.Value);
break;
case VistaDBType.DateTime:
query.SetParameter(vp.ParameterName, VistaDBType.DateTime, (DateTime)vp.Value);
break;
case VistaDBType.Int32:
query.SetParameter(vp.ParameterName, VistaDBType.Int32, (int)vp.Value);
break;
case VistaDBType.Int64:
query.SetParameter(vp.ParameterName, VistaDBType.Int64, (long)vp.Value);
break;
case VistaDBType.Boolean:
query.SetParameter(vp.ParameterName, VistaDBType.Boolean, (bool)vp.Value);
break;
case VistaDBType.Double:
query.SetParameter(vp.ParameterName, VistaDBType.Double, (double)vp.Value);
break;
case VistaDBType.Varchar:
query.SetParameter(vp.ParameterName, VistaDBType.Varchar, (string)vp.Value);
break;
case VistaDBType.Memo:
query.SetParameter(vp.ParameterName, VistaDBType.Memo, (string)vp.Value);
break;
case VistaDBType.Blob:
query.SetParameter(vp.ParameterName, VistaDBType.Blob, vp.Value);
break;
case VistaDBType.Picture:
query.SetParameter(vp.ParameterName, VistaDBType.Picture, vp.Value);
break;
case VistaDBType.Currency:
query.SetParameter(vp.ParameterName, VistaDBType.Currency, (decimal)vp.Value);
break;
case VistaDBType.Guid:
query.SetParameter(vp.ParameterName, VistaDBType.Guid, (Guid)vp.Value);
break;
}
}
}
}
private void AddSQLParameter(VistaDBSQLQuery query)
{
VistaDBType vdbType;
foreach (VistaDBParameter vp in Parameters)
{
vdbType = vp.VistaDBType;
if (vp.Value == null || vp.Value == DBNull.Value)
{
query.SetParamNull(vp.ParameterName, vdbType);
}
else
{
switch (vdbType)
{
case VistaDBType.Character:
query.SetParameter(vp.ParameterName, VistaDBType.Character, (string)vp.Value);
break;
case VistaDBType.Date:
query.SetParameter(vp.ParameterName, VistaDBType.Date, (DateTime)vp.Value);
break;
case VistaDBType.DateTime:
query.SetParameter(vp.ParameterName, VistaDBType.DateTime, (DateTime)vp.Value);
break;
case VistaDBType.Int32:
query.SetParameter(vp.ParameterName, VistaDBType.Int32, (int)vp.Value);
break;
case VistaDBType.Int64:
query.SetParameter(vp.ParameterName, VistaDBType.Int64, (long)vp.Value);
break;
case VistaDBType.Boolean:
query.SetParameter(vp.ParameterName, VistaDBType.Boolean, (bool)vp.Value);
break;
case VistaDBType.Double:
query.SetParameter(vp.ParameterName, VistaDBType.Double, (double)vp.Value);
break;
case VistaDBType.Varchar:
query.SetParameter(vp.ParameterName, VistaDBType.Varchar, (string)vp.Value);
break;
case VistaDBType.Memo:
query.SetParameter(vp.ParameterName, VistaDBType.Memo, (string)vp.Value);
break;
case VistaDBType.Blob:
query.SetParameter(vp.ParameterName, VistaDBType.Blob, vp.Value);
break;
case VistaDBType.Picture:
query.SetParameter(vp.ParameterName, VistaDBType.Picture, vp.Value);
break;
case VistaDBType.Currency:
query.SetParameter(vp.ParameterName, VistaDBType.Currency, (decimal)vp.Value);
break;
case VistaDBType.Guid:
query.SetParameter(vp.ParameterName, VistaDBType.Guid, (Guid)vp.Value);
break;
}
}
}
}
