private void ShowChart(DateTime start, DateTime end)
{
//两个时间差
if (start > end)
{
Page.RegisterStartupScript("error", "<script>alert('时间选择有误!');</script>");
return;
}
TaoBaoGoodsOrderService orderDal = new TaoBaoGoodsOrderService();
IList <BackTotalInfo> list = orderDal.GetAllBackTotalList(start, end, HttpUtility.UrlDecode(Request.Cookies["nick"].Value));
SeriseText = "[{name:'完成订单量', data:[";
string iptotal = ",{name:'回头客数量',data:[";
string avg = ",{name:'回头客占比',data:[";
DateText = "[";
for (DateTime i = start; i <= end; i = i.AddDays(1))
{
DateText += "'" + i.ToString("yyyyMMdd").Substring(6, 2) + "',";
IList <BackTotalInfo> mylist = list.Where(o => o.PDate == i.ToString("yyyyMMdd")).ToList();
if (mylist.Count > 0)
{
BackTotalInfo info = mylist[0];
iptotal += info.PCount + ",";
SeriseText += info.AllCount + ",";
if (info.AllCount == 0)
{
avg += "0,";
}
else
{
avg += ((double)info.PCount / info.AllCount).ToString(".00") + ",";
}
}
else
{
iptotal += "0,";
SeriseText += "0,";
avg += "0,";
}
}
SeriseText = SeriseText.Substring(0, SeriseText.Length - 1);
SeriseText += "]}";
iptotal = iptotal.Substring(0, iptotal.Length - 1);
iptotal += "]}";
avg = iptotal + avg.Substring(0, avg.Length - 1);
SeriseText += avg + "]}]";
DateText = DateText.Substring(0, DateText.Length - 1);
DateText += "]";
TB_Start.Text = start.ToShortDateString();
TB_End.Text = end.ToShortDateString();
}
public static void InsertGoodsOrder(DateTime start, DateTime end, string session, string nick)
{
TaoBaoGoodsOrderService tbgo = new TaoBaoGoodsOrderService();
List <string> allOrderTid = tbgo.GetAllOrderId(start, end, nick);
//等待卖家发货,即:买家已付款
InsertGoodsOrderByState(start, end, "WAIT_SELLER_SEND_GOODS", session, nick, tbgo, allOrderTid);
//等待买家确认收货,即:卖家已发货
InsertGoodsOrderByState(start, end, "WAIT_BUYER_CONFIRM_GOODS", session, nick, tbgo, allOrderTid);
//买家已签收,货到付款专用
InsertGoodsOrderByState(start, end, "TRADE_BUYER_SIGNED", session, nick, tbgo, allOrderTid);
//交易成功
InsertGoodsOrderByState(start, end, "TRADE_FINISHED", session, nick, tbgo, allOrderTid);
}
private void ShowChart(DateTime date)
{
if (date.ToShortDateString() != DateTime.Now.ToShortDateString())
{
Btn_Totay.Visible = true;
}
//大于今天
if (DateTime.Parse(date.ToShortDateString()) > DateTime.Parse(DateTime.Now.ToShortDateString()))
{
TB_Start.Text = HF_Date.Value;
return;
}
TaoBaoGoodsOrderService orderDal = new TaoBaoGoodsOrderService();
IList <GoodsOrderInfo> list = orderDal.GetHourOrderTotal(DateTime.Parse(date.ToShortDateString()), DateTime.Parse(date.AddDays(1).ToShortDateString()), HttpUtility.UrlDecode(Request.Cookies["nick"].Value));
SeriseText = "[{name:'订单量', data:[";
DateText = "[";
int nowhour = 23;
if (date.ToShortDateString() == DateTime.Now.ToShortDateString())
{
nowhour = date.Hour;
}
for (int h = 0; h <= nowhour; h++)
{
DateText += "'" + h + "',";
IList <GoodsOrderInfo> thisInfo = list.Where(o => o.OrderTotal == h).ToList();
if (thisInfo.Count == 0)
{
SeriseText += "0,";
}
else
{
SeriseText += (int)thisInfo[0].payment + ",";
}
}
SeriseText = SeriseText.Substring(0, SeriseText.Length - 1);
SeriseText += "]}]";
DateText = DateText.Substring(0, DateText.Length - 1);
DateText += "]";
TB_Start.Text = date.ToShortDateString();
HF_Date.Value = date.ToShortDateString();
}
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);
}
private static void InsertGoodsOrderByState(DateTime start, DateTime end, string orderState, string session, string nick, TaoBaoGoodsOrderService tbgoDal, List <string> tids)
{
IList <GoodsOrderInfo> goodsOrderList = TaoBaoAPI.GetGoodsOrderInfoList(nick, start, end, session, orderState);
if (goodsOrderList == null)
{
LogInfo.WriteLog("订购时获取订单错误", "参数错误");
}
else
{
for (int i = 0; i < goodsOrderList.Count; i++)
{
//判断是否已经添加
if (tids.Contains(goodsOrderList[i].tid))
{
continue;
}
goodsOrderList[i].UsePromotion = TaoBaoAPI.GetPromotion(nick, session, goodsOrderList[i].tid, "店铺优惠券");
goodsOrderList[i].PingInfo = TaoBaoAPI.GetPingjia(nick, session, goodsOrderList[i].tid);
if (goodsOrderList[i].PingInfo == null)
{
goodsOrderList[i].PingInfo = new PingJiaInfo
{
content = "",
created = DateTime.Parse("1990-1-1"),
result = ""
};
}
tbgoDal.InsertTaoBaoGoodsOrder(goodsOrderList[i]);
tbgoDal.InsertChildOrderInfo(goodsOrderList[i].orders, goodsOrderList[i].tid);
//添加进集合
tids.Add(goodsOrderList[i].tid);
}
}
}
private void ShowChart(DateTime start, DateTime end)
{
//两个时间差
if (start > end)
{
Page.RegisterStartupScript("error", "<script>alert('时间选择有误!');</script>");
return;
}
TaoBaoGoodsOrderService tboDal = new TaoBaoGoodsOrderService();
IList <PingJiaInfo> list = tboDal.GetPingjiaTotal(start, end, HttpUtility.UrlDecode(Request.Cookies["nick"].Value));
SeriseText = "[{name:'好评', data:[";
string zhong = ",{name:'中评',data:[";
string cha = ",{name:'差评',data:[";
string nop = ",{name:'尚未评价',data:[";
DateText = "[";
for (DateTime i = start; i <= end; i = i.AddDays(1))
{
DateText += "'" + i.ToString("yyyyMMdd").Substring(6, 2) + "',";
IList <PingJiaInfo> mylist = list.Where(o => o.pdate == i.ToString("yyyyMMdd")).ToList();
if (mylist.Count > 0)
{
if (mylist.Where(o => o.result == "good").ToList().Count > 0)
{
SeriseText += mylist.Where(o => o.result == "good").ToList()[0].pcount + ",";
}
else
{
SeriseText += "0,";
}
if (mylist.Where(o => o.result == "neutral").ToList().Count > 0)
{
zhong += mylist.Where(o => o.result == "neutral").ToList()[0].pcount + ",";
}
else
{
zhong += "0,";
}
if (mylist.Where(o => o.result == "bad").ToList().Count > 0)
{
cha += mylist.Where(o => o.result == "bad").ToList()[0].pcount + ",";
}
else
{
cha += "0,";
}
if (mylist.Where(o => o.result == "").ToList().Count > 0)
{
nop += mylist.Where(o => o.result == "").ToList()[0].pcount + ",";
}
else
{
nop += "0,";
}
}
else
{
zhong += "0,";
SeriseText += "0,";
cha += "0,";
nop += "0,";
}
}
SeriseText = SeriseText.Substring(0, SeriseText.Length - 1);
SeriseText += "]}";
zhong = zhong.Substring(0, zhong.Length - 1);
zhong += "]}";
cha = zhong + cha.Substring(0, cha.Length - 1);
cha += "]}";
nop = cha + nop.Substring(0, nop.Length - 1);
SeriseText += nop + "]}]";
DateText = DateText.Substring(0, DateText.Length - 1);
DateText += "]";
TB_Start.Text = start.ToString("yyyy-MM-dd");
TB_End.Text = end.ToString("yyyy-MM-dd");
}
