var rows_ = String.IsNullOrEmpty(rows) ? 20 : Convert.ToInt32(rows);
var page_ = String.IsNullOrEmpty(page) ? 1 : Convert.ToInt32(page); if (!String.IsNullOrEmpty(rows))
{ rows_ = Convert.ToInt32(rows); }
if (!String.IsNullOrEmpty(page))
{ page_ = Convert.ToInt32(page); }
var strSql = new StringBuilder();
strSql.Append("select @total=count(1) from Archives where 1=1 " + strWhere + ';');
strSql.Append("select * from (");
strSql.Append(" select *, ROW_NUMBER() over(");
if (!string.IsNullOrEmpty(strOrder))
{
strSql.Append(" order by " + strOrder);
}
else
{
strSql.Append(" order by autoid");
}
strSql.Append(" ) row");
strSql.Append(" from Archives");
strSql.Append(" where 1=1 ");
strSql.Append(strWhere);
strSql.AppendFormat(") t where row between {0} and {1}", rows_ * (page_ - 1) + 1, rows_ * (page_));
SqlParameter[] parameters = { DbHelperSQL.CreateOutParam("@total", SqlDbType.Int, 0) };
var ds = DbHelperSQL.Query(strSql.ToString(), parameters);
total = Convert.ToInt32(parameters[0].Value);
return (from DataRow t in ds.Tables[0].Rows select DataRowToModel(t, true)).ToList();视图的名字是View_Archives,这样该如何办啊?数据库easyuidatagridAsp.net
var page_ = String.IsNullOrEmpty(page) ? 1 : Convert.ToInt32(page); if (!String.IsNullOrEmpty(rows))
{ rows_ = Convert.ToInt32(rows); }
if (!String.IsNullOrEmpty(page))
{ page_ = Convert.ToInt32(page); }
var strSql = new StringBuilder();
strSql.Append("select @total=count(1) from Archives where 1=1 " + strWhere + ';');
strSql.Append("select * from (");
strSql.Append(" select *, ROW_NUMBER() over(");
if (!string.IsNullOrEmpty(strOrder))
{
strSql.Append(" order by " + strOrder);
}
else
{
strSql.Append(" order by autoid");
}
strSql.Append(" ) row");
strSql.Append(" from Archives");
strSql.Append(" where 1=1 ");
strSql.Append(strWhere);
strSql.AppendFormat(") t where row between {0} and {1}", rows_ * (page_ - 1) + 1, rows_ * (page_));
SqlParameter[] parameters = { DbHelperSQL.CreateOutParam("@total", SqlDbType.Int, 0) };
var ds = DbHelperSQL.Query(strSql.ToString(), parameters);
total = Convert.ToInt32(parameters[0].Value);
return (from DataRow t in ds.Tables[0].Rows select DataRowToModel(t, true)).ToList();视图的名字是View_Archives,这样该如何办啊?数据库easyuidatagridAsp.net
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货