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