Exemplo n.º 1
0
    private void ShowChart(DateTime start, DateTime end)
    {
        //两个时间差
        if (start > end)
        {
            Page.RegisterStartupScript("error", "<script>alert('时间选择有误!');</script>");
            return;
        }
        SiteTotalService         stDal = new SiteTotalService();
        IList <TopSiteTotalInfo> list  = stDal.GetNickOrderTotal(start, end, HttpUtility.UrlDecode(Request.Cookies["nick"].Value));

        SeriseText = "[{name:'订单量', data:[";
        string orderPay = ",{name:'订单金额',data:[";
        string cusPay   = ",{name:'每单均价',data:[";

        DateText = "[";
        for (DateTime i = start; i <= end; i = i.AddDays(1))
        {
            DateText += "'" + i.ToString("yyyyMMdd").Substring(6, 2) + "',";
            IList <TopSiteTotalInfo> mylist = list.Where(o => o.SiteTotalDate == i.ToString("yyyyMMdd")).ToList();

            if (mylist.Count > 0)
            {
                SeriseText += mylist[0].SiteOrderCount + ",";
                orderPay   += mylist[0].SiteOrderPay + ",";
                if (mylist[0].SiteOrderCount == 0)
                {
                    cusPay += "0,";
                }
                else
                {
                    cusPay += ((double)mylist[0].SiteOrderPay / mylist[0].SiteOrderCount).ToString(".00") + ",";
                }
            }
            else
            {
                orderPay   += "0,";
                SeriseText += "0,";
                cusPay     += "0,";
            }
        }
        SeriseText  = SeriseText.Substring(0, SeriseText.Length - 1);
        SeriseText += "]}";
        orderPay    = orderPay.Substring(0, orderPay.Length - 1);
        orderPay   += "]}";
        cusPay      = orderPay + cusPay.Substring(0, cusPay.Length - 1);
        SeriseText += cusPay + "]}]";

        DateText      = DateText.Substring(0, DateText.Length - 1);
        DateText     += "]";
        TB_Start.Text = start.ToShortDateString();
        TB_End.Text   = end.ToShortDateString();
    }
Exemplo n.º 2
0
    private void ShowChart(DateTime start, DateTime end)
    {
        //两个时间差
        if (start > end)
        {
            Page.RegisterStartupScript("error", "<script>alert('时间选择有误!');</script>");
            return;
        }

        string nick = HttpUtility.UrlDecode(Request.Cookies["nick"].Value);
        IList <TopSiteTotalInfo> list = new SiteTotalService().GetCustomerTotal(start.ToString("yyyyMMdd"), end.ToString("yyyyMMdd"), nick);

        SeriseText = "[{name:'客户数', data:[";
        string sucss   = ",{name:'订单金额', data:[";
        string onesell = ",{name:'客单价',data:[";

        DateText = "[";

        for (DateTime i = start; i <= end; i = i.AddDays(1))
        {
            DateText += "'" + i.ToString("yyyyMMdd").Substring(6, 2) + "',";
            IList <TopSiteTotalInfo> mylist = list.Where(o => o.SiteTotalDate == i.ToString("yyyyMMdd")).ToList();
            if (mylist.Count == 0)
            {
                SeriseText += "0,";
                sucss      += "0,";
                onesell    += "0,";
            }
            else
            {
                SeriseText += mylist.Sum(o => o.SiteBuyCustomTotal) + ",";
                sucss      += mylist.Sum(o => o.SiteOrderPay) + ",";
                if (mylist.Sum(o => o.SiteBuyCustomTotal) == 0)
                {
                    onesell += "0,";
                }
                else
                {
                    onesell += Math.Round(mylist.Sum(o => o.SiteOrderPay) / mylist.Sum(o => o.SiteBuyCustomTotal), 2).ToString() + ",";
                }
            }
        }

        SeriseText = SeriseText.Substring(0, SeriseText.Length - 1) + "]}";
        onesell    = onesell.Substring(0, onesell.Length - 1) + "]}";
        SeriseText = SeriseText + onesell + sucss.Substring(0, sucss.Length - 1) + "]}]";

        DateText      = DateText.Substring(0, DateText.Length - 1);
        DateText     += "]";
        TB_Start.Text = start.ToString("yyyy-MM-dd");
        TB_End.Text   = end.ToString("yyyy-MM-dd");
    }
