/// <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); }