public static StringWriter ShowListLabelNoPageIn(params string[] strString) { StringWriter output = new StringWriter(); try { string LableName = ""; XsltArgumentList argsList = new XsltArgumentList(); argsList.AddExtensionObject("WP:BaseClass", new BaseClass()); LableName = strString[0].Split('=')[1]; string XMLPath = BaseClass.GetListLabel() + LableName + ".config"; string LableSqlString = XMLExplainer.GetXMLValue("root", "LabelSqlString", XMLPath); string LabelSqlCount = XMLExplainer.GetXMLValue("root", "LabelSqlCount", XMLPath); string XsltString = XMLExplainer.GetXMLValue("root", "LabelTemplate", XMLPath); for (int i = 1; i < strString.Length; i++) { string strObject = strString[i]; string[] strObjects = strObject.Split('='); LableSqlString = LableSqlString.Replace("@" + strObjects[0], strObjects[1]); argsList.AddParam(strObjects[0], "", strObjects[1]); } DataTable DT = XMLExplainer.GetXMLValues("attributes", XMLPath); for (int i = 0; i < DT.Rows.Count; i++) { LableSqlString = LableSqlString.Replace("@" + DT.Rows[i]["name"].ToString(), DT.Rows[i]["default"].ToString()); string tempstring = (string)argsList.GetParam(DT.Rows[i]["name"].ToString(), ""); try { argsList.AddParam(DT.Rows[i]["name"].ToString(), "", DT.Rows[i]["default"].ToString()); } catch { continue; } } XDocument source = new XDocument(); XDocument newTree = new XDocument(); using (XmlWriter writer = newTree.CreateWriter()) { XslCompiledTransform xslt = new XslCompiledTransform(); xslt.Load(XmlReader.Create(new StringReader(XsltString))); DataTable DTT = PersistenceLayer.Query.ProcessSql(LableSqlString, Names.DBName); DataSet DS = new DataSet(); DS.Tables.Add(DTT); string XmlStr = "<?xml version=\"1.0\" encoding=\"utf-8\" ?>"; XmlStr = XmlStr + DS.GetXml().ToString(); XmlDocument XmlDoc = new XmlDocument(); XmlDoc.LoadXml(XmlStr); XPathNavigator navgator = XmlDoc.CreateNavigator(); xslt.Transform(navgator, argsList, output); return(output); } } catch (Exception ex) { output.Write(ex.Message.ToString()); return(output); } }
/// <summary> /// 形成新闻列表HTML /// </summary> /// <param name="NodeId"></param> /// <param name="outputQty"></param> /// <param name="TitleLength"></param> /// <returns></returns> public static StringWriter GetContentList(string NodeId, string outputQty, string TitleLength, bool outputType, string DateTimeFormat, string OrderString, string UpDown) { string strSql = "SELECT WEB_TB_COMMONMODEL.GENERALID,WEB_TB_COMMONMODEL.TITLE FROM WEB_TB_COMMONMODEL ORDER BY " + OrderString + " " + UpDown; strSql = "SELECT * FROM (SELECT ROWNUM AS RN,T1.* FROM (" + strSql + ") T1 WHERE ROWNUM <= " + outputType + ") WHERE RN >= 0"; DataTable DT = PersistenceLayer.Query.ProcessSql(strSql, Names.DBName); string xslPath = BaseClass.GetListLabel() + "通用信息列表.config"; XsltArgumentList argsList = new XsltArgumentList(); argsList.AddParam("titleLength", "", TitleLength); StringWriter str = new StringWriter(); str = LabelManage.GetOutPrint(DT, xslPath, argsList); return(str); }
public static StringWriter GetPicNewsShow(string NodeId, string outputType, int titleLength, string imageWidth, string imageHeight, string OrderString, string UpDown) { string strsql = "SELECT WEB_TB_COMMONMODEL.GENERALID,WEB_TB_COMMONMODEL.DEFAULTPICURL,WEB_TB_COMMONMODEL.TITLE" + " FROM WEB_TB_COMMONMODEL WHERE DEFAULTPICURL <> 'NULL' AND WEB_TB_COMMONMODEL.STATUS=99 AND NODEID =" + NodeId + " ORDER BY " + OrderString + " " + UpDown; strsql = "SELECT * FROM (SELECT ROWNUM AS RN,T1.* FROM (" + strsql + ") T1 WHERE ROWNUM <= " + outputType + ") WHERE RN >= 0"; DataTable DT = PersistenceLayer.Query.ProcessSql(strsql, Names.DBName); string xslPath = BaseClass.GetListLabel() + "WEB_首页新闻图片列表.config"; XsltArgumentList argsList = new XsltArgumentList(); argsList.AddParam("titleLength", "", titleLength); argsList.AddParam("focusWidth", "", imageWidth); argsList.AddParam("focusHeight", "", imageHeight); StringWriter str = new StringWriter(); str = LabelManage.GetOutPrint(DT, xslPath, argsList); return(str); }
public static StringWriter GetSqPicShow(string NodeId, string outputType, int titleLength, string imageWidth, string imageHeight, string OrderString, string UpDown, string orgCode) { try { string strsql = "SELECT ID,ORGCODE,COM_TB_SQXW_0001.PICURL,TITLE" + " FROM COM_TB_SQXW_0001 WHERE PICURL <> 'NULL' AND COM_TB_SQXW_0001.STATUS=1 and COM_TB_SQXW_0001.ORGCODE=" + orgCode + " ORDER BY " + OrderString + " " + UpDown; strsql = "SELECT * FROM (SELECT ROWNUM AS RN,T1.* FROM (" + strsql + ") T1 WHERE ROWNUM <= " + outputType + ") WHERE RN >= 0"; DataTable DT = PersistenceLayer.Query.ProcessSql(strsql, Names.DBName); string xslPath = BaseClass.GetListLabel() + "WEB_首页图片新闻滚动列表.config"; XsltArgumentList argsList = new XsltArgumentList(); argsList.AddParam("titleLength", "", titleLength); argsList.AddParam("focusWidth", "", imageWidth); argsList.AddParam("focusHeight", "", imageHeight); StringWriter str = new StringWriter(); str = LabelManage.GetOutPrint(DT, xslPath, argsList); return(str); } catch (Exception ex) { StringWriter str1 = new StringWriter(); return(str1); } }
/// <summary> /// 图片新闻FLASH展示 /// </summary> /// <param name="NodeID"></param> /// <param name="outputType"></param> /// <param name="titleLength"></param> /// <param name="contentLength"></param> /// <param name="imageClass"></param> /// <param name="titleClass"></param> /// <param name="imageWidth"></param> /// <param name="imageHeight"></param> /// <param name="OrderString"></param> /// <param name="UpDown"></param> /// <returns>AddLinks</returns> public static StringWriter GetPicShow(string NodeId, string outputType, int titleLength, string imageWidth, string imageHeight, string OrderString, string UpDown) { try { string strsql = "SELECT T_PRODUCT.ID,T_PRODUCTPIC.PICURL,T_PRODUCT.PRONAME" + " FROM T_PRODUCT,T_PRODUCTPIC WHERE PICURL <> 'NULL' AND T_PRODUCT.PROID=T_PRODUCTPIC.PROID AND T_PRODUCTPIC.ISTOP=1 ORDER BY " + OrderString + " " + UpDown; strsql = "SELECT * FROM (SELECT ROWNUM AS RN,T1.* FROM (" + strsql + ") T1 WHERE ROWNUM <= " + outputType + ") WHERE RN >= 0"; DataTable DT = PersistenceLayer.Query.ProcessSql(strsql, Names.DBName); string xslPath = BaseClass.GetListLabel() + "WEB_首页图片新闻滚动列表.config"; XsltArgumentList argsList = new XsltArgumentList(); argsList.AddParam("titleLength", "", titleLength); argsList.AddParam("focusWidth", "", imageWidth); argsList.AddParam("focusHeight", "", imageHeight); StringWriter str = new StringWriter(); str = LabelManage.GetOutPrint(DT, xslPath, argsList); return(str); } catch (Exception ex) { StringWriter str1 = new StringWriter(); return(str1); } }