protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string inSalaryItemIds = Request["inIds"]; string outSalaryItemIds = Request["outIds"]; string teacherNo = Request["tid"]; string cid = Request["cid"]; string acType = Request["acType"]; string teacherType = Request["teacherType"]; DalOperationAboutTeacherSalary dalts = new DalOperationAboutTeacherSalary(); string[] courseInfo = cid.Split('-'); cid = courseInfo[0]; TeacherSalary teacherSalary = dalts.GetTeacherSalaryByTidAndCidAndTermTag(teacherNo, cid, int.Parse(teacherType), null); List<SalaryItem> inSalaryItemList = GetInSalaryItemListByIdString(inSalaryItemIds, teacherSalary); List<SalaryItem> outSalaryItemList = GetOutSalaryItemListByIdString(outSalaryItemIds); if (inSalaryItemList.Count == 0) { Javascript.AlertAndRedirect("请至少选择一项待发薪酬项", "/Administrator/SelectSalaryItem.aspx?teacherNO=" + teacherNo, Page); } else { DalOperationAboutTeacher teacherDal = new DalOperationAboutTeacher(); TeachersList teacher = teacherDal.GetTeacherById(teacherNo); this.teacherNo.Value = teacher.teacherNo; this.teacherName.Text = teacher.teacherName; this.courseNo.Value = cid; this.atCourseType.Value = acType; this.teacherType.Value = teacherType; this.TeacherType_Literal.Text = CommonUtility.ConvertTeacherType2String(int.Parse(teacherType)); this.InSalaryItemList.DataSource = inSalaryItemList; this.InSalaryItemList.DataBind(); this.OutSalaryItemList.DataSource = outSalaryItemList; this.OutSalaryItemList.DataBind(); if (!string.IsNullOrWhiteSpace(cid)) { DalOperationAboutCourses dalc = new DalOperationAboutCourses(); Courses course = dalc.GetCoursesByNo(cid, null); this.Course_TR.Visible = true; this.CourseName_Literal.Text = course.courseName; this.Course_TR.Visible = true; this.CoursePeriod_TR.Visible = true; if (string.IsNullOrWhiteSpace(course.TestHours) || "0" == course.TestHours) { this.CoursePeriod_Literal.Text = course.period; } else { this.CoursePeriod_Literal.Text = course.period + "/" + course.TestHours; } } } } }
protected void btnUpdate_Click(object sender, EventArgs e) { UserCookiesInfo UserCookiesInfo = BllOperationAboutUser.GetUserCookiesInfo(); if (UserCookiesInfo.userType == 1 || UserCookiesInfo.userType == 2) { using (TransactionScope scope = new TransactionScope()) { try { DalOperationAboutTeacher DalOperationAboutTeacher = new DalOperationAboutTeacher(); DalOperationAboutTeacher.UpdateEmail(UserCookiesInfo.userNo, CommonUtility.JavascriptStringFilter(ltlEmail.Text), CommonUtility.JavascriptStringFilter(txtOffice.Text), CommonUtility.JavascriptStringFilter(txtRemark.Text)); scope.Complete(); } catch (Exception ex) { MongoDBLog.LogRecord(ex); Javascript.GoHistory(-1, "修改失败,错误提示:您输入的Email重复,请重新输入后提交!", Page); } finally { } } } Javascript.AlertAndRedirect("修改成功:)", "EditTeacherInfo.aspx", Page); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request["teacherNo"] != null && Request["courseNo"] != null && Request["classID"] != null && Request["termTag"] != null) { teacherNo = Request["teacherNo"]; String courseNo = Request["courseNo"].ToString().Trim(); String ClassID = Server.UrlDecode(Request["classID"].ToString().Trim()); String termTag = Request["termTag"].ToString().Trim(); DalOperationAboutTeacher dalOperationAboutTeacher = new DalOperationAboutTeacher(); dalOperationAboutTeacher.AddCourseOfTeacher(teacherNo, courseNo, ClassID, termTag); Javascript.RefreshParentWindow("TeacherManager.aspx?fragment=4&teacherNo=" + teacherNo, Page); return; } if (Request["teacherNo"] != null) { teacherNo = Request["teacherNo"]; DalOperationAboutTeacher dalOperationAboutTeacher = new DalOperationAboutTeacher(); DataSet ds = dalOperationAboutTeacher.GetOtherCoursesByTeacherNo(teacherNo); courses.DataSource = ds.Tables[0]; courses.DataBind(); } else { Javascript.GoHistory(-1, Page); } } }
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) { //控制Tab的显示 string fragmentFlag = "1"; if (Request["fragment"] != null) { fragmentFlag = Request["fragment"]; } CommonUtility.ShowLiControl(fragmentFlag, liFragment1, liFragment2, liFragment3 , divFragment1, divFragment2, divFragment3); UserCookiesInfo UserCookiesInfo = BllOperationAboutUser.GetUserCookiesInfo(); if (UserCookiesInfo.userType == 1 || UserCookiesInfo.userType == 2) { DalOperationAboutTeacher DalOperationAboutTeacher = new DalOperationAboutTeacher(); TeachersList teacher = DalOperationAboutTeacher.GetTeacherById(UserCookiesInfo.userNo); ltlEmail.Text = teacher.emailAddress; txtOffice.Text = teacher.officeAddress; txtRemark.Text = teacher.remark; } } }
protected void dlSearchAssistant_ItemCommand(object source, DataListCommandEventArgs e) { DalOperationAboutTeacher dalOperationAboutTeacher = new DalOperationAboutTeacher(); if (e.CommandName == "cancelAssistant") { string assistantNo = this.dlSearchAssistant.DataKeys[e.Item.ItemIndex].ToString();//取选中行教师编号 dalOperationAboutTeacher.ChangeTeacherType(assistantNo, false); Javascript.AlertAndRedirect("取消助教身份成功!", "/Administrator/AssistantManager.aspx?page="+pageIndex, Page); DataListBind(); } }
protected void AddSalary_Submit(object sender, EventArgs e) { DalOperationAboutSalaryEntry dal = new DalOperationAboutSalaryEntry(); DalOperationAboutTeacher dalt = new DalOperationAboutTeacher(); DalOperationAboutCourses dalc = new DalOperationAboutCourses(); string teacherNo = this.TeacherId.Value; string termTag = this.SalaryTermTag.SelectedValue; string salaryMonth = this.SalaryMonth.Value; int teacherType = int.Parse(this.teacherType.Value.Trim()); int salaryEntryStatus = 0; List<SalaryEntry> salaryEntries = dal.GetSalaryEntrys(teacherNo, termTag, salaryMonth, teacherType, salaryEntryStatus); if (salaryEntries != null && salaryEntries.Count != 0) { Javascript.Alert("本月已为该教师添加过薪酬信息,请核对信息后再次录入!", Page); } else { SalaryEntry salaryEntry = new SalaryEntry(); TeachersList teacher = new TeachersList { teacherNo = teacherNo }; Courses course = new Courses { courseNo = this.CourseId.Value }; salaryEntry.teacher = teacher; salaryEntry.course = course; salaryEntry.atCourseType = atCourseType.Value; salaryEntry.termTag = termTag; salaryEntry.salaryMonth = salaryMonth; salaryEntry.teacherCostWithTax = float.Parse(this.TeacherSalaryCostWithTax.Text); salaryEntry.teacherCostWithoutTax = float.Parse(this.TeacherSalaryCostWithoutTax.Text); salaryEntry.teacherTotalCost = float.Parse(this.TeacherTotalCost.Text); salaryEntry.SetSalaryInItemValueList(this.InSalaryItemValueList.Value, false); salaryEntry.SetSalaryOutItemValueList(this.OutSalaryItemValueList.Value, false); salaryEntry.memo = this.SalaryEntryMemo.Text.Trim(); salaryEntry.teacherType = teacherType; dal.AddSalaryEntry(salaryEntry); Javascript.RefreshParentWindow("/Administrator/SalaryManage.aspx?fragment=5", Page); } }
protected void DatalistBind(string tag) { UserCookiesInfo UserCookiesInfo = BllOperationAboutUser.GetUserCookiesInfo(); DataSet ds = new DataSet(); DalOperationAboutTeacher DalOperationAboutTeacher = new DalOperationAboutTeacher(); if (tag == "当前学期") { ds = DalOperationAboutTeacher.GetOtherCoursesByTeacherNo(UserCookiesInfo.userNo); } else { ds = DalOperationAboutTeacher.GetOtherCoursesByTeacherNo(UserCookiesInfo.userNo, tag); } dlstCourses.DataSource = ds.Tables[0]; dlstCourses.DataBind(); }
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 Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request["email"] == null) { Javascript.GoHistory(-1, Page); return; } else { email = Request["email"].Trim(); PageDataBind(); DalOperationAboutTeacher DalOperationAboutTeacher = new DalOperationAboutTeacher(); String teacherNo = DalOperationAboutTeacher.GetTeacherNoByAddressEmail(email); DataSet ds = DalOperationAboutTeacher.GetCoursesByTeacherAssistant(teacherNo); courses.DataSource = ds.Tables[0]; courses.DataBind(); } } }
protected void DatalistBind(string tag) { UserCookiesInfo UserCookiesInfo = BllOperationAboutUser.GetUserCookiesInfo(); DataSet ds = new DataSet(); DataSet dsA = new DataSet(); DalOperationAboutTeacher DalOperationAboutTeacher = new DalOperationAboutTeacher(); DalOperationAboutAssistant DalOperationAboutAssistant = new DalOperationAboutAssistant(); ds = DalOperationAboutTeacher.GetCoursesByTeachertNo(UserCookiesInfo.userNo, tag); dsA = DalOperationAboutAssistant.GetCoursesByAssistantNo(UserCookiesInfo.userNo, tag); tags = TagToString(tag); dlstAssistantCourses.DataSource = dsA.Tables[0]; dlstAssistantCourses.DataBind(); dlstCourses.DataSource = ds.Tables[0]; dlstCourses.DataBind(); if (dlstAssistantCourses.Items.Count == 0) { dlstAssistantCourses.ShowFooter = true; } else { dlstAssistantCourses.ShowFooter = false; } if (dlstCourses.Items.Count == 0) { dlstCourses.ShowFooter = true; } else { dlstCourses.ShowFooter = false; } }
protected void Page_Load(object sender, EventArgs e) { UserCookiesInfo userCookiesInfo = BllOperationAboutUser.GetUserCookiesInfo(); if (!isAuth(userCookiesInfo.userNo)) { Javascript.Alert("你无权查看此页面", Page); Javascript.RefreshParentWindow("/Common/NotifyList.aspx", Page); } else { //控制Tab的显示 string fragmentFlag = "2"; if (Request["fragment"] != null) { fragmentFlag = Request["fragment"]; } CommonUtility.ShowLiControl(fragmentFlag, liFragment1, liFragment2, liFragment3 , liFragment4, liFragment5, divFragment1, divFragment2, divFragment3, divFragment4, divFragment5); if (fragmentFlag.Equals("2")) { if (!IsPostBack) { DataListBindSalaryItem(); } } if (fragmentFlag.Equals("3")) { if (!IsPostBack) { string tid = Request["teacherNo"]; if (tid != null && tid.Trim().Length != 0) { DalOperationAboutTeacher teacherDal = new DalOperationAboutTeacher(); TeachersList teacher = teacherDal.GetTeacherById(tid); this.TeacherSalary_TeacherName.Text = teacher.teacherName; } DataListBindTeacherSalary(); } } if (fragmentFlag.Equals("4")) { if (!IsPostBack) { string tid = Request["teacherNo"]; if (tid == null || tid.Trim().Length == 0) { Javascript.AlertAndRedirect("请先选择教师再进行此项操作", "/Administrator/SalaryManage.aspx?fragmentFlag=1", Page); } else { Javascript.JavaScriptLocationHref("SelectSalaryItem.aspx?keepThis=true&tid=" + tid + "&TB_iframe=true&height=300&width=500", Page); } } } if (fragmentFlag.Equals("5")) { if (!IsPostBack) { string tid = Request["teacherNo"]; if (tid != null && tid.Trim().Length != 0) { DalOperationAboutTeacher teacherDal = new DalOperationAboutTeacher(); TeachersList teacher = teacherDal.GetTeacherById(tid); this.SalaryQuery_Name.Text = teacher.teacherName; } DataListBindSalaryEntry(); } } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string tid = Request["teacherNo"]; string courseNo = Request["cid"]; string teacherType = Request["teacherType"]; string atCourseType = Request["acType"]; if (tid == null || tid.Trim().Length == 0) { Javascript.Alert("请先选择教师再进行此项操作", Page); Javascript.RefreshParentWindow("/Administrator/SalaryManage.aspx?fragment=1", Page); } else { DalOperationAboutTeacher dal = new DalOperationAboutTeacher(); TeachersList teacher = dal.GetTeacherById(tid); if (teacher == null) { Javascript.AlertAndRedirect("请正确选择教师后再进行此操作", "/Administrator/SalaryManage.aspx?fragmentFlag=1", Page); } else { this.teacherName.Text = teacher.teacherName; this.teacherNo.Value = teacher.teacherNo; this.teacherType.Value = teacherType; } DataBindSearchTermTagList(this.TeacherSalary_TermTag.Items); if (!string.IsNullOrWhiteSpace(courseNo)) { DalOperationAboutCourses dalc = new DalOperationAboutCourses(); string[] courseInfo = courseNo.Split('-'); Courses course = dalc.GetCoursesByNo(courseInfo[0], null); this.Course_TR.Visible = true; string courseName = course.courseName + (atCourseType == "1" ? "(教师)" : "(助教)"); this.CourseName_Literal.Text = courseName; this.CourseId_hf.Value = course.courseNo; this.teachPeriod_TR.Visible = true; this.experPeriod_TR.Visible = true; this.atCourseType.Value = atCourseType; DataBindTeacherSalaryCourse(course); } this.teacherType_Literal.Text = CommonUtility.ConvertTeacherType2String(int.Parse(teacherType.Trim())); string inSalaryItemIds = Request["inIds"]; List<SalaryItem> inSalaryItemList = GetSalaryItemListByIdString(inSalaryItemIds); TeacherSalary_ItemList.DataSource = inSalaryItemList; TeacherSalary_ItemList.DataBind(); } } }
protected void Page_Load(object sender, EventArgs e) { UserCookiesInfo userCookiesInfo = BllOperationAboutUser.GetUserCookiesInfo(); string tid = userCookiesInfo.userNo; if (tid == null || tid.Trim().Length == 0) { Javascript.AlertAndRedirect("你尚未登陆,请先登陆!", "/Common/NotifyList.aspx", Page); } else { //控制Tab的显示 string fragmentFlag = "1"; if (Request["fragment"] != null) { fragmentFlag = Request["fragment"]; } CommonUtility.ShowLiControl(fragmentFlag, liFragment1, liFragment2, divFragment1, divFragment2); if (fragmentFlag.Equals("1")) { if (!IsPostBack) { DalOperationAboutTeacher teacherDal = new DalOperationAboutTeacher(); TeachersList teacher = teacherDal.GetTeacherById(tid); this.TeacherSalary_Name.Text = teacher.teacherName; DataListBindTeacherSalary(tid); } } if (fragmentFlag.Equals("2")) { if (!IsPostBack) { DalOperationAboutTeacher teacherDal = new DalOperationAboutTeacher(); TeachersList teacher = teacherDal.GetTeacherById(tid); this.SalaryEntry_TeacherName.Text = teacher.teacherName; DataListBindSalaryEntry(tid); } } } }
/// <summary> /// 从DataReader中转化并构造SalaryEntry记录集 /// </summary> /// <param name="dataReader"></param> /// <returns></returns> private void BuildSalaryEntry(IDataReader dataReader, List<SalaryEntry> salaryEntries) { DalOperationAboutTeacher dalt = new DalOperationAboutTeacher(); DalOperationAboutCourses dalc = new DalOperationAboutCourses(); if (dataReader != null) { while (dataReader.Read()) { SalaryEntry salaryEntry = new SalaryEntry(); salaryEntry.salaryEntryId = int.Parse(dataReader["salaryEntryId"].ToString().Trim()); TeachersList teacher = dalt.GetTeacherById(dataReader["teacherNo"].ToString().Trim()); salaryEntry.teacher = teacher; salaryEntry.teacherType = int.Parse(dataReader["teacherType"].ToString().Trim()); salaryEntry.termTag = dataReader["termTag"].ToString().Trim(); Courses course = dalc.GetCoursesByNo(dataReader["courseNo"].ToString().Trim(), salaryEntry.termTag); salaryEntry.course = course; salaryEntry.atCourseType = dataReader["atCourseType"].ToString().Trim(); salaryEntry.SetSalaryInItemValueList(dataReader["salaryInItemValueList"].ToString().Trim(), true); salaryEntry.SetSalaryOutItemValueList(dataReader["salaryOutItemValueList"].ToString().Trim(), true); if (dataReader["salaryInAdjustFactor"] != null) { salaryEntry.salaryInAdjustFactor = float.Parse(dataReader["salaryInAdjustFactor"].ToString().Trim()); } if (dataReader["salaryOutAdjustFactor"] != null) { salaryEntry.salaryOutAdjustFactor = float.Parse(dataReader["salaryOutAdjustFactor"].ToString().Trim()); } if (dataReader["teachPeriod"] != null) { salaryEntry.teachPeriod = int.Parse(dataReader["teachPeriod"].ToString().Trim()); } if (dataReader["teachAssiPeriod"] != null) { salaryEntry.teachAssiPeriod = int.Parse(dataReader["teachAssiPeriod"].ToString().Trim()); } salaryEntry.teacherCostWithTax = float.Parse(dataReader["teacherCostWithTax"].ToString().Trim()); salaryEntry.teacherCostWithoutTax = float.Parse(dataReader["teacherCostWithoutTax"].ToString().Trim()); salaryEntry.teacherTotalCost = float.Parse(dataReader["teacherTotalCost"].ToString().Trim()); salaryEntry.salaryMonth = dataReader["salaryMonth"].ToString().Trim(); salaryEntry.salaryEntryStatus = int.Parse(dataReader["salaryEntryStatus"].ToString()); salaryEntry.createdTime = DateTime.Parse(dataReader["createdTime"].ToString().Trim()); salaryEntry.memo = dataReader["memo"].ToString().Trim(); salaryEntries.Add(salaryEntry); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string tid = Request["teacherNO"]; string courseNo = Request["courseNo"]; if (tid == null || tid.Trim().Length == 0) { Javascript.Alert("请先选择教师后再进行此项操作", Page); Javascript.RefreshParentWindow("/Administrator/SalaryManage.aspx?fragment=1", Page); } else { DalOperationAboutTeacher teacherDal = new DalOperationAboutTeacher(); TeachersList teacher = teacherDal.GetTeacherById(tid); if (teacher == null) { Javascript.AlertAndRedirect("请先确定教师后再进行此项操作", "/Administrator.aspx?fragment=1", Page); } else { this.teacherName.Text = teacher.teacherName; this.teacherNo.Value = teacher.teacherNo; } int teacherType = 1; if ("本院" == teacher.teacherType) { teacherType = 1; } else { this.SelectCourse_Literal.Visible = true; this.SelectCourse.Visible = true; DalOperationAboutTeacher dalt = new DalOperationAboutTeacher(); DataTable dsTeacher = dalt.GetCoursesByTeacherAssistant(tid).Tables[0]; if (dsTeacher.Rows.Count == 0) { Javascript.Alert("该教师非院内教师并且本学期未待任何课程!", Page); Javascript.RefreshParentWindowReload(Page); } else { DataBindTeacherSalaryCourse(dsTeacher, courseNo); if (string.IsNullOrWhiteSpace(courseNo)) { courseNo = this.SelectCourse.SelectedValue; } string[] courseInfo = courseNo.Split('-'); int atCourseType = 1; if (courseInfo.Length > 1) { atCourseType = int.Parse(courseInfo[1].Trim()); } teacherType = CommonUtility.CheckTeacherType(teacher.teacherType, atCourseType); } } this.TeacherType_Literal.Text = CommonUtility.ConvertTeacherType2String(teacherType); this.teacherType.Value = teacherType.ToString(); DalOperationAboutSalaryItem dalsi = new DalOperationAboutSalaryItem(); List<SalaryItem> salaryItems = dalsi.GetAllSalaryItem(teacherType, 1); this.TeacherInSalaryItemList.DataSource = salaryItems; this.TeacherInSalaryItemList.DataBind(); this.TeacherOutSalaryItemList.DataSource = salaryItems; this.TeacherOutSalaryItemList.DataBind(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string formatedTeacherSalaryCostWithTax = CommonUtility.ConvertFormatedFloat("{0:F2}", Request["withTax"].Trim()).ToString(); string formatedTeacherSalaryCostWithoutTax = CommonUtility.ConvertFormatedFloat("{0:F2}", Request["withoutTax"].Trim()).ToString(); string formatedTeacherTotalCost = CommonUtility.ConvertFormatedFloat("{0:F2}", Request["totalCost"].Trim()).ToString(); this.TeacherSalaryCostWithTax.Text = formatedTeacherSalaryCostWithTax; this.TeacherSalaryCostWithoutTax.Text = formatedTeacherSalaryCostWithoutTax; this.TeacherTotalCost.Text = formatedTeacherTotalCost; this.InSalaryItemValueList.Value = Request["inValueList"]; this.OutSalaryItemValueList.Value = Request["outValueList"]; SalaryEntry salaryEntry = new SalaryEntry(); salaryEntry.SetSalaryInItemValueList(Request["inValueList"], true); salaryEntry.SetSalaryOutItemValueList(Request["outValueList"], true); List<SalaryItemElement> inItemElements = salaryEntry.GetSalaryInItemElements(); List<SalaryItemElement> outItemElements = salaryEntry.GetSalaryOutItemElements(); FullFillSalaryItemElements(inItemElements); FullFillSalaryItemElements(outItemElements); this.ShowSalaryInItems.DataSource = inItemElements; this.ShowSalaryOutItems.DataSource = outItemElements; this.ShowSalaryInItems.DataBind(); this.ShowSalaryOutItems.DataBind(); DataBindSearchTermTagList(); this.TeacherId.Value = Request["tid"]; DalOperationAboutTeacher teacherDal = new DalOperationAboutTeacher(); TeachersList teacher = teacherDal.GetTeacherById(Request["tid"].Trim()); this.TeacherName.Text = teacher.teacherName; DateTime lastMonth = DateTime.Now.Date.AddMonths(-1); string lastMonthString = lastMonth.Month < 10 ? "0" + lastMonth.Month.ToString() : lastMonth.Month.ToString(); this.SalaryMonth.Value = lastMonth.Year + "-" + lastMonthString; this.CourseId.Value = Request["cid"]; this.atCourseType.Value = Request["acType"]; this.teacherType.Value = Request["teacherType"]; } }
/// <summary> /// 把从数据库中读出的数据转化为对象实例 /// </summary> /// <param name="reader"></param> /// <param name="salaries"></param> /// <returns></returns> private void buildTeacherSalarys(IDataReader reader, List<TeacherSalary> salaries) { DalOperationAboutCourses courseDal = new DalOperationAboutCourses(); DalOperationAboutTeacher teacherDal = new DalOperationAboutTeacher(); while (reader.Read()) { TeacherSalary salary = new TeacherSalary(); salary.teacherSalaryId = int.Parse(reader["teacherSalaryId"].ToString().Trim()); salary.teacher = teacherDal.GetTeacherById(reader["teacherNo"].ToString().Trim()); salary.teacherType = int.Parse(reader["teacherType"].ToString().Trim()); salary.termTag = reader["termTag"].ToString().Trim(); if (reader["courseNo"] != null && reader["courseNo"].ToString().Trim().Length > 0) { salary.course = courseDal.GetCoursesByNo(reader["courseNo"].ToString().Trim(), salary.termTag); salary.atCourseType = int.Parse(reader["atCourseType"].ToString().Trim()); salary.teachPeriod = int.Parse(reader["teachPeriod"].ToString().Trim()); salary.experPeriod = int.Parse(reader["experPeriod"].ToString().Trim()); } salary.SetSalaryInItemValueList(reader["salaryItemValueList"].ToString().Trim(), true); salary.totalTeachCost = float.Parse(reader["totalTeachCost"].ToString().Trim()); salary.isConfirm = bool.Parse(reader["isConfirm"].ToString().Trim()); salary.memo = reader["memo"].ToString().Trim(); salary.createdTime = DateTime.Parse(reader["createdTime"].ToString().Trim()); salaries.Add(salary); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //控制Tab的显示 string fragmentFlag = "1"; if (Request["fragment"] != null) { fragmentFlag = Request["fragment"]; } CommonUtility.ShowLiControl(fragmentFlag, liFragment1, liFragment2, liFragment3 , divFragment1, divFragment2, divFragment3); //删除版面 if (Request["del"] == "true" && Request["forumId"] != null) { DalOperationAboutBbsManage dalOperationAboutBbsManage = new DalOperationAboutBbsManage(); dalOperationAboutBbsManage.DeleteForumByForumId(Request["forumId"]); } if (fragmentFlag.Equals("1")) { //TODO DalOperationAboutBbsManage dalOperationAboutBbsManage = new DalOperationAboutBbsManage(); DataSet ds = dalOperationAboutBbsManage.GetAllForums(); dlstforums.DataSource = ds.Tables[0]; dlstforums.DataBind(); } if (fragmentFlag.Equals("2")) { DalOperationAboutTeacher dalt = new DalOperationAboutTeacher(); dlstteachers.DataSource = dalt.GetTeachers().Tables[0]; dlstteachers.DataBind(); txtTitle.Attributes.Add("class", "required"); } if (fragmentFlag.Equals("3")) { txtSearchString.Attributes.Add("class", "required"); } } }