/// <summary>
/// 根据域名获取服务器
/// </summary>
/// <param name="serviceUrl">域名地址</param>
/// <returns></returns>
public ImageServiceDbModel GetByName(string serviceUrl)
{
using (var dbcontext = new ImageMySqlEntities())
{
return(dbcontext.Set <ImageServiceDbModel>().AsNoTracking().Where(e => e.ServerUrl == serviceUrl).FirstOrDefault());
}
}
/// <summary>
/// 获取
/// </summary>
/// <param name="serviceId"></param>
/// <returns></returns>
public ImageServiceDbModel Get(int serviceId)
{
using (var dbcontext = new ImageMySqlEntities())
{
return(dbcontext.Set <ImageServiceDbModel>().AsNoTracking().Where(e => e.ServerId == serviceId).FirstOrDefault());
}
}
/// <summary>
/// 更新
/// </summary>
/// <param name="model"></param>
public void Update(ImageInfoDbModel model)
{
using (var dbcontext = new ImageMySqlEntities())
{
dbcontext.Entry <ImageInfoDbModel>(model).State = EntityState.Modified;
dbcontext.SaveChanges();
}
}
/// <summary>
///添加
/// </summary>
/// <param name="model"></param>
public void Add(ImageInfoDbModel model)
{
using (var dbcontext = new ImageMySqlEntities())
{
var result = dbcontext.Set <ImageInfoDbModel>().Add(model);
dbcontext.SaveChanges();
}
}
/// <summary>
/// 查询可用图片服务器
/// </summary>
/// <returns></returns>
public List <ImageServiceDbModel> Query()
{
var result = new List <ImageServiceDbModel>();
using (var dbcontext = new ImageMySqlEntities())
{
var dbs = dbcontext.Set <ImageServiceDbModel>().AsNoTracking().Where(e => e.FlgUsable == true && e.CurPicAmount < e.MaxPicAmount).ToList();
if (dbs == null)
{
return(result);
}
return(dbs);
}
}
