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 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; }
public static DbQueryResult GetBalanceDrawRequests(BalanceDrawRequestQuery query) { return UnderlingProvider.Instance().GetBalanceDrawRequests(query); }
public static DbQueryResult GetDistributorBalanceDrawRequests(BalanceDrawRequestQuery query) { return DistributorProvider.Instance().GetDistributorBalanceDrawRequests(query); }
public abstract DbQueryResult GetDistributorBalanceDrawRequests(BalanceDrawRequestQuery query);
public abstract DbQueryResult GetBalanceDrawRequestsNoPage(BalanceDrawRequestQuery query);
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 UserId IN (SELECT UserId FROM vw_aspnet_Distributors 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(); }
public override DbQueryResult GetDistributorBalanceDrawRequests(BalanceDrawRequestQuery query) { if (null == query) { return new DbQueryResult(); } DbQueryResult result = new DbQueryResult(); StringBuilder builder = new StringBuilder(); string str = BuildBalanceDrawRequestQuery(query); builder.AppendFormat("select top {0} *", query.PageSize); builder.Append(" from Hishop_DistributorBalanceDrawRequest B where 0=0 "); if (query.PageIndex == 1) { builder.AppendFormat("{0} ORDER BY RequestTime DESC", str); } else { builder.AppendFormat(" and RequestTime < (select min(RequestTime) from (select top {0} RequestTime from Hishop_DistributorBalanceDrawRequest where 0=0 {1} ORDER BY RequestTime DESC ) as tbltemp) {1} ORDER BY RequestTime DESC", (query.PageIndex - 1) * query.PageSize, str); } if (query.IsCount) { builder.AppendFormat(";select count(*) as Total from Hishop_DistributorBalanceDrawRequest 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 static DbQueryResult GetBalanceDrawRequestsNoPage(BalanceDrawRequestQuery query) { return MemberProvider.Instance().GetBalanceDrawRequestsNoPage(query); }
public override DbQueryResult GetBalanceDrawRequests(BalanceDrawRequestQuery query) { if (null == query) { return null; } DbQueryResult result = new DbQueryResult(); StringBuilder builder = new StringBuilder(); string str = BuildBalanceDrawRequestQuery(query); builder.AppendFormat("SELECT Top {0} * FROM distro_BalanceDrawRequest B WHERE 0=0", query.PageSize); if (query.PageIndex == 1) { builder.AppendFormat("{0} ORDER BY RequestTime DESC;", str); } else { builder.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, str); } if (query.IsCount) { builder.AppendFormat("SELECT COUNT(*) AS Total from distro_BalanceDrawRequest 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 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 = 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; }