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