protected void commit_Click(object sender, EventArgs e)
{
UserCookiesInfo UserCookiesInfo = BllOperationAboutUser.GetUserCookiesInfo();
Experiments experiments = new Experiments
{
experimentId = experimentId,
updateTime=DateTime.Now,
experimentResourceId = experimentResourcesIdt,
studentNo=UserCookiesInfo.userNo,
isCheck=false,
isExcellent=false,
remark="",
checkTime=DateTime.Now,
excellentTime=DateTime.Now
};
if (hidAttachmentId.Value.Length != 0)
{
experiments.attachmentId = hidAttachmentId.Value;
}
else
{
Javascript.Alert("请上传附件！", Page);
return;
}
DalOperationAboutExperiment dalOperationAboutExperiment=new DalOperationAboutExperiment();
dalOperationAboutExperiment.UpdateExperiment(experiments);
Javascript.RefreshParentWindow("修改成功！", "CInfoExperiment.aspx?experimentResourceId=" + experiments.experimentResourceId + "courseNo=" + Request["courseNo"], Page);
}
//提交批阅信息--评语和实验分数
protected void btnUpdate_Click(object sender, EventArgs e)
{
float score = 0;
if (CommonUtility.SafeCheckByParams<string>(txtScore.Text.Trim(), ref score))
{
if (!CommonUtility.CheckScoreScope(ref score))
{
Javascript.Alert("请输入0-100之间的分数", Page);
return;
}
int attachmentId = 0;
if (hidAttachmentId.Value.CompareTo(string.Empty) != 0)
{
attachmentId = int.Parse(hidAttachmentId.Value);
}
DalOperationAboutExperiment doae = new DalOperationAboutExperiment();
doae.CheckExperimentByexperimentId(int.Parse(Request["experimentId"].Trim()), CommonUtility.JavascriptStringFilter(txtRemark.Text.Trim()), score.ToString(), attachmentId);
Response.Redirect("VExpRExperimentSubed.aspx?page="+pageIndex+"&experimentResourceId=" + Request["experimentResourceId"] + "&courseNo=" + Request["courseNo"] + "&classID=" + Server.UrlEncode(Server.UrlDecode(Request["classID"])) + "&termtag=" + Request["termtag"]);
}
else
{
Javascript.Alert("请输入数字！", Page);
}
}
protected void btnExperiment_Click(object sender, EventArgs e)
{
int experimentResourceId = int.Parse(Request["experimentResourceId"]);
UserCookiesInfo UserCookiesInfo = BllOperationAboutUser.GetUserCookiesInfo();
DalOperationAboutExperiment DalOperationAboutExperiment = new DalOperationAboutExperiment();
Experiments experiment = new Experiments
{
studentNo = UserCookiesInfo.userNo,
experimentResourceId = experimentResourceId,
updateTime = DateTime.Now,
};
if (hidAttachmentId.Value.CompareTo(string.Empty) != 0)
{
experiment.attachmentId = hidAttachmentId.Value;
}
else
{
Javascript.Alert("请上传附件！", Page);
return;
}
DalOperationAboutExperiment.SubmitExperiment(experiment);
Javascript.AlertAndRedirect("提交成功！", "CInfoExperiment.aspx?experimentResourceId=" + experiment.experimentResourceId + "&courseNo=" + Request["courseNo"] + "&classID=" + Server.UrlEncode(Server.UrlDecode(Request["classID"])) + "&termtag=" + Request["termtag"], Page);
}
protected void Page_Load(object sender, EventArgs e)
{
Master.ShowLiControl(this.Page, "liFragment2");
if (CommonUtility.SafeCheckByParams<string>(Request["experimentResourceId"], ref Master.experimentResourceId))
{
//设置优秀实验操作--start
if (Request["excellent"] != null && Request["studentNo"] != null)
{
DalOperationAboutExperiment doae = new DalOperationAboutExperiment();
if (Request["excellent"].ToString().Trim().Equals("true"))
{
doae.UpdateExperimentByexperimentResourceIdAndStudentNo(Master.experimentResourceId, Request["studentNo"].ToString().Trim(), 1);//设置为1：优秀实验
}
else if (Request["excellent"].ToString().Trim().Equals("false"))
{
doae.UpdateExperimentByexperimentResourceIdAndStudentNo(Master.experimentResourceId, Request["studentNo"].ToString().Trim(), 0);//设置为0：非优秀实验
}
}
//设置优秀实验操作--end
//提交列表
DataBindExperments(Master.experimentResourceId);
}
else
{
Javascript.GoHistory(-1, Page);
return;
}
}
//绑定提交实验列表
public void DataBindExperments(int experimentResourceId)
{
DalOperationAboutExperiment dalOperationAboutExperiment = new DalOperationAboutExperiment();
string studentName = txtNameSearch.Text;
DataView dv = null;
if ((txtlow.Text != null && txtlow.Text.Length > 0) || (txthigh.Text != null && txthigh.Text.Length > 0))
{
float low = (txtlow.Text == null || txtlow.Text.Equals("")) ? float.MinValue : float.Parse(txtlow.Text.Trim());
float high = (txthigh.Text == null || txtlow.Text.Equals("")) ? float.MaxValue : float.Parse(txthigh.Text.Trim());
dv = dalOperationAboutExperiment.GetExperimentsByResourcesId(experimentResourceId,studentName,low,high).Tables[0].DefaultView;
}
else
{
dv = dalOperationAboutExperiment.GetExperimentsByResourcesId(experimentResourceId,studentName).Tables[0].DefaultView;
}
this.AspNetPager2.RecordCount = dv.Count;
PagedDataSource pds = new PagedDataSource(); //定义一个PagedDataSource类来执行分页功
pds.DataSource = dv;
pds.AllowPaging = true;
pds.CurrentPageIndex = pageIndex - 1;
pds.PageSize = CommonUtility.pageSize; ;
this.ddlstExp.DataSource = pds;
this.ddlstExp.DataBind();
if (pds.Count > 0) {
this.ddlstExp.ShowFooter = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
Response.CacheControl = "no-cache";
if (!IsPostBack)
{
Javascript.ExcuteJavascriptCode("window.onbeforeunload= function(){if($.trim($('#hidOriginalAttachmentId').val())!=$.trim($('#hidAttachmentId').val())){return '温馨提示：实验数据可能未保存哟~（此为提示，并不代表您真正未保存实验数据，请在完成附件上传后点击提交，确保顺利提交实验）';}}", Page);
HtmlControl liControl = (HtmlControl)Master.Master.FindControl("ContentPlaceHolder1").FindControl("liFragment9");
liControl.Visible = true;
liControl.Attributes.Add("class", "ui-tabs-selected");
UserCookiesInfo UserCookiesInfo = BllOperationAboutUser.GetUserCookiesInfo();
//设置实验资源ID
int experimentResourceId = -1;
if (CommonUtility.SafeCheckByParams<string>(Request["experimentResourceId"], ref experimentResourceId))
{
DalOperationAboutExperimentResources DalOperationAboutExperimentResources = new DalOperationAboutExperimentResources();
DataSet dsExperimentResource = DalOperationAboutExperimentResources.GetExperimentResourcesById(experimentResourceId);
dlstExperiment.DataSource = dsExperimentResource.Tables[0];
dlstExperiment.DataBind();
DateTime deadLine = Convert.ToDateTime(dsExperimentResource.Tables[0].Rows[0]["deadLine"].ToString());
DalOperationAboutExperiment DalOperationAboutExperiment = new DalOperationAboutExperiment();
int experimentId = 0;
bool checkOR = false;
if (checkOR)
{
experimentspan.InnerHtml += "已经批阅！";
btnExperiment.Visible = false;
return;
}
else if (deadLine.CompareTo(DateTime.Now) <= 0)
{
experimentspan.InnerHtml += "已过截止日期！";
btnExperiment.Visible = false;
return;
}
if (DalOperationAboutExperiment.ExperimentIsCommit(UserCookiesInfo.userNo, experimentResourceId, ref experimentId, ref checkOR))
{
string attachmentids = DalOperationAboutExperiment.GetExperimentById(experimentId).attachmentId.ToString();
hidAttachmentId.Value = attachmentids;
hidOriginalAttachmentId.Value = attachmentids;
experimentspan.InnerHtml = "已提交实验文件列表<br/><br />" + GetSchoolAttachmentsURL(attachmentids);
}
experimentspan.InnerHtml += "<input id=\"Button3\" type=\"button\" value=\"点击添加一个附件，可添加多个\" onclick=\"addIframe(" + (int)FileFolderType.experiments + ");\" /> <b>上传文件大小不超过</b>" + ConfigurationManager.AppSettings["uploadFileLimit"] + "<div id=\"iframes\"></div>";
}
}
}
//绑定实验信息
public void DataBindExperment(int experimentId)
{
DalOperationAboutExperiment doae = new DalOperationAboutExperiment();
DataTable dt = doae.FindExperimentsByexperimentIdForCheck(experimentId).Tables[0];
lblNo.Text = dt.Rows[0]["studentNo"].ToString().Trim();
lblName.Text = dt.Rows[0]["studentName"].ToString().Trim();
txtRemark.Text = dt.Rows[0]["remark"].ToString().Trim();
txtScore.Text = dt.Rows[0]["score"].ToString().Trim();
if (int.TryParse(dt.Rows[0]["returnAttachmentId"].ToString().Trim(), out attachmentIds))
{
attachmentIds = int.Parse(dt.Rows[0]["returnAttachmentId"].ToString().Trim());
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request["courseNo"] == null)
{
Javascript.GoHistory(-1, Page);
return;
}
experimentId = 0;
if (CommonUtility.SafeCheckByParams<string>(Request["experimentId"], ref experimentId))
{
DalOperationAboutExperiment dalOperationAboutExperiment = new DalOperationAboutExperiment();
experiment = dalOperationAboutExperiment.GetExperimentById(experimentId);
experimentResourcesIdt = experiment.experimentResourceId;
}
else
{
Javascript.GoHistory(-1, Page);
}
}
//绑定未提交实验列表
public void DataBindNoExperments(int experimentResourceId)
{
DalOperationAboutExperiment dalOperationAboutNoExperiment = new DalOperationAboutExperiment();
string studentName = txtNameSearch.Text;
DataView dv = dalOperationAboutNoExperiment.GetNoExperimentsByResourcesId(experimentResourceId,studentName).Tables[0].DefaultView;
this.AspNetPager1.RecordCount = dv.Count;
PagedDataSource pds = new PagedDataSource(); //定义一个PagedDataSource类来执行分页功
pds.DataSource = dv;
pds.AllowPaging = true;
pds.CurrentPageIndex = pageIndex - 1;
pds.PageSize = CommonUtility.pageSize; ;
this.dlNoExp.DataSource = pds;
this.dlNoExp.DataBind();
if (pds.Count > 0)
{
this.dlNoExp.ShowFooter = false;
}
}
protected void submitExpriment_Click(object sender, EventArgs e)
{
UserCookiesInfo UserCookiesInfo = BllOperationAboutUser.GetUserCookiesInfo();
DalOperationAboutExperiment DalOperationAboutExperiment = new DalOperationAboutExperiment();
Experiments experiment = new Experiments
{
studentNo = UserCookiesInfo.userNo,
experimentResourceId = experimentResourceId,
updateTime = DateTime.Now,
};
if (hidAttachmentId.Value.CompareTo(string.Empty) != 0)
{
experiment.attachmentId = hidAttachmentId.Value;
}
else
{
Javascript.Alert("请上传附件！", Page);
return;
}
DalOperationAboutExperiment.SubmitExperiment(experiment);
Javascript.RefreshParentWindow("提交成功！","haha", Page);
}
private void ExperimentBind(string user, string courseNoTermTagClassID)
{
DalOperationAboutExperiment dale = new DalOperationAboutExperiment();
DataSet dsexperiment = dale.GetExperimentByStudentNo(user, courseNoTermTagClassID);
dlstMyExperiments.DataSource = dsexperiment.Tables[0];
dlstMyExperiments.DataBind();
}
protected void btnAddExperimentResource_Click(object sender, EventArgs e)
{
if (txtTitle.Text.Trim().Length != 0)
{
UserCookiesInfo UserCookiesInfo = BllOperationAboutUser.GetUserCookiesInfo();
DateTime deadline_t = Convert.ToDateTime(datepicker.Value);
if (deadline_t.CompareTo(DateTime.Now) > 0)
{
ExperimentResources ExperimentResources = new ExperimentResources
{
courseNo = Request["courseNo"].Trim(),
classID = Server.UrlDecode(Request["classID"].Trim()),
termTag = Request["termtag"].Trim(),
experimentResourceTitle = CommonUtility.JavascriptStringFilter(txtTitle.Text),
experimentResourceContent = Textarea1.Value,
deadLine = deadline_t,
updateTime = DateTime.Now,
attachmentIds = hidAttachmentId.Value
};
//添加课程实验并返回作业的自增长主键
using (TransactionScope scope = new TransactionScope())
{
DalOperationAboutExperimentResources DalOperationAboutExperimentResources = new DalOperationAboutExperimentResources();
ExperimentResources = DalOperationAboutExperimentResources.InsertExperimentResources(ExperimentResources);
//添加了课程实验以后,往提交表中添加记录
//查询出选课学生记录
DalOperationAboutExperiment doae = new DalOperationAboutExperiment();
DalOperationAboutCourses dalOperationAboutCourses = new DalOperationAboutCourses();
DataTable dt = dalOperationAboutCourses.FindStudentInfoByCourseNo(Request["courseNo"].ToString().Trim(),Server.UrlDecode(Request["classID"]),Request["termtag"]).Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
Experiments experiment = new Experiments
{
experimentResourceId = ExperimentResources.experimentResourceId,
studentNo = dt.Rows[i]["studentNo"].ToString().Trim(),
updateTime = DateTime.Now,
checkTime = DateTime.Now,
isExcellent = false,
remark = "",
excellentTime = DateTime.Now,
attachmentId = "0"
};
doae.InsertExperiment(experiment);
}
scope.Complete();
}
Javascript.RefreshParentWindow("添加成功!", "CInfoExperimentResource.aspx?courseNo=" + Request["courseNo"]+"&classID="+Server.UrlEncode(Server.UrlDecode(Request["classID"]))+"&termtag="+Request["termtag"], Page);
}
else
{
Javascript.Alert("截止时间不能在当前时间之前", Page);
}
}
else
{
Javascript.Alert("标题不能为空！", Page);
}
}
