/// <summary> /// 导出蓄电池覆盖区域--按品牌 /// </summary> /// <param name="brand"></param> /// <returns></returns> public async Task <ActionResult> ExportData(string productType, string brand) { if (string.IsNullOrEmpty(brand)) { return(Json(new { Status = false, Msg = "请选择品牌" }, JsonRequestBehavior.AllowGet)); } var workbook = new XSSFWorkbook(); var index = 0; var sheet = workbook.CreateSheet(); var row = sheet.CreateRow(index++); var cellNum = 0; row.CreateCell(cellNum++).SetCellValue("省份名称"); row.CreateCell(cellNum++).SetCellValue("城市名称"); row.CreateCell(cellNum++).SetCellValue("区域名称"); row.CreateCell(cellNum++).SetCellValue("品牌"); row.CreateCell(cellNum++).SetCellValue("是否启用TRUE/FALSE"); row.CreateCell(cellNum).SetCellValue("备注(选填)"); cellNum = 0; sheet.SetColumnWidth(cellNum++, 10 * 256); sheet.SetColumnWidth(cellNum++, 10 * 256); sheet.SetColumnWidth(cellNum++, 10 * 256); sheet.SetColumnWidth(cellNum++, 14 * 256); sheet.SetColumnWidth(cellNum++, 20 * 256); sheet.SetColumnWidth(cellNum, 28 * 256); var pager = new PagerModel() { CurrentPage = 1, PageSize = int.MaxValue }; var manager = new VendorProductCoverAreaManager(); var list = (await manager.SelectVendorProductCoverArea (productType, "Brand", brand, string.Empty, 0, 0, 0, pager))?.Item1; if (list != null && list.Any()) { foreach (var item in list) { row = sheet.CreateRow(index++); cellNum = 0; row.CreateCell(cellNum++).SetCellValue(item.ProvinceName); row.CreateCell(cellNum++).SetCellValue(item.CityName); row.CreateCell(cellNum++).SetCellValue(item.DistrictName); row.CreateCell(cellNum++).SetCellValue(item.Brand); row.CreateCell(cellNum++).SetCellValue(item.IsEnabled); row.CreateCell(cellNum).SetCellValue(item.Remark); } } var ms = new MemoryStream(); workbook.Write(ms); var zhName = manager.GetZhNameByProductType(productType); return(File(ms.ToArray(), "application/x-xls", $"{zhName}产品{brand}品牌覆盖区域数据" + $"{DateTime.Now.ToString("yyyy年MM月dd日HH时mm分ss秒")}.xlsx")); }
public async Task <ActionResult> RemoveCache(VendorProductCoverAreaModel model) { if (string.IsNullOrEmpty(model?.ProductType) || model.CoverRegionId < 1) { return(Json(new { Status = false, Msg = "未知的对象" }, JsonRequestBehavior.AllowGet)); } var manager = new VendorProductCoverAreaManager(); var result = await manager.RemoveCache(new List <VendorProductCoverAreaModel>(1) { model }); return(Json(new { Status = result, Msg = $" 清除缓存{(result ? "成功" : "失败")}" }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 查询覆盖区域--按品牌 /// </summary> /// <param name="brand"></param> /// <param name="province"></param> /// <param name="city"></param> /// <param name="district"></param> /// <param name="pageNum"></param> /// <param name="pageSize"></param> /// <returns></returns> public async Task <JsonResult> SelectCoverArea (string productType, string coverType, string brand, string pid, int provinceId, int cityId, int districtId, int pageIndex, int pageSize = 20) { var manager = new VendorProductCoverAreaManager(); var pager = new PagerModel(pageIndex, pageSize); var result = await manager.SelectVendorProductCoverArea(productType, coverType, brand, pid, provinceId, cityId, districtId, pager); return(Json(new { Status = result.Item1 != null, Data = result.Item1, TotalCount = result.Item2 } , JsonRequestBehavior.AllowGet)); }
public JsonResult DeleteCoverArea(VendorProductCoverAreaModel model) { if (model?.PKID < 1) { return(Json(new { Status = false, Msg = "未知的删除对象" })); } bool result = false; var user = HttpContext.User.Identity.Name; var manager = new VendorProductCoverAreaManager(); result = manager.DeleteCoverArea(model, user); return(Json(new { Status = result, Msg = $"删除{(result ? "成功" : "失败")}" }, JsonRequestBehavior.AllowGet)); }
public async Task <ActionResult> UploadExcel(string productType, string coverType) { var files = Request.Files; if (files.Count < 1) { return(Json(new { Status = false, Msg = "请选择文件" })); } var file = files[0]; if (file.ContentType != "application/vnd.ms-excel" && file.ContentType != "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet") { return(Json(new { Status = false, Msg = "请上传Excel文件" })); } var fileSize = file.ContentLength; if (fileSize > 200 * 1024) { return(Json(new { Status = false, Msg = "文件大小不得超过200KB(不同品牌分批上传)" })); } var convertResult = ConvertExcelToList(file); if (!string.IsNullOrEmpty(convertResult.Item2)) { return(Json(new { Status = false, Msg = convertResult.Item2 })); } else if (convertResult.Item1 == null || !convertResult.Item1.Any()) { return(Json(new { Status = false, Msg = "Excel内容为空" })); } else { var manager = new VendorProductCoverAreaManager(); var user = User.Identity.Name; var fillResult = await manager.FillConvertCoverArea(convertResult.Item1, productType, coverType); if (!string.IsNullOrEmpty(fillResult.Item2)) { return(Json(new { Status = false, Msg = fillResult.Item2 })); } var result = await manager.UploadBatterCoverArea(fillResult.Item1, user); return(Json(new { Status = result, Msg = $"导入{(result ? "成功" : "失败")}" })); } }
public JsonResult AddCoverArea(VendorProductCoverAreaModel model) { if (model?.CoverRegionId < 1 || string.IsNullOrEmpty(model.ProductType) || string.IsNullOrEmpty(model.CoverType)) { return(Json(new { Status = false, Msg = "未知的添加对象" })); } var user = HttpContext.User.Identity.Name; var manager = new VendorProductCoverAreaManager(); var validateResult = manager.ValidateVendorProductConverArea(model); if (!validateResult.Item1) { return(Json(new { Status = false, Msg = validateResult.Item2 })); } var result = manager.AddCoverArea(model, user); return(Json(new { Status = result, Msg = $"添加{(result ? "成功" : "失败")}" }, JsonRequestBehavior.AllowGet)); }