public JsonResult DeleteBanner(long?NewInfoId) { NewInfoModel model = new NewInfoModel(); var resultModel = new ResultModel(); if (NewInfoId.HasValue) { model.NewInfoId = NewInfoId.Value; var result = this._newInfoService.DeleteNewInfo(model).IsValid; if (result) { resultModel.IsValid = true; resultModel.Messages = new List <string> { "Delete success" }; } else { resultModel.IsValid = false; resultModel.Messages = new List <string> { "Delete failed" }; } return(Json(resultModel, JsonRequestBehavior.AllowGet)); } else { resultModel.IsValid = false; resultModel.Messages = new List <string> { "Parameter ID error" }; } return(Json(resultModel, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 更新新闻信息表 wuyf /// </summary> /// <param name="model">新闻信息表模型</param> /// <returns>是否修改成功</returns> public ResultModel UpdateNewInfos(NewInfoModel model) { var result = new ResultModel { Data = _database.Db.NewInfo.UpdateByNewInfoId(NewInfoId: model.NewInfoId, NewContent: model.NewContent, NewImage: model.NewImage, NewTitle: model.NewTitle, NewType: model.NewType, UpdateBy: model.UpdateBy, UpdateDT: model.UpdateDT) }; return(result); }
/// <summary> /// 添加新闻信息表 wuyf /// </summary> /// <param name="model">新闻信息表</param> /// <returns>是否成功</returns> public ResultModel AddNewInfo(NewInfoModel model) { var result = new ResultModel { Data = _database.Db.NewInfo.Insert(model) }; return(result); }
//[UserAuthorize] public JsonResult UpdateIsRecommend(long?NewInfoId, int IsRecommend) { NewInfoModel model = new NewInfoModel(); var resultModel = new ResultModel(); if (NewInfoId.HasValue) { model.NewInfoId = NewInfoId.Value; model.IsRecommend = IsRecommend; model.UpdateBy = UserInfo.CurrentUserName; model.UpdateDT = DateTime.Now; var result = this._newInfoService.UpdateNewInfo(model).IsValid; if (result) { resultModel.IsValid = true; if (IsRecommend == 1) { resultModel.Messages = new List <string> { "Recommend success" }; } else { resultModel.Messages = new List <string> { "Not Recommend success" }; } } else { resultModel.IsValid = false; if (IsRecommend == 1) { resultModel.Messages = new List <string> { "Recommend failed" }; } else { resultModel.Messages = new List <string> { "Not Recommend failed" }; } } return(Json(resultModel, JsonRequestBehavior.AllowGet)); } else { resultModel.IsValid = false; resultModel.Messages = new List <string> { "Parameter ID error" }; } return(Json(resultModel, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 删除 /// </summary> /// <param name="model">新闻信息表模型</param> /// <returns>是否删除成功</returns> public ResultModel DeleteNewInfo(NewInfoModel model) { var result = new ResultModel() { Data = base._database.Db.NewInfo.Delete(NewInfoId: model.NewInfoId) }; result.IsValid = result.Data > 0 ? true : false; return(result); }
public ActionResult Add(NewInfoModel model) { var opera = string.Empty; if (ModelState.IsValid) { ResultModel resultModel = new ResultModel(); if (model.NewInfoId != 0) { model.UpdateBy = UserInfo.CurrentUserName;//asuser.UserName; model.UpdateDT = DateTime.Now; resultModel = this._newInfoService.UpdateNewInfos(model); resultModel.Messages = new List <string>() { resultModel.Data > 0 ? "Modify success" : "Modify failed" }; opera = string.Format("修改新闻:{0},操作结果:{1}", JsonConverts.ToJson(model), resultModel.Messages); LogPackage.InserAC_OperateLog(opera, "企业信息--新闻信息-修改"); } else { model.NewInfoId = MemCacheFactory.GetCurrentMemCache().Increment("commonId"); model.CreateBy = UserInfo.CurrentUserName; model.CreateDT = DateTime.Now; model.UpdateBy = UserInfo.CurrentUserName; model.UpdateDT = DateTime.Now; model.IsRecommend = 0; if (model.NewImage != null && model.NewImage.Trim() == ImagePath.Trim()) { model.NewImage = null;//前台会根据空值,加载默认图片 } resultModel = this._newInfoService.AddNewInfo(model); resultModel.Messages = new List <string>() { resultModel.Data != 0 ? "Add success" : "Add failed" }; opera = string.Format("添加新闻:{0},操作结果:{1}", JsonConverts.ToJson(model), resultModel.Messages); LogPackage.InserAC_OperateLog(opera, "企业信息--新闻信息-添加"); } if (resultModel.IsValid) { Response.Redirect("/NewInfo/Index"); } else { ViewBag.Messages = resultModel.Messages; return(View(model)); } //return Json(resultModel, JsonRequestBehavior.AllowGet); } return(View(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(NewInfoModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into NewInfo("); strSql.Append("NewSummary,NewTitle,NewContent,CreateTime,CreateUser,NewSourse,HotLv,RecommendLv,ClickLv,NewClassId,FlagInvalid"); strSql.Append(") values ("); strSql.Append("@NewSummary,@NewTitle,@NewContent,@CreateTime,@CreateUser,@NewSourse,@HotLv,@RecommendLv,@ClickLv,@NewClassId,@FlagInvalid"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@NewSummary", SqlDbType.NVarChar, 1000), new SqlParameter("@NewTitle", SqlDbType.NVarChar, 200), new SqlParameter("@NewContent", SqlDbType.NVarChar), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@CreateUser", SqlDbType.Decimal, 9), new SqlParameter("@NewSourse", SqlDbType.VarChar, 50), new SqlParameter("@HotLv", SqlDbType.Int, 4), new SqlParameter("@RecommendLv", SqlDbType.Int, 4), new SqlParameter("@ClickLv", SqlDbType.Int, 4), new SqlParameter("@NewClassId", SqlDbType.Decimal, 9), new SqlParameter("@FlagInvalid", SqlDbType.Bit, 1) }; parameters[0].Value = model.NewSummary; parameters[1].Value = model.NewTitle; parameters[2].Value = model.NewContent; parameters[3].Value = model.CreateTime; parameters[4].Value = model.CreateUser; parameters[5].Value = model.NewSourse; parameters[6].Value = model.HotLv; parameters[7].Value = model.RecommendLv; parameters[8].Value = model.ClickLv; parameters[9].Value = model.NewClassId; parameters[10].Value = model.FlagInvalid; bool result = false; try { helper.ExecSqlReInt(strSql.ToString(), parameters); result = true; } catch (Exception ex) { this.helper.Close(); throw ex; } finally { } return(result); }
/// <summary> /// Banner加载数据 /// </summary> /// <param name="id"></param> /// <returns></returns> public ActionResult Create(long?id) { ViewBag.RootImage = ImagePath; NewInfoModel model = new NewInfoModel(); if (id.HasValue) { ResultModel result = _newInfoService.GetNewsById(id.Value); if (result != null) { model = result.Data; } } return(PartialView(model)); }
/// <summary> /// 更新新闻信息表(更新推荐) wuyf /// </summary> /// <param name="model">新闻信息表模型</param> /// <returns>是否修改成功</returns> public ResultModel UpdateNewInfo(NewInfoModel model) { var result = new ResultModel(); using (var tx = _database.Db.BeginTransaction()) { try { //tx.NewInfo.UpdateAll(IsRecommend: 0, Condition: tx.NewInfo.IsRecommend > 0);//先把所以修改成为未推荐 tx.NewInfo.UpdateByNewInfoId(NewInfoId: model.NewInfoId, IsRecommend: model.IsRecommend);//在把单个改成推荐 tx.Commit(); } catch (Exception ex) { tx.Rollback(); result.IsValid = false; result.Messages.Add(ex.Message); } } return(result); }
public async Task LoadNewInfoData() { var result = await HomeService.GetNewInfoAsync(); NewInfos = new ObservableCollection <NewInfoModel>(); foreach (var item in result) { var model = new NewInfoModel { Code = item.Code, Consignee = item.Consignee, EnumExpressType = item.EnumExpressType, Ponus = item.Ponus, Remarks = item.Remarks, PickUpCode = item.PickUpCode, Sendaddress = item.Sendaddress, UserName = item.UserName, PickUpAddress = item.PickUpAddress, }; NewInfos.Add(model); } newInfoList.ItemsSource = NewInfos; }
public static NewInfo ToEntity(this NewInfoModel model) { return(Mapper.Map <NewInfo>(model)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(NewInfoModel model) { bool reValue = true; int reCount = 0; StringBuilder strSql = new StringBuilder(); strSql.Append("update NewInfo set "); strSql.Append(" NewSummary = @NewSummary , "); strSql.Append(" NewTitle = @NewTitle , "); strSql.Append(" NewContent = @NewContent , "); strSql.Append(" CreateTime = @CreateTime , "); strSql.Append(" CreateUser = @CreateUser , "); strSql.Append(" NewSourse = @NewSourse , "); strSql.Append(" HotLv = @HotLv , "); strSql.Append(" RecommendLv = @RecommendLv , "); strSql.Append(" ClickLv = @ClickLv , "); strSql.Append(" NewClassId = @NewClassId , "); strSql.Append(" FlagInvalid = @FlagInvalid "); strSql.Append(" where NewId=@NewId "); SqlParameter[] parameters = { new SqlParameter("@NewId", SqlDbType.Decimal, 9), new SqlParameter("@NewSummary", SqlDbType.NVarChar, 1000), new SqlParameter("@NewTitle", SqlDbType.NVarChar, 200), new SqlParameter("@NewContent", SqlDbType.NVarChar), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@CreateUser", SqlDbType.Decimal, 9), new SqlParameter("@NewSourse", SqlDbType.VarChar, 50), new SqlParameter("@HotLv", SqlDbType.Int, 4), new SqlParameter("@RecommendLv", SqlDbType.Int, 4), new SqlParameter("@ClickLv", SqlDbType.Int, 4), new SqlParameter("@NewClassId", SqlDbType.Decimal, 9), new SqlParameter("@FlagInvalid", SqlDbType.Bit, 1) }; parameters[0].Value = model.NewId; parameters[1].Value = model.NewSummary; parameters[2].Value = model.NewTitle; parameters[3].Value = model.NewContent; parameters[4].Value = model.CreateTime; parameters[5].Value = model.CreateUser; parameters[6].Value = model.NewSourse; parameters[7].Value = model.HotLv; parameters[8].Value = model.RecommendLv; parameters[9].Value = model.ClickLv; parameters[10].Value = model.NewClassId; parameters[11].Value = model.FlagInvalid; try {//异常处理 reCount = this.helper.ExecSqlReInt(strSql.ToString(), parameters); } catch (Exception ex) { this.helper.Close(); throw ex; } if (reCount <= 0) { reValue = false; } return(reValue); }