protected void bindData()
{
DataTable dt = SPDayReportWrapper.GetAllTodayReport(this.chkFilterNoCount.Checked);
dt.Columns.Add(new DataColumn("ClientGroupName"));
dt.Columns.Add(new DataColumn("SetInterceptRate"));
dt.Columns.Add(new DataColumn("ChannelClientCode"));
dt.Columns.Add(new DataColumn("IsSycnData", typeof(bool)));
dt.AcceptChanges();
foreach (DataRow item in dt.Rows)
{
SPClientWrapper client = SPClientWrapper.FindById((int)item["ClientID"]);
if (client == null)
{
item["ChannelClientID"] = 0;
item["ClientGroupName"] = "";
item["SetInterceptRate"] = "";
item["ChannelClientCode"] = "";
item["IsSycnData"] = false;
}
else
{
item["ChannelClientID"] = client.DefaultClientChannelSetting.Id;
item["ClientGroupName"] = client.ClientGroupName;
item["SetInterceptRate"] = client.DefaultClientChannelSetting.InterceptRate;
item["ChannelClientCode"] = client.DefaultClientChannelSetting.ChannelClientCode;
item["IsSycnData"] = client.DefaultClientChannelSetting.SyncData.HasValue && client.DefaultClientChannelSetting.SyncData.Value;
}
}
Store1.DataSource = dt;
Store1.DataBind();
this.txtTotalCount.Text = string.Format("总点播数(条)：{0}", GetSumField(dt, "TotalCount"));
this.txtInterceptCount.Text = string.Format("总扣量数(条)：{0}", GetSumField(dt, "InterceptCount"));
this.txtDownCount.Text = string.Format("总转发下家数(条)：{0}", GetSumField(dt, "DownCount"));
this.txtDownSycnCount.Text = string.Format("总同步下家数(条)：{0}", GetSumField(dt, "DownSycnCount"));
}
protected void bindData()
{
DataTable dt = SPDayReportWrapper.GetAllTodayReport(this.chkFilterNoCount.Checked);
dt.Columns.Add(new DataColumn("ClientGroupName"));
dt.Columns.Add(new DataColumn("AssignedUser"));
dt.Columns.Add(new DataColumn("SetInterceptRate"));
dt.Columns.Add(new DataColumn("ChannelClientCode"));
dt.Columns.Add(new DataColumn("IsSycnData", typeof(bool)));
dt.Columns.Add(new DataColumn("Price", typeof(string)));
dt.AcceptChanges();
foreach (DataRow item in dt.Rows)
{
SPClientWrapper client = SPClientWrapper.FindById((int)item["ClientID"]);
if (client == null)
{
item["ChannelClientID"] = 0;
item["ClientGroupName"] = "";
item["SetInterceptRate"] = "";
item["ChannelClientCode"] = "";
item["IsSycnData"] = false;
item["AssignedUser"] = "";
item["Price"] = "0.00/0.00";
}
else
{
item["ChannelClientID"] = client.DefaultClientChannelSetting.Id;
item["ClientGroupName"] = client.ClientGroupName;
item["SetInterceptRate"] = client.DefaultClientChannelSetting.InterceptRate;
item["ChannelClientCode"] = client.DefaultClientChannelSetting.ChannelClientCode;
item["IsSycnData"] = client.DefaultClientChannelSetting.SyncData.HasValue && client.DefaultClientChannelSetting.SyncData.Value;
if (client.SPClientGroupID != null)
{
item["AssignedUser"] = client.SPClientGroupID.AssigedUserLoginID;
}
else
{
item["AssignedUser"] = "";
}
if (AppConfig.IsGamePlatform)
{
decimal channlePrice = 0;
if (client.DefaultClientChannelSetting.ChannelID != null &&
client.DefaultClientChannelSetting.ChannelID.Price.HasValue)
{
channlePrice = client.DefaultClientChannelSetting.ChannelID.Price.Value;
}
item["Price"] = client.Price.ToString("N2") + "/" + channlePrice.ToString("N2");
}
else
{
item["Price"] = client.Price.ToString();
}
}
}
Store1.DataSource = dt;
Store1.DataBind();
this.txtTotalCount.Text = string.Format("总点播数(条)：{0}", GetSumField(dt, "TotalCount"));
this.txtInterceptCount.Text = string.Format("总扣量数(条)：{0}", GetSumField(dt, "InterceptCount"));
this.txtDownCount.Text = string.Format("总转发下家数(条)：{0}", GetSumField(dt, "DownCount"));
this.txtDownSycnCount.Text = string.Format("总同步下家数(条)：{0}", GetSumField(dt, "DownSycnCount"));
}
