📄 model.smark.cs
字号:
try {
return Order.SUM(_context, field, false, null);
}
catch (System.Exception e_) {
throw e_;
}
finally {
_context.Dispose();
}
}
public static object SUM(string field, bool DISTINCT) {
IConnectinContext _context;
_context = DBContext.Context;
try {
return Order.SUM(_context, field, DISTINCT, null);
}
catch (System.Exception e_) {
throw e_;
}
finally {
_context.Dispose();
}
}
public static object MAX(IConnectinContext context, string field, Expression expression) {
return EntityBase.OnAggregation(context, "Orders", "MAX", field, false, expression, Order.mGroupString);
}
public static object MAX(IConnectinContext context, string field) {
return Order.MAX(context, field, null);
}
public static object MAX(string field, Expression expression) {
IConnectinContext _context;
_context = DBContext.Context;
try {
return Order.MAX(_context, field, expression);
}
catch (System.Exception e_) {
throw e_;
}
finally {
_context.Dispose();
}
}
public static object MAX(string field) {
IConnectinContext _context;
_context = DBContext.Context;
try {
return Order.MAX(_context, field, null);
}
catch (System.Exception e_) {
throw e_;
}
finally {
_context.Dispose();
}
}
public static object MIN(IConnectinContext context, string field, Expression expression) {
return EntityBase.OnAggregation(context, "Orders", "MIN", field, false, expression, Order.mGroupString);
}
public static object MIN(IConnectinContext context, string field) {
return Order.MIN(context, field, null);
}
public static object MIN(string field, Expression expression) {
IConnectinContext _context;
_context = DBContext.Context;
try {
return Order.MIN(_context, field, expression);
}
catch (System.Exception e_) {
throw e_;
}
finally {
_context.Dispose();
}
}
public static object MIN(string field) {
IConnectinContext _context;
_context = DBContext.Context;
try {
return Order.MIN(_context, field, null);
}
catch (System.Exception e_) {
throw e_;
}
finally {
_context.Dispose();
}
}
protected override void OnLoadData(System.Data.IDataReader reader) {
if ((reader["_OrderID"] != System.DBNull.Value)) {
this.OrderID = ((int)(this.Convert(typeof(int), reader["_OrderID"])));
}
if ((reader["_CustomerID"] != System.DBNull.Value)) {
this.CustomerID = ((string)(this.Convert(typeof(string), reader["_CustomerID"])));
}
if ((reader["_EmployeeID"] != System.DBNull.Value)) {
this.EmployeeID = ((int)(this.Convert(typeof(int), reader["_EmployeeID"])));
}
if ((reader["_OrderDate"] != System.DBNull.Value)) {
this.OrderDate = ((System.DateTime)(this.Convert(typeof(System.DateTime), reader["_OrderDate"])));
}
if ((reader["_RequiredDate"] != System.DBNull.Value)) {
this.RequiredDate = ((System.DateTime)(this.Convert(typeof(System.DateTime), reader["_RequiredDate"])));
}
if ((reader["_ShippedDate"] != System.DBNull.Value)) {
this.ShippedDate = ((System.DateTime)(this.Convert(typeof(System.DateTime), reader["_ShippedDate"])));
}
if ((reader["_ShipVia"] != System.DBNull.Value)) {
this.ShipVia = ((int)(this.Convert(typeof(int), reader["_ShipVia"])));
}
if ((reader["_Freight"] != System.DBNull.Value)) {
this.Freight = ((decimal)(this.Convert(typeof(decimal), reader["_Freight"])));
}
}
public static void Delete(IConnectinContext context, Expression expression) {
EntityBase.OnDelete(context, "Orders", expression);
}
public static void Delete(Expression expression) {
IConnectinContext _context;
_context = DBContext.Context;
try {
Order.Delete(_context, expression);
}
catch (System.Exception e_) {
throw e_;
}
finally {
_context.Dispose();
}
}
public static Order Load(IConnectinContext context, int id) {
return EntityBase.OnLoad<Order>(context, Order.mSelectString, "OrderID", id);
}
public static Order Load(int id) {
IConnectinContext _context;
_context = DBContext.Context;
try {
return Order.Load(_context, id);
}
catch (System.Exception e_) {
throw e_;
}
finally {
_context.Dispose();
}
}
public virtual void Save(IConnectinContext context) {
System.Collections.Generic.IList<Field> _fields;
Field _id;
Field item;
_fields = new System.Collections.Generic.List<Field>();
_id = new Field();
_id.Name = "OrderID";
_id.Value = this.OrderID;
_id.GetValueBy = "SELECT @@IDENTITY ";
_id.GetValueAfterInsert = true;
item = new Field();
item.Name = "CustomerID";
item.Value = this.CustomerID;
_fields.Add(item);
item = new Field();
item.Name = "EmployeeID";
item.Value = this.EmployeeID;
_fields.Add(item);
item = new Field();
item.Name = "OrderDate";
item.Value = this.OrderDate;
_fields.Add(item);
item = new Field();
item.Name = "RequiredDate";
item.Value = this.RequiredDate;
_fields.Add(item);
item = new Field();
item.Name = "ShippedDate";
item.Value = this.ShippedDate;
_fields.Add(item);
item = new Field();
item.Name = "ShipVia";
item.Value = this.ShipVia;
_fields.Add(item);
item = new Field();
item.Name = "Freight";
item.Value = this.Freight;
_fields.Add(item);
this.OnSave(context, "Orders", _fields, _id);
this.OrderID = ((int)(this.Convert(typeof(int), _id.Value)));
}
public virtual void Save() {
IConnectinContext _context;
_context = DBContext.Context;
try {
this.Save(_context);
}
catch (System.Exception e_) {
throw e_;
}
finally {
_context.Dispose();
}
}
public virtual void Delete(IConnectinContext context) {
this.OnDeleteObject(context, "Orders", "OrderID", this.OrderID);
}
public virtual void Delete() {
IConnectinContext _context;
_context = DBContext.Context;
try {
this.Delete(_context);
}
catch (System.Exception e_) {
throw e_;
}
finally {
_context.Dispose();
}
}
}
/// <summary>
/// Smark.Data.VSGenerator Copyright 泥水佬
/// Email:henryfan@msn.com
/// MappingTable:Employees
///
/// </summary>
[Serializable()]
public partial class Employee : EntityBase {
private int mEmployeeID;
public static FieldInfo employeeID = new FieldInfo("Employees", "EmployeeID");
private string mFirstName;
public static FieldInfo firstName = new FieldInfo("Employees", "FirstName");
private string mLastName;
public static FieldInfo lastName = new FieldInfo("Employees", "LastName");
private string mCountry;
public static FieldInfo country = new FieldInfo("Employees", "Country");
private int mReportsTo;
public static FieldInfo reportsTo = new FieldInfo("Employees", "ReportsTo");
static string mSelectString = "Select (EmployeeID) as _EmployeeID,(FirstName) as _FirstName,(LastName) as _LastN" +
"ame,(Country) as _Country,(ReportsTo) as _ReportsTo from Employees";
static string mGroupString = null;
/// <summary>
///
/// </summary>
public virtual int EmployeeID {
get {
return this.mEmployeeID;
}
set {
this.mEmployeeID = value;
this.EntityState.FieldChange("EmployeeID");
}
}
/// <summary>
///
/// </summary>
public virtual string FirstName {
get {
return this.mFirstName;
}
set {
this.mFirstName = value;
this.EntityState.FieldChange("FirstName");
}
}
/// <summary>
///
/// </summary>
public virtual string LastName {
get {
return this.mLastName;
}
set {
this.mLastName = value;
this.EntityState.FieldChange("LastName");
}
}
/// <summary>
///
/// </summary>
public virtual string Country {
get {
return this.mCountry;
}
set {
this.mCountry = value;
this.EntityState.FieldChange("Country");
}
}
/// <summary>
///
/// </summary>
public virtual int ReportsTo {
get {
return this.mReportsTo;
}
set {
this.mReportsTo = value;
this.EntityState.FieldChange("ReportsTo");
}
}
public static string Table {
get {
return " Employees ";
}
}
public static System.Collections.Generic.IList<Employee> List(IConnectinContext context, Expression expression, Region region, string OrderBy) {
return EntityBase.OnList<Employee>(context, Employee.mSelectString, expression, region, OrderBy, Employee.mGroupString);
}
public static System.Collections.Generic.IList<Employee> List(IConnectinContext context, Expression expression) {
return Employee.List(context, expression, null, null);
}
public static System.Collections.Generic.IList<Employee> List(Expression expression, Region region, string OrderBy) {
IConnectinContext _context;
_context = DBContext.Context;
try {
return Employee.List(_context, expression, region, OrderBy);
}
catch (System.Exception e_) {
throw e_;
}
finally {
_context.Dispose();
}
}
public static System.Collections.Generic.IList<Employee> List(Expression expression) {
IConnectinContext _context;
_context = DBContext.Context;
try {
return Employee.List(_context, expression, null, null);
}
catch (System.Exception e_) {
throw e_;
}
finally {
_context.Dispose();
}
}
public static Employee ListFirst(IConnectinContext context, Expression expression, string OrderBy) {
return EntityBase.OnListFirst<Employee>(context, Employee.mSelectString, expression, OrderBy, Employee.mGroupString);
}
public static Employee ListFirst(IConnectinContext context, Expression expression) {
return Employee.ListFirst(context, expression);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -