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; }