Example #1
0
        protected void WriteData(List<Jdp> jdps, ShopData shp, DateTime begin, DateTime end, string remark = "同步") {
            try {
                List<TradeFullinfoGetResponse> trdf = jdps.Select(k => TopUtils.ParseResponse<TradeFullinfoGetResponse>(k.jdp_response))
                    .Where(j => !string.IsNullOrEmpty(j.Trade.PayTime)).ToList();
                if (null == trdf || trdf.Count < 1) return;

                using (var blk = new SqlBulkCopy(_con)) {
                    blk.DestinationTableName = "T_ERP_SyncLog";
                    blk.WriteToServerAdv<T_ERP_SyncLog>(new List<T_ERP_SyncLog> { new T_ERP_SyncLog{
                        SellerNick=shp.SellerNick,MinDateTime=begin,MaxDateTime=end,Remark=remark,JdpCounts=jdps.Count,JdpResCounts=trdf.Count
                    }}, Exclude);
                }

                var trdpayed = trdf.Select(k => k.Trade).ToList();
                if (null == trdpayed || trdpayed.Count < 1) return;
                var trdpay = Caster.CastTrades(trdpayed);
                if (null == trdpay || trdpay.Count < 1) return;
                using (var blk = new SqlBulkCopy(_con)) {
                    blk.DestinationTableName = "T_ERP_TaoBaoATS_Trade";
                    blk.WriteToServerAdv<T_ERP_TaoBao_Trade>(trdpay, Exclude);

                    blk.DestinationTableName = "T_ERP_TaoBaoATS_Order";
                    var ords = trdpay.SelectMany(k => k.OrderList).ToList();
                    blk.WriteToServerAdv<T_ERP_TaoBao_Order>(ords, Exclude);

                    blk.DestinationTableName = "T_ERP_TaoBaoATS_PromotionDetail";
                    var kpromt = trdpay.Where(j => j.PromotList != null).SelectMany(k => k.PromotList);
                    if (null != kpromt) {
                        try {
                            var promots = kpromt.ToList();
                            if (null != promots && promots.Count > 0)
                                blk.WriteToServerAdv<T_ERP_TaoBao_PromotionDetail>(promots, Exclude);
                        } catch (Exception ex) { _applog.DebugException(new Exception(string.Format("SHOP:{0} Promot Error:{1}", shp.SellerNick, ex.Message))); }
                    }

                    blk.DestinationTableName = "T_ERP_TaobaoATS_ServiceOrder";
                    var ksvcs = trdpay.Where(j => j.ServiceOrderList != null).SelectMany(k => k.ServiceOrderList);
                    if (null != ksvcs) {
                        try {
                            var svcs = ksvcs.ToList();
                            if (null != svcs && svcs.Count > 0)
                                blk.WriteToServerAdv<T_ERP_Taobao_ServiceOrder>(svcs, Exclude);
                        } catch (Exception ex) { _applog.DebugException(new Exception(string.Format("SHOP:{0} SvcOrder Error:{1}", shp.SellerNick, ex.Message))); }
                    }
                }
                //登记同步时间
                if (remark != "重试")
                    _applog.DebugException(new Exception(string.Format("SHOP:{0} Begin:{1} End:{2} Count:{3}", shp.SellerNick, begin.ToDefaultStr(), end.ToDefaultStr(), jdps.Count)));
                else
                    _applog.DebugException(new Exception(string.Format("RETRY\tSHOP:{1}\tCOUNT:{0}\tBegin:{2}\tEnd:{3}\tFor Retry Sync.", jdps.Count, shp.SellerNick,
                    begin.ToDefaultStr(), end.ToDefaultStr())));
            } catch (Exception ex) {
                _applog.DebugException(new Exception(string.Format("Shop:{0} Begin:{2} End:{3} Ex:{1}", shp.SellerNick, ex.Message,
                    begin.ToDefaultStr(), end.ToDefaultStr())));
                lock (objLock)//加入失败队列重新操作
                {
                    QueFail.Enqueue(new T_ERP_SyncLog {
                        SellerNick = shp.SellerNick,
                        MinDateTime = begin,
                        MaxDateTime = end
                    });
                }
#if DEBUG
                throw;
#else
#endif
            }

        }
Example #2
0
 private T_ERP_ShopRefund GetShopRefund(ShopData shop, DateTime begin, DateTime end, List<Jdp> jds, out List<Refund> refs) {
     List<RefundGetResponse> trdf = jds.Select(k => TopUtils.ParseResponse<RefundGetResponse>(k.jdp_response))
                         .ToList();
     refs = trdf.Select(k => k.Refund).ToList();
     Guid shpguid = Guid.NewGuid();
     return new T_ERP_ShopRefund() {
         Begin = begin,
         End = end,
         Guid = shpguid,
         SellerNick = shop.SellerNick,
         JdpCount = refs.Count
     };
 }
Example #3
0
        private string GetRefFileID(ShopData shop, DateTime begin, DateTime end, T_ERP_ShopRefund shpRef) {
            try {
                using (var blk = new SqlBulkCopy(_con)) {
                    blk.DestinationTableName = shop.RefundTableName;
                    blk.WriteToServer<T_ERP_ShopRefund>(shpRef);
                }
                var fileId = SqlHelper.ExecuteScalar(_con, System.Data.CommandType.Text,
                    string.Format("select id from {0} where guid='{1}'", shop.RefundTableName, shpRef.Guid));
                var fileName = _filepath + "refund\\" + shop.SellerNick + "\\" + fileId.ToString() + ".json";
                if (!File.Exists(_filepath + "test.txt")) {
                    _applog.DebugException(new Exception("路径不合法或者测试文件不存在!"));
                    return string.Empty;
                }
                return fileName;
            } catch (Exception ex) {
                _applog.DebugException(ex);
#if DEBUG
                throw;
#else
#endif
            }
        }
Example #4
0
 private T_ERP_ShopTrade GetShopTrade(ShopData shop, DateTime begin, DateTime end, List<Jdp> jds, out List<Trade> trds) {
     Guid shpguid = Guid.NewGuid();
     List<TradeFullinfoGetResponse> trdf = jds.Select(k => TopUtils.ParseResponse<TradeFullinfoGetResponse>(k.jdp_response))
             .ToList();
     trds = trdf.Select(k => k.Trade).ToList();
     var payed = trds.Where(p => !string.IsNullOrEmpty(p.PayTime));
     var unpay = trds.Where(p => string.IsNullOrEmpty(p.PayTime));
     var step = trds.Where(p => !string.IsNullOrEmpty(p.StepTradeStatus));
     return new T_ERP_ShopTrade() {
         Begin = begin,
         End = end,
         Guid = shpguid,
         SellerNick = shop.SellerNick,
         JdpCount = trds.Count(),
         TrdPayed = payed == null ? 0 : payed.Count(),
         TrdUnPay = unpay == null ? 0 : unpay.Count(),
         TrdStep = step == null ? 0 : step.Count()
     };
 }