public void Test()
{
//正常模式下仓储使用
using (var repository = new FlowOrderRepository())
{
repository.UnitOfWork.BeginTransaction(() =>
{
var flowList = repository.QuerySet()
.NotUnitOfWork()
.ToList();
var count = repository.Insert(flowList);
});
repository.UnitOfWork.Rollback();
}
}
public void Test()
{
SqlMapper.Aop.OnExecuting += Aop_OnExecuting;
//正常模式下仓储使用
using (var repository = new FlowOrderRepository())
{
repository.UnitOfWork.BeginTransaction(() =>
{
var flowList = repository.QuerySet()
.Top(10)
.ToList();
var count = repository.Insert(flowList);
});
//repository.UnitOfWork.Rollback();
// var json = JsonConvert.SerializeObject(repository.Orm.Query("SELECT * FROM customer_pay_info LIMIT 1"));
var flowOrders = repository.QuerySet <FlowOrder>()
//.Where(x => x.CustomerCode == "G1119")
.OrderBy(x => x.OrderNumber)
.Top(100)
.ToList();
int index = 0;
//for (var i = 0; i < 50; i++)
//{
// Console.WriteLine(index);
//}
foreach (var item in flowOrders)
{
item.UpdateTime = DateTime.Now;
//item.OrderNumber = Guid.NewGuid().ToString("N");
}
// List<Task> tasks = new List<Task>();
// tasks.Add(Task.Run(async () =>
//{
// var result1 = await repository.CommandSet<FlowOrder>()
// .InsertAsync(flowOrders);
// Console.WriteLine(result1);
//}));
// Task.WaitAll(tasks.ToArray());
var result = repository.CommandSet <FlowOrder>()
.Update(flowOrders);
var testData = flowOrders.FirstOrDefault();
var updateFlowOrder = repository.CommandSet <FlowOrder>()
.Where(x => x.Id.Between(4, 5))
.UpdateSelect(x => new FlowOrder
{
Id = x.Id,
AccountCode = x.AccountCode
});
result = repository.CommandSet <FlowOrder>()
.Delete(testData);
var newId = repository.CommandSet <FlowOrder>()
.InsertIdentity(testData);
}
}
