void GetGroupsInDdl() { DataTable dt = new DataTable(); condition = DataExtension.AndConditon( GroupsTSql.GetGroupsByVglang(language), GroupsTSql.GetGroupsByVgapp(app), " igenable <> '2' "); dt = Groups.GetAllGroups("*", condition, ""); DdlGroupTrainTicket.Items.Clear(); DdlGroupTrainTicket.Items.Add(new ListItem("Danh mục gốc", "0")); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { DdlGroupTrainTicket.Items.Add(new ListItem(DropDownListExtension.FormatForDdl(dt.Rows[i]["IGLEVEL"].ToString()) + dt.Rows[i]["VGNAME"].ToString(), dt.Rows[i]["IGID"].ToString())); } } DdlGroupTrainTicket.SelectedValue = hd_parent; }
void LayDanhSachTour(string igid, string iid) { string condition = DataExtension.AndConditon( GroupsItemsTSql.GetItemsInGroupCondition(igid, ""), GroupsTSql.GetGroupsByVglang(lang), GroupsTSql.GetGroupsByIgenable("1"), ItemsTSql.GetItemsByIienable("1"), ItemsTSql.GetItemsByViapp(TatThanhJsc.TourModul.CodeApplications.Tour)); string orderby = ItemsColumns.IiorderColumn + "," + ItemsColumns.DicreatedateColumn + " desc "; DataTable dt = GroupsItems.GetAllData("", " * ", condition, orderby); for (int i = 0; i < dt.Rows.Count; i++) { ddlChuyenDi.Items.Add(new ListItem(dt.Rows[i][ItemsColumns.VititleColumn].ToString(), dt.Rows[i][ItemsColumns.IidColumn].ToString())); } ddlChuyenDi.SelectedValue = iid; }
void GetGroupsInDdl() { DataTable dt = new DataTable(); fields = "*"; condition = DataExtension.AndConditon( GroupsTSql.GetGroupsByVglang(language), GroupsTSql.GetGroupsByVgapp(app), " IGENABLE <> 2 "); orderBy = ""; dt = Groups.GetAllGroups(fields, condition, orderBy); if (dt.Rows.Count > 0) { ddlCateSearch.Items.Add(new ListItem(Developer.ContactKeyword.TatCaDanhMuc, "")); for (int i = 0; i < dt.Rows.Count; i++) { ddlCateSearch.Items.Add(new ListItem(DropDownListExtension.FormatForDdl(dt.Rows[i]["IGLEVEL"].ToString()) + dt.Rows[i]["VGNAME"].ToString(), dt.Rows[i]["IGID"].ToString())); } } }
void OpenUpdatePanel(string igid) { ltrInsertUpdate.Text = "Cập nhật trường"; hdIgid.Value = igid; update = true; pnList.Visible = false; pnInsert.Visible = true; condition = GroupsTSql.GetGroupsByIgid(igid); DataTable dt = new DataTable(); dt = Groups.GetGroups("", "*", condition, ""); if (dt.Rows.Count > 0) { tbName.Text = dt.Rows[0][GroupsColumns.VgnameColumn].ToString(); tbKey.Text = dt.Rows[0][GroupsColumns.VgdescColumn].ToString(); tbOrder.Text = dt.Rows[0][GroupsColumns.IgorderColumn].ToString(); ddlStatus.SelectedValue = dt.Rows[0][GroupsColumns.IgenableColumn].ToString(); ddlTextEditor.SelectedValue = dt.Rows[0][GroupsColumns.VgparamsColumn].ToString(); } }
void GetGroupsInDdl() { DataTable dt = new DataTable(); fields = "*"; condition = DataExtension.AndConditon( GroupsTSql.GetGroupsByVglang(language), GroupsTSql.GetGroupsByVgapp(app), " IGENABLE <> 2 "); orderBy = ""; dt = Groups.GetAllGroups(fields, condition, orderBy); if (dt.Rows.Count > 0) { ddl_group_ontab.Items.Add(new ListItem("Tất cả danh mục quảng cáo", "")); for (int i = 0; i < dt.Rows.Count; i++) { ddl_group_ontab.Items.Add(new ListItem(DropDownListExtension.FormatForDdl(dt.Rows[i]["IGLEVEL"].ToString()) + dt.Rows[i]["VGNAME"].ToString(), dt.Rows[i]["IGID"].ToString())); } } }
string LayThoiGianTour(string igid) { string s = ""; DataTable dt = new DataTable(); string fields = " * "; string condition = DataExtension.AndConditon( GroupsTSql.GetByApp(CodeApplications.TourVehicle), GroupsTSql.GetGroupsByIgid(igid), GroupsTSql.GetByLang(lang) ); string orderBy = GroupsColumns.IgorderColumn + "," + GroupsColumns.VgnameColumn; dt = Groups.GetGroups("1", fields, condition, orderBy); if (dt.Rows.Count > 0) { s = dt.Rows[0][GroupsColumns.VgName].ToString(); } return(s); }
void LoadContactDetailContent(string iid) { top = ""; fields = "*"; condition = DataExtension.AndConditon(ItemsTSql.GetItemsByIid(iid), GroupsTSql.GetGroupsByVgapp(modul)); 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 = dt.Rows[0][ItemsColumns.VidescColumn].ToString(); ltrDiaChi.Text = StringExtension.LayChuoi(dt.Rows[0][ItemsColumns.ViparamsColumn].ToString(), "", 2); ltrDienthoai.Text = StringExtension.LayChuoi(dt.Rows[0][ItemsColumns.ViparamsColumn].ToString(), "", 1); ltrGuiDen.Text = dt.Rows[0][GroupsColumns.VgnameColumn].ToString(); ltrTieuDe.Text = dt.Rows[0][ItemsColumns.VititleColumn].ToString(); 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 InitialControlsValue(bool insert) { #region update if (!insert) { LtInsertUpdate.Text = Developer.HotelKeyword.CapNhatNhomHotel; btOK.Text = "Đồng ý"; ckbContinue.Visible = false; fields = "*"; condition = GroupsTSql.GetGroupsByIgid(igid); DataTable dt = new DataTable(); dt = Groups.GetGroups(top, fields, condition, orderBy); DdlPosition.SelectedValue = dt.Rows[0]["VGPARAMS"].ToString(); DdlGroupProduct.SelectedValue = dt.Rows[0][GroupsColumns.VGSEOMETACANONICALColumn].ToString(); tbTitle.Text = dt.Rows[0]["VGNAME"].ToString(); flAnhDaiDien.Load(dt.Rows[0][GroupsColumns.VgimageColumn].ToString()); tbOrder.Text = dt.Rows[0]["IGORDER"].ToString(); tbDesc.Text = dt.Rows[0][TatThanhJsc.Columns.GroupsColumns.VgdescColumn].ToString(); tbMaxItem.Text = dt.Rows[0][TatThanhJsc.Columns.GroupsColumns.IgtotalitemsColumn].ToString(); #region SEO tbSeoLink.Text = dt.Rows[0]["VGSEOLINK"].ToString(); tbSeoTitle.Text = dt.Rows[0]["VGSEOTITLE"].ToString(); tbSeoKeyword.Text = dt.Rows[0]["VGSEOMETAKEY"].ToString(); tbSeoDescription.Text = dt.Rows[0]["VGSEOMETADESC"].ToString(); #endregion cbStatus.Checked = dt.Rows[0]["IGENABLE"].ToString() == "1"; } #endregion #region insert else { LtInsertUpdate.Text = Developer.HotelKeyword.TaoNhomMoi; btOK.Text = "Đồng ý"; } #endregion }
void GetCate() { DataTable dt = new DataTable(); fields = " * "; condition = GroupsTSql.GetGroupsCondition(language, Modul, "", " IGENABLE <> '2' "); if (ddl_type_groupnews_show.SelectedIndex > 0) { condition = DataExtension.AndConditon( condition, GroupsTSql.GetGroupsByIgtotalitems(ddl_type_groupnews_show.SelectedValue)); } orderBy = " IGORDER ASC "; dt = Groups.GetGroups(top, fields, condition, orderBy); if (dt.Rows.Count > 0) { LtCates.Text += "<div id=\"CateOrder-0\" >"; LtCates.Text += DisplayCate(dt); LtCates.Text += "</div>"; } }
private string GetGroupsAdv(string position, string cssImage) { string s = ""; string fields = DataExtension.GetListColumns(GroupsColumns.IgidColumn, GroupsColumns.VgnameColumn); string orderby = GroupsColumns.IgorderColumn; string condition = DataExtension.AndConditon( GroupsTSql.GetGroupsByVgapp(app), GroupsTSql.GetGroupsByIgenable("1"), GroupsTSql.GetGroupsByVgparams(position), GroupsTSql.GetGroupsByVglang(lang) ); DataTable dt = new DataTable(); dt = Groups.GetGroups("", fields, condition, orderby); for (int i = 0; i < dt.Rows.Count; i++) { s += GetListAdv(dt.Rows[i][GroupsColumns.IgidColumn].ToString(), cssImage); } return(s); }
void LayThuocTinh() { string app = CodeApplications.CruisesProperty; string fields = DataExtension.GetListColumns(GroupsColumns.IgidColumn, GroupsColumns.VgnameColumn, GroupsColumns.VgimageColumn); string condition = DataExtension.AndConditon( GroupsTSql.GetGroupsByVgapp(app), GroupsTSql.GetGroupsByIgparentid("0"), GroupsTSql.GetGroupsByVglang(lang), GroupsColumns.IgenableColumn + "<>2" ); string orderBy = GroupsColumns.IgorderColumn + "," + GroupsColumns.VgnameColumn; DataTable dt = Groups.GetGroups("", fields, condition, orderBy); for (int i = 0; i < dt.Rows.Count; i++) { cblThuocTinh.Items.Add( new ListItem( ImagesExtension.GetImage(pic, dt.Rows[i][GroupsColumns.VgimageColumn].ToString(), dt.Rows[i][GroupsColumns.VgnameColumn].ToString(), "imgProp", false, false, "") + dt.Rows[i][GroupsColumns.VgnameColumn].ToString(), dt.Rows[i][GroupsColumns.IgidColumn].ToString())); } }
/// <summary> /// Lấy thông tin bản đồ. Hiện Hoà đang cho lấy bản đồ của phòng ban đầu tiên /// </summary> void GetMapInfo() { string condition = DataExtension.AndConditon( GroupsTSql.GetGroupsByVgapp(app), GroupsTSql.GetGroupsByIgenable("1"), GroupsTSql.GetGroupsByVglang(lang), GroupsTSql.GetGroupsByIgparentid("0") ); string order = GroupsColumns.IgorderColumn; DataTable dt = Groups.GetGroups("1", "*", condition, order); if (dt.Rows.Count > 0) { string content = dt.Rows[0][GroupsColumns.VgcontentColumn].ToString(); Lng = StringExtension.LayChuoi(content, "", 5); Lat = StringExtension.LayChuoi(content, "", 6); InfoWindow = dt.Rows[0][GroupsColumns.VgName].ToString(); ltrMaps.Text = dt.Rows[0][GroupsColumns.VgParams].ToString(); } }
/// <summary> /// Lấy thông tin của các trường khác trong item /// </summary> private void LoadSubInfo() { #region Không cần thay đổi DataTable dt = new DataTable(); condition = DataExtension.AndConditon( GroupsTSql.GetGroupsByIgid(igid.Value), ItemsTSql.GetItemsByIienable("1"), ItemsTSql.GetItemsByViapp(subApp) ); dt = GroupsItems.GetAllData("1", "*", condition, "groups_items.igiid desc"); #endregion if (dt.Rows.Count > 0) { iid.Value = dt.Rows[0][ItemsColumns.IidColumn].ToString(); //Điền dữ liệu ra các controls theo vị trí mà lập trình đã lưu vào. //Hiện lên khi cần dùng //tbYouTubeCode.Text = dt.Rows[0][ItemsColumns.VititleColumn].ToString(); } }
private void LayLienKetDiemDenSeQua() { string app = TatThanhJsc.DestinationModul.CodeApplications.Destination; string fields = DataExtension.GetListColumns(GroupsColumns.IgidColumn, GroupsColumns.VgnameColumn, GroupsColumns.IglevelColumn); string condition = DataExtension.AndConditon( GroupsTSql.GetGroupsByVgapp(app), GroupsTSql.GetGroupsByIgparentid("0"), GroupsTSql.GetGroupsByVglang(lang), GroupsColumns.IgenableColumn + "<>2" ); string orderBy = GroupsColumns.IgorderColumn + "," + GroupsColumns.VgnameColumn; DataTable dt = Groups.GetGroups("", fields, condition, orderBy); for (int i = 0; i < dt.Rows.Count; i++) { ltrCacDiemDenChuaChon.Text += @" <div class='dest0'> <label for='cbd_0_" + dt.Rows[i][GroupsColumns.IgidColumn] + "'><input id='cbd_0_" + dt.Rows[i][GroupsColumns.IgidColumn] + "' type='checkbox'/>" + dt.Rows[i][GroupsColumns.VgnameColumn] + @"</label> " + LayLienKetDiemDenSeQua_Cap2(dt.Rows[i][GroupsColumns.IgidColumn].ToString(), dt.Rows[i][GroupsColumns.IglevelColumn].ToString()) + @" </div>"; } }
private string GetGroupsAdv(string position, string cssImage) { string s = ""; string fields = DataExtension.GetListColumns(GroupsColumns.IgidColumn, GroupsColumns.VgnameColumn, GroupsColumns.VgdescColumn); string orderby = GroupsColumns.IgorderColumn; string condition = DataExtension.AndConditon( GroupsTSql.GetGroupsByVgapp(app), GroupsTSql.GetGroupsByIgenable("1"), GroupsTSql.GetGroupsByVgparams(position), GroupsTSql.GetGroupsByVglang(lang) ); DataTable dt = new DataTable(); dt = Groups.GetGroups("", fields, condition, orderby); if (dt.Rows.Count > 0) { s += @" <div class='section about-us'> <div class='container'> <div class='list'> <h2> <a href='#' class='title list-title txtCenter fSize-34 fSize-sm-26 nb-color-m1'>" + dt.Rows[0][GroupsColumns.VgnameColumn].ToString() + @"</a> </h2> <p class='list-text hed txtCenter'>" + dt.Rows[0][GroupsColumns.VgdescColumn].ToString() + @"</p> <div class='list-body'> <div class='row'> " + GetListAdv(dt.Rows[0][GroupsColumns.IgidColumn].ToString(), cssImage) + @" </div> </div> </div> </div> </div>"; } return(s); }
private string GetCateRoads(string igParentId) { string s = ""; string condition = DataExtension.AndConditon( GroupsTSql.GetGroupsByIgenable("1"), GroupsTSql.GetGroupsByVgapp(app), GroupsTSql.GetGroupsByVglang(lang), "charindex(','+cast(" + GroupsColumns.IgidColumn + " as varchar)+',','" + igParentId + "')>0" //Lấy danh sách cha của cate hiện tại ); string orderby = "len(" + GroupsColumns.IgparentsidColumn + ")"; //Order theo chiều dài của trường danh sách cha để các cate cha hiện trước string fields = DataExtension.GetListColumns(GroupsColumns.VgnameColumn, GroupsColumns.VGSEOLINKSEARCHColumn); DataTable dt = Groups.GetGroups("", fields, condition, orderby); for (int i = 0; i < dt.Rows.Count; i++) { s += "<li class='element'><a class='link' href='" + UrlExtension.WebisteUrl + dt.Rows[i][GroupsColumns.VGSEOLINKSEARCHColumn].ToString().ToLower() + RewriteExtension.Extensions + "' title='" + dt.Rows[i][GroupsColumns.VgnameColumn] + "'><span>" + dt.Rows[i][GroupsColumns.VgnameColumn] + "</span><i class='fa fa-angle-right' aria-hidden='true'></i></a></li>"; } return(s); }
void LayLienKetBaoGom() { string app = CodeApplications.HotelFacilityRoom; string fields = DataExtension.GetListColumns(GroupsColumns.IgidColumn, GroupsColumns.VgnameColumn); string condition = DataExtension.AndConditon( GroupsTSql.GetGroupsByVgapp(app), GroupsTSql.GetGroupsByIgparentid("0"), GroupsTSql.GetGroupsByVglang(lang), GroupsColumns.IgenableColumn + "<>2" ); string orderBy = GroupsColumns.IgorderColumn + "," + GroupsColumns.VgnameColumn; DataTable dt = Groups.GetGroups("", fields, condition, orderBy); //DataRow dr = dt.NewRow(); //dr[0] = "0"; //dr[1] = "Chọn/bỏ tất cả"; //dt.Rows.InsertAt(dr,0); cblBaoGom.DataSource = dt; cblBaoGom.DataTextField = GroupsColumns.VgnameColumn; cblBaoGom.DataValueField = GroupsColumns.IgidColumn; cblBaoGom.DataBind(); }
private string GetCate(string igid) { string s = ""; string condition = DataExtension.AndConditon( GroupsTSql.GetGroupsByIgenable("1"), GroupsTSql.GetGroupsByVgapp(app), GroupsTSql.GetGroupsByVglang(lang), GroupsTSql.GetGroupsByIgid(igid) ); string fields = DataExtension.GetListColumns(GroupsColumns.VgnameColumn, GroupsColumns.VgdescColumn, GroupsColumns.VGSEOLINKSEARCHColumn); string orderby = GroupsColumns.IgOrder + " desc "; DataTable dt = Groups.GetGroups("1", fields, condition, orderby); if (dt.Rows.Count > 0) { s = StringExtension.GhepChuoi("", dt.Rows[0][GroupsColumns.VgnameColumn].ToString(), dt.Rows[0][GroupsColumns.VgdescColumn].ToString(), dt.Rows[0][GroupsColumns.VGSEOLINKSEARCHColumn].ToString()); } return(s); }
string GetCate() { string s = ""; if (igparentidCurrent.Equals("0")) { DataTable dt = new DataTable(); fields = "*"; condition = GroupsTSql.GetGroupsCondition(language, Modul, "", " IGENABLE <> '2' "); orderBy = " IGORDER ASC "; dt = Groups.GetGroups(top, fields, condition, orderBy); if (dt.Rows.Count > 0) { s += cateControls.DisplayCate(dt); } } else { s = cateControls.GetSubCate(igparentidCurrent); } return(s); }
string StatusGroupParent(string igparentid) { string str = ""; top = " 1 "; fields = " * "; condition = DataExtension.AndConditon(GroupsTSql.GetGroupsByVgapp(Modul), GroupsTSql.GetGroupsByIgid(igparentid)); orderBy = ""; DataTable dt = new DataTable(); dt = Groups.GetGroups("1", "*", condition, orderBy); if (igparentid.Equals("0")) { str = "1"; } else if (dt.Rows.Count > 0) { str = dt.Rows[0]["IGENABLE"].ToString(); } return(str); }
public string GetSubCate(string igparentid) { top = ""; fields = " * "; condition = DataExtension.AndConditon(GroupsTSql.GetGroupsByVgapp(app), GroupsTSql.GetGroupsByVglang(language), GroupsTSql.GetGroupsByIgparentid(igparentid), " IGENABLE <> '2' "); orderBy = " IGORDER ASC "; DataTable dt = new DataTable(); dt = Groups.GetGroups(top, fields, condition, orderBy); string s = ""; if (dt.Rows.Count > 0) { s += "<div id=\"CateOrder-" + igparentid + "\" >"; TxtLevel += "..."; s += DisplaySubCate(dt, igparentid); s += "</div>"; TxtLevel = TxtLevel.Remove(TxtLevel.Length - "...".Length); } return(s); }
void GetGroupsInDdl() { DataTable dt = new DataTable(); dt = Groups.GetAllGroups("*", DataExtension.AndConditon(GroupsTSql.GetGroupsByVgapp(app) + " AND IGENABLE <> '2' ", GroupsTSql.GetGroupsByVglang(language)), ""); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { ddl_group_product.Items.Add(new ListItem(DropDownListExtension.FormatForDdl(dt.Rows[i]["IGLEVEL"].ToString()) + dt.Rows[i]["VGNAME"].ToString(), dt.Rows[i]["IGID"].ToString())); } } if (!igid.Equals("")) { ddl_group_product.SelectedValue = igid; } #region Hiển thị các danh mục ra checkboxlist for (int i = 0; i < dt.Rows.Count; i++) { cbListCates.Items.Add(new ListItem(DropDownListExtension.FormatForDdl(dt.Rows[i]["IGLEVEL"].ToString()) + dt.Rows[i]["VGNAME"], dt.Rows[i]["IGID"].ToString())); } #endregion }
private void GetAllTag() { condition = DataExtension.AndConditon( GroupsTSql.GetGroupsByVgapp(app), GroupsTSql.GetGroupsByIgparentid("0"), GroupsTSql.GetGroupsByIgenable("1") ); if (ddlTagModul.SelectedValue.Length > 0) { condition = DataExtension.AndConditon(condition, GroupsTSql.GetGroupsByVgparams(ddlTagModul.SelectedValue)); } fields = DataExtension.GetListColumns(GroupsColumns.VgnameColumn, GroupsColumns.IgidColumn); orderby = GroupsColumns.VgnameColumn; DataTable dt = new DataTable(); dt = Groups.GetGroups("", fields, condition, orderby); cblListTag.DataSource = dt; cblListTag.DataTextField = GroupsColumns.VgnameColumn; cblListTag.DataValueField = GroupsColumns.IgidColumn; cblListTag.DataBind(); }
protected string LoadMenu() { string top = ""; string field = "*"; string condition = DataExtension.AndConditon( GroupsTSql.GetGroupsByVgapp(app), GroupsTSql.GetGroupsByIgparentid("0"), GroupsTSql.GetGroupsByIgenable("1"), GroupsTSql.GetGroupsByVglang(lang)); string orderby = GroupsColumns.IgorderColumn; DataTable dt = Groups.GetGroups(top, field, condition, orderby); string s = ""; if (dt.Rows.Count > 0) { string link = ""; string subMenus = ""; for (int i = 0; i < dt.Rows.Count; i++) { link = RewriteExtension.GetLinkMenu(dt.Rows[i][GroupsColumns.VgdescColumn].ToString()); subMenus = LoadChildMenu(dt.Rows[i][GroupsColumns.IgidColumn].ToString(), dt.Rows[i][GroupsColumns.VgdescColumn].ToString(), "", "1"); s += @" <li class='litop item " + (subMenus != "" ? "nb-dropdown" : "") + @"'> <a class='item-link' href='" + link + @"' " + MenuExtension.GetTarget(dt.Rows[i][GroupsColumns.VgparamsColumn].ToString()) + @" title='" + dt.Rows[i][GroupsColumns.VgnameColumn] + @"'> <span>" + dt.Rows[i][GroupsColumns.VgnameColumn] + @"</span> </a> " + subMenus + @" </li>"; } } return(s); }
void GetService(string order) { DdlListShowItem.SelectedValue = NumberShowItem; if (!igid.Equals("")) { ddl_group_ontab.SelectedValue = igid; conditionItems = GroupsItemsTSql.GetItemsInGroupCondition(ddl_group_ontab.SelectedValue, ""); } else { conditionItems = DataExtension.AndConditon( "VGAPP = '" + app + "'", GroupsTSql.GetGroupsByVglang(language)); } conditionItems = DataExtension.AndConditon(conditionItems, ItemsTSql.GetItemsByViapp(app)); #region Lọc với tính năng duyệt tin if (ServiceConfig.KeyDuyetTin) { pnStatus.Visible = false; keyHide = "dn"; string userId = CookieExtension.GetCookies("userId"); if (HorizaMenuConfig.ShowDuyetTin1 || HorizaMenuConfig.ShowDuyetTin2) { conditionItems += " AND VIURL = '" + userId + "' "; } } #endregion conditionItems += " AND IIENABLE = '2' "; if (txt_key.Text.Length > 0 && !txt_key.Text.Equals(strdisplay)) { SearchCondition = " AND " + SearchTSql.GetSearchMathedCondition(txt_key.Text, ItemsColumns.VititleColumn); } if (txt_key.Text.Equals(strdisplay)) { txt_key.Text = ""; } if (order.Length > 0) { orderBy = order; } else { orderBy = CookieExtension.GetCookiesSort(sortCookiesName); if (orderBy.Length < 1) { orderBy = " DCREATEDATE DESC "; } } DataSet ds = new DataSet(); ds = GroupsItems.GetAllDataPagging(p, NumberShowItem, conditionItems + SearchCondition, orderBy); DataTable dt = new DataTable(); dt = ds.Tables[1]; LtPagging.Text = PagingExtension.SpilitPages(Convert.ToInt32(dt.Rows[0]["TotalRows"]), Convert.ToInt16(NumberShowItem), Convert.ToInt32(p), LinkAdmin.UrlAdmin(CodeApplications.Service, TypePage.RecycleItem, ddl_group_ontab.SelectedValue, txt_key.Text, NumberShowItem), "currentPS", "otherPS", "firstPS", "lastPS", "previewPS", "nextPS"); rp_mn_users.DataSource = ds.Tables[0]; rp_mn_users.DataBind(); }
void InitialControlsValue(bool insert) { #region update if (!insert) { btn_insert_update.Text = "Đồng ý"; ckbContinue.Visible = false; fields = "*"; condition = DataExtension.AndConditon(GroupsTSql.GetGroupsByVgapp(app), ItemsTSql.GetItemsByIid(iid)); DataTable dt = new DataTable(); dt = GroupsItems.GetAllData(top, fields, condition, orderBy); lnk_delete_Image_current.Visible = true; ddl_group_product.SelectedValue = dt.Rows[0]["IGID"].ToString(); txt_title.Text = dt.Rows[0]["VITITLE"].ToString(); txt_description.Text = dt.Rows[0]["VIDESC"].ToString(); txt_content.Text = dt.Rows[0]["VICONTENT"].ToString(); hdOldService.Value = dt.Rows[0]["VICONTENT"].ToString(); #region SEO textLinkRewrite.Text = dt.Rows[0]["VISEOLINK"].ToString(); textTagTitle.Text = dt.Rows[0]["VISEOTITLE"].ToString(); textTagKeyword.Text = dt.Rows[0]["VISEOMETAKEY"].ToString(); textTagDescription.Text = dt.Rows[0]["VISEOMETADESC"].ToString(); #endregion txtCreateDate.Text = dt.Rows[0]["DCREATEDATE"].ToString(); #region Image if (!dt.Rows[0]["VIIMAGE"].ToString().Equals("")) { ltimg.Text = TatThanhJsc.Extension.ImagesExtension.GetImage(pic, dt.Rows[0]["VIIMAGE"].ToString(), "", "imgItem", false, false, "", false); lnk_delete_Image_current.Visible = true; } else { ltimg.Visible = false; lnk_delete_Image_current.Visible = false; } hd_img.Value = dt.Rows[0]["VIIMAGE"].ToString(); if (hd_img.Value.Length < 1) { cbLayAnhTuNoiDung.Checked = true; } else { cbLayAnhTuNoiDung.Checked = false; } #endregion HdIitotalview.Value = dt.Rows[0]["IITOTALVIEW"].ToString(); #region IIENABLE if (dt.Rows[0]["IIENABLE"].ToString().Equals("0")) { chk_status.Checked = false; } else { chk_status.Checked = true; } #endregion tbKey.Text = dt.Rows[0][ItemsColumns.VikeyColumn].ToString(); tbOrder.Text = dt.Rows[0][ItemsColumns.IiorderColumn].ToString(); tbDanhSachTepDinhKem.Text = dt.Rows[0][ItemsColumns.ViurlColumn].ToString(); #region ThuocTinhDichVu-Chi thực hiện khi chức năng Quản lý thuộc tính được hiển thị if (ServiceConfig.KeyHienThiQuanLyThuocTinhDichVu) { string properties = ""; condition = TatThanhJsc.Extension.DataExtension.AndConditon( TatThanhJsc.TSql.SubitemsTSql.GetSubitemsByIid(iid), TatThanhJsc.TSql.SubitemsTSql.GetSubitemsByVskey(propertyModul)); fields = SubitemsColumns.VscontentColumn; dt = Subitems.GetSubItems("", fields, condition, ""); if (dt.Rows.Count > 0) { properties = dt.Rows[0][SubitemsColumns.VscontentColumn].ToString(); } for (int i = 0; i < rptProperties.Items.Count; i++) { CheckBox checkBoxProperties = (CheckBox)rptProperties.Items[i].FindControl("checkBoxProperties"); if (properties.IndexOf(parramSpitString + checkBoxProperties.ToolTip + parramSpitString) > -1) { checkBoxProperties.Checked = true; } else { checkBoxProperties.Checked = false; } } } #endregion } #endregion #region insert else { btn_insert_update.Text = "Đồng ý"; txtCreateDate.Text = DateTime.Now.ToString(); txt_title.Focus(); } #endregion }
void GetGroupsPhotoAlbum() { fields = " * "; string conditionItem = ""; conditionItem = TatThanhJsc.Extension.DataExtension.AndConditon(GroupsTSql.GetGroupsByVglang(language), GroupsTSql.GetGroupsByVgapp(app)); if (!ddl_type_groupnew_show.SelectedValue.Equals("")) { conditionItem += " AND VGPARAMS = " + ddl_type_groupnew_show.SelectedValue; } DataTable dt_Groups = new DataTable(); dt_Groups = Groups.GetAllGroups(fields, conditionItem, ""); if (dt_Groups.Rows.Count > 0) { for (int i = 0; i < dt_Groups.Rows.Count; i++) { condition = GroupsItemsTSql.GetItemsInGroupCondition(dt_Groups.Rows[i]["IGID"].ToString(), " [GROUPS_ITEMS].IID = '" + iid + "' "); DataTable dt = new DataTable(); dt = GroupsItems.GetAllData(top, fields, condition, orderBy); if (dt.Rows.Count > 0) { lstadded.Items.Add(new ListItem(dt_Groups.Rows[i]["VGNAME"].ToString(), dt_Groups.Rows[i]["IGID"].ToString())); } else { lstnotadded.Items.Add(new ListItem(dt_Groups.Rows[i]["VGNAME"].ToString(), dt_Groups.Rows[i]["IGID"].ToString())); } } } }
void GetNew(string order) { if (!igid.Equals("")) { ddlCateSearch.SelectedValue = igid; condition = GroupsItemsTSql.GetItemsInGroupCondition(ddlCateSearch.SelectedValue, ItemsTSql.GetItemsByViapp(app)); } else { condition = DataExtension.AndConditon( "VGAPP = '" + app + "'", GroupsTSql.GetGroupsByVglang(language)); } #region Hiển thị bài đã duyệt theo trạng thái phân quyền string userRole = CookieExtension.GetCookies("RolesUser"); condition += " AND VIURL = '" + userId + "' "; if (HorizaMenuConfig.ShowDuyetTin2) { if (StringExtension.RoleInListRoles(PhanQuyen.DuyetTin.Cap1, userRole)) { #region Với tài khoản cấp 1 (phóng viên, biên tập viên) condition += " AND IIENABLE = '" + PhanQuyen.DuyetTin.Cap1 + "' "; #endregion } else if (StringExtension.RoleInListRoles(PhanQuyen.DuyetTin.Cap2, userRole)) { #region Với tài khoản cấp 2 (tổng biên tập) condition += " AND IIENABLE = '" + PhanQuyen.DuyetTin.Cap2 + "' "; #endregion } } else if (HorizaMenuConfig.ShowDuyetTin1) { if (StringExtension.RoleInListRoles(PhanQuyen.DuyetTin.Cap2, userRole)) { #region Với tài khoản cấp 1 (phóng viên, biên tập viên) condition += " AND IIENABLE = '" + PhanQuyen.DuyetTin.Cap2 + "' "; #endregion } } #endregion if (tbKeySearch.Text.Length > 0) { condition += " AND " + SearchTSql.GetSearchMathedCondition(tbKeySearch.Text, ItemsColumns.VikeyColumn); } if (tbTitleSearch.Text.Length > 0) { condition += " AND " + SearchTSql.GetSearchMathedCondition(tbTitleSearch.Text, ItemsColumns.VititleColumn); } if (order.Length > 0) { orderBy = order; } else { orderBy = CookieExtension.GetCookiesSort(sortCookiesName); if (orderBy.Length < 1) { orderBy = " DCREATEDATE DESC "; } } DataSet ds = new DataSet(); ds = GroupsItems.GetAllDataPagging(p, DdlListShowItem.SelectedValue, condition, orderBy); DataTable dt = new DataTable(); dt = ds.Tables[1]; string key = tbKeySearch.Text + "&name=" + tbTitleSearch.Text; LtPagging.Text = PagingExtension.SpilitPages(Convert.ToInt32(dt.Rows[0]["TotalRows"]), Convert.ToInt16(DdlListShowItem.SelectedValue), Convert.ToInt32(p), LinkAdmin.UrlAdmin(app, "QuanLyBaiVietChoPheDuyet", ddlCateSearch.SelectedValue, key, NumberShowItem), "currentPS", "otherPS", "firstPS", "lastPS", "previewPS", "nextPS"); LtPaggingTop.Text = LtPagging.Text; rp_mn_users.DataSource = ds.Tables[0]; rp_mn_users.DataBind(); }
void InitialControlsValue(bool insert) { #region update if (!insert) { LtInsertUpdate.Text = Developer.TourKeyword.CapNhatBaiViet; btOK.Text = "Đồng ý"; cbTiepTuc.Visible = false; string fields = "*"; string condition = DataExtension.AndConditon(GroupsTSql.GetGroupsByVgapp(appCate), ItemsTSql.GetItemsByIid(iid)); DataTable dt = GroupsItems.GetAllData("1", fields, condition, ""); hdGroupsItemId.Value = dt.Rows[0][GroupsItemsColumns.IgiidColumn].ToString(); ddlParentCate.SelectedValue = dt.Rows[0]["IGID"].ToString(); tbTenTour.Text = dt.Rows[0][ItemsColumns.VititleColumn].ToString(); tbMaTour.Text = dt.Rows[0][ItemsColumns.VikeyColumn].ToString(); flAnhDaiDien.Load(dt.Rows[0][ItemsColumns.ViimageColumn].ToString()); tbMoTa.Text = dt.Rows[0][ItemsColumns.VidescColumn].ToString(); tbGiaNiemYet.Text = dt.Rows[0][ItemsColumns.FipriceColumn].ToString(); tbGiaKhuyenMai.Text = dt.Rows[0][ItemsColumns.FisalepriceColumn].ToString(); tbNgayKhoiHanh.Text = dt.Rows[0][ItemsColumns.VISEOMETAPARAMSColumn].ToString(); tbXuatPhat.Text = StringExtension.LayChuoi(dt.Rows[0][ItemsColumns.VicontentColumn].ToString(), "", 1); tbPhuongTien.Text = StringExtension.LayChuoi(dt.Rows[0][ItemsColumns.VicontentColumn].ToString(), "", 2); tbYoutubeEmbed.Text = StringExtension.LayChuoi(dt.Rows[0][ItemsColumns.VicontentColumn].ToString(), "", 3); tbMaDinhKemBanDoTour.Text = StringExtension.LayChuoi(dt.Rows[0][ItemsColumns.VicontentColumn].ToString(), "", 4); tbGioKhoiHanh.Text = StringExtension.LayChuoi(dt.Rows[0][ItemsColumns.VicontentColumn].ToString(), "", 5); #region SEO tbSeoLink.Text = dt.Rows[0]["VISEOLINK"].ToString(); tbSeoTitle.Text = dt.Rows[0]["VISEOTITLE"].ToString(); tbSeoKeyword.Text = dt.Rows[0]["VISEOMETAKEY"].ToString(); tbSeoDescription.Text = dt.Rows[0]["VISEOMETADESC"].ToString(); #endregion tbThuTu.Text = dt.Rows[0][ItemsColumns.IiorderColumn].ToString(); cbTrangThai.Checked = (dt.Rows[0][ItemsColumns.IienableColumn].ToString() == "1"); tbNgayDang.Text = dt.Rows[0][ItemsColumns.DicreatedateColumn].ToString(); hdTotalView.Value = dt.Rows[0][ItemsColumns.IitotalviewColumn].ToString(); tbGiaChoNguoiLon.Text = StringExtension.LayChuoi(dt.Rows[0][ItemsColumns.VISEOMETACANONICALColumn].ToString(), "", 1); tbGiaChoTreViThanhNien.Text = StringExtension.LayChuoi(dt.Rows[0][ItemsColumns.VISEOMETACANONICALColumn].ToString(), "", 2); tbGiaChoTreEm.Text = StringExtension.LayChuoi(dt.Rows[0][ItemsColumns.VISEOMETACANONICALColumn].ToString(), "", 3); tbGiaChoEmBe.Text = StringExtension.LayChuoi(dt.Rows[0][ItemsColumns.VISEOMETACANONICALColumn].ToString(), "", 4); ddlThoiGianTour.SelectedValue = dt.Rows[0][ItemsColumns.ViurlColumn].ToString(); ddlDiemDen.SelectedValue = dt.Rows[0][ItemsColumns.ViauthorColumn].ToString(); } #endregion #region insert else { LtInsertUpdate.Text = Developer.TourKeyword.ThemMoiBaiViet; btOK.Text = "Đồng ý"; tbNgayDang.Text = DateTime.Now.ToString(); tbTenTour.Focus(); } #endregion }
void InitialControlsValue(bool insert) { #region update if (!insert) { LtInsertUpdate.Text = Developer.WebsiteKeyword.CapNhatNhomBaiVietMoi; btn_insert_update.Text = "Đồng ý"; ckbContinue.Visible = false; fields = "*"; condition = GroupsTSql.GetGroupsByIgid(igid); DataTable dt = new DataTable(); dt = Groups.GetGroups(top, fields, condition, orderBy); txt_title_modul.Text = dt.Rows[0]["VGNAME"].ToString(); ltimg.Text = ImagesExtension.GetImage(pic, dt.Rows[0]["VGIMAGE"].ToString(), "", "adm_img_product", false, false, "", false); if (ltimg.Text.Length > 0) { btnXoaAnhHienTai.Visible = true; hd_img.Value = dt.Rows[0]["VGIMAGE"].ToString(); } txt_ordermodul.Text = dt.Rows[0]["IGORDER"].ToString(); txtDesc.Text = dt.Rows[0][TatThanhJsc.Columns.GroupsColumns.VgdescColumn].ToString(); #region SEO textLinkRewrite.Text = dt.Rows[0]["VGSEOLINK"].ToString(); textTagTitle.Text = dt.Rows[0]["VGSEOTITLE"].ToString(); textTagKeyword.Text = dt.Rows[0]["VGSEOMETAKEY"].ToString(); textTagDescription.Text = dt.Rows[0]["VGSEOMETADESC"].ToString(); #endregion if (dt.Rows[0]["IGENABLE"].ToString().Equals("0")) { chk_status.Checked = false; } else { chk_status.Checked = true; } #region Địa chỉ, điện thoại, fax, email, gmap string content = dt.Rows[0][TatThanhJsc.Columns.GroupsColumns.VgcontentColumn].ToString(); tbDiaChi.Text = StringExtension.LayChuoi(content, "", 1); tbDienThoai.Text = StringExtension.LayChuoi(content, "", 2); tbFax.Text = StringExtension.LayChuoi(content, "", 3); tbEmail.Text = StringExtension.LayChuoi(content, "", 4); tbKinhDo.Text = StringExtension.LayChuoi(content, "", 5); tbViDo.Text = StringExtension.LayChuoi(content, "", 6); lat = tbViDo.Text; lng = tbKinhDo.Text; infoWindow = tbDiaChi.Text; #endregion tbCreateDate.Text = dt.Rows[0][TatThanhJsc.Columns.GroupsColumns.DgcreatedateColumn].ToString(); tbEndDate.Text = dt.Rows[0][TatThanhJsc.Columns.GroupsColumns.DgenddateColumn].ToString(); } #endregion #region insert else { LtInsertUpdate.Text = Developer.WebsiteKeyword.TaoNhomBaiVietMoi; btn_insert_update.Text = "Đồng ý"; tbCreateDate.Text = DateTime.Now.ToString(); tbEndDate.Text = DateTime.MaxValue.ToString(); } #endregion }