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); } }
public void BindData(ReportFilter filter) { try { ReportController rpCtr = new ReportController(); xrl_TenCongTy.Text = rpCtr.GetCompanyName(filter.SessionDepartment); var location = new ReportController().GetCityName(filter.SessionDepartment); xrtReportDate.Text = string.Format(xrtReportDate.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_FullName.Text = record.FullName; xrl_DepartmentName.Text = record.DepartmentName; xrl_Position.Text = record.PositionName; xrl_Occupation.Text = ""; xr_ParticipationDate.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) { xrt_Seniority.Text = seniority.Rows[0]["Seniority"].ToString(); } var table = SQLHelper.ExecuteTable( SQLManagementAdapter.GetStore_ListContractOfEmployee(filter.RecordId)); DataSource = table; xrt_ContractNumber.DataBindings.Add("Text", DataSource, "ContractNumber"); xrt_ContractType.DataBindings.Add("Text", DataSource, "ContractTypeName"); xrt_Job.DataBindings.Add("Text", DataSource, "JobName"); xrt_ContractDate.DataBindings.Add("Text", DataSource, "ContractDate", "{0:dd/MM/yyyy}"); xrt_EffectiveDate.DataBindings.Add("Text", DataSource, "EffectiveDate", "{0:dd/MM/yyyy}"); xrt_ContractEndDate.DataBindings.Add("Text", DataSource, "ContractEndDate", "{0:dd/MM/yyyy}"); xrt_ContractStatus.DataBindings.Add("Text", DataSource, "ContractStatusName"); } catch (Exception ex) { Dialog.ShowError("Có lỗi xảy ra: " + ex.Message); } }