/// <summary>
/// 插入
/// </summary>
/// <param name="model">数据模型</param>
/// <returns>影响行数</returns>
public JResult Insert(FeVideoCategory model)
{
var result = new JResult()
{
Status = false
};
try
{
if (Using <IVideoCategory>().Insert(model) <= 0)
{
throw new Exception("添加数据失败");
}
//LogApp.Instance.Info(new LogRequest() { Source = LogSource.后台, Message = "新增视频" });
result.Status = true;
}
catch (Exception ex)
{
result.Message = ex.Message;
}
return(result);
}
/// <summary>
/// 插入
/// </summary>
/// <param name="model">数据模型</param>
/// <returns>影响行数</returns>
public int Insert(FeVideoCategory model)
{
var result = DBContext.Insert <FeVideoCategory>("fevideocategory", model)
.AutoMap(x => x.SysNo)
.ExecuteReturnLastId <int>("sysNo");
return(result);
}
/// <summary>
/// 修改
/// </summary>
/// <param name="model">数据模型</param>
/// <returns>影响行数</returns>
public int Update(FeVideoCategory model)
{
int rowsAffected = DBContext.Update <FeVideoCategory>("fevideocategory", model)
.AutoMap(x => x.SysNo)
.Where(x => x.SysNo)
.Execute();
return(rowsAffected);
}
/// <summary>
/// 验证标题是否存在
/// </summary>
/// <param name="model">账号</param>
public FeVideoCategory GetByTitle(FeVideoCategory model)
{
var sql = "select * from fevideocategory where subject=@subject and sysno!=@sysno";
return(DBContext.Sql(sql)
.Parameter("subject", model.Subject)
.Parameter("sysno", model.SysNo)
.QuerySingle <FeVideoCategory>());
}
/// <summary>
/// 插入
/// </summary>
/// <param name="request">菜单</param>
public JResult Save(SaveVideoCategoryRequest request)
{
var response = new JResult()
{
Status = false,
Message = "添加失败！"
};
using (var tran = new TransactionProvider())
{
try
{
var forum = new FeVideoCategory()
{
SysNo = request.SysNo,
Subject = request.Subject,
ImageUrl = request.ImageUrl,
ParentSysNo = request.ParentSysNo,
DisplayOrder = request.DisplayOrder,
Status = request.Status
};
if (request.SysNo > 0)
{
var row = Using <IVideoCategory>().Update(forum);
if (row <= 0)
{
throw new Exception("添加失败！");
}
tran.Commit();
response.Status = true;
response.Message = "更新成功！";
}
else
{
var menuSysNo = Using <IVideoCategory>().Insert(forum);
if (menuSysNo <= 0)
{
throw new Exception("添加版块失败！");
}
tran.Commit();
response.Status = true;
response.Message = "添加成功！";
}
}
catch (Exception ex)
{
tran.Rollback();
response.Message = ex.Message;
}
}
return(response);
}
/// <summary>
/// 验证编码是否存在
/// </summary>
/// <param name="model">专题模型</param>
public JResult GetByTitle(FeVideoCategory model)
{
var result = new JResult()
{
Status = false
};
try
{
if (Using <IVideoCategory>().GetByTitle(model) != null)
{
result.Message = "名称已存在！";
result.Status = true;
}
}
catch (Exception ex)
{
result.Message = ex.Message;
}
return(result);
}
