private static void Main(string[] args)
{
var db = new MyDbUtil();
var dd = db.QueryByTable("SENSOR");
var a = 1;
}
public JsonResult Delete(int id)
{
var db = new MyDbUtil();
var row = db.Delete <StockItem>(id);
var result = row > 0 ? ResultUtil.Success() : ResultUtil.Do(ResultCodes.数据库操作失败, "操作失败");
return(Json(result));
}
public BaseService(string sectionName = "")
{
if (!string.IsNullOrWhiteSpace(sectionName))
{
db = new MyDbUtil(sectionName);
}
else
{
db = new MyDbUtil();
}
}
public JsonResult GetAssets(AssetSearchParam param, int stockId, int pageIndex = 1, int pageSize = 50)
{
var util = param.ToSearchUtil();
util.And("Id NOT IN (SELECT AssetId FROM Asset_StockItem WHERE StockId=" + stockId.ToString() + ")");
var db = new MyDbUtil();
var list = db.Query <AssetDto>(util, pageIndex, pageSize, "AssetView");
return(Json(ResultUtil.PageList(list)));
}
public void ConfigureServices(IServiceCollection services)
{
// 使用分布式缓存
// services.AddDistributedMemoryCache();
// 启用Session
services.AddSession();
// 初始化数据库工具
MyDbUtil.Init(Configuration);
// 初始化并添加AutoMapper
Mapper.Initialize(cfg =>
{
cfg.AddProfile <ServicesProfile>();
});
services.AddAutoMapper();
// 压缩输出
services.AddResponseCompression();
// cookie身份验证
services
.AddAuthentication(CookieAuthenticationDefaults.AuthenticationScheme)
.AddCookie(opts =>
{
opts.Cookie.Name = "Taoxue.Training.Core";
opts.Cookie.HttpOnly = true;
opts.LoginPath = "/Login";
opts.LogoutPath = "/Home/Logout";
});
services
.AddAuthorization(opts =>
{
opts.AddPolicy("AdminOnly", policy => policy.RequireRole("admin"));
opts.AddPolicy("ManagerOnly", policy => policy.RequireRole("manager"));
});
// senparc使用本地缓存必须注册此服务
services.AddMemoryCache();
services.AddMvc().SetCompatibilityVersion(CompatibilityVersion.Version_2_1);
}
