/// <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="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 <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>
/// 右侧浮动栏，前十条新闻
/// </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>
/// 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> 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);
}
/// <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);
}
