public static List<Models.Classificacao> GetListClassificacao()
{
try {
using (var db = new dbContext()) {
return db.Classificacao.ToList();
}
}
catch (Exception) {
throw new Exception("Erro!");
}
}
public quesRepo(dbContext context)
{
_context = context;
}
public StatusController(dbContext context)
{
_context = context;
}
public ProcessControlItemsController(dbContext context)
{
_context = context;
}
(await CollectionMustExist(dbContext, request), await ValidateSong(dbContext, request))
public VoteController(dbContext db)
{
_db = db;
}
public UsuarioController(dbContext context)
{
_context = context;
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public ActionResult Index()
{
Object data = null;
using (var db = new dbContext())
{
#region 单表查询
//data = db.Province.Count();//查询记录数量 - 无关联条件
//data = db.Province.Count(a => a.Province_Letter.Contains("H"));//查询记录数量 - 模糊条件
//data = db.Province.ToList();//所有数据
//data = db.City.Where(a => a.City_Name.Contains("州") & a.City_Letter == "A").ToList();//多条件查询
//data = db.Province.OrderBy(a => a.Province_Letter).ToList();//升序
//data = db.Province.OrderByDescending(a => a.Province_Letter).ToList();//降序
//组合条件查询
//var query = db.Province.Select(a => a);
//query = query.Where(a => a.Province_Letter == "X" || a.Province_Letter == "H");
//query = query.Where(a => a.Province_Name.Contains("省"));
//data = query.ToList();
//分页
//var PageSize = 5;
//var PageIndex = 3;
//data = db.City.Select(a => new
//{
// Id = a.City_Id, //
// Name = a.City_Name, //设置查询字段 映射到匿名类型
// Letter = a.City_Letter //
//})
//.OrderByDescending(a => a.Id)
//.Skip((PageIndex - 1) * PageSize)
//.Take(PageSize)
//.ToList();
//LEFT JOIN
//data = db.Province.Select(a => new
//{
// Pid = a.Province_Id,
// PName = a.Province_Name,
// a.Citys
//}).ToList();
//INNER JOIN
//data = db.City.Select(a => new
//{
// Id = a.City_Id,
// Name = a.City_Name,
// PId = a.Province_Id,
// PName = db.Province.FirstOrDefault(g => g.Province_Id == a.Province_Id).Province_Name
//}).ToList();
//查询主表数据同时查询子表数据
//data = db.Province.Include(x => x.Citys).ToList();
//事务
//using (DbContextTransaction dbTran = db.Database.BeginTransaction())
//{
// try
// {
// db.City.Add(new T_CityEntities { });
// db.SaveChanges();
// }
// catch (Exception ex)
// {
// dbTran.Rollback();
// }
//}
//分类
//data = db.Group.Include(a => a.Childs).Where(x => x.ParentID == 0).ToList();
#endregion
#region 数据增删改
//更新单个字段值
//var obj = new T_CityEntities { City_Id = 110100, City_Name = "城市名称", City_Letter = "X" };
//db.City.Attach(obj);
//db.Entry(obj).Property(x => x.City_Name).IsModified = true;
//db.SaveChanges();
//更新整个实体
//var obj = new T_CityEntities { City_Id = 110100, City_Name = "新城市名称", City_Letter = "X" };
//db.City.Attach(obj);
////db.Entry(obj).State = EntityState.Modified;
////db.Entry<T_CityEntities>(obj).State = EntityState.Modified;
//db.SaveChanges();
//批量更新 EntityFramework.Extended
//db.City.Where(x => x.Province_Id == 110000).Update(c => new T_CityEntities { City_Name = "批量更新" });
//添加数据
//非自增主键设置元标记:[DatabaseGenerated(DatabaseGeneratedOption.None)]
//var obj = new T_CityEntities { City_Id = 900000, City_Name = "新城市", City_Letter = "X", Province_Id = 0 };
//db.City.Add(obj);
////db.Entry(obj).State = EntityState.Added;
////db.Entry<T_CityEntities>(obj).State = EntityState.Added;
//db.SaveChanges();
//删除数据
//var obj = new T_CityEntities { City_Id = 900000 };
//db.City.Remove(obj);
////db.Entry(obj).State = EntityState.Deleted;
////db.Entry<T_NewsEntities>(obj).State = EntityState.Deleted;
//db.SaveChanges();
//批量删除
//var items = db.City.Where(x => x.Province_Id == 650000).ToList();
//db.City.RemoveRange(items);
////db.City.Where(x => x.Province_Id == 650000).Delete(); //EntityFramework.Extended
//db.SaveChanges();
#endregion
//一对多取第一条子表记录(:>MS Sql2005以上)
//data = db.Area.Select(a => a.Area_Name).Distinct().Select(b => db.Area.FirstOrDefault(c => c.Area_Name == b)).ToList();
//data = db.Province.ToList();//全部数据
//data = (db.News.ta.Select(100));//主键查询
//简单查询
//data = db.News.SqlQuery("SELECT * FROM [t_news] ORDER BY id DESC").ToList();//SQL
//data = db.News.Where(a => a.ID == 100 || a.ID == 99).OrderBy(a => a.ID).ToList();//Func形式
//data = (from a in db.News where a.ID == 100 || a.ID == 99 orderby a.ID select a).ToList();//Linq
//查询部分字段
//var d1 = db.News.Where(a => a.ID > 1).Select(a => new { a = a.ID, b = a.Title }).ToList();
//return Content(JsonConvert.SerializeObject(d1));
//查询单一记录：
//var d2 = db.News.FirstOrDefault(a => a.ID == 100);
//return Content(JsonConvert.SerializeObject(d2));
//LEFT JOIN 连接查询
//var d3 = db.City.Select(a => new
//{
// a.City_Id,
// a.City_Name,
// a.City_Letter,
// a.Province_Id,
// Province_Name = db.Province.FirstOrDefault(b => b.Province_Id == a.Province_Id).Province_Name
//}).ToList();
//return Content(JsonConvert.SerializeObject(d3));
//INNER JOIN 连接查询
//var d4 = db.News.Where(c => c.ID > 0).OrderBy(c => c.ID).Skip(20).Take(3).ToList();
//return Content(JsonConvert.SerializeObject(d4));
}
return(Content(JsonConvert.SerializeObject(data)));
return(View(data));
}
public PortfolioService()
{
this.db = new dbContext();
}
public TelegramBotSettingPersistenceRepository(dbContext _db) : base(_db)
{
_db = db;
}
public AccountController(UserManager <User> userManager, SignInManager <User> signInManager, RoleManager <IdentityRole> roleManager, dbContext dbContext)
{
_userManager = userManager;
_signInManager = signInManager;
_roleManager = roleManager;
_dbContext = dbContext;
}
public UnitOfWork(string connectionString)
{
db = new dbContext(connectionString);
}
public AdvertiseLogPersistenceRepository(dbContext _db) : base(_db)
{
_db = db;
}
public EmployeesController(dbContext context)
{
_context = context;
}
public MedicosController(dbContext context)
{
_context = context;
}
public ProjectRepository(dbContext dbContext)
{
this.dbContext = dbContext;
}
public ProductManager(dbContext context, IElasticSearchService elasticSearchService)
{
_context = context;
_elasticSearchService = elasticSearchService;
}
public MachineKindPropertiesController(dbContext context)
{
_context = context;
}
(await ProgramScheduleMustExist(dbContext, request), ValidateName(request))
public WorkDispatchingsController(dbContext context)
{
_context = context;
}
public StoragesController(dbContext context)
{
_context = context;
}
public NgCodesController(dbContext context)
{
_context = context;
}
public MouldTypesController(dbContext context)
{
_context = context;
}
(await CollectionMustExist(dbContext, request), await ValidateSong(dbContext, request)) .Apply((collection, episode) => new Parameters(collection, episode));
public PedidosController(dbContext _db)
{
db = _db;
}
public ReportsController(dbContext context)
{
_context = context;
}
public employeeDao()
{
db = new dbContext();
}
public PutProductCommandHandler(dbContext context)
{
_context = context;
}
public WorkCalendarController(dbContext context)
{
_context = context;
}
public ProjectAssignmentRepository(dbContext dbContext)
{
this.dbContext = dbContext;
}
public Startup(IConfiguration configuration)
{
this.configuration = configuration;
this.mapper = mappingConfig.CreateMapper();
this.context = new dbContext();
}
