public DbQueryResult GetSendRedpackRecordList(SendRedpackRecordQuery sendredpackrecordquery) { StringBuilder builder = new StringBuilder(); builder.AppendFormat(" UserId={0} and BalanceDrawRequestID={1} ", sendredpackrecordquery.UserID); return(DataHelper.PagingByRownumber(sendredpackrecordquery.PageIndex, sendredpackrecordquery.PageSize, sendredpackrecordquery.SortBy, sendredpackrecordquery.SortOrder, sendredpackrecordquery.IsCount, "vshop_SendRedpackRecord", "ID", builder.ToString(), "*")); }
public DbQueryResult GetSendRedpackRecordRequest(SendRedpackRecordQuery query) { StringBuilder builder = new StringBuilder(); if (query.BalanceDrawRequestID > 0) { if (builder.Length > 0) { builder.Append(" AND "); } builder.AppendFormat(" BalanceDrawRequestID={0} ", query.BalanceDrawRequestID); } return(DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "vshop_SendRedpackRecord ", "ID", (builder.Length > 0) ? builder.ToString() : null, "*")); }
private void LoadSendRedpackRecord() { SendRedpackRecordQuery sendRedpackRecordQuery = new SendRedpackRecordQuery() { BalanceDrawRequestID = this.m_BalanceDrawRequestID, SortBy = "ID", SortOrder = SortAction.Asc }; Globals.EntityCoding(sendRedpackRecordQuery, true); sendRedpackRecordQuery.PageIndex = this.pager.PageIndex; sendRedpackRecordQuery.PageSize = this.pager.PageSize; DbQueryResult sendRedpackRecordRequest = DistributorsBrower.GetSendRedpackRecordRequest(sendRedpackRecordQuery); this.rptList.DataSource = sendRedpackRecordRequest.Data; this.rptList.DataBind(); this.pager.TotalRecords = sendRedpackRecordRequest.TotalRecords; }
public static DbQueryResult GetSendRedpackRecordRequest(SendRedpackRecordQuery query) { return(new SendRedpackRecordDao().GetSendRedpackRecordRequest(query)); }