BookStoreDataSet.Designer.cs
资源名称:BookStore.rar [点击查看]
上传用户:xyl529207
上传日期:2022-08-03
资源大小:935k
文件大小:277k
源码类别:
行业应用
开发平台:
SQL
- }
- public event V_BookSellRowChangeEventHandler V_BookSellRowChanging;
- public event V_BookSellRowChangeEventHandler V_BookSellRowChanged;
- public event V_BookSellRowChangeEventHandler V_BookSellRowDeleting;
- public event V_BookSellRowChangeEventHandler V_BookSellRowDeleted;
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public void AddV_BookSellRow(V_BookSellRow row) {
- this.Rows.Add(row);
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public V_BookSellRow AddV_BookSellRow(int ID, int CustomerID, System.DateTime Time, string ISBN, string Name, string Press, decimal Price, int Number, double Discount, decimal Sum, int SellID) {
- V_BookSellRow rowV_BookSellRow = ((V_BookSellRow)(this.NewRow()));
- rowV_BookSellRow.ItemArray = new object[] {
- ID,
- CustomerID,
- Time,
- ISBN,
- Name,
- Press,
- Price,
- Number,
- Discount,
- Sum,
- SellID};
- this.Rows.Add(rowV_BookSellRow);
- return rowV_BookSellRow;
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public V_BookSellRow FindByID(int ID) {
- return ((V_BookSellRow)(this.Rows.Find(new object[] {
- ID})));
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public virtual System.Collections.IEnumerator GetEnumerator() {
- return this.Rows.GetEnumerator();
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public override System.Data.DataTable Clone() {
- V_BookSellDataTable cln = ((V_BookSellDataTable)(base.Clone()));
- cln.InitVars();
- return cln;
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- protected override System.Data.DataTable CreateInstance() {
- return new V_BookSellDataTable();
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- internal void InitVars() {
- this.columnID = base.Columns["ID"];
- this.columnCustomerID = base.Columns["CustomerID"];
- this.columnTime = base.Columns["Time"];
- this.columnISBN = base.Columns["ISBN"];
- this.columnName = base.Columns["Name"];
- this.columnPress = base.Columns["Press"];
- this.columnPrice = base.Columns["Price"];
- this.columnNumber = base.Columns["Number"];
- this.columnDiscount = base.Columns["Discount"];
- this.columnSum = base.Columns["Sum"];
- this.columnSellID = base.Columns["SellID"];
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- private void InitClass() {
- this.columnID = new System.Data.DataColumn("ID", typeof(int), null, System.Data.MappingType.Element);
- base.Columns.Add(this.columnID);
- this.columnCustomerID = new System.Data.DataColumn("CustomerID", typeof(int), null, System.Data.MappingType.Element);
- base.Columns.Add(this.columnCustomerID);
- this.columnTime = new System.Data.DataColumn("Time", typeof(System.DateTime), null, System.Data.MappingType.Element);
- base.Columns.Add(this.columnTime);
- this.columnISBN = new System.Data.DataColumn("ISBN", typeof(string), null, System.Data.MappingType.Element);
- base.Columns.Add(this.columnISBN);
- this.columnName = new System.Data.DataColumn("Name", typeof(string), null, System.Data.MappingType.Element);
- base.Columns.Add(this.columnName);
- this.columnPress = new System.Data.DataColumn("Press", typeof(string), null, System.Data.MappingType.Element);
- base.Columns.Add(this.columnPress);
- this.columnPrice = new System.Data.DataColumn("Price", typeof(decimal), null, System.Data.MappingType.Element);
- base.Columns.Add(this.columnPrice);
- this.columnNumber = new System.Data.DataColumn("Number", typeof(int), null, System.Data.MappingType.Element);
- base.Columns.Add(this.columnNumber);
- this.columnDiscount = new System.Data.DataColumn("Discount", typeof(double), null, System.Data.MappingType.Element);
- base.Columns.Add(this.columnDiscount);
- this.columnSum = new System.Data.DataColumn("Sum", typeof(decimal), null, System.Data.MappingType.Element);
- base.Columns.Add(this.columnSum);
- this.columnSellID = new System.Data.DataColumn("SellID", typeof(int), null, System.Data.MappingType.Element);
- base.Columns.Add(this.columnSellID);
- this.Constraints.Add(new System.Data.UniqueConstraint("Constraint1", new System.Data.DataColumn[] {
- this.columnID}, true));
- this.columnID.AllowDBNull = false;
- this.columnID.Unique = true;
- this.columnTime.AllowDBNull = false;
- this.columnISBN.AllowDBNull = false;
- this.columnISBN.MaxLength = 10;
- this.columnName.AllowDBNull = false;
- this.columnName.MaxLength = 256;
- this.columnPress.MaxLength = 50;
- this.columnPrice.AllowDBNull = false;
- this.columnNumber.AllowDBNull = false;
- this.columnDiscount.AllowDBNull = false;
- this.columnSellID.AllowDBNull = false;
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public V_BookSellRow NewV_BookSellRow() {
- return ((V_BookSellRow)(this.NewRow()));
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- protected override System.Data.DataRow NewRowFromBuilder(System.Data.DataRowBuilder builder) {
- return new V_BookSellRow(builder);
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- protected override System.Type GetRowType() {
- return typeof(V_BookSellRow);
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- protected override void OnRowChanged(System.Data.DataRowChangeEventArgs e) {
- base.OnRowChanged(e);
- if ((this.V_BookSellRowChanged != null)) {
- this.V_BookSellRowChanged(this, new V_BookSellRowChangeEvent(((V_BookSellRow)(e.Row)), e.Action));
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- protected override void OnRowChanging(System.Data.DataRowChangeEventArgs e) {
- base.OnRowChanging(e);
- if ((this.V_BookSellRowChanging != null)) {
- this.V_BookSellRowChanging(this, new V_BookSellRowChangeEvent(((V_BookSellRow)(e.Row)), e.Action));
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- protected override void OnRowDeleted(System.Data.DataRowChangeEventArgs e) {
- base.OnRowDeleted(e);
- if ((this.V_BookSellRowDeleted != null)) {
- this.V_BookSellRowDeleted(this, new V_BookSellRowChangeEvent(((V_BookSellRow)(e.Row)), e.Action));
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- protected override void OnRowDeleting(System.Data.DataRowChangeEventArgs e) {
- base.OnRowDeleting(e);
- if ((this.V_BookSellRowDeleting != null)) {
- this.V_BookSellRowDeleting(this, new V_BookSellRowChangeEvent(((V_BookSellRow)(e.Row)), e.Action));
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public void RemoveV_BookSellRow(V_BookSellRow row) {
- this.Rows.Remove(row);
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public static System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(System.Xml.Schema.XmlSchemaSet xs) {
- System.Xml.Schema.XmlSchemaComplexType type = new System.Xml.Schema.XmlSchemaComplexType();
- System.Xml.Schema.XmlSchemaSequence sequence = new System.Xml.Schema.XmlSchemaSequence();
- BookStoreDataSet ds = new BookStoreDataSet();
- xs.Add(ds.GetSchemaSerializable());
- System.Xml.Schema.XmlSchemaAny any1 = new System.Xml.Schema.XmlSchemaAny();
- any1.Namespace = "http://www.w3.org/2001/XMLSchema";
- any1.MinOccurs = new decimal(0);
- any1.MaxOccurs = decimal.MaxValue;
- any1.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax;
- sequence.Items.Add(any1);
- System.Xml.Schema.XmlSchemaAny any2 = new System.Xml.Schema.XmlSchemaAny();
- any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
- any2.MinOccurs = new decimal(1);
- any2.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax;
- sequence.Items.Add(any2);
- System.Xml.Schema.XmlSchemaAttribute attribute1 = new System.Xml.Schema.XmlSchemaAttribute();
- attribute1.Name = "namespace";
- attribute1.FixedValue = ds.Namespace;
- type.Attributes.Add(attribute1);
- System.Xml.Schema.XmlSchemaAttribute attribute2 = new System.Xml.Schema.XmlSchemaAttribute();
- attribute2.Name = "tableTypeName";
- attribute2.FixedValue = "V_BookSellDataTable";
- type.Attributes.Add(attribute2);
- type.Particle = sequence;
- return type;
- }
- }
- [System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
- [System.Serializable()]
- [System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedTableSchema")]
- public partial class P_GetSellDetailDataTable : System.Data.DataTable, System.Collections.IEnumerable {
- private System.Data.DataColumn columnBookID;
- private System.Data.DataColumn columnISBN;
- private System.Data.DataColumn columnName;
- private System.Data.DataColumn columnPrice;
- private System.Data.DataColumn columnNumber;
- private System.Data.DataColumn columnDiscount;
- private System.Data.DataColumn columnSum;
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public P_GetSellDetailDataTable() {
- this.TableName = "P_GetSellDetail";
- this.BeginInit();
- this.InitClass();
- this.EndInit();
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- internal P_GetSellDetailDataTable(System.Data.DataTable table) {
- this.TableName = table.TableName;
- if ((table.CaseSensitive != table.DataSet.CaseSensitive)) {
- this.CaseSensitive = table.CaseSensitive;
- }
- if ((table.Locale.ToString() != table.DataSet.Locale.ToString())) {
- this.Locale = table.Locale;
- }
- if ((table.Namespace != table.DataSet.Namespace)) {
- this.Namespace = table.Namespace;
- }
- this.Prefix = table.Prefix;
- this.MinimumCapacity = table.MinimumCapacity;
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- protected P_GetSellDetailDataTable(System.Runtime.Serialization.SerializationInfo info, System.Runtime.Serialization.StreamingContext context) :
- base(info, context) {
- this.InitVars();
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public System.Data.DataColumn BookIDColumn {
- get {
- return this.columnBookID;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public System.Data.DataColumn ISBNColumn {
- get {
- return this.columnISBN;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public System.Data.DataColumn NameColumn {
- get {
- return this.columnName;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public System.Data.DataColumn PriceColumn {
- get {
- return this.columnPrice;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public System.Data.DataColumn NumberColumn {
- get {
- return this.columnNumber;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public System.Data.DataColumn DiscountColumn {
- get {
- return this.columnDiscount;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public System.Data.DataColumn SumColumn {
- get {
- return this.columnSum;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [System.ComponentModel.Browsable(false)]
- public int Count {
- get {
- return this.Rows.Count;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public P_GetSellDetailRow this[int index] {
- get {
- return ((P_GetSellDetailRow)(this.Rows[index]));
- }
- }
- public event P_GetSellDetailRowChangeEventHandler P_GetSellDetailRowChanging;
- public event P_GetSellDetailRowChangeEventHandler P_GetSellDetailRowChanged;
- public event P_GetSellDetailRowChangeEventHandler P_GetSellDetailRowDeleting;
- public event P_GetSellDetailRowChangeEventHandler P_GetSellDetailRowDeleted;
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public void AddP_GetSellDetailRow(P_GetSellDetailRow row) {
- this.Rows.Add(row);
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public P_GetSellDetailRow AddP_GetSellDetailRow(int BookID, string ISBN, string Name, decimal Price, int Number, double Discount, decimal Sum) {
- P_GetSellDetailRow rowP_GetSellDetailRow = ((P_GetSellDetailRow)(this.NewRow()));
- rowP_GetSellDetailRow.ItemArray = new object[] {
- BookID,
- ISBN,
- Name,
- Price,
- Number,
- Discount,
- Sum};
- this.Rows.Add(rowP_GetSellDetailRow);
- return rowP_GetSellDetailRow;
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public virtual System.Collections.IEnumerator GetEnumerator() {
- return this.Rows.GetEnumerator();
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public override System.Data.DataTable Clone() {
- P_GetSellDetailDataTable cln = ((P_GetSellDetailDataTable)(base.Clone()));
- cln.InitVars();
- return cln;
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- protected override System.Data.DataTable CreateInstance() {
- return new P_GetSellDetailDataTable();
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- internal void InitVars() {
- this.columnBookID = base.Columns["BookID"];
- this.columnISBN = base.Columns["ISBN"];
- this.columnName = base.Columns["Name"];
- this.columnPrice = base.Columns["Price"];
- this.columnNumber = base.Columns["Number"];
- this.columnDiscount = base.Columns["Discount"];
- this.columnSum = base.Columns["Sum"];
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- private void InitClass() {
- this.columnBookID = new System.Data.DataColumn("BookID", typeof(int), null, System.Data.MappingType.Element);
- base.Columns.Add(this.columnBookID);
- this.columnISBN = new System.Data.DataColumn("ISBN", typeof(string), null, System.Data.MappingType.Element);
- base.Columns.Add(this.columnISBN);
- this.columnName = new System.Data.DataColumn("Name", typeof(string), null, System.Data.MappingType.Element);
- base.Columns.Add(this.columnName);
- this.columnPrice = new System.Data.DataColumn("Price", typeof(decimal), null, System.Data.MappingType.Element);
- base.Columns.Add(this.columnPrice);
- this.columnNumber = new System.Data.DataColumn("Number", typeof(int), null, System.Data.MappingType.Element);
- base.Columns.Add(this.columnNumber);
- this.columnDiscount = new System.Data.DataColumn("Discount", typeof(double), null, System.Data.MappingType.Element);
- base.Columns.Add(this.columnDiscount);
- this.columnSum = new System.Data.DataColumn("Sum", typeof(decimal), null, System.Data.MappingType.Element);
- base.Columns.Add(this.columnSum);
- this.columnBookID.AllowDBNull = false;
- this.columnISBN.AllowDBNull = false;
- this.columnISBN.MaxLength = 10;
- this.columnName.AllowDBNull = false;
- this.columnName.MaxLength = 256;
- this.columnPrice.AllowDBNull = false;
- this.columnNumber.AllowDBNull = false;
- this.columnDiscount.AllowDBNull = false;
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public P_GetSellDetailRow NewP_GetSellDetailRow() {
- return ((P_GetSellDetailRow)(this.NewRow()));
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- protected override System.Data.DataRow NewRowFromBuilder(System.Data.DataRowBuilder builder) {
- return new P_GetSellDetailRow(builder);
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- protected override System.Type GetRowType() {
- return typeof(P_GetSellDetailRow);
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- protected override void OnRowChanged(System.Data.DataRowChangeEventArgs e) {
- base.OnRowChanged(e);
- if ((this.P_GetSellDetailRowChanged != null)) {
- this.P_GetSellDetailRowChanged(this, new P_GetSellDetailRowChangeEvent(((P_GetSellDetailRow)(e.Row)), e.Action));
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- protected override void OnRowChanging(System.Data.DataRowChangeEventArgs e) {
- base.OnRowChanging(e);
- if ((this.P_GetSellDetailRowChanging != null)) {
- this.P_GetSellDetailRowChanging(this, new P_GetSellDetailRowChangeEvent(((P_GetSellDetailRow)(e.Row)), e.Action));
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- protected override void OnRowDeleted(System.Data.DataRowChangeEventArgs e) {
- base.OnRowDeleted(e);
- if ((this.P_GetSellDetailRowDeleted != null)) {
- this.P_GetSellDetailRowDeleted(this, new P_GetSellDetailRowChangeEvent(((P_GetSellDetailRow)(e.Row)), e.Action));
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- protected override void OnRowDeleting(System.Data.DataRowChangeEventArgs e) {
- base.OnRowDeleting(e);
- if ((this.P_GetSellDetailRowDeleting != null)) {
- this.P_GetSellDetailRowDeleting(this, new P_GetSellDetailRowChangeEvent(((P_GetSellDetailRow)(e.Row)), e.Action));
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public void RemoveP_GetSellDetailRow(P_GetSellDetailRow row) {
- this.Rows.Remove(row);
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public static System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(System.Xml.Schema.XmlSchemaSet xs) {
- System.Xml.Schema.XmlSchemaComplexType type = new System.Xml.Schema.XmlSchemaComplexType();
- System.Xml.Schema.XmlSchemaSequence sequence = new System.Xml.Schema.XmlSchemaSequence();
- BookStoreDataSet ds = new BookStoreDataSet();
- xs.Add(ds.GetSchemaSerializable());
- System.Xml.Schema.XmlSchemaAny any1 = new System.Xml.Schema.XmlSchemaAny();
- any1.Namespace = "http://www.w3.org/2001/XMLSchema";
- any1.MinOccurs = new decimal(0);
- any1.MaxOccurs = decimal.MaxValue;
- any1.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax;
- sequence.Items.Add(any1);
- System.Xml.Schema.XmlSchemaAny any2 = new System.Xml.Schema.XmlSchemaAny();
- any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
- any2.MinOccurs = new decimal(1);
- any2.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax;
- sequence.Items.Add(any2);
- System.Xml.Schema.XmlSchemaAttribute attribute1 = new System.Xml.Schema.XmlSchemaAttribute();
- attribute1.Name = "namespace";
- attribute1.FixedValue = ds.Namespace;
- type.Attributes.Add(attribute1);
- System.Xml.Schema.XmlSchemaAttribute attribute2 = new System.Xml.Schema.XmlSchemaAttribute();
- attribute2.Name = "tableTypeName";
- attribute2.FixedValue = "P_GetSellDetailDataTable";
- type.Attributes.Add(attribute2);
- type.Particle = sequence;
- return type;
- }
- }
- [System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
- public partial class BookRow : System.Data.DataRow {
- private BookDataTable tableBook;
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- internal BookRow(System.Data.DataRowBuilder rb) :
- base(rb) {
- this.tableBook = ((BookDataTable)(this.Table));
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public int ID {
- get {
- return ((int)(this[this.tableBook.IDColumn]));
- }
- set {
- this[this.tableBook.IDColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public string ISBN {
- get {
- return ((string)(this[this.tableBook.ISBNColumn]));
- }
- set {
- this[this.tableBook.ISBNColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public string Name {
- get {
- return ((string)(this[this.tableBook.NameColumn]));
- }
- set {
- this[this.tableBook.NameColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public string Author {
- get {
- try {
- return ((string)(this[this.tableBook.AuthorColumn]));
- }
- catch (System.InvalidCastException e) {
- throw new System.Data.StrongTypingException("表“Book”中列“Author”的值为 DBNull。", e);
- }
- }
- set {
- this[this.tableBook.AuthorColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public string Press {
- get {
- try {
- return ((string)(this[this.tableBook.PressColumn]));
- }
- catch (System.InvalidCastException e) {
- throw new System.Data.StrongTypingException("表“Book”中列“Press”的值为 DBNull。", e);
- }
- }
- set {
- this[this.tableBook.PressColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public System.DateTime PublishDate {
- get {
- try {
- return ((System.DateTime)(this[this.tableBook.PublishDateColumn]));
- }
- catch (System.InvalidCastException e) {
- throw new System.Data.StrongTypingException("表“Book”中列“PublishDate”的值为 DBNull。", e);
- }
- }
- set {
- this[this.tableBook.PublishDateColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public decimal Price {
- get {
- return ((decimal)(this[this.tableBook.PriceColumn]));
- }
- set {
- this[this.tableBook.PriceColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public short Pages {
- get {
- try {
- return ((short)(this[this.tableBook.PagesColumn]));
- }
- catch (System.InvalidCastException e) {
- throw new System.Data.StrongTypingException("表“Book”中列“Pages”的值为 DBNull。", e);
- }
- }
- set {
- this[this.tableBook.PagesColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public string Barcode {
- get {
- return ((string)(this[this.tableBook.BarcodeColumn]));
- }
- set {
- this[this.tableBook.BarcodeColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public bool CD {
- get {
- try {
- return ((bool)(this[this.tableBook.CDColumn]));
- }
- catch (System.InvalidCastException e) {
- throw new System.Data.StrongTypingException("表“Book”中列“CD”的值为 DBNull。", e);
- }
- }
- set {
- this[this.tableBook.CDColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public int Storage {
- get {
- return ((int)(this[this.tableBook.StorageColumn]));
- }
- set {
- this[this.tableBook.StorageColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public bool IsAuthorNull() {
- return this.IsNull(this.tableBook.AuthorColumn);
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public void SetAuthorNull() {
- this[this.tableBook.AuthorColumn] = System.Convert.DBNull;
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public bool IsPressNull() {
- return this.IsNull(this.tableBook.PressColumn);
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public void SetPressNull() {
- this[this.tableBook.PressColumn] = System.Convert.DBNull;
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public bool IsPublishDateNull() {
- return this.IsNull(this.tableBook.PublishDateColumn);
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public void SetPublishDateNull() {
- this[this.tableBook.PublishDateColumn] = System.Convert.DBNull;
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public bool IsPagesNull() {
- return this.IsNull(this.tableBook.PagesColumn);
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public void SetPagesNull() {
- this[this.tableBook.PagesColumn] = System.Convert.DBNull;
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public bool IsCDNull() {
- return this.IsNull(this.tableBook.CDColumn);
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public void SetCDNull() {
- this[this.tableBook.CDColumn] = System.Convert.DBNull;
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public SellItemRow[] GetSellItemRows() {
- return ((SellItemRow[])(base.GetChildRows(this.Table.ChildRelations["FK_SellItem_Book"])));
- }
- }
- [System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
- public partial class CustomerRow : System.Data.DataRow {
- private CustomerDataTable tableCustomer;
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- internal CustomerRow(System.Data.DataRowBuilder rb) :
- base(rb) {
- this.tableCustomer = ((CustomerDataTable)(this.Table));
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public int ID {
- get {
- return ((int)(this[this.tableCustomer.IDColumn]));
- }
- set {
- this[this.tableCustomer.IDColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public string Name {
- get {
- return ((string)(this[this.tableCustomer.NameColumn]));
- }
- set {
- this[this.tableCustomer.NameColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public short Levels {
- get {
- return ((short)(this[this.tableCustomer.LevelsColumn]));
- }
- set {
- this[this.tableCustomer.LevelsColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public bool Gender {
- get {
- try {
- return ((bool)(this[this.tableCustomer.GenderColumn]));
- }
- catch (System.InvalidCastException e) {
- throw new System.Data.StrongTypingException("表“Customer”中列“Gender”的值为 DBNull。", e);
- }
- }
- set {
- this[this.tableCustomer.GenderColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public System.DateTime Birthday {
- get {
- try {
- return ((System.DateTime)(this[this.tableCustomer.BirthdayColumn]));
- }
- catch (System.InvalidCastException e) {
- throw new System.Data.StrongTypingException("表“Customer”中列“Birthday”的值为 DBNull。", e);
- }
- }
- set {
- this[this.tableCustomer.BirthdayColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public string Degree {
- get {
- try {
- return ((string)(this[this.tableCustomer.DegreeColumn]));
- }
- catch (System.InvalidCastException e) {
- throw new System.Data.StrongTypingException("表“Customer”中列“Degree”的值为 DBNull。", e);
- }
- }
- set {
- this[this.tableCustomer.DegreeColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public string Address {
- get {
- try {
- return ((string)(this[this.tableCustomer.AddressColumn]));
- }
- catch (System.InvalidCastException e) {
- throw new System.Data.StrongTypingException("表“Customer”中列“Address”的值为 DBNull。", e);
- }
- }
- set {
- this[this.tableCustomer.AddressColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public string Telephone {
- get {
- try {
- return ((string)(this[this.tableCustomer.TelephoneColumn]));
- }
- catch (System.InvalidCastException e) {
- throw new System.Data.StrongTypingException("表“Customer”中列“Telephone”的值为 DBNull。", e);
- }
- }
- set {
- this[this.tableCustomer.TelephoneColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public string Email {
- get {
- try {
- return ((string)(this[this.tableCustomer.EmailColumn]));
- }
- catch (System.InvalidCastException e) {
- throw new System.Data.StrongTypingException("表“Customer”中列“Email”的值为 DBNull。", e);
- }
- }
- set {
- this[this.tableCustomer.EmailColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public int Score {
- get {
- try {
- return ((int)(this[this.tableCustomer.ScoreColumn]));
- }
- catch (System.InvalidCastException e) {
- throw new System.Data.StrongTypingException("表“Customer”中列“Score”的值为 DBNull。", e);
- }
- }
- set {
- this[this.tableCustomer.ScoreColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public bool IsGenderNull() {
- return this.IsNull(this.tableCustomer.GenderColumn);
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public void SetGenderNull() {
- this[this.tableCustomer.GenderColumn] = System.Convert.DBNull;
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public bool IsBirthdayNull() {
- return this.IsNull(this.tableCustomer.BirthdayColumn);
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public void SetBirthdayNull() {
- this[this.tableCustomer.BirthdayColumn] = System.Convert.DBNull;
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public bool IsDegreeNull() {
- return this.IsNull(this.tableCustomer.DegreeColumn);
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public void SetDegreeNull() {
- this[this.tableCustomer.DegreeColumn] = System.Convert.DBNull;
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public bool IsAddressNull() {
- return this.IsNull(this.tableCustomer.AddressColumn);
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public void SetAddressNull() {
- this[this.tableCustomer.AddressColumn] = System.Convert.DBNull;
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public bool IsTelephoneNull() {
- return this.IsNull(this.tableCustomer.TelephoneColumn);
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public void SetTelephoneNull() {
- this[this.tableCustomer.TelephoneColumn] = System.Convert.DBNull;
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public bool IsEmailNull() {
- return this.IsNull(this.tableCustomer.EmailColumn);
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public void SetEmailNull() {
- this[this.tableCustomer.EmailColumn] = System.Convert.DBNull;
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public bool IsScoreNull() {
- return this.IsNull(this.tableCustomer.ScoreColumn);
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public void SetScoreNull() {
- this[this.tableCustomer.ScoreColumn] = System.Convert.DBNull;
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public SellRow[] GetSellRows() {
- return ((SellRow[])(base.GetChildRows(this.Table.ChildRelations["Customer_Sell"])));
- }
- }
- [System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
- public partial class SellRow : System.Data.DataRow {
- private SellDataTable tableSell;
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- internal SellRow(System.Data.DataRowBuilder rb) :
- base(rb) {
- this.tableSell = ((SellDataTable)(this.Table));
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public int ID {
- get {
- return ((int)(this[this.tableSell.IDColumn]));
- }
- set {
- this[this.tableSell.IDColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public int CustomerID {
- get {
- try {
- return ((int)(this[this.tableSell.CustomerIDColumn]));
- }
- catch (System.InvalidCastException e) {
- throw new System.Data.StrongTypingException("表“Sell”中列“CustomerID”的值为 DBNull。", e);
- }
- }
- set {
- this[this.tableSell.CustomerIDColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public decimal Sum {
- get {
- return ((decimal)(this[this.tableSell.SumColumn]));
- }
- set {
- this[this.tableSell.SumColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public System.DateTime Time {
- get {
- return ((System.DateTime)(this[this.tableSell.TimeColumn]));
- }
- set {
- this[this.tableSell.TimeColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public CustomerRow CustomerRow {
- get {
- return ((CustomerRow)(this.GetParentRow(this.Table.ParentRelations["Customer_Sell"])));
- }
- set {
- this.SetParentRow(value, this.Table.ParentRelations["Customer_Sell"]);
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public bool IsCustomerIDNull() {
- return this.IsNull(this.tableSell.CustomerIDColumn);
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public void SetCustomerIDNull() {
- this[this.tableSell.CustomerIDColumn] = System.Convert.DBNull;
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public SellItemRow[] GetSellItemRows() {
- return ((SellItemRow[])(base.GetChildRows(this.Table.ChildRelations["FK_SellItem_Sell"])));
- }
- }
- [System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
- public partial class SellItemRow : System.Data.DataRow {
- private SellItemDataTable tableSellItem;
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- internal SellItemRow(System.Data.DataRowBuilder rb) :
- base(rb) {
- this.tableSellItem = ((SellItemDataTable)(this.Table));
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public int ID {
- get {
- return ((int)(this[this.tableSellItem.IDColumn]));
- }
- set {
- this[this.tableSellItem.IDColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public int SellID {
- get {
- return ((int)(this[this.tableSellItem.SellIDColumn]));
- }
- set {
- this[this.tableSellItem.SellIDColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public int BookID {
- get {
- return ((int)(this[this.tableSellItem.BookIDColumn]));
- }
- set {
- this[this.tableSellItem.BookIDColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public int Number {
- get {
- return ((int)(this[this.tableSellItem.NumberColumn]));
- }
- set {
- this[this.tableSellItem.NumberColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public double Discount {
- get {
- return ((double)(this[this.tableSellItem.DiscountColumn]));
- }
- set {
- this[this.tableSellItem.DiscountColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public decimal Sum {
- get {
- try {
- return ((decimal)(this[this.tableSellItem.SumColumn]));
- }
- catch (System.InvalidCastException e) {
- throw new System.Data.StrongTypingException("表“SellItem”中列“Sum”的值为 DBNull。", e);
- }
- }
- set {
- this[this.tableSellItem.SumColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public BookRow BookRow {
- get {
- return ((BookRow)(this.GetParentRow(this.Table.ParentRelations["FK_SellItem_Book"])));
- }
- set {
- this.SetParentRow(value, this.Table.ParentRelations["FK_SellItem_Book"]);
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public SellRow SellRow {
- get {
- return ((SellRow)(this.GetParentRow(this.Table.ParentRelations["FK_SellItem_Sell"])));
- }
- set {
- this.SetParentRow(value, this.Table.ParentRelations["FK_SellItem_Sell"]);
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public bool IsSumNull() {
- return this.IsNull(this.tableSellItem.SumColumn);
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public void SetSumNull() {
- this[this.tableSellItem.SumColumn] = System.Convert.DBNull;
- }
- }
- [System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
- public partial class V_BookSellRow : System.Data.DataRow {
- private V_BookSellDataTable tableV_BookSell;
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- internal V_BookSellRow(System.Data.DataRowBuilder rb) :
- base(rb) {
- this.tableV_BookSell = ((V_BookSellDataTable)(this.Table));
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public int ID {
- get {
- return ((int)(this[this.tableV_BookSell.IDColumn]));
- }
- set {
- this[this.tableV_BookSell.IDColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public int CustomerID {
- get {
- try {
- return ((int)(this[this.tableV_BookSell.CustomerIDColumn]));
- }
- catch (System.InvalidCastException e) {
- throw new System.Data.StrongTypingException("表“V_BookSell”中列“CustomerID”的值为 DBNull。", e);
- }
- }
- set {
- this[this.tableV_BookSell.CustomerIDColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public System.DateTime Time {
- get {
- return ((System.DateTime)(this[this.tableV_BookSell.TimeColumn]));
- }
- set {
- this[this.tableV_BookSell.TimeColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public string ISBN {
- get {
- return ((string)(this[this.tableV_BookSell.ISBNColumn]));
- }
- set {
- this[this.tableV_BookSell.ISBNColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public string Name {
- get {
- return ((string)(this[this.tableV_BookSell.NameColumn]));
- }
- set {
- this[this.tableV_BookSell.NameColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public string Press {
- get {
- try {
- return ((string)(this[this.tableV_BookSell.PressColumn]));
- }
- catch (System.InvalidCastException e) {
- throw new System.Data.StrongTypingException("表“V_BookSell”中列“Press”的值为 DBNull。", e);
- }
- }
- set {
- this[this.tableV_BookSell.PressColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public decimal Price {
- get {
- return ((decimal)(this[this.tableV_BookSell.PriceColumn]));
- }
- set {
- this[this.tableV_BookSell.PriceColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public int Number {
- get {
- return ((int)(this[this.tableV_BookSell.NumberColumn]));
- }
- set {
- this[this.tableV_BookSell.NumberColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public double Discount {
- get {
- return ((double)(this[this.tableV_BookSell.DiscountColumn]));
- }
- set {
- this[this.tableV_BookSell.DiscountColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public decimal Sum {
- get {
- try {
- return ((decimal)(this[this.tableV_BookSell.SumColumn]));
- }
- catch (System.InvalidCastException e) {
- throw new System.Data.StrongTypingException("表“V_BookSell”中列“Sum”的值为 DBNull。", e);
- }
- }
- set {
- this[this.tableV_BookSell.SumColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public int SellID {
- get {
- return ((int)(this[this.tableV_BookSell.SellIDColumn]));
- }
- set {
- this[this.tableV_BookSell.SellIDColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public bool IsCustomerIDNull() {
- return this.IsNull(this.tableV_BookSell.CustomerIDColumn);
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public void SetCustomerIDNull() {
- this[this.tableV_BookSell.CustomerIDColumn] = System.Convert.DBNull;
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public bool IsPressNull() {
- return this.IsNull(this.tableV_BookSell.PressColumn);
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public void SetPressNull() {
- this[this.tableV_BookSell.PressColumn] = System.Convert.DBNull;
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public bool IsSumNull() {
- return this.IsNull(this.tableV_BookSell.SumColumn);
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public void SetSumNull() {
- this[this.tableV_BookSell.SumColumn] = System.Convert.DBNull;
- }
- }
- [System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
- public partial class P_GetSellDetailRow : System.Data.DataRow {
- private P_GetSellDetailDataTable tableP_GetSellDetail;
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- internal P_GetSellDetailRow(System.Data.DataRowBuilder rb) :
- base(rb) {
- this.tableP_GetSellDetail = ((P_GetSellDetailDataTable)(this.Table));
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public int BookID {
- get {
- return ((int)(this[this.tableP_GetSellDetail.BookIDColumn]));
- }
- set {
- this[this.tableP_GetSellDetail.BookIDColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public string ISBN {
- get {
- return ((string)(this[this.tableP_GetSellDetail.ISBNColumn]));
- }
- set {
- this[this.tableP_GetSellDetail.ISBNColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public string Name {
- get {
- return ((string)(this[this.tableP_GetSellDetail.NameColumn]));
- }
- set {
- this[this.tableP_GetSellDetail.NameColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public decimal Price {
- get {
- return ((decimal)(this[this.tableP_GetSellDetail.PriceColumn]));
- }
- set {
- this[this.tableP_GetSellDetail.PriceColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public int Number {
- get {
- return ((int)(this[this.tableP_GetSellDetail.NumberColumn]));
- }
- set {
- this[this.tableP_GetSellDetail.NumberColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public double Discount {
- get {
- return ((double)(this[this.tableP_GetSellDetail.DiscountColumn]));
- }
- set {
- this[this.tableP_GetSellDetail.DiscountColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public decimal Sum {
- get {
- try {
- return ((decimal)(this[this.tableP_GetSellDetail.SumColumn]));
- }
- catch (System.InvalidCastException e) {
- throw new System.Data.StrongTypingException("表“P_GetSellDetail”中列“Sum”的值为 DBNull。", e);
- }
- }
- set {
- this[this.tableP_GetSellDetail.SumColumn] = value;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public bool IsSumNull() {
- return this.IsNull(this.tableP_GetSellDetail.SumColumn);
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public void SetSumNull() {
- this[this.tableP_GetSellDetail.SumColumn] = System.Convert.DBNull;
- }
- }
- [System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
- public class BookRowChangeEvent : System.EventArgs {
- private BookRow eventRow;
- private System.Data.DataRowAction eventAction;
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public BookRowChangeEvent(BookRow row, System.Data.DataRowAction action) {
- this.eventRow = row;
- this.eventAction = action;
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public BookRow Row {
- get {
- return this.eventRow;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public System.Data.DataRowAction Action {
- get {
- return this.eventAction;
- }
- }
- }
- [System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
- public class CustomerRowChangeEvent : System.EventArgs {
- private CustomerRow eventRow;
- private System.Data.DataRowAction eventAction;
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public CustomerRowChangeEvent(CustomerRow row, System.Data.DataRowAction action) {
- this.eventRow = row;
- this.eventAction = action;
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public CustomerRow Row {
- get {
- return this.eventRow;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public System.Data.DataRowAction Action {
- get {
- return this.eventAction;
- }
- }
- }
- [System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
- public class SellRowChangeEvent : System.EventArgs {
- private SellRow eventRow;
- private System.Data.DataRowAction eventAction;
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public SellRowChangeEvent(SellRow row, System.Data.DataRowAction action) {
- this.eventRow = row;
- this.eventAction = action;
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public SellRow Row {
- get {
- return this.eventRow;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public System.Data.DataRowAction Action {
- get {
- return this.eventAction;
- }
- }
- }
- [System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
- public class SellItemRowChangeEvent : System.EventArgs {
- private SellItemRow eventRow;
- private System.Data.DataRowAction eventAction;
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public SellItemRowChangeEvent(SellItemRow row, System.Data.DataRowAction action) {
- this.eventRow = row;
- this.eventAction = action;
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public SellItemRow Row {
- get {
- return this.eventRow;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public System.Data.DataRowAction Action {
- get {
- return this.eventAction;
- }
- }
- }
- [System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
- public class V_BookSellRowChangeEvent : System.EventArgs {
- private V_BookSellRow eventRow;
- private System.Data.DataRowAction eventAction;
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public V_BookSellRowChangeEvent(V_BookSellRow row, System.Data.DataRowAction action) {
- this.eventRow = row;
- this.eventAction = action;
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public V_BookSellRow Row {
- get {
- return this.eventRow;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public System.Data.DataRowAction Action {
- get {
- return this.eventAction;
- }
- }
- }
- [System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
- public class P_GetSellDetailRowChangeEvent : System.EventArgs {
- private P_GetSellDetailRow eventRow;
- private System.Data.DataRowAction eventAction;
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public P_GetSellDetailRowChangeEvent(P_GetSellDetailRow row, System.Data.DataRowAction action) {
- this.eventRow = row;
- this.eventAction = action;
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public P_GetSellDetailRow Row {
- get {
- return this.eventRow;
- }
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- public System.Data.DataRowAction Action {
- get {
- return this.eventAction;
- }
- }
- }
- }
- }
- namespace BookStoreMan.BookStoreDataSetTableAdapters {
- [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 BookTableAdapter : 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 BookTableAdapter() {
- 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 = "Book";
- tableMapping.ColumnMappings.Add("ID", "ID");
- tableMapping.ColumnMappings.Add("ISBN", "ISBN");
- tableMapping.ColumnMappings.Add("Name", "Name");
- tableMapping.ColumnMappings.Add("Author", "Author");
- tableMapping.ColumnMappings.Add("Press", "Press");
- tableMapping.ColumnMappings.Add("PublishDate", "PublishDate");
- tableMapping.ColumnMappings.Add("Price", "Price");
- tableMapping.ColumnMappings.Add("Pages", "Pages");
- tableMapping.ColumnMappings.Add("Barcode", "Barcode");
- tableMapping.ColumnMappings.Add("CD", "CD");
- tableMapping.ColumnMappings.Add("Storage", "Storage");
- 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].[Book] WHERE (([ID] = @Original_ID) AND ([ISBN] = @Original_ISBN) AND ([Name] = @Original_Name) AND ((@IsNull_Author = 1 AND [Author] IS NULL) OR ([Author] = @Original_Author)) AND ((@IsNull_Press = 1 AND [Press] IS NULL) OR ([Press] = @Original_Press)) AND ((@IsNull_PublishDate = 1 AND [PublishDate] IS NULL) OR ([PublishDate] = @Original_PublishDate)) AND ([Price] = @Original_Price) AND ((@IsNull_Pages = 1 AND [Pages] IS NULL) OR ([Pages] = @Original_Pages)) AND ([Barcode] = @Original_Barcode) AND ((@IsNull_CD = 1 AND [CD] IS NULL) OR ([CD] = @Original_CD)) AND ([Storage] = @Original_Storage))";
- this._adapter.DeleteCommand.CommandType = System.Data.CommandType.Text;
- this._adapter.DeleteCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ID", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "ID", System.Data.DataRowVersion.Original, false, null, "", "", ""));
- this._adapter.DeleteCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ISBN", System.Data.SqlDbType.NChar, 0, System.Data.ParameterDirection.Input, 0, 0, "ISBN", System.Data.DataRowVersion.Original, false, null, "", "", ""));
- this._adapter.DeleteCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Name", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "Name", System.Data.DataRowVersion.Original, false, null, "", "", ""));
- this._adapter.DeleteCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsNull_Author", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "Author", System.Data.DataRowVersion.Original, true, null, "", "", ""));
- this._adapter.DeleteCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Author", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "Author", System.Data.DataRowVersion.Original, false, null, "", "", ""));
- this._adapter.DeleteCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsNull_Press", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "Press", System.Data.DataRowVersion.Original, true, null, "", "", ""));
- this._adapter.DeleteCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Press", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "Press", System.Data.DataRowVersion.Original, false, null, "", "", ""));
- this._adapter.DeleteCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsNull_PublishDate", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "PublishDate", System.Data.DataRowVersion.Original, true, null, "", "", ""));
- this._adapter.DeleteCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_PublishDate", System.Data.SqlDbType.SmallDateTime, 0, System.Data.ParameterDirection.Input, 0, 0, "PublishDate", System.Data.DataRowVersion.Original, false, null, "", "", ""));
- this._adapter.DeleteCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Price", System.Data.SqlDbType.SmallMoney, 0, System.Data.ParameterDirection.Input, 0, 0, "Price", System.Data.DataRowVersion.Original, false, null, "", "", ""));
- this._adapter.DeleteCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsNull_Pages", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "Pages", System.Data.DataRowVersion.Original, true, null, "", "", ""));
- this._adapter.DeleteCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Pages", System.Data.SqlDbType.SmallInt, 0, System.Data.ParameterDirection.Input, 0, 0, "Pages", System.Data.DataRowVersion.Original, false, null, "", "", ""));
- this._adapter.DeleteCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Barcode", System.Data.SqlDbType.NChar, 0, System.Data.ParameterDirection.Input, 0, 0, "Barcode", System.Data.DataRowVersion.Original, false, null, "", "", ""));
- this._adapter.DeleteCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsNull_CD", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "CD", System.Data.DataRowVersion.Original, true, null, "", "", ""));
- this._adapter.DeleteCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_CD", System.Data.SqlDbType.Bit, 0, System.Data.ParameterDirection.Input, 0, 0, "CD", System.Data.DataRowVersion.Original, false, null, "", "", ""));
- this._adapter.DeleteCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Storage", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "Storage", 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].[Book] ([ISBN], [Name], [Author], [Press], [PublishDate], [Price], [Pages], [Barcode], [CD], [Storage]) VALUES (@ISBN, @Name, @Author, @Press, @PublishDate, @Price, @Pages, @Barcode, @CD, @Storage);
- SELECT ID, ISBN, Name, Author, Press, PublishDate, Price, Pages, Barcode, CD, Storage FROM Book WHERE (ID = SCOPE_IDENTITY())";
- this._adapter.InsertCommand.CommandType = System.Data.CommandType.Text;
- this._adapter.InsertCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ISBN", System.Data.SqlDbType.NChar, 0, System.Data.ParameterDirection.Input, 0, 0, "ISBN", System.Data.DataRowVersion.Current, false, null, "", "", ""));
- this._adapter.InsertCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Name", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "Name", System.Data.DataRowVersion.Current, false, null, "", "", ""));
- this._adapter.InsertCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Author", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "Author", System.Data.DataRowVersion.Current, false, null, "", "", ""));
- this._adapter.InsertCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Press", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "Press", System.Data.DataRowVersion.Current, false, null, "", "", ""));
- this._adapter.InsertCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@PublishDate", System.Data.SqlDbType.SmallDateTime, 0, System.Data.ParameterDirection.Input, 0, 0, "PublishDate", System.Data.DataRowVersion.Current, false, null, "", "", ""));
- this._adapter.InsertCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Price", System.Data.SqlDbType.SmallMoney, 0, System.Data.ParameterDirection.Input, 0, 0, "Price", System.Data.DataRowVersion.Current, false, null, "", "", ""));
- this._adapter.InsertCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Pages", System.Data.SqlDbType.SmallInt, 0, System.Data.ParameterDirection.Input, 0, 0, "Pages", System.Data.DataRowVersion.Current, false, null, "", "", ""));
- this._adapter.InsertCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Barcode", System.Data.SqlDbType.NChar, 0, System.Data.ParameterDirection.Input, 0, 0, "Barcode", System.Data.DataRowVersion.Current, false, null, "", "", ""));
- this._adapter.InsertCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@CD", System.Data.SqlDbType.Bit, 0, System.Data.ParameterDirection.Input, 0, 0, "CD", System.Data.DataRowVersion.Current, false, null, "", "", ""));
- this._adapter.InsertCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Storage", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "Storage", 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].[Book] SET [ISBN] = @ISBN, [Name] = @Name, [Author] = @Author, [Press] = @Press, [PublishDate] = @PublishDate, [Price] = @Price, [Pages] = @Pages, [Barcode] = @Barcode, [CD] = @CD, [Storage] = @Storage WHERE (([ID] = @Original_ID) AND ([ISBN] = @Original_ISBN) AND ([Name] = @Original_Name) AND ((@IsNull_Author = 1 AND [Author] IS NULL) OR ([Author] = @Original_Author)) AND ((@IsNull_Press = 1 AND [Press] IS NULL) OR ([Press] = @Original_Press)) AND ((@IsNull_PublishDate = 1 AND [PublishDate] IS NULL) OR ([PublishDate] = @Original_PublishDate)) AND ([Price] = @Original_Price) AND ((@IsNull_Pages = 1 AND [Pages] IS NULL) OR ([Pages] = @Original_Pages)) AND ([Barcode] = @Original_Barcode) AND ((@IsNull_CD = 1 AND [CD] IS NULL) OR ([CD] = @Original_CD)) AND ([Storage] = @Original_Storage));
- SELECT ID, ISBN, Name, Author, Press, PublishDate, Price, Pages, Barcode, CD, Storage FROM Book WHERE (ID = @ID)";
- this._adapter.UpdateCommand.CommandType = System.Data.CommandType.Text;
- this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ISBN", System.Data.SqlDbType.NChar, 0, System.Data.ParameterDirection.Input, 0, 0, "ISBN", System.Data.DataRowVersion.Current, false, null, "", "", ""));
- this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Name", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "Name", System.Data.DataRowVersion.Current, false, null, "", "", ""));
- this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Author", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "Author", System.Data.DataRowVersion.Current, false, null, "", "", ""));
- this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Press", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "Press", System.Data.DataRowVersion.Current, false, null, "", "", ""));
- this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@PublishDate", System.Data.SqlDbType.SmallDateTime, 0, System.Data.ParameterDirection.Input, 0, 0, "PublishDate", System.Data.DataRowVersion.Current, false, null, "", "", ""));
- this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Price", System.Data.SqlDbType.SmallMoney, 0, System.Data.ParameterDirection.Input, 0, 0, "Price", System.Data.DataRowVersion.Current, false, null, "", "", ""));
- this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Pages", System.Data.SqlDbType.SmallInt, 0, System.Data.ParameterDirection.Input, 0, 0, "Pages", System.Data.DataRowVersion.Current, false, null, "", "", ""));
- this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Barcode", System.Data.SqlDbType.NChar, 0, System.Data.ParameterDirection.Input, 0, 0, "Barcode", System.Data.DataRowVersion.Current, false, null, "", "", ""));
- this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@CD", System.Data.SqlDbType.Bit, 0, System.Data.ParameterDirection.Input, 0, 0, "CD", System.Data.DataRowVersion.Current, false, null, "", "", ""));
- this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Storage", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "Storage", System.Data.DataRowVersion.Current, false, null, "", "", ""));
- this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ID", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "ID", System.Data.DataRowVersion.Original, false, null, "", "", ""));
- this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ISBN", System.Data.SqlDbType.NChar, 0, System.Data.ParameterDirection.Input, 0, 0, "ISBN", System.Data.DataRowVersion.Original, false, null, "", "", ""));
- this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Name", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "Name", System.Data.DataRowVersion.Original, false, null, "", "", ""));
- this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsNull_Author", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "Author", System.Data.DataRowVersion.Original, true, null, "", "", ""));
- this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Author", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "Author", System.Data.DataRowVersion.Original, false, null, "", "", ""));
- this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsNull_Press", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "Press", System.Data.DataRowVersion.Original, true, null, "", "", ""));
- this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Press", System.Data.SqlDbType.NVarChar, 0, System.Data.ParameterDirection.Input, 0, 0, "Press", System.Data.DataRowVersion.Original, false, null, "", "", ""));
- this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsNull_PublishDate", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "PublishDate", System.Data.DataRowVersion.Original, true, null, "", "", ""));
- this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_PublishDate", System.Data.SqlDbType.SmallDateTime, 0, System.Data.ParameterDirection.Input, 0, 0, "PublishDate", System.Data.DataRowVersion.Original, false, null, "", "", ""));
- this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Price", System.Data.SqlDbType.SmallMoney, 0, System.Data.ParameterDirection.Input, 0, 0, "Price", System.Data.DataRowVersion.Original, false, null, "", "", ""));
- this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsNull_Pages", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "Pages", System.Data.DataRowVersion.Original, true, null, "", "", ""));
- this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Pages", System.Data.SqlDbType.SmallInt, 0, System.Data.ParameterDirection.Input, 0, 0, "Pages", System.Data.DataRowVersion.Original, false, null, "", "", ""));
- this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Barcode", System.Data.SqlDbType.NChar, 0, System.Data.ParameterDirection.Input, 0, 0, "Barcode", System.Data.DataRowVersion.Original, false, null, "", "", ""));
- this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@IsNull_CD", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "CD", System.Data.DataRowVersion.Original, true, null, "", "", ""));
- this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_CD", System.Data.SqlDbType.Bit, 0, System.Data.ParameterDirection.Input, 0, 0, "CD", System.Data.DataRowVersion.Original, false, null, "", "", ""));
- this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Storage", System.Data.SqlDbType.Int, 0, System.Data.ParameterDirection.Input, 0, 0, "Storage", System.Data.DataRowVersion.Original, false, null, "", "", ""));
- this._adapter.UpdateCommand.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, 0, 0, "ID", System.Data.DataRowVersion.Current, false, null, "", "", ""));
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- private void InitConnection() {
- this._connection = new System.Data.SqlClient.SqlConnection();
- this._connection.ConnectionString = global::BookStoreMan.Properties.Settings.Default.BookStoreConnectionString;
- }
- [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 ID, ISBN, Name, Author, Press, PublishDate, Price, Pages, Barcode, CD, Sto" +
- "rage FROM dbo.Book";
- 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(BookStoreDataSet.BookDataTable 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 BookStoreDataSet.BookDataTable GetData() {
- this.Adapter.SelectCommand = this.CommandCollection[0];
- BookStoreDataSet.BookDataTable dataTable = new BookStoreDataSet.BookDataTable();
- this.Adapter.Fill(dataTable);
- return dataTable;
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
- public virtual int Update(BookStoreDataSet.BookDataTable dataTable) {
- return this.Adapter.Update(dataTable);
- }
- [System.Diagnostics.DebuggerNonUserCodeAttribute()]
- [System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
- public virtual int Update(BookStoreDataSet dataSet) {
- return this.Adapter.Update(dataSet, "Book");
- }