public bool SaveStaffSalary(StaffSalary staffSalary)
{
//throw new NotImplementedException();
IStaffSalaryDAL dAL = new StaffSalaryDAL();
if (dAL.QueryById(staffSalary.Id) != null)
{
if (dAL.Update(staffSalary) > 0)
{
return(true);
}
else
{
return(false);
}
}
else
{
if (dAL.Add(staffSalary) > 0)
{
return(true);
}
else
{
return(false);
}
}
}
public StaffSalary GetStaffSalaryById(int id)
{
//throw new NotImplementedException();
IStaffSalaryDAL dAL = new StaffSalaryDAL();
return(dAL.QueryById(id));
}
public List <SalaryPayment> GetAllSalaryPayment()
{
//throw new NotImplementedException();
List <SalaryPayment> list = new List <SalaryPayment>();
ISalaryPaymentDAL salaryPaymentDAL = new SalaryPaymentDAL();
IStaffSalaryDAL staffSalaryDAL = new StaffSalaryDAL();
IStaffPaymentDAL staffPaymentDAL = new StaffPaymentDAL();
string sql = @"SELECT COUNT(ss.id) totalPerson, SUM(s.total) totalAmout, ss.tOrgId FROM StaffSalary ss, SalaryStandard s WHERE ss.standardId = s.id GROUP BY ss.tOrgId";
using (SqlDataReader reader = SQLHelper.ExecuteReader(sql))
{
if (reader.HasRows)
{
while (reader.Read())
{
SalaryPayment salaryPayment = new SalaryPayment
{
TotalPerson = Convert.ToInt32(reader["totalPerson"]),
TotalAmout = Convert.ToDecimal(reader["totalAmout"]),
TOrgId = Convert.ToInt32(reader["tOrgId"])
};
salaryPayment.FileNumber = Guid.NewGuid().ToString();
salaryPayment.FileState = EnumState.SalaryPaymentStateEnum.WaitRegist;
salaryPayment.RegistTime = DateTime.Now;
salaryPayment.TotalReal = 0;
salaryPayment.Registrant = "未登记";
salaryPayment.CheckBy = "未审核";
salaryPayment.CheckTime = DateTime.Now;
list.Add(salaryPayment);
}
}
else
{
list = null;
}
}
if (list != null)
{
foreach (var salaryPayment in list)
{
salaryPaymentDAL.Add(salaryPayment);
}
}
List <SalaryPayment> paymentList = new List <SalaryPayment>();
List <StaffSalary> allStaff = staffSalaryDAL.Query();
foreach (var p in list)
{
paymentList.Add(salaryPaymentDAL.GetSalaryPaymentByFileNumber(p.FileNumber));
}
foreach (var p in paymentList)
{
foreach (var s in allStaff)
{
if (s.TOrgId == p.TOrgId)
{
staffPaymentDAL.Add(new StaffPayment {
PaymentId = p.Id, StaffSalaryId = s.Id, OddAmout = 0, MinusAmout = 0
});
}
}
}
return(paymentList);
}
