public void BindData(ReportFilter filter)
{
try
{
ReportController control = new ReportController();
xrTenCoQuanDonVi.Text = control.GetCompanyName(filter.SessionDepartment);
var location = new ReportController().GetCityName(filter.SessionDepartment);
lblReportDate.Text = string.Format(lblReportDate.Text, location, DateTime.Now.Day,
DateTime.Now.Month, DateTime.Now.Year);
// get organization
var organization = cat_DepartmentServices.GetByDepartments(filter.SessionDepartment);
if (organization != null)
{
var age = 16;
var giftLevel = "300.000";
//select form db
var arrOrgCode = string.IsNullOrEmpty(filter.SelectedDepartment)
? new string[] { }
: filter.SelectedDepartment.Split(new[] { "," }, StringSplitOptions.RemoveEmptyEntries);
for (int i = 0; i < arrOrgCode.Length; i++)
{
arrOrgCode[i] = "'{0}'".FormatWith(arrOrgCode[i]);
}
var table = SQLHelper.ExecuteTable(SQLManagementAdapter.GetStore_ListEmployeeHaveChildrenReceiveMidAutumnFestivalGift(string.Join(",", arrOrgCode), age));
DataSource = table;
xrTableCellGiftLevel.Text = giftLevel;
//binding data
xrTableCellEmployeeCode.DataBindings.Add("Text", DataSource, "EmployeeCode");
xrTableCellFullName.DataBindings.Add("Text", DataSource, "FullName");
xrTableCellBirthDate.DataBindings.Add("Text", DataSource, "BirthDate", "{0:dd/MM/yyyy}");
xrTableCellSex.DataBindings.Add("Text", DataSource, "Sex");
xrTableCellPosition.DataBindings.Add("Text", DataSource, "Position");
xrTableCellTypeOfContract.DataBindings.Add("Text", DataSource, "TypeOfContract");
xrTableCellNumberOfChildren.DataBindings.Add("Text", DataSource, "NumberOfChildren");
GroupHeader1.GroupFields.AddRange(new GroupField[] {
new GroupField("DepartmentId", XRColumnSortOrder.Ascending)
});
xrTableCellGroupHead.DataBindings.Add("Text", DataSource, "DepartmentName");
}
}
catch
{
}
}
