示例#1
0
        /// <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);
        }
示例#2
0
        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);
        }
示例#3
0
 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);
     }
 }
示例#4
0
        /// <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);
            }
        }