protected void DlstStudentGradeCheckDataBind() { DalOperationAboutGradeCheck dal = new DalOperationAboutGradeCheck(); //DataView dv = dal.GetUpdateTimeByStudentNo(studentNo).Tables[0].DefaultView; //this.dlstStudentGradeCheck.DataSource = dv; //this.dlstStudentGradeCheck.DataBind(); DataTable dt = dal.GetGradeCheckNotify().Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["notifyTitle"].ToString().Trim().Length > 0) { notifyTitle.NavigateUrl = "~/Common/ViewGradeCheckNotify.aspx?keepThis=true&TB_iframe=true&height=500&width=800"; notifyTitle.CssClass = "thickbox"; notifyTitle.Text = dt.Rows[i]["notifyTitle"].ToString().Trim() + "(点击查看重修重考详细通知)"; notifyTitle.ToolTip = dt.Rows[i]["notifyTitle"].ToString().Trim(); } } //dlstStudentGradeCheckDataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DalOperationAboutGradeCheck dal = new DalOperationAboutGradeCheck(); DataTable dt = dal.GetStudentGradeCheckApplyById(gradeCheckApplyId).Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { ltlTermTag.Text = CommonUtility.ChangeTermToString(dt.Rows[i]["termTag"].ToString().Trim()); ltlCourseName.Text = dt.Rows[i]["courseName"].ToString().Trim() + "(" + dt.Rows[i]["ClassID"].ToString().Trim() + ")"; if (dt.Rows[i]["gradeCheckApplyType"].ToString().Trim() == "重修") { ddlGradeCheckApplyType.Items.Add(new ListItem("重修", "重修")); ddlGradeCheckApplyType.Items.Add(new ListItem("重考", "重考")); } else { ddlGradeCheckApplyType.Items.Add(new ListItem("重考", "重考")); ddlGradeCheckApplyType.Items.Add(new ListItem("重修", "重修")); } txtapplyChecKSuggestion.Text = dt.Rows[i]["applyChecKSuggestion"].ToString().Trim(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DalOperationAboutGradeCheck doan = new DalOperationAboutGradeCheck(); //检测是否有重名规则 string _name = txtGradeCheckItemName.Text.Trim(); if (doan.CheckIsExistGradeCheckItemName(_name).Tables[0].Rows.Count > 0) { Javascript.GoHistory(-1, "已经存在此名称的规则,请更换规则名或者在已有规则上修改所应用的学年即可!", Page); return; } DataTable dt = doan.GetTermYear().Tables[0]; //for (int i = 0; i < dt.Rows.Count; i++) //{ // ddlTermYear.Items.Add(new ListItem("20" + dt.Rows[i]["termYear"].ToString().Trim() + "学年", dt.Rows[i]["termYear"].ToString().Trim())); //} if (dt.Rows[0]["termYear"].ToString().Trim().Length > 0) { dt.Columns.Add("termYearFormat", typeof(string), "'20'+termYear+'学年'"); ddlTermYears.DataSource = dt; ddlTermYears.DataTextField = "termYearFormat"; ddlTermYears.DataValueField = "termYear"; ddlTermYears.DataBind(); } } }
//绑定搜索的课程信息 public void DataBindSearchCourse() { DalOperationAboutGradeCheck dal = new DalOperationAboutGradeCheck(); // Response.Write(ddlCourses.SelectedValue); DataTable dt = dal.GetAllStudentGradeCheckApply(ddlCourses.SelectedValue == "all" ? "all_" + ddlTermTags.SelectedValue : ddlCourses.SelectedValue, ddlApplyResult.SelectedValue, ddlApplyLocale.SelectedValue).Tables[0]; DataView dv = dt.DefaultView; this.AspNetPager1.RecordCount = dv.Count; PagedDataSource pds = new PagedDataSource(); //定义一个PagedDataSource类来执行分页功 pds.DataSource = dv; pds.AllowPaging = true; pds.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1; pds.PageSize = CommonUtility.pageSize; this.dlstGradeCheckApply.DataSource = pds; this.dlstGradeCheckApply.DataBind(); if (dt.Rows.Count == 0) { this.dlstGradeCheckApply.ShowFooter = true; } else { this.dlstGradeCheckApply.ShowFooter = false; } }
public void DataBindSearchTermNormTagList() { DalOperationAboutGradeCheck dal = new DalOperationAboutGradeCheck(); DataTable dt = dal.GetTermYear().Tables[0]; string termTag = null; for (int i = 0; i < dt.Rows.Count; i++) { termTag = dt.Rows[i]["termYear"].ToString().Trim(); ListItem li = new ListItem("20" + termTag, termTag); this.ddltNormTerm.Items.Add(li); } }
protected void Page_Load(object sender, EventArgs e) { if(!IsPostBack) { DalOperationAboutGradeCheck dal = new DalOperationAboutGradeCheck(); DataTable dt = dal.GetGradeCheckNotify().Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { ltlNotifyTitle.Text = dt.Rows[i]["notifyTitle"].ToString().Trim(); ltlNotifyContent.Text = dt.Rows[i]["notifyContent"].ToString().Trim(); attachmentIds = dt.Rows[i]["attachmentIds"].ToString().Trim(); } } }
protected void btnNotAccord_Click(object sender, EventArgs e) { DalOperationAboutGradeCheck dal = new DalOperationAboutGradeCheck(); try { dal.UpdateStudentGradeCheckApplyState("不符合", txtapplyChecKSuggestion.Text.Trim(), gradeCheckApplyId); Javascript.RefreshParentWindow("修改重修重考申请状态成功!", "/Administrator/StudentManager.aspx?fragment=2", Page); } catch (Exception ex) { MongoDBLog.LogRecord(ex); Javascript.GoHistory(-1, "修改重修重考申请状态失败,请检查格式是否有误!", Page); } }
protected void deleteGradeCheckApplyById() { DalOperationAboutGradeCheck doan = new DalOperationAboutGradeCheck(); int _gradeCheckApplyId = -1; if (Request["action"] != null && Request["action"].Trim() == "delete" && CommonUtility.SafeCheckByParams<string>(Request["gradeCheckApplyId"],ref _gradeCheckApplyId)) { if (!this.isAllowTime()) { Javascript.GoHistory(-1, "当前暂未开放办理重修重考", Page); return; } doan.DeleteStudentGradeCheckApplyById(_gradeCheckApplyId, studentNo); Javascript.AlertAndRedirect("删除成功!", "/Student/MyGradeCheckManage.aspx", Page); } }
//修改 protected void btnUpdate_Click(object sender, EventArgs e) { DalOperationAboutGradeCheck dalOperationAboutGradeCheck = new DalOperationAboutGradeCheck(); string _name = txtGradeCheckItemName.Text.Trim(); if (dalOperationAboutGradeCheck.CheckIsExistGradeCheckItemName(_name, gradeCheckId).Tables[0].Rows.Count > 0) { Javascript.GoHistory(-1, "已经存在此名称的规则,请更换规则名或者在已有规则上修改所应用的学年即可!", Page); return; } if (txtGradeCheckItemName.Text.Trim().Length == 0) { Javascript.GoHistory(-1, "请输入成绩审核单项名称!", Page); } else { StudentsGradeCheck model = new StudentsGradeCheck(); model.gradeCheckItemName = txtGradeCheckItemName.Text.Trim(); model.gradeCheckItemDefaultValue = txtGradeCheckItemDefaultValue.Text.Trim(); model.gradeCheckId = gradeCheckId; model.displayOrder = int.Parse(txtDisplayOrder.Text.Trim()); List<string> items = new List<string>(); for (int i = 0; i < ddlTermYears.Items.Count; i++) { ListItem _item = ddlTermYears.Items[i]; if (_item.Selected) { items.Add(_item.Value); } } model.termYears = string.Join(",", items).Trim(); try { dalOperationAboutGradeCheck.UpdateGradeCheckItemById(model);//修改 Javascript.RefreshParentWindow("修改成绩审核单项成功!", "/Administrator/StudentManager.aspx?fragment=5", Page); } catch (Exception ex) { MongoDBLog.LogRecord(ex); Javascript.GoHistory(-1, "修改失败,请检查格式是否有误!", Page); } } }
protected void btnAdd_Click(object sender, EventArgs e) { DalOperationAboutGradeCheck dal = new DalOperationAboutGradeCheck(); string dtime = DateTime.Now.ToString(); using (TransactionScope scope = new TransactionScope()) { try { foreach (Control ctlTable in PlaceHolder1.Controls) { foreach (Control ctlTableRow in ctlTable.Controls) { foreach (Control ctlTableCell in ctlTableRow.Controls) { foreach (Control ctl in ctlTableCell.Controls) { if (ctl.GetType().ToString().Trim() == "System.Web.UI.WebControls.TextBox") { StudentsGradeCheckDetail model = new StudentsGradeCheckDetail(); model.studentNo = studentNo; model.updateTime = Convert.ToDateTime(dtime); model.gradeCheckDetailValue = ((TextBox)ctl).Text.Trim(); model.gradeCheckId = int.Parse(ctl.ID.Split("_".ToCharArray())[1]); dal.AddGradeCheckDetailByStudentNo(model); } } } } } StudentsGradeCheckConfirm model1 = new StudentsGradeCheckConfirm { studentNo = studentNo, updateTime = Convert.ToDateTime(dtime), isAccord = int.Parse(ddlIsAccord.SelectedValue), remark = remark.Text.Trim() }; dal.AddStudentGradeCheckConfirm(model1); scope.Complete(); Javascript.RefreshParentWindow("添加成绩审核记录成功!", "/Administrator/StudentManager.aspx?fragment=7&studentNo=" + studentNo, Page); } catch (Exception ex) { MongoDBLog.LogRecord(ex); Javascript.GoHistory(-1, "添加成绩审核记录失败!", Page); } finally { dal.conn.Close(); } } }
//初始化编辑页面 public void InitialNotifyEdit(int englishExamNotifyInfoId) { DalOperationAboutGradeCheck dalOperationAboutGradeCheck = new DalOperationAboutGradeCheck(); DataTable dt = dalOperationAboutGradeCheck.GetGradeCheckItemById(gradeCheckId).Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { txtGradeCheckItemName.Text = dt.Rows[i]["gradeCheckItemName"].ToString().Trim(); txtGradeCheckItemDefaultValue.Text = dt.Rows[i]["gradeCheckItemDefaultValue"].ToString().Trim(); txtDisplayOrder.Text = dt.Rows[i]["displayOrder"].ToString().Trim(); } DataTable dt1 = dalOperationAboutGradeCheck.GetTermYear().Tables[0]; //for (int i = 0; i < dt.Rows.Count; i++) //{ // ddlTermYear.Items.Add(new ListItem("20" + dt.Rows[i]["termYear"].ToString().Trim() + "学年", dt.Rows[i]["termYear"].ToString().Trim())); //} string termYears = dt.Rows[0]["termYears"].ToString().Trim(); dt1.Columns.Add("termYearFormat", typeof(string), "'20'+termYear+'学年'"); ddlTermYears.DataSource = dt1; ddlTermYears.DataTextField = "termYearFormat"; ddlTermYears.DataValueField = "termYear"; ddlTermYears.DataBind(); string[] items = termYears.Split(",".ToCharArray()); for (int i = 0; i < ddlTermYears.Items.Count; i++) { ListItem _item = ddlTermYears.Items[i]; for (int j = 0; j < items.Length; j++) { if (_item.Value == items[j].Trim()) { _item.Selected = true; break; } } } }
//修改 protected void btnAdd_Click(object sender, EventArgs e) { if (txtGradeCheckItemName.Text.Trim().Length == 0) { Javascript.GoHistory(-1, "请输入成绩审核单项名称!", Page); } else { DalOperationAboutGradeCheck dalOperationAboutGradeCheck = new DalOperationAboutGradeCheck(); StudentsGradeCheck model = new StudentsGradeCheck(); model.gradeCheckItemName = txtGradeCheckItemName.Text.Trim(); model.gradeCheckItemDefaultValue = txtGradeCheckItemDefaultValue.Text.Trim(); model.displayOrder = int.Parse(txtDisplayOrder.Text.Trim()); List<string> items = new List<string>(); for (int i = 0; i < ddlTermYears.Items.Count; i++) { ListItem _item = ddlTermYears.Items[i]; if (_item.Selected) { items.Add(_item.Value); } } model.termYears = string.Join(",", items).Trim(); try { dalOperationAboutGradeCheck.AddGradeCheckItems(model);//修改 Javascript.RefreshParentWindow("添加成绩审核单项成功!", "/Administrator/StudentManager.aspx?fragment=5", Page); } catch (Exception ex) { MongoDBLog.LogRecord(ex); Javascript.GoHistory(-1, "添加成绩审核单项失败,请检查格式是否有误!", Page); } } }
//======== protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //控制Tab的显示 if (Request["fragment"] != null) { fragmentFlag = Request["fragment"]; } CommonUtility.ShowLiControl(fragmentFlag, liFragment1, liFragment2, liFragment3, liFragment4 , liFragment5, liFragment6, liFragment7, liFragment8, liFragment9, divFragment1, divFragment2, divFragment3, divFragment4, divFragment5, divFragment6, divFragment7, divFragment8, divFragment9); if (fragmentFlag.Equals("1")) { startTime.Attributes.Remove("class"); endTime.Attributes.Remove("class"); DalOperationAboutGradeCheck doan = new DalOperationAboutGradeCheck(); DataTable dt = doan.GetTermYear().Tables[0]; ddlSearchYear.Items.Add(new ListItem("所有", "all")); for (int i = 0; i < dt.Rows.Count; i++) { ddlSearchYear.Items.Add(new ListItem("20" + dt.Rows[i]["termYear"].ToString().Trim() + "学年", dt.Rows[i]["termYear"].ToString().Trim())); } if (!string.IsNullOrEmpty(_ddlSearchYear)) { for (int i = 0; i < ddlSearchYear.Items.Count; i++) { if (ddlSearchYear.Items[i].Value == _ddlSearchYear.Trim()) { ddlSearchYear.SelectedIndex = i; break; } } } DalOperationStudentSpecility doss = new DalOperationStudentSpecility(); dt = doss.FindAllStudentSpecilitye().Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { ddlSearchMajor.Items.Add(new ListItem(dt.Rows[i]["specilityName"].ToString().Trim(), dt.Rows[i]["MajorTypeID"].ToString().Trim())); } if (!string.IsNullOrEmpty(_ddlSearchMajor)) { for (int i = 0; i < ddlSearchMajor.Items.Count; i++) { if (ddlSearchMajor.Items[i].Value == _ddlSearchMajor.Trim()) { ddlSearchMajor.SelectedIndex = i; break; } } } if (!string.IsNullOrEmpty(_ddlSearchYear) || (!string.IsNullOrEmpty(_ddlSearchMajor))) { GetSchoolClassList(); } if (!string.IsNullOrEmpty(_ddlSearchSchoolClass)) { for (int i = 0; i < ddlSearchSchoolClass.Items.Count; i++) { if (ddlSearchSchoolClass.Items[i].Value == _ddlSearchSchoolClass.Trim()) { ddlSearchSchoolClass.SelectedIndex = i; break; } } } if (!string.IsNullOrEmpty(_ddlGradeCheckDegree)) { for (int i = 0; i < ddlGradeCheckDegree.Items.Count; i++) { if (ddlGradeCheckDegree.Items[i].Value == _ddlGradeCheckDegree.Trim()) { ddlGradeCheckDegree.SelectedIndex = i; break; } } } if (!string.IsNullOrEmpty(_ddlGradeCheckLocale)) { for (int i = 0; i < ddlGradeCheckLocale.Items.Count; i++) { if (ddlGradeCheckLocale.Items[i].Value == _ddlGradeCheckLocale.Trim()) { ddlGradeCheckLocale.SelectedIndex = i; break; } } } if (!string.IsNullOrEmpty(_keyword)) { txtKeyword.Text = _keyword; } DataListBind(); } if (fragmentFlag.Equals("2")) { startTime.Attributes.Remove("class"); endTime.Attributes.Remove("class"); DataBindTermTagList(); DataBindSearchCourse(); } if (fragmentFlag.Equals("3")) { //txtKeyword.Attributes.Add("class", "required"); DataListBindGradeCheckApplyReason(); } if (fragmentFlag.Equals("5")) { DalOperationAboutGradeCheck doan = new DalOperationAboutGradeCheck(); DataTable dt = doan.GetTermYear().Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { ddlTermYear.Items.Add(new ListItem("20" + dt.Rows[i]["termYear"].ToString().Trim() + "学年", dt.Rows[i]["termYear"].ToString().Trim())); } DataListBindGradeCheck(); } if (fragmentFlag.Equals("6")) { DalOperationAboutGradeCheck doan = new DalOperationAboutGradeCheck(); DataTable dt = doan.GetTermYear().Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { ddlTermYearImportExcelData.Items.Add(new ListItem("20" + dt.Rows[i]["termYear"].ToString().Trim() + "学年", dt.Rows[i]["termYear"].ToString().Trim())); } } if (Request["studentNo"] != null && fragmentFlag.Equals("4")) { liFragment4.Visible = true; studentNo = Request["studentNo"]; //删除 if (Request["del"] == "true" && Request["courseNo"] != null && Request["coursesStudentsCorrelationId"] != null) { DalOperationAboutStudent dalw = new DalOperationAboutStudent(); string coursesStudentsCorrelationId = Request["coursesStudentsCorrelationId"].ToString().Trim(); dalw.DelChooseCourseByCoursesStudentsCorrelationId(coursesStudentsCorrelationId); } DalOperationAboutStudent dal = new DalOperationAboutStudent(); lblstudentName.Text = dal.GetStudentById(Request["studentNo"]).studentName; DalOperationAboutStudent dal1 = new DalOperationAboutStudent(); DataSet ds = dal1.GetCoursesByStudentNo(Request["studentNo"].ToString().Trim()); dlstcourses.DataSource = ds.Tables[0]; dlstcourses.DataBind(); } if (fragmentFlag.Equals("6")) { BindGradeCheckExcelTemplate(spanAttachment2, false); } if (Request["studentNo"] != null && fragmentFlag.Equals("7")) { liFragment7.Visible = true; studentNo = Request["studentNo"]; DlstStudentSchoolClassNameDataBind(); DlstStudentGradeCheckDataBind(); if (Request["action"] != null && Request["action"].ToString().Trim() == "delete") { dlstStudentGradeCheckDetail_Delete(); } } if (fragmentFlag.Equals("8")) { BindGradeCheckExcelTemplate(spanExcelTemplate, true); if (!IsPostBack) { Javascript.ExcuteJavascriptCode("initBeforeUnloadEvent('温馨提示:当前页面相关操作必须点击提交才能生效~(此为提示,并不代表您真正未保存数据),确定离开吗?');", Page); } } if (fragmentFlag.Equals("9")) { BindGradeCheckAllowTime(); BindGradeCheckNotify(); if (!IsPostBack) { txtNotifyTitle.CssClass = "required"; Javascript.ExcuteJavascriptCode("initBeforeUnloadEvent('温馨提示:当前页面数据可能未保存哟~(此为提示,并不代表您真正未保存数据),确定离开吗?');", Page); } } } if (fragmentFlag.Equals("1") || fragmentFlag.Equals("2") || fragmentFlag.Equals("6") || fragmentFlag.Equals("8") || fragmentFlag.Equals("9")) { startTime.Attributes.Remove("class"); endTime.Attributes.Remove("class"); } }
//判断是否是规定的办理时间范围 protected bool isAllowTime() { DalOperationAboutGradeCheck dalOperationAboutGradeCheck = new DalOperationAboutGradeCheck(); return dalOperationAboutGradeCheck.CheckGradeCheckAllowTime(); }
/// <summary> /// 获取动态表单元格 /// </summary> /// <returns></returns> protected string GetTableTd(string studentNo, DateTime updateTime) { StringBuilder sb = new StringBuilder(); DalOperationAboutGradeCheck dal = new DalOperationAboutGradeCheck(); foreach (int _key in listGradeCheckId) { DataTable dt = dal.GetGradeCheckDetailByGradeCheckIdAndStudentNoAndUpdateTime(_key, studentNo, updateTime).Tables[0]; if (dt.Rows.Count == 0) { sb.Append("<td width=\"6%\">" + ht[_key.ToString()] + "</td>"); } else { for (int i = 0; i < dt.Rows.Count; i++) { foreach (DictionaryEntry _item in ht) { if (_item.Key.ToString().Trim() == dt.Rows[i]["gradeCheckId"].ToString().Trim()) { sb.Append(string.Format("<td width=\"6%\">{0}</td>", dt.Rows[i]["gradeCheckDetailValue"].ToString().Trim())); } } } } } return sb.ToString(); }
/// <summary> /// 获取动态表头 /// </summary> /// <returns></returns> protected string GetTableHeader() { StringBuilder sb = new StringBuilder(); DalOperationAboutGradeCheck dal = new DalOperationAboutGradeCheck(); DataTable dt = dal.GetGradeCheckItemsByTermYear(ddlSearchYear.SelectedValue).Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { sb.Append(string.Format("<th width=\"6%\">{0}</th>",dt.Rows[i]["gradeCheckItemName"].ToString().Trim())); listGradeCheckId.Add(int.Parse(dt.Rows[i]["gradeCheckId"].ToString().Trim())); ht.Add(dt.Rows[i]["gradeCheckId"].ToString().Trim(), dt.Rows[i]["gradeCheckItemDefaultValue"].ToString().Trim()); } return sb.ToString(); }
//展现确认无疑问、确认有疑问等按钮 protected string DisplayConfirmPanel(int itemIndex, DateTime updateTime) { StringBuilder sb = new StringBuilder(); DalOperationAboutGradeCheck dal = new DalOperationAboutGradeCheck(); DataTable dt = dal.GetStudentGradeCheckConfirmRecordNum(studentNo, updateTime).Tables[0]; int recordNum = dt.Rows.Count; if (recordNum > 0) { sb.Append("<br />当前状态:确认无疑问 "); } else { sb.Append("<br />当前状态:暂未确认 "); } return sb.ToString(); }
protected string GetGradeCheckDetailByGradeCheckId(int gradeCheckId) { DalOperationAboutGradeCheck dalOperationAboutGradeCheck = new DalOperationAboutGradeCheck(); DataSet ds = dalOperationAboutGradeCheck.GetGradeCheckItemById(gradeCheckId); string gradeCheckItemName = string.Empty; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { gradeCheckItemName = ds.Tables[0].Rows[i]["gradeCheckItemName"].ToString().Trim(); } return gradeCheckItemName + ":"; }
protected void Button3_Click(object sender, EventArgs e) { try { DalOperationAboutGradeCheck dal = new DalOperationAboutGradeCheck(); dal.UpdateGradeCheckExcelTemplate(hidAttachmentId1.Value); Javascript.AlertAndRedirect("更新重修重考Excel模板成功:)", "/Administrator/StudentManager.aspx?fragment=8", Page); } catch (Exception ex) { MongoDBLog.LogRecord(ex); Javascript.GoHistory(-1, "更新重修重考Excel模板失败:(", Page); return; } }
//绑定搜索到的学生数据到DataList protected void DataListBind() { tableHeader = this.GetTableHeader(); DalOperationAboutGradeCheck dos = new DalOperationAboutGradeCheck(); DataView dv = dos.SearchStudentsList(ddlSearchYear.SelectedValue, ddlSearchMajor.SelectedValue, ddlSearchSchoolClass.SelectedValue, txtKeyword.Text.Trim(),ddlGradeCheckLocale.SelectedValue,ddlGradeCheckDegree.SelectedValue).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.dlSearchStudent.DataSource = pds; this.dlSearchStudent.DataBind(); if (pds.Count == 0) { this.dlSearchStudent.ShowFooter = true; } else { this.dlSearchStudent.ShowFooter = false; } }
protected void dlstStudentGradeCheck_ItemDataBound(object sender, DataListItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { DataList dataList = (DataList)e.Item.FindControl("dlstStudentGradeCheckItem"); DataRowView rowv = (DataRowView)e.Item.DataItem; string updateTime = rowv["updateTime"].ToString().Trim(); DalOperationAboutGradeCheck dalOperationAboutGradeCheck = new DalOperationAboutGradeCheck(); //DataSet ds = dalOperationAboutGradeCheck.GetGradeCheckDetailByStudentNo(studentNo, updateTime); DataSet ds = dalOperationAboutGradeCheck.GetGradeCheckDetailByStudentNo(studentNo); dataList.DataSource = ds.Tables[0].DefaultView; dataList.DataBind(); if (dataList.Items.Count == 0) { dataList.ShowFooter = true; } else { dataList.ShowFooter = false; } } }
protected void dlstStudentGradeCheckDetail_Delete() { DalOperationAboutGradeCheck dal = new DalOperationAboutGradeCheck(); DateTime updateTime = DateTime.Now; if (!CommonUtility.SafeCheckByParams<string>(Request["updateTime"].ToString(), ref updateTime)) { Javascript.GoHistory(-1, "参数有误", Page); return; } try { dal.DeleteGradeCheckDetailByStudentNoAndUpdateTime(studentNo, updateTime); Javascript.RefreshParentWindow("删除成绩审核记录成功!", "/Administrator/StudentManager.aspx?fragment=7&studentNo=" + studentNo, Page); } catch (Exception ex) { MongoDBLog.LogRecord(ex); Javascript.GoHistory(-1, "删除成绩审核记录失败!", Page); } finally { dal.conn.Close(); } }
protected void DlstStudentGradeCheckDataBind() { DalOperationAboutGradeCheck dal = new DalOperationAboutGradeCheck(); DataView dv = dal.GetUpdateTimeByStudentNo(studentNo).Tables[0].DefaultView; this.dlstStudentGradeCheck.DataSource = dv; this.dlstStudentGradeCheck.DataBind(); }
protected void dlstGradeCheck_ItemCommand(object source, DataListCommandEventArgs e) { DalOperationAboutGradeCheck dos = new DalOperationAboutGradeCheck(); if (e.CommandName == "delete") { int gradeCheckId = int.Parse(dlstGradeCheck.DataKeys[e.Item.ItemIndex].ToString());//取选中行学生编号 if (dos.DeleteGradeCheckItemById(gradeCheckId) > 0) { Javascript.AlertAndRedirect("删除成功!", "/Administrator/StudentManager.aspx?fragment=5", Page); } else { Javascript.GoHistory(-1, "删除失败!", Page); } } }
protected string GetStudentGradeCheckConfirm(DateTime updateTime) { DalOperationAboutGradeCheck dalOperationAboutGradeCheck = new DalOperationAboutGradeCheck(); DataSet ds = dalOperationAboutGradeCheck.GetStudentGradeCheckConfirm(studentNo, updateTime); string isAccord = string.Empty; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { isAccord = ds.Tables[0].Rows[i]["isAccord"].ToString().Trim(); } return isAccord; }
protected string GetStudentGradeCheckConfirmAboutRemark(DateTime updateTime) { DalOperationAboutGradeCheck dalOperationAboutGradeCheck = new DalOperationAboutGradeCheck(); DataSet ds = dalOperationAboutGradeCheck.GetStudentGradeCheckConfirm(studentNo, updateTime); string remark = string.Empty; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { remark = ds.Tables[0].Rows[i]["remark"].ToString().Trim(); } return remark; }
protected void DlstStudentSchoolClassNameDataBind() { DalOperationAboutGradeCheck dal = new DalOperationAboutGradeCheck(); DataView dv = dal.GetTermYearByStudentNo(studentNo).Tables[0].DefaultView; this.dlstStudentSchoolClassName.DataSource = dv; this.dlstStudentSchoolClassName.DataBind(); }
protected void DataListBindGradeCheck() { DalOperationAboutGradeCheck dal = new DalOperationAboutGradeCheck(); if (ddlTermYear.SelectedValue.Trim() == "all") { dlstGradeCheck.DataSource = dal.GetAllGradeCheckItems().Tables[0]; dlstGradeCheck.DataBind(); } else { dlstGradeCheck.DataSource = dal.GetGradeCheckItemsByTermYear(ddlTermYear.SelectedValue).Tables[0]; dlstGradeCheck.DataBind(); } }
public void ProcessRequest(HttpContext context) { CommonFunction.CheckUser(); context.Response.CacheControl = "no-cache"; string termTagCourseNoClassID = context.Server.UrlDecode(context.Request["termTagCourseNoClassID"]); string termTag = (context.Request["termTag"] == null ? string.Empty : context.Request["termTag"]); string courseName = (context.Request["courseName"] == null ? string.Empty : context.Server.UrlDecode(context.Request["courseName"])); string gradeCheckApplyExcel = System.Configuration.ConfigurationManager.AppSettings["GradeCheckApplyExcel"]; //StringBuilder sb = new StringBuilder(); HSSFWorkbook workbook = new HSSFWorkbook(); DalOperationAboutGradeCheck dal = new DalOperationAboutGradeCheck(); //// Response.Write(ddlCourses.SelectedValue); DataTable dt = dal.GetAllStudentGradeCheckApply(termTagCourseNoClassID, "all","all").Tables[0]; //创建WorkSheet HSSFSheet sheet1 = workbook.CreateSheet(CommonUtility.ChangeTermToString(termTag) + "_" + courseName); sheet1.CreateRow(0).CreateCell(0).SetCellValue("序号"); sheet1.CreateRow(0).CreateCell(1).SetCellValue("学号"); sheet1.CreateRow(0).CreateCell(2).SetCellValue("姓名"); sheet1.CreateRow(0).CreateCell(3).SetCellValue("专业"); sheet1.CreateRow(0).CreateCell(4).SetCellValue("班级"); sheet1.CreateRow(0).CreateCell(5).SetCellValue("手机号"); sheet1.CreateRow(0).CreateCell(6).SetCellValue("邮件地址"); sheet1.CreateRow(0).CreateCell(7).SetCellValue("所属学期"); sheet1.CreateRow(0).CreateCell(8).SetCellValue("课程名称"); sheet1.CreateRow(0).CreateCell(9).SetCellValue("重修重考类型"); sheet1.CreateRow(0).CreateCell(10).SetCellValue("审核结果"); sheet1.CreateRow(0).CreateCell(11).SetCellValue("备注"); int drRowCount = dt.Rows.Count; for (int i = 0; i < drRowCount; i++) { sheet1.CreateRow(i + 1).CreateCell(0).SetCellValue(i + 1); sheet1.CreateRow(i + 1).CreateCell(1).SetCellValue(dt.Rows[i]["studentNo"].ToString().Trim()); sheet1.CreateRow(i + 1).CreateCell(2).SetCellValue(dt.Rows[i]["studentName"].ToString().Trim()); sheet1.CreateRow(i + 1).CreateCell(3).SetCellValue(dt.Rows[i]["studentSpeciality"].ToString().Trim()); sheet1.CreateRow(i + 1).CreateCell(4).SetCellValue(dt.Rows[i]["SchoolClassName"].ToString().Trim()); sheet1.CreateRow(i + 1).CreateCell(5).SetCellValue(dt.Rows[i]["mobileNo"].ToString().Trim()); sheet1.CreateRow(i + 1).CreateCell(6).SetCellValue(dt.Rows[i]["emailAddress"].ToString().Trim()); sheet1.CreateRow(i + 1).CreateCell(7).SetCellValue(CommonUtility.ChangeTermToString(termTag)); sheet1.CreateRow(i + 1).CreateCell(8).SetCellValue(courseName); sheet1.CreateRow(i + 1).CreateCell(9).SetCellValue(dt.Rows[i]["gradeCheckApplyType"].ToString().Trim()); sheet1.CreateRow(i + 1).CreateCell(10).SetCellValue(dt.Rows[i]["applyResult"].ToString().Trim()); sheet1.CreateRow(i + 1).CreateCell(11).SetCellValue(dt.Rows[i]["applyChecKSuggestion"].ToString().Trim()); } string fileName = CommonUtility.ChangeTermToString(termTag) + "_" + courseName + UploadFiles.DateTimeString(); if (!Directory.Exists(context.Server.MapPath(gradeCheckApplyExcel))) { Directory.CreateDirectory(context.Server.MapPath(gradeCheckApplyExcel)); } System.IO.FileStream file = new System.IO.FileStream(HttpContext.Current.Server.MapPath(gradeCheckApplyExcel + fileName + ".xls"), System.IO.FileMode.Create); workbook.Write(file); file.Dispose(); ////插入值 FileInfo DownloadFile = new FileInfo(context.Server.MapPath(gradeCheckApplyExcel + fileName + ".xls")); context.Response.Clear(); context.Response.ClearHeaders(); context.Response.Buffer = false; Encoding code = Encoding.GetEncoding("gb2312"); context.Response.ContentEncoding = Encoding.UTF8; context.Response.HeaderEncoding = code;//这句很重要 context.Response.ContentType = "application/octet-stream"; context.Response.AppendHeader("Content-Disposition", "attachment;filename=" + fileName + ".xls"); context.Response.AppendHeader("Content-Length", DownloadFile.Length.ToString()); context.Response.WriteFile(DownloadFile.FullName); if (File.Exists(context.Server.MapPath(gradeCheckApplyExcel + fileName + ".xls"))) { File.Delete(context.Server.MapPath(gradeCheckApplyExcel + fileName + ".xls")); } context.Response.Flush(); }
protected string GetGradeCheckApplyInfo(DateTime updateTime) { StringBuilder sb = new StringBuilder(); DalOperationAboutGradeCheck dal = new DalOperationAboutGradeCheck(); //DataTable dt = dal.GetStudentGradeCheckApplyByStudentNoAndUpdateTime(studentNo, updateTime).Tables[0]; DataTable dt = dal.GetStudentGradeCheckApplyByStudentNo(studentNo).Tables[0]; if (dt.Rows.Count > 0) { sb.Append("<br /><b>当前已申请的重修重考记录:</b><br />"); } int rowsCount = dt.Rows.Count; for (int i = 0; i < rowsCount; i++) { sb.Append("<table class=\"datagrid2\"><th>详细信息</th>"); sb.Append("<tr><td>所属学期:" + CommonUtility.ChangeTermToString(dt.Rows[i]["termTag"].ToString().Trim()) + "</td></tr><tr><td>课程名称:" + dt.Rows[i]["courseName"].ToString().Trim() + "</td></tr><tr><td>申请时间:" + dt.Rows[i]["updateTime"].ToString().Trim() + "</td></tr><tr><td>审核结果:" + (string.IsNullOrEmpty(dt.Rows[i]["applyResult"].ToString().Trim()) ? "未处理" : dt.Rows[i]["applyResult"].ToString().Trim()) + "</td></tr><tr><td>审核意见:" + dt.Rows[i]["applyChecKSuggestion"].ToString().Trim() + "</td></tr>"); sb.Append("</table>"); } return sb.ToString(); }