public ActionResult Edit(short type, int id = 0)
{
ViewBag.ProvinceList = MeiRongAcitivityConfigManager.GetRegion(0);
if (id == 0)
{
BeautyHomePageConfig model = new BeautyHomePageConfig();
model.StartTime = DateTime.Now;
model.EndTime = DateTime.Now.AddDays(30);
model.Status = true;
model.Channel = "ios";
model.Type = type;
return(View(model));
}
else
{
BeautyHomePageConfig model = BeautyHomePageConfigManager.GetBeautyHomePageConfigById(id);
model.RegionList = MeiRongAcitivityConfigManager.GetRegionRelation(model.Id, 2);
return(View(model));
}
}
public ActionResult Export(MDBeautyApplyConfig model)
{
using (var stream = new MemoryStream(System.IO.File.ReadAllBytes(Server.MapPath(@"~/Content/Export/门店美容活动退出审核列表.xlsx"))))
{
int count = 0;
var list = MDBeautyApplyConfigManager.GetMDBeautyApplyConfigList(model, int.MaxValue, 1, "Exit", out count);
var xssfWorkbook = new XSSFWorkbook(stream); //创建Workbook对象 2007+
// var hssfWorkbook = new HSSFWorkbook(stream)://2003
if (list.Count > 0)
{
var i = 0;
var sheet = xssfWorkbook.GetSheetAt(0);
foreach (var item in list)
{
MeiRongAcitivityConfigManager manager = new MeiRongAcitivityConfigManager();
model.RegionList = manager.GetRegionRelation(item.Id, 1);
string region = string.Empty;
if (model.RegionList != null && model.RegionList.Count > 0)
{
foreach (var regionItem in model.RegionList)
{
region += regionItem.ProvinceName + "：" + regionItem.CityName + "；";
}
}
string apply = string.Empty;
switch (item.ApplyAuditStatus)
{
case 1:
apply = "待审核";
break;
case 2:
apply = "不通过";
break;
case 3:
apply = "通过";
break;
default:
break;
}
string exit = string.Empty;
switch (item.ExitAuditStatus)
{
case 1:
exit = "待审核";
break;
case 2:
exit = "不通过";
break;
case 3:
exit = "通过";
break;
default:
break;
}
var row = sheet.CreateRow((i++) + 1);
row.CreateCell(0).SetCellValue(item.BeautyAcitivityId);
row.CreateCell(1).SetCellValue(item.Name);
row.CreateCell(2).SetCellValue(region);
row.CreateCell(3).SetCellValue(item.CategoryName);
row.CreateCell(4).SetCellValue(item.MinShopQuantity);
row.CreateCell(5).SetCellValue(item.SignUpStartTime?.ToString() + "—" + item.SignUpEndTime?.ToString());
row.CreateCell(6).SetCellValue(item.PlanStartTime?.ToString() + "—" + item.ActivityEndTime?.ToString());
row.CreateCell(7).SetCellValue(item.MinPrice + "—" + item.MaxPrice);
row.CreateCell(8).SetCellValue(item.Status == 1 ? "启用" : "禁用");
row.CreateCell(9).SetCellValue(item.ShopId);
row.CreateCell(10).SetCellValue(item.ShopName);
row.CreateCell(11).SetCellValue(item.ProductId);
row.CreateCell(12).SetCellValue(item.ProductName);
row.CreateCell(13).SetCellValue(apply);
row.CreateCell(13).SetCellValue(exit);
}
Response.AppendHeader("Content-Disposition", "attachment;fileName=门店美容活动退出审核列表" + ".xlsx");
xssfWorkbook.Write(Response.OutputStream);
Response.End();
}
}
return(Json(true, JsonRequestBehavior.AllowGet));
}