private void BindData() { BalanceDrawRequestQuery entity = new BalanceDrawRequestQuery { RequestTime = "", CheckTime = "", StoreName = this.StoreName, PageIndex = this.pager.PageIndex, PageSize = this.pager.PageSize, SortOrder = SortAction.Desc, SortBy = "Id", RequestEndTime = this.RequestEndTime, RequestStartTime = this.RequestStartTime, IsCheck = "", UserId = "" }; string[] extendChecks = new string[] { 0.ToString(), 1.ToString(), 3.ToString() }; Globals.EntityCoding(entity, true); DbQueryResult memberAmountRequest = MemberAmountProcessor.GetMemberAmountRequest(entity, extendChecks); this.reCommissions.DataSource = memberAmountRequest.Data; this.reCommissions.DataBind(); this.pager.TotalRecords = memberAmountRequest.TotalRecords; }
public override DbQueryResult GetBalanceDrawRequestsNoPage(BalanceDrawRequestQuery query) { if (null == query) { return(new DbQueryResult()); } DbQueryResult result = new DbQueryResult(); StringBuilder builder = new StringBuilder(); string str = BuildBalanceDrawRequestQuery(query); builder.Append("select *"); builder.Append(" from Hishop_BalanceDrawRequest B where 0=0 "); builder.AppendFormat("{0} ORDER BY RequestTime DESC", str); if (query.IsCount) { builder.AppendFormat(";select count(*) as Total from Hishop_BalanceDrawRequest 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); }
protected override void AttachChildControls() { DistributorsInfo currentDistributors = DistributorsBrower.GetCurrentDistributors(); if (currentDistributors.ReferralStatus != 0) { HttpContext.Current.Response.Redirect("MemberCenter.aspx"); } else { this.vshopbalancedraw = (VshopTemplatedRepeater)this.FindControl("vshopbalancedraw"); BalanceDrawRequestQuery query = new BalanceDrawRequestQuery { PageIndex = 1, PageSize = 0x186a0, UserId = currentDistributors.UserId.ToString(), SortBy = "SerialID", RequestTime = "", RequestStartTime = "", RequestEndTime = "", CheckTime = "", IsCheck = "", SortOrder = SortAction.Desc }; DbQueryResult balanceDrawRequest = DistributorsBrower.GetBalanceDrawRequest(query, null); if (balanceDrawRequest.TotalRecords > 0) { this.vshopbalancedraw.DataSource = balanceDrawRequest.Data; this.vshopbalancedraw.DataBind(); } } }
private void BindDrawRecords() { 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 = 10; } BalanceDrawRequestQuery balanceDrawRequestQuery = new BalanceDrawRequestQuery(); balanceDrawRequestQuery.PageIndex = pageIndex; balanceDrawRequestQuery.PageSize = pageSize; balanceDrawRequestQuery.UserId = HiContext.Current.UserId; DbQueryResult mySplittinDraws = MemberProcessor.GetMySplittinDraws(balanceDrawRequestQuery, null); this.rptDrawRecodes.DataSource = mySplittinDraws.Data; this.rptDrawRecodes.DataBind(); int totalRecords = mySplittinDraws.TotalRecords; this.txtTotalPages.SetWhenIsNotNull(totalRecords.ToString()); }
private void Exporttoexcel(HttpContext context) { BalanceDrawRequestQuery balanceDrawRequestQuery = this.GetBalanceDrawRequestQuery(context); balanceDrawRequestQuery.PageIndex = 1; balanceDrawRequestQuery.PageSize = 2147483647; DbQueryResult splittinDraws = MemberHelper.GetSplittinDraws(balanceDrawRequestQuery, 1); DataTable data = splittinDraws.Data; string empty = string.Empty; empty += "用户名"; empty += ",申请时间"; empty += ",提现金额"; empty += ",支付宝帐号"; empty += ",真实姓名"; empty += ",备注\r\n"; foreach (DataRow row in data.Rows) { empty += row["UserName"].ToString(); empty = empty + "," + row["RequestDate"].ToString(); empty = empty + "," + row["Amount"].ToString(); empty = empty + "," + row["AlipayCode"].ToString(); empty = empty + "," + row["AlipayRealName"].ToString(); empty = empty + "," + row["Remark"].ToString() + "\r\n"; } context.Response.Clear(); context.Response.Buffer = false; context.Response.Charset = "GB2312"; context.Response.AppendHeader("Content-Disposition", "attachment;filename=SplittinAlipayDrawRequest.csv"); context.Response.ContentEncoding = Encoding.GetEncoding("GB2312"); context.Response.ContentType = "application/ms-excel"; context.Response.Write(empty); context.Response.End(); }
public void ExportExcel(HttpContext context) { BalanceDrawRequestQuery dataQuery = this.GetDataQuery(context); dataQuery.PageIndex = 1; dataQuery.PageSize = 2147483647; DbQueryResult balanceDrawRequests = MemberHelper.GetBalanceDrawRequests(dataQuery, true); DataTable data = balanceDrawRequests.Data; string empty = string.Empty; empty += "用户名"; empty += ",申请时间"; empty += ",提现金额"; empty += ",备注\r\n"; foreach (DataRow row in data.Rows) { empty += row["UserName"].ToString(); empty = empty + "," + row["RequestTime"].ToString(); empty = empty + "," + row["Amount"].ToString(); empty = empty + "," + row["Remark"].ToString() + "\r\n"; } context.Response.Clear(); context.Response.Buffer = false; context.Response.Charset = "GB2312"; context.Response.AppendHeader("Content-Disposition", "attachment;filename=BalanceWeiXinDrawRequest.csv"); context.Response.ContentEncoding = Encoding.GetEncoding("GB2312"); context.Response.ContentType = "application/octet-stream"; context.Response.Write(empty); context.Response.End(); }
public DbQueryResult GetSplittinDraws(BalanceDrawRequestQuery query, int?auditStatus) { StringBuilder stringBuilder = new StringBuilder("1=1"); if (auditStatus.HasValue) { stringBuilder.AppendFormat(" AND AuditStatus = {0}", auditStatus); } if (query.UserId.HasValue) { stringBuilder.AppendFormat(" AND UserId = {0}", query.UserId); } if (!string.IsNullOrEmpty(query.UserName)) { stringBuilder.AppendFormat(" AND UserName LIKE '%{0}%'", DataHelper.CleanSearchString(query.UserName)); } if (query.FromDate.HasValue) { stringBuilder.AppendFormat(" AND RequestDate >= '{0}'", query.FromDate); } if (query.ToDate.HasValue) { stringBuilder.AppendFormat(" AND RequestDate <= '{0}'", query.ToDate); } return(DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "Ecshop_SplittinDraws s", "JournalNumber", stringBuilder.ToString(), "*, (SELECT TOP 1 Balance FROM Ecshop_SplittinDetails WHERE UserId = s.UserId AND IsUse = 'true' ORDER BY JournalNumber DESC) AS Balance")); }
public DbQueryResult GetBalanceDrawRequestsNoPage(BalanceDrawRequestQuery query) { DbQueryResult result; if (null == query) { result = new DbQueryResult(); } else { DbQueryResult dbQueryResult = new DbQueryResult(); StringBuilder stringBuilder = new StringBuilder(); string arg = this.BuildBalanceDrawRequestQuery(query); stringBuilder.Append("select *"); stringBuilder.Append(" from Ecshop_BalanceDrawRequest B where 0=0 "); stringBuilder.AppendFormat("{0} ORDER BY RequestTime DESC", arg); if (query.IsCount) { stringBuilder.AppendFormat(";select count(*) as Total from Ecshop_BalanceDrawRequest 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); } } result = dbQueryResult; } return(result); }
public DbQueryResult GetBalanceDrawRequests(BalanceDrawRequestQuery query) { DbQueryResult dbQueryResult = new DbQueryResult(); StringBuilder stringBuilder = new StringBuilder(); string text = this.BuildBalanceDrawRequestQuery(query); stringBuilder.AppendFormat("select top {0} *", query.PageSize); stringBuilder.Append(" from Ecshop_BalanceDrawRequest B where 0=0 "); if (query.PageIndex == 1) { stringBuilder.AppendFormat("{0} ORDER BY RequestTime DESC", text); } else { stringBuilder.AppendFormat(" and RequestTime < (select min(RequestTime) from (select top {0} RequestTime from Ecshop_BalanceDrawRequest where 0=0 {1} ORDER BY RequestTime DESC ) as tbltemp) {1} ORDER BY RequestTime DESC", (query.PageIndex - 1) * query.PageSize, text); } if (query.IsCount) { stringBuilder.AppendFormat(";select count(*) as Total from Ecshop_BalanceDrawRequest where 0=0 {0}", text); } 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); }
private void BindData() { BalanceDrawRequestQuery entity = new BalanceDrawRequestQuery { RequestTime = "", CheckTime = "", StoreName = this.StoreName, PageIndex = this.pager.PageIndex, PageSize = this.pager.PageSize, SortOrder = SortAction.Desc, SortBy = "SerialID", RequestEndTime = this.RequestEndTime, RequestStartTime = this.RequestStartTime, IsCheck = "", UserId = "" }; string[] extendChecks = new string[] { "0", "1" }; Globals.EntityCoding(entity, true); DbQueryResult balanceDrawRequest = DistributorsBrower.GetBalanceDrawRequest(entity, extendChecks); this.reCommissions.DataSource = balanceDrawRequest.Data; this.reCommissions.DataBind(); this.pager.TotalRecords = balanceDrawRequest.TotalRecords; DataTable drawRequestNum = DistributorsBrower.GetDrawRequestNum(new int[] { 3 }); this.Frist.Text = "待发放(" + this.pager.TotalRecords + ")"; if (drawRequestNum.Rows.Count > 0) { this.Second.Text = "发放异常(" + drawRequestNum.Rows[0]["num"].ToString() + ")"; } }
private void GetList(HttpContext context) { BalanceDrawRequestQuery 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 BalanceDrawRequestQuery GetDataQuery(HttpContext context) { BalanceDrawRequestQuery balanceDrawRequestQuery = new BalanceDrawRequestQuery(); balanceDrawRequestQuery.FromDate = base.GetDateTimeParam(context, "FromDate"); balanceDrawRequestQuery.ToDate = base.GetDateTimeParam(context, "ToDate"); balanceDrawRequestQuery.UserName = base.GetParameter(context, "UserName", true); balanceDrawRequestQuery.PageIndex = base.CurrentPageIndex; balanceDrawRequestQuery.PageSize = base.CurrentPageSize; balanceDrawRequestQuery.DrawRequestType = 1; return(balanceDrawRequestQuery); }
private void BindSplittinDraw() { BalanceDrawRequestQuery balanceDrawRequestQuery = new BalanceDrawRequestQuery(); balanceDrawRequestQuery.PageIndex = this.pager.PageIndex; balanceDrawRequestQuery.PageSize = this.pager.PageSize; balanceDrawRequestQuery.UserId = HiContext.Current.UserId; DbQueryResult mySplittinDraws = MemberProcessor.GetMySplittinDraws(balanceDrawRequestQuery, null); this.rptSplittinDraw.DataSource = mySplittinDraws.Data; this.rptSplittinDraw.DataBind(); this.pager.TotalRecords = mySplittinDraws.TotalRecords; }
public void GetBalanceDrawRequest() { BalanceDrawRequestQuery query = new BalanceDrawRequestQuery(); query.FromDate = dataStart; query.ToDate = dataEnd; query.UserName = txtUserName.Text; query.UserId = userId; query.PageIndex = pager.PageIndex; DbQueryResult distributorBalanceDrawRequests = DistributorHelper.GetDistributorBalanceDrawRequests(query); grdBalanceDrawRequest.DataSource = distributorBalanceDrawRequests.Data; grdBalanceDrawRequest.DataBind(); pager.TotalRecords = distributorBalanceDrawRequests.TotalRecords; }
public void BindBalanceDrawRequest() { BalanceDrawRequestQuery query = new BalanceDrawRequestQuery(); query.FromDate = dataStart; query.ToDate = dataEnd; query.UserName = txtUserName.Text; query.PageIndex = pager.PageIndex; query.PageSize = pager.PageSize; DbQueryResult balanceDrawRequests = MemberHelper.GetBalanceDrawRequests(query); grdBalanceDrawRequest.DataSource = balanceDrawRequests.Data; grdBalanceDrawRequest.DataBind(); pager1.TotalRecords = pager.TotalRecords = balanceDrawRequests.TotalRecords; pager.TotalRecords = pager.TotalRecords = balanceDrawRequests.TotalRecords; }
public DbQueryResult GetBalanceDrawRequests(BalanceDrawRequestQuery query, bool IsAdmin = true) { DbQueryResult dbQueryResult = new DbQueryResult(); StringBuilder stringBuilder = new StringBuilder(); string text = this.BuildBalanceDrawRequestQuery(query); stringBuilder.AppendFormat("select top {0} *", query.PageSize); stringBuilder.Append(" from Hishop_BalanceDrawRequest B where 0=0 "); if (IsAdmin) { text += " AND IsPass IS NULL "; } switch (query.DrawRequestType) { case 1: text += " AND IsWeixin <> 1 AND IsAlipay <> 1"; break; case 2: text += " AND IsWeixin = 1 "; break; case 3: text += " AND IsAlipay = 1"; break; } if (query.PageIndex == 1) { stringBuilder.AppendFormat("{0} ORDER BY RequestTime DESC", text); } else { stringBuilder.AppendFormat(" and RequestTime < (select min(RequestTime) from (select top {0} RequestTime from Hishop_BalanceDrawRequest where 0=0 {1} ORDER BY RequestTime DESC ) as tbltemp) {1} ORDER BY RequestTime DESC", (query.PageIndex - 1) * query.PageSize, text); } if (query.IsCount) { stringBuilder.AppendFormat(";select count(*) as Total from Hishop_BalanceDrawRequest 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 void BindBalanceDrawRequest() { BalanceDrawRequestQuery query = new BalanceDrawRequestQuery { FromDate = this.dataStart, ToDate = this.dataEnd, UserName = this.txtUserName.Text, PageIndex = this.pager.PageIndex, PageSize = this.pager.PageSize }; DbQueryResult balanceDrawRequests = MemberHelper.GetBalanceDrawRequests(query); this.grdBalanceDrawRequest.DataSource = balanceDrawRequests.Data; this.grdBalanceDrawRequest.DataBind(); this.pager1.TotalRecords = this.pager.TotalRecords = balanceDrawRequests.TotalRecords; this.pager.TotalRecords = this.pager.TotalRecords = balanceDrawRequests.TotalRecords; }
public void HistoryExportToExcel(HttpContext context) { int value = base.GetIntParam(context, "UserId", false).Value; BalanceDrawRequestQuery balanceDrawRequestQuery = this.GetBalanceDrawRequestQuery(context); IList <CommissionRequestModel> splittinDrawsExportData = MemberHelper.GetSplittinDrawsExportData(balanceDrawRequestQuery, balanceDrawRequestQuery.AuditStatus); StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("<table border='1'>"); stringBuilder.Append("<thead><tr>"); stringBuilder.Append("<th>分销员</th>"); stringBuilder.Append("<th>申请时间</th>"); stringBuilder.Append("<th>提现金额</th>"); stringBuilder.Append("<th>操作人</th>"); stringBuilder.Append("<th>备注</th>"); stringBuilder.Append("<th>提现账号信息</th>"); stringBuilder.Append("</tr></thead>"); StringBuilder stringBuilder2 = new StringBuilder(); DateTime dateTime; foreach (CommissionRequestModel item in splittinDrawsExportData) { stringBuilder2.Append("<tr>"); stringBuilder2.Append(ExcelHelper.GetXLSFieldsTD(item.ReferralUserName, true)); StringBuilder stringBuilder3 = stringBuilder2; dateTime = item.RequestDate; stringBuilder3.Append(ExcelHelper.GetXLSFieldsTD(dateTime.ToString("yyyy-MM-dd HH:mm:ss"), false)); stringBuilder2.Append(ExcelHelper.GetXLSFieldsTD(item.Amount.F2ToString("f2"), false)); stringBuilder2.Append(ExcelHelper.GetXLSFieldsTD(item.ManagerUserName, true)); stringBuilder2.Append(ExcelHelper.GetXLSFieldsTD(item.Remark, true)); stringBuilder2.Append(ExcelHelper.GetXLSFieldsTD(item.AccountInfo, true)); stringBuilder2.Append("</tr>"); } stringBuilder.AppendFormat("<tbody>{0}</tbody></table>", stringBuilder2.ToString()); StringWriter stringWriter = new StringWriter(); stringWriter.Write(stringBuilder); HttpResponse response = context.Response; StringBuilder stringBuilder4 = stringWriter.GetStringBuilder(); dateTime = DateTime.Now; DownloadHelper.DownloadFile(response, stringBuilder4, "SplittinDraws" + dateTime.ToString("yyyyMMddhhmmss") + ".xls"); stringWriter.Close(); context.Response.End(); }
public DbQueryResult GetBalanceDrawRequestsNoPage(BalanceDrawRequestQuery query, bool IsAdmin = true) { if (query == null) { return new DbQueryResult(); } DbQueryResult dbQueryResult = new DbQueryResult(); StringBuilder stringBuilder = new StringBuilder(); string text = this.BuildBalanceDrawRequestQuery(query); stringBuilder.Append("SELECT *"); stringBuilder.Append(" FROM Hishop_BalanceDrawRequest B WHERE 0=0 "); if (IsAdmin) { text += " AND IsPass IS NULL "; } switch (query.DrawRequestType) { case 1: text += " AND IsWeixin <> 1 AND IsAlipay <> 1"; break; case 2: text += " AND IsWeixin = 1 "; break; case 3: text += " AND IsAlipay = 1"; break; } stringBuilder.AppendFormat("{0} ORDER BY RequestTime DESC", text); if (query.IsCount) { stringBuilder.AppendFormat(";SELECT COUNT(*) AS TOTAL FROM Hishop_BalanceDrawRequest 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; }
private void BindData() { BalanceDrawRequestQuery balanceDrawRequestQuery = new BalanceDrawRequestQuery(); balanceDrawRequestQuery.RequestTime = ""; balanceDrawRequestQuery.CheckTime = ""; balanceDrawRequestQuery.StoreName = this.StoreName; balanceDrawRequestQuery.PageIndex = this.pager.PageIndex; balanceDrawRequestQuery.PageSize = this.pager.PageSize; balanceDrawRequestQuery.SortOrder = SortAction.Desc; balanceDrawRequestQuery.SortBy = "SerialID"; balanceDrawRequestQuery.RequestEndTime = this.RequestEndTime; balanceDrawRequestQuery.RequestStartTime = this.RequestStartTime; balanceDrawRequestQuery.IsCheck = ""; balanceDrawRequestQuery.UserId = ""; string[] extendChecks = new string[] { "3" }; Globals.EntityCoding(balanceDrawRequestQuery, true); DbQueryResult balanceDrawRequest = DistributorsBrower.GetBalanceDrawRequest(balanceDrawRequestQuery, extendChecks); this.reCommissions.DataSource = balanceDrawRequest.Data; this.reCommissions.DataBind(); this.pager.TotalRecords = balanceDrawRequest.TotalRecords; System.Data.DataTable drawRequestNum = DistributorsBrower.GetDrawRequestNum(new int[] { 0, 1 }); int num = 0; if (drawRequestNum.Rows.Count > 0) { for (int i = 0; i < drawRequestNum.Rows.Count; i++) { num += Globals.ToNum(drawRequestNum.Rows[i]["num"]); } this.Frist.Text = "待发放(" + num.ToString() + ")"; } this.Second.Text = "发放异常(" + this.pager.TotalRecords + ")"; }
protected void Page_Load(object sender, EventArgs e) { if (!int.TryParse(this.Page.Request.QueryString["JournalNumber"], out this.journalNumber)) { base.GotoResourceNotFound(); } else if (!this.Page.IsPostBack) { this.lblUserName.Text = this.Page.Request.QueryString["Name"].ToNullString(); BalanceDrawRequestQuery query = new BalanceDrawRequestQuery { JournalNumber = this.journalNumber, PageSize = 1, PageIndex = 1, IsCount = false }; DbQueryResult splittinDraws = MemberHelper.GetSplittinDraws(query, null); if (splittinDraws != null && splittinDraws.Data.Rows.Count > 0) { DataRow dataRow = splittinDraws.Data.Rows[0]; this.lblAlipayCode.Text = dataRow["AlipayCode"].ToNullString(); this.lblAlipayRealName.Text = dataRow["AlipayRealName"].ToNullString(); this.lblAccountName.Text = dataRow["AccountName"].ToNullString(); this.lblBankName.Text = dataRow["BankName"].ToNullString(); this.lblMerchantCode.Text = dataRow["MerchantCode"].ToNullString(); this.lblMoney.Text = dataRow["Amount"].ToDecimal(0).ToString("0.00"); this.LabRemark.Text = dataRow["ManagerRemark"].ToNullString(); if (dataRow["IsAlipay"].ToBool()) { this.isAlipay = true; } if (dataRow["IsWeixin"].ToBool()) { this.isWeixin = true; } if (dataRow["IsWithdrawToAccount"].ToBool()) { this.isWithdrawToAccount = true; } } } }
public void BindBalanceDrawRequest() { BalanceDrawRequestQuery balanceDrawRequestQuery = new BalanceDrawRequestQuery(); if (this.userId > 0) { balanceDrawRequestQuery.UserId = new int?(this.userId); } balanceDrawRequestQuery.UserName = this.userName; balanceDrawRequestQuery.FromDate = this.dateStart; balanceDrawRequestQuery.ToDate = this.dateEnd; balanceDrawRequestQuery.PageIndex = this.pager.PageIndex; balanceDrawRequestQuery.PageSize = this.pager.PageSize; DbQueryResult balanceDrawRequests = UnderlingHelper.GetBalanceDrawRequests(balanceDrawRequestQuery); this.grdBalanceDrawRequest.DataSource = balanceDrawRequests.Data; this.grdBalanceDrawRequest.DataBind(); this.pager.TotalRecords = balanceDrawRequests.TotalRecords; this.pager1.TotalRecords = balanceDrawRequests.TotalRecords; }
public void BindBalanceDrawRequest() { BalanceDrawRequestQuery query = new BalanceDrawRequestQuery(); if (userId > 0) { query.UserId = new int?(userId); } query.UserName = userName; query.FromDate = dateStart; query.ToDate = dateEnd; query.PageIndex = pager.PageIndex; query.PageSize = pager.PageSize; DbQueryResult balanceDrawRequests = UnderlingHelper.GetBalanceDrawRequests(query); grdBalanceDrawRequest.DataSource = balanceDrawRequests.Data; grdBalanceDrawRequest.DataBind(); pager.TotalRecords = balanceDrawRequests.TotalRecords; pager1.TotalRecords = balanceDrawRequests.TotalRecords; }
private void BindData() { BalanceDrawRequestQuery balanceDrawRequestQuery = new BalanceDrawRequestQuery(); balanceDrawRequestQuery.RequestTime = ""; balanceDrawRequestQuery.CheckTime = "CheckTime"; balanceDrawRequestQuery.RequestStartTime = this.RequestStartTime; balanceDrawRequestQuery.RequestEndTime = this.RequestEndTime; balanceDrawRequestQuery.StoreName = this.StoreName; balanceDrawRequestQuery.PageIndex = this.pager.PageIndex; balanceDrawRequestQuery.PageSize = this.pager.PageSize; balanceDrawRequestQuery.SortOrder = SortAction.Desc; balanceDrawRequestQuery.SortBy = "RequestTime"; balanceDrawRequestQuery.IsCheck = "2"; Globals.EntityCoding(balanceDrawRequestQuery, true); DbQueryResult balanceDrawRequest = VShopHelper.GetBalanceDrawRequest(balanceDrawRequestQuery); this.reBalanceDrawRequest.DataSource = balanceDrawRequest.Data; this.reBalanceDrawRequest.DataBind(); this.pager.TotalRecords = balanceDrawRequest.TotalRecords; }
public override DbQueryResult GetBalanceDrawRequests(BalanceDrawRequestQuery query) { DbQueryResult result; if (null == query) { result = null; } else { DbQueryResult dbQueryResult = new DbQueryResult(); StringBuilder stringBuilder = new StringBuilder(); string text = UnderlingData.BuildBalanceDrawRequestQuery(query); stringBuilder.AppendFormat("SELECT Top {0} * FROM distro_BalanceDrawRequest B WHERE 0=0", query.PageSize); if (query.PageIndex == 1) { stringBuilder.AppendFormat("{0} ORDER BY RequestTime DESC;", text); } else { stringBuilder.AppendFormat(" AND RequestTime < (SELECT MIN(RequestTime) FROM (SELECT TOP {0} RequestTime FROM distro_BalanceDrawRequest WHERE 0=0 {1} ORDER BY RequestTime DESC ) as T) {1} ORDER BY RequestTime DESC;", (query.PageIndex - 1) * query.PageSize, text); } if (query.IsCount) { stringBuilder.AppendFormat("SELECT COUNT(*) AS Total from distro_BalanceDrawRequest WHERE 0=0 {0}", text); } System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand(stringBuilder.ToString()); using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand)) { dbQueryResult.Data = DataHelper.ConverDataReaderToDataTable(dataReader); if (query.IsCount && dataReader.NextResult()) { dataReader.Read(); dbQueryResult.TotalRecords = dataReader.GetInt32(0); } } result = dbQueryResult; } return(result); }
static string BuildBalanceDrawRequestQuery(BalanceDrawRequestQuery 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 RequestTime >= '{0}'", DataHelper.GetSafeDateTimeFormat(query.FromDate.Value)); } if (query.ToDate.HasValue) { builder.AppendFormat(" AND RequestTime <= '{0}'", DataHelper.GetSafeDateTimeFormat(query.ToDate.Value)); } return(builder.ToString()); }
private void BindData() { BalanceDrawRequestQuery entity = new BalanceDrawRequestQuery { CheckTime = this.CheckTime, RequestTime = this.RequestTime, StoreName = this.StoreName, PageIndex = this.pager.PageIndex, PageSize = this.pager.PageSize, SortOrder = SortAction.Desc, SortBy = "UserId", RequestEndTime = "", RequestStartTime = "", IsCheck = "" }; Globals.EntityCoding(entity, true); DbQueryResult balanceDrawRequest = VShopHelper.GetBalanceDrawRequest(entity); this.reBalanceDrawRequest.DataSource = balanceDrawRequest.Data; this.reBalanceDrawRequest.DataBind(); this.pager.TotalRecords = balanceDrawRequest.TotalRecords; }
private static string BuildBalanceDrawRequestQuery(BalanceDrawRequestQuery query) { StringBuilder builder = new StringBuilder(); builder.AppendFormat(" AND DistributorUserId = {0}", HiContext.Current.User.UserId); if (query.UserId.HasValue) { builder.AppendFormat(" AND UserId = {0}", query.UserId.Value); } if (!string.IsNullOrEmpty(query.UserName)) { builder.AppendFormat(" AND UserId IN (SELECT UserId FROM vw_distro_Members WHERE UserName='******')", DataHelper.CleanSearchString(query.UserName)); } if (query.FromDate.HasValue) { builder.AppendFormat(" AND RequestTime >= '{0}'", DataHelper.GetSafeDateTimeFormat(query.FromDate.Value)); } if (query.ToDate.HasValue) { builder.AppendFormat(" AND RequestTime <= '{0}'", DataHelper.GetSafeDateTimeFormat(query.ToDate.Value)); } return(builder.ToString()); }
protected override void AttachChildControls() { this.vshopbalancedraw = (VshopTemplatedRepeater)this.FindControl("vshopbalancedraw"); BalanceDrawRequestQuery query = new BalanceDrawRequestQuery { PageIndex = 1, PageSize = 0x186a0, UserId = DistributorsBrower.GetCurrentDistributors().UserId.ToString(), SortBy = "SerialID", RequestTime = "", RequestStartTime = "", RequestEndTime = "", CheckTime = "", IsCheck = "", SortOrder = SortAction.Desc }; DbQueryResult balanceDrawRequest = DistributorsBrower.GetBalanceDrawRequest(query); if (balanceDrawRequest.TotalRecords > 0) { this.vshopbalancedraw.DataSource = balanceDrawRequest.Data; this.vshopbalancedraw.DataBind(); } }
private void BindData() { BalanceDrawRequestQuery entity = new BalanceDrawRequestQuery { RequestTime = "", CheckTime = "", StoreName = this.StoreName, PageIndex = this.pager.PageIndex, PageSize = this.pager.PageSize, SortOrder = SortAction.Desc, SortBy = "SerialID", RequestEndTime = this.RequestEndTime, RequestStartTime = this.RequestStartTime, IsCheck = "0", UserId = "" }; Globals.EntityCoding(entity, true); DbQueryResult balanceDrawRequest = DistributorsBrower.GetBalanceDrawRequest(entity, null); this.reBalanceDrawRequest.DataSource = balanceDrawRequest.Data; this.reBalanceDrawRequest.DataBind(); this.pager.TotalRecords = balanceDrawRequest.TotalRecords; }
public DbQueryResult GetBalanceDrawRequest(BalanceDrawRequestQuery query) { StringBuilder builder = new StringBuilder(); if (!string.IsNullOrEmpty(query.StoreName)) { if (builder.Length > 0) { builder.Append(" AND "); } builder.AppendFormat(" StoreName LIKE '%{0}%'", DataHelper.CleanSearchString(query.StoreName)); } if (!string.IsNullOrEmpty(query.UserId)) { if (builder.Length > 0) { builder.Append(" AND "); } builder.AppendFormat(" UserId = {0}", DataHelper.CleanSearchString(query.UserId)); } if (!string.IsNullOrEmpty(query.RequestTime.ToString())) { if (builder.Length > 0) { builder.Append(" AND "); } builder.AppendFormat(" convert(varchar(10),RequestTime,120)='{0}'", query.RequestTime); } if (!string.IsNullOrEmpty(query.IsCheck.ToString())) { if (builder.Length > 0) { builder.Append(" AND "); } builder.AppendFormat(" IsCheck={0}", query.IsCheck); } if (!string.IsNullOrEmpty(query.CheckTime.ToString())) { if (builder.Length > 0) { builder.Append(" AND "); } builder.AppendFormat(" convert(varchar(10),CheckTime,120)='{0}'", query.CheckTime); } if (!string.IsNullOrEmpty(query.RequestStartTime.ToString())) { if (builder.Length > 0) { builder.Append(" AND "); } builder.AppendFormat(" datediff(dd,'{0}',RequestTime)>=0", query.RequestStartTime); } if (!string.IsNullOrEmpty(query.RequestEndTime.ToString())) { if (builder.Length > 0) { builder.Append(" AND "); } builder.AppendFormat(" datediff(dd,'{0}',RequestTime)<=0", query.RequestEndTime); } return DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "vw_Hishop_BalanceDrawRequesDistributors ", "SerialID", (builder.Length > 0) ? builder.ToString() : null, "*"); }
public static DbQueryResult GetBalanceDrawRequest(BalanceDrawRequestQuery query) { return new DistributorsDao().GetBalanceDrawRequest(query); }