public ActionResult SearchExportAvg() { var filter = SerializeHelper.JsonDeserializeFixed <QF_Subject>(Request.Form["queryString"]); var list = SubjectBasisService.SearchExportAvg(filter); var tables = new List <DataTable> { DataMapper.ListToDataTable(list) }; var columns = new List <List <ColumnData> > { new List <ColumnData> { new ColumnData { FieldName = "dept_name", Width = 40, Title = "单位", HorizontalAlignment = HorizAlignments.Centered }, new ColumnData { FieldName = "dd", Width = 30, Title = "单位平均未读数", HorizontalAlignment = HorizAlignments.Right } //ValueFormat="yyyy/MM/dd HH:mm:ss" } }; string fileName = string.Empty; var excelExport = new ExcelFileExporter(); byte[] excelByte = excelExport.CreateFile(tables, new List <string>() { "单位平均未读数" }, columns, null, out fileName, "单位平均未读数"); fileName = "单位平均未读数.xls"; return(File(new MemoryStream(excelByte), "application/ms-excel", fileName)); }
public JsonResult GetById(int subjectId) { return(Json(new AjaxResult() { Success = true, Data = SubjectBasisService.GetById(subjectId) }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 更新主题参与活动关系表质量达人分 /// </summary> /// <param name="entity"></param> /// <returns></returns> public ActionResult UpdateSubjectPlanScoreExtra(SubjectPlanScoreExtra entity) { var result = SubjectBasisService.UpdateSubjectPlanScoreExtra(entity); return(Json(new AjaxResult() { Data = entity, Success = true, Message = "保存成功!" }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 获取主题参与活动关系表 /// </summary> /// <param name="subject_id"></param> /// <returns></returns> public ActionResult LoadSubjectPlan(int subject_id) { var result = SubjectBasisService.LoadSubjectPlan(subject_id); return(Json(new AjaxResult() { Success = true, Data = result }, JsonRequestBehavior.AllowGet)); }
public JsonResult LoadSubject(int id) { var entity = SubjectBasisService.LoadSubject(id); return(Json(new AjaxResult() { Success = true, Data = entity }, JsonRequestBehavior.AllowGet)); }
public JsonResult UpdateViews(SubjectModel entity) { entity.id = entity.subjectid; SubjectBasisService.UpdateViewCount(entity); return(Json(new AjaxResult() { Success = true, Data = true }, JsonRequestBehavior.AllowGet)); }
public ActionResult SearchExportRanking() { var filter = SerializeHelper.JsonDeserializeFixed <QF_Subject>(Request.Form["queryString"]); var list = SubjectBasisService.SearchExportRanking(filter); var tables = new List <DataTable> { DataMapper.ListToDataTable(list) }; var columns = new List <List <ColumnData> > { new List <ColumnData> { new ColumnData { FieldName = "user_id", Width = 30, Title = "用户Id", HorizontalAlignment = HorizAlignments.Centered }, new ColumnData { FieldName = "user_name", Width = 30, Title = "用户姓名", HorizontalAlignment = HorizAlignments.Left }, new ColumnData { FieldName = "number1", Width = 40, Title = "投诉量统计", HorizontalAlignment = HorizAlignments.Right }, new ColumnData { FieldName = "number2", Width = 30, Title = "处理质量", HorizontalAlignment = HorizAlignments.Right }, new ColumnData { FieldName = "number3", Width = 30, Title = "处理效率", HorizontalAlignment = HorizAlignments.Right } } }; string fileName = string.Empty; var excelExport = new ExcelFileExporter(); byte[] excelByte = excelExport.CreateFile(tables, new List <string>() { "排行榜" }, columns, null, out fileName, "排行榜"); fileName = "排行榜.xls"; return(File(new MemoryStream(excelByte), "application/ms-excel", fileName)); }
public JsonResult UpdateWeight(int?weight, int subjectId) { int count = 0; if (weight.HasValue && weight != 0) { count = SubjectBasisService.ValidWeight(weight, subjectId); } if (count > 0) { return(Json(new AjaxResult() { Success = false, Data = true, Message = "重要置顶与其他重复" }, JsonRequestBehavior.AllowGet)); } else { SubjectBasisService.UpdateWeight(weight, subjectId); } return(Json(new AjaxResult() { Success = true, Data = true }, JsonRequestBehavior.AllowGet)); }
public ActionResult SearchExportList() { var filter = SerializeHelper.JsonDeserializeFixed <QF_Subject>(Request.Form["queryString"]); var list = SubjectBasisService.SearchExportList(filter); var tables = new List <DataTable> { DataMapper.ListToDataTable(list) }; var columns = new List <List <ColumnData> > { new List <ColumnData> { new ColumnData { FieldName = "Id", Width = 20, Title = "主题Id", HorizontalAlignment = HorizAlignments.Centered }, new ColumnData { FieldName = "CreateTimeStr", Width = 20, Title = "发表时间", HorizontalAlignment = HorizAlignments.Left }, //ValueFormat="yyyy/MM/dd HH:mm:ss" new ColumnData { FieldName = "OrderTimeStr", Width = 20, Title = "最新回复时间", HorizontalAlignment = HorizAlignments.Left }, //ValueFormat="yyyy/MM/dd HH:mm:ss" new ColumnData { FieldName = "CreateUserName", Width = 20, Title = "发表人", HorizontalAlignment = HorizAlignments.Left }, new ColumnData { FieldName = "DepartmentName", Width = 20, Title = "主题所属单位", HorizontalAlignment = HorizAlignments.Left }, new ColumnData { FieldName = "CatName", Width = 20, Title = "主题分类", HorizontalAlignment = HorizAlignments.Left }, new ColumnData { FieldName = "Telephone", Width = 20, Title = "发表人手机号码", HorizontalAlignment = HorizAlignments.Left }, new ColumnData { FieldName = "TitleDesc", Width = 40, Title = "标题", HorizontalAlignment = HorizAlignments.Left }, new ColumnData { FieldName = "ContentDesc", Width = 40, Title = "正文", HorizontalAlignment = HorizAlignments.Left }, new ColumnData { FieldName = "ProductName", Width = 30, Title = "产品名称", HorizontalAlignment = HorizAlignments.Left }, new ColumnData { FieldName = "Vendor", Width = 30, Title = "供应商", HorizontalAlignment = HorizAlignments.Left }, new ColumnData { FieldName = "ComplainVendor", Width = 30, Title = "投诉供应商", HorizontalAlignment = HorizAlignments.Left }, new ColumnData { FieldName = "ReplyerUserDesc", Width = 30, Title = "分配对象", HorizontalAlignment = HorizAlignments.Left }, new ColumnData { FieldName = "Zan", Width = 10, Title = "赞数", HorizontalAlignment = HorizAlignments.Right }, new ColumnData { FieldName = "View", Width = 10, Title = "热度", HorizontalAlignment = HorizAlignments.Right }, new ColumnData { FieldName = "CommentCount", Width = 10, Title = "回复数", HorizontalAlignment = HorizAlignments.Right }, new ColumnData { FieldName = "FirstCommentTimeStr", Width = 20, Title = "首响回复时间", HorizontalAlignment = HorizAlignments.Left }, // ValueFormat="yyyy/MM/dd HH:mm:ss", new ColumnData { FieldName = "FirstCommentUser", Width = 20, Title = "首响回复人", HorizontalAlignment = HorizAlignments.Left }, new ColumnData { FieldName = "FirstCommentDesc", Width = 30, Title = "首响回复内容", HorizontalAlignment = HorizAlignments.Left }, new ColumnData { FieldName = "FirstStatTimeStr", Width = 20, Title = "评星回复时间", HorizontalAlignment = HorizAlignments.Left }, new ColumnData { FieldName = "FirstStatCommentDesc", Width = 30, Title = "评星回复内容", HorizontalAlignment = HorizAlignments.Left }, //ValueFormat="yyyy/MM/dd HH:mm:ss", new ColumnData { FieldName = "FirstStatUser", Width = 20, Title = "评星回复人", HorizontalAlignment = HorizAlignments.Left }, new ColumnData { FieldName = "FirstStar", Width = 10, Title = "评星数", HorizontalAlignment = HorizAlignments.Right }, new ColumnData { FieldName = "StarRemark", Width = 30, Title = "评星意见", HorizontalAlignment = HorizAlignments.Left }, new ColumnData { FieldName = "StartTimeStr", Width = 20, Title = "评星时间", HorizontalAlignment = HorizAlignments.Left }, //ValueFormat="yyyy/MM/dd HH:mm:ss" , new ColumnData { FieldName = "StarRemarkAppend", Width = 30, Title = "追评意见", HorizontalAlignment = HorizAlignments.Left }, new ColumnData { FieldName = "VendorStar", Width = 20, Title = "供应商评价", HorizontalAlignment = HorizAlignments.Right } } }; string fileName = string.Empty; var excelExport = new ExcelFileExporter(); byte[] excelByte = excelExport.CreateFile(tables, new List <string>() { "论坛活动主题" }, columns, null, out fileName, "论坛活动主题"); fileName = "论坛活动主题.xls"; return(File(new MemoryStream(excelByte), "application/ms-excel", fileName)); }
public JsonResult Query() { QF_Subject filter = BuildQueryFilterEntity <QF_Subject>(); return(AjaxGridJson(SubjectBasisService.SearchPageList(filter))); }