💕鸿蒙



2023年度挖坑浏览：

- [ ] 模仿禅道，简化功能，需求是符合小公司使用习惯
- [ ] 在线图片生成（除了生成图片，还生成C#生成图片的代码，场景是一些活动商品等海报图）
- [ ] 模仿sqlsugar的webfirst
- [ ] 私有网页收藏夹 （支持生成离线单Html页面）
- [ ] 小博客系统
- [ ] 论坛系统
- [ ] 


TODO 开坑备忘

Vscode插件备忘





**GitLens** 可以增强 VSCode 内置 Git 的功能。例如 commits 搜索，历史记录和显示的代码作者身份具体功能可以查看Feature list

**Git History**  - 显示提交历史记录的美丽图表等等

Vscode插件备忘



### http请求
```
function sendGetRequest(url, callback) {
  var xhr = new XMLHttpRequest();
  xhr.open("GET", url, true);
  xhr.onreadystatechange = function() {
    if (xhr.readyState === 4 && xhr.status === 200) {
      var response = JSON.parse(xhr.responseText);
      callback(response);
    }
  };
  xhr.send();
}

// 调用示例
sendGetRequest("https://api.example.com/data", function(response) {
  console.log(response);
});
```

😛 返璞归真，原生JS收集

😃封装一些常见的又是自己喜欢的方式，方便日后复制


### 分页封装

> 复杂等高级查询，参照sqlsugar官网的表格查询 ![0478E7B4.png](/static/img/e180f3dfafbc68d45842f9066fee0b95.0478E7B4.webp) [点我访问](https://www.donet5.com/home/doc?masterId=1&typeId=2314)


 - 比简单多一点的条件
 ```
 /// <summary>
    /// 获取分页数据
    /// </summary>
    /// <typeparam name="TEntity"></typeparam>
    /// <param name="exp"></param>
    /// <param name="lstWhereIF"></param>
    /// <returns></returns>
    public async Task<ResPageModel<TEntity>> GetPageDataAsync<TEntity>(Expression<Func<TEntity, bool>> exp,
        (bool isWhere, Expression<Func<TEntity, bool>> expression)[] lstWhereIF) where TEntity : class, new()
    {
        RefAsync<int> total = 0;
        RefAsync<int> totalPage = 0;
        int page = 1;
        int pageSize = 10;
        ISugarQueryable<TEntity> queryable =
            Db.Queryable<TEntity>().Where(exp);

        foreach (var whereIF in lstWhereIF)
        {
            queryable.WhereIF(whereIF.isWhere,whereIF.expression);
        }

        var pageData = await queryable.ToPageListAsync(page, pageSize, total, totalPage);
        return new ResPageModel<TEntity>
        {
            PageSize = pageSize,
            DataCount = total,
            PageCount = totalPage,
            Data = pageData
        };
    }
 ```

- 就一个简单的条件
```
 public async Task<ResPageDto<List<TData>>> PageDataAsync<TData>(ReqPageDto model, Expression<Func<TData, bool>>? whereExpression = null, Expression<Func<TData, object>>? orderExpression = null, OrderByType type = OrderByType.Asc) where TData : class
        {
            RefAsync<int> total = 0;
            RefAsync<int> totalPage = 0;
            List<TData>? pageInfo = await _db.Queryable<TData>()
                .WhereIF(whereExpression!=null, whereExpression)
                .OrderByIF(orderExpression!=null, orderExpression,type)
                .ToPageListAsync(model.PageNum, model.PageSize, total, totalPage);

            return new ResPageDto<List<TData>>
            {
                Data = pageInfo,
                PageNum = model.PageNum,
                PageSize = model.PageSize,
                Total = total,
                TotalPage = totalPage
            };
        }
```

 相关实体类
 
```
/// <summary>
/// 请求分页数据传输对象
/// </summary>
public class ReqPageDto
{
    /// <summary>
    /// 页码
    /// </summary>
    public int PageNum { get; set; }

    /// <summary>
    /// 每页大小
    /// </summary>
    public int PageSize { get; set; }
}

/// <summary>
/// 响应分页数据传输对象
/// </summary>
/// <typeparam name="TData">数据类型</typeparam>
public class ResPageDto<TData>
{
    /// <summary>
    /// 总页数
    /// </summary>
    public int TotalPage { get; set; }

    /// <summary>
    /// 总记录数
    /// </summary>
    public int Total { get; set; }

    /// <summary>
    /// 页码
    /// </summary>
    public int PageNum { get; set; }

    /// <summary>
    /// 每页大小
    /// </summary>
    public int PageSize { get; set; }

    /// <summary>
    /// 数据
    /// </summary>
    public TData Data { get; set; }
}
```