string CountCate(string igid)
{
top = "";
fields = " * ";
condition = DataExtension.AndConditon(GroupsTSql.GetGroupsByVgapp(app),
GroupsTSql.GetGroupsByVglang(language),
GroupsTSql.GetGroupsByIgparentid(igid));
orderBy = GroupsColumns.IgorderColumn + "," + GroupsColumns.VgnameColumn;
DataTable dt = new DataTable();
dt = Groups.GetGroups(top, fields, condition, orderBy);
return(dt.Rows.Count.ToString());
}
string CountCate(string igid)
{
top = "";
fields = " * ";
condition = DataExtension.AndConditon(GroupsTSql.GetGroupsByVgapp(Modul),
GroupsTSql.GetGroupsByVglang(language),
GroupsTSql.GetGroupsByIgparentid(igid));
orderBy = " IGORDER ASC ";
DataTable dt = new DataTable();
dt = Groups.GetGroups(top, fields, condition, orderBy);
return(dt.Rows.Count.ToString());
}
protected void 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(), "", "0");
if (i < 4)
{
ltrList.Text += @"
<li class='litop item'>
<a href='" + link + "' " +
MenuExtension.GetTarget(dt.Rows[i][GroupsColumns.VgparamsColumn].ToString()) + @" title='" +
dt.Rows[i][GroupsColumns.VgnameColumn] + @"'>" +
dt.Rows[i][GroupsColumns.VgnameColumn] + @"
</a>" + subMenus + @"
</li>";
}
if (i > 3)
{
ltrList2.Text += @"
<li class='litop item'>
<a href='" + link + "' " +
MenuExtension.GetTarget(dt.Rows[i][GroupsColumns.VgparamsColumn].ToString()) + @" title='" +
dt.Rows[i][GroupsColumns.VgnameColumn] + @"'>" +
dt.Rows[i][GroupsColumns.VgnameColumn] + @"
</a>" + subMenus + @"
</li>";
}
}
}
}
/// <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 LayLienKetPhuongTien()
{
string app = CodeApplications.TourVehicle;
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);
cblPhuongTien.DataSource = dt;
cblPhuongTien.DataTextField = GroupsColumns.VgnameColumn;
cblPhuongTien.DataValueField = GroupsColumns.IgidColumn;
cblPhuongTien.DataBind();
}
void LayThuocTinh()
{
string app = CodeApplications.TourProperty;
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++)
{
ddlDiemDen.Items.Add(new ListItem(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();
ltrOfficeInfo.Text = @"
<h2 class='contact02__ttl fade-up'>" + dt.Rows[0][GroupsColumns.VgnameColumn].ToString() + @"</h2>
<ul>
<li class=' fade-up'>
<span class='icon'>
<img src='/img/contact/ico-01.png' alt=''>
</span>
<p><span>Địa chỉ</span><br>
" + StringExtension.LayChuoi(content, "", 1) + @"
</p>
</li>
<li class=' fade-up'>
<span class='icon'><img src='/img/contact/ico-02.png' alt=''></span>
<p><span>Email</span><br>
<a href='mailto:" + StringExtension.LayChuoi(content, "", 4) + @"'>" + StringExtension.LayChuoi(content, "", 4) + @"</a>
</p>
</li>
<li class=' fade-up'>
<span class='icon'><img src='/img/contact/ico-03.png' alt=''></span>
<p><span>Hotline</span><br>
<a href='tel:" + StringExtension.LayChuoi(content, "", 8) + @"'>" + StringExtension.LayChuoi(content, "", 8) + @"</a>
</p>
</li>
</ul>
";
}
}
/// <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();
}
}
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>";
}
}
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 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();
}
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);
}
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 LoadChildMenu(string igParentId, string vgdesc, string rewrite, string layMenuConTheoDanhMuc)
{
string top = "";
string field = "*";
string orderby = GroupsColumns.IgorderColumn;
string condition = DataExtension.AndConditon(
GroupsTSql.GetGroupsByIgenable("1"),
GroupsTSql.GetGroupsByVglang(lang));
#region Xét điều kiện lấy các danh mục con nếu menu trỏ đến trang chủ của các modul
if (layMenuConTheoDanhMuc == "1")
{
if (MenuExtension.GetQueryString(vgdesc, "go") == RewriteExtension.News)
{
rewrite = RewriteExtension.News;
condition = DataExtension.AndConditon(condition,
GroupsTSql.GetGroupsByVgapp(TatThanhJsc.NewsModul.CodeApplications.News),
GroupsTSql.GetGroupsByIgparentid(MenuExtension.GetIgidInVgdesc(vgdesc)));
}
else
if (MenuExtension.GetQueryString(vgdesc, "go") == RewriteExtension.Product)
{
rewrite = RewriteExtension.Product;
condition = DataExtension.AndConditon(condition,
GroupsTSql.GetGroupsByVgapp(TatThanhJsc.ProductModul.CodeApplications.Product),
GroupsTSql.GetGroupsByIgparentid(MenuExtension.GetIgidInVgdesc(vgdesc)));
}
//else
// if (MenuExtension.GetQueryString(vgdesc, "go") == RewriteExtension.Service)
//{
// rewrite = RewriteExtension.Service;
// condition = DataExtension.AndConditon(condition,
// GroupsTSql.GetGroupsByVgapp(TatThanhJsc.ServiceModul.CodeApplications.Service),
// GroupsTSql.GetGroupsByIgparentid(MenuExtension.GetIgidInVgdesc(vgdesc)));
//}
else
if (MenuExtension.GetQueryString(vgdesc, "go") == RewriteExtension.Video)
{
rewrite = RewriteExtension.Video;
condition = DataExtension.AndConditon(condition,
GroupsTSql.GetGroupsByVgapp(TatThanhJsc.VideoModul.CodeApplications.Video),
GroupsTSql.GetGroupsByIgparentid(MenuExtension.GetIgidInVgdesc(vgdesc)));
}
else
if (MenuExtension.GetQueryString(vgdesc, "go") == RewriteExtension.PhotoAlbum)
{
rewrite = RewriteExtension.PhotoAlbum;
condition = DataExtension.AndConditon(condition,
GroupsTSql.GetGroupsByVgapp(TatThanhJsc.PhotoAlbumModul.CodeApplications.PhotoAlbum),
GroupsTSql.GetGroupsByIgparentid(MenuExtension.GetIgidInVgdesc(vgdesc)));
}
else
if (MenuExtension.GetQueryString(vgdesc, "go") == RewriteExtension.FileLibrary)
{
rewrite = RewriteExtension.FileLibrary;
condition = DataExtension.AndConditon(condition,
GroupsTSql.GetGroupsByVgapp(TatThanhJsc.FileLibraryModul.CodeApplications.FileLibrary),
GroupsTSql.GetGroupsByIgparentid(MenuExtension.GetIgidInVgdesc(vgdesc)));
}
else
if (MenuExtension.GetQueryString(vgdesc, "go") == RewriteExtension.QA)
{
rewrite = RewriteExtension.QA;
condition = DataExtension.AndConditon(condition,
GroupsTSql.GetGroupsByVgapp(TatThanhJsc.QAModul.CodeApplications.QA),
GroupsTSql.GetGroupsByIgparentid(MenuExtension.GetIgidInVgdesc(vgdesc)));
}
else
if (MenuExtension.GetQueryString(vgdesc, "go") == RewriteExtension.Customer)
{
rewrite = RewriteExtension.Customer;
condition = DataExtension.AndConditon(condition,
GroupsTSql.GetGroupsByVgapp(TatThanhJsc.CustomerModul.CodeApplications.Customer),
GroupsTSql.GetGroupsByIgparentid(MenuExtension.GetIgidInVgdesc(vgdesc)));
}
else
if (MenuExtension.GetQueryString(vgdesc, "go") == RewriteExtension.Hotel)
{
rewrite = RewriteExtension.Hotel;
condition = DataExtension.AndConditon(condition,
GroupsTSql.GetGroupsByVgapp(TatThanhJsc.HotelModul.CodeApplications.Hotel),
GroupsTSql.GetGroupsByIgparentid(MenuExtension.GetIgidInVgdesc(vgdesc)));
}
else
if (MenuExtension.GetQueryString(vgdesc, "go") == RewriteExtension.Tour)
{
rewrite = RewriteExtension.Tour;
condition = DataExtension.AndConditon(condition,
GroupsTSql.GetGroupsByVgapp(TatThanhJsc.TourModul.CodeApplications.Tour),
GroupsTSql.GetGroupsByIgparentid(MenuExtension.GetIgidInVgdesc(vgdesc)));
}
//else
//if (MenuExtension.GetQueryString(vgdesc, "go") == RewriteExtension.AboutUs)
// {
// rewrite = RewriteExtension.AboutUs;
// condition = DataExtension.AndConditon(condition,
// GroupsTSql.GetGroupsByVgapp(TatThanhJsc.AboutUsModul.CodeApplications.AboutUs),
// GroupsTSql.GetGroupsByIgparentid(MenuExtension.GetIgidInVgdesc(vgdesc)));
// }
//else
//if (MenuExtension.GetQueryString(vgdesc, "go") == RewriteExtension.CustomerReviews)
// {
// rewrite = RewriteExtension.CustomerReviews;
// condition = DataExtension.AndConditon(condition,
// GroupsTSql.GetGroupsByVgapp(TatThanhJsc.CustomerReviewsModul.CodeApplications.CustomerReviews),
// GroupsTSql.GetGroupsByIgparentid(MenuExtension.GetIgidInVgdesc(vgdesc)));
// }
else
{
condition = DataExtension.AndConditon(condition,
GroupsTSql.GetGroupsByIgparentid(igParentId));
}
}
else
{
condition = DataExtension.AndConditon(condition,
GroupsTSql.GetGroupsByIgparentid(igParentId));
}
#endregion
DataTable dt = Groups.GetGroups(top, field, condition, orderby);
string s = "";
if (dt.Rows.Count > 0)
{
string link = "";
s += @"
<i class='fa fa-angle-down' aria-hidden='true'></i>
<div class='sub-menu-1'>
<ul class='sublist'>";
for (int i = 0; i < dt.Rows.Count; i++)
{
if (rewrite.Length < 1)
{
link = RewriteExtension.GetLinkMenu(dt.Rows[i][GroupsColumns.VgdescColumn].ToString());
}
else
{
link = (UrlExtension.WebisteUrl + dt.Rows[i][GroupsColumns.VGSEOLINKSEARCHColumn] +
RewriteExtension.Extensions).ToLower();
}
s += @"
<li class='sub-item'>
<a class='subitem-link' href='" + link + "' " + MenuExtension.GetTarget(dt.Rows[i][GroupsColumns.VgparamsColumn].ToString()) + @" title='" + dt.Rows[i][GroupsColumns.VgnameColumn] + @"'>
<i class='fa fa-angle-right' aria-hidden='true'></i>
<span>" + dt.Rows[i][GroupsColumns.VgnameColumn] + @"</span>
</a>
</li>";
}
s += "</ul></div>";
}
return(s);
}
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 str = "";
string linkUpdate = "";
string CountChild = "";
string valueCb = "";
if (dt.Rows.Count > 0)
{
str += "<div id=\"CateOrder-" + igparentid + "\" >";
TxtLevel += "...";
for (int i = 0; i < dt.Rows.Count; i++)
{
//linkUpdate = Link.GoAdminCategory(TypeModul.Menu, typePageUpdate, dt.Rows[i]["IGID"].ToString(), igparentid);
linkUpdate = "?uc=" + uc + "&app=" + app + "&suc=" + TypePage.update + "&igid=" + dt.Rows[i]["IGID"].ToString();
CountChild = GroupsExtension.CountChildCategory(dt.Rows[i]["IGID"].ToString(), "");
if (igidParent.Equals(igparentid))
{
valueCb = "";
}
else
{
valueCb = igparentid + "_";
}
str += "<div id=\"Cate-" + dt.Rows[i]["IGID"].ToString() + "\" >";
str += "<div class=\"FormatCellItemOther\">";
str += "<div class=\"pdCellItemOther\">";
str += "<div class=\"cot1 box-cb\"><input id=\"CbGroup_" + igidParent + "_" + valueCb + dt.Rows[i]["IGID"].ToString() + "\" type=\"checkbox\" onclick=\"CheckAllCheckBox('CbGroup_" + igidParent + "_" + valueCb + dt.Rows[i]["IGID"].ToString() + "',this)\" /></div>";
str += "<div class=\"splitc\">|</div>";
str += "<div class=\"cot2\" align=\"left\">";
if (!CountChild.Equals("0"))
{
str += "<a id=\"showhide" + dt.Rows[i]["IGID"].ToString() + "\" href=\"javascript:void(0)\" class=\"IcoArrowShow0\" onclick=\"ShowHideGroup('" + dt.Rows[i]["IGID"].ToString() + "');\"> </a>";
}
str += TxtLevel + " " + dt.Rows[i]["VGNAME"].ToString();
str += "<div class=\"cbh0\"><!----></div>";
str += "</div>";
str += "<div class=\"splitc\">|</div>";
str += "<div class=\"cot3\"><a id=\"nc_" + dt.Rows[i]["IGID"].ToString() + "\" href=\"javascript:UpdateMenuType('" + dt.Rows[i]["IGID"].ToString() + "')\" class=\"EnableIcon" + GetValueEnable(dt.Rows[i]["VGPARAMS"].ToString()) + "\"><!----></a></div>";
str += "<div class=\"splitc\">|</div>";
str += "<div class=\"cot4\">" + CountChild + "</div>";
str += "<div class=\"splitc\">|</div>";
str += "<div class=\"cot5\"><input id=\"TbOrder" + dt.Rows[i]["IGID"].ToString() + "\" type=\"text\" value=\"" + dt.Rows[i]["IGORDER"].ToString() + "\" class=\"TextInBox box-stt\" onchange=\"UpdateOrderGroup('" + dt.Rows[i]["IGID"].ToString() + "','" + igparentid + "','" + app + "')\" /></div>";
str += "<div class=\"splitc\">|</div>";
str += "<div class=\"cot6\"><a id=\"nc" + dt.Rows[i]["IGID"].ToString() + "\" href=\"javascript:UpdateEnableGroup('" + dt.Rows[i]["IGID"].ToString() + "')\" class=\"EnableIcon" + dt.Rows[i]["IGENABLE"].ToString() + "\"> </a></div>";
str += "<div class=\"splitc\">|</div>";
str += "<div class=\"cot7 box-cc\">";
str += "<a href=\"" + linkUpdate + "&psc=" + GetValueEnable(dt.Rows[i]["VGPARAMS"].ToString()) + "\"><span class='iconEdit'><!----></span></a>";
str += " ";
str += "<a href=\"javascript:DeleteGroup('" + dt.Rows[i]["IGID"].ToString() + "','" + dt.Rows[i]["VGNAME"].ToString() + "')\"><span class='iconDelete'><!----></span></a>";
str += "</div>";
str += "<div class=\"cbh0\"><!----></div>";
str += "</div>";
str += "</div>";
if (i != dt.Rows.Count - 1)
{
str += "<div class=\"PdSpaceRow\"><div class=\"SpaceRowOther\"><!----></div></div>";
}
str += "<div id=\"" + dt.Rows[i]["IGID"].ToString() + "\" style=\"display:none\">";
str += GetSubCate(dt.Rows[i]["IGID"].ToString());
str += "</div>";
str += "</div>";
}
str += "</div>";
TxtLevel = "...";
}
return(str);
}
string GetCate()
{
string s = "";
#region Condition, orderby, fields
string condition = "";
if (igid != "")
{
condition = GroupsTSql.GetGroupsByIgid(igid);
}
else
{
condition = DataExtension.AndConditon(GroupsTSql.GetGroupsByIgparentid("0"),
GroupsTSql.GetGroupsByVgapp(app));
}
condition = DataExtension.AndConditon(
condition,
GroupsTSql.GetGroupsByVglang(lang),
GroupsTSql.GetGroupsByIgenable("1"));
string orderby = GroupsColumns.VGSEOMETAPARAMSColumn + " DESC";
try
{
rows = int.Parse(SettingsExtension.GetSettingKey(maxItemKey, lang));
}
catch { }
string fields = DataExtension.GetListColumns(GroupsColumns.IgidColumn, GroupsColumns.VgnameColumn, GroupsColumns.VGSEOLINKSEARCHColumn);
#endregion
DataTable dt = Groups.GetGroups("", "*", condition, orderby);
string link = "";
string list = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
link = (UrlExtension.WebisteUrl + dt.Rows[i][GroupsColumns.VGSEOLINKSEARCHColumn] + RewriteExtension.Extensions).ToLower();
if (dt.Rows[i][GroupsColumns.VGSEOMETAPARAMSColumn].ToString() == "3")
{
list = GetList(dt.Rows[i][GroupsColumns.IgidColumn].ToString(), rows.ToString());
s += @"
<section class='sec-drink'>
<div class='inner'>
<h2 class='ttl-comp03 fade-up'>" + dt.Rows[i][GroupsColumns.VgnameColumn] + @"</h2>
<div class='list-drink'>
" + list + @"
</div>
</div>
</section>
";
}
else if (dt.Rows[i][GroupsColumns.VGSEOMETAPARAMSColumn].ToString() == "0")
{
list = GetList2(dt.Rows[i][GroupsColumns.IgidColumn].ToString(), rows.ToString());
if (list.Length > 0)
{
s += list;
}
}
}
return(s);
}
string GetCate()
{
string s = "";
#region Condition, orderby, fields
string condition = "";
if (igid != "")
{
condition = GroupsTSql.GetGroupsByIgid(igid);
}
else
{
condition = DataExtension.AndConditon(GroupsTSql.GetGroupsByIgparentid("0"),
GroupsTSql.GetGroupsByVgapp(app));
}
condition = DataExtension.AndConditon(
condition,
GroupsTSql.GetGroupsByVglang(lang),
GroupsTSql.GetGroupsByIgenable("1"));
string orderby = GroupsColumns.VGSEOMETAPARAMSColumn;
try
{
rows = int.Parse(SettingsExtension.GetSettingKey(maxItemKey, lang));
}
catch { }
string fields = DataExtension.GetListColumns(GroupsColumns.IgidColumn, GroupsColumns.VgnameColumn, GroupsColumns.VGSEOLINKSEARCHColumn);
#endregion
DataTable dt = Groups.GetGroups("", "*", condition, orderby);
string link = "";
string list = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
link =
(UrlExtension.WebisteUrl + dt.Rows[i][GroupsColumns.VGSEOLINKSEARCHColumn] + RewriteExtension.Extensions).ToLower();
if (dt.Rows[i][GroupsColumns.VGSEOMETAPARAMSColumn].ToString() == "1")
{
s += @"
<div class='itemM itemM--style02 fade-up'>
<div class='itemM__content'>
<h2 class='itemM__ttl'>" + dt.Rows[i][GroupsColumns.VgnameColumn] + @"</h2>
<p class='txtBase'>
" + StringExtension.LayChuoi(dt.Rows[i][GroupsColumns.VgcontentColumn].ToString(), "", 1) + @"
</p>
</div>
<div class='itemM__img img'>
<div class='img__crop'>
" + ImagesExtension.GetImage(pic, dt.Rows[i][GroupsColumns.VgimageColumn].ToString(), dt.Rows[i][GroupsColumns.VgnameColumn].ToString(), "", true, false, "") + @"
</div>
</div>
</div>
";
}
else if (dt.Rows[i][GroupsColumns.VGSEOMETAPARAMSColumn].ToString() == "2")
{
list = GetList(dt.Rows[i][GroupsColumns.IgidColumn].ToString(), rows.ToString());
if (list.Length > 0)
{
s += @"
<h2 class=' ttl-comp03 ttl-comp03--md fade-up'>" + dt.Rows[i][GroupsColumns.VgnameColumn] + @"</h2>
<div class='list-service'>
" + list + @"
</div>
";
}
}
else if (dt.Rows[i][GroupsColumns.VGSEOMETAPARAMSColumn].ToString() == "3")
{
list = GetList2(dt.Rows[i][GroupsColumns.IgidColumn].ToString(), rows.ToString());
if (list.Length > 0)
{
s += list;
}
}
else if (dt.Rows[i][GroupsColumns.VGSEOMETAPARAMSColumn].ToString() == "4")
{
list = GetList3(dt.Rows[i][GroupsColumns.IgidColumn].ToString(), rows.ToString());
if (list.Length > 0)
{
s += @"
<div class='price-album'>
<h2 class='ttl-comp03 ttl-comp03--md fade-up'>album ảnh cưới tại blue lotus</h2>
<div class='list-price'>
" + list + @"
</div>
</div>
";
}
}
}
return(s);
}
string GetCate()
{
string s = "";
#region Condition, orderby, fields
string condition = "";
if (igid != "")
{
condition = GroupsTSql.GetGroupsByIgid(igid);
}
else
{
condition = DataExtension.AndConditon(GroupsTSql.GetGroupsByIgparentid("0"),
GroupsTSql.GetGroupsByVgapp(app));
}
condition = DataExtension.AndConditon(
condition,
GroupsTSql.GetGroupsByVglang(lang),
GroupsTSql.GetGroupsByIgenable("1"));
string orderby = GroupsColumns.IgorderColumn + "," + GroupsColumns.DgcreatedateColumn + " desc ";
try
{
rows = int.Parse(SettingsExtension.GetSettingKey(maxItemKey, lang));
}
catch { }
string fields = DataExtension.GetListColumns(GroupsColumns.IgidColumn, GroupsColumns.VgnameColumn, GroupsColumns.VGSEOLINKSEARCHColumn);
#endregion
DataTable dt = Groups.GetGroups("", "*", condition, orderby);
string link = "";
string list = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
link =
(UrlExtension.WebisteUrl + dt.Rows[i][GroupsColumns.VGSEOLINKSEARCHColumn] + RewriteExtension.Extensions).ToLower();
if (dt.Rows[i][GroupsColumns.IgtotalitemsColumn].ToString() == "0")
{
s += @"
<div class='itemM fade-up'>
<div class='itemM__content'>
<h2 class='itemM__ttl'>" + dt.Rows[i][GroupsColumns.VgnameColumn] + @"</h2>
<p class='txtBase'>
" + dt.Rows[i][GroupsColumns.VgcontentColumn] + @"
</p>
</div>
<div class='itemM__img img'>
<div class='img__crop'>
" + ImagesExtension.GetImage(pic, dt.Rows[i][GroupsColumns.VgimageColumn].ToString(), dt.Rows[i][GroupsColumns.VgnameColumn].ToString(), "", true, false, "") + @"
</div>
</div>
</div>
";
}
else
{
list = GetList(dt.Rows[i][GroupsColumns.IgidColumn].ToString(), rows.ToString());
if (list.Length > 0)
{
s += @"
<h2 class='ttl-comp03 fade-up'>" + dt.Rows[i][GroupsColumns.VgnameColumn] + @"</h2>
<div class='list-service'>
" + list + @"
</div>
";
}
}
}
return(s);
}
string GetCate()
{
string s = "";
#region Condition, orderby, fields
string condition = "";
if (igid != "")
{
condition = GroupsTSql.GetGroupsByIgid(igid);
}
else
{
condition = DataExtension.AndConditon(GroupsTSql.GetGroupsByIgparentid("0"),
GroupsTSql.GetGroupsByVgapp(app));
}
condition = DataExtension.AndConditon(
condition,
GroupsTSql.GetGroupsByVglang(lang),
GroupsTSql.GetGroupsByIgenable("1"));
string orderby = GroupsColumns.VGSEOMETAPARAMSColumn;
try
{
rows = int.Parse(SettingsExtension.GetSettingKey(maxItemKey, lang));
}
catch { }
string fields = DataExtension.GetListColumns(GroupsColumns.IgidColumn, GroupsColumns.VgnameColumn, GroupsColumns.VGSEOLINKSEARCHColumn);
#endregion
DataTable dt = Groups.GetGroups("", "*", condition, orderby);
string link = "";
string list = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
link =
(UrlExtension.WebisteUrl + dt.Rows[i][GroupsColumns.VGSEOLINKSEARCHColumn] + RewriteExtension.Extensions).ToLower();
s += @"
<div class='item-seminor'>
<div class='inner'>
<div class='item-seminor__img fade-up'>
<div class='img'>
<div class='img__crop'>
" + ImagesExtension.GetImage(pic, dt.Rows[i][GroupsColumns.VgimageColumn].ToString(), dt.Rows[i][GroupsColumns.VgnameColumn].ToString(), "", true, false, "", false) + @"
</div>
</div>
</div>
<div class='item-seminor__content fade-up'>
<h2 class='item-seminor__ttl'>
<span>" + dt.Rows[i][GroupsColumns.VgnameColumn] + @"</span>
</h2>
<p class='txtBase'><span>" + dt.Rows[i][GroupsColumns.VgdescColumn] + @"</span></p>
<div class='txt-center'>
<a href='" + link + @"' class='btn on'>Xem chi tiết</a>
</div>
</div>
</div>
</div>
";
}
return(s);
}
string GetCate()
{
string s = "";
#region Condition, orderby, fields
string condition = "";
if (igid != "")
{
condition = GroupsTSql.GetGroupsByIgid(igid);
}
else
{
condition = DataExtension.AndConditon(GroupsTSql.GetGroupsByIgparentid("0"),
GroupsTSql.GetGroupsByVgapp(app));
}
condition = DataExtension.AndConditon(
condition,
GroupsTSql.GetGroupsByVglang(lang),
GroupsTSql.GetGroupsByIgenable("1"));
string orderby = GroupsColumns.IgorderColumn + "," + GroupsColumns.DgcreatedateColumn + " desc ";
try
{
rows = int.Parse(SettingsExtension.GetSettingKey(maxItemKey, lang));
}
catch { }
string fields = DataExtension.GetListColumns(GroupsColumns.IgidColumn, GroupsColumns.VgnameColumn, GroupsColumns.VGSEOLINKSEARCHColumn, GroupsColumns.VgdescColumn);
#endregion
DataTable dt = Groups.GetGroups("", fields, condition, orderby);
string link = "";
string list = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
link =
(UrlExtension.WebisteUrl + dt.Rows[i][GroupsColumns.VGSEOLINKSEARCHColumn] + RewriteExtension.Extensions).ToLower();
list = GetList(dt.Rows[i][GroupsColumns.IgidColumn].ToString(), rows.ToString());
if (list.Length > 0)
{
s += @"
<div class='section tag-service'>
<div class='container'>
<div class='list'>
<h2>
<a href='" + link + @"' class='title list-title txtCenter fSize-34 fSize-sm-26 nb-color-m1' title='" + dt.Rows[i][GroupsColumns.VgnameColumn] + @"'>" + dt.Rows[i][GroupsColumns.VgnameColumn] + @"</a>
</h2>
<p class='list-text hed txtCenter'>" + dt.Rows[i][GroupsColumns.VgdescColumn] + @"</p>
<div class='list-body'>
" + list + @"
</div>
</div>
</div>
</div>";
}
}
return(s);
}
