/// <summary>
/// Lấy danh sách các thuộc tính chưa được add ( chỉ hiện ra những thuộc tính mà nó và cha nó chưa bị add)
/// </summary>
void GetListNotAdded()
{
string listFilterProperties = GetListFilterProperties();
lstbNotAdded.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 + "','" + listFilterProperties + "') <1");
DataTable dt = new DataTable();
dt = TatThanhJsc.Database.Groups.GetAllGroups("*", condition, "");
string parentsId = "";
string danhDauThuocChaHopLe = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
//Kiểm tra, chỉ hiện ra các mục mà cha nó chưa bị add
parentsId = dt.Rows[i][TatThanhJsc.Columns.GroupsColumns.IgparentsidColumn].ToString();
if (!parentInListFilterproperties(parentsId, listFilterProperties))
{
if (ThuocTinhChaHopLe(dt.Rows[i]["IGID"].ToString()))
{
danhDauThuocChaHopLe = "+";
}
else
{
danhDauThuocChaHopLe = ".";
}
lstbNotAdded.Items.Add(new ListItem(danhDauThuocChaHopLe + DropDownListExtension.FormatForDdl(dt.Rows[i]["IGLEVEL"].ToString()) + dt.Rows[i]["VGNAME"].ToString(), dt.Rows[i]["IGID"].ToString()));
}
}
}
protected void ddlModul_SelectedIndexChanged(object sender, EventArgs e)
{
tbUrl.Text = ddlModul.SelectedValue.Substring(0, ddlModul.SelectedValue.IndexOf("__"));
tbTitle.Text = ddlModul.SelectedItem.Text;
tbUrl.CssClass = "active";
tbTitle.CssClass = "active";
string app = ddlModul.SelectedValue.Substring(ddlModul.SelectedValue.IndexOf("__") + "__".Length);
DataTable dt = new DataTable();
dt = Groups.GetAllGroups(
" * ",
DataExtension.AndConditon(
GroupsTSql.GetGroupsByVglang(language),
GroupsTSql.GetGroupsByVgapp(app),
GroupsColumns.IgenableColumn + " <> 2 "),
"");
ddlModulCate.Items.Clear();
if (dt.Rows.Count > 0)
{
ddlModulCate.Items.Add(new ListItem("Chọn danh mục", ""));
for (int i = 0; i < dt.Rows.Count; i++)
{
ddlModulCate.Items.Add(new ListItem(DropDownListExtension.FormatForDdl(dt.Rows[i]["IGLEVEL"].ToString()) + dt.Rows[i]["VGNAME"].ToString(), dt.Rows[i]["IGID"].ToString()));
}
}
}
void GetParentCate()
{
DropDownListExtension.LoadParentCates(app, lang, ddlParentCate, false);
if (!igid.Equals(""))
{
ddlParentCate.SelectedValue = igid;
}
}
//Lấy nhóm modul, đổ vào dropdownlist
void getGroups()
{
DataTable dt = new DataTable();
dt = Groups.GetAllGroups(" * ", DataExtension.AndConditon(GroupsTSql.GetGroupsByVgapp(Modul), GroupsTSql.GetGroupsByVglang(language), "igenable <> '2'"), "");
ddl_groups.Items.Add(new ListItem("Chọn danh mục", string.Empty));
for (int i = 0; i < dt.Rows.Count; i++)
{
ddl_groups.Items.Add(new ListItem(DropDownListExtension.FormatForDdl(dt.Rows[i]["IGLEVEL"].ToString()) + dt.Rows[i]["VGNAME"].ToString(), dt.Rows[i]["IGID"].ToString()));
}
}
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()));
}
}
}
/// <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()));
}
}
void GetGroupsInDdl()
{
DataTable dt = new DataTable();
condition = DataExtension.AndConditon(GroupsTSql.GetGroupsByVglang(language), GroupsTSql.GetGroupsByVgapp(app), " igenable <> '2' ");
dt = Groups.GetAllGroups("*", condition, "");
DdlGroupWebsite.Items.Clear();
DdlGroupWebsite.Items.Add(new ListItem("Danh mục gốc", "0"));
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
DdlGroupWebsite.Items.Add(new ListItem(DropDownListExtension.FormatForDdl(dt.Rows[i]["IGLEVEL"].ToString()) + dt.Rows[i]["VGNAME"].ToString(), dt.Rows[i]["IGID"].ToString()));
}
}
DdlGroupWebsite.SelectedValue = hd_parent;
}
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;
}
}
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()));
}
}
}
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);
ddlCateSearch.Items.Add(new ListItem(Developer.NewKeyword.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()));
}
ddlCateSearch.SelectedValue = igid;
}
private void LoadDestCate()
{
ddlCateDest.Items.Clear();
condition = DataExtension.AndConditon(
GroupsTSql.GetGroupsByIgenable("1"),
GroupsTSql.GetGroupsByVglang(ddlLanguageDest.SelectedValue),
GroupsTSql.GetGroupsByVgapp(ddlModulDest.SelectedValue)
);
DataTable dt = new DataTable();
fields = DataExtension.GetListColumns(GroupsColumns.IgidColumn, GroupsColumns.VgnameColumn, GroupsColumns.IglevelColumn);
dt = Groups.GetAllGroups(fields, condition, "");
for (int i = 0; i < dt.Rows.Count; i++)
{
ddlCateDest.Items.Add(new ListItem(DropDownListExtension.FormatForDdl(dt.Rows[i][GroupsColumns.IglevelColumn].ToString()) + dt.Rows[i][GroupsColumns.VgnameColumn].ToString(), dt.Rows[i][GroupsColumns.IgidColumn].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()));
}
}
}
void LoadParentCate()
{
DropDownListExtension.LoadParentCates(app, language, ddlParentCate);
ddlParentCate.SelectedValue = hd_parent;
}
