aspx
显示
CodeBehind 命名空间 public partial class xxx : Web.UI.ManagePage protected int totalCount;//总记录数 protected void Page_Load(object sender, EventArgs e) this.keywords = Utils..GetQueryString("keywords");//获取查询条件 if (!Page.IsPostBack) RptBind("根据keywords整合的查询语句", "排序字段 asc/desc"); } } private void RptBind(string _strWhere, string _orderby) private int GetPageSize(int _default_size) protected void lbtnSearch_Click(object sender, EventArgs e) protected void txtPageNum_TextChanged(object sender, EventArgs e) } Utils 命名空间 public class Utils public static string GetQueryString(string strName) public static string GetQueryString(string strName, bool sqlSafeCheck) public static bool IsSafeSqlString(string str) public static int GetQueryInt(string strName, int defValue) public static int StrToInt(string expression, int defValue) public static float StrToFloat(string expression, float defValue) public static string CombUrlTxt(string _url, string _keys, params string[] _values) public static string UrlEncode(string str) //删除最后结尾的指定字符后的字符 public static string DelLastChar(string str, string strchar) //返回分页页码 public static string OutPageList(int pageSize, int pageIndex, int totalCount, string linkUrl, int centSize) public static string ReplaceStr(string originalStr, string oldStr, string newStr) public static string GetCookie(string strName, string key) public static string UrlDecode(string str) public static void WriteCookie(string strName, string key, string strValue, int expires) } Bussiness 命名空间 public class Business public Business() } public List } DAL 命名空间 public partial class xxx public List } PagingHelper 命名空间 // ROW_NUMBER高效率分页(仅支持MSSQL2005及以上) public static class PagingHelper // 获取分页SQL语句，默认row_number为关健字，所有表不允许使用该字段名 public static string CreatePagingSql(int _recordCount, int _pageSize, int _pageIndex, string _safeSql, string _orderField) } 2 月 9 日消息，雷神 (THUNDEROBOT) 现已宣布推出基于英 2 月 10 日消息，制造商 Musnap 现已在海外推出一款 Oce
{
protected int page;//当前页面
protected int pageSize;//每页数据大小
protected string keywords = string.Empty;//查询条件
{
this.pageSize = GetPageSize(10); //设置每页数据大小
{
{
this.page = Utils.GetQueryInt("page", 1);
txtKeywords.Text = this.keywords;
BLL.Business bll = new BLL.Business();
this.rptList.DataSource = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out totalCount,out totalIncome);
this.rptList.DataBind();
lblTotalIncome.Text = Math.Round(totalIncome, 3).ToString();
txtPageNum.Text = this.pageSize.ToString();
string pageUrl = Utils.CombUrlTxt("xxx.aspx", "keywords={0}&page={1}", this.keywords, "__id__");
PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8);
}
{
int _pagesize;
if (int.TryParse(Utils.GetCookie("detail_page_size", "NovelPage"), out _pagesize))
{
if (_pagesize > 0)
{
return _pagesize;
}
}
return _default_size;
}
{
Response.Redirect(Utils.CombUrlTxt("xxx.aspx", "keywords={0}", txtKeywords.Text));
}
{
int _pagesize;
if (int.TryParse(txtPageNum.Text.Trim(), out _pagesize))
{
if (_pagesize > 0)
{
Utils.WriteCookie("detail_page_size", "NovelPage", _pagesize.ToString(), 14400);
}
}
Response.Redirect(Utils.CombUrlTxt("xxx.aspx", "keywords={0}", this.keywords));
}
{
{
return GetQueryString(strName, false);
}
{
if (HttpContext.Current.Request.QueryString[strName] == null)
return "";
if (sqlSafeCheck && !IsSafeSqlString(HttpContext.Current.Request.QueryString[strName]))
return "unsafe string";
return HttpContext.Current.Request.QueryString[strName];
}
{
return !Regex.IsMatch(str, @"[-|;|,|\/|\(|\)|\[|\]|\}|\{|%|@|\*|!|\']");
}
{
return StrToInt(HttpContext.Current.Request.QueryString[strName], defValue);
}
{
if (string.IsNullOrEmpty(expression) || expression.Trim().Length >= 11 || !Regex.IsMatch(expression.Trim(), @"^([-]|[0-9])[0-9]*(\.\w*)?$"))
return defValue;
int rv;
if (Int32.TryParse(expression, out rv))
return rv;
return Convert.ToInt32(StrToFloat(expression, defValue));
}
{
if ((expression == null) || (expression.Length > 10))
return defValue;
float intValue = defValue;
if (expression != null)
{
bool IsFloat = Regex.IsMatch(expression, @"^([-]|[0-9])[0-9]*(\.\w*)?$");
if (IsFloat)
float.TryParse(expression, out intValue);
}
return intValue;
}
{
StringBuilder urlParams = new StringBuilder();
try
{
string[] keyArr = _keys.Split(new char[] { '&' });
for (int i = 0; i {
if (!string.IsNullOrEmpty(_values[i]) && _values[i] != "0")
{
_values[i] = UrlEncode(_values[i]);
urlParams.Append(string.Format(keyArr[i], _values) + "&");
}
}
if (!string.IsNullOrEmpty(urlParams.ToString()) && _url.IndexOf("?") == -1)
urlParams.Insert(0, "?");
}
catch
{
return _url;
}
return _url + DelLastChar(urlParams.ToString(), "&");
}
{
if (string.IsNullOrEmpty(str))
{
return "";
}
str = str.Replace("'", "");
return HttpContext.Current.Server.UrlEncode(str);
}
{
if (string.IsNullOrEmpty(str))
return "";
if (str.LastIndexOf(strchar) >= 0 && str.LastIndexOf(strchar) == str.Length - 1)
{
return str.Substring(0, str.LastIndexOf(strchar));
}
return str;
}
{
//计算页数
if (totalCount {
return "";
}
int pageCount = totalCount / pageSize;
if (pageCount {
return "";
}
if (totalCount % pageSize > 0)
{
pageCount += 1;
}
if (pageCount {
return "";
}
StringBuilder pageStr = new StringBuilder();
string pageId = "__id__";
string firstBtn = "上一页»";
string lastBtn = "下一页»";
string firstStr = "1";
string lastStr = "" + pageCount.ToString() + "";
if (pageIndex {
firstBtn = "«上一页";
}
if (pageIndex >= pageCount)
{
lastBtn = "下一页»";
}
if (pageIndex == 1)
{
firstStr = "1";
}
if (pageIndex == pageCount)
{
lastStr = "" + pageCount.ToString() + "";
}
int firstNum = pageIndex - (centSize / 2); //中间开始的页码
if (pageIndex firstNum = 2;
int lastNum = pageIndex + centSize - ((centSize / 2) + 1); //中间结束的页码
if (lastNum >= pageCount)
lastNum = pageCount - 1;
pageStr.Append("共" + totalCount + "记录");
pageStr.Append(firstBtn + firstStr);
if (pageIndex >= centSize)
{
pageStr.Append("...\n");
}
for (int i = firstNum; i {
if (i == pageIndex)
{
pageStr.Append("" + i + "");
}
else
{
pageStr.Append("" + i + "");
}
}
if (pageCount - pageIndex > centSize - ((centSize / 2)))
{
pageStr.Append("...");
}
pageStr.Append(lastStr + lastBtn);
return pageStr.ToString();
}
{
if (string.IsNullOrEmpty(oldStr))
{
return "";
}
return originalStr.Replace(oldStr, newStr);
}
{
if (HttpContext.Current.Request.Cookies != null && HttpContext.Current.Request.Cookies[strName] != null && HttpContext.Current.Request.Cookies[strName][key] != null)
return UrlDecode(HttpContext.Current.Request.Cookies[strName][key].ToString());
return "";
}
{
if (string.IsNullOrEmpty(str))
{
return "";
}
return HttpContext.Current.Server.UrlDecode(str);
}
{
HttpCookie cookie = HttpContext.Current.Request.Cookies[strName];
if (cookie == null)
{
cookie = new HttpCookie(strName);
}
cookie[key] = UrlEncode(strValue);
cookie.Expires = DateTime.Now.AddMinutes(expires);
HttpContext.Current.Response.AppendCookie(cookie);
}
{
private readonly DAL.xxx xxxDal;
{
xxxDal = new DAL.xxx();
{
return xxxDal.GetList(pageSize, pageIndex, strWhere, filedOrder, out recordCount,out totalIncome);
}
{
{
totalIncome = 0;
StringBuilder strSql = new StringBuilder();
strSql.Append(@"select a.oid,ocreatetime,a.oaccname,a.oacctel,(select ucardnum from AppUser where uid=a.ouid) as ucardnum,c.pname,
otype,ISNULL(b.corealmoney,0) as corealmoney,ISNULL(b.cooid,0) as cooid,
omoney,ISNULL(coprate,0) coprate,ISNULL(codrawfee,0) codrawfee,ISNULL(codowndrawfee,0) codowndrawfee,ISNULL(d.uname,'无') as uname,
ISNULL(b.couserrate,0) as couserrate,
ROW_NUMBER() over(order by ocreatetime desc) r from xxx a left join
(select cooid,coprate,comoney,corealmoney,codowndrawfee,codrawfee,couupperid,couserrate from xxx where costatus=1)b
on a.oid=b.cooid join xxx c on a.opid=c.pid
left join xxx d on b.couupperid=d.[uid] where a.ostatus=1 ");
if (strWhere.Trim() != "")
{
strSql.Append(strWhere);
}
using (var context = DataBaseConnection.GetSdkBaseConnection())
{
recordCount = context.ExecuteScalar
if (recordCount > 0)
{
StringBuilder strSql2 = new StringBuilder();
strSql2.Append(@"select SUM(corealmoney) from xxx a left join
(select cooid,coprate,corealmoney,codowndrawfee,comoney,codrawfee,couupperid,couserrate from xxx where costatus=1)b
on a.oid=b.cooid join xxx c on a.opid=c.pid
left join xxx d on b.couupperid=d.[uid] where a.ostatus=1 ");
if (strWhere.Trim() != "")
{
strSql2.Append(strWhere);
}
}
return context.Query
}
}
{
{
//计算总页数
_pageSize = _pageSize == 0 ? _recordCount : _pageSize;
int pageCount = (_recordCount + _pageSize - 1) / _pageSize;
//检查当前页数
if (_pageIndex {
_pageIndex = 1;
}
else if (_pageIndex > pageCount)
{
_pageIndex = pageCount;
}
//拼接SQL字符串，加上ROW_NUMBER函数进行分页
StringBuilder newSafeSql = new StringBuilder();
newSafeSql.AppendFormat("SELECT ROW_NUMBER() OVER(ORDER BY {0}) as row_number,", _orderField);
newSafeSql.Append(_safeSql.Substring(_safeSql.ToUpper().IndexOf("SELECT") + 6));
//拼接成最终的SQL语句
StringBuilder sbSql = new StringBuilder();
sbSql.Append("SELECT * FROM (");
sbSql.Append(newSafeSql.ToString());
sbSql.Append(") AS T");
sbSql.AppendFormat(" WHERE row_number between {0} and {1}", ((_pageIndex - 1) * _pageSize) + 1, _pageIndex * _pageSize);
return sbSql.ToString();
}
// 获取记录总数SQL语句
public static string CreateCountingSql(string _safeSql)
{
return string.Format(" SELECT COUNT(1) AS RecordCount FROM ({0}) AS T ", _safeSql);
}编辑推荐：
相关推荐
雷神推出 MIX PRO II 迷你主机：基于 Ultra 200H，玻璃上盖 + ARGB 灯效
制造商 Musnap 推出彩色墨水屏电纸书 Ocean C：支持手写笔、第三方安卓应用
