public void Update(
string id,
string userName,
string loginName,
string password,
string connString,
string ket,
string description)
{
using (O2OContext db = new O2OContext())
{
BaseService <UserEntity> baseService = new BaseService <UserEntity>(db);
UserEntity entity = baseService.FirstOrDefault(a => a.Id == id) ?? throw new ArgumentNullException("ÉÌ»§²»´æÔÚ");
entity.Id = id;
entity.UserName = userName;
entity.LoginName = loginName;
if (!string.IsNullOrWhiteSpace(password))
{
entity.PasswordHash = ToolsCommon.MD5Encrypt(password + entity.PasswordSalt);
}
if (!string.IsNullOrWhiteSpace(connString))
{
entity.ConnString = ToolsCommon.ToBase64(connString);
}
entity.Ket = ket;
entity.Description = description;
baseService.Update(entity);
}
}
public async Task SetAsync(string userId, string shopNo, int mtState, int eleState)
{
using (var context = new O2OContext())
{
var service = new BaseService <ShopConfigEntity>(context);
var entity = await service.Entities.FirstOrDefaultAsync(a => a.UserId == userId && a.ShopNo == shopNo);
if (entity != null)
{
entity.MtAutoConfirm = mtState;
entity.EleAutoConfirm = eleState;
service.Update(entity);
}
else
{
var shopConfig = new ShopConfigEntity()
{
UserId = userId,
ShopNo = shopNo,
MtAutoConfirm = mtState,
EleAutoConfirm = eleState
};
service.Add(shopConfig);
}
}
}
public int[] GetMissOrder(string userId, DateTime dateTime, string shopNo, int takeType)
{
Expression <Func <OrderEntity, bool> > expression = a => a.UserId.Equals(userId) && SqlFunctions.DateDiff("d", dateTime, a.OptTime) == 0 && a.ShopNo.Equals(shopNo) && a.TakeType.Equals(takeType);
if (takeType == 1)
{
expression = a => a.UserId.Equals(userId) && (SqlFunctions.DateDiff("d", dateTime, a.OptTime) == (int?)0 && SqlFunctions.DateDiff("d", a.DeliverTime, "1970-01-01") == 0 || SqlFunctions.DateDiff("d", dateTime, a.DeliverTime) == 0) && a.ShopNo.Equals(shopNo) && a.TakeType.Equals(takeType);
}
using (var db = new O2OContext())
{
var baseService = new BaseService <OrderEntity>(db);
var data = db.Order.Where(expression).GroupBy(a => new
{
ShopNo = a.ShopNo
}).Select(g => new
{
MaxDaySeq = g.Max(a => a.DaySeq),
Count = g.Count()
}).FirstOrDefault();
var numArray = new int[0];
if (data == null || data.MaxDaySeq == data.Count)
{
return(numArray);
}
var arrayDaySeq = baseService.Where(expression).Select(a => a.DaySeq).ToArray();
numArray = Enumerable.Range(1, data.MaxDaySeq).Where(a => !arrayDaySeq.Contains(a)).ToArray();
return(numArray);
}
}
public async Task <List <StockRuleShopProdDTO> > GetListShopProdAsync(string userId)
{
var rules = new List <StockRuleEntity>();
using (var context = new O2OContext())
{
var service = new BaseService <StockRuleEntity>(context);
rules = await service
.Where(x => x.UserId == userId)
.Include(x => x.StockRuleShops)
.Include(x => x.StockRuleProds)
.ToListAsync();
}
var shopProds = new List <StockRuleShopProdDTO>();
foreach (var rule in rules)
{
foreach (var stockRuleShop in rule.StockRuleShops)
{
shopProds.Add(new StockRuleShopProdDTO()
{
ShopNo = stockRuleShop.ShopNo,
StockRuleProds = rule.StockRuleProds.Select(x => ToolsCommon.EntityToEntity(x, new StockRuleProdDTO()) as StockRuleProdDTO).ToList()
});
}
}
return(shopProds);
}
public void Add(
string id,
string userName,
string loginName,
string password,
string connString,
string ket,
string description)
{
UserEntity entity = new UserEntity()
{
Id = id,
UserName = userName,
LoginName = loginName,
PasswordSalt = ToolsCommon.CreateVerifyCode(5)
};
entity.PasswordHash = ToolsCommon.MD5Encrypt(password + entity.PasswordSalt);
entity.ConnString = ToolsCommon.ToBase64(connString);
entity.Ket = ket;
entity.Description = description;
entity.CreateDate = DateTime.Now;
using (O2OContext db = new O2OContext())
new BaseService <UserEntity>(db).Add(entity);
}
public void Add(
string userId,
string accountNo,
string accountName,
string waimaiAppId,
string waimaiAppSecret,
string tuangouAppKey,
string tuangouAppSecret,
string description)
{
var entity = new Mt_AccountEntity()
{
UserId = userId,
AccountNo = accountNo,
AccountName = accountName,
WaimaiAppId = waimaiAppId,
WaimaiAppSecret = waimaiAppSecret,
TuangouAppKey = tuangouAppKey,
TuangouAppSecret = tuangouAppSecret,
Description = description
};
using (var db = new O2OContext())
new BaseService <Mt_AccountEntity>(db).Add(entity);
}
public void DeleteProdNoMapInfo(string userId, string prodNo, string prodName)
{
using (var o2Ocontext = new O2OContext())
{
var sql = "WITH t AS (SELECT b.* FROM T_Order a INNER JOIN T_OrderDtl b ON a.Id = b.OrderId WHERE a.UserId= '" + userId + "' AND b.ProdNo = '" + prodNo + "' AND b.ProdName = '" + prodName + "') DELETE T_OrderDtl WHERE Id IN (SELECT Id FROM t)";
o2Ocontext.Database.ExecuteSqlCommand(sql);
}
}
public Mt_AccountDTO GetAccount(string userId)
{
using (var db = new O2OContext())
{
UserEntity userEntity = new BaseService <UserEntity>(db).Entities.FirstOrDefault(a => a.Id == userId);
return(userEntity != null?ToolsCommon.EntityToEntity(userEntity.Mt_Accounts.FirstOrDefault(), new Mt_AccountDTO()) as Mt_AccountDTO : (Mt_AccountDTO)null);
}
}
public Mt_AccountDTO GetAccount(Guid id)
{
using (var db = new O2OContext())
{
var mtAccountEntity = new BaseService <Mt_AccountEntity>(db).FirstOrDefault(a => a.Id == id);
return(mtAccountEntity == null ? null : ToolsCommon.EntityToEntity(mtAccountEntity, new Mt_AccountDTO()) as Mt_AccountDTO);
}
}
public void Delete(string userId)
{
using (O2OContext context = new O2OContext())
{
BaseService <PreProdEntity> service = new BaseService <PreProdEntity>(context);
service.Delete(a => a.UserId == userId);
}
}
public void Update(OrderEntity entity)
{
using (var context = new O2OContext())
{
var service = new BaseService <OrderEntity>(context);
service.Update(entity);
}
}
public async Task DeleteShopAsync(Guid id)
{
using (var context = new O2OContext())
{
var service = new BaseService <StockRuleShopEntity>(context);
service.Delete(id);
}
}
public OrderEntity Get(Guid id)
{
using (var context = new O2OContext())
{
var service = new BaseService <OrderEntity>(context);
return(service.FirstOrDefault(a => a.Id == id));
}
}
public OrderEntity GetByOrderId(string orderId)
{
using (var context = new O2OContext())
{
var service = new BaseService <OrderEntity>(context);
var entity = service.Where(a => a.OrderId == orderId).Include(a => a.OrderDtls).FirstOrDefault();
return(entity);
}
}
public void Update(Ele_AccountDTO dto)
{
using (var context = new O2OContext())
{
var service = new BaseService <Ele_AccountEntity>(context);
var entity = ToolsCommon.EntityToEntity(dto, new Ele_AccountEntity()) as Ele_AccountEntity;
service.Update(entity);
}
}
public bool IsExist(string orderId)
{
using (var context = new O2OContext())
{
var service = new BaseService <OrderEntity>(context);
var count = service.Count(a => a.OrderId == orderId);
return(count != 0);
}
}
public UserDTO GetByLoginName(string loginName, string id = "")
{
using (O2OContext context = new O2OContext())
{
BaseService <UserEntity> service = new BaseService <UserEntity>(context);
var entity = service.Entities.FirstOrDefault(a => a.LoginName == loginName && (id == "" || a.Id != id));
return(ToolsCommon.EntityToEntity(entity, new UserDTO()) as UserDTO);
}
}
public void Update(OrderEntity entity, Dictionary <string, object> dic)
{
ToolsCommon.SetValue(entity, dic);
using (var context = new O2OContext())
{
var service = new BaseService <OrderEntity>(context);
service.Update(entity);
}
}
public void UpdateDtl(IEnumerable <OrderDtlEntity> entities)
{
using (var db = new O2OContext())
{
var baseService = new BaseService <OrderDtlEntity>(db);
foreach (var entity in entities)
{
baseService.UpdateForce(entity);
}
}
}
public Ele_AccountDTO Get(Guid id)
{
using (var context = new O2OContext())
{
var service = new BaseService <Ele_AccountEntity>(context);
Ele_AccountEntity entity = service.GetById(id);
return(ToolsCommon.EntityToEntity(entity, new Ele_AccountDTO()) as Ele_AccountDTO);
}
}
public UserDTO Get(string id)
{
using (O2OContext context = new O2OContext())
{
BaseService <UserEntity> service = new BaseService <UserEntity>(context);
var entity = service.Entities.FirstOrDefault(a => a.Id == id);
return(ToolsCommon.EntityToEntity(entity, new UserDTO()) as UserDTO);
}
}
public void Add(List <PreProdDTO> list)
{
using (O2OContext context = new O2OContext())
{
BaseService <PreProdEntity> service = new BaseService <PreProdEntity>(context);
var entityList = list.Select(a => ToolsCommon.EntityToEntity(a, new PreProdEntity()) as PreProdEntity).ToList();
service.AddRange(entityList);
}
}
public async Task CreateShopAsync(StockRuleShopDTO input)
{
using (var context = new O2OContext())
{
var service = new BaseService <StockRuleShopEntity>(context);
var entity = ToolsCommon.EntityToEntity(input, new StockRuleShopEntity()) as StockRuleShopEntity;
service.Add(entity);
}
}
public void UpdateState(string orderId, int state)
{
using (var context = new O2OContext())
{
var service = new BaseService <OrderEntity>(context);
var entity = service.Entities.FirstOrDefault(a => a.OrderId == orderId);
entity.State = state;
service.Update(entity);
}
}
public void Update(Ele_ShopDTO dto)
{
using (O2OContext context = new O2OContext())
{
BaseService <Ele_ShopEntity> service = new BaseService <Ele_ShopEntity>(context);
var entity = ToolsCommon.EntityToEntity(dto, new Ele_ShopEntity()) as Ele_ShopEntity;
service.Update(entity);
}
}
public void Add(UserDTO dto)
{
using (O2OContext context = new O2OContext())
{
BaseService <UserEntity> service = new BaseService <UserEntity>(context);
var entity = ToolsCommon.EntityToEntity(dto, new UserEntity()) as UserEntity;
service.Add(entity);
}
}
public bool hasPreProd(string userId, string[] prodNos)
{
using (O2OContext context = new O2OContext())
{
BaseService <PreProdEntity> service = new BaseService <PreProdEntity>(context);
var count = service.Where(a => a.UserId == userId && prodNos.Contains(a.ProdNo)).Count();
return(count > 0 ? true : false);
}
}
public async Task <StockRuleProdDTO> GetProdAsync(Guid stockRuleId, string prodNo)
{
using (var context = new O2OContext())
{
var service = new BaseService <StockRuleProdEntity>(context);
var entity = await service.Entities.FirstOrDefaultAsync(x => x.StockRuleId == stockRuleId && x.ProdNo == prodNo);
return(ToolsCommon.EntityToEntity(entity, new StockRuleProdDTO()) as StockRuleProdDTO);
}
}
public async Task <ShopConfigDTO> GetAsync(string userId, string shopNo)
{
using (var context = new O2OContext())
{
var service = new BaseService <ShopConfigEntity>(context);
var entity = await service.Entities.FirstOrDefaultAsync(a => a.UserId == userId && a.ShopNo == shopNo);
return(entity is null ? new ShopConfigDTO() : ToolsCommon.EntityToEntity(entity, new ShopConfigDTO()) as ShopConfigDTO);
}
}
public void SetBuy(string userId, int buyState)
{
using (var context = new O2OContext())
{
var service = new BaseService <OrderEntity>(context);
var entity = service.FirstOrDefault(a => a.OrderId == userId);
entity.BuyState = buyState;
service.Update(entity);
}
}