protected void Page_Load(object sender, EventArgs e)
{
// Response.Write(@"[
// {
// ""name"": ""55555"",
// ""value"": 1
// },
// {
// ""name"": ""44444"",
// ""value"": 5555
// }]
//");
czy_dbEntities theEntity = new czy_dbEntities();
IQueryable <object> rtv =
(from oneclass in theEntity.study_class
select new
{
value = oneclass.name,
name = oneclass.id
});
JavaScriptSerializer jss = new JavaScriptSerializer();
string jsonstr = jss.Serialize(rtv.ToList());
Response.Write(jsonstr);
}
protected void Page_Load(object sender, EventArgs e)
{
string username = Request.Form["name"];
string password = Request.Form["password"];
czy_dbEntities theEntity = new czy_dbEntities();
IQueryable <study_students> rtv =
from oneStudent in theEntity.study_students
where oneStudent.name.Equals(username) &&
oneStudent.password.Equals(password)
select oneStudent;
if (rtv.Count() < 1)
{
//
}
else
{
Response.Redirect("index.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.HttpMethod == "GET")
{
return;
}
string username = Request.Form["username"];
string sex = Request.Form["sex"];
string classnum = Request.Form["classnum"];
bool?b_sex = null;
if (!string.IsNullOrEmpty(sex))
{
if (sex == "女")
{
b_sex = true;
}
else
{
b_sex = false;
}
}
czy_dbEntities theEntity = new czy_dbEntities();
String firstbtn = Request.Form["firstbtn"];
String prebtn = Request.Form["prebtn"];
String nextbtn = Request.Form["nextbtn"];
String endbtn = Request.Form["endbtn"];
String gobtn = Request.Form["gobtn"];
String currentpagebtn = Request.Form["currentpageindex"];
int wantpage = 1;
if (null != Request.Form["currentpageindex"])
{
wantpage = Int32.Parse(currentpagebtn);
}
int total =
(from onestudent in theEntity.study_students
join oneclass in theEntity.study_class
on onestudent.class_id equals oneclass.id
select onestudent
).Count();
int totalpage = total / 5;
if (total % 5 != 0)
{
totalpage++;
}
totalpagecount = totalpage;
if (!String.IsNullOrEmpty(firstbtn))
{
wantpage = 1;
}
else if (!String.IsNullOrEmpty(prebtn))
{
wantpage--;
if (wantpage <= 0)
{
wantpage = 1;
}
}
else if (!String.IsNullOrEmpty(nextbtn))
{
wantpage++;
if (wantpage > totalpage)
{
wantpage = totalpage;
}
}
else if (!String.IsNullOrEmpty(endbtn))
{
wantpage = totalpage;
}
else if (!String.IsNullOrEmpty(gobtn))
{
if (wantpage > totalpage)
{
wantpage = totalpage;
}
}
IQueryable <object> rtv =
(from oneStudent in theEntity.study_students
join oneClass in theEntity.study_class
on oneStudent.class_id equals oneClass.id
where (string.IsNullOrEmpty(username) ? true : oneStudent.name.Equals(username)) &&
(b_sex.Equals(null) ? true : oneStudent.sex.Equals(b_sex.Value)) &&
(string.IsNullOrEmpty(classnum) ? true : oneClass.name.Equals(classnum))
select new
{
studentid = oneStudent.id,
name = oneStudent.name,
sex = oneStudent.sex,
banji = oneClass.name,
}).OrderBy(theKey => theKey.studentid).Skip((wantpage - 1) * 5).Take(5);
ViewState["data"] = rtv.ToList();
responsepageindex = wantpage;
}
