public ActionResult TradeInfoDetailSave(TradeInfoViewPage TradeInfoSave, string idd)
{
ITradeInfo IT = new TradeInfoMethod();
string message = IT.CheckTradeInfoSave(TradeInfoSave);
string fileSave = Server.MapPath("~/upload/");
if (message != "修改成功！")
{
return(Json(message));
}
try
{
HttpFileCollectionBase file = Request.Files;
if (file.Count != 0)
{
for (int i = 0; i < file.Count; i++)
{
if (file.AllKeys[i] == "TradeImg")
{
HttpPostedFileBase file1 = file[i];
string extName = Path.GetExtension(file1.FileName);
string newName = Guid.NewGuid().ToString() + extName;
file1.SaveAs(Path.Combine(fileSave, newName));
TradeInfoSave.TradeImg = "../upload/" + newName;
}
}
}
}
catch
{
return(Json("文件过大", JsonRequestBehavior.AllowGet));
}
IT.Save(TradeInfoSave, idd);
return(Json("修改成功！"));
}
public ActionResult Delete(string id = null)
{
ITradeInfo IU = new TradeInfoMethod();
string message = IU.Delete(id);
if (message != "删除成功！")
{
return(Json(message));
}
return(Json("删除成功！"));
}
//导出
public ActionResult daochu()
{
ITradeInfo IT = new TradeInfoMethod();
//将查询出来的数据转化为对象列表的格式
var dao = IT.daochu().aa;
//创建工作簿
HSSFWorkbook excelBook = new HSSFWorkbook();
//为工作簿创建工作表并命名
NPOI.SS.UserModel.ISheet sheet1 = excelBook.CreateSheet("商展信息");
//创建表头
NPOI.SS.UserModel.IRow row1 = sheet1.CreateRow(0); //先创建一行用来放表头
//创建7列并赋值
row1.CreateCell(0).SetCellValue("企业名称"); //第0行，第0列
row1.CreateCell(1).SetCellValue("商展地址"); //第0行，第1列
//创建数据行
for (int i = 0; i < dao.Count(); i++)
{
//创建行
NPOI.SS.UserModel.IRow rowTemp = sheet1.CreateRow(i + 1);//因为第一行已经被表头占用了，所以要+1
rowTemp.CreateCell(0).SetCellValue(dao[i].CompanyName);
rowTemp.CreateCell(1).SetCellValue(dao[i].TradeAddress);
}
//命名文件名
var fileName = "商展信息" + DateTime.Now.ToString("yyyy-MM-dd-HH-mm-ss-ffff") + ".xls";
//将Excel表格转化为流，输出
//创建文件流
MemoryStream bookStream = new MemoryStream();
//文件写入流（向流中写入字节序列）
excelBook.Write(bookStream);
//输出之前调用Seek（偏移量，游标位置) 把0位置指定为开始位置
bookStream.Seek(0, SeekOrigin.Begin);
return(File(bookStream, "applicationnd.ms-excel", fileName));
}
public ActionResult TradeInfoDetail1(string id = null)
{
ITradeInfo IU = new TradeInfoMethod();
return(Json(IU.TradeInfoDetail(id)));
}
public ActionResult TradeInfoIndex1(string searchString, string Date, string Place, int?page)
{
ITradeInfo IU = new TradeInfoMethod();
return(Json(IU.Index(searchString, Date, Place, page), JsonRequestBehavior.AllowGet));
}
public ActionResult LeaveMessage1(string id)
{
ITradeInfo IT = new TradeInfoMethod();
return(Json(IT.TradeInfoMessage(id), JsonRequestBehavior.AllowGet));
}
