/// <summary>
/// Đếm comment cho một blog
/// </summary>
/// <param name="iid"></param>
/// <returns></returns>
public static string CountComment(string iid)
{
string app = TatThanhJsc.BlogModul.CodeApplications.BlogComment;
string condition = DataExtension.AndConditon(
SubitemsTSql.GetByIid(iid),
SubitemsTSql.GetByApp(app),
SubitemsTSql.GetByEnable("1")
);
DataTable dt = Subitems.GetSubItems("", SubitemsColumns.IsidColumn, condition, "");
return(NumberExtension.FormatNumber(dt.Rows.Count.ToString()));
}
void GetBookings(string order)
{
string condition = DataExtension.AndConditon(
SubitemsTSql.GetByApp(app),
SubitemsTSql.GetByLang(language),
SubitemsColumns.IsenableColumn + "<>2"
);
if (tbTitleSearch.Text.Length > 0)
{
condition += " AND " + SearchTSql.GetSearchMathedCondition(tbTitleSearch.Text, SubitemsColumns.VstitleColumn, SubitemsColumns.VsemailColumn);
}
if (order.Length > 0)
{
orderBy = order;
}
else
{
orderBy = CookieExtension.GetCookiesSort(sortCookiesName);
if (orderBy.Length < 1)
{
orderBy = SubitemsColumns.DscreatedateColumn + " desc ";
}
}
DataSet ds = new DataSet();
ds = Subitems.GetSubItemsPagging(p, DdlListShowItem.SelectedValue, condition, orderBy);
DataTable dt = new DataTable();
dt = ds.Tables[1];
LtPagging.Text = PagingExtension.SpilitPages(Convert.ToInt32(dt.Rows[0]["TotalRows"]),
Convert.ToInt16(DdlListShowItem.SelectedValue), Convert.ToInt32(p),
LinkAdmin.UrlAdmin(CodeApplications.Hotel, TypePage.Booking,
ddlCateSearch.SelectedValue, "",
NumberShowItem), "currentPS", "otherPS", "firstPS",
"lastPS", "previewPS", "nextPS");
LtPaggingTop.Text = LtPagging.Text;
rp_mn_users.DataSource = ds.Tables[0];
rp_mn_users.DataBind();
}