Exemplo n.º 3
0
    protected void Btn_Month_Click(object sender, EventArgs e)
    {
        SiteTotalService         stDal = new SiteTotalService();
        IList <TopSiteTotalInfo> list  = stDal.GetMonthOrderTotalInfoList(HttpUtility.UrlDecode(Request.Cookies["nick"].Value), DateTime.Now.Year.ToString());

        SeriseText = "[{name:'订单量', data:[";
        string orderPay = ",{name:'订单金额',data:[";

        DateText = "[";
        for (int i = 1; i <= DateTime.Now.Month; i++)
        {
            DateText += "'" + i + "',";
            bool notfind = true;
            foreach (TopSiteTotalInfo info in list)
            {
                if (info.SiteTotalDate.Substring(4, 1) == "0")
                {
                    if (i.ToString() == info.SiteTotalDate.Substring(5))
                    {
                        SeriseText += info.SiteOrderCount + ",";
                        orderPay   += info.SiteOrderPay + ",";
                        notfind     = false;
                        break;
                    }
                }
                else
                {
                    if (i.ToString() == info.SiteTotalDate.Substring(4))
                    {
                        SeriseText += info.SiteOrderCount + ",";
                        orderPay   += info.SiteOrderPay + ",";
                        notfind     = false;
                        break;
                    }
                }
            }
            if (notfind)
            {
                orderPay   += "0,";
                SeriseText += "0,";
            }
        }

        SeriseText  = SeriseText.Substring(0, SeriseText.Length - 1);
        SeriseText += "]}";
        orderPay    = orderPay.Substring(0, orderPay.Length - 1);
        orderPay   += "]}";
        SeriseText += orderPay + "]";

        DateText  = DateText.Substring(0, DateText.Length - 1);
        DateText += "]";
    }
Exemplo n.º 4
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            DateTime now = DateTime.Parse(DateTime.Now.ToShortDateString());

            string nickNo = HttpUtility.UrlDecode(Request.Cookies["nick"].Value);
            IList <TopSiteTotalInfo> siteTotalList = new SiteTotalService().GetNickOrderTotal(now.AddDays(-10), now.AddDays(-1), nickNo);
            InsertTongbi(siteTotalList);
            Rpt_TotalList.DataSource = siteTotalList;
            Rpt_TotalList.DataBind();
        }
    }
    private void ShowChart(DateTime start, DateTime end)
    {
        //两个时间差
        if (start > end)
        {
            Page.RegisterStartupScript("error", "<script>alert('时间选择有误!');</script>");
            return;
        }

        string nick = HttpUtility.UrlDecode(Request.Cookies["nick"].Value);
        IList <TopKefuTotalInfo> list   = new TopKefuTotalService().GetKefuTotalDay(start, end, nick);
        IList <TopSiteTotalInfo> stlist = new SiteTotalService().GetNickOrderTotal(start, end, nick);

        SeriseText = "[{name:'询单数', data:[";
        string sucss = ",{name:'成功下单数', data:[";

        DateText = "[";

        for (DateTime i = start; i <= end; i = i.AddDays(1))
        {
            DateText += "'" + i.ToString("yyyyMMdd").Substring(6, 2) + "',";
            IList <TopKefuTotalInfo> mylist = list.Where(o => o.NickDate == i.ToString("yyyyMMdd")).ToList();
            if (mylist.Count == 0)
            {
                SeriseText += "0,";
                sucss      += "0,";
            }
            else
            {
                List <TopSiteTotalInfo> mystlist = stlist.Where(o => o.SiteTotalDate == i.ToString("yyyyMMdd")).ToList();
                if (mylist.Count == 0)
                {
                    SeriseText += "0,";
                }
                else
                {
                    SeriseText += mystlist[0].AskOrder + ",";
                }
                sucss += mylist.Sum(o => o.OrderCount) + ",";
            }
        }

        SeriseText = SeriseText.Substring(0, SeriseText.Length - 1) + "]}";
        SeriseText = SeriseText + sucss.Substring(0, sucss.Length - 1) + "]}]";

        DateText      = DateText.Substring(0, DateText.Length - 1);
        DateText     += "]";
        TB_Start.Text = start.ToString("yyyy-MM-dd");
        TB_End.Text   = end.ToString("yyyy-MM-dd");
    }
Exemplo n.º 6
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (Request.Cookies["nick"] == null || string.IsNullOrEmpty(Request.Cookies["nick"].Value))
            {
                Response.Write("false");
                Response.End();
                return;
            }
            string nick    = HttpUtility.UrlDecode(Request.Cookies["nick"].Value);
            string session = Request.Cookies["nicksession"].Value;

            if (CacheCollection.GetNickSessionList().Where(o => o.Nick == nick).ToList().Count > 0)
            {
                //try
                //{
                DateTime now = DateTime.Now;
                DataHelper.InsertGoodsOrder(DateTime.Parse(now.AddDays(-7).ToShortDateString()), now, session, nick);
                //获取聊天记录
                DateTime start = DataHelper.GetTalkContent(nick, session, now);

                //添加统计数据
                SiteTotalService taoDal = new SiteTotalService();
                for (DateTime i = DateTime.Parse(now.AddDays(-7).ToShortDateString()); i <= now; i = i.AddDays(1))
                {
                    DataHelper.UpdateSiteTotal(nick, session, i, taoDal);
                }

                //添加客服绩效统计
                DataHelper.GetKfjxTotal(nick, start, now);
                //}
                //catch (Exception ex)
                //{
                //    LogInfo.WriteLog("出错了", ex.Message);
                //}

                Response.Write("true");
                Response.End();
            }
            else
            {
                Response.Write("false");
                Response.End();
            }
        }
    }
Exemplo n.º 7
0
    private void ShowChart(DateTime start, DateTime end)
    {
        //两个时间差
        if (start > end)
        {
            Page.RegisterStartupScript("error", "<script>alert('时间选择有误!');</script>");
            return;
        }
        SiteTotalService         stDal = new SiteTotalService();
        IList <TopSiteTotalInfo> list  = stDal.GetNickOrderTotal(start, end, HttpUtility.UrlDecode(Request.Cookies["nick"].Value));

        SeriseText = "[{name:'PV量', data:[";
        string uvtotal   = ",{name:'UV量',data:[";
        string backtotal = ",{name:'浏览回头客',data:[";

        DateText = "[";
        for (DateTime i = start; i <= end; i = i.AddDays(1))
        {
            DateText += "'" + i.ToString("yyyyMMdd").Substring(6, 2) + "',";
            IList <TopSiteTotalInfo> mylist = list.Where(o => o.SiteTotalDate == i.ToString("yyyyMMdd")).ToList();

            if (mylist.Count > 0)
            {
                SeriseText += mylist[0].SitePVCount + ",";
                uvtotal    += mylist[0].SiteUVCount + ",";
                backtotal  += mylist[0].SiteUVBack + ",";
            }
            else
            {
                uvtotal    += "0,";
                SeriseText += "0,";
                backtotal  += "0,";
            }
        }
        SeriseText  = SeriseText.Substring(0, SeriseText.Length - 1);
        SeriseText += "]}";
        uvtotal     = uvtotal.Substring(0, uvtotal.Length - 1);
        uvtotal    += "]}";
        backtotal   = uvtotal + backtotal.Substring(0, backtotal.Length - 1);
        SeriseText += backtotal + "]}]";

        DateText      = DateText.Substring(0, DateText.Length - 1);
        DateText     += "]";
        TB_Start.Text = start.ToShortDateString();
        TB_End.Text   = end.ToShortDateString();
    }
