/// <summary>
/// 向数据库中添加一条记录
/// </summary>
/// <param name="model">要添加的实体</param>
/// <returns>插入数据的ID</returns>
public int Insert(VidoFile model)
{
#region SQL语句
const string sql = @"
INSERT INTO [dbo].[VidoFile] (
[Title]
,[FivPath]
,[Status]
,[FileExt]
)
VALUES (
@Title
,@FivPath
,@Status
,@FileExt
);select @@IDENTITY";
#endregion
var res = SqlHelper.ExecuteScalar(sql,
new SqlParameter("@Title", model.Title),
new SqlParameter("@FivPath", model.FivPath),
new SqlParameter("@Status", model.Status),
new SqlParameter("@FileExt", model.FileExt)
);
return(res == null ? 0 : Convert.ToInt32(res));
}
/// <summary>
/// 根据主键ID更新一条记录
/// </summary>
/// <param name="model">更新后的实体</param>
/// <returns>执行结果受影响行数</returns>
public int Update(VidoFile model)
{
#region SQL语句
const string sql = @"
UPDATE [dbo].[VidoFile]
SET
[Title] = @Title
,[FivPath] = @FivPath
,[Status] = @Status
,[FileExt] = @FileExt
WHERE [Id] = @Id";
#endregion
return(SqlHelper.ExecuteNonQuery(sql,
new SqlParameter("@Id", model.Id),
new SqlParameter("@Title", model.Title),
new SqlParameter("@FivPath", model.FivPath),
new SqlParameter("@Status", model.Status),
new SqlParameter("@FileExt", model.FileExt)
));
}
