public int Save(CourseFlieEntity data)
{
try
{
return(Connection.Db.Query <int>("spCourseFlieSet",
new
{
Id = data.Id,
CourseId = data.CourseId,
FileName = data.FileName,
FileType = data.FileType,
Address = data.Address,
Active = data.Active,
}, commandType: CommandType.StoredProcedure).SingleOrDefault());
}
catch (Exception ex)
{
Tools.SaveLog.Save(ex);
return(-1);
}
}
public List <CourseFlieEntity> Search(CourseFlieEntity data)
{
try
{
return(Connection.Db.Query <CourseFlieEntity>("spCourseFlieSearch",
new
{
Id = data.Id,
CourseId = data.CourseId,
FileName = "%" + data.FileName + "%",
FileType = "%" + data.FileType + "%",
Address = "%" + data.Address + "%",
Active = data.Active,
}, commandType: CommandType.StoredProcedure).ToList());
}
catch (Exception ex)
{
Tools.SaveLog.Save(ex);
return(new List <CourseFlieEntity>());
}
}
