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
}
