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); }