protected void Page_Load(object sender, EventArgs e)
{
if (Ext.IsAjaxRequest)
{
return;
}
int id = this.ClientGroupID;
this.dfReportEndDate.DateField.Value = System.DateTime.Now.Date;
this.dfReportStartDate.DateField.Value = System.DateTime.Now.Date;
SPClientGroupWrapper spClientGroupWrapper = SPClientGroupWrapper.FindById(this.ClientGroupID);
this.dfReportStartDate.DateField.MinDate = spClientGroupWrapper.GetDT();
storeSPClient.BaseParams.Add(new Coolite.Ext.Web.Parameter("ClientGroupID", id.ToString(), ParameterMode.Value));
this.hidId.Text = id.ToString();
}
protected void btnSaveSPClientGroup_Click(object sender, AjaxEventArgs e)
{
try
{
SPClientGroupWrapper obj = SPClientGroupWrapper.FindById(int.Parse(hidId.Text.Trim()));
obj.Name = this.txtName.Text.Trim();
obj.Description = this.txtDescription.Text.Trim();
obj.DefaultSycnMoUrl = this.txtDefaultSycnMoUrl.Text.Trim();
obj.DefaultInterceptRate = Convert.ToInt32(this.txtDefaultInterceptRate.Text);
obj.DefaultNoInterceptCount = Convert.ToInt32(this.txtDefaultNoInterceptCount.Text);
SPClientGroupWrapper.Update(obj);
winSPClientGroupEdit.Hide();
}
catch (Exception ex)
{
Coolite.Ext.Web.ScriptManager.AjaxSuccess = false;
Coolite.Ext.Web.ScriptManager.AjaxErrorMessage = "错误信息：" + ex.Message;
return;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Ext.IsAjaxRequest)
{
return;
}
this.gridPanelSPClient.Reload();
this.btnAddToClientGroup.Hidden = (ClientGroupID <= 0);
if (ClientGroupID > 0)
{
this.winSPClientAddToGroup.Title = "添加下家到下家组'" + SPClientGroupWrapper.FindById(ClientGroupID).Name + "'";
this.winSPClientAddToGroup.AutoLoad.Params.Clear();
this.winSPClientAddToGroup.AutoLoad.Params.Add(new Parameter("ClientGroupID", ClientGroupID.ToString(),
ParameterMode.Value));
this.txtSreachName.Hide();
}
}
public void Show(int id)
{
try
{
SPClientGroupWrapper obj = SPClientGroupWrapper.FindById(id);
if (obj != null)
{
//this.lblChannelClientCode.Text = obj.ChannelClientCode;
//this.lblChannelName.Text = obj.ChannelName;
//this.lblClientGroupName.Text = obj.ClientGroupName;
this.lblName.Text = obj.Name;
this.lblResult.Text = "";
hidId.Text = id.ToString();
winSPClientGroupQuery.Show();
}
else
{
ScriptManager.AjaxSuccess = false;
ScriptManager.AjaxErrorMessage = "错误信息：数据不存在";
return;
}
}
catch (Exception ex)
{
Coolite.Ext.Web.ScriptManager.AjaxSuccess = false;
Coolite.Ext.Web.ScriptManager.AjaxErrorMessage = "错误信息：" + ex.Message;
return;
}
}
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();
}
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;
}
List <SPPaymentInfoWrapper> list = null;
DateTime startDate = Convert.ToDateTime(this.dfReportStartDate.DateField.Value);
SPClientGroupWrapper spClientGroupWrapper = SPClientGroupWrapper.FindById(this.ClientGroupID);
if (startDate < spClientGroupWrapper.GetDT())
{
startDate = spClientGroupWrapper.GetDT();
}
string province = "";
if (this.cmbProvince.SelectedItem != null)
{
province = this.cmbProvince.SelectedItem.Value;
}
string city = "";
if (!string.IsNullOrEmpty(this.txtCity.Text.Trim()))
{
city = this.txtCity.Text.Trim();
}
string phone = "";
if (!string.IsNullOrEmpty(this.txtMoblie.Text.Trim()))
{
phone = this.txtMoblie.Text.Trim();
}
if (SPClientID > 0)
{
list = SPPaymentInfoWrapper.FindAllByOrderByAndCleintIDAndChanneLIDAndDateAndProviceNoIntercept(ChannelID, SPClientID, startDate, Convert.ToDateTime(this.dfReportEndDate.DateField.Value), province, city, phone, sortFieldName, (e.Dir == Coolite.Ext.Web.SortDirection.DESC), pageIndex, limit, out recordCount);
}
else
{
list = SPPaymentInfoWrapper.FindAllByOrderByAndSPClientGroupIDAndDateAndProviceNoIntercept(SPClientGroupID, startDate, Convert.ToDateTime(this.dfReportEndDate.DateField.Value), province, city, phone, sortFieldName, (e.Dir == Coolite.Ext.Web.SortDirection.DESC), pageIndex, limit, out recordCount);
}
store1.DataSource = list;
e.TotalCount = recordCount;
store1.DataBind();
}
protected void storeSPChannelGroup_Refresh(object sender, StoreRefreshDataEventArgs e)
{
this.storeSPChannelGroup.DataSource = SPClientGroupWrapper.FindAll();
this.storeSPChannelGroup.DataBind();
}
protected void btnSaveSPClient_Click(object sender, AjaxEventArgs e)
{
try
{
SPClientWrapper obj = SPClientWrapper.FindById(int.Parse(hidId.Text.Trim()));
int oldClientGroupID = 0;
if (obj.SPClientGroupID != null)
{
oldClientGroupID = obj.SPClientGroupID.Id;
}
obj.Name = this.txtName.Text.Trim();
obj.Alias = this.txtAlias.Text.Trim();
obj.Description = this.txtDescription.Text.Trim();
if (ClientGroupID <= 0)
{
if (this.cmbClientGroupID.SelectedItem != null)
{
obj.SPClientGroupID =
SPClientGroupWrapper.FindById(Convert.ToInt32(this.cmbClientGroupID.SelectedItem.Value));
}
}
else
{
obj.SPClientGroupID = SPClientGroupWrapper.FindById(ClientGroupID);
}
SPClientWrapper.Update(obj);
int newClientGroupID = 0;
if (obj.SPClientGroupID != null)
{
newClientGroupID = obj.SPClientGroupID.Id;
}
if (newClientGroupID != 0 && oldClientGroupID != newClientGroupID)
{
obj.UpdateSyncDataSetting();
}
obj.SetClientPrice(Convert.ToDecimal(numPrice.Value));
//if (obj.SPClientGroupID != null && obj.DefaultClientChannelSetting != null)
//{
// obj.DefaultClientChannelSetting.SyncDataUrl = this.txtSyncDataUrl.Text;
// SPClientChannelSettingWrapper.Update(obj.DefaultClientChannelSetting);
//}
winSPClientEdit.Hide();
}
catch (Exception ex)
{
Coolite.Ext.Web.ScriptManager.AjaxSuccess = false;
Coolite.Ext.Web.ScriptManager.AjaxErrorMessage = "错误信息：" + ex.Message;
return;
}
}
protected void storeSPClient_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;
}
List <QueryFilter> queryFilters = new List <QueryFilter>();
string clientName = "";
if (!string.IsNullOrEmpty(this.txtSreachName.Text.Trim()))
{
clientName = this.txtSreachName.Text.Trim();
queryFilters.Add(new QueryFilter(SPClientWrapper.PROPERTY_NAME_NAME, clientName, FilterFunction.Contains));
}
if (ClientGroupID > 0)
{
storeSPClient.DataSource = SPClientWrapper.FindAllByOrderByAndFilterAndSPClientGroupID(sortFieldName, (e.Dir == SortDirection.DESC), pageIndex, limit, SPClientGroupWrapper.FindById(this.ClientGroupID), out recordCount);
}
else
{
storeSPClient.DataSource = SPClientWrapper.FindAllByOrderByAndFilter(queryFilters, sortFieldName, (e.Dir == SortDirection.DESC), pageIndex, limit, out recordCount);
}
e.TotalCount = recordCount;
storeSPClient.DataBind();
}
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 SPClientGroupWrapper ToWrapper()
{
SPClientGroupWrapper wrapper = new SPClientGroupWrapper();
wrapper.Id = this.Id;
wrapper.Name = this.Name;
wrapper.Description = this.Description;
wrapper.UserID = this.UserID;
wrapper.DefaultSycnMoUrl = this.DefaultSycnMoUrl;
wrapper.DefaultSycnMRUrl = this.DefaultSycnMRUrl;
return wrapper;
}
public void FromWrapper(SPClientGroupWrapper wrapper)
{
this.Id = wrapper.Id;
this.Name = wrapper.Name;
this.Description = wrapper.Description;
this.UserID = wrapper.UserID;
this.DefaultSycnMoUrl = wrapper.DefaultSycnMoUrl;
this.DefaultSycnMRUrl = wrapper.DefaultSycnMRUrl;
}
protected void btnSaveSPClient_Click(object sender, AjaxEventArgs e)
{
try
{
//string loginID = this.txtRelateUserLoginID.Text.Trim();
//if (SystemUserWrapper.GetUserByLoginID(loginID) != null)
//{
// Coolite.Ext.Web.ScriptManager.AjaxSuccess = false;
// Coolite.Ext.Web.ScriptManager.AjaxErrorMessage = "错误信息：用户登录ID已存在！";
// return;
//}
SPClientWrapper obj = new SPClientWrapper();
obj.Name = this.txtName.Text.Trim();
obj.Alias = this.txtAlias.Text.Trim();
obj.IsDefaultClient = false;
obj.Description = this.txtDescription.Text.Trim();
if (ClientGroupID <= 0)
{
obj.SPClientGroupID =
SPClientGroupWrapper.FindById(Convert.ToInt32(this.cmbClientGroupID.SelectedItem.Value));
}
else
{
obj.SPClientGroupID = SPClientGroupWrapper.FindById(ClientGroupID);
}
//obj.RecieveDataUrl = this.txtRecieveDataUrl.Text.Trim();
//obj.SyncData = this.chkSyncDate.Checked;
//obj.OkMessage = this.txtOkMessage.Text.Trim();
//obj.FailedMessage = this.txtFailedMessage.Text.Trim();
//obj.SyncType = this.cmbSycnType.SelectedItem.Value;
//Membership.CreateUser(loginID, this.txtRelateUserPassword.Text.Trim(), this.txtRelateUserLoginID.Text.Trim()+"@163.com");
//SystemUserWrapper clientUser = SystemUserWrapper.GetUserByLoginID(loginID);
//clientUser.UserName = loginID;
//SystemUserWrapper.Update(clientUser);
//SystemRoleWrapper clientRole = SystemRoleWrapper.GetRoleByName("SPDownUser");
//SystemUserWrapper.PatchAssignUserRoles(clientUser, new List<string> { clientRole.RoleID.ToString() });
//obj.UserID = clientUser.UserID;
SPClientWrapper.Save(obj);
winSPClientAdd.Hide();
}
catch (Exception ex)
{
Coolite.Ext.Web.ScriptManager.AjaxSuccess = false;
Coolite.Ext.Web.ScriptManager.AjaxErrorMessage = "错误信息：" + ex.Message;
}
}
protected void storeSPClient_Refresh(object sender, StoreRefreshDataEventArgs e)
{
this.storeSPClient.DataSource = SPClientWrapper.FindAllBySPClientGroupID(SPClientGroupWrapper.FindById(SPClientGroupID));
this.storeSPClient.DataBind();
}
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();
}
protected void btnSaveSPClient_Click(object sender, AjaxEventArgs e)
{
try
{
SPClientWrapper obj = SPClientWrapper.FindById(int.Parse(hidId.Text.Trim()));
int oldClientGroupID = 0;
if (obj.SPClientGroupID != null)
{
oldClientGroupID = obj.SPClientGroupID.Id;
}
obj.Name = this.txtName.Text.Trim();
obj.Alias = this.txtAlias.Text.Trim();
obj.Description = this.txtDescription.Text.Trim();
if (ClientGroupID <= 0)
{
if (this.cmbClientGroupID.SelectedItem != null)
{
obj.SPClientGroupID =
SPClientGroupWrapper.FindById(Convert.ToInt32(this.cmbClientGroupID.SelectedItem.Value));
}
}
else
{
obj.SPClientGroupID = SPClientGroupWrapper.FindById(ClientGroupID);
}
SPClientWrapper.Update(obj);
int newClientGroupID = 0;
if (obj.SPClientGroupID != null)
{
newClientGroupID = obj.SPClientGroupID.Id;
}
if (newClientGroupID != 0 && oldClientGroupID != newClientGroupID)
{
int interceptRate = 15;
if (rgdCustomIntercept.Checked)
{
interceptRate = Convert.ToInt32(numCustomerIntercept.Value);
}
if (rgdDefaultChannelIntercept.Checked)
{
if (obj.DefaultClientChannelSetting.ChannelID.Rate.HasValue)
{
interceptRate = obj.DefaultClientChannelSetting.ChannelID.Rate.Value;
}
else
{
interceptRate = 15;
}
}
if (rgdDefaultClientIntercept.Checked)
{
interceptRate = obj.SPClientGroupID.DefaultInterceptRate;
}
obj.UpdateSyncDataSetting(interceptRate);
}
//更新为通道价格
//if (obj.DefaultClientChannelSetting != null && obj.DefaultClientChannelSetting.ChannelID != null && obj.DefaultClientChannelSetting.ChannelID.Price.HasValue)
// obj.SetClientPrice(obj.DefaultClientChannelSetting.ChannelID.Price.Value);
//else
obj.SetClientPrice(Convert.ToDecimal(numPrice.Value));
winSPClientEdit.Hide();
}
catch (Exception ex)
{
Coolite.Ext.Web.ScriptManager.AjaxSuccess = false;
Coolite.Ext.Web.ScriptManager.AjaxErrorMessage = "错误信息：" + ex.Message;
return;
}
}
