public void BindData(ReportFilter filter) { try { var age = 16; 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 control = new ReportController(); var location = control.GetCityName(filter.SessionDepartment); lblReportDate.Text = string.Format(lblReportDate.Text, location, DateTime.Now.Day, DateTime.Now.Month, DateTime.Now.Year); var table = SQLHelper.ExecuteTable( SQLManagementAdapter.GetStore_InformationRelativesReceivesMid_AutumnFestival( string.Join(",", arrDepartment), age)); DataSource = table; xrTableCellFullName.DataBindings.Add("Text", DataSource, "FullName"); xrTableCellSex.DataBindings.Add("Text", DataSource, "Sex"); xrTableCellBirthYear.DataBindings.Add("Text", DataSource, "BirthYear"); xrTableCellParentName.DataBindings.Add("Text", DataSource, "ParentName"); xrTableCellEmployeeCode.DataBindings.Add("Text", DataSource, "EmployeeCode"); GroupHeader2.GroupFields.AddRange(new[] { new GroupField("DepartmentId", XRColumnSortOrder.Ascending) }); xrGroupConstruction.DataBindings.Add("Text", DataSource, "DepartmentName"); } catch { } }
/// <summary> /// /// </summary> /// <param name="tableName"></param> /// <param name="id"></param> /// <param name="sender"></param> public void DeleteAttackFile(string tableName, int id, Hidden sender) { // xóa trong csdl SQLHelper.ExecuteTable( SQLManagementAdapter.GetStore_DeleteFileScan(tableName, id)); DeleteFile(sender.Text); }
/// <summary> /// /// </summary> private void DisplayTotalRetirement() { // retrirement of employee var totalRetirementOfEmployee = SQLHelper .ExecuteTable(SQLManagementAdapter.GetStore_RetirementOfEmployee(null, null, DepartmentIds)).Rows.Count; pnlEmployeeRetired.Title += @" <b id='pNghiHuu' style='color:red;'>(" + totalRetirementOfEmployee + @" cán bộ)</b>"; }
/// <summary> /// /// </summary> private void DisplayTotalContractCount() { // count contract var totalContractExpirse = SQLHelper.ExecuteTable( SQLManagementAdapter.GetStore_DanhSachNhanVienSapHetHopDong(null, null, 30, DepartmentIds)).Rows.Count; pnEmployeeExpried.Title += @" <b id='pNhanVienSapHetHopDong' style='color:red;'>(" + totalContractExpirse + @" cán bộ)</b>"; }
/// <summary> /// /// </summary> private void DisplayTotalBirthInMonth() { var firstDayOfMonth = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); // get start of month var lastDayOfMonth = firstDayOfMonth.AddMonths(1).AddDays(-1); // last day of month // count birth in month var totalBirdInMonth = SQLHelper .ExecuteTable(SQLManagementAdapter.GetStore_BirthdayOfEmployee(DepartmentIds, firstDayOfMonth, lastDayOfMonth, null, null)).Rows.Count; pnlSinhNhatNhanVien.Title += @" <b id='pSinhNhatNhanVien' style='color:red;'>(" + totalBirdInMonth + @" cán bộ)</b>"; }
public void BindData(ReportFilter filter) { try { var location = new ReportController().GetCityName(filter.SessionDepartment); xrt_OutputDate.Text = string.Format(xrt_OutputDate.Text, location, DateTime.Now.Day, DateTime.Now.Month, DateTime.Now.Year); xrl_CompanyName.Text = ReportController.GetInstance().GetCompanyName(filter.SessionDepartment); // get organization var organization = cat_DepartmentServices.GetByDepartments(filter.SessionDepartment); if (organization != null) { //select form db var departments = string.IsNullOrEmpty(filter.SelectedDepartment) ? new string[] { } : filter.SelectedDepartment.Split(new[] { "," }, StringSplitOptions.RemoveEmptyEntries); for (int i = 0; i < departments.Length; i++) { departments[i] = "'{0}'".FormatWith(departments[i]); } var table = SQLHelper.ExecuteTable( SQLManagementAdapter.GetStore_ReportListEmployeeATMNumber(string.Join(",", departments))); DataSource = table; //binding data xrt_EmployeeCode.DataBindings.Add("Text", DataSource, "EmployeeCode"); xrt_FullName.DataBindings.Add("Text", DataSource, "FullName"); xrt_BirthDate.DataBindings.Add("Text", DataSource, "BirthDate", "{0:dd/MM/yyyy}"); xrt_Sex.DataBindings.Add("Text", DataSource, "SexName"); xrt_ParticipationDate.DataBindings.Add("Text", DataSource, "ParticipationDate", "{0:dd/MM/yyyy}"); xrt_ATMNumber.DataBindings.Add("Text", DataSource, "AccountNumber"); xrt_BankName.DataBindings.Add("Text", DataSource, "BankName"); xrt_Position.DataBindings.Add("Text", DataSource, "PositionName"); xrt_Address.DataBindings.Add("Text", DataSource, "Address"); 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 { var control = new ReportController(); xrTableCellDepartment.Text = control.GetCompanyName(filter.SessionDepartment); //var toDate = new DateTime(filter.Year, filter.StartMonth, DateTime.DaysInMonth(filter.Year, filter.StartMonth)); var toDate = filter.ReportedDate; lblReportDate.Text = string.Format(lblReportDate.Text, toDate.Day, toDate.Month, toDate.Year); var location = new ReportController().GetCityName(filter.SessionDepartment); lblInformationFooter.Text = string.Format(lblInformationFooter.Text, location, DateTime.Now.Day, DateTime.Now.Month, DateTime.Now.Year); // get organization 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( SQLManagementAdapter.GetStore_ListEmployeeHavePersonalTaxCode(string.Join(",", arrDepartment), filter.WhereClause)); DataSource = table; //binding data GroupHeader1.GroupFields.AddRange(new[] { new GroupField("DepartmentId", XRColumnSortOrder.Ascending) }); xrTableCellDepartment.DataBindings.Add("Text", DataSource, "DepartmentName"); xrTableCellEmployeeCode.DataBindings.Add("Text", DataSource, "EmployeeCode"); xrTableCellFullName.DataBindings.Add("Text", DataSource, "FullName"); xrTableCellGender.DataBindings.Add("Text", DataSource, "Gender"); xrTableCellBirthDate.DataBindings.Add("Text", DataSource, "BirthDate", "{0:dd/MM/yyyy}"); xrTableCellPositionName.DataBindings.Add("Text", DataSource, "PositionName"); xrTableCellPersonalTax.DataBindings.Add("Text", DataSource, "PersonalTaxCode"); } catch { } }
public void BindData(ReportFilter filter) { try { ReportController control = new ReportController(); xrTenCoQuanDonVi.Text = control.GetCompanyName(filter.SessionDepartment); var location = new ReportController().GetCityName(filter.SessionDepartment); lblReportDate.Text = string.Format(lblReportDate.Text, location, DateTime.Now.Day, DateTime.Now.Month, DateTime.Now.Year); // get organization var organization = cat_DepartmentServices.GetByDepartments(filter.SessionDepartment); if (organization != null) { var age = 16; var giftLevel = "300.000"; //select form db var arrOrgCode = string.IsNullOrEmpty(filter.SelectedDepartment) ? new string[] { } : filter.SelectedDepartment.Split(new[] { "," }, StringSplitOptions.RemoveEmptyEntries); for (int i = 0; i < arrOrgCode.Length; i++) { arrOrgCode[i] = "'{0}'".FormatWith(arrOrgCode[i]); } var table = SQLHelper.ExecuteTable(SQLManagementAdapter.GetStore_ListEmployeeHaveChildrenReceiveMidAutumnFestivalGift(string.Join(",", arrOrgCode), age)); DataSource = table; xrTableCellGiftLevel.Text = giftLevel; //binding data xrTableCellEmployeeCode.DataBindings.Add("Text", DataSource, "EmployeeCode"); xrTableCellFullName.DataBindings.Add("Text", DataSource, "FullName"); xrTableCellBirthDate.DataBindings.Add("Text", DataSource, "BirthDate", "{0:dd/MM/yyyy}"); xrTableCellSex.DataBindings.Add("Text", DataSource, "Sex"); xrTableCellPosition.DataBindings.Add("Text", DataSource, "Position"); xrTableCellTypeOfContract.DataBindings.Add("Text", DataSource, "TypeOfContract"); xrTableCellNumberOfChildren.DataBindings.Add("Text", DataSource, "NumberOfChildren"); GroupHeader1.GroupFields.AddRange(new GroupField[] { new GroupField("DepartmentId", XRColumnSortOrder.Ascending) }); xrTableCellGroupHead.DataBindings.Add("Text", DataSource, "DepartmentName"); } } catch { } }
public void BindData(ReportFilter filter) { try { xrl_TenCongTy.Text = ReportController.GetInstance().GetCompanyName(filter.SessionDepartment); var location = new ReportController().GetCityName(filter.SessionDepartment); xrtngayketxuat.Text = string.Format(xrtngayketxuat.Text, location, DateTime.Now.Day, DateTime.Now.Month, DateTime.Now.Year); var month = filter.StartMonth != 0 ? filter.StartMonth : 1; var year = filter.Year < 1900 ? DateTime.Now.Year : filter.Year; // get organization var organization = cat_DepartmentServices.GetByDepartments(filter.SessionDepartment); if (organization == null) { return; } //select form db var departments = string.IsNullOrEmpty(filter.SelectedDepartment) ? new string[] { } : filter.SelectedDepartment.Split(new[] { "," }, StringSplitOptions.RemoveEmptyEntries); for (int i = 0; i < departments.Length; i++) { departments[i] = "'{0}'".FormatWith(departments[i]); } var table = SQLHelper.ExecuteTable(SQLManagementAdapter.GetStore_ExpiredContractInMonth( string.Join(",", departments), month, year)); DataSource = table; //binding data xrt_EmployeeCode.DataBindings.Add("Text", DataSource, "EmployeeCode"); xrt_FullName.DataBindings.Add("Text", DataSource, "FullName"); xrt_Sex.DataBindings.Add("Text", DataSource, "SexName"); xrt_Department.DataBindings.Add("Text", DataSource, "DepartmentName"); xrt_ContractDate.DataBindings.Add("Text", DataSource, "ContractDate", "{0:dd/MM/yyyy}"); xrt_ContractEndDate.DataBindings.Add("Text", DataSource, "ContractEndDate", "{0:dd/MM/yyyy}"); xrt_Position.DataBindings.Add("Text", DataSource, "PositionName"); xrt_ContractType.DataBindings.Add("Text", DataSource, "ContractTypeName"); xrt_Education.DataBindings.Add("Text", DataSource, "EducationName"); GroupHeader1.GroupFields.AddRange(new[] { new GroupField("DepartmentId", XRColumnSortOrder.Ascending) }); xrDepartmentName.DataBindings.Add("Text", DataSource, "DepartmentName"); } catch (Exception ex) { Dialog.Alert("Có lỗi xảy ra: " + ex.Message); } }
public void DeleteTepTinDinhKem(string tableName, int id, Hidden sender) { // xóa trong csdl SQLHelper.ExecuteTable( SQLManagementAdapter.GetStore_DeleteFileScan("hr_BusinessHistory", Convert.ToInt32(hdfKeyRecord.Text))); // xóa file trong thư mục var serverPath = Server.MapPath(sender.Text); if (Util.GetInstance().FileIsExists(serverPath) == false) { Dialog.ShowNotification("Tệp tin không tồn tại hoặc đã bị xóa !"); return; } File.Delete(serverPath); }
public void BindData(ReportFilter filter) { try { // lấy thông tin chung xrl_TenCongTy.Text = ReportController.GetInstance().GetCompanyName(filter.SessionDepartment); var location = new ReportController().GetCityName(filter.SessionDepartment); xrt_ReportDate.Text = string.Format(xrt_ReportDate.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_HoTen.Text = record.FullName; xrl_PhongBan.Text = record.DepartmentName; xrl_ChucVu.Text = record.PositionName; xrl_ViTriCongViec.Text = ""; xr_TuyenChinhThuc.Text = record.ParticipationDate.ToString(); } //Tính thâm niên của nhân viên var seniority = SQLHelper.ExecuteTable( SQLManagementAdapter.GetStore_CalculateSeniorityByRecordId(filter.RecordId)); if (seniority.Rows.Count > 0) { xrThamNien.Text = seniority.Rows[0]["Seniority"].ToString(); } // lấy danh sách người phụ thuộc var table = SQLHelper.ExecuteTable( SQLManagementAdapter.GetStore_ListEmployeeDependence(filter.RecordId)); DataSource = table; xrt_FullName.DataBindings.Add("Text", DataSource, "FullName"); xrt_BirthYear.DataBindings.Add("Text", DataSource, "BirthYear"); xrt_Sex.DataBindings.Add("Text", DataSource, "SexName"); xrt_Relation.DataBindings.Add("Text", DataSource, "RelationName"); xrt_Occupation.DataBindings.Add("Text", DataSource, "Occupation"); xrt_WorkPlace.DataBindings.Add("Text", DataSource, "WorkPlace"); xrt_IDNumber.DataBindings.Add("Text", DataSource, "IDNumber"); xrt_Note.DataBindings.Add("Text", DataSource, "Note"); } catch (Exception ex) { Dialog.ShowNotification("Có lỗi xảy ra ", ex.Message); } }
/// <summary> /// /// </summary> /// <param name="tableName"></param> /// <param name="prkey"></param> /// <param name="sender"></param> public void DeleteTepTinDinhKem(string tableName, decimal prkey, Hidden sender) { // TODO : using controller // xóa trong csdl SQLHelper.ExecuteTable( SQLManagementAdapter.GetStore_DeleteAttachFile("hr_WorkProcess", Convert.ToInt32(hdfRecordId.Text))); // xóa file trong thư mục var serverPath = Server.MapPath(sender.Text); if (Util.GetInstance().FileIsExists(serverPath) == false) { Dialog.ShowNotification("Tệp tin không tồn tại hoặc đã bị xóa !"); return; } File.Delete(serverPath); }
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( SQLManagementAdapter.GetStore_CalculateSeniorityByRecordId(filter.RecordId)); if (seniority.Rows.Count > 0) { xrt_Seniority.Text = seniority.Rows[0]["Seniority"].ToString(); } var table = SQLHelper.ExecuteTable( SQLManagementAdapter.GetStore_ListContractOfEmployee(filter.RecordId)); 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 { ReportController rpCtr = new ReportController(); xrl_NgayBaoCao.Text = "Ngày báo cáo: " + string.Format("{0:dd/MM/yyyy}", filter.ReportedDate); var location = new ReportController().GetCityName(filter.SessionDepartment); xrtngayketxuat.Text = string.Format(xrtngayketxuat.Text, location, DateTime.Now.Day, DateTime.Now.Month, DateTime.Now.Year); xrl_TenCongTy.Text = rpCtr.GetCompanyName(filter.SessionDepartment); // get organization var organization = cat_DepartmentServices.GetByDepartments(filter.SessionDepartment); if (organization != null) { //select form db var arrOrgCode = string.IsNullOrEmpty(filter.SelectedDepartment) ? new string[] { } : filter.SelectedDepartment.Split(new[] { "," }, StringSplitOptions.RemoveEmptyEntries); for (int i = 0; i < arrOrgCode.Length; i++) { arrOrgCode[i] = "'{0}'".FormatWith(arrOrgCode[i]); } var table = SQLHelper.ExecuteTable( SQLManagementAdapter.GetStore_ListEmployeeNotHaveHealthInsuranceRecord(string.Join(",", arrOrgCode))); DataSource = table; xrtmanhanvien.DataBindings.Add("Text", DataSource, "EmployeeCode"); xrthoten.DataBindings.Add("Text", DataSource, "FullName"); xrt_ngaysinh.DataBindings.Add("Text", DataSource, "BirthDate", "{0:dd/MM/yyyy}"); xrtgioitinh.DataBindings.Add("Text", DataSource, "Sex"); xrtdiachi.DataBindings.Add("Text", DataSource, "Address"); xrtdienthoai.DataBindings.Add("Text", DataSource, "Phone"); xrtngayvaocongty.DataBindings.Add("Text", DataSource, "ParticipationDate", "{0:dd/MM/yyyy}"); xrt_trinhdo.DataBindings.Add("Text", DataSource, "Education"); xrtchucvu.DataBindings.Add("Text", DataSource, "Position"); GroupHeader1.GroupFields.AddRange(new[] { new GroupField("DepartmentId", XRColumnSortOrder.Ascending) }); xrDepartmentName.DataBindings.Add("Text", DataSource, "DepartmentName"); } } catch (Exception ex) { Dialog.Alert("Có lỗi xảy ra: " + ex.Message); } }
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 { } }
public void BindData(ReportFilter filter) { var location = new ReportController().GetCityName(filter.SessionDepartment); xrtOutputDate.Text = string.Format(xrtOutputDate.Text, location, DateTime.Now.Day, DateTime.Now.Month, DateTime.Now.Year); xrlCompanyName.Text = ReportController.GetInstance().GetCompanyName(filter.SessionDepartment); // get organization var organization = cat_DepartmentServices.GetByDepartments(filter.SessionDepartment); if (organization != null) { //select form db var arrOrgCode = string.IsNullOrEmpty(filter.SelectedDepartment) ? new string[] { } : filter.SelectedDepartment.Split(new[] { "," }, StringSplitOptions.RemoveEmptyEntries); for (int i = 0; i < arrOrgCode.Length; i++) { arrOrgCode[i] = "'{0}'".FormatWith(arrOrgCode[i]); } var table = SQLHelper.ExecuteTable( SQLManagementAdapter.GetStore_ListEmployeeNotHaveSocialInsuranceRecord(string.Join(",", arrOrgCode))); DataSource = table; //binding data xrtEmployeeCode.DataBindings.Add("Text", DataSource, "EmployeeCode"); xrtFullName.DataBindings.Add("Text", DataSource, "FullName"); xrtBirthDate.DataBindings.Add("Text", DataSource, "BirthDate", "{0:dd/MM/yyyy}"); xrtSex.DataBindings.Add("Text", DataSource, "Sex"); xrtAddress.DataBindings.Add("Text", DataSource, "Address"); xrtPhone.DataBindings.Add("Text", DataSource, "Phone"); xrtDate.DataBindings.Add("Text", DataSource, "ParticipationDate", "{0:dd/MM/yyyy}"); xrtEducation.DataBindings.Add("Text", DataSource, "Education"); xrtPosition.DataBindings.Add("Text", DataSource, "Position"); GroupHeader1.GroupFields.AddRange(new[] { new GroupField("DepartmentId", XRColumnSortOrder.Ascending) }); xrtDepartment.DataBindings.Add("Text", DataSource, "DepartmentName"); } }
public void BindData(ReportFilter filter) { try { const string hrDepartment = @"Trần Thị Việt Hồng"; const string creator = @"Trần Thị Thu"; var toDate = filter.ReportedDate; lblReportDate.Text = string.Format(lblReportDate.Text, toDate.Day, toDate.Month, toDate.Year); lblHRDepartment.Text = hrDepartment; lblCreator.Text = creator; // get organization 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( SQLManagementAdapter.GetStore_ListEmployeeFamilyRelation(filter.RecordId, string.Join(",", arrDepartment), filter.WhereClause)); DataSource = table; //binding data xrCellEmployeeCode.DataBindings.Add("Text", DataSource, "EmployeeCode"); xrCellFullName.DataBindings.Add("Text", DataSource, "FullName"); xrCellDependenceNumber.DataBindings.Add("Text", DataSource, "DependenceNumber"); xrCellDepartmentName.DataBindings.Add("Text", DataSource, "DepartmentName"); } catch (Exception ex) { Dialog.ShowNotification("Có lỗi xảy ra ", ex.Message); } }
public void BindData(ReportFilter filter) { try { ReportController rpCtr = new ReportController(); xrl_TenCongTy.Text = rpCtr.GetCompanyName(filter.SessionDepartment); var arrDepartment = string.IsNullOrEmpty(filter.SelectedDepartment) ? new string[] { } : filter.SelectedDepartment.Split(new[] { "," }, StringSplitOptions.RemoveEmptyEntries); for (int i = 0; i < arrDepartment.Length; i++) { arrDepartment[i] = "'{0}'".FormatWith(arrDepartment[i]); } var control = new ReportController(); var location = control.GetCityName(filter.SessionDepartment); xrt_ReportDate.Text = string.Format(xrt_ReportDate.Text, location, DateTime.Now.Day, DateTime.Now.Month, DateTime.Now.Year); var table = SQLHelper.ExecuteTable( SQLManagementAdapter.GetStore_ReportlistemployeeProbation(String.Join(",", arrDepartment))); DataSource = table; //Binding data xrtEmployeeCode.DataBindings.Add("Text", DataSource, "EmployeeCode"); xrtFullName.DataBindings.Add("Text", DataSource, "FullName"); xrtBirthDate.DataBindings.Add("Text", DataSource, "BirthDate", "{0:dd/MM/yyyy}"); xrtSex.DataBindings.Add("Text", DataSource, "Sex"); xrtAddress.DataBindings.Add("Text", DataSource, "Address"); xrtRecruimentDate.DataBindings.Add("Text", DataSource, "RecruimentDate", "{0:dd/MM/yyyy}"); xrtJobName.DataBindings.Add("Text", DataSource, "JobName"); xrtPositionName.DataBindings.Add("Text", DataSource, "PositionName"); GroupHeader1.GroupFields.AddRange(new[] { new GroupField("DepartmentId", XRColumnSortOrder.Ascending) }); xrlDepartmentName.DataBindings.Add("Text", DataSource, "DepartmentName"); } catch (Exception ex) { Dialog.ShowNotification("Có lỗi xảy ra " + ex.Message); } }
public void BindData(ReportFilter filter) { try { ReportController rpCtr = new ReportController(); xrl_TenCongTy.Text = rpCtr.GetCompanyName(filter.SessionDepartment); var location = rpCtr.GetCityName(filter.SessionDepartment); xrtReportDate.Text = string.Format(xrtReportDate.Text, location, DateTime.Now.Day, DateTime.Now.Month, DateTime.Now.Year); var departments = string.IsNullOrEmpty(filter.SelectedDepartment) ? new string[] { } : filter.SelectedDepartment.Split(new[] { "," }, StringSplitOptions.RemoveEmptyEntries); for (int i = 0; i < departments.Length; i++) { departments[i] = "'{0}'".FormatWith(departments[i]); } var table = SQLHelper.ExecuteTable( SQLManagementAdapter.GetStore_ListEmployeeJoinSocialInsurance(string.Join(",", departments))); DataSource = table; //Binding data xrtEmployeeCode.DataBindings.Add("Text", DataSource, "EmployeeCode"); xrtFullName.DataBindings.Add("Text", DataSource, "FullName"); xrtBirthDate.DataBindings.Add("Text", DataSource, "BirthDate", "{0:dd/MM/yyyy}"); xrtSex.DataBindings.Add("Text", DataSource, "SexName"); xrtAddress.DataBindings.Add("Text", DataSource, "Address"); xrtPhone.DataBindings.Add("Text", DataSource, "CellPhoneNumber"); xrtInsuranceIssueDate.DataBindings.Add("Text", DataSource, "InsuranceIssueDate", "{0:dd/MM/yyyy}"); xrtInsuranceNumber.DataBindings.Add("Text", DataSource, "InsuranceNumber"); xrtPosition.DataBindings.Add("Text", DataSource, "PositionName"); GroupHeader1.GroupFields.AddRange(new[] { new GroupField("DepartmentId", XRColumnSortOrder.Ascending) }); xrtDepartmentName.DataBindings.Add("Text", DataSource, "DepartmentName"); } catch (Exception ex) { Dialog.ShowError(ex.Message); } }
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}"); }
protected void DownloadTemplate_Click(object sender, DirectEventArgs e) { try { var serverPath = Server.MapPath("../../../File/Template/importTimeSheetCodeTemplate.xlsx"); DataTable dataTable = SQLHelper.ExecuteTable(SQLManagementAdapter.GetStore_ExcelTimeSheetCode(null)); WorkBook workBook = new WorkBook(); workBook.ImportDataTable(dataTable, true, 0, 0, dataTable.Rows.Count + 1, dataTable.Columns.Count + 1); workBook.writeXLSX(serverPath); Response.AddHeader("Content-Disposition", "attachment; filename=" + "importTimeSheetCodeTemplate.xlsx"); if (serverPath != null) { Response.WriteFile(serverPath); } Response.End(); } catch (Exception ex) { ExtNet.MessageBox.Alert("Có lỗi xảy ra", ex.Message).Show(); } }
public void BindData(ReportFilter filter) { try { var controler = new ReportController(); xrl_TenCongTy.Text = ReportController.GetInstance().GetCompanyName(filter.SessionDepartment); var location = controler.GetCityName(filter.SessionDepartment); xrt_ReportDate.Text = string.Format(xrt_ReportDate.Text, location, DateTime.Now.Day, DateTime.Now.Month, DateTime.Now.Year); //select form db var departments = string.IsNullOrEmpty(filter.SelectedDepartment) ? new string[] { } : filter.SelectedDepartment.Split(new[] { "," }, StringSplitOptions.RemoveEmptyEntries); for (int i = 0; i < departments.Length; i++) { departments[i] = "'{0}'".FormatWith(departments[i]); } var table = SQLHelper.ExecuteTable( SQLManagementAdapter.GetStore_ListEmployeeHaveDeduction(string.Join(",", departments))); DataSource = table; xrt_FullName.DataBindings.Add("Text", DataSource, "FullName"); xrt_EmployeeCode.DataBindings.Add("Text", DataSource, "EmployeeCode"); xrt_Position.DataBindings.Add("Text", DataSource, "PositionName"); xrt_NumberPeople.DataBindings.Add("Text", DataSource, ""); GroupHeader.GroupFields.AddRange(new GroupField[] { new GroupField("DepartmentId", XRColumnSortOrder.Ascending) }); xrt_DepartmentName.DataBindings.Add("Text", DataSource, "DepartmentName"); } catch (Exception ex) { Dialog.ShowError("Có lỗi xảy ra: " + ex.Message); } }
// [DirectMethod] // public void FillData() /// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void wdWindow_BeforeShow(object sender, DirectEventArgs e) { try { string strMau = "Mẫu: 001/" + DateTime.Now.Year + "/"; // TODO : ??? //DataTable table = DataHandler.GetInstance().ExecuteDataTable("SystemConfig_GetConfigByMaDonVi", "@MaDonVi", Session["MaDonVi"].ToString()); var departments = string.Join(",", _userModel.Departments.Select(d => d.Id)); // department 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(SQLManagementAdapter.GetStore_GetAllByDepartment(string.Join(",", arrDepartment))); foreach (DataRow item in table.Rows) { switch (item["Name"].ToString()) { case SystemConfigParameter.EMAIL: txtSystemMail.Text = item["Value"].ToString(); break; case SystemConfigParameter.PASSWORD_EMAIL: txtPassword.Text = item["Value"].ToString(); txtConfirmPassword.Text = txtPassword.Text; break; case SystemConfigParameter.MENU_TYPE: cbMenuType.SetValue(item["Value"].ToString()); break; case SystemConfigParameter.COMPANY_NAME: //if (string.IsNullOrEmpty(item["VAR_VALUE"].ToString())) //{ // txtCompanyName.Text = new DM_DONVIController().GetById(Session["MaDonVi"].ToString()).TEN_DONVI; //} //else //{ txtCompanyName.Text = item["Value"].ToString(); // } break; case SystemConfigParameter.COMPANY_ADDRESS: txt_DiaChi.Text = item["Value"].ToString(); break; case SystemConfigParameter.COMPANY_MASOTHUE: txt_MaSoThue.Text = item["Value"].ToString(); break; case SystemConfigParameter.COMPANY_DIENTHOAI: txt_DienThoai.Text = item["Value"].ToString(); break; case SystemConfigParameter.COMPANY_FAX: txt_Fax.Text = item["Value"].ToString(); break; case SystemConfigParameter.COMPANY_EMAIL: txt_Email.Text = item["Value"].ToString(); break; case SystemConfigParameter.CITY: txtCity.Text = item["Value"].ToString(); break; case SystemConfigParameter.MNG_COMPANY_NAME: txtManagementCompanyName.Text = item["Value"].ToString(); break; //case SystemConfigParameter.LUONG_CB: // txtLuongCB.SetValue(item["VAR_VALUE"].ToString()); // break; case SystemConfigParameter.PREFIX: txtTienTo.Text = item["Value"].ToString(); break; case SystemConfigParameter.NUMBER_OF_CHARACTER: txtSoLuong.Text = item["Value"].ToString(); break; //case SystemConfigParameter.CONG_CHUAN: // txtSoNgayCongChuan.Text = item["VAR_VALUE"].ToString(); // break; // tab sinh mã, số quyết định case SystemConfigParameter.SUFFIX_SOHOPDONG: txtSoHopDong.Text = item["Value"].ToString(); txtSoHopDong.Note = strMau + item["Value"].ToString(); break; case SystemConfigParameter.SUFFIX_SOQDLUONG: txtSoQuyetDinhLuong.Text = item["Value"].ToString(); txtSoQuyetDinhLuong.Note = strMau + item["Value"].ToString(); break; case SystemConfigParameter.SUFFIX_SOQDKHENTHUONG: txtSoQDKhenThuong.Text = item["Value"].ToString(); txtSoQDKhenThuong.Note = strMau + item["Value"].ToString(); break; case SystemConfigParameter.SUFFIX_SOQDKYLUAT: txtSoQDKyLuat.Text = item["Value"].ToString(); txtSoQDKyLuat.Note = strMau + item["Value"].ToString(); break; case SystemConfigParameter.SUFFIX_SOQDCONGTAC: txtSoQDCongTac.Text = item["Value"].ToString(); txtSoQDCongTac.Note = strMau + item["Value"].ToString(); break; case SystemConfigParameter.SUFFIX_SOQDDIEUCHUYEN: txtSoQĐieuChuyen.Text = item["Value"].ToString(); txtSoQĐieuChuyen.Note = strMau + item["Value"].ToString(); break; // tab sinh người ký báo cáo case SystemConfigParameter.SuDungTenDangNhap: // chknguoidangnhap.SetValue(Boolean.Parse(item["VAR_VALUE"].ToString())); chknguoidangnhap.Checked = Boolean.Parse(item["Value"].ToString()); break; case SystemConfigParameter.chuky1: txtnguoiky1.Text = item["Value"].ToString(); break; case SystemConfigParameter.chuky2: txtnguoiky2.Text = item["Value"].ToString(); break; case SystemConfigParameter.chuky3: txtnguoiky3.Text = item["Value"].ToString(); break; case SystemConfigParameter.chuky4: txtnguoiky4.Text = item["Value"].ToString(); break; } } if (string.IsNullOrEmpty(txtCompanyName.Text.Trim())) { int departmentId = _userModel.DepartmentsTree[0].Id; txtCompanyName.Text = cat_DepartmentServices.GetFieldValueById(departmentId, "Name"); } } catch (Exception ex) { X.MessageBox.Alert("Thông báo", ex.Message).Show(); } }
/// <summary> /// DataBind /// </summary> 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(SQLReportRegulationAdapter.GetStore_EmployeeRetired(string.Join(",", _filter.Departments.Split( // new[] { "," }, StringSplitOptions.RemoveEmptyEntries).Select(d => "'{0}'".FormatWith(d))), fromDate, toDate, _filter.Condition)); var table = SQLHelper.ExecuteTable(SQLManagementAdapter.GetStore_RetirementOfEmployee(0, 20, string.Join(",", _filter.Departments.Split( new[] { "," }, StringSplitOptions.RemoveEmptyEntries).Select(d => "'{0}'".FormatWith(d))))); DataSource = table; xrCellEmployeeCode.DataBindings.Add("Text", DataSource, "EmployeeCode"); xrCellFullName.DataBindings.Add("Text", DataSource, "FullName"); xrCellPosition.DataBindings.Add("Text", DataSource, "CurrentPosition"); xrCellDepartment.DataBindings.Add("Text", DataSource, "DepartmentName"); xrCellDecisionNumber.DataBindings.Add("Text", DataSource, "DecisionNumber"); xrCellDecisionDate.DataBindings.Add("Text", DataSource, "DecisionDate", "{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"); // 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 DirectLogin() { try { // init return message var message = string.Empty; // init user model var userModel = new UserModel { // authenticate User = UserServices.Authenticate(txtUserName.Text.Trim(), txtPassword.Text, ref message) }; // check user login if (userModel.User == null) { // login fail ExtNet.MessageBox.Alert("Login Fail", message).Show(); return; } // check departments if (userModel.Departments.Count > 0) { // set current user Session["CurrentUser"] = userModel; // if (userModel.User != null) { // check u //lấy danh sách các bộ phận được truy cập tìm cán bộ sinh nhật trong tháng var listDepartmentId = string.Join(",", userModel.Departments.Select(d => d.Id)); var objCountContract = SQLHelper.ExecuteTable( SQLManagementAdapter.GetStore_DanhSachNhanVienSapHetHopDong(null, null, 30, listDepartmentId)).Rows.Count; // Danh sách sinh nhật trong tháng var firstDayOfMonth = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); // get start of month var lastDayOfMonth = firstDayOfMonth.AddMonths(1).AddDays(-1); // last day of month var tableBirthInMonth = SQLHelper .ExecuteTable(SQLManagementAdapter.GetStore_BirthdayOfEmployee(listDepartmentId, firstDayOfMonth, lastDayOfMonth, null, null)).Rows.Count; // Danh sách nhân viên đến kì nghỉ hưu var tableRetirement = SQLHelper .ExecuteTable(SQLManagementAdapter.GetStore_RetirementOfEmployee(null, null, listDepartmentId)); var countRetirement = 0; var newEmployeeCode = string.Empty; for (var i = 0; i < tableRetirement.Rows.Count; i++) { var currentEmployeeCode = (string)tableRetirement.Rows[i]["EmployeeCode"]; if (currentEmployeeCode != newEmployeeCode) { countRetirement++; newEmployeeCode = currentEmployeeCode; } } // Danh sách nhân viên được nâng lương var tableListSalaryRaise = SQLHelper.ExecuteTable(SQLManagementAdapter.GetStore_ListSalaryRaise(listDepartmentId, "1900-01-01", DateTime.Now.ToString("MM/dd/yyyy"), null, null, (int)SalaryDecisionType.Regular, null, null)).Rows.Count; var tableOutFrameSalary = SQLHelper.ExecuteTable(SQLManagementAdapter.GetStore_ListSalaryRaise(listDepartmentId, null, null, null, null, (int)SalaryDecisionType.OverGrade, null, null)).Rows.Count; Session["DataHomePage"] = tableBirthInMonth + ";" + objCountContract + ";" + countRetirement + ";" + tableListSalaryRaise + ";" + tableOutFrameSalary; } else { RM.RegisterClientScriptBlock("al", "Ext.Msg.alert('Lỗi đăng nhập', 'Có lỗi xảy ra trong quá trình đăng nhập');"); } // redirect home page Response.Redirect("~/Default.aspx"); } else { // alert error message ExtNet.MessageBox.Alert("No Department", "Người dùng chưa được cấp quyền với bất kỳ đơn vị nào.").Show(); // redirect login page Response.Redirect("~/Login.aspx"); } } catch (Exception ex) { ExtNet.MessageBox.Alert("Exception", ex.Message).Show(); } }
public void BindData() { try { var firstDayOfMonth = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); // get start of month var lastDayOfMonth = firstDayOfMonth.AddMonths(1).AddDays(-1); // last day of month // from date var fromDate = _filter.StartDate != null ? _filter.StartDate.Value : firstDayOfMonth; // to date var toDate = _filter.EndDate != null ? _filter.EndDate.Value : lastDayOfMonth; // select form db string departmentIds = string.Join(",", _filter.Departments.Split( new[] { "," }, StringSplitOptions.RemoveEmptyEntries).Select(d => "'{0}'".FormatWith(d))); var table = SQLHelper.ExecuteTable(SQLManagementAdapter.GetStore_BirthdayOfEmployee(departmentIds, fromDate, toDate, null, null)); DataSource = table; //binding data xrCellEmployeeCode.DataBindings.Add("Text", DataSource, "EmployeeCode"); xrCellFullName.DataBindings.Add("Text", DataSource, "FullName"); xrCellPosition.DataBindings.Add("Text", DataSource, "PositionName"); xrCellPosition.DataBindings.Add("Text", DataSource, "PositionName"); xrCellDepartment.DataBindings.Add("Text", DataSource, "DepartmentName"); xrCellBirthDate.DataBindings.Add("Text", DataSource, "BirthDate", "{0:dd/MM/yyyy}"); xrCellAge.DataBindings.Add("Text", DataSource, "Age"); 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> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void menuExportExcel_Event(object sender, DirectEventArgs e) { var searchKey = txtSearch.Text; var maDonVi = hdfSelectedDepartment.Text; var birthDate = filterBirthDate.SelectedItem.Value ?? ""; var sex = filterSex.SelectedItem.Value ?? ""; switch (sex) { case "F": sex = "0"; break; case "M": sex = "1"; break; default: sex = string.Empty; break; } var selectedDepartment = filterPhongBan.SelectedItem.Value ?? ""; var folk = filterFolk.SelectedItem.Value ?? ""; var religion = filterReligion.SelectedItem.Value ?? ""; var personalClass = filterPersonalClass.SelectedItem.Value ?? ""; var familyClass = filterFamilyClass.SelectedItem.Value ?? ""; var recruimentDate = filterRecruimentDate.SelectedItem.Value ?? ""; var position = filterPosition.SelectedItem.Value ?? ""; var jobTitle = filterJobTitle.SelectedItem.Value ?? ""; //string ngayHuong = ""; var basicEducation = filterBasicEducation.SelectedItem.Value ?? ""; var education = filterEducation.SelectedItem.Value ?? ""; var politicLevel = filterPoliticLevel.SelectedItem.Value ?? ""; var manegementLevel = filterManagementLevel.SelectedItem.Value ?? ""; var languageLevel = filterLanguageLevel.SelectedItem.Value ?? ""; var itLevel = filterITLevel.SelectedItem.Value ?? ""; var cpvPosition = filterCPVPosition.SelectedItem.Value ?? ""; var vyuPosition = filterVYUPosition.SelectedItem.Value ?? ""; var armyLevel = filterArmyLevel.SelectedItem.Value ?? ""; var maritalStatus = filterMaritalStatus.SelectedItem.Value ?? ""; var phone = filterDiDong.Text; var email = filterEmail.Text; var departmentIds = hdfDepartments.Text; var arrOrgCode = string.IsNullOrEmpty(departmentIds) ? new string[] { } : departmentIds.Split(new[] { "," }, StringSplitOptions.RemoveEmptyEntries); for (var i = 0; i < arrOrgCode.Length; i++) { arrOrgCode[i] = "'{0}'".FormatWith(arrOrgCode[i]); } var table = SQLHelper.ExecuteTable(SQLManagementAdapter.GetStore_ExcelLyLichTrichNgang( string.Join(",", arrOrgCode), selectedDepartment, maDonVi, searchKey, birthDate, sex, folk, religion, familyClass, personalClass, recruimentDate, position, jobTitle, basicEducation, education, politicLevel, manegementLevel, languageLevel, itLevel, cpvPosition, vyuPosition, armyLevel, maritalStatus, phone, email)); var stt = 0; for (var i = 0; i < table.Rows.Count; i++) { stt++; table.Rows[i]["STT"] = stt.ToString(); } // export short profile excel ExportToExcel(table, RelativePath, ShortProfile); }