private BalanceDetailQuery GetQuery()
{
int pageIndex;
if (!int.TryParse(this.Page.Request.QueryString["page"], out pageIndex))
{
pageIndex = 1;
}
int pageSize;
if (!int.TryParse(this.Page.Request.QueryString["size"], out pageSize))
{
pageSize = 10;
}
BalanceDetailQuery balanceDetailQuery = new BalanceDetailQuery();
balanceDetailQuery.UserId = new int?(HiContext.Current.User.UserId);
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["dataStart"]))
{
balanceDetailQuery.FromDate = new System.DateTime?(System.Convert.ToDateTime(this.Page.Server.UrlDecode(this.Page.Request.QueryString["dataStart"])));
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["dataEnd"]))
{
balanceDetailQuery.ToDate = new System.DateTime?(System.Convert.ToDateTime(this.Page.Server.UrlDecode(this.Page.Request.QueryString["dataEnd"])));
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["splittingtype"]))
{
balanceDetailQuery.SplittingTypes = (SplittingTypes)System.Convert.ToInt32(this.Page.Server.UrlDecode(this.Page.Request.QueryString["splittingtype"]));
}
balanceDetailQuery.PageIndex = pageIndex;
balanceDetailQuery.PageSize = pageSize;
return(balanceDetailQuery);
}
private void btnCreateReport_Click(object sender, EventArgs e)
{
BalanceDetailQuery query = new BalanceDetailQuery();
query.UserName = this.userName;
query.FromDate = this.dateStart;
query.ToDate = this.dateEnd;
query.SortBy = "TradeDate";
query.SortOrder = SortAction.Desc;
query.TradeType = TradeTypes.DrawRequest;
DbQueryResult distributorBalanceDetailsNoPage = DistributorHelper.GetDistributorBalanceDetailsNoPage(query);
string s = ((string.Empty + "用户名") + ",交易时间" + ",业务摘要") + ",转出金额" + ",当前余额\r\n";
foreach (DataRow row in ((DataTable)distributorBalanceDetailsNoPage.Data).Rows)
{
s = s + row["UserName"];
s = s + "," + row["TradeDate"];
s = s + ",提现";
s = s + "," + row["Expenses"];
object obj2 = s;
s = string.Concat(new object[] { obj2, ",", row["Balance"], "\r\n" });
}
this.Page.Response.Clear();
this.Page.Response.Buffer = false;
this.Page.Response.Charset = "GB2312";
this.Page.Response.AppendHeader("Content-Disposition", "attachment;filename=DistributionBalanceDetailsStatistics.csv");
this.Page.Response.ContentEncoding = Encoding.GetEncoding("GB2312");
this.Page.Response.ContentType = "application/octet-stream";
this.Page.EnableViewState = false;
this.Page.Response.Write(s);
this.Page.Response.End();
}
private BalanceDetailQuery GetQuery()
{
BalanceDetailQuery balanceDetailQuery = new BalanceDetailQuery();
balanceDetailQuery.UserId = new int?(HiContext.Current.User.UserId);
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["dataStart"]))
{
balanceDetailQuery.FromDate = new System.DateTime?(System.Convert.ToDateTime(this.Page.Server.UrlDecode(this.Page.Request.QueryString["dataStart"])));
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["dataEnd"]))
{
balanceDetailQuery.ToDate = new System.DateTime?(System.Convert.ToDateTime(this.Page.Server.UrlDecode(this.Page.Request.QueryString["dataEnd"])));
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["splittingtype"]))
{
balanceDetailQuery.SplittingTypes = (SplittingTypes)System.Convert.ToInt32(this.Page.Server.UrlDecode(this.Page.Request.QueryString["splittingtype"]));
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["orderid"]))
{
balanceDetailQuery.OrderId = this.Page.Request.QueryString["orderid"];
}
balanceDetailQuery.PageIndex = this.pager.PageIndex;
balanceDetailQuery.PageSize = this.pager.PageSize;
return(balanceDetailQuery);
}
public override DbQueryResult GetMyBalanceDetails(BalanceDetailQuery query)
{
if (null == query)
{
return new DbQueryResult();
}
DbQueryResult result = new DbQueryResult();
StringBuilder builder = new StringBuilder();
string str = BuildBalanceDetailsQuery(query);
builder.AppendFormat("select top {0} B.JournalNumber,B.UserId,B.UserName, B.TradeDate,B.TradeType,B.Income,B.Expenses,B.Balance,B.Remark", query.PageSize);
builder.Append(" from Hishop_DistributorBalanceDetails B where 0=0 ");
if (query.PageIndex == 1)
{
builder.AppendFormat("{0} ORDER BY JournalNumber DESC", str);
}
else
{
builder.AppendFormat(" and JournalNumber < (select min(JournalNumber) from (select top {0} JournalNumber from Hishop_DistributorBalanceDetails where 0=0 {1} ORDER BY JournalNumber DESC ) as tbltemp) {1} ORDER BY JournalNumber DESC", (query.PageIndex - 1) * query.PageSize, str);
}
if (query.IsCount)
{
builder.AppendFormat(";select count(JournalNumber) as Total from Hishop_DistributorBalanceDetails where 0=0 {0}", str);
}
DbCommand sqlStringCommand = this.database.GetSqlStringCommand(builder.ToString());
using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand))
{
result.Data = DataHelper.ConverDataReaderToDataTable(reader);
if (query.IsCount && reader.NextResult())
{
reader.Read();
result.TotalRecords = reader.GetInt32(0);
}
}
return result;
}
static string BuildBalanceDetailsQuery(BalanceDetailQuery query)
{
StringBuilder builder = new StringBuilder();
if (query.UserId.HasValue)
{
builder.AppendFormat(" AND UserId = {0}", query.UserId.Value);
}
if (!string.IsNullOrEmpty(query.UserName))
{
builder.AppendFormat(" AND UserName='******'", DataHelper.CleanSearchString(query.UserName));
}
if (query.FromDate.HasValue)
{
builder.AppendFormat(" AND TradeDate >= '{0}'", DataHelper.GetSafeDateTimeFormat(query.FromDate.Value));
}
if (query.ToDate.HasValue)
{
builder.AppendFormat(" AND TradeDate <= '{0}'", DataHelper.GetSafeDateTimeFormat(query.ToDate.Value));
}
if (query.TradeType != TradeTypes.NotSet)
{
builder.AppendFormat(" AND TradeType = {0}", (int)query.TradeType);
}
return(builder.ToString());
}
public DbQueryResult GetSplittinDetails(BalanceDetailQuery query, bool?isUser)
{
StringBuilder stringBuilder = new StringBuilder("1=1");
if (isUser.HasValue)
{
stringBuilder.AppendFormat(" AND IsUse = '{0}'", isUser);
}
if (query.UserId.HasValue)
{
stringBuilder.AppendFormat(" AND UserId = {0}", query.UserId.Value);
}
if (query.FromDate.HasValue)
{
stringBuilder.AppendFormat(" AND TradeDate >= '{0}'", query.FromDate);
}
if (query.ToDate.HasValue)
{
stringBuilder.AppendFormat(" AND TradeDate <= '{0}'", query.ToDate);
}
if (query.SplittingTypes != SplittingTypes.NotSet)
{
stringBuilder.AppendFormat(" AND TradeType = {0}", (int)query.SplittingTypes);
}
if (!string.IsNullOrEmpty(query.OrderId))
{
stringBuilder.AppendFormat("AND OrderId='{0}'", query.OrderId);
}
string strtable = "(select S.*,O.OrderTotal,U.UserName as SubUserName from Ecshop_SplittinDetails S join dbo.Ecshop_Orders O on S.OrderId=O.OrderId join dbo.aspnet_Users U on U.UserId=S.SubUserId) as ExtendTable ";
return(DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, strtable, "JournalNumber", stringBuilder.ToString(), "*"));
}
private string BuildBalanceDetailsQuery(BalanceDetailQuery query)
{
StringBuilder stringBuilder = new StringBuilder();
if (query.UserId.HasValue)
{
stringBuilder.AppendFormat(" AND UserId = {0}", query.UserId.Value);
}
if (!string.IsNullOrEmpty(query.UserName))
{
stringBuilder.AppendFormat(" AND UserName='******'", DataHelper.CleanSearchString(query.UserName));
}
if (query.FromDate.HasValue)
{
stringBuilder.AppendFormat(" AND TradeDate >= '{0}'", DataHelper.GetSafeDateTimeFormat(query.FromDate.Value));
}
if (query.ToDate.HasValue)
{
stringBuilder.AppendFormat(" AND TradeDate < '{0}'", DataHelper.GetSafeDateTimeFormat(query.ToDate.Value.AddDays(1.0)));
}
if (query.TradeType != 0)
{
stringBuilder.AppendFormat(" AND TradeType = {0}", (int)query.TradeType);
}
return stringBuilder.ToString();
}
public DbQueryResult GetBalanceDetailsNoPage(BalanceDetailQuery query)
{
DbQueryResult dbQueryResult = new DbQueryResult();
StringBuilder stringBuilder = new StringBuilder();
string arg = this.BuildBalanceDetailsQuery(query);
stringBuilder.Append("SELECT * FROM Ecshop_BalanceDetails WHERE 0=0 ");
stringBuilder.AppendFormat("{0} ORDER BY JournalNumber DESC", arg);
if (query.IsCount)
{
stringBuilder.AppendFormat(";select count(JournalNumber) as Total from Ecshop_BalanceDetails where 0=0 {0}", arg);
}
DbCommand sqlStringCommand = this.database.GetSqlStringCommand(stringBuilder.ToString());
using (IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
dbQueryResult.Data = DataHelper.ConverDataReaderToDataTable(dataReader);
if (query.IsCount && dataReader.NextResult())
{
dataReader.Read();
dbQueryResult.TotalRecords = dataReader.GetInt32(0);
}
}
return(dbQueryResult);
}
public DbQueryResult GetBalanceDetails(BalanceDetailQuery query)
{
if (query == null)
{
return new DbQueryResult();
}
DbQueryResult dbQueryResult = new DbQueryResult();
StringBuilder stringBuilder = new StringBuilder();
string text = this.BuildBalanceDetailsQuery(query);
stringBuilder.AppendFormat("SELECT TOP {0} *, isnull (Income, 0) + isnull (Expenses, 0) Amount ,CASE WHEN TradeType = 1 THEN '自助充值' WHEN TradeType = 2 THEN '后台加款' WHEN TradeType = 3 THEN '消费' WHEN TradeType = 4 THEN '提现' WHEN TradeType = 5 THEN '退款' WHEN TradeType = 7 THEN '退货' WHEN TradeType = 8 THEN '分销奖励' WHEN TradeType = 9 THEN '充值赠送' ELSE '其他' END TradeTypeText ", query.PageSize);
stringBuilder.Append(" FROM Hishop_BalanceDetails B where 0=0 ");
if (query.PageIndex == 1)
{
stringBuilder.AppendFormat("{0} ORDER BY JournalNumber DESC", text);
}
else
{
stringBuilder.AppendFormat(" and JournalNumber < (select min(JournalNumber) from (select top {0} JournalNumber from Hishop_BalanceDetails where 0=0 {1} ORDER BY JournalNumber DESC ) as tbltemp) {1} ORDER BY JournalNumber DESC", (query.PageIndex - 1) * query.PageSize, text);
}
if (query.IsCount)
{
stringBuilder.AppendFormat(";select count(JournalNumber) as Total from Hishop_BalanceDetails where 0=0 {0}", text);
}
DbCommand sqlStringCommand = base.database.GetSqlStringCommand(stringBuilder.ToString());
using (IDataReader dataReader = base.database.ExecuteReader(sqlStringCommand))
{
dbQueryResult.Data = DataHelper.ConverDataReaderToDataTable(dataReader);
if (query.IsCount && dataReader.NextResult())
{
dataReader.Read();
dbQueryResult.TotalRecords = dataReader.GetInt32(0);
}
}
return dbQueryResult;
}
public override DbQueryResult GetBalanceDetailsNoPage(BalanceDetailQuery query)
{
if (null == query)
{
return(new DbQueryResult());
}
DbQueryResult result = new DbQueryResult();
StringBuilder builder = new StringBuilder();
string str = BuildBalanceDetailsQuery(query);
builder.Append("SELECT * FROM Hishop_BalanceDetails WHERE 0=0 ");
builder.AppendFormat("{0} ORDER BY JournalNumber DESC", str);
if (query.IsCount)
{
builder.AppendFormat(";select count(JournalNumber) as Total from Hishop_BalanceDetails where 0=0 {0}", str);
}
DbCommand sqlStringCommand = database.GetSqlStringCommand(builder.ToString());
using (IDataReader reader = database.ExecuteReader(sqlStringCommand))
{
result.Data = DataHelper.ConverDataReaderToDataTable(reader);
if (query.IsCount && reader.NextResult())
{
reader.Read();
result.TotalRecords = reader.GetInt32(0);
}
}
return(result);
}
public void ExportExcel(HttpContext context)
{
BalanceDetailQuery dataQuery = this.GetDataQuery(context);
DbQueryResult balanceDetailsNoPage = MemberHelper.GetBalanceDetailsNoPage(dataQuery);
string empty = string.Empty;
empty += "用户名";
empty += ",交易时间";
empty += ",业务摘要";
empty += ",转入金额";
empty += ",转出金额";
empty += ",当前余额\r\n";
foreach (DataRow row in balanceDetailsNoPage.Data.Rows)
{
string tradeType = this.GetTradeType((TradeTypes)row["TradeType"], false);
empty += row["UserName"];
empty = empty + "," + row["TradeDate"];
empty = empty + "," + tradeType;
empty = empty + "," + row["Income"];
empty = empty + "," + row["Expenses"];
empty = empty + "," + row["Balance"] + "\r\n";
}
context.Response.Clear();
context.Response.Buffer = false;
context.Response.Charset = "GB2312";
context.Response.AppendHeader("Content-Disposition", "attachment;filename=BalanceDetailsStatistics.csv");
context.Response.ContentEncoding = Encoding.GetEncoding("GB2312");
context.Response.ContentType = "application/octet-stream";
context.Response.Write(empty);
context.Response.End();
}
private void BindSplittins()
{
BalanceDetailQuery query = this.GetQuery();
bool?flag = null;
bool value = true;
if (this.Page.Request.QueryString["usestatus"] != null && !string.IsNullOrEmpty(this.Page.Request.QueryString["usestatus"]) && bool.TryParse(this.Page.Request.QueryString["usestatus"], out value))
{
flag = new bool?(value);
}
DbQueryResult mySplittinDetails = MemberProcessor.GetMySplittinDetails(query, flag);
this.rptReferralSplitin.DataSource = mySplittinDetails.Data;
this.rptReferralSplitin.DataBind();
this.dropSplittingType.Items.Add(new System.Web.UI.WebControls.ListItem("全部", "0"));
this.dropSplittingType.Items.Add(new System.Web.UI.WebControls.ListItem("直接推广", "1"));
this.dropSplittingType.Items.Add(new System.Web.UI.WebControls.ListItem("下级会员", "2"));
this.dropSplittingType.Items.Add(new System.Web.UI.WebControls.ListItem("下级推广员", "3"));
this.dropSplittingType.Items.Add(new System.Web.UI.WebControls.ListItem("提现", "4"));
this.dropSplittingType.SelectedValue = ((int)query.SplittingTypes).ToString();
this.dropUseStatus.Items.Add(new System.Web.UI.WebControls.ListItem("全部", ""));
this.dropUseStatus.Items.Add(new System.Web.UI.WebControls.ListItem("可用", "true"));
this.dropUseStatus.Items.Add(new System.Web.UI.WebControls.ListItem("不可用", "false"));
this.dropUseStatus.SelectedValue = (flag.HasValue ? ((flag == true) ? "true" : "false") : "");
this.calendarStart.SelectedDate = query.FromDate;
this.calendarEnd.SelectedDate = query.ToDate;
this.pager.TotalRecords = mySplittinDetails.TotalRecords;
}
private void btnCreateReport_Click(object sender, EventArgs e)
{
BalanceDetailQuery query = new BalanceDetailQuery();
query.FromDate = this.dateStart;
query.ToDate = this.dateEnd;
query.SortBy = "TradeDate";
query.SortOrder = SortAction.Desc;
query.UserName = this.userName;
DbQueryResult balanceDetailsNoPage = MemberHelper.GetBalanceDetailsNoPage(query);
string s = ((string.Empty + "用户名" + ",交易时间") + ",业务摘要" + ",转入金额") + ",转出金额" + ",当前余额\r\n";
foreach (DataRow row in ((DataTable)balanceDetailsNoPage.Data).Rows)
{
string str2 = string.Empty;
switch (Convert.ToInt32(row["TradeType"]))
{
case 1:
str2 = "自助充值";
break;
case 2:
str2 = "后台加款";
break;
case 3:
str2 = "消费";
break;
case 4:
str2 = "提现";
break;
case 5:
str2 = "订单退款";
break;
default:
str2 = "其他";
break;
}
s = s + row["UserName"];
s = s + "," + row["TradeDate"];
s = s + "," + str2;
s = s + "," + row["Income"];
s = s + "," + row["Expenses"];
object obj2 = s;
s = string.Concat(new object[] { obj2, ",", row["Balance"], "\r\n" });
}
this.Page.Response.Clear();
this.Page.Response.Buffer = false;
this.Page.Response.Charset = "GB2312";
this.Page.Response.AppendHeader("Content-Disposition", "attachment;filename=BalanceDetailsStatistics.csv");
this.Page.Response.ContentEncoding = Encoding.GetEncoding("GB2312");
this.Page.Response.ContentType = "application/octet-stream";
this.Page.EnableViewState = false;
this.Page.Response.Write(s);
this.Page.Response.End();
}
private void GetList(HttpContext context)
{
BalanceDetailQuery dataQuery = this.GetDataQuery(context);
DataGridViewModel <Dictionary <string, object> > listSplittinDraws = this.GetListSplittinDraws(dataQuery);
string s = base.SerializeObjectToJson(listSplittinDraws);
context.Response.Write(s);
context.Response.End();
}
private void GetList(HttpContext context)
{
string empty = string.Empty;
BalanceDetailQuery dataQuery = this.GetDataQuery(context);
DataGridViewModel <Dictionary <string, object> > referralRequest = this.GetReferralRequest(dataQuery);
string s = base.SerializeObjectToJson(referralRequest);
context.Response.Write(s);
context.Response.End();
}
private void BindBalanceDetails()
{
BalanceDetailQuery balanceDetailQuery = this.GetBalanceDetailQuery();
DbQueryResult balanceDetails = MemberProcessor.GetBalanceDetails(balanceDetailQuery);
this.rptAccountSummary.DataSource = balanceDetails.Data;
this.rptAccountSummary.DataBind();
if (this.pageTotal != null)
{
this.pageTotal.Value = balanceDetails.TotalRecords.ToString();
}
}
private BalanceDetailQuery GetDataQuery(HttpContext context)
{
BalanceDetailQuery balanceDetailQuery = new BalanceDetailQuery();
balanceDetailQuery.FromDate = base.GetDateTimeParam(context, "FromDate");
balanceDetailQuery.ToDate = base.GetDateTimeParam(context, "ToDate");
balanceDetailQuery.UserName = base.GetParameter(context, "UserName", true);
balanceDetailQuery.PageIndex = base.CurrentPageIndex;
balanceDetailQuery.PageSize = base.CurrentPageSize;
balanceDetailQuery.SortBy = "TradeDate";
balanceDetailQuery.SortOrder = SortAction.Desc;
return(balanceDetailQuery);
}
private void BindBalanceDetails()
{
BalanceDetailQuery balanceDetailQuery = this.GetBalanceDetailQuery();
DbQueryResult balanceDetails = PersonalHelper.GetBalanceDetails(balanceDetailQuery);
this.accountList.DataSource = balanceDetails.Data;
this.accountList.DataBind();
this.dropTradeType.DataBind();
this.dropTradeType.SelectedValue = balanceDetailQuery.TradeType;
this.calendarStart.SelectedDate = balanceDetailQuery.FromDate;
this.calendarEnd.SelectedDate = balanceDetailQuery.ToDate;
this.pager.TotalRecords = balanceDetails.TotalRecords;
}
private void BindSplittins()
{
BalanceDetailQuery query = this.GetQuery();
this.BindSplittingType();
DbQueryResult mySplittinDetails = MemberProcessor.GetMySplittinDetails(query, null);
this.rptReferralSplitin.DataSource = mySplittinDetails.Data;
this.rptReferralSplitin.DataBind();
this.calendarStart.SelectedDate = query.FromDate;
this.calendarEnd.SelectedDate = query.ToDate;
this.pager.TotalRecords = mySplittinDetails.TotalRecords;
}
private BalanceDetailQuery GetDataQuery(HttpContext context)
{
BalanceDetailQuery balanceDetailQuery = new BalanceDetailQuery();
balanceDetailQuery.TradeType = (TradeTypes)base.GetIntParam(context, "TradeType", false).Value;
balanceDetailQuery.UserId = base.GetIntParam(context, "UserId", false);
balanceDetailQuery.FromDate = base.GetDateTimeParam(context, "FromDate");
balanceDetailQuery.ToDate = base.GetDateTimeParam(context, "ToDate");
balanceDetailQuery.PageIndex = base.CurrentPageIndex;
balanceDetailQuery.PageSize = base.CurrentPageSize;
balanceDetailQuery.SortBy = "Balance";
balanceDetailQuery.SortOrder = SortAction.Desc;
return(balanceDetailQuery);
}
public IList<BalanceDetailInfo> GetMemberBalanceDetailsNoPage(BalanceDetailQuery query)
{
IList<BalanceDetailInfo> result = new List<BalanceDetailInfo>();
StringBuilder stringBuilder = new StringBuilder();
string arg = this.BuildBalanceDetailsQuery(query);
stringBuilder.Append("SELECT * FROM Hishop_BalanceDetails WHERE 0=0 ");
stringBuilder.AppendFormat("{0} ORDER BY JournalNumber DESC", arg);
DbCommand sqlStringCommand = base.database.GetSqlStringCommand(stringBuilder.ToString());
using (IDataReader objReader = base.database.ExecuteReader(sqlStringCommand))
{
result = DataHelper.ReaderToList<BalanceDetailInfo>(objReader);
}
return result;
}
private void GetBalanceDetails()
{
BalanceDetailQuery query = new BalanceDetailQuery();
query.FromDate = dataStart;
query.ToDate = dataEnd;
query.PageIndex = pager.PageIndex;
query.PageSize = pager.PageSize;
DbQueryResult myBalanceDetails = SubsiteStoreHelper.GetMyBalanceDetails(query);
grdBalanceDetails.DataSource = myBalanceDetails.Data;
grdBalanceDetails.DataBind();
pager.TotalRecords = myBalanceDetails.TotalRecords;
pager1.TotalRecords = myBalanceDetails.TotalRecords;
}
public void GetBalanceDrawRequest()
{
BalanceDetailQuery query = new BalanceDetailQuery();
query.UserName = this.userName;
query.FromDate = this.dateStart;
query.ToDate = this.dateEnd;
query.PageIndex = this.pager.PageIndex;
query.TradeType = TradeTypes.DrawRequest;
DbQueryResult distributorBalanceDetails = DistributorHelper.GetDistributorBalanceDetails(query);
this.grdBalanceDrawRequest.DataSource = distributorBalanceDetails.Data;
this.grdBalanceDrawRequest.DataBind();
this.pager1.TotalRecords = this.pager.TotalRecords = distributorBalanceDetails.TotalRecords;
}
public void GetBalanceDrawRequest()
{
BalanceDetailQuery query = new BalanceDetailQuery();
query.UserName = userName;
query.FromDate = dateStart;
query.ToDate = dateEnd;
query.PageIndex = pager.PageIndex;
query.TradeType = TradeTypes.DrawRequest;
DbQueryResult balanceDetails = MemberHelper.GetBalanceDetails(query);
grdBalanceDrawRequest.DataSource = balanceDetails.Data;
grdBalanceDrawRequest.DataBind();
pager1.TotalRecords = pager.TotalRecords = balanceDetails.TotalRecords;
}
public void GetBalanceDrawRequest()
{
BalanceDetailQuery query = new BalanceDetailQuery
{
UserName = this.userName,
FromDate = this.dateStart,
ToDate = this.dateEnd,
PageIndex = this.pager.PageIndex,
TradeType = TradeTypes.DrawRequest
};
DbQueryResult balanceDetails = MemberHelper.GetBalanceDetails(query);
this.grdBalanceDrawRequest.DataSource = balanceDetails.Data;
this.grdBalanceDrawRequest.DataBind();
this.pager1.TotalRecords = this.pager.TotalRecords = balanceDetails.TotalRecords;
}
private DataGridViewModel <Dictionary <string, object> > GetDataList(BalanceDetailQuery query)
{
DataGridViewModel <Dictionary <string, object> > dataGridViewModel = new DataGridViewModel <Dictionary <string, object> >();
if (query != null)
{
DbQueryResult balanceDetails = MemberHelper.GetBalanceDetails(query);
dataGridViewModel.rows = DataHelper.DataTableToDictionary(balanceDetails.Data);
dataGridViewModel.total = balanceDetails.TotalRecords;
foreach (Dictionary <string, object> row in dataGridViewModel.rows)
{
row["TradeTypeText"] = this.GetTradeType((TradeTypes)row["TradeType"], false);
}
}
return(dataGridViewModel);
}
private void GetBalanceDetails()
{
BalanceDetailQuery query = new BalanceDetailQuery();
query.TradeType = (TradeTypes)this.typeId;
query.FromDate = this.dataStart;
query.ToDate = this.dataEnd;
query.PageIndex = this.pager.PageIndex;
query.PageSize = this.pager.PageSize;
DbQueryResult myBalanceDetails = SubsiteStoreHelper.GetMyBalanceDetails(query);
this.grdBalanceDetails.DataSource = myBalanceDetails.Data;
this.grdBalanceDetails.DataBind();
this.pager.TotalRecords = myBalanceDetails.TotalRecords;
this.pager1.TotalRecords = myBalanceDetails.TotalRecords;
}
static string BuildBalanceDetailsQuery(BalanceDetailQuery query)
{
IUser user = HiContext.Current.User;
StringBuilder builder = new StringBuilder();
builder.AppendFormat(" AND UserId = {0}", user.UserId);
if (query.FromDate.HasValue)
{
builder.AppendFormat(" AND TradeDate >= '{0}'", DataHelper.GetSafeDateTimeFormat(query.FromDate.Value));
}
if (query.ToDate.HasValue)
{
builder.AppendFormat(" AND TradeDate <= '{0}'", DataHelper.GetSafeDateTimeFormat(query.ToDate.Value));
}
return(builder.ToString());
}
protected override void AttachChildControls()
{
PageTitle.AddSiteNameTitle("分销员");
MemberInfo user = Users.GetUser(HiContext.Current.UserId);
if (user != null)
{
if (!user.IsReferral())
{
this.Page.Response.Redirect("ReferralRegisterAgreement.aspx");
}
this.litAllSplittin = (Literal)this.FindControl("litAllSplittin");
this.litUserSplittin = (Literal)this.FindControl("litUserSplittin");
this.litNoUserSplittin = (Literal)this.FindControl("litNoUserSplittin");
this.litMonthLowerNum = (Literal)this.FindControl("litMonthLowerNum");
this.litLowerNum = (Literal)this.FindControl("litLowerNum");
this.rptAccountSummary = (AppshopTemplatedRepeater)this.FindControl("rptAccountSummary");
this.pageTotal = (this.FindControl("pageTotal") as HtmlInputHidden);
this.litDrawSplittin = (Literal)this.FindControl("litDrawSplittin");
int userId = HiContext.Current.User.UserId;
this.litAllSplittin.Text = MemberProcessor.GetUserAllSplittin(userId).F2ToString("f2");
this.litUserSplittin.Text = MemberProcessor.GetUserUseSplittin(userId).F2ToString("f2");
this.litNoUserSplittin.Text = MemberProcessor.GetUserNoUseSplittin(userId).F2ToString("f2");
this.litDrawSplittin.Text = MemberProcessor.GetUserDrawSplittin().F2ToString("f2");
BalanceDetailQuery balanceDetailQuery = new BalanceDetailQuery();
balanceDetailQuery.UserId = userId;
int pageIndex = default(int);
if (!int.TryParse(this.Page.Request.QueryString["page"], out pageIndex))
{
pageIndex = 1;
}
int pageSize = default(int);
if (!int.TryParse(this.Page.Request.QueryString["size"], out pageSize))
{
pageSize = 20;
}
balanceDetailQuery.PageIndex = pageIndex;
balanceDetailQuery.PageSize = pageSize;
DbQueryResult splittinDetails = MemberHelper.GetSplittinDetails(balanceDetailQuery);
this.rptAccountSummary.DataSource = splittinDetails.Data;
this.rptAccountSummary.DataBind();
if (this.pageTotal != null)
{
this.pageTotal.Value = splittinDetails.TotalRecords.ToString();
}
}
}
private void GetDistributionBalanceDetails()
{
BalanceDetailQuery query = new BalanceDetailQuery();
query.FromDate = this.dateStart;
query.ToDate = this.dateEnd;
query.PageIndex = this.pager.PageIndex;
query.PageSize = this.pager.PageSize;
query.SortBy = "TradeDate";
query.SortOrder = SortAction.Desc;
query.UserName = this.userName;
DbQueryResult distributorBalanceDetails = DistributorHelper.GetDistributorBalanceDetails(query);
this.grdBalanceDetails.DataSource = distributorBalanceDetails.Data;
this.grdBalanceDetails.DataBind();
this.pager1.TotalRecords = this.pager.TotalRecords = distributorBalanceDetails.TotalRecords;
}
