private void gridviewBind() { StuCourseManage cm = new StuCourseManage(); GridView1.DataSource = cm.SelectClassByStu(Session["studentId"].ToString()); GridView1.DataBind(); }
protected void Button1_Click(object sender, EventArgs e) { StuCourseManage sm = new StuCourseManage(); StuHomeworkManage mm = new StuHomeworkManage(); DataTable dt = sm.SelectClassByClassId(Convert.ToInt32(Request.QueryString["classId"])); stuHomework n = new stuHomework(); n.StudentId = Session["studentId"].ToString(); n.ClassId = Convert.ToInt32(Request.QueryString["classId"]); n.Times = Convert.ToInt32(Label1.Text); n.Creater = Session["studentId"].ToString(); string path = Server.MapPath("~/upload/" + dt.Rows[0]["teacherId"].ToString() + "/" + dt.Rows[0]["name"].ToString() + Request.QueryString["classId"] + "/第" + Label1.Text + "次作业/"); if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } if (mm.Isexistence(n).Rows.Count > 0) { FileInfo fi1 = new FileInfo(Server.MapPath(mm.Isexistence(n).Rows[0]["content"].ToString())); fi1.Delete(); mm.Delete(n); } FileUpload1.SaveAs(path + FileUpload1.FileName); n.Content = "~/upload/" + dt.Rows[0]["teacherId"].ToString() + "/" + dt.Rows[0]["name"].ToString() + Request.QueryString["classId"] + "/第" + Label1.Text + "次作业/" + FileUpload1.FileName; mm.Insert(n); ScriptManager.RegisterStartupScript(this, this.GetType(), "updateScript", "alert(\"上交成功\");", true); }
// gridView1 绑定 public void gridviewBind1() { StuCourseManage sm = new StuCourseManage(); stuCourse n = new stuCourse(); n.ClassId = Convert.ToInt32(Request.QueryString["classId"]); DataSource = sm.SelectAllstu(n); }
//触发gridview行的删除事件 protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { stuCourse n = new stuCourse(); StuCourseManage sm = new StuCourseManage(); GridViewRow gvr = GridView1.Rows[e.RowIndex]; n.StudentId = GridView1.DataKeys[e.RowIndex].Value.ToString(); //获取当前行主键id n.ClassId = Convert.ToInt32(Label6.Text); sm.DeleteStu(n); gridviewBind1(); gridviewBind(); //Response.Write(n.StudentId.ToString()); }
protected void btnmes_Click(object sender, EventArgs e) { StuCourseManage sm = new StuCourseManage(); stuCourse n = new stuCourse(); n.ClassId = Convert.ToInt32(Request.QueryString["classId"]); n.StudentId = TextBox1.Text.Trim(); n.Creater = Session["adminId"].ToString(); for (int i = 0; i < sm.SelectAllstu(n).Rows.Count; i++) { if (sm.SelectAllstu(n).Rows[i]["studentId"].ToString() == TextBox1.Text.Trim()) { return; } } sm.InsertStu(n); gridviewBind1(); gridviewBind(); }
void EntityDataSource() { StuCourseManage sm = new StuCourseManage(); stuCourse n = new stuCourse(); n.ClassId = Convert.ToInt32(Request.QueryString["classId"]); DataTable dt = sm.SelectAllstu(n); // 获取数据库中所有数据 DataSource.Rows.Clear(); // 清除数据源 for (int i = 0; i < dt.Rows.Count; i++) { DataRow row = DataSource.NewRow(); row["studentId"] = dt.Rows[i]["studentId"]; row["name"] = dt.Rows[i]["name"]; row["subject"] = dt.Rows[i]["subject"]; row["college"] = dt.Rows[i]["college"]; DataSource.Rows.Add(row); } gridviewBind(); }
private void gridviewBind() { StuHomeworkManage sm = new StuHomeworkManage(); StuCourseManage cm = new StuCourseManage(); DataTable dt = cm.SelectClassByStu(Session["studentId"].ToString()); DataColumn dc = new DataColumn(); HomeworkListManage hm = new HomeworkListManage(); dc.ColumnName = "noup"; dc.DataType = typeof(int); dt.Columns.Add(dc); for (int i = 0; i < dt.Rows.Count; i++) { int k; int tmp = Convert.ToInt32(dt.Rows[i]["classId"]); DataTable dd = hm.SelectTime(Convert.ToInt32(dt.Rows[i]["classId"])); stuHomework n = new stuHomework(); n.StudentId = Session["studentId"].ToString(); n.ClassId = Convert.ToInt32(dt.Rows[i]["classId"]); if (dd.Rows.Count != 0 && dd != null) { int t = Convert.ToInt32(dd.Rows[0][0]); if (sm.SelectCountByStu(n).Rows.Count == 0) { k = 0; } else { k = Convert.ToInt32(sm.SelectCountByStu(n).Rows[0][0]); } int y = t - k; dt.Rows[i]["noup"] = y; } } GridView1.DataSource = dt; GridView1.DataBind(); }