public void AccountSyncing(int userId)
{
using (var db = new YintaiHangzhouContext("YintaiHangzhouContext"))
{
var account = db.UserAccounts.Where(ua => ua.AccountType == (int)AccountType.Point && ua.User_Id == userId && ua.Status != (int)DataStatus.Deleted).FirstOrDefault();
var sumPoints = db.PointHistories.Where(p => p.User_Id == userId && p.Status != (int)DataStatus.Deleted).Sum(p => p.Amount);
if (account != null)
{
account.Amount = sumPoints > 0 ? sumPoints : 0;
account.UpdatedDate = DateTime.Now;
db.Entry(account).State = System.Data.EntityState.Modified;
db.SaveChanges();
}
else
{
db.UserAccounts.Add(new UserAccountEntity()
{
AccountType = (int)AccountType.Point,
Amount = sumPoints > 0 ? sumPoints : 0,
User_Id = userId,
Status = (int)DataStatus.Normal,
CreatedDate = DateTime.Now,
CreatedUser = userId,
UpdatedDate = DateTime.Now,
UpdatedUser = userId
});
db.SaveChanges();
}
}
}
public void AccountSyncing(int userId)
{
using (var db = new YintaiHangzhouContext("YintaiHangzhouContext"))
{
var account = db.UserAccounts.Where(ua => ua.AccountType == (int)AccountType.Point && ua.User_Id == userId && ua.Status != (int)DataStatus.Deleted).FirstOrDefault();
var sumPoints = db.PointHistories.Where(p => p.User_Id == userId && p.Status != (int)DataStatus.Deleted).Sum(p => p.Amount);
if (account != null)
{
account.Amount = sumPoints > 0 ? sumPoints : 0;
account.UpdatedDate = DateTime.Now;
db.Entry(account).State = System.Data.EntityState.Modified;
db.SaveChanges();
}
else
{
db.UserAccounts.Add(new UserAccountEntity()
{
AccountType = (int)AccountType.Point,
Amount = sumPoints > 0 ? sumPoints : 0,
User_Id = userId,
Status = (int)DataStatus.Normal,
CreatedDate = DateTime.Now,
CreatedUser = userId,
UpdatedDate = DateTime.Now,
UpdatedUser = userId
});
db.SaveChanges();
}
}
}
private void updateILike(YintaiHangzhouContext db, int accountId)
{
var account = db.UserAccounts.Where(ua => ua.AccountType == (int)AccountType.IlikeCount && ua.User_Id == accountId && ua.Status != (int)DataStatus.Deleted).FirstOrDefault();
var likes = db.Likes.Where(p => p.LikeUserId == accountId && p.Status != (int)DataStatus.Deleted).Count();
if (account != null)
{
account.Amount = likes;
account.UpdatedDate = DateTime.Now;
db.Entry(account).State = System.Data.EntityState.Modified;
db.SaveChanges();
}
else
{
db.UserAccounts.Add(new UserAccountEntity()
{
AccountType = (int)AccountType.IlikeCount,
Amount = likes,
User_Id = accountId,
Status = (int)DataStatus.Normal,
CreatedDate = DateTime.Now,
CreatedUser = accountId,
UpdatedDate = DateTime.Now,
UpdatedUser = accountId
});
}
}
private void updateILike(YintaiHangzhouContext db, int accountId)
{
var account = db.UserAccounts.Where(ua => ua.AccountType == (int)AccountType.IlikeCount && ua.User_Id == accountId && ua.Status != (int)DataStatus.Deleted).FirstOrDefault();
var likes = db.Likes.Where(p => p.LikeUserId == accountId && p.Status != (int)DataStatus.Deleted).Count();
if (account != null)
{
account.Amount = likes;
account.UpdatedDate = DateTime.Now;
db.Entry(account).State = System.Data.EntityState.Modified;
db.SaveChanges();
}
else
{
db.UserAccounts.Add(new UserAccountEntity()
{
AccountType = (int)AccountType.IlikeCount,
Amount = likes,
User_Id = accountId,
Status = (int)DataStatus.Normal,
CreatedDate = DateTime.Now,
CreatedUser = accountId,
UpdatedDate = DateTime.Now,
UpdatedUser = accountId
});
}
}
private void internalVoidOrderWhenRMAComplete()
{
ILog log = LogManager.GetLogger(this.GetType());
int cursor = 0;
int size = JobConfig.DEFAULT_PAGE_SIZE;
int successCount = 0;
var benchDate = DateTime.Today;
var toBenchDate = benchDate.AddDays(1);
Stopwatch sw = new Stopwatch();
sw.Start();
using (var db = new YintaiHangzhouContext("YintaiHangzhouContext"))
{
var rmas = db.RMAs.Where(r => r.Status == (int)RMAStatus.Complete && r.UpdateDate >= benchDate && r.UpdateDate < toBenchDate);
int totalCount = rmas.Count();
while (cursor < totalCount)
{
var result = rmas.OrderByDescending(r => r.Id).Skip(cursor).Take(size);
foreach (var rma in result)
{
var rmaQuantity = db.RMAs.Where(r => r.OrderNo == rma.OrderNo && r.Status == (int)RMAStatus.Complete)
.Join(db.RMAItems, o => o.RMANo, i => i.RMANo, (o, i) => i).Sum(i => i.Quantity);
var totalQuantity = db.OrderItems.Where(o => o.OrderNo == rma.OrderNo).Sum(i => i.Quantity);
if (rmaQuantity != totalQuantity)
continue;
var orderEntity = db.Orders.Where(o => o.OrderNo == rma.OrderNo).First();
if (orderEntity.Status != (int)OrderStatus.RMAd)
{
orderEntity.Status = (int)OrderStatus.RMAd;
orderEntity.UpdateDate = DateTime.Now;
db.OrderLogs.Add(new OrderLogEntity()
{
CreateDate = DateTime.Now,
CreateUser = 0,
CustomerId = orderEntity.CustomerId,
Operation = "订单全部退货",
OrderNo = orderEntity.OrderNo,
Type = (int)OrderOpera.FromSystem
});
db.SaveChanges();
successCount++;
}
}
cursor += size;
}
}
sw.Stop();
log.Info(string.Format("{0} order convert to rmad in {1} => {2} docs/s", successCount, sw.Elapsed, successCount / sw.Elapsed.TotalSeconds));
}
public void Notify(int id)
{
int notifiedId = NotifyId;
using (var db = new YintaiHangzhouContext("YintaiHangzhouContext"))
{
db.NotificationLogs.Add(new NotificationLogEntity()
{
CreateDate = DateTime.Now,
SourceId = notifiedId,
SourceType = (int)Yintai.Hangzhou.Model.Enums.SourceType.Comment,
Status = (int)NotificationStatus.Default
});
db.SaveChanges();
}
}
public void Execute(IJobExecutionContext context)
{
ILog log = LogManager.GetLogger(this.GetType());
JobDataMap data = context.JobDetail.JobDataMap;
var benchDate = data.ContainsKey("benchdate")?data.GetDateTime("benchdate"):DateTime.Today.AddDays(-1);
int successCount = 0;
int cursor = 0;
int size = JobConfig.DEFAULT_PAGE_SIZE;
Stopwatch sw = new Stopwatch();
sw.Start();
using (var db = new YintaiHangzhouContext("YintaiHangzhouContext"))
{
var prods = from r in db.UserAccounts
where r.AccountType == (int)AccountType.Point
&& (from p in db.PointHistories
where (p.CreatedDate>=benchDate || p.UpdatedDate>=benchDate)
&& p.User_Id == r.User_Id
select p).Any()
select r;
int totalCount = prods.Count();
while (cursor < totalCount)
{
var linq = prods.OrderByDescending(p => p.Id).Skip(cursor).Take(size).ToList();
foreach (var l in linq)
{
var sumPoints = db.PointHistories.Where(p => p.User_Id == l.User_Id && p.Status != (int)DataStatus.Deleted).Sum(p => p.Amount);
if (sumPoints == l.Amount)
continue;
l.Amount = sumPoints > 0 ? sumPoints : 0;
l.UpdatedDate = DateTime.Now;
db.Entry(l).State = System.Data.EntityState.Modified;
db.SaveChanges();
successCount++;
}
cursor += size;
}
}
sw.Stop();
log.Info(string.Format("{0} accounts in {1} => {2} docs/s", successCount, sw.Elapsed, successCount / sw.Elapsed.TotalSeconds));
}
public void Notify(int id)
{
int notifiedId = NotifyId;
using (var db = new YintaiHangzhouContext("YintaiHangzhouContext"))
{
db.NotificationLogs.Add(new NotificationLogEntity()
{
CreateDate = DateTime.Now,
SourceId = notifiedId,
SourceType = (int)Yintai.Hangzhou.Model.Enums.SourceType.PMessage,
Status = (int)NotificationStatus.Default
});
db.SaveChanges();
}
}
protected override void QueueNotification(PushBroker push,IJobExecutionContext context)
{
ILog log = LogManager.GetLogger(typeof(ApnsNotificationCommonJob));
JobDataMap data = context.JobDetail.JobDataMap;
var interval = data.GetIntValue("intervalofsec");
int cursor = 0;
int size = JobConfig.DEFAULT_PAGE_SIZE;
int successCount = 0;
var benchDate = DateTime.Now.AddSeconds(-interval);
Stopwatch sw = new Stopwatch();
sw.Start();
using (var db = new YintaiHangzhouContext("YintaiHangzhouContext"))
{
var prods = (from p in db.NotificationLogs
where p.CreateDate>= benchDate &&
p.Status==(int)NotificationStatus.Default
select p);
if (prods != null)
{
int totalCount = prods.Count();
while (cursor < totalCount)
{
var linq = prods.OrderByDescending(p => p.Id).Skip(cursor).Take(size).ToList();
foreach (var l in linq)
{
try
{
if (l.SourceType.Value == (int)SourceType.PMessage)
{
var device = db.PMessages.Where(p => p.Id == l.SourceId)
.Join(db.DeviceLogs, o => o.ToUser, i => i.User_Id, (o, i) => new {
D = i,U=o
}).FirstOrDefault();
if (device==null)
continue;
push.QueueNotification(new AppleNotification()
.ForDeviceToken(device.D.DeviceToken)
.WithAlert("新私信...")
.WithBadge(1)
.WithCustomItem("from", JsonConvert.SerializeObject(new { targettype = (int)PushSourceType.PMessage, targetvalue =device.U.FromUser}))
.WithSound("sound.caf"));
successCount++;
l.NotifyDate = DateTime.Now;
l.Status = (int)NotificationStatus.Notified;
db.Entry(l).State = System.Data.EntityState.Modified;
db.SaveChanges();
}
else if (l.SourceType.Value == (int)SourceType.Comment)
{
// if it's comment, always notify all comments owners of this item
var comment = db.Comments.Find(l.SourceId);
if (comment == null)
continue;
var relatedComments = db.Comments.Where(c => c.SourceType == comment.SourceType
&& c.SourceId == comment.SourceId
&& c.User_Id != comment.User_Id)
.Join(db.DeviceLogs.Where(d => d.User_Id > 0),
o => o.User_Id,
i => i.User_Id,
(o, i) => new { Token = i.DeviceToken }).ToList();
if (comment.SourceType == (int)SourceType.Product)
{
var product = db.Products.Where(p => p.Id == comment.SourceId && p.RecommendUser != comment.User_Id)
.Join(db.DeviceLogs.Where(d => d.User_Id > 0),
o => o.CreatedUser,
i => i.User_Id,
(o, i) => new { Token = i.DeviceToken }).FirstOrDefault();
if (product != null)
relatedComments.Add(new { Token = product.Token });
}
else if (comment.SourceType == (int)SourceType.Promotion)
{
var promotion = db.Promotions.Where(p => p.Id == comment.SourceId && p.RecommendUser != comment.User_Id)
.Join(db.DeviceLogs.Where(d => d.User_Id > 0),
o => o.CreatedUser,
i => i.User_Id,
(o, i) => new { Token = i.DeviceToken }).FirstOrDefault();
if (promotion != null)
relatedComments.Add(new { Token = promotion.Token });
}
foreach (var device in relatedComments.Distinct())
{
push.QueueNotification(new AppleNotification()
.ForDeviceToken(device.Token)
.WithAlert("新评论...")
.WithBadge(1)
.WithCustomItem("from", JsonConvert.SerializeObject(new { targettype = (int)PushSourceType.SelfComment, targetvalue = comment.SourceId }))
.WithSound("sound.caf"));
successCount++;
}
l.NotifyDate = DateTime.Now;
l.Status = (int)NotificationStatus.Notified;
db.Entry(l).State = System.Data.EntityState.Modified;
db.SaveChanges();
}
}
catch (Exception ex)
{
log.Info(ex);
}
}
cursor += size;
}
}
}
sw.Stop();
log.Info(string.Format("{0} notifications in {1} => {2} notis/s", successCount, sw.Elapsed, successCount / sw.Elapsed.TotalSeconds));
}
public void AccountSyncing(int userId)
{
using (var db = new YintaiHangzhouContext("YintaiHangzhouContext"))
{
var offlineAccount = db.UserAccounts.Where(ua => ua.AccountType == (int)AccountType.OfflineCoupon && ua.User_Id == userId && ua.Status != (int)DataStatus.Deleted).FirstOrDefault();
var account = db.UserAccounts.Where(ua => ua.AccountType == (int)AccountType.Coupon && ua.User_Id == userId && ua.Status != (int)DataStatus.Deleted).FirstOrDefault();
var sumCoupons = db.CouponHistories.Where(p => p.User_Id == userId && p.Status != (int)DataStatus.Deleted && p.ValidEndDate >= DateTime.Now && p.Status != (int)CouponStatus.Used).Count();
var sumStoreCoupons = db.StoreCoupons.Where(p => p.UserId == userId && p.Status != (int)DataStatus.Deleted && p.ValidEndDate >= DateTime.Now && p.Status != (int)CouponStatus.Used).Count();
if (offlineAccount != null)
{
offlineAccount.Amount = sumStoreCoupons;
offlineAccount.UpdatedDate = DateTime.Now;
db.Entry(offlineAccount).State = System.Data.EntityState.Modified;
}
else
{
db.UserAccounts.Add(new UserAccountEntity()
{
AccountType = (int)AccountType.OfflineCoupon,
Amount = sumStoreCoupons,
User_Id = userId,
Status = (int)DataStatus.Normal,
CreatedDate = DateTime.Now,
CreatedUser = userId,
UpdatedDate = DateTime.Now,
UpdatedUser = userId
});
}
if (account != null)
{
account.Amount = sumCoupons + sumStoreCoupons;
account.UpdatedDate = DateTime.Now;
db.Entry(account).State = System.Data.EntityState.Modified;
}
else
{
db.UserAccounts.Add(new UserAccountEntity()
{
AccountType = (int)AccountType.Coupon,
Amount = sumCoupons + sumStoreCoupons,
User_Id = userId,
Status = (int)DataStatus.Normal,
CreatedDate = DateTime.Now,
CreatedUser = userId,
UpdatedDate = DateTime.Now,
UpdatedUser = userId
});
}
db.SaveChanges();
}
}
public void Execute(IJobExecutionContext context)
{
ILog log = LogManager.GetLogger(this.GetType());
JobDataMap data = context.JobDetail.JobDataMap;
var interval = data.ContainsKey("interval") ? data.GetIntValue("interval") : 24 * 60;
var benchDate = DateTime.Now.AddMinutes(-interval);
var host = data.GetString("awshost");
var public_key = data.GetString("publickey");
var private_key = data.GetString("privatekey");
dynamic jsonResponse = null;
AwsHelper.SendHttpMessage(host, new
{
benchdate = benchDate.ToUniversalTime()
},public_key,private_key,r=>jsonResponse = r,null);
if (jsonResponse == null )
{
log.Info("request error!" );
return;
}
int successCount = 0;
Stopwatch sw = new Stopwatch();
sw.Start();
using (var db = new YintaiHangzhouContext("YintaiHangzhouContext"))
{
foreach (var dynamicObject in jsonResponse.data)
{
try
{
string code = dynamicObject.code;
int? status = dynamicObject.status;
DateTime opeDate = dynamicObject.created_at;
CouponStatus targetStatus = CouponStatus.Used;
CouponActionType targetActionType = CouponActionType.Consume;
if (status.HasValue && status.Value == -1)
{
targetStatus = CouponStatus.Normal;
targetActionType = CouponActionType.Rebate;
}
switch ((int)dynamicObject.coupontype)
{
case 1:
var coupon = db.StoreCoupons.Where(s => s.Code == code && s.Status != (int)CouponStatus.Deleted).FirstOrDefault();
if (coupon != null)
{
coupon.Status = (int)targetStatus;
coupon.UpdateDate = opeDate.ToLocalTime();
coupon.UpdateUser = 0;
db.Entry(coupon).State = EntityState.Modified;
db.CouponLogs.Add(new CouponLogEntity()
{
ActionType = (int)targetActionType,
BrandNo = dynamicObject.brandno,
Code = code,
ConsumeStoreNo = dynamicObject.storeno,
CreateDate = opeDate.ToLocalTime(),
CreateUser = 0,
ReceiptNo = dynamicObject.receiptno,
Type = 1
});
db.SaveChanges();
successCount++;
}
break;
case 2:
var coupon2 = db.CouponHistories.Where(s => s.CouponId == code && s.Status != (int)CouponStatus.Deleted).FirstOrDefault();
if (coupon2 != null)
{
coupon2.Status = (int)targetStatus;
db.Entry(coupon2).State = EntityState.Modified;
db.CouponLogs.Add(new CouponLogEntity()
{
ActionType = (int)targetActionType,
BrandNo = dynamicObject.brandno,
Code = code,
ConsumeStoreNo = dynamicObject.storeno,
CreateDate = opeDate.ToLocalTime(),
CreateUser = 0,
ReceiptNo = dynamicObject.receiptno,
Type = 2
});
db.SaveChanges();
successCount++;
}
break;
}
}
catch (Exception ex)
{
log.Error(ex);
}
}
}
sw.Stop();
log.Info(string.Format("{0} status logs in {1} => {2} docs/s", successCount, sw.Elapsed, successCount / sw.Elapsed.TotalSeconds));
}
public static void SyncOne(SALE_CODE section)
{
EnsureSectionContext(section);
using (var db = new YintaiHangzhouContext("YintaiHangzhouContext"))
{
var sectionId = section.SID;
var existBrand = db.Set<SectionEntity>().Where(b => b.ChannelSectionId == sectionId).FirstOrDefault();
var storeEntity = db.Set<StoreEntity>().Where(s => s.ExStoreId == section.SHOP_SID).FirstOrDefault();
if (existBrand == null)
{
db.Sections.Add(new SectionEntity()
{
ChannelSectionId = (int)section.SID,
CreateDate = DateTime.Now,
CreateUser = 0,
Location = section.ADDRESS ?? string.Empty,
Name = section.SALE_CODE_NAME ?? string.Empty,
ContactPhone = string.Empty,
StoreId = storeEntity.Id,
Status = (int)DataStatus.Normal,
UpdateDate = DateTime.Now,
UpdateUser = 0
});
}
else
{
existBrand.Name = section.SALE_CODE_NAME ?? string.Empty;
existBrand.UpdateDate = section.OPT_UPDATE_TIME ?? DateTime.Now;
existBrand.Location = section.ADDRESS ?? string.Empty;
existBrand.StoreId = storeEntity.Id;
db.Entry(existBrand).State = System.Data.EntityState.Modified;
}
db.SaveChanges();
}
}
public static void SyncOne(PRO_CLASS_DICT cat)
{
using (var db = new YintaiHangzhouContext("YintaiHangzhouContext"))
{
var existCat = db.Set<CategoryEntity>().Where(b => b.ExCatId == cat.SID).FirstOrDefault();
if (existCat == null)
{
db.Categories.Add(new CategoryEntity()
{
ExCatCode = cat.PRO_CLASS_NUM,
ExCatId = (int)cat.SID,
Name = cat.PRO_CLASS_DESC,
Status = 1,
UpdateDate = cat.OPT_UPDATE_TIME ?? DateTime.Now
});
}
else
{
existCat.ExCatCode = cat.PRO_CLASS_NUM;
existCat.Name = cat.PRO_CLASS_DESC;
existCat.UpdateDate = cat.OPT_UPDATE_TIME ?? DateTime.Now;
}
db.SaveChanges();
}
}
public void Execute(IJobExecutionContext context)
{
ILog log = LogManager.GetLogger(this.GetType());
JobDataMap data = context.JobDetail.JobDataMap;
var totalCount = 0;
var interval = data.ContainsKey("intervalOfHrs") ? data.GetInt("intervalOfHrs") : 1;
if (!data.ContainsKey("benchtime"))
{
data.Put("benchtime", DateTime.Now.AddHours(-interval));
}
else
{
data["benchtime"] = data.GetDateTimeValue("benchtime").AddHours(interval);
}
var benchTime = data.GetDateTime("benchtime");
Query(benchTime, orders => totalCount = orders.Count());
int cursor = 0;
int successCount = 0;
int size = JobConfig.DEFAULT_PAGE_SIZE;
int lastCursor = 0;
Stopwatch sw = new Stopwatch();
sw.Start();
while (cursor < totalCount)
{
List<OrderEntity> oneTimeList = null;
Query(benchTime, orders =>
{
oneTimeList = orders.Where(a => a.Id > lastCursor).OrderBy(a => a.Id).Take(size).ToList();
});
foreach (var order in oneTimeList)
{
try
{
using (var db = new YintaiHangzhouContext("YintaiHangzhouContext"))
{
order.Status = (int)OrderStatus.Void;
order.UpdateDate = DateTime.Now;
db.Entry(order).State = System.Data.EntityState.Modified;
db.OrderLogs.Add(new OrderLogEntity() {
CreateDate = DateTime.Now,
CreateUser = 0,
CustomerId = order.CreateUser,
Operation="过期未支付，自动取消",
OrderNo = order.OrderNo,
Type=(int)OrderOpera.SystemVoid
});
db.SaveChanges();
successCount++;
}
}
catch (Exception ex)
{
log.Info(ex);
}
}
cursor += size;
if (oneTimeList != null && oneTimeList.Count > 0)
lastCursor = oneTimeList.Max(o => o.Id);
}
sw.Stop();
log.Info(string.Format("total voiding orders:{0},{1} voided orders in {2} => {3} docs/s", totalCount, successCount, sw.Elapsed, successCount / sw.Elapsed.TotalSeconds));
}
public static void SyncOne(SHOP_INFO store)
{
using (var db = new YintaiHangzhouContext("YintaiHangzhouContext"))
{
var existStore = db.Set<StoreEntity>().Where(b => b.ExStoreId == store.SID).FirstOrDefault();
if (existStore == null)
{
db.Stores.Add(new StoreEntity()
{
CreatedDate = DateTime.Now,
CreatedUser = 0,
ExStoreId = (int)store.SID,
Description = string.Empty,
Location = store.SHOP_ADDR??string.Empty,
Name = store.SHOP_NAME,
RMAAddress = store.SHOP_ADDR,
RMAPerson = store.REFUND_LINKER,
RMAPhone = store.REFUND_TEL,
RMAZipCode = store.POSTCODE.HasValue?store.POSTCODE.ToString():string.Empty,
UpdatedDate = store.OPT_UPDATE_TIME ?? DateTime.Now,
UpdatedUser = 0,
Status = 1,
Tel = store.LINKER_PHONE??string.Empty
});
}
else
{
existStore.RMAZipCode = store.POSTCODE.HasValue ? store.POSTCODE.ToString() : string.Empty;
existStore.RMAPhone = store.REFUND_TEL;
existStore.RMAAddress = store.SHOP_ADDR;
existStore.RMAPerson = store.REFUND_LINKER;
existStore.UpdatedDate = store.OPT_UPDATE_TIME ?? DateTime.Now;
existStore.Location = store.SHOP_ADDR??string.Empty;
existStore.Tel = store.LINKER_PHONE ?? string.Empty;
existStore.Name = store.SHOP_NAME;
db.Entry(existStore).State = System.Data.EntityState.Modified;
}
db.SaveChanges();
}
}
public void Execute(IJobExecutionContext context)
{
ILog log = LogManager.GetLogger(this.GetType());
JobDataMap data = context.JobDetail.JobDataMap;
var benchDate = data.ContainsKey("benchdate") ? data.GetDateTime("benchdate") : DateTime.Today.AddDays(-1);
var interval = data.ContainsKey("intervalOfSecs") ? data.GetInt("intervalOfSecs") : 5 * 60;
int successCount = 0;
int cursor = 0;
int size = JobConfig.DEFAULT_PAGE_SIZE;
Stopwatch sw = new Stopwatch();
sw.Start();
int totalCount = 0;
Query(o => totalCount = o.Count());
while (cursor < totalCount)
{
var orderList = new List<OrderEntity>();
Query(o=>orderList = o.OrderBy(p=>p.Id).Skip(cursor).Take(size).ToList());
foreach (var l in orderList)
{
using(var ts = new TransactionScope())
{
using (var db = new YintaiHangzhouContext("YintaiHangzhouContext"))
{
db.JobSuccessHistories.Add(new JobSuccessHistoryEntity() {
CreateDate = DateTime.Now,
JobId = l.Id,
JobType = (int)JobType.Wx_Shipping
});
var linq = db.Set<Order2ExEntity>().Where(o => o.OrderNo == l.OrderNo)
.Join(db.Set<OrderTransactionEntity>().Where(ot => ot.PaymentCode == WxPayConfig.PaymentCode)
, o => o.OrderNo
, i => i.OrderNo
, (o, i) => new { OE = o, OT = i }).FirstOrDefault();
if (linq == null)
{
log.Info(string.Format("order has not transaction:{0}",l.OrderNo));
continue;
}
var requestData = new WxNotify() {
DeliverMsg = "已提货",
DeliverStatus="1",
DeliverTS = DateTime.Now.TicksOfWx().ToString(),
OutTradeNo = linq.OE.ExOrderNo,
OpenId = linq.OT.OutsiteUId,
TransactionId = linq.OT.TransNo
};
bool notifyResult = WxServiceHelper.Notify(requestData.EncodedRequest, null, null);
if (notifyResult)
{
db.SaveChanges();
ts.Complete();
successCount++;
}
}
}
}
cursor += size;
}
sw.Stop();
log.Info(string.Format("{0} wx orders notified in {1} => {2} docs/s", successCount, sw.Elapsed, successCount / sw.Elapsed.TotalSeconds));
}
public void Execute(IJobExecutionContext context)
{
JobDataMap data = context.JobDetail.JobDataMap;
var privatekey = data.GetString("privatekey");
var publickey = data.GetString("publickey");
var awsExpireurl = data.GetString("awsexpireurl");
int point2GroupRatio = int.Parse(ConfigurationManager.AppSettings["point2groupratio"]);
ILog log = LogManager.GetLogger(this.GetType());
int cursor = 0;
int successCount = 0;
int size = JobConfig.DEFAULT_PAGE_SIZE;
int totalCount = 0;
DateTime fromDate = DateTime.Today.AddDays(-1);
Stopwatch sw = new Stopwatch();
sw.Start();
using (var db = new YintaiHangzhouContext("YintaiHangzhouContext"))
{
Query(db, fromDate, coupons => totalCount = coupons.Count());
}
int lastMaxId = 0;
while (cursor < totalCount)
{
List<StoreCouponEntity> oneTimeList = null;
using (var db = new YintaiHangzhouContext("YintaiHangzhouContext"))
{
Query(db, fromDate, coupons => oneTimeList = coupons.Where(c=>c.Id>lastMaxId).OrderBy(c=>c.Id).Take(size).ToList());
}
foreach (var coupon in oneTimeList)
{
bool canRebate = AwsHelper.SendHttpMessage(awsExpireurl, new { code = coupon.Code }
, publickey
, privatekey
, null
, null);
if (!canRebate)
{
continue;
}
using (var ts = new TransactionScope())
{
using (var db = new YintaiHangzhouContext("YintaiHangzhouContext"))
{
var point = db.PointHistories.Where(u => u.User_Id == coupon.UserId.Value && u.Type == (int)PointType.VoidCoupon && u.Description == coupon.Code).FirstOrDefault();
if (point == null)
{
db.PointHistories.Add(new PointHistoryEntity()
{
Amount = (decimal)coupon.Points * point2GroupRatio,
CreatedDate = DateTime.Now,
CreatedUser = 0,
Description = coupon.Code,
Name = string.Format("代金券过期返回积点{0}", coupon.Points * point2GroupRatio),
PointSourceType = (int)PointSourceType.System,
PointSourceId = 0,
Status = (int)DataStatus.Normal,
Type = (int)PointType.VoidCoupon,
UpdatedDate = DateTime.Now,
UpdatedUser = 0,
User_Id = coupon.UserId.Value
});
db.SaveChanges();
}
ts.Complete();
successCount++;
}
}
}
cursor += size;
lastMaxId = oneTimeList.Max(c => c.Id);
}
sw.Stop();
log.Info(string.Format("{0} rebate points in {1} => {2} docs/s", successCount, sw.Elapsed, successCount / sw.Elapsed.TotalSeconds));
}
public static bool OrderPaid2Erp(OrderTransactionEntity order,bool isOnlinePay = true)
{
string vipCard = string.Empty;
var log = ServiceLocator.Current.Resolve<ILog>();
if (order.OutsiteType.HasValue && order.OutsiteType.Value == (int)OutsiteType.WX
&& !string.IsNullOrEmpty(order.OutsiteUId))
{
try
{
AwsHelper.SendHttpMessage(string.Format("{0}card/find", ConfigManager.AwsHost), new
{
uid = order.OutsiteUId
}, ConfigManager.AwsHttpPublicKey, ConfigManager.AwsHttpPrivateKey, r => vipCard = r.data, null);
}
catch (Exception ex)
{
log.Error(ex);
}
}
bool isSuccess = false;
if (order.OrderType == (int)PaidOrderType.Erp2)
{
isSuccess = Erp2ServiceHelper.SendHttpMessage(Erp2Config.PAY_URL, new { saleno = order.OrderNo, paymentcode = order.PaymentCode, transno = order.TransNo, vipno = vipCard }, null
, null);
}
else
{
var paymentName = string.Empty;
string dealCode = order.OrderNo;
using (var db = new YintaiHangzhouContext("YintaiHangzhouContext"))
{
var paymentEntity = db.Set<PaymentMethodEntity>().Where(p => p.Code == order.PaymentCode).FirstOrDefault();
if (paymentEntity == null)
{
log.Error(string.Format("orderno :{1} not support payment code paid:{0}", order.PaymentCode, order.OrderNo));
return false;
}
paymentName = paymentEntity.Name;
//渠道订单同步时传递的是渠道订单号
var channelOrder = db.Set<Map4Order>().FirstOrDefault(o=>o.OrderNo==dealCode);
if (channelOrder != null && !string.IsNullOrEmpty(channelOrder.ChannelOrderCode))
{
dealCode = channelOrder.ChannelOrderCode;
}
}
var paidFunc = isOnlinePay ? "WebOrdersPaid" : "WebSalesPaid";
isSuccess = ErpServiceHelper.SendHttpMessage(ConfigManager.ErpBaseUrl, new { func = paidFunc, dealCode, PAY_TYPE = order.PaymentCode, PaymentName = paymentName, TRADE_NO = order.TransNo, CardNo = vipCard }, null
, null);
}
if (isSuccess)
{
using (var db = new YintaiHangzhouContext("YintaiHangzhouContext"))
{
order.IsSynced = true;
order.SyncDate = DateTime.Now;
db.Entry(order).State = EntityState.Modified;
db.SaveChanges();
}
}
return isSuccess;
}
public static void SyncOne(SUPPLY_MIN_PRICE_MX product)
{
if (!EnsureProductContext(product))
return;
using (var ts = new TransactionScope())
{
using (var db = new YintaiHangzhouContext("YintaiHangzhouContext"))
{
var existProduct = db.Set<ProductEntity>().Join(db.Set<ProductMapEntity>().Where(ep => ep.ChannelPId == product.PRODUCT_SID), o => o.Id, i => i.ProductId, (o, i) => o).FirstOrDefault();
var color = db.Set<ProductPropertyValueEntity>().Where(b => b.ChannelValueId == product.PRO_COLOR_SID)
.Join(db.Set<ProductPropertyEntity>().Where(pp => pp.ProductId == existProduct.Id), o => o.PropertyId, i => i.Id, (o, i) => o).FirstOrDefault();
var size = db.Set<ProductPropertyValueEntity>().Where(b => b.ChannelValueId == product.PRO_STAN_SID)
.Join(db.Set<ProductPropertyEntity>().Where(pp => pp.ProductId == existProduct.Id), o => o.PropertyId, i => i.Id, (o, i) => o).FirstOrDefault();
var inventory = db.Set<InventoryEntity>().Where(i => i.ChannelInventoryId == product.PRO_DETAIL_SID).FirstOrDefault();
int amount = (int)product.PRO_STOCK_SUM;
bool no4sale = product.PRO_ACTIVE_BIT.GetValueOrDefault()==0;
if (no4sale)
amount = 0;
if (inventory == null)
{
db.Inventories.Add(new InventoryEntity()
{
ProductId = existProduct.Id,
PColorId = color.Id,
PSizeId = size.Id,
UpdateDate = DateTime.Now,
UpdateUser = 0,
Amount = amount,
ChannelInventoryId = (int)product.PRO_DETAIL_SID
});
}
else
{
inventory.Amount = amount;
}
//update product.is4sale
if ((existProduct.Is4Sale ?? false) == false && !no4sale)
{
existProduct.Is4Sale = true;
existProduct.UpdatedDate = DateTime.Now;
}
db.SaveChanges();
}
ts.Complete();
}
}
public void Execute(IJobExecutionContext context)
{
ILog log = LogManager.GetLogger(this.GetType());
JobDataMap data = context.JobDetail.JobDataMap;
var privatekey = data.GetString("privatekey");
var publickey = data.GetString("publickey");
var minPoints = data.GetInt("minpoints");
var groupPointConvertUrl = data.GetString("pointconverturl");
int point2GroupRatio = int.Parse(ConfigurationManager.AppSettings["point2groupratio"]);
string appStoreNo = ConfigurationManager.AppSettings["appStoreNoInGroup"];
if (string.IsNullOrEmpty(appStoreNo))
{
log.Info("app store no in group is empty!");
return;
}
int cursor = 0;
int successCount = 0;
int size = JobConfig.DEFAULT_PAGE_SIZE;
int totalCount = 0;
Stopwatch sw = new Stopwatch();
sw.Start();
Type linqType = new { U = (UserAccountEntity)null, C = (CardEntity)null }.GetType();
using (var db = new YintaiHangzhouContext("YintaiHangzhouContext"))
{
Query(db, minPoints, a => totalCount = a.Count());
}
int lastMaxId = 0;
while (cursor < totalCount)
{
List<LinqInner> accounts = null;
using (var db = new YintaiHangzhouContext("YintaiHangzhouContext"))
{
Query(db, minPoints, acs => accounts = acs.Where(a=>a.U.Id>lastMaxId).OrderBy(a => a.U.Id).Take(size).ToList());
}
foreach (var account in accounts)
{
using (var ts = new TransactionScope())
{
// step1: check account balanced
using (var db = new YintaiHangzhouContext("YintaiHangzhouContext"))
{
var correctPoints = db.PointHistories.Where(p => p.User_Id == account.U.User_Id && p.Status != (int)DataStatus.Deleted).Sum(p => p.Amount);
var convertPoints = correctPoints - correctPoints % point2GroupRatio;
if (convertPoints < minPoints)
continue;
//step 2: insert deduct point history
db.PointHistories.Add(new PointHistoryEntity()
{
Amount = -convertPoints,
CreatedDate = DateTime.Now,
CreatedUser = 0,
Description = string.Format("转换为集团积点{0}", -convertPoints),
Name = string.Format("转换为集团积点{0}", -convertPoints),
PointSourceType = (int)PointSourceType.System,
PointSourceId = 0,
Status = (int)DataStatus.Normal,
Type = (int)PointType.Convert2Group,
UpdatedDate = DateTime.Now,
UpdatedUser = 0,
User_Id = account.U.User_Id
});
db.SaveChanges();
// step 3: call group service to convert points
string errorMsg;
bool canConvert = GroupServiceHelper.SendHttpMessage(groupPointConvertUrl,
publickey,
privatekey,
new
{
cardno = account.C.CardNo,
amount = convertPoints / point2GroupRatio,
storeno = appStoreNo
},
out errorMsg);
if (canConvert)
{
ts.Complete();
successCount++;
}
else
{
log.Info(string.Format("convert points failed for cardno:{0},msg:{1}", account.C.CardNo, errorMsg));
}
}
}
}
cursor += size;
lastMaxId = accounts.Max(a => a.U.Id);
}
sw.Stop();
log.Info(string.Format("{0} points from app2group in {1} => {2} docs/s", successCount, sw.Elapsed, successCount / sw.Elapsed.TotalSeconds));
}
public static void SyncOne(BRAND brand)
{
using (var db = new YintaiHangzhouContext("YintaiHangzhouContext"))
{
var existBrand = db.Set<BrandEntity>().Where(b => b.ChannelBrandId == brand.SID).FirstOrDefault();
if (existBrand == null)
{
db.Brands.Add(new BrandEntity()
{
ChannelBrandId = (int)brand.SID,
CreatedDate = DateTime.Now,
CreatedUser = 0,
Name = brand.BRAND_NAME,
EnglishName = brand.BRAND_NAME_SECOND,
Logo = brand.PICTURE_URL??string.Empty,
Status = brand.BRAND_ACTIVE_BIT,
UpdatedDate = brand.OPT_UPDATE_TIME ?? DateTime.Now,
UpdatedUser = 0,
Description = brand.BRAND_STORY??string.Empty,
Group = (brand.BRAND_GROUP_NUM??0).ToString(),
WebSite = string.Empty
});
}
else
{
existBrand.Name = brand.BRAND_NAME;
existBrand.EnglishName = brand.BRAND_NAME_SECOND;
existBrand.Logo = brand.PICTURE_URL??string.Empty;;
existBrand.Status = brand.BRAND_ACTIVE_BIT;
existBrand.UpdatedUser = 0;
existBrand.UpdatedDate = brand.OPT_UPDATE_TIME ?? DateTime.Now;
existBrand.Description = brand.BRAND_STORY??string.Empty;
existBrand.Group = (brand.BRAND_GROUP_NUM ?? 0).ToString();
db.Entry(existBrand).State = System.Data.EntityState.Modified;
}
db.SaveChanges();
}
}
public static bool SyncOne(decimal pid, decimal sizeId,string sizeName, decimal colorId,string colorName)
{
if (!EnsureProductContext(pid))
return false;
if (sizeId == 0 || colorId == 0)
{
Log.Error(string.Format("product sid:{0} with empty color sid or size sid",pid));
return false;
}
using (var db = new YintaiHangzhouContext("YintaiHangzhouContext"))
{
var product = db.Set<ProductMapEntity>().Where(p=>p.ChannelPId == pid).FirstOrDefault();
if (product == null)
return false; ;
var existColor = db.Set<ProductPropertyValueEntity>().Where(b =>b.ChannelValueId == colorId)
.Join(db.Set<ProductPropertyEntity>().Where(pp=>pp.ProductId==product.ProductId),o=>o.PropertyId,i=>i.Id,(o,i)=>o)
.FirstOrDefault();
if (existColor == null)
{
var colorEntity = db.Set<ProductPropertyEntity>().Where(p => p.ProductId == product.ProductId && p.IsColor.HasValue && p.IsColor.Value == true).FirstOrDefault();
if (colorEntity == null)
{
colorEntity = db.ProductProperties.Add(new ProductPropertyEntity()
{
IsColor = true,
ChannelPropertyId = 0,
ProductId = product.ProductId,
PropertyDesc = "颜色",
SortOrder = 0,
Status = 1,
UpdateDate = DateTime.Now,
UpdateUser = 0
});
db.SaveChanges();
}
db.ProductPropertyValues.Add(new ProductPropertyValueEntity() {
ChannelValueId = (int)colorId,
PropertyId = colorEntity.Id,
CreateDate = DateTime.Now,
Status =1,
UpdateDate = DateTime.Now,
ValueDesc = colorName
});
}
else
{
existColor.ValueDesc = colorName;
existColor.UpdateDate = DateTime.Now;
}
var existSize = db.Set<ProductPropertyValueEntity>().Where(b => b.ChannelValueId == sizeId)
.Join(db.Set<ProductPropertyEntity>().Where(pp => pp.ProductId == product.ProductId), o => o.PropertyId, i => i.Id, (o, i) => o).FirstOrDefault();
if (existSize == null)
{
var sizeEntity = db.Set<ProductPropertyEntity>().Where(p => p.ProductId == product.ProductId && p.IsSize.HasValue && p.IsSize.Value == true).FirstOrDefault();
if (sizeEntity == null)
{
sizeEntity = db.ProductProperties.Add(new ProductPropertyEntity()
{
IsSize = true,
ChannelPropertyId = 0,
ProductId = product.ProductId,
PropertyDesc = "尺码",
SortOrder = 0,
Status = 1,
UpdateDate = DateTime.Now,
UpdateUser = 0
});
db.SaveChanges();
}
db.ProductPropertyValues.Add(new ProductPropertyValueEntity()
{
ChannelValueId = (int)sizeId,
PropertyId = sizeEntity.Id,
CreateDate = DateTime.Now,
Status = 1,
UpdateDate = DateTime.Now,
ValueDesc = sizeName
});
}
else
{
existSize.ValueDesc = sizeName;
existSize.UpdateDate = DateTime.Now;
}
db.SaveChanges();
}
return true;
}
public static bool SyncOne(SUPPLY_MIN_PRICE product)
{
EnsureProductContext(product);
if (!product.SHOP_SID.HasValue)
return false;
using (var ts = new TransactionScope())
{
using (var db = new YintaiHangzhouContext("YintaiHangzhouContext"))
{
var existProduct = db.Set<ProductMapEntity>().Where(b => b.ChannelPId == product.PRODUCT_SID).FirstOrDefault();
var tagEntity = db.Set<TagEntity>().Join(db.Set<CategoryMapEntity>().Where(cm => cm.ChannelCatId == product.PRO_CLASS_SID), o => o.Id, i => i.CatId, (o, i) => o)
.FirstOrDefault();
var storeEntity = db.Set<StoreEntity>().Where(s => s.ExStoreId == product.SHOP_SID).FirstOrDefault();
if (storeEntity == null)
{
Log.Error(string.Format("product sid has no store:{0}", product.PRODUCT_SID));
return false;
}
var brandEntity = db.Set<BrandEntity>().Where(b => b.ChannelBrandId == product.BRAND_SID).FirstOrDefault();
if (brandEntity == null)
{
Log.Error(string.Format("product sid has no brand:{0}", product.PRODUCT_SID));
return false;
}
if (existProduct == null)
{
var newProduct = new ProductEntity()
{
CreatedDate = DateTime.Now,
CreatedUser = DEFAULT_OWNER_ID,
SkuCode = product.PRO_SKU,
Brand_Id = brandEntity == null ? 0 : brandEntity.Id,
Description = product.PRO_DESC ?? string.Empty,
Is4Sale = false,
Name = string.IsNullOrEmpty(product.PRODUCT_NAME)? string.Format("{0}-{1}", brandEntity.Name, product.PRO_SKU):product.PRODUCT_NAME,
UnitPrice = product.ORIGINAL_PRICE ?? NULL_PRICE,
RecommendedReason = product.PRO_DESC ?? string.Empty,
RecommendUser = DEFAULT_OWNER_ID,
SortOrder = 0,
Status = (int)DataStatus.Default,
Store_Id = storeEntity == null ? 0 : storeEntity.Id,
Tag_Id = tagEntity == null ? int.Parse(DEFAULT_TAG_ID) : tagEntity.Id,
Price = product.PROMOTION_PRICE ?? NULL_PRICE,
UpdatedDate = product.OPT_UPDATE_TIME ?? DateTime.Now,
UpdatedUser = DEFAULT_OWNER_ID,
BarCode = product.BARCODE,
Favorable = "1"
};
db.Products.Add(newProduct);
db.SaveChanges();
db.ProductMaps.Add(new ProductMapEntity()
{
Channel = "ERP",
ChannelBrandId = (int)product.BRAND_SID,
ChannelPId = (int)product.PRODUCT_SID,
ChannelCatId = (int)(product.PRO_CLASS_SID??0m),
ProductId = newProduct.Id,
UpdateDate = product.OPT_UPDATE_TIME ?? DateTime.Now
});
}
else
{
var existProductEntity = db.Set<ProductEntity>().Find(existProduct.ProductId);
existProductEntity.BarCode = product.BARCODE;
existProductEntity.UpdatedDate = product.OPT_UPDATE_TIME ?? DateTime.Now;
existProductEntity.Store_Id = storeEntity == null ? 0 : storeEntity.Id;
existProductEntity.Brand_Id = brandEntity == null ? 0 : brandEntity.Id;
existProductEntity.Tag_Id = tagEntity == null ? int.Parse(DEFAULT_TAG_ID) : tagEntity.Id;
existProductEntity.SkuCode = product.PRO_SKU;
existProductEntity.Name = string.IsNullOrEmpty(product.PRODUCT_NAME) ? string.Format("{0}-{1}", brandEntity.Name, product.PRO_SKU) : product.PRODUCT_NAME;
existProductEntity.UnitPrice = product.ORIGINAL_PRICE ?? NULL_PRICE;
existProductEntity.Price = product.PROMOTION_PRICE ?? NULL_PRICE;
existProductEntity.Description = product.PRO_DESC ?? string.Empty;
existProductEntity.RecommendedReason = product.PRO_DESC ?? string.Empty;
}
db.SaveChanges();
}
ts.Complete();
}
return true;
}
private void SyncOne(PRO_PICTURE product)
{
if (!EnsureProductContext(product))
return ;
var log = LogManager.GetLogger(this.GetType());
//download remote picture
string exPicDomain = ConfigurationManager.AppSettings["EXPIC_DOMAIN"];
var filePath = FetchRemotePic(string.Format("{0}/{1}",exPicDomain.TrimEnd('/'),Path.Combine(product.PRO_PICT_DIR,product.PRO_PICT_NAME)));
//resize pics
var file = new FileInfo(filePath);
FileInfor uploadFile;
var uploadResult = FileUploadServiceManager.UploadFile(file, "product", out uploadFile, string.Empty);
if (uploadResult != FileMessage.Success)
{
log.Error(string.Format("upload file error:{0}", filePath));
File.Delete(filePath);
return;
}
using (var db = new YintaiHangzhouContext("YintaiHangzhouContext"))
{
var existPic = db.Set<ResourceEntity>().Where(r => r.ChannelPicId == product.SID).FirstOrDefault();
if (existPic == null)
{
var colorEntity = db.Set<ProductPropertyValueEntity>().Where(ppv => ppv.ChannelValueId == product.PRO_COLOR_SID)
.Join(db.Set<ProductPropertyEntity>().Join(db.Set<ProductMapEntity>().Where(pm => pm.ChannelPId == product.PRODUCT_SID), o => o.ProductId, i => i.ProductId, (o, i) => o),
o => o.PropertyId, i => i.Id, (o, i) => o).FirstOrDefault();
var existProduct = db.Set<ProductEntity>().Join(db.Set<ProductMapEntity>().Where(ep => ep.ChannelPId == product.PRODUCT_SID), o => o.Id, i => i.ProductId, (o, i) => o).FirstOrDefault();
db.Resources.Add(new ResourceEntity()
{
ColorId = colorEntity == null ? 0 : colorEntity.Id,
SourceId = existProduct.Id,
SourceType = (int)SourceType.Product,
ContentSize = uploadFile.FileSize,
CreatedDate = DateTime.Now,
CreatedUser = 0,
Domain = string.Empty,
ExtName = uploadFile.FileExtName,
Height = uploadFile.Height,
IsDefault = product.PICTURE_MAST_BIT == 1 ? true : false,
UpdatedDate = product.OPT_UPDATE_TIME ?? DateTime.Now,
Name = uploadFile.FileName,
Status = 1,
SortOrder = (int)product.PRO_PICT_ORDER,
Size = string.Format("{0}x{1}", uploadFile.Width, uploadFile.Height),
Type = (int)uploadFile.ResourceType,
Width = uploadFile.Width,
ChannelPicId = (int)product.SID
});
existProduct.IsHasImage = true;
existProduct.UpdatedDate = product.OPT_UPDATE_TIME ?? DateTime.Now;
existProduct.Status = (int)DataStatus.Normal;
db.SaveChanges();
}
}
File.Delete(filePath);
}