Exemplo n.º 8
0
    private void BindRpt_OrderTotal(SiteTotalService siteTotalDal)
    {
        string nickNo = HttpUtility.UrlDecode(Request.Cookies["nick"].Value);
        List <TopSiteTotalInfo> list  = new List <TopSiteTotalInfo>();
        TopSiteTotalInfo        today = siteTotalDal.GetOrderTotalInfo(DateTime.Now, DateTime.Now, nickNo);

        today.SiteNick = "今天";

        TopSiteTotalInfo yesterday = siteTotalDal.GetOrderTotalInfo(DateTime.Now.AddDays(-1), DateTime.Now.AddDays(-1), nickNo);

        yesterday.SiteNick = "昨天";

        list.Add(today);
        list.Add(yesterday);

        Rpt_OrderTotal.DataSource = list;
        Rpt_OrderTotal.DataBind();
    }
Exemplo n.º 9
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (Request.Cookies["nick"] == null || string.IsNullOrEmpty(Request.Cookies["nick"].Value))
            {
                Response.Write("false");
                Response.End();
                return;
            }
            string nick    = HttpUtility.UrlDecode(Request.Cookies["nick"].Value);
            string session = Request.Cookies["nicksession"].Value;
            //"610062491512599df1afc0664ee3a7041eb4f8d0b200134204200856";//测试

            if (CacheCollection.GetNickSessionList().Where(o => o.Nick == nick).ToList().Count > 0)
            {
                DateTime now = DateTime.Now;
                DataHelper.InsertGoodsOrder(DateTime.Parse(now.AddDays(-7).ToShortDateString()), now, session, nick);
                //获取聊天记录
                DateTime start = DataHelper.GetTalkContent(nick, session, now);

                //添加统计数据
                SiteTotalService taoDal = new SiteTotalService();
                for (DateTime i = DateTime.Parse(now.AddDays(-7).ToShortDateString()); i <= now; i = i.AddDays(1))
                {
                    DataHelper.UpdateSiteTotal(nick, session, i, taoDal);
                }

                //添加客服绩效统计
                DataHelper.GetKfjxTotal(nick, start, now);

                Response.Write("true");
                Response.End();
            }
            else
            {
                Response.Write("false");
                Response.End();
            }
        }
    }
Exemplo n.º 10
0
    private void ShowChart(DateTime start, DateTime end)
    {
        //两个时间差
        if (start > end)
        {
            Page.RegisterStartupScript("error", "<script>alert('时间选择有误!');</script>");
            return;
        }

        string nick = HttpUtility.UrlDecode(Request.Cookies["nick"].Value);
        List <TopSiteTotalInfo> list = new SiteTotalService().GetZuanZhanTotal(start.ToString("yyyyMMdd"), end.ToString("yyyyMMdd"), nick);

        SeriseText = "[{name:'钻展流量', data:[";
        DateText   = "[";

        for (DateTime i = start; i <= end; i = i.AddDays(1))
        {
            DateText += "'" + i.ToString("yyyyMMdd").Substring(6, 2) + "',";
            IList <TopSiteTotalInfo> mylist = list.Where(o => o.SiteTotalDate == i.ToString("yyyyMMdd")).ToList();
            if (mylist.Count == 0)
            {
                SeriseText += "0,";
            }
            else
            {
                SeriseText += mylist[0].SiteZuanZhan + ",";
            }
        }

        SeriseText = SeriseText.Substring(0, SeriseText.Length - 1) + "]}]";

        DateText      = DateText.Substring(0, DateText.Length - 1);
        DateText     += "]";
        TB_Start.Text = start.ToString("yyyy-MM-dd");
        TB_End.Text   = end.ToString("yyyy-MM-dd");
    }
