public void BindData(int id, int moiQuanHe) { DataSource = SQLHelper.ExecuteTable(SQLBusinessAdapter.GetStore_SRQuanHeGiaDinh(id, moiQuanHe)); xrRelationShipName.DataBindings.Add("Text", DataSource, "RelationshipName"); xrName.DataBindings.Add("Text", DataSource, "FullName"); xrDateOfBirth.DataBindings.Add("Text", DataSource, "Age"); xrWorkPlace.DataBindings.Add("Text", DataSource, "Note"); }
public void BindData(ReportFilter filter) { try { var reportDate = filter.ReportedDate; lblReportDate.Text = string.Format(lblReportDate.Text, reportDate.Day, reportDate.Month, reportDate.Year); var organization = cat_DepartmentServices.GetByDepartments(filter.SessionDepartment); if (organization == null) { return; } var departments = filter.SelectedDepartment; var arrDepartment = departments.Split(new[] { ',' }, StringSplitOptions.None); for (var i = 0; i < arrDepartment.Length; i++) { arrDepartment[i] = "'{0}'".FormatWith(arrDepartment[i]); } if (arrDepartment.Length > 2) { lblTitle.Text = @"BÁO CÁO CBCNV THEO PHÒNG BAN"; } else { var orgSelected = cat_DepartmentServices.GetById(Convert.ToInt32(departments.TrimEnd(','))); lblTitle.Text = string.Format(lblTitle.Text, orgSelected.Name); } // get data from date var fromDate = filter.StartDate != null ? filter.StartDate.Value.ToString("yyyy-MM-dd", CultureInfo.InvariantCulture) : string.Empty; // get data to date var toDate = filter.EndDate != null ? filter.EndDate.Value.ToString("yyyy-MM-dd", CultureInfo.InvariantCulture) : string.Empty; var table = SQLHelper.ExecuteTable( SQLBusinessAdapter.GetStore_EmployeeByDepartment(string.Join(",", arrDepartment), filter.WhereClause, fromDate, toDate)); DataSource = table; xrCellEmployeeCode.DataBindings.Add("Text", DataSource, "EmployeeCode"); xrCellFullName.DataBindings.Add("Text", DataSource, "FullName"); xrCellPosition.DataBindings.Add("Text", DataSource, "PositionName"); xrCellPhoneNumber.DataBindings.Add("Text", DataSource, "CellPhoneNumber"); xrCellDepartment.DataBindings.Add("Text", DataSource, "DepartmentName"); GroupHeader1.GroupFields.AddRange(new[] { new GroupField("DepartmentId", XRColumnSortOrder.Ascending) }); xrt_GroupDepartment.DataBindings.Add("Text", DataSource, "DepartmentName"); } catch (Exception ex) { Dialog.ShowNotification("Có lỗi xảy ra: " + ex.Message); } }
public void BindData(ReportFilter filter) { try { const string hrDepartment = @"Trần Thị Việt Hồng"; const string creator = @"Trần Thị Thu"; var reportDate = filter.ReportedDate; lblReportDate.Text = string.Format(lblReportDate.Text, reportDate.Day, reportDate.Month, reportDate.Year); lblHRDepartment.Text = hrDepartment; lblCreator.Text = creator; var organization = cat_DepartmentServices.GetByDepartments(filter.SessionDepartment); if (organization == null) { return; } var departments = filter.SelectedDepartment; var arrDepartment = departments.Split(new[] { ',' }, StringSplitOptions.None); for (var i = 0; i < arrDepartment.Length; i++) { arrDepartment[i] = "'{0}'".FormatWith(arrDepartment[i]); } // get data from date var fromDate = filter.StartDate != null ? filter.StartDate.Value.ToString("yyyy-MM-dd", CultureInfo.InvariantCulture) : string.Empty; // get data from date var toDate = filter.EndDate != null ? filter.EndDate.Value.ToString("yyyy-MM-dd", CultureInfo.InvariantCulture) : string.Empty; var table = SQLHelper.ExecuteTable( SQLBusinessAdapter.GetStore_SocialInsurance(string.Join(",", arrDepartment), filter.WhereClause, fromDate, toDate)); DataSource = table; xrCellEmployeeCode.DataBindings.Add("Text", DataSource, "EmployeeCode"); xrCellFullName.DataBindings.Add("Text", DataSource, "FullName"); xrCellBirthYear.DataBindings.Add("Text", DataSource, "BirthDate", "{0:dd/MM/yyyy}"); xrCellSocialInsuranceNumber.DataBindings.Add("Text", DataSource, "InsuranceNumber"); xrCellPosition.DataBindings.Add("Text", DataSource, "PositionName"); xrCellYearJoin.DataBindings.Add("Text", DataSource, "InsuranceIssueDate", "{0:dd/MM/yyyy}"); xrCellMoney.DataBindings.Add("Text", DataSource, "InsuranceAmount"); xrCellEmployee.DataBindings.Add("Text", DataSource, "LaborAmount"); xrCellCompany.DataBindings.Add("Text", DataSource, "EnterpriseAmount"); xrCellTotal.DataBindings.Add("Text", DataSource, "TotalAmount"); GroupHeader1.GroupFields.AddRange(new[] { new GroupField("DepartmentId", XRColumnSortOrder.Ascending) }); xrt_GroupDepartment.DataBindings.Add("Text", DataSource, "DepartmentName"); } catch (Exception ex) { Dialog.ShowNotification("Có lỗi xảy ra: " + ex.Message); } }
public void BindData(int id) { DataSource = SQLHelper.ExecuteTable(SQLBusinessAdapter.GetStore_SRQuaTrinhDaoTao(id)); xrt_tentruong.DataBindings.Add("Text", DataSource, "UniversityName"); xrt_chuyennghanh.DataBindings.Add("Text", DataSource, "IndustryName"); xrt_tuthangnam.DataBindings.Add("Text", DataSource, "thang"); xrt_hinhthuc.DataBindings.Add("Text", DataSource, "TrainingSystemName"); xrt_vanbang.DataBindings.Add("Text", DataSource, "EducationName"); }
public void BindData(ReportFilter filter) { try { ReportController rpCtr = new ReportController(); xrl_TenCongTy.Text = rpCtr.GetCompanyName(filter.SessionDepartment); var location = new ReportController().GetCityName(filter.SessionDepartment); xrtReportDate.Text = string.Format(xrtReportDate.Text, location, DateTime.Now.Day, DateTime.Now.Month, DateTime.Now.Year); //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.ParticipationDate.ToString(); } //Tính thâm niên của nhân viên var seniority = SQLHelper.ExecuteTable( SQLBusinessAdapter.GetStore_CalculateSeniorityByRecordId(filter.RecordId)); if (seniority.Rows.Count > 0) { xrt_Seniority.Text = seniority.Rows[0]["Seniority"].ToString(); } // get data from date var fromDate = filter.StartDate != null ? filter.StartDate.Value.ToString("yyyy-MM-dd", CultureInfo.InvariantCulture) : string.Empty; // get data from date var toDate = filter.EndDate != null ? filter.EndDate.Value.ToString("yyyy-MM-dd", CultureInfo.InvariantCulture) : string.Empty; var table = SQLHelper.ExecuteTable( SQLBusinessAdapter.GetStore_ListContractOfEmployee(filter.RecordId, fromDate, toDate)); 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"); } catch (Exception ex) { Dialog.ShowError("Có lỗi xảy ra: " + ex.Message); } }
public void BindData(ReportFilter filter) { try { var reportDate = filter.ReportedDate; lblReportDate.Text = string.Format(lblReportDate.Text, reportDate.Day, reportDate.Month, reportDate.Year); var organization = cat_DepartmentServices.GetByDepartments(filter.SessionDepartment); if (organization == null) { return; } var departments = filter.SelectedDepartment; var arrDepartment = departments.Split(new[] { ',' }, StringSplitOptions.None); for (var i = 0; i < arrDepartment.Length; i++) { arrDepartment[i] = "'{0}'".FormatWith(arrDepartment[i]); } // get data from date var fromDate = filter.StartDate != null ? filter.StartDate.Value.ToString("yyyy-MM-dd", CultureInfo.InvariantCulture) : string.Empty; // get data to date var toDate = filter.EndDate != null ? filter.EndDate.Value.ToString("yyyy-MM-dd", CultureInfo.InvariantCulture) : string.Empty; var table = SQLHelper.ExecuteTable( SQLBusinessAdapter.GetStore_PersonelRotation(string.Join(",", arrDepartment), fromDate, toDate, filter.WhereClause)); DataSource = table; xrCellEmployeeCode.DataBindings.Add("Text", DataSource, "EmployeeCode"); xrCellFullName.DataBindings.Add("Text", DataSource, "FullName"); xrCellCurrentPosition.DataBindings.Add("Text", DataSource, "CurrentPosition"); xrCellCurrentProject.DataBindings.Add("Text", DataSource, "CurrentProjectName"); xrCellNewPosition.DataBindings.Add("Text", DataSource, "NewPosition"); xrCellNewProject.DataBindings.Add("Text", DataSource, "NewProjectName"); xrCellRotationDate.DataBindings.Add("Text", DataSource, "DecisionDate", "{0:dd/MM/yyyy}"); GroupHeader1.GroupFields.AddRange(new[] { new GroupField("DepartmentId", XRColumnSortOrder.Ascending) }); xrt_GroupDepartment.DataBindings.Add("Text", DataSource, "DepartmentName"); } catch (Exception ex) { Dialog.ShowNotification("Có lỗi xảy ra: " + ex.Message); } }
public void BindData(ReportFilter filter) { try { lblReportDate.Text = string.Format(lblReportDate.Text, DateTime.Now.Day, DateTime.Now.Month, DateTime.Now.Year); var departments = filter.SelectedDepartment; var arrDepartment = departments.Split(new[] { "," }, StringSplitOptions.RemoveEmptyEntries); for (var i = 0; i < arrDepartment.Length; i++) { arrDepartment[i] = "'{0}'".FormatWith(arrDepartment[i]); } // get data from date var fromDate = filter.StartDate != null ? filter.StartDate.Value.ToString("yyyy-MM-dd", CultureInfo.InvariantCulture) : string.Empty; // get data from date var toDate = filter.EndDate != null ? filter.EndDate.Value.ToString("yyyy-MM-dd", CultureInfo.InvariantCulture) : string.Empty; // select form db var table = SQLHelper.ExecuteTable(SQLBusinessAdapter.GetStore_SeniorityEmployee(string.Join(",", arrDepartment), fromDate, toDate, filter.WhereClause)); DataSource = table; //binding data xrCellEmployeeCode.DataBindings.Add("Text", DataSource, "EmployeeCode"); xrCellFullName.DataBindings.Add("Text", DataSource, "FullName"); xrCellBirthYear.DataBindings.Add("Text", DataSource, "Year"); xrCellAddress.DataBindings.Add("Text", DataSource, "Address"); xrCellDegree.DataBindings.Add("Text", DataSource, "EducationName"); xrCellPosition.DataBindings.Add("Text", DataSource, "PositionName"); xrCellPhoneNumber.DataBindings.Add("Text", DataSource, "CellPhoneNumber"); xrCellDepartment.DataBindings.Add("Text", DataSource, "DepartmentName"); xrWorkingYear.DataBindings.Add("Text", DataSource, "ParticipationDate", "{0:dd/MM/yyyy}"); xrCellSeniority.DataBindings.Add("Text", DataSource, "Seniority"); GroupHeader1.GroupFields.AddRange(new[] { new GroupField("DepartmentId", XRColumnSortOrder.Ascending) }); xrt_GroupDepartment.DataBindings.Add("Text", DataSource, "DepartmentName"); } catch (Exception ex) { Dialog.ShowNotification("Có lỗi xảy ra: " + ex.Message); } }
public void BindData(ReportFilter filter) { try { const string hrDepartment = @"Trần Thị Việt Hồng"; const string creator = @"Trần Thị Thu"; var reportDate = filter.ReportedDate; lblReportDate.Text = string.Format(lblReportDate.Text, reportDate.Day, reportDate.Month, reportDate.Year); lblHRDepartment.Text = hrDepartment; lblCreator.Text = creator; var organization = cat_DepartmentServices.GetByDepartments(filter.SessionDepartment); if (organization == null) { return; } var departments = filter.SelectedDepartment; var arrDepartment = departments.Split(new[] { ',' }, StringSplitOptions.None); for (var i = 0; i < arrDepartment.Length; i++) { arrDepartment[i] = "'{0}'".FormatWith(arrDepartment[i]); } var table = SQLHelper.ExecuteTable( SQLBusinessAdapter.GetStore_EmployeeIsFemale(string.Join(",", arrDepartment), filter.WhereClause)); 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"); } catch (Exception ex) { Dialog.ShowNotification("Có lỗi xảy ra: " + ex.Message); } }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void filterRecruitmentDateStore_Store_OnRefreshData(object sender, StoreRefreshDataEventArgs e) { try { // get list recruitmentYear var table = SQLHelper.ExecuteTable(SQLBusinessAdapter.GetRecruitmentYear()); var obj = new List <object> { new { MA = -1, TEN = "Tất cả" } }; foreach (DataRow item in table.Rows) { obj.Add(new { MA = item["RecruitmentYear"], TEN = item["RecruitmentYear"] }); } filterRecruitmentDateStore.DataSource = obj; filterRecruitmentDateStore.DataBind(); } catch (Exception ex) { Dialog.Alert("Thông báo", ex.Message); } }
public void BindData(int id) { DataSource = SQLHelper.ExecuteTable(SQLBusinessAdapter.GetStore_SRQuaTrinhCongTac(id)); xrt_thangnam.DataBindings.Add("Text", DataSource, "Time"); xrt_thongtin.DataBindings.Add("Text", DataSource, "Note"); }
public void BindData(int id) { var dt = SQLHelper.ExecuteTable(SQLBusinessAdapter.GetStore_SRDienBienLuong(id)); int count1 = dt.Rows.Count; if (dt.Rows.Count > 0 && dt.Rows.Count <= 8) { for (int i = 0; i < dt.Rows.Count; i++) { if (i == 0) { thang1.Text = string.Format("{0:MM/yyyy}", dt.Rows[i][0]); bac1.Text = dt.Rows[i][1].ToString(); luong1.Text = dt.Rows[i][2].ToString(); } if (i == 1) { thang2.Text = string.Format("{0:MM/yyyy}", dt.Rows[i][0]); bac2.Text = dt.Rows[i][1].ToString(); luong2.Text = dt.Rows[i][2].ToString(); } if (i == 2) { thang3.Text = string.Format("{0:MM/yyyy}", dt.Rows[i][0]); bac3.Text = dt.Rows[i][1].ToString(); luog3.Text = dt.Rows[i][2].ToString(); } if (i == 3) { thang4.Text = string.Format("{0:MM/yyyy}", dt.Rows[i][0]); bac4.Text = dt.Rows[i][1].ToString(); luong4.Text = dt.Rows[i][2].ToString(); } if (i == 4) { thang5.Text = string.Format("{0:MM/yyyy}", dt.Rows[i][0]); bac5.Text = dt.Rows[i][1].ToString(); luong5.Text = dt.Rows[i][2].ToString(); } if (i == 5) { thang6.Text = string.Format("{0:MM/yyyy}", dt.Rows[i][0]); bac6.Text = dt.Rows[i][1].ToString(); luong6.Text = dt.Rows[i][2].ToString(); } if (i == 6) { thang7.Text = string.Format("{0:MM/yyyy}", dt.Rows[i][0]); bac7.Text = dt.Rows[i][1].ToString(); luong7.Text = dt.Rows[i][2].ToString(); } if (i == 7) { thang8.Text = string.Format("{0:MM/yyyy}", dt.Rows[i][0]); bac8.Text = dt.Rows[i][1].ToString(); luong8.Text = dt.Rows[i][2].ToString(); } } } else if (dt.Rows.Count >= 9) { for (int i = count1 - 8; i < dt.Rows.Count; i++) { if (i == count1 - 8) { thang1.Text = string.Format("{0:MM/yyyy}", dt.Rows[i][0]); bac1.Text = dt.Rows[i][1].ToString(); luong1.Text = dt.Rows[i][2].ToString(); } if (i == count1 - 7) { thang2.Text = string.Format("{0:MM/yyyy}", dt.Rows[i][0]); bac2.Text = dt.Rows[i][1].ToString(); luong2.Text = dt.Rows[i][2].ToString(); } if (i == count1 - 6) { thang3.Text = string.Format("{0:MM/yyyy}", dt.Rows[i][0]); bac3.Text = dt.Rows[i][1].ToString(); luog3.Text = dt.Rows[i][2].ToString(); } if (i == count1 - 5) { thang4.Text = string.Format("{0:MM/yyyy}", dt.Rows[i][0]); bac4.Text = dt.Rows[i][1].ToString(); luong4.Text = dt.Rows[i][2].ToString(); } if (i == count1 - 4) { thang5.Text = string.Format("{0:MM/yyyy}", dt.Rows[i][0]); bac5.Text = dt.Rows[i][1].ToString(); luong5.Text = dt.Rows[i][2].ToString(); } if (i == count1 - 3) { thang6.Text = string.Format("{0:MM/yyyy}", dt.Rows[i][0]); bac6.Text = dt.Rows[i][1].ToString(); luong6.Text = dt.Rows[i][2].ToString(); } if (i == count1 - 2) { thang7.Text = string.Format("{0:MM/yyyy}", dt.Rows[i][0]); bac7.Text = dt.Rows[i][1].ToString(); luong7.Text = dt.Rows[i][2].ToString(); } if (i == count1 - 1) { thang8.Text = string.Format("{0:MM/yyyy}", dt.Rows[i][0]); bac8.Text = dt.Rows[i][1].ToString(); luong8.Text = dt.Rows[i][2].ToString(); } } } // this.ReportFooter.Controls.Add(CreateXRTable(dt)); }