📄 银行储蓄系统dataset2.designer.cs
字号:
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("存款期限", "存款期限");
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.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.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.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.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.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.Money, 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.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.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.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.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.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.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.Float, 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.Money, 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.DateTime, 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_存款金额)) 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.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.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.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.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.Float, 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.Money, 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.DateTime, 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.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.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.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.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.Float, 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.Money, 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.DateTime, 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::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(银行储蓄系统DataSet2.存款信息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 银行储蓄系统DataSet2.存款信息DataTable GetData() {
this.Adapter.SelectCommand = this.CommandCollection[0];
银行储蓄系统DataSet2.存款信息DataTable dataTable = new 银行储蓄系统DataSet2.存款信息DataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
public virtual int Update(银行储蓄系统DataSet2.存款信息DataTable dataTable) {
return this.Adapter.Update(dataTable);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -