/// <summary> /// 修改 /// </summary> /// <param name="model">数据模型</param> /// <returns>影响行数</returns> public JResult Update(FeVideoItem model) { var result = new JResult() { Status = false }; try { if (Using <IVideoItem>().Update(model) <= 0) { throw new Exception("修改数据失败"); } //LogApp.Instance.Info(new LogRequest() { Source = LogSource.后台, Message = "修改视频" }); result.Message = "操作成功!"; result.Status = true; } catch (Exception ex) { result.Message = ex.Message; } return(result); }
/// <summary> /// 插入 /// </summary> /// <param name="model">数据模型</param> /// <returns>影响行数</returns> public int Insert(FeVideoItem model) { var result = DBContext.Insert <FeVideoItem>("fevideoitem", model) .AutoMap(x => x.SysNo) .ExecuteReturnLastId <int>("sysNo"); return(result); }
/// <summary> /// 修改 /// </summary> /// <param name="model">数据模型</param> /// <returns>影响行数</returns> public int Update(FeVideoItem model) { int rowsAffected = DBContext.Update <FeVideoItem>("fevideoitem", model) .AutoMap(x => x.SysNo) .Where(x => x.SysNo) .Execute(); return(rowsAffected); }
/// <summary> /// 验证标题是否存在 /// </summary> /// <param name="model">账号</param> public FeVideoItem GetByTitle(FeVideoItem model) { var sql = "select * from fevideoitem where name=@name and sysno!=@sysno"; return(DBContext.Sql(sql) .Parameter("name", model.Name) .Parameter("sysno", model.SysNo) .QuerySingle <FeVideoItem>()); }
/// <summary> /// 验证编码是否存在 /// </summary> /// <param name="model">专题模型</param> public JResult GetByTitle(FeVideoItem model) { var result = new JResult() { Status = false }; try { if (Using <IVideoItem>().GetByTitle(model) != null) { result.Message = "名称已存在!"; result.Status = true; } } catch (Exception ex) { result.Message = ex.Message; } return(result); }
/// <summary> /// 插入 /// </summary> /// <param name="videoItem">数据模型</param> /// <returns>影响行数</returns> public JResult Save(List <VideoItemRequest> videoItem) { var response = new JResult() { Status = false }; using (var tran = new TransactionProvider()) { try { foreach (var item in videoItem) { var obj = new FeVideoItem(); if (item.SysNo > 0) { obj = Using <IVideoItem>().Get(item.SysNo); obj.Name = item.Name; obj.ImageUrl = item.ImageUrl; obj.PlayUrl = item.PlayUrl; obj.DisplayOrder = item.DisplayOrder; } else { obj.VideoSysNo = item.VideoSysNo; obj.Name = item.Name; obj.ImageUrl = item.ImageUrl; obj.PlayUrl = item.PlayUrl; obj.PlayNumber = 0; obj.DisplayOrder = item.DisplayOrder; obj.Status = StatusEnum.启用.GetHashCode(); obj.CreatedDate = DateTime.Now; } if (item.SysNo > 0) { if (Using <IVideoItem>().Update(obj) <= 0) { throw new Exception("修改失败:" + item.Name); } } else { if (Using <IVideoItem>().Insert(obj) <= 0) { throw new Exception("添加失败:" + item.Name); } } } //LogApp.Instance.Info(new LogRequest() { Source = LogSource.后台, Message = "新增视频" }); tran.Commit(); response.Status = true; } catch (Exception ex) { tran.Rollback(); response.Message = ex.Message; } finally { tran.Dispose(); } } return(response); }