private void Bind(DateTime start, DateTime end, string nick,params int[] tid)
{
int TotalCount = 0;//总记录数
int TotalPage = 1; //总页数
int page = 1;
try
{
page = int.Parse(Request.QueryString["Page"]);
if (ViewState["page"] != null)
{
page = int.Parse(ViewState["page"].ToString());
ViewState["page"] = null;
}
}
catch { }
List<GoodsOrderInfo> goodsOrderList = goDal.GetCustomerList(nick, start, end);
IList<CustomerInfo> list = trDal.GetCustomerList(start, end, nick);
if (list.Count > 0)
{
for (int i = 0; i < list.Count; i++)
{
IList<GoodsOrderInfo> thislist = goodsOrderList.Where(o => o.buyer_nick == list[i].CustomerNick).ToList();
if (thislist.Count > 0)
{
list[i].tid = thislist[0].tid;
}
}
}
int suc = 0;
if (tid != null && tid.Length > 0)
{
list = list.Where(o => !string.IsNullOrEmpty(o.tid)).ToList();
suc = 1;
}
TotalCount = list.Count;
pds.DataSource = list;
pds.AllowPaging = true;
pds.PageSize = 20;
if (TotalCount == 0)
TotalPage = 1;
else
{
if (TotalCount % pds.PageSize == 0)
TotalPage = TotalCount / pds.PageSize;
else
TotalPage = TotalCount / pds.PageSize + 1;
}
pds.CurrentPageIndex = page - 1;
lblCurrentPage.Text = "共" + TotalCount.ToString() + "条记录 当前页：" + page + "/" + TotalPage;
lnkFrist.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=1" + "&start=" + start.ToShortDateString() + "&suc=" + suc;
if (!pds.IsFirstPage)
lnkPrev.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + (page - 1) + "&start=" + start.ToShortDateString() + "&suc=" + suc;
if (!pds.IsLastPage)
lnkNext.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + (page + 1) + "&start=" + start.ToShortDateString() + "&suc=" + suc;
lnkEnd.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + TotalPage + "&start=" + start.ToShortDateString() + "&suc=" + suc;
Rpt_CustomerList.DataSource = pds;
Rpt_CustomerList.DataBind();
TB_Start.Text = start.ToString("yyyy-MM-dd");
}
public static void GetKfjxTotal(string nick, DateTime start, DateTime now)
{
TalkRecodService trDal = new TalkRecodService();
GoodsService goodsDal = new GoodsService();
GoodsOrderService goDal = new GoodsOrderService();
TopKefuTotalService kfDal = new TopKefuTotalService();
//所有商品
List <TaoBaoAPIHelper.GoodsInfo> goodsNickList = goodsDal.GetAllGoods(nick);
for (DateTime h = start; h < now; h = h.AddDays(1))
{
//所有订单
List <TaoBaoAPIHelper.GoodsOrderInfo> orderList = goDal.GetGoodsOrderList(nick, h, h.AddDays(1));
//得到回复次数和接待人数
List <CustomerInfo> cuslist = trDal.GetReceiveList(nick, h, h.AddDays(1));
//得到接待人和购买者信息
IList <CustomerInfo> cusBuyList = trDal.GetCustomerList(h, h.AddDays(1), nick);
//得到客服未回复的客户数量
List <TopKefuTotalInfo> untalkList = trDal.GetUnTalkCustomerList(nick, h, h.AddDays(1));
for (int i = 0; i < cusBuyList.Count; i++)
{
IList <TaoBaoAPIHelper.GoodsOrderInfo> thislist = orderList.Where(o => o.buyer_nick == cusBuyList[i].CustomerNick).ToList();
if (thislist.Count > 0)
{
cusBuyList[i].tid = thislist[0].tid;
}
}
//得到成功下单
List <CustomerInfo> orderCusList = cusBuyList.Where(o => !string.IsNullOrEmpty(o.tid)).ToList();
foreach (CustomerInfo fromInfo in cuslist)
{
TopKefuTotalInfo kefutotalInfo = new TopKefuTotalInfo();
kefutotalInfo.CustomerCount = int.Parse(fromInfo.CustomerNick);
kefutotalInfo.ReceiveCount = fromInfo.TalkCount;
kefutotalInfo.Nick = fromInfo.FromNick;
kefutotalInfo.NickDate = h.ToString("yyyyMMdd");
//赋值未回复数量
if (untalkList.Where(o => o.Nick == fromInfo.FromNick).ToList().Count > 0)
{
kefutotalInfo.UnTalkCustomerCount = untalkList.Where(o => o.Nick == fromInfo.FromNick).ToList()[0].UnTalkCustomerCount;
}
List <CustomerInfo> mylist = orderCusList.Where(o => o.FromNick == fromInfo.FromNick).ToList();
if (mylist.Count > 0)
{
List <string> tids = new List <string>();
foreach (CustomerInfo inf in mylist)
{
tids.Add(inf.tid);
}
List <TaoBaoAPIHelper.GoodsOrderInfo> myolist = orderList.Where(o => tids.Contains(o.tid)).ToList();
kefutotalInfo.OrderCount = mylist.Count;
kefutotalInfo.PostFee = myolist.Sum(o => o.post_fee);
kefutotalInfo.Payment = myolist.Sum(o => o.payment);
List <TaoBaoAPIHelper.GoodsInfo> goodsList = goDal.GetGoodsCount(tids);
kefutotalInfo.GoodsCount = goodsList.Sum(o => o.Count);
decimal goodsPriceTotal = 0;
foreach (TaoBaoAPIHelper.GoodsInfo ginfo in goodsList)
{
List <TaoBaoAPIHelper.GoodsInfo> mygoodsList = goodsNickList.Where(o => o.num_iid == ginfo.num_iid).ToList();
if (mygoodsList.Count > 0)
{
goodsPriceTotal += mygoodsList[0].price * ginfo.Count;
}
else
{
TaoBaoAPIHelper.GoodsInfo newgoods = TaoBaoAPIHelper.TaoBaoAPI.GetGoodsInfoService(ginfo.num_iid);
if (newgoods != null)
{
goodsPriceTotal += newgoods.price * ginfo.Count;
//找到后添加到集合
goodsNickList.Add(newgoods);
}
}
}
kefutotalInfo.GoodsPay = goodsPriceTotal;
}
//添加或者更新
kfDal.AddOrUp(kefutotalInfo);
}
}
}
private void Bind(string nick, string session, DateTime start, DateTime end, int totalCount, int recordCount)
{
int TotalPage = totalCount % recordCount != 0 ? (totalCount / recordCount) + 1 : totalCount / recordCount; //总页数
int page = 1;
try
{
page = int.Parse(Request.QueryString["Page"]);
if (ViewState["page"] != null)
{
page = int.Parse(ViewState["page"].ToString());
ViewState["page"] = null;
}
}
catch { }
IList <GoodsOrderInfo> goodsOrderList = taoGoodsOrderService.GetOrderList(HttpUtility.UrlDecode(Request.Cookies["nick"].Value), start, end, page, recordCount);
IList <CustomerInfo> list = trDal.GetCustomerList(start, end, nick);
if (list.Count > 0)
{
for (int i = 0; i < goodsOrderList.Count; i++)
{
IList <CustomerInfo> thislist = list.Where(o => o.CustomerNick == goodsOrderList[i].buyer_nick).ToList();
if (thislist.Count > 0)
{
if (thislist[0].FromNick.IndexOf(":") > 0)
{
goodsOrderList[i].seller_nick = thislist[0].FromNick.Substring(thislist[0].FromNick.IndexOf(":") + 1);
}
else
{
goodsOrderList[i].seller_nick = thislist[0].FromNick;
}
}
else
{
}
}
}
lblCurrentPage.Text = "共" + totalCount.ToString() + "条记录 当前页：" + page + "/" + (TotalPage == 0 ? 1 : TotalPage);
lnkFrist.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=1&" + "start=" + start.ToShortDateString() + "&end=" + end.ToShortDateString();
if (page > 1)
{
lnkPrev.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(page - 1) + "&" + "start=" + start.ToShortDateString() + "&end=" + end.ToShortDateString();
}
if (page != TotalPage && TotalPage != 0)
{
lnkNext.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(page + 1) + "&" + "start=" + start.ToShortDateString() + "&end=" + end.ToShortDateString();
}
lnkEnd.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + (TotalPage == 0 ? 1 : TotalPage) + "&" + "start=" + start.ToShortDateString() + "&end=" + end.ToShortDateString();
Rpt_PageVisit.DataSource = goodsOrderList;
Rpt_PageVisit.DataBind();
TB_Start.Text = start.ToString("yyyy-MM-dd");
TB_End.Text = end.ToString("yyyy-MM-dd");
}
private void Bind(DateTime start, DateTime end, string nick, params int[] tid)
{
int TotalCount = 0; //总记录数
int TotalPage = 1; //总页数
int page = 1;
try
{
page = int.Parse(Request.QueryString["Page"]);
if (ViewState["page"] != null)
{
page = int.Parse(ViewState["page"].ToString());
ViewState["page"] = null;
}
}
catch { }
List <GoodsOrderInfo> goodsOrderList = goDal.GetCustomerList(nick, start, end);
IList <CustomerInfo> list = trDal.GetCustomerList(start, end, nick);
if (list.Count > 0)
{
for (int i = 0; i < list.Count; i++)
{
IList <GoodsOrderInfo> thislist = goodsOrderList.Where(o => o.buyer_nick == list[i].CustomerNick).ToList();
if (thislist.Count > 0)
{
list[i].tid = thislist[0].tid;
}
}
}
if (tid != null && tid.Length > 0)
{
list = list.Where(o => !string.IsNullOrEmpty(o.tid)).ToList();
}
TotalCount = list.Count;
pds.DataSource = list;
pds.AllowPaging = true;
pds.PageSize = 10;
if (TotalCount == 0)
{
TotalPage = 1;
}
else
{
if (TotalCount % pds.PageSize == 0)
{
TotalPage = TotalCount / pds.PageSize;
}
else
{
TotalPage = TotalCount / pds.PageSize + 1;
}
}
pds.CurrentPageIndex = page - 1;
Rpt_Jie.DataSource = pds;
Rpt_Jie.DataBind();
}