📄 dsorderhistory.cs
字号:
}
public System.Collections.IEnumerator GetEnumerator() {
return this.Rows.GetEnumerator();
}
public override DataTable Clone() {
OrdersDataTable cln = ((OrdersDataTable)(base.Clone()));
cln.InitVars();
return cln;
}
protected override DataTable CreateInstance() {
return new OrdersDataTable();
}
internal void InitVars() {
this.columnOrderID = this.Columns["OrderID"];
this.columnCustomerID = this.Columns["CustomerID"];
this.columnOrderDate = this.Columns["OrderDate"];
this.columnFreight = this.Columns["Freight"];
this.columnShipAddress = this.Columns["ShipAddress"];
this.columnShipName = this.Columns["ShipName"];
this.columnShipCity = this.Columns["ShipCity"];
this.columnShipPostalCode = this.Columns["ShipPostalCode"];
this.columnShipCountry = this.Columns["ShipCountry"];
}
private void InitClass() {
this.columnOrderID = new DataColumn("OrderID", typeof(int), null, System.Data.MappingType.Element);
this.Columns.Add(this.columnOrderID);
this.columnCustomerID = new DataColumn("CustomerID", typeof(string), null, System.Data.MappingType.Element);
this.Columns.Add(this.columnCustomerID);
this.columnOrderDate = new DataColumn("OrderDate", typeof(System.DateTime), null, System.Data.MappingType.Element);
this.Columns.Add(this.columnOrderDate);
this.columnFreight = new DataColumn("Freight", typeof(System.Decimal), null, System.Data.MappingType.Element);
this.Columns.Add(this.columnFreight);
this.columnShipAddress = new DataColumn("ShipAddress", typeof(string), null, System.Data.MappingType.Element);
this.Columns.Add(this.columnShipAddress);
this.columnShipName = new DataColumn("ShipName", typeof(string), null, System.Data.MappingType.Element);
this.Columns.Add(this.columnShipName);
this.columnShipCity = new DataColumn("ShipCity", typeof(string), null, System.Data.MappingType.Element);
this.Columns.Add(this.columnShipCity);
this.columnShipPostalCode = new DataColumn("ShipPostalCode", typeof(string), null, System.Data.MappingType.Element);
this.Columns.Add(this.columnShipPostalCode);
this.columnShipCountry = new DataColumn("ShipCountry", typeof(string), null, System.Data.MappingType.Element);
this.Columns.Add(this.columnShipCountry);
this.Constraints.Add(new UniqueConstraint("Constraint1", new DataColumn[] {
this.columnOrderID}, true));
this.columnOrderID.AutoIncrement = true;
this.columnOrderID.AllowDBNull = false;
this.columnOrderID.ReadOnly = true;
this.columnOrderID.Unique = true;
}
public OrdersRow NewOrdersRow() {
return ((OrdersRow)(this.NewRow()));
}
protected override DataRow NewRowFromBuilder(DataRowBuilder builder) {
return new OrdersRow(builder);
}
protected override System.Type GetRowType() {
return typeof(OrdersRow);
}
protected override void OnRowChanged(DataRowChangeEventArgs e) {
base.OnRowChanged(e);
if ((this.OrdersRowChanged != null)) {
this.OrdersRowChanged(this, new OrdersRowChangeEvent(((OrdersRow)(e.Row)), e.Action));
}
}
protected override void OnRowChanging(DataRowChangeEventArgs e) {
base.OnRowChanging(e);
if ((this.OrdersRowChanging != null)) {
this.OrdersRowChanging(this, new OrdersRowChangeEvent(((OrdersRow)(e.Row)), e.Action));
}
}
protected override void OnRowDeleted(DataRowChangeEventArgs e) {
base.OnRowDeleted(e);
if ((this.OrdersRowDeleted != null)) {
this.OrdersRowDeleted(this, new OrdersRowChangeEvent(((OrdersRow)(e.Row)), e.Action));
}
}
protected override void OnRowDeleting(DataRowChangeEventArgs e) {
base.OnRowDeleting(e);
if ((this.OrdersRowDeleting != null)) {
this.OrdersRowDeleting(this, new OrdersRowChangeEvent(((OrdersRow)(e.Row)), e.Action));
}
}
public void RemoveOrdersRow(OrdersRow row) {
this.Rows.Remove(row);
}
}
[System.Diagnostics.DebuggerStepThrough()]
public class OrdersRow : DataRow {
private OrdersDataTable tableOrders;
internal OrdersRow(DataRowBuilder rb) :
base(rb) {
this.tableOrders = ((OrdersDataTable)(this.Table));
}
public int OrderID {
get {
return ((int)(this[this.tableOrders.OrderIDColumn]));
}
set {
this[this.tableOrders.OrderIDColumn] = value;
}
}
public string CustomerID {
get {
try {
return ((string)(this[this.tableOrders.CustomerIDColumn]));
}
catch (InvalidCastException e) {
throw new StrongTypingException("Cannot get value because it is DBNull.", e);
}
}
set {
this[this.tableOrders.CustomerIDColumn] = value;
}
}
public System.DateTime OrderDate {
get {
try {
return ((System.DateTime)(this[this.tableOrders.OrderDateColumn]));
}
catch (InvalidCastException e) {
throw new StrongTypingException("Cannot get value because it is DBNull.", e);
}
}
set {
this[this.tableOrders.OrderDateColumn] = value;
}
}
public System.Decimal Freight {
get {
try {
return ((System.Decimal)(this[this.tableOrders.FreightColumn]));
}
catch (InvalidCastException e) {
throw new StrongTypingException("Cannot get value because it is DBNull.", e);
}
}
set {
this[this.tableOrders.FreightColumn] = value;
}
}
public string ShipAddress {
get {
try {
return ((string)(this[this.tableOrders.ShipAddressColumn]));
}
catch (InvalidCastException e) {
throw new StrongTypingException("Cannot get value because it is DBNull.", e);
}
}
set {
this[this.tableOrders.ShipAddressColumn] = value;
}
}
public string ShipName {
get {
try {
return ((string)(this[this.tableOrders.ShipNameColumn]));
}
catch (InvalidCastException e) {
throw new StrongTypingException("Cannot get value because it is DBNull.", e);
}
}
set {
this[this.tableOrders.ShipNameColumn] = value;
}
}
public string ShipCity {
get {
try {
return ((string)(this[this.tableOrders.ShipCityColumn]));
}
catch (InvalidCastException e) {
throw new StrongTypingException("Cannot get value because it is DBNull.", e);
}
}
set {
this[this.tableOrders.ShipCityColumn] = value;
}
}
public string ShipPostalCode {
get {
try {
return ((string)(this[this.tableOrders.ShipPostalCodeColumn]));
}
catch (InvalidCastException e) {
throw new StrongTypingException("Cannot get value because it is DBNull.", e);
}
}
set {
this[this.tableOrders.ShipPostalCodeColumn] = value;
}
}
public string ShipCountry {
get {
try {
return ((string)(this[this.tableOrders.ShipCountryColumn]));
}
catch (InvalidCastException e) {
throw new StrongTypingException("Cannot get value because it is DBNull.", e);
}
}
set {
this[this.tableOrders.ShipCountryColumn] = value;
}
}
public CustomersRow CustomersRow {
get {
return ((CustomersRow)(this.GetParentRow(this.Table.ParentRelations["CustomersOrders"])));
}
set {
this.SetParentRow(value, this.Table.ParentRelations["CustomersOrders"]);
}
}
public bool IsCustomerIDNull() {
return this.IsNull(this.tableOrders.CustomerIDColumn);
}
public void SetCustomerIDNull() {
this[this.tableOrders.CustomerIDColumn] = System.Convert.DBNull;
}
public bool IsOrderDateNull() {
return this.IsNull(this.tableOrders.OrderDateColumn);
}
public void SetOrderDateNull() {
this[this.tableOrders.OrderDateColumn] = System.Convert.DBNull;
}
public bool IsFreightNull() {
return this.IsNull(this.tableOrders.FreightColumn);
}
public void SetFreightNull() {
this[this.tableOrders.FreightColumn] = System.Convert.DBNull;
}
public bool IsShipAddressNull() {
return this.IsNull(this.tableOrders.ShipAddressColumn);
}
public void SetShipAddressNull() {
this[this.tableOrders.ShipAddressColumn] = System.Convert.DBNull;
}
public bool IsShipNameNull() {
return this.IsNull(this.tableOrders.ShipNameColumn);
}
public void SetShipNameNull() {
this[this.tableOrders.ShipNameColumn] = System.Convert.DBNull;
}
public bool IsShipCityNull() {
return this.IsNull(this.tableOrders.ShipCityColumn);
}
public void SetShipCityNull() {
this[this.tableOrders.ShipCityColumn] = System.Convert.DBNull;
}
public bool IsShipPostalCodeNull() {
return this.IsNull(this.tableOrders.ShipPostalCodeColumn);
}
public void SetShipPostalCodeNull() {
this[this.tableOrders.ShipPostalCodeColumn] = System.Convert.DBNull;
}
public bool IsShipCountryNull() {
return this.IsNull(this.tableOrders.ShipCountryColumn);
}
public void SetShipCountryNull() {
this[this.tableOrders.ShipCountryColumn] = System.Convert.DBNull;
}
}
[System.Diagnostics.DebuggerStepThrough()]
public class OrdersRowChangeEvent : EventArgs {
private OrdersRow eventRow;
private DataRowAction eventAction;
public OrdersRowChangeEvent(OrdersRow row, DataRowAction action) {
this.eventRow = row;
this.eventAction = action;
}
public OrdersRow Row {
get {
return this.eventRow;
}
}
public DataRowAction Action {
get {
return this.eventAction;
}
}
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -