/// <summary> /// 获取途虎挪车二维码总生成下载记录 /// </summary> /// <returns></returns> public ActionResult GetMoveCarTotalRecordsModel() { var manager = new MoveCarQRCodeManager(); var totalRecordsModel = manager.GetMoveCarTotalRecordsModel(); return(Json(new { data = totalRecordsModel }, JsonRequestBehavior.AllowGet)); }
public ActionResult GetMoveCarGenerationRecordsList(int pageSize = 20, int pageIndex = 1) { var manager = new MoveCarQRCodeManager(); int recordCount = 0; var list = manager.GetMoveCarGenerationRecordsList(out recordCount, pageSize, pageIndex); return(Json(new { data = list, count = recordCount }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 新增下载 /// </summary> /// <param name="downloadNum"></param> /// <returns></returns> public ActionResult DownloadMoveCarQRCode(int downloadNum) { var workbook = new XSSFWorkbook(); var sheet = workbook.CreateSheet(); var index = 0; var row = sheet.CreateRow(index++); var num = 0; row.CreateCell(num++).SetCellValue("二维码"); row.CreateCell(num++).SetCellValue("使用状态"); row.CreateCell(num++).SetCellValue("生成时间"); num = 0; sheet.SetColumnWidth(num++, 16 * 256); sheet.SetColumnWidth(num++, 16 * 256); sheet.SetColumnWidth(num++, 16 * 256); var exm = new MoveCarQRCodeManager(); //更新途虎挪车二维码表的下载flag为true 并获取更新flag的列表 var list = exm.UpdateDownloadFlagAndSelectMoveCarQRCode(downloadNum, User.Identity.Name); //修改途虎挪车二维码总下载记录 var existTotalModel = exm.GetMoveCarTotalRecord(); var totalRecordModel = new MoveCarTotalRecordsModel(); totalRecordModel.GeneratedNum = 0; totalRecordModel.DownloadedNum = downloadNum; exm.AddOrUpdateMoveCarTotalRecord(totalRecordModel, 1); string bingStatus = string.Empty; foreach (var item in list) { row = sheet.CreateRow(index++); num = 0; if (item.IsBinding == false) { bingStatus = "未绑定"; } else { bingStatus = "已绑定"; } row.CreateCell(num++).SetCellValue(item.QRCodeImageUrl); row.CreateCell(num++).SetCellValue(bingStatus); row.CreateCell(num++).SetCellValue(item.CreateDatetime.ToString("yyyy-MM-dd HH:mm:ss")); } var ms = new MemoryStream(); workbook.Write(ms); return(File(ms.ToArray(), "application/x-xls", $"下载途虎挪车二维码-{DateTime.Now.ToString("yyyy年MM月dd日HH时mm分ss秒")}-{downloadNum}.xlsx")); }
public ActionResult GenerationMoveCarQRCode(int generationNum) { var manager = new MoveCarQRCodeManager(); //添加途虎挪车二维码生成记录 var generationRecordModel = new MoveCarGenerationRecordsModel(); generationRecordModel.GeneratedNum = generationNum; generationRecordModel.GeneratingStatus = 0; generationRecordModel.CreateBy = User.Identity.Name; generationRecordModel.LastUpdateBy = User.Identity.Name; int batchID = manager.AddMoveCarGenerationRecords(generationRecordModel);//生成记录表的pkid bool isSuccess = batchID > 0; if (isSuccess) { return(Json(new { status = isSuccess, msg = "操作成功!" })); } else { return(Json(new { status = isSuccess, msg = "操作失败!" })); } }