public JsonResult SelectOperationLog(string objectId) { CompanyClientManager manager = new CompanyClientManager(); var result = manager.SelectOperationLog(objectId, string.Empty); return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult ExportClientCouponCode(int parentId, int isBind, string channel) { CompanyClientManager manager = new CompanyClientManager(); var result = manager.SelectCouponCodeByParentId(parentId, isBind); //创建Excel文件的对象 NPOI.HSSF.UserModel.HSSFWorkbook book = new NPOI.HSSF.UserModel.HSSFWorkbook(); //添加一个sheet NPOI.SS.UserModel.ISheet sheet1 = book.CreateSheet("Sheet1"); //获取list数据 //给sheet1添加第一行的头部标题 NPOI.SS.UserModel.IRow row1 = sheet1.CreateRow(0); var fileName = channel + DateTime.Now.ToString("yyyy_MM_dd_HHmm") + ".xls"; row1.CreateCell(0).SetCellValue("渠道"); row1.CreateCell(1).SetCellValue("活动券码"); row1.CreateCell(2).SetCellValue("手机号"); row1.CreateCell(3).SetCellValue("创建时间"); if (result != null && result.Any()) { for (var i = 0; i < result.Count; i++) { NPOI.SS.UserModel.IRow rowtemp = sheet1.CreateRow(i + 1); rowtemp.CreateCell(0).SetCellValue(channel); rowtemp.CreateCell(1).SetCellValue(result[i].CouponCode); rowtemp.CreateCell(2).SetCellValue(result[i].Telephone); rowtemp.CreateCell(3).SetCellValue(result[i].CreatedTime.ToString()); } } // 写入到客户端 System.IO.MemoryStream ms = new System.IO.MemoryStream(); book.Write(ms); ms.Seek(0, SeekOrigin.Begin); return(File(ms, "application/vnd.ms-excel", fileName)); }
public JsonResult SelectCouponCodeByParentId(int parentId, int isBind) { CompanyClientManager manager = new CompanyClientManager(); var result = manager.SelectCouponCodeByParentId(parentId, isBind); if (result != null && result.Any()) { return(Json(new { status = "success", data = result, count = result.FirstOrDefault().Total }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { status = "fail", count = 0 }, JsonRequestBehavior.AllowGet)); } }
public JsonResult GetAllCompanyClientConfig(int pageIndex = 1, int pageSize = 15) { CompanyClientManager manager = new CompanyClientManager(); var result = manager.GetAllCompanyClientConfig(pageIndex, pageSize); if (result != null && result.Any()) { return(Json(new { status = "success", data = result, count = result.FirstOrDefault().Total }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { status = "fail" }, JsonRequestBehavior.AllowGet)); } }
public JsonResult DeletedCouponCodeByPkid(int pkid) { CompanyClientManager manager = new CompanyClientManager(); var result = manager.DeletedCouponCodeByPkid(pkid); if (result) { return(Json(new { status = "success" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { status = "fail" }, JsonRequestBehavior.AllowGet)); } }
public JsonResult DeletedCompanyClientConfig(int pkid) { CompanyClientManager manager = new CompanyClientManager(); var result = manager.DeletedCompanyClientConfig(pkid, HttpContext.User.Identity.Name); if (result) { return(Json(new { status = "success" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { status = "fail" }, JsonRequestBehavior.AllowGet)); } }
public JsonResult UpdateCompanyClientConfig(string channel, string url, int pkid) { CompanyClientManager manager = new CompanyClientManager(); var result = manager.UpdateCompanyClientConfig(channel, url, pkid, HttpContext.User.Identity.Name); if (result) { return(Json(new { status = "success" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { status = "fail" }, JsonRequestBehavior.AllowGet)); } }
public JsonResult GenerateCouponCode(string channel, int count, int parentId) { CompanyClientManager manager = new CompanyClientManager(); var result = manager.GenerateCouponCode(channel, count, parentId, HttpContext.User.Identity.Name); if (result) { return(Json(new { status = "success" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { status = "fail" }, JsonRequestBehavior.AllowGet)); } }