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; } }