62,041
社区成员
发帖
与我相关
我的任务
分享
// strSql = string.Format(@"select news_id,news_title,cre_date,cate_id,upd_date from
// (select news_id,news_title,cre_date,cate_id,upd_date from vw_news where cate_id in ({0}) order by is_top desc,PUBLISH_DATE desc)
// where rownum <={1}", JoinArray(cate_type_id),rownum);
strSql = @"select news_id,news_title,cre_date,cate_id,upd_date from
(select news_id,news_title,cre_date,cate_id,upd_date from vw_news where cate_id in (:cate_type_ids) order by is_top desc,PUBLISH_DATE desc)
where rownum <=:rownumber";
OracleParameter[] prams = { new OracleParameter(":cate_type_ids", JoinArray(cate_type_id)),
new OracleParameter(":rownumber",rownum)};
List<OracleParameter> parList = new List<OracleParameter>();
if (cate_type_id.Length > 0)
{
strSql = @"select news_id,news_title,cre_date,cate_id,upd_date from
(select news_id,news_title,cre_date,cate_id,upd_date from vw_news where cate_id in (";
StringBuilder sbtemp = new StringBuilder();
for (int i = 0; i < cate_type_id.Length; i++)
{
sbtemp.Append(":cate_type_id" + i + ",");
}
string str = sbtemp.ToString().Substring(0, sbtemp.ToString().Length - 1);
strSql += str;
strSql += ") order by is_top desc,PUBLISH_DATE desc) where rownum <=:rownumber";
OracleParameter prs = null;
for (int i = 0; i < cate_type_id.Length; i++)
{
prs = new OracleParameter(":cate_type_id"+i,cate_type_id[i]);
parList.Add(prs);
}
prs = new OracleParameter(":rownumber", rownum);
parList.Add(prs);
}
strSql = @"select news_id,news_title,cre_date,cate_id,upd_date from
(select news_id,news_title,cre_date,cate_id,upd_date from vw_news where cate_id in (:col1,:col2) order by is_top desc,PUBLISH_DATE desc)
where rownum <=:rownumber";