protected override void AttachChildControls()
{
this.vshoporders = (VshopTemplatedRepeater) this.FindControl("vshoporders");
this.litfinishnum = (Literal) this.FindControl("litfinishnum");
this.litallnum = (Literal) this.FindControl("litallnum");
int result = 0;
int.TryParse(HttpContext.Current.Request.QueryString.Get("status"), out result);
OrderQuery query = new OrderQuery {
UserId = new int?(Globals.GetCurrentMemberUserId())
};
if (result != 5)
{
query.Status = OrderStatus.Finished;
this.litfinishnum.Text = DistributorsBrower.GetDistributorOrderCount(query).ToString();
query.Status = OrderStatus.All;
this.litallnum.Text = DistributorsBrower.GetDistributorOrderCount(query).ToString();
}
else
{
this.litallnum.Text = DistributorsBrower.GetDistributorOrderCount(query).ToString();
query.Status = OrderStatus.Finished;
this.litfinishnum.Text = DistributorsBrower.GetDistributorOrderCount(query).ToString();
}
this.vshoporders.DataSource = DistributorsBrower.GetDistributorOrder(query);
this.vshoporders.DataBind();
}
protected override void AttachChildControls()
{
PageTitle.AddSiteNameTitle("会员中心");
MemberInfo currentMember = MemberProcessor.GetCurrentMember();
if (currentMember != null)
{
this.litUserName = (Literal) this.FindControl("litUserName");
this.litExpenditure = (Literal) this.FindControl("litExpenditure");
this.litExpenditure.SetWhenIsNotNull(currentMember.Expenditure.ToString("F2"));
this.litMemberGrade = (Literal) this.FindControl("litMemberGrade");
MemberGradeInfo memberGrade = MemberProcessor.GetMemberGrade(currentMember.GradeId);
if (memberGrade != null)
{
this.litMemberGrade.SetWhenIsNotNull(memberGrade.Name);
}
this.litUserName.Text = string.IsNullOrEmpty(currentMember.RealName) ? currentMember.UserName : currentMember.RealName;
this.Page.Session["stylestatus"] = "1";
this.litWaitForRecieveCount = (Literal) this.FindControl("litWaitForRecieveCount");
this.litWaitForPayCount = (Literal) this.FindControl("litWaitForPayCount");
OrderQuery query = new OrderQuery {
Status = OrderStatus.WaitBuyerPay
};
int userOrderCount = MemberProcessor.GetUserOrderCount(Globals.GetCurrentMemberUserId(), query);
this.litWaitForPayCount.SetWhenIsNotNull(userOrderCount.ToString());
query.Status = OrderStatus.SellerAlreadySent;
this.litWaitForRecieveCount.SetWhenIsNotNull(MemberProcessor.GetUserOrderCount(Globals.GetCurrentMemberUserId(), query).ToString());
}
}
private void BindUserOrderStatistics()
{
OrderQuery userOrder = new OrderQuery {
UserName = this.userName,
ShipTo = this.shipTo,
StartDate = this.dateStart,
EndDate = this.dateEnd,
OrderId = this.orderId,
PageSize = this.pager.PageSize,
PageIndex = this.pager.PageIndex,
SortBy = "OrderDate",
SortOrder = SortAction.Desc
};
OrderStatisticsInfo userOrders = SalesHelper.GetUserOrders(userOrder);
this.rp_orderStatistics.DataSource = userOrders.OrderTbl;
this.rp_orderStatistics.DataBind();
this.pager.TotalRecords = userOrders.TotalCount;
this.lblPageCount.Text = string.Format("当前页共计<span class=\"colorG\">{0}</span>个 <span style=\"padding-left:10px;\">订单金额共计</span><span class=\"colorG\">{1}</span>元 <span style=\"padding-left:10px;\">订单毛利润共计</span><span class=\"colorG\">{2}</span>元 ", userOrders.OrderTbl.Rows.Count, Globals.FormatMoney(userOrders.TotalOfPage), Globals.FormatMoney(userOrders.ProfitsOfPage));
this.lblSearchCount.Text = string.Format("当前查询结果共计<span class=\"colorG\">{0}</span>个 <span style=\"padding-left:10px;\">订单金额共计</span><span class=\"colorG\">{1}</span>元 <span style=\"padding-left:10px;\">订单毛利润共计</span><span class=\"colorG\">{2}</span>元 ", userOrders.TotalCount, Globals.FormatMoney(userOrders.TotalOfSearch), Globals.FormatMoney(userOrders.ProfitsOfSearch));
}
protected override void AttachChildControls()
{
PageTitle.AddSiteNameTitle("会员订单");
int result = 0;
int.TryParse(HttpContext.Current.Request.QueryString.Get("status"), out result);
OrderQuery query = new OrderQuery();
switch (result)
{
case 1:
query.Status = OrderStatus.WaitBuyerPay;
break;
case 3:
query.Status = OrderStatus.SellerAlreadySent;
break;
}
this.rptOrders = (VshopTemplatedRepeater) this.FindControl("rptOrders");
this.rptOrders.DataSource = MemberProcessor.GetUserOrder(Globals.GetCurrentMemberUserId(), query);
this.rptOrders.DataBind();
}
public int GetUserOrderCount(int userId, OrderQuery query)
{
string str = string.Empty;
if (query.Status == OrderStatus.WaitBuyerPay)
{
str = str + " AND OrderStatus = 1 AND Gateway <> 'hishop.plugins.payment.podrequest'";
}
else if (query.Status == OrderStatus.SellerAlreadySent)
{
str = str + " AND (OrderStatus = 2 OR OrderStatus = 3 OR (OrderStatus = 1 AND Gateway = 'hishop.plugins.payment.podrequest'))";
}
string str2 = "SELECT COUNT(1) FROM Hishop_Orders o WHERE UserId = @UserId";
str2 = str2 + str;
DbCommand sqlStringCommand = this.database.GetSqlStringCommand(str2);
sqlStringCommand.CommandType = CommandType.Text;
this.database.AddInParameter(sqlStringCommand, "UserId", DbType.Int32, userId);
return (int) this.database.ExecuteScalar(sqlStringCommand);
}
public DataSet GetUserOrder(int userId, OrderQuery query)
{
string str = string.Empty;
if (query.Status == OrderStatus.WaitBuyerPay)
{
str = str + " AND OrderStatus = 1 AND Gateway <> 'hishop.plugins.payment.podrequest'";
}
else if (query.Status == OrderStatus.SellerAlreadySent)
{
str = str + " AND (OrderStatus = 2 OR OrderStatus = 3 OR (OrderStatus = 1 AND Gateway = 'hishop.plugins.payment.podrequest'))";
}
string str2 = "SELECT OrderId, OrderDate, OrderStatus,PaymentTypeId, OrderTotal, (SELECT SUM(Quantity) FROM Hishop_OrderItems WHERE OrderId = o.OrderId) as ProductSum FROM Hishop_Orders o WHERE UserId = @UserId";
str2 = (str2 + str + " ORDER BY OrderDate DESC") + " SELECT OrderId, ThumbnailsUrl, ItemDescription, SKUContent, SKU, ProductId FROM Hishop_OrderItems WHERE OrderId IN (SELECT OrderId FROM Hishop_Orders WHERE UserId = @UserId" + str + ")";
DbCommand sqlStringCommand = this.database.GetSqlStringCommand(str2);
this.database.AddInParameter(sqlStringCommand, "UserId", DbType.Int32, userId);
DataSet set = this.database.ExecuteDataSet(sqlStringCommand);
DataColumn parentColumn = set.Tables[0].Columns["OrderId"];
DataColumn childColumn = set.Tables[1].Columns["OrderId"];
DataRelation relation = new DataRelation("OrderItems", parentColumn, childColumn);
set.Relations.Add(relation);
return set;
}
public DbQueryResult GetOrders(OrderQuery query)
{
StringBuilder builder = new StringBuilder("1=1");
if (query.Type.HasValue)
{
if (((OrderQuery.OrderType) query.Type.Value) == OrderQuery.OrderType.GroupBuy)
{
builder.Append(" And GroupBuyId > 0 ");
}
else
{
builder.Append(" And GroupBuyId is null ");
}
}
if ((query.OrderId != string.Empty) && (query.OrderId != null))
{
builder.AppendFormat(" AND OrderId = '{0}'", DataHelper.CleanSearchString(query.OrderId));
}
if (query.UserId.HasValue)
{
builder.AppendFormat(" AND UserId = '{0}'", query.UserId.Value);
}
if (query.PaymentType.HasValue)
{
builder.AppendFormat(" AND PaymentTypeId = '{0}'", query.PaymentType.Value);
}
if (query.GroupBuyId.HasValue)
{
builder.AppendFormat(" AND GroupBuyId = {0}", query.GroupBuyId.Value);
}
if (!string.IsNullOrEmpty(query.ProductName))
{
builder.AppendFormat(" AND OrderId IN (SELECT OrderId FROM Hishop_OrderItems WHERE ItemDescription LIKE '%{0}%')", DataHelper.CleanSearchString(query.ProductName));
}
if (!string.IsNullOrEmpty(query.ShipTo))
{
builder.AppendFormat(" AND ShipTo LIKE '%{0}%'", DataHelper.CleanSearchString(query.ShipTo));
}
if (query.RegionId.HasValue)
{
builder.AppendFormat(" AND ShippingRegion like '%{0}%'", DataHelper.CleanSearchString(RegionHelper.GetFullRegion(query.RegionId.Value, "，")));
}
if (!string.IsNullOrEmpty(query.UserName))
{
builder.AppendFormat(" AND UserName = '******' ", DataHelper.CleanSearchString(query.UserName));
}
if (query.Status == OrderStatus.History)
{
builder.AppendFormat(" AND OrderStatus != {0} AND OrderStatus != {1} AND OrderStatus != {2} AND OrderDate < '{3}'", new object[] { 1, 4, 9, DateTime.Now.AddMonths(-3) });
}
else if (query.Status == OrderStatus.BuyerAlreadyPaid)
{
builder.AppendFormat(" AND (OrderStatus = {0} OR (OrderStatus = 1 AND Gateway = 'hishop.plugins.payment.podrequest'))", (int) query.Status);
}
else if (query.Status != OrderStatus.All)
{
builder.AppendFormat(" AND OrderStatus = {0}", (int) query.Status);
}
if (query.StartDate.HasValue)
{
builder.AppendFormat(" AND datediff(dd,'{0}',OrderDate)>=0", DataHelper.GetSafeDateTimeFormat(query.StartDate.Value));
}
if (query.EndDate.HasValue)
{
builder.AppendFormat(" AND datediff(dd,'{0}',OrderDate)<=0", DataHelper.GetSafeDateTimeFormat(query.EndDate.Value));
}
if (query.ShippingModeId.HasValue)
{
builder.AppendFormat(" AND ShippingModeId = {0}", query.ShippingModeId.Value);
}
if (query.IsPrinted.HasValue)
{
builder.AppendFormat(" AND ISNULL(IsPrinted, 0)={0}", query.IsPrinted.Value);
}
return DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "vw_Hishop_Order", "OrderId", builder.ToString(), "*");
}
public int GetDistributorOrderCount(OrderQuery query)
{
string str = string.Empty;
if (query.Status == OrderStatus.Finished)
{
str = str + " AND OrderStatus=" + ((int) query.Status);
}
string str2 = "SELECT COUNT(*) FROM Hishop_Orders o WHERE ReferralUserId = @ReferralUserId";
str2 = str2 + str;
DbCommand sqlStringCommand = this.database.GetSqlStringCommand(str2);
sqlStringCommand.CommandType = CommandType.Text;
this.database.AddInParameter(sqlStringCommand, "ReferralUserId", DbType.Int32, query.UserId);
return (int) this.database.ExecuteScalar(sqlStringCommand);
}
public DataSet GetDistributorOrder(OrderQuery query)
{
string str = string.Empty;
if (query.Status == OrderStatus.Finished)
{
str = str + " AND OrderStatus=" + ((int) query.Status);
}
string str2 = "SELECT OrderId, OrderDate, OrderStatus,PaymentTypeId, OrderTotal,(SELECT SUM(Quantity) FROM Hishop_OrderItems WHERE OrderId = o.OrderId) as ProductSum,isnull((SELECT sum(CommTotal) FROM Hishop_Commissions WHERE UserId=@UserId AND OrderId=o.OrderId),0) AS CommTotal FROM Hishop_Orders o WHERE ReferralUserId = @UserId";
str2 = (str2 + str + " ORDER BY OrderDate DESC") + " SELECT OrderId, ThumbnailsUrl, ItemDescription, SKUContent, SKU, ProductId,Quantity,ItemListPrice FROM Hishop_OrderItems WHERE OrderId IN (SELECT OrderId FROM Hishop_Orders WHERE ReferralUserId = @UserId" + str + ")";
DbCommand sqlStringCommand = this.database.GetSqlStringCommand(str2);
this.database.AddInParameter(sqlStringCommand, "UserId", DbType.Int32, query.UserId);
DataSet set = this.database.ExecuteDataSet(sqlStringCommand);
DataColumn parentColumn = set.Tables[0].Columns["OrderId"];
DataColumn childColumn = set.Tables[1].Columns["OrderId"];
DataRelation relation = new DataRelation("OrderItems", parentColumn, childColumn);
set.Relations.Add(relation);
return set;
}
private OrderQuery GetOrderQuery()
{
int num4;
int num5;
OrderQuery query = new OrderQuery();
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["OrderId"]))
{
query.OrderId = Globals.UrlDecode(this.Page.Request.QueryString["OrderId"]);
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["ProductName"]))
{
query.ProductName = Globals.UrlDecode(this.Page.Request.QueryString["ProductName"]);
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["ShipTo"]))
{
query.ShipTo = Globals.UrlDecode(this.Page.Request.QueryString["ShipTo"]);
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["UserName"]))
{
query.UserName = Globals.UrlDecode(this.Page.Request.QueryString["UserName"]);
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["StartDate"]))
{
query.StartDate = new DateTime?(DateTime.Parse(this.Page.Request.QueryString["StartDate"]));
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["GroupBuyId"]))
{
query.GroupBuyId = new int?(int.Parse(this.Page.Request.QueryString["GroupBuyId"]));
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["EndDate"]))
{
query.EndDate = new DateTime?(DateTime.Parse(this.Page.Request.QueryString["EndDate"]));
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["OrderStatus"]))
{
int num = 0;
if (int.TryParse(this.Page.Request.QueryString["OrderStatus"], out num))
{
query.Status = (OrderStatus) num;
}
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["IsPrinted"]))
{
int num2 = 0;
if (int.TryParse(this.Page.Request.QueryString["IsPrinted"], out num2))
{
query.IsPrinted = new int?(num2);
}
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["ModeId"]))
{
int num3 = 0;
if (int.TryParse(this.Page.Request.QueryString["ModeId"], out num3))
{
query.ShippingModeId = new int?(num3);
}
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["region"]) && int.TryParse(this.Page.Request.QueryString["region"], out num4))
{
query.RegionId = new int?(num4);
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["UserId"]) && int.TryParse(this.Page.Request.QueryString["UserId"], out num5))
{
query.UserId = new int?(num5);
}
int result = 0;
if (int.TryParse(base.Request.QueryString["orderType"], out result) && (result > 0))
{
query.Type = new OrderQuery.OrderType?((OrderQuery.OrderType) result);
}
query.PageIndex = this.pager.PageIndex;
query.PageSize = this.pager.PageSize;
query.SortBy = "OrderDate";
query.SortOrder = SortAction.Desc;
return query;
}
public static int GetDistributorOrderCount(OrderQuery query)
{
return new OrderDao().GetDistributorOrderCount(query);
}
public static DataSet GetDistributorOrder(OrderQuery query)
{
return new OrderDao().GetDistributorOrder(query);
}
private void btnCreateReport_Click(object sender, EventArgs e)
{
OrderQuery userOrder = new OrderQuery {
UserName = this.userName,
ShipTo = this.shipTo,
StartDate = this.dateStart,
EndDate = this.dateEnd,
OrderId = this.orderId,
PageSize = this.pager.PageSize,
PageIndex = this.pager.PageIndex,
SortBy = "OrderDate",
SortOrder = SortAction.Desc
};
OrderStatisticsInfo userOrdersNoPage = SalesHelper.GetUserOrdersNoPage(userOrder);
StringBuilder builder = new StringBuilder();
builder.AppendLine("<table cellspacing=\"0\" cellpadding=\"5\" rules=\"all\" border=\"1\">");
builder.AppendLine("<tr style=\"font-weight: bold; white-space: nowrap;\">");
builder.AppendLine("<td>订单号</td>");
builder.AppendLine("<td>下单时间</td>");
builder.AppendLine("<td>总订单金额</td>");
builder.AppendLine("<td>昵称</td>");
builder.AppendLine("<td>收货人</td>");
builder.AppendLine("<td>利润</td>");
builder.AppendLine("</tr>");
foreach (DataRow row in userOrdersNoPage.OrderTbl.Rows)
{
builder.AppendLine("<tr>");
builder.AppendLine("<td style=\"vnd.ms-excel.numberformat:@\">" + row["OrderId"].ToString() + "</td>");
builder.AppendLine("<td>" + row["OrderDate"].ToString() + "</td>");
builder.AppendLine("<td>" + row["Total"].ToString() + "</td>");
builder.AppendLine("<td>" + row["UserName"].ToString() + "</td>");
builder.AppendLine("<td>" + row["ShipTo"].ToString() + "</td>");
builder.AppendLine("<td>" + row["Profits"].ToString() + "</td>");
builder.AppendLine("</tr>");
}
builder.AppendLine("<tr>");
builder.AppendLine("<td>当前查询结果共计," + userOrdersNoPage.TotalCount + "</td>");
builder.AppendLine("<td>订单金额共计," + userOrdersNoPage.TotalOfSearch + "</td>");
builder.AppendLine("<td>订单毛利润共计," + userOrdersNoPage.ProfitsOfSearch + "</td>");
builder.AppendLine("<td></td>");
builder.AppendLine("</tr>");
builder.AppendLine("</table>");
this.Page.Response.Clear();
this.Page.Response.Buffer = false;
this.Page.Response.Charset = "GB2312";
this.Page.Response.AppendHeader("Content-Disposition", "attachment;filename=UserOrderStatistics.xls");
this.Page.Response.ContentEncoding = Encoding.GetEncoding("GB2312");
this.Page.Response.ContentType = "application/ms-excel";
this.Page.EnableViewState = false;
this.Page.Response.Write(builder.ToString());
this.Page.Response.End();
}
public static DbQueryResult GetOrders(OrderQuery query)
{
return new OrderDao().GetOrders(query);
}