📄 studentsdataset.designer.cs
字号:
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Delete, true)]
public virtual int Delete(string Original_学号, string Original_姓名, string Original_性别, string Original_班级, System.Nullable<short> Original_数学, System.Nullable<short> Original_语文, System.Nullable<short> Original_英语) {
if ((Original_学号 == null)) {
this.Adapter.DeleteCommand.Parameters[0].Value = System.DBNull.Value;
}
else {
this.Adapter.DeleteCommand.Parameters[0].Value = ((string)(Original_学号));
}
if ((Original_姓名 == null)) {
this.Adapter.DeleteCommand.Parameters[1].Value = ((object)(1));
this.Adapter.DeleteCommand.Parameters[2].Value = System.DBNull.Value;
}
else {
this.Adapter.DeleteCommand.Parameters[1].Value = ((object)(0));
this.Adapter.DeleteCommand.Parameters[2].Value = ((string)(Original_姓名));
}
if ((Original_性别 == null)) {
this.Adapter.DeleteCommand.Parameters[3].Value = ((object)(1));
this.Adapter.DeleteCommand.Parameters[4].Value = System.DBNull.Value;
}
else {
this.Adapter.DeleteCommand.Parameters[3].Value = ((object)(0));
this.Adapter.DeleteCommand.Parameters[4].Value = ((string)(Original_性别));
}
if ((Original_班级 == null)) {
this.Adapter.DeleteCommand.Parameters[5].Value = ((object)(1));
this.Adapter.DeleteCommand.Parameters[6].Value = System.DBNull.Value;
}
else {
this.Adapter.DeleteCommand.Parameters[5].Value = ((object)(0));
this.Adapter.DeleteCommand.Parameters[6].Value = ((string)(Original_班级));
}
if ((Original_数学.HasValue == true)) {
this.Adapter.DeleteCommand.Parameters[7].Value = ((object)(0));
this.Adapter.DeleteCommand.Parameters[8].Value = ((short)(Original_数学.Value));
}
else {
this.Adapter.DeleteCommand.Parameters[7].Value = ((object)(1));
this.Adapter.DeleteCommand.Parameters[8].Value = System.DBNull.Value;
}
if ((Original_语文.HasValue == true)) {
this.Adapter.DeleteCommand.Parameters[9].Value = ((object)(0));
this.Adapter.DeleteCommand.Parameters[10].Value = ((short)(Original_语文.Value));
}
else {
this.Adapter.DeleteCommand.Parameters[9].Value = ((object)(1));
this.Adapter.DeleteCommand.Parameters[10].Value = System.DBNull.Value;
}
if ((Original_英语.HasValue == true)) {
this.Adapter.DeleteCommand.Parameters[11].Value = ((object)(0));
this.Adapter.DeleteCommand.Parameters[12].Value = ((short)(Original_英语.Value));
}
else {
this.Adapter.DeleteCommand.Parameters[11].Value = ((object)(1));
this.Adapter.DeleteCommand.Parameters[12].Value = System.DBNull.Value;
}
System.Data.ConnectionState previousConnectionState = this.Adapter.DeleteCommand.Connection.State;
if (((this.Adapter.DeleteCommand.Connection.State & System.Data.ConnectionState.Open)
!= System.Data.ConnectionState.Open)) {
this.Adapter.DeleteCommand.Connection.Open();
}
try {
int returnValue = this.Adapter.DeleteCommand.ExecuteNonQuery();
return returnValue;
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed)) {
this.Adapter.DeleteCommand.Connection.Close();
}
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Insert, true)]
public virtual int Insert(string 学号, string 姓名, string 性别, string 班级, System.Nullable<short> 数学, System.Nullable<short> 语文, System.Nullable<short> 英语) {
if ((学号 == null)) {
this.Adapter.InsertCommand.Parameters[0].Value = System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[0].Value = ((string)(学号));
}
if ((姓名 == null)) {
this.Adapter.InsertCommand.Parameters[1].Value = System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[1].Value = ((string)(姓名));
}
if ((性别 == null)) {
this.Adapter.InsertCommand.Parameters[2].Value = System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[2].Value = ((string)(性别));
}
if ((班级 == null)) {
this.Adapter.InsertCommand.Parameters[3].Value = System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[3].Value = ((string)(班级));
}
if ((数学.HasValue == true)) {
this.Adapter.InsertCommand.Parameters[4].Value = ((short)(数学.Value));
}
else {
this.Adapter.InsertCommand.Parameters[4].Value = System.DBNull.Value;
}
if ((语文.HasValue == true)) {
this.Adapter.InsertCommand.Parameters[5].Value = ((short)(语文.Value));
}
else {
this.Adapter.InsertCommand.Parameters[5].Value = System.DBNull.Value;
}
if ((英语.HasValue == true)) {
this.Adapter.InsertCommand.Parameters[6].Value = ((short)(英语.Value));
}
else {
this.Adapter.InsertCommand.Parameters[6].Value = System.DBNull.Value;
}
System.Data.ConnectionState previousConnectionState = this.Adapter.InsertCommand.Connection.State;
if (((this.Adapter.InsertCommand.Connection.State & System.Data.ConnectionState.Open)
!= System.Data.ConnectionState.Open)) {
this.Adapter.InsertCommand.Connection.Open();
}
try {
int returnValue = this.Adapter.InsertCommand.ExecuteNonQuery();
return returnValue;
}
finally {
if ((previousConnectionState == System.Data.ConnectionState.Closed)) {
this.Adapter.InsertCommand.Connection.Close();
}
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
[System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Update, true)]
public virtual int Update(string 学号, string 姓名, string 性别, string 班级, System.Nullable<short> 数学, System.Nullable<short> 语文, System.Nullable<short> 英语, string Original_学号, string Original_姓名, string Original_性别, string Original_班级, System.Nullable<short> Original_数学, System.Nullable<short> Original_语文, System.Nullable<short> Original_英语) {
if ((学号 == null)) {
this.Adapter.UpdateCommand.Parameters[0].Value = System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[0].Value = ((string)(学号));
}
if ((姓名 == null)) {
this.Adapter.UpdateCommand.Parameters[1].Value = System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[1].Value = ((string)(姓名));
}
if ((性别 == null)) {
this.Adapter.UpdateCommand.Parameters[2].Value = System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[2].Value = ((string)(性别));
}
if ((班级 == null)) {
this.Adapter.UpdateCommand.Parameters[3].Value = System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[3].Value = ((string)(班级));
}
if ((数学.HasValue == true)) {
this.Adapter.UpdateCommand.Parameters[4].Value = ((short)(数学.Value));
}
else {
this.Adapter.UpdateCommand.Parameters[4].Value = System.DBNull.Value;
}
if ((语文.HasValue == true)) {
this.Adapter.UpdateCommand.Parameters[5].Value = ((short)(语文.Value));
}
else {
this.Adapter.UpdateCommand.Parameters[5].Value = System.DBNull.Value;
}
if ((英语.HasValue == true)) {
this.Adapter.UpdateCommand.Parameters[6].Value = ((short)(英语.Value));
}
else {
this.Adapter.UpdateCommand.Parameters[6].Value = System.DBNull.Value;
}
if ((Original_学号 == null)) {
this.Adapter.UpdateCommand.Parameters[7].Value = System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[7].Value = ((string)(Original_学号));
}
if ((Original_姓名 == null)) {
this.Adapter.UpdateCommand.Parameters[8].Value = ((object)(1));
this.Adapter.UpdateCommand.Parameters[9].Value = System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[8].Value = ((object)(0));
this.Adapter.UpdateCommand.Parameters[9].Value = ((string)(Original_姓名));
}
if ((Original_性别 == null)) {
this.Adapter.UpdateCommand.Parameters[10].Value = ((object)(1));
this.Adapter.UpdateCommand.Parameters[11].Value = System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[10].Value = ((object)(0));
this.Adapter.UpdateCommand.Parameters[11].Value = ((string)(Original_性别));
}
if ((Original_班级 == null)) {
this.Adapter.UpdateCommand.Parameters[12].Value = ((object)(1));
this.Adapter.UpdateCommand.Parameters[13].Value = System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[12].Value = ((object)(0));
this.Adapter.UpdateCommand.Parameters[13].Value = ((string)(Original_班级));
}
if ((Original_数学.HasValue == true)) {
this.Adapter.UpdateCommand.Parameters[14].Value = ((object)(0));
this.Adapter.UpdateCommand.Parameters[15].Value = ((short)(Original_数学.Value));
}
else {
this.Adapter.UpdateCommand.Parameters[14].Value = ((object)(1));
this.Adapter.UpdateCommand.Parameters[15].Value = System.DBNull.Value;
}
if ((Original_语文.HasValue == true)) {
this.Adapter.UpdateCommand.Parameters[16].Value = ((object)(0));
this.Adapter.UpdateCommand.Parameters[17].Value = ((short)(Original_语文.Value));
}
else {
this.Adapter.UpdateCommand.Parameters[16].Value = ((object)(1));
this.Adapter.UpdateCommand.Para⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -