| New file |
| | |
| | | using System.Threading.Tasks; |
| | | using Furion.DynamicApiController; |
| | | using Microsoft.AspNetCore.Mvc; |
| | | using SqlSugar; |
| | | using ZTICInterface.Application; |
| | | using ZTICInterface.Core.Entity; |
| | | using ZTICInterface.Core.Extend; |
| | | |
| | | namespace ZTICInterface.Application.App; |
| | | |
| | | /// <summary> |
| | | /// 行业政策 |
| | | /// </summary> |
| | | public class IndustryPolicyApp:IDynamicApiController |
| | | { |
| | | private readonly Repository<IndustryPolicy> _industryPolicyService; |
| | | public IndustryPolicyApp(Repository<IndustryPolicy> industryPolicyService) |
| | | { |
| | | _industryPolicyService = industryPolicyService; |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 获取分页 |
| | | /// </summary> |
| | | /// <param name="pageIndex"></param> |
| | | /// <param name="pageSize"></param> |
| | | /// <returns></returns> |
| | | public async Task<Page<IndustryPolicy>> GetPages([FromQuery] int pageIndex, [FromQuery] int pageSize) |
| | | { |
| | | return await _industryPolicyService.GetPagesAsync(pageIndex, pageSize,null,a=>a.PublishDate,OrderByType.Desc); |
| | | } |
| | | |
| | | |
| | | } |
| New file |
| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Linq; |
| | | using System.Linq.Expressions; |
| | | using System.Reflection; |
| | | using System.Threading.Tasks; |
| | | using SqlSugar; |
| | | using SqlSugar.IOC; |
| | | using ZTICInterface.Core.Extend; |
| | | |
| | | namespace ZTICInterface.Application; |
| | | |
| | | public class Repository<T> : SimpleClient<T> where T : class, new() |
| | | { |
| | | |
| | | protected ITenant itenant = null;//多租户事务 |
| | | public Repository(ISqlSugarClient context = null) : base(context)//注意这里要有默认值等于null |
| | | { |
| | | //通过特性拿到ConfigId |
| | | var configId = typeof(T).GetCustomAttribute<TenantAttribute>().configId; |
| | | |
| | | |
| | | //方式1:SqlSugar.Ioc用法 |
| | | base.Context = DbScoped.SugarScope.GetConnection(configId);//子Db无租户方法,其他功能都有 |
| | | itenant = DbScoped.SugarScope;//设置租户接口 |
| | | |
| | | |
| | | //方式2:Furion框架中用 |
| | | //base.Context= App.GetService<ISqlSugarClient>().AsTenant().GetConnection(configId); |
| | | //itenant = App.GetService<ISqlSugarClient>().AsTenant() ; |
| | | |
| | | |
| | | //方式3:不用Ioc |
| | | //base.Context=单例的SqlSugarScope.GetConnection(configId); |
| | | //itenant=单例的SqlSugarScope; |
| | | |
| | | |
| | | //方式4:.NET CORE自带的IOC 不推荐 |
| | | //需要自个封装成 SqlSugar.IOC或者Furion框架那种形式赋值,不能用构造函数注入 |
| | | |
| | | } |
| | | |
| | | #region 添加操作 |
| | | /// <summary> |
| | | /// 添加一条数据 |
| | | /// </summary> |
| | | /// <param name="parm">T</param> |
| | | /// <returns></returns> |
| | | public async Task<T> AddAsync(T parm, bool Async = true) |
| | | { |
| | | var dbres = Async ? await Context.Insertable<T>(parm).ExecuteReturnEntityAsync() : Context.Insertable<T>(parm).ExecuteReturnEntity(); |
| | | return dbres; |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 批量添加数据 |
| | | /// </summary> |
| | | /// <param name="parm">List<T></param> |
| | | /// <returns>受影响行数</returns> |
| | | public async Task<int> AddListAsync(List<T> parm, bool Async = true) |
| | | { |
| | | var dbres = Async ? await Context.Insertable<T>(parm).ExecuteCommandAsync() : Context.Insertable<T>(parm).ExecuteCommand(); |
| | | return dbres; |
| | | } |
| | | #endregion |
| | | |
| | | #region 查询操作 |
| | | /// <summary> |
| | | /// 获得一条数据 |
| | | /// </summary> |
| | | /// <param name="where">Expression<Func<T, bool>></param> |
| | | /// <returns></returns> |
| | | public async Task<T> GetModelAsync(Expression<Func<T, bool>> where, bool Async = true) |
| | | { |
| | | var res = Async |
| | | ? await Context.Queryable<T>().FirstAsync(where) |
| | | : Context.Queryable<T>().First(@where); |
| | | return res; |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 获得一条数据 |
| | | /// </summary> |
| | | /// <param name="where">Expression<Func<T, bool>></param> |
| | | /// <returns></returns> |
| | | public async Task<T> GetModelAsync(Expression<Func<T, bool>> where, Expression<Func<T, object>> order, |
| | | OrderByType orderEnum, bool Async = true) |
| | | { |
| | | var res = Async |
| | | ? await Context.Queryable<T>() |
| | | .OrderBy(order, orderEnum) |
| | | .FirstAsync(where) |
| | | : Context.Queryable<T>() |
| | | .OrderBy(order, orderEnum) |
| | | .First(@where); |
| | | return res; |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 获得一条数据 |
| | | /// </summary> |
| | | /// <param name="parm">string</param> |
| | | /// <returns></returns> |
| | | public async Task<T> GetModelAsync(string parm, bool Async = true) |
| | | { |
| | | var res = Async ? await Context.Queryable<T>().Where(parm).FirstAsync() |
| | | : Context.Queryable<T>().Where(parm).First(); |
| | | return res; |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 获得列表——分页 |
| | | /// </summary> |
| | | /// <param name="parm">PageParm</param> |
| | | /// <returns></returns> |
| | | public async Task<Page<T>> GetPagesAsync(int pageIndex, int pageSize, bool Async = true) |
| | | { |
| | | var res = Async ? await Context.Queryable<T>() |
| | | .ToPageAsync(pageIndex, pageSize) : Context.Queryable<T>() |
| | | .ToPage(pageIndex, pageSize); |
| | | return res; |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 分页 |
| | | /// </summary> |
| | | /// <param name="parm">分页参数</param> |
| | | /// <param name="where">条件</param> |
| | | /// <param name="order">排序值</param> |
| | | /// <param name="orderEnum">排序方式OrderByType</param> |
| | | /// <returns></returns> |
| | | public async Task<Page<T>> GetPagesAsync(int pageIndex, int pageSize, Expression<Func<T, bool>> where, |
| | | Expression<Func<T, object>> order, OrderByType orderEnum, bool Async = true) |
| | | { |
| | | var query = Context.Queryable<T>() |
| | | .WhereIF(where != null, where) |
| | | .OrderBy(order, orderEnum); |
| | | var res = Async ? await query.ToPageAsync(pageIndex, pageSize) : query.ToPage(pageIndex, pageSize); |
| | | return res; |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 获得列表 |
| | | /// </summary> |
| | | /// <param name="parm">PageParm</param> |
| | | /// <returns></returns> |
| | | public async Task<List<T>> GetListAsync(Expression<Func<T, bool>> where, |
| | | Expression<Func<T, object>> order, OrderByType orderEnum, bool Async = true) |
| | | { |
| | | var query = Context.Queryable<T>() |
| | | .WhereIF(where != null, where) |
| | | .OrderBy(order, orderEnum); |
| | | var res = Async ? await query.ToListAsync() : query.ToList(); |
| | | return res; |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 获得列表 |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | public async Task<List<T>> GetListAsync(Expression<Func<T, bool>> where = null, bool Async = true) |
| | | { |
| | | var quary = where == null ? Context.Queryable<T>() : Context.Queryable<T>().Where(where); |
| | | var res = Async ? await quary.ToListAsync() : quary.ToList(); |
| | | return res; |
| | | } |
| | | #endregion |
| | | |
| | | #region 修改操作 |
| | | /// <summary> |
| | | /// 修改一条数据 |
| | | /// </summary> |
| | | /// <param name="parm">T</param> |
| | | /// <returns>是否成功</returns> |
| | | public async Task<bool> UpdateAsync(T parm, string[] updateCols = null, bool Async = true) |
| | | { |
| | | var res = Async ? |
| | | await Context.Updateable<T>(parm).UpdateColumnsIF(updateCols != null && updateCols.Any(), updateCols).ExecuteCommandHasChangeAsync() |
| | | : Context.Updateable<T>(parm).UpdateColumnsIF(updateCols != null && updateCols.Any(), updateCols).ExecuteCommandHasChange(); |
| | | return res; |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 批量修改 |
| | | /// </summary> |
| | | /// <param name="parm">T</param> |
| | | /// <returns>受影响行数</returns> |
| | | public async Task<int> UpdateAsync(List<T> parm, bool Async = true) |
| | | { |
| | | var res = Async ? await Context.Updateable<T>(parm).ExecuteCommandAsync() : Context.Updateable<T>(parm).ExecuteCommand(); |
| | | return res; |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 修改一条数据,可用作假删除 |
| | | /// </summary> |
| | | /// <param name="columns">修改的列=Expression<Func<T,T>></param> |
| | | /// <param name="where">Expression<Func<T,bool>></param> |
| | | /// <returns>受影响行数</returns> |
| | | public async Task<int> UpdateAsync(Expression<Func<T, T>> columns, |
| | | Expression<Func<T, bool>> where, bool Async = true) |
| | | { |
| | | var res = Async ? await Context.Updateable<T>().SetColumns(columns).Where(where).ExecuteCommandAsync() |
| | | : Context.Updateable<T>().SetColumns(columns).Where(where).ExecuteCommand(); |
| | | return res; |
| | | } |
| | | #endregion |
| | | |
| | | #region 删除操作 |
| | | /// <summary> |
| | | /// 删除一条或多条数据 |
| | | /// </summary> |
| | | /// <param name="parm">string</param> |
| | | /// <returns>受影响行数</returns> |
| | | public async Task<int> DeleteAsync(string parm, bool Async = true) |
| | | { |
| | | var list = parm.Split(','); |
| | | var res = Async ? await Context.Deleteable<T>().In(list).ExecuteCommandAsync() : Context.Deleteable<T>().In(list).ExecuteCommand(); |
| | | return res; |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 删除一条或多条数据 |
| | | /// </summary> |
| | | /// <param name="where">Expression<Func<T, bool>></param> |
| | | /// <returns>受影响行数</returns> |
| | | public async Task<int> DeleteAsync(Expression<Func<T, bool>> where, bool Async = true) |
| | | { |
| | | var res = Async ? await Context.Deleteable<T>().Where(where).ExecuteCommandAsync() : Context.Deleteable<T>().Where(where).ExecuteCommand(); |
| | | return res; |
| | | } |
| | | #endregion |
| | | |
| | | #region 查询Count |
| | | public async Task<int> CountAsync(Expression<Func<T, bool>> where, bool Async = true) |
| | | { |
| | | var res = Async ? await Context.Queryable<T>().CountAsync(where) : Context.Queryable<T>().Count(where); |
| | | return res; |
| | | } |
| | | #endregion |
| | | |
| | | #region 是否存在 |
| | | public async Task<bool> IsExistAsync(Expression<Func<T, bool>> where, bool Async = true) |
| | | { |
| | | var res = Async ? await Context.Queryable<T>().AnyAsync(where) : Context.Queryable<T>().Any(where); |
| | | return res; |
| | | } |
| | | #endregion |
| | | } |
| | | |
| | |
| | | </ItemGroup> |
| | | |
| | | <ItemGroup> |
| | | <Folder Include="System\Services\" /> |
| | | <Folder Include="Service\" /> |
| | | <Folder Include="App\" /> |
| | | </ItemGroup> |
| | | |
| | | </Project> |
| | |
| | | <name>ZTICInterface.Application</name> |
| | | </assembly> |
| | | <members> |
| | | <member name="T:ZTICInterface.Application.App.IndustryPolicyApp"> |
| | | <summary> |
| | | 行业政策 |
| | | </summary> |
| | | </member> |
| | | <member name="M:ZTICInterface.Application.App.IndustryPolicyApp.GetPages(System.Int32,System.Int32)"> |
| | | <summary> |
| | | 获取分页 |
| | | </summary> |
| | | <param name="pageIndex"></param> |
| | | <param name="pageSize"></param> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:ZTICInterface.Application.Base.Repository`1.AddAsync(`0,System.Boolean)"> |
| | | <summary> |
| | | 添加一条数据 |
| | | </summary> |
| | | <param name="parm">T</param> |
| | | <returns></returns> |
| | | </member> |
| | | <!-- Badly formed XML comment ignored for member "M:ZTICInterface.Application.Base.Repository`1.AddListAsync(System.Collections.Generic.List{`0},System.Boolean)" --> |
| | | <!-- Badly formed XML comment ignored for member "M:ZTICInterface.Application.Base.Repository`1.GetModelAsync(System.Linq.Expressions.Expression{System.Func{`0,System.Boolean}},System.Boolean)" --> |
| | | <!-- Badly formed XML comment ignored for member "M:ZTICInterface.Application.Base.Repository`1.GetModelAsync(System.Linq.Expressions.Expression{System.Func{`0,System.Boolean}},System.Linq.Expressions.Expression{System.Func{`0,System.Object}},SqlSugar.OrderByType,System.Boolean)" --> |
| | | <member name="M:ZTICInterface.Application.Base.Repository`1.GetModelAsync(System.String,System.Boolean)"> |
| | | <summary> |
| | | 获得一条数据 |
| | | </summary> |
| | | <param name="parm">string</param> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:ZTICInterface.Application.Base.Repository`1.GetPagesAsync(System.Int32,System.Int32,System.Boolean)"> |
| | | <summary> |
| | | 获得列表——分页 |
| | | </summary> |
| | | <param name="parm">PageParm</param> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:ZTICInterface.Application.Base.Repository`1.GetPagesAsync(System.Int32,System.Int32,System.Linq.Expressions.Expression{System.Func{`0,System.Boolean}},System.Linq.Expressions.Expression{System.Func{`0,System.Object}},SqlSugar.OrderByType,System.Boolean)"> |
| | | <summary> |
| | | 分页 |
| | | </summary> |
| | | <param name="parm">分页参数</param> |
| | | <param name="where">条件</param> |
| | | <param name="order">排序值</param> |
| | | <param name="orderEnum">排序方式OrderByType</param> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:ZTICInterface.Application.Base.Repository`1.GetListAsync(System.Linq.Expressions.Expression{System.Func{`0,System.Boolean}},System.Linq.Expressions.Expression{System.Func{`0,System.Object}},SqlSugar.OrderByType,System.Boolean)"> |
| | | <summary> |
| | | 获得列表 |
| | | </summary> |
| | | <param name="parm">PageParm</param> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:ZTICInterface.Application.Base.Repository`1.GetListAsync(System.Linq.Expressions.Expression{System.Func{`0,System.Boolean}},System.Boolean)"> |
| | | <summary> |
| | | 获得列表 |
| | | </summary> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:ZTICInterface.Application.Base.Repository`1.UpdateAsync(`0,System.String[],System.Boolean)"> |
| | | <summary> |
| | | 修改一条数据 |
| | | </summary> |
| | | <param name="parm">T</param> |
| | | <returns>是否成功</returns> |
| | | </member> |
| | | <member name="M:ZTICInterface.Application.Base.Repository`1.UpdateAsync(System.Collections.Generic.List{`0},System.Boolean)"> |
| | | <summary> |
| | | 批量修改 |
| | | </summary> |
| | | <param name="parm">T</param> |
| | | <returns>受影响行数</returns> |
| | | </member> |
| | | <!-- Badly formed XML comment ignored for member "M:ZTICInterface.Application.Base.Repository`1.UpdateAsync(System.Linq.Expressions.Expression{System.Func{`0,`0}},System.Linq.Expressions.Expression{System.Func{`0,System.Boolean}},System.Boolean)" --> |
| | | <member name="M:ZTICInterface.Application.Base.Repository`1.DeleteAsync(System.String,System.Boolean)"> |
| | | <summary> |
| | | 删除一条或多条数据 |
| | | </summary> |
| | | <param name="parm">string</param> |
| | | <returns>受影响行数</returns> |
| | | </member> |
| | | <!-- Badly formed XML comment ignored for member "M:ZTICInterface.Application.Base.Repository`1.DeleteAsync(System.Linq.Expressions.Expression{System.Func{`0,System.Boolean}},System.Boolean)" --> |
| | | <member name="T:ZTICInterface.Application.SystemAppService"> |
| | | <summary> |
| | | 系统服务接口 |
| New file |
| | |
| | | using SqlSugar; |
| | | |
| | | namespace ZTICInterface.Core.Entity; |
| | | |
| | | public class BaseEntity |
| | | { |
| | | |
| | | /// <summary> |
| | | /// 自增主键 |
| | | /// </summary> |
| | | [SugarColumn(IsIdentity = true,IsPrimaryKey = true)] |
| | | public int Id { get; set; } |
| | | } |
| New file |
| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Linq; |
| | | using System.Text; |
| | | using System.Threading.Tasks; |
| | | using SqlSugar; |
| | | |
| | | namespace ZTICInterface.Core.Entity |
| | | { |
| | | /// <summary> |
| | | /// 行业政策 |
| | | /// </summary> |
| | | [Tenant("1")] |
| | | public class IndustryPolicy:BaseEntity |
| | | { |
| | | /// <summary> |
| | | /// 日期 |
| | | /// </summary> |
| | | public DateTime PublishDate { get; set; } |
| | | /// <summary> |
| | | /// 发布单位 |
| | | /// </summary> |
| | | public string Organization { get; set; } |
| | | /// <summary> |
| | | /// 政策名称 |
| | | /// </summary> |
| | | public string Title { get; set; } |
| | | /// <summary> |
| | | /// 主要内容 |
| | | /// </summary> |
| | | public string Content { get; set; } |
| | | /// <summary> |
| | | /// 国家 |
| | | /// </summary> |
| | | public string Country { get; set; } |
| | | /// <summary> |
| | | /// 区域 |
| | | /// </summary> |
| | | public string Area { get; set; } |
| | | /// <summary> |
| | | /// 政策性质 |
| | | /// </summary> |
| | | public string Type { get; set; } |
| | | /// <summary> |
| | | /// 链接 |
| | | /// </summary> |
| | | public string Url { get; set; } |
| | | } |
| | | } |
| New file |
| | |
| | | using System.Collections.Generic; |
| | | using System.Threading.Tasks; |
| | | using SqlSugar; |
| | | |
| | | namespace ZTICInterface.Core.Extend; |
| | | |
| | | public class Page<T> |
| | | { |
| | | /// <summary> |
| | | /// 当前页索引 |
| | | /// </summary> |
| | | public int PageIndex { get; set; } |
| | | /// <summary> |
| | | /// 总页数 |
| | | /// </summary> |
| | | public int TotalPages => TotalItems != 0 ? (TotalItems % PageSize) == 0 ? (TotalItems / PageSize) : (TotalItems / PageSize) + 1 : 0; |
| | | /// <summary> |
| | | /// 总记录数 |
| | | /// </summary> |
| | | public int TotalItems { get; set; } |
| | | /// <summary> |
| | | /// 每页的记录数 |
| | | /// </summary> |
| | | public int PageSize { get; set; } |
| | | /// <summary> |
| | | /// 数据集 |
| | | /// </summary> |
| | | public List<T> Items { get; set; } |
| | | } |
| | | |
| | | public static class PageExtension |
| | | { |
| | | /// <summary> |
| | | /// 读取列表QueryableExtension |
| | | /// </summary> |
| | | /// <typeparam name="T"></typeparam> |
| | | /// <param name="query"></param> |
| | | /// <param name="pageIndex"></param> |
| | | /// <param name="pageSize"></param> |
| | | /// <param name="isOrderBy"></param> |
| | | /// <returns></returns> |
| | | public static async Task<Page<T>> ToPageAsync<T>(this ISugarQueryable<T> query, |
| | | int pageIndex, |
| | | int pageSize, |
| | | bool isOrderBy = false) |
| | | { |
| | | RefAsync<int> totalItems = 0; |
| | | var page = new Page<T>(); |
| | | page.Items = await query.ToPageListAsync(pageIndex, pageSize, totalItems); |
| | | page.PageIndex = pageIndex; |
| | | page.PageSize = pageSize; |
| | | page.TotalItems = totalItems; |
| | | return page; |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 读取列表 |
| | | /// </summary> |
| | | /// <typeparam name="T"></typeparam> |
| | | /// <param name="query"></param> |
| | | /// <param name="pageIndex"></param> |
| | | /// <param name="pageSize"></param> |
| | | /// <param name="isOrderBy"></param> |
| | | /// <returns></returns> |
| | | public static Page<T> ToPage<T>(this ISugarQueryable<T> query, |
| | | int pageIndex, |
| | | int pageSize, |
| | | bool isOrderBy = false) |
| | | { |
| | | var page = new Page<T>(); |
| | | var totalItems = 0; |
| | | page.Items = query.ToPageList(pageIndex, pageSize, ref totalItems); |
| | | page.PageIndex = pageIndex; |
| | | page.PageSize = pageSize; |
| | | page.TotalItems = totalItems; |
| | | return page; |
| | | } |
| | | } |
| | |
| | | using Microsoft.Extensions.Configuration; |
| | | using Microsoft.Extensions.DependencyInjection; |
| | | using SqlSugar; |
| | | using SqlSugar.IOC; |
| | | |
| | | namespace ZTICInterface.Core; |
| | | |
| | | public static class SqlsugarSetup |
| | | { |
| | | public static void AddSqlsugarSetup(this IServiceCollection services, IConfiguration configuration, string dbName = "db_master") |
| | | public static void AddSqlsugarSetup(this IServiceCollection services) |
| | | { |
| | | //如果多个数数据库传 List<ConnectionConfig> |
| | | var configConnection = new ConnectionConfig() |
| | | |
| | | services.AddSqlSugar(new IocConfig() |
| | | { |
| | | DbType = (DbType)Enum.Parse(typeof(DbType), App.Configuration["DatabaseSettings:Data:DbType"]), |
| | | ConnectionString = App.Configuration["DatabaseSettings:MainDb:ConnectionString"], |
| | | ConnectionString = App.Configuration["DatabaseSettings:MainDb:ConnectionString"],//连接符字串 |
| | | DbType = (IocDbType)Enum.Parse(typeof(IocDbType), App.Configuration["DatabaseSettings:MainDb:DbType"]), |
| | | IsAutoCloseConnection = true, |
| | | }; |
| | | |
| | | SqlSugarScope sqlSugar = new SqlSugarScope(configConnection, |
| | | db => |
| | | ConfigId = "1", |
| | | }); |
| | | |
| | | services.ConfigurationSugar(db => |
| | | { |
| | | db.GetConnection("1").Aop.OnLogExecuting = (sql, p) => |
| | | { |
| | | //单例参数配置,所有上下文生效 |
| | | db.Aop.OnLogExecuting = (sql, p) => |
| | | { |
| | | Console.WriteLine(SqlProfiler.ParameterFormat(sql, p)); |
| | | Console.WriteLine(); |
| | | App.PrintToMiniProfiler("SqlSugar", "Info", SqlProfiler.ParameterFormat(sql, p)); |
| | | }; |
| | | }); |
| | | |
| | | services.AddSingleton<ISqlSugarClient>(sqlSugar);//这边是SqlSugarScope用AddSingleton |
| | | Console.WriteLine(SqlProfiler.ParameterFormat(sql, p)); |
| | | Console.WriteLine(); |
| | | App.PrintToMiniProfiler("SqlSugar", "Info", SqlProfiler.ParameterFormat(sql, p)); |
| | | }; |
| | | |
| | | }); |
| | | } |
| | | |
| | | |
| | |
| | | <name>ZTICInterface.Core</name> |
| | | </assembly> |
| | | <members> |
| | | <member name="P:ZTICInterface.Core.Entity.BaseEntity.Id"> |
| | | <summary> |
| | | 自增主键 |
| | | </summary> |
| | | </member> |
| | | <member name="T:ZTICInterface.Core.Entity.IndustryPolicy"> |
| | | <summary> |
| | | 行业政策 |
| | | </summary> |
| | | </member> |
| | | <member name="P:ZTICInterface.Core.Entity.IndustryPolicy.PublishDate"> |
| | | <summary> |
| | | 日期 |
| | | </summary> |
| | | </member> |
| | | <member name="P:ZTICInterface.Core.Entity.IndustryPolicy.Organization"> |
| | | <summary> |
| | | 发布单位 |
| | | </summary> |
| | | </member> |
| | | <member name="P:ZTICInterface.Core.Entity.IndustryPolicy.Title"> |
| | | <summary> |
| | | 政策名称 |
| | | </summary> |
| | | </member> |
| | | <member name="P:ZTICInterface.Core.Entity.IndustryPolicy.Content"> |
| | | <summary> |
| | | 主要内容 |
| | | </summary> |
| | | </member> |
| | | <member name="P:ZTICInterface.Core.Entity.IndustryPolicy.Country"> |
| | | <summary> |
| | | 国家 |
| | | </summary> |
| | | </member> |
| | | <member name="P:ZTICInterface.Core.Entity.IndustryPolicy.Area"> |
| | | <summary> |
| | | 区域 |
| | | </summary> |
| | | </member> |
| | | <member name="P:ZTICInterface.Core.Entity.IndustryPolicy.Type"> |
| | | <summary> |
| | | 政策性质 |
| | | </summary> |
| | | </member> |
| | | <member name="P:ZTICInterface.Core.Entity.IndustryPolicy.Url"> |
| | | <summary> |
| | | 链接 |
| | | </summary> |
| | | </member> |
| | | <member name="T:ZTICInterface.Core.Extend.MyConstant.MyCacheKey"> |
| | | <summary> |
| | | 缓存key |
| | | </summary> |
| | | </member> |
| | | <member name="F:ZTICInterface.Core.Extend.MyConstant.MyCacheKey.FeedSelfPageCol"> |
| | | <summary> |
| | | 自建进料page显示列 |
| | | </summary> |
| | | </member> |
| | | <member name="F:ZTICInterface.Core.Extend.MyConstant.MyCacheKey.FeedHistoryPageCol"> |
| | | <summary> |
| | | 历史进料page显示列 |
| | | </summary> |
| | | </member> |
| | | <member name="F:ZTICInterface.Core.Extend.MyConstant.MyCacheKey.CasePageCol"> |
| | | <summary> |
| | | 工况page显示列 |
| | | </summary> |
| | | </member> |
| | | <member name="P:ZTICInterface.Core.Extend.Page`1.PageIndex"> |
| | | <summary> |
| | | 当前页索引 |
| | | </summary> |
| | | </member> |
| | | <member name="P:ZTICInterface.Core.Extend.Page`1.TotalPages"> |
| | | <summary> |
| | | 总页数 |
| | | </summary> |
| | | </member> |
| | | <member name="P:ZTICInterface.Core.Extend.Page`1.TotalItems"> |
| | | <summary> |
| | | 总记录数 |
| | | </summary> |
| | | </member> |
| | | <member name="P:ZTICInterface.Core.Extend.Page`1.PageSize"> |
| | | <summary> |
| | | 每页的记录数 |
| | | </summary> |
| | | </member> |
| | | <member name="P:ZTICInterface.Core.Extend.Page`1.Items"> |
| | | <summary> |
| | | 数据集 |
| | | </summary> |
| | | </member> |
| | | <member name="M:ZTICInterface.Core.Extend.PageExtension.ToPageAsync``1(SqlSugar.ISugarQueryable{``0},System.Int32,System.Int32,System.Boolean)"> |
| | | <summary> |
| | | 读取列表QueryableExtension |
| | | </summary> |
| | | <typeparam name="T"></typeparam> |
| | | <param name="query"></param> |
| | | <param name="pageIndex"></param> |
| | | <param name="pageSize"></param> |
| | | <param name="isOrderBy"></param> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:ZTICInterface.Core.Extend.PageExtension.ToPage``1(SqlSugar.ISugarQueryable{``0},System.Int32,System.Int32,System.Boolean)"> |
| | | <summary> |
| | | 读取列表 |
| | | </summary> |
| | | <typeparam name="T"></typeparam> |
| | | <param name="query"></param> |
| | | <param name="pageIndex"></param> |
| | | <param name="pageSize"></param> |
| | | <param name="isOrderBy"></param> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:ZTICInterface.Core.Extend.TranReturn.Return``1(SqlSugar.DbResult{``0})"> |
| | | <summary> |
| | | 事务返回 |
| | | </summary> |
| | | <typeparam name="TR"></typeparam> |
| | | <param name="result"></param> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="T:ZTICInterface.Core.RESTfulResultProvider"> |
| | | <summary> |
| | | RESTful 风格返回值 |
| | | </summary> |
| | | </member> |
| | | <member name="M:ZTICInterface.Core.RESTfulResultProvider.OnException(Microsoft.AspNetCore.Mvc.Filters.ExceptionContext,Furion.UnifyResult.Internal.ExceptionMetadata)"> |
| | | <summary> |
| | | 异常返回值 |
| | | </summary> |
| | | <param name="context"></param> |
| | | <param name="metadata"></param> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:ZTICInterface.Core.RESTfulResultProvider.OnSucceeded(Microsoft.AspNetCore.Mvc.Filters.ActionExecutedContext,System.Object)"> |
| | | <summary> |
| | | 成功返回值 |
| | | </summary> |
| | | <param name="context"></param> |
| | | <param name="data"></param> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:ZTICInterface.Core.RESTfulResultProvider.OnValidateFailed(Microsoft.AspNetCore.Mvc.Filters.ActionExecutingContext,Furion.DataValidation.ValidationMetadata)"> |
| | | <summary> |
| | | 验证失败返回值 |
| | | </summary> |
| | | <param name="context"></param> |
| | | <param name="metadata"></param> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:ZTICInterface.Core.RESTfulResultProvider.OnResponseStatusCodes(Microsoft.AspNetCore.Http.HttpContext,System.Int32,Furion.UnifyResult.UnifyResultSettingsOptions)"> |
| | | <summary> |
| | | 特定状态码返回值 |
| | | </summary> |
| | | <param name="context"></param> |
| | | <param name="statusCode"></param> |
| | | <param name="unifyResultSettings"></param> |
| | | <returns></returns> |
| | | </member> |
| | | <member name="M:ZTICInterface.Core.RESTfulResultProvider.RESTfulResult(System.Int32,System.Boolean,System.Object,System.String,System.Object)"> |
| | | <summary> |
| | | 返回 RESTful 风格结果集 |
| | | </summary> |
| | | <param name="statusCode"></param> |
| | | <param name="succeeded"></param> |
| | | <param name="msg"></param> |
| | | <param name="data"></param> |
| | | <param name="errors"></param> |
| | | <returns></returns> |
| | | </member> |
| | | </members> |
| | | </doc> |
| | |
| | | using Newtonsoft.Json; |
| | | using Newtonsoft.Json.Serialization; |
| | | using ZTICInterface.Application.Base; |
| | | using ZTICInterface.Core; |
| | | |
| | | var builder = WebApplication.CreateBuilder(args).Inject(); |
| | | |
| | | builder.Services.AddControllers() |
| | | .AddInjectWithUnifyResult<RESTfulResultProvider>() |
| | | //.AddInjectWithUnifyResult<RESTfulResultProvider>() |
| | | .AddNewtonsoftJson(options => |
| | | { |
| | | options.SerializerSettings.ContractResolver = |
| | |
| | | options.SerializerSettings.DateTimeZoneHandling = DateTimeZoneHandling.Local; |
| | | options.SerializerSettings.DateFormatString = "yyyy-MM-dd HH:mm:ss"; |
| | | options.SerializerSettings.ReferenceLoopHandling = ReferenceLoopHandling.Ignore; //忽略循环引用 |
| | | }); |
| | | }) |
| | | ; |
| | | |
| | | |
| | | |
| | | builder.Services.AddSqlsugarSetup(); |
| | | builder.Services.AddSingleton(typeof(Repository<>)); |
| | | |
| | | |
| | | |