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