BookStoreDataSet.Designer.cs
上传用户:xyl529207
上传日期:2022-08-03
资源大小:935k
文件大小:277k
源码类别:

行业应用

开发平台:

SQL

  1.             }
  2.             
  3.             public event V_BookSellRowChangeEventHandler V_BookSellRowChanging;
  4.             
  5.             public event V_BookSellRowChangeEventHandler V_BookSellRowChanged;
  6.             
  7.             public event V_BookSellRowChangeEventHandler V_BookSellRowDeleting;
  8.             
  9.             public event V_BookSellRowChangeEventHandler V_BookSellRowDeleted;
  10.             
  11.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  12.             public void AddV_BookSellRow(V_BookSellRow row) {
  13.                 this.Rows.Add(row);
  14.             }
  15.             
  16.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  17.             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) {
  18.                 V_BookSellRow rowV_BookSellRow = ((V_BookSellRow)(this.NewRow()));
  19.                 rowV_BookSellRow.ItemArray = new object[] {
  20.                         ID,
  21.                         CustomerID,
  22.                         Time,
  23.                         ISBN,
  24.                         Name,
  25.                         Press,
  26.                         Price,
  27.                         Number,
  28.                         Discount,
  29.                         Sum,
  30.                         SellID};
  31.                 this.Rows.Add(rowV_BookSellRow);
  32.                 return rowV_BookSellRow;
  33.             }
  34.             
  35.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  36.             public V_BookSellRow FindByID(int ID) {
  37.                 return ((V_BookSellRow)(this.Rows.Find(new object[] {
  38.                             ID})));
  39.             }
  40.             
  41.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  42.             public virtual System.Collections.IEnumerator GetEnumerator() {
  43.                 return this.Rows.GetEnumerator();
  44.             }
  45.             
  46.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  47.             public override System.Data.DataTable Clone() {
  48.                 V_BookSellDataTable cln = ((V_BookSellDataTable)(base.Clone()));
  49.                 cln.InitVars();
  50.                 return cln;
  51.             }
  52.             
  53.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  54.             protected override System.Data.DataTable CreateInstance() {
  55.                 return new V_BookSellDataTable();
  56.             }
  57.             
  58.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  59.             internal void InitVars() {
  60.                 this.columnID = base.Columns["ID"];
  61.                 this.columnCustomerID = base.Columns["CustomerID"];
  62.                 this.columnTime = base.Columns["Time"];
  63.                 this.columnISBN = base.Columns["ISBN"];
  64.                 this.columnName = base.Columns["Name"];
  65.                 this.columnPress = base.Columns["Press"];
  66.                 this.columnPrice = base.Columns["Price"];
  67.                 this.columnNumber = base.Columns["Number"];
  68.                 this.columnDiscount = base.Columns["Discount"];
  69.                 this.columnSum = base.Columns["Sum"];
  70.                 this.columnSellID = base.Columns["SellID"];
  71.             }
  72.             
  73.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  74.             private void InitClass() {
  75.                 this.columnID = new System.Data.DataColumn("ID", typeof(int), null, System.Data.MappingType.Element);
  76.                 base.Columns.Add(this.columnID);
  77.                 this.columnCustomerID = new System.Data.DataColumn("CustomerID", typeof(int), null, System.Data.MappingType.Element);
  78.                 base.Columns.Add(this.columnCustomerID);
  79.                 this.columnTime = new System.Data.DataColumn("Time", typeof(System.DateTime), null, System.Data.MappingType.Element);
  80.                 base.Columns.Add(this.columnTime);
  81.                 this.columnISBN = new System.Data.DataColumn("ISBN", typeof(string), null, System.Data.MappingType.Element);
  82.                 base.Columns.Add(this.columnISBN);
  83.                 this.columnName = new System.Data.DataColumn("Name", typeof(string), null, System.Data.MappingType.Element);
  84.                 base.Columns.Add(this.columnName);
  85.                 this.columnPress = new System.Data.DataColumn("Press", typeof(string), null, System.Data.MappingType.Element);
  86.                 base.Columns.Add(this.columnPress);
  87.                 this.columnPrice = new System.Data.DataColumn("Price", typeof(decimal), null, System.Data.MappingType.Element);
  88.                 base.Columns.Add(this.columnPrice);
  89.                 this.columnNumber = new System.Data.DataColumn("Number", typeof(int), null, System.Data.MappingType.Element);
  90.                 base.Columns.Add(this.columnNumber);
  91.                 this.columnDiscount = new System.Data.DataColumn("Discount", typeof(double), null, System.Data.MappingType.Element);
  92.                 base.Columns.Add(this.columnDiscount);
  93.                 this.columnSum = new System.Data.DataColumn("Sum", typeof(decimal), null, System.Data.MappingType.Element);
  94.                 base.Columns.Add(this.columnSum);
  95.                 this.columnSellID = new System.Data.DataColumn("SellID", typeof(int), null, System.Data.MappingType.Element);
  96.                 base.Columns.Add(this.columnSellID);
  97.                 this.Constraints.Add(new System.Data.UniqueConstraint("Constraint1", new System.Data.DataColumn[] {
  98.                                 this.columnID}, true));
  99.                 this.columnID.AllowDBNull = false;
  100.                 this.columnID.Unique = true;
  101.                 this.columnTime.AllowDBNull = false;
  102.                 this.columnISBN.AllowDBNull = false;
  103.                 this.columnISBN.MaxLength = 10;
  104.                 this.columnName.AllowDBNull = false;
  105.                 this.columnName.MaxLength = 256;
  106.                 this.columnPress.MaxLength = 50;
  107.                 this.columnPrice.AllowDBNull = false;
  108.                 this.columnNumber.AllowDBNull = false;
  109.                 this.columnDiscount.AllowDBNull = false;
  110.                 this.columnSellID.AllowDBNull = false;
  111.             }
  112.             
  113.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  114.             public V_BookSellRow NewV_BookSellRow() {
  115.                 return ((V_BookSellRow)(this.NewRow()));
  116.             }
  117.             
  118.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  119.             protected override System.Data.DataRow NewRowFromBuilder(System.Data.DataRowBuilder builder) {
  120.                 return new V_BookSellRow(builder);
  121.             }
  122.             
  123.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  124.             protected override System.Type GetRowType() {
  125.                 return typeof(V_BookSellRow);
  126.             }
  127.             
  128.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  129.             protected override void OnRowChanged(System.Data.DataRowChangeEventArgs e) {
  130.                 base.OnRowChanged(e);
  131.                 if ((this.V_BookSellRowChanged != null)) {
  132.                     this.V_BookSellRowChanged(this, new V_BookSellRowChangeEvent(((V_BookSellRow)(e.Row)), e.Action));
  133.                 }
  134.             }
  135.             
  136.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  137.             protected override void OnRowChanging(System.Data.DataRowChangeEventArgs e) {
  138.                 base.OnRowChanging(e);
  139.                 if ((this.V_BookSellRowChanging != null)) {
  140.                     this.V_BookSellRowChanging(this, new V_BookSellRowChangeEvent(((V_BookSellRow)(e.Row)), e.Action));
  141.                 }
  142.             }
  143.             
  144.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  145.             protected override void OnRowDeleted(System.Data.DataRowChangeEventArgs e) {
  146.                 base.OnRowDeleted(e);
  147.                 if ((this.V_BookSellRowDeleted != null)) {
  148.                     this.V_BookSellRowDeleted(this, new V_BookSellRowChangeEvent(((V_BookSellRow)(e.Row)), e.Action));
  149.                 }
  150.             }
  151.             
  152.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  153.             protected override void OnRowDeleting(System.Data.DataRowChangeEventArgs e) {
  154.                 base.OnRowDeleting(e);
  155.                 if ((this.V_BookSellRowDeleting != null)) {
  156.                     this.V_BookSellRowDeleting(this, new V_BookSellRowChangeEvent(((V_BookSellRow)(e.Row)), e.Action));
  157.                 }
  158.             }
  159.             
  160.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  161.             public void RemoveV_BookSellRow(V_BookSellRow row) {
  162.                 this.Rows.Remove(row);
  163.             }
  164.             
  165.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  166.             public static System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(System.Xml.Schema.XmlSchemaSet xs) {
  167.                 System.Xml.Schema.XmlSchemaComplexType type = new System.Xml.Schema.XmlSchemaComplexType();
  168.                 System.Xml.Schema.XmlSchemaSequence sequence = new System.Xml.Schema.XmlSchemaSequence();
  169.                 BookStoreDataSet ds = new BookStoreDataSet();
  170.                 xs.Add(ds.GetSchemaSerializable());
  171.                 System.Xml.Schema.XmlSchemaAny any1 = new System.Xml.Schema.XmlSchemaAny();
  172.                 any1.Namespace = "http://www.w3.org/2001/XMLSchema";
  173.                 any1.MinOccurs = new decimal(0);
  174.                 any1.MaxOccurs = decimal.MaxValue;
  175.                 any1.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax;
  176.                 sequence.Items.Add(any1);
  177.                 System.Xml.Schema.XmlSchemaAny any2 = new System.Xml.Schema.XmlSchemaAny();
  178.                 any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
  179.                 any2.MinOccurs = new decimal(1);
  180.                 any2.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax;
  181.                 sequence.Items.Add(any2);
  182.                 System.Xml.Schema.XmlSchemaAttribute attribute1 = new System.Xml.Schema.XmlSchemaAttribute();
  183.                 attribute1.Name = "namespace";
  184.                 attribute1.FixedValue = ds.Namespace;
  185.                 type.Attributes.Add(attribute1);
  186.                 System.Xml.Schema.XmlSchemaAttribute attribute2 = new System.Xml.Schema.XmlSchemaAttribute();
  187.                 attribute2.Name = "tableTypeName";
  188.                 attribute2.FixedValue = "V_BookSellDataTable";
  189.                 type.Attributes.Add(attribute2);
  190.                 type.Particle = sequence;
  191.                 return type;
  192.             }
  193.         }
  194.         
  195.         [System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
  196.         [System.Serializable()]
  197.         [System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedTableSchema")]
  198.         public partial class P_GetSellDetailDataTable : System.Data.DataTable, System.Collections.IEnumerable {
  199.             
  200.             private System.Data.DataColumn columnBookID;
  201.             
  202.             private System.Data.DataColumn columnISBN;
  203.             
  204.             private System.Data.DataColumn columnName;
  205.             
  206.             private System.Data.DataColumn columnPrice;
  207.             
  208.             private System.Data.DataColumn columnNumber;
  209.             
  210.             private System.Data.DataColumn columnDiscount;
  211.             
  212.             private System.Data.DataColumn columnSum;
  213.             
  214.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  215.             public P_GetSellDetailDataTable() {
  216.                 this.TableName = "P_GetSellDetail";
  217.                 this.BeginInit();
  218.                 this.InitClass();
  219.                 this.EndInit();
  220.             }
  221.             
  222.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  223.             internal P_GetSellDetailDataTable(System.Data.DataTable table) {
  224.                 this.TableName = table.TableName;
  225.                 if ((table.CaseSensitive != table.DataSet.CaseSensitive)) {
  226.                     this.CaseSensitive = table.CaseSensitive;
  227.                 }
  228.                 if ((table.Locale.ToString() != table.DataSet.Locale.ToString())) {
  229.                     this.Locale = table.Locale;
  230.                 }
  231.                 if ((table.Namespace != table.DataSet.Namespace)) {
  232.                     this.Namespace = table.Namespace;
  233.                 }
  234.                 this.Prefix = table.Prefix;
  235.                 this.MinimumCapacity = table.MinimumCapacity;
  236.             }
  237.             
  238.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  239.             protected P_GetSellDetailDataTable(System.Runtime.Serialization.SerializationInfo info, System.Runtime.Serialization.StreamingContext context) : 
  240.                     base(info, context) {
  241.                 this.InitVars();
  242.             }
  243.             
  244.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  245.             public System.Data.DataColumn BookIDColumn {
  246.                 get {
  247.                     return this.columnBookID;
  248.                 }
  249.             }
  250.             
  251.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  252.             public System.Data.DataColumn ISBNColumn {
  253.                 get {
  254.                     return this.columnISBN;
  255.                 }
  256.             }
  257.             
  258.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  259.             public System.Data.DataColumn NameColumn {
  260.                 get {
  261.                     return this.columnName;
  262.                 }
  263.             }
  264.             
  265.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  266.             public System.Data.DataColumn PriceColumn {
  267.                 get {
  268.                     return this.columnPrice;
  269.                 }
  270.             }
  271.             
  272.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  273.             public System.Data.DataColumn NumberColumn {
  274.                 get {
  275.                     return this.columnNumber;
  276.                 }
  277.             }
  278.             
  279.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  280.             public System.Data.DataColumn DiscountColumn {
  281.                 get {
  282.                     return this.columnDiscount;
  283.                 }
  284.             }
  285.             
  286.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  287.             public System.Data.DataColumn SumColumn {
  288.                 get {
  289.                     return this.columnSum;
  290.                 }
  291.             }
  292.             
  293.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  294.             [System.ComponentModel.Browsable(false)]
  295.             public int Count {
  296.                 get {
  297.                     return this.Rows.Count;
  298.                 }
  299.             }
  300.             
  301.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  302.             public P_GetSellDetailRow this[int index] {
  303.                 get {
  304.                     return ((P_GetSellDetailRow)(this.Rows[index]));
  305.                 }
  306.             }
  307.             
  308.             public event P_GetSellDetailRowChangeEventHandler P_GetSellDetailRowChanging;
  309.             
  310.             public event P_GetSellDetailRowChangeEventHandler P_GetSellDetailRowChanged;
  311.             
  312.             public event P_GetSellDetailRowChangeEventHandler P_GetSellDetailRowDeleting;
  313.             
  314.             public event P_GetSellDetailRowChangeEventHandler P_GetSellDetailRowDeleted;
  315.             
  316.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  317.             public void AddP_GetSellDetailRow(P_GetSellDetailRow row) {
  318.                 this.Rows.Add(row);
  319.             }
  320.             
  321.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  322.             public P_GetSellDetailRow AddP_GetSellDetailRow(int BookID, string ISBN, string Name, decimal Price, int Number, double Discount, decimal Sum) {
  323.                 P_GetSellDetailRow rowP_GetSellDetailRow = ((P_GetSellDetailRow)(this.NewRow()));
  324.                 rowP_GetSellDetailRow.ItemArray = new object[] {
  325.                         BookID,
  326.                         ISBN,
  327.                         Name,
  328.                         Price,
  329.                         Number,
  330.                         Discount,
  331.                         Sum};
  332.                 this.Rows.Add(rowP_GetSellDetailRow);
  333.                 return rowP_GetSellDetailRow;
  334.             }
  335.             
  336.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  337.             public virtual System.Collections.IEnumerator GetEnumerator() {
  338.                 return this.Rows.GetEnumerator();
  339.             }
  340.             
  341.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  342.             public override System.Data.DataTable Clone() {
  343.                 P_GetSellDetailDataTable cln = ((P_GetSellDetailDataTable)(base.Clone()));
  344.                 cln.InitVars();
  345.                 return cln;
  346.             }
  347.             
  348.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  349.             protected override System.Data.DataTable CreateInstance() {
  350.                 return new P_GetSellDetailDataTable();
  351.             }
  352.             
  353.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  354.             internal void InitVars() {
  355.                 this.columnBookID = base.Columns["BookID"];
  356.                 this.columnISBN = base.Columns["ISBN"];
  357.                 this.columnName = base.Columns["Name"];
  358.                 this.columnPrice = base.Columns["Price"];
  359.                 this.columnNumber = base.Columns["Number"];
  360.                 this.columnDiscount = base.Columns["Discount"];
  361.                 this.columnSum = base.Columns["Sum"];
  362.             }
  363.             
  364.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  365.             private void InitClass() {
  366.                 this.columnBookID = new System.Data.DataColumn("BookID", typeof(int), null, System.Data.MappingType.Element);
  367.                 base.Columns.Add(this.columnBookID);
  368.                 this.columnISBN = new System.Data.DataColumn("ISBN", typeof(string), null, System.Data.MappingType.Element);
  369.                 base.Columns.Add(this.columnISBN);
  370.                 this.columnName = new System.Data.DataColumn("Name", typeof(string), null, System.Data.MappingType.Element);
  371.                 base.Columns.Add(this.columnName);
  372.                 this.columnPrice = new System.Data.DataColumn("Price", typeof(decimal), null, System.Data.MappingType.Element);
  373.                 base.Columns.Add(this.columnPrice);
  374.                 this.columnNumber = new System.Data.DataColumn("Number", typeof(int), null, System.Data.MappingType.Element);
  375.                 base.Columns.Add(this.columnNumber);
  376.                 this.columnDiscount = new System.Data.DataColumn("Discount", typeof(double), null, System.Data.MappingType.Element);
  377.                 base.Columns.Add(this.columnDiscount);
  378.                 this.columnSum = new System.Data.DataColumn("Sum", typeof(decimal), null, System.Data.MappingType.Element);
  379.                 base.Columns.Add(this.columnSum);
  380.                 this.columnBookID.AllowDBNull = false;
  381.                 this.columnISBN.AllowDBNull = false;
  382.                 this.columnISBN.MaxLength = 10;
  383.                 this.columnName.AllowDBNull = false;
  384.                 this.columnName.MaxLength = 256;
  385.                 this.columnPrice.AllowDBNull = false;
  386.                 this.columnNumber.AllowDBNull = false;
  387.                 this.columnDiscount.AllowDBNull = false;
  388.             }
  389.             
  390.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  391.             public P_GetSellDetailRow NewP_GetSellDetailRow() {
  392.                 return ((P_GetSellDetailRow)(this.NewRow()));
  393.             }
  394.             
  395.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  396.             protected override System.Data.DataRow NewRowFromBuilder(System.Data.DataRowBuilder builder) {
  397.                 return new P_GetSellDetailRow(builder);
  398.             }
  399.             
  400.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  401.             protected override System.Type GetRowType() {
  402.                 return typeof(P_GetSellDetailRow);
  403.             }
  404.             
  405.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  406.             protected override void OnRowChanged(System.Data.DataRowChangeEventArgs e) {
  407.                 base.OnRowChanged(e);
  408.                 if ((this.P_GetSellDetailRowChanged != null)) {
  409.                     this.P_GetSellDetailRowChanged(this, new P_GetSellDetailRowChangeEvent(((P_GetSellDetailRow)(e.Row)), e.Action));
  410.                 }
  411.             }
  412.             
  413.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  414.             protected override void OnRowChanging(System.Data.DataRowChangeEventArgs e) {
  415.                 base.OnRowChanging(e);
  416.                 if ((this.P_GetSellDetailRowChanging != null)) {
  417.                     this.P_GetSellDetailRowChanging(this, new P_GetSellDetailRowChangeEvent(((P_GetSellDetailRow)(e.Row)), e.Action));
  418.                 }
  419.             }
  420.             
  421.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  422.             protected override void OnRowDeleted(System.Data.DataRowChangeEventArgs e) {
  423.                 base.OnRowDeleted(e);
  424.                 if ((this.P_GetSellDetailRowDeleted != null)) {
  425.                     this.P_GetSellDetailRowDeleted(this, new P_GetSellDetailRowChangeEvent(((P_GetSellDetailRow)(e.Row)), e.Action));
  426.                 }
  427.             }
  428.             
  429.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  430.             protected override void OnRowDeleting(System.Data.DataRowChangeEventArgs e) {
  431.                 base.OnRowDeleting(e);
  432.                 if ((this.P_GetSellDetailRowDeleting != null)) {
  433.                     this.P_GetSellDetailRowDeleting(this, new P_GetSellDetailRowChangeEvent(((P_GetSellDetailRow)(e.Row)), e.Action));
  434.                 }
  435.             }
  436.             
  437.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  438.             public void RemoveP_GetSellDetailRow(P_GetSellDetailRow row) {
  439.                 this.Rows.Remove(row);
  440.             }
  441.             
  442.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  443.             public static System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(System.Xml.Schema.XmlSchemaSet xs) {
  444.                 System.Xml.Schema.XmlSchemaComplexType type = new System.Xml.Schema.XmlSchemaComplexType();
  445.                 System.Xml.Schema.XmlSchemaSequence sequence = new System.Xml.Schema.XmlSchemaSequence();
  446.                 BookStoreDataSet ds = new BookStoreDataSet();
  447.                 xs.Add(ds.GetSchemaSerializable());
  448.                 System.Xml.Schema.XmlSchemaAny any1 = new System.Xml.Schema.XmlSchemaAny();
  449.                 any1.Namespace = "http://www.w3.org/2001/XMLSchema";
  450.                 any1.MinOccurs = new decimal(0);
  451.                 any1.MaxOccurs = decimal.MaxValue;
  452.                 any1.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax;
  453.                 sequence.Items.Add(any1);
  454.                 System.Xml.Schema.XmlSchemaAny any2 = new System.Xml.Schema.XmlSchemaAny();
  455.                 any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
  456.                 any2.MinOccurs = new decimal(1);
  457.                 any2.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax;
  458.                 sequence.Items.Add(any2);
  459.                 System.Xml.Schema.XmlSchemaAttribute attribute1 = new System.Xml.Schema.XmlSchemaAttribute();
  460.                 attribute1.Name = "namespace";
  461.                 attribute1.FixedValue = ds.Namespace;
  462.                 type.Attributes.Add(attribute1);
  463.                 System.Xml.Schema.XmlSchemaAttribute attribute2 = new System.Xml.Schema.XmlSchemaAttribute();
  464.                 attribute2.Name = "tableTypeName";
  465.                 attribute2.FixedValue = "P_GetSellDetailDataTable";
  466.                 type.Attributes.Add(attribute2);
  467.                 type.Particle = sequence;
  468.                 return type;
  469.             }
  470.         }
  471.         
  472.         [System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
  473.         public partial class BookRow : System.Data.DataRow {
  474.             
  475.             private BookDataTable tableBook;
  476.             
  477.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  478.             internal BookRow(System.Data.DataRowBuilder rb) : 
  479.                     base(rb) {
  480.                 this.tableBook = ((BookDataTable)(this.Table));
  481.             }
  482.             
  483.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  484.             public int ID {
  485.                 get {
  486.                     return ((int)(this[this.tableBook.IDColumn]));
  487.                 }
  488.                 set {
  489.                     this[this.tableBook.IDColumn] = value;
  490.                 }
  491.             }
  492.             
  493.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  494.             public string ISBN {
  495.                 get {
  496.                     return ((string)(this[this.tableBook.ISBNColumn]));
  497.                 }
  498.                 set {
  499.                     this[this.tableBook.ISBNColumn] = value;
  500.                 }
  501.             }
  502.             
  503.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  504.             public string Name {
  505.                 get {
  506.                     return ((string)(this[this.tableBook.NameColumn]));
  507.                 }
  508.                 set {
  509.                     this[this.tableBook.NameColumn] = value;
  510.                 }
  511.             }
  512.             
  513.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  514.             public string Author {
  515.                 get {
  516.                     try {
  517.                         return ((string)(this[this.tableBook.AuthorColumn]));
  518.                     }
  519.                     catch (System.InvalidCastException e) {
  520.                         throw new System.Data.StrongTypingException("表“Book”中列“Author”的值为 DBNull。", e);
  521.                     }
  522.                 }
  523.                 set {
  524.                     this[this.tableBook.AuthorColumn] = value;
  525.                 }
  526.             }
  527.             
  528.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  529.             public string Press {
  530.                 get {
  531.                     try {
  532.                         return ((string)(this[this.tableBook.PressColumn]));
  533.                     }
  534.                     catch (System.InvalidCastException e) {
  535.                         throw new System.Data.StrongTypingException("表“Book”中列“Press”的值为 DBNull。", e);
  536.                     }
  537.                 }
  538.                 set {
  539.                     this[this.tableBook.PressColumn] = value;
  540.                 }
  541.             }
  542.             
  543.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  544.             public System.DateTime PublishDate {
  545.                 get {
  546.                     try {
  547.                         return ((System.DateTime)(this[this.tableBook.PublishDateColumn]));
  548.                     }
  549.                     catch (System.InvalidCastException e) {
  550.                         throw new System.Data.StrongTypingException("表“Book”中列“PublishDate”的值为 DBNull。", e);
  551.                     }
  552.                 }
  553.                 set {
  554.                     this[this.tableBook.PublishDateColumn] = value;
  555.                 }
  556.             }
  557.             
  558.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  559.             public decimal Price {
  560.                 get {
  561.                     return ((decimal)(this[this.tableBook.PriceColumn]));
  562.                 }
  563.                 set {
  564.                     this[this.tableBook.PriceColumn] = value;
  565.                 }
  566.             }
  567.             
  568.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  569.             public short Pages {
  570.                 get {
  571.                     try {
  572.                         return ((short)(this[this.tableBook.PagesColumn]));
  573.                     }
  574.                     catch (System.InvalidCastException e) {
  575.                         throw new System.Data.StrongTypingException("表“Book”中列“Pages”的值为 DBNull。", e);
  576.                     }
  577.                 }
  578.                 set {
  579.                     this[this.tableBook.PagesColumn] = value;
  580.                 }
  581.             }
  582.             
  583.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  584.             public string Barcode {
  585.                 get {
  586.                     return ((string)(this[this.tableBook.BarcodeColumn]));
  587.                 }
  588.                 set {
  589.                     this[this.tableBook.BarcodeColumn] = value;
  590.                 }
  591.             }
  592.             
  593.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  594.             public bool CD {
  595.                 get {
  596.                     try {
  597.                         return ((bool)(this[this.tableBook.CDColumn]));
  598.                     }
  599.                     catch (System.InvalidCastException e) {
  600.                         throw new System.Data.StrongTypingException("表“Book”中列“CD”的值为 DBNull。", e);
  601.                     }
  602.                 }
  603.                 set {
  604.                     this[this.tableBook.CDColumn] = value;
  605.                 }
  606.             }
  607.             
  608.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  609.             public int Storage {
  610.                 get {
  611.                     return ((int)(this[this.tableBook.StorageColumn]));
  612.                 }
  613.                 set {
  614.                     this[this.tableBook.StorageColumn] = value;
  615.                 }
  616.             }
  617.             
  618.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  619.             public bool IsAuthorNull() {
  620.                 return this.IsNull(this.tableBook.AuthorColumn);
  621.             }
  622.             
  623.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  624.             public void SetAuthorNull() {
  625.                 this[this.tableBook.AuthorColumn] = System.Convert.DBNull;
  626.             }
  627.             
  628.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  629.             public bool IsPressNull() {
  630.                 return this.IsNull(this.tableBook.PressColumn);
  631.             }
  632.             
  633.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  634.             public void SetPressNull() {
  635.                 this[this.tableBook.PressColumn] = System.Convert.DBNull;
  636.             }
  637.             
  638.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  639.             public bool IsPublishDateNull() {
  640.                 return this.IsNull(this.tableBook.PublishDateColumn);
  641.             }
  642.             
  643.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  644.             public void SetPublishDateNull() {
  645.                 this[this.tableBook.PublishDateColumn] = System.Convert.DBNull;
  646.             }
  647.             
  648.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  649.             public bool IsPagesNull() {
  650.                 return this.IsNull(this.tableBook.PagesColumn);
  651.             }
  652.             
  653.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  654.             public void SetPagesNull() {
  655.                 this[this.tableBook.PagesColumn] = System.Convert.DBNull;
  656.             }
  657.             
  658.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  659.             public bool IsCDNull() {
  660.                 return this.IsNull(this.tableBook.CDColumn);
  661.             }
  662.             
  663.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  664.             public void SetCDNull() {
  665.                 this[this.tableBook.CDColumn] = System.Convert.DBNull;
  666.             }
  667.             
  668.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  669.             public SellItemRow[] GetSellItemRows() {
  670.                 return ((SellItemRow[])(base.GetChildRows(this.Table.ChildRelations["FK_SellItem_Book"])));
  671.             }
  672.         }
  673.         
  674.         [System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
  675.         public partial class CustomerRow : System.Data.DataRow {
  676.             
  677.             private CustomerDataTable tableCustomer;
  678.             
  679.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  680.             internal CustomerRow(System.Data.DataRowBuilder rb) : 
  681.                     base(rb) {
  682.                 this.tableCustomer = ((CustomerDataTable)(this.Table));
  683.             }
  684.             
  685.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  686.             public int ID {
  687.                 get {
  688.                     return ((int)(this[this.tableCustomer.IDColumn]));
  689.                 }
  690.                 set {
  691.                     this[this.tableCustomer.IDColumn] = value;
  692.                 }
  693.             }
  694.             
  695.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  696.             public string Name {
  697.                 get {
  698.                     return ((string)(this[this.tableCustomer.NameColumn]));
  699.                 }
  700.                 set {
  701.                     this[this.tableCustomer.NameColumn] = value;
  702.                 }
  703.             }
  704.             
  705.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  706.             public short Levels {
  707.                 get {
  708.                     return ((short)(this[this.tableCustomer.LevelsColumn]));
  709.                 }
  710.                 set {
  711.                     this[this.tableCustomer.LevelsColumn] = value;
  712.                 }
  713.             }
  714.             
  715.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  716.             public bool Gender {
  717.                 get {
  718.                     try {
  719.                         return ((bool)(this[this.tableCustomer.GenderColumn]));
  720.                     }
  721.                     catch (System.InvalidCastException e) {
  722.                         throw new System.Data.StrongTypingException("表“Customer”中列“Gender”的值为 DBNull。", e);
  723.                     }
  724.                 }
  725.                 set {
  726.                     this[this.tableCustomer.GenderColumn] = value;
  727.                 }
  728.             }
  729.             
  730.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  731.             public System.DateTime Birthday {
  732.                 get {
  733.                     try {
  734.                         return ((System.DateTime)(this[this.tableCustomer.BirthdayColumn]));
  735.                     }
  736.                     catch (System.InvalidCastException e) {
  737.                         throw new System.Data.StrongTypingException("表“Customer”中列“Birthday”的值为 DBNull。", e);
  738.                     }
  739.                 }
  740.                 set {
  741.                     this[this.tableCustomer.BirthdayColumn] = value;
  742.                 }
  743.             }
  744.             
  745.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  746.             public string Degree {
  747.                 get {
  748.                     try {
  749.                         return ((string)(this[this.tableCustomer.DegreeColumn]));
  750.                     }
  751.                     catch (System.InvalidCastException e) {
  752.                         throw new System.Data.StrongTypingException("表“Customer”中列“Degree”的值为 DBNull。", e);
  753.                     }
  754.                 }
  755.                 set {
  756.                     this[this.tableCustomer.DegreeColumn] = value;
  757.                 }
  758.             }
  759.             
  760.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  761.             public string Address {
  762.                 get {
  763.                     try {
  764.                         return ((string)(this[this.tableCustomer.AddressColumn]));
  765.                     }
  766.                     catch (System.InvalidCastException e) {
  767.                         throw new System.Data.StrongTypingException("表“Customer”中列“Address”的值为 DBNull。", e);
  768.                     }
  769.                 }
  770.                 set {
  771.                     this[this.tableCustomer.AddressColumn] = value;
  772.                 }
  773.             }
  774.             
  775.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  776.             public string Telephone {
  777.                 get {
  778.                     try {
  779.                         return ((string)(this[this.tableCustomer.TelephoneColumn]));
  780.                     }
  781.                     catch (System.InvalidCastException e) {
  782.                         throw new System.Data.StrongTypingException("表“Customer”中列“Telephone”的值为 DBNull。", e);
  783.                     }
  784.                 }
  785.                 set {
  786.                     this[this.tableCustomer.TelephoneColumn] = value;
  787.                 }
  788.             }
  789.             
  790.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  791.             public string Email {
  792.                 get {
  793.                     try {
  794.                         return ((string)(this[this.tableCustomer.EmailColumn]));
  795.                     }
  796.                     catch (System.InvalidCastException e) {
  797.                         throw new System.Data.StrongTypingException("表“Customer”中列“Email”的值为 DBNull。", e);
  798.                     }
  799.                 }
  800.                 set {
  801.                     this[this.tableCustomer.EmailColumn] = value;
  802.                 }
  803.             }
  804.             
  805.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  806.             public int Score {
  807.                 get {
  808.                     try {
  809.                         return ((int)(this[this.tableCustomer.ScoreColumn]));
  810.                     }
  811.                     catch (System.InvalidCastException e) {
  812.                         throw new System.Data.StrongTypingException("表“Customer”中列“Score”的值为 DBNull。", e);
  813.                     }
  814.                 }
  815.                 set {
  816.                     this[this.tableCustomer.ScoreColumn] = value;
  817.                 }
  818.             }
  819.             
  820.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  821.             public bool IsGenderNull() {
  822.                 return this.IsNull(this.tableCustomer.GenderColumn);
  823.             }
  824.             
  825.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  826.             public void SetGenderNull() {
  827.                 this[this.tableCustomer.GenderColumn] = System.Convert.DBNull;
  828.             }
  829.             
  830.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  831.             public bool IsBirthdayNull() {
  832.                 return this.IsNull(this.tableCustomer.BirthdayColumn);
  833.             }
  834.             
  835.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  836.             public void SetBirthdayNull() {
  837.                 this[this.tableCustomer.BirthdayColumn] = System.Convert.DBNull;
  838.             }
  839.             
  840.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  841.             public bool IsDegreeNull() {
  842.                 return this.IsNull(this.tableCustomer.DegreeColumn);
  843.             }
  844.             
  845.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  846.             public void SetDegreeNull() {
  847.                 this[this.tableCustomer.DegreeColumn] = System.Convert.DBNull;
  848.             }
  849.             
  850.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  851.             public bool IsAddressNull() {
  852.                 return this.IsNull(this.tableCustomer.AddressColumn);
  853.             }
  854.             
  855.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  856.             public void SetAddressNull() {
  857.                 this[this.tableCustomer.AddressColumn] = System.Convert.DBNull;
  858.             }
  859.             
  860.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  861.             public bool IsTelephoneNull() {
  862.                 return this.IsNull(this.tableCustomer.TelephoneColumn);
  863.             }
  864.             
  865.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  866.             public void SetTelephoneNull() {
  867.                 this[this.tableCustomer.TelephoneColumn] = System.Convert.DBNull;
  868.             }
  869.             
  870.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  871.             public bool IsEmailNull() {
  872.                 return this.IsNull(this.tableCustomer.EmailColumn);
  873.             }
  874.             
  875.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  876.             public void SetEmailNull() {
  877.                 this[this.tableCustomer.EmailColumn] = System.Convert.DBNull;
  878.             }
  879.             
  880.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  881.             public bool IsScoreNull() {
  882.                 return this.IsNull(this.tableCustomer.ScoreColumn);
  883.             }
  884.             
  885.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  886.             public void SetScoreNull() {
  887.                 this[this.tableCustomer.ScoreColumn] = System.Convert.DBNull;
  888.             }
  889.             
  890.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  891.             public SellRow[] GetSellRows() {
  892.                 return ((SellRow[])(base.GetChildRows(this.Table.ChildRelations["Customer_Sell"])));
  893.             }
  894.         }
  895.         
  896.         [System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
  897.         public partial class SellRow : System.Data.DataRow {
  898.             
  899.             private SellDataTable tableSell;
  900.             
  901.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  902.             internal SellRow(System.Data.DataRowBuilder rb) : 
  903.                     base(rb) {
  904.                 this.tableSell = ((SellDataTable)(this.Table));
  905.             }
  906.             
  907.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  908.             public int ID {
  909.                 get {
  910.                     return ((int)(this[this.tableSell.IDColumn]));
  911.                 }
  912.                 set {
  913.                     this[this.tableSell.IDColumn] = value;
  914.                 }
  915.             }
  916.             
  917.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  918.             public int CustomerID {
  919.                 get {
  920.                     try {
  921.                         return ((int)(this[this.tableSell.CustomerIDColumn]));
  922.                     }
  923.                     catch (System.InvalidCastException e) {
  924.                         throw new System.Data.StrongTypingException("表“Sell”中列“CustomerID”的值为 DBNull。", e);
  925.                     }
  926.                 }
  927.                 set {
  928.                     this[this.tableSell.CustomerIDColumn] = value;
  929.                 }
  930.             }
  931.             
  932.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  933.             public decimal Sum {
  934.                 get {
  935.                     return ((decimal)(this[this.tableSell.SumColumn]));
  936.                 }
  937.                 set {
  938.                     this[this.tableSell.SumColumn] = value;
  939.                 }
  940.             }
  941.             
  942.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  943.             public System.DateTime Time {
  944.                 get {
  945.                     return ((System.DateTime)(this[this.tableSell.TimeColumn]));
  946.                 }
  947.                 set {
  948.                     this[this.tableSell.TimeColumn] = value;
  949.                 }
  950.             }
  951.             
  952.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  953.             public CustomerRow CustomerRow {
  954.                 get {
  955.                     return ((CustomerRow)(this.GetParentRow(this.Table.ParentRelations["Customer_Sell"])));
  956.                 }
  957.                 set {
  958.                     this.SetParentRow(value, this.Table.ParentRelations["Customer_Sell"]);
  959.                 }
  960.             }
  961.             
  962.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  963.             public bool IsCustomerIDNull() {
  964.                 return this.IsNull(this.tableSell.CustomerIDColumn);
  965.             }
  966.             
  967.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  968.             public void SetCustomerIDNull() {
  969.                 this[this.tableSell.CustomerIDColumn] = System.Convert.DBNull;
  970.             }
  971.             
  972.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  973.             public SellItemRow[] GetSellItemRows() {
  974.                 return ((SellItemRow[])(base.GetChildRows(this.Table.ChildRelations["FK_SellItem_Sell"])));
  975.             }
  976.         }
  977.         
  978.         [System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
  979.         public partial class SellItemRow : System.Data.DataRow {
  980.             
  981.             private SellItemDataTable tableSellItem;
  982.             
  983.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  984.             internal SellItemRow(System.Data.DataRowBuilder rb) : 
  985.                     base(rb) {
  986.                 this.tableSellItem = ((SellItemDataTable)(this.Table));
  987.             }
  988.             
  989.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  990.             public int ID {
  991.                 get {
  992.                     return ((int)(this[this.tableSellItem.IDColumn]));
  993.                 }
  994.                 set {
  995.                     this[this.tableSellItem.IDColumn] = value;
  996.                 }
  997.             }
  998.             
  999.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1000.             public int SellID {
  1001.                 get {
  1002.                     return ((int)(this[this.tableSellItem.SellIDColumn]));
  1003.                 }
  1004.                 set {
  1005.                     this[this.tableSellItem.SellIDColumn] = value;
  1006.                 }
  1007.             }
  1008.             
  1009.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1010.             public int BookID {
  1011.                 get {
  1012.                     return ((int)(this[this.tableSellItem.BookIDColumn]));
  1013.                 }
  1014.                 set {
  1015.                     this[this.tableSellItem.BookIDColumn] = value;
  1016.                 }
  1017.             }
  1018.             
  1019.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1020.             public int Number {
  1021.                 get {
  1022.                     return ((int)(this[this.tableSellItem.NumberColumn]));
  1023.                 }
  1024.                 set {
  1025.                     this[this.tableSellItem.NumberColumn] = value;
  1026.                 }
  1027.             }
  1028.             
  1029.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1030.             public double Discount {
  1031.                 get {
  1032.                     return ((double)(this[this.tableSellItem.DiscountColumn]));
  1033.                 }
  1034.                 set {
  1035.                     this[this.tableSellItem.DiscountColumn] = value;
  1036.                 }
  1037.             }
  1038.             
  1039.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1040.             public decimal Sum {
  1041.                 get {
  1042.                     try {
  1043.                         return ((decimal)(this[this.tableSellItem.SumColumn]));
  1044.                     }
  1045.                     catch (System.InvalidCastException e) {
  1046.                         throw new System.Data.StrongTypingException("表“SellItem”中列“Sum”的值为 DBNull。", e);
  1047.                     }
  1048.                 }
  1049.                 set {
  1050.                     this[this.tableSellItem.SumColumn] = value;
  1051.                 }
  1052.             }
  1053.             
  1054.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1055.             public BookRow BookRow {
  1056.                 get {
  1057.                     return ((BookRow)(this.GetParentRow(this.Table.ParentRelations["FK_SellItem_Book"])));
  1058.                 }
  1059.                 set {
  1060.                     this.SetParentRow(value, this.Table.ParentRelations["FK_SellItem_Book"]);
  1061.                 }
  1062.             }
  1063.             
  1064.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1065.             public SellRow SellRow {
  1066.                 get {
  1067.                     return ((SellRow)(this.GetParentRow(this.Table.ParentRelations["FK_SellItem_Sell"])));
  1068.                 }
  1069.                 set {
  1070.                     this.SetParentRow(value, this.Table.ParentRelations["FK_SellItem_Sell"]);
  1071.                 }
  1072.             }
  1073.             
  1074.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1075.             public bool IsSumNull() {
  1076.                 return this.IsNull(this.tableSellItem.SumColumn);
  1077.             }
  1078.             
  1079.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1080.             public void SetSumNull() {
  1081.                 this[this.tableSellItem.SumColumn] = System.Convert.DBNull;
  1082.             }
  1083.         }
  1084.         
  1085.         [System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
  1086.         public partial class V_BookSellRow : System.Data.DataRow {
  1087.             
  1088.             private V_BookSellDataTable tableV_BookSell;
  1089.             
  1090.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1091.             internal V_BookSellRow(System.Data.DataRowBuilder rb) : 
  1092.                     base(rb) {
  1093.                 this.tableV_BookSell = ((V_BookSellDataTable)(this.Table));
  1094.             }
  1095.             
  1096.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1097.             public int ID {
  1098.                 get {
  1099.                     return ((int)(this[this.tableV_BookSell.IDColumn]));
  1100.                 }
  1101.                 set {
  1102.                     this[this.tableV_BookSell.IDColumn] = value;
  1103.                 }
  1104.             }
  1105.             
  1106.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1107.             public int CustomerID {
  1108.                 get {
  1109.                     try {
  1110.                         return ((int)(this[this.tableV_BookSell.CustomerIDColumn]));
  1111.                     }
  1112.                     catch (System.InvalidCastException e) {
  1113.                         throw new System.Data.StrongTypingException("表“V_BookSell”中列“CustomerID”的值为 DBNull。", e);
  1114.                     }
  1115.                 }
  1116.                 set {
  1117.                     this[this.tableV_BookSell.CustomerIDColumn] = value;
  1118.                 }
  1119.             }
  1120.             
  1121.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1122.             public System.DateTime Time {
  1123.                 get {
  1124.                     return ((System.DateTime)(this[this.tableV_BookSell.TimeColumn]));
  1125.                 }
  1126.                 set {
  1127.                     this[this.tableV_BookSell.TimeColumn] = value;
  1128.                 }
  1129.             }
  1130.             
  1131.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1132.             public string ISBN {
  1133.                 get {
  1134.                     return ((string)(this[this.tableV_BookSell.ISBNColumn]));
  1135.                 }
  1136.                 set {
  1137.                     this[this.tableV_BookSell.ISBNColumn] = value;
  1138.                 }
  1139.             }
  1140.             
  1141.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1142.             public string Name {
  1143.                 get {
  1144.                     return ((string)(this[this.tableV_BookSell.NameColumn]));
  1145.                 }
  1146.                 set {
  1147.                     this[this.tableV_BookSell.NameColumn] = value;
  1148.                 }
  1149.             }
  1150.             
  1151.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1152.             public string Press {
  1153.                 get {
  1154.                     try {
  1155.                         return ((string)(this[this.tableV_BookSell.PressColumn]));
  1156.                     }
  1157.                     catch (System.InvalidCastException e) {
  1158.                         throw new System.Data.StrongTypingException("表“V_BookSell”中列“Press”的值为 DBNull。", e);
  1159.                     }
  1160.                 }
  1161.                 set {
  1162.                     this[this.tableV_BookSell.PressColumn] = value;
  1163.                 }
  1164.             }
  1165.             
  1166.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1167.             public decimal Price {
  1168.                 get {
  1169.                     return ((decimal)(this[this.tableV_BookSell.PriceColumn]));
  1170.                 }
  1171.                 set {
  1172.                     this[this.tableV_BookSell.PriceColumn] = value;
  1173.                 }
  1174.             }
  1175.             
  1176.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1177.             public int Number {
  1178.                 get {
  1179.                     return ((int)(this[this.tableV_BookSell.NumberColumn]));
  1180.                 }
  1181.                 set {
  1182.                     this[this.tableV_BookSell.NumberColumn] = value;
  1183.                 }
  1184.             }
  1185.             
  1186.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1187.             public double Discount {
  1188.                 get {
  1189.                     return ((double)(this[this.tableV_BookSell.DiscountColumn]));
  1190.                 }
  1191.                 set {
  1192.                     this[this.tableV_BookSell.DiscountColumn] = value;
  1193.                 }
  1194.             }
  1195.             
  1196.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1197.             public decimal Sum {
  1198.                 get {
  1199.                     try {
  1200.                         return ((decimal)(this[this.tableV_BookSell.SumColumn]));
  1201.                     }
  1202.                     catch (System.InvalidCastException e) {
  1203.                         throw new System.Data.StrongTypingException("表“V_BookSell”中列“Sum”的值为 DBNull。", e);
  1204.                     }
  1205.                 }
  1206.                 set {
  1207.                     this[this.tableV_BookSell.SumColumn] = value;
  1208.                 }
  1209.             }
  1210.             
  1211.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1212.             public int SellID {
  1213.                 get {
  1214.                     return ((int)(this[this.tableV_BookSell.SellIDColumn]));
  1215.                 }
  1216.                 set {
  1217.                     this[this.tableV_BookSell.SellIDColumn] = value;
  1218.                 }
  1219.             }
  1220.             
  1221.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1222.             public bool IsCustomerIDNull() {
  1223.                 return this.IsNull(this.tableV_BookSell.CustomerIDColumn);
  1224.             }
  1225.             
  1226.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1227.             public void SetCustomerIDNull() {
  1228.                 this[this.tableV_BookSell.CustomerIDColumn] = System.Convert.DBNull;
  1229.             }
  1230.             
  1231.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1232.             public bool IsPressNull() {
  1233.                 return this.IsNull(this.tableV_BookSell.PressColumn);
  1234.             }
  1235.             
  1236.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1237.             public void SetPressNull() {
  1238.                 this[this.tableV_BookSell.PressColumn] = System.Convert.DBNull;
  1239.             }
  1240.             
  1241.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1242.             public bool IsSumNull() {
  1243.                 return this.IsNull(this.tableV_BookSell.SumColumn);
  1244.             }
  1245.             
  1246.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1247.             public void SetSumNull() {
  1248.                 this[this.tableV_BookSell.SumColumn] = System.Convert.DBNull;
  1249.             }
  1250.         }
  1251.         
  1252.         [System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
  1253.         public partial class P_GetSellDetailRow : System.Data.DataRow {
  1254.             
  1255.             private P_GetSellDetailDataTable tableP_GetSellDetail;
  1256.             
  1257.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1258.             internal P_GetSellDetailRow(System.Data.DataRowBuilder rb) : 
  1259.                     base(rb) {
  1260.                 this.tableP_GetSellDetail = ((P_GetSellDetailDataTable)(this.Table));
  1261.             }
  1262.             
  1263.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1264.             public int BookID {
  1265.                 get {
  1266.                     return ((int)(this[this.tableP_GetSellDetail.BookIDColumn]));
  1267.                 }
  1268.                 set {
  1269.                     this[this.tableP_GetSellDetail.BookIDColumn] = value;
  1270.                 }
  1271.             }
  1272.             
  1273.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1274.             public string ISBN {
  1275.                 get {
  1276.                     return ((string)(this[this.tableP_GetSellDetail.ISBNColumn]));
  1277.                 }
  1278.                 set {
  1279.                     this[this.tableP_GetSellDetail.ISBNColumn] = value;
  1280.                 }
  1281.             }
  1282.             
  1283.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1284.             public string Name {
  1285.                 get {
  1286.                     return ((string)(this[this.tableP_GetSellDetail.NameColumn]));
  1287.                 }
  1288.                 set {
  1289.                     this[this.tableP_GetSellDetail.NameColumn] = value;
  1290.                 }
  1291.             }
  1292.             
  1293.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1294.             public decimal Price {
  1295.                 get {
  1296.                     return ((decimal)(this[this.tableP_GetSellDetail.PriceColumn]));
  1297.                 }
  1298.                 set {
  1299.                     this[this.tableP_GetSellDetail.PriceColumn] = value;
  1300.                 }
  1301.             }
  1302.             
  1303.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1304.             public int Number {
  1305.                 get {
  1306.                     return ((int)(this[this.tableP_GetSellDetail.NumberColumn]));
  1307.                 }
  1308.                 set {
  1309.                     this[this.tableP_GetSellDetail.NumberColumn] = value;
  1310.                 }
  1311.             }
  1312.             
  1313.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1314.             public double Discount {
  1315.                 get {
  1316.                     return ((double)(this[this.tableP_GetSellDetail.DiscountColumn]));
  1317.                 }
  1318.                 set {
  1319.                     this[this.tableP_GetSellDetail.DiscountColumn] = value;
  1320.                 }
  1321.             }
  1322.             
  1323.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1324.             public decimal Sum {
  1325.                 get {
  1326.                     try {
  1327.                         return ((decimal)(this[this.tableP_GetSellDetail.SumColumn]));
  1328.                     }
  1329.                     catch (System.InvalidCastException e) {
  1330.                         throw new System.Data.StrongTypingException("表“P_GetSellDetail”中列“Sum”的值为 DBNull。", e);
  1331.                     }
  1332.                 }
  1333.                 set {
  1334.                     this[this.tableP_GetSellDetail.SumColumn] = value;
  1335.                 }
  1336.             }
  1337.             
  1338.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1339.             public bool IsSumNull() {
  1340.                 return this.IsNull(this.tableP_GetSellDetail.SumColumn);
  1341.             }
  1342.             
  1343.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1344.             public void SetSumNull() {
  1345.                 this[this.tableP_GetSellDetail.SumColumn] = System.Convert.DBNull;
  1346.             }
  1347.         }
  1348.         
  1349.         [System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
  1350.         public class BookRowChangeEvent : System.EventArgs {
  1351.             
  1352.             private BookRow eventRow;
  1353.             
  1354.             private System.Data.DataRowAction eventAction;
  1355.             
  1356.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1357.             public BookRowChangeEvent(BookRow row, System.Data.DataRowAction action) {
  1358.                 this.eventRow = row;
  1359.                 this.eventAction = action;
  1360.             }
  1361.             
  1362.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1363.             public BookRow Row {
  1364.                 get {
  1365.                     return this.eventRow;
  1366.                 }
  1367.             }
  1368.             
  1369.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1370.             public System.Data.DataRowAction Action {
  1371.                 get {
  1372.                     return this.eventAction;
  1373.                 }
  1374.             }
  1375.         }
  1376.         
  1377.         [System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
  1378.         public class CustomerRowChangeEvent : System.EventArgs {
  1379.             
  1380.             private CustomerRow eventRow;
  1381.             
  1382.             private System.Data.DataRowAction eventAction;
  1383.             
  1384.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1385.             public CustomerRowChangeEvent(CustomerRow row, System.Data.DataRowAction action) {
  1386.                 this.eventRow = row;
  1387.                 this.eventAction = action;
  1388.             }
  1389.             
  1390.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1391.             public CustomerRow Row {
  1392.                 get {
  1393.                     return this.eventRow;
  1394.                 }
  1395.             }
  1396.             
  1397.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1398.             public System.Data.DataRowAction Action {
  1399.                 get {
  1400.                     return this.eventAction;
  1401.                 }
  1402.             }
  1403.         }
  1404.         
  1405.         [System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
  1406.         public class SellRowChangeEvent : System.EventArgs {
  1407.             
  1408.             private SellRow eventRow;
  1409.             
  1410.             private System.Data.DataRowAction eventAction;
  1411.             
  1412.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1413.             public SellRowChangeEvent(SellRow row, System.Data.DataRowAction action) {
  1414.                 this.eventRow = row;
  1415.                 this.eventAction = action;
  1416.             }
  1417.             
  1418.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1419.             public SellRow Row {
  1420.                 get {
  1421.                     return this.eventRow;
  1422.                 }
  1423.             }
  1424.             
  1425.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1426.             public System.Data.DataRowAction Action {
  1427.                 get {
  1428.                     return this.eventAction;
  1429.                 }
  1430.             }
  1431.         }
  1432.         
  1433.         [System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
  1434.         public class SellItemRowChangeEvent : System.EventArgs {
  1435.             
  1436.             private SellItemRow eventRow;
  1437.             
  1438.             private System.Data.DataRowAction eventAction;
  1439.             
  1440.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1441.             public SellItemRowChangeEvent(SellItemRow row, System.Data.DataRowAction action) {
  1442.                 this.eventRow = row;
  1443.                 this.eventAction = action;
  1444.             }
  1445.             
  1446.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1447.             public SellItemRow Row {
  1448.                 get {
  1449.                     return this.eventRow;
  1450.                 }
  1451.             }
  1452.             
  1453.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1454.             public System.Data.DataRowAction Action {
  1455.                 get {
  1456.                     return this.eventAction;
  1457.                 }
  1458.             }
  1459.         }
  1460.         
  1461.         [System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
  1462.         public class V_BookSellRowChangeEvent : System.EventArgs {
  1463.             
  1464.             private V_BookSellRow eventRow;
  1465.             
  1466.             private System.Data.DataRowAction eventAction;
  1467.             
  1468.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1469.             public V_BookSellRowChangeEvent(V_BookSellRow row, System.Data.DataRowAction action) {
  1470.                 this.eventRow = row;
  1471.                 this.eventAction = action;
  1472.             }
  1473.             
  1474.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1475.             public V_BookSellRow Row {
  1476.                 get {
  1477.                     return this.eventRow;
  1478.                 }
  1479.             }
  1480.             
  1481.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1482.             public System.Data.DataRowAction Action {
  1483.                 get {
  1484.                     return this.eventAction;
  1485.                 }
  1486.             }
  1487.         }
  1488.         
  1489.         [System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
  1490.         public class P_GetSellDetailRowChangeEvent : System.EventArgs {
  1491.             
  1492.             private P_GetSellDetailRow eventRow;
  1493.             
  1494.             private System.Data.DataRowAction eventAction;
  1495.             
  1496.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1497.             public P_GetSellDetailRowChangeEvent(P_GetSellDetailRow row, System.Data.DataRowAction action) {
  1498.                 this.eventRow = row;
  1499.                 this.eventAction = action;
  1500.             }
  1501.             
  1502.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1503.             public P_GetSellDetailRow Row {
  1504.                 get {
  1505.                     return this.eventRow;
  1506.                 }
  1507.             }
  1508.             
  1509.             [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1510.             public System.Data.DataRowAction Action {
  1511.                 get {
  1512.                     return this.eventAction;
  1513.                 }
  1514.             }
  1515.         }
  1516.     }
  1517. }
  1518. namespace BookStoreMan.BookStoreDataSetTableAdapters {
  1519.     
  1520.     
  1521.     [System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
  1522.     [System.ComponentModel.DesignerCategoryAttribute("code")]
  1523.     [System.ComponentModel.ToolboxItem(true)]
  1524.     [System.ComponentModel.DataObjectAttribute(true)]
  1525.     [System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterDesigner, Microsoft.VSDesigner" +
  1526.         ", Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
  1527.     [System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  1528.     public partial class BookTableAdapter : System.ComponentModel.Component {
  1529.         
  1530.         private System.Data.SqlClient.SqlDataAdapter _adapter;
  1531.         
  1532.         private System.Data.SqlClient.SqlConnection _connection;
  1533.         
  1534.         private System.Data.SqlClient.SqlCommand[] _commandCollection;
  1535.         
  1536.         private bool _clearBeforeFill;
  1537.         
  1538.         [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1539.         public BookTableAdapter() {
  1540.             this.ClearBeforeFill = true;
  1541.         }
  1542.         
  1543.         [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1544.         private System.Data.SqlClient.SqlDataAdapter Adapter {
  1545.             get {
  1546.                 if ((this._adapter == null)) {
  1547.                     this.InitAdapter();
  1548.                 }
  1549.                 return this._adapter;
  1550.             }
  1551.         }
  1552.         
  1553.         [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1554.         internal System.Data.SqlClient.SqlConnection Connection {
  1555.             get {
  1556.                 if ((this._connection == null)) {
  1557.                     this.InitConnection();
  1558.                 }
  1559.                 return this._connection;
  1560.             }
  1561.             set {
  1562.                 this._connection = value;
  1563.                 if ((this.Adapter.InsertCommand != null)) {
  1564.                     this.Adapter.InsertCommand.Connection = value;
  1565.                 }
  1566.                 if ((this.Adapter.DeleteCommand != null)) {
  1567.                     this.Adapter.DeleteCommand.Connection = value;
  1568.                 }
  1569.                 if ((this.Adapter.UpdateCommand != null)) {
  1570.                     this.Adapter.UpdateCommand.Connection = value;
  1571.                 }
  1572.                 for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
  1573.                     if ((this.CommandCollection[i] != null)) {
  1574.                         ((System.Data.SqlClient.SqlCommand)(this.CommandCollection[i])).Connection = value;
  1575.                     }
  1576.                 }
  1577.             }
  1578.         }
  1579.         
  1580.         [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1581.         protected System.Data.SqlClient.SqlCommand[] CommandCollection {
  1582.             get {
  1583.                 if ((this._commandCollection == null)) {
  1584.                     this.InitCommandCollection();
  1585.                 }
  1586.                 return this._commandCollection;
  1587.             }
  1588.         }
  1589.         
  1590.         [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1591.         public bool ClearBeforeFill {
  1592.             get {
  1593.                 return this._clearBeforeFill;
  1594.             }
  1595.             set {
  1596.                 this._clearBeforeFill = value;
  1597.             }
  1598.         }
  1599.         
  1600.         [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1601.         private void InitAdapter() {
  1602.             this._adapter = new System.Data.SqlClient.SqlDataAdapter();
  1603.             System.Data.Common.DataTableMapping tableMapping = new System.Data.Common.DataTableMapping();
  1604.             tableMapping.SourceTable = "Table";
  1605.             tableMapping.DataSetTable = "Book";
  1606.             tableMapping.ColumnMappings.Add("ID", "ID");
  1607.             tableMapping.ColumnMappings.Add("ISBN", "ISBN");
  1608.             tableMapping.ColumnMappings.Add("Name", "Name");
  1609.             tableMapping.ColumnMappings.Add("Author", "Author");
  1610.             tableMapping.ColumnMappings.Add("Press", "Press");
  1611.             tableMapping.ColumnMappings.Add("PublishDate", "PublishDate");
  1612.             tableMapping.ColumnMappings.Add("Price", "Price");
  1613.             tableMapping.ColumnMappings.Add("Pages", "Pages");
  1614.             tableMapping.ColumnMappings.Add("Barcode", "Barcode");
  1615.             tableMapping.ColumnMappings.Add("CD", "CD");
  1616.             tableMapping.ColumnMappings.Add("Storage", "Storage");
  1617.             this._adapter.TableMappings.Add(tableMapping);
  1618.             this._adapter.DeleteCommand = new System.Data.SqlClient.SqlCommand();
  1619.             this._adapter.DeleteCommand.Connection = this.Connection;
  1620.             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))";
  1621.             this._adapter.DeleteCommand.CommandType = System.Data.CommandType.Text;
  1622.             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, "", "", ""));
  1623.             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, "", "", ""));
  1624.             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, "", "", ""));
  1625.             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, "", "", ""));
  1626.             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, "", "", ""));
  1627.             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, "", "", ""));
  1628.             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, "", "", ""));
  1629.             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, "", "", ""));
  1630.             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, "", "", ""));
  1631.             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, "", "", ""));
  1632.             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, "", "", ""));
  1633.             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, "", "", ""));
  1634.             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, "", "", ""));
  1635.             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, "", "", ""));
  1636.             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, "", "", ""));
  1637.             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, "", "", ""));
  1638.             this._adapter.InsertCommand = new System.Data.SqlClient.SqlCommand();
  1639.             this._adapter.InsertCommand.Connection = this.Connection;
  1640.             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);
  1641. SELECT ID, ISBN, Name, Author, Press, PublishDate, Price, Pages, Barcode, CD, Storage FROM Book WHERE (ID = SCOPE_IDENTITY())";
  1642.             this._adapter.InsertCommand.CommandType = System.Data.CommandType.Text;
  1643.             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, "", "", ""));
  1644.             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, "", "", ""));
  1645.             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, "", "", ""));
  1646.             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, "", "", ""));
  1647.             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, "", "", ""));
  1648.             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, "", "", ""));
  1649.             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, "", "", ""));
  1650.             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, "", "", ""));
  1651.             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, "", "", ""));
  1652.             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, "", "", ""));
  1653.             this._adapter.UpdateCommand = new System.Data.SqlClient.SqlCommand();
  1654.             this._adapter.UpdateCommand.Connection = this.Connection;
  1655.             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));
  1656. SELECT ID, ISBN, Name, Author, Press, PublishDate, Price, Pages, Barcode, CD, Storage FROM Book WHERE (ID = @ID)";
  1657.             this._adapter.UpdateCommand.CommandType = System.Data.CommandType.Text;
  1658.             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, "", "", ""));
  1659.             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, "", "", ""));
  1660.             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, "", "", ""));
  1661.             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, "", "", ""));
  1662.             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, "", "", ""));
  1663.             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, "", "", ""));
  1664.             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, "", "", ""));
  1665.             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, "", "", ""));
  1666.             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, "", "", ""));
  1667.             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, "", "", ""));
  1668.             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, "", "", ""));
  1669.             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, "", "", ""));
  1670.             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, "", "", ""));
  1671.             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, "", "", ""));
  1672.             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, "", "", ""));
  1673.             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, "", "", ""));
  1674.             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, "", "", ""));
  1675.             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, "", "", ""));
  1676.             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, "", "", ""));
  1677.             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, "", "", ""));
  1678.             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, "", "", ""));
  1679.             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, "", "", ""));
  1680.             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, "", "", ""));
  1681.             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, "", "", ""));
  1682.             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, "", "", ""));
  1683.             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, "", "", ""));
  1684.             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, "", "", ""));
  1685.         }
  1686.         
  1687.         [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1688.         private void InitConnection() {
  1689.             this._connection = new System.Data.SqlClient.SqlConnection();
  1690.             this._connection.ConnectionString = global::BookStoreMan.Properties.Settings.Default.BookStoreConnectionString;
  1691.         }
  1692.         
  1693.         [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1694.         private void InitCommandCollection() {
  1695.             this._commandCollection = new System.Data.SqlClient.SqlCommand[1];
  1696.             this._commandCollection[0] = new System.Data.SqlClient.SqlCommand();
  1697.             this._commandCollection[0].Connection = this.Connection;
  1698.             this._commandCollection[0].CommandText = "SELECT ID, ISBN, Name, Author, Press, PublishDate, Price, Pages, Barcode, CD, Sto" +
  1699.                 "rage FROM dbo.Book";
  1700.             this._commandCollection[0].CommandType = System.Data.CommandType.Text;
  1701.         }
  1702.         
  1703.         [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1704.         [System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  1705.         [System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Fill, true)]
  1706.         public virtual int Fill(BookStoreDataSet.BookDataTable dataTable) {
  1707.             this.Adapter.SelectCommand = this.CommandCollection[0];
  1708.             if ((this.ClearBeforeFill == true)) {
  1709.                 dataTable.Clear();
  1710.             }
  1711.             int returnValue = this.Adapter.Fill(dataTable);
  1712.             return returnValue;
  1713.         }
  1714.         
  1715.         [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1716.         [System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  1717.         [System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, true)]
  1718.         public virtual BookStoreDataSet.BookDataTable GetData() {
  1719.             this.Adapter.SelectCommand = this.CommandCollection[0];
  1720.             BookStoreDataSet.BookDataTable dataTable = new BookStoreDataSet.BookDataTable();
  1721.             this.Adapter.Fill(dataTable);
  1722.             return dataTable;
  1723.         }
  1724.         
  1725.         [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1726.         [System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  1727.         public virtual int Update(BookStoreDataSet.BookDataTable dataTable) {
  1728.             return this.Adapter.Update(dataTable);
  1729.         }
  1730.         
  1731.         [System.Diagnostics.DebuggerNonUserCodeAttribute()]
  1732.         [System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
  1733.         public virtual int Update(BookStoreDataSet dataSet) {
  1734.             return this.Adapter.Update(dataSet, "Book");
  1735.         }