/// <summary>
/// 新增.
/// </summary>
/// <param name="entity">数据实体.</param>
/// <returns>返回主键值.</returns>
public async Task <BaseResult <SickEntity> > Add(SickEntity entity)
{
string insertSql = @"INSERT INTO dbo.tbSick(title, overview,acupoint,pathogeny,analysis,food) VALUES(@title, @overview,@acupoint,@pathogeny,@analysis,@food) select @@identity";
var result = new BaseResult <SickEntity>();
try
{
var i = await Add(entity, insertSql);
if (null != i && i > 0)
{
result.code = ResultKey.RETURN_SUCCESS_CODE;
result.desc = ResultKey.RETURN_SUCCESS_DESC;
}
else
{
result.code = ResultKey.RETURN_FAIL_CODE;
result.desc = ResultKey.RETURN_FAIL_DESC;
}
}
catch (Exception ex)
{
NlogHelper.InfoLog(ex.Message);
throw new Exception(ex.Message);
}
return(result);
}
/// <summary>
/// 新增.
/// </summary>
/// <param name="entity">数据实体.</param>
/// <returns>返回主键值.</returns>
public async Task <BaseResult <AcupointEntity> > Add(AcupointEntity entity)
{
string insertSql = @"INSERT INTO dbo.tbAcupoint(name, findout,overview,info,handle,image) VALUES(@name, @findout,@overview,@info,@handle,@image) select @@identity";
var result = new BaseResult <AcupointEntity>();
try
{
var i = await Add(entity, insertSql);
if (null != i && i > 0)
{
result.code = ResultKey.RETURN_SUCCESS_CODE;
result.desc = ResultKey.RETURN_SUCCESS_DESC;
}
else
{
result.code = ResultKey.RETURN_FAIL_CODE;
result.desc = ResultKey.RETURN_FAIL_DESC;
}
}
catch (Exception ex)
{
NlogHelper.InfoLog(ex.Message);
throw new Exception(ex.Message);
}
return(result);
}
/// <summary>
/// 新增.
/// </summary>
/// <param name="entity">数据实体.</param>
/// <returns>返回主键值.</returns>
public async Task <BaseResult <FoodEntity> > Add(FoodEntity entity)
{
string insertSql = @"INSERT INTO dbo.tbFood(name, image,material,method,act) VALUES(@name, @image,@material,@method,@act) select @@identity";
var result = new BaseResult <FoodEntity>();
try
{
var i = await Add(entity, insertSql);
if (null != i && i > 0)
{
result.code = ResultKey.RETURN_SUCCESS_CODE;
result.desc = ResultKey.RETURN_SUCCESS_DESC;
}
else
{
result.code = ResultKey.RETURN_FAIL_CODE;
result.desc = ResultKey.RETURN_FAIL_DESC;
}
}
catch (Exception ex)
{
NlogHelper.InfoLog(ex.Message);
throw new Exception(ex.Message);
}
return(result);
}
/// <summary>
/// 修改.
/// </summary>
/// <param name="entity">.</param>
/// <returns>.</returns>
public async Task <BaseResult <FoodEntity> > Update(FoodEntity entity)
{
StringBuilder sb = new StringBuilder();
string detailSql = @"SELECT * FROM dbo.tbFood WHERE id=@id";
var i = await Detail(entity.id, detailSql);
if (i == null)
{
throw new Exception("数据不存在");
}
sb.AppendFormat(@"UPDATE dbo.tbFood SET name = '{0}', material ='{1}', method = '{2}', act ='{3}',image='{4}' WHERE id={5} ", entity.name, entity.material, entity.method, entity.act, entity.image, entity.id);
var result = new BaseResult <FoodEntity>();
try
{
await Update(entity, sb.ToString());
result.code = ResultKey.RETURN_SUCCESS_CODE;
result.desc = ResultKey.RETURN_SUCCESS_DESC;
}
catch (Exception ex)
{
NlogHelper.InfoLog(ex.Message);
throw new Exception(ex.Message);
}
return(result);
}
/// <summary>
/// 新增
/// </summary>
/// <param name="entity">数据实体</param>
/// <returns>返回主键值</returns>
public async Task <BaseResult <UserEntity> > Add(UserEntity entity)
{
string insertSql = @"INSERT INTO [dbo].[tbUser](userName, passWord,age) VALUES(@userName, @passWord,@age) select @@identity";
var result = new BaseResult <UserEntity>();
try
{
var i = await Add(entity, insertSql);
if (null != i && i > 0)
{
result.code = ResultKey.RETURN_SUCCESS_CODE;
result.desc = ResultKey.RETURN_SUCCESS_DESC;
}
else
{
result.code = ResultKey.RETURN_FAIL_CODE;
result.desc = ResultKey.RETURN_FAIL_DESC;
}
}
catch (Exception ex)
{
NlogHelper.InfoLog(ex.Message);
result.code = ResultKey.RETURN_EXCEPTION_CODE;
result.desc = ResultKey.RETURN_EXCEPTION_DESC;
}
return(result);
}
/// <summary>
/// 登录.
/// </summary>
/// <param name="entity">The entity<see cref="UserEntity"/>.</param>
/// <returns>.</returns>
public async Task <BaseResult <UserEntity> > Login(UserEntity entity)
{
var result = new BaseResult <UserEntity>();
string selectSql = string.Format(@"SELECT * FROM dbo.tbUser where IsDelete=0 and userName='******' and passWord='******'", entity.userName, entity.passWord);
try
{
var qList = await Select(selectSql);
if (qList.Count > 0)
{
result.code = ResultKey.RETURN_SUCCESS_CODE;
result.data = new PageData <UserEntity> {
list = qList, total = qList.Count
};
result.desc = ResultKey.RETURN_SUCCESS_DESC;
}
else
{
result.code = ResultKey.RETURN_FAIL_CODE;
result.desc = "帐号或密码错误！";
}
}
catch (Exception ex)
{
NlogHelper.InfoLog(ex.Message);
throw new Exception(ex.Message);
}
return(result);
}
/// <summary>
/// 更新.
/// </summary>
/// <param name="modal">The modal<see cref="UserDTO"/>.</param>
/// <returns>.</returns>
public async Task <BaseResult <UserEntity> > Update(UserDTO modal)
{
string updateSql = string.Format(@"UPDATE dbo.tbUser SET passWord='******',isManager={1} where userId={2}", modal.newPassword, modal.isManager, modal.userId);
var result = new BaseResult <UserEntity>();
UserEntity entity = new UserEntity()
{
userId = modal.userId,
passWord = modal.newPassword,
isManager = modal.isManager,
};
try
{
await Update(entity, updateSql.ToString());
result.code = ResultKey.RETURN_SUCCESS_CODE;
result.desc = ResultKey.RETURN_SUCCESS_DESC;
}
catch (Exception ex)
{
NlogHelper.InfoLog(ex.Message);
throw new Exception(ex.Message);
}
return(result);
}
/// <summary>
/// 按条件删除.
/// </summary>
/// <param name="conditionStr">The conditionStr<see cref="string"/>.</param>
/// <returns>受影响都行数.</returns>
public async Task <BaseResult <UserEntity> > DeleteBy(string conditionStr)
{
string deleteSql = "UPDATE dbo.tbUser SET IsDelete=1 WHERE 1=1 and " + conditionStr;
var result = new BaseResult <UserEntity>();
try
{
var i = await DeleteBy(deleteSql);
if (null != i)
{
result.code = ResultKey.RETURN_SUCCESS_CODE;
result.desc = ResultKey.RETURN_SUCCESS_DESC;
}
else
{
result.code = ResultKey.RETURN_FAIL_CODE;
result.desc = ResultKey.RETURN_FAIL_DESC;
}
}
catch (Exception ex)
{
NlogHelper.InfoLog(ex.Message);
throw new Exception(ex.Message);
}
return(result);
}
/// <summary>
/// 判断用户是否收藏.
/// </summary>
/// <param name="query">.</param>
/// <returns>.</returns>
public async Task <BaseResult <IsCollectDTO> > IsCollect(IsCollectDTO query)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat(@"SELECT * FROM dbo.tbUserCollect WHERE userId = {0} AND objId = {1} AND type={2}", query.userId, query.objId, query.type);
var result = new BaseResult <IsCollectDTO>();
try
{
var i = await DetailBy(sb.ToString());
if (i != null)
{
query.isCollect = true;
}
else
{
query.isCollect = false;
}
result.code = ResultKey.RETURN_SUCCESS_CODE;
result.data = new PageData <IsCollectDTO> {
list = new List <IsCollectDTO>()
{
query
}, total = 1
};
result.desc = ResultKey.RETURN_SUCCESS_DESC;
}
catch (Exception ex)
{
NlogHelper.InfoLog(ex.Message);
throw new Exception(ex.Message);
}
return(result);
}
/// <summary>
/// 新增收藏记录.
/// </summary>
/// <param name="entity">.</param>
/// <returns>.</returns>
public async Task <BaseResult <UserCollectEntity> > Add(UserCollectEntity entity)
{
string insertSql = @"INSERT INTO dbo.tbUserCollect(userId, objId,type,name,createDate) VALUES(@userId, @objId,@type,@name,getdate()) select @@identity";
var result = new BaseResult <UserCollectEntity>();
try
{
var i = await Add(entity, insertSql);
if (null != i && i > 0)
{
result.code = ResultKey.RETURN_SUCCESS_CODE;
result.desc = ResultKey.RETURN_SUCCESS_DESC;
}
else
{
result.code = ResultKey.RETURN_FAIL_CODE;
result.desc = ResultKey.RETURN_FAIL_DESC;
}
}
catch (Exception ex)
{
NlogHelper.InfoLog(ex.Message);
throw new Exception(ex.Message);
}
return(result);
}
public void OnException(ExceptionContext context)
{
var json = new JsonErrorResponse();
//这里面是自定义的操作记录日志
if (context.Exception.GetType() == typeof(UserOperationException))
{
json.Message = context.Exception.Message;
if (_env.IsDevelopment())
{
json.DevelopmentMessage = context.Exception.StackTrace; //堆栈信息
}
context.Result = new BadRequestObjectResult(json); //返回异常数据
}
else
{
json.Message = "发生了未知内部错误";
if (_env.IsDevelopment())
{
json.DevelopmentMessage = context.Exception.StackTrace;//堆栈信息
}
context.Result = new InternalServerErrorObjectResult(json);
}
//采用NLog 进行错误日志记录
NlogHelper.ErrorLog(json.Message, context.Exception);
}
/// <summary>
/// 修改.
/// </summary>
/// <param name="entity">.</param>
/// <returns>.</returns>
public async Task <BaseResult <AcupointEntity> > Update(AcupointEntity entity)
{
StringBuilder sb = new StringBuilder();
string detailSql = @"SELECT * FROM dbo.tbAcupoint WHERE id=@id";
var i = await Detail(entity.id, detailSql);
if (i == null)
{
throw new Exception("数据不存在");
}
sb.AppendFormat(@"UPDATE dbo.tbAcupoint SET name = '{0}', findout ='{1}', overview = '{2}', info ='{3}',handle='{4}',image='{5}' WHERE id={6} ", entity.name, entity.findout, entity.overview, entity.info, entity.handle, entity.image, entity.id);
var result = new BaseResult <AcupointEntity>();
try
{
await Update(entity, sb.ToString());
result.code = ResultKey.RETURN_SUCCESS_CODE;
result.desc = ResultKey.RETURN_SUCCESS_DESC;
}
catch (Exception ex)
{
NlogHelper.InfoLog(ex.Message);
throw new Exception(ex.Message);
}
return(result);
}
/// <summary>
/// 获取详细信息.
/// </summary>
/// <param name="Id">.</param>
/// <returns>.</returns>
public async Task <BaseResult <AcupointEntity> > Detail(int Id)
{
string detailSql = @"SELECT * FROM dbo.tbAcupoint WHERE id=@id";
var result = new BaseResult <AcupointEntity>();
try
{
var entity = await Detail(Id, detailSql);
if (null != entity)
{
result.code = ResultKey.RETURN_SUCCESS_CODE;
result.data = new PageData <AcupointEntity> {
list = new List <AcupointEntity>()
{
entity
}, total = 1
};
result.desc = ResultKey.RETURN_SUCCESS_DESC;
}
else
{
result.code = ResultKey.RETURN_FAIL_CODE;
result.desc = ResultKey.RETURN_FAIL_DESC;
}
}
catch (Exception ex)
{
NlogHelper.InfoLog(ex.Message);
throw new Exception(ex.Message);
}
return(result);
}
/// <summary>
/// 批量删除.
/// </summary>
/// <param name="Ids">The Ids<see cref="int[]"/>.</param>
/// <returns>影响的行数.</returns>
public async Task <BaseResult <UserEntity> > DeleteList(int[] Ids)
{
string deleteSql = "update dbo.tbUser SET isDelete=1 WHERE userId in @userIds";
var result = new BaseResult <UserEntity>();
try
{
var i = await Delete(Ids, deleteSql);
if (null != i && i > 0)
{
result.code = ResultKey.RETURN_SUCCESS_CODE;
result.desc = ResultKey.RETURN_SUCCESS_DESC;
}
else
{
result.code = ResultKey.RETURN_FAIL_CODE;
result.desc = ResultKey.RETURN_FAIL_DESC;
}
}
catch (Exception ex)
{
NlogHelper.InfoLog(ex.Message);
throw new Exception(ex.Message);
}
return(result);
}
/// <summary>
/// 获取总记录数.
/// </summary>
/// <returns>返回记录总数.</returns>
public async Task <BaseResult <AcupointEntity> > GetCount()
{
string countSql = @"SELECT count(id) FROM dbo.tbAcupoint where IsDelete=0";
var result = new BaseResult <AcupointEntity>();
try
{
var entity = await GetCount(countSql);
if (entity > -1)
{
result.code = ResultKey.RETURN_SUCCESS_CODE;
result.data = new PageData <AcupointEntity> {
list = { }, total = 1
};
result.desc = ResultKey.RETURN_SUCCESS_DESC;
}
else
{
result.code = ResultKey.RETURN_FAIL_CODE;
result.desc = ResultKey.RETURN_FAIL_DESC;
}
}
catch (Exception ex)
{
NlogHelper.InfoLog(ex.Message);
throw new Exception(ex.Message);
}
return(result);
}
/// <summary>
/// 获取分页数据.
/// </summary>
/// <param name="pageIndex">页码.</param>
/// <param name="pageSize">页数.</param>
/// <param name="SortRule">The SortRule<see cref="int"/>.</param>
/// <returns>.</returns>
public async Task <BaseResult <AcupointEntity> > GetListByPage(int pageIndex, int pageSize, int SortRule = 1)
{
string tableName = "tbAcupoint";
string where = " IsDelete=0";
string orderby = "id ";
if (SortRule == 1)
{
orderby += " desc";
}
else
{
orderby += " asc";
}
pageSize = pageSize < 1 ? 10 : pageSize;
int skip = 1;
if (pageIndex > 0)
{
skip = (pageIndex - 1) * pageSize + 1;
}
StringBuilder sb = new StringBuilder();
sb.AppendFormat("SELECT COUNT(1) FROM {0} where {1};", tableName, where);
sb.AppendFormat(@"SELECT *
FROM(SELECT ROW_NUMBER() OVER(ORDER BY {2}) AS RowNum,*
FROM {0}
WHERE {1}
) AS result
WHERE RowNum >= {3} AND RowNum <= {4}
ORDER BY {2}", tableName, where, orderby, skip, pageIndex * pageSize);
var result = new BaseResult <AcupointEntity>();
try
{
var pageData = await GetPageList(sb.ToString());
if (pageData.total > -1)
{
result.code = ResultKey.RETURN_SUCCESS_CODE;
result.data = pageData;
result.desc = ResultKey.RETURN_SUCCESS_DESC;
}
else
{
result.code = ResultKey.RETURN_FAIL_CODE;
result.desc = ResultKey.RETURN_FAIL_DESC;
}
}
catch (Exception ex)
{
NlogHelper.InfoLog(ex.Message);
throw new Exception(ex.Message);
}
return(result);
}
/// <summary>
/// 分页 新版.
/// </summary>
/// <param name="models">.</param>
/// <returns>.</returns>
public async Task <BaseResult <FoodEntity> > GetList(QueryDTO models)
{
string tableName = "tbFood";
string where = " IsDelete=0";
string orderby = "id ";
if (models.sortRule == 1)
{
orderby += " DESC";
}
else
{
orderby += " ASC";
}
int skip = (models.pageIndex - 1) * models.pageSize + 1;
if (models.name != null)
{
where = where + "AND name LIKE '%" + models.name + "%'";
}
StringBuilder sb = new StringBuilder();
sb.AppendFormat("SELECT COUNT(1) FROM {0} WHERE {1};", tableName, where);
sb.AppendFormat(@"SELECT *
FROM(SELECT ROW_NUMBER() OVER(ORDER BY {2}) AS RowNum,*
FROM {0}
WHERE {1}
) AS result
WHERE RowNum >= {3} AND RowNum <= {4}
ORDER BY {2}", tableName, where, orderby, skip, models.pageIndex * models.pageSize);
var result = new BaseResult <FoodEntity>();
try
{
var pageData = await GetPageList(sb.ToString());
if (pageData.total > -1)
{
result.code = ResultKey.RETURN_SUCCESS_CODE;
result.data = pageData;
result.desc = ResultKey.RETURN_SUCCESS_DESC;
}
else
{
result.code = ResultKey.RETURN_FAIL_CODE;
result.desc = ResultKey.RETURN_FAIL_DESC;
}
}
catch (Exception ex)
{
NlogHelper.InfoLog(ex.Message);
throw new Exception(ex.Message);
}
return(result);
}
/// <summary>
/// 获取分页数据.
/// </summary>
/// <param name="modal">The modal<see cref="UserCollectQueryDTO"/>.</param>
/// <returns>.</returns>
public async Task <BaseResult <UserCollectEntity> > GetCollectList(UserCollectQueryDTO modal)
{
string tableName = "tbUserCollect";
//string where = " IsDelete=0";
string orderby = "id ";
if (modal.sortRule == 1)
{
orderby += " desc";
}
else
{
orderby += " asc";
}
int skip = (modal.pageIndex - 1) * modal.pageSize + 1;
StringBuilder sb = new StringBuilder();
sb.AppendFormat(@"SELECT COUNT(1) FROM {0} where 1=1 AND type={1} AND userId={2};", tableName, modal.type, modal.userId);
sb.AppendFormat(@"SELECT *
FROM(SELECT ROW_NUMBER() OVER(ORDER BY {1}) AS RowNum,*
FROM {0}
WHERE 1=1
) AS result
WHERE RowNum >= {2} AND RowNum <= {3} AND type={4} AND userId={5}
ORDER BY {1}", tableName, orderby, skip, modal.pageIndex * modal.pageSize, modal.type, modal.userId);
var result = new BaseResult <UserCollectEntity>();
try
{
var pageData = await GetPageList(sb.ToString());
if (pageData.total > -1)
{
result.code = ResultKey.RETURN_SUCCESS_CODE;
result.data = pageData;
result.desc = ResultKey.RETURN_SUCCESS_DESC;
}
else
{
result.code = ResultKey.RETURN_FAIL_CODE;
result.desc = ResultKey.RETURN_FAIL_DESC;
}
}
catch (Exception ex)
{
NlogHelper.InfoLog(ex.Message);
throw new Exception(ex.Message);
}
return(result);
}
protected void Page_Load(object sender, EventArgs e)
{
var logger = LogManager.GetLogger("NlogDemo");
try
{
int i = 10, j = 0;
var k = i / j;
}
catch (Exception ex)
{
NlogHelper.Error(ex);
}
}
/// <summary>
/// 删除收藏记录.
/// </summary>
/// <param name="entity">The entity<see cref="UserCollectEntity"/>.</param>
/// <returns>.</returns>
public async Task <BaseResult <UserCollectEntity> > Delete(UserCollectEntity entity)
{
string deleteSql = string.Format("delete tbUserCollect where userId={0} and objId={1} and type={2}", entity.userId, entity.objId, entity.type);
var result = new BaseResult <UserCollectEntity>();
try
{
int?i = await DeleteReal(deleteSql);
result.code = ResultKey.RETURN_SUCCESS_CODE;
result.desc = ResultKey.RETURN_SUCCESS_DESC;
}
catch (Exception ex)
{
NlogHelper.InfoLog(ex.Message);
throw new Exception(ex.Message);
}
return(result);
}
public ActionResult <IEnumerable <string> > Get()
{
var domain222 = _testInterface.add(1, 2);
#region redis
_distributedCache.SetString("name", "zhangsan");
var value = _distributedCache.GetString("name");
#endregion
var domaincache = _cache.Get("getkey");
if (domaincache == null)
{
var domain = _testInterface.add(1, 2);
_cache.Set("getkey", domain);
}
//var aa = "dfasdfas";
//int bb = Convert.ToInt32(aa);
NlogHelper.InfoLog("1234123");
return(new string[] { "value1", "value2" });
}
/// <summary>
/// 修改.
/// </summary>
/// <param name="entity">数据实体.</param>
/// <returns>返回主键值.</returns>
public async Task <BaseResult <SickEntity> > Updata(SickEntity entity)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat(@"UPDATE dbo.tbSick SET title = '{0}', overview ='{1}', acupoint = '{2}', food ='{3}', pathogeny ='{4}', analysis = '{5}' WHERE id={6} ", entity.title, entity.overview, entity.acupoint, entity.food, entity.pathogeny, entity.analysis, entity.id);
var result = new BaseResult <SickEntity>();
try
{
await Update(entity, sb.ToString());
result.code = ResultKey.RETURN_SUCCESS_CODE;
result.desc = ResultKey.RETURN_SUCCESS_DESC;
}
catch (Exception ex)
{
NlogHelper.InfoLog(ex.Message);
throw new Exception(ex.Message);
}
return(result);
}
/// <summary>
/// 删除 逻辑删除.
/// </summary>
/// <param name="entity">数据实体.</param>
/// <returns>返回主键值.</returns>
public async Task <BaseResult <SickEntity> > Delete(SickEntity entity)
{
StringBuilder sb = new StringBuilder();
sb.AppendFormat(@"UPDATE dbo.tbSick SET IsDelete = 1 WHERE id = {0}", entity.id);
var result = new BaseResult <SickEntity>();
try
{
var i = await Delete(entity.id, sb.ToString());
result.code = ResultKey.RETURN_SUCCESS_CODE;
result.desc = ResultKey.RETURN_SUCCESS_DESC;
}
catch (Exception ex)
{
NlogHelper.InfoLog(ex.Message);
throw new Exception(ex.Message);
}
return(result);
}
/// <summary>
/// 新增.
/// </summary>
/// <param name="entity">数据实体.</param>
/// <returns>返回主键值.</returns>
public async Task <BaseResult <UserEntity> > Add(UserEntity entity)
{
var result = new BaseResult <UserEntity>();
string countSql = string.Format(@"SELECT count(userId) FROM dbo.tbUser where IsDelete=0 and userName='******'", entity.userName);
int? n = await GetCount(countSql);
if (n > 0)
{
result.code = ResultKey.RETURN_FAIL_CODE;
result.desc = "用户名已存在！";
return(result);
}
string insertSql = @"INSERT INTO dbo.tbUser (userName, passWord,age) VALUES(@userName, @passWord,@age) select @@identity";
try
{
var i = await Add(entity, insertSql);
if (null != i && i > 0)
{
result.code = ResultKey.RETURN_SUCCESS_CODE;
result.desc = ResultKey.RETURN_SUCCESS_DESC;
}
else
{
result.code = ResultKey.RETURN_FAIL_CODE;
result.desc = ResultKey.RETURN_FAIL_DESC;
}
}
catch (Exception ex)
{
NlogHelper.InfoLog(ex.Message);
throw new Exception(ex.Message);
}
return(result);
}
public void RunAtTimeOf(DateTime now)
{
NlogHelper.InfoLog("1234123");
}
// This method gets called by the runtime. Use this method to add services to the container.
public void ConfigureServices(IServiceCollection services)
{
services.AddMvcCore(options => options.Filters.Add(typeof(ApiActionFilter)))
.AddAuthorization()
.AddJsonFormatters()
.AddApiExplorer();
JwtSecurityTokenHandler.DefaultInboundClaimTypeMap.Clear();
services.AddAuthentication(JwtBearerDefaults.AuthenticationScheme)
.AddJwtBearer(options =>
{
options.Authority = Configuration["IdentityService:Authority"];
options.Audience = "GeneralServiceApi";
options.RequireHttpsMetadata = false;
});
services.AddSingleton <IHttpContextAccessor, HttpContextAccessor>();
services.AddSingleton <IUserPermissionCache, UserPermissionCache>();
services.AddHttpClient <CallPermissionServiceApi>();
services.AddSingleton <ICallPermissionServiceApi, CallPermissionServiceApi>();
services.AddDbContext <ProductDBContext>(option => option.UseNpgsql(Configuration.GetConnectionString("ProductDBConnStr"), npgsqlOptions =>
{
npgsqlOptions.EnableRetryOnFailure();
npgsqlOptions.CommandTimeout(60);
})
.UseQueryTrackingBehavior(QueryTrackingBehavior.NoTracking)
);
services.AddDbContext <ProductDBReadOnlyContext>(option => option.UseNpgsql(Configuration.GetConnectionString("ProductDBConnStr"), npgsqlOptions =>
{
npgsqlOptions.EnableRetryOnFailure();
npgsqlOptions.CommandTimeout(60);
})
.UseQueryTrackingBehavior(QueryTrackingBehavior.NoTracking)
);
services.Configure <ApiBehaviorOptions>(options =>
{
options.SuppressModelStateInvalidFilter = true; //去掉自动模型验证
});
services.AddSwaggerDocumentation("v1", "ProductService API", Assembly.GetExecutingAssembly().GetName().Name);
services.AddMediatR(Assembly.GetAssembly(typeof(Application.ProductSvc.AddProductHandler)));
services.AddAutoMapper(Assembly.GetAssembly(typeof(Domain.Models.ProductMamagementAutoMapperProfile)));
services.AddCap(x =>
{
//如果你使用的 EF 进行数据操作，你需要添加如下配置：
x.UseEntityFramework <ProductDBContext>(); //可选项
//x.UsePostgreSql("数据库连接字符串");
x.UseRabbitMQ(o =>
{
o.HostName = Configuration.GetValue <string>("RabbitMQ:HostName");
o.Port = Configuration.GetValue <int>("RabbitMQ:Port");
o.UserName = Configuration.GetValue <string>("RabbitMQ:UserName");
o.Password = Configuration.GetValue <string>("RabbitMQ:Password");
});
x.UseDashboard();
x.FailedRetryCount = 5;
x.FailedThresholdCallback = (type, name, content) =>
{
string message = $@"A message of type { type}
failed after executing { x.FailedRetryCount}
several times, requiring manual troubleshooting. Message name: { name}, message body: { content}";
NlogHelper.LogGeneralError(message);
};
});
services.AddTransient <ISubscriberService, SubscriberService>();
}
