public IEnumerable <dynamic> GetPageList(System.Collections.Specialized.NameValueCollection nvl, out int recordCount)
{
var query = BusinessRepository.GetQuery();
var queryTrader = TraderRepository.GetQuery();
var queryBrand = BrandRepository.GetQuery();
var title = nvl["title"];
if (!title.IsNullOrEmpty())
{
query = query.Where(o => o.Title.Contains(title) || o.Byname.Contains(title));
}
var q = from x in query
select new {
x.Id,
x.Title,
x.Byname,
x.ById,
x.CreateDT,
x.CreateUID,
x.Status,
StateTitle = x.Status == 1 ? "可用" : "禁用",
TraderNum = queryTrader.Count(o => ("," + o.BusinessScopeId + ",").Contains("," + x.ById + ","))
};
recordCount = q.Count();
return(q.ToPageList());
}
public void KeyValueHistoryRepositoryTest()
{
var connectionstring =
"DefaultEndpointsProtocol=https;AccountName=lkedevmain;AccountKey=l0W0CaoNiRZQIqJ536sIScSV5fUuQmPYRQYohj/UjO7+ZVdpUiEsRLtQMxD+1szNuAeJ351ndkOsdWFzWBXmdw==";
var traderRepository = new TraderRepository(new AzureTableStorage <TableEntity>(connectionstring, "Traders", null),
new AzureTableStorage <TraderSettings>(connectionstring, "TraderSettings", null));
var settings = traderRepository.GetPropertiyByPhoneNumber("+375447890502", "SmsSettings").Result;
}
public void SubmitOffer()
{
Trader me = null;
TradingPost post = null;
Commodity commondity = null;
NewTradeOffer offer = null;
int id = 0;
var dbName = "SubmitOffer";
"Given I am a trader".x(async() =>
{
var traderRepository = new TraderRepository(CreateNewContext(dbName));
id = await traderRepository.New(TestTradeDataStatic.MargamanTrader);
me = await traderRepository.Get(id);
});
"And I have a trading post".x(async() =>
{
var systemRepository = new AstralSystemRepository(CreateNewContext(dbName));
await systemRepository.New(TestSystemDataStatic.StantonSystem);
var system = await systemRepository.Get(id);
post = system.TradePoints.OfType <TradingPost>().First();
});
"And I have a new commodity".x(async() =>
{
var commodityRepo = new CommodityRepository(CreateNewContext(dbName));
var id = await commodityRepo.New(TestTradeDataStatic.AgriciumCommondity);
commondity = await commodityRepo.Get(id);
});
"And I have an offer".x(() => offer = new NewTradeOffer
{
Id = 0,
TraderId = me.Id,
TradePointId = post.Id,
CommodityId = commondity.Id,
PricePerUnit = 23.99M,
OfferType = (int)OfferType.Buy
});
"When I submit the offer".x(async() =>
{
var traderRepository = new TraderRepository(CreateNewContext(dbName));
var command = new NewTradeOfferCommand(traderRepository);
id = await command.Execute(offer);
});
"Then the Offer is displayed".x(async() =>
{
var traderRepository = new TraderRepository(CreateNewContext(dbName), true);
var trader = await traderRepository.Get(me.Id);
AssertOffer(trader.TradeOffers.First(o => o.Id == id), offer);
});
}
public List <Entity.Business> GetTreeList(System.Collections.Specialized.NameValueCollection nvl)
{
var query = BusinessRepository.GetQuery();
var queryTrader = TraderRepository.GetQuery();
var queryBrand = BrandRepository.GetQuery();
var queryPayLicense = PayLicenseRepository.GetQuery();
var title = nvl["title"];
if (!title.IsNullOrEmpty())
{
query = query.Where(o => o.Title.Contains(title) || o.Byname.Contains(title));
}
var q = from x in query
select new
{
Id = x.Id,
Title = x.Title,
Byname = x.Byname,
ById = x.ById,
CreateDT = x.CreateDT,
CreateUID = x.CreateUID,
Status = x.Status,
TraderNum = queryTrader.Count(o => ("," + o.BusinessScopeId + ",").Contains("," + x.ById + ",")),
PayLicenseNum = queryPayLicense.Count(o => o.BusinessId1 == x.ById || o.BusinessId2 == x.ById),
x.ParentId
};
var buss = q.ToList().Select(x => new Business()
{
Id = x.Id,
Title = x.Title,
Byname = x.Byname,
ById = x.ById,
CreateDT = x.CreateDT,
CreateUID = x.CreateUID,
Status = x.Status,
TraderNum = x.TraderNum,
PayLicenseNum = x.PayLicenseNum,
ParentId = x.ParentId
}).ToList();
var list = new List <Entity.Business>();
foreach (var bu in buss.Where(o => o.ParentId.IsNullOrEmpty()))
{
SetChilds(bu, buss);
list.Add(bu);
}
return(list);
}
public void SubmitTrader()
{
Trader trader = null;
int id = 0;
var dbName = "SubmitTrader";
"Given I have a new trader".x(() => trader = TestTradeDataStatic.MargamanTrader);
"When I submit the trader".x(async() =>
{
var traderRepository = new TraderRepository(CreateNewContext(dbName));
await traderRepository.New(trader);
id = trader.Id;
});
"Then the trader is displayed".x(async() =>
{
var traderRepository = new TraderRepository(CreateNewContext(dbName));
AssertTrader(await traderRepository.Get(id), trader);
});
}
public TraderService(Service service) : base(service)
{
this._traderRepository = new TraderRepository(Provider, OInfo);
}
public TraderService(string connString) : base(connString)
{
this._traderRepository = new TraderRepository(Provider, OInfo);
}
public OpResult SaveOrUpdate(CompanyAuthorize obj)
{
if (!TraderRepository.GetQuery(o => o.CID == obj.CID).Any())
{
return(OpResult.Fail("商户不存在!"));
}
//if(!obj.RealmName.IsNullOrEmpty()) obj.RealmName=obj.RealmName.Trim();
//if(!obj.RealmName.IsNullOrEmpty() && RealmRepository.GetQuery(o => o.Name == obj.RealmName && o.Url!=obj.RealmUrl).Any())
// return OpResult.Fail("子域名已存在!");
obj.AppProper = obj.AppProper ?? "N";
obj.StoreProper = obj.StoreProper ?? "N";
obj.PosMinorDisp = obj.PosMinorDisp ?? "N";
obj.MemberShared = obj.MemberShared ?? "Y";
if (obj.Id == 0)
{
if (CompanyAuthorRepository.GetQuery(o => o.CID == obj.CID).Any())
{
return(OpResult.Fail("该商户已存在，如果已过期，请选择续约方式"));
}
obj.CreateDT = DateTime.Now;
obj.CreateUID = CurrentUser.UID;
obj.ExpirationDT = DateTime.Parse(obj.EffectiveDT).AddMonths(obj.ValidityNum.GetValueOrDefault()).ToString("yyyy-MM-dd");
if (obj.RealmName.IsNullOrEmpty())
{
CompanyAuthorRepository.Add(obj);
}
else
{
//CompanyAuthorRepository.Add(obj, false);
//RealmRepository.Add(new Realm() { CID = obj.CID.Value, Name = obj.RealmName, State = Convert.ToInt16(obj.RealmState), Url = obj.RealmName + obj.RealmSuffixUrl });
}
}
else
{
var res = CompanyAuthorRepository.Get(obj.Id);
var pwd = res.SupperPassword;
obj.ToCopyProperty(res, new List <string>()
{
"CreateDT", "CreateUID", "CID", "MachineSN", "SerialNo"
});
res.ExpirationDT = DateTime.Parse(obj.EffectiveDT).AddMonths(obj.ValidityNum.GetValueOrDefault()).ToString("yyyy-MM-dd");
if (obj.SupperPassword.IsNullOrEmpty())
{
res.SupperPassword = pwd;
}
//if(!res.RealmName.IsNullOrEmpty())
//{
// var realm = RealmRepository.Find(o => o.Url == res.RealmUrl && o.CID==res.CID.Value);
// if (realm == null)
// {
// realm = new Realm();
// realm.CID = res.CID.Value;
// RealmRepository.Add(realm,false);
// }
// realm.Name = res.RealmName;
// realm.Url = res.RealmName + res.RealmSuffixUrl;
// realm.State = Convert.ToInt16(res.RealmState);
//}
//else if (res.RealmName.IsNullOrEmpty())
//{
// var reals = RealmRepository.GetQuery(o => o.Url == res.RealmUrl && o.CID == res.CID).ToList();
// RealmRepository.RemoveRange(reals, false);
//}
CompanyAuthorRepository.SaveChanges();
}
return(OpResult.Success());
}
