private void init()
{
BO_CHUNG_CHI chungchi = new BO_CHUNG_CHI();
DataTable tbl_chungchi = chungchi.getChungChi_All();
if (tbl_chungchi.Rows.Count > 0)
{
for (int i = 0; i < tbl_chungchi.Rows.Count; i++)
{
TreeNode node = new TreeNode();
node.Text = tbl_chungchi.Rows[i]["CHC_Name"].ToString();
node.Tag = "CHC";
node.Name = tbl_chungchi.Rows[i]["CHC_ID"].ToString();
treeChungchi.Nodes.Add(node);
DateTime fromDates = dateFrom.DateTime;
DateTime endDates = dateEnd.DateTime;
BO_LOP lop = new BO_LOP();
DataTable tbl_lop = lop.getLopByChungChiIDFromTo(Convert.ToInt32(node.Name), fromDates, endDates);
if (tbl_lop.Rows.Count > 0)
{
for (int j = 0; j < tbl_lop.Rows.Count; j++)
{
TreeNode childNode = new TreeNode();
childNode.Text = tbl_lop.Rows[j]["LOP_Name"].ToString();
childNode.Tag = "LOP";
childNode.Name = tbl_lop.Rows[j]["LOP_ID"].ToString();// +" KHÓA " + tbl_lop.Rows[j]["LOP_Khoa"].ToString();
node.Nodes.Add(childNode);
}
}
}
}
}
private void initComboboxChungChi(int _nhomCcID)
{
BoCc = new BO_CHUNG_CHI();
lookChungChiTK.Properties.DataSource = BoCc.getChungChiByNhomCcID(_nhomCcID);
lookChungChiTK.Properties.DisplayMember = "CHC_Name";
lookChungChiTK.Properties.ValueMember = "CHC_ID";
}
private void initComboxKhoaHoc()
{
bal = new BO_CHUNG_CHI();
lookKhoaHoc_InGCN.Properties.DataSource = bal.getChungChi_All();
lookKhoaHoc_InGCN.Properties.ValueMember = "CHC_ID";
lookKhoaHoc_InGCN.Properties.DisplayMember = "CHC_Name";
}
private void vLoadChungChi()
{
BoCc = new BO_CHUNG_CHI();
tbl = new DataTable();
tbl = BoCc.getChungChi_All();
if (tbl.Rows.Count > 0)
{
lookKhoaHoc_InGCN.Properties.DataSource = tbl.DefaultView;
lookKhoaHoc_InGCN.Properties.DisplayMember = "CHC_Name";
lookKhoaHoc_InGCN.Properties.ValueMember = "CHC_ID";
}
}
private DataTable vGetCapChungChiGeneral()
{
tbl = new DataTable();
BoCc = new BO_CHUNG_CHI();
vDto = new CHUNG_CHI();
rptbl = new DataTable();
DataColumn colSTT = new DataColumn("STT");
DataColumn colCHCName = new DataColumn("CHC_Name");
DataColumn colCapMoi = new DataColumn("TotlaCapMoi");
DataColumn colCapDoi = new DataColumn("TotalCapDoi");
DataColumn colCapLai = new DataColumn("TotalCapLai");
rptbl.Columns.Add(colSTT);
rptbl.Columns.Add(colCHCName);
rptbl.Columns.Add(colCapMoi);
rptbl.Columns.Add(colCapDoi);
rptbl.Columns.Add(colCapLai);
vDto.CHC_ID = int.Parse(lookKhoaHoc_InGCN.GetColumnValue("CHC_ID").ToString());
tbl = BoCc.vGetCapChungChiGeneral(vDto, dateFrom.DateTime, dateEnd.DateTime);
DataTable tblCcName = new DataTable();
if (tbl.Rows.Count > 0)
{
tblCcName = tbl.DefaultView.ToTable(true, "CHC_Name", "CHC_ID");
if (tblCcName.Rows.Count > 0)
{
for (int i = 0; i < tblCcName.Rows.Count; i++)
{
}
DataRow vRow = rptbl.NewRow();
vRow[colSTT] = 1;
for (int i = 0; i < tbl.Rows.Count; i++)
{
DataRow [] xxcolCapLai = tbl.Select("CCC_Status=1");
}
}
}
int ccx = 0;
//ccx = xx.Length;
return(tbl);
}
private bool loadKhoaHoc()
{
BAL.BO_CHUNG_CHI bal = new BO_CHUNG_CHI();
DataTable vtb = new DataTable();
vtb = bal.getChungChi_All();
if (vtb.Rows.Count > 0)
{
lookCcID.Properties.DataSource = vtb.DefaultView;
lookCcID.Properties.ValueMember = "CHC_ID";
lookCcID.Properties.DisplayMember = "CHC_Name";
return(true);
}
else
{
return(false);
}
}
private bool vLoadChungChi()
{
DataTable vtb = new System.Data.DataTable();
dtoChungChi = new CHUNG_CHI();
boChungChi = new BO_CHUNG_CHI();
vtb = boChungChi.getChungChi_All();
if (vtb.Rows.Count > 0)
{
lookCcID.Properties.DataSource = vtb.DefaultView;
lookCcID.Properties.ValueMember = "CHC_ID";
lookCcID.Properties.DisplayMember = "CHC_Name";
lookCcID.EditValue = gChungChiID;
return(true);
}
else
{
return(false);
}
}
private DataTable getKhoaHoc()
{
BAL.BO_CHUNG_CHI bal = new BO_CHUNG_CHI();
return(bal.getChungChi_All());
}
