protected void Query() { String snowPage = Request.QueryString["nowPage"]; int nowPage; String sql = "select * from 学生情况 查询"; String sql2 = "select count(*) from 学生情况 查询"; DataTable stuList = db.Query(sql); DataTable stuNum = db.Query(sql2); int isLast = 0; int isFont = 0; int num = int.Parse(stuNum.Rows[0][0].ToString()); String stuArray; pageNum.Value = num.ToString(); if (snowPage != null) //是否第一次加载 { //后面post刷新 nowPage = int.Parse(snowPage) - 1; //当前页面号减1等于对应的datatable的行记录 if (nowPage == num - 1) { isLast = 1;//传给前端当前是否是最后页 } if (nowPage == 0) { isFont = 1;//传给前端当前是否是第一页 } string index = stuList.Rows[nowPage]["是否住宿"].ToString() == "True" ? "是" : "否"; string sex = stuList.Rows[nowPage]["性别"].ToString() == "男" ? "男" : "女"; stuArray = stuList.Rows[nowPage]["学号"].ToString() + "," + stuList.Rows[nowPage]["姓名"].ToString() + "," + sex + "," + stuList.Rows[nowPage]["出生日期"].ToString() + "," + stuList.Rows[nowPage]["生源地"].ToString() + "," + index + "," + stuList.Rows[nowPage]["宿舍电话"].ToString() + "," + isLast + "," + isFont; Response.Write(stuArray); Response.End(); } else { nowPage = 0;//传一条数据给隐藏域 id.Value = stuList.Rows[nowPage]["学号"].ToString(); name.Value = stuList.Rows[nowPage]["姓名"].ToString(); String sexual = stuList.Rows[nowPage]["性别"].ToString(); if (sexual == "男") { sex.Value = sexual; } else { sex.Value = sexual; } birthday.Value = stuList.Rows[nowPage]["出生日期"].ToString(); origion.Value = stuList.Rows[nowPage]["生源地"].ToString(); String dro = stuList.Rows[nowPage]["是否住宿"].ToString(); if (dro == "True") { dor.Value = "是"; } else { dor.Value = "否"; } phone.Value = stuList.Rows[nowPage]["宿舍电话"].ToString(); } }
protected void Page_Load(object sender, EventArgs e) { String snowPage = Request.QueryString["nowPage"]; int nowPage; String sql = "select * from 学生情况"; String sql2 = "select count(*) from 学生情况"; DataTable stuList = db.Query(sql); DataTable stuNum = db.Query(sql2); int isLast = 0; int isFont = 0; int num = int.Parse(stuNum.Rows[0][0].ToString()); String stuArray; if (snowPage != null) //是否第一次加载 { //后面post刷新 nowPage = int.Parse(snowPage) - 1; //当前页面号减1等于对应的datatable的行记录 if (nowPage == num - 1) { isLast = 1; } if (nowPage == 0) { isFont = 1; } string index = stuList.Rows[nowPage]["是否住宿"].ToString() == "True" ? "是" : "否"; stuArray = stuList.Rows[nowPage]["学号"].ToString() + "," + stuList.Rows[nowPage]["姓名"].ToString() + "," + stuList.Rows[nowPage]["性别"].ToString() + "," + stuList.Rows[nowPage]["出生日期"].ToString() + "," + stuList.Rows[nowPage]["生源地"].ToString() + "," + stuList.Rows[nowPage]["政治面貌"].ToString() + "," + index + "," + stuList.Rows[nowPage]["宿舍电话"].ToString() + "," + isLast + "," + isFont; Response.Write(stuArray); Response.End(); } else {//第一次加载 nowPage = 0; TextBox1.Text = stuList.Rows[nowPage]["学号"].ToString(); TextBox2.Text = stuList.Rows[nowPage]["姓名"].ToString(); TextBox3.Text = stuList.Rows[nowPage]["性别"].ToString(); TextBox4.Text = stuList.Rows[nowPage]["出生日期"].ToString(); TextBox5.Text = stuList.Rows[nowPage]["生源地"].ToString(); TextBox6.Text = stuList.Rows[nowPage]["政治面貌"].ToString(); TextBox7.Text = stuList.Rows[nowPage]["是否住宿"].ToString() == "True" ? "是" : "否"; TextBox8.Text = stuList.Rows[nowPage]["宿舍电话"].ToString(); pageNum.Value = num.ToString(); } }
protected void Query() { String snowPage = Request.QueryString["nowPage"]; int nowPage; String sql = "select * from 课程档案"; String sql2 = "select count(*) from 课程档案"; DataTable stuList = db.Query(sql); DataTable stuNum = db.Query(sql2); int isLast = 0; int isFont = 0; int num = int.Parse(stuNum.Rows[0][0].ToString()); String stuArray; pageNum.Value = num.ToString(); if (snowPage != null) //是否第一次加载 { //后面post刷新 nowPage = int.Parse(snowPage) - 1; //当前页面号减1等于对应的datatable的行记录 if (nowPage == num - 1) { isLast = 1;//传给前端当前是否是最后页 } if (nowPage == 0) { isFont = 1;//传给前端当前是否是第一页 } stuArray = stuList.Rows[nowPage]["课程代号"].ToString() + "," + stuList.Rows[nowPage]["课程名称"].ToString() + "," + stuList.Rows[nowPage]["类别"].ToString() + "," + stuList.Rows[nowPage]["考核方式"].ToString() + "," + stuList.Rows[nowPage]["学分"].ToString() + "," + stuList.Rows[nowPage]["备注"].ToString() + "," + isLast + "," + isFont; Response.Write(stuArray); Response.End(); } else { nowPage = 0;//传一条数据给隐藏域 id.Value = stuList.Rows[nowPage]["课程代号"].ToString(); name.Value = stuList.Rows[nowPage]["课程名称"].ToString(); cla.Value = stuList.Rows[nowPage]["类别"].ToString(); way.Value = stuList.Rows[nowPage]["考核方式"].ToString(); grade.Value = stuList.Rows[nowPage]["学分"].ToString(); note.Value = stuList.Rows[nowPage]["备注"].ToString(); } }