public void BindData(ReportFilter filter)
{
try
{
var toDate = filter.ReportedDate;
xrDate.Text = string.Format(xrDate.Text, toDate.Month, toDate.Year);
var organization = cat_DepartmentServices.GetByDepartments(filter.SessionDepartment);
if (organization == null)
{
return;
}
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 table = SQLHelper.ExecuteTable(
SQLManagementAdapter.GetStore_BaoCaoTongHopNgheNghiepNhanSu(
string.Join(",", arrDepartment), filter.WhereClause));
DataSource = table;
xrTableCellHoVaTen.DataBindings.Add("Text", DataSource, "TeamName");
xrTableCellSoLuongNhanSu.DataBindings.Add("Text", DataSource, "xTeam");
GroupHeader1.GroupFields.AddRange(new[] {
new GroupField("DepartmentId", XRColumnSortOrder.Ascending)
});
xrGroupDepartment.DataBindings.Add("Text", DataSource, "DepartmentName");
xrTotalDepartment.DataBindings.Add("Text", DataSource, "xDepartment");
GroupHeader2.GroupFields.AddRange(new[] {
new GroupField("ConstructionId", XRColumnSortOrder.Ascending)
});
xrGroupConstruction.DataBindings.Add("Text", DataSource, "ConstructionName");
xrTotalConstruction.DataBindings.Add("Text", DataSource, "xConstruction");
xrTableCellTotal.DataBindings.Add("Text", DataSource, "xEmployee");
}
catch
{
}
}
