public void BindData(ReportFilter filter)
{
try
{
ReportController rpCtr = new ReportController();
xrl_TenCongTy.Text = rpCtr.GetCompanyName(filter.SessionDepartment);
var location = rpCtr.GetCityName(filter.SessionDepartment);
xrtReportDate.Text = string.Format(xrtReportDate.Text, location, DateTime.Now.Day, DateTime.Now.Month,
DateTime.Now.Year);
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_ListEmployeeJoinSocialInsurance(string.Join(",", departments)));
DataSource = table;
//Binding data
xrtEmployeeCode.DataBindings.Add("Text", DataSource, "EmployeeCode");
xrtFullName.DataBindings.Add("Text", DataSource, "FullName");
xrtBirthDate.DataBindings.Add("Text", DataSource, "BirthDate", "{0:dd/MM/yyyy}");
xrtSex.DataBindings.Add("Text", DataSource, "SexName");
xrtAddress.DataBindings.Add("Text", DataSource, "Address");
xrtPhone.DataBindings.Add("Text", DataSource, "CellPhoneNumber");
xrtInsuranceIssueDate.DataBindings.Add("Text", DataSource, "InsuranceIssueDate", "{0:dd/MM/yyyy}");
xrtInsuranceNumber.DataBindings.Add("Text", DataSource, "InsuranceNumber");
xrtPosition.DataBindings.Add("Text", DataSource, "PositionName");
GroupHeader1.GroupFields.AddRange(new[] { new GroupField("DepartmentId", XRColumnSortOrder.Ascending) });
xrtDepartmentName.DataBindings.Add("Text", DataSource, "DepartmentName");
}
catch (Exception ex)
{
Dialog.ShowError(ex.Message);
}
}
