private void gridviewBind()
{
HomeworkListManage cm = new HomeworkListManage();
GridView1.DataSource = cm.SelectByClass(Convert.ToInt32(Request.QueryString["classId"]));
GridView1.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
HomeworkListManage hm = new HomeworkListManage();
homeworkList n = new homeworkList();
n.ClassId = Convert.ToInt32(Request.QueryString["classId"]);
n.Name = txt1.Text.Trim();
n.Remarks = txt2.Text.Trim();
n.PublishTime = Convert.ToDateTime(txt3.Text.Trim());
n.CloseTime = Convert.ToDateTime(txt4.Text.Trim());
string path = Server.MapPath("~/upload/" + Session["teacherId"].ToString() + "/" + Request.QueryString["classname"] + Request.QueryString["classId"] + "/第" + Label1.Text + "次作业/");
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
FileUpload1.SaveAs(path + FileUpload1.FileName);
n.Content = "~/upload/" + Session["teacherId"].ToString() + "/" + Request.QueryString["classname"] + Request.QueryString["classId"] + "/第" + Label1.Text + "次作业/" + FileUpload1.FileName;
n.Modifier = Session["teacherId"].ToString();
n.Times = Convert.ToInt32(Label1.Text);
hm.Update(n);
}
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();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["teacherId"] != null)
{
if (!IsPostBack)
{
HomeworkListManage hm = new HomeworkListManage();
Label6.Text = Request.QueryString["classId"];
Label7.Text = Request.QueryString["classname"];
Label8.Text = Request.QueryString["term"];
Label9.Text = Request.QueryString["name"];
DropDownList1.DataSource = hm.SelectByClass(Convert.ToInt32(Request.QueryString["classId"]));
DropDownList1.DataTextField = "times";
DropDownList1.DataValueField = "name";
DropDownList1.DataBind();
Label10.Text = DropDownList1.SelectedValue;
gridviewBind();
}
}
else
{
Response.Redirect("../login.aspx");
}
}