Exemplo n.º 11
0
    public static void UpdateSiteTotal(string nick, string session, DateTime now, SiteTotalService taoDal)
    {
        RefundService           refDal  = new RefundService();
        TaoBaoGoodsOrderService tbgoDal = new TaoBaoGoodsOrderService();

        List <RefundInfo> refundList = (List <RefundInfo>)TaoBaoAPI.GetRefundInfoList(now.AddDays(-2), now, nick, session, "SUCCESS");
        //所有有订单的用户
        TopSiteTotalInfo stinfo = taoDal.GetOrderTotalPay(DateTime.Parse(now.ToShortDateString()), DateTime.Parse(now.AddDays(1).ToShortDateString()), nick);
        //所有表名(添加过统计代码到网页的)
        List <string> tableList   = taoDal.GetTableName();
        string        tablename   = GetTableName(nick);
        List <string> mytablelist = tableList.Where(o => o == tablename).ToList();

        TopSiteTotalInfo addup = new TopSiteTotalInfo();

        addup.SiteNick      = nick;
        addup.SiteTotalDate = now.ToString("yyyyMMdd");
        //给询单数赋值
        addup.AskOrder = new TalkRecodService().GetCustomerList(DateTime.Parse(now.ToShortDateString()), DateTime.Parse(now.AddDays(1).ToShortDateString()), nick).Count;

        //有添加统计代码
        if (mytablelist.Count > 0)
        {
            //有订单
            if (stinfo != null)
            {
                addup.SiteOrderCount     = stinfo.SiteOrderCount;
                addup.SiteOrderPay       = stinfo.SiteOrderPay;
                addup.PostFee            = stinfo.PostFee;
                addup.SiteBuyCustomTotal = stinfo.SiteBuyCustomTotal;
                addup.SiteSecondBuy      = taoDal.GetSecondBuyTotal(DateTime.Parse(now.ToShortDateString()), DateTime.Parse(now.AddDays(1).ToShortDateString()), nick);
            }
            TopSiteTotalInfo puvinfo = taoDal.GetPvUvTotal(DateTime.Parse(now.ToShortDateString()), DateTime.Parse(now.AddDays(1).ToShortDateString()), tablename);
            addup.SiteUVCount  = puvinfo.SiteUVCount;
            addup.SitePVCount  = puvinfo.SitePVCount;
            addup.ZhiTongFlow  = taoDal.GetZhiTongTotal(now, now.AddDays(1), tablename);
            addup.SiteZuanZhan = taoDal.GetZuanZhanTotal(now, now.AddDays(1), tablename);

            addup.SiteUVBack = taoDal.GetBackTotal(DateTime.Parse(now.ToShortDateString()), DateTime.Parse(now.AddDays(1).ToShortDateString()), tablename);
        }
        else
        {
            //有订单
            if (stinfo != null)
            {
                addup.SiteOrderCount     = stinfo.SiteOrderCount;
                addup.SiteOrderPay       = stinfo.SiteOrderPay;
                addup.PostFee            = stinfo.PostFee;
                addup.SiteBuyCustomTotal = stinfo.SiteBuyCustomTotal;
                addup.SiteSecondBuy      = taoDal.GetSecondBuyTotal(DateTime.Parse(now.ToShortDateString()), DateTime.Parse(now.AddDays(1).ToShortDateString()), nick);
            }
        }

        IList <string> tidList = taoDal.GetOrderIds(DateTime.Parse(now.ToShortDateString()), DateTime.Parse(now.AddDays(1).ToShortDateString()), nick);

        if (tidList.Count > 0)
        {
            addup.GoodsCount = taoDal.GetGoodsCount(tidList);
        }
        List <RefundInfo> hadReList = refDal.GetAllRefund(nick, now.AddDays(-2), now);

        //退款情况
        List <RefundInfo> trefundList = refundList.Where(o => o.modified.ToShortDateString() == now.ToShortDateString()).ToList();

        if (trefundList.Count > 0)
        {
            int     rorderCount = 0;
            decimal rpay        = 0;
            foreach (RefundInfo refund in new List <RefundInfo>(trefundList))
            {
                if (!tidList.Contains(refund.tid))
                {
                    GoodsOrderInfo roinfo = tbgoDal.GetGoodsOrderInfo(refund.tid);
                    if (roinfo == null)
                    {
                        continue;
                    }
                    else
                    {
                        if (hadReList.Where(o => o.tid == refund.tid).ToList().Count > 0)
                        {
                            continue;
                        }
                        if (roinfo.pay_time != DateTime.Parse("1990-1-1"))
                        {
                            refund.OrderTime = roinfo.pay_time;
                        }
                        else
                        {
                            refund.OrderTime = roinfo.created;
                        }
                        refund.seller_nick = nick;
                        refDal.AddRefund(refund);
                        //需要查询这一天有多少订单
                        RefundInfo newrefund = refDal.GetRefundTotal(nick, DateTime.Parse(refund.OrderTime.ToShortDateString()), DateTime.Parse(refund.OrderTime.ToShortDateString()).AddDays(1));

                        taoDal.UpdateGoodsOrderInfo(nick, refund.OrderTime.ToString("yyyyMMdd"), newrefund.total_fee, newrefund.num);
                    }
                    continue;
                }
                rorderCount++;
                rpay += (refund.total_fee - refund.payment);
            }
            addup.RefundOrderCount = rorderCount;
            addup.RefundMoney      = rpay;
        }

        taoDal.AddOrUp(addup);
    }
