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