/// <summary> /// 添加 /// </summary> /// <param name="model"></param> /// <returns>是否成功</returns> public bool Add(Aut_MenuModel model) { string sqlStr = @"USE Authority INSERT INTO Aut_Menu( IsDel , CreateTime , Name , Url , Sort , MenuLevel , ParentId ) VALUES ( @IsDel , @CreateTime , @Name , @Url , @Sort , @MenuLevel , @ParentId )"; SqlParameter[] parameters = { new SqlParameter("@IsDel", model.IsDel), new SqlParameter("@CreateTime", model.CreateTime), new SqlParameter("@Name", model.Name), new SqlParameter("@Url", model.Url), new SqlParameter("@Sort", model.Sort), new SqlParameter("@MenuLevel", model.MenuLevel), new SqlParameter("@ParentId", model.ParentId) }; return SqlHelper.ExecteNonQueryText(sqlStr, parameters) > 0; }
/// <summary> /// 更新 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Update(Aut_MenuModel model) { return _dataDemo.Update(model); }
/// <summary> /// 更新 /// </summary> /// <param name="model"></param> /// <returns>是否成功</returns> public bool Update(Aut_MenuModel model) { string sqlStr = @"USE Authority UPDATE Aut_Menu SET IsDel = @IsDel , CreateTime = @CreateTime , Name = @Name , Url = @Url , Sort = @Sort , MenuLevel = @MenuLevel , ParentId = @ParentId WHERE Id = @Id"; SqlParameter[] parameters = { new SqlParameter("@Id",model.Id), new SqlParameter("@IsDel", model.IsDel), new SqlParameter("@CreateTime", model.CreateTime), new SqlParameter("@Name", model.Name), new SqlParameter("@Url", model.Url), new SqlParameter("@Sort", model.Sort), new SqlParameter("@MenuLevel", model.MenuLevel), new SqlParameter("@ParentId", model.ParentId) }; return SqlHelper.ExecteNonQueryText(sqlStr, parameters) > 0; }
/// <summary> /// 添加 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Add(Aut_MenuModel model) { return _dataDemo.Add(model); }