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