/// </summary>
/// <param name="testcase"></param>
/// <returns></returns>
public bool UploadTestCase(ExcelTest test)
{
bool blnResult = false;
//if (Framework.CreateDescription(testdata))
//{
if (Framework.UploadTestCase(test))
{
blnResult = true;
}
//}
return blnResult;
}
static void Main(string[] args)
{
var docs = Path.GetTempPath();
var fileName = Path.Combine(docs, "andreiIgnat.xlsx");
if (File.Exists(fileName))
{
File.Delete(fileName);
}
var x = new ExcelTest();
//x.CreateNew(fileName);
//x.CreateCorrect(fileName);
x.CreateNewDisposable(fileName);
x = null;
Console.WriteLine("See if excel it is in task manager");
Console.ReadKey();
}
private void button24_Click(object sender, EventArgs e)
{
ExcelTest test = new ExcelTest();
test.Show();
}
public ActionResult Excel1(HttpPostedFileBase filebase)
{
HttpPostedFileBase file = Request.Files["files"];
string FileName;
string savePath;
if (file == null || file.ContentLength <= 0)
{
ViewBag.error = "文件不能为空";
return(View());
}
else
{
string filename = Path.GetFileName(file.FileName);
int filesize = file.ContentLength; //获取上传文件的大小单位为字节byte
string fileEx = System.IO.Path.GetExtension(filename); //获取上传文件的扩展名
string NoFileName = System.IO.Path.GetFileNameWithoutExtension(filename); //获取无扩展名的文件名
int Maxsize = 4000 * 1024; //定义上传文件的最大空间大小为4M
string FileType = ".xls,.xlsx"; //定义上传文件的类型字符串
FileName = NoFileName + fileEx;
if (!FileType.Contains(fileEx))
{
ViewBag.error = "文件类型不对，只能导入xls和xlsx格式的文件";
return(View());
}
if (filesize >= Maxsize)
{
ViewBag.error = "上传文件超过4M，不能上传";
return(View());
}
string path = AppDomain.CurrentDomain.BaseDirectory + "/App_Data/";
savePath = Path.Combine(path, FileName);
file.SaveAs(savePath);
}
string strConn;
strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + savePath + ";" + "Extended Properties=Excel 12.0";
//strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + savePath + ";" + "Extended Properties=Excel 8.0";
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
OleDbDataAdapter myCommand = new OleDbDataAdapter("select * from [Sheet1$]", strConn);
DataSet myDataSet = new DataSet();
conn.Close();
try
{
myCommand.Fill(myDataSet, "ExcelInfo");
}
catch (Exception ex)
{
ViewBag.error = ex.Message;
return(View());
}
DataTable table = myDataSet.Tables["ExcelInfo"].DefaultView.ToTable();
//引用事务机制，出错时，事物回滚
using (TransactionScope transaction = new TransactionScope())
{
for (int i = 0; i < table.Rows.Count; i++)
{
int id = int.Parse(table.Rows[i][0].ToString());
string name = table.Rows[i][1].ToString();
int age = int.Parse(table.Rows[i][2].ToString());
var model = new ExcelTest()
{
Id = id,
Name = name,
Age = age
};
//此处写录入数据库代码；
_excelTest.Add(model);
}
transaction.Complete();
}
ViewBag.error = "导入成功";
System.Threading.Thread.Sleep(2000);
return(View()); // RedirectToAction("Excel1");
}
public void Add(ExcelTest excel)
{
_dao.Add(excel);
}
