//更新到正式表
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();
}
}
