public void BindData(ReportFilter filter)
{
try
{
const string hrDepartment = @"Trần Thị Việt Hồng";
const string creator = @"Trần Thị Thu";
var toDate = filter.ReportedDate;
lblReportDate.Text = string.Format(lblReportDate.Text, toDate.Day, toDate.Month, toDate.Year);
lblHRDepartment.Text = hrDepartment;
lblCreator.Text = creator;
// get organization
var organization = cat_DepartmentServices.GetByDepartments(filter.SessionDepartment);
if (organization == null)
{
return;
}
var departments = filter.SelectedDepartment;
var arrDepartment = departments.Split(new[] { ',' }, StringSplitOptions.None);
for (var i = 0; i < arrDepartment.Length; i++)
{
arrDepartment[i] = "'{0}'".FormatWith(arrDepartment[i]);
}
var table = SQLHelper.ExecuteTable(
SQLManagementAdapter.GetStore_ListEmployeeFamilyRelation(filter.RecordId,
string.Join(",", arrDepartment), filter.WhereClause));
DataSource = table;
//binding data
xrCellEmployeeCode.DataBindings.Add("Text", DataSource, "EmployeeCode");
xrCellFullName.DataBindings.Add("Text", DataSource, "FullName");
xrCellDependenceNumber.DataBindings.Add("Text", DataSource, "DependenceNumber");
xrCellDepartmentName.DataBindings.Add("Text", DataSource, "DepartmentName");
}
catch (Exception ex)
{
Dialog.ShowNotification("Có lỗi xảy ra ", ex.Message);
}
}