Exemplo n.º 12
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (Request.Cookies["nick"] == null)
            {
                System.Threading.Thread.Sleep(1000 * 6);
            }
            string       nickNo    = DataHelper.Encrypt(HttpUtility.UrlDecode(Request.Cookies["nick"].Value));
            VisitService vistitDal = new VisitService();
            DateTime[]   darray    = DataHelper.GetDateTime(DateTime.Now, 1);
            Rpt_IpPV.DataSource = vistitDal.GetIndexTotalInfoList(nickNo, darray[0], darray[1]).OrderByDescending(o => o.Value).ToList();
            Rpt_IpPV.DataBind();

            Rpt_OnlineCustomer.DataSource = vistitDal.GetIndexOnlineCustomer(nickNo, 3, darray[0], darray[1]);
            Rpt_OnlineCustomer.DataBind();

            TaoBaoGoodsServive taoGoodsService = new TaoBaoGoodsServive();

            IList <GoodsInfo> list = taoGoodsService.GetTopBuyGoods(HttpUtility.UrlDecode(Request.Cookies["nick"].Value), darray[0], darray[1], 1, 3);

            if (list.Count > 0)
            {
                string           pids       = "";
                List <GoodsInfo> cachegoods = new List <GoodsInfo>();
                if (Cache["taobaogoodslist"] != null)
                {
                    cachegoods = (List <GoodsInfo>)Cache["taobaogoodslist"];
                }
                foreach (GoodsInfo info in list)
                {
                    if (!cachegoods.Contains(info))
                    {
                        pids += info.num_iid + ",";
                    }
                }

                if (pids != "")
                {
                    List <GoodsInfo> goodsinfoList = TaoBaoAPI.GetGoodsInfoList(HttpUtility.UrlDecode(Request.Cookies["nick"].Value), Request.Cookies["nicksession"].Value, pids.Substring(0, pids.Length - 1));

                    if (Cache["taobaogoodslist"] == null)
                    {
                        Cache.Insert("taobaogoodslist", goodsinfoList, null, DateTime.Now.AddHours(12), System.Web.Caching.Cache.NoSlidingExpiration);
                    }
                    else
                    {
                        cachegoods.AddRange(goodsinfoList);
                    }
                }
                for (int i = 0; i < list.Count; i++)
                {
                    IList <GoodsInfo> thislist = ((List <GoodsInfo>)Cache["taobaogoodslist"]).Where(o => o.num_iid == list[i].num_iid).ToList();
                    if (thislist.Count > 0)
                    {
                        list[i].title   = thislist[0].title;
                        list[i].price   = thislist[0].price;
                        list[i].pic_url = thislist[0].pic_url;
                    }
                }
            }

            Rpt_GoodsSellTop.DataSource = list;
            Rpt_GoodsSellTop.DataBind();

            SiteTotalService siteTotalDal = new SiteTotalService();
            BindRpt_OrderTotal(siteTotalDal);
            TopSiteTotalInfo lastweek  = siteTotalDal.GetOrderTotalInfo(DateTime.Now.AddDays(-7), DateTime.Now, HttpUtility.UrlDecode(Request.Cookies["nick"].Value));
            TopSiteTotalInfo llastweek = siteTotalDal.GetOrderTotalInfo(DateTime.Now.AddDays(-14), DateTime.Now.AddDays(-8), HttpUtility.UrlDecode(Request.Cookies["nick"].Value));
            ViewState["lastweek"]  = lastweek;
            ViewState["llastweek"] = llastweek;
        }
    }
