string GetInsertedId(string app, string title, string createDate) { string condition = DataExtension.AndConditon( ItemsTSql.GetByApp(app), ItemsTSql.GetByTitle(title), ItemsTSql.GetByCreateDate(createDate) ); DataTable dt = Items.GetItems("1", ItemsColumns.IidColumn, condition, ItemsColumns.IidColumn + " desc"); if (dt.Rows.Count > 0) { return(dt.Rows[0][ItemsColumns.IidColumn].ToString()); } return(""); }
private string GetList(string id, string top) { var s = string.Empty; string fields = "*", condition = "", orderby = ""; int rows = 6; try { rows = int.Parse(top); } catch { } condition = DataExtension.AndConditon( ItemsTSql.GetByEnable("1"), ItemsTSql.GetByApp(app) ); condition = GroupsItemsTSql.GetItemsInGroupCondition(id, condition); orderby = GroupsItemsColumns.IorderColumn; DataTable dt = GroupsItems.GetAllData(rows.ToString(), fields, condition, orderby); if (dt.Rows.Count > 0) { s = ""; string link = "", titleItem = "", desc = "", img = "", dateIT = "", countView = "", listOrther = ""; for (int i = 0; i < dt.Rows.Count; i++) { link = (UrlExtension.WebisteUrl + dt.Rows[i][ItemsColumns.VISEOLINKSEARCHColumn] + RewriteExtension.Extensions).ToLower(); titleItem = dt.Rows[i][ItemsColumns.VititleColumn].ToString(); img = ImagesExtension.GetImage(pic, dt.Rows[i][ItemsColumns.ViimageColumn].ToString(), titleItem, "", true, false, "", false); desc = dt.Rows[i][ItemsColumns.VidescColumn].ToString(); dateIT = ((DateTime)dt.Rows[i][ItemsColumns.DicreatedateColumn]).ToString("dd/MM/yyyy"); countView = NumberExtension.FormatNumber((int.Parse(dt.Rows[i][ItemsColumns.IitotalviewColumn].ToString())).ToString()); s += @" <div class='list-news03__item fade-up'> <div class='list-news03__img img'> <a class='img__crop' href='" + link + "' title='" + titleItem + @"'> " + img + @"</a> </div> <div class='list-news03__content'> <h3 class='list-news03__ttl'><a href='" + link + "' title='" + titleItem + @"'>" + titleItem + @"</a></h3> </div> </div>"; } } return(s); }
void LoadContactDetailContent(string iid) { top = ""; fields = "*"; condition = DataExtension.AndConditon(ItemsTSql.GetItemsByIid(iid), ItemsTSql.GetByApp("QLDDKTV")); orderby = ""; DataTable dt = TatThanhJsc.Database.GroupsItems.GetAllData(top, fields, condition, orderby); if (dt.Rows.Count > 0) { ltrHoten.Text = dt.Rows[0][ItemsColumns.ViauthorColumn].ToString(); ltrEmail.Text = StringExtension.LayChuoi(dt.Rows[0][ItemsColumns.ViparamsColumn].ToString(), "", 1); ltrNoiDung.Text = dt.Rows[0][ItemsColumns.VicontentColumn].ToString(); ltrGuiLuc.Text = ((DateTime)dt.Rows[0][ItemsColumns.DicreatedateColumn]).ToString("dd/MM/yyyy hh:mm:ss tt"); } }
void GetParentCate() { DataTable dt = new DataTable(); fields = "*"; condition = DataExtension.AndConditon( ItemsTSql.GetByLang(language), ItemsTSql.GetByApp(appCate), " IIENABLE <> 2 "); orderBy = ItemsColumns.VititleColumn; dt = Items.GetItems("", fields, condition, orderBy); ddlCateSearch.Items.Add(new ListItem("Chọn tour cần xem bình luận", "")); for (int i = 0; i < dt.Rows.Count; i++) { ddlCateSearch.Items.Add(new ListItem(dt.Rows[i][ItemsColumns.VititleColumn].ToString(), dt.Rows[i][ItemsColumns.IidColumn].ToString())); } ddlCateSearch.SelectedValue = iid; }
void GetBookings(string order) { string condition = DataExtension.AndConditon( ItemsTSql.GetByApp(app), ItemsTSql.GetByLang(language), ItemsColumns.IienableColumn + "<>2" ); if (order.Length > 0) { orderBy = order; } else { orderBy = CookieExtension.GetCookiesSort(sortCookiesName); if (orderBy.Length < 1) { orderBy = ItemsColumns.DicreatedateColumn + " desc "; } } DataSet ds = new DataSet(); ds = Items.GetItemsPagging(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.Tour, TypePage.Booking + "02", ddlCateSearch.SelectedValue, "", NumberShowItem), "currentPS", "otherPS", "firstPS", "lastPS", "previewPS", "nextPS"); LtPaggingTop.Text = LtPagging.Text; rp_mn_users.DataSource = ds.Tables[0]; rp_mn_users.DataBind(); }