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