protected void storeSPDayReport_Refresh(object sender, StoreRefreshDataEventArgs e)
{
List <SPDayReportWrapper> spDayReports = SPDayReportWrapper.QueryReport(dfStart.SelectedDate, dfEnd.SelectedDate, this.Client);
storeSPDayReport.DataSource = spDayReports;
storeSPDayReport.DataBind();
this.lblTotalDownTotalCount.Text = spDayReports.Sum(p => p.DownTotalCount).ToString();
this.lblTotalDownSycnSuccess.Text = spDayReports.Sum(p => p.DownSycnSuccess).ToString();
this.lblTotalDownSycnFailed.Text = spDayReports.Sum(p => p.DownSycnFailed).ToString();
}
protected void storeSPDayReport_Refresh(object sender, StoreRefreshDataEventArgs e)
{
List <SPDayReportWrapper> spDayReports = SPDayReportWrapper.CaculateReport(System.DateTime.Now.Date, this.Client);
storeSPDayReport.DataSource = spDayReports;
storeSPDayReport.DataBind();
this.lblTotalDownTotalCount.Text = spDayReports.Sum(p => p.DownTotalCount).ToString();
this.lblTotalDownSycnSuccess.Text = spDayReports.Sum(p => p.DownSycnSuccess).ToString();
this.lblTotalDownSycnFailed.Text = spDayReports.Sum(p => p.DownSycnFailed).ToString();
}
private void BindData()
{
DataTable tb = SPDayReportWrapper.GetALlClientGroupPriceReport(StartDate.Date, EndDate.Date);
foreach (DataRow row in tb.Rows)
{
string moCode = "";
if (row["ClientID"] != null && row["ClientID"] != System.DBNull.Value && !string.IsNullOrEmpty(row["ClientID"].ToString()))
{
SPClientWrapper client = SPClientWrapper.FindById((int)row["ClientID"]);
if (client != null)
{
SPClientChannelSettingWrapper channelSetting = client.DefaultClientChannelSetting;
if (channelSetting != null)
{
moCode = channelSetting.MoCode;
}
}
}
row["ClientAliasName"] = row["ClientAliasName"] + " " + row["ClientID"].ToString() + " " + moCode;
}
ReportDataSource rds = new ReportDataSource("DataSet2", tb);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(rds);
ReportParameter rpStartDate = new ReportParameter();
rpStartDate.Name = "StartDate";
rpStartDate.Values.Add(StartDate.ToShortDateString());
ReportParameter rpEndDate = new ReportParameter();
rpEndDate.Name = "EndDate";
rpEndDate.Values.Add(EndDate.ToShortDateString());
ReportViewer1.LocalReport.SetParameters(
new ReportParameter[] { rpStartDate, rpEndDate });
ReportViewer1.LocalReport.Refresh();
}
private DataTable GetDataTable(int spClientId, int spClientGroupId)
{
DataTable dt = null;
if (spClientId > 0)
{
dt = SPDayReportWrapper.GetTodayReportByClientID(spClientId);
}
else
{
dt = SPDayReportWrapper.GetTodayReportByClientGroupID(spClientGroupId);
}
DataTable table = new DataTable();
table.Columns.AddRange(new DataColumn[] {
new DataColumn("CHour")
{
ColumnName = "CHour", DataType = typeof(string)
},
new DataColumn("Count")
{
ColumnName = "Count", DataType = typeof(int)
}
});
int chour = System.DateTime.Now.Hour;
for (int i = 0; i <= chour; i++)
{
DataRow[] drs;
drs = dt.Select(string.Format(" CHour = {0} ", i));
int count = 0;
if (drs.Length > 0)
{
foreach (DataRow dataRow in drs)
{
count += Convert.ToInt32(dataRow["Total"]);
}
}
table.Rows.Add(new object[] { i.ToString("D2") + ":00", count.ToString() });
}
return(table);
}
protected void storeData_Refresh(object sender, StoreRefreshDataEventArgs e)
{
DataTable dt = SPDayReportWrapper.GetProvinceCountReport(ChannleID, this.SPClientID, Convert.ToDateTime(this.StartDate), Convert.ToDateTime(this.EndDate), DType);
//object result = dt.Compute("Sum(DataCount)","");
//if (result != System.DBNull.Value)
// this.txtTotalCount.Text = "总计：0";
//else
// this.txtTotalCount.Text = "总计：" + result.ToString();
storeData.DataSource = dt;
storeData.DataBind();
}
protected override void ExecuteInternal(JobExecutionContext context)
{
logger.Info("日报表任务开始。。。");
try
{
SPDayReportWrapper.ReGenerateDayReport(DateTime.Now.AddDays(-1));
logger.Info("日报表任务成功。。。");
}
catch (Exception ex)
{
logger.Error("日报表任务失败:" + ex.Message);
}
}
private void BindData()
{
DataTable dt = SPDayReportWrapper.GetDayCountReportForMaster((DateTime)dfReportStartDate.DateField.Value, (DateTime)dfReportEndDate.DateField.Value);
if (dt.Columns["SPClientGroupName"] == null)
{
dt.Columns.Add("SPClientGroupName");
}
foreach (DataRow dataRow in dt.Rows)
{
if (dataRow["ClientID"] == System.DBNull.Value || dataRow["ClientID"].Equals(0))
{
dataRow["SPClientGroupName"] = "";
}
else if (dataRow["ClientGroupID"] != System.DBNull.Value && !dataRow["ClientGroupID"].Equals(0))
{
SPClientGroupWrapper clientGroupWrapper = SPClientGroupWrapper.FindById((int)dataRow["ClientGroupID"]);
if (clientGroupWrapper != null)
{
dataRow["SPClientGroupName"] = clientGroupWrapper.Name;
}
else
{
dataRow["SPClientGroupName"] = "";
}
}
else
{
SPClientWrapper clientWrapper = SPClientWrapper.FindById((int)dataRow["ClientID"]);
if (clientWrapper != null)
{
dataRow["SPClientGroupName"] = clientWrapper.ClientGroupName;
}
else
{
dataRow["SPClientGroupName"] = "";
}
}
}
this.Store1.DataSource = dt;
this.Store1.DataBind();
}
private void BindData()
{
DataTable tb = SPDayReportWrapper.GetALlChannelReport(StartDate.Date, EndDate.Date);
tb.Columns.Add("UpperName");
tb.Columns.Add("ChannelName");
tb.Columns.Add("MoCode");
tb.AcceptChanges();
foreach (DataRow row in tb.Rows)
{
SPClientChannelSettingWrapper spClientChannelSetting =
SPClientChannelSettingWrapper.FindById(Convert.ToInt32(row["ChannelClientID"]));
row.BeginEdit();
row["UpperName"] = spClientChannelSetting.ChannelID.UperName;
row["ChannelName"] = spClientChannelSetting.ChannelID.Name;
row["MoCode"] = spClientChannelSetting.MoCode;
row.EndEdit();
}
tb.AcceptChanges();
ReportDataSource rds = new ReportDataSource("DataSet1", tb);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(rds);
string reportName = string.Format("【{0}】-【{1}】上家结算报表", StartDate.ToString("yyyy-MM-dd"), EndDate.ToString("yyyy-MM-dd"));
ReportParameter rpReportName = new ReportParameter();
rpReportName.Name = "ReportName";
rpReportName.Values.Add(reportName);
ReportViewer1.LocalReport.SetParameters(
new ReportParameter[] { rpReportName });
ReportViewer1.LocalReport.Refresh();
}
private void BindData()
{
DataTable tb = SPDayReportWrapper.GetReportDataChange(ReportClientChannleID, StartDate, EndDate);
ReportDataSource rds = new ReportDataSource("DayReport", tb);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(rds);
SPClientChannelSettingWrapper channelSettingWrapper = SPClientChannelSettingWrapper.FindById(ReportClientChannleID);
ReportParameter rpClientChannleID = new ReportParameter();
rpClientChannleID.Name = "ReportClientChannleID";
rpClientChannleID.Values.Add(ReportClientChannleID.ToString());
ReportParameter rpStartDate = new ReportParameter();
rpStartDate.Name = "StartDate";
rpStartDate.Values.Add(StartDate.ToShortDateString());
ReportParameter rpEndDate = new ReportParameter();
rpEndDate.Name = "EndDate";
rpEndDate.Values.Add(EndDate.ToShortDateString());
ReportParameter rpChannelName = new ReportParameter();
rpChannelName.Name = "ReportChannelName";
rpChannelName.Values.Add(channelSettingWrapper.ChannelName);
ReportParameter rpCodeName = new ReportParameter();
rpCodeName.Name = "ReportCodeName";
rpCodeName.Values.Add(string.Format("下家[{0} 指令 [{1}]", channelSettingWrapper.ClientName, channelSettingWrapper.ChannelClientCode));
ReportViewer1.LocalReport.SetParameters(
new ReportParameter[] { rpClientChannleID, rpStartDate, rpEndDate, rpChannelName, rpCodeName });
ReportViewer1.LocalReport.Refresh();
}
private DataTable GetDataTable(int clientID, int channelID, string province)
{
DataTable dt = SPDayReportWrapper.GetTodayReportByProvince(clientID, channelID, province);
DataTable table = new DataTable();
table.Columns.AddRange(new DataColumn[] {
new DataColumn("CHour")
{
ColumnName = "CHour", DataType = typeof(string)
},
new DataColumn("Count")
{
ColumnName = "Count", DataType = typeof(int)
}
});
int chour = System.DateTime.Now.Hour;
for (int i = 0; i <= chour; i++)
{
DataRow[] drs;
if (channelID != 0)
{
drs = dt.Select(string.Format(" ChannelID = {0} and ClientID = {1} and CHour = {2} ", channelID, clientID, i));
}
else
{
drs = dt.Select(string.Format(" ClientID = {1} and CHour = {2} ", channelID, clientID, i));
}
int count = 0;
if (drs.Length > 0)
{
if (drs[0]["Total"] != System.DBNull.Value)
{
count = Convert.ToInt32(drs[0]["Total"]);
}
}
table.Rows.Add(new object[] { i.ToString("D2") + ":00", count.ToString() });
}
return(table);
}
private bool ReGenerateDayReport()
{
try
{
SPDayReportWrapper.ReGenerateDayReport(DateTime.Now.AddDays(-1));
logger.Info("日报表任务成功。。。");
return(true);
}
catch (Exception ex)
{
logger.Error("日报表任务失败:" + ex.Message);
return(false);
}
}
protected void StartLongAction(object sender, AjaxEventArgs e)
{
Server.ScriptTimeout = 300;
try
{
//SPDayReportWrapper.ArchivesData(this.Server.MapPath("~/DayReport/"), );
SPDayReportWrapper.ReGenerateDayReport(Convert.ToDateTime(this.dfStart.Value), Convert.ToDateTime(this.dfEnd.Value));
Coolite.Ext.Web.ScriptManager.AjaxSuccess = true;
}
catch (Exception ex)
{
Coolite.Ext.Web.ScriptManager.AjaxSuccess = false;
Coolite.Ext.Web.ScriptManager.AjaxErrorMessage = "错误信息：" + ex.Message;
}
}
public void FromWrapper(SPDayReportWrapper wrapper)
{
this.ReportID = wrapper.ReportID;
this.ReportDate = wrapper.ReportDate;
this.UpTotalCount = wrapper.UpTotalCount;
this.UpSuccess = wrapper.UpSuccess;
this.InterceptTotalCount = wrapper.InterceptTotalCount;
this.InterceptSuccess = wrapper.InterceptSuccess;
this.DownTotalCount = wrapper.DownTotalCount;
this.DownSuccess = wrapper.DownSuccess;
this.DayXmlFileName = wrapper.DayXmlFileName;
this.ClientID = wrapper.ClientID;
this.ChannelID = wrapper.ChannelID;
this.ChannelClientID = wrapper.ChannelClientID;
this.UperID = wrapper.UperID;
this.ClientGroupID = wrapper.ClientGroupID;
}
private void BindData()
{
ReportViewer1.LocalReport.EnableHyperlinks = true;
DataTable tb = SPDayReportWrapper.GetProvinceReport(StartDate, EndDate, ReportChannleID, ReportClientChannleID);
ReportDataSource rds = new ReportDataSource("DataSet1", tb);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(rds);
string reportName = string.Format("【{0}】-【{1}】数据省份分部报表", StartDate.ToString("yyyy-MM-dd"), EndDate.ToString("yyyy-MM-dd"));
if (ReportChannleID == 0)
{
reportName = "全平台" + reportName;
}
else
{
SPChannelWrapper channel = SPChannelWrapper.FindById(ReportChannleID);
if (ReportClientChannleID == 0)
{
reportName = string.Format("通道【{0}】", channel.Name) + reportName;
}
else
{
SPClientChannelSettingWrapper clientChannelSetting = SPClientChannelSettingWrapper.FindById(ReportClientChannleID);
reportName = string.Format("通道【{0}】", channel.Name) + string.Format("指令【{0}】", clientChannelSetting.MoCode) + reportName;
}
}
ReportParameter rpReportName = new ReportParameter();
rpReportName.Name = "ReportName";
rpReportName.Values.Add(reportName);
ReportViewer1.LocalReport.SetParameters(
new ReportParameter[] { rpReportName });
ReportViewer1.LocalReport.Refresh();
}
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"));
}
private void BindData()
{
//DataTable dt = SPDayReportWrapper.GetDayliyReport(Convert.ToDateTime(dfReportDate.DateField.Value));
DataTable dt = SPDayReportWrapper.GetDayCountReportForMaster((DateTime)dfReportDate.DateField.Value, (DateTime)dfReportDate.DateField.Value);
if (dt.Columns["SPClientGroupName"] == null)
{
dt.Columns.Add("SPClientGroupName");
}
foreach (DataRow dataRow in dt.Rows)
{
if (dataRow["ClientID"] == System.DBNull.Value || dataRow["ClientID"].Equals(0))
{
dataRow["SPClientGroupName"] = "";
}
else
{
SPClientWrapper clientWrapper = SPClientWrapper.FindById((int)dataRow["ClientID"]);
if (clientWrapper != null)
{
dataRow["SPClientGroupName"] = clientWrapper.ClientGroupName;
}
else
{
dataRow["SPClientGroupName"] = "";
}
}
}
this.Store1.DataSource = dt;
this.Store1.DataBind();
this.Store1.DataSource = dt;
this.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"));
}
public SPDayReportWrapper ToWrapper()
{
SPDayReportWrapper wrapper = new SPDayReportWrapper();
wrapper.ReportID = this.ReportID;
wrapper.ReportDate = this.ReportDate;
wrapper.UpTotalCount = this.UpTotalCount;
wrapper.UpSuccess = this.UpSuccess;
wrapper.InterceptTotalCount = this.InterceptTotalCount;
wrapper.InterceptSuccess = this.InterceptSuccess;
wrapper.DownTotalCount = this.DownTotalCount;
wrapper.DownSuccess = this.DownSuccess;
wrapper.DayXmlFileName = this.DayXmlFileName;
wrapper.ClientID = this.ClientID;
wrapper.ChannelID = this.ChannelID;
wrapper.ChannelClientID = this.ChannelClientID;
wrapper.UperID = this.UperID;
wrapper.ClientGroupID = this.ClientGroupID;
return(wrapper);
}
private void BindData()
{
int channleID = 0;
//if (this.cmbChannelID.SelectedItem!=null)
//{
// if (!string.IsNullOrEmpty(this.cmbChannelID.SelectedItem.Value))
// channleID = int.Parse(this.cmbChannelID.SelectedItem.Value);
// else
// channleID = 0;
//}
DataTable dt = SPDayReportWrapper.GetCountReportForMaster(channleID, (DateTime)dfReportStartDate.DateField.Value, (DateTime)dfReportEndDate.DateField.Value);
this.Store1.DataSource = dt;
this.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"));
}
private void BindData()
{
DataTable tb = SPDayReportWrapper.QueryRecordProvine(StartDate, EndDate, DataType, ChannelID, CodeID, ClientID).Tables[0];
ReportDataSource rds = new ReportDataSource("DataSet1", tb);
rptvContainer.LocalReport.DataSources.Clear();
rptvContainer.LocalReport.DataSources.Add(rds);
string reportName = string.Format("【{0}】-【{1}】数据省份分布报表", StartDate.Value.ToString("yyyy-MM-dd"), EndDate.Value.ToString("yyyy-MM-dd"));
ReportParameter rpReportName = new ReportParameter();
rpReportName.Name = "ReportName";
rpReportName.Values.Add(reportName);
rptvContainer.LocalReport.SetParameters(
new ReportParameter[] { rpReportName });
rptvContainer.LocalReport.Refresh();
}
private void BindData()
{
DataTable tb = SPDayReportWrapper.GetClientGroupTotalReport(StartDate.Date, EndDate.Date);
ReportDataSource rds = new ReportDataSource("DataSet1", tb);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(rds);
string reportName = string.Format("【{0}】-【{1}】下家结算报表", StartDate.ToString("yyyy-MM-dd"), EndDate.ToString("yyyy-MM-dd"));
ReportParameter rpReportName = new ReportParameter();
rpReportName.Name = "ReportName";
rpReportName.Values.Add(reportName);
ReportViewer1.LocalReport.SetParameters(
new ReportParameter[] { rpReportName });
ReportViewer1.LocalReport.Refresh();
}
protected void store1_Refresh(object sender, StoreRefreshDataEventArgs e)
{
//int recordCount = 0;
//string sortFieldName = "";
//if (e.Sort != null)
// sortFieldName = e.Sort;
//int startIndex = 0;
//if (e.Start > -1)
//{
// startIndex = e.Start;
//}
//int limit = this.PagingToolBar1.PageSize;
//int pageIndex = 1;
//if ((startIndex % limit) == 0)
// pageIndex = startIndex / limit + 1;
//else
// pageIndex = startIndex / limit;
int channelID = 0;
DateTime startDate = Convert.ToDateTime(this.dfReportStartDate.DateField.Value);
if (startDate < GetDT())
{
startDate = GetDT();
}
DataTable tb = SPDayReportWrapper.GetCountReport(channelID, this.SPClientID, startDate.Date, Convert.ToDateTime(this.dfReportEndDate.DateField.Value).Date);
store1.DataSource = tb;
store1.DataBind();
}
private void BindData()
{
DataTable tb = SPDayReportWrapper.QueryChannelInvoiceReport(StartDate, EndDate, ChannelID, CodeID).Tables[0];
string channelName = "所有";
if (ChannelID.HasValue && ChannelID > 0)
{
channelName = "【" + SPChannelWrapper.FindById(ChannelID.Value).Name + "】";
}
string codeName = "";
if (CodeID.HasValue && CodeID > 0)
{
codeName = "【" + SPCodeWrapper.FindById(CodeID.Value).MoCode + "】指令";
}
string reportName = string.Format("【{0}】-【{1}】 {2} 通道 {3} 结算报表", StartDate.Value.ToString("yyyy-MM-dd"),
EndDate.Value.ToString("yyyy-MM-dd"), channelName, codeName);
ReportViewHelper.BindDataTableToReport(rptvContainer, tb, "DataSet1", reportName);
}
private void BindData()
{
DataTable tb = SPDayReportWrapper.GetClientGroupPriceReport(ClientGroupID, StartDate.Date, EndDate.Date);
ReportDataSource rds = new ReportDataSource("DataSet1", tb);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(rds);
SPClientGroupWrapper clientGroupWrapper = SPClientGroupWrapper.FindById(ClientGroupID);
ReportParameter rpName = new ReportParameter();
rpName.Name = "ReportClientGroupName";
rpName.Values.Add(clientGroupWrapper.Name);
ReportParameter rpStartDate = new ReportParameter();
rpStartDate.Name = "ReportStartDate";
rpStartDate.Values.Add(StartDate.ToShortDateString());
ReportParameter rpEndDate = new ReportParameter();
rpEndDate.Name = "ReportEndDate";
rpEndDate.Values.Add(EndDate.ToShortDateString());
ReportViewer1.LocalReport.SetParameters(
new ReportParameter[] { rpName, rpStartDate, rpEndDate });
ReportViewer1.LocalReport.Refresh();
}
public void ReGenerateDayReportByDate(DateTime reportDate)
{
SPDayReportWrapper.ReGenerateDayReport(reportDate.Date);
}
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"));
}
private void BindData()
{
DataTable tb = SPDayReportWrapper.GetClientGroupDayReport(StartDate.Date, EndDate.Date, ClientGroupID);
DataTable rtp = tb.Clone();
foreach (DataRow row in tb.Rows)
{
if (row["ClientGroupID"] != System.DBNull.Value)
{
int clientGroupID = (int)row["ClientGroupID"];
if (clientGroupID == ClientGroupID)
{
rtp.ImportRow(row);
}
}
}
rtp.AcceptChanges();
rtp.Columns.Add("CodeName");
rtp.Columns.Add("Price", typeof(decimal));
rtp.Columns.Add("Amount", typeof(decimal));
rtp.AcceptChanges();
foreach (DataRow row in rtp.Rows)
{
int channleClientID = (int)row["ChannleClientID"];
int recordCount = (int)row["RecordCount"];
SPClientChannelSettingWrapper clientChannelSetting =
SPClientChannelSettingWrapper.FindById(channleClientID);
row.BeginEdit();
row["CodeName"] = clientChannelSetting.ClinetID.Alias;
row["Price"] = clientChannelSetting.ClinetID.Price;
row["Amount"] = clientChannelSetting.ClinetID.Price * recordCount;
row.EndEdit();
}
rtp.AcceptChanges();
SPClientGroupWrapper clientGroup = SPClientGroupWrapper.FindById(ClientGroupID);
string reportName = string.Format("下家组【{2}】 【{0}】-【{1}】结算报表", StartDate.ToString("yyyy-MM-dd"), EndDate.ToString("yyyy-MM-dd"), clientGroup.Name);
ReportDataSource rds = new ReportDataSource("DataSet1", rtp);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(rds);
SPClientGroupWrapper clientGroupWrapper = SPClientGroupWrapper.FindById(ClientGroupID);
ReportParameter rpName = new ReportParameter();
rpName.Name = "ReportName";
rpName.Values.Add(reportName);
ReportViewer1.LocalReport.SetParameters(
new ReportParameter[] { rpName });
ReportViewer1.LocalReport.Refresh();
}
private void BindData()
{
DataTable tb = null;
if (ReportType == "1")
{
tb = SPDayReportWrapper.GetProvinceCityReport(StartDate, EndDate, ReportID, ReportClientChannleID, Province);
}
else if (ReportType == "2")
{
tb = SPDayReportWrapper.GetProvinceCityReportForClientGroup(StartDate, EndDate, ReportID, ReportClientChannleID, Province);
}
ReportDataSource rds = new ReportDataSource("DataSet1", tb);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(rds);
string reporttypeName = "";
if (ReportType == "1")
{
reporttypeName = "通道";
}
else if (ReportType == "2")
{
reporttypeName = "下家组";
}
string reportName = string.Format("【{0}】-【{1}】数据分部报表", StartDate.ToString("yyyy-MM-dd"), EndDate.ToString("yyyy-MM-dd"));
if (ReportID == 0)
{
reportName = "全平台" + reportName;
}
else
{
string name = "";
if (ReportType == "1")
{
name = SPChannelWrapper.FindById(ReportID).Name;
}
else if (ReportType == "2")
{
name = SPClientGroupWrapper.FindById(ReportID).Name;
}
if (ReportClientChannleID == 0)
{
reportName = string.Format(reporttypeName + "【{0}】", name) + reportName;
}
else
{
SPClientChannelSettingWrapper clientChannelSetting = SPClientChannelSettingWrapper.FindById(ReportClientChannleID);
reportName = string.Format(reporttypeName + "【{0}】", name) + string.Format("指令【{0}】", clientChannelSetting.MoCode) + reportName;
}
}
ReportParameter rpReportName = new ReportParameter();
rpReportName.Name = "ReportName";
rpReportName.Values.Add(reportName);
ReportViewer1.LocalReport.SetParameters(
new ReportParameter[] { rpReportName });
ReportViewer1.LocalReport.Refresh();
}
public void ReGenerateDayReportByDateRange(DateTime startDate, DateTime endDate)
{
SPDayReportWrapper.ReGenerateDayReport(startDate.Date, endDate.Date);
}
