sqlsugar 正序倒序查询

lly_79

已于 2024-08-02 11:11:40 修改

阅读量186

点赞数 3

文章标签：开发语言 c# 后端 mvc

于 2024-08-02 10:54:58 首次发布

本文链接：https://blog.csdn.net/lly_79/article/details/140866404

版权

1.Model层

namespace SqlSugarORM.Models.Models_Ceshi
{
    [SugarTable("Train_table")]  // 数据库表名

    public class TrainList{
    
       [SugarColumn(ColumnName = "id", IsPrimaryKey = true)]
       public int id { get; set; }

       [SugarColumn(ColumnName = "trainDay")]
       public DateTime TrainDay { get; set; }


       [SugarColumn(ColumnName = "stuId")]
       public string StuId { get; set; }

         
       [SugarColumn(ColumnName = "stuName")]
       public string StuName { get; set; }

    }


}

2.servise层

namespace SqlSugarORM.Services.Services_Ceshi
{
    public class TrainListManager : Repository_Excel<TrainList>
    {
    }
}

3.控制层

 private TrainListManager _TrainListManager = new TrainListManager(); // 培训记录 

 public ActionResult GetTrainData(string dataType , string dataText)  //  培训记录 
  {
     List<TrainList> result = new List<TrainList>(); 

              if ( dataType  == "stuId")
              {
                  // 正序  
                  result = _TrainListManager.AsQueryable().Where(p => p.StuId == dataText).OrderBy(it => new { it.TrainDay }).ToList(); 
              }
              else
              {
                  // 倒叙 
                  result = _TrainListManager.AsQueryable().Where(p => p.StuName == dataText).OrderBy(it => new { it.StuName, trainDay = SqlFunc.Desc(it.TrainDay) }).ToList();
                  
              }

     return Json(Common.AjaxJsonResult(SuccessType.Success, "查询成功", result.ToJson()));

  }

参考：排序 OrderBy - SqlSugar 5x - .NET果糖网 (donet5.com)