/// <summary>
/// 开始检测资源失效
/// </summary>
public void StartCheck()
{
var categoryList = dbContext.Set <Categories>().Include(x => x.ContentList).Where(x => x.Status != ContentStatus.Close).ToList();
foreach (var category in categoryList)
{
var content = dbContext.Set <ContentEntry>().Include(x => x.MediaResource).FirstOrDefault(x => x.Category == category);
if (content == null)
{
category.Status = ContentStatus.Close;
dbContext.SaveChanges();
continue;
}
var img = content.MediaResource.FirstOrDefault();
if (img == null)
{
category.Status = ContentStatus.Close;
dbContext.SaveChanges();
continue;
}
var isNotFound = CheckNotFound(img.ActualPath);
if (isNotFound)
{
category.Status = ContentStatus.Close;
dbContext.SaveChanges();
}
}
}
public void CreateCategory(string name, ContentStatus status, params string[] tags)
{
var hasCategory = dbContext.Set <Categories>().Any(x => x.Name == name);
if (!hasCategory)
{
var tagsList = new List <Tags>();
if (tags != null || tags.Length > 1)
{
foreach (var tag in tags)
{
tagsList.Add(new Tags
{
Id = Guid.NewGuid(),
Name = tag
});
}
}
var cateCartoon = GetTopCategory("漫画");
var category = new Categories
{
Id = Guid.NewGuid(),
CreateTime = DateTime.Now,
Name = name,
Tags = tagsList,
ParentCategory = cateCartoon,
Status = status
};
dbContext.Set <Categories>().Add(category);
dbContext.SaveChanges();
}
}
public IActionResult Put(int id, ProductionData productionData)
{
if (id != productionData.Id)
{
return(BadRequest());
}
_context.Update(productionData);
try
{
_context.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ProductionDataExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
/// <summary>
/// 保存信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ApiResult <bool> Save(DutyRecord model, UserInfo userInfo)
{
ApiResult <bool> result = new ApiResult <bool>();
try
{
using (CommonDbContext db = new CommonDbContext())
{
if (string.IsNullOrEmpty(model.DutyRecordId))
{
db.Set <DutyRecord>().Insert(model);
}
else
{
db.Set <DutyRecord>().Update(model);
}
result.Result = db.SaveChanges() > 0;
result.Code = ResultCode.Success;
}
}
catch (Exception e)
{
result.Code = ResultCode.SystemError;
result.Message = e.ToString();
}
return(result);
}
public void Start()
{
var allNum = dbcontext.Set <FileEntry>().Where(x => x.ActualPath.Contains("img.fox800.xyz")).Count();
var wc = new WebClient();
for (int i = 0; i < allNum;)
{
var targetRow = dbcontext.Set <FileEntry>().Where(x => x.ActualPath.Contains("img.fox800.xyz")).Skip(i).Take(100).ToList();
foreach (var item in targetRow)
{
try
{
var imgBytes = wc.DownloadData(item.ActualPath);
var imgStream = new MemoryStream(imgBytes);
var savekey = item.ActualPath.Replace("img.fox800.xyz", "fox800/");
QiniuTool.UploadImage(imgStream, savekey).Wait();
item.ActualPath = "http://mioto.milbit.com/" + savekey;
item.Name = "fox800";
dbcontext.SaveChanges();
Console.WriteLine("process : " + i);
}
catch (Exception exc)
{
Console.WriteLine(exc.Message);
}
}
i += 100;
if (i > allNum)
{
i = allNum - 1;
}
}
}
public override void OnActionExecuted(ActionExecutedContext context)
{
if (context.Exception == null)
{
_dbContext.SaveChanges();
}
}
/// <summary>
/// 保存岗位信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ApiResult <bool> Save(DutyPost model, UserInfo userInfo)
{
ApiResult <bool> result = new ApiResult <bool>();
try
{
using (CommonDbContext db = new CommonDbContext())
{
if (string.IsNullOrEmpty(model.PostId))
{
model.PostId = GuidHelper.GetSeqGUID();
model.CreatedTime = DateTime.Now;
model.Creater = userInfo.UserCode;
model.Updater = userInfo.UserCode;
model.UpdateTime = DateTime.Now;
db.Set <DutyPost>().Insert(model);
}
else
{
model.UpdateTime = DateTime.Now;
model.Updater = userInfo.UserCode;
db.Set <DutyPost>().Update(model);
}
result.Result = db.SaveChanges() > 0;
result.Code = ResultCode.Success;
}
}
catch (Exception e)
{
result.Code = ResultCode.SystemError;
result.Message = e.ToString();
}
return(result);
}
public void OperacoesBancariasDAOTest_Sacar()
{
var options = testesUteis.CriarDataBaseTeste("SacarDAOTeste");
decimal valorSacar = 100;
using (var context = new CommonDbContext(options))
{
context.Contas.Add(testesUteis.ListarContas());
context.Caixas.Add(testesUteis.ListarCaixas());
context.SaveChanges();
OperacoesBancariasDao = new OperacoesBancariasDAO(context, mockCaixaEletronico.Object);
mockCaixaEletronico.Setup(x => x.ValidarSaque(It.IsAny <decimal>(), It.IsAny <ContaContext>(), It.IsAny <CaixaEletronicoContext>())).Returns(true);
int[] arrayRetorno = new int[4];
mockCaixaEletronico.Setup(x => x.RetornarNotasNecessarias(It.IsAny <decimal>())).Returns(arrayRetorno);
var result = OperacoesBancariasDao.Sacar(testesUteis.Contas(), valorSacar);
Assert.IsNotNull(result);
}
}
private static void UpdateCityLefvel(CommonDbContext dbContext)
{
var province = dbContext.CityInfos.Where(x => x.ParentCode == null || x.ParentCode == string.Empty).ToList();
foreach (var pinfo in province)
{
var cities = dbContext.CityInfos.Where(x => x.ParentCode == pinfo.Code);
foreach (var cityInfo in cities)
{
var districts = dbContext.CityInfos.Where(x => x.ParentCode == cityInfo.Code);
cityInfo.Level = 1;
dbContext.Update(cityInfo);
foreach (var dinfo in districts)
{
dinfo.Level = 2;
dbContext.Update(dinfo);
}
dbContext.SaveChanges();
}
}
}
public OperacaoDTO Sacar(ContaDTO conta, decimal valorSacar)
{
var caixaEletronico = _commonDbContext.Caixas.FirstOrDefault();
var contaUsuario = _commonDbContext.Contas.Where(x => x.NumeroContaCli == conta.NumeroContaCli).FirstOrDefault();
OperacaoDTO operacao = new OperacaoDTO();
if (_caixaEletronicoDAO.ValidarSaque(valorSacar, contaUsuario, caixaEletronico))
{
contaUsuario.SaldoConta -= valorSacar;
conta.SaldoConta = contaUsuario.SaldoConta;
_commonDbContext.Update(contaUsuario);
_commonDbContext.Update(caixaEletronico);
_commonDbContext.SaveChanges();
operacao.Conta = conta;
operacao.Realizada = true;
var notasParaSaque = _caixaEletronicoDAO.RetornarNotasNecessarias(valorSacar);
caixaEletronico.NotasCem -= notasParaSaque[0];
caixaEletronico.NotasCinquenta -= notasParaSaque[1];
caixaEletronico.NotasVinte -= notasParaSaque[2];
caixaEletronico.NotasCem -= notasParaSaque[3];
caixaEletronico.Valor_Disponivel -= valorSacar;
contaUsuario.SaldoConta -= valorSacar;
conta.SaldoConta = contaUsuario.SaldoConta;
_commonDbContext.Update(contaUsuario);
_commonDbContext.Update(caixaEletronico);
_commonDbContext.SaveChanges();
operacao.NotasUtilizadas = new int[4] {
notasParaSaque[0], notasParaSaque[1], notasParaSaque[2], notasParaSaque[3]
};
operacao.ValorSacado = valorSacar;
operacao.Conta = conta;
operacao.Realizada = true;
return(operacao);
}
return(operacao);
}
/// <summary>
/// データベースへコミットします。
/// </summary>
/// <param name="user">更新者</param>
/// <returns>
/// 影響を受けた行数
/// </returns>
public int Commit(string user)
{
var result = context.SaveChanges(user);
if (result > 0)
{
LogUtil.WriteLLog(logger.LogInformation, userName, requestId, $"commited transaction. entries = {result}");
}
return(result);
}
public void SaveChanges()
{
if (_unitOfWork == null)
{
_context.SaveChanges();
}
else
{
_unitOfWork.Commit();
}
}
public void StartSet()
{
var cateCartoon = GetTopCategory("漫画");
var cateNews = GetTopCategory("资讯");
var categoryList = dbContext.Categories.Include(x => x.Tags).ToList();
foreach (var category in categoryList)
{
if (category.Tags.Any(x => x.Name == "资讯"))
{
category.ParentCategory = cateNews;
}
else
{
category.ParentCategory = cateCartoon;
}
dbContext.SaveChanges();
}
}
private static void RemoveContent(CommonDbContext dbcontext, Categories categories)
{
//dbcontext.Entry(contentList);
foreach (var contentItem in categories.ContentList)
{
QiniuTool.DeleteImage(contentItem.MediaResource.Select(x => x.ActualPath.Replace("https://mioto.milbit.com/", "")).ToArray()).Wait();
//dbcontext.Entry(contentItem.MediaResource);
//dbcontext.Remove(contentItem.MediaResource);
}
dbcontext.RemoveRange(categories.ContentList);
dbcontext.SaveChanges();
}
/// <summary>
/// 保存信息
/// </summary>
/// <param name="model">备案记录</param>
/// /// <param name="userInfo">用户信息</param>
/// <returns></returns>
public ApiResult <bool> Save(PoliceRecord model, UserInfo userInfo)
{
ApiResult <bool> result = new ApiResult <bool>();
try
{
using (CommonDbContext db = new CommonDbContext())
{
var record = new List <PostRecordViewModel>();
//提取当前用户部分的岗位，生成部门的报备信息
List <DutyPost> posts = db.Set <DutyPost>().FindAll(p => p.PostLiabledep == userInfo.DepartmentId).ToList();
foreach (var item in posts)
{
var pm = new PostRecordViewModel
{
DutyPost = item,
PostPoliceOnduty = db.Set <PostPoliceOnduty>().FindAll(p => p.PostId == item.PostId).ToList()
};
var plist = pm.PostPoliceOnduty.Select(p => p.PoliceManid).ToList();
pm.PoliceMan = db.Set <PoliceMan>().FindAll(p => plist.Contains(p.PoliceManID)).ToList();
record.Add(pm);
}
model.Record = JsonHelper.ToJson(record);
model.DepartmentId = userInfo.DepartmentId;
if (string.IsNullOrEmpty(model.PoliceRecordId))
{
model.CreatedTime = DateTime.Now;
model.Creater = userInfo.UserCode;
model.Updater = userInfo.UserCode;
model.UpdateTime = DateTime.Now;
db.Set <PoliceRecord>().Insert(model);
}
else
{
model.UpdateTime = DateTime.Now;
model.Updater = userInfo.UserCode;
db.Set <PoliceRecord>().Update(model);
}
result.Result = db.SaveChanges() > 0;
result.Code = ResultCode.Success;
}
}
catch (Exception e)
{
result.Code = ResultCode.SystemError;
result.Message = e.ToString();
}
return(result);
}
public void AddThread(User user, string contents)
{
Guid guid = Guid.NewGuid();
_ctx.Thread.Add(new Threads
{
ThreadId = guid.ToString(),
UserId = user.UserId,
Contents = contents,
UpdateDateTime = DateTime.Now.ToString(),
DeleteKey = "0"
});
_ctx.SaveChanges();
}
public OperacaoDTO Sacar(ContaDTO conta, decimal valorSacar)
{
OperacaoDTO operacao = new OperacaoDTO();
var caixaEletronico = _commonDbContext.Caixas.FirstOrDefault();
var contaUsuario = _commonDbContext.Contas.Where(x => x.Banco == conta.BancoContaCli && x.Agencia == conta.AgenciaContaCli && x.NumeroContaCli == conta.NumeroContaCli && x.CpfCliente == conta.CpfCli).FirstOrDefault();
if (_caixaEletronicoDAO.ValidarSaque(valorSacar, contaUsuario, caixaEletronico))
{
var notasParaSaque = _caixaEletronicoDAO.RetornarNotasNecessarias(valorSacar);
caixaEletronico.NotasCem -= notasParaSaque[0];
caixaEletronico.NotasCinquenta -= notasParaSaque[1];
caixaEletronico.NotasVinte -= notasParaSaque[2];
caixaEletronico.NotasDez -= notasParaSaque[3];
caixaEletronico.Valor_Disponivel -= valorSacar;
contaUsuario.SaldoConta -= valorSacar;
conta.SaldoConta = contaUsuario.SaldoConta.ToString().Length < 12 ? Convert.ToDecimal(contaUsuario.SaldoConta.ToString().PadRight(12, '0')) : contaUsuario.SaldoConta;
_commonDbContext.Update(contaUsuario);
_commonDbContext.Update(caixaEletronico);
_commonDbContext.SaveChanges();
operacao.NotasUtilizadas = new int[4] {
notasParaSaque[0], notasParaSaque[1], notasParaSaque[2], notasParaSaque[3]
};
operacao.ValorSacado = valorSacar;
operacao.Conta = conta;
operacao.Realizada = true;
return(operacao);
}
return(operacao);
}
/// <summary>
/// 保存同一类标签
/// </summary>
/// <param name="tagsList">标签列表</param>
/// <param name="SourceType">来源类型 <seealso cref="TagsSourceType"/></param>
/// <param name="SourceId">来源Id</param>
/// <param name="operatorCode">操作人</param>
public int SaveTags(List <Tags> tagsList, string SourceType, string SourceId, string operatorCode)
{
if (string.IsNullOrEmpty(SourceType) || tagsList == null || tagsList.Count == 0)
{
return(-1);
}
using (CommonDbContext cdb = new CommonDbContext())
{
var dbSet = cdb.Set <Tags>();
var query = dbSet.FindAll(e => e.TagType == SourceType);
var allTagList = query.ToList();
if (!string.IsNullOrEmpty(SourceId))
{
query = query.Where(e => e.SourceId == SourceId);
}
var list = query.ToList();
//删除的数据
var queryRemove = (from p in list
where !(from q in tagsList select q.TagGUID).Contains(p.TagGUID)
select p);
//新增的数据
var queryAdd = tagsList.Where(e => string.IsNullOrEmpty(e.TagGUID)).ToList();
var dict = new Dictionary <string, int>();
foreach (var item in allTagList)
{
dict[item.TagName] = item.TagHeat.Value;
}
int TagHeat = 0;
foreach (var item in queryAdd)
{
if (!dict.TryGetValue(item.TagName, out TagHeat))
{
TagHeat = 0;
}
item.TagGUID = GuidHelper.GetSeqGUID();
item.TagType = SourceType;
item.SourceId = SourceId;
item.TagHeat = TagHeat;
item.CreatedTime = DateTime.Now;
item.Creator = operatorCode;
}
dbSet.AddRange(queryAdd);
dbSet.RemoveRange(queryRemove);
return(cdb.SaveChanges());
}
}
private static Categories GetTopCategory(CommonDbContext dbContext, string name)
{
Categories cartoonCate = dbContext.Categories.FirstOrDefault(x => x.Name == name);
if (cartoonCate == null)
{
cartoonCate = new Categories
{
Id = Guid.NewGuid(),
Name = name,
CreateTime = DateTime.Now
};
dbContext.Add(cartoonCate);
dbContext.SaveChanges();
}
return(cartoonCate);
}
public void DeveTestar_Login()
{
var options = testeUteis.CriarDataBaseTeste("LoginTeste");
using (var context = new CommonDbContext(options))
{
context.Contas.Add(testeUteis.ListarContas());
context.SaveChanges();
var chamada = service.Login(testeUteis.ListarContas().CpfCliente, testeUteis.ListarContas().SenhaConta);
Assert.AreEqual(500, chamada.Codigo);
Assert.IsNull(chamada.Data);
Assert.AreEqual("Erro ao realizar login, verifique as informações.", chamada.Mensagem);
}
}
public void CaixaEletronicoDAOTest_Login()
{
var options = testesUteis.CriarDataBaseTeste("LoginDAOTeste");
using (var context = new CommonDbContext(options))
{
context.Contas.Add(testesUteis.ListarContas());
context.SaveChanges();
caixaEletronicoDao = new CaixaEletronicoDAO(context);
var result = caixaEletronicoDao.Login(testesUteis.ListarContas().CpfCliente, testesUteis.ListarContas().SenhaConta);
Assert.AreEqual(true, result);
}
}
public void CaixaEletronicoDAOTest_ValidarInformacoes()
{
var options = testesUteis.CriarDataBaseTeste("ValidarInformacoesDAOTeste");
using (var context = new CommonDbContext(options))
{
context.Caixas.Add(testesUteis.ListarCaixas());
context.SaveChanges();
caixaEletronicoDao = new CaixaEletronicoDAO(context);
var result = caixaEletronicoDao.ValidarInformacoes(testesUteis.ContasTransferencia());
Assert.AreEqual(false, result);
}
}
public void OperacoesBancariasDAOTest_Saldo()
{
var options = testesUteis.CriarDataBaseTeste("SaldoDAOTeste");
using (var context = new CommonDbContext(options))
{
context.Contas.Add(testesUteis.ListarContas());
context.SaveChanges();
OperacoesBancariasDao = new OperacoesBancariasDAO(context, mockCaixaEletronico.Object);
var result = OperacoesBancariasDao.Saldo(testesUteis.Contas().BancoContaCli, testesUteis.Contas().AgenciaContaCli, testesUteis.Contas().NumeroContaCli, testesUteis.Contas().CpfCli);
Assert.IsNotNull(result);
}
}
public void CaixaEletronicoDAOTest_ListarUsuario()
{
var options = testesUteis.CriarDataBaseTeste("ListarUsuarioDAOTeste");
using (var context = new CommonDbContext(options))
{
context.Contas.Add(testesUteis.ListarContas());
context.Clientes.Add(testesUteis.ListarClientes());
context.SaveChanges();
caixaEletronicoDao = new CaixaEletronicoDAO(context);
var result = caixaEletronicoDao.ListarUsuario(testesUteis.ListarContas().CpfCliente);
Assert.IsNotNull(result);
}
}
public void Start()
{
var targetImgFiles = dbContext.FileEntry.Where(x => x.Name == "Commission 50集全 无水印").Select(x => x.ActualPath).Distinct().ToList();
foreach (var imgItem in targetImgFiles)
{
var imgs = dbContext.FileEntry.Where(x => x.ActualPath == imgItem).ToList();
if (imgs.Count == 1)
{
continue;
}
var tmpToRemoveImgList = imgs.Skip(1);
dbContext.RemoveRange(tmpToRemoveImgList);
dbContext.SaveChanges();
}
}
/// <summary>
/// 删除某个类别所有标签
/// </summary>
/// <param name="SourceType">来源类型 <seealso cref="TagsSourceType"/></param>
/// <param name="SourceId">来源Id</param>
/// <returns>影响条数</returns>
public int DeleteTags(string SourceType, string SourceId)
{
if (string.IsNullOrEmpty(SourceType))
{
return(-1);
}
using (CommonDbContext cdb = new CommonDbContext())
{
var dbSet = cdb.Set <Tags>();
var query = dbSet.FindAll(e => e.TagType == SourceType);
if (!string.IsNullOrEmpty(SourceId))
{
query = query.Where(e => e.SourceId == SourceId);
}
dbSet.RemoveRange(query);
return(cdb.SaveChanges());
}
}
public void DeveTestar_ListarUsuarioC1()
{
var options = testeUteis.CriarDataBaseTeste("ListarUsuarioC1Teste");
using (var context = new CommonDbContext(options))
{
context.Contas.Add(testeUteis.ListarContas());
context.SaveChanges();
mockCaixaEletronicoDao.Setup(x => x.ListarUsuario(It.IsAny <long>())).Returns(testeUteis.Contas());
var chamada = service.ListarUsuario(testeUteis.ListarContas().CpfCliente);
Assert.AreEqual(200, chamada.Codigo);
Assert.IsNotNull(chamada.Data);
Assert.AreEqual("Consulta efetuada com sucesso", chamada.Mensagem);
}
}
public void DeveTestar_ListarUsuario()
{
var options = testeUteis.CriarDataBaseTeste("ListarUsuarioTeste");
using (var context = new CommonDbContext(options))
{
context.Contas.Add(testeUteis.ListarContas());
context.SaveChanges();
mockCaixaEletronicoDao.Setup(x => x.ListarUsuario(It.IsAny <long>())).Returns(new ContaDTO());
var chamada = service.ListarUsuario(testeUteis.ListarContas().CpfCliente);
Assert.AreEqual(500, chamada.Codigo);
Assert.IsNull(chamada.Data);
Assert.AreEqual("Erro ao listar usuário, verifique as informações.", chamada.Mensagem);
}
}
public void CaixaEletronicoDAOTest_RetornarNotasNecessarias()
{
var options = testesUteis.CriarDataBaseTeste("RetornarNotasNecessariasDAOTeste");
decimal valorSacar = 500;
using (var context = new CommonDbContext(options))
{
context.Caixas.Add(testesUteis.ListarCaixas());
context.SaveChanges();
caixaEletronicoDao = new CaixaEletronicoDAO(context);
var result = caixaEletronicoDao.RetornarNotasNecessarias(valorSacar);
Assert.IsNotNull(result);
}
}
private static void LoadInitalData(CommonDbContext db)
{
foreach (var item in _currencyData)
{
Currency currency = db.Currencies.FirstOrDefault(c => c.Symbol == item.Symbol);
if (currency == null)
{
db.Currencies.Add(item);
}
else
{
currency.Name = item.Name;
currency.Symbol = item.Symbol;
}
}
db.SaveChanges();
}