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