private void BindGroup()
{
DataTable dt = Data.GetHotGroup(10, CategoryB.ToCategory(catID).ID);
StringBuilder sb = new StringBuilder();
foreach (DataRow row in dt.Rows)
{
sb.AppendFormat("<div class='gitem'><div style='float:left;width:50px;'><img src='/upload/group/{0}-s.jpg' {1} /></div>", row["g_id"], Strings.GroupSmallImageError);
sb.AppendFormat("<div style='float:right;width:100px;'><a href='/group/{0}{1}' target=_blank>{2}</a>", row["g_id"], Settings.Ext, Tools.HtmlEncode(row["g_name"].ToString()));
sb.AppendFormat("<br /><span class='em'>人气：{0}</span></div><div class='clear'></div></div>", row["g_redu"]);
}
lblGroup.Text = sb.ToString();
}
private void BindUserBlog()
{
string un = q.Split('/')[0].Replace("'", "");
string sql = "select top " + size.ToString() + " [_id],[user_name],[title],[cat_id],[zhaiyao],[uptime],[filepath] from [blog] ";
sql += "where [user_name]='" + un + "'";
int subid = 0;
if (q.Split('/').Length > 2)
{
if (int.TryParse(q.Split('/')[1], out subid))
{
sql += " and [subcat_id]=" + subid.ToString();
}
}
string cat = "";
if (subid > 0)
{
cat = DB.GetValue("select [uc_name] from [user_category] where [uc_id]=" + subid.ToString()).ToString();
cat = "[" + cat + "]";
}
DataTable dt = DB.GetTable(sql);
StringBuilder sb = new StringBuilder();
sb.Append(RSSHead);
sb.Append("<channel>");
sb.AppendFormat("<title>订阅{0}的博客{1} - cnOpenBlog.com</title>", un, cat);
sb.AppendFormat("<link>{0}{1}/feed{2}</link>", Settings.BaseURL, q, Settings.Ext);
sb.Append("<description></description>");
sb.AppendFormat("<pubDate>{0}</pubDate>", DateTime.Now.ToLongTimeString());
sb.AppendFormat("<generator>{0}{1}{2}</generator>", Settings.BaseURL, q, Settings.Ext);
Response.Write(sb.ToString());
foreach (DataRow row in dt.Rows)
{
sb = new StringBuilder();
sb.Append("<item>");
sb.AppendFormat("<title><![CDATA[{0}]]></title>", row["title"]);
sb.AppendFormat("<link>{0}{1}</link>", Settings.BaseURL.TrimEnd('/'), row["filepath"]);
sb.AppendFormat("<description><![CDATA[{0}]]></description>", row["zhaiyao"]);
sb.AppendFormat("<author>{0}</author>", un);
sb.AppendFormat("<category>{0}</category>", CategoryB.GetNameById((int)row["cat_id"]));
sb.AppendFormat("<pubDate>{0}</pubDate>", row["uptime"]);
sb.AppendFormat("<guid>{0}{1}</guid>", Settings.BaseURL.TrimEnd('/'), row["filepath"]);
sb.Append("</item>");
Response.Write(sb.ToString());
}
Response.Write("</channel>");
Response.Write("</rss>");
}
private void BindBlog()
{
int catID = 0;
int.TryParse(q.Split('/')[0], out catID);
string sort = "date";
if (q.Contains("/"))
{
sort = q.Split('/')[1];
}
string where = "";
if (catID > 100)
{
where = " where [cat_id]=" + catID.ToString();
}
string sql = "select top " + size.ToString() + " [_id],[user_name],[title],[cat_id],[zhaiyao],[uptime],[filepath] from [blog]";
sql += where;
if (sort == "read")
{
sql += " order by [read_cnt] desc";
}
else if (sort == "comment")
{
sql += " order by [comment_cnt] desc";
}
else
{
sql += " order by [_id] desc";
}
DataTable dt = DB.GetTable(sql);
StringBuilder sb = new StringBuilder();
sb.Append(RSSHead);
sb.Append("<channel>");
sb.Append("<title>博客订阅 - cnOpenBlog.com</title>");
sb.AppendFormat("<link>{0}{1}/feed{2}</link>", Settings.BaseURL, q, Settings.Ext);
sb.Append("<description></description>");
sb.AppendFormat("<pubDate>{0}</pubDate>", DateTime.Now.ToLongTimeString());
sb.AppendFormat("<generator>{0}{1}{2}</generator>", Settings.BaseURL, q, Settings.Ext);
Response.Write(sb.ToString());
foreach (DataRow row in dt.Rows)
{
sb = new StringBuilder();
sb.Append("<item>");
sb.AppendFormat("<title><![CDATA[{0}]]></title>", row["title"]);
sb.AppendFormat("<link>{0}{1}</link>", Settings.BaseURL.TrimEnd('/'), row["filepath"]);
sb.AppendFormat("<description><![CDATA[{0}]]></description>", row["zhaiyao"]);
sb.AppendFormat("<author>{0}</author>", row["user_name"]);
sb.AppendFormat("<category>{0}</category>", CategoryB.GetNameById((int)row["cat_id"]));
sb.AppendFormat("<pubDate>{0}</pubDate>", row["uptime"]);
sb.AppendFormat("<guid>{0}{1}</guid>", Settings.BaseURL.TrimEnd('/'), row["filepath"]);
sb.Append("</item>");
Response.Write(sb.ToString());
}
Response.Write("</channel>");
Response.Write("</rss>");
}
private void BindBlog()
{
string where = "1=1";
if (catID > 100)
{
where += " and [cat_id]=" + catID.ToString();
}
string sqlc = "select count(*) from [blog] where " + where;
where += " and [blog].[user_name]=[users].[_name]";
int cnt = (int)DB.GetValue(sqlc);
if (cnt == 0)
{
return;
}
pageCount = cnt / pageSize;
if (cnt % pageSize > 0)
{
pageCount++;
}
pageIndex = Math.Max(0, pageIndex);
pageIndex = Math.Min(pageCount - 1, pageIndex);
string fieldlist = "[blog].[_id],[user_name],[fullname],[cat_id],[subcat_id],[title],[zhaiyao],[comment_cnt],[read_cnt],[filepath],[edit_time]";
string orderfield = "[edit_time]";
if (sort == "read")
{
orderfield = "[read_cnt]";
}
else if (sort == "comment")
{
orderfield = "[comment_cnt]";
}
DataTable dt = Data.GetPagingData("[blog],[users]", fieldlist, orderfield, "[blog].[_id]", pageIndex, pageSize, where, true);
if (dt == null || dt.Rows.Count == 0)
{
return;
}
DataRow[] rows = null;
if (sort == "read")
{
rows = dt.Select("", "read_cnt desc,edit_time desc");
}
if (sort == "comment")
{
rows = dt.Select("", "comment_cnt desc,edit_time desc");
}
else
{
rows = dt.Select("");
}
StringBuilder sb = new StringBuilder();
foreach (DataRow row in rows)
{
sb.Append("<div>");
sb.AppendFormat("<p class='title'><a href='{0}'>{1}</a></p>", row["filepath"], Tools.HtmlEncode(row["title"].ToString()));
sb.AppendFormat("<p class='zhaiyao'>摘要: {0} - <a href='{1}'>阅读全文</a></p>", Tools.HtmlEncode(row["zhaiyao"].ToString()), row["filepath"]);
sb.Append("<p class='bot'>");
if (catID == 10)
{
sb.AppendFormat("类别：<a href='/{0}{1}'>{2}</a> ", row["cat_id"], Settings.Ext, CategoryB.GetNameById((int)row["cat_id"]));
}
sb.AppendFormat("作者：<a href='/{0}{1}'>{2}</a> ", row["user_name"], Settings.Ext, row["fullname"]);
sb.AppendFormat("【评论:{0}】【阅读:{1}】 {2}</p>", row["comment_cnt"], row["read_cnt"], Tools.DateString(row["edit_time"].ToString()));
sb.Append("</div>");
}
lblBlogList.Text = sb.ToString();
if (pageCount > 1)
{
string url = String.Format("/{0}/{1}/{2}{3}", catID, sort, "{0}", Settings.Ext);
lblPageList.Text = Tools.GetPager(pageIndex, pageCount, pageNumber, url);
}
}
public Shop GetShops()
{
var listVendor = new Vendor().GetListVendor();
var baseUrl = Settings.PriceSettings.BaseURL;
var list = new List <Shop>();
var listCategory = new CategoryB().GetListCategory().Select(x => x.Id).ToList <int>();
var shop = new Shop()
{
Name = Settings.PriceSettings.Name,
Company = Settings.PriceSettings.CopanyName,
Url = Settings.PriceSettings.URL,
Currencies = new Currencies()
{
Currency = new Currency()
{
Id = "UAH", Rate = "1"
}
},
};
var listAddParams = new AddParam().GetListAddParam();
var listAdd = new Product().GetNameReplace();
var listPictureAdd = new Picture().GetListPicture();
foreach (var categoryId in listCategory)
{
var ListCat = new CategoryB().GetListcategoryToPrice(categoryId);
var categories = new List <Category>();
foreach (var cat in ListCat)
{
if (!listPictureAdd.Select(x => x.category).Contains(cat.Id))
{
continue;
}
if (cat.Parent_Id == 0)
{
categories.Add(new Category()
{
Id = cat.Id.ToString(),
Text = cat.Name.ToString()
});
}
else
{
categories.Add(new Category()
{
Id = cat.Id.ToString(),
Text = cat.Name.ToString(),
ParentId = cat.Parent_Id.ToString()
});
var parent = new CategoryB().GetListcategoryToPrice(cat.Parent_Id);
categories.Add(new Category()
{
Id = parent.FirstOrDefault().Id.ToString(),
Text = parent.FirstOrDefault().Name.ToString()
});
}
}
var listOffes = new List <Offer>();
var products = new Product().GetListProduct(categoryId);
if (products.Count() == 0)
{
continue;
}
foreach (var product in products)
{
if (!listPictureAdd.Where(x => x.link.Contains(product.Url)).Any())
{
continue;
}
var skuses = new Skus().GetListSkus(product.Id);
if (product.Images.Count() == 0)
{
continue;
}
foreach (var skus in skuses)
{
var parames = new List <Param>();
var listParames = new Paramses().GetListParams(product.Id, skus.Id);
foreach (var item in listParames.Where(x => x.Status == true))
{
parames.Add(
new Param()
{
Name = item.Name.ToString(),
Text = item.Text.ToString()
});
}
foreach (var item in listAddParams.Where(z => z.GroupId == categoryId))
{
parames.Add(
new Param()
{
Name = item.ParamName.ToString(),
Text = item.ParamValue.ToString()
});
}
var additname = string.Empty;
if (product.addparam > 0)
{
var addName = listAdd[product.addparam];
var add = parames.Where(x => x.Name == addName).FirstOrDefault();
if (add != null)
{
additname = " " + add.Text.ToString();
}
}
if (skus.Price == 0)
{
skus.Price = product.Price;
}
if (skus.Price == 0)
{
continue;
}
var markup = listParames.Where(x => x.Status == false).FirstOrDefault()?.Text;
double markupValue = 0;
var resM = double.TryParse(markup, out markupValue);
if (resM && markupValue > 0)
{
markupValue = markupValue / 100;
skus.Price = Math.Round(skus.Price + skus.Price * markupValue, 0);
}
listOffes.Add(new Offer()
{
Id = skus.Id.ToString(),
Available = "true",
Url = baseUrl + product.Url.ToString(),
Price = skus.Price.ToString(),
Price_old = (skus.OldPrice == 0) ? null : skus.OldPrice.ToString(),
CurrencyId = "UAH",
CategoryId = categoryId.ToString(),
Picture = product.Images,
Vendor = listVendor.Where(x => x.Product_id == skus.Product_id)?.FirstOrDefault()?.Name ?? string.Empty,
Stock_quantity = product.Count.ToString(),
Name = product.Name.ToString() + additname.ToString(),
Description = product.Description.ToString(),
Param = parames
});
}
}
if (listOffes.Count() == 0)
{
continue;
}
if (shop.Categories == null)
{
shop.Categories = new Categories()
{
Category = categories
}
}
;
else
{
shop.Categories.Category.AddRange(categories);
}
if (shop.Offers == null)
{
shop.Offers = new Offers()
{
Offer = listOffes
}
}
;
else
{
shop.Offers.Offer.AddRange(listOffes);
}
shop.Offers.Offer = shop.Offers.Offer.GroupBy(x => x.Id).Select(x => new Offer
{
Id = x.Key,
Available = x.Select(z => z.Available).FirstOrDefault().ToString(),
CategoryId = x.Select(z => z.CategoryId).FirstOrDefault().ToString(),
CurrencyId = x.Select(z => z.CurrencyId).FirstOrDefault().ToString(),
Description = x.Select(z => z.Description).FirstOrDefault().ToString(),
Name = x.Select(z => z.Name).FirstOrDefault().ToString(),
Param = x.Select(z => z.Param).FirstOrDefault(),
Picture = x.Select(z => z.Picture).FirstOrDefault(),
Price = x.Select(z => z.Price).FirstOrDefault(),
Price_old = x.Select(z => z.Price_old).FirstOrDefault(),
Stock_quantity = x.Select(z => z.Stock_quantity).FirstOrDefault(),
Url = x.Select(z => z.Url).FirstOrDefault(),
Vendor = x.Select(z => z.Vendor).FirstOrDefault().ToString()
}).ToList();
var listName = shop.Offers.Offer.GroupBy(x => x.Name);
foreach (var item in listName)
{
if (item.Count() > 1)
{
Settings.Dublicates.Add(string.Concat(item.Select(x => x.CategoryId).FirstOrDefault(), item.Select(x => x.Url).FirstOrDefault()));
}
}
foreach (var item in shop.Offers.Offer)
{
if (item.Description.Contains(" href"))
{
Settings.Urls.Add(item.Url);
}
if (item.Vendor == string.Empty)
{
Settings.Errores.Add(string.Format("Не указана торговая марка {0}, {1}", item.Id, string.Empty));
}
}
}
if (shop.Categories == null)
{
return(shop);
}
shop.Categories.Category = shop.Categories.Category.GroupBy(x => x.Id).Select(x => new Category {
Id = x.Key, ParentId = x.Select(z => z.ParentId).FirstOrDefault(), Text = x.Select(z => z.Text).FirstOrDefault()
}).ToList();
return(shop);
}
public void DoSomething(CategoryB c)
{
Console.WriteLine("B");
}
