public void BindData(ReportFilter filter) { try { var controler = new ReportController(); xrl_TenCongTy.Text = ReportController.GetInstance().GetCompanyName(filter.SessionDepartment); var location = controler.GetCityName(filter.SessionDepartment); xrt_ReportDate.Text = string.Format(xrt_ReportDate.Text, location, DateTime.Now.Day, DateTime.Now.Month, DateTime.Now.Year); //select form db var departments = string.IsNullOrEmpty(filter.SelectedDepartment) ? new string[] { } : filter.SelectedDepartment.Split(new[] { "," }, StringSplitOptions.RemoveEmptyEntries); for (int i = 0; i < departments.Length; i++) { departments[i] = "'{0}'".FormatWith(departments[i]); } var table = SQLHelper.ExecuteTable( SQLManagementAdapter.GetStore_ListEmployeeHaveDeduction(string.Join(",", departments))); DataSource = table; xrt_FullName.DataBindings.Add("Text", DataSource, "FullName"); xrt_EmployeeCode.DataBindings.Add("Text", DataSource, "EmployeeCode"); xrt_Position.DataBindings.Add("Text", DataSource, "PositionName"); xrt_NumberPeople.DataBindings.Add("Text", DataSource, ""); GroupHeader.GroupFields.AddRange(new GroupField[] { new GroupField("DepartmentId", XRColumnSortOrder.Ascending) }); xrt_DepartmentName.DataBindings.Add("Text", DataSource, "DepartmentName"); } catch (Exception ex) { Dialog.ShowError("Có lỗi xảy ra: " + ex.Message); } }