public static void SavaChange(AspNetPager CtrPagerIndex)
{
int totalPage = CtrPagerIndex.RecordCount % CtrPagerIndex.PageSize == 0 ? CtrPagerIndex.RecordCount / CtrPagerIndex.PageSize : CtrPagerIndex.RecordCount / CtrPagerIndex.PageSize + 1;
totalPage = totalPage == 0 ? 1 : totalPage;
CtrPagerIndex.CustomInfoHTML = "当前第" + CtrPagerIndex.CurrentPageIndex + "/" + totalPage + "页 共" + CtrPagerIndex.RecordCount + "条记录 每页" + CtrPagerIndex.PageSize + "条";
}
/// <summary>
/// 绑定分页控件
/// </summary>
/// <param name="recordCount"></param>
/// <param name="pager"></param>
/// <param name="pageSize"></param>
/// <param name="pageIndex"></param>
public static void PaginationInfo(int recordCount, AspNetPager pager, int pageSize, int pageIndex)
{
pager.RecordCount = recordCount;
pager.AlwaysShow = true;
pager.PageSize = pageSize;
pager.PageIndexBoxType = PageIndexBoxType.DropDownList;
pager.PageIndexBoxClass = "PageDropDown";
pager.PageIndexBoxStyle = "width:42px;margin:0";
pager.ShowBoxThreshold = 1;
pager.CurrentPageIndex = pageIndex;
//pager.HorizontalAlign = HorizontalAlign.Right;
pager.UrlPaging = true;
pager.ShowCustomInfoSection = ShowCustomInfoSection.Never;
//pager.CustomInfoHTML = "当前第<b>%CurrentPageIndex%</b>/<b>%PageCount%</b>页 共<b>%RecordCount%</b>条记录 每页<b>%PageSize%</b>条 ";
pager.CustomInfoHTML = " ";
pager.CustomInfoClass = "PageCustomInfo";
pager.FirstLastButtonsStyle = "display:none";
pager.FirstPageText = "<i class=\"icon-step-backward\"></i>";
pager.LastPageText = "<i class=\"icon-step-forward\"></i>";
pager.NextPageText = "<i class=\"icon-double-angle-right\"></i>";
pager.PrevPageText = "<i class=\"icon-double-angle-left\"></i>";
pager.CssClass = "PagingClass";
pager.CurrentPageButtonClass = "CurrentPagingClass";
}
protected void getPager(object sender, EventArgs e)
{
AspNetPager g = (AspNetPager)sender;
this.StoreGridView.DataSource = srv.GetAllBlogStorysSummaryOfUser(userId, anp.StartRecordIndex - 1, anp.PageSize);
this.StoreGridView.DataBind();
}
public void Asp_Holiday(GridView gv, AspNetPager pager, UserEntity en)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@UserID", SqlDbType.VarChar, 50);
param[0].Value = en.UserID;
param[1] = new SqlParameter("@UserName", SqlDbType.VarChar, 50);
param[1].Value = en.UserName;
string comstr = "with UsersInfo as(select users.*,\r\n (\r\n select count(*) from UserHoliday where UserHoliday.UserID=users.UserID and UserHoliday.RecordState=1) as num,\r\n Row_Number() over(order by users.UserID) as row_number from users where 1=1";
string comstr2 = "select count(*) from users where 1=1 \t";
if (en.UserID != null && en.UserID != "")
{
comstr += " and UserID=@UserID";
comstr2 += " and UserID=@UserID";
}
if (en.UserName != null && en.UserName != "")
{
comstr += " and UserName Like '%'+@UserName+'%'";
comstr2 += " and UserName Like '%'+@UserName+'%'";
}
comstr += " )select * from UsersInfo where row_number>{0} and row_number<={1};";
comstr = string.Format(comstr, (pager.CurrentPageIndex - 1) * pager.PageSize, pager.CurrentPageIndex * pager.PageSize);
DataBase db = new DataBase();
pager.RecordCount = Convert.ToInt32(db.ExecuteValue(comstr2, param));
gv.DataSource = db.GetDataTable(comstr, param);
gv.DataBind();
}
public void Asp5(GridView gv, AspNetPager pager, ProjectPaperEntity en)
{
SqlParameter[] para = new SqlParameter[4];
para[0] = new SqlParameter("@PPID", SqlDbType.Int);
para[0].Value = en.PPID;
para[1] = new SqlParameter("@Name", SqlDbType.VarChar, 256);
para[1].Value = en.Name;
para[2] = new SqlParameter("@PTID", SqlDbType.Int);
para[2].Value = en.PTID;
para[3] = new SqlParameter("@ClientID", SqlDbType.VarChar, 256);
para[3].Value = en.ClientID;
string comstr = "with ProjectPaperInfo as \r\n(\r\n\tselect (case when State=2 then '已承接' else '未承接' end) as IsAccept,ProjectPaper.PPID,ProjectPaper.Name,ProjectPaper.FhdateTime,PTName,Row_Number() over(order by PPID ) as row_number from ProjectPaper,PaperType where 1=1 and PaperType.PTID=ProjectPaper.PTID and ClientID=@ClientID";
string comstr2 = "select count(*) from ProjectPaper where 1=1";
if (en.PPID != 0)
{
comstr += " and PPID = @PPID";
comstr2 += " and PPID = @PPID";
}
if (en.Name != null)
{
comstr += " and Name Like '%'+@Name+'%'";
comstr2 += " and Name Like '%'+@Name+'%'";
}
comstr += ") select * from ProjectPaperInfo where row_number>{0} and row_number<={1};";
comstr = string.Format(comstr, (pager.CurrentPageIndex - 1) * pager.PageSize, pager.CurrentPageIndex * pager.PageSize);
pager.RecordCount = Convert.ToInt32(this.db.ExecuteValue(comstr2, para));
gv.DataSource = this.db.GetDataTable(comstr, para);
gv.DataBind();
}
public void Asp(GridView gv, AspNetPager pager, DepartmentEntity en)
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@DepartmentName", SqlDbType.VarChar, 100)
};
param[0].Value = en.DepartmentName;
DataBase db = new DataBase();
string comstr = "with DepartmentsInfo as\r\n(select *,Row_Number() over(order by DepartmentID) as row_number from Department\twhere 1=1";
// string comstr="with DepartmentsInfo as\r\n(select *,Row_Number() over(order by DepartmentID) as row_number from Department\twhere 1=1";
string comstr2 = "select count(*) from Department\twhere 1=1";
// string comstr2 = "select count(*) from Department\twhere 1=1";
if (en.DepartmentName != null && en.DepartmentName != "")
{
comstr += " and DepartmentName Like '%'+@DepartmentName+'%'";
comstr2 += " and DepartmentName Like '%'+@DepartmentName+'%'";
}
comstr += " )select * from DepartmentsInfo where row_number>{0} and row_number<={1}";
comstr = string.Format(comstr, (pager.CurrentPageIndex - 1) * pager.PageSize, pager.CurrentPageIndex * pager.PageSize);
pager.RecordCount = Convert.ToInt32(db.ExecuteValue(comstr2, param));
gv.DataSource = db.GetDataTable(comstr, param);
gv.DataBind();
}
public void Asp2(DataList gv, AspNetPager pager, UserHolidayEntity mo)
{
DataBase db = new DataBase();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@UserID", SqlDbType.VarChar, 50);
param[0].Value = mo.UserID;
string comstr = "with UserHolidayInfo as\r\n (\r\n select UserHoliday.*,(case when RecordState=1 then '未读' when RecordState=2 then '已读,认同加分' else '已读,不认同加分' end ) as CheckState,Users.UserName as UserName,ChangDes,Row_Number() over(order by UserHolidayID) as row_number from Users,UserHoliday,UserIntegraDetail where UserHoliday.UserID=Users.UserID,Users.UserID=UserIntegraDetail.UserID";
// string comstr = "with WrongProblemInfo as\r\n (\r\n select WrongProblem.*,(case when RecordState=1 then '教师未读' when RecordState=2 then '教师已读,认同加分' else '教师已读,不认同加分' end ) as CheckState,Problems.ProblemName as ProblemName,Problems.ProblemDes as ProblemDes,Users.UserName as UserName,Row_Number() over(order by WrongProblemID) as row_number from Problems,Users,WrongProblem where WrongProblem.UserID=Users.UserID and WrongProblem.ProblemID=Problems.ProblemID";
string comstr2 = "select count(*) from Users,UserHoliday where UserHoliday.UserID=Users.UserID ";
if (mo.UserID != null && mo.UserID != "")
{
comstr += " and UserHoliday.UserID=@UserID";
comstr2 += " and UserHoliday.UserID=@UserID";
}
comstr += " )select * from UserHolidayInfo where row_number>{0} and row_number<={1}";
comstr = string.Format(comstr, (pager.CurrentPageIndex - 1) * pager.PageSize, pager.CurrentPageIndex * pager.PageSize);
pager.RecordCount = Convert.ToInt32(db.ExecuteValue(comstr2, param));
gv.DataSource = db.GetDataTable(comstr, param);
gv.DataBind();
}
public void Asp(GridView gv, AspNetPager pager, UserIntegralDetailEntity mo)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@DetailID", SqlDbType.Int);
param[0].Value = mo.DetailID;
param[1] = new SqlParameter("@UserID", SqlDbType.VarChar, 50);
param[1].Value = mo.UserID;
string comstr = "with IntegralInfo as\r\n (\r\n select ui.DetailID as DetailID,ui.UserID as UserID,ui.IntegralChange as IntegralChange,ui.ChangeDes as ChangeDes,us.UserName as UserName,Row_Number() over(order by DetailID) as row_number from UserIntegralDetail ui,Users us where ui.UserID=us.UserID";
string comstr2 = "select count(*) from UserIntegralDetail ui,Users us where ui.UserID=us.UserID";
if (mo.DetailID != 0)
{
comstr += " and ui.DetailID=@DetailID";
comstr2 += " and ui.DetailID=@DetailID";
}
if (mo.UserID != null && mo.UserID != "")
{
comstr += " and ui.UserID=@UserID";
comstr2 += " and ui.UserID=@UserID";
}
comstr += " ) select * from IntegralInfo where row_number>{0} and row_number<{1}";
comstr = string.Format(comstr, (pager.CurrentPageIndex - 1) * pager.PageSize, pager.CurrentPageIndex * pager.PageSize);
DataBase db = new DataBase();
pager.RecordCount = Convert.ToInt32(db.ExecuteValue(comstr2, param));
gv.DataSource = db.GetDataTable(comstr, param);
gv.DataBind();
}
protected void aspPager_PageChanged(object sender, EventArgs e)
{
AspNetPager asppage = sender as AspNetPager;
if (asppage == null)
{
return;
}
switch (asppage.ID)
{
case "aspAllCusPager":
V_CRM_STAFF_CUSTOMER conAllCus = new V_CRM_STAFF_CUSTOMER();
if (string.IsNullOrEmpty(hidAllCus.Value))
{
conAllCus = JsonServiceBase.FromJson <V_CRM_STAFF_CUSTOMER>(hidAllCus.Value);
}
BindData(conAllCus, asppage.CurrentPageIndex, asppage);
break;
case "aspToDayMustConPager":
V_CRM_STAFF_CUSTOMER_NOTCONTACT conToDayMustCon = new V_CRM_STAFF_CUSTOMER_NOTCONTACT();
if (string.IsNullOrEmpty(hidToDayMustCon.Value))
{
conToDayMustCon = JsonServiceBase.FromJson <V_CRM_STAFF_CUSTOMER_NOTCONTACT>(hidToDayMustCon.Value);
}
BindData(conToDayMustCon, asppage.CurrentPageIndex, asppage);
break;
case "aspExpiredPager":
V_CRM_STAFF_CUSTOMER_NOTCONTACT conExpired = new V_CRM_STAFF_CUSTOMER_NOTCONTACT();
if (string.IsNullOrEmpty(hidExpired.Value))
{
conExpired = JsonServiceBase.FromJson <V_CRM_STAFF_CUSTOMER_NOTCONTACT>(hidExpired.Value);
}
BindData(conExpired, asppage.CurrentPageIndex, asppage);
break;
case "aspWillInHighSeasPager":
V_CRM_STAFF_CUSTOMER_NOTCONTACT conWillInHighSeas = new V_CRM_STAFF_CUSTOMER_NOTCONTACT();
if (string.IsNullOrEmpty(hidWillInHighSeas.Value))
{
conExpired = JsonServiceBase.FromJson <V_CRM_STAFF_CUSTOMER_NOTCONTACT>(hidWillInHighSeas.Value);
}
BindData(conWillInHighSeas, asppage.CurrentPageIndex, asppage);
break;
case "aspContractedPager":
V_CRM_STAFF_CUSTOMER conContracted = new V_CRM_STAFF_CUSTOMER();
if (string.IsNullOrEmpty(hidContracted.Value))
{
conContracted = JsonServiceBase.FromJson <V_CRM_STAFF_CUSTOMER>(hidContracted.Value);
}
BindData(conContracted, asppage.CurrentPageIndex, asppage);
break;
default:
break;
}
}
public BindPagedList(Page page, AspNetPager pager, NBiz.BLLBase <T> bllBase, GridView gv, IList <T> list)
{
this.CurrentPage = page;
this.pager = pager;
this.bllBase = bllBase;
this.gv = gv;
//
//TODO: 在此处添加构造函数逻辑
//
}
public override string GetDesignTimeHtml()
{
this.wb = (AspNetPager)base.Component;
this.wb.RecordCount = 0xe1;
StringWriter writer = new StringWriter();
HtmlTextWriter writer2 = new HtmlTextWriter(writer);
this.wb.RenderControl(writer2);
return(writer.ToString());
}
public void Asp(GridView gv, AspNetPager pager)
{
string sql = "with AllWrongProblem as(select UserHolidayID,UserHolidayDes,ManagerBack,DateUp,UserID,Row_Number() over(order by UserHolidayID) as row_number from WrongProblem)select * from AllWrongProblem where row_number>{0} and row_number<={1}";
string sql2 = "select count(*) from WrongProblem";
sql = string.Format(sql, (pager.CurrentPageIndex - 1) * pager.PageSize, pager.CurrentPageIndex * pager.PageSize);
pager.RecordCount = Convert.ToInt32(this.db.ExecuteValue(sql2));
gv.DataSource = this.db.GetDataTable(sql);
gv.DataBind();
}
public void Asp(DataList gv, AspNetPager pager)
{
DataBase db = new DataBase();
string sql = @"with OrderTable as(select ItemID,ParentID,ItemName,ItemContent,ItemSort,ItemKind,ItemUrl,IsTop,IsHome,NewsSort,DisplayNum,DepartID,Row_Number() over(order by ItemID,ItemSort)as row_number from Item) select * from OrderTable where row_number>{0} and row_number<{1}";
string sql1 = "select count(*) from Item";
sql = string.Format(sql, (pager.CurrentPageIndex - 1) * pager.PageSize, pager.CurrentPageIndex * pager.PageSize);
pager.RecordCount = Convert.ToInt32(db.ExecuteValue(sql1));
gv.DataSource = db.GetDataTable(sql);
gv.DataBind();
}
public void Asp(GridView gv, AspNetPager pager)
{
DataBase db = new DataBase();
string comstr = "with PowersInfo as \r\n(\r\n\tselect *,Row_Number() over(order by PowerID ) as row_number from Powers \r\n)\r\nselect * from PowersInfo where row_number>{0} and row_number<={1}";
string comstr2 = "select count(*) from Powers";
comstr = string.Format(comstr, (pager.CurrentPageIndex - 1) * pager.PageSize, pager.CurrentPageIndex * pager.PageSize);
pager.RecordCount = Convert.ToInt32(db.ExecuteValue(comstr2));
gv.DataSource = db.GetDataTable(comstr);
gv.DataBind();
}
/// <summary>
/// 分页
/// </summary>
/// <param name="src"></param>
/// <param name="e"></param>
protected void anp_top_PageChanging(object src, PageChangingEventArgs e)
{
Control controlGrid = Page.FindControl("anp_top");
if (controlGrid != null)
{
AspNetPager Grid = (AspNetPager)controlGrid;
Grid.CurrentPageIndex = e.NewPageIndex;
BindGridView();
}
}
/// <summary>
/// 分页数据绑定(列表控件和数据控件)
/// </summary>
/// <param name="ctrl">绑定控件</param>
/// <param name="source">数据源</param>
/// <param name="pager">分页控件</param>
public static void BindControl(Repeater ctrl, DataSet source, AspNetPager pager)
{
if (source.Tables.Count < 1)
{
return;
}
ctrl.DataSource = source.Tables[0];
ctrl.DataBind();
pager.RecordCount = Convert.ToInt32(source.Tables[1].Rows[0][0]);
pager.SetRewriteUrl();
}
public void Asp(GridView gv, AspNetPager pager, ManagerEnitity en)
{
SqlParameter[] param = new SqlParameter[4];
param[0] = new SqlParameter("@ManagerID", SqlDbType.VarChar, 50);
param[0].Value = en.ManagerID;
param[1] = new SqlParameter("@DepartmentID", SqlDbType.Int, 4);
param[1].Value = en.DepartmentID;
param[2] = new SqlParameter("@PowerID", SqlDbType.Int, 4);
param[2].Value = en.PowerID;
param[3] = new SqlParameter("@ManagerName", SqlDbType.VarChar, 100);
param[3].Value = en.ManagerName;
/*row_number() over (order by '字段名')是
* 微软最新发布的MSSQL2005,对TSQL进行了小规模的加强 按照字段名进行排序，可以实现数据分页功能
*
*/
string comstr = "with ManagerInfo as\r\n(\r\nselect Manager.ManagerID,Manager.DepartmentID,Manager.PowerID,ManagerName,ManagerPwd,ManagerImage,ManagerDes\r\n ,Powers.PowerName,Department.DepartmentName\t,\r\nRow_Number() over(order by ManagerID) as row_number\tfrom Manager ,Powers,Department\r\nwhere\tManager.PowerID=powers.PowerID\tand Manager.DepartmentID=Department.DepartmentID";
// string comstr = "with ManagerInfo as\r\n(\r\nselect Manager.ManagerID,Manager.DepartmentID,Manager.PowerID,ManagerName,ManagerPwd,ManagerImage,ManagerDes\r\n,Powers.PowerName,Department.DepartmentName\t,\r\nRow_Number() over(order by ManagerID) as row_number\tfrom Manager,Powers,Department\r\nwhere\tManager.PowerID=powers.PowerID\tand Manager.DepartmentID=Department.DepartmentID)";
// string comstr2 = "select count(*) from Manager,Powers,Department\r\nwhere\tManager.PowerID=Powers.PowerID\t and Manager.DepartmentID=Department.DepartmentID";
string comstr2 = "select count(*)\tfrom Manager ,Powers,Department\r\nwhere\tManager.PowerID=Powers.PowerID\tand Manager.DepartmentID=Department.DepartmentID";
if (en.DepartmentID != 0)
{
comstr += " and Manager.DepartmentID=@DepartmentID";
comstr2 += " and Manager.DepartmentID=@DepartmentID";
}
if (en.PowerID != 0)
{
comstr += " and Manager.PowerID=@PowerID";
comstr2 += " and Manager.PowerID=@PowerID";
}
if (en.ManagerID != "" && en.ManagerID != null)
{
comstr += " and ManagerID=@ManagerID";
comstr2 += " and ManagerID=@ManagerID";
}
if (en.ManagerName != "" && en.ManagerName != null)
{
comstr += " and ManagerName Like '%'+@ManagerName+'%'";
comstr2 += " and ManagerName Like '%'+ManagerName+'%'";
}
comstr += " )select * from ManagerInfo where row_number>{0} and row_number<={1};";
comstr = string.Format(comstr, (pager.CurrentPageIndex - 1) * pager.PageSize, pager.CurrentPageIndex * pager.PageSize);
DataBase db = new DataBase();
pager.RecordCount = Convert.ToInt32(db.ExecuteValue(comstr2, param));
gv.DataSource = db.GetDataTable(comstr, param);
gv.DataBind();
}
public DataSet DsPager(string sql, AspNetPager pager)
{
open();
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adapter.Fill(ds, pager.PageSize * (pager.CurrentPageIndex - 1), pager.PageSize, "Table");
return(ds);
ds.Dispose();
close();
}
/// <summary>
/// 设置分页控件
/// </summary>
/// <param name="pager"></param>
/// <returns></returns>
public AspNetPager ResetPager(AspNetPager pager)
{
pager.CssClass = "pager";
pager.FirstPageText = "First";
pager.LastPageText = "Last";
pager.NextPageText = "Next";
pager.PrevPageText = "prev";
pager.AlwaysShow = true;
pager.Wrap = false;
pager.PageSize = FGA_NUtility.ConfigHelper.GetConfigInt("PageSize");
pager.SubmitButtonText = "To";
pager.ShowBoxThreshold = Int32.MaxValue;
return(pager);
}
/// <summary>
/// 组织的GridView绑定
/// </summary>
/// <param name="anpager"></param>
/// <param name="strWhere"></param>
/// <param name="strOrder"></param>
/// <param name="grvControl"></param>
public void GridViewPagerBind(AspNetPager anpager, string strWhere, string strOrder, GridView grvControl)
{
int iRowCount = 0;
int row1 = (anpager.CurrentPageIndex - 1) * anpager.PageSize + 1;
int row2 = anpager.CurrentPageIndex * anpager.PageSize;
grvControl.DataSource = dal.GridViewData(strWhere, strOrder, row1, row2, ref iRowCount);
grvControl.DataBind();
anpager.RecordCount = iRowCount;
anpager.CustomInfoHTML = "共<font color=\"blue\"><b>" + anpager.RecordCount.ToString() + "</b></font>条记录";
anpager.CustomInfoHTML += " 共<font color=\"blue\"><b>" + anpager.PageCount.ToString() + "</b></font>页";
anpager.CustomInfoHTML += " 当前第<font color=\"red\"><b>" + anpager.CurrentPageIndex.ToString() + "</b></font>页";
}
/// <summary>
/// 根据pager返回当前页码(索引从0开始)
/// 分页控件采用post方式的时候一定要加onpagechanged事件
/// </summary>
/// <param name="pager">分页控件</param>
/// <returns></returns>
public static int getPageIndex(AspNetPager pager)
{
int reval = 1;
if (pager.UrlPaging)
{
reval = getPageIndex();
}
else
{
reval = pager.CurrentPageIndex - 1;
}
return(reval);
}
public void Asp(GridView gv, AspNetPager pager, UserHolidayEntity en)
{
SqlParameter[] p = new SqlParameter[]
{
new SqlParameter("@UserID", SqlDbType.VarChar, 50)
};
p[0].Value = en.UserID;
string sql = "with AllUserProblem as( select UserHolidayID,UserHolidayDes,ManagerBack,DateUp,Row_Number() over(order by UserHolidayID) as row_number from UserHoliday where UserID=@UserID ) select * from AllUserProblem where row_number>{0} and row_number<={1}";
string sql2 = "select count (*) from WrongProblem where UserID=@UserID";
sql = string.Format(sql, (pager.CurrentPageIndex - 1) * pager.PageSize, pager.CurrentPageIndex * pager.PageSize);
pager.RecordCount = Convert.ToInt32(this.db.ExecuteValue(sql2, p));
gv.DataSource = this.db.GetDataTable(sql, p);
gv.DataBind();
}
/// <summary>
/// 绑定分页数据
/// </summary>
/// <param name="dt">DataTable对象</param>
/// <param name="anp">AspNetPager对象</param>
public static void BindPageData(DataTable dt, Repeater rpt, AspNetPager AspNetPager1)
{
AspNetPager1.RecordCount = dt.Rows.Count;
if (dt.Rows.Count >= 0)
{
PagedDataSource ps = new PagedDataSource();
DataView dv = new DataView(dt);
ps.DataSource = dv;
ps.AllowPaging = true;
ps.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1;
ps.PageSize = AspNetPager1.PageSize;
rpt.DataSource = ps;
rpt.DataBind();
}
}
public void DsRep(string sql, AspNetPager pager)
{
open();
SqlDataAdapter adapter = new SqlDataAdapter(sql, con);
DataSet ds = new DataSet();
adapter.Fill(ds, "Table");
pager.RecordCount = ds.Tables[0].Rows.Count;
ds.Dispose();
close();
}
public void Asp(GridView gv, AspNetPager pager, RecordEntity en)
{
SqlParameter[] p = new SqlParameter[]
{
new SqlParameter("@PPID", SqlDbType.Int)
};
p[0].Value = en.PpID;
string sql = "with AllRecord as( select RecordID,PPIDD,PresentDate,Des,ProjectPaper.Name,Row_Number() over(order by RecordID) as row_number from Record,ProjectPaper where PPIDD=@PPID and PPID=PPIDD ) select * from AllRecord where row_number>{0} and row_number<={1}";
string sql2 = "select count (*) from Record where PPIDD=@PPID";
sql = string.Format(sql, (pager.CurrentPageIndex - 1) * pager.PageSize, pager.CurrentPageIndex * pager.PageSize);
pager.RecordCount = Convert.ToInt32(this.db.ExecuteValue(sql2, p));
gv.DataSource = this.db.GetDataTable(sql, p);
gv.DataBind();
}
/// <summary>
/// 全部数据用AspNetPager分页绑定，Repeater,GridView,DataList
/// </summary>
/// <param name="ie">实现IEnumerable的数据源</param>
/// <param name="ctl_Listctl">列表控件</param>
/// <param name="AspNetPager1"></param>
public static void BindCtrl(IEnumerable ie, Control ctl_Listctl, AspNetPager AspNetPager1)
{
PagedDataSource PDS = new PagedDataSource();
PDS.DataSource = ie;
if (ie is DataTable)
{
AspNetPager1.RecordCount = ((DataTable)ie).Rows.Count;
}
if (ie is IList)
{
AspNetPager1.RecordCount = ((IList)ie).Count;
}
int cPageIndex = AspNetPager1.CurrentPageIndex;
if (cPageIndex > 1)
{
PDS.CurrentPageIndex = cPageIndex - 1;
}
PDS.AllowPaging = true;
PDS.PageSize = AspNetPager1.PageSize;
if (ctl_Listctl is Repeater)
{
((Repeater)ctl_Listctl).DataSource = PDS;
((Repeater)ctl_Listctl).DataBind();
}
if (ctl_Listctl is DataList)
{
((DataList)ctl_Listctl).DataSource = PDS;
((DataList)ctl_Listctl).DataBind();
}
if (ctl_Listctl is GridView)
{
((GridView)ctl_Listctl).DataSource = PDS;
((GridView)ctl_Listctl).DataBind();
}
}
/// <summary>
/// DataList分页
/// </summary>
/// <param name="pager">AspNetPager控件ID</param>
/// <param name="dt">DataTable</param>
/// <param name="e">DataList</param>
public static void BindAspNetPager(AspNetPager pager, DataTable dt, DataList e)
{
((AspNetPager)pager).RecordCount = dt.Rows.Count;
PagedDataSource pds = new PagedDataSource();
pds.DataSource = dt.DefaultView;
pds.AllowPaging = true;
pds.CurrentPageIndex = pager.CurrentPageIndex - 1;
pds.PageSize = pager.PageSize;
e.DataSource = pds;
e.DataBind();
dt.Dispose();
dt = null;
}
protected override void OnLoad(EventArgs e)
{
if (!IsPostBack)
{
Control controlGrid = Page.FindControl("anp_top");
if (controlGrid != null)
{
AspNetPager Grid = (AspNetPager)controlGrid;
if (Grid.PageSize == 10)
{
Grid.PageSize = Convert.ToInt32(ConfigurationManager.AppSettings["PageSize"]);
}
}
}
base.OnLoad(e);
}
public void DsLoad(string sql, AspNetPager pager, DataList datalist)
{
open();
SqlDataAdapter adapter = new SqlDataAdapter(sql, con);
DataSet ds = new DataSet();
DataSet ds1 = new DataSet();
adapter.Fill(ds, "Table");
adapter.Fill(ds1, pager.PageSize * (pager.CurrentPageIndex - 1), pager.PageSize, "Table");
pager.RecordCount = ds.Tables[0].Rows.Count;
datalist.DataSource = ds1.Tables[0].DefaultView;
datalist.DataBind();
adapter.Dispose();
ds.Dispose();
ds1.Dispose();
close();
}
private void AddPager(Panel p)
{
pager = new AspNetPager();
pager.ID = "Pager";
pager.CssClass = "pager";
pager.UrlPaging = true;
pager.PagingButtonType = PagingButtonType.Text;
pager.NumericButtonType = PagingButtonType.Text;
pager.NavigationButtonType = PagingButtonType.Text;
pager.ShowNavigationToolTip = true;
pager.ShowPageIndexBox = ShowPageIndexBox.Never;
pager.ShowPageIndex = true;
pager.AlwaysShowFirstLastPageNumber = true;
pager.AlwaysShow = false;
pager.UrlPageIndexName = "page";
p.Controls.Add(pager);
}
private void BindData(ITableImplement con, int pageCur, AspNetPager asppager)
{
int recount = -1;
asppager.PageSize = 20;
switch (asppager.ID)
{
case "aspAllCusPager":
case "aspContractedPager":
V_CRM_STAFF_CUSTOMER vcrmscCon = con as V_CRM_STAFF_CUSTOMER;
if (vcrmscCon == null)
return;
if (asppager.ID == "aspAllCusPager")
hidAllCus.Value = JsonServiceBase.ToJson<V_CRM_STAFF_CUSTOMER>(vcrmscCon);
else
hidContracted.Value = JsonServiceBase.ToJson<V_CRM_STAFF_CUSTOMER>(vcrmscCon);
vcrmscCon.af_PageBy(V_CRM_STAFF_CUSTOMER.Attribute.Cus_ID, Order.Desc);
V_CRM_STAFF_CUSTOMER valsc = new V_CRM_STAFF_CUSTOMER();
valsc._SID = "";
valsc.Cus_ID = 0;
valsc.CompanyName = "";
valsc.ShopName = "";
valsc.Cus_Name = "";
valsc.CustQQ = "";
valsc.WangWangId = "";
valsc.LastContactTime = DateTime.MinValue;
valsc.SNAME = "";
valsc.CustStatus = 0;
List<V_CRM_STAFF_CUSTOMER> vcrmscList = BLLTable<V_CRM_STAFF_CUSTOMER>.Factory(conn).SelectByPage(valsc, vcrmscCon, asppager.PageSize, pageCur, ref recount);
if (vcrmscList.Count > 0)
{
FormHelper.Bind(Page, vcrmscList[0].DicAttrValues);
//BindToFindSelect(listObj[0].DicAttrValues);
}
if (asppager.ID == "aspAllCusPager")
{
repAllCusList.DataSource = vcrmscList;
repAllCusList.DataBind();
}
else
{
lit_ContractedCusCount.Text = recount.ToString();
repContractedList.DataSource = vcrmscList;
repContractedList.DataBind();
}
asppager.RecordCount = recount;
break;
case "aspToDayMustConPager":
case "aspExpiredPager":
case "aspWillInHighSeasPager":
V_CRM_STAFF_CUSTOMER_NOTCONTACT vcrmscnCon = con as V_CRM_STAFF_CUSTOMER_NOTCONTACT;
if (vcrmscnCon == null)
return;
if (asppager.ID == "aspToDayMustConPager")
hidToDayMustCon.Value = JsonServiceBase.ToJson<V_CRM_STAFF_CUSTOMER_NOTCONTACT>(vcrmscnCon);
else if (asppager.ID == "aspExpiredPager")
hidExpired.Value = JsonServiceBase.ToJson<V_CRM_STAFF_CUSTOMER_NOTCONTACT>(vcrmscnCon);
else
hidWillInHighSeas.Value = JsonServiceBase.ToJson<V_CRM_STAFF_CUSTOMER_NOTCONTACT>(vcrmscnCon);
vcrmscnCon.af_PageBy(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.Cus_ID, Order.Desc);
V_CRM_STAFF_CUSTOMER_NOTCONTACT valscn = new V_CRM_STAFF_CUSTOMER_NOTCONTACT();
valscn.STAFF_ID = 0;
valscn.Cus_ID = 0;
valscn.CompanyName = "";
valscn.ShopName = "";
valscn.Cus_Name = "";
valscn.CustQQ = "";
valscn.WangWangId = "";
valscn.LastContactTime = DateTime.MinValue;
valscn.NextContactTime = DateTime.MinValue;
valscn.SNAME = "";
valscn.CustStatus = 0;
List<V_CRM_STAFF_CUSTOMER_NOTCONTACT> vcrmscnList = BLLTable<V_CRM_STAFF_CUSTOMER_NOTCONTACT>.Factory(conn).SelectByPage(valscn, vcrmscnCon, asppager.PageSize, pageCur, ref recount);
if (vcrmscnList.Count > 0)
{
FormHelper.Bind(Page, vcrmscnList[0].DicAttrValues);
//BindToFindSelect(listObj[0].DicAttrValues);
}
if (asppager.ID == "aspToDayMustConPager")
{
lit_todayConCusCount.Text = recount.ToString();
repToDayMustConList.DataSource = vcrmscnList;
repToDayMustConList.DataBind();
}
else if (asppager.ID == "aspExpiredPager")
{
lit_ExpiredUnConCusCount.Text = recount.ToString();
repExpiredList.DataSource = vcrmscnList;
repExpiredList.DataBind();
}
else
{
lit_WillInHighSeasCusCount.Text = recount.ToString();
repWillInHighSeasList.DataSource = vcrmscnList;
repWillInHighSeasList.DataBind();
}
asppager.RecordCount = recount;
break;
default:
break;
}
}
