void GetAllModul() { DataTable dt = new DataTable(); fields = " * "; condition = DataExtension.AndConditon(GroupsTSql.GetGroupsByVgapp(app), GroupsTSql.GetGroupsByVglang(language), " IGENABLE = '2' "); orderBy = ""; dt = Groups.GetAllGroups(fields, condition, orderBy); string str = ""; if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { str += "<div id=\"Cate-" + dt.Rows[i]["IGID"].ToString() + "\">"; str += "<div class=\"FormatCellItem\">"; str += "<div class=\"pdCellItem\">"; str += "<div class=\"cot1 box-cb\"><input id=\"CbGroup_" + dt.Rows[i]["IGID"].ToString() + "\" type=\"checkbox\" onclick=\"CheckAllCheckBox('CbGroup_" + dt.Rows[i]["IGID"].ToString() + "',this)\" /></div>"; str += "<div class=\"splitc\">|</div>"; str += "<div class=\"cot2\" align=\"left\">"; str += dt.Rows[i]["VGNAME"].ToString(); str += "<div class=\"cbh0\"><!----></div>"; str += "</div>"; str += "<div class=\"splitc\">|</div>"; str += "<div class=\"cot4\" align=\"left\">" + GetRoadGroup(dt.Rows[i]["IGPARENTID"].ToString(), dt.Rows[i]["VGNAME"].ToString()) + " </div>"; str += "<div class=\"splitc\">|</div>"; str += "<div class=\"cot5\">" + dt.Rows[i]["IGORDER"].ToString() + "</div>"; str += "<div class=\"splitc\">|</div>"; str += "<div class=\"cot7 box-cc\">"; str += "<a href=\"javascript:RestoreGroup('" + dt.Rows[i]["IGID"].ToString() + "','" + StatusGroupParent(dt.Rows[i]["IGPARENTID"].ToString()) + "','" + GetSubCate(dt.Rows[i]["IGID"].ToString()) + "','" + dt.Rows[i]["VGNAME"].ToString() + "')\"><span class='iconRestore'><!----></span></a>"; str += " "; str += "<a href=\"javascript:DeleteRecGroup('" + dt.Rows[i]["IGID"].ToString() + "','" + GetSubCate(dt.Rows[i]["IGID"].ToString()) + "','" + dt.Rows[i]["VGNAME"].ToString() + "','" + pic + "')\"><span class='iconDelete'><!----></span></a>"; str += "</div>"; str += "<div class=\"cbh0\"><!----></div>"; str += "</div>"; str += "</div>"; //igidParent = dt.Rows[i]["IGID"].ToString(); if (i != dt.Rows.Count - 1) { str += "<div class=\"PdSpaceRow\"><div class=\"SpaceRow\"><!----></div></div>"; } str += "</div>"; } } LtListMenus.Text = str; }
private string GetList(string igid, string maxRow) { string condition = DataExtension.AndConditon( ItemsTSql.GetItemsByIienable("1"), ItemsTSql.GetItemsByViapp(app), ItemsTSql.GetItemsByVilang(lang), GroupsItemsTSql.GetItemsInGroupCondition(igid, "") ); string orderby = ItemsColumns.IiorderColumn + "," + ItemsColumns.DicreatedateColumn + " desc "; DataTable dt = GroupsItems.GetAllData(maxRow, "*", condition, orderby); return(BindItemsToHTML(dt)); }
string loadDataDetail(string iid) { string s = ""; condition = DataExtension.AndConditon( ItemsTSql.GetItemsByIid(iid) ); DataTable dt = TatThanhJsc.Database.Items.GetItems("", " * ", condition, ""); if (dt.Rows.Count > 0) { s = dt.Rows[0]["VITITLE"].ToString(); } return(s); }
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(""); }
void GetVotes() { top = ""; fields = " * "; condition = DataExtension.AndConditon("VGAPP = '" + app + "'", GroupsTSql.GetGroupsByVglang(language)); orderBy = " DCREATEDATE DESC "; DataTable dt = new DataTable(); dt = GroupsItems.GetAllData(top, fields, condition, orderBy); rp_mn_users.DataSource = dt; rp_mn_users.DataBind(); }
void GetListReply() { condition = DataExtension.AndConditon ( SubitemsTSql.GetSubitemsByIid(iid), SubitemsTSql.GetSubitemsByVsurl(isid),//lấy trả lời SubitemsTSql.GetSubitemsByVskey(app) ); orderby = SubitemsColumns.DscreatedateColumn + " desc "; DataTable dt = new DataTable(); dt = Subitems.GetSubItems("", "*", condition, orderby); rptList.DataSource = dt; rptList.DataBind(); }
void GetGroupsProductInDdl() { DataTable dt = new DataTable(); condition = DataExtension.AndConditon(GroupsTSql.GetGroupsByVglang(language), GroupsTSql.GetGroupsByVgapp(CodeApplications.Tour), " igenable <> '2' "); dt = Groups.GetAllGroups("*", condition, ""); DdlGroupProduct.Items.Clear(); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { DdlGroupProduct.Items.Add(new ListItem(DropDownListExtension.FormatForDdl(dt.Rows[i]["IGLEVEL"].ToString()) + dt.Rows[i]["VGNAME"].ToString(), dt.Rows[i][GroupsColumns.IgidColumn].ToString())); } } }
private static string GetCateOfBlog(string iid) { string condition = DataExtension.AndConditon( GroupsTSql.GetByApp(TatThanhJsc.BlogModul.CodeApplications.Blog), ItemsTSql.GetById(iid) ); DataTable dt = GroupsItems.GetAllData("1", "*", condition, ""); if (dt.Rows.Count > 0) { return("<a href='" + (UrlExtension.WebisteUrl + dt.Rows[0][GroupsColumns.VGSEOLINKSEARCHColumn] + RewriteExtension.Extensions).ToLower() + @"' title='" + dt.Rows[0][GroupsColumns.VgnameColumn] + @"'>" + dt.Rows[0][GroupsColumns.VgnameColumn] + @"</a>"); } return(""); }
void GetItems() { top = "10"; fields = "*"; condition = DataExtension.AndConditon( GroupsTSql.GetGroupsByVgapp(app) + " AND IGENABLE <> '2' AND IIENABLE <> '2' ", ItemsTSql.GetItemsByVilang(language)); orderBy = ItemsColumns.IitotalviewColumn + " desc"; DataTable dt = new DataTable(); dt = GroupsItems.GetAllData(top, fields, condition, orderBy); if (dt.Rows.Count > 0) { RpItems.DataSource = dt; RpItems.DataBind(); } }
private string LayEmailPhongBan(string igid) { string s = ""; string condition = DataExtension.AndConditon( GroupsTSql.GetGroupsByIgid(igid), GroupsTSql.GetGroupsByVgapp(app) ); DataTable dt = new DataTable(); dt = Groups.GetGroups("1", GroupsColumns.VgcontentColumn, condition, ""); if (dt.Rows.Count > 0) { s = StringExtension.LayChuoi(dt.Rows[0][GroupsColumns.VgcontentColumn].ToString(), "", 4); } return(s); }
/// <summary> /// Lấy danh sách các thuộc tính đã được add cho danh mục /// </summary> void GetFilterProperties() { if (DealConfig.KeyHienThiThuocTinhLocDeal) { condition = DataExtension.AndConditon( GroupsTSql.GetGroupsByVglang(language), GroupsTSql.GetGroupsByVgapp(appFilter), GroupsTSql.GetGroupsByIgenable("1"), "charindex('" + parramSpitString + "'+cast(" + GroupsColumns.IgidColumn + " as varchar(10))+'" + parramSpitString + "','" + GetListFilterProperties() + "') >0"); DataTable dt = new DataTable(); dt = Groups.GetGroups("", "*", condition, ""); rptParentFilter.DataSource = dt; rptParentFilter.DataBind(); } }
/// <summary> /// Lấy danh sách các thuộc tính đã được add /// </summary> void GetListAdded() { lstbAdded.Items.Clear(); condition = DataExtension.AndConditon( TatThanhJsc.TSql.GroupsTSql.GetGroupsByVglang(language), TatThanhJsc.TSql.GroupsTSql.GetGroupsByVgapp(app), GroupsColumns.IgenableColumn + "<>2", "charindex('" + parramSplitString + "'+cast(" + TatThanhJsc.Columns.GroupsColumns.IgidColumn + " as varchar(10))+'" + parramSplitString + "','" + GetListFilterProperties() + "') >0"); DataTable dt = new DataTable(); dt = TatThanhJsc.Database.Groups.GetAllGroups("*", condition, ""); for (int i = 0; i < dt.Rows.Count; i++) { lstbAdded.Items.Add(new ListItem(DropDownListExtension.FormatForDdl(dt.Rows[i]["IGLEVEL"].ToString()) + dt.Rows[i]["VGNAME"].ToString(), dt.Rows[i]["IGID"].ToString())); } }
private void GetGroupsInfoByItemId(string iid, string viapp) { string condition = DataExtension.AndConditon( GroupsTSql.GetGroupsByIgenable("1"), GroupsTSql.GetGroupsByVgapp(viapp), GroupsTSql.GetGroupsByVglang(lang), ItemsTSql.GetItemsByIid(iid) ); DataTable dt = GroupsItems.GetAllData("1", "groups.*", condition, ""); if (dt.Rows.Count > 0) { Session["dataByTitle_Cate"] = dt; Session["igid"] = dt.Rows[0][GroupsColumns.IgidColumn].ToString(); } }
void GetGroupsInDdl() { DataTable dt = new DataTable(); condition = DataExtension.AndConditon(GroupsTSql.GetGroupsByVglang(language), GroupsTSql.GetGroupsByVgapp(app), " igenable <> '2' "); dt = Groups.GetAllGroups("*", condition, ""); DdlGroupService.Items.Clear(); DdlGroupService.Items.Add(new ListItem("Danh mục gốc", "0")); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { DdlGroupService.Items.Add(new ListItem(TatThanhJsc.Extension.DropDownListExtension.FormatForDdl(dt.Rows[i]["IGLEVEL"].ToString()) + dt.Rows[i]["VGNAME"].ToString(), dt.Rows[i]["IGID"].ToString())); } } DdlGroupService.SelectedValue = hd_parent; }
void GetCategories(string order) { DdlListShowItem.SelectedValue = NumberShowItem; fields = "*"; condition = DataExtension.AndConditon( MembersTSql.GetMembersByVproperty(app), MembersColumns.ImemberisapprovedColumn + "<>2"); if (txtKeySearch.Text.Length > 0 && !txtKeySearch.Text.Equals("Nhập địa chỉ email cần tìm")) { condition = DataExtension.AndConditon(condition, TatThanhJsc.TSql.SearchTSql.GetSearchMathedCondition(txtKeySearch.Text, MembersColumns.VmemberaccountColumn, MembersColumns.VmembernameColumn)); } #region OrderBy if (order.Length > 0) { orderBy = order; } else { orderBy = CookieExtension.GetCookiesSort(sortCookiesName); if (orderBy.Length < 1) { orderBy = MembersColumns.VmemberaccountColumn; } } #endregion DataTable dt = new DataTable(); DataSet ds = Members.GetMembersPaggingCondition(p, NumberShowItem, condition, orderBy); dt = ds.Tables[1]; LtPagging.Text = PagingExtension.SpilitPages(Convert.ToInt32(dt.Rows[0]["TotalRows"]), Convert.ToInt16(DdlListShowItem.SelectedValue), Convert.ToInt32(p), LinkAdmin.UrlAdmin("", TypePage.Item, "", key, NumberShowItem), "currentPS", "otherPS", "firstPS", "lastPS", "previewPS", "nextPS"); dt = ds.Tables[0]; rp_mn_users.DataSource = dt; rp_mn_users.DataBind(); }
public void DeleteSubItem(string isid, string pic) { DataTable dtItem = new DataTable(); dtItem = Subitems.GetSubItems("", "*", SubitemsTSql.GetSubitemsByIsid(isid), ""); if (dtItem.Rows.Count > 0) { string split = TatThanhJsc.AdminModul.Keyword.ParamsSpilitItems; #region Xoá trả lời của comment DataTable dt = new DataTable(); dt = Subitems.GetSubItems("", "*", DataExtension.AndConditon(SubitemsTSql.GetSubitemsByVskey(dtItem.Rows[0][SubitemsColumns.VskeyColumn].ToString() + "Reply"), SubitemsTSql.GetSubitemsByVsurl(isid)), ""); for (int i = 0; i < dt.Rows.Count; i++) { #region Xóa ảnh if (dt.Rows[i][SubitemsColumns.VsimageColumn].ToString().IndexOf(split) < 0) { ImagesExtension.DeleteImageWhenDeleteItem(pic, dt.Rows[i][SubitemsColumns.VsimageColumn].ToString()); } else { foreach (string s in dt.Rows[i][SubitemsColumns.VsimageColumn].ToString().Split(new string[] { split }, StringSplitOptions.RemoveEmptyEntries)) { ImagesExtension.DeleteImageWhenDeleteItem(pic, s); } } #endregion Subitems.DeleteSubitems(dt.Rows[i][SubitemsColumns.IsidColumn].ToString()); } #endregion #region Xóa ảnh if (dtItem.Rows[0][SubitemsColumns.VsimageColumn].ToString().IndexOf(split) < 0) { ImagesExtension.DeleteImageWhenDeleteItem(pic, dtItem.Rows[0][SubitemsColumns.VsimageColumn].ToString()); } else { foreach (string s in dtItem.Rows[0][SubitemsColumns.VsimageColumn].ToString().Split(new string[] { split }, StringSplitOptions.RemoveEmptyEntries)) { ImagesExtension.DeleteImageWhenDeleteItem(pic, s); } } #endregion Subitems.DeleteSubitems(isid); } }
void GetQA(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)); 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.QA, 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 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(TatThanhJsc.Extension.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; } }
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); }
/// <summary> /// Lấy danh sách các nhóm /// </summary> /// <returns></returns> private string GetGroups(string position) { string s = ""; string fields = "", condition = "", orderby = ""; condition = DataExtension.AndConditon( GroupsTSql.GetByParams(position), GroupsTSql.GetByEnable("1"), GroupsTSql.GetByApp(appGroup), GroupsTSql.GetByLang(lang) ); fields = DataExtension.GetListColumns( GroupsColumns.IgidColumn, GroupsColumns.VgnameColumn, GroupsColumns.VgimageColumn, GroupsColumns.VGSEOLINKSEARCHColumn, GroupsColumns.IgtotalitemsColumn ); orderby = GroupsColumns.IgorderColumn; DataTable dt = Groups.GetGroups("", fields, condition, orderby); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { string list = ""; string cateName = ""; list = GetList(dt.Rows[i][GroupsColumns.IgidColumn].ToString(), "5"); // tieu de string link = "", name = ""; link = (UrlExtension.WebisteUrl + dt.Rows[i][GroupsColumns.VGSEOLINKSEARCHColumn] + RewriteExtension.Extensions).ToLower(); name = dt.Rows[i][GroupsColumns.VgnameColumn].ToString(); if (list.Length > 0) { ltrList.Text = @" <div class='main-right'> <span class='btn-comp01 fade-up'><b>" + name + @"</b></span> <div class='list-news03'> " + list + @" </div> </div>"; } } } return(s); }
void GetGroupsProductInDdl() { DataTable dt = new DataTable(); condition = DataExtension.AndConditon(GroupsTSql.GetGroupsByVglang(language), GroupsTSql.GetGroupsByVgapp(CodeApplications.Product), " igenable <> '2' "); dt = Groups.GetAllGroups("*", condition, ""); DdlGroupProduct.Items.Clear(); DdlGroupProduct.Items.Add(new ListItem("Danh mục gốc", "0")); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { string link = "/" + dt.Rows[i][GroupsColumns.VGSEOLINKSEARCHColumn].ToString().ToLower() + RewriteExtension.Extensions; DdlGroupProduct.Items.Add(new ListItem(DropDownListExtension.FormatForDdl(dt.Rows[i]["IGLEVEL"].ToString()) + dt.Rows[i]["VGNAME"].ToString(), dt.Rows[i][GroupsColumns.IgidColumn].ToString())); } } }
private string GetFirtIGID() { string s = ""; string condition = DataExtension.AndConditon( GroupsTSql.GetByApp(CodeApplications.Contact), GroupsTSql.GetByEnable("1"), GroupsTSql.GetByLevel("1"), GroupsTSql.GetByLang(lang) ); DataTable dt = Groups.GetGroups("1", GroupsColumns.IgidColumn, condition, GroupsColumns.IgorderColumn); if (dt.Rows.Count > 0) { s = dt.Rows[0][GroupsColumns.IgidColumn].ToString(); } return(s); }
void LoadInfo() { top = "1"; fields = LanguageItemColumns.nLanguageItemParams; condition = DataExtension.AndConditon(LanguageItemTSql.GetByiLanguageKeyId(iLanguageKeyId), LanguageItemTSql.GetByiLanguageNationalId(language)); order = ""; DataTable dt = new DataTable(); dt = LanguageItem.GetLanguageItem(top, fields, condition, order); if (dt.Rows.Count > 0) { hdOldImage.Value = dt.Rows[0][LanguageItemColumns.nLanguageItemParams].ToString(); hdUpdate.Value = "1"; ltrImage.Text = ImagesExtension.GetImage(folderpic, hdOldImage.Value, "", "", false, false, ""); } }
bool ExistedEmail(string email, string app) { condition = DataExtension.AndConditon( MembersTSql.GetMembersByVmemberemail(email), MembersTSql.GetMembersByVproperty(app)); DataTable dt = new DataTable(); dt = Members.GetMembersCondition("", MembersColumns.ImidColumn, condition, ""); if (dt.Rows.Count > 0) { return(true); } else { return(false); } }
void GetListMes() { top = ""; fields = " * "; condition = DataExtension.AndConditon(SubitemsTSql.GetSubitemsByVskey(CodeApplications.MemberNoticeBQT), SubitemsTSql.GetSubitemsByVsatuthor(imid) ); order = " DSCREATEDATE DESC "; DataTable dt = new DataTable(); dt = Subitems.GetSubItems(top, fields, condition, order); if (dt.Rows.Count > 0) { RpListNoticeBQT.DataSource = dt; RpListNoticeBQT.DataBind(); } }
/// <summary> /// Lấy danh sách các thuộc tính lọc con /// </summary> /// <param name="igid">igid của thuộc tính cha</param> /// <param name="vgparrams">parram của thuộc tính cha (lưu thiết lập cho chọn 1 hoặc nhiều thuộc tính con)</param> /// <param name="allowMultipSelect">0: chỉ lấy ra thuộc tính con nếu thuộc tính cha thiết lập chỉ cho chọn 1 thuộc tính con/1 sp</param> /// <returns></returns> protected DataTable GetSubFilter(string igid, string vgparrams, string allowMultipSelect) { DataTable dtSubs = new DataTable(); if (vgparrams == allowMultipSelect) { fields = GroupsColumns.IgidColumn + "," + GroupsColumns.VgnameColumn; condition = DataExtension.AndConditon ( GroupsTSql.GetGroupsByVgapp(appFilter), GroupsTSql.GetGroupsByIgparentid(igid), GroupsTSql.GetGroupsByIgenable("1") ); dtSubs = Groups.GetGroups("", fields, condition, ""); } return(dtSubs); }
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 GetProductGroups(string IgidInDll) { string iid_inListAdded = ""; fields = " * "; condition = GroupsItemsTSql.GetGroupsItemsByIgid(igid); DataTable dtProductInCate = new DataTable(); dtProductInCate = GroupsItems.GetAllData(top, fields, condition, " IORDER ASC, DCREATEDATE DESC "); if (dtProductInCate.Rows.Count > 0) { for (int i = 0; i < dtProductInCate.Rows.Count; i++) { lstadded.Items.Add(new ListItem(dtProductInCate.Rows[i]["VITITLE"].ToString(), dtProductInCate.Rows[i]["IID"].ToString())); iid_inListAdded += dtProductInCate.Rows[i]["IID"].ToString(); if (i != (dtProductInCate.Rows.Count - 1)) { iid_inListAdded += ","; } } } DataTable dt = new DataTable(); string conditionItem = ""; conditionItem = DataExtension.AndConditon(GroupsTSql.GetGroupsByVglang(language), GroupsTSql.GetGroupsByVgapp(Modul), ItemsTSql.GetItemsByViapp(Modul)); if (!iid_inListAdded.Equals("")) { conditionItem += "and ITEMS.IID not in(" + iid_inListAdded + ")"; } if (!IgidInDll.Equals("")) { conditionItem += " AND " + GroupsItemsTSql.GetItemsInGroupCondition(IgidInDll, "") + " "; } //conditionItem += " AND IGENABLE <> '2' AND IIENABLE <> '2' "; conditionItem += " AND IGENABLE <> '2' AND (IIENABLE = '1' OR IIENABLE = '0') "; dt = GroupsItems.GetAllData("", "*", conditionItem, " IORDER ASC, DCREATEDATE DESC "); for (int i = 0; i < dt.Rows.Count; i++) { lstnotadded.Items.Add(new ListItem(dt.Rows[i]["VITITLE"].ToString(), dt.Rows[i]["IID"].ToString())); } }
private void InitialControlsValue() { //Trường hợp sửa lịch trình if (isid != "") { string condition = DataExtension.AndConditon(SubitemsTSql.GetSubitemsByVskey(app), SubitemsTSql.GetSubitemsByIsid(isid)); DataTable dt = Subitems.GetSubItems("1", "*", condition, ""); if (dt.Rows.Count > 0) { tbNgay.Text = StringExtension.LayChuoi(dt.Rows[0][SubitemsColumns.VstitleColumn].ToString(), "", 1); tbTenHoatDong.Text = StringExtension.LayChuoi(dt.Rows[0][SubitemsColumns.VstitleColumn].ToString(), "", 2); flAnhDaiDien.Load(dt.Rows[0][SubitemsColumns.VsimageColumn].ToString()); #region Các điểm đến sẽ qua if (dt.Rows[0][SubitemsColumns.VsurlColumn].ToString().StartsWith("text-")) { tbCacDiemDenSeQua.Text = dt.Rows[0][SubitemsColumns.VsurlColumn].ToString().Substring("text-".Length); } if (dt.Rows[0][SubitemsColumns.VsurlColumn].ToString().StartsWith("id-")) { hdIdCacDiemDenSeQua.Value = "," + dt.Rows[0][SubitemsColumns.VsurlColumn].ToString().Substring("id-".Length) + ","; } #endregion #region Bữa ăn string listId = "," + dt.Rows[0][SubitemsColumns.VsemailColumn].ToString() + ","; for (int i = 0; i < cblBuaAn.Items.Count; i++) { if (listId.IndexOf("," + cblBuaAn.Items[i].Value + ",") > -1) { cblBuaAn.Items[i].Selected = true; } } #endregion tbThuTu.Text = dt.Rows[0][SubitemsColumns.VsatuthorColumn].ToString(); cbTrangThai.Checked = (dt.Rows[0][SubitemsColumns.IsenableColumn].ToString() == "1"); tbHoatDongChiTiet.Text = dt.Rows[0][SubitemsColumns.VscontentColumn].ToString(); hdHoatDongChiTiet.Value = dt.Rows[0][SubitemsColumns.VscontentColumn].ToString(); } } }
/// <summary> /// Lấy danh sách các nhóm /// </summary> /// <returns></returns> private string GetGroups(string position) { string s = ""; string condition = DataExtension.AndConditon( GroupsTSql.GetGroupsByIgenable("1"), GroupsTSql.GetGroupsByVgapp(appGroup), GroupsTSql.GetGroupsByVglang(lang), GroupsTSql.GetGroupsByVgparams(position) ); string fields = DataExtension.GetListColumns(GroupsColumns.IgidColumn, GroupsColumns.VgnameColumn, GroupsColumns.VGSEOLINKSEARCHColumn, GroupsColumns.IgtotalitemsColumn); DataTable dt = Groups.GetGroups("", fields, condition, GroupsColumns.IgorderColumn); string list = ""; string link = ""; for (int i = 0; i < dt.Rows.Count; i++) { list = GetList(dt.Rows[i][GroupsColumns.IgidColumn].ToString(), dt.Rows[i][GroupsColumns.IgtotalitemsColumn].ToString()); if (list.Length > 0) { link = UrlExtension.WebisteUrl + dt.Rows[i][GroupsColumns.VGSEOLINKSEARCHColumn].ToString().ToLower() + RewriteExtension.Extensions; } else//Nếu không có tin --> lấy tự động tin mới { link = UrlExtension.WebisteUrl + rewrite + RewriteExtension.Extensions; list = GetLastest(dt.Rows[i][GroupsColumns.IgtotalitemsColumn].ToString()); } s += @" <h2 class='ttl-comp03 fade-up'>" + dt.Rows[i][GroupsColumns.VgnameColumn] + @"</h2> <div class='list-carpark'> " + list + @" </div> "; } return(s); }