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 DataListBindSalaryEntry(string teacherNo) { DalOperationAboutSalaryEntry dal = new DalOperationAboutSalaryEntry(); string termTag = Request["termTag"]; DataBindSearchTermTagList(this.SalaryQuery_TermTag.Items, termTag); if (termTag == null || termTag.Trim().Length == 0) { termTag = this.SalaryQuery_TermTag.SelectedValue; } else if (termTag.Trim() == "all") { termTag = null; } string salaryMonth = Request["salaryMonth"] != null && Request["salaryMonth"].Trim().Length > 0 ? Request["salaryMonth"].Trim() : null; this.SalaryQuery_SalaryMonth.Value = salaryMonth; List<SalaryEntry> salaryEntries = new List<SalaryEntry>(); salaryEntries = dal.GetSalaryEntrys(teacherNo, termTag, salaryMonth, 0, 4); //salaryEntryStatus=4:只看到已发放的 if (salaryEntries != null) { this.SalaryEntryPager.RecordCount = salaryEntries.Count; SalaryEntryPager.PageSize = CommonUtility.pageSize; PagedDataSource pds = new PagedDataSource(); pds.DataSource = salaryEntries; pds.AllowPaging = true; pds.CurrentPageIndex = pageIndex - 1; pds.PageSize = SalaryEntryPager.PageSize; this.SalaryEntryList.DataSource = pds; this.SalaryEntryList.DataBind(); } else { this.SalaryEntryPager.RecordCount = 0; } if (SalaryEntryPager.RecordCount > 0) { this.SalaryEntryList.ShowFooter = false; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string salaryEntryId = Request["salaryEntryId"]; if (salaryEntryId == null || salaryEntryId.Trim().Length == 0) { Javascript.Alert("请提供准确的薪酬主键", Page); } else { DalOperationAboutSalaryEntry dal = new DalOperationAboutSalaryEntry(); SalaryEntry salaryEntry = dal.GetSalaryEntry(int.Parse(salaryEntryId.Trim())); if (salaryEntry == null) { Javascript.Alert("您查看的薪酬记录不存在!", Page); Javascript.RefreshParentWindowReload(Page); } else { UserCookiesInfo userCookiesInfo = BllOperationAboutUser.GetUserCookiesInfo(); List<SalaryItemElement> inSalaryItemElement = salaryEntry.GetSalaryInItemElements(); List<SalaryItemElement> outSalaryItemElement = salaryEntry.GetSalaryOutItemElements(); FullFillSalaryItemElements(inSalaryItemElement); FullFillSalaryItemElements(outSalaryItemElement); this.ShowSalaryInItems.DataSource = inSalaryItemElement; this.ShowSalaryInItems.DataBind(); this.ShowSalaryOutItems.DataSource = outSalaryItemElement; this.ShowSalaryOutItems.DataBind(); this.TeacherName.Text = salaryEntry.teacher.teacherName; this.TeacherSalaryCostWithTax.Text = salaryEntry.teacherCostWithTax.ToString(); this.TeacherSalaryCostWithoutTax.Text = salaryEntry.teacherCostWithoutTax.ToString(); this.TeacherTotalSalaryCost.Text = salaryEntry.teacherTotalCost.ToString(); this.SalaryMonth.Text = salaryEntry.salaryMonth; this.TermTag.Text = CommonUtility.ChangeTermToString(salaryEntry.termTag); if (salaryEntry.course != null) { TeacherCourse_TR.Visible = true; this.TeacherCourse.Text = salaryEntry.course.courseName; } this.TeacherPosition.Text = CommonUtility.ConvertTeacherType2String(salaryEntry.teacherType); this.SalaryEntryId.Value = "" + salaryEntry.salaryEntryId; this.SalaryEntryMemo.Text = salaryEntry.memo; if (salaryEntry.salaryEntryStatus == 1) //未发放 { this.btn_TeacherSalaryPay.Visible = true; this.btn_TeacherSalaryConfirm.Visible = false; this.btn_TeacherSalaryQA.Visible = false; this.Input_SalaryMonth.Visible = true; this.SalaryMonth.Visible = false; this.Input_SalaryMonth.Value = salaryEntry.salaryMonth; this.TB_SalaryEntryMemo.Visible = true; this.SalaryEntryMemo.Visible = false; this.TB_SalaryEntryMemo.Text = salaryEntry.memo; } if (salaryEntry.salaryEntryStatus == 2 && salaryEntry.teacher.teacherNo == userCookiesInfo.userNo) // 未确认 { this.btn_TeacherSalaryPay.Visible = false; this.btn_TeacherSalaryConfirm.Visible = true; this.btn_TeacherSalaryQA.Visible = true; this.hf_salaryId.Value = salaryEntryId; } } } } }
protected void TeacherSalaryPay_Click(object sender, EventArgs e) { DalOperationAboutSalaryEntry dalSe = new DalOperationAboutSalaryEntry(); string salaryEntryId = this.SalaryEntryId.Value; SalaryEntry salaryEntry = dalSe.GetSalaryEntry(int.Parse(salaryEntryId)); if (salaryEntry == null) { Javascript.Alert("您所操作的对象不存在!", Page); } else { salaryEntry.memo = this.TB_SalaryEntryMemo.Text.Trim(); salaryEntry.salaryMonth = this.Input_SalaryMonth.Value.Trim(); salaryEntry.salaryEntryStatus = 2; dalSe.UpdateSalaryEntryMonthMemoAndStatus(salaryEntry); } Javascript.RefreshParentWindowReload(Page); }
protected void TeacherSalaryConfirm_Click(object sender, EventArgs e) { DalOperationAboutSalaryEntry dal = new DalOperationAboutSalaryEntry(); string salaryEntryId = this.SalaryEntryId.Value; dal.updateSalaryEntryStatus(int.Parse(salaryEntryId), 3); //2->3 Javascript.RefreshParentWindowReload(Page); }
protected void DataListBindSalaryEntry() { DalOperationAboutSalaryEntry dal = new DalOperationAboutSalaryEntry(); string teacherNo = null; string teacherName = Request["teacherName"]; this.SalaryQuery_Name.Text = teacherName; if (teacherName != null && teacherName.Trim().Length > 0) { teacherNo = SearchTeacherIds(teacherName.Trim()); } else { teacherName = null; } string termTag = Request["termTag"]; string teacherType = Request["teacherType"]; string salaryEntryStatus = Request["status"]; DataBindSearchTermTagList(this.SalaryQuery_TermTag.Items, termTag); DataBindTeacherTypeList(this.SalaryQuery_TeacherType.Items, teacherType); DataBindSalaryStatus(this.SalaryQuery_SalaryEntryStatus.Items, salaryEntryStatus); if (termTag == null || termTag.Trim().Length == 0) { termTag = this.SalaryQuery_TermTag.SelectedValue; } else if (termTag.Trim() == "all") { termTag = null; } if (teacherType == null || teacherType.Trim().Length == 0) { teacherType = "0"; } else { teacherType = teacherType.Trim(); } if (string.IsNullOrWhiteSpace(salaryEntryStatus) || "0" == salaryEntryStatus.Trim()) { salaryEntryStatus = "0"; } else { salaryEntryStatus = salaryEntryStatus.Trim(); } string salaryMonth = Request["salaryMonth"] != null && Request["salaryMonth"].Trim().Length > 0 ? Request["salaryMonth"].Trim() : null; this.SalaryQuery_SalaryMonth.Value = salaryMonth; List<SalaryEntry> salaryEntries = new List<SalaryEntry>(); if (!(teacherName != null && (teacherNo == null || teacherNo.Trim().Length == 0))) { if (teacherNo == null && termTag == null && salaryMonth == null && teacherType == "0" && salaryEntryStatus == "0") { salaryEntries = dal.GetAllSalaryEntry(); } else { salaryEntries = dal.GetSalaryEntrys(teacherNo, termTag, salaryMonth, int.Parse(teacherType), int.Parse(salaryEntryStatus)); } } TotalSalaryModel selectedTotalSalaryModel = dal.GetTotalSalaryEntryValues(teacherNo, termTag, salaryMonth, int.Parse(teacherType), int.Parse(salaryEntryStatus)); TotalSalaryModel allTotalSalaryModel = dal.GetTotalSalaryEntryValues(null, null, null, 0, 0); this.literal_SelectedSalaryWithTax.Text = selectedTotalSalaryModel.salaryWithTax.ToString(); this.literal_SelectedSalaryWithoutTax.Text = selectedTotalSalaryModel.salaryWithoutTax.ToString(); this.literal_SelectedTotalSalary.Text = selectedTotalSalaryModel.salaryTotal.ToString(); this.literal_AllSalaryWithTax.Text = allTotalSalaryModel.salaryWithTax.ToString(); this.literal_AllSalaryWithoutTax.Text = allTotalSalaryModel.salaryWithoutTax.ToString(); this.literal_AllTotalSalary.Text = allTotalSalaryModel.salaryTotal.ToString(); if (salaryEntries != null) { this.SalaryEntryPager.RecordCount = salaryEntries.Count; SalaryEntryPager.PageSize = CommonUtility.pageSize; PagedDataSource pds = new PagedDataSource(); pds.DataSource = salaryEntries; pds.AllowPaging = true; pds.CurrentPageIndex = pageIndex - 1; pds.PageSize = SalaryEntryPager.PageSize; this.SalaryEntryList.DataSource = pds; this.SalaryEntryList.DataBind(); } else { this.SalaryEntryPager.RecordCount = 0; } if (SalaryEntryPager.RecordCount > 0) { this.SalaryEntryList.ShowFooter = false; } }
private void AddSalaryEntryDefault(TeacherSalary teacherSalary) { List<SalaryItemElement> teacherSalaryElements = teacherSalary.GetSalaryInItemElements(); int maxMonth = 1; foreach(SalaryItemElement teacherSalaryElement in teacherSalaryElements){ if (teacherSalaryElement.MonthNum > maxMonth) { maxMonth = teacherSalaryElement.MonthNum; } } List<string> salaryInValueListForMonth = new List<string>(); List<float> salaryWithTax = new List<float>(); List<float> salaryWithoutTax = new List<float>(); string salaryInValueStringForMonth; string singleSalaryItemValue; float salaryWithTaxForMonth; float salaryWithoutTaxForMonth; for (int i = 1; i <= maxMonth; i++) { salaryInValueStringForMonth = ""; salaryWithTaxForMonth = 0f; salaryWithoutTaxForMonth = 0f; foreach (SalaryItemElement teacherSalaryElement in teacherSalaryElements) { singleSalaryItemValue = ""; if (i <= teacherSalaryElement.MonthNum) { if (teacherSalaryElement.salaryStandard != 0) { singleSalaryItemValue = (teacherSalaryElement.salaryItemId + ":" + teacherSalaryElement.salaryStandard + "," + CommonUtility.ConvertFormatedFloat("{0:F2}", (teacherSalaryElement.times / teacherSalaryElement.MonthNum).ToString()) + ",1;"); } else { singleSalaryItemValue = (teacherSalaryElement.salaryItemId + ":" + CommonUtility.ConvertFormatedFloat("{0:F2}", (teacherSalaryElement.itemCost / teacherSalaryElement.MonthNum).ToString()) + ",1,1;"); if (teacherSalaryElement.hasTax) { salaryWithTaxForMonth += CommonUtility.ConvertFormatedFloat("{0:F2}", (teacherSalaryElement.itemCost / teacherSalaryElement.MonthNum).ToString()); } else { salaryWithoutTaxForMonth += CommonUtility.ConvertFormatedFloat("{0:F2}", (teacherSalaryElement.itemCost / teacherSalaryElement.MonthNum).ToString()); } } salaryInValueStringForMonth += singleSalaryItemValue; if (teacherSalaryElement.hasTax) { salaryWithTaxForMonth += (teacherSalaryElement.salaryStandard * teacherSalaryElement.times / teacherSalaryElement.MonthNum); }else{ salaryWithoutTaxForMonth += (teacherSalaryElement.salaryStandard * teacherSalaryElement.times / teacherSalaryElement.MonthNum); } } } if (!string.IsNullOrWhiteSpace(salaryInValueStringForMonth)) { salaryInValueStringForMonth = salaryInValueStringForMonth.Substring(0, salaryInValueStringForMonth.Length - 1); salaryInValueListForMonth.Add(salaryInValueStringForMonth); salaryWithTax.Add(salaryWithTaxForMonth); salaryWithoutTax.Add(salaryWithoutTaxForMonth); } } DalOperationAboutSalaryEntry dalse = new DalOperationAboutSalaryEntry(); SalaryEntry salaryEntry = new SalaryEntry(); salaryEntry.teacher = teacherSalary.teacher; salaryEntry.teacherType = teacherSalary.teacherType; salaryEntry.course = teacherSalary.course; salaryEntry.atCourseType = "" + teacherSalary.atCourseType; salaryEntry.termTag = teacherSalary.termTag; salaryEntry.salaryEntryStatus = 1; salaryEntry.memo = "本列表中的税后所得仅为假定你在苏州研究院的所有收入只有此项而计算(因为是兼职,财务默认您的基础收入已经为3500元),仅供参考!实际税后金额,以财务发放为准,有问题可以及时联系教学管理部(0512-68839206)或者财务(0512-87161163)"; DateTime monthDateTime = DateTime.Now; for (int i = 0; i < salaryInValueListForMonth.Count; i++) { salaryEntry.SetSalaryInItemValueList(salaryInValueListForMonth[i], false); salaryEntry.teacherCostWithTax = CommonUtility.ConvertFormatedFloat("{0:F2}", salaryWithTax[i].ToString()); salaryEntry.teacherCostWithoutTax = CommonUtility.ConvertFormatedFloat("{0:F2}", salaryWithoutTax[i].ToString()); salaryEntry.teacherTotalCost = CommonUtility.ConvertFormatedFloat("{0:F2}", ((salaryEntry.teacherCostWithTax - float.Parse(CommonUtility.CalculateTax(decimal.Parse(salaryEntry.teacherCostWithTax.ToString())).ToString())) + salaryEntry.teacherCostWithoutTax).ToString()); int monthValue = monthDateTime.Month; salaryEntry.salaryMonth = (monthDateTime.Year + "-" + (monthValue < 10 ? "0" + monthValue.ToString() : monthValue.ToString())); dalse.AddSalaryEntry(salaryEntry); monthDateTime = monthDateTime.AddMonths(1); } }
protected void SalaryEntryManage_ItemCommand(object source, DataListCommandEventArgs e) { DalOperationAboutSalaryEntry dal = new DalOperationAboutSalaryEntry(); if (e.CommandName == "delete") { string salaryEntryId = SalaryEntryList.DataKeys[e.Item.ItemIndex].ToString(); dal.DelSalaryEntry(int.Parse(salaryEntryId)); Javascript.AlertAndRedirect("删除成功", "/Administrator/SalaryManage.aspx?fragment=5&page=" + pageIndex + "&termTag=" + this.SalaryQuery_TermTag.SelectedValue.Trim() + "&salaryMonth=" + this.SalaryQuery_SalaryMonth.Value.Trim() + "&teacherName=" + this.SalaryQuery_Name.Text.Trim(), Page); } }