private void BindData()
{
role_GetDataSet myDS = new role_GetDataSet();
gvrequest.DataSource = myDS.GetUserRequestData(Session["user"].ToString());
gvrequest.DataKeyNames = new string[] { "requestID" };
gvrequest.DataBind();
}
protected void GridView_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
gvrequest.PageIndex = e.NewPageIndex;
role_GetDataSet myDS = new role_GetDataSet();
gvrequest.DataSource = myDS.GetUserRequestData(Session["user"].ToString());
gvrequest.DataKeyNames = new string[] { "requestID" };
gvrequest.DataBind();
}
private void BindData()
{
role_GetDataSet myDS = new role_GetDataSet();
role_User user = new role_User();
lsname.Text = user.GetUserName(Session["user"].ToString());
gvmonitor.DataSource = myDS.GetUserMonitorData(Session["user"].ToString());
gvmonitor.DataKeyNames = new string[] { "monitorID" };
gvmonitor.DataBind();
}
private void BindData()
{
role_GetDataSet myDS = new role_GetDataSet();
anpcourse.RecordCount = myDS.GetCourseSearchCount(kcnamesearch, kccodesearch);
int pageindex = anpcourse.CurrentPageIndex - 1;
int pagesize = 13;
gvcourse.DataSource = myDS.GetCourseSearchData(kcnamesearch, kccodesearch, pageindex, pagesize);
gvcourse.DataKeyNames = new string[] { "courseID" };
gvcourse.DataBind();
}
private void BindData()
{
role_GetDataSet myDS = new role_GetDataSet();
anpteacher.RecordCount = myDS.GetTeacherSearchCount(lsnamesearch, lscodesearch);
int pageindex = anpteacher.CurrentPageIndex - 1;
int pagesize = 13;
gvteacher.DataSource = myDS.GetTeacherSearchData(lsnamesearch, lscodesearch, pageindex, pagesize);
gvteacher.DataKeyNames = new string[] { "teacherID" };
gvteacher.DataBind();
}
private void BindData()
{
role_GetDataSet myDS = new role_GetDataSet();
anpmonitor.RecordCount = myDS.GetAllMonitorCount();
int pageindex = anpmonitor.CurrentPageIndex - 1;
int pagesize = 10;
gvmonitor.DataSource = myDS.GetAllMonitorData(pageindex, pagesize);
gvmonitor.DataKeyNames = new string[] { "monitorID" };
gvmonitor.DataBind();
}
private void BindData()
{
role_GetDataSet myDS = new role_GetDataSet();
anprequest.RecordCount = myDS.GetAllRequestCount();
int pageindex = anprequest.CurrentPageIndex - 1;
int pagesize = 13;
gvrequest.DataSource = myDS.GetAllRequestData(pageindex, pagesize);
gvrequest.DataKeyNames = new string[] { "requestID" };
gvrequest.DataBind();
}
private void BindData()
{
role_GetDataSet myDS = new role_GetDataSet();
anpclass.RecordCount = myDS.GetClassSearchCount(bjnamesearch, bjcodesearch);
int pageindex = anpclass.CurrentPageIndex - 1;
int pagesize = 13;
gvclass.DataSource = myDS.GetClassSearchData(bjnamesearch, bjcodesearch, pageindex, pagesize);
gvclass.DataKeyNames = new string[] { "classID" };
gvclass.DataBind();
}
protected void down_Click(object sender, EventArgs e)
{
role_GetDataSet myDS = new role_GetDataSet();
gvmonitor.DataSource = myDS.GetUserMonitorData(Session["user"].ToString());
gvmonitor.DataKeyNames = new string[] { "monitorID" };
gvmonitor.AllowPaging = false;
gvmonitor.DataBind();
string FileName = "监考安排" + DateTime.Now + ".xls";
Response.Charset = "GB2312";
Response.ContentEncoding = Encoding.UTF8;
Response.AddHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString());
Response.AddHeader("content-type", "appliction/ms-excel");//或者Response.ContentType=File Type
StringWriter tw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(tw);
gvmonitor.RenderControl(hw);
Response.Write(tw.ToString());
Response.End();
}
