void BuildTree()
{
tlMenu = new tlControl();
tlModule = new tlControl();
//tlModule
tlModule.Name = "tlModule";
tlModule.Dock = DockStyle.Fill;
tlModule.KeyFieldName = "MODULE_ID";
tlModule.ParentFieldName = "MODULE_PARENT";
tapgModule.Controls.Add(tlModule);
tlModule.strZone = "MODULE";
tlModule.BuildTreeList(false);
//tlMenu
tlMenu.Name = "tlMenu";
tlMenu.Dock = DockStyle.Fill;
tlMenu.KeyFieldName = "MENU_ID";
tlMenu.ParentFieldName = "MENU_PARENT";
tapgMenu.Controls.Add(tlMenu);
tlMenu.strZone = "MENU";
tlMenu.BuildTreeList(false);
}
private void Build()
{
//tlDmCbNv.KeyFieldName = "MA_CBNV";
//tlDmCbNv.ParentFieldName = "MA_BP";
//tlDmCbNv.Dock = DockStyle.Fill;
//tlDmCbNv.strZone = "EMPLOYEE";
//tlDmCbNv.BuildTreeList(this.isLookup);
//dtEmployee = HRMCommon.GetCustomerTable("MA_KV");
tlDmCbNv = HRMCommon.GetTreeViewCust(this.isLookup);
this.splControl1.Visible = false;
this.pageEmployee.Controls.Add(tlDmCbNv);
dgvBHXH.strZone = "BHXH";
dgvBHXH.BuildGridView();
dgvBHYT.strZone = "BHYT";
dgvBHYT.BuildGridView();
dgvTroCap.strZone = "TROCAP";
dgvTroCap.BuildGridView();
dgvTyLe.strZone = "TYLE";
dgvTyLe.BuildGridView();
}
private void Build()
{
//
tlDmCbNv = HRMCommon.GetTreeViewCust(this.isLookup);
this.splControl1.Visible = false;
this.pageEmployee.Controls.Add(tlDmCbNv);
dgvThue.strZone = "THUE_NV";
dgvThue.BuildGridView();
}
public static tlControl GetTreeViewCust(bool isLookup)
{
tlControl tlDmCbNv = new tlControl();
tlDmCbNv.KeyFieldName = "MA_CBNV";
tlDmCbNv.ParentFieldName = "MA_TH";
tlDmCbNv.strZone = "EMPLOYEE";
tlDmCbNv.Dock = DockStyle.Fill;
tlDmCbNv.BuildTreeList(isLookup);
return(tlDmCbNv);
}
private void Build()
{
//dtEmployee = HRMCommon.GetCustomerTable("MA_KV");
tlDmCbNv = HRMCommon.GetTreeViewCust(this.isLookup);
this.splControl1.Visible = false;
this.pageEmployee.Controls.Add(tlDmCbNv);
dgvHopDong.strZone = "HOPDONGLD";
dgvHopDong.BuildGridView();
dgvHopDongPL.strZone = "HOPDONGLD_PL";
dgvHopDongPL.BuildGridView();
}
private void Build()
{
//
tlDmCbNv = HRMCommon.GetTreeViewCust(this.isLookup);
this.splControl1.Visible = false;
this.pageEmployee.Controls.Add(tlDmCbNv);
dgvNghiPhep.strZone = "NGHIPHEP";
dgvNghiPhep.BuildGridView();
dgvPhepNam.strZone = "PHEPNAM";
dgvPhepNam.BuildGridView();
}
private void Build()
{
//tlDmCbNv.KeyFieldName = "MA_CBNV";
//tlDmCbNv.ParentFieldName = "MA_TH";
//tlDmCbNv.Dock = DockStyle.Fill;
tlDmCbNv.strZone = "EMPLOYEE";
//tlDmCbNv.BuildTreeList(this.isLookup);
tlDmCbNv = HRMCommon.GetTreeViewCust(this.isLookup);
this.splControl1.Visible = false;
this.pageEmployee.Controls.Add(tlDmCbNv);
dgvGiaDinh.strZone = "GIADINH";
dgvGiaDinh.BuildGridView();
dgvCongTac.strZone = "CONGTAC";
dgvCongTac.BuildGridView();
dgvBangCap.strZone = "DAOTAO";
dgvBangCap.BuildGridView();
dgvKhenThuong.strZone = "KHENTHUONG";
dgvKhenThuong.BuildGridView();
dgvNghiPhep.strZone = "NGHIPHEP";
dgvNghiPhep.BuildGridView();
dgvPhucLoi.strZone = "PHUCLOI";
dgvPhucLoi.BuildGridView();
dgvDanhGia.strZone = "DANHGIA";
dgvDanhGia.BuildGridView();
dgvKinhNghiem.strZone = "KINHNGHIEM";
dgvKinhNghiem.BuildGridView();
dgvKyNang.strZone = "KYNANG";
dgvKyNang.BuildGridView();
dgvLamViec.strZone = "LAMVIEC";
dgvLamViec.BuildGridView();
dgvQUALIFY.strZone = "HRQUALIFY";
dgvQUALIFY.BuildGridView();
}
void tsbSearch_Click(object sender, EventArgs e)
{
frmSearch frmSearch = new frmSearch();
Form frm = this.Parent.FindForm().GetType().Name == "frmMain" ? this.Parent.FindForm().ActiveMdiChild : this.Parent.FindForm();
// Tim form tren tabcontrol
if (frm == null)
{
frm = Common.FindFormChildInTab();
}
if (frm == null)
{
return;
}
object ExportControl = ((frmBase)frm).ExportControl;
if (ExportControl == null)
{
return;
}
//dgvControl
if (Common.Inlist(ExportControl.GetType().Name, "dgvControl,dgvReport,dgvVoucher"))
{
dgvControl dgv = (dgvControl)ExportControl;
frmSearch.bdsSearch = (BindingSource)dgv.DataSource;
}
else if (Common.Inlist(ExportControl.GetType().Name, "tlControl,tlReport"))
{
tlControl tl = (tlControl)ExportControl;
frmSearch.bdsSearch = (BindingSource)tl.DataSource;
}
frmSearch.Show();
}
void SetBindingSource()
{
//dgvControl
if (Common.Inlist(ExportControl.GetType().Name, "dgvControl,dgvReport,dgvVoucher"))
{
dgvControl dgv = (dgvControl)ExportControl;
if (dgv.DataSource == null)
{
return;
}
if (dgv.DataSource.GetType().Name != "BindingSource")
{
return;
}
BindingSource bds = (BindingSource)dgv.DataSource;
if (bds == null)
{
return;
}
this.bdsFilter = bds;
this.dtDataSource = (DataTable)bds.DataSource;
dtColumnList = new DataTable();
dtColumnList.Columns.Add("ColumnID", typeof(string));
dtColumnList.Columns.Add("ColumnName", typeof(string));
dtColumnList.Columns.Add("DataType", typeof(string));
foreach (DataGridViewColumn dgvc in dgv.Columns)
{
if (!dtDataSource.Columns.Contains(dgvc.Name))
{
continue;
}
DataRow dr = dtColumnList.NewRow();
dr["ColumnID"] = dgvc.DataPropertyName;
dr["ColumnName"] = dgvc.HeaderText;
dr["DataType"] = dgvc.ValueType.Name;
dtColumnList.Rows.Add(dr);
}
if (dgv.CurrentCell != null)
{
strDefaultColumn = dgv.Columns[dgv.CurrentCell.ColumnIndex].DataPropertyName;
}
}
//tlControl
if (Common.Inlist(ExportControl.GetType().Name, "tlControl,tlReport"))
{
tlControl tl = (tlControl)ExportControl;
if (tl.DataSource == null)
{
return;
}
if (tl.DataSource.GetType().Name != "BindingSource")
{
return;
}
BindingSource bds = (BindingSource)tl.DataSource;
if (bds == null)
{
return;
}
this.bdsFilter = bds;
this.dtDataSource = (DataTable)bds.DataSource;
dtColumnList = new DataTable();
dtColumnList.Columns.Add("ColumnID", typeof(string));
dtColumnList.Columns.Add("ColumnName", typeof(string));
dtColumnList.Columns.Add("DataType", typeof(string));
foreach (DevExpress.XtraTreeList.Columns.TreeListColumn tlc in tl.Columns)
{
DataRow dr = dtColumnList.NewRow();
dr["ColumnID"] = tlc.FieldName;
dr["ColumnName"] = tlc.Caption;
dr["DataType"] = tlc.ColumnType.Name;
dtColumnList.Rows.Add(dr);
}
if (tl.FocusedColumn != null)
{
strDefaultColumn = tl.FocusedColumn.FieldName;
}
}
}
public void Filter()
{
Form frm = this.Parent.FindForm().GetType().Name == "frmMain" ? this.Parent.FindForm().ActiveMdiChild : this.Parent.FindForm();
// Tim form tren tabcontrol
if (frm == null)
{
frm = Common.FindFormChildInTab();
}
if (frm == null)
{
return;
}
object ExportControl = ((frmBase)frm).ExportControl;
if (ExportControl == null)
{
return;
}
//dgvControl
if (Common.Inlist(ExportControl.GetType().Name, "dgvControl,dgvReport,dgvVoucher"))
{
dgvControl dgv = (dgvControl)ExportControl;
if (strColumnFilter == string.Empty)
{
strColumnFilter = dgv.CurrentCell.OwningColumn.DataPropertyName;
}
if (dgv.bdsFind == null) //|| this.CurrentCell == null)
{
return;
}
if (dgv.bFilter == false)
{
dgv.strFilterOrg = dgv.bdsFind.Filter;
}
string strFilter = "(" + strColumnFilter + " LIKE '%" + this.Text + "%')";
if (((DataTable)dgv.bdsFind.DataSource).Columns[strColumnFilter].DataType.Name != "String")
{
return;
}
if (dgv.strFilterOrg != string.Empty && dgv.strFilterOrg != null)
{
dgv.bdsFind.Filter = "(" + dgv.strFilterOrg + ") AND " + strFilter;
}
else
{
dgv.bdsFind.Filter = strFilter;
}
if (dgv.Rows.Count > 0)
{
dgv.CurrentCell = dgv.Rows[0].Cells[strColumnFilter];
}
dgv.bFilter = true;
}
else if (Common.Inlist(ExportControl.GetType().Name, "tlControl,tlReport"))
{
tlControl tl = (tlControl)ExportControl;
//if (tl.FocusedColumn == null)
// return;
if (strColumnFilter == string.Empty)
{
strColumnFilter = tl.FocusedColumn.FieldName;
}
if (tl.bdsFind == null)
{
return;
}
if (tl.bFilter == false)
{
tl.strFilterOrg = tl.bdsFind.Filter;
}
string strFilter = strColumnFilter + " LIKE '%" + this.Text + "%'";
//bdsFind.Filter = strFilter;
if (tl.strFilterOrg != string.Empty && tl.strFilterOrg != null)
{
tl.bdsFind.Filter = "(" + tl.strFilterOrg + ") AND " + strFilter;
}
else
{
tl.bdsFind.Filter = strFilter;
}
if (tl.Nodes.Count > 0)
{
tl.SetNodeIndex(tl.Nodes[0], tl.Columns[strColumnFilter].VisibleIndex);
}
tl.bFilter = true;
}
}
void tsbTotal_Click(object sender, EventArgs e)
{
DataTable dtTotal = null;
string strColumnName = string.Empty;
string strHeaderText = string.Empty;
string strFilter = string.Empty;
Form frm = this.Parent.FindForm().GetType().Name == "frmMain" ? this.Parent.FindForm().ActiveMdiChild : this.Parent.FindForm();
// Tim form tren tabcontrol
if (frm == null)
{
frm = Common.FindFormChildInTab();
}
if (frm == null)
{
frm = Common.FindFormReportResultInTab();
}
if (frm == null)
{
return;
}
object ExportControl = ((frmBase)frm).ExportControl;
if (ExportControl == null)
{
return;
}
#region dgvControl, tlControl
//dgvControl
if (Common.Inlist(ExportControl.GetType().Name, "dgvControl,dgvReport,dgvVoucher"))
{
dgvControl dgv = (dgvControl)ExportControl;
if (dgv.DataSource == null)
{
return;
}
if (dgv.DataSource.GetType().Name != "BindingSource")
{
return;
}
BindingSource bds = (BindingSource)dgv.DataSource;
if (bds == null)
{
return;
}
if (dgv.CurrentCell == null)
{
return;
}
dtTotal = (DataTable)bds.DataSource;
strColumnName = dgv.CurrentCell.OwningColumn.DataPropertyName;
strHeaderText = dgv.CurrentCell.OwningColumn.HeaderText;
strFilter = bds.Filter;
}
if (Common.Inlist(ExportControl.GetType().Name, "dgvGridReport,dgvGridControl,dgvReportGrid"))
{
dgvGridControl dgv = (dgvGridControl)ExportControl;
if (dgv.DataSource == null)
{
return;
}
if (dgv.DataSource.GetType().Name != "BindingSource")
{
return;
}
BindingSource bds = (BindingSource)dgv.DataSource;
if (bds == null)
{
return;
}
if (dgv.dgvGridView == null)
{
return;
}
dtTotal = (DataTable)bds.DataSource;
strColumnName = dgv.dgvGridView.FocusedColumn.Name;
strHeaderText = dgv.dgvGridView.FocusedColumn.Caption;
strFilter = bds.Filter;
}
//tlControl
if (Common.Inlist(ExportControl.GetType().Name, "tlControl,tlReport"))
{
tlControl tl = (tlControl)ExportControl;
if (tl.DataSource == null)
{
return;
}
if (tl.DataSource.GetType().Name != "BindingSource")
{
return;
}
BindingSource bds = (BindingSource)tl.DataSource;
if (bds == null)
{
return;
}
if (tl.FocusedColumn == null)
{
return;
}
dtTotal = (DataTable)bds.DataSource;
strColumnName = tl.FocusedColumn.FieldName;
strHeaderText = tl.FocusedColumn.Caption;
strFilter = bds.Filter;
}
if (!Common.Inlist(dtTotal.Columns[strColumnName].DataType.Name, "Byte, Int16, Int32, Int64, Decimal, Double"))
{
return;
}
#endregion
if (dtTotal == null)
{
return;
}
double dbSumToltal = Common.SumDCValue(dtTotal, strColumnName, strFilter);
string strMsg = Languages.GetLanguage("SUM") + " " + strHeaderText + ": " + dbSumToltal.ToString("N");
if (dtTotal.Columns.Contains("Bold"))
{
string strFilterNormal = strFilter + (strFilter == string.Empty || strFilter == null ? "" : " AND ") + " Bold = 0 ";
string strFilterBold = strFilter + (strFilter == string.Empty || strFilter == null ? "" : " AND ") + " Bold = 1 ";
double dbSumNormal = Common.SumDCValue(dtTotal, strColumnName, strFilterNormal);
double dbSumBold = Common.SumDCValue(dtTotal, strColumnName, strFilterBold);
strMsg += "\n" + Languages.GetLanguage("SUM_NORMAL") + ": " + dbSumNormal.ToString("N");
strMsg += "\n" + Languages.GetLanguage("SUM_BOLD") + ": " + dbSumBold.ToString("N");
}
EpointMessage.MsgOk(strMsg);
}