Exemplo n.º 13
0
    public static void UpdateSiteTotal(string nick, string session, DateTime now, SiteTotalService taoDal)
    {
        List <RefundInfo> refundList = (List <RefundInfo>)TaoBaoAPI.GetRefundInfoList(now.AddDays(-2), now, nick, session, "SUCCESS");
        //所有有订单的用户
        TopSiteTotalInfo stinfo = taoDal.GetOrderTotalPay(DateTime.Parse(now.ToShortDateString()), DateTime.Parse(now.AddDays(1).ToShortDateString()), nick);
        //所有表名(添加过统计代码到网页的)
        //List<string> tableList = taoDal.GetTableName();
        //string tablename = GetTableName(nick);
        List <string> mytablelist = new List <string>();//tableList.Where(o => o == tablename).ToList();

        TopSiteTotalInfo addup = new TopSiteTotalInfo();

        addup.SiteNick      = nick;
        addup.SiteTotalDate = now.ToString("yyyyMMdd");
        //给询单数赋值
        addup.AskOrder = new TalkRecodService().GetCustomerList(DateTime.Parse(now.ToShortDateString()), DateTime.Parse(now.AddDays(1).ToShortDateString()), nick).Count;

        //有添加统计代码
        if (mytablelist.Count > 0)
        {
            //有订单
            if (stinfo != null)
            {
                addup.SiteOrderCount     = stinfo.SiteOrderCount;
                addup.SiteOrderPay       = stinfo.SiteOrderPay;
                addup.PostFee            = stinfo.PostFee;
                addup.SiteBuyCustomTotal = stinfo.SiteBuyCustomTotal;
                addup.SiteSecondBuy      = taoDal.GetSecondBuyTotal(DateTime.Parse(now.ToShortDateString()), DateTime.Parse(now.AddDays(1).ToShortDateString()), nick);
            }
            //TopSiteTotalInfo puvinfo = taoDal.GetPvUvTotal(DateTime.Parse(now.ToShortDateString()), DateTime.Parse(now.AddDays(1).ToShortDateString()), tablename);
            addup.SiteUVCount  = 0; //puvinfo.SiteUVCount;
            addup.SitePVCount  = 0; // puvinfo.SitePVCount;
            addup.ZhiTongFlow  = 0; // taoDal.GetZhiTongTotal(now, now.AddDays(1), tablename);
            addup.SiteZuanZhan = 0; // taoDal.GetZuanZhanTotal(now, now.AddDays(1), tablename);

            addup.SiteUVBack = 0;   // taoDal.GetBackTotal(DateTime.Parse(now.ToShortDateString()), DateTime.Parse(now.AddDays(1).ToShortDateString()), tablename);
        }
        else
        {
            //有订单
            if (stinfo != null)
            {
                addup.SiteOrderCount     = stinfo.SiteOrderCount;
                addup.SiteOrderPay       = stinfo.SiteOrderPay;
                addup.PostFee            = stinfo.PostFee;
                addup.SiteBuyCustomTotal = stinfo.SiteBuyCustomTotal;
                addup.SiteSecondBuy      = taoDal.GetSecondBuyTotal(DateTime.Parse(now.ToShortDateString()), DateTime.Parse(now.AddDays(1).ToShortDateString()), nick);
            }
        }

        IList <string> tidList = taoDal.GetOrderIds(DateTime.Parse(now.ToShortDateString()), DateTime.Parse(now.AddDays(1).ToShortDateString()), nick);

        if (tidList.Count > 0)
        {
            addup.GoodsCount = taoDal.GetGoodsCount(tidList);
        }

        //退款情况
        List <RefundInfo> trefundList = refundList.Where(o => o.modified.ToShortDateString() == now.ToShortDateString()).ToList();

        if (trefundList.Count > 0)
        {
            int     rorderCount = 0;
            decimal rpay        = 0;
            foreach (RefundInfo refund in trefundList)
            {
                if (!tidList.Contains(refund.tid))
                {
                    continue;
                }
                rorderCount++;
                rpay += (refund.total_fee - refund.payment);
            }
            addup.RefundOrderCount = rorderCount;
            addup.RefundMoney      = rpay;
        }

        taoDal.AddOrUp(addup);
    }