public void BindData(ReportFilter filter) { try { // lấy thông tin chung xrl_TenCongTy.Text = ReportController.GetInstance().GetCompanyName(filter.SessionDepartment); var location = new ReportController().GetCityName(filter.SessionDepartment); xrt_ReportDate.Text = string.Format(xrt_ReportDate.Text, location, DateTime.Now.Day, DateTime.Now.Month, DateTime.Now.Year); //Lấy thông tin của nhân viên var record = RecordController.GetById(filter.RecordId); if (record != null) { xrl_HoTen.Text = record.FullName; xrl_PhongBan.Text = record.DepartmentName; xrl_ChucVu.Text = record.PositionName; xrl_ViTriCongViec.Text = ""; xr_TuyenChinhThuc.Text = record.ParticipationDate.ToString(); } //Tính thâm niên của nhân viên var seniority = SQLHelper.ExecuteTable( SQLManagementAdapter.GetStore_CalculateSeniorityByRecordId(filter.RecordId)); if (seniority.Rows.Count > 0) { xrThamNien.Text = seniority.Rows[0]["Seniority"].ToString(); } // lấy danh sách người phụ thuộc var table = SQLHelper.ExecuteTable( SQLManagementAdapter.GetStore_ListEmployeeDependence(filter.RecordId)); DataSource = table; xrt_FullName.DataBindings.Add("Text", DataSource, "FullName"); xrt_BirthYear.DataBindings.Add("Text", DataSource, "BirthYear"); xrt_Sex.DataBindings.Add("Text", DataSource, "SexName"); xrt_Relation.DataBindings.Add("Text", DataSource, "RelationName"); xrt_Occupation.DataBindings.Add("Text", DataSource, "Occupation"); xrt_WorkPlace.DataBindings.Add("Text", DataSource, "WorkPlace"); xrt_IDNumber.DataBindings.Add("Text", DataSource, "IDNumber"); xrt_Note.DataBindings.Add("Text", DataSource, "Note"); } catch (Exception ex) { Dialog.ShowNotification("Có lỗi xảy ra ", ex.Message); } }