-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathstudents_del.cshtml
35 lines (35 loc) · 1.47 KB
/
students_del.cshtml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
@{
Layout = "~/_xuejiLayout.cshtml";
if (Session["name"] == null || Session["username"] == null)
{
Response.Redirect("~/#.cshtml");
}
var id = Convert.ToInt16(Request.QueryString["id"]);
var db = Database.Open("ctXueji");
var list = "select *from students inner join classes on students.classes_id = classes.id inner join majors on classes.majors_id = majors.id where students.id="+id;
var row = db.QuerySingle(list, id);
if (IsPost)
{
var sid = Request.Form["id"];
var deleteCommand = "DELETE FROM students WHERE id = @0";
db.Execute(deleteCommand, sid);
//var delete = "delete from scores where students_id = @0";
//db.Execute(delete, id);
Response.Redirect("~/students");
}
}
<form method="post" class="navbar-form">
<dl>
<dt class="page-header">学号:@row.students_number</dt>
<dt class="page-header">姓名:@row.students_name</dt>
<dt class="page-header">性别:@row.students_sex</dt>
<dt class="page-header">年龄:@row.students_age</dt>
<dt class="page-header">电话:@row.students_phone</dt>
<dt class="page-header">QQ:@row.students_qq</dt>
<dt class="page-header">WeChat:@row.students_wx</dt>
<dt class="page-header">专业:@row.classes_year@row.majors_name</dt>
</dl>
<input type="hidden" id="id" name="id" value=@id >
<br />
<input class="btn btn-primary" type="submit" value="确认删除" />
</form>