public void BindData(ReportFilter filter)
{
const string type = "ThuyenChuyenDieuChuyen";
var recordId = filter.RecordId;
var fromDate = filter.StartDate != null?filter.StartDate.Value.ToString("yyyy-dd-MM") : string.Empty;
var endDate = filter.EndDate != null?filter.EndDate.Value.ToString("yyyy-dd-MM") : string.Empty;
var toDate = filter.ReportedDate;
lblOldDate.Text = string.Format(lblOldDate.Text, toDate.Day, toDate.Month, toDate.Year);
lblNewDate.Text = string.Format(lblOldDate.Text, toDate.Day, toDate.Month, toDate.Year);
lblOldDateFooter.Text = string.Format(lblOldDate.Text, toDate.Day, toDate.Month, toDate.Year);
lblNewDateFooter.Text = string.Format(lblOldDate.Text, toDate.Day, toDate.Month, toDate.Year);
// get organization
var people = hr_RecordServices.GetById(recordId);
if (people == null)
{
return;
}
lblFullName.Text = people.FullName;
lblEmployeeCode.Text = people.EmployeeCode;
var table = SQLHelper.ExecuteTable(
SQLManagementAdapter.GetStore_PaperRequestTransfer(recordId, type, fromDate, endDate));
DataSource = table;
xrTableCellOldPosition.DataBindings.Add("Text", DataSource, "OldPosition");
xrTableCellOldSalary.DataBindings.Add("Text", DataSource, "OldSalary");
xrTableCellOldEffectiveDate.DataBindings.Add("Text", DataSource, "OldEffectiveDate", "{0:dd/MM/yyyy}");
xrTableCellNewPosition.DataBindings.Add("Text", DataSource, "NewPosition");
xrTableCellNewSalary.DataBindings.Add("Text", DataSource, "NewSalary");
xrTableCellNewEffectiveDate.DataBindings.Add("Text", DataSource, "NewEffectiveDate", "{0:dd/MM/yyyy}");
}