/// <summary>
/// 新增学生作业
/// </summary>
/// <param name="n">作业列表实体类</param>
/// <returns></returns>
public bool Insert(homeworkList n)
{
bool flag = false;
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@classId", n.ClassId),
new SqlParameter("@closeTime", n.CloseTime),
new SqlParameter("@content", n.Content),
new SqlParameter("@name", n.Name),
new SqlParameter("@publishTime", n.PublishTime),
new SqlParameter("@creater", n.Creater),
//new SqlParameter("@referenceAnswer",n.ReferenceAnswer ),
new SqlParameter("@modifier", n.Creater),
new SqlParameter("@remarks", n.Remarks),
new SqlParameter("@times", n.Times),
};
int res = sqlhelper.ExecuteNonQuery("INSERT INTO homeworkList (classId, closeTime, [content], name, publishTime,creater, modifier, remarks, times) VALUES (@classId,@closeTime,@content,@name,@publishTime,@creater,@creater,@remarks,@times)", paras, CommandType.Text);
if (res > 0)
{
flag = true;
}
return(flag);
}
/// <summary>
/// 更新学生作业
/// </summary>
/// <param name="n">作业列表实体类</param>
public void Update(homeworkList n)
{
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@classId", n.ClassId),
new SqlParameter("@closeTime", n.CloseTime),
new SqlParameter("@content", n.Content),
new SqlParameter("@name", n.Name),
new SqlParameter("@publishTime", n.PublishTime),
//new SqlParameter("@referenceAnswer",n.ReferenceAnswer ),
new SqlParameter("@modifier", n.Modifier),
new SqlParameter("@remarks", n.Remarks),
new SqlParameter("@times", n.Times),
};
sqlhelper.ExecuteQuery("UPDATE homeworkList SET closeTime = @closeTime,[content]=@content,name=@name,publishTime = @publishTime,modifier = @modifier,remarks=@remarks,lastmodify = getdate() where classId=@classId AND times=@times", paras, CommandType.Text);
}
/// <summary>
/// 删除作业
/// </summary>
/// <param name="n">作业列表实体类</param>
/// <returns></returns>
public bool DeleteHomework(homeworkList n)
{
bool flag = false;
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@classId", n.ClassId),
new SqlParameter("@times", n.Times),
};
int res = sqlhelper.ExecuteNonQuery("DELETE FROM homeworkList where classId=@classId AND times=@times", paras, CommandType.Text);
if (res > 0)
{
flag = true;
}
return(flag);
}
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);
}
protected void Button1_Click(object sender, EventArgs e)
{
homeworkList n = new homeworkList();
n.ClassId = Convert.ToInt32(Request.QueryString["classId"]);
n.Times = Convert.ToInt32(Label1.Text);
n.Name = txt1.Text.Trim();
n.Remarks = txt2.Text;
n.PublishTime = Convert.ToDateTime(txt3.Text.Trim());
n.CloseTime = Convert.ToDateTime(txt4.Text.Trim());
n.Creater = Session["teacherId"].ToString();
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;
hm.Insert(n);
ScriptManager.RegisterStartupScript(this, this.GetType(), "updateScript", "alert(\"新增成功\");", true);
}
/// <summary>
/// 删除作业
/// </summary>
/// <param name="n">作业列表实体类</param>
/// <returns></returns>
public bool DeleteHomework(homeworkList n)
{
return(ndao.DeleteHomework(n));
}
/// <summary>
/// 更新学生作业
/// </summary>
/// <param name="n">作业列表实体类</param>
/// <returns></returns>
public void Update(homeworkList n)
{
ndao.Update(n);
}
/// <summary>
/// 新增学生作业
/// </summary>
/// <param name="n">作业列表实体类</param>
/// <returns></returns>
public bool Insert(homeworkList n)
{
return(ndao.Insert(n));
}
