private void Load_cmbNhomCha()
{
var cmb = cmbLoaiCVCha;
cmb.Tag = 0;
clsDM_LoaiCV cls = new clsDM_LoaiCV();
DataTable dt;
if (m_bCapNhat)
{
dt = cls.SelectAll_ParentNodes(m_iID_LoaiCV);
}
else
{
dt = cls.SelectAll();
}
dt.DefaultView.RowFilter = "TonTai = 1";
dt.DefaultView.Sort = "Ten_LoaiCV ASC";
dt = dt.DefaultView.ToTable();
cmb.Properties.DataSource = dt;
cmb.Properties.DisplayMember = "Ten_LoaiCV";
cmb.Properties.ValueMember = "ID_LoaiCV";
cmb.Tag = 1;
}
private void LoadCombobox()
{
var cmb = cmbLoaiCV;
cmb.Tag = 0;
clsDM_LoaiCV cls = new clsDM_LoaiCV();
DataTable dt = cls.SelectAll();
dt = dt.DefaultView.ToTable();
cmb.Properties.DataSource = dt;
cmb.Properties.DisplayMember = "Ten_LoaiCV";
cmb.Properties.ValueMember = "ID_LoaiCV";
List <String> editValues = new List <String>();
foreach (DataRow dr in dt.Rows)
{
editValues.Add(dr["ID_LoaiCV"].ToString());
}
string s = String.Join(",", editValues.ToArray());
cmb.SetEditValue(s);
cmb.Tag = 1;
}
private void LoadcmbLoaiCV()
{
var cmb = cmbLoaiCongViec;
cmb.Tag = 0;
clsDM_LoaiCV cls = new clsDM_LoaiCV();
DataTable dt = cls.SelectAll();
dt.DefaultView.Sort = "ID_LoaiCV ASC";
dt.DefaultView.RowFilter = "TonTai = 1";
dt = dt.DefaultView.ToTable();
cmb.Properties.DataSource = dt;
cmb.Properties.DisplayMember = "Ten_LoaiCV";
cmb.Properties.ValueMember = "ID_LoaiCV";
if (dt.DefaultView.ToTable().Rows.Count == 1)
{
cmb.EditValue = dt.DefaultView.ToTable().Rows[0]["ID_LoaiCV"];
}
else
{
cmb.EditValue = null;
}
cmb.Tag = 1;
}
public void LoadData()
{
//
var cls = new clsDM_LoaiCV();
var dt = new DataTable();
cls.ID_DonVi = int.Parse(cmbDonVi.EditValue.ToString());
dt = cls.SelectAll_TheoDonVi();
//
fg.BeginUpdate();
fg.Cols["ID_LoaiCV_Cha"].DataMap = null;
fg.ClearRows();
foreach (DataRow dr in dt.Rows)
{
var fgRow = fg.Rows.Add();
fgRow["ID_LoaiCV"] = dr["ID_LoaiCV"];
fgRow["Ten_LoaiCV"] = dr["Ten_LoaiCV"];
fgRow["ID_LoaiCV_Cha"] = dr["ID_LoaiCV_Cha"];
fgRow["TonTai"] = dr["TonTai"];
fgRow["SuDung"] = dr["SuDung"];
fgRow["ID_DonVi"] = dr["ID_DonVi"];
fgRow["STT_LoaiCV"] = dr["STT_LoaiCV"];
}
//add combobox column
//Add Node 0 công việc con
for (var r = fg.Rows.Fixed; r < fg.Rows.Count; ++r)
{
fg.Rows[r].Visible = false;
fg.Rows.InsertNode(r + 1, 0);
GetDataTwoRow(r + 1, r);
++r;
}
for (var r = fg.Rows.Fixed; r < fg.Rows.Count; r++)
{
if (!fg.Rows[r].Visible)
{
fg.Rows.Remove(r);
r = r - 1;
}
}
//
for (var r = fg.Rows.Fixed; r < fg.Rows.Count; ++r)
{
if (fg.Rows[r].Node.Level == 0 && fg.Rows[r].Visible && IsNode0(r))
{
r = TimCongViecGoc(r, 1);
}
}
var level = 1;
while (TonTaiCongViecGoc(level))
{
for (var r1 = fg.Rows.Fixed; r1 < fg.Rows.Count; ++r1)
{
if (fg.Rows[r1].Node.Level == level && fg.Rows[r1].Visible)
{
r1 = TimCongViecGoc(r1, level + 1);
}
}
++level;
}
fg.Tree.Column = 1;
////////
for (var r = fg.Rows.Fixed; r < fg.Rows.Count; ++r)
{
if (!fg.Rows[r].Visible)
{
fg.Rows.Remove(r);
--r;
}
}
SetSTT();
fg.Tree.Show(0);
var clsCha = new clsDM_LoaiCV();
dt = clsCha.SelectAll();
dt.DefaultView.RowFilter = "TonTai = 1";
dt = dt.DefaultView.ToTable();
var drow = dt.NewRow();
drow["ID_LoaiCV"] = 0;
drow["Ten_LoaiCV"] = "";
dt.Rows.Add(drow);
dt.DefaultView.Sort = "Ten_LoaiCV ASC";
//add datamap
var datamap = new ListDictionary();
for (var i = 0; i <= dt.DefaultView.ToTable().Rows.Count - 1; i++)
{
datamap.Add(dt.DefaultView.ToTable().Rows[i][0], dt.DefaultView.ToTable().Rows[i][1]);
}
fg.Cols["ID_LoaiCV_Cha"].DataMap = datamap;
fg.EndUpdate();
}
private void Loadfg()
{
fg.Tag = 0;
fg.BeginUpdate();
clsDM_LoaiCV cls = new clsDM_LoaiCV();
DataTable dt = cls.SelectAll_Sorted();
dt.DefaultView.RowFilter = "TonTai = 1";
fg.Rows.Count = fg.Rows.Fixed;
fg.SetDataSource(dt.DefaultView.ToTable());
//create treeview
for (int i = fg.Rows.Fixed; i < fg.Rows.Count; i++)
{
int level = 0;
if ((fg[i, "ID_LoaiCV_Cha"] ?? "").ToString() == "")
{
fg.Rows[i].IsNode = true;
fg.Rows[i].Node.Level = level;
GroupBy(i, level + 1);
}
}
//add combobox column
clsDM_LoaiCV clsCha = new clsDM_LoaiCV();
dt = clsCha.SelectAll();
dt.DefaultView.RowFilter = "TonTai = 1";
dt = dt.DefaultView.ToTable();
DataRow dr = dt.NewRow();
dr["ID_LoaiCV"] = 0;
dr["Ten_LoaiCV"] = "";
dt.Rows.Add(dr);
dt.DefaultView.Sort = "Ten_LoaiCV ASC";
ListDictionary datamap = new ListDictionary();
for (int i = 0; i <= dt.DefaultView.ToTable().Rows.Count - 1; i++)
{
datamap.Add(dt.DefaultView.ToTable().Rows[i][0], dt.DefaultView.ToTable().Rows[i][1]);
}
fg.Cols["ID_LoaiCV_Cha"].DataMap = datamap;
fg.Tree.Column = 1;
fg.Tree.Style = TreeStyleFlags.Symbols;
fg.Tree.Show(0);
fg.Row = -1;
//fg.AutoSizeRows();
//Add STT
int stt1 = 1;
int stt2 = 1;
int stt3 = 1;
int stt4 = 1;
int stt5 = 1;
for (int i = fg.Rows.Fixed; i < fg.Rows.Count; ++i)
{
if (fg.Rows[i].Node.Level == 0)
{
fg[i, "STT"] = stt1;
++stt1;
stt2 = 1;
}
if (fg.Rows[i].Node.Level == 1)
{
fg[i, "STT"] = " " + (stt1 - 1) + "." + stt2;
++stt2;
stt3 = 1;
}
if (fg.Rows[i].Node.Level == 2)
{
fg[i, "STT"] = " " + (stt1 - 1) + "." + (stt2 - 1) + "." + stt3;
++stt3;
stt4 = 1;
}
if (fg.Rows[i].Node.Level == 3)
{
fg[i, "STT"] = " " + (stt1 - 1) + "." + (stt2 - 1) + "." + (stt3 - 1) + "." + stt4;
++stt4;
stt5 = 1;
}
if (fg.Rows[i].Node.Level == 4)
{
fg[i, "STT"] = " " + (stt1 - 1) + "." + (stt2 - 1) + "." + (stt3 - 1) + "." + (stt4 - 1) + "." + stt5;
++stt5;
}
}
//fg.AutoSizeCols(fg.Cols["STT"].Index);
fg.EndUpdate();
fg.Tag = 1;
}
public void LoadData()
{
fg.Tag = 0;
fg.BeginUpdate();
clsDM_LoaiCV cls = new clsDM_LoaiCV();
DataTable dt = cls.SelectAll();
dt.DefaultView.RowFilter = "TonTai = 1";
fg.ClearRows();
fg.SetDataSource(dt);
//Add Node 0 công việc con
for (int r = fg.Rows.Fixed; r < fg.Rows.Count; ++r)
{
fg.Rows[r].Visible = false;
fg.Rows.InsertNode(r + 1, 0);
GetDataTwoRow(r + 1, r);
++r;
}
for (int r = fg.Rows.Fixed; r < fg.Rows.Count; r++)
{
if (!fg.Rows[r].Visible)
{
fg.Rows.Remove(r);
r = r - 1;
}
}
for (int r = fg.Rows.Fixed; r < fg.Rows.Count; ++r)
{
if (fg.Rows[r].Node.Level == 0 && fg.Rows[r].Visible && IsNode0(r))
{
r = TimCongViecGoc(r, 1);
}
}
int level = 1;
while (TonTaiCongViecGoc(level))
{
for (int r1 = fg.Rows.Fixed; r1 < fg.Rows.Count; ++r1)
{
if (fg.Rows[r1].Node.Level == level && fg.Rows[r1].Visible)
{
r1 = TimCongViecGoc(r1, level + 1);
}
}
++level;
}
//chỉ số cột hiển thị cây
fg.Tree.Column = 4;
for (int r = fg.Rows.Fixed; r < fg.Rows.Count; ++r)
{
if (!fg.Rows[r].Visible)
{
fg.Rows.Remove(r);
--r;
}
}
SetSTT();
fg.Row = -1;
fg.EndUpdate();
// fg.Tree.Show(0);
fg.Tag = 1;
}