public void RequestTest()
{
GetOrderListRequestModel reqModel = new GetOrderListRequestModel();
reqModel.Page = 1;
reqModel.PageSize = 1000;
var req = new GetOrderListRequest("7417441d04ea6267a57cbb6cdced5552", "726fb5fbe5b258d33e32aba78df42e83", reqModel);
var res = req.Request().Result;
var sp = new Moq.Mock <IServiceProvider>();
var myContext = new Service.Context.XinDBContext(new Microsoft.EntityFrameworkCore.DbContextOptions <Service.Context.XinDBContext>());
var logger = new Moq.Mock <ILogger <DataAccess> >();
sp.Setup((o) => o.GetService(typeof(IEntityContext))).Returns(myContext);
sp.Setup((o) => o.GetService(typeof(IRepository <OmsOrderList>)))
.Returns(new GenericEntityRepository <OmsOrderList>(logger.Object));
var provider = new UowProvider(logger.Object, sp.Object);
using (var uow = provider.CreateUnitOfWork())
{
var repository = uow.GetRepository <OmsOrderList>();
List <OmsOrderList> list = new List <OmsOrderList>();
foreach (var item in res.data)
{
var tt = Mapper <GetOrderListResponseModel, OmsOrderList> .Map(item);
list.Add(tt);
}
repository.BulkInsert(list, x => x.IncludeGraph = true);
uow.SaveChanges();
}
}
public async Task JobTest()
{
var repository = LogManager.CreateRepository(Common.LogFactory.repositoryName);
// 指定配置文件
XmlConfigurator.Configure(repository, new FileInfo("log4net.config"));
var logger = new Moq.Mock <ILogger <DataAccess> >();
var sp = new Moq.Mock <IServiceProvider>();
var myContext = new Service.Context.XinDBContext(new Microsoft.EntityFrameworkCore.DbContextOptions <Service.Context.XinDBContext>());
sp.Setup((o) => o.GetService(typeof(IEntityContext))).Returns(myContext);
sp.Setup((o) => o.GetService(typeof(IRepository <ECDeliveryDetail>)))
.Returns(new GenericEntityRepository <ECDeliveryDetail>(logger.Object));
var provider = new UowProvider(logger.Object, sp.Object);
try
{
EcGetDeliveryDetailDaily job = new EcGetDeliveryDetailDaily();
await job.Job();
}
catch (Exception ex)
{
throw ex;
}
}
public void TestFromSql()
{
var logger = new Moq.Mock <ILogger <DataAccess> >();
var sp = new Moq.Mock <IServiceProvider>();
var myContext = new Service.Context.XinDBContext(new Microsoft.EntityFrameworkCore.DbContextOptions <Service.Context.XinDBContext>());
sp.Setup((o) => o.GetService(typeof(IEntityContext))).Returns(myContext);
sp.Setup((o) => o.GetService(typeof(IRepository <SingleProductSell>)))
.Returns(new GenericEntityRepository <SingleProductSell>(logger.Object));
var provider = new UowProvider(logger.Object, sp.Object);
var uow = provider.CreateUnitOfWork();
var repository = uow.GetRepository <SingleProductSell>();
var list = repository.FromSql("select x.Plateform,x.UserAccount,x.SaleOrderCode," +
"x.ShippingMethodPlatform, x.ShippingMethod, x.WarehouseCode," +
"x.DatePaidPlatform, x.PlatformShipTime, x.DateLatestShip, x.Currency," +
"x.CountryCode, ProductCount,a.ProductSku, a.Qty,c.pcrProductSku SubProductSku," +
" a.Qty * c.PcrQuantity SubQty, b.WarehouseId " +
"from EC_SalesOrder x join EC_SalesOrderDetail a on x.OrderId = a.OrderId " +
"join EC_SkuRelation b on a.ProductSku = b.ProductSku " +
"join EC_SkuRelationItems c on b.relationid = c.relationid " +
"order by x.SaleOrderCode").ToList();
string subsku = list[0].SubProductSku;
}
public void RequestTest()
{
EBRmaRefaListReqModel reqModel = new EBRmaRefaListReqModel();
reqModel.Page = 1;
reqModel.PageSize = 1000;
EBRmaRefaRequest req = new EBRmaRefaRequest("admin", "eccang123456", reqModel);
var res = req.Request().Result;
var logger = new Moq.Mock <ILogger <DataAccess> >();
var sp = new Moq.Mock <IServiceProvider>();
var myContext = new Service.Context.XinDBContext(new Microsoft.EntityFrameworkCore.DbContextOptions <Service.Context.XinDBContext>());
sp.Setup((o) => o.GetService(typeof(IEntityContext))).Returns(myContext);
sp.Setup((o) => o.GetService(typeof(IRepository <ECRmaRefa>)))
.Returns(new GenericEntityRepository <ECRmaRefa>(logger.Object));
var _uowProvider = new UowProvider(logger.Object, sp.Object);
List <ECRmaRefa> list = new List <ECRmaRefa>();
using (var uow = _uowProvider.CreateUnitOfWork())
{
var repository = uow.GetRepository <ECRmaRefa>();
foreach (var item in res.Body)
{
var m = Mapper <EC_RmaRefa, ECRmaRefa> .Map(item);
list.Add(m);
}
repository.BulkInsert(list, x => x.IncludeGraph = true);
uow.SaveChanges();
}
}
public async System.Threading.Tasks.Task RequestTestAsync()
{
WMSGetShippingMethodRequest req = new WMSGetShippingMethodRequest("admin", "longqi123456");
var res = await req.Request();
var logger = new Moq.Mock <ILogger <DataAccess> >();
var sp = new Moq.Mock <IServiceProvider>();
var myContext = new Service.Context.XinDBContext(new Microsoft.EntityFrameworkCore.DbContextOptions <Service.Context.XinDBContext>());
sp.Setup((o) => o.GetService(typeof(IEntityContext))).Returns(myContext);
sp.Setup((o) => o.GetService(typeof(IRepository <ECShippingMethod>)))
.Returns(new GenericEntityRepository <ECShippingMethod>(logger.Object));
var _uowProvider = new UowProvider(logger.Object, sp.Object);
List <ECShippingMethod> list = new List <ECShippingMethod>();
using (var uow = _uowProvider.CreateUnitOfWork())
{
var repository = uow.GetRepository <ECShippingMethod>();
foreach (var item in res.Body)
{
var m = Mapper <EC_ShippingMethod, ECShippingMethod> .Map(item);
list.Add(m);
}
repository.BulkInsert(list, x => x.IncludeGraph = true);
uow.SaveChanges();
}
}
public async System.Threading.Tasks.Task RequestTestAsync()
{
WMSGetCountryRequest req = new WMSGetCountryRequest("admin", "eccang123456");
var ee = await req.Request();
var repository = LogManager.CreateRepository(Common.LogFactory.repositoryName);
// 指定配置文件
XmlConfigurator.Configure(repository, new FileInfo("log4net.config"));
var logger = new Moq.Mock <ILogger <DataAccess> >();
var sp = new Moq.Mock <IServiceProvider>();
var myContext = new Service.Context.XinDBContext(new Microsoft.EntityFrameworkCore.DbContextOptions <Service.Context.XinDBContext>());
sp.Setup((o) => o.GetService(typeof(IEntityContext))).Returns(myContext);
sp.Setup((o) => o.GetService(typeof(IRepository <ECCountry>)))
.Returns(new GenericEntityRepository <ECCountry>(logger.Object));
var provider = new UowProvider(logger.Object, sp.Object);
using (var uow = provider.CreateUnitOfWork())
{
var repos = uow.GetRepository <ECCountry>();
List <ECCountry> list = new List <ECCountry>();
foreach (var item in ee.Body)
{
var m = Mapper <EC_Country, ECCountry> .Map(item);
list.Add(m);
}
repos.BulkInsert(list, X => X.IncludeGraph = true);
uow.SaveChanges();
}
}
public async System.Threading.Tasks.Task JobTestAsync()
{
var repository = LogManager.CreateRepository(Common.LogFactory.repositoryName);
// 指定配置文件
XmlConfigurator.Configure(repository, new FileInfo("log4net.config"));
var logger = new Moq.Mock <ILogger <DataAccess> >();
var sp = new Moq.Mock <IServiceProvider>();
var myContext = new Service.Context.XinDBContext(new Microsoft.EntityFrameworkCore.DbContextOptions <Service.Context.XinDBContext>());
EcShipBatchInit job = new EcShipBatchInit();
await job.Job();
}
public void TestMethod1()
{
var logger = new Moq.Mock <ILogger <DataAccess> >();
var sp = new Moq.Mock <IServiceProvider>();
var myContext = new Service.Context.XinDBContext(new Microsoft.EntityFrameworkCore.DbContextOptions <Service.Context.XinDBContext>());
sp.Setup((o) => o.GetService(typeof(IEntityContext))).Returns(myContext);
sp.Setup((o) => o.GetService(typeof(IRepository <ResDepartment>)))
.Returns(new GenericEntityRepository <ResDepartment>(logger.Object));
var provider = new UowProvider(logger.Object, sp.Object);
var uow = provider.CreateUnitOfWork();
var repository = uow.GetRepository <ResDepartment>();
var list = repository.GetAll().ToList();
int id = list[0].Id;
}
public async System.Threading.Tasks.Task JobTestAsync()
{
var repository = LogManager.CreateRepository(Common.LogFactory.repositoryName);
// 指定配置文件
XmlConfigurator.Configure(repository, new FileInfo("log4net.config"));
var logger = new Moq.Mock <ILogger <DataAccess> >();
var sp = new Moq.Mock <IServiceProvider>();
var myContext = new Service.Context.XinDBContext(new Microsoft.EntityFrameworkCore.DbContextOptions <Service.Context.XinDBContext>());
sp.Setup((o) => o.GetService(typeof(IEntityContext))).Returns(myContext);
sp.Setup((o) => o.GetService(typeof(IRepository <ECTransitBatchNumber>)))
.Returns(new GenericEntityRepository <ECTransitBatchNumber>(logger.Object));
var provider = new UowProvider(logger.Object, sp.Object);
EcTransitBatchNumberInit job = new EcTransitBatchNumberInit(provider);
await job.Job();
}
public void TestOne2many()
{
var logger = new Moq.Mock <ILogger <DataAccess> >();
var sp = new Moq.Mock <IServiceProvider>();
var myContext = new Service.Context.XinDBContext(new Microsoft.EntityFrameworkCore.DbContextOptions <Service.Context.XinDBContext>());
sp.Setup((o) => o.GetService(typeof(IEntityContext))).Returns(myContext);
sp.Setup((o) => o.GetService(typeof(IRepository <ResUser>)))
.Returns(new GenericEntityRepository <ResUser>(logger.Object));
var provider = new UowProvider(logger.Object, sp.Object);
using (var uow = provider.CreateUnitOfWork())
{
var repository = uow.GetRepository <ResUser>();
var user = repository.Query(x => x.UserName == "admin" && x.UserPwd == SecretHelper.MD5Encrypt("h111111", "h111111"));
}
}
public void GetListTest()
{
var logger = new Moq.Mock <ILogger <DataAccess> >();
var sp = new Moq.Mock <IServiceProvider>();
var myContext = new Service.Context.XinDBContext(new Microsoft.EntityFrameworkCore.DbContextOptions <Service.Context.XinDBContext>());
sp.Setup((o) => o.GetService(typeof(IEntityContext))).Returns(myContext);
sp.Setup((o) => o.GetService(typeof(IRepository <SingleSalesAnalysis>)))
.Returns(new GenericEntityRepository <SingleSalesAnalysis>(logger.Object));
sp.Setup((o) => o.GetService(typeof(ISingleSalesAnlysisRepository)))
.Returns(new SingleSalesAnlysisRepository(myContext));
var provider = new UowProvider(logger.Object, sp.Object);
using (var uow = provider.CreateUnitOfWork())
{
var repository = uow.GetCustomRepository <ISingleSalesAnlysisRepository>();
var list = repository.GetPage(DateTime.Now, 10, 50);
}
}
public void TestProcedure()
{
var edate = DateTime.Now;
var sdate = edate.AddDays(-7);
var sdatep = new SqlParameter("@Sdate", sdate);
var edatep = new SqlParameter("@Edate", edate);
var logger = new Moq.Mock <ILogger <DataAccess> >();
var sp = new Moq.Mock <IServiceProvider>();
var myContext = new Service.Context.XinDBContext(new Microsoft.EntityFrameworkCore.DbContextOptions <Service.Context.XinDBContext>());
sp.Setup((o) => o.GetService(typeof(IEntityContext))).Returns(myContext);
sp.Setup((o) => o.GetService(typeof(IRepository <TotalSale>)))
.Returns(new GenericEntityRepository <TotalSale>(logger.Object));
var provider = new UowProvider(logger.Object, sp.Object);
using (var uow = provider.CreateUnitOfWork())
{
var repository = uow.GetRepository <TotalSale>();
var list = repository.FromProcedure("EXECUTE TotalSale_sp @Sdate,@Edate", sdatep, edatep).ToList();
}
}
public async System.Threading.Tasks.Task RequestTestAsync()
{
#region 实体类转Json
// string str = @"public class TransitBox{
//public int? Id { get; set; }
//public int? WarehouseId { get; set; }
//public int? BoxId { get; set; }
//public string BoxCode { get; set; }
//public string FbaCode { get; set; }
//public decimal? Length { get; set; }
//public decimal? Width { get; set; }
//public decimal? Height { get; set; }
//public decimal? Weight { get; set; }
//public int? ProQty { get; set; }
//public int? MeasureUserId { get; set; }
//public DateTime? MeasureTime { get; set; }
//public DateTime? ArriveTime { get; set; }
//public DateTime? OutTime { get; set; }
//public int? ReceiptStatus { get; set; }
//public int? MeasureStatus { get; set; }
//public int? ExceptionStatus { get; set; }
//public int? ExceptionConfirm { get; set; }
//public string ExceptionInfo { get; set; }
//public DateTime? UpdateTime { get; set; }
//}";
// str = Regex.Replace(str, @"[\r\n]", "");
// string sqlhead = "EC_";
// string sqlbody = "";
// for (int i = 0; i < str.Length; i++)
// if (str[i] == 'p' && str[i + 1] == 'u' && str[i + 2] == 'b' && str[i + 3] == 'l' && str[i + 4] == 'i' && str[i + 5] == 'c')
// {
// if (i == 0)
// {
// i += 13;
// for (; ; )
// {
// if (str[i] == '{') break;
// sqlhead += str[i];
// i++;
// }
// }
// else
// {
// string type = "";
// string sqltype = "";
// string sqlname = "";
// i += 7;
// for (; ; )
// {
// if (str[i] == ' ') break;
// type += str[i];
// i++;
// }
// switch (type)
// {
// case "string":
// sqltype = " nvarchar(255),\r\n";
// break;
// case "bool":
// sqltype = " nvarchar(255),\r\n";
// break;
// case "DateTime":
// sqltype = " datetime,\r\n";
// break;
// case "decimal":
// sqltype = " decimal(18, 0),\r\n";
// break;
// case "int":
// sqltype = " int,\r\n";
// break;
// default:
// sqltype = " " + type + ",\r\n";
// break;
// }
// i++;
// for (; ; )
// {
// if (str[i] == ' ') break;
// sqlname += str[i];
// i++;
// }
// sqlbody += sqlname + sqltype;
// i += 13;
// }
// }
// string sql = "create table " + sqlhead + "(\r" + sqlbody + ")";
// Console.WriteLine(sql);
#endregion
try
{
QueryFbaOrderRequestModel model = new QueryFbaOrderRequestModel();
model.FbaCode = "FZ-A007-200119-0001";
QueryFbaOrderRequest req = new QueryFbaOrderRequest("7417441d04ea6267a57cbb6cdced5552",
"726fb5fbe5b258d33e32aba78df42e83",
model);
var res = await req.Request();
var sp = new Moq.Mock <IServiceProvider>();
var myContext = new Service.Context.XinDBContext(new Microsoft.EntityFrameworkCore.DbContextOptions <Service.Context.XinDBContext>());
var logger = new Moq.Mock <ILogger <DataAccess> >();
sp.Setup((o) => o.GetService(typeof(IEntityContext))).Returns(myContext);
sp.Setup((o) => o.GetService(typeof(IRepository <ECFbaQueryOrder>)))
.Returns(new GenericEntityRepository <ECFbaQueryOrder>(logger.Object));
var provider = new UowProvider(logger.Object, sp.Object);
using (var uow = provider.CreateUnitOfWork())
{
var repository = uow.GetRepository <ECFbaQueryOrder>();
var tt = Mapper <QueryFbaOrderResponseModel, ECFbaQueryOrder> .Map(res.data);
tt.FbaCode = tt.FbaOrder.FbaCode;
repository.Add(tt);
uow.SaveChanges();
}
}
catch (Exception ex)
{
throw;
}
}
public EcBaseJob()
{
var logger = new Moq.Mock <ILogger <DataAccess> >();
var sp = new Moq.Mock <IServiceProvider>();
var myContext = new Service.Context.XinDBContext(new Microsoft.EntityFrameworkCore.DbContextOptions <Service.Context.XinDBContext>());
sp.Setup((o) => o.GetService(typeof(IEntityContext))).Returns(myContext);
sp.Setup((o) => o.GetService(typeof(IRepository <ECDeliveryDetail>)))
.Returns(new GenericEntityRepository <ECDeliveryDetail>(logger.Object));
sp.Setup((o) => o.GetService(typeof(IRepository <ECSalesOrder>)))
.Returns(new GenericEntityRepository <ECSalesOrder>(logger.Object));
sp.Setup((o) => o.GetService(typeof(IRepository <ECSalesOrderAddress>)))
.Returns(new GenericEntityRepository <ECSalesOrderAddress>(logger.Object));
sp.Setup((o) => o.GetService(typeof(IRepository <ECProduct>)))
.Returns(new GenericEntityRepository <ECProduct>(logger.Object));
sp.Setup((o) => o.GetService(typeof(IRepository <ECReceivingDetail>)))
.Returns(new GenericEntityRepository <ECReceivingDetail>(logger.Object));
sp.Setup((o) => o.GetService(typeof(IRepository <ECRMARefund>)))
.Returns(new GenericEntityRepository <ECRMARefund>(logger.Object));
sp.Setup((o) => o.GetService(typeof(IRepository <ECSkuRelation>)))
.Returns(new GenericEntityRepository <ECSkuRelation>(logger.Object));
sp.Setup((o) => o.GetService(typeof(IRepository <BnsSendDeliverdToEc>)))
.Returns(new GenericEntityRepository <BnsSendDeliverdToEc>(logger.Object));
sp.Setup((o) => o.GetService(typeof(IRepository <ECRmaRefa>)))
.Returns(new GenericEntityRepository <ECRmaRefa>(logger.Object));
sp.Setup((o) => o.GetService(typeof(IRepository <ECInventoryBatch>)))
.Returns(new GenericEntityRepository <ECInventoryBatch>(logger.Object));
sp.Setup((o) => o.GetService(typeof(IRepository <ECTransitBatchNumber>)))
.Returns(new GenericEntityRepository <ECTransitBatchNumber>(logger.Object));
sp.Setup((o) => o.GetService(typeof(IRepository <ECShipBatch>)))
.Returns(new GenericEntityRepository <ECShipBatch>(logger.Object));
sp.Setup((o) => o.GetService(typeof(IRepository <ECWarehouse>)))
.Returns(new GenericEntityRepository <ECWarehouse>(logger.Object));
sp.Setup((o) => o.GetService(typeof(IRepository <ECCurrency>)))
.Returns(new GenericEntityRepository <ECCurrency>(logger.Object));
sp.Setup((o) => o.GetService(typeof(IRepository <ECShippingMethod>)))
.Returns(new GenericEntityRepository <ECShippingMethod>(logger.Object));
_uowProvider = new UowProvider(logger.Object, sp.Object);
var config = new AppConfigurationServices().Configuration;
login = new LoginModel()
{
Username = config["ECLogin:Username"],
Password = config["ECLogin:Password"]
};
}
public void TestContext()
{
var myContext = new Service.Context.XinDBContext(new Microsoft.EntityFrameworkCore.DbContextOptions <Service.Context.XinDBContext>());
var query = myContext.Set <ResDepartment>();
var all = query.First <ResDepartment>(p => p.Id == 1);
}
public async System.Threading.Tasks.Task RequestTestAsync()
{
EBGetOrderListReqModel reqModel = new EBGetOrderListReqModel();
reqModel.GetDetail = IsOrNotEnum.Yes;
reqModel.Page = 1;
reqModel.PageSize = 100;
Conditions c = new Conditions();
List <string> list = new List <string>();
list.Add("600153656");
c.RefNos = list;
reqModel.Condition = c;
EBGetOrderListRequest req = new EBGetOrderListRequest("admin", "longqi123456", reqModel);
var rr = await req.Request();
var repository = LogManager.CreateRepository(Common.LogFactory.repositoryName);
// 指定配置文件
XmlConfigurator.Configure(repository, new FileInfo("log4net.config"));
var logger = new Moq.Mock <ILogger <DataAccess> >();
var sp = new Moq.Mock <IServiceProvider>();
var myContext = new Service.Context.XinDBContext(new Microsoft.EntityFrameworkCore.DbContextOptions <Service.Context.XinDBContext>());
sp.Setup((o) => o.GetService(typeof(IEntityContext))).Returns(myContext);
sp.Setup((o) => o.GetService(typeof(IRepository <ECSalesOrder>)))
.Returns(new GenericEntityRepository <ECSalesOrder>(logger.Object));
var provider = new UowProvider(logger.Object, sp.Object);
using (var uow = provider.CreateUnitOfWork())
{
var repos = uow.GetRepository <ECSalesOrder>();
List <ECSalesOrder> insertList = new List <ECSalesOrder>();
List <ECSalesOrder> updateList = new List <ECSalesOrder>();
foreach (var item in rr.Body)
{
var m = Mapper <EC_SalesOrder, ECSalesOrder> .Map(item);
var had = repos.Get(m.OrderId, x => x.Include(a => a.BnsSendDeliverdToEcs));
if (had != null)
{
updateList.Add(m);
}
else
{
insertList.Add(m);
}
}
try
{
insertList = insertList.GroupBy(item => item.OrderId).Select(item => item.First()).ToList();
updateList = updateList.GroupBy(item => item.OrderId).Select(item => item.First()).ToList();
await repos.BulkInsertAsync(insertList, x => x.IncludeGraph = true);
await repos.BulkUpdateAsync(updateList, x => x.IncludeGraph = true);
uow.BulkSaveChanges();
insertList.Clear();
updateList.Clear();
}
catch (Exception ex)
{
throw ex;
}
}
Assert.Fail();
}
