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