private void DataListBindTeacherSalary() { DalOperationAboutTeacherSalary dal = new DalOperationAboutTeacherSalary(); string teacherNo = null; string teacherName = Request["teacherName"]; if (teacherName != null && teacherName.Trim().Length > 0) { teacherName = teacherName.Trim(); teacherNo = SearchTeacherIds(teacherName); this.TeacherSalary_TeacherName.Text = teacherName; } else { teacherName = null; } string termTag = Request["termTag"]; string teacherType = Request["teacherType"]; string status = Request["status"]; DataBindSearchTermTagList(this.TeacherSalary_TermTag.Items, termTag); DataBindTeacherTypeList(this.TeacherSalary_TeacherType.Items, teacherType); DataBindSalaryStatus(this.TeacherSalary_Status.Items, status); if (string.IsNullOrWhiteSpace(termTag)) { termTag = this.TeacherSalary_TermTag.SelectedValue; } else if (termTag.Trim() == "all") { termTag = null; } if (string.IsNullOrWhiteSpace(teacherType)) { teacherType = "0"; } else { teacherType = teacherType.Trim(); } if (string.IsNullOrWhiteSpace(status)) { status = "0"; } else { status = status.Trim(); } List<TeacherSalary> teacherSalaries = new List<TeacherSalary>(); if (!(teacherName != null && string.IsNullOrWhiteSpace(teacherNo))) { if (teacherNo == null && teacherType == "0" && termTag == null && status == "0") { teacherSalaries = dal.GetAllTeacherSalary(); } else { teacherSalaries = dal.GetTeacherSalarys(teacherNo, int.Parse(teacherType), termTag, int.Parse(status)); } } double totalTeacherSummary = dal.GetTeacherSalarysValue(null, 0, null, 0); double selectedTeacherSummary = dal.GetTeacherSalarysValue(teacherNo, int.Parse(teacherType), termTag, int.Parse(status)); this.literal_TotalTeacherSummay.Text = totalTeacherSummary.ToString(); this.literal_SelectedTeacherSummay.Text = selectedTeacherSummary.ToString(); if (teacherSalaries != null) { this.TeacherSalaryPager.RecordCount = teacherSalaries.Count; TeacherSalaryPager.PageSize = CommonUtility.pageSize; PagedDataSource pds = new PagedDataSource(); pds.DataSource = teacherSalaries; pds.AllowPaging = true; pds.CurrentPageIndex = pageIndex - 1; pds.PageSize = TeacherSalaryPager.PageSize; this.TeacherSalaryList.DataSource = pds; this.TeacherSalaryList.DataBind(); } else { this.TeacherSalaryPager.RecordCount = 0; } if (TeacherSalaryPager.RecordCount > 0) { this.TeacherSalaryList.ShowFooter = false; } }
private void DataListBindTeacherSalary(string teacherNo) { DalOperationAboutTeacherSalary dal = new DalOperationAboutTeacherSalary(); string termTag = Request["termTag"]; DataBindSearchTermTagList(this.TeacherSalary_TermTag.Items, termTag); if (termTag == null || termTag.Trim().Length == 0) { termTag = this.TeacherSalary_TermTag.SelectedValue; } else if(termTag.Trim() == "all") { termTag = null; } List<TeacherSalary> teacherSalaries = new List<TeacherSalary>(); teacherSalaries = dal.GetTeacherSalarys(teacherNo, 0, termTag, 0); if (teacherSalaries != null) { this.TeacherSalaryPager.RecordCount = teacherSalaries.Count; TeacherSalaryPager.PageSize = CommonUtility.pageSize; PagedDataSource pds = new PagedDataSource(); pds.DataSource = teacherSalaries; pds.AllowPaging = true; pds.CurrentPageIndex = pageIndex - 1; pds.PageSize = TeacherSalaryPager.PageSize; this.TeacherSalaryList.DataSource = pds; this.TeacherSalaryList.DataBind(); } else { this.TeacherSalaryPager.RecordCount = 0; } if (TeacherSalaryPager.RecordCount > 0) { this.TeacherSalaryList.ShowFooter = false; } }
private List<TeacherSalary> QueryTeacherSalaries(string teacherName, string termTag, int teacherType, int status) { string teacherNo = null; if (teacherName != null && teacherName.Trim().Length > 0) { teacherName = teacherName.Trim(); teacherNo = SearchTeacherIds(teacherName); if (teacherNo == null || teacherNo.Trim().Length == 0) { teacherNo = null; } } else { teacherName = null; } if (termTag == null || termTag.Trim().Length == 0 || termTag.Trim() == "all") { termTag = null; } DalOperationAboutTeacherSalary dalts = new DalOperationAboutTeacherSalary(); List<TeacherSalary> teacherSalaries = new List<TeacherSalary>(); if (!(teacherName != null && (teacherNo == null || teacherNo.Trim().Length == 0))) { teacherSalaries = dalts.GetTeacherSalarys(teacherNo, teacherType, termTag, status); } return teacherSalaries; }
protected void btn_TeacherSalary_Click(object sender, EventArgs e) { DalOperationAboutTeacherSalary teacherSalaryDal = new DalOperationAboutTeacherSalary(); if (this.btn_TeacherSalary.Text == "添加") { string teacherNo = this.teacherNo.Value; string termTag = this.TeacherSalary_TermTag.SelectedValue; int teacherType = int.Parse(this.teacherType.Value.Trim()); List<TeacherSalary> teacherSalaries = teacherSalaryDal.GetTeacherSalarys(teacherNo, teacherType, termTag, 0); if (teacherSalaries != null && teacherSalaries.Count != 0) { Javascript.Alert("本学期已为该教师添加过薪酬预算,请核对信息后再次录入!", Page); } else { TeachersList teacherList = new TeachersList { teacherNo = this.teacherNo.Value }; TeacherSalary salary = new TeacherSalary(); salary.teacher = teacherList; if (Course_TR.Visible) { string atCourseType = this.atCourseType.Value; Courses course = new Courses { courseNo = this.CourseId_hf.Value }; salary.course = course; salary.atCourseType = int.Parse(atCourseType); salary.teachPeriod = int.Parse(this.teachPeriod.Text.Trim()); if (this.experPeriod.Text == null || this.experPeriod.Text.Trim().Length == 0) { salary.experPeriod = 0; } else { salary.experPeriod = int.Parse(this.experPeriod.Text.Trim()); } } if (BuildInSalaryItemValueList(salary)) { salary.teacherType = int.Parse(this.teacherType.Value.Trim()); salary.termTag = TeacherSalary_TermTag.SelectedValue; salary.memo = teacherSalary_Memo.Text.Trim(); using (TransactionScope scope = new TransactionScope()) { try { teacherSalaryDal.AddTeacherSalary(salary); AddSalaryEntryDefault(salary); scope.Complete(); Javascript.RefreshParentWindow("/Administrator/SalaryManage.aspx?fragment=3", Page); } catch (Exception ex) { MongoDBLog.LogRecord(ex); Javascript.GoHistory(-1, "添加薪酬预算和月发放薪酬记录失败!", Page); } } } } } }