MESProductionWeb/Central.Control.Domain/Sql_Wkdb.Context.cs

//------------------------------------------------------------------------------
// <auto-generated>
//     此代码已从模板生成。
//
//     手动更改此文件可能导致应用程序出现意外的行为。
//     如果重新生成代码，将覆盖对此文件的手动更改。
// </auto-generated>
//------------------------------------------------------------------------------

namespace Central.Control.Domain
{
    using System;
    using System.Data.Entity;
    using System.Data.Entity.Infrastructure;
    using System.Data.Entity.Core.Objects;
    using System.Linq;

    public partial class Entities : DbContext
    {
        public Entities()
            : base("name=Entities")
        {
        }

        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            throw new UnintentionalCodeFirstException();
        }

        public virtual DbSet<COM_CONTENT> COM_CONTENT { get; set; }
        public virtual DbSet<COM_CUSCONTACT> COM_CUSCONTACT { get; set; }
        public virtual DbSet<COM_DOWNLOAD> COM_DOWNLOAD { get; set; }
        public virtual DbSet<COM_FLOWINFO> COM_FLOWINFO { get; set; }
        public virtual DbSet<COM_INDEX> COM_INDEX { get; set; }
        public virtual DbSet<COM_UPLOAD> COM_UPLOAD { get; set; }
        public virtual DbSet<SYS_BEUSER> SYS_BEUSER { get; set; }
        public virtual DbSet<SYS_CODE> SYS_CODE { get; set; }
        public virtual DbSet<SYS_CODE_AREA> SYS_CODE_AREA { get; set; }
        public virtual DbSet<SYS_LOG> SYS_LOG { get; set; }
        public virtual DbSet<SYS_MODULE> SYS_MODULE { get; set; }
        public virtual DbSet<SYS_MSG> SYS_MSG { get; set; }
        public virtual DbSet<SYS_MSGATTACH> SYS_MSGATTACH { get; set; }
        public virtual DbSet<SYS_MSGREV> SYS_MSGREV { get; set; }
        public virtual DbSet<SYS_PERMISSION> SYS_PERMISSION { get; set; }
        public virtual DbSet<SYS_POST> SYS_POST { get; set; }
        public virtual DbSet<SYS_POST_DEPARTMENT> SYS_POST_DEPARTMENT { get; set; }
        public virtual DbSet<SYS_POST_USER> SYS_POST_USER { get; set; }
        public virtual DbSet<SYS_ROLE> SYS_ROLE { get; set; }
        public virtual DbSet<SYS_ROLE_PERMISSION> SYS_ROLE_PERMISSION { get; set; }
        public virtual DbSet<SYS_SMS> SYS_SMS { get; set; }
        public virtual DbSet<SYS_SYSTEM> SYS_SYSTEM { get; set; }
        public virtual DbSet<SYS_USER> SYS_USER { get; set; }
        public virtual DbSet<SYS_USER_DEPARTMENT> SYS_USER_DEPARTMENT { get; set; }
        public virtual DbSet<SYS_USER_PERMISSION> SYS_USER_PERMISSION { get; set; }
        public virtual DbSet<SYS_USER_ROLE> SYS_USER_ROLE { get; set; }
        public virtual DbSet<SYS_USERINFO> SYS_USERINFO { get; set; }
        public virtual DbSet<SYS_WEBCHAT> SYS_WEBCHAT { get; set; }
        public virtual DbSet<YW_Bicycle> YW_Bicycle { get; set; }
        public virtual DbSet<YW_CarParamDetails> YW_CarParamDetails { get; set; }
        public virtual DbSet<YW_CarPurchaser> YW_CarPurchaser { get; set; }
        public virtual DbSet<YW_Notice> YW_Notice { get; set; }
        public virtual DbSet<YW_User_Notice> YW_User_Notice { get; set; }
        public virtual DbSet<YW_UserCar> YW_UserCar { get; set; }
        public virtual DbSet<YW_UserDistributor> YW_UserDistributor { get; set; }
        public virtual DbSet<YW_UserToken> YW_UserToken { get; set; }
        public virtual DbSet<SYS_ONLINE> SYS_ONLINE { get; set; }
        public virtual DbSet<SYS_DISTRIBUTORS> SYS_DISTRIBUTORS { get; set; }

        public virtual int PaginationByRowNumber(string table, string sort, Nullable<int> currentPage, Nullable<int> pageSize, string fields, string filter)
        {
            var tableParameter = table != null ?
                new ObjectParameter("Table", table) :
                new ObjectParameter("Table", typeof(string));

            var sortParameter = sort != null ?
                new ObjectParameter("Sort", sort) :
                new ObjectParameter("Sort", typeof(string));

            var currentPageParameter = currentPage.HasValue ?
                new ObjectParameter("CurrentPage", currentPage) :
                new ObjectParameter("CurrentPage", typeof(int));

            var pageSizeParameter = pageSize.HasValue ?
                new ObjectParameter("PageSize", pageSize) :
                new ObjectParameter("PageSize", typeof(int));

            var fieldsParameter = fields != null ?
                new ObjectParameter("Fields", fields) :
                new ObjectParameter("Fields", typeof(string));

            var filterParameter = filter != null ?
                new ObjectParameter("Filter", filter) :
                new ObjectParameter("Filter", typeof(string));

            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("PaginationByRowNumber", tableParameter, sortParameter, currentPageParameter, pageSizeParameter, fieldsParameter, filterParameter);
        }
    }
}