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 + ",";
}
}
}
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 += ",";
}
}
}