public void BindData(ReportFilter filter) { try { xrl_TenCongTy.Text = ReportController.GetInstance().GetCompanyName(filter.SessionDepartment); var location = new ReportController().GetCityName(filter.SessionDepartment); xrtngayketxuat.Text = string.Format(xrtngayketxuat.Text, location, DateTime.Now.Day, DateTime.Now.Month, DateTime.Now.Year); var month = filter.StartMonth != 0 ? filter.StartMonth : 1; var year = filter.Year < 1900 ? DateTime.Now.Year : filter.Year; // get organization var organization = cat_DepartmentServices.GetByDepartments(filter.SessionDepartment); if (organization == null) { return; } //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_ExpiredContractInMonth( string.Join(",", departments), month, year)); DataSource = table; //binding data xrt_EmployeeCode.DataBindings.Add("Text", DataSource, "EmployeeCode"); xrt_FullName.DataBindings.Add("Text", DataSource, "FullName"); xrt_Sex.DataBindings.Add("Text", DataSource, "SexName"); xrt_Department.DataBindings.Add("Text", DataSource, "DepartmentName"); xrt_ContractDate.DataBindings.Add("Text", DataSource, "ContractDate", "{0:dd/MM/yyyy}"); xrt_ContractEndDate.DataBindings.Add("Text", DataSource, "ContractEndDate", "{0:dd/MM/yyyy}"); xrt_Position.DataBindings.Add("Text", DataSource, "PositionName"); xrt_ContractType.DataBindings.Add("Text", DataSource, "ContractTypeName"); xrt_Education.DataBindings.Add("Text", DataSource, "EducationName"); GroupHeader1.GroupFields.AddRange(new[] { new GroupField("DepartmentId", XRColumnSortOrder.Ascending) }); xrDepartmentName.DataBindings.Add("Text", DataSource, "DepartmentName"); } catch (Exception ex) { Dialog.Alert("Có lỗi xảy ra: " + ex.Message); } }