public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/html";
StringBuilder _strContent = new StringBuilder();
if (_strContent.Length == 0)
{
string _strAction = context.Request.Params["action"];
if (string.IsNullOrEmpty(_strAction))
{
_strContent.Append(_strContent.Append(SqlHelperCatalog.WriteTemplate("", "404.html")));
}
else
{
switch (_strAction.Trim())
{
case "MainPage": _strContent.Append(MainPage(context)); break; //主页
case "GetProduct": _strContent.Append(GetProduct(context)); break; //栏目，产品列表页
case "DetailPage": _strContent.Append(DetailPage(context)); break; //渲染动态详情页，伪静态可用
case "sitemap": _strContent.Append(SiteMapXML(context)); break; //站点地图XML
case "sitemap.html": _strContent.Append(SiteMapHtml(context)); break; //站点地图Html
default: break;
}
}
}
context.Response.Write(_strContent.ToString());
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/html";
string columnId = context.Request["cId"];
string Id = context.Request["Id"];
if (!string.IsNullOrEmpty(columnId) && !string.IsNullOrEmpty(Id))
{
List <htmlPara> pList = bll.GetHtmlBAPage(columnId, Id);//上一篇，下一篇
object BPage = null, APage = null;
if (pList.Count == 2)
{
BPage = new { Href = pList[0].titleURL, Title = pList[0].title };
APage = new { Href = pList[1].titleURL, Title = pList[1].title };
}
else
{
BPage = new { Href = pList[0].titleURL, Title = pList[0].title };
APage = new { Href = "javascript:alert('没有了');", Title = "没有了" };
}
var data = new
{
BPage,
APage
};
string html = SqlHelperCatalog.WriteTemplate(data, "BAPage.html");
context.Response.Write(html);
}
}
/// <summary>
/// 更多产品页
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
public string MoreProduct(HttpContext context)
{
string cId = "21";
var data = new
{
htmlTitle = "产品栏目",
hostName,
hostUrl,
cId,
c1Title = GetParaByCId("1", 1, 10),
c2Title = GetParaByCId("2", 1, 10),
c3Title = GetParaByCId("3", 1, 10),
c4Title = GetParaByCId("4", 1, 10),//工具量具，不显示
c5Title = GetParaByCId("5", 1, 10),
c6Title = GetParaByCId("6", 1, 10),
c7Title = GetParaByCId("7", 1, 10),
c8Title = GetParaByCId("8", 1, 10),
c9Title = GetParaByCId("9", 1, 10),
c10Title = GetParaByCId("10", 1, 10),
c11Title = GetParaByCId("11", 1, 10),
c12Title = GetParaByCId("12", 1, 10),
c13Title = GetParaByCId("13", 1, 10),
c14Title = GetParaByCId("14", 1, 10),
c15Title = GetParaByCId("15", 1, 10),
c16Title = GetParaByCId("16", 1, 10),
c17Title = GetParaByCId("17", 1, 10),
c18Title = GetParaByCId("18", 1, 10),
c19Title = GetParaByCId("19", 1, 10)
};
return(SqlHelperCatalog.WriteTemplate(data, "MoreProduct.html"));
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/html";
StringBuilder _strContent = new StringBuilder();
if (_strContent.Length == 0)
{
string _strAction = context.Request.Params["action"];
if (string.IsNullOrEmpty(_strAction))
{
_strContent.Append(_strContent.Append(SqlHelperCatalog.WriteTemplate("", "404.html")));
}
else
{
switch (_strAction.Trim())
{
case "MainPage": _strContent.Append(MainPage(context)); break;
case "GetProduct": _strContent.Append(GetProduct(context)); break; //产品列表
case "GetNews": _strContent.Append(GetNews(context)); break; //新闻列表
case "MoreProduct": _strContent.Append(MoreProduct(context)); break; //更多产品
case "MoreNews": _strContent.Append(MoreNews(context)); break; //更多新闻
case "DetailPage": _strContent.Append(DetailPage(context)); break; //渲染详情页
default: break;
}
}
}
context.Response.Write(_strContent.ToString());
}
/// <summary>
///
/// </summary>
/// <param name="columnId"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public List <htmlPara> GetHtmlList(string count, string columnId)
{
//分页查询
List <htmlPara> hList = new List <htmlPara>();
DataTable dt = SqlHelperCatalog.ExecuteDataTable(@"select top (CONVERT(int,@count)) * from htmlPara where columnId !='@columnId' order by addTime desc",
new SqlParameter("@columnId", columnId),
new SqlParameter("@count", count));
if (dt.Rows.Count < 1)
{
return(null);
}
foreach (DataRow row in dt.Rows)
{
htmlPara hPara = new htmlPara();
hPara.Id = (long)row["Id"];
hPara.userId = row["userId"].ToString();
hPara.title = (string)row["title"];
hPara.titleImg = (string)row["titleImg"];
hPara.titleURL = (string)row["titleURL"];
hPara.columnId = (string)row["columnId"]; //栏目Id
string content = (string)row["articlecontent"];
hPara.articlecontent = ReplaceHtmlTag(content, 60); //产品简介
hPara.city = (string)row["city"]; //生产城市
hPara.smallCount = (string)row["smallCount"]; //起订
hPara.companyName = (string)SqlHelper.FromDBNull(row["companyName"]); //公司名字
hPara.ten_qq = (string)SqlHelper.FromDBNull(row["ten_qq"]);
hPara.com_web = (string)SqlHelper.FromDBNull(row["com_web"]); //网址
hPara.addTime = ((DateTime)row["addTime"]).ToString("yyyy-MM-dd");
hList.Add(hPara);
}
return(hList);
}
/// <summary>
/// 获取目录主页内容
/// </summary>
/// <param name="sqlstr"></param>
/// <returns></returns>
public List <htmlInfo> GetMainHtmlList()
{
List <htmlInfo> hList = new List <htmlInfo>();
// DataTable dt = SqlHelper.ExecuteDataSet(@"select title,titleImg,titleURL,addTime,columnId,columnName from
//( select
//RANK()OVER(PARTITION BY columnInfo.Id ORDER BY htmlInfo.addTime DESC) AS
//RANK2, title,titleImg,titleURL,addTime,htmlInfo.columnId,columnName from
//htmlInfo left join columnInfo On htmlInfo.columnId = columnInfo.Id) T
//where RANK2<=10 ").Tables[0];
DataTable dt = SqlHelperCatalog.ExecuteDataSet(@"select title,titleURL,titleImg,addTime,columnId from
( select
RANK()OVER(PARTITION BY columnId ORDER BY addTime DESC) AS
RANK2, title,titleImg,titleURL,addTime,columnId from
htmlPara ) T
where RANK2<=10").Tables[0];
if (dt.Rows.Count < 1)
{
return(null);
}
foreach (DataRow row in dt.Rows)
{
htmlInfo hInfo = new htmlInfo();
hInfo.title = (string)row["title"];
hInfo.titleImg = (string)row["titleImg"];
hInfo.titleURL = (string)row["titleURL"];
hInfo.columnId = (string)row["columnId"];//栏目Id
hInfo.addTime = row["addTime"].ToString();
//hInfo.realmNameId = (string)row["realmNameId"];//目录名
hList.Add(hInfo);
}
return(hList);
}
/// <summary>
/// 标题存储成功后返回titleUrl
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public string GetTitleUrl(string userId)
{
object tUrl = SqlHelperCatalog.ExecuteScalar("select top 1 titleURL from htmlPara where userId=@userId order by Id desc",
new SqlParameter("@userId", SqlHelper.ToDBNull(userId)));
return(tUrl.ToString());
}
/// <summary>
/// 获取栏目页网页
/// </summary>
/// <param name="columnId">行业类别</param>
/// <param name="pageIndex">页码</param>
/// <param name="pageSize">每页条数</param>
/// <returns></returns>
public List <htmlPara> GetHtmlList(string columnId, int pageIndex, int pageSize)
{
//分页查询
List <htmlPara> hList = new List <htmlPara>();
DataTable dt = SqlHelperCatalog.ExecuteDataTable(@"select * from
(select *, ROW_NUMBER() OVER(order by addTime desc) AS RowId from htmlPara where columnId=@columnId) as b where b.RowId between @startNum and @endNum",
new SqlParameter("@columnId", columnId),
new SqlParameter("@startNum", (pageIndex - 1) * pageSize + 1),
new SqlParameter("@endNum", pageIndex * pageSize));
if (dt.Rows.Count < 1)
{
return(null);
}
foreach (DataRow row in dt.Rows)
{
htmlPara hPara = new htmlPara();
hPara.Id = (long)row["Id"];
hPara.userId = row["userId"].ToString();
hPara.title = (string)row["title"];
hPara.titleImg = (string)row["titleImg"];
hPara.titleURL = (string)row["titleURL"];
hPara.columnId = (string)row["columnId"]; //栏目Id
string content = (string)row["articlecontent"];
hPara.articlecontent = ReplaceHtmlTag(content, 60); //产品简介
hPara.city = (string)row["city"]; //生产城市
hPara.smallCount = (string)row["smallCount"]; //起订
hPara.companyName = (string)SqlHelper.FromDBNull(row["companyName"]); //公司名字
hPara.ten_qq = (string)SqlHelper.FromDBNull(row["ten_qq"]);
hPara.com_web = (string)SqlHelper.FromDBNull(row["com_web"]); //网址
hPara.addTime = ((DateTime)row["addTime"]).ToString("yyyy-MM-dd");
hList.Add(hPara);
}
return(hList);
}
/// <summary>
/// 渲染详情页，伪静态
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
public string DetailPage(HttpContext context)
{
string columnId = context.Request["cId"];
string Id = context.Request["Id"];
if (string.IsNullOrEmpty(columnId) || string.IsNullOrEmpty(Id))
{
return(SqlHelperCatalog.WriteTemplate("", "404.html"));
}
try
{
htmlPara hInfo = bll.GetHtmlPara(columnId, Id);
string keyword = ""; //关键词
string description = ""; //描述
if (hInfo.title.Length > 6)
{
keyword = hInfo.title + "," + hInfo.title.Substring(0, 2) + "," + hInfo.title.Substring(2, 2) + "," + hInfo.title.Substring(4, 2);
}
else
{
keyword = hInfo.title;
}
description = hInfo.title + "，" + BLL.ReplaceHtmlTag(hInfo.articlecontent, 80)
.Replace("\r\n", "").Replace("<br/>", "").Replace("\r", "").Replace("\n", "").Replace(" ", "") + "...";//产品简介;//产品简介
#region 一篇，下一篇
List <string> BAPage = new List <string>();
List <htmlPara> pList = bll.GetHtmlBAPage(columnId, Id);//上一篇，下一篇
if (pList.Count == 1)
{
BAPage.Add("上一篇：<a href = '" + pList[0].titleURL + "' >" + pList[0].title + "</a> <br />");//上一篇
}
if (pList.Count == 2)
{
BAPage.Add("上一篇：<a href = '" + pList[0].titleURL + "' >" + pList[0].title + "</a> <br />");
BAPage.Add("下一篇：<a href = '" + pList[1].titleURL + "' >" + pList[1].title + "</a> <br />");//下一篇
}
#endregion
var data = new
{
htmlTitle = hInfo.title + "_" + hInfo.companyName,
hInfo,
keyword,
description,
hostUrl,
hostName,
columnName = bll.GetColumns(" where Id=" + columnId)[0].columnName,
columnsList = bll.GetColumns(""), //导航
BAPage,
ProductFloat = bll.GetProFloat(hInfo.userId, "22"), //右侧浮动10条产品
NewsFloat = bll.GetNewsFloat(hInfo.userId, "22") //右侧浮动10条新闻
};
string html = SqlHelperCatalog.WriteTemplate(data, "DetailModel.html");
return(html);
}
catch (Exception ex)
{
return(json.WriteJson(0, ex.ToString(), new { }));
}
}
/// <summary>
/// 将html内容参数存入数据库
/// </summary>
/// <param name="info"></param>
public void AddHtml(htmlPara info)
{
int a = SqlHelperCatalog.ExecuteNonQuery(@"INSERT INTO htmlPara
([title]
,[titleURL]
,[articlecontent]
,[columnId]
,[pinpai]
,[xinghao]
,[price]
,[smallCount]
,[sumCount]
,[unit]
,[city]
,[titleImg]
,[addTime]
,[ten_qq]
,[companyName]
,[com_web]
,[userId]
,[userName])
VALUES
(@title
,@titleURL+CONVERT(varchar(10), IDENT_CURRENT('htmlPara'))+'.html'
,@articlecontent
,@columnId
,@pinpai
,@xinghao
,@price
,@smallCount
,@sumCount
,@unit
,@city
,@titleImg
,@addTime
,@ten_qq
,@companyName
,@com_web
,@userId
,@userName)",
new SqlParameter("@title", SqlHelper.ToDBNull(info.title)),
new SqlParameter("@titleURL", SqlHelper.ToDBNull(info.titleURL)),
new SqlParameter("@articlecontent", SqlHelper.ToDBNull(info.articlecontent)),
new SqlParameter("@columnId", SqlHelper.ToDBNull(info.columnId)),
new SqlParameter("@pinpai", SqlHelper.ToDBNull(info.pinpai)),
new SqlParameter("@xinghao", SqlHelper.ToDBNull(info.xinghao)),
new SqlParameter("@price", SqlHelper.ToDBNull(info.price)),
new SqlParameter("@smallCount", SqlHelper.ToDBNull(info.smallCount)),
new SqlParameter("@sumCount", SqlHelper.ToDBNull(info.sumCount)),
new SqlParameter("@unit", SqlHelper.ToDBNull(info.unit)),
new SqlParameter("@city", SqlHelper.ToDBNull(info.city)),
new SqlParameter("@titleImg", SqlHelper.ToDBNull(info.titleImg)),
new SqlParameter("@addTime", SqlHelper.ToDBNull(info.addTime)),
new SqlParameter("@ten_qq", SqlHelper.ToDBNull(info.ten_qq)),
new SqlParameter("@companyName", SqlHelper.ToDBNull(info.companyName)),
new SqlParameter("@com_web", SqlHelper.ToDBNull(info.com_web)),
new SqlParameter("@userId", SqlHelper.ToDBNull(info.userId)),
new SqlParameter("@userName", SqlHelper.ToDBNull(info.username)));
}
/// <summary>
/// siteMap XML
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
public string SiteMapXML(HttpContext context)
{
context.Response.ContentType = "application/xml;charset=utf-8";
List <htmlPara> hInfo = bll.GetXML();
var data = new
{
hInfo
};
string html = SqlHelperCatalog.WriteTemplate(data, "sitemap.xml");
return(html);
}
/// <summary>
/// 更多新闻页
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
public string MoreNews(HttpContext context)
{
string cId = "22";
var data = new
{
htmlTitle = "新闻栏目",
hostName,
hostUrl,
cId,
newsTitle = GetParaByCId("20", 1, 30)
};
return(SqlHelperCatalog.WriteTemplate(data, "MoreNews.html"));
}
/// <summary>
/// 主页
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
public string MainPage(HttpContext context)
{
var data = new
{
htmlTitle = hostName,
hostName,
hostUrl,
columnsList = bll.GetColumns(""), //导航
productTitle = bll.GetHtmlList("50", "22"), //最新产品，无分类
newsTitle = bll.GetHtmlList("22", 1, 50) //最新新闻
};
return(SqlHelperCatalog.WriteTemplate(data, "MainPage.html"));
}
/// <summary>
/// siteMap Html
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
public string SiteMapHtml(HttpContext context)
{
List <htmlPara> hInfo = bll.GetXML();
var data = new
{
hInfo,
htmlTitle = hostName,
hostName,
hostUrl,
columnsList = bll.GetColumns(""),//导航
};
return(SqlHelperCatalog.WriteTemplate(data, "sitemap.html"));
}
/// <summary>
/// 主页
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
public string MainPage(HttpContext context)
{
var data = new
{
htmlTitle = hostName,
hostName,
hostUrl,
columnsList = bll.GetColumns(""), //导航
lunboTitle = GetParaByCId("20", 1, 6), //轮播标题，推荐新闻
tuijianTitle = GetNoNewsByCId("12", "20"), //推荐产品
productTitle = GetNoNewsByCId("30", "20"), //最新产品，无分类
newsTitle = GetParaByCId("20", 1, 30) //最新新闻
};
return(SqlHelperCatalog.WriteTemplate(data, "MainPage.html"));
}
/// <summary>
/// 获取当前表最大Id
/// </summary>
/// <returns></returns>
public int GetMaxId()
{
object ob = "";
try
{
ob = SqlHelperCatalog.ExecuteScalar("select Id from htmlPara order by Id desc");
if (ob == null)
{
ob = 0;
}
}
catch (Exception ex)
{ return(1); }
return(int.Parse(ob.ToString()));
}
/// <summary>
/// 获取栏目信息
/// </summary>
/// <param name="sqlstr"></param>
/// <returns></returns>
public List <columnInfo> GetColumns(string sqlstr)
{
List <columnInfo> cList = new List <columnInfo>();
DataTable dt = SqlHelperCatalog.ExecuteDataTable("select * from columnInfo " + sqlstr);
if (dt.Rows.Count < 1)
{
return(null);
}
foreach (DataRow row in dt.Rows)
{
columnInfo cInfo = new columnInfo();
cInfo.Id = (int)row["Id"];
cInfo.columnName = (string)row["columnName"];
cList.Add(cInfo);
}
return(cList);
}
/// <summary>
/// XML
/// </summary>
/// <returns></returns>
public List <htmlPara> GetXML()
{
List <htmlPara> hParaList = new List <htmlPara>();
DataTable dt = SqlHelperCatalog.ExecuteDataTable("select top 1000 Id, title,titleURL,addTime from htmlPara order by Id desc");
if (dt.Rows.Count < 1)
{
return(null);
}
foreach (DataRow row in dt.Rows)
{
htmlPara hPara = new htmlPara();
hPara.Id = (long)SqlHelper.FromDBNull(row["Id"]);
hPara.title = (string)SqlHelper.FromDBNull(row["title"]);
hPara.titleURL = (string)SqlHelper.FromDBNull(row["titleURL"]);
hPara.addTime = ((DateTime)SqlHelper.FromDBNull(row["addTime"])).ToString("yyyy-MM-dd");
hParaList.Add(hPara);
}
return(hParaList);
}
/// <summary>
/// 右侧浮动栏，前十条新闻
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public List <htmlPara> GetNewsFloat(string userId)
{
List <htmlPara> hList = new List <htmlPara>();
DataTable dt = SqlHelperCatalog.ExecuteDataTable(@"select top 10 * from htmlPara where userId=1 and columnId=20 order by addTime desc",
new SqlParameter("@userId", userId));
if (dt.Rows.Count < 1)
{
return(null);
}
foreach (DataRow row in dt.Rows)
{
htmlPara hPara = new htmlPara();
hPara.Id = (long)row["Id"];
hPara.title = (string)row["title"];
hPara.titleURL = row["titleURL"].ToString();
hList.Add(hPara);
}
return(hList);
}
/// <summary>
/// 新闻列表页
/// </summary>
/// <param name="context"></param>
/// <param name="cId"></param>
/// <returns></returns>
public string GetNews(HttpContext context)
{
int pageIndex = 1;
if (context.Request["pageIndex"] != null)
{
try
{
pageIndex = int.Parse(context.Request["pageIndex"]);
}
catch
{
}
}
string cId = context.Request["cId"];
int paraTotal = bll.GetPageTotal(cId); //此行业总条数
int pageCount = (int)Math.Ceiling(paraTotal / 20.0); //总页数（每页20条）
object[] pageData = new object[pageCount];
for (int i = 0; i < pageCount; i++)
{
pageData[i] = new { Href = "http://hyzx.100dh.cn/handler/TestHandler.ashx?action=GetNews&cId=" + cId + "&pageIndex=" + (i + 1), Title = i + 1 };
}
var data = new
{
htmlTitle = "新闻栏目",
hostName,
hostUrl,
cId,
columnsList = bll.GetColumns(""), //导航
columnName = bll.GetColumns("where Id=" + cId)[0].columnName,
paraTotal, //总条数
pageIndex, //当前页
pageData, //页码渲染
pageCount, //总页数
newsList = GetParaByCId("20", pageIndex, 20),
productList = GetNoNewsByCId("20", "20")
};
return(SqlHelperCatalog.WriteTemplate(data, "News.html"));
}
/// <summary>
/// 右侧浮动栏，前十条公司产品
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public List <htmlPara> GetProFloat(string userId, string cId)
{
List <htmlPara> hList = new List <htmlPara>();
DataTable dt = SqlHelperCatalog.ExecuteDataTable(@"select top 10 Id,title,titleURL from htmlPara where userId=@userId and columnId!=@columnId order by addTime desc",
new SqlParameter("@userId", userId),
new SqlParameter("@columnId", cId));
if (dt.Rows.Count < 1)
{
return(null);
}
foreach (DataRow row in dt.Rows)
{
htmlPara hPara = new htmlPara();
hPara.Id = (long)SqlHelper.FromDBNull(row["Id"]);
hPara.title = (string)SqlHelper.FromDBNull(row["title"]);
hPara.titleURL = (string)SqlHelper.FromDBNull(row["titleURL"]);
hList.Add(hPara);
}
return(hList);
}
public string DetailPage(HttpContext context)
{
string columnId = context.Request["cId"];
string Id = context.Request["Id"];
if (string.IsNullOrEmpty(columnId) || string.IsNullOrEmpty(Id))
{
return(SqlHelperCatalog.WriteTemplate("", "404.html"));
}
try
{
htmlPara hInfo = bll.GetHtmlPara(columnId, Id);
string keyword = "";//关键词
if (hInfo.title.Length > 6)
{
keyword = hInfo.title + "," + hInfo.title.Substring(0, 2) + "," + hInfo.title.Substring(2, 2) + "," + hInfo.title.Substring(4, 2);
}
else
{
keyword = hInfo.title;
}
var data = new
{
title = hInfo.title + "_" + hInfo.companyName,
hInfo,
keyword,
description = BLL.ReplaceHtmlTag(hInfo.articlecontent, 80),//产品简介
host = hostUrl,
ProductFloat = bll.GetProFloat(hInfo.userId),
NewsFloat = bll.GetNewsFloat(hInfo.userId)
};
string html = SqlHelperCatalog.WriteTemplate(data, "DetailModel.html");
return(html);
}
catch (Exception ex)
{
return(json.WriteJson(0, ex.ToString(), new { }));
}
}
/// <summary>
/// 获取前多少条数据
/// </summary>
/// <param name="count">条数</param>
/// <param name="columnId">栏目Id</param>
/// <returns></returns>
public List <htmlPara> GetHtmlList(string count, string columnId)
{
List <htmlPara> hList = new List <htmlPara>();
DataTable dt = SqlHelperCatalog.ExecuteDataTable(@"select top (CONVERT(int,@count)) Id,title,titleURL,addTime from htmlPara where columnId !='@columnId' order by addTime desc",
new SqlParameter("@columnId", columnId),
new SqlParameter("@count", count));
if (dt.Rows.Count < 1)
{
return(null);
}
foreach (DataRow row in dt.Rows)
{
htmlPara hPara = new htmlPara();
hPara.Id = (long)SqlHelper.FromDBNull(row["Id"]);
hPara.title = (string)SqlHelper.FromDBNull(row["title"]);
hPara.titleURL = (string)SqlHelper.FromDBNull(row["titleURL"]);
hPara.addTime = ((DateTime)SqlHelper.FromDBNull(row["addTime"])).ToString("yyyy-MM-dd");
hList.Add(hPara);
}
return(hList);
}
/// <summary>
/// 获取单条信息
/// </summary>
/// <param name="Id"></param>
/// <param name="columnId"></param>
/// <returns></returns>
public htmlPara GetHtmlPara(string columnId, string Id)
{
htmlPara hPara = new htmlPara();
DataTable dt = SqlHelperCatalog.ExecuteDataTable(@"select * from htmlPara h left join columnInfo c on h.columnId=c.Id where columnId =@columnId and h.Id=@Id",
new SqlParameter("@columnId", columnId),
new SqlParameter("@Id", Id));
if (dt.Rows.Count != 1)
{
return(null);
}
DataRow row = dt.Rows[0];
hPara.Id = (long)SqlHelper.FromDBNull(row["Id"]);
hPara.userId = SqlHelper.FromDBNull(row["userId"]).ToString();
hPara.title = (string)SqlHelper.FromDBNull(row["title"]);
hPara.titleImg = (string)SqlHelper.FromDBNull(row["titleImg"]);
hPara.titleURL = (string)SqlHelper.FromDBNull(row["titleURL"]);
hPara.columnId = (string)SqlHelper.FromDBNull(row["columnId"]);//栏目Id
string content = (string)SqlHelper.FromDBNull(row["articlecontent"]);
//hPara.articlecontent = ReplaceHtmlTag(content, 60);//产品简介
hPara.articlecontent = content;
hPara.city = (string)SqlHelper.FromDBNull(row["city"]); //生产城市
hPara.smallCount = (string)SqlHelper.FromDBNull(row["smallCount"]); //起订
hPara.xinghao = (string)SqlHelper.FromDBNull(row["xinghao"]); //型号
hPara.unit = (string)SqlHelper.FromDBNull(row["unit"]); //单位
hPara.sumCount = (string)SqlHelper.FromDBNull(row["sumCount"]); //供货总量
hPara.price = (string)SqlHelper.FromDBNull(row["price"]); //单价
hPara.pinpai = (string)SqlHelper.FromDBNull(row["pinpai"]); //品牌
hPara.companyName = (string)SqlHelper.FromDBNull(row["companyName"]); //公司名字
hPara.ten_qq = (string)SqlHelper.FromDBNull(row["ten_qq"]);
hPara.com_web = (string)SqlHelper.FromDBNull(row["com_web"]); //网址
hPara.addTime = ((DateTime)SqlHelper.FromDBNull(row["addTime"])).ToString("yyyy-MM-dd");
hPara.columnName = (string)SqlHelper.FromDBNull(row["columnName"]); //栏目名
hPara.username = (string)SqlHelper.FromDBNull(row["username"]); //用户名
return(hPara);
}
/// <summary>
/// 查询上一条下一条
/// </summary>
/// <param name="columnId"></param>
/// <param name="Id"></param>
/// <returns></returns>
public List <htmlPara> GetHtmlBAPage(string columnId, string Id)
{
List <htmlPara> hList = new List <htmlPara>();
DataTable dt = SqlHelperCatalog.ExecuteDataTable(@"select top 1 -1 as [Sort],Id,title,columnId,titleURL from (select top 1 Id,title,columnId,titleURL from htmlPara where columnId=@columnId and Id<@Id order by Id desc) as tab_up
union select top 1 1 as [Sort],Id,title,columnId,titleURL from (select top 1 Id,title,columnId,titleURL from htmlPara where columnId=@columnId and Id>@Id order by Id) as tab_up",
new SqlParameter("@columnId", columnId),
new SqlParameter("@Id", Id));
if (dt.Rows.Count < 1)
{
return(null);
}
foreach (DataRow row in dt.Rows)
{
htmlPara hPara = new htmlPara();
hPara.Id = (long)row["Id"];
hPara.title = (string)row["title"];
hPara.titleURL = row["titleURL"].ToString();
hPara.columnId = (string)row["columnId"];
hList.Add(hPara);
}
return(hList);
}
public string ModuleHtml(HttpContext context)
{
//需要做一个时间，每隔多长时间才允许访问一次
string keyValue = NetHelper.GetMD5("liu" + "100dh888");
string url = "";
string key = context.Request["key"];
if (key != keyValue)
{
return(json.WriteJson(0, "key值错误", new { }));
}
string username = context.Request["username"];
if (string.IsNullOrEmpty(username))
{
return(json.WriteJson(0, "用户名不能为空", new { }));
}
try
{
htmlPara hInfo = new htmlPara();
hInfo.userId = bll.GetUserId(username);//用户名
hInfo.title = context.Request["title"];
string cid = context.Request["catid"];
if (string.IsNullOrEmpty(cid))
{
return(json.WriteJson(0, "行业或栏目不能为空", new { }));
}
hInfo.columnId = cid;//行业id，行业新闻id=20
string content = context.Request["content"];
if (string.IsNullOrEmpty(content) || content.Length < 500)
{
return(json.WriteJson(0, "文章不能少于500字，请丰富文章内容", new { }));
}
hInfo.articlecontent = content;
//hInfo.articlecontent = HttpUtility.UrlDecode(jo["content"].ToString(), Encoding.UTF8);//内容,UrlDecode解码
//命名规则：ip/目录/用户名/show_行业id+(五位数id)
long htmlId = (bll.GetMaxId() + 1);
hInfo.Id = htmlId;
string showName = "show_" + cid + "_" + htmlId + ".html";
url = host + username + "/" + showName;
hInfo.titleURL = url;
//hInfo.titleURL = string.Format("handler/TestHandler.ashx?action=DetailPage&cId={0}&Id={1}", cid, htmlId);
//url = host + hInfo.titleURL;
hInfo.pinpai = context.Request["pinpai"];
hInfo.xinghao = context.Request["xinghao"];
hInfo.price = context.Request["price"];
hInfo.smallCount = context.Request["qiding"];
hInfo.sumCount = context.Request["gonghuo"];
hInfo.unit = context.Request["unit"];
hInfo.city = context.Request["city"];
hInfo.titleImg = context.Request["thumb"];
hInfo.addTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
hInfo.username = username;
//公司 / 会员信息
cmUserInfo uInfo = bll.GetUser(string.Format("where username='******'", username));
hInfo.companyName = uInfo.companyName;
hInfo.com_web = uInfo.com_web;
//hInfo.realmNameId = "1";//发到哪个站
bll.AddHtml(hInfo); //存入数据库
string keyword = ""; //关键词
string description = ""; //描述
if (hInfo.title.Length > 6)
{
keyword = hInfo.title + "," + hInfo.title.Substring(0, 2) + "," + hInfo.title.Substring(2, 2) + "," + hInfo.title.Substring(4, 2);
}
else
{
keyword = hInfo.title;
}
description = BLL.ReplaceHtmlTag(hInfo.articlecontent, 80);//产品简介
var data = new
{
title = hInfo.title + "_" + hInfo.companyName,
hInfo,
keyword,
description,
host,
columnName = bll.GetColumns(" where Id=" + cid)[0].columnName,
ProductFloat = bll.GetProFloat(hInfo.userId),
NewsFloat = bll.GetNewsFloat(hInfo.userId)
};
string html = SqlHelperCatalog.WriteTemplate(data, "DetailModel.html");
WriteFile(html, showName, username);//写模板
}
catch (Exception ex)
{
return(json.WriteJson(0, ex.ToString(), new { }));
}
return(json.WriteJson(1, "发布成功", new { url, username }));
}
/// <summary>
/// 产品列表页
/// </summary>
/// <param name="context"></param>
/// <param name="cId"></param>
/// <returns></returns>
public string GetProduct(HttpContext context)
{
int pageIndex = 1;
if (context.Request["pageIndex"] != null)
{
try
{
pageIndex = int.Parse(context.Request["pageIndex"]);
}
catch
{
}
}
string cId = context.Request["cId"];
int paraTotal = bll.GetPageTotal(cId); //此行业总条数
int pageCount = (int)Math.Ceiling(paraTotal / 20.0); //总页数（每页20条）
List <object> pageData = new List <object>();
if (pageCount > 8)
{
if (pageIndex > 4)
{
int maxIndex = pageIndex + 4;
if (maxIndex > pageCount)
{
maxIndex = pageCount;
}
for (int i = pageIndex - 5; i < maxIndex; i++)
{
pageData.Add(new { Href = "list-" + cId + "-" + (i + 1), Title = i + 1 });
}
}
else
{
for (int i = 0; i < 9; i++)
{
pageData.Add(new { Href = "list-" + cId + "-" + (i + 1), Title = i + 1 });
}
}
}
else
{
for (int i = 0; i < pageCount; i++)
{
pageData.Add(new { Href = "list-" + cId + "-" + (i + 1), Title = i + 1 });
}
}
string columnName = "";
List <columnInfo> columnsList = bll.GetColumns("");//导航
foreach (columnInfo c in columnsList)
{
if (c.Id.ToString() == cId)
{
columnName = c.columnName;
}
}
var data = new
{
htmlTitle = columnName + "_" + hostName,
hostName,
hostUrl,
cId,
columnsList, //导航
columnName, //栏目名称
paraTotal, //总条数
pageIndex, //当前页
pageData, //页码渲染
pageCount, //总页数
productList = bll.GetHtmlList(cId, pageIndex, 20),
newsList = bll.GetHtmlList("22", 1, 20), //右侧浮动栏新闻20条
productListNocId = bll.GetHtmlList("20", "22") //右侧浮动栏产品20条(非新闻，cId!=22)
};
return(SqlHelperCatalog.WriteTemplate(data, "Product.html"));
}
public int GetPageTotal(string columnId)
{
return((int)SqlHelperCatalog.ExecuteScalar("select count(*) from htmlPara where columnId=@columnId",
new SqlParameter("@columnId", columnId)));
}
