| ||
Body: |
| |
Expires: |
| |
Attachments: |
|
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using ITsolution.Config;
using System.Text;
using Microsoft.Practices.EnterpriseLibrary.Data;
using Microsoft.Practices.EnterpriseLibrary.Data.Sql;
using System.Data.Common;
///使用到了企业程序库
public partial class Test : System.Web.UI.UserControl
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("生成的分页存储过程");
db.AddInParameter(dbCommand, "pageindex", DbType.Int32, 1);
db.AddInParameter(dbCommand, "pagesize", DbType.Int32, 1);
db.AddInParameter(dbCommand, "docount", DbType.Boolean, true);
Pager.RecordCount = (int)db.ExecuteScalar(dbCommand);
BindData();
}
}
网上收集的取过长字符串的方法
public static string CutString(string inputString, int len)
{
ASCIIEncoding ascii = new ASCIIEncoding();
int tempLen = 0;
string tempString = "";
byte[] s = ascii.GetBytes(inputString);
for (int i = 0; i < s.Length; i++)
{
if ((int)s[i] == 63)
{
tempLen += 2;
}
else
{
tempLen += 1;
}
try
{
tempString += inputString.Substring(i, 1);
}
catch
{
break;
}
if (tempLen > len)
break;
}
//如果截过则加上半个省略号
byte[] mybyte = System.Text.Encoding.Default.GetBytes(inputString);
if (mybyte.Length > len)
tempString += "…";
return tempString;
}
void BindData()
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("生成的分页存储过程");
db.AddInParameter(dbCommand, "pageindex", DbType.Int32, Pager.CurrentPageIndex);
db.AddInParameter(dbCommand, "pagesize", DbType.Int32, Pager.PageSize);
db.AddInParameter(dbCommand, "docount", DbType.Boolean, false);
(DataList或Repeat控件Id).DataSource = db.ExecuteDataSet(dbCommand);
(DataList或Repeat控件Id).DataBind();
Pager.CustomInfoText = "记录总数:<font color=/"blue/"><b>" + Pager.RecordCount.ToString() + "</b></font>";
Pager.CustomInfoText += " 总页数:<font color=/"blue/"><b>" + Pager.PageCount.ToString() + "</b></font>";
Pager.CustomInfoText += " 当前页:<font color=/"red/"><b>" + Pager.CurrentPageIndex.ToString() + "</b></font>";
}
protected void AspNetPager1_PageChanged(object src, Wuqi.Webdiyer.PageChangedEventArgs e)
{
Pager.CurrentPageIndex = e.NewPageIndex;
BindData();
}
}