protected void Test_Btn_Click(object sender, EventArgs e)
{
DBConnectText.Text = DBConnectText.Text.Trim();
TestResult_L.Text = "";
string success = "<span style='color:green'>测试成功</span>";
SqlBase db = SqlBase.CreateHelper(DataSource_DP.SelectedValue);
try
{
db.ConnectionString = DBConnectText.Text;
db.Table_List();
TestResult_L.Text = success;
}
catch (Exception ex) { TestResult_L.Text = "<span style='color:red;'>连接失败,原因:" + ex.Message + "</span>"; }
}
//根据所选数据源,加载本地或外地数据源
private DataTable GetDBTabeList(string selected)
{
DataTable tableDT = new DataTable();
switch (selected)
{
case "new":
Response.Redirect("ExternDS/DSAdd.aspx");
break;
default: //读取外部数据源中的信息
SqlBase db = DS_GetByDP(selected);
tableDT = db.Table_List();
break;
}
return(tableDT);
}
//根据csv或xlsx,将数据导入数据库
public void ContentManage_Import()
{
HttpPostedFileBase file = Request.Files["fileImp"];
if (file == null)
{
function.WriteErrMsg("没有上传数据文件"); return;
}
string exName = Path.GetExtension(file.FileName).ToLower();
if (!exName.Equals(".csv") && !exName.Equals(".xls") && !exName.Equals(".xlsx"))//判断扩展名
{
function.WriteErrMsg("上传的文件不是符合扩展名csv,请重新选择!"); return;
}
string vpath = SafeSC.SaveFile(ZLHelper.GetUploadDir_System("Content", "Import", "yyyyMMdd"), function.GetRandomString(6) + exName, IOHelper.StreamToBytes(file.InputStream));
//导入文件到数据集对象
DataTable dt = null;
if (exName.Equals(".csv"))
{
OfficeHelper office = new OfficeHelper();
dt = office.OpenCSV(vpath);
}
else
{
SqlBase excel = SqlBase.CreateHelper("excel");
excel.ConnectionString = vpath;
dt = excel.ExecuteTable(new SqlModel()
{
tbName = excel.Table_List().Rows[0]["name"].ToString()
});
}
SafeSC.DelFile(vpath);
DataSet newDs = Import_CreateTable(dt);
Import_SaveDB(newDs);//保存到数据库
}
