/// <summary>
/// 产品分类
/// </summary>
/// <returns></returns>
public object GetProductType()
{
string sql = $@"
SELECT t3.nodeid,t3.nodename
FROM dbo.PE_Nodes t3
WHERE CAST(t3.parentdir AS nvarchar) = '/Article/Products/xccp/'
AND t3.showonmenu = 1 ORDER BY t3.nodeid
";
return(DbHelper_SQL2.Query(sql).Tables[0].Select().Select(x => new
{
NodeName = x[1],
NodeId = x[0]
}).ToList());
}
/// <summary>
/// 邢钢网站产品信息
/// </summary>
/// <param name="type"></param>
/// <param name="keyword"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public object GetProduct(string type, string keyword, int pageIndex, int pageSize)
{
string sqlwhere = string.Empty;
if (!string.IsNullOrEmpty(type))
{
sqlwhere += $"AND t3.nodeid = {type}";
}
string sql = $@"
SELECT t2.nodeid AS 'typeid', t2.nodename AS 'typeName', t1.Pmodel AS 'xh', t1.Specification AS 'gg', t1.Producer AS 'zxbz'
, t1.MainExplanation AS 'syfw', t1.PexhibitionPic AS 'tpdz', t1.content AS 'cpjs'
FROM PE_CommonModel t
LEFT JOIN PE_U_Exhibition t1 ON t.itemId = t1.Id
LEFT JOIN PE_Nodes t2 ON t.nodeid = t2.nodeid
WHERE t.tableName = 'PE_U_Exhibition'
AND t.nodeid IN (
SELECT t3.nodeid
FROM dbo.PE_Nodes t3
WHERE CAST(t3.parentdir AS nvarchar) = '/Article/Products/xccp/'
AND t3.showonmenu = 1 {sqlwhere}
)
ORDER BY t.nodeid
";
var websiturl = string.Empty;
try
{
var fr = new Dal_TS_DIC().GetDis("XG_WEB_SITE_IMG_URL").Tables[0].Select().FirstOrDefault();
websiturl = fr?["c_detailcode"]?.ToString() ?? string.Empty;
}
catch (Exception ex)
{
}
websiturl = string.Concat(websiturl, "/UploadFiles/");
var products = DbHelper_SQL2.Query(sql).Tables[0].Select().Select((x) =>
{
var dz = x[6]?.ToString();
dz = dz.Substring(dz.IndexOf('|') + 1);
dz = string.Concat(websiturl, dz);
var fw = x[5]?.ToString().Replace("<p>", "").Replace("</p>", "").Replace("\r\n", "");
var js = x[7]?.ToString().Replace("<p>", "").Replace("</p>", "").Replace("\r\n", "");
return(new
{
// 类型id
typeid = x[0],
// 类型名称
typename = x[1],
// 型号
xh = x[2],
// 规格
gg = x[3],
// 执行标准
zxbz = x[4],
// 使用范围
stfw = fw,
// 图片地址
tpdz = dz,
// 产品介绍
cpjs = js
});
}).ToList();
return(products);
}
