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)); }