public static SalarySheetItem[] GetSalarySheetItem(int year, int month, Guid DepartmentId)
{
object obj = SqlHelper.ExecuteScalar(@"select Id from T_SalarySheet where
Year=@Year and Month=@Month and DeptId=@DeptId",
new SqlParameter("@Year", year),
new SqlParameter("@Month", month),
new SqlParameter("@DeptId", DepartmentId));
Guid sheetId = (Guid)obj;
DataTable table = SqlHelper.ExecuteDataTable("select * from T_SalarySheetItem where SheetId=@sheetId",
new SqlParameter("@sheetId", sheetId));
SalarySheetItem[] items = new SalarySheetItem[table.Rows.Count];
for (int i = 0; i < table.Rows.Count; i++)
{
SalarySheetItem item = new SalarySheetItem();
DataRow row = table.Rows[i];
item.Id = (Guid)row["Id"];
item.EmployeeId = (Guid)row["EmployeeId"];
item.SheetId = (Guid)row["SheetId"];
item.BaseSalary = (decimal)row["BaseSalary"];
item.Bonus = (decimal)row["Bonus"];
item.Fine = (decimal)row["Fine"];
item.Other = (decimal)row["Other"];
items[i] = item;
}
return items;
}
public static void UpdateSalarySheet(SalarySheetItem item)
{
SqlHelper.ExcuteNonQuery(@"update T_SalarySheetItem set BaseSalary=@BaseSalary,
Bonus=@Bonus,Fine=@Fine,Other=@Other where Id=@Id",
new SqlParameter("@BaseSalary",item.BaseSalary),
new SqlParameter("@Bonus",item.Bonus),
new SqlParameter("@Fine",item.Fine),
new SqlParameter("@Other",item.Other),
new SqlParameter("@Id",item.Id));
}
