public void ImportData(string sPath, string ApplyNo)
{
string dicPath = sPath + ApplyNo;
if (Directory.Exists(dicPath))
{
string[] files = Directory.GetFiles(dicPath);
if (files.Length > 0)
{
DataTable dt = ReadFile(files[0]);
string connStr = System.Configuration.ConfigurationManager.ConnectionStrings["ctpconn"].ConnectionString;
BatchImportUtil import = new BatchImportUtil(connStr);
import.DoBatchImport(dt, "Track_Retrospect_JawasoftCode", null, System.Data.SqlClient.SqlBulkCopyOptions.Default);
}
}
}
public void ImportTableValued(string sPath, string ApplyNo)
{
string dicPath = sPath + ApplyNo;
if (Directory.Exists(dicPath))
{
string[] files = Directory.GetFiles(dicPath);
if (files.Length > 0)
{
DataTable dt = ReadFile2(files[0]);
string connStr = System.Configuration.ConfigurationManager.ConnectionStrings["ctpconn"].ConnectionString;
BatchImportUtil import = new BatchImportUtil(connStr);
SqlParameter[] param = new SqlParameter[1];
SqlParameter p = new SqlParameter("@TV", SqlDbType.Structured);
p.Value = dt;
p.TypeName = "dbo.JCodeTableValued";
param[0] = p;
import.BulkTableValuedToDB("SP_BatchJCodeByTableValued", param);
}
}
}
