string GetList()
{
string s = "";
string condition = GroupsTSql.GetGroupsByVgapp(app);
if (igid != "")
{
condition = GroupsItemsTSql.GetItemsInGroupCondition(igid, "");
}
condition = DataExtension.AndConditon(condition,
GroupsTSql.GetGroupsByVglang(lang),
GroupsTSql.GetGroupsByIgenable("1"),
ItemsTSql.GetItemsByIienable("1"),
ItemsTSql.GetItemsByViapp(app));
if (iid != "")
{
condition += " and ITEMS.IID<> " + iid + " ";
}
string fields = DataExtension.GetListColumns(ItemsColumns.VititleColumn, ItemsColumns.IitotalviewColumn,
ItemsColumns.VISEOLINKSEARCHColumn, ItemsColumns.DicreatedateColumn, ItemsColumns.ViImage, ItemsColumns.VidescColumn);
string orderby = ItemsColumns.IiorderColumn + "," + ItemsColumns.DicreatedateColumn + " desc ";
try
{
rows = int.Parse(SettingsExtension.GetSettingKey(maxItemKey, lang));
}
catch { }
DataTable dt = new DataTable();
dt = GroupsItems.GetAllData(rows.ToString(), fields, condition, orderby);
if (dt.Rows.Count > 0)
{
string link = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
link = (UrlExtension.WebisteUrl + dt.Rows[i][ItemsColumns.VISEOLINKSEARCHColumn] + RewriteExtension.Extensions).ToLower();
s += @"
<div class='item'>
<div class='item-img'>
<a href='" + link + @"' title='" + dt.Rows[i][ItemsColumns.VititleColumn] + @"' class='imgc'>
" + ImagesExtension.GetImage(pic, dt.Rows[i][ItemsColumns.ViimageColumn].ToString(), dt.Rows[i][ItemsColumns.VititleColumn].ToString(), "", true, false, "") + @"
</a>
</div>
<div class='item-body'>
<a href='" + link + @"' class='title item-title customer-name' title='" + dt.Rows[i][ItemsColumns.VititleColumn] + @"'>" + dt.Rows[i][ItemsColumns.VititleColumn] + @"</a>
<p class='item-text'>
" + dt.Rows[i][ItemsColumns.VidescColumn] + @"
</p>
</div>
</div>";
}
}
return(s);
}
private void CheckTag()
{
DataTable dt = new DataTable();
condition = DataExtension.AndConditon(GroupsItemsTSql.GetGroupsItemsByIid(iid), GroupsTSql.GetGroupsByVgapp(app));
dt = GroupsItems.GetAllData("", "groups.igid", condition, "");
string listIgid = ",";
for (int i = 0; i < dt.Rows.Count; i++)
{
listIgid += dt.Rows[i][GroupsColumns.IgidColumn].ToString() + ",";
}
for (int i = 0; i < cblListTag.Items.Count; i++)
{
if (listIgid.IndexOf("," + cblListTag.Items[i].Value + ",") > -1)
{
cblListTag.Items[i].Selected = true;
}
else
{
cblListTag.Items[i].Selected = false;
}
}
}
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()));
}
}
}
}
private string CountTagInGroups(string igid)
{
return
(NumberExtension.FormatNumber(
GroupsItems.GetGroupsItems("", GroupsItemsColumns.IgiidColumn,
GroupsItemsTSql.GetGroupsItemsByIgid(igid), "").Rows.Count.ToString()));
}
void GetList()
{
#region Condition, orderby
string condition = "";
if (igid != "")
{
condition = GroupsItemsTSql.GetItemsInGroupCondition(igid, "");
}
else
{
condition = GroupsTSql.GetGroupsByVgapp(app);
}
condition = DataExtension.AndConditon(
condition,
GroupsTSql.GetGroupsByVglang(lang),
GroupsTSql.GetGroupsByIgenable("1"),
ItemsTSql.GetItemsByIienable("1"),
ItemsTSql.GetItemsByViapp(app));
string orderby = ItemsColumns.IiorderColumn + "," + ItemsColumns.DicreatedateColumn + " desc ";
#endregion
DataTable dt = GroupsItems.GetAllData("", " * ", condition, orderby);
if (dt.Rows.Count > 0)
{
ddlService2.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
ddlService2.Items.Add(new ListItem(dt.Rows[i][ItemsColumns.VititleColumn].ToString(), dt.Rows[i][ItemsColumns.IidColumn].ToString()));
}
}
}
void GetList()
{
#region Condition, orderby
string condition = "";
if (igid != "")
{
condition = GroupsItemsTSql.GetItemsInGroupCondition(igid, "");
}
else
{
condition = GroupsTSql.GetGroupsByVgapp(app);
}
condition = DataExtension.AndConditon(
condition,
GroupsTSql.GetGroupsByVglang(lang),
GroupsTSql.GetGroupsByIgenable("1"),
ItemsTSql.GetItemsByIienable("1"),
ItemsTSql.GetItemsByViapp(app));
if (key.Length > 0)
{
condition = DataExtension.AndConditon(condition, SearchTSql.GetSearchMathedCondition(key, ItemsColumns.VititleColumn, ItemsColumns.VikeyColumn, ItemsColumns.FipriceColumn, ItemsColumns.FisalepriceColumn));
}
string orderby = ItemsColumns.IiorderColumn + "," + ItemsColumns.DicreatedateColumn + " desc ";
#endregion
DataTable dt = GroupsItems.GetAllData("", " * ", condition, orderby);
#region Lấy ra danh sách bài viết
if (dt.Rows.Count > 0)
{
string link = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
link = (UrlExtension.WebisteUrl + dt.Rows[i][ItemsColumns.VISEOLINKSEARCHColumn] + RewriteExtension.Extensions).ToLower();
ltrList.Text += @"
<div class='item item-row'>
<div class='item-img'>
<a href='" + link + @"' title='" + dt.Rows[i][ItemsColumns.VititleColumn] + @"' class='imgc'>
" + ImagesExtension.GetImage(pic, dt.Rows[i][ItemsColumns.ViimageColumn].ToString(), dt.Rows[i][ItemsColumns.VititleColumn].ToString(), "", true, false, "") + @"
</a>
</div>
<div class='item-body'>
<h1>
<a href='" + link + @"' class='title item-title fSize-17' title='" + dt.Rows[i][ItemsColumns.VititleColumn] + @"'>" + dt.Rows[i][ItemsColumns.VititleColumn] + @"</a>
</h1>
<p class='item-text'>
" + dt.Rows[i][ItemsColumns.VidescColumn].ToString() + @"
</p>
</div>
</div>
<hr>";
}
}
#endregion
}
string GetList3(string igid, string top)
{
string s = "";
#region Condition, orderby, fields
string condition = "";
if (igid != "")
{
condition = GroupsItemsTSql.GetItemsInGroupCondition(igid, "");
}
else
{
condition = GroupsTSql.GetGroupsByVgapp(app);
}
condition = DataExtension.AndConditon(
condition,
GroupsTSql.GetGroupsByVglang(lang),
GroupsTSql.GetGroupsByIgenable("1"),
ItemsTSql.GetItemsByIienable("1"),
ItemsTSql.GetItemsByViapp(app));
if (key.Length > 0)
{
condition = DataExtension.AndConditon(condition, SearchTSql.GetSearchMathedCondition(key, ItemsColumns.VititleColumn, ItemsColumns.VikeyColumn, ItemsColumns.FipriceColumn, ItemsColumns.FisalepriceColumn));
}
string orderby = ItemsColumns.IiorderColumn + "," + ItemsColumns.DicreatedateColumn + " desc ";
string fields = DataExtension.GetListColumns(ItemsColumns.VititleColumn,
ItemsColumns.ViimageColumn, ItemsColumns.VISEOLINKSEARCHColumn, ItemsColumns.VidescColumn, ItemsColumns.DiCreateDate, ItemsColumns.IiTotalView);
#endregion
DataTable dt = GroupsItems.GetAllData("3", "*", condition, orderby);
#region Lấy ra danh sách bài viết
if (dt.Rows.Count > 0)
{
string link = (UrlExtension.WebisteUrl + dt.Rows[0][ItemsColumns.VISEOLINKSEARCHColumn] + RewriteExtension.Extensions).ToLower();
for (int i = 0; i < dt.Rows.Count; i++)
{
link =
(UrlExtension.WebisteUrl + dt.Rows[i][ItemsColumns.VISEOLINKSEARCHColumn] + RewriteExtension.Extensions)
.ToLower();
s += @"
<div class='list-price__item fade-up'>
<h3 class='list-price__ttl'>" + dt.Rows[i][ItemsColumns.VititleColumn] + @"</h3>
<p class='list-price__price'> " + dt.Rows[i][ItemsColumns.ViDesc] + @"</p>
" + StringExtension.LayChuoi(dt.Rows[i][ItemsColumns.VicontentColumn].ToString(), "", 1) + @"
</div>";
}
}
#endregion
return(s);
}
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));
}
condition += " AND IIENABLE = '1' ";
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 = " VISEOMETALANG 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, "QuanLyBaiVietDaXuatBan",
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 LayIgid(string iid)
{
DataTable dt = GroupsItems.GetAllData("", " * ", GroupsItemsTSql.GetByIid(iid), ItemsColumns.IiorderColumn + " desc ");
if (dt.Rows.Count > 0)
{
LayDanhSachTour(dt.Rows[0][GroupsColumns.IgidColumn].ToString(), iid);
}
}
void GetNews(string order)
{
DdlListShowItem.SelectedValue = NumberShowItem;
if (!igid.Equals(""))
{
ddlCateSearch.SelectedValue = igid;
condition = GroupsItemsTSql.GetItemsInGroupCondition(ddlCateSearch.SelectedValue, "");
}
else
{
condition = DataExtension.AndConditon(
"VGAPP = '" + app + "'",
"VIAPP = '" + app + "1'",
GroupsTSql.GetGroupsByVglang(language));
}
condition += " AND IIENABLE <> '2' ";
if (tbKeySearch.Text.Length > 0)
{
condition += " AND " + SearchTSql.GetSearchMathedCondition(tbKeySearch.Text, ItemsColumns.ViauthorColumn);
}
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(NumberShowItem), Convert.ToInt32(p),
LinkAdmin.UrlAdmin(CodeApplications.Contact + "2", TypePage.Item,
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();
}
private void InsertProperty(string igid, string iid)
{
string condition = DataExtension.AndConditon(GroupsItemsTSql.GetByIgid(igid), GroupsItemsTSql.GetByIid(iid));
DataTable dt = GroupsItems.GetGroupsItems("1", GroupsItemsColumns.IgiidColumn, condition, "");
if (dt.Rows.Count == 0)
{
GroupsItems.InsertGroupsItems(igid, iid, "", DateTime.Now.ToString(), DateTime.Now.ToString(),
DateTime.Now.ToString(), "");
}
}
void GetPhotoAlbum(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.PhotoAlbum, 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();
}
private string GetListAdv(string igid, string cssImage)
{
string s = "";
DataTable dt = new DataTable();
dt = GroupsItems.GetAllData("", " * ", GroupsItemsTSql.GetItemsInGroupCondition(
igid, ItemsTSql.GetItemsByIienable("1")),
GroupsItemsColumns.IorderColumn);
string href = "";
string target = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i][ItemsColumns.ViUrl].ToString() != "")
{
href = dt.Rows[i][ItemsColumns.ViUrl].ToString();
}
else
{
href = "javascript://";
}
if (dt.Rows[i][ItemsColumns.ViParams].ToString() == "1")
{
target = "target='_blank'";
}
else
{
target = "";
}
s += @"
<div class='intro-head__img img fade-up'>
<span class='img__crop'>
<img alt='" + dt.Rows[i][ItemsColumns.ViTitle] + @"' src='" + UrlExtension.WebisteUrl + pic + "/" + dt.Rows[i][ItemsColumns.ViImage] + @"' />
</span>
</div>
<div class='intro-head__content fade-up '>
<h3 class='ttl-comp02'>
<span>
" + dt.Rows[i][ItemsColumns.ViTitle] + @"
</span>
</h3>
<p class='txtBase'> " + dt.Rows[i][ItemsColumns.ViSeoTitle] + @"</p>
<a href='" + href + @"' " + target + @" title='" + dt.Rows[i][ItemsColumns.ViTitle] + @"' class='btn'>Xem thêm</a>
</div>";
}
return(s);
}
void GetList()
{
condition = DataExtension.AndConditon
(
GroupsItemsTSql.GetItemsInGroupCondition(igid, ItemsColumns.IienableColumn + "<>2"),
ItemsTSql.GetItemsByViapp(app)
);
orderby = ItemsColumns.IiorderColumn;
DataTable dt = new DataTable();
dt = GroupsItems.GetAllData("", "*", condition, orderby);
rptList.DataSource = dt;
rptList.DataBind();
}
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));
}
private string GetListAdv(string igid, string cssImage)
{
string s = "";
DataTable dt = new DataTable();
dt = GroupsItems.GetAllData("", " * ", GroupsItemsTSql.GetItemsInGroupCondition(
igid, ItemsTSql.GetItemsByIienable("1")),
GroupsItemsColumns.IorderColumn);
string href = "";
string target = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i][ItemsColumns.ViUrl].ToString() != "")
{
href = dt.Rows[i][ItemsColumns.ViUrl].ToString();
}
else
{
href = "javascript://";
}
if (dt.Rows[i][ItemsColumns.ViParams].ToString() == "1")
{
target = "target='_blank'";
}
else
{
target = "";
}
s += @"
<div class='list-foods__item fade-up " + (i > 7?"hide":"") + @"'>
<div class='img'>
<a href='" + href + @"' " + target + @" title='" + dt.Rows[i][ItemsColumns.ViTitle] + @"' class='img__crop'>
<img alt='" + dt.Rows[i][ItemsColumns.ViTitle] + @"' src='" + UrlExtension.WebisteUrl + pic + "/" + dt.Rows[i][ItemsColumns.ViImage] + @"' />
</a>
</div>
<h3 class='list-foods__ttl'>
<a href='" + href + @"' " + target + @" title='" + dt.Rows[i][ItemsColumns.ViTitle] + @"'>" + dt.Rows[i][ItemsColumns.ViTitle] + @"</a>
</h3>
</div>";
}
return(s);
}
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);
}
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()));
}
}
/// <summary>
/// Hiện thị các tag cho 1 blog
/// </summary>
/// <param name="iid"></param>
/// <returns></returns>
private static string ShowTags(string iid)
{
string s = "";
string condition = DataExtension.AndConditon(
GroupsItemsTSql.GetGroupsItemsByIid(iid),
GroupsTSql.GetGroupsByVgapp(TatThanhJsc.OtherModul.CodeApplications.Tag));
DataTable dt = GroupsItems.GetAllData("", "groups.*", condition, GroupsColumns.IgorderColumn);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
s += "<a href='" + (UrlExtension.WebisteUrl + RewriteExtension.Tag + "/" + dt.Rows[i][GroupsColumns.VGSEOLINKSEARCHColumn] + RewriteExtension.Extensions).ToLower() + "' title='" + dt.Rows[i][GroupsColumns.VgnameColumn] + @"'>" + dt.Rows[i][GroupsColumns.VgnameColumn] + @"</a>, ";
}
s = s.Remove(s.Length - ", ".Length);
}
return(s);
}
private string GetListAdv(string igid, string cssImage)
{
string s = "";
DataTable dt = new DataTable();
dt = GroupsItems.GetAllData("", " * ", GroupsItemsTSql.GetItemsInGroupCondition(
igid, ItemsTSql.GetItemsByIienable("1")),
GroupsItemsColumns.IorderColumn);
string href = "";
string target = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i][ItemsColumns.ViUrl].ToString() != "")
{
href = dt.Rows[i][ItemsColumns.ViUrl].ToString();
}
else
{
href = "javascript://";
}
if (dt.Rows[i][ItemsColumns.ViParams].ToString() == "1")
{
target = "target='_blank'";
}
else
{
target = "";
}
s += @"
<li class='img'>
<span class='img__crop'>
<img alt='" + dt.Rows[i][ItemsColumns.ViTitle] + @"' src='" + UrlExtension.WebisteUrl + pic + "/" + dt.Rows[i][ItemsColumns.ViImage] + @"' />
</span>
</li>";
}
return(s);
}
private void LoadList()
{
lbListItem.Items.Clear();
DataTable dt = new DataTable();
if (ddlCateSource.SelectedValue.Length > 0)
{
condition = DataExtension.AndConditon(
GroupsItemsTSql.GetItemsInGroupCondition(ddlCateSource.SelectedValue, ItemsTSql.GetItemsByIienable("1"), ddlWebSource.SelectedValue),
ItemsTSql.GetItemsByViapp(ddlModulSource.SelectedValue)
);
dt = GroupsItems.GetAllData("", "*", condition, ItemsColumns.VititleColumn, ddlWebSource.SelectedValue);
}
for (int i = 0; i < dt.Rows.Count; i++)
{
lbListItem.Items.Add(new ListItem(dt.Rows[i][ItemsColumns.VititleColumn].ToString(), dt.Rows[i][ItemsColumns.IidColumn].ToString()));
}
}
private void CheckOtherIgid(string iid)
{
DataTable dt = GroupsItems.GetGroupsItems("", GroupsItemsColumns.IgidColumn,
GroupsItemsTSql.GetGroupsItemsByIid(iid), "");
string listigid = ",";
for (int i = 0; i < dt.Rows.Count; i++)
{
listigid += dt.Rows[i][GroupsColumns.IgidColumn].ToString() + ",";
}
//hdIgid.Value = listigid;
foreach (ListItem item in cbListCates.Items)
{
if (listigid.IndexOf("," + item.Value + ",") > -1)
{
item.Selected = true;
}
}
}
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;
}
private string GetListAdv(string igid, string cssImage)
{
string s = "";
DataTable dt = new DataTable();
dt = GroupsItems.GetAllData("", " * ", GroupsItemsTSql.GetItemsInGroupCondition(
igid, ItemsTSql.GetItemsByIienable("1")),
GroupsItemsColumns.IorderColumn);
for (int i = 0; i < dt.Rows.Count; i++)
{
string target = "";
if (dt.Rows[i]["VIPARAMS"].ToString().Equals("1"))
{
target = "target='_blank'";
}
s += @"
<div class='col-12 col-sm-12 col-md-12 col-lg-6 col-xl-6'>
<div class='item item-row'>
<div class='item-img'>
<a href='" + dt.Rows[i]["VIURL"] + "' " + target + @" class='imgc0'>
" + ImagesExtension.GetImage(pic, dt.Rows[i][ItemsColumns.ViimageColumn].ToString(), dt.Rows[i][ItemsColumns.VititleColumn].ToString(), "", true, false, "") + @"
</a>
</div>
<div class='item-body'>
<h3>
<a href='" + dt.Rows[i]["VIURL"] + "' " + target + @" class='title item-title'>" + dt.Rows[i][ItemsColumns.VititleColumn].ToString() + @"</a>
<p class='item-text'>" + dt.Rows[i][ItemsColumns.VISEOTITLEColumn].ToString() + @"</p>
</h3>
</div>
</div>
</div>";
}
return(s);
}
protected void btSave_Click(object sender, EventArgs e)
{
//Xoá các bản ghi trong groups_items có vgapp là TatThanhJsc.OtherModul.CodeApplications.Tag
DataTable dt = new DataTable();
condition = DataExtension.AndConditon(GroupsItemsTSql.GetGroupsItemsByIid(iid), GroupsTSql.GetGroupsByVgapp(app));
dt = GroupsItems.GetAllData("", GroupsItemsColumns.IgiidColumn, condition, "");
for (int i = 0; i < dt.Rows.Count; i++)
{
//Response.Write(dt.Rows[i][GroupsItemsColumns.IgiidColumn].ToString());
GroupsItems.DeleteGroupsItems(GroupsItemsTSql.GetGroupsItemsByIgiid(dt.Rows[i][GroupsItemsColumns.IgiidColumn].ToString()));
}
//Thêm các bản ghi vào groups_items
for (int i = 0; i < cblListTag.Items.Count; i++)
{
if (cblListTag.Items[i].Selected)
{
GroupsItems.InsertGroupsItems(cblListTag.Items[i].Value, iid, "", DateTime.Now.ToString(), DateTime.Now.ToString(), DateTime.Now.ToString(), "0");
}
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "", "alert('Đã lưu tag');window.close();", true);
}
protected void btOK_Click(object sender, EventArgs e)
{
string chiTiet = ContentExtendtions.ProcessStringContent(tbChiTiet.Text, hdChiTiet.Value, pic);
#region Trạng thái
string trangThai = "0";
if (cbTrangThai.Checked == true)
{
trangThai = "1";
}
#endregion
#region Seo
if (tbSeoLink.Text.Trim().Equals(""))
{
tbSeoLink.Text = tbHoTen.Text;
}
if (tbSeoTitle.Text.Trim().Equals(""))
{
tbSeoTitle.Text = tbHoTen.Text;
}
if (tbSeoKeyword.Text.Trim().Equals(""))
{
tbSeoKeyword.Text = tbHoTen.Text;
}
if (tbSeoDescription.Text.Trim().Equals(""))
{
tbSeoDescription.Text = "";
}
#endregion
#region Ngày đăng
if (tbNgayDang.Text == "")
{
tbNgayDang.Text = DateTime.Now.ToString();
}
#endregion
string viparams = StringExtension.GhepChuoi("", tbCongTy.Text, tbChucVu.Text, tbTieuDeYKien.Text);
#region Insert
if (insert)
{
string image = flAnhDaiDien.Save(false, chiTiet);
GroupsItems.InsertItemsGroupsItems(lang, app, "", tbHoTen.Text, "", chiTiet,
image, tbDiaChi.Text, tbEmail.Text, tbSeoTitle.Text, tbSeoLink.Text,
StringExtension.ReplateTitle(tbSeoLink.Text),
tbSeoKeyword.Text, tbSeoDescription.Text, "", "", "", viparams, "",
"", "", "", tbNgayDang.Text,
DateTime.Now.ToString(), DateTime.Now.ToString(), tbThuTu.Text, ddlParentCate.SelectedValue,
tbNgayDang.Text, DateTime.Now.ToString(), DateTime.Now.ToString(), tbThuTu.Text, trangThai);
#region Logs
string logAuthor = CookieExtension.GetCookies("LoginSetting");
string logCreateDate = DateTime.Now.ToString();
Logs.InsertLogs(logCreateDate, Request.Url.ToString(), "", tbHoTen.Text, logAuthor, "", logCreateDate + ": " + logAuthor + " tạo mới " + tbHoTen.Text);
#endregion
}
#endregion
#region Update
else
{
string image = flAnhDaiDien.Save(true, chiTiet);
GroupsItems.DeleteGroupsItems(GroupsItemsTSql.GetGroupsItemsByIgiid(hdGroupsItemId.Value));
GroupsItems.UpdateItemsGroupsItems(lang, app, "", tbHoTen.Text, "", chiTiet,
image, tbDiaChi.Text, tbEmail.Text, tbSeoTitle.Text, tbSeoLink.Text,
StringExtension.ReplateTitle(tbSeoLink.Text),
tbSeoKeyword.Text, tbSeoDescription.Text, "", "", "", viparams, "",
"", "", hdTotalView.Value,
tbNgayDang.Text, DateTime.Now.ToString(), DateTime.Now.ToString(), tbThuTu.Text,
ddlParentCate.SelectedValue, tbNgayDang.Text, DateTime.Now.ToString(), DateTime.Now.ToString(),
tbThuTu.Text, trangThai, iid);
#region Logs
string logAuthor = CookieExtension.GetCookies("LoginSetting");
string logCreateDate = DateTime.Now.ToString();
Logs.InsertLogs(logCreateDate, Request.Url.ToString(), "", tbHoTen.Text, logAuthor, "", logCreateDate + ": " + logAuthor + " cập nhật " + tbHoTen.Text);
#endregion
}
#endregion
#region After Insert/Update
if (cbTiepTuc.Checked == true)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertSuccess",
"ThongBao(3000,'Đã tạo: " + tbHoTen.Text + "');", true);
ResetControls();
}
else
{
Response.Redirect(LinkRedrect());
}
#endregion
}
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 DeleteProperty(string igid, string iid)
{
GroupsItems.DeleteGroupsItems(DataExtension.AndConditon(GroupsItemsTSql.GetByIgid(igid),
GroupsItemsTSql.GetByIid(iid)));
}
protected void btOK_Click(object sender, EventArgs e)
{
string content = StringExtension.GhepChuoi("",
tbXuatPhat.Text,
tbPhuongTien.Text,
tbYoutubeEmbed.Text,
tbMaDinhKemBanDoTour.Text,
tbGioKhoiHanh.Text);
#region Trạng thái
string trangThai = "0";
if (cbTrangThai.Checked == true)
{
trangThai = "1";
}
#endregion
#region Seo
if (tbSeoLink.Text.Trim().Equals(""))
{
tbSeoLink.Text = tbTenTour.Text;
}
if (tbSeoTitle.Text.Trim().Equals(""))
{
tbSeoTitle.Text = tbTenTour.Text;
}
if (tbSeoKeyword.Text.Trim().Equals(""))
{
tbSeoKeyword.Text = tbTenTour.Text;
}
if (tbSeoDescription.Text.Trim().Equals(""))
{
tbSeoDescription.Text = tbMoTa.Text;
}
#endregion
#region Ngày đăng
if (tbNgayDang.Text == "")
{
tbNgayDang.Text = DateTime.Now.ToString();
}
#endregion
string giaChuanKhiDatTour = StringExtension.GhepChuoi("", tbGiaChoNguoiLon.Text, tbGiaChoTreViThanhNien.Text, tbGiaChoTreEm.Text,
tbGiaChoEmBe.Text);
#region Insert
if (insert)
{
string image = flAnhDaiDien.Save(false, tbMoTa.Text);
GroupsItems.InsertItemsGroupsItems(lang, app, tbMaTour.Text, tbTenTour.Text, tbMoTa.Text, content,
image, ddlThoiGianTour.SelectedValue, ddlDiemDen.SelectedValue, tbSeoTitle.Text, tbSeoLink.Text,
StringExtension.ReplateTitle(tbSeoLink.Text),
tbSeoKeyword.Text, tbSeoDescription.Text, giaChuanKhiDatTour, "", tbNgayKhoiHanh.Text, "", tbGiaNiemYet.Text,
tbGiaKhuyenMai.Text, "", "", tbNgayDang.Text,
DateTime.Now.ToString(), DateTime.Now.ToString(), tbThuTu.Text, ddlParentCate.SelectedValue,
tbNgayDang.Text, DateTime.Now.ToString(), DateTime.Now.ToString(), tbThuTu.Text, trangThai);
#region Lấy ra id của items vừa được thêm
iid = GetInsertedId(app, tbTenTour.Text, tbNgayDang.Text);
#endregion
#region Logs
string logAuthor = CookieExtension.GetCookies("LoginSetting");
string logCreateDate = DateTime.Now.ToString();
Logs.InsertLogs(logCreateDate, Request.Url.ToString(), "", tbTenTour.Text, logAuthor, "", logCreateDate + ": " + logAuthor + " tạo mới " + tbTenTour.Text);
#endregion
}
#endregion
#region Update
else
{
string image = flAnhDaiDien.Save(true, tbMoTa.Text);
GroupsItems.DeleteGroupsItems(GroupsItemsTSql.GetGroupsItemsByIgiid(hdGroupsItemId.Value));
GroupsItems.UpdateItemsGroupsItems(lang, app, tbMaTour.Text, tbTenTour.Text, tbMoTa.Text, content,
image, ddlThoiGianTour.SelectedValue, ddlDiemDen.SelectedValue, tbSeoTitle.Text, tbSeoLink.Text,
StringExtension.ReplateTitle(tbSeoLink.Text),
tbSeoKeyword.Text, tbSeoDescription.Text, giaChuanKhiDatTour, "", tbNgayKhoiHanh.Text, "", tbGiaNiemYet.Text,
tbGiaKhuyenMai.Text, "", hdTotalView.Value,
tbNgayDang.Text, DateTime.Now.ToString(), DateTime.Now.ToString(), tbThuTu.Text,
ddlParentCate.SelectedValue, tbNgayDang.Text, DateTime.Now.ToString(), DateTime.Now.ToString(),
tbThuTu.Text, trangThai, iid);
#region Logs
string logAuthor = CookieExtension.GetCookies("LoginSetting");
string logCreateDate = DateTime.Now.ToString();
Logs.InsertLogs(logCreateDate, Request.Url.ToString(), "", tbTenTour.Text, logAuthor, "", logCreateDate + ": " + logAuthor + " cập nhật " + tbTenTour.Text);
#endregion
}
#endregion
#region Thuộc tính tour, mỗi thuộc tính làm một bản ghi liên kết Groups_Items
#endregion
#region After Insert/Update
if (cbTiepTuc.Checked == true)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertSuccess",
"ThongBao(3000,'Đã tạo: " + tbTenTour.Text + "');", true);
ResetControls();
}
else
{
Response.Redirect(LinkRedrect());
}
#endregion
}
void GetFileLibrary(string order)
{
if (!igid.Equals(""))
{
ddlCateSearch.SelectedValue = igid;
condition = GroupsItemsTSql.GetItemsInGroupCondition(ddlCateSearch.SelectedValue, "");
}
else
{
condition = DataExtension.AndConditon(
"VGAPP = '" + app + "'",
GroupsTSql.GetGroupsByVglang(language));
}
#region Điều chỉnh bộ lọc với tính năng duyệt tin
if (FileLibraryConfig.KeyDuyetTin)
{
if (HorizaMenuConfig.ShowDuyetTin1 || HorizaMenuConfig.ShowDuyetTin2)
{
string userId = CookieExtension.GetCookies("UserId");
condition += " AND IIENABLE = '0' ";
condition += " AND VIURL = '" + userId + "' ";
}
}
else
{
condition += " AND IIENABLE <> '2' ";
}
#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(CodeApplications.FileLibrary, TypePage.Item,
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();
}
