📄 order.cs
字号:
using System;
using System.Data;
public class Order {
#region private vars
int _OrderID;
string _OrderGUID;
DateTime _OrderDate;
DateTime _ShipDate;
int _OrderStatusID;
string _UserName;
string _ShippingAddress;
double _OrderSubTotal;
double _Shipping;
double _Tax;
string _OrderZipCode;
string _OrderStatus;
string _ShippingMethod;
string _PayPalTransactionID;
DateTime _DatePaid;
string _PaymentMethod;
string _ShippingTrackingNumber;
#endregion
#region Public Props
public int OrderID {
get { return _OrderID; }
set { _OrderID = value; }
}
public string ShippingTrackingNumber {
get { return _ShippingTrackingNumber; }
set { _ShippingTrackingNumber = value; }
}
public string OrderGUID {
get { return _OrderGUID; }
set { _OrderGUID = value; }
}
public string OrderStatus {
get { return _OrderStatus; }
set { _OrderStatus = value; }
}
public DateTime OrderDate {
get { return _OrderDate; }
set { _OrderDate = value; }
}
public DateTime ShipDate {
get { return _ShipDate; }
set { _ShipDate = value; }
}
public int OrderStatusID {
get { return _OrderStatusID; }
set { _OrderStatusID = value; }
}
public string UserName {
get { return _UserName; }
set { _UserName = value; }
}
public string ShippingAddress {
get { return _ShippingAddress; }
set { _ShippingAddress = value; }
}
public double OrderSubTotal {
get { return _OrderSubTotal; }
set { _OrderSubTotal = value; }
}
public double Shipping {
get { return _Shipping; }
set { _Shipping = value; }
}
public double Tax {
get { return _Tax; }
set { _Tax = value; }
}
public string OrderZipCode {
get { return _OrderZipCode; }
set { _OrderZipCode = value; }
}
public string ShippingMethod {
get { return _ShippingMethod; }
set { _ShippingMethod = value; }
}
public string PayPalTransactionID {
get { return _PayPalTransactionID; }
set { _PayPalTransactionID = value; }
}
public DateTime DatePaid {
get { return _DatePaid; }
set { _DatePaid = value; }
}
public string PaymentMethod {
get { return _PaymentMethod; }
set { _PaymentMethod = value; }
}
#endregion
public void Load(IDataReader rdr) {
if (rdr.Read()) {
_OrderID = (int)rdr["OrderID"];
_OrderGUID = rdr["OrderGUID"].ToString();
_OrderDate = (DateTime)rdr["OrderDate"];
_ShipDate = (DateTime)rdr["ShipDate"];
_OrderStatusID = (int)rdr["OrderStatusID"];
_UserName = rdr["UserName"].ToString();
_ShippingMethod = rdr["ShippingMethod"].ToString();
_ShippingAddress = rdr["ShippingAddress"].ToString();
_OrderSubTotal = Convert.ToDouble(rdr["OrderSubTotal"].ToString());
_Shipping = Convert.ToDouble(rdr["Shipping"].ToString());
_Tax = Convert.ToDouble(rdr["Tax"].ToString());
_OrderZipCode = rdr["OrderZipCode"].ToString();
_PayPalTransactionID = rdr["PayPalTransactionID"].ToString();
try {
_DatePaid = (DateTime)rdr["DatePaid"];
} catch {
_DatePaid = DateTime.Parse("1/1/1900");
}
_PaymentMethod = rdr["PaymentMethod"].ToString();
_OrderStatus = rdr["OrderStatus"].ToString();
_ShippingTrackingNumber = rdr["ShippingTrackingNumber"].ToString();
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -