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