//更新到正式表 public void UpdateToFormalTable() { if (this.内容不同的字段.Count > 0) { return; } GradeSalaryAdjust m = GradeSalaryAdjust.GetGradeSalaryAdjust(this.薪酬体系, this.职等, this.期号, 0); if (m == null) { m = new GradeSalaryAdjust(); m.标识 = Guid.NewGuid(); } this.CopyWatchMember(m); m.Save(); //更新生效标记 if (!this.已生效) { this.生效时间 = DateTime.Now; this.Save(); GradeSalaryAdjustInput opposite = 另一人录入的记录; opposite.生效时间 = DateTime.Now; opposite.Save(); } }
void LoadData() { //分隔行没有数据 if (is_separator) { return; } 薪酬体系 = jobGrade.薪酬体系; 称 = jobGrade.称; 期号 = period; 职等 = jobGrade; RankNames = ""; 标识 = jobGrade.标识; rss_list.Clear(); List <JobRank> jobranks = JobRank.GetJobRanks(jobGrade.标识); foreach (JobRank rank in jobranks) { //本期标准 RankSalaryStandardInput rss = RankSalaryStandardInput.AddRankSalaryStandardInput(jobGrade.薪酬体系, jobGrade.称, rank.称, period, rank.序号, is_verify); rss_list.Add(rss); 开始执行日期 = rss.开始执行日期; //赋值 string propertyName = "R" + rss.序号; string monthlySalary = rss.月薪.ToString(); PropertyInfo property = this.GetType().GetProperty(propertyName); if (property != null) { property.SetValue(this, monthlySalary, null); } if (RankNames != "") { RankNames += ":"; } RankNames += rank.称; } int t = is_verify ? 2 : 1; //统计表类型:0: 正式, 1: 初次录入, 2: 验证录入 gsa = GradeSalaryAdjust.GetGradeSalaryAdjust(jobGrade.薪酬体系, jobGrade.称, period, t); if (gsa == null) { gsa = GradeSalaryAdjust.AddGradeSalaryAdjust(jobGrade.薪酬体系, jobGrade.称, period, t); gsa.Calculate(); } SetFieldValue(); }
//重新统计 public void Calculate() { int differential = 0; double total = 0; int avg = 0; double yearAdjustRate = 1; int max = 0; int min = 0; List <IRankSalary> rss_list = new List <IRankSalary>(); if (类型 == 0) { foreach (IRankSalary irs in RankSalaryStandard.GetRankSalaryStandards(this.薪酬体系, this.职等, this.期号)) { rss_list.Add(irs); } } else { foreach (IRankSalary irs in RankSalaryStandardInput.GetRankSalaryStandardInputs(this.薪酬体系, this.职等, this.期号, this.类型 == 2)) { rss_list.Add(irs); } } rss_list = rss_list.FindAll(a => a.月薪 > 0).ToList(); //过滤掉没有设置月薪的记录 if (rss_list.Count > 0) { total = rss_list.Sum(a => a.月薪); avg = (int)(total / rss_list.Count); min = rss_list.Min(a => a.月薪); max = rss_list.Max(a => a.月薪); if (rss_list.Count >= 2) { IRankSalary rss0 = rss_list[0]; IRankSalary rss1 = rss_list[1]; differential = rss0.月薪 - rss1.月薪; } } #region 计算年调率 this.每年调资额 = Convert.ToInt32(this.半年调资额 * 1.5); int previous_period = RankSalaryStandard.GetPreviousPeriod(this.薪酬体系, this.期号); GradeSalaryAdjust previous_gsh = GradeSalaryAdjust.GetGradeSalaryAdjust(this.薪酬体系, this.职等, previous_period, 0); //如果找到上期数据(通取正式数据) if (previous_gsh != null) { int avg_previous = previous_gsh.平均工资; if (avg_previous > 0) { yearAdjustRate = (double)每年调资额 / avg_previous; } } else //首次标准 { if (avg != 0) { yearAdjustRate = (double)每年调资额 / avg; } } #endregion this.级差 = differential; this.年调率 = yearAdjustRate; this.平均工资 = avg; this.最低工资 = min; this.最高工资 = max; #region 计算职等差 //获取对比的职等 GradeSalaryAdjust contrast = GradeSalaryAdjust.GetFromCache(this.薪酬体系, this.对比的职等, this.期号, this.类型); if (contrast != null) { this.职等差 = contrast.最低工资 - this.最高工资; } #endregion this.Save(); }
public ImplementJobGrade(string salaryPlan, string grade, int year, SemiannualType semiannual) { is_separator = false; this.year = year; this.period = year * 10 + (byte)semiannual; 薪酬体系 = salaryPlan; 职等 = grade; 期号 = period; ID = salaryPlan + grade + period; RankNames = ""; rss_list = RankSalaryStandard.GetRankSalaryStandards(salaryPlan, grade, period); foreach (RankSalaryStandard rss in rss_list) { 开始执行日期 = rss.开始执行日期; //赋值 string propertyName = "R" + rss.序号; string monthlySalary = rss != null?rss.月薪.ToString() : ""; PropertyInfo property = this.GetType().GetProperty(propertyName); if (property != null) { property.SetValue(this, monthlySalary, null); } if (RankNames != "") { RankNames += ":"; } RankNames += rss.职级; } GradeSalaryAdjust gsa = GradeSalaryAdjust.GetGradeSalaryAdjust(salaryPlan, grade, period, 0); if (gsa == null) { gsa = GradeSalaryAdjust.AddGradeSalaryAdjust(salaryPlan, grade, period, 0); gsa.Calculate(); } 序号 = gsa.职等数; 职等数 = gsa.职等数.ToString(); 级差 = gsa.级差.ToString(); 平均工资 = gsa.平均工资.ToString(); 最低工资 = gsa.最低工资; 最高工资 = gsa.最高工资; 对比的职等 = gsa.对比的职等; if (gsa.年调率 > 0) { 半年调资额 = gsa.半年调资额.ToString(); 年调 = gsa.每年调资额.ToString(); 半年调率 = (gsa.年调率 * 100 / 1.5).ToString("#0.#") + "%"; 年调率 = (gsa.年调率 * 100).ToString("#0.#") + "%"; } if (gsa.年调率 == 1) { 年调率 = ""; } if (!string.IsNullOrEmpty(对比的职等)) { 职等差 = gsa.职等差.ToString(); } if (gsa.期调整 != null) { 期级别平均 = gsa.期调整.平均工资.ToString(); } }