📄 masterdataset.designer.cs
字号:
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool Is服务项目Null() {
return this.IsNull(this.table协力厂商信息.服务项目Column);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void Set服务项目Null() {
this[this.table协力厂商信息.服务项目Column] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool Is服务描述Null() {
return this.IsNull(this.table协力厂商信息.服务描述Column);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void Set服务描述Null() {
this[this.table协力厂商信息.服务描述Column] = System.Convert.DBNull;
}
}
[System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
public class 协力厂商信息RowChangeEvent : System.EventArgs {
private 协力厂商信息Row eventRow;
private System.Data.DataRowAction eventAction;
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public 协力厂商信息RowChangeEvent(协力厂商信息Row row, System.Data.DataRowAction action) {
this.eventRow = row;
this.eventAction = action;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public 协力厂商信息Row Row {
get {
return this.eventRow;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataRowAction Action {
get {
return this.eventAction;
}
}
}
}
}
namespace ControlLibraryXLCS.masterDataSetTableAdapters {
[System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
[System.ComponentModel.DesignerCategoryAttribute("code")]
[System.ComponentModel.ToolboxItem(true)]
[System.ComponentModel.DataObjectAttribute(true)]
[System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterDesigner, Microsoft.VSDesigner" +
", Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
[System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
public partial class 协力厂商信息TableAdapter : System.ComponentModel.Component {
private System.Data.SqlClient.SqlDataAdapter _adapter;
private System.Data.SqlClient.SqlConnection _connection;
private System.Data.SqlClient.SqlCommand[] _commandCollection;
private bool _clearBeforeFill;
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public 协力厂商信息TableAdapter() {
this.ClearBeforeFill = true;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private System.Data.SqlClient.SqlDataAdapter Adapter {
get {
if ((this._adapter == null)) {
this.InitAdapter();
}
return this._adapter;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal System.Data.SqlClient.SqlConnection Connection {
get {
if ((this._connection == null)) {
this.InitConnection();
}
return this._connection;
}
set {
this._connection = value;
if ((this.Adapter.InsertCommand != null)) {
this.Adapter.InsertCommand.Connection = value;
}
if ((this.Adapter.DeleteCommand != null)) {
this.Adapter.DeleteCommand.Connection = value;
}
if ((this.Adapter.UpdateCommand != null)) {
this.Adapter.UpdateCommand.Connection = value;
}
for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
if ((this.CommandCollection[i] != null)) {
((System.Data.SqlClient.SqlCommand)(this.CommandCollection[i])).Connection = value;
}
}
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected System.Data.SqlClient.SqlCommand[] CommandCollection {
get {
if ((this._commandCollection == null)) {
this.InitCommandCollection();
}
return this._commandCollection;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool ClearBeforeFill {
get {
return this._clearBeforeFill;
}
set {
this._clearBeforeFill = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitAdapter() {
this._adapter = new System.Data.SqlClient.SqlDataAdapter();
System.Data.Common.DataTableMapping tableMapping = new System.Data.Common.DataTableMapping();
tableMapping.SourceTable = "Table";
tableMapping.DataSetTable = "协力厂商信息";
tableMapping.ColumnMappings.Add("厂商编号", "厂商编号");
tableMapping.ColumnMappings.Add("厂商名称", "厂商名称");
tableMapping.ColumnMappings.Add("联系地址", "联系地址");
tableMapping.ColumnMappings.Add("联系电话", "联系电话");
tableMapping.ColumnMappings.Add("网址", "网址");
tableMapping.ColumnMappings.Add("服务项目", "服务项目");
tableMapping.ColumnMappings.Add("服务描述", "服务描述");
this._adapter.TableMappings.Add(tableMapping);
this._adapter.DeleteCommand = new System.Data.SqlClient.SqlCommand();
this._adapter.DeleteCommand.Connection = this.Connection;
this._adapter.DeleteCommand.CommandText = @"DELETE FROM [dbo].[协力厂商信息] WHERE (([厂商编号] = @Original_厂商编号) AND ((@IsNull_厂商名称 = 1 AND [厂商名称] IS NULL) OR ([厂商名称] = @Original_厂商名称)) AND ((@IsNull_联系地址 = 1 AND [联系地址] IS NULL) OR ([联系地址] = @Original_联系地址)) AND ((@IsNull_联系电话 = 1 AND [联系电话] IS NULL) OR ([联系电话] = @Original_联系电话)) AND ((@IsNull_网址 = 1 AND [网址] IS NULL) OR ([网址] = @Original_网址)) AND ((@IsNull_服务项目 = 1 AND [服务项目] IS NULL) OR ([服务项目] = @Original_服务项目)) AND ((@IsNull_服务描述 = 1 AND [服务描述] IS NULL) OR ([服务描述] = @Original_服务描述)))";
this._adapter.DeleteCommand.CommandType = System.Data.CommandType.Text;
this._adapter.DeleteCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_厂商编号", System.Data.SqlDbType.BigInt, 0, System.Data.ParameterDirection.Input, 0, 0, "厂商编号", System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsNull_厂商名称", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "厂商名称", System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_厂商名称", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "厂商名称", System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsNull_联系地址", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "联系地址", System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_联系地址", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "联系地址", System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsNull_联系电话", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "联系电话", System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_联系电话", System.Data.SqlDbType.BigInt, 0, System.Data.ParameterDirection.Input, 0, 0, "联系电话", System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsNull_网址", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "网址", System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_网址", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "网址", System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsNull_服务项目", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "服务项目", System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_服务项目", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "服务项目", System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsNull_服务描述", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "服务描述", System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_服务描述", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "服务描述", System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.InsertCommand = new System.Data.SqlClient.SqlCommand();
this._adapter.InsertCommand.Connection = this.Connection;
this._adapter.InsertCommand.CommandText = "INSERT INTO [dbo].[协力厂商信息] ([厂商编号], [厂商名称], [联系地址], [联系电话], [网址], [服务项目], [服务描述])" +
" VALUES (@厂商编号, @厂商名称, @联系地址, @联系电话, @网址, @服务项目, @服务描述);\r\nSELECT 厂商编号, 厂商名称, 联系地" +
"址, 联系电话, 网址, 服务项目, 服务描述 FROM 协力厂商信息 WHERE (厂商编号 = @厂商编号)";
this._adapter.InsertCommand.CommandType = System.Data.CommandType.Text;
this._adapter.InsertCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@厂商编号", System.Data.SqlDbType.BigInt, 0, System.Data.ParameterDirection.Input, 0, 0, "厂商编号", System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.InsertCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@厂商名称", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "厂商名称", System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.InsertCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@联系地址", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "联系地址", System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.InsertCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@联系电话", System.Data.SqlDbType.BigInt, 0, System.Data.ParameterDirection.Input, 0, 0, "联系电话", System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.InsertCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@网址", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "网址", System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.InsertCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@服务项目", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "服务项目", System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.InsertCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@服务描述", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "服务描述", System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.UpdateCommand = new System.Data.SqlClient.SqlCommand();
this._adapter.UpdateCommand.Connection = this.Connection;
this._adapter.UpdateCommand.CommandText = @"UPDATE [dbo].[协力厂商信息] SET [厂商编号] = @厂商编号, [厂商名称] = @厂商名称, [联系地址] = @联系地址, [联系电话] = @联系电话, [网址] = @网址, [服务项目] = @服务项目, [服务描述] = @服务描述 WHERE (([厂商编号] = @Original_厂商编号) AND ((@IsNull_厂商名称 = 1 AND [厂商名称] IS NULL) OR ([厂商名称] = @Original_厂商名称)) AND ((@IsNull_联系地址 = 1 AND [联系地址] IS NULL) OR ([联系地址] = @Original_联系地址)) AND ((@IsNull_联系电话 = 1 AND [联系电话] IS NULL) OR ([联系电话] = @Original_联系电话)) AND ((@IsNull_网址 = 1 AND [网址] IS NULL) OR ([网址] = @Original_网址)) AND ((@IsNull_服务项目 = 1 AND [服务项目] IS NULL) OR ([服务项目] = @Original_服务项目)) AND ((@IsNull_服务描述 = 1 AND [服务描述] IS NULL) OR ([服务描述] = @Original_服务描述)));
SELECT 厂商编号, 厂商名称, 联系地址, 联系电话, 网址, 服务项目, 服务描述 FROM 协力厂商信息 WHERE (厂商编号 = @厂商编号)";
this._adapter.UpdateCommand.CommandType = System.Data.CommandType.Text;
this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@厂商编号", System.Data.SqlDbType.BigInt, 0, System.Data.ParameterDirection.Input, 0, 0, "厂商编号", System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@厂商名称", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "厂商名称", System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@联系地址", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "联系地址", System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@联系电话", System.Data.SqlDbType.BigInt, 0, System.Data.ParameterDirection.Input, 0, 0, "联系电话", System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@网址", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "网址", System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@服务项目", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "服务项目", System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@服务描述", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "服务描述", System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_厂商编号", System.Data.SqlDbType.BigInt, 0, System.Data.ParameterDirection.Input, 0, 0, "厂商编号", System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsNull_厂商名称", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "厂商名称", System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_厂商名称", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "厂商名称", System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsNull_联系地址", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "联系地址", System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_联系地址", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "联系地址", System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsNull_联系电话", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "联系电话", System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_联系电话", System.Data.SqlDbType.BigInt, 0, System.Data.ParameterDirection.Input, 0, 0, "联系电话", System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsNull_网址", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "网址", System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_网址", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "网址", System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsNull_服务项目", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "服务项目", System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_服务项目", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "服务项目", System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsNull_服务描述", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "服务描述", System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_服务描述", System.Data.SqlDbType.VarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "服务描述", System.Data.DataRowVersion.Original, false, null, "", "", ""));
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitConnection() {
this._connection = new System.Data.SqlClient.SqlConnection();
this._connection.ConnectionString = global::ControlLibraryXLCS.Properties.Settings.Default.masterConnectionString;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitCommandCollection() {
this._commandCollection = new System.Data.SqlClient.SqlCommand[1];
this._commandCollection[0] = new System.Data.SqlClient.SqlCommand();
this._commandCollection[0].Connection = this.Connection;
this._commandCollection[0].CommandText = "SELECT 厂商编号, 厂商名称, 联系地址, 联系电话, 网址, 服务项目, 服务描述 FROM dbo.协力厂商信息";
this._commandCollection[0].CommandType = System.Data.CommandType.Text;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -