private DataTable vTable(int stdentId)
{
DataTable tb = boHv.search_CCC_ByHocVienId(stdentId);
DataTable tbDkh = boDkh.get_DKH_By_HvID(stdentId);
DataTable vTemTable = new DataTable();
vTemTable.Columns.Add("CCC_ID", typeof(int));
vTemTable.Columns.Add("LOP_ShortName", typeof(string));
vTemTable.Columns.Add("CCC_CHCID", typeof(int));
vTemTable.Columns.Add("CCC_SoCC", typeof(string));
vTemTable.Columns.Add("CCC_NgayCap", typeof(DateTime));
vTemTable.Columns.Add("CCC_NgayHetHan", typeof(DateTime));
vTemTable.Columns.Add("CCC_LOPID", typeof(int));
vTemTable.Columns.Add("CCC_SoHieuDoi", typeof(string));
vTemTable.Columns.Add("NGAY_KG", typeof(DateTime));
vTemTable.Columns.Add("NGAY_KT", typeof(DateTime));
if (tb.Rows.Count > 0)
{
for (int i = 0; i < tb.Rows.Count; i++)
{
DataRow row = vTemTable.NewRow();
row["CCC_ID"] = tb.Rows[i]["CCC_ID"].ToString();
if (tb.Rows[i]["LOP_ShortName"].ToString() == "")
{
row["LOP_ShortName"] = tb.Rows[i]["CCC_SoHieuDoi"].ToString();
}
else
{
row["LOP_ShortName"] = tb.Rows[i]["LOP_ShortName"].ToString();
}
row["CCC_CHCID"] = tb.Rows[i]["CCC_CHCID"].ToString();
if (tb.Rows[i]["LOP_Ngay_KG"].ToString() != "")
{
row["NGAY_KG"] = tb.Rows[i]["LOP_Ngay_KG"].ToString();
row["NGAY_KT"] = tb.Rows[i]["LOP_Ngay_KT"].ToString();
}
else
{
row["NGAY_KG"] = System.DBNull.Value;
row["NGAY_KT"] = System.DBNull.Value;
}
if (tb.Rows[i]["CCC_NgayCap"].ToString() != string.Empty)
{
row["CCC_NgayCap"] = tb.Rows[i]["CCC_NgayCap"].ToString();
}
else
{
row["CCC_NgayCap"] = System.DBNull.Value;
}
row["CCC_SoCC"] = tb.Rows[i]["CCC_SoCC"].ToString();
row["CCC_LOPID"] = tb.Rows[i]["CCC_LOPID"].ToString();
vTemTable.Rows.Add(row);
}
}
else if (tbDkh.Rows.Count > 0)
{
for (int i = 0; i < tbDkh.Rows.Count; i++)
{
DataRow row = vTemTable.NewRow();
row["CCC_ID"] = tbDkh.Rows[i]["DKH_ID"].ToString();
row["LOP_ShortName"] = tbDkh.Rows[i]["LOP_ShortName"].ToString();
row["CCC_CHCID"] = tbDkh.Rows[i]["DKH_ID"].ToString();
if (tbDkh.Rows[i]["LOP_Ngay_KG"].ToString() != "")
{
row["NGAY_KG"] = tbDkh.Rows[i]["LOP_Ngay_KG"].ToString();
row["NGAY_KT"] = tbDkh.Rows[i]["LOP_Ngay_KT"].ToString();
}
else
{
row["NGAY_KG"] = System.DBNull.Value;
row["NGAY_KT"] = System.DBNull.Value;
}
if (tbDkh.Rows[i]["LOP_ID"].ToString() != "")
{
row["CCC_LOPID"] = tbDkh.Rows[i]["LOP_ID"].ToString();
}
else
{
row["CCC_LOPID"] = -1;
}
vTemTable.Rows.Add(row);
}
}
return(vTemTable);
}
