 |
|
| |
|
<%
SQLTxt = "SELECT * FROM orc_webdata_cy WHERE nodeId='products|succade' AND WEB='" + WEB + "' ORDER BY SortDate DESC";
array = Data.Query(SQLTxt,1,3);
if (array != null)
{
Iterator iterator = array.iterator();
Wdata wdata = null;
try
{
while (iterator.hasNext())
{
wdata = (Wdata)iterator.next();
if (wdata != null)
{
String dID = wdata.WEB_ID;
String dSubject = wdata.WEB_Subject;
String dPutDate = wdata.WEB_Putdate;
String dContent = wdata.WEB_Content ;
String dimg = wdata.WEB_img;
int dVisMan = wdata.WEB_VisMan;
String dOrigin = wdata.WEB_Origin;
String dAuthor = wdata.WEB_Author;
dSubject = CHStr.NotHtml(dSubject); //去掉HTML
dContent = CHStr.NotHtml(dContent); //去掉HTML
if (dSubject.length()>=42) dSubject = dSubject.substring(0,40) + "..."; //限制长度
if (dContent.length()>=102) dContent = dContent.substring(0,100) + "..."; //限制长度
/>
<%
} // if (wdata != null)
} //while
}catch(Exception e) {
//..
}
array.clear();
}
/>
|
<%
SQLTxt = "SELECT * FROM orc_webdata_cy WHERE nodeId='products|jam' AND WEB='" + WEB + "' ORDER BY SortDate DESC";
array = Data.Query(SQLTxt,1,3);
if (array != null)
{
Iterator iterator = array.iterator();
Wdata wdata = null;
try
{
while (iterator.hasNext())
{
wdata = (Wdata)iterator.next();
if (wdata != null)
{
String dID = wdata.WEB_ID;
String dSubject = wdata.WEB_Subject;
String dPutDate = wdata.WEB_Putdate;
String dContent = wdata.WEB_Content ;
String dimg = wdata.WEB_img;
int dVisMan = wdata.WEB_VisMan;
String dOrigin = wdata.WEB_Origin;
String dAuthor = wdata.WEB_Author;
dSubject = CHStr.NotHtml(dSubject); //去掉HTML
dContent = CHStr.NotHtml(dContent); //去掉HTML
if (dSubject.length()>=42) dSubject = dSubject.substring(0,40) + "..."; //限制长度
if (dContent.length()>=102) dContent = dContent.substring(0,100) + "..."; //限制长度
/>
<%
} // if (wdata != null)
} //while
}catch(Exception e) {
//..
}
array.clear();
}
/>
|
|
|
|
<%
SQLTxt = "SELECT * FROM orc_webdata_cy WHERE nodeId='products|soup and wine material' AND WEB='" + WEB + "' ORDER BY SortDate DESC";
array = Data.Query(SQLTxt,1,3);
if (array != null)
{
Iterator iterator = array.iterator();
Wdata wdata = null;
try
{
while (iterator.hasNext())
{
wdata = (Wdata)iterator.next();
if (wdata != null)
{
String dID = wdata.WEB_ID;
String dSubject = wdata.WEB_Subject;
String dPutDate = wdata.WEB_Putdate;
String dContent = wdata.WEB_Content ;
String dimg = wdata.WEB_img;
int dVisMan = wdata.WEB_VisMan;
String dOrigin = wdata.WEB_Origin;
String dAuthor = wdata.WEB_Author;
dSubject = CHStr.NotHtml(dSubject); //去掉HTML
dContent = CHStr.NotHtml(dContent); //去掉HTML
if (dSubject.length()>=42) dSubject = dSubject.substring(0,40) + "..."; //限制长度
if (dContent.length()>=102) dContent = dContent.substring(0,100) + "..."; //限制长度
/>
<%
} // if (wdata != null)
} //while
}catch(Exception e) {
//..
}
array.clear();
}
/>
|
<%
SQLTxt = "SELECT * FROM orc_webdata_cy WHERE nodeId='products|medicinal herbs sold' AND WEB='" + WEB + "' ORDER BY SortDate DESC";
array = Data.Query(SQLTxt,1,3);
if (array != null)
{
Iterator iterator = array.iterator();
Wdata wdata = null;
try
{
while (iterator.hasNext())
{
wdata = (Wdata)iterator.next();
if (wdata != null)
{
String dID = wdata.WEB_ID;
String dSubject = wdata.WEB_Subject;
String dPutDate = wdata.WEB_Putdate;
String dContent = wdata.WEB_Content ;
String dimg = wdata.WEB_img;
int dVisMan = wdata.WEB_VisMan;
String dOrigin = wdata.WEB_Origin;
String dAuthor = wdata.WEB_Author;
dSubject = CHStr.NotHtml(dSubject); //去掉HTML
dContent = CHStr.NotHtml(dContent); //去掉HTML
if (dSubject.length()>=42) dSubject = dSubject.substring(0,40) + "..."; //限制长度
if (dContent.length()>=102) dContent = dContent.substring(0,100) + "..."; //限制长度
/>
<%
} // if (wdata != null)
} //while
}catch(Exception e) {
//..
}
array.clear();
}
/>
|
|
|
|
<%
SQLTxt = "SELECT * FROM orc_webdata_cy WHERE nodeId='products|agricultural product' AND WEB='" + WEB + "' ORDER BY SortDate DESC";
array = Data.Query(SQLTxt,1,3);
if (array != null)
{
Iterator iterator = array.iterator();
Wdata wdata = null;
try
{
while (iterator.hasNext())
{
wdata = (Wdata)iterator.next();
if (wdata != null)
{
String dID = wdata.WEB_ID;
String dSubject = wdata.WEB_Subject;
String dPutDate = wdata.WEB_Putdate;
String dContent = wdata.WEB_Content ;
String dimg = wdata.WEB_img;
int dVisMan = wdata.WEB_VisMan;
String dOrigin = wdata.WEB_Origin;
String dAuthor = wdata.WEB_Author;
dSubject = CHStr.NotHtml(dSubject); //去掉HTML
dContent = CHStr.NotHtml(dContent); //去掉HTML
if (dSubject.length()>=42) dSubject = dSubject.substring(0,40) + "..."; //限制长度
if (dContent.length()>=102) dContent = dContent.substring(0,100) + "..."; //限制长度
/>
<%
} // if (wdata != null)
} //while
}catch(Exception e) {
//..
}
array.clear();
}
/>
|
<%
SQLTxt = "SELECT * FROM orc_webdata_cy WHERE nodeId='products|agency product' AND WEB='" + WEB + "' ORDER BY SortDate DESC";
array = Data.Query(SQLTxt,1,3);
if (array != null)
{
Iterator iterator = array.iterator();
Wdata wdata = null;
try
{
while (iterator.hasNext())
{
wdata = (Wdata)iterator.next();
if (wdata != null)
{
String dID = wdata.WEB_ID;
String dSubject = wdata.WEB_Subject;
String dPutDate = wdata.WEB_Putdate;
String dContent = wdata.WEB_Content ;
String dimg = wdata.WEB_img;
int dVisMan = wdata.WEB_VisMan;
String dOrigin = wdata.WEB_Origin;
String dAuthor = wdata.WEB_Author;
dSubject = CHStr.NotHtml(dSubject); //去掉HTML
dContent = CHStr.NotHtml(dContent); //去掉HTML
if (dSubject.length()>=42) dSubject = dSubject.substring(0,40) + "..."; //限制长度
if (dContent.length()>=102) dContent = dContent.substring(0,100) + "..."; //限制长度
/>
<%
} // if (wdata != null)
} //while
}catch(Exception e) {
//..
}
array.clear();
}
/>
|
|
|
