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