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