public void BindData(ReportFilter filter)
{
try
{
var controler = new ReportController();
xrl_TenCongTy.Text = ReportController.GetInstance().GetCompanyName(filter.SessionDepartment);
var location = controler.GetCityName(filter.SessionDepartment);
xrt_ReportDate.Text = string.Format(xrt_ReportDate.Text, location, DateTime.Now.Day, DateTime.Now.Month,
DateTime.Now.Year);
//select form db
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_ListEmployeeHaveDeduction(string.Join(",", departments)));
DataSource = table;
xrt_FullName.DataBindings.Add("Text", DataSource, "FullName");
xrt_EmployeeCode.DataBindings.Add("Text", DataSource, "EmployeeCode");
xrt_Position.DataBindings.Add("Text", DataSource, "PositionName");
xrt_NumberPeople.DataBindings.Add("Text", DataSource, "");
GroupHeader.GroupFields.AddRange(new GroupField[]
{
new GroupField("DepartmentId", XRColumnSortOrder.Ascending)
});
xrt_DepartmentName.DataBindings.Add("Text", DataSource, "DepartmentName");
}
catch (Exception ex)
{
Dialog.ShowError("Có lỗi xảy ra: " + ex.Message);
}
}
