public ActionResult Add(Supplier supplier, HttpPostedFileBase UploadImage)
{
try
{
if (UploadImage != null)
{
supplier.Image = new byte[UploadImage.ContentLength];
UploadImage.InputStream.Read(supplier.Image, 0, UploadImage.ContentLength);
}
var added = _supplier.Add(supplier);
if (added)
{
ViewBag.SMsg = "Save Success.";
}
else
{
ViewBag.FMsg = "Failed";
}
}
catch (Exception exception)
{
ViewBag.FMsg = exception.Message;
}
return(View());
}
protected void Button3_Click(object sender, EventArgs e)
{
int successfulcount = 0, errorcount = 0;
try
{
if (this.FileUpload1.HasFile)
{
if (!ue.SaveUpFile("~/Admin/temp/", this.FileUpload1))//上传文件
{
throw new Exception("上传文件失败!");
}
DataTable inputdt = ue.InputExcel("Sheet1");
if (inputdt == null)
{
throw new Exception("Excel文件读取失败!找不到表Sheet1");
}
int j;
string erroritems = "";
SupplierBll supp = new SupplierBll();
tab_suppliers supplier;
for (int i = 0; i < inputdt.Rows.Count; i++)
{
j = 0;
supplier = new tab_suppliers();
supplier.supplier = inputdt.Rows[i][j++].ToString().Trim();
supplier.branch = inputdt.Rows[i][j++].ToString().Trim();
supplier.hospid = inputdt.Rows[i][j++].ToString().Trim();
supplier.province = inputdt.Rows[i][j++].ToString().Trim();
supplier.city = inputdt.Rows[i][j++].ToString().Trim();
supplier.zone = inputdt.Rows[i][j++].ToString().Trim();
supplier.address = inputdt.Rows[i][j++].ToString().Trim();
supplier.phone = inputdt.Rows[i][j++].ToString().Trim();
supplier.note = inputdt.Rows[i][j++].ToString().Trim();
supplier.lat = inputdt.Rows[i][j++].ToString().Trim();
supplier.lng = inputdt.Rows[i][j++].ToString().Trim();
supplier.type = inputdt.Rows[i][j++].ToString().Trim();
try
{
if (supp.Add(supplier) < 1)
{
errorcount++;
}
else
{
successfulcount++;
}
}
catch (Exception ex)
{
ex.Message.ToString();
errorcount++;
erroritems += supplier.supplier + " " + supplier.branch + "\n";
}
}
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "message", " <script>alert('操作已完成！其中成功导入数据" + successfulcount + "条，失败" + errorcount + "条," + erroritems + "'); </script>");
GridView1.DataBind();
}
else
{
throw new Exception("请选择Excel文件!");
}
}
catch (Exception ex)
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "message", " <script>alert('" + ex.Message + "'); </script>");
}
}
