public EmployeeSalaryHistory GetEmployeeSalaryHistoryByPKID(int pkid)
{
SqlCommand cmd = new SqlCommand();
cmd.Parameters.Add(_ParmPKID, SqlDbType.Int).Value = pkid;
using (SqlDataReader sdr = SqlHelper.ExecuteReader("GetEmployeeSalaryHistoryByPKID", cmd))
{
while (sdr.Read())
{
EmployeeSalaryHistory salaryHistory = new EmployeeSalaryHistory();
salaryHistory.EmployeeAccountSet = new AccountSet((int)sdr[_DBAccountSetID], sdr[_DBAccountSetName].ToString());
salaryHistory.HistoryId = (int)sdr[_DBPKID];
byte[] employeeAccountSetItems = sdr[_DBEmployeeAccountSetItems] as byte[];
if (employeeAccountSetItems != null)
{
salaryHistory.EmployeeAccountSet.Items = DeserializeAccountSetItems(employeeAccountSetItems);
}
salaryHistory.EmployeeSalaryStatus = EmployeeSalaryStatusEnum.GetEmployeeSalaryStatusEnum((int)sdr[_DBStatus]);
salaryHistory.AccountsBackName = sdr[_DBAccountsBackName].ToString();
salaryHistory.VersionNumber = (int)sdr[_DBVersionNumber];
salaryHistory.SalaryDateTime = Convert.ToDateTime(sdr[_DBSalaryDateTime]);
salaryHistory.Description = sdr[_DBDescpriton].ToString();
return(salaryHistory);
}
}
return(null);
}
public static string EmployeeSalaryStatusDisplay(EmployeeSalaryStatusEnum employeeSalaryStatusEnum)
{
switch (employeeSalaryStatusEnum.Id)
{
case 0:
return("ÔÝ´æ");
case 1:
return("·âÕÊ");
case 2:
return("½â·â");
default:
return("");
}
}
public List <EmployeeSalary> GetEmployeeSalaryByCondition(DateTime salaryTime, int accountSetId)
{
List <EmployeeSalary> employeeSalarys = new List <EmployeeSalary>();
SqlCommand cmd = new SqlCommand();
//cmd.Parameters.Add(_ParmName, SqlDbType.NVarChar,50).Value = name;
cmd.Parameters.Add(_ParmSalaryDateTime, SqlDbType.DateTime).Value = salaryTime;
//cmd.Parameters.Add(_ParmDepartmentID, SqlDbType.Int).Value = departmentId;
//cmd.Parameters.Add(_ParmpositionID, SqlDbType.Int).Value = positionId;
cmd.Parameters.Add(_ParmAccountSetID, SqlDbType.Int).Value = accountSetId;
//cmd.Parameters.Add(_ParmEmployeeType, SqlDbType.Int).Value = employeeType;
using (SqlDataReader sdr = SqlHelper.ExecuteReader("GetEmployeeSalaryByCondition", cmd))
{
while (sdr.Read())
{
EmployeeSalary salary = new EmployeeSalary((int)sdr[_DBEmployeeId]);
//salary.EmployeeName = sdr[_DBEmployeeName].ToString();
salary.EmployeeSalaryHistoryList = new List <EmployeeSalaryHistory>();
EmployeeSalaryHistory salaryHistory = new EmployeeSalaryHistory();
salaryHistory.HistoryId = (int)sdr[_DBPKID];
salaryHistory.EmployeeAccountSet = new AccountSet((int)sdr[_DBAccountSetID], sdr[_DBAccountSetName].ToString());
byte[] employeeAccountSetItems = sdr[_DBEmployeeAccountSetItems] as byte[];
if (employeeAccountSetItems != null)
{
salaryHistory.EmployeeAccountSet.Items = DeserializeAccountSetItems(employeeAccountSetItems);
}
salaryHistory.EmployeeSalaryStatus = EmployeeSalaryStatusEnum.GetEmployeeSalaryStatusEnum((int)sdr[_DBStatus]);
salaryHistory.AccountsBackName = sdr[_DBAccountsBackName].ToString();
salaryHistory.VersionNumber = (int)sdr[_DBVersionNumber];
salaryHistory.SalaryDateTime = Convert.ToDateTime(sdr[_DBSalaryDateTime]);
salaryHistory.Description = sdr[_DBDescpriton].ToString();
salary.EmployeeSalaryHistoryList.Add(salaryHistory);
employeeSalarys.Add(salary);
}
}
return(employeeSalarys);
}
