itcast.crm.IServices/base/IBaseServices.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace itcast.crm.IServices
{
    using System.Linq.Expressions;
    public interface IBaseServices<TEntity> where TEntity : class
    {
        #region 查询
        /// <summary>
        /// 带条件 查询的
        /// </summary>
        /// <param name="where">sql条件</param>
        /// <returns></returns>
        IQueryable<TEntity> QueryWhere(Expression<Func<TEntity, bool>> where);
        /// <summary>
        /// 带条件的 连表查询
        /// </summary>
        /// <param name="where">sql条件</param>
        /// <param name="tablenames">连表</param>
        /// <returns></returns>
        IQueryable<TEntity> QueryJoinWhere(Expression<Func<TEntity, bool>> where, string[] tablenames);
        /// <summary>
        /// 带条件的分页查询
        /// </summary>
        /// <param name="pagesize">第几页</param>
        /// <param name="pagecount">每页总条数</param>
        /// <param name="tcount"></param>
        /// <param name="where">sql条件</param>
        /// <param name="order">排序</param>
        /// <returns></returns>
        IQueryable<TEntity> QueryByPage<TKey>(int pageIndex, int pageSize, out int tcount, Expression<Func<TEntity, bool>> where, Expression<Func<TEntity, TKey>> order);
        /// <summary>
        /// 带条件的连表分页查询
        /// </summary>
        /// <param name="pagesize">第几页</param>
        /// <param name="pagecount">每页总条数</param>
        /// <param name="tcount"></param>
        /// <param name="where">sql条件</param>
        /// <param name="order">排序</param>
        /// <param name="tablenames">连表</param>
        /// <returns></returns>
        IQueryable<TEntity> QueryByPage<TKey>(int pageIndex, int pageSize, out int tcount, Expression<Func<TEntity, bool>> where, Expression<Func<TEntity, TKey>> order, string[] tablenames);

        /// <summary>
        /// 执行一条sql语句或者一个存储过程
        /// </summary>
        /// <typeparam name="TElement"></typeparam>
        /// <param name="sql"></param>
        /// <param name="parms"></param>
        /// <returns></returns>
        List<TElement> RunSql<TElement>(string sql, params object[] parms);
        #endregion

        #region 新增
        /// <summary>
        /// 新增