20240927czx接口更新

chenzx

2024-09-27 ef9491453afcf20c321b1dade7a5d62629125c34

20240927czx接口更新

 .vs/PolicyControl/FileContentIndex/506cb465-50fc-4c42-8a62-e2608990606d.vsidx

Binary files differ

 .vs/PolicyControl/FileContentIndex/6d1cf153-70d8-43a0-9459-736519dde152.vsidx

Binary files differ

 .vs/PolicyControl/FileContentIndex/d186196d-ef53-4460-a0a1-31867a5567dc.vsidx

Binary files differ

 .vs/PolicyControl/FileContentIndex/f7563f6e-c917-499a-9650-72616de95474.vsidx

Binary files differ

 .vs/PolicyControl/FileContentIndex/fc96f90c-fc3e-48dc-867d-ee5fa92934c2.vsidx

Binary files differ

 GasolineBlend.DAL/ArticleDataDAL.cs

@@ -47,7 +47,7 @@
                    sql += $" and articletitle like '%{Keyword}%' ";
                }
                int offset = (PageNumber - 1) * PageSize;
                sql += $" LIMIT {PageSize} OFFSET {offset}";
                sql += $" ORDER BY pubtime DESC  LIMIT {PageSize} OFFSET {offset}";

                return connection.Query<ArticleDataPage>(sql).ToList();
            }
@@ -87,6 +87,7 @@
                {
                    sql += $" and articletitle like '%{Keyword}%' ";
                }
                sql += $" ORDER BY pubtime DESC ";
                int Count = connection.Query<int>(sql).FirstOrDefault();
                return Count;
            }