public static DataSet getfieldAreaTopValue(int id)
{
string sql = "GetFieldAreaTopValue";
ParameterCollection par = new ParameterCollection();
par.Add("@Id", id.ToString());
return SQLDatabaseManager.ExecuteDataSet1(sql, par);
}
private void BuildCommand(IConfigurationElement parametersSection, ParameterCollection parameters)
{
parameters.Clear();
foreach (IConfigurationElement parameterElement in parametersSection.Elements.Values)
{
Parameter commandParameter = new Parameter();
foreach (IConfigurationElement propertyElement in parameterElement.Elements.Values)
{
ReflectionServices.SetValue(commandParameter, propertyElement.GetAttributeReference("name").Value.ToString(), propertyElement.GetAttributeReference("value").Value);
}
parameters.Add(commandParameter);
}
}
/// <summary>
/// myself：不用异常处理
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void SearchButton1_Click(object sender, EventArgs e)
{
//try
//{
if (SearchByXH.Text != "")
{
querry += "and [XH]= @XH";
}
if (SearchByNickName.Text != "")
{
querry += "and [User_NickName]=@UNN";
}
if (SearchByName.Text != "")
{
querry += "and [XM]=@XM";
}
if (SearchByQQ.Text != "")
{
querry += "and [User_QQ]=@UQ";
}
if (DropXY.SelectedValue != null)
{
querry += "and [YXSMC]=@XY";
}
if (DropZY.SelectedValue != null)
{
querry += "and [ZYMC]=@ZY";
}
//}
//catch
//{
// Context.Response.Write("<script>alert('出错了!')</script>");
//}
ParameterCollection co = new ParameterCollection();
co.Add("@XH", SearchByXH.Text);
co.Add("@UNN", SearchByNickName.Text);
co.Add("@XM", SearchByName.Text);
co.Add("@UQ", SearchByQQ.Text);
co.Add("@XY", DropXY.SelectedValue);
co.Add("@ZY", DropZY.SelectedValue);
Source1.SelectCommand = querry;
Repeater1.DataSource = Source1;
Repeater1.DataBind();
}
private static void ApplyParameterCollection(Row row, ParameterCollection parameters, string prefix)
{
if (string.IsNullOrEmpty(prefix))
prefix = "{0}";
foreach (RowCell cell in row.Cells)
{
string value = null;
if (cell.Value != null)
value = cell.Value.ToString();
if (parameters[cell.CellId] == null)
parameters.Add(cell.CellId, row.Columns[cell.CellId].DataType, value);
else
parameters[cell.CellId].DefaultValue = value;
if (parameters[String.Format("@" + prefix, cell.CellId)] == null)
parameters.Add(String.Format("@" + prefix, cell.CellId), row.Columns[cell.CellId].DataType, value);
else
parameters[String.Format("@" + prefix, cell.CellId)].DefaultValue = value;
}
}
private void OnOkButtonClick(object sender, EventArgs e)
{
ICollection dataSource = (ICollection) this._parametersDataGridView.DataSource;
ParameterCollection parameters = new ParameterCollection();
foreach (ParameterItem item in dataSource)
{
if (item.DbType == DbType.Object)
{
parameters.Add(new Parameter(item.Name, item.Type, item.DefaultValue));
}
else
{
parameters.Add(new Parameter(item.Name, item.DbType, item.DefaultValue));
}
}
if (this._sqlDataSourceDesigner.RefreshSchema(new DesignerDataConnection(string.Empty, this._providerName, this._connectionString), this._selectCommand, this._selectCommandType, parameters, false))
{
base.DialogResult = DialogResult.OK;
base.Close();
}
}
private void SetParameters(ParameterCollection original, ParameterCollection newParams)
{
original.Clear();
foreach (Parameter parameter in newParams)
{
original.Add(parameter);
}
}
internal void CloneParameters(ParameterCollection originalParameters, ParameterCollection newParameters)
{
foreach (ICloneable parameter in originalParameters)
{
Parameter clone = (Parameter)parameter.Clone();
RegisterClone(parameter, clone);
newParameters.Add(clone);
}
}
private static void MoveParameters(ParameterCollection source, ParameterCollection target)
{
foreach (Parameter p in source)
{
target.Add(p);
}
source.Clear();
}
private void OnOkButtonClick(object sender, EventArgs e)
{
ParameterCollection parameters = new ParameterCollection();
foreach (ParameterItem item in this._parameterItems)
{
if (item.Parameter.DbType == DbType.Object)
{
parameters.Add(new Parameter(item.Parameter.Name, item.Parameter.Type, item.Parameter.DefaultValue));
}
else
{
parameters.Add(new Parameter(item.Parameter.Name, item.Parameter.DbType, item.Parameter.DefaultValue));
}
}
try
{
parameters.GetValues(null, null);
}
catch (Exception exception)
{
UIServiceHelper.ShowError(base.ServiceProvider, exception, System.Design.SR.GetString("SqlDataSourceParameterValueEditorForm_InvalidParameter"));
return;
}
base.DialogResult = DialogResult.OK;
base.Close();
}
internal static void MergeParameters(ParameterCollection parameters, MethodInfo methodInfo, System.Type dataObjectType)
{
Parameter[] parameterArray = new Parameter[parameters.Count];
parameters.CopyTo(parameterArray, 0);
parameters.Clear();
if ((methodInfo != null) && (dataObjectType == null))
{
foreach (ParameterInfo info in methodInfo.GetParameters())
{
Parameter parameter = CreateMergedParameter(info, parameterArray);
if (parameters[parameter.Name] == null)
{
parameters.Add(parameter);
}
}
}
}
private void @__BuildControl__control2(System.Web.UI.WebControls.ParameterCollection @__ctrl)
{
global::System.Web.UI.WebControls.ControlParameter @__ctrl1;
@__ctrl1 = this.@__BuildControl__control3();
@__ctrl.Add(@__ctrl1);
}
public override void RefreshSchema(bool preferSilent)
{
try
{
this.SuppressDataSourceEvents();
bool flag = false;
IServiceProvider site = this.SqlDataSource.Site;
if (!this.CanRefreshSchema)
{
if (!preferSilent)
{
UIServiceHelper.ShowError(site, System.Design.SR.GetString("SqlDataSourceDesigner_RefreshSchemaRequiresSettings"));
}
}
else
{
IDataSourceViewSchema schema = this.GetView("DefaultView").Schema;
bool flag2 = false;
if (schema == null)
{
this._forceSchemaRetrieval = true;
schema = this.GetView("DefaultView").Schema;
this._forceSchemaRetrieval = false;
flag2 = true;
}
DesignerDataConnection connection = new DesignerDataConnection(string.Empty, this.ProviderName, this.ConnectionString);
if (preferSilent)
{
flag = this.RefreshSchema(connection, this.SelectCommand, this.SqlDataSource.SelectCommandType, this.SqlDataSource.SelectParameters, true);
}
else
{
Parameter[] parameterArray = this.InferParameterNames(connection, this.SelectCommand, this.SqlDataSource.SelectCommandType);
if (parameterArray == null)
{
return;
}
ParameterCollection parameters = new ParameterCollection();
ParameterCollection parameters2 = new ParameterCollection();
foreach (ICloneable cloneable in this.SqlDataSource.SelectParameters)
{
parameters2.Add((Parameter) cloneable.Clone());
}
foreach (Parameter parameter in parameterArray)
{
if ((parameter.Direction == ParameterDirection.Input) || (parameter.Direction == ParameterDirection.InputOutput))
{
Parameter parameter2 = parameters2[parameter.Name];
if (parameter2 != null)
{
parameter.DefaultValue = parameter2.DefaultValue;
if ((parameter.DbType == DbType.Object) && (parameter.Type == TypeCode.Empty))
{
parameter.DbType = parameter2.DbType;
parameter.Type = parameter2.Type;
}
parameters2.Remove(parameter2);
}
parameters.Add(parameter);
}
}
if (parameters.Count > 0)
{
SqlDataSourceRefreshSchemaForm form = new SqlDataSourceRefreshSchemaForm(site, this, parameters);
flag = UIServiceHelper.ShowDialog(site, form) == DialogResult.OK;
}
else
{
flag = this.RefreshSchema(connection, this.SelectCommand, this.SqlDataSource.SelectCommandType, parameters, false);
}
}
if (flag)
{
IDataSourceViewSchema schema2 = this.GetView("DefaultView").Schema;
if (flag2 && DataSourceDesigner.ViewSchemasEquivalent(schema, schema2))
{
this.OnDataSourceChanged(EventArgs.Empty);
}
else if (!DataSourceDesigner.ViewSchemasEquivalent(schema, schema2))
{
this.OnSchemaRefreshed(EventArgs.Empty);
}
}
}
}
finally
{
this.ResumeDataSourceEvents();
}
}
private void OnTestQueryButtonClick(object sender, EventArgs e)
{
ParameterCollection parameters = new ParameterCollection();
foreach (Parameter parameter in this._selectQuery.Parameters)
{
if (parameter.DbType == DbType.Object)
{
parameters.Add(new Parameter(parameter.Name, parameter.Type, parameter.DefaultValue));
}
else
{
parameters.Add(new Parameter(parameter.Name, parameter.DbType, parameter.DefaultValue));
}
}
if (parameters.Count > 0)
{
SqlDataSourceParameterValueEditorForm form = new SqlDataSourceParameterValueEditorForm(base.ServiceProvider, parameters);
if (UIServiceHelper.ShowDialog(base.ServiceProvider, form) == DialogResult.Cancel)
{
return;
}
}
this._resultsGridView.DataSource = null;
DbCommand command = null;
Cursor current = Cursor.Current;
try
{
Cursor.Current = Cursors.WaitCursor;
DbProviderFactory dbProviderFactory = SqlDataSourceDesigner.GetDbProviderFactory(this._dataConnection.ProviderName);
DbConnection designTimeConnection = null;
try
{
designTimeConnection = SqlDataSourceDesigner.GetDesignTimeConnection(base.ServiceProvider, this._dataConnection);
}
catch (Exception exception)
{
if (designTimeConnection == null)
{
UIServiceHelper.ShowError(base.ServiceProvider, exception, System.Design.SR.GetString("SqlDataSourceSummaryPanel_CouldNotCreateConnection"));
return;
}
}
if (designTimeConnection == null)
{
UIServiceHelper.ShowError(base.ServiceProvider, System.Design.SR.GetString("SqlDataSourceSummaryPanel_CouldNotCreateConnection"));
}
else
{
command = this._sqlDataSourceDesigner.BuildSelectCommand(dbProviderFactory, designTimeConnection, this._selectQuery.Command, parameters, this._selectQuery.CommandType);
DbDataAdapter adapter = SqlDataSourceDesigner.CreateDataAdapter(dbProviderFactory, command);
adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;
DataSet dataSet = new DataSet();
adapter.Fill(dataSet);
if (dataSet.Tables.Count == 0)
{
UIServiceHelper.ShowError(base.ServiceProvider, System.Design.SR.GetString("SqlDataSourceSummaryPanel_CannotExecuteQueryNoTables"));
}
else
{
this._resultsGridView.DataSource = dataSet.Tables[0];
foreach (DataGridViewColumn column in this._resultsGridView.Columns)
{
column.SortMode = DataGridViewColumnSortMode.NotSortable;
}
this._resultsGridView.AutoResizeColumnHeadersHeight();
this._resultsGridView.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
}
}
}
catch (Exception exception2)
{
UIServiceHelper.ShowError(base.ServiceProvider, exception2, System.Design.SR.GetString("SqlDataSourceSummaryPanel_CannotExecuteQuery"));
}
finally
{
if ((command != null) && (command.Connection.State == ConnectionState.Open))
{
command.Connection.Close();
}
Cursor.Current = current;
}
}
protected internal override void OnComplete()
{
PropertyDescriptor descriptor;
SqlDataSource component = (SqlDataSource) this._sqlDataSourceDesigner.Component;
if (component.DeleteCommand != this._deleteQuery.Command)
{
descriptor = TypeDescriptor.GetProperties(component)["DeleteCommand"];
descriptor.SetValue(component, this._deleteQuery.Command);
}
if (component.DeleteCommandType != this._deleteQuery.CommandType)
{
descriptor = TypeDescriptor.GetProperties(component)["DeleteCommandType"];
descriptor.SetValue(component, this._deleteQuery.CommandType);
}
if (component.InsertCommand != this._insertQuery.Command)
{
descriptor = TypeDescriptor.GetProperties(component)["InsertCommand"];
descriptor.SetValue(component, this._insertQuery.Command);
}
if (component.InsertCommandType != this._insertQuery.CommandType)
{
descriptor = TypeDescriptor.GetProperties(component)["InsertCommandType"];
descriptor.SetValue(component, this._insertQuery.CommandType);
}
if (component.SelectCommand != this._selectQuery.Command)
{
descriptor = TypeDescriptor.GetProperties(component)["SelectCommand"];
descriptor.SetValue(component, this._selectQuery.Command);
}
if (component.SelectCommandType != this._selectQuery.CommandType)
{
descriptor = TypeDescriptor.GetProperties(component)["SelectCommandType"];
descriptor.SetValue(component, this._selectQuery.CommandType);
}
if (component.UpdateCommand != this._updateQuery.Command)
{
descriptor = TypeDescriptor.GetProperties(component)["UpdateCommand"];
descriptor.SetValue(component, this._updateQuery.Command);
}
if (component.UpdateCommandType != this._updateQuery.CommandType)
{
TypeDescriptor.GetProperties(component)["UpdateCommandType"].SetValue(component, this._updateQuery.CommandType);
}
this._sqlDataSourceDesigner.CopyList(this._selectQuery.Parameters, component.SelectParameters);
this._sqlDataSourceDesigner.CopyList(this._insertQuery.Parameters, component.InsertParameters);
this._sqlDataSourceDesigner.CopyList(this._updateQuery.Parameters, component.UpdateParameters);
this._sqlDataSourceDesigner.CopyList(this._deleteQuery.Parameters, component.DeleteParameters);
ParameterCollection parameters = new ParameterCollection();
foreach (Parameter parameter in this._selectQuery.Parameters)
{
parameters.Add(parameter);
}
this._sqlDataSourceDesigner.RefreshSchema(this._dataConnection, this._selectQuery.Command, this._selectQuery.CommandType, parameters, true);
}
