protected void btnImport_Click(object sender, EventArgs e)
{
if (Request.Files.Count > 0)
{
HttpPostedFile postedFile = Request.Files[0];
if (postedFile.FileName.Trim() != "")
{
string filePath = Server.MapPath("/Content/DataImport/") + postedFile.FileName.Trim();
postedFile.SaveAs(filePath);
string destinationString = "Data Source=.;Initial Catalog=JXT;uid=sa;pwd=123456";
Utility.DataTransferTookits.ExcelItem sourceItem = new Utility.DataTransferTookits.ExcelItem(filePath);
Utility.DataTransferTookits.ExcelItem outputItem = new Utility.DataTransferTookits.ExcelItem(@"C:\导入错误信息提示.xls");
JXT.Core.Business.User.ImportDataFromExcel(sourceItem, destinationString, JXT.Core.Business.User.JXT_USER_TABLE_COLUME_MAPPING, outputItem);
File.Delete(filePath);
}
else
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "", "<script>alert('请选择导入的EXCEL文件')</script>");
}
}
else
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "", "<script>alert('请选择导入的EXCEL文件')</script>");
}
}
public void TestMethod1()
{
Utility.DataTransferTookits.ExcelItem sourceItem = new Utility.DataTransferTookits.ExcelItem(@"D:\家校通\统计表.xls");
Utility.DataTransferTookits.ExcelItem outputItem = new Utility.DataTransferTookits.ExcelItem(@"D:\家校通\2.xls");
string connection = "Data Source=.;Initial Catalog=JXT;uid=sa;pwd=123456";
JXT.Core.Business.User.ImportDataFromExcel(sourceItem, connection, JXT.Core.Business.User.JXT_USER_TABLE_COLUME_MAPPING, outputItem);
}
