📄 pubsdataset2.designer.cs
字号:
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public int age {
get {
try {
return ((int)(this[this.tableusers.ageColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("表“users”中列“age”的值为 DBNull。", e);
}
}
set {
this[this.tableusers.ageColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string company {
get {
try {
return ((string)(this[this.tableusers.companyColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("表“users”中列“company”的值为 DBNull。", e);
}
}
set {
this[this.tableusers.companyColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public int islocked {
get {
try {
return ((int)(this[this.tableusers.islockedColumn]));
}
catch (System.InvalidCastException e) {
throw new System.Data.StrongTypingException("表“users”中列“islocked”的值为 DBNull。", e);
}
}
set {
this[this.tableusers.islockedColumn] = value;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IspidNull() {
return this.IsNull(this.tableusers.pidColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetpidNull() {
this[this.tableusers.pidColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsunameNull() {
return this.IsNull(this.tableusers.unameColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetunameNull() {
this[this.tableusers.unameColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsageNull() {
return this.IsNull(this.tableusers.ageColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetageNull() {
this[this.tableusers.ageColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IscompanyNull() {
return this.IsNull(this.tableusers.companyColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetcompanyNull() {
this[this.tableusers.companyColumn] = System.Convert.DBNull;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsislockedNull() {
return this.IsNull(this.tableusers.islockedColumn);
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetislockedNull() {
this[this.tableusers.islockedColumn] = System.Convert.DBNull;
}
}
[System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
public class usersRowChangeEvent : System.EventArgs {
private usersRow eventRow;
private System.Data.DataRowAction eventAction;
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public usersRowChangeEvent(usersRow row, System.Data.DataRowAction action) {
this.eventRow = row;
this.eventAction = action;
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public usersRow Row {
get {
return this.eventRow;
}
}
[System.Diagnostics.DebuggerNonUserCodeAttribute()]
public System.Data.DataRowAction Action {
get {
return this.eventAction;
}
}
}
}
}
namespace 图书馆管理系统.pubsDataSet2TableAdapters {
[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 usersTableAdapter : 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 usersTableAdapter() {
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 = "users";
tableMapping.ColumnMappings.Add("uid", "uid");
tableMapping.ColumnMappings.Add("pid", "pid");
tableMapping.ColumnMappings.Add("uname", "uname");
tableMapping.ColumnMappings.Add("age", "age");
tableMapping.ColumnMappings.Add("company", "company");
tableMapping.ColumnMappings.Add("islocked", "islocked");
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].[users] WHERE (([uid] = @Original_uid) AND ((@IsNull_pid = 1 AND [pid] IS NULL) OR ([pid] = @Original_pid)) AND ((@IsNull_uname = 1 AND [uname] IS NULL) OR ([uname] = @Original_uname)) AND ((@IsNull_age = 1 AND [age] IS NULL) OR ([age] = @Original_age)) AND ((@IsNull_company = 1 AND [company] IS NULL) OR ([company] = @Original_company)) AND ((@IsNull_islocked = 1 AND [islocked] IS NULL) OR ([islocked] = @Original_islocked)))";
this._adapter.DeleteCommand.CommandType = System.Data.CommandType.Text;
this._adapter.DeleteCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_uid", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "uid", System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsNull_pid", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "pid", System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_pid", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "pid", System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsNull_uname", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "uname", System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_uname", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "uname", System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsNull_age", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "age", System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_age", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "age", System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsNull_company", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "company", System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_company", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "company", System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsNull_islocked", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "islocked", System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_islocked", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "islocked", 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].[users] ([pid], [uname], [age], [company], [islocked]) VALUES (" +
"@pid, @uname, @age, @company, @islocked);\r\nSELECT uid, pid, uname, age, company," +
" islocked FROM users WHERE (uid = SCOPE_IDENTITY())";
this._adapter.InsertCommand.CommandType = System.Data.CommandType.Text;
this._adapter.InsertCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@pid", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "pid", System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.InsertCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@uname", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "uname", System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.InsertCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@age", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "age", System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.InsertCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@company", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "company", System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.InsertCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@islocked", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "islocked", 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].[users] SET [pid] = @pid, [uname] = @uname, [age] = @age, [company] = @company, [islocked] = @islocked WHERE (([uid] = @Original_uid) AND ((@IsNull_pid = 1 AND [pid] IS NULL) OR ([pid] = @Original_pid)) AND ((@IsNull_uname = 1 AND [uname] IS NULL) OR ([uname] = @Original_uname)) AND ((@IsNull_age = 1 AND [age] IS NULL) OR ([age] = @Original_age)) AND ((@IsNull_company = 1 AND [company] IS NULL) OR ([company] = @Original_company)) AND ((@IsNull_islocked = 1 AND [islocked] IS NULL) OR ([islocked] = @Original_islocked)));
SELECT uid, pid, uname, age, company, islocked FROM users WHERE (uid = @uid)";
this._adapter.UpdateCommand.CommandType = System.Data.CommandType.Text;
this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@pid", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "pid", System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@uname", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "uname", System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@age", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "age", System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@company", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "company", System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@islocked", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "islocked", System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_uid", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "uid", System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsNull_pid", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "pid", System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_pid", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "pid", System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsNull_uname", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "uname", System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_uname", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "uname", System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsNull_age", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "age", System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_age", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "age", System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsNull_company", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "company", System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_company", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "company", System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsNull_islocked", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "islocked", System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_islocked", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "islocked", System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@uid", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, 0, 0, "uid", System.Data.DataRowVersion.Current, false, null, "", "", ""));
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -