protected void gvCardInfo_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
if (search.Text.Trim() == "")
{
gvCardInfo.PageIndex = e.NewPageIndex;
string sqlstr = "select * from ModuleInfo_View order by CardDate desc";
sqlBind.gvBind(gvCardInfo, sqlstr);
}
else
{
gvCardInfo.PageIndex = e.NewPageIndex;
string searchstr = search.Text.Trim();
string sqlstr = "select * from ModuleInfo_View where CardName like @title order by CardDate desc";
gvCardInfo.DataSource = sqlBind.Search(sqlstr, searchstr);
gvCardInfo.DataBind();
}
}
protected void gvModuleInfo_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
string idStr = Page.Request.QueryString["ModuleName"];
if (txtKeyWord.Text.Trim() == "")
{
gvModuleInfo.PageIndex = e.NewPageIndex;
string sqlstr = "select * from ModuleInfo_View where ModuleName='" + idStr + "' and CardName like '%" + txtKeyWord.Text + "%'order by CardDate desc";
sqlBind.gvBind(gvModuleInfo, sqlstr);
}
else
{
gvModuleInfo.PageIndex = e.NewPageIndex;
string search = txtKeyWord.Text.Trim();
string sqlstr = "select * from ModuleInfo_View where ModuleName='" + idStr + "' and CardName like @title order by CardDate desc";
gvModuleInfo.DataSource = sqlBind.Search(sqlstr, search);
gvModuleInfo.DataBind();
}
}
