public DbQueryResult GetNineImgsesList(NineImgsesQuery query)
{
StringBuilder builder = new StringBuilder();
if (!string.IsNullOrEmpty(query.key))
{
builder.AppendFormat(" ShareDesc LIKE '%{0}%'", DataHelper.CleanSearchString(query.key));
}
return(DataHelper.PagingByRownumber(query.PageIndex, query.PageSize, query.SortBy, query.SortOrder, query.IsCount, "Vshop_ShareMaterial_NineImages ", "id", (builder.Length > 0) ? builder.ToString() : null, "*"));
}
private void BindData()
{
NineImgsesQuery query = new NineImgsesQuery {
key = "",
SortBy = "id",
PageIndex = this.pager.PageIndex,
PageSize = this.pager.PageSize,
SortOrder = SortAction.Desc
};
DbQueryResult nineImgsesList = ShareMaterialBrowser.GetNineImgsesList(query);
this.refriendscircle.DataSource = nineImgsesList.Data;
this.refriendscircle.DataBind();
this.pager.TotalRecords = nineImgsesList.TotalRecords;
}
private void BindData()
{
NineImgsesQuery query = new NineImgsesQuery {
key = this.ShareDesc,
SortBy = "id",
PageIndex = this.pager.PageIndex,
PageSize = this.pager.PageSize,
SortOrder = SortAction.Desc
};
DbQueryResult nineImgsesList = ShareMaterialBrowser.GetNineImgsesList(query);
this.ShareRep.DataSource = nineImgsesList.Data;
this.ShareRep.DataBind();
this.pager.TotalRecords = nineImgsesList.TotalRecords;
this.NineTotal.Text = this.pager.TotalRecords.ToString();
}
public static DbQueryResult GetNineImgsesList(NineImgsesQuery query)
{
return(new ShareMaterialDao().GetNineImgsesList(query));
}