private DataSet vDsDanhSachHocVienCapGCN()
{
tb = new DataTable();
boCcc = new BO_CAP_CHUNGCHI();
vDsBieuMau = new DsInBieuMau();
object vDateCapChungChi;
int vChungChiID = int.Parse(lookKhoaHoc_InGCN.GetColumnValue("CHC_ID").ToString());
int vLopID = int.Parse(lookLop_InGCN.GetColumnValue("LOP_ID").ToString());
tb = boCcc.ExportExcel_DsHV_DuocCapCC(vChungChiID, vLopID);
if (tb.Rows.Count > 0)
{
for (int i = 0; i < tb.Rows.Count; i++)
{
vRow = vDsBieuMau.DsHvDuocCapGCN.NewRow();
vRow["STT"] = i + 1;
vRow["HOV_FirstName"] = tb.Rows[i]["HOV_FirstName"].ToString();
vRow["HOV_LastName"] = tb.Rows[i]["HOV_LastName"].ToString();
vRow["HOV_BirthDay"] = tb.Rows[i]["HOV_BirthDay"].ToString();
vRow["TIN_Name"] = tb.Rows[i]["TIN_Name"].ToString();
vRow["DON_Name"] = tb.Rows[i]["DON_Name"].ToString();
vRow["CCC_SoCC"] = tb.Rows[i]["CCC_SoCC"].ToString();
vDateCapChungChi = DateTime.Parse(tb.Rows[i]["CCC_NgayCap"].ToString());
vRow["CCC_NgayCap"] = string.Format("{0:dd/MM/yyyy}", vDateCapChungChi).ToString().Substring(0, 10);
vRow["vLopName"] = lookLop_InGCN.GetColumnValue("LOP_Name").ToString();
vDsBieuMau.DsHvDuocCapGCN.Rows.Add(vRow);
}
}
return(vDsBieuMau);
}
private DataSet vDsKetQuaHocTap()
{
tb = new DataTable();
boHv = new BO_HOCVIEN();
vDsBieuMau = new DsInBieuMau();
int vLopID = int.Parse(lookLop_InGCN.GetColumnValue("LOP_ID").ToString());
int vMonID = int.Parse(lookMonHoc.GetColumnValue("MON_ID").ToString());
int vLanThi = int.Parse(lookLanThi.GetColumnValue("DIE_LanThi").ToString());
tb = boHv.ExportExcel_DiemThi(vLopID, vMonID, vLanThi);
if (tb.Rows.Count > 0)
{
for (int i = 0; i < tb.Rows.Count; i++)
{
vRow = vDsBieuMau.DiemDanhHocVien.NewRow();
vRow["STT"] = i + 1;
vRow["HOV_FirstName"] = tb.Rows[i]["HOV_FirstName"].ToString();
vRow["HOV_LastName"] = tb.Rows[i]["HOV_LastName"].ToString();
vRow["HOV_BirthDay"] = tb.Rows[i]["HOV_BirthDay"].ToString();
vRow["TIN_Name"] = tb.Rows[i]["TIN_Name"].ToString();
vRow["vLopName"] = lookLop_InGCN.GetColumnValue("LOP_Name").ToString();
vRow["vMonName"] = lookMonHoc.GetColumnValue("MON_Name").ToString();
vDsBieuMau.DiemDanhHocVien.Rows.Add(vRow);
}
}
return(vDsBieuMau);
}
private DataSet vDsDanhSachHocVien()
{
tb = new DataTable();
boHv = new BO_HOCVIEN();
vDsBieuMau = new DsInBieuMau();
int i;
tb = boHv.ExportExcel_DsHocVien_ByLopID(int.Parse(lookLop_InGCN.GetColumnValue("LOP_ID").ToString()));
if (tb.Rows.Count > 0)
{
for (i = 0; i < tb.Rows.Count; i++)
{
vRow = vDsBieuMau.DanhSachHocVien.NewRow();
vRow["STT"] = i + 1;
vRow["HOV_FirstName"] = tb.Rows[i]["HOV_FirstName"].ToString();
vRow["HOV_LastName"] = tb.Rows[i]["HOV_LastName"].ToString();
vRow["HOV_BirthDay"] = tb.Rows[i]["HOV_BirthDay"].ToString();
vRow["TIN_Name"] = tb.Rows[i]["TIN_Name"].ToString();
vRow["HOV_Phone"] = tb.Rows[i]["HOV_Phone"].ToString();
vRow["HOV_ChucDanh"] = tb.Rows[i]["HOV_ChucDanh"].ToString();
vRow["DON_Name"] = tb.Rows[i]["DON_Name"].ToString();
vRow["DKH_BienLai"] = tb.Rows[i]["DKH_BienLai"].ToString();
vRow["HOV_GhiChu"] = tb.Rows[i]["HOV_GhiChu"].ToString();
vRow["vLopName"] = lookLop_InGCN.GetColumnValue("LOP_Name").ToString();
vDsBieuMau.DanhSachHocVien.Rows.Add(vRow);
}
}
return(vDsBieuMau);
}
private DataSet vDsSoTheoDoiCapGCN()
{
tb = new DataTable();
boCcc = new BO_CAP_CHUNGCHI();
vDsBieuMau = new DsInBieuMau();
object vDateCapChungChi;
int vLopID = int.Parse(lookLop_InGCN.GetColumnValue("LOP_ID").ToString());
int vChungChiID = int.Parse(lookKhoaHoc_InGCN.GetColumnValue("CHC_ID").ToString());
tb = boCcc.ExportExcel_Phat_CHUNGCHI(vChungChiID, vLopID);
if (tb.Rows.Count > 0)
{
for (int i = 0; i < tb.Rows.Count; i++)
{
vRow = vDsBieuMau.SoTheoDoiCapGCN.NewRow();
vRow["STT"] = i + 1;
//vRow["HOV_FirstName"] = tb.Rows[i]["HOV_FirstName"].ToString();
vRow["HOV_FirstName"] = tb.Rows[i]["HOV_FullName"].ToString();
vRow["HOV_LastName"] = tb.Rows[i]["HOV_LastName"].ToString();
vRow["HOV_BirthDay"] = tb.Rows[i]["HOV_BirthDay"].ToString();
vRow["IMG_Image"] = tb.Rows[i]["IMG_Image"];
//vRow["DON_Name"] = tb.Rows[i]["DON_Name"].ToString();
vRow["CCC_SoCC"] = tb.Rows[i]["CCC_SoCC"].ToString();
vDateCapChungChi = DateTime.Parse(tb.Rows[i]["CCC_NgayCap"].ToString());
vRow["CCC_NgayCap"] = string.Format("{0:dd/MM/yyyy}", vDateCapChungChi).ToString().Substring(0, 10);
//int status = int.Parse(tb.Rows[i]["CCC_Status"].ToString());
//if (status == 1)
//{
// vRow["CCC_Status"] = "Cấp mới";// "Khóa " + tb.Rows[i]["LOP_Khoa"].ToString();
//}
//else if (status == 2)
//{
// vRow["CCC_Status"] = " Gia hạn";
//}
//else if (status == 3)
//{
// vRow["CCC_Status"] = " Đổi";
//}
vRow["CCC_Status"] = "Cấp mới";
vRow["vChungChiName"] = lookKhoaHoc_InGCN.GetColumnValue("CHC_Name").ToString() + " - Khóa: " + tb.Rows[i]["LOP_Khoa"].ToString();;
vDsBieuMau.SoTheoDoiCapGCN.Rows.Add(vRow);
}
}
return(vDsBieuMau);
}
private DataSet vDsSanhSachHocVienCapGCNDoi()
{
tb = new DataTable();
boCcc = new BO_CAP_CHUNGCHI();
vDsBieuMau = new DsInBieuMau();
object vDateCapChungChi;
int vChungChiID = int.Parse(lookKhoaHoc_InGCN.GetColumnValue("CHC_ID").ToString());
int sCap = -1;
if (radCapQ.SelectedIndex == 1)
{
sCap = 2;
}
else
if (radCapQ.SelectedIndex == 2)
{
sCap = 3;
}
tb = boCcc.ExportExcel_DsHV_DuocCapCC_Doi(vChungChiID, sCap, lookUpSoHieuDoi.Text);
if (tb.Rows.Count > 0)
{
for (int i = 0; i < tb.Rows.Count; i++)
{
vRow = vDsBieuMau.DsHvDuocCapGCN.NewRow();
vRow["STT"] = i + 1;
vRow["HOV_FirstName"] = tb.Rows[i]["HOV_FirstName"].ToString();
vRow["HOV_LastName"] = tb.Rows[i]["HOV_LastName"].ToString();
vRow["HOV_BirthDay"] = tb.Rows[i]["HOV_BirthDay"].ToString();
vRow["TIN_Name"] = tb.Rows[i]["TIN_Name"].ToString();
vRow["DON_Name"] = tb.Rows[i]["DON_Name"].ToString();
vRow["CCC_SoCC"] = tb.Rows[i]["CCC_SoCC"].ToString();
vDateCapChungChi = DateTime.Parse(tb.Rows[i]["CCC_NgayCap"].ToString());
vRow["CCC_NgayCap"] = string.Format("{0:dd/MM/yyyy}", vDateCapChungChi).ToString().Substring(0, 10);
vRow["vLopName"] = lookKhoaHoc_InGCN.GetColumnValue("CHC_Name").ToString();
vDsBieuMau.DsHvDuocCapGCN.Rows.Add(vRow);
}
}
return(vDsBieuMau);
}
private DataSet vDsSoTheoDoiCapGCNDoi()
{
tb = new DataTable();
boCcc = new BO_CAP_CHUNGCHI();
vDsBieuMau = new DsInBieuMau();
object vDateCapChungChi;
string vSoHieuDoi = lookUpSoHieuDoi.Text;
int vChungChiID = int.Parse(lookKhoaHoc_InGCN.GetColumnValue("CHC_ID").ToString());
int sCap = -1;
if (radCapQ.SelectedIndex == 1)
{
sCap = 2;
}
else if (radCapQ.SelectedIndex == 2)
{
sCap = 3;
}
tb = boCcc.ExportExcel_Phat_Doi_CHUNGCHI(vChungChiID, sCap, vSoHieuDoi);
if (tb.Rows.Count > 0)
{
for (int i = 0; i < tb.Rows.Count; i++)
{
vRow = vDsBieuMau.SoTheoDoiCapGCN.NewRow();
vRow["STT"] = i + 1;
vRow["HOV_FirstName"] = tb.Rows[i]["HOV_FullName"].ToString();
vRow["HOV_LastName"] = tb.Rows[i]["HOV_LastName"].ToString();
vRow["HOV_BirthDay"] = tb.Rows[i]["HOV_BirthDay"].ToString();
vRow["IMG_Image"] = tb.Rows[i]["IMG_Image"];
vRow["CCC_SoCC"] = tb.Rows[i]["CCC_SoCC"].ToString();
vDateCapChungChi = DateTime.Parse(tb.Rows[i]["CCC_NgayCap"].ToString());
vRow["CCC_NgayCap"] = string.Format("{0:dd/MM/yyyy}", vDateCapChungChi).ToString().Substring(0, 10);
int status = int.Parse(tb.Rows[i]["CCC_Status"].ToString());
if (status == 2)
{
vRow["CCC_Status"] = " Gia hạn";
vSoHieuDoi = "Số hiệu gia hạn: " + vSoHieuDoi;
}
else if (status == 3)
{
vRow["CCC_Status"] = " Đổi";
vSoHieuDoi = "Số hiệu đổi: " + vSoHieuDoi;
}
//if (status == 1)
//{
// vRow["CCC_Status"] = "Khóa " + tb.Rows[i]["LOP_Khoa"].ToString();
//}
//else if (status == 2)
//{
// vRow["CCC_Status"] = " Gia hạn";
//}
//else if (status == 3)
//{
// vRow["CCC_Status"] = " Đổi";
//}
vRow["vChungChiName"] = lookKhoaHoc_InGCN.GetColumnValue("CHC_Name").ToString() + " - " + vSoHieuDoi;
vDsBieuMau.SoTheoDoiCapGCN.Rows.Add(vRow);
}
}
return(vDsBieuMau);
}
