/// <summary>
/// 修改
/// </summary>
/// <param name="model">数据模型</param>
/// <returns>影响行数</returns>
public JResult Update(FeVideo model)
{
var result = new JResult()
{
Status = false
};
try
{
if (Using <IVideo>().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 JResult <int> Insert(FeVideo model)
{
var result = new JResult <int>()
{
Status = false
};
try
{
var sysNo = Using <IVideo>().Insert(model);
if (sysNo <= 0)
{
throw new Exception("添加数据失败");
}
//LogApp.Instance.Info(new LogRequest() { Source = LogSource.后台, Message = "新增视频" });
result.Data = sysNo;
result.Status = true;
}
catch (Exception ex)
{
result.Message = ex.Message;
}
return(result);
}
/// <summary>
/// 插入
/// </summary>
/// <param name="model">数据模型</param>
/// <returns>影响行数</returns>
public int Insert(FeVideo model)
{
var result = DBContext.Insert <FeVideo>("fevideo", model)
.AutoMap(x => x.SysNo)
.ExecuteReturnLastId <int>("sysNo");
return(result);
}
/// <summary>
/// 修改
/// </summary>
/// <param name="model">数据模型</param>
/// <returns>影响行数</returns>
public int Update(FeVideo model)
{
int rowsAffected = DBContext.Update <FeVideo>("fevideo", model)
.AutoMap(x => x.SysNo)
.Where(x => x.SysNo)
.Execute();
return(rowsAffected);
}
/// <summary>
/// 验证标题是否存在
/// </summary>
/// <param name="model">账号</param>
public FeVideo GetByTitle(FeVideo model)
{
var sql = "select * from fevideo where title=@title and sysno!=@sysno";
return(DBContext.Sql(sql)
.Parameter("title", model.Title)
.Parameter("sysno", model.SysNo)
.QuerySingle <FeVideo>());
}
/// <summary>
/// 验证编码是否存在
/// </summary>
/// <param name="model">专题模型</param>
public JResult GetByTitle(FeVideo model)
{
var result = new JResult()
{
Status = false
};
try
{
if (Using <IVideo>().GetByTitle(model) != null)
{
result.Message = "名称已存在！";
result.Status = true;
}
}
catch (Exception ex)
{
result.Message = ex.Message;
}
return(result);
}
