private DataSet bidingDataSet_Matngoai_Doi()
{
DataTable tb = new DataTable();
DsInGCN Ds = new DsInGCN();
tb = boCcc.get_Print_CcDoi(mChungChiId, StatustDoi, mSoHieuDoi);
for (int i = 0; i < tb.Rows.Count; i++)
{
int CHC_ID = Int32.Parse(tb.Rows[i]["CHC_ID"].ToString());
DataRow row = Ds.TableInGcn_MatNgoai.NewRow();
row["StaticNumber"] = tb.Rows[i]["CHC_ModleCode"].ToString();
DateTime fromDate = DateTime.Parse(tb.Rows[i]["DOI_Ngay_KG"].ToString());
string sFromDate = fromDate.ToString("dd/MM/yyyy", CultureInfo.InvariantCulture);
row["FromDate"] = sFromDate.ToString().Substring(0, 2) + "/" + sFromDate.ToString().Substring(3, 2) + "/" + sFromDate.ToString().Substring(6, 4);
DateTime endDate = DateTime.Parse(tb.Rows[i]["DOI_Ngay_KT"].ToString());
string sEndDate = endDate.ToString("dd/MM/yyyy", CultureInfo.InvariantCulture);
row["ToDate"] = sEndDate.ToString().Substring(0, 2) + "/" + sEndDate.ToString().Substring(3, 2) + "/" + sEndDate.ToString().Substring(6, 4);
row["At"] = " TT HUẤN LUYỆN THUYỀN VIÊN \n MARITIME TRAINING CENTER \n ĐẠI HỌC GIAO THÔNG VẬN TẢI TP HCM \n HOCIMINH CITY UNIVERSITY OF TRANSPORT";
row["ShortName"] = tb.Rows[i]["CCC_SoHieuDoi"].ToString();
row["HvSoCc"] = tb.Rows[i]["CCC_SoCC"].ToString();
DateTime sQdDate = DateTime.Parse(tb.Rows[i]["DOI_Ngay_QD"].ToString());
string sSQdDate = sQdDate.ToString("dd/MM/yyyy", CultureInfo.InvariantCulture);
row["DateQd"] = sSQdDate.ToString().Substring(0, 2);
row["MonthQd"] = sSQdDate.ToString().Substring(3, 2);
row["YearQd"] = sSQdDate.ToString().Substring(6, 4);
Ds.TableInGcn_MatNgoai.Rows.Add(row);
}
return(Ds);
}
private DataSet bidingDataSet_Matngoai()
{
DataTable tb = new DataTable();
DsInGCN Ds = new DsInGCN();
tb = boDkh.getDataInGCN(mLopId, mLanThi);
for (int i = 0; i < tb.Rows.Count; i++)
{
int CHC_ID = Int32.Parse(tb.Rows[i]["CHC_ID"].ToString());
DataRow row = Ds.TableInGcn_MatNgoai.NewRow();
row["StaticNumber"] = tb.Rows[i]["CHC_ModleCode"].ToString();
DateTime fromDate = DateTime.Parse(tb.Rows[i]["LOP_Ngay_KG"].ToString());
string sFromDate = fromDate.ToString("dd/MM/yyyy", CultureInfo.InvariantCulture);
row["FromDate"] = sFromDate.ToString().Substring(0, 2) + "/" + sFromDate.ToString().Substring(3, 2) + "/" + sFromDate.ToString().Substring(6, 4);
DateTime endDate = DateTime.Parse(tb.Rows[i]["LOP_Ngay_KT"].ToString());
string sEndDate = endDate.ToString("dd/MM/yyyy", CultureInfo.InvariantCulture);
row["ToDate"] = sEndDate.ToString().Substring(0, 2) + "/" + sEndDate.ToString().Substring(3, 2) + "/" + sEndDate.ToString().Substring(6, 4);
row["At"] = " TT HUẤN LUYỆN THUYỀN VIÊN "; //\n SEMAN TRAINING CENTER \n ĐẠI HỌC GIAO THÔNG VẬN TẢI TP HCM \n HOCIMINH CITY UNIVERSITY OF TRANSPORT";
// row["At1"] = "SEMAN TRAINING CENTER";
row["At1"] = "MARITIME TRAINING CENTER";
row["At2"] = "ĐẠI HỌC GIAO THÔNG VẬN TẢI TP HCM";
row["At3"] = "HOCIMINH CITY UNIVERSITY OF TRANSPORT";
row["ShortName"] = tb.Rows[i]["LOP_ShortName"].ToString();
row["HvSoCc"] = tb.Rows[i]["HvSoCc"].ToString();
DateTime sQdDate = DateTime.Parse(tb.Rows[i]["LOP_Ngay_QD"].ToString());
string sSQdDate = sQdDate.ToString("dd/MM/yyyy", CultureInfo.InvariantCulture);
row["DateQd"] = sSQdDate.ToString().Substring(0, 2);
row["MonthQd"] = sSQdDate.ToString().Substring(3, 2);
row["YearQd"] = sSQdDate.ToString().Substring(6, 4);
// row["Img"] = tb.Rows[i]["IMG_Image"];
Ds.TableInGcn_MatNgoai.Rows.Add(row);
}
return(Ds);
}
private DataSet bidingDataSet_Mattrong()
{
DataTable tb = new DataTable();
DsInGCN Ds = new DsInGCN();
int CHC_ID = -1;
DateTime fromDate;
DateTime endDate;
string sFromDate;
string sEndDate;
tb = boDkh.getDataInGCN(mLopId, mLanThi);
if (tb.Rows.Count > 0)
{
for (int i = 0; i < tb.Rows.Count; i++)
{
DataRow row = Ds.TableInGcn_MatTrong.NewRow();
CHC_ID = Int32.Parse(tb.Rows[i]["CHC_ID"].ToString());
row["TrungTam"] = " ĐẠI HỌC GIAO THÔNG VẬN TẢI TPHCM";
row["TrungTamE"] = "HOCHIMINH CITY UNIVERSITY OF TRANSPORT ";
row["FullName"] = tb.Rows[i]["HvFirstName"].ToString() + " " + tb.Rows[i]["HvLastName"].ToString();
row["HvBirthDay"] = tb.Rows[i]["HvBirthDay"].ToString();
row["HOV_QuocTich"] = tb.Rows[i]["HOV_QuocTich"].ToString();
row["HvSoCc"] = tb.Rows[i]["HvSoCc"].ToString();
fromDate = DateTime.Parse(tb.Rows[i]["HvNgayCapSoCc"].ToString());
sFromDate = fromDate.ToString("dd/MM/yyyy", CultureInfo.InvariantCulture);
row["HvNgayCapSoCc"] = sFromDate.ToString().Substring(0, 2) + "/" + sFromDate.ToString().Substring(3, 2) + "/" + sFromDate.ToString().Substring(6, 4);
endDate = DateTime.Parse(tb.Rows[i]["HvNgayHetHan"].ToString());
sEndDate = endDate.ToString("dd/MM/yyyy", CultureInfo.InvariantCulture);
row["HvNgayHetHan"] = sEndDate.ToString().Substring(0, 2) + "/" + sEndDate.ToString().Substring(3, 2) + "/" + sEndDate.ToString().Substring(6, 4);
row["CHC_Name"] = tb.Rows[i]["CHC_Name"].ToString();
row["HvNoiSinh"] = tb.Rows[i]["TIN_Name"].ToString();
row["CHC_Content1"] = tb.Rows[i]["CHC_Content1"].ToString();
row["CHC_Content2"] = tb.Rows[i]["CHC_Content2"].ToString();
row["CHC_Content3"] = tb.Rows[i]["CHC_Content3"].ToString();
row["CHC_Content4"] = tb.Rows[i]["CHC_Content4"].ToString();
row["CHC_Content5"] = tb.Rows[i]["CHC_Content5"].ToString();
row["SoQT"] = tb.Rows[i]["CHC_QuyTac"].ToString();
row["LocationCenter"] = tb.Rows[i]["CHC_QuyDinh"].ToString();
row["Regulation"] = tb.Rows[i]["CHC_QuyDinhEngl"].ToString();
row["CHC_FontSize1"] = tb.Rows[i]["CHC_FontSize1"].ToString();
row["CHC_FontSize2"] = tb.Rows[i]["CHC_FontSize2"].ToString();
row["CHC_FontSize3"] = tb.Rows[i]["CHC_FontSize3"].ToString();
row["CHC_FontSize4"] = tb.Rows[i]["CHC_FontSize4"].ToString();
row["Img"] = tb.Rows[i]["IMG_Image"];
Ds.TableInGcn_MatTrong.Rows.Add(row);
}
}
return(Ds);
}
