protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DalOperationNorm daln = new DalOperationNorm(); DalOperationAboutTeacher dalt = new DalOperationAboutTeacher(); DalOperationAboutUserAuth dalua = new DalOperationAboutUserAuth(); UserAuth auth = dalua.GetUserAuth(pageName); DataSet ds = dalt.GetTeachers(); DataTable dt = new DataTable(); dt.Columns.Add("teacherNo"); dt.Columns.Add("teacherName"); if (auth != null) { if (auth.userIds != null) { foreach (string s in auth.userIds.Split(',')) { DataRow[] drs = ds.Tables[0].Select("teacherNo='" + s + "'"); if (drs.Length > 0) { DataRow dr = dt.NewRow(); dr.SetField("teacherNo", drs[0]["teacherNo"].ToString()); dr.SetField("teacherName", drs[0]["teacherName"].ToString()); dt.Rows.Add(dr); } } dsltAuthTeacher.DataSource = dt; } } dsltAuthTeacher.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DalOperationNorm dalOperationNorm = new DalOperationNorm(); if (Request["normId"] != null) { int normId = Convert.ToInt32(Request["normId"]); Norm norm = dalOperationNorm.getNormById(normId); if (norm != null) { this.hidNormId.Value = Convert.ToString(norm.normId); this.hidParentId.Value = Convert.ToString(norm.parentId); this.ddltNormType.SelectedValue = Convert.ToString(norm.type); Norm parent = null; if ((parent = dalOperationNorm.getNormById(norm.parentId)) != null) { this.parentName = parent.name; } this.TextNormName.Text = norm.name; this.TextComment.Text = norm.comment; } } } }
public void ProcessRequest(HttpContext context) { CommonFunction.CheckUser(); context.Response.CacheControl = "no-cache"; context.Response.ContentType = "text/plain"; string term = context.Request["term"]; string searchKey = context.Request["searchKey"].Trim(); string teacherType = context.Request["teacherType"].Trim(); DalOperationNorm dalnorm = new DalOperationNorm(); DataSet ds = dalnorm.getTeacherLoad(term, searchKey, teacherType); HSSFWorkbook workbook = new HSSFWorkbook(); for (int tableIndex = 0; tableIndex < ds.Tables.Count; tableIndex++) { HSSFSheet sheet = workbook.CreateSheet(ds.Tables[tableIndex].TableName); DataRowCollection drc = ds.Tables[tableIndex].Rows; for (int i = 0; i < ds.Tables[tableIndex].Columns.Count; i++) { sheet.CreateRow(0).CreateCell(i).SetCellValue(ds.Tables[tableIndex].Columns[i].ColumnName); } for (int i = 0; i < drc.Count; i++) { for (int j = 0; j < ds.Tables[tableIndex].Columns.Count; j++) { sheet.CreateRow(i + 1).CreateCell(j).SetCellValue(drc[i][j].ToString()); } } } string fileName = "norm"; System.IO.FileStream file = new System.IO.FileStream(HttpContext.Current.Server.MapPath(fileName + ".xls"), System.IO.FileMode.Create); workbook.Write(file); file.Dispose(); ////插入值 FileInfo DownloadFile = new FileInfo(context.Server.MapPath(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(fileName + ".xls"))) { File.Delete(context.Server.MapPath(fileName + ".xls")); } context.Response.Flush(); }
protected void btnSubmit_Click(object sender, EventArgs e) { Norm norm = new Norm(); norm.normId = Convert.ToInt32(hidNormId.Value); norm.name = TextNormName.Text; norm.comment = TextComment.Text; norm.parentId = Convert.ToInt32(hidParentId.Value); norm.type = Convert.ToInt32(ddltNormType.SelectedValue); DalOperationNorm dalOperationNorm = new DalOperationNorm(); dalOperationNorm.EditNorm(norm); Javascript.RefreshParentWindow("/Administrator/NormManager.aspx?fragment=2&term=" + Request["year"], Page); }
protected void Page_Load(object sender, EventArgs e) { if (Request["normId"] != null && Request["termYear"]!=null) { normIds = Request["normId"].Trim(); termYear = Request["termYear"].Trim(); DalOperationNorm dal = new DalOperationNorm(); this.dlstChildNorm.DataSource = dal.GetChildNorms(Convert.ToInt32(normIds),0,termYear); this.dlstChildNorm.DataBind(); } }
protected void btnSubmit_Click(object sender, EventArgs e) { DalOperationNorm dalOperationNorm = new DalOperationNorm(); Norm norm = new Norm(); norm.name = TextNormName.Text.Trim(); norm.comment = TextComment.Text.Trim(); norm.type = int.Parse(ddltNormType.SelectedValue); //if (parentId.Value != null && parentId.Value != "") //{ // norm.parentId = Convert.ToInt32(parentId.Value); //} //else //{ // norm.parentId = 0; //} if (Request["parentId"] == null || Request["parentId"]=="") { norm.parentId = 0; } else { norm.parentId = Convert.ToInt32(Request["parentId"]); } if (Request["year"] != null && !Request["year"].Trim().Equals("")) { norm.year = Request["year"].Trim(); if (norm.parentId == -1) { if ("课程名称".Equals(norm.name) || "学期".Equals(norm.name) || "类型".Equals(norm.name) || "理论课时".Equals(norm.name) || "实验课时".Equals(norm.name)) { Javascript.Alert("此指标名称在硕士教学中已经存在,不能重复添加!", Page); return; } } if (dalOperationNorm.ExistNormName(TextNormName.Text.Trim(),norm.parentId , norm.year)) { Javascript.Alert("存在此指标名称,不能重复输入", Page); return; } dalOperationNorm.AddNorm(norm); Javascript.RefreshParentWindow("/Administrator/NormManager.aspx?fragment=2&term=" + Request["year"], Page); } else { Javascript.RefreshParentWindow("/Administrator/NormManager.aspx?fragment=2", Page); } }
protected void btnCommit_Click(object sender, EventArgs e) { DalOperationNorm daln = new DalOperationNorm(); NormConfirm ncom = new NormConfirm { teacherNo = Request["teacherNo"].Trim(), term = Request["term"].Trim(), question = txtproblem.Text, type = 1, value = Request["value"].Trim(), answer = "" }; daln.AddNormConfirm(ncom); Javascript.RefreshParentWindow("/Teacher/NormView.aspx", Page); }
protected void Page_Load(object sender, EventArgs e) { DalOperationNorm dalOperationNorm = new DalOperationNorm(); if (Request["parentId"] != null && Request["parentId"]!="") { int parentId = Convert.ToInt32(Request["parentId"]); Norm norm = dalOperationNorm.getNormById(parentId); if (norm != null) { this.parentId.Value = Convert.ToString(norm.normId); parentName = norm.name; } } }
protected void btnConfirm_Click(object sender, EventArgs e) { UserCookiesInfo UserCookiesInfo = BllOperationAboutUser.GetUserCookiesInfo(); DalOperationNorm dalOperationNorm = new DalOperationNorm(); NormConfirm nc = new NormConfirm{ term=term, teacherNo = UserCookiesInfo.userNo, question="OK", answer="", value = GetNormValue(0), type = 0, }; dalOperationNorm.AddNormConfirm(nc); Javascript.JavaScriptLocationHref("/Teacher/NormView.aspx", Page); }
protected void btnCommit_Click(object sender, EventArgs e) { NormFormula normformula = new NormFormula { targetNormId = Convert.ToInt32(Request["normId"].ToString().Trim()), formula = this.formula.Value, formulaShow = this.TextNormFormula.Value, termYear = termYear }; DalOperationNorm dal = new DalOperationNorm(); dal.setFormula(normformula); NormFormula rootformula = dal.GetFormula(0,termYear); DalOperationAboutTeacher dalteacher = new DalOperationAboutTeacher(); DataSet dsTeacher = dalteacher.GetTeachers(); for (int i = 0; i < dsTeacher.Tables[0].Rows.Count; i++) { string teacherNo = dsTeacher.Tables[0].Rows[i]["teacherNo"].ToString().Trim(); if (normformula != null) { dal.Execute(normformula, teacherNo,termYear); } if (rootformula != null) { dal.Execute(rootformula, teacherNo, termYear); } } string t = "template"; if (normformula != null) { dal.Execute(normformula, t, termYear); } if (rootformula != null) { dal.Execute(rootformula, t, termYear); } Javascript.RefreshParentWindow("/Administrator/NormManager.aspx?fragment=2&&term=" + Request["termYear"], Page); }
protected void dsltAuthTeacher_OnItemCommand(object source, DataListCommandEventArgs e) { string teacherNoSelect = this.dsltAuthTeacher.DataKeys[e.Item.ItemIndex].ToString();//取选中行教师编号 if (e.CommandName.Equals("remove")) { DalOperationNorm dalOperationNorm = new DalOperationNorm(); DalOperationAboutUserAuth dalua = new DalOperationAboutUserAuth(); UserAuth userAuth = dalua.GetUserAuth(pageName); string[] ids = userAuth.userIds.Split(','); List<string> list = new List<string>(); for (int i = 0; i < ids.Length; i++) { if (!ids[i].Equals(teacherNoSelect)) { list.Add(ids[i]); } } userAuth.userIds = string.Join(",", list.ToArray()); dalua.setUserAuth(userAuth); Javascript.JavaScriptLocationHref("/Administrator/ViewNormAuth.aspx", Page); } }
protected void dlstFirstNorm_ItemDataBound(object sender, DataListItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { DataList dataList = (DataList)e.Item.FindControl("dlstSecondNorm"); DataRowView rowv = (DataRowView)e.Item.DataItem; int mainID = Convert.ToInt32(rowv["normId"]); DalOperationNorm dalOperationNorm = new DalOperationNorm(); DataSet ds = dalOperationNorm.GetChildNorms(mainID,term); dataList.DataSource = ds.Tables[0].DefaultView; dataList.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { BaseConfig baseconfig = CacheCollections.GetBaseConfig(); if (!IsPostBack) { UserCookiesInfo UserCookiesInfo = BllOperationAboutUser.GetUserCookiesInfo(); //UserCookiesInfo UserCookiesInfo = CacheCollections.GetUserCookiesInfo(); string nickName = string.Empty; switch (UserCookiesInfo.userType) { case 0: ulAdmin.Visible = true; nickName = "老师"; if (UserCookiesInfo.teacherType != null && UserCookiesInfo.teacherType == "本院") { drawAdminTeacher.Visible = true; } break; case 1: case 2: ulTeacher.Visible = true; nickName = "老师"; DalOperationNorm dalOperationNorm = new DalOperationNorm(); DalOperationAboutUserAuth dalua = new DalOperationAboutUserAuth(); UserAuth auth = dalOperationNorm.GetUserAuth(pageName); UserAuth salaryAuth = dalua.GetUserAuth(salaryPageName); UserAuth projectAuth = dalua.GetUserAuth(projectPageName); if (auth!=null&&auth.userIds != null) { string[] _ids = auth.userIds.Split(','); if (_ids != null) { norm_right = _ids.Contains(UserCookiesInfo.userNo); } } if (salaryAuth!=null&&salaryAuth.userIds != null) { string[] _ids = salaryAuth.userIds.Split(','); if (_ids != null) { if (_ids.Contains(UserCookiesInfo.userNo)) { salary_right = true; } } } if (projectAuth != null) { string projectUserIds = projectAuth.userIds; if (!(projectUserIds == null || projectUserIds.Trim().Length == 0)) { if (projectUserIds.Contains(UserCookiesInfo.userNo)) { project_right = true; } } } if (UserCookiesInfo.teacherType != null && UserCookiesInfo.teacherType == "本院") { drawTeacher.Visible = true; } break; case 3: ulStudent.Visible = true; nickName = "同学"; break; default: break; } user.InnerHtml = "尊敬的" + UserCookiesInfo.userName.Trim() + nickName + " 您好!"; //设置系统配置信息 //DalOperationBaseConfig dobc = new DalOperationBaseConfig(); ltlSystemVersion.Text = baseconfig.systemVersion; this.lblCopyRight.Text = baseconfig.systemCopyRight; //判断是否为班主任 DalOperationAboutEnglishExam dalOperationAboutEnglishExam = new DalOperationAboutEnglishExam(); if (dalOperationAboutEnglishExam.CheckIsHeadTeacherByTeacherNo(UserCookiesInfo.userNo)) { englishExamManage.Visible = true; } } pageTitle.Text = baseconfig.systemName + " 当前系统版本号:" + baseconfig.systemVersion; }