public ActionResult Import(string id)
{
try
{
HttpFileCollectionBase files = Request.Files;
DataTable dt = CommClass.CreateTB("UserName:System.String,UserID:System.String,UserPwd:System.String,UserPermission:System.String,UserState:System.Int32,Remark:System.String");
string str = NPOIExcel.ImportExcelFile(files, dt, 1, 0);
List <M_User> lstUser = new JavaScriptSerializer().Deserialize <List <M_User> >(str);
bool iSucc = SQLDBHelperClient.CreateUser().Add(lstUser);
if (iSucc)
{
ViewBag.Succ = "1";
ViewBag.Msg = "数据添加成功!";
return(View());
}
else
{
ViewBag.Succ = "0";
ViewBag.Msg = "数据添加失败!";
return(View());
}
}
catch (Exception ex)
{
ViewBag.Succ = "0";
ViewBag.Msg = "数据添加失败!";
return(View());
}
}
