📄 testdataset.designer.cs
字号:
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.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.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.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 ServiceControlLibrary1.testDataSetTableAdapters {
[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("维护费用", "维护费用");
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_维护费用)) 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.DateTime, 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.Float, 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();
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -