public DbQueryResult GetSendAllRequest(SendAllQuery query)
{
StringBuilder builder = new StringBuilder("1=1");
if (!string.IsNullOrEmpty(query.Title))
{
if (builder.Length > 0)
{
builder.Append(" AND ");
}
builder.AppendFormat(" Title LIKE '%{0}%' )", DataHelper.CleanSearchString(query.Title));
}
builder.AppendFormat(" and wid = '{0}'", query.wid);
return(DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "WeiXin_SendAll ", "ID", (builder.Length > 0) ? builder.ToString() : null, "*"));
}
public DbQueryResult GetSendAllRequest(SendAllQuery query, int Platform = 0)
{
StringBuilder stringBuilder = new StringBuilder();
if (!string.IsNullOrEmpty(query.Title))
{
if (stringBuilder.Length > 0)
{
stringBuilder.Append(" AND ");
}
stringBuilder.AppendFormat(" Title LIKE '%{0}%' ", DataHelper.CleanSearchString(query.Title));
}
if (Platform > -1)
{
if (stringBuilder.Length > 0)
{
stringBuilder.Append(" AND ");
}
stringBuilder.AppendFormat(" platform={0} ", Platform);
}
return(DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "WeiXin_SendAll ", "ID", (stringBuilder.Length > 0) ? stringBuilder.ToString() : null, "*"));
}
private void BindData(int pageno)
{
SendAllQuery sendAllQuery = new SendAllQuery();
sendAllQuery.SortBy = "ID";
sendAllQuery.SortOrder = SortAction.Desc;
Globals.EntityCoding(sendAllQuery, true);
sendAllQuery.PageIndex = pageno;
sendAllQuery.PageSize = this.pager.PageSize;
DbQueryResult sendAllRequest = WeiXinHelper.GetSendAllRequest(sendAllQuery, 0);
this.rptList.DataSource = sendAllRequest.Data;
this.rptList.DataBind();
int totalRecords = sendAllRequest.TotalRecords;
this.pager.TotalRecords = totalRecords;
this.recordcount = totalRecords;
if (this.pager.TotalRecords <= this.pager.PageSize)
{
this.pager.Visible = false;
}
}
public static DbQueryResult GetSendAllRequest(SendAllQuery query, [Optional, DefaultParameterValue(0)] int platform)
{
return(new SendAllDao().GetSendAllRequest(query, platform));
}
public static DbQueryResult GetSendAllRequest(SendAllQuery query)
{
return(new SendAllDao().GetSendAllRequest(query));
}
public static DbQueryResult GetSendAllRequest(SendAllQuery query, int platform = 0)
{
return((new SendAllDao()).GetSendAllRequest(query, platform));
}
