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();
}
}
