/// <summary>
/// 开始生成
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
if (this.filenameDing == null || this.filenameHe == null)
{
MessageBox.Show("请先选择文件！", "错误警告");
return;
}
DataTable dtDing = NpoiHelper.Import(filenameDing, getFileSuffiex(filenameDing));
DataTable dtHe = NpoiHelper.Import(filenameHe, getFileSuffiex(filenameHe));
for (int i = 3; i < dtDing.Rows.Count; i++)
{
DataRow dr = dtDing.Rows[i];
this.RowHandleDingToHe(dtHe, dr);
for (int j = 0; j < dr.ItemArray.Length; j++)
{
Console.Out.Write(j + "=>" + dr.ItemArray[j].ToString() + ",");
}
Console.Out.WriteLine();
}
//保存到桌面
saveFile(dtHe);
}
/// <summary>
/// 数据导入
/// </summary>
/// <param name="FileStram"></param>
/// <returns></returns>
public ActionResult DataImport(HttpPostedFileBase file)
{
var message = "";
int Columns = 0;
//判断是否提交excel文件
var FileName = file.FileName.Split('.');
if (file != null && file.ContentLength > 0)
{
if (FileName[1] == "xls" || FileName[1] == "xlsx")
{
//首先我们需要导入数据的话第一步其实就是先把excel数据保存到本地中，然后通过Npoi封装的方法去读取已保存的Excel数据
string DictorysPath = Server.MapPath("~/Content/ExcelFiles/" + DateTime.Now.ToString("yyyyMMdd"));
if (!System.IO.Directory.Exists(DictorysPath))
{
System.IO.Directory.CreateDirectory(DictorysPath);
}
file.SaveAs(System.IO.Path.Combine(DictorysPath, file.FileName));
//将Excel数据转化为DataTable数据源
DataTable Dt = NpoiHelper.Import(System.IO.Path.Combine(DictorysPath, file.FileName), FileName[1]);
List <UserInfo> list = new List <UserInfo>();
for (int i = 0; i < Dt.Rows.Count; i++)
{
UserInfo U = new UserInfo();
//从行索引从1开始，标题除外
U.UserName = Dt.Rows[i][0].ToString();
U.Sex = Dt.Rows[i][1].ToString();
U.Phone = Dt.Rows[i][2].ToString();
U.Hobby = Dt.Rows[i][3].ToString();
list.Add(U);
}
//数据全部添加
UserEntites.Set <UserInfo>().AddRange(list);
Columns = UserEntites.SaveChanges();
if (Columns > 0)
{
message = "导入成功";
}
else
{
message = "导入失败";
}
}
else
{
message = "格式错误";
}
}
else
{
message = "未找到需要导入的数据";
}
ViewBag.Columns = Columns;
ViewBag.Message = message;
return(View());
}
