public void BindData()
{
try
{
// from date
var fromDate = _filter.StartDate != null?_filter.StartDate.Value.ToString("yyyy-MM-dd 00:00:00") : string.Empty;
// to date
var toDate = _filter.EndDate != null?_filter.EndDate.Value.ToString("yyyy-MM-dd 23:59:59") : string.Empty;
// select form db
var table = SQLHelper.ExecuteTable(SQLReportAdapter.GetStore_EmployeeIsFemale(string.Join(",", _filter.Departments.Split(
new[] { "," }, StringSplitOptions.RemoveEmptyEntries).Select(d => "'{0}'".FormatWith(d))), fromDate, toDate, _filter.Condition));
DataSource = table;
xrCellEmployeeCode.DataBindings.Add("Text", DataSource, "EmployeeCode");
xrCellFullName.DataBindings.Add("Text", DataSource, "FullName");
xrCellPosition.DataBindings.Add("Text", DataSource, "PositionName");
xrCellDepartment.DataBindings.Add("Text", DataSource, "DepartmentName");
xrCellWorkingDate.DataBindings.Add("Text", DataSource, "StartDate", "{0:dd/MM/yyyy}");
xrCellBirthYear.DataBindings.Add("Text", DataSource, "BirthDate", "{0:dd/MM/yyyy}");
xrCellNote.DataBindings.Add("Text", DataSource, "Note");
GroupHeader1.GroupFields.AddRange(new[] { new GroupField("DepartmentId", XRColumnSortOrder.Ascending) });
xrt_GroupDepartment.DataBindings.Add("Text", DataSource, "DepartmentName");
// other items
// label report title
if (!string.IsNullOrEmpty(_filter.ReportTitle))
{
lblReportTitle.Text = _filter.ReportTitle;
}
// lablel duration
if (_filter.StartDate != null && _filter.EndDate != null)
{
lblDuration.Text = lblDuration.Text.FormatWith(_filter.StartDate.Value.ToString("dd/MM/yyyy"),
_filter.EndDate.Value.ToString("dd/MM/yyyy"));
}
else
{
lblDuration.Text = string.Empty;
}
// label report date
lblReportDate.Text = lblReportDate.Text.FormatWith(_filter.ReportDate.Day, _filter.ReportDate.Month, _filter.ReportDate.Year);
// created by
if (!string.IsNullOrEmpty(_filter.CreatedByTitle))
{
lblCreatedByTitle.Text = _filter.CreatedByTitle;
}
if (!string.IsNullOrEmpty(_filter.CreatedByName))
{
lblCreatedByName.Text = _filter.CreatedByName;
}
// reviewed by
//if(!string.IsNullOrEmpty(_filter.ReviewedByTitle)) lblReviewedByTitle.Text = _filter.ReviewedByTitle;
//if(!string.IsNullOrEmpty(_filter.ReviewedByName)) lblReviewedByName.Text = _filter.ReviewedByName;
// signed by
if (!string.IsNullOrEmpty(_filter.SignedByTitle))
{
lblSignedByTitle.Text = _filter.SignedByTitle;
}
if (!string.IsNullOrEmpty(_filter.SignedByName))
{
lblSignedByName.Text = _filter.SignedByName;
}
}
catch (Exception ex)
{
Dialog.ShowError(ex);
}
}
/// <summary>
/// DataBind
/// </summary>
public void BindData()
{
try
{
//Lấy thông tin của nhân viên
var record = RecordController.GetById(_filter.RecordId);
if (record != null)
{
xrl_FullName.Text = record.FullName;
xrl_DepartmentName.Text = record.DepartmentName;
xrl_Position.Text = record.PositionName;
xrl_Occupation.Text = "";
xr_ParticipationDate.Text = record.ParticipationDateVn;
}
//Tính thâm niên của nhân viên
var seniority = SQLHelper.ExecuteTable(SQLReportAdapter.GetStore_CalculateSeniority(_filter.RecordId));
if (seniority.Rows.Count > 0)
{
xrt_Seniority.Text = seniority.Rows[0]["Seniority"].ToString();
}
// from date
var fromDate = _filter.StartDate != null?_filter.StartDate.Value.ToString("yyyy-MM-dd 00:00:00") : string.Empty;
// to date
var toDate = _filter.EndDate != null?_filter.EndDate.Value.ToString("yyyy-MM-dd 23:59:59") : string.Empty;
// select form db
var table = SQLHelper.ExecuteTable(SQLReportAdapter.GetStore_ContractOfEmployee(_filter.RecordId, fromDate, toDate, _filter.Condition));
DataSource = table;
xrt_ContractNumber.DataBindings.Add("Text", DataSource, "ContractNumber");
xrt_ContractType.DataBindings.Add("Text", DataSource, "ContractTypeName");
xrt_Job.DataBindings.Add("Text", DataSource, "JobName");
xrt_ContractDate.DataBindings.Add("Text", DataSource, "ContractDate", "{0:dd/MM/yyyy}");
xrt_EffectiveDate.DataBindings.Add("Text", DataSource, "EffectiveDate", "{0:dd/MM/yyyy}");
xrt_ContractEndDate.DataBindings.Add("Text", DataSource, "ContractEndDate", "{0:dd/MM/yyyy}");
xrt_ContractStatus.DataBindings.Add("Text", DataSource, "ContractStatusName");
// other items
// label report title
if (!string.IsNullOrEmpty(_filter.ReportTitle))
{
lblReportTitle.Text = _filter.ReportTitle;
}
// lablel duration
if (_filter.StartDate != null && _filter.EndDate != null)
{
lblDuration.Text = lblDuration.Text.FormatWith(_filter.StartDate.Value.ToString("dd/MM/yyyy"),
_filter.EndDate.Value.ToString("dd/MM/yyyy"));
}
else
{
lblDuration.Text = string.Empty;
}
// label report date
lblReportDate.Text = lblReportDate.Text.FormatWith(_filter.ReportDate.Day, _filter.ReportDate.Month, _filter.ReportDate.Year);
// created by
if (!string.IsNullOrEmpty(_filter.CreatedByTitle))
{
lblCreatedByTitle.Text = _filter.CreatedByTitle;
}
if (!string.IsNullOrEmpty(_filter.CreatedByName))
{
lblCreatedByName.Text = _filter.CreatedByName;
}
// reviewed by
if (!string.IsNullOrEmpty(_filter.ReviewedByTitle))
{
lblReviewedByTitle.Text = _filter.ReviewedByTitle;
}
if (!string.IsNullOrEmpty(_filter.ReviewedByName))
{
lblReviewedByName.Text = _filter.ReviewedByName;
}
// signed by
if (!string.IsNullOrEmpty(_filter.SignedByTitle))
{
lblSignedByTitle.Text = _filter.SignedByTitle;
}
if (!string.IsNullOrEmpty(_filter.SignedByName))
{
lblSignedByName.Text = _filter.SignedByName;
}
}
catch (Exception ex)
{
Dialog.ShowError(ex);
}
}
public void BindData()
{
// from date
var fromDate = _filter.StartDate != null?_filter.StartDate.Value.ToString("yyyy-MM-dd 00:00:00") : string.Empty;
// to date
var toDate = _filter.EndDate != null?_filter.EndDate.Value.ToString("yyyy-MM-dd 23:59:59") : string.Empty;
// select form db
var table = SQLHelper.ExecuteTable(SQLReportAdapter.GetStore_EmployeeFostering(string.Join(",", _filter.Departments.Split(
new[] { "," }, StringSplitOptions.RemoveEmptyEntries).Select(d => "'{0}'".FormatWith(d))), fromDate, toDate, CONST_BUSINESS_TYPE, _filter.Condition));
DataSource = table;
GroupHeader1.GroupFields.AddRange(new[] { new GroupField("DepartmentId", XRColumnSortOrder.Ascending) });
xrDepartmentGroupHeader.DataBindings.Add("Text", DataSource, "DepartmentName");
GroupHeader2.GroupFields.AddRange(new[] { new GroupField("JobTitleId", XRColumnSortOrder.Ascending) });
xrPositionGroupHeader.DataBindings.Add("Text", DataSource, "JobTitleName");
xrTableCellFullname.DataBindings.Add("Text", DataSource, "FullName");
xrTableCellBirthday.DataBindings.Add("Text", DataSource, "BirthDate", "{0:dd/MM/yyyy}");
xrTableCellSex.DataBindings.Add("Text", DataSource, "SexName");
xrTableCellCPVMember.DataBindings.Add("Text", DataSource, "CPVPositionName");
xrTableCellFolk.DataBindings.Add("Text", DataSource, "FolkName");
xrTableCellEducation.DataBindings.Add("Text", DataSource, "EducationName");
xrTableCellPoliticLevel.DataBindings.Add("Text", DataSource, "PoliticLevelName");
xrTableCellLanguageLevel.DataBindings.Add("Text", DataSource, "LanguageLevelName");
xrTableCellITLevel.DataBindings.Add("Text", DataSource, "ITLevelName");
xrTableCellManagementLevel.DataBindings.Add("Text", DataSource, "ManagementLevelName");
xrTableCellPlanJobTitle.DataBindings.Add("Text", DataSource, "PlanJobTitleName");
xrTableCellPlanPhase.DataBindings.Add("Text", DataSource, "PlanPhaseName");
xrTableCellTrainningSystem.DataBindings.Add("Text", DataSource, "TrainingSystemName");
xrTableCellPositionDepartment.DataBindings.Add("Text", DataSource, "PositionDepartmentName");
// label org name
if (!string.IsNullOrEmpty(_filter.OrganizationName))
{
lblOrgName.Text = _filter.OrganizationName;
}
// label report title
if (!string.IsNullOrEmpty(_filter.ReportTitle))
{
lblReportTitle.Text = _filter.ReportTitle;
}
// lablel duration
if (_filter.StartDate != null && _filter.EndDate != null)
{
lblDuration.Text = lblDuration.Text.FormatWith(_filter.StartDate.Value.ToString("dd/MM/yyyy"),
_filter.EndDate.Value.ToString("dd/MM/yyyy"));
}
else
{
lblDuration.Text = string.Empty;
}
// label report date
lblReportDate.Text = lblReportDate.Text.FormatWith(_filter.ReportDate.Day, _filter.ReportDate.Month, _filter.ReportDate.Year);
// created by
if (!string.IsNullOrEmpty(_filter.CreatedByTitle))
{
lblCreatedByTitle.Text = _filter.CreatedByTitle;
}
if (!string.IsNullOrEmpty(_filter.CreatedByName))
{
lblCreatedByName.Text = _filter.CreatedByName;
}
// reviewed by
if (!string.IsNullOrEmpty(_filter.ReviewedByTitle))
{
lblReviewedByTitle.Text = _filter.ReviewedByTitle;
}
if (!string.IsNullOrEmpty(_filter.ReviewedByName))
{
lblReviewedByName.Text = _filter.ReviewedByName;
}
// signed by
if (!string.IsNullOrEmpty(_filter.SignedByTitle))
{
lblSignedByTitle.Text = _filter.SignedByTitle;
}
if (!string.IsNullOrEmpty(_filter.SignedByName))
{
lblSignedByName.Text = _filter.SignedByName;
}
}
