public void BindData(ReportFilter filter)
{
try
{
var age = 16;
var arrDepartment = string.IsNullOrEmpty(filter.SelectedDepartment)
? new string[] { }
: filter.SelectedDepartment.Split(new[] { "," }, StringSplitOptions.RemoveEmptyEntries);
for (var i = 0; i < arrDepartment.Length; i++)
{
arrDepartment[i] = "'{0}'".FormatWith(arrDepartment[i]);
}
var control = new ReportController();
var location = control.GetCityName(filter.SessionDepartment);
lblReportDate.Text = string.Format(lblReportDate.Text, location, DateTime.Now.Day,
DateTime.Now.Month, DateTime.Now.Year);
var table = SQLHelper.ExecuteTable(
SQLManagementAdapter.GetStore_InformationRelativesReceivesMid_AutumnFestival(
string.Join(",", arrDepartment), age));
DataSource = table;
xrTableCellFullName.DataBindings.Add("Text", DataSource, "FullName");
xrTableCellSex.DataBindings.Add("Text", DataSource, "Sex");
xrTableCellBirthYear.DataBindings.Add("Text", DataSource, "BirthYear");
xrTableCellParentName.DataBindings.Add("Text", DataSource, "ParentName");
xrTableCellEmployeeCode.DataBindings.Add("Text", DataSource, "EmployeeCode");
GroupHeader2.GroupFields.AddRange(new[] {
new GroupField("DepartmentId", XRColumnSortOrder.Ascending)
});
xrGroupConstruction.DataBindings.Add("Text", DataSource, "DepartmentName");
}
catch
{
}
}
