/// <summary> /// 页面点击下一步时候触发动作 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void AddSalaryValue_Forward(object sender, EventArgs e) { SalaryEntry salaryEntry = new SalaryEntry(); BuildInSalaryItemValueList(salaryEntry); BuildOutSalaryItemValueList(salaryEntry); string tid = this.teacherNo.Value; string cid = this.courseNo.Value; string acType = this.atCourseType.Value; string teacherType = this.teacherType.Value; if (salaryEntry.teacherTotalCost <= 0) { Javascript.Alert("该老师本月发放薪酬应该为大于0的数值,请核对后再次录入", Page); } else { Javascript.JavaScriptLocationHref("/Administrator/AddSalaryEntryConfirm.aspx?tid=" + tid + "&inValueList=" + salaryEntry.GetSalaryInItemValueList() + "&outValueList=" + salaryEntry.GetSalaryOutItemValueList() + "&totalCost=" + salaryEntry.teacherTotalCost + "&withTax=" + salaryEntry.teacherCostWithTax + "&withoutTax=" + salaryEntry.teacherCostWithoutTax + "&cid=" + cid + "&acType=" + acType + "&teacherType=" + teacherType, Page); } }
/// <summary> /// 添加一条SalaryEntry记录 /// </summary> /// <param name="salaryEntry"></param> public void AddSalaryEntry(SalaryEntry salaryEntry) { try { string commandString = "INSERT INTO [USTA].[dbo].[usta_salaryEntry]([teacherNo],[teacherType],[courseNo],[atCourseType], [salaryInItemValueList],[salaryOutItemValueList],[salaryInAdjustFactor],[salaryOutAdjustFactor],[teachPeriod],[teachAssiPeriod],[termTag],[teacherCostWithTax],[teacherCostWithoutTax], [teacherTotalCost],[salaryMonth],[salaryEntryStatus],[memo] , [createdTime]) VALUES (@teacherNo, @teacherType,@courseNo, @atCourseType, @salaryInItemValueList, @salaryOutItemValueList, @salaryInAdjustFactor, @salaryOutAdjustFactor, @teachPeriod, @teachAssiPeriod, @termTag, @teacherCostWithTax, @teacherCostWithoutTax, @teacherTotalCost, @salaryMonth,@salaryEntryStatus,@memo, @createdTime)"; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@teacherNo", salaryEntry.teacher.teacherNo), new SqlParameter("@teacherType", salaryEntry.teacherType), new SqlParameter("@courseNo", salaryEntry.course == null ? null : salaryEntry.course.courseNo), new SqlParameter("@atCourseType", salaryEntry.atCourseType), new SqlParameter("@salaryInItemValueList", salaryEntry.GetSalaryInItemValueList()), new SqlParameter("@salaryOutItemValueList", salaryEntry.GetSalaryOutItemValueList()), new SqlParameter("@salaryInAdjustFactor", salaryEntry.salaryInAdjustFactor), new SqlParameter("@salaryOutAdjustFactor", salaryEntry.salaryOutAdjustFactor), new SqlParameter("@teachPeriod", salaryEntry.teachPeriod), new SqlParameter("@teachAssiPeriod", salaryEntry.teachAssiPeriod), new SqlParameter("@termTag", salaryEntry.termTag), new SqlParameter("@teacherCostWithTax", salaryEntry.teacherCostWithTax), new SqlParameter("@teacherCostWithoutTax", salaryEntry.teacherCostWithoutTax), new SqlParameter("@teacherTotalCost", salaryEntry.teacherTotalCost), new SqlParameter("@salaryMonth", salaryEntry.salaryMonth), new SqlParameter("@salaryEntryStatus", "1"), new SqlParameter("@memo", salaryEntry.memo), new SqlParameter("@createdTime", DateTime.Now.ToString()) }; SqlHelper.ExecuteNonQuery(conn, CommandType.Text, commandString, parameters); } catch (Exception ex) { MongoDBLog.LogRecord(ex); CommonUtility.RedirectUrl(); } finally { conn.Close(); } }