📄 银行储蓄系统dataset3.designer.cs
字号:
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("地址", "地址");
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_地址)) 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.NChar, 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.NChar, 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.Char, 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.Char, 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.Char, 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.Char, 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.Int, 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.InsertCommand = new System.Data.SqlClient.SqlCommand();
this._adapter.InsertCommand.Connection = this.Connection;
this._adapter.InsertCommand.CommandText = @"INSERT INTO [dbo].[储户信息] ([储户编号], [身份证号], [储户姓名], [联系电话], [备注], [卡号], [密码], [地址], [业务员编号], [开户日期]) VALUES (@储户编号, @身份证号, @储户姓名, @联系电话, @备注, @卡号, @密码, @地址, @业务员编号, @开户日期);
SELECT 储户编号, 身份证号, 储户姓名, 联系电话, 备注, 卡号, 密码, 地址, 业务员编号, 开户日期 FROM 储户信息 WHERE (储户编号 = @储户编号)";
this._adapter.InsertCommand.CommandType = System.Data.CommandType.Text;
this._adapter.InsertCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@储户编号", System.Data.SqlDbType.NChar, 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.NChar, 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.Char, 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.Char, 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.Char, 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.Char, 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.Int, 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.DateTime, 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_密码)) 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.NChar, 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.NChar, 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.Char, 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.Char, 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.Char, 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.Char, 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.Int, 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.DateTime, 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.NChar, 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.NChar, 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.Char, 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.Char, 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.Char, 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.Char, 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.Int, 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.DateTime, 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::Store.Properties.Settings.Default.银行储蓄系统ConnectionString;
}
[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;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Fill, true)]
public virtual int Fill(银行储蓄系统DataSet3.储户信息DataTable dataTable) {
this.Adapter.SelectCommand = this.CommandCollection[0];
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, true)]
public virtual 银行储蓄系统DataSet3.储户信息DataTable GetData() {
this.Adapter.SelectCommand = this.CommandCollection[0];
银行储蓄系统DataSet3.储户信息DataTable dataTable = new 银行储蓄系统DataSet3.储户信息DataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
public virtual int Update(银行储蓄系统DataSet3.储户信息DataTable dataTable) {
return this.Adapter.Update(dataTable);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
public virtual int Update(银行储⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -