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);
}
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 GetCartDetails(string iid)
{
DataTable dt = new DataTable();
condition = DataExtension.AndConditon(
ItemsTSql.GetItemsByViapp(app),
ItemsTSql.GetItemsByIid(iid)
);
dt = TatThanhJsc.Database.Items.GetItems("1", "*", condition, "");
if (dt.Rows.Count > 0)
{
ltrMaDonHang.Text = dt.Rows[0][ItemsColumns.VikeyColumn].ToString();
ltrThongTinKhachHang.Text = LayThongTinKhachHang(dt.Rows[0][ItemsColumns.VicontentColumn].ToString());
double phiVanChuyen = 0;
double tongTienHang = 0;
try
{
phiVanChuyen = double.Parse(dt.Rows[0][ItemsColumns.FisalepriceColumn].ToString());
}
catch { }
try
{
tongTienHang = double.Parse(dt.Rows[0][ItemsColumns.FipriceColumn].ToString());
}
catch {}
tongTienHang += phiVanChuyen;
ltrTotalPrice.Text = NumberExtension.FormatNumber(tongTienHang.ToString());
ltrReadPrice.Text = NumberExtension.ReadNumber(tongTienHang.ToString());
GetList(iid);
}
}
void GetItemsInfo()
{
fields = DataExtension.GetListColumns(ItemsColumns.VititleColumn, ItemsColumns.DicreatedateColumn);
DataTable dt = new DataTable();
dt = TatThanhJsc.Database.Items.GetItems("", "*", ItemsTSql.GetItemsByIid(iid), "");
#region ThongTinCoBan
ltrHotelName.Text = @"
<div class='fwb'>
Thông tin :
</div>
<div class='cbh20'><!----></div>
<div class='fwb'>
" + dt.Rows[0][ItemsColumns.VititleColumn].ToString() + @"
</div>
<div class='cbh5'><!----></div>
<div style='font:11px Tahoma;color:#0e0e0e;'>
Ngày đăng: " + ((DateTime)dt.Rows[0][ItemsColumns.DicreatedateColumn]).ToString("dd/MM/yyyy") + @" - Lượt xem: " + dt.Rows[0][ItemsColumns.IitotalviewColumn].ToString() + @"
</div>
<div class='cbh5'><!----></div>
<div style='font:12px/18px Tahoma;color:#000;'>
" + dt.Rows[0][ItemsColumns.VicontentColumn].ToString() + @"
</div>
<div class='cbh20'><!----></div>
";
#endregion
}
public static string GetPropertyIcon(string iid, string propertyApp, string pic)
{
string s = "";
string lang = TatThanhJsc.LanguageModul.Cookie.GetLanguageValueDisplay();
string condition = DataExtension.AndConditon(
GroupsTSql.GetByApp(propertyApp),
GroupsTSql.GetByEnable("1"),
GroupsTSql.GetByLang(lang),
ItemsTSql.GetItemsByIid(iid));
DataTable dt = GroupsItems.GetAllData("", GroupsColumns.VgimageColumn + "," + GroupsColumns.VgnameColumn,
condition, GroupsColumns.IgorderColumn);
if (dt.Rows.Count > 0)
{
s += "<span class='propertyIcons'>";
for (int i = 0; i < dt.Rows.Count; i++)
{
s += ImagesExtension.GetImage(pic, dt.Rows[i][GroupsColumns.VgimageColumn].ToString(),
dt.Rows[i][GroupsColumns.VgnameColumn].ToString(), "propertyIcon", false, false, "");
}
s += "</span>";
}
return(s);
}
public void DeleteRecItem(string iid, string pic)
{
#region Xóa ảnh items
DataTable dt = new DataTable();
dt = TatThanhJsc.Database.Items.GetItems("", ItemsColumns.ViimageColumn, ItemsTSql.GetItemsByIid(iid), "");
string split = TatThanhJsc.AdminModul.Keyword.ParamsSpilitItems;
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i][ItemsColumns.ViimageColumn].ToString().IndexOf(split) < 0)
{
ImagesExtension.DeleteImageWhenDeleteItem(pic, dt.Rows[i][ItemsColumns.ViimageColumn].ToString());
ImagesExtension.DeleteImageWhenDeleteItem(pic, dt.Rows[i][ItemsColumns.ViimageColumn].ToString().Replace("_HasThumb.", "_HasThumb_Thumb."));
}
else
{
foreach (
string s in
dt.Rows[i][ItemsColumns.ViimageColumn].ToString()
.Split(new string[] { split }, StringSplitOptions.RemoveEmptyEntries))
{
ImagesExtension.DeleteImageWhenDeleteItem(pic, s);
ImagesExtension.DeleteImageWhenDeleteItem(pic, s.Replace("_HasThumb.", "_HasThumb_Thumb."));
}
}
}
#endregion
DeleteSubItems(iid, pic);
GroupsItems.DeleteItemsGroupsItemsByIid(iid);
}
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
}
void InitialControlsValue(bool insert)
{
#region update
if (!insert)
{
btn_insert_update.Text = "Đồng ý";
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();
hdOldContent.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 = 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 = dt.Rows[0]["VIIMAGE"].ToString();
#endregion
HdIitotalview = 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
}
#endregion
#region insert
else
{
btn_insert_update.Text = "Đồng ý";
txtCreateDate.Text = DateTime.Now.ToString();
}
#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 GetItems(string order)
{
if (!igid.Equals(""))
{
ddlCateSearch.SelectedValue = igid;
condition = GroupsItemsTSql.GetItemsInGroupCondition(ddlCateSearch.SelectedValue, ItemsTSql.GetItemsByViapp(app));
}
else
{
condition = DataExtension.AndConditon(
"VGAPP = '" + appCate + "'",
GroupsTSql.GetGroupsByVglang(language),
ItemsTSql.GetItemsByViapp(app),
ItemsTSql.GetItemsByVilang(language));
}
condition += " AND IIENABLE <> '2' AND IGENABLE <> '2' ";
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 = ItemsColumns.IiorderColumn + "," + ItemsColumns.DicreatedateColumn + " 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.Destination, TypePage.Item,
ddlCateSearch.SelectedValue, key,
NumberShowItem) + "&app=" + app, "currentPS", "otherPS", "firstPS",
"lastPS", "previewPS", "nextPS");
LtPaggingTop.Text = LtPagging.Text;
rp_mn_users.DataSource = ds.Tables[0];
rp_mn_users.DataBind();
}
protected void rp_mn_users_ItemCommand(object source, RepeaterCommandEventArgs e)
{
string c = e.CommandName.Trim();
string p = e.CommandArgument.ToString().Trim();
fields = "*";
condition = ItemsTSql.GetItemsCondition(p, app);
DataTable dt = new DataTable();
dt = GroupsItems.GetAllData(top, fields, condition, orderBy);
switch (c)
{
#region Delete
case "delete":
TatThanhJsc.Database.Items.DeleteItems(ItemsTSql.GetItemsByIid(p));
break;
#endregion
#region Edit Enable
case "EditEnable":
string[] fieldsEnable = { "IIENABLE" };
string[] valuesEnable = { "" };
if (dt.Rows[0]["IIENABLE"].ToString().Equals("0"))
{
valuesEnable[0] = "1";
TatThanhJsc.Database.Items.UpdateItems(DataExtension.UpdateTransfer(fieldsEnable, valuesEnable), condition);
}
else
{
valuesEnable[0] = "0";
TatThanhJsc.Database.Items.UpdateItems(DataExtension.UpdateTransfer(fieldsEnable, valuesEnable), condition);
}
GetVotes();
break;
#endregion
#region Edit
case "edit":
pnList.Visible = false;
pnShorcut.Visible = true;
hdInsertUpdate.Value = "update";
HdId.Value = dt.Rows[0]["IID"].ToString();
TbRep.Text = dt.Rows[0]["VITITLE"].ToString();
if (dt.Rows[0]["IIENABLE"].ToString().Equals("1"))
{
cbEnable.Checked = true;
}
else
{
cbEnable.Checked = false;
}
break;
#endregion
}
}
protected string GetItemNameById(string iid)
{
DataTable dt = Items.GetItems("1", ItemsColumns.VititleColumn, ItemsTSql.GetById(iid), "");
if (dt.Rows.Count > 0)
{
return(dt.Rows[0][ItemsColumns.VititleColumn].ToString());
}
return("");
}
protected void UpdateTitle(object sender, EventArgs e)
{
TextBox textbox = sender as TextBox;
string[] fields = { ItemsColumns.VititleColumn };
string[] values = { "N'" + textbox.Text + "'" };
string condition = ItemsTSql.GetItemsByIid(textbox.ToolTip);
TatThanhJsc.Database.Items.UpdateItems(DataExtension.UpdateTransfer(fields, values), condition);
//GetListWebsites("");
}
private string GetTitle(string iid)
{
DataTable dt = new DataTable();
dt = TatThanhJsc.Database.Items.GetItems("1", ItemsColumns.VititleColumn, ItemsTSql.GetItemsByIid(iid), "");
if (dt.Rows.Count > 0)
{
return(dt.Rows[0][ItemsColumns.VititleColumn].ToString());
}
return("");
}
//Lấy thông tin của nhóm modul, in ra literal
void GetDetailGroups()
{
DataTable dt = new DataTable();
fields = "*";
condition = ItemsTSql.GetItemsByIid(igid);
dt = TatThanhJsc.Database.Items.GetItems(top, fields, condition, orderBy);
if (dt.Rows.Count > 0)
{
lt_cate_name.Text = "<div>" + dt.Rows[0]["VITITLE"] + "</div>";
}
}
private string GetIid()
{
condition = ItemsTSql.GetItemsByViapp(app);
DataTable dt = new DataTable();
dt = GroupsItems.GetAllData("1", "Items.iid", condition, ItemsColumns.IidColumn + " desc");
if (dt.Rows.Count > 0)
{
return(dt.Rows[0][ItemsColumns.IidColumn].ToString());
}
return("");
}
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 GetNews(string order)
{
DdlListShowItem.SelectedValue = NumberShowItem;
condition = DataExtension.AndConditon(
"VIAPP = 'QLDDDV'",
ItemsTSql.GetByLang(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.Service, "QuanLyDonDatDichVu",
"", key,
NumberShowItem), "currentPS", "otherPS", "firstPS",
"lastPS", "previewPS", "nextPS");
LtPaggingTop.Text = LtPagging.Text;
rp_mn_users.DataSource = ds.Tables[0];
rp_mn_users.DataBind();
}
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();
}
string loadDataDetail(string iid)
{
string s = "";
condition = DataExtension.AndConditon(
ItemsTSql.GetItemsByIid(iid)
);
DataTable dt = TatThanhJsc.Database.Items.GetItems("", " * ", condition, "");
if (dt.Rows.Count > 0)
{
s = dt.Rows[0]["VITITLE"].ToString();
}
return(s);
}
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));
}
void GetTitleItem()
{
fields = TatThanhJsc.Extension.DataExtension.GetListColumns(TatThanhJsc.Columns.ItemsColumns.VititleColumn, TatThanhJsc.Columns.ItemsColumns.DicreatedateColumn);
condition = ItemsTSql.GetItemsByIid(iid);
DataTable dt = new DataTable();
dt = GroupsItems.GetAllData(top, fields, condition, orderBy);
if (dt.Rows.Count > 0)
{
LtTitlePage.Text = dt.Rows[0]["VITITLE"].ToString();
lt_cate_name.Text = @"
<div class='TitleItem'>Tên album: " + dt.Rows[0]["VITITLE"].ToString() + @"</div>
<div>Ngày đăng: " + TatThanhJsc.Extension.TimeExtension.FormatTime(dt.Rows[0][TatThanhJsc.Columns.ItemsColumns.DicreatedateColumn], "dd/MM/yyyy") + @"</div>";
}
}
private static string GetCateOfBlog(string iid)
{
string condition = DataExtension.AndConditon(
GroupsTSql.GetByApp(TatThanhJsc.BlogModul.CodeApplications.Blog),
ItemsTSql.GetById(iid)
);
DataTable dt = GroupsItems.GetAllData("1", "*", condition, "");
if (dt.Rows.Count > 0)
{
return("<a href='" + (UrlExtension.WebisteUrl + dt.Rows[0][GroupsColumns.VGSEOLINKSEARCHColumn] + RewriteExtension.Extensions).ToLower() + @"' title='" + dt.Rows[0][GroupsColumns.VgnameColumn] + @"'>" + dt.Rows[0][GroupsColumns.VgnameColumn] + @"</a>");
}
return("");
}
string GetInsertedId(string app, string title, string createDate)
{
string condition = DataExtension.AndConditon(
ItemsTSql.GetByApp(app),
ItemsTSql.GetByTitle(title),
ItemsTSql.GetByCreateDate(createDate)
);
DataTable dt = Items.GetItems("1", ItemsColumns.IidColumn, condition, ItemsColumns.IidColumn + " desc");
if (dt.Rows.Count > 0)
{
return(dt.Rows[0][ItemsColumns.IidColumn].ToString());
}
return("");
}
void GetItemsInfo()
{
fields = DataExtension.GetListColumns(ItemsColumns.VititleColumn, ItemsColumns.FipriceColumn, ItemsColumns.FisalepriceColumn);
DataTable dt = new DataTable();
dt = TatThanhJsc.Database.Items.GetItems("", fields, ItemsTSql.GetItemsByIid(iid), "");
#region ThongTinCoBan
ltrName.Text = @"
<div class='fwb'>
Tên deal: " + dt.Rows[0][ItemsColumns.VititleColumn].ToString() + @"
</div>
<div class='cbh20'><!----></div>
";
#endregion
}
protected void rp_mn_users_ItemCommand(object source, RepeaterCommandEventArgs e)
{
string c = e.CommandName.Trim();
string p = e.CommandArgument.ToString().Trim();
fields = "*";
condition = ItemsTSql.GetItemsCondition(p, app);
switch (c)
{
#region Delete
case "delete":
string[] fieldsDelItem = { "IIENABLE", ItemsColumns.DiupdateColumn };
string[] valuesDelItem = { "2", "'" + DateTime.Now.ToString() + "'" };
Items.UpdateItems(DataExtension.UpdateTransfer(fieldsDelItem, valuesDelItem), condition);
GetService("");
break;
#endregion
#region Edit Enable
case "EditEnable":
DataTable dt = new DataTable();
dt = GroupsItems.GetAllData(top, fields, condition, orderBy);
string[] fieldsEnable = { "IIENABLE" };
string[] valuesEnable = { "" };
if (dt.Rows[0]["IIENABLE"].ToString().Equals("0"))
{
valuesEnable[0] = "1";
Items.UpdateItems(DataExtension.UpdateTransfer(fieldsEnable, valuesEnable), condition);
}
else
{
valuesEnable[0] = "0";
Items.UpdateItems(DataExtension.UpdateTransfer(fieldsEnable, valuesEnable), condition);
}
GetService("");
break;
#endregion
#region Edit
case "edit":
Response.Redirect(LinkUpdate(p));
break;
#endregion
}
}
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 void GetGroupsInfoByItemId(string iid, string viapp)
{
string condition = DataExtension.AndConditon(
GroupsTSql.GetGroupsByIgenable("1"),
GroupsTSql.GetGroupsByVgapp(viapp),
GroupsTSql.GetGroupsByVglang(lang),
ItemsTSql.GetItemsByIid(iid)
);
DataTable dt = GroupsItems.GetAllData("1", "groups.*", condition, "");
if (dt.Rows.Count > 0)
{
Session["dataByTitle_Cate"] = dt;
Session["igid"] = dt.Rows[0][GroupsColumns.IgidColumn].ToString();
}
}
void GetItems()
{
top = "10";
fields = "*";
condition = DataExtension.AndConditon(
GroupsTSql.GetGroupsByVgapp(app) + " AND IGENABLE <> '2' AND IIENABLE <> '2' ",
ItemsTSql.GetItemsByVilang(language));
orderBy = ItemsColumns.IitotalviewColumn + " desc";
DataTable dt = new DataTable();
dt = GroupsItems.GetAllData(top, fields, condition, orderBy);
if (dt.Rows.Count > 0)
{
RpItems.DataSource = dt;
RpItems.DataBind();
}
}
