public override void Run()
{
ReportExplorerPad pad = this.Owner as ReportExplorerPad;
if (pad != null) {
ParameterCollection par = pad.ReportModel.ReportSettings.ParameterCollection;
using (ParameterDialog paramDialog = new ParameterDialog(par)) {
paramDialog.ShowDialog();
if (paramDialog.DialogResult == System.Windows.Forms.DialogResult.OK) {
/*
foreach (BasicParameter bp in e.Collection as ParameterCollection){
r.ReportModel.ReportSettings.ParameterCollection.Add (bp);
}
*/
foreach (BasicParameter bp in new System.Collections.ArrayList(paramDialog.Collection))
{
if (bp.ParameterName != null)
{
pad.ReportModel.ReportSettings.ParameterCollection.Add (bp);
}
}
pad.RefreshParameters();
}
}
}
}
public override void Run()
{
if (model.ReportSettings.ParameterCollection != null && model.ReportSettings.ParameterCollection.Count > 0) {
using (ParameterDialog dlg = new ParameterDialog(model.ReportSettings.ParameterCollection)){
dlg.ShowDialog();
}
}
}
public override void Run()
{
ReportExplorerPad r = this.Owner as ReportExplorerPad;
if (r != null) {
ParameterCollection par = r.ReportModel.ReportSettings.ParameterCollection;
using (ParameterDialog e = new ParameterDialog(par)) {
e.ShowDialog();
if (e.DialogResult == System.Windows.Forms.DialogResult.OK) {
foreach (BasicParameter bp in e.Collection as ParameterCollection){
r.ReportModel.ReportSettings.ParameterCollection.Add (bp);
}
r.RefreshParameters();
}
}
}
}
private DataSet ExecuteStoredProc (SharpQueryProcedure procedure)
{
SharpQuerySchemaClassCollection tmp = procedure.GetSchemaParameters();
this.sqlParamsCollection = new ParameterCollection();
SqlParameterConverter converter = new SqlParameterConverter();
if (converter.CanConvertFrom(typeof(SharpQuerySchemaClassCollection))) {
if (converter.CanConvertTo(null,typeof(ParameterCollection))){
sqlParamsCollection = (ParameterCollection)converter.ConvertTo(null,
CultureInfo.InstalledUICulture,
tmp,
typeof(ParameterCollection));
}
}
if (sqlParamsCollection.Count > 0){
using (ParameterDialog inputform = new ParameterDialog(sqlParamsCollection)) {
if ( inputform.ShowDialog() != DialogResult.OK ){
return null;
}
else
{
IDbCommand command = this.BuildCommand();
DbDataAdapter adapter = this.BuildAdapter();
DataSet dataSet = ResultPanel.CreateDataSet();
try {
SqlDataAccessStrategy.BuildQueryParameters(command,sqlParamsCollection);
adapter.SelectCommand = (DbCommand)command;
adapter.Fill (dataSet);
return dataSet;
} catch (Exception e) {
MessageService.ShowError(e.Message);
} finally {
if (adapter.SelectCommand.Connection.State == ConnectionState.Open) {
adapter.SelectCommand.Connection.Close();
}
}
}
}
}
return null;
}