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