private DataTable getLopDaCapCC()
{
DataTable cCMhTable = new DataTable();
DataTable dsHvDaCapCC = new DataTable("dsHvDaCapCC");
DataColumn column = new DataColumn();
dsHvDaCapCC.Columns.Add("HvID", typeof(int));
dsHvDaCapCC.Columns.Add("Họ", typeof(string));
dsHvDaCapCC.Columns.Add("Tên", typeof(string));
dsHvDaCapCC.Columns.Add("Ngày sinh", typeof(string));
cCMhTable = boMonHoc.SelectMONHOC_Name_By_CHCID(int.Parse(lookChungChi.GetColumnValue("CHC_ID").ToString()));
for (int i = 0; i < cCMhTable.Rows.Count; i++)
{
dsHvDaCapCC.Columns.Add(cCMhTable.Rows[i]["MonHoc"].ToString(), typeof(string));// (i.ToString() + 4)+
}
dsHvDaCapCC.Columns.Add("Số CC", typeof(string));
dsHvDaCapCC.Columns.Add("Ngày cấp", typeof(string));
dsHvDaCapCC.Columns.Add("CCC_LOPID", typeof(int));
DataTable tbs = new DataTable();
//tbs = boDkh.getDangKiHoc_Name_ByLopID(int.Parse(lookLopHoc.GetColumnValue("LOP_ID").ToString()));
tbs = boCcc.Search_CCC_Status(int.Parse(lookLopHoc.GetColumnValue("LOP_ID").ToString()), mStatus);
foreach (DataRow dr in tbs.Rows)
{
DataRow newRow = dsHvDaCapCC.NewRow();
newRow.ItemArray = dr.ItemArray;
dsHvDaCapCC.Rows.Add(newRow);
}
return(dsHvDaCapCC);
}
private DataTable getLopDaCapCC()
{
int vLanThi = -1;
vLanThi = int.Parse(lookLanThi.GetColumnValue("DIE_LanThi").ToString());
mLanThi = vLanThi;
DataTable cCMhTable = new DataTable();
DataTable dsHvDaCapCC = new DataTable("dsHvDaCapCC");
DataColumn column = new DataColumn();
dsHvDaCapCC.Columns.Add("HvID", typeof(int));
dsHvDaCapCC.Columns.Add("Họ", typeof(string));
dsHvDaCapCC.Columns.Add("Tên", typeof(string));
dsHvDaCapCC.Columns.Add("Ngày sinh", typeof(string));
cCMhTable = boMonHoc.SelectMONHOC_Name_By_CHCID(int.Parse(lookChungChi.GetColumnValue("CHC_ID").ToString()));
for (int i = 0; i < cCMhTable.Rows.Count; i++)
{
dsHvDaCapCC.Columns.Add(cCMhTable.Rows[i]["MonHoc"].ToString(), typeof(string));// (i.ToString() + 4)+
}
dsHvDaCapCC.Columns.Add("CCC_ID", typeof(int));
dsHvDaCapCC.Columns.Add("Số CC", typeof(string));
dsHvDaCapCC.Columns.Add("Ngày cấp", typeof(DateTime));
dsHvDaCapCC.Columns.Add("CCC_LOPID", typeof(int));
DataTable tbs = new DataTable();
mLopHocID = int.Parse(lookLopHoc.GetColumnValue("LOP_ID").ToString());
tbs = boDkh.getDangKiHoc_Name_ByLopID(mLopHocID, vLanThi);
foreach (DataRow dr in tbs.Rows)
{
DataRow newRow = dsHvDaCapCC.NewRow();
if (int.Parse(lookChungChi.EditValue.ToString()) == 1 && dsHvDaCapCC.Columns.Count > tbs.Columns.Count)
{
newRow["HvID"] = dr["DAC_HOVID"];
newRow["Họ"] = dr["DAC_HOVFIRSTNAME"];
newRow["Tên"] = dr["DAC_HOVLASTNAME"];
newRow["Ngày sinh"] = dr["DAC_HOVBIRTHDAY"];
newRow[4] = dr[4];
newRow[5] = dr[5];
newRow[6] = dr[6];
newRow[7] = dr[7];
newRow[8] = dr[8];
newRow[9] = dr[9];
newRow[10] = string.Empty;
newRow["CCC_ID"] = dr["DAC_ID"];
newRow["Số CC"] = dr["DAC_CCCSoCC"];
newRow["Ngày cấp"] = dr["DAC_CCCNgayCap"];
newRow["CCC_LOPID"] = dr["DAC_LOPID"];
}
else
{
newRow.ItemArray = dr.ItemArray;
}
dsHvDaCapCC.Rows.Add(newRow);
}
return(dsHvDaCapCC);
}
