private void BindData()
{
OrderStatisticsQuery_UnderShop orderStatisticsQuery_UnderShop = new OrderStatisticsQuery_UnderShop();
orderStatisticsQuery_UnderShop.BeginDate = this.BeginDate;
orderStatisticsQuery_UnderShop.EndDate = this.EndDate;
orderStatisticsQuery_UnderShop.Top = new int?(this.Top);
orderStatisticsQuery_UnderShop.PageIndex = this.pager.PageIndex;
orderStatisticsQuery_UnderShop.PageSize = this.pager.PageSize;
orderStatisticsQuery_UnderShop.SortOrder = SortAction.Desc;
orderStatisticsQuery_UnderShop.SortBy = "SaleAmountFee";
orderStatisticsQuery_UnderShop.ShopLevel = new int?(2);
orderStatisticsQuery_UnderShop.AgentId = new int?(base.GetUrlIntParam("UserId"));
Globals.EntityCoding(orderStatisticsQuery_UnderShop, true);
DbQueryResult orderStatisticReport_UnderShop = ShopStatisticHelper.GetOrderStatisticReport_UnderShop(orderStatisticsQuery_UnderShop);
this.pager.TotalRecords = orderStatisticReport_UnderShop.TotalRecords;
this.rptList.DataSource = orderStatisticReport_UnderShop.Data;
this.rptList.DataBind();
System.Data.DataRow orderStatisticReportGlobalByAgentID = ShopStatisticHelper.GetOrderStatisticReportGlobalByAgentID(orderStatisticsQuery_UnderShop);
this.FXOrderNumber = base.GetFieldIntValue(orderStatisticReportGlobalByAgentID, "OrderNumber");
this.BuyerNumber = base.GetFieldIntValue(orderStatisticReportGlobalByAgentID, "BuyerNumber");
this.FXSaleAmountFee = base.GetFieldDecimalValue(orderStatisticReportGlobalByAgentID, "SaleAmountFee").ToString("N2");
this.FXBuyAvgPrice = "0";
if (base.GetFieldDecimalValue(orderStatisticReportGlobalByAgentID, "BuyerNumber") > 0m)
{
this.FXBuyAvgPrice = System.Math.Round(base.GetFieldDecimalValue(orderStatisticReportGlobalByAgentID, "SaleAmountFee") / base.GetFieldDecimalValue(orderStatisticReportGlobalByAgentID, "BuyerNumber"), 2).ToString("N2");
}
this.FXCommissionFee = base.GetFieldDecimalValue(orderStatisticReportGlobalByAgentID, "CommissionAmountFee").ToString("N2");
}
private void LoadData()
{
System.Data.DataRow dataRow = ShopStatisticHelper.MemberGlobal_GetCountInfo();
if (dataRow != null)
{
this.ActiveUserQty = base.GetFieldValue(dataRow, "ActiveUserQty");
this.SleepUserQty = base.GetFieldValue(dataRow, "SleepUserQty");
this.SuccessTradeUserQty = base.GetFieldValue(dataRow, "SuccessTradeUserQty");
this.SuccessTradeUserQty_Yesterday = base.GetFieldValue(dataRow, "SuccessTradeUserQty_Yesterday");
this.PotentialUserQty = base.GetFieldValue(dataRow, "PotentialUserQty");
this.PotentialUserQty_Yesterday = base.GetFieldValue(dataRow, "PotentialUserQty_Yesterday");
this.CollectUserQty = base.GetFieldValue(dataRow, "CollectUserQty");
this.CartUserQty = base.GetFieldValue(dataRow, "CartUserQty");
this.MemberQty = base.GetFieldValue(dataRow, "MemberQty");
}
System.Data.DataTable dataTable = ShopStatisticHelper.MemberGlobal_GetStatisticList(1);
System.Data.DataTable dataTable2 = ShopStatisticHelper.MemberGlobal_GetStatisticList(2);
this.MemberGradeList = "";
int num = 0;
int num2 = dataTable.Rows.Count;
foreach (System.Data.DataRow drOne in dataTable.Rows)
{
this.MemberGradeList = this.MemberGradeList + "'" + base.GetFieldValue(drOne, "Name") + "'";
this.QtyList_Grade = this.QtyList_Grade + "{" + string.Format("value:{0}, name:'{1}'", base.GetFieldValue(drOne, "Total"), base.GetFieldValue(drOne, "Name")) + "}";
if (num < num2 - 1)
{
this.MemberGradeList += ",";
this.QtyList_Grade += ",";
}
this.QtyList_Grade += "\n";
num++;
}
System.Data.DataView defaultView = dataTable2.DefaultView;
defaultView.Sort = "Total Desc";
dataTable2 = defaultView.ToTable();
this.RegionNameList = "";
this.RegionQtyList = "";
num = 0;
num2 = dataTable2.Rows.Count;
if (num2 > 9)
{
num2 = 9;
}
foreach (System.Data.DataRow drOne2 in dataTable2.Rows)
{
if (num >= 9)
{
break;
}
this.RegionNameList = this.RegionNameList + "'" + base.GetFieldValue(drOne2, "RegionName") + "'";
this.RegionQtyList += base.GetFieldValue(drOne2, "Total");
if (num < num2 - 1)
{
this.RegionNameList += ",";
this.RegionQtyList += ",";
}
num++;
}
}
private void LoadData()
{
DataRow drOne = ShopStatisticHelper.MemberGlobal_GetCountInfo();
if (drOne != null)
{
this.ActiveUserQty = base.GetFieldValue(drOne, "ActiveUserQty");
this.SleepUserQty = base.GetFieldValue(drOne, "SleepUserQty");
this.SuccessTradeUserQty = base.GetFieldValue(drOne, "SuccessTradeUserQty");
this.SuccessTradeUserQty_Yesterday = base.GetFieldValue(drOne, "SuccessTradeUserQty_Yesterday");
this.PotentialUserQty = base.GetFieldValue(drOne, "PotentialUserQty");
this.PotentialUserQty_Yesterday = base.GetFieldValue(drOne, "PotentialUserQty_Yesterday");
this.CollectUserQty = base.GetFieldValue(drOne, "CollectUserQty");
this.CartUserQty = base.GetFieldValue(drOne, "CartUserQty");
DataRow row2 = ShopStatisticHelper.ShopGlobal_GetMemberCount();
this.MemberQty = base.GetFieldValue(row2, "MemberQty");
}
DataTable table = ShopStatisticHelper.MemberGlobal_GetStatisticList(1);
DataTable table2 = ShopStatisticHelper.MemberGlobal_GetStatisticList(2);
this.MemberGradeList = "";
int num = 0;
int count = table.Rows.Count;
foreach (DataRow row3 in table.Rows)
{
this.MemberGradeList = this.MemberGradeList + "'" + base.GetFieldValue(row3, "Name") + "'";
this.QtyList_Grade = this.QtyList_Grade + "{" + string.Format("value:{0}, name:'{1}'", base.GetFieldValue(row3, "Total"), base.GetFieldValue(row3, "Name")) + "}";
if (num < (count - 1))
{
this.MemberGradeList = this.MemberGradeList + ",";
this.QtyList_Grade = this.QtyList_Grade + ",";
}
this.QtyList_Grade = this.QtyList_Grade + "\n";
num++;
}
DataView defaultView = table2.DefaultView;
defaultView.Sort = "Total Desc";
table2 = defaultView.ToTable();
this.RegionNameList = "";
this.RegionQtyList = "";
num = 0;
count = table2.Rows.Count;
if (count > 9)
{
count = 9;
}
foreach (DataRow row4 in table2.Rows)
{
if (num >= 9)
{
break;
}
this.RegionNameList = this.RegionNameList + "'" + base.GetFieldValue(row4, "RegionName") + "'";
this.RegionQtyList = this.RegionQtyList + base.GetFieldValue(row4, "Total");
if (num < (count - 1))
{
this.RegionNameList = this.RegionNameList + ",";
this.RegionQtyList = this.RegionQtyList + ",";
}
num++;
}
}
public void CalData(string AppPath, out bool result)
{
string text = "";
ShopStatisticHelper.AutoStatisticsOrdersV2(AppPath, out text);
result = true;
}
private void BindData()
{
OrderStatisticsQuery_UnderShop entity = new OrderStatisticsQuery_UnderShop {
BeginDate = this.BeginDate,
EndDate = this.EndDate,
Top = new int?(this.Top),
PageIndex = this.pager.PageIndex,
PageSize = this.pager.PageSize,
SortOrder = SortAction.Desc,
SortBy = "SaleAmountFee",
ShopLevel = 2,
AgentId = new int?(base.GetUrlIntParam("UserId"))
};
Globals.EntityCoding(entity, true);
DbQueryResult result = ShopStatisticHelper.GetOrderStatisticReport_UnderShop(entity);
this.pager.TotalRecords = result.TotalRecords;
this.rptList.DataSource = result.Data;
this.rptList.DataBind();
DataRow orderStatisticReportGlobalByAgentID = ShopStatisticHelper.GetOrderStatisticReportGlobalByAgentID(entity);
this.FXOrderNumber = base.GetFieldIntValue(orderStatisticReportGlobalByAgentID, "OrderNumber");
this.BuyerNumber = base.GetFieldIntValue(orderStatisticReportGlobalByAgentID, "BuyerNumber");
this.FXSaleAmountFee = base.GetFieldDecimalValue(orderStatisticReportGlobalByAgentID, "SaleAmountFee").ToString("N2");
this.FXBuyAvgPrice = "0";
if (base.GetFieldDecimalValue(orderStatisticReportGlobalByAgentID, "BuyerNumber") > 0M)
{
this.FXBuyAvgPrice = Math.Round((decimal)(base.GetFieldDecimalValue(orderStatisticReportGlobalByAgentID, "SaleAmountFee") / base.GetFieldDecimalValue(orderStatisticReportGlobalByAgentID, "BuyerNumber")), 2).ToString("N2");
}
this.FXCommissionFee = base.GetFieldDecimalValue(orderStatisticReportGlobalByAgentID, "CommissionAmountFee").ToString("N2");
}
public void Execute(IJobExecutionContext context)
{
TLog.SaveLog("定时器正执行指定任务...");
string retInfo = "";
ShopStatisticHelper.AutoStatisticsOrders(out retInfo);
TLog.SaveLog("任务执行完毕。结果：" + retInfo);
}
protected void Page_Load(object sender, EventArgs e)
{
DateTime today = DateTime.Today;
DateTime beginDate = today.AddDays(-6.0);
if (!base.IsPostBack)
{
SiteSettings masterSettings = SettingsManager.GetMasterSettings(false);
this.lbShopName.Text = masterSettings.SiteName;
if (this.imgLogo != null)
{
this.imgLogo.Src = masterSettings.DistributorLogoPic;
if (!File.Exists(base.Server.MapPath(masterSettings.DistributorLogoPic)))
{
this.imgLogo.Src = "/Admin/Shop/Public/images/80x80.png";
}
}
int port = base.Request.Url.Port;
string text = (port == 80) ? "" : (":" + port.ToString());
this.showUrl = string.Concat(new string[]
{
"http://",
base.Request.Url.Host,
text,
Globals.ApplicationPath,
"/default.aspx"
});
DataRow drOne = ShopStatisticHelper.ShopGlobal_GetMemberCount();
DataRow drOne2 = ShopStatisticHelper.ShopGlobal_GetOrderCountByDate(today);
DataRow drOne3 = ShopStatisticHelper.ShopGlobal_GetOrderCountByDate(today.AddDays(-1.0));
this.WaitSendOrderQty = base.GetFieldValue(drOne, "WaitSendOrderQty");
this.OrderQty_Today = base.GetFieldValue(drOne2, "OrderQty");
this.OrderQty_Yesterday = base.GetFieldValue(drOne3, "OrderQty");
this.OrderAmountFee_Today = base.GetFieldDecimalValue(drOne2, "OrderAmountFee").ToString("N2");
this.OrderAmountFee_Yesterday = base.GetFieldDecimalValue(drOne3, "OrderAmountFee").ToString("N2");
this.ServiceOrderQty = base.GetFieldValue(drOne, "ServiceOrderQty");
this.lbServiceOrderQty.Text = this.ServiceOrderQty;
if (this.ServiceOrderQty == "0")
{
this.lbServiceOrderQty.ForeColor = Color.Green;
}
else
{
this.lbServiceOrderQty.ForeColor = Color.Red;
}
this.GoodsQty = base.GetFieldValue(drOne, "GoodsQty");
this.MemberQty = base.GetFieldValue(drOne, "MemberQty");
this.DistributorQty = base.GetFieldValue(drOne, "DistributorQty");
//this.LoadTradeDataList(beginDate, 7);
this.rptDistributor.DataSource = ShopStatisticHelper.ShopGlobal_GetSortList_Distributor(beginDate, 8);
this.rptDistributor.DataBind();
this.rptMember.DataSource = ShopStatisticHelper.ShopGlobal_GetSortList_Member(beginDate, 8);
this.rptMember.DataBind();
}
}
protected void Page_Load(object sender, System.EventArgs e)
{
if (!base.IsPostBack)
{
string text = "";
ShopStatisticHelper.StatisticsOrdersByRecDate(System.DateTime.Today, UpdateAction.AllUpdate, 0, out text);
this.LoadData();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!base.IsPostBack)
{
string retInfo = "";
ShopStatisticHelper.StatisticsOrdersByRecDate(DateTime.Today, UpdateAction.AllUpdate, 0, out retInfo);
this.LoadData();
}
}
private void BindData()
{
DataSet set = ShopStatisticHelper.GetOrder_Member_Rebuy(this.BeginDate.Value, this.EndDate.Value, this.wid);
DataTable table = set.Tables[0];
foreach (DataRow row in table.Rows)
{
if (base.GetFieldIntValue(row, "IsOldMember") == 1)
{
this.OldMember += base.GetFieldIntValue(row, "TotalDiffMemberNumber");
}
this.BuyerNumber += base.GetFieldIntValue(row, "TotalDiffMemberNumber");
}
this.OldMemberPercent = "0";
if (this.BuyerNumber > 0)
{
this.OldMemberPercent = ((Convert.ToDecimal(this.OldMember) / Convert.ToDecimal(this.BuyerNumber)) * 100M).ToString("N2");
}
DataTable table2 = set.Tables[1];
DataTable table3 = new DataTable();
table3.Columns.Add("PayDate", typeof(string));
table3.Columns.Add("NewMemberQty", typeof(int));
table3.Columns.Add("OldMemberQty", typeof(int));
TimeSpan span = this.EndDate.Value - this.BeginDate.Value;
int days = span.Days;
for (int i = 0; i < days; i++)
{
DataRow row2 = table3.NewRow();
row2["PayDate"] = this.BeginDate.Value.AddDays((double)i).ToString("yyyy-MM-dd");
row2["OldMemberQty"] = 0;
row2["NewMemberQty"] = 0;
DataRow[] rowArray = table2.Select("IsOldMember=1 and PayDate='" + this.BeginDate.Value.AddDays((double)i).ToString("yyyy-MM-dd") + "' ");
if (rowArray.Length > 0)
{
row2["OldMemberQty"] = rowArray[0]["Number"];
}
rowArray = table2.Select("IsOldMember<>1 and PayDate='" + this.BeginDate.Value.AddDays((double)i).ToString("yyyy-MM-dd") + "'");
if (rowArray.Length > 0)
{
row2["NewMemberQty"] = rowArray[0]["Number"];
}
table3.Rows.Add(row2);
this.DateList = this.DateList + "'" + Convert.ToDateTime(row2["PayDate"].ToString()).ToString("yyyy-MM-dd") + "'";
this.QtyListNew = this.QtyListNew + base.GetFieldIntValue(row2, "NewMemberQty").ToString();
this.QtyListOld = this.QtyListOld + base.GetFieldDecimalValue(row2, "OldMemberQty").ToString();
this.QtyListAll = this.QtyListAll + ((base.GetFieldIntValue(row2, "NewMemberQty") + base.GetFieldDecimalValue(row2, "OldMemberQty"))).ToString();
if (i < (days - 1))
{
this.DateList = this.DateList + ",";
this.QtyListNew = this.QtyListNew + ",";
this.QtyListOld = this.QtyListOld + ",";
this.QtyListAll = this.QtyListAll + ",";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
DateTime today = DateTime.Today;
DateTime beginDate = today.AddDays(-7.0);
wid = GetCurWebId();
if (string.IsNullOrEmpty(wid))
{
return;
}
if (!base.IsPostBack)
{
//SiteSettings masterSettings = SettingsManager.GetMasterSettings(false);
//this.lbShopName.Text = masterSettings.SiteName;
//this.imgLogo.Src = masterSettings.DistributorLogoPic;
Chenduo.BLL.sf_website bll = new Chenduo.BLL.sf_website();
Chenduo.Model.sf_website website = bll.GetModelByWid(wid);
this.lbShopName.Text = website.sitename;
this.imgLogo.Src = website.logo;
if (!File.Exists(base.Server.MapPath(website.logo /*masterSettings.DistributorLogoPic*/)))
{
this.imgLogo.Src = "http://fpoimg.com/80x80";
}
int port = base.Request.Url.Port;
string str = (port == 80) ? "" : (":" + port.ToString());
this.showUrl = "http://" + base.Request.Url.Host + str + Globals.ApplicationPath + "/default.aspx?wid=" + this.wid;
DataRow drOne = ShopStatisticHelper.ShopGlobal_GetMemberCount(this.wid);
DataRow row2 = ShopStatisticHelper.ShopGlobal_GetOrderCountByDate(today, this.wid);
DataRow row3 = ShopStatisticHelper.ShopGlobal_GetOrderCountByDate(today.AddDays(-1.0), this.wid);
this.WaitSendOrderQty = base.GetFieldValue(drOne, "WaitSendOrderQty");
this.OrderQty_Today = base.GetFieldValue(row2, "OrderQty");
this.OrderQty_Yesterday = base.GetFieldValue(row3, "OrderQty");
this.OrderAmountFee_Today = base.GetFieldDecimalValue(row2, "OrderAmountFee").ToString("N2");
this.OrderAmountFee_Yesterday = base.GetFieldDecimalValue(row3, "OrderAmountFee").ToString("N2");
this.ServiceOrderQty = base.GetFieldValue(drOne, "ServiceOrderQty");
this.lbServiceOrderQty.Text = this.ServiceOrderQty;
if (this.ServiceOrderQty == "0")
{
this.lbServiceOrderQty.ForeColor = Color.Green;
}
else
{
this.lbServiceOrderQty.ForeColor = Color.Red;
}
this.GoodsQty = base.GetFieldValue(drOne, "GoodsQty");
this.MemberQty = base.GetFieldValue(drOne, "MemberQty");
this.DistributorQty = base.GetFieldValue(drOne, "DistributorQty");
this.LoadTradeDataList(beginDate, 7);
this.rptDistributor.DataSource = ShopStatisticHelper.ShopGlobal_GetSortList_Distributor(beginDate, 8, this.wid);
this.rptDistributor.DataBind();
this.rptMember.DataSource = ShopStatisticHelper.ShopGlobal_GetSortList_Member(beginDate, 8, this.wid);
this.rptMember.DataBind();
}
}
private void BindData()
{
DateTime beginDate = DateTime.Today.AddDays(-6.0);
if (this.txtBeginDate.TextToDate.HasValue)
{
beginDate = DateTime.Parse(this.txtBeginDate.TextToDate.Value.ToString());
}
DateTime now = DateTime.Now;
if (this.txtEndDate.TextToDate.HasValue)
{
now = DateTime.Parse(this.txtEndDate.TextToDate.Value.ToString());
}
DataRow drOne = ShopStatisticHelper.GetOrder_Member_CountInfo(beginDate, now);
DataTable saleReport = ShopStatisticHelper.GetSaleReport(beginDate, now);
TimeSpan span = (TimeSpan)(now - beginDate);
int days = span.Days;
this.OrderNumber = base.GetFieldDecimalValue(drOne, "OrderNumber");
this.BuyerNumber = base.GetFieldDecimalValue(drOne, "BuyerNumber");
this.SaleAmountFee = base.GetFieldDecimalValue(drOne, "SaleAmountFee");
this.BuyerAvgPrice = 0M;
if (this.BuyerNumber > 0M)
{
this.BuyerAvgPrice = Math.Round((decimal)(this.SaleAmountFee / this.BuyerNumber), 2);
}
this.NewMemberNumber = base.GetFieldIntValue(drOne, "NewMemberNumber");
this.NewAgentNumber = base.GetFieldIntValue(drOne, "NewAgentNumber");
this.DateListA = "";
this.DateListB = "";
int num2 = 0;
days = saleReport.Rows.Count;
foreach (DataRow row2 in saleReport.Rows)
{
this.DateListA = this.DateListA + "'" + Convert.ToDateTime(row2["RecDate"].ToString()).ToString("yyyy-MM-dd") + "'";
this.QtyListA1 = this.QtyListA1 + base.GetFieldIntValue(row2, "OrderNumber").ToString();
this.QtyListA2 = this.QtyListA2 + base.GetFieldDecimalValue(row2, "SaleAmountFee").ToString();
this.QtyListB1 = this.QtyListB1 + base.GetFieldIntValue(row2, "NewMemberNumber").ToString();
this.QtyListB2 = this.QtyListB2 + base.GetFieldIntValue(row2, "NewAgentNumber").ToString();
if (num2 < (days - 1))
{
this.DateListA = this.DateListA + ",";
this.QtyListA1 = this.QtyListA1 + ",";
this.QtyListA2 = this.QtyListA2 + ",";
this.DateListB = this.DateListB + ",";
this.QtyListB1 = this.QtyListB1 + ",";
this.QtyListB2 = this.QtyListB2 + ",";
}
num2++;
}
this.DateListB = this.DateListA;
}
protected void Page_Load(object sender, System.EventArgs e)
{
System.DateTime arg_05_0 = System.DateTime.Today;
System.DateTime beginDate = System.DateTime.Today.AddDays(-6.0);
if (!base.IsPostBack)
{
string text = "";
ShopStatisticHelper.StatisticsOrdersByRecDate(System.DateTime.Today, UpdateAction.AllUpdate, 0, out text);
this.LoadData();
this.LoadTradeDataList(beginDate, 7);
}
}
private void BindData()
{
OrderStatisticsQuery orderStatisticsQuery = new OrderStatisticsQuery();
orderStatisticsQuery.PageIndex = 1;
orderStatisticsQuery.PageSize = 50;
orderStatisticsQuery.SortOrder = SortAction.Desc;
orderStatisticsQuery.SortBy = "TotalRec";
Globals.EntityCoding(orderStatisticsQuery, true);
DbQueryResult dbQueryResult = ShopStatisticHelper.Member_GetRegionReport(orderStatisticsQuery);
int num = 0;
System.Data.DataTable dataTable = ((System.Data.DataTable)dbQueryResult.Data).Clone();
foreach (System.Data.DataRow dataRow in ((System.Data.DataTable)dbQueryResult.Data).Rows)
{
num++;
System.Data.DataRow dataRow2 = dataTable.NewRow();
dataRow2["RegionName"] = dataRow["RegionName"];
dataRow2["TotalRec"] = dataRow["TotalRec"];
dataTable.Rows.Add(dataRow2);
if (num == 1)
{
this.MaxQty = int.Parse(dataRow2["TotalRec"].ToString());
}
if (num >= 10)
{
break;
}
}
this.rptList.DataSource = dataTable;
this.rptList.DataBind();
this.QtyList1 = "";
num = 0;
int count = ((System.Data.DataTable)dbQueryResult.Data).Rows.Count;
foreach (System.Data.DataRow drOne in ((System.Data.DataTable)dbQueryResult.Data).Rows)
{
this.QtyList1 = string.Concat(new string[]
{
this.QtyList1,
"{name: '",
base.GetFieldValue(drOne, "RegionName"),
"',value: ",
base.GetFieldIntValue(drOne, "TotalRec").ToString(),
"}"
});
if (num < count - 1)
{
this.QtyList1 += ",\n";
}
num++;
}
}
protected void Page_Load(object sender, EventArgs e)
{
DateTime today = DateTime.Today;
DateTime beginDate = DateTime.Today.AddDays(-6.0);
if (!base.IsPostBack)
{
string retInfo = "";
ShopStatisticHelper.StatisticsOrdersByRecDate(DateTime.Today, UpdateAction.AllUpdate, 0, out retInfo);
this.LoadData();
this.LoadTradeDataList(beginDate, 7);
}
}
private void BindData()
{
System.DateTime dateTime = System.DateTime.Today.AddDays(-6.0);
if (this.txtBeginDate.TextToDate.HasValue)
{
dateTime = System.DateTime.Parse(this.txtBeginDate.TextToDate.Value.ToString());
}
System.DateTime dateTime2 = System.DateTime.Now;
if (this.txtEndDate.TextToDate.HasValue)
{
dateTime2 = System.DateTime.Parse(this.txtEndDate.TextToDate.Value.ToString());
}
System.Data.DataRow order_Member_CountInfo = ShopStatisticHelper.GetOrder_Member_CountInfo(dateTime, dateTime2);
System.Data.DataTable saleReport = ShopStatisticHelper.GetSaleReport(dateTime, dateTime2);
int num = (dateTime2 - dateTime).Days;
this.OrderNumber = base.GetFieldDecimalValue(order_Member_CountInfo, "OrderNumber");
this.BuyerNumber = base.GetFieldDecimalValue(order_Member_CountInfo, "BuyerNumber");
this.SaleAmountFee = base.GetFieldDecimalValue(order_Member_CountInfo, "SaleAmountFee");
this.BuyerAvgPrice = 0m;
if (this.BuyerNumber > 0m)
{
this.BuyerAvgPrice = System.Math.Round(this.SaleAmountFee / this.BuyerNumber, 2);
}
this.NewMemberNumber = base.GetFieldIntValue(order_Member_CountInfo, "NewMemberNumber");
this.NewAgentNumber = base.GetFieldIntValue(order_Member_CountInfo, "NewAgentNumber");
this.DateListA = "";
this.DateListB = "";
int num2 = 0;
num = saleReport.Rows.Count;
foreach (System.Data.DataRow dataRow in saleReport.Rows)
{
this.DateListA = this.DateListA + "'" + System.Convert.ToDateTime(dataRow["RecDate"].ToString()).ToString("yyyy-MM-dd") + "'";
this.QtyListA1 += base.GetFieldIntValue(dataRow, "OrderNumber").ToString();
this.QtyListA2 += base.GetFieldDecimalValue(dataRow, "SaleAmountFee").ToString();
this.QtyListB1 += base.GetFieldIntValue(dataRow, "NewMemberNumber").ToString();
this.QtyListB2 += base.GetFieldIntValue(dataRow, "NewAgentNumber").ToString();
if (num2 < num - 1)
{
this.DateListA += ",";
this.QtyListA1 += ",";
this.QtyListA2 += ",";
this.DateListB += ",";
this.QtyListB1 += ",";
this.QtyListB2 += ",";
}
num2++;
}
this.DateListB = this.DateListA;
}
protected void Page_Load(object sender, System.EventArgs e)
{
this.btnSearch.Click += new System.EventHandler(this.btnSearch_Click);
if (base.GetUrlParam("BeginDate") == "")
{
string text = "";
ShopStatisticHelper.StatisticsOrdersByRecDate(System.DateTime.Today, UpdateAction.AllUpdate, 0, out text);
}
if (!base.IsPostBack)
{
this.LoadParameters();
this.BindData();
}
}
private void BindData()
{
System.Data.DataSet order_Member_Rebuy = ShopStatisticHelper.GetOrder_Member_Rebuy(this.BeginDate.Value, this.EndDate.Value);
System.Data.DataTable dataTable = order_Member_Rebuy.Tables[0];
foreach (System.Data.DataRow drOne in dataTable.Rows)
{
this.OldMember += base.GetFieldIntValue(drOne, "OldBuy");
this.BuyerNumber += base.GetFieldIntValue(drOne, "totalBuy");
}
this.OldMemberPercent = "0";
if (this.BuyerNumber > 0)
{
this.OldMemberPercent = (System.Convert.ToDecimal(this.OldMember) / System.Convert.ToDecimal(this.BuyerNumber) * 100m).ToString("N2");
}
System.Data.DataTable dataTable2 = order_Member_Rebuy.Tables[1];
System.Data.DataTable dataTable3 = new System.Data.DataTable();
dataTable3.Columns.Add("PayDate", typeof(string));
dataTable3.Columns.Add("NewMemberQty", typeof(int));
dataTable3.Columns.Add("OldMemberQty", typeof(int));
int num = (this.EndDate.Value - this.BeginDate.Value).Days + 1;
for (int i = 0; i < num; i++)
{
System.Data.DataRow dataRow = dataTable3.NewRow();
dataRow["PayDate"] = this.BeginDate.Value.AddDays((double)i).ToString("yyyy-MM-dd");
dataRow["OldMemberQty"] = 0;
dataRow["NewMemberQty"] = 0;
System.Data.DataRow[] array = dataTable2.Select("gpDate='" + this.BeginDate.Value.AddDays((double)i).ToString("yyyy-MM-dd") + "' ");
if (array.Length > 0)
{
dataRow["OldMemberQty"] = array[0]["OldBuy"];
dataRow["NewMemberQty"] = (int.Parse(array[0]["TotalBuy"].ToString()) - int.Parse(array[0]["OldBuy"].ToString())).ToString();
}
dataTable3.Rows.Add(dataRow);
this.DateList = this.DateList + "'" + System.Convert.ToDateTime(dataRow["PayDate"].ToString()).ToString("yyyy-MM-dd") + "'";
this.QtyListNew += base.GetFieldIntValue(dataRow, "NewMemberQty").ToString();
this.QtyListOld += base.GetFieldDecimalValue(dataRow, "OldMemberQty").ToString();
int fieldIntValue = base.GetFieldIntValue(dataRow, "NewMemberQty");
int fieldIntValue2 = base.GetFieldIntValue(dataRow, "OldMemberQty");
this.QtyListAll += (fieldIntValue + fieldIntValue2).ToString();
if (i < num - 1)
{
this.DateList += ",";
this.QtyListNew += ",";
this.QtyListOld += ",";
this.QtyListAll += ",";
}
}
}
public void Execute(IJobExecutionContext context)
{
string logname = "_Tonji.txt";
try
{
Globals.Debuglog("定时器正执行指定任务AutoStatisticsOrdersV2...", logname);
string retInfo = "";
ShopStatisticHelper.AutoStatisticsOrdersV2("", out retInfo);
Globals.Debuglog("任务执行完毕。结果：" + retInfo, logname);
}
catch (Exception exception)
{
Globals.Debuglog("任务执行出错：" + exception.Message, logname);
}
}
private void BindData()
{
OrderStatisticsQuery entity = new OrderStatisticsQuery
{
PageIndex = 1,
PageSize = 50,
SortOrder = SortAction.Desc,
SortBy = "TotalRec"
};
Globals.EntityCoding(entity, true);
DbQueryResult result = ShopStatisticHelper.Member_GetRegionReport(entity);
int num = 0;
DataTable table = ((DataTable)result.Data).Clone();
foreach (DataRow row in ((DataTable)result.Data).Rows)
{
num++;
DataRow row2 = table.NewRow();
row2["RegionName"] = row["RegionName"];
row2["TotalRec"] = row["TotalRec"];
table.Rows.Add(row2);
if (num == 1)
{
this.MaxQty = int.Parse(row2["TotalRec"].ToString());
}
if (num >= 10)
{
break;
}
}
this.rptList.DataSource = table;
this.rptList.DataBind();
this.QtyList1 = "";
num = 0;
int count = ((DataTable)result.Data).Rows.Count;
foreach (DataRow row3 in ((DataTable)result.Data).Rows)
{
this.QtyList1 = this.QtyList1 + "{name: '" + base.GetFieldValue(row3, "RegionName") + "',value: " + base.GetFieldIntValue(row3, "TotalRec").ToString() + "}";
if (num < (count - 1))
{
this.QtyList1 = this.QtyList1 + ",\n";
}
num++;
}
}
private void BindData()
{
OrderStatisticsQuery orderStatisticsQuery = new OrderStatisticsQuery();
orderStatisticsQuery.BeginDate = this.BeginDate;
orderStatisticsQuery.EndDate = this.EndDate;
orderStatisticsQuery.PageIndex = this.pager.PageIndex;
orderStatisticsQuery.PageSize = this.pager.PageSize;
orderStatisticsQuery.SortOrder = SortAction.Desc;
orderStatisticsQuery.SortBy = "SaleAmountFee";
Globals.EntityCoding(orderStatisticsQuery, true);
DbQueryResult dbQueryResult = ShopStatisticHelper.Product_GetStatisticReport(orderStatisticsQuery);
this.rptList.DataSource = dbQueryResult.Data;
this.rptList.DataBind();
this.pager.TotalRecords = dbQueryResult.TotalRecords;
}
private void BindData()
{
OrderStatisticsQuery entity = new OrderStatisticsQuery {
BeginDate = this.BeginDate,
EndDate = this.EndDate,
PageIndex = this.pager.PageIndex,
PageSize = this.pager.PageSize,
SortOrder = SortAction.Desc,
SortBy = "OrderTotal"
};
Globals.EntityCoding(entity, true);
DbQueryResult result = ShopStatisticHelper.Member_GetStatisticReport(entity);
this.rptList.DataSource = result.Data;
this.rptList.DataBind();
this.pager.TotalRecords = result.TotalRecords;
}
private void BindData()
{
OrderStatisticsQuery orderStatisticsQuery = new OrderStatisticsQuery();
OrderStatisticsQuery arg_1E_0 = orderStatisticsQuery;
System.DateTime arg_12_0 = this.BeginDate.Value;
arg_1E_0.BeginDate = this.txtBeginDate.TextToDate;
OrderStatisticsQuery arg_3B_0 = orderStatisticsQuery;
System.DateTime arg_2F_0 = this.EndDate.Value;
arg_3B_0.EndDate = this.txtEndDate.TextToDate;
orderStatisticsQuery.SortOrder = SortAction.Desc;
orderStatisticsQuery.SortBy = "RecDate";
Globals.EntityCoding(orderStatisticsQuery, true);
System.Data.DataTable dtDist = ShopStatisticHelper.Member_GetInCreateReport(orderStatisticsQuery);
this.lastDay = (orderStatisticsQuery.EndDate.Value - orderStatisticsQuery.BeginDate.Value).Days + 1;
this.LoadTradeDataList(dtDist, this.BeginDate.Value, this.lastDay);
}
private void BindData()
{
OrderStatisticsQuery entity = new OrderStatisticsQuery();
DateTime local1 = this.BeginDate.Value;
entity.BeginDate = this.txtBeginDate.TextToDate;
DateTime local2 = this.EndDate.Value;
entity.EndDate = this.txtEndDate.TextToDate;
entity.SortOrder = SortAction.Desc;
entity.SortBy = "RecDate";
Globals.EntityCoding(entity, true);
DataTable dtDist = ShopStatisticHelper.Member_GetInCreateReport(entity);
TimeSpan span = entity.EndDate.Value - entity.BeginDate.Value;
this.lastDay = span.Days + 1;
this.LoadTradeDataList(dtDist, this.BeginDate.Value, this.lastDay);
}
private void BindData()
{
OrderStatisticsQuery entity = new OrderStatisticsQuery {
BeginDate = this.BeginDate,
EndDate = this.EndDate,
Top = new int?(this.Top),
PageIndex = this.pager.PageIndex,
PageSize = this.pager.PageSize,
SortOrder = SortAction.Desc,
SortBy = "SaleAmountFee",
wid = this.wid
};
Globals.EntityCoding(entity, true);
DbQueryResult orderStatisticReport = ShopStatisticHelper.GetOrderStatisticReport(entity);
DateTime beginDate = DateTime.Today.AddDays(-7.0);
if (this.txtBeginDate.TextToDate.HasValue)
{
beginDate = this.txtBeginDate.TextToDate.Value;
}
DateTime now = DateTime.Now;
if (this.txtEndDate.TextToDate.HasValue)
{
now = this.txtEndDate.TextToDate.Value;
}
DataRow drOne = ShopStatisticHelper.GetOrder_Member_CountInfo(beginDate, now, this.wid);
this.OrderNumber = base.GetFieldIntValue(drOne, "OrderNumber");
this.SaleAmountFee = base.GetFieldDecimalValue(drOne, "SaleAmountFee").ToString("N2");
this.FXOrderNumber = base.GetFieldIntValue(drOne, "FXOrderNumber");
this.FXSaleAmountFee = base.GetFieldDecimalValue(drOne, "FXSaleAmountFee").ToString("N2");
this.FXResultPercent = "0";
if (base.GetFieldDecimalValue(drOne, "SaleAmountFee") > 0M)
{
this.FXResultPercent = Math.Round((decimal)((base.GetFieldDecimalValue(drOne, "FXSaleAmountFee") / base.GetFieldDecimalValue(drOne, "SaleAmountFee")) * 100M), 2).ToString("N2");
}
this.FXCommissionFee = base.GetFieldDecimalValue(drOne, "FXCommissionFee").ToString("N2");
this.rptList.DataSource = orderStatisticReport.Data;
this.rptList.DataBind();
this.pager.TotalRecords = orderStatisticReport.TotalRecords;
}
private void LoadData()
{
DateTime today = DateTime.Today;
DateTime recDate = today.AddDays(-1.0);
DataRow drOne = ShopStatisticHelper.Distributor_GetGlobal(today);
if (drOne != null)
{
this.SaleAmountFee = base.GetFieldDecimalValue(drOne, "ValidOrderTotal");
this.FXValidOrderTotal = base.GetFieldDecimalValue(drOne, "FXValidOrderTotal");
this.FXOrderNumber = base.GetFieldIntValue(drOne, "FXOrderNumber");
this.FXCommissionFee = base.GetFieldDecimalValue(drOne, "FXSumCommission");
this.FXResultPercent = 0M;
if ((this.SaleAmountFee > 0M) && (this.FXValidOrderTotal > 0M))
{
this.FXResultPercent = Convert.ToDecimal((decimal)((this.FXValidOrderTotal / this.SaleAmountFee) * 100M));
}
}
drOne = ShopStatisticHelper.Distributor_GetGlobal(recDate);
if (drOne != null)
{
this.SaleAmountFee_Yesterday = base.GetFieldDecimalValue(drOne, "ValidOrderTotal");
this.FXValidOrderTotal_Yesterday = base.GetFieldDecimalValue(drOne, "FXValidOrderTotal");
this.FXOrderNumber_Yesterday = base.GetFieldIntValue(drOne, "FXOrderNumber");
this.FXCommissionFee_Yesterday = base.GetFieldDecimalValue(drOne, "FXSumCommission");
this.FXResultPercent_Yesterday = 0M;
if ((this.SaleAmountFee_Yesterday > 0M) && (this.FXValidOrderTotal_Yesterday > 0M))
{
this.FXResultPercent_Yesterday = Convert.ToDecimal((decimal)((this.FXValidOrderTotal_Yesterday / this.SaleAmountFee_Yesterday) * 100M));
}
}
drOne = ShopStatisticHelper.Distributor_GetGlobalTotal(recDate);
if (drOne != null)
{
this.AgentNumber = base.GetFieldIntValue(drOne, "DistributorNumber");
this.NewAgentNumber_Yesterday = base.GetFieldIntValue(drOne, "NewAgentNumber");
this.FinishedDrawCommissionFee = base.GetFieldDecimalValue(drOne, "FinishedDrawCommissionFee");
this.WaitDrawCommissionFee = base.GetFieldDecimalValue(drOne, "WaitDrawCommissionFee");
}
}
private void LoadTradeDataList(System.DateTime BeginDate, int Days)
{
System.Data.DataTable dataTable = ShopStatisticHelper.ShopGlobal_GetTrendDataList(BeginDate, Days);
this.DateList = "";
int num = 0;
foreach (System.Data.DataRow dataRow in dataTable.Rows)
{
this.DateList = this.DateList + "'" + System.Convert.ToDateTime(dataRow["RecDate"].ToString()).ToString("yyyy-MM-dd") + "'";
this.QtyList1 += base.GetFieldValue(dataRow, "OrderCount");
this.QtyList2 += base.GetFieldValue(dataRow, "NewDistributorCount");
this.QtyList3 += base.GetFieldValue(dataRow, "NewMemberCount");
if (num < Days - 1)
{
this.DateList += ",";
this.QtyList1 += ",";
this.QtyList2 += ",";
this.QtyList3 += ",";
}
num++;
}
}
private void BindData()
{
OrderStatisticsQuery orderStatisticsQuery = new OrderStatisticsQuery();
orderStatisticsQuery.BeginDate = this.BeginDate;
orderStatisticsQuery.EndDate = this.EndDate;
orderStatisticsQuery.Top = new int?(this.Top);
orderStatisticsQuery.PageIndex = this.pager.PageIndex;
orderStatisticsQuery.PageSize = this.pager.PageSize;
orderStatisticsQuery.SortOrder = SortAction.Desc;
orderStatisticsQuery.SortBy = "SaleAmountFee";
Globals.EntityCoding(orderStatisticsQuery, true);
DbQueryResult orderStatisticReport = ShopStatisticHelper.GetOrderStatisticReport(orderStatisticsQuery);
System.DateTime beginDate = System.DateTime.Today.AddDays(-6.0);
if (this.txtBeginDate.TextToDate.HasValue)
{
beginDate = this.txtBeginDate.TextToDate.Value;
}
System.DateTime endDate = System.DateTime.Now;
if (this.txtEndDate.TextToDate.HasValue)
{
endDate = this.txtEndDate.TextToDate.Value;
}
System.Data.DataRow order_Member_CountInfo = ShopStatisticHelper.GetOrder_Member_CountInfo(beginDate, endDate);
this.OrderNumber = base.GetFieldIntValue(order_Member_CountInfo, "OrderNumber");
this.SaleAmountFee = base.GetFieldDecimalValue(order_Member_CountInfo, "SaleAmountFee").ToString("N2");
this.FXOrderNumber = base.GetFieldIntValue(order_Member_CountInfo, "FXOrderNumber");
this.FXSaleAmountFee = base.GetFieldDecimalValue(order_Member_CountInfo, "FXSaleAmountFee").ToString("N2");
this.FXResultPercent = "0";
if (base.GetFieldDecimalValue(order_Member_CountInfo, "SaleAmountFee") > 0m)
{
this.FXResultPercent = System.Math.Round(base.GetFieldDecimalValue(order_Member_CountInfo, "FXSaleAmountFee") / base.GetFieldDecimalValue(order_Member_CountInfo, "SaleAmountFee") * 100m, 2).ToString("N2");
}
this.FXCommissionFee = base.GetFieldDecimalValue(order_Member_CountInfo, "FXCommissionFee").ToString("N2");
this.rptList.DataSource = orderStatisticReport.Data;
this.rptList.DataBind();
this.pager.TotalRecords = orderStatisticReport.TotalRecords;
}
protected void Page_Load(object sender, EventArgs e)
{
this.btnExport.Click += new EventHandler(this.btnExport_Click);
this.btnSearch.Click += new EventHandler(this.btnSearch_Click);
if (base.GetUrlParam("BeginDate") == "")
{
string retInfo = "";
ShopStatisticHelper.StatisticsOrdersByRecDate(DateTime.Today, UpdateAction.AllUpdate, 0, out retInfo);
}
this.LoadParameters();
if (!base.IsPostBack)
{
this.BindData();
this.exportFieldsCheckBoxList.Items.Clear();
this.exportFieldsCheckBoxList.Items.Add(new ListItem("排名", "RankIndex"));
this.exportFieldsCheckBoxList.Items.Add(new ListItem("商品名称", "ProductName"));
this.exportFieldsCheckBoxList.Items.Add(new ListItem("销售量", "SaleQty"));
this.exportFieldsCheckBoxList.Items.Add(new ListItem("销售额", "SaleAmountFee"));
this.exportFieldsCheckBoxList.Items.Add(new ListItem("购买人数", "BuyerNumber"));
this.exportFieldsCheckBoxList.Items.Add(new ListItem("转化率", "ConversionRate"));
}
}
private void LoadData()
{
System.DateTime today = System.DateTime.Today;
System.DateTime dateTime = today.AddDays(-1.0);
System.Data.DataRow dataRow = ShopStatisticHelper.Distributor_GetGlobal(today);
if (dataRow != null)
{
this.SaleAmountFee = base.GetFieldDecimalValue(dataRow, "ValidOrderTotal");
this.FXValidOrderTotal = base.GetFieldDecimalValue(dataRow, "FXValidOrderTotal");
this.FXOrderNumber = base.GetFieldIntValue(dataRow, "FXOrderNumber");
this.FXCommissionFee = base.GetFieldDecimalValue(dataRow, "FXSumCommission");
this.FXResultPercent = 0m;
if (this.SaleAmountFee > 0m && this.FXValidOrderTotal > 0m)
{
this.FXResultPercent = System.Convert.ToDecimal(this.FXValidOrderTotal / this.SaleAmountFee * 100m);
}
}
dataRow = ShopStatisticHelper.Distributor_GetGlobal(dateTime);
if (dataRow != null)
{
this.SaleAmountFee_Yesterday = base.GetFieldDecimalValue(dataRow, "ValidOrderTotal");
this.FXValidOrderTotal_Yesterday = base.GetFieldDecimalValue(dataRow, "FXValidOrderTotal");
this.FXOrderNumber_Yesterday = base.GetFieldIntValue(dataRow, "FXOrderNumber");
this.FXCommissionFee_Yesterday = base.GetFieldDecimalValue(dataRow, "FXSumCommission");
this.FXResultPercent_Yesterday = 0m;
if (this.SaleAmountFee_Yesterday > 0m && this.FXValidOrderTotal_Yesterday > 0m)
{
this.FXResultPercent_Yesterday = System.Convert.ToDecimal(this.FXValidOrderTotal_Yesterday / this.SaleAmountFee_Yesterday * 100m);
}
}
dataRow = ShopStatisticHelper.Distributor_GetGlobalTotal(dateTime);
if (dataRow != null)
{
this.AgentNumber = base.GetFieldIntValue(dataRow, "DistributorNumber");
this.NewAgentNumber_Yesterday = base.GetFieldIntValue(dataRow, "NewAgentNumber");
this.FinishedDrawCommissionFee = base.GetFieldDecimalValue(dataRow, "FinishedDrawCommissionFee");
this.WaitDrawCommissionFee = base.GetFieldDecimalValue(dataRow, "WaitDrawCommissionFee");
}
}
