/// <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);
}
