private void dataBind(int pageIndex)
{
//AccountsPrincipal user = new AccountsPrincipal(Context.User.Identity.Name);
//if (!user.HasPermissionID(PermId_Add))
//{
// this.Page011.Page_Add = "";
//}
//if (!user.HasPermissionID(PermId_Search))
//{
// this.Page011.Page_Search = "";
//}
//if (user.HasPermissionID(PermId_Modify))
//{
// grid.Columns[6].Visible = true;
//}
//if (user.HasPermissionID(PermId_Delete))
//{
// grid.Columns[7].Visible = true;
//}
pageIndex--;
Maticsoft.BLL.NewsManage.News bll = new Maticsoft.BLL.NewsManage.News();
string strWhere = "";
if (Session["strWhereNewsRelea"] != null && Session["strWhereNewsRelea"].ToString() != "")
{
strWhere = Session["strWhereNewsRelea"].ToString();
}
DataSet ds = new DataSet();
ds = bll.GetList(strWhere);
grid.DataSource = ds.Tables[0].DefaultView;
int record_Count = ds.Tables[0].Rows.Count;
int page_Size = grid.PageSize;
int totalPages = int.Parse(Math.Ceiling((double)record_Count / page_Size).ToString());
if (totalPages > 0)
{
if ((pageIndex + 1) > totalPages)
pageIndex = totalPages - 1;
}
else
{
pageIndex = 0;
}
grid.CurrentPageIndex = pageIndex;
grid.DataBind();
int page_Count = grid.PageCount;
int page_Current = pageIndex + 1;
Page011.Record_Count = record_Count;
Page011.Page_Count = page_Count;
Page021.Page_Count = page_Count;
Page011.Page_Size = page_Size;
Page021.Page_Size = page_Size;
Page011.Page_Current = page_Current;
Page021.Page_Current = page_Current;
}
protected void newssearch()
{
string key = Request.Form[0].ToString();
int type = int.Parse(Request.Form[1]);
string strType = "";
this.searchInfo.InnerHtml = key + type.ToString();
string strwhere = "";
switch (type)
{
case 1:
strwhere = " ( heading like'%" + key + "%')";
strType = "标题";
break;
case 2:
strwhere = " ( content like'%" + key + "%')";
strType = "内容";
break;
case 3:
string strdate = "1900-01-01";
try { strdate = Convert.ToDateTime(key).ToShortDateString(); }
catch { }
strwhere = " issuedate>'" + strdate + "' and issuedate-1<'" + strdate + "'";
strType = "日期";
break;
}
Maticsoft.BLL.NewsManage.News bll = new Maticsoft.BLL.NewsManage.News();
DataSet ds = new DataSet();
ds = bll.GetList(strwhere);
this.GridView1.DataSource = ds.Tables[0].DefaultView;
this.GridView1.DataBind();
int count = 0;
try
{
count = ds.Tables[0].Rows.Count;
}
catch { }
this.searchInfo.InnerHtml = "搜索关键字：<b>" + key + " </b>搜索方式：<b>" + strType;
this.searchInfo.InnerHtml += "</b>共找到记录：<b>" + count.ToString() + "</b>";
}
protected void newssearch()
{
string key = Request.Form[0].ToString();
int type = int.Parse(Request.Form[1]);
string strType = "";
this.searchInfo.InnerHtml = key + type.ToString();
string strwhere="";
switch (type)
{
case 1:
strwhere = " ( heading like'%" + key + "%')";
strType = "标题";
break;
case 2:
strwhere = " ( content like'%" + key + "%')";
strType = "内容";
break;
case 3:
string strdate="1900-01-01";
try { strdate = Convert.ToDateTime(key).ToShortDateString(); }
catch { }
strwhere = " issuedate>'" + strdate + "' and issuedate-1<'" + strdate + "'";
strType = "日期";
break;
}
Maticsoft.BLL.NewsManage.News bll = new Maticsoft.BLL.NewsManage.News();
DataSet ds = new DataSet();
ds = bll.GetList(strwhere);
this.GridView1.DataSource = ds.Tables[0].DefaultView;
this.GridView1.DataBind();
int count=0;
try
{
count=ds.Tables[0].Rows.Count;
}
catch { }
this.searchInfo.InnerHtml = "搜索关键字：<b>" + key + " </b>搜索方式：<b>" + strType;
this.searchInfo.InnerHtml += "</b>共找到记录：<b>" +count.ToString() +"</b>";
}
private void BindData()
{
#region 权限检查
if (!Context.User.Identity.IsAuthenticated)
{
return;
}
AccountsPrincipal user = new AccountsPrincipal(Context.User.Identity.Name);
if (user.HasPermissionID(PermId_Modify))
{
gridView.Columns[7].Visible = true;
}
if (user.HasPermissionID(PermId_Delete))
{
gridView.Columns[8].Visible = true;
}
#endregion
string strWhere = "";
if (Session["strWhereNews"] != null && Session["strWhereNews"].ToString() != "")
{
strWhere += Session["strWhereNews"].ToString();
}
DataSet ds = new DataSet();
ds = bll.GetList(strWhere);
DataView dv = ds.Tables[0].DefaultView;
gridView.DataSource = dv;
gridView.DataBind();
//分页
int rows_Count = ds.Tables[0].Rows.Count;
int page_Size = gridView.PageSize;
int page_Count = gridView.PageCount;
int page_Current = gridView.PageIndex + 1;
lblRowsCount.Text = rows_Count.ToString();
lblPageCount.Text = page_Count.ToString();
lblCurrentPage.Text = page_Current.ToString();
#region 显示页导航
btnFirst.Enabled = true;
btnPrev.Enabled = true;
btnNext.Enabled = true;
btnLast.Enabled = true;
if (gridView.PageIndex == 0)
{
btnFirst.Enabled = false;
btnPrev.Enabled = false;
if (gridView.PageCount == 1)
{
btnLast.Enabled = false;
btnNext.Enabled = false;
}
}
else if (gridView.PageIndex == gridView.PageCount - 1)
{
btnLast.Enabled = false;
btnNext.Enabled = false;
}
#endregion
}
private void dataBind(int pageIndex)
{
//AccountsPrincipal user = new AccountsPrincipal(Context.User.Identity.Name);
//if (!user.HasPermissionID(PermId_Add))
//{
// this.Page011.Page_Add = "";
//}
//if (!user.HasPermissionID(PermId_Search))
//{
// this.Page011.Page_Search = "";
//}
//if (user.HasPermissionID(PermId_Modify))
//{
// grid.Columns[6].Visible = true;
//}
//if (user.HasPermissionID(PermId_Delete))
//{
// grid.Columns[7].Visible = true;
//}
pageIndex--;
Maticsoft.BLL.NewsManage.News bll = new Maticsoft.BLL.NewsManage.News();
string strWhere = "";
if (Session["strWhereNewsRelea"] != null && Session["strWhereNewsRelea"].ToString() != "")
{
strWhere = Session["strWhereNewsRelea"].ToString();
}
DataSet ds = new DataSet();
ds = bll.GetList(strWhere);
grid.DataSource = ds.Tables[0].DefaultView;
int record_Count = ds.Tables[0].Rows.Count;
int page_Size = grid.PageSize;
int totalPages = int.Parse(Math.Ceiling((double)record_Count / page_Size).ToString());
if (totalPages > 0)
{
if ((pageIndex + 1) > totalPages)
{
pageIndex = totalPages - 1;
}
}
else
{
pageIndex = 0;
}
grid.CurrentPageIndex = pageIndex;
grid.DataBind();
int page_Count = grid.PageCount;
int page_Current = pageIndex + 1;
Page011.Record_Count = record_Count;
Page011.Page_Count = page_Count;
Page021.Page_Count = page_Count;
Page011.Page_Size = page_Size;
Page021.Page_Size = page_Size;
Page011.Page_Current = page_Current;
Page021.Page_Current = page_Current;
}