第 1 行: 'PublishArticle' 附近有语法异常。请各位帮小弟看看,多谢各位了
第 1 行: 'PublishArticle' 附近有语法错误。请各位帮小弟看看,谢谢各位了
如下错误提示:,这个是分页取数据,但是出现错误,我实在看不出,请大家帮帮我,谢谢了
下面是我部分代码:
web层代码:
int RecordCount = 0;
int PageSize = 10;//每页显示的条数
int PageIndex = 1;//当前页数
public DataTable GetArticle(int userId)
{
Article articleBll = new Article();
string strUrl = string.Format("BlogDefault.aspx?userId={0}&", userId);
DataTable dt = articleBll.StructureArticleListDefault(userId, PageSize, PageIndex, out RecordCount);
return dt;
}
BLL代码:
/// <summary>
/// 构造首页博文列表
/// </summary>
/// <param name="userId"></param>
/// <param name="pageSize"></param>
/// <param name="pageIndex"></param>
/// <param name="recordCount"></param>
/// <returns></returns>
public DataTable StructureArticleListDefault(int userId,int pageSize,int pageIndex,out int recordCount)
{
string strWhere = "PublishArticle.IsShow = 1 and PublishArticle.ArticleFrom < 2 and ";
strWhere += "PublishArticle.UserId = "+userId;
DataTable dt = dal.GetDefaultArticleData(pageSize, pageIndex, out recordCount,strWhere);
return dt;
}
DAL代码:
/// <summary>
/// 分页获取首页博文数据表
/// </summary>
/// <param name="PageSize"></param>
/// <param name="PageIndex"></param>
/// <param name="RecordCount"></param>
/// <param name="strWhere"></param>
public DataTable GetDefaultArticleData(int PageSize, int PageIndex, out int RecordCount,string strWhere)
{
string tabName = "Tab_Article as Article inner join Tab_PublishArticle as PublishArticle on Article.ArticleId = PublishArticle.ArticleId";
string fieldName = "PublishArticle.RecordId,Article.PublisherId, PublishArticle.ArticleId,";
fieldName += "PublishArticle.ArticleFrom,";
fieldName += "PublishArticle.ReadCount, PublishArticle.CollectionTime,";
fieldName += "Article.ArticleTitle, Article.ArticleContent, Article.IsContainPic,";
fieldName += "Article.ArticleTag, Article.ArticleTypeName, Article.SetComment,Article.SetArticleReprint";
string fieldSort = "PublishArticle.CollectionTime";
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@tblName", SqlDbType.NVarChar, 300),
new SqlParameter("@fldName", SqlDbType.NVarChar, 800),
new SqlParameter("@pageSize", SqlDbType.Int),
如下错误提示:,这个是分页取数据,但是出现错误,我实在看不出,请大家帮帮我,谢谢了
下面是我部分代码:
web层代码:
int RecordCount = 0;
int PageSize = 10;//每页显示的条数
int PageIndex = 1;//当前页数
public DataTable GetArticle(int userId)
{
Article articleBll = new Article();
string strUrl = string.Format("BlogDefault.aspx?userId={0}&", userId);
DataTable dt = articleBll.StructureArticleListDefault(userId, PageSize, PageIndex, out RecordCount);
return dt;
}
BLL代码:
/// <summary>
/// 构造首页博文列表
/// </summary>
/// <param name="userId"></param>
/// <param name="pageSize"></param>
/// <param name="pageIndex"></param>
/// <param name="recordCount"></param>
/// <returns></returns>
public DataTable StructureArticleListDefault(int userId,int pageSize,int pageIndex,out int recordCount)
{
string strWhere = "PublishArticle.IsShow = 1 and PublishArticle.ArticleFrom < 2 and ";
strWhere += "PublishArticle.UserId = "+userId;
DataTable dt = dal.GetDefaultArticleData(pageSize, pageIndex, out recordCount,strWhere);
return dt;
}
DAL代码:
/// <summary>
/// 分页获取首页博文数据表
/// </summary>
/// <param name="PageSize"></param>
/// <param name="PageIndex"></param>
/// <param name="RecordCount"></param>
/// <param name="strWhere"></param>
public DataTable GetDefaultArticleData(int PageSize, int PageIndex, out int RecordCount,string strWhere)
{
string tabName = "Tab_Article as Article inner join Tab_PublishArticle as PublishArticle on Article.ArticleId = PublishArticle.ArticleId";
string fieldName = "PublishArticle.RecordId,Article.PublisherId, PublishArticle.ArticleId,";
fieldName += "PublishArticle.ArticleFrom,";
fieldName += "PublishArticle.ReadCount, PublishArticle.CollectionTime,";
fieldName += "Article.ArticleTitle, Article.ArticleContent, Article.IsContainPic,";
fieldName += "Article.ArticleTag, Article.ArticleTypeName, Article.SetComment,Article.SetArticleReprint";
string fieldSort = "PublishArticle.CollectionTime";
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@tblName", SqlDbType.NVarChar, 300),
new SqlParameter("@fldName", SqlDbType.NVarChar, 800),
new SqlParameter("@pageSize", SqlDbType.Int),