最近在寫樞紐分析表查詢，先筆記一下，比較常用的是固定的寫法如下： public class HomeController : Controller { public List<Report> reports = new List<Report>() { new Report("001","案件1","E1","張三"), new Report("001","案件1","E1","張三"), new Report("001","案件1","E2","李四"), new Report("001","案件1","E3","李五"), new Report("002","案件2","E1","張三"), new Report("002","案件2","E1","張三"), new Report("003","案件3","E3","李五"), new Report("003","案件3","E3","李五"), }; public ActionResult LinqToPivotDemo() { #region 固定樞紐分析表 var staticPivot = reports.
在實務上在這記錄一些比較常用的LINQ使用的操作 public class Program { public static List<Student> students = new List<Student> { new Student{Id = "1",Name = "張三",Age = 25, Score = 90,ClassId = "101"}, new Student{Id = "2",Name = "兆四",Age = 33, Score = 70, ClassId = "101"}, new Student{Id = "3",Name = "兆四",Age =33, Score = 77,ClassId = "102"}, new Student{Id = "4",Name = "張三",Age = 25, Score = 65,ClassId = "102"}, new Student{Id = "5",Name = "張三",Age = 27, Score = 72,ClassId = "103"}, new Student{Id = "6",Name = "李六",Age = 28, Score = 66,ClassId = "103"}, }; public static List<StudentClass> studentClass = new List<StudentClass> { new StudentClass{ClassId = "101",ClassName = "一年一班" ,}, new StudentClass{ClassId = "102",ClassName = "一年二班"}, new StudentClass{ClassId = "103",ClassName = "一年三班"}, new StudentClass{ClassId = "104",ClassName = "一年四班"}, }; private static void Main(string[] args) { //找到第一位名叫張三的學生 var qryData1 = students.
最近想記錄一下繁體轉換簡體，是因為網站或是在寫blog的時候，未來會加入簡體版，這樣內容就可以迅速轉成簡體版狀況。 先到nuget,安裝CHTCHSConv 在程式碼加入using Microsoft.International.Converters.TraditionalChineseToSimplifiedConverter; using Microsoft.International.Converters.TraditionalChineseToSimplifiedConverter; using System; namespace ConsoleApp1 { internal class Program { private static void Main(string[] args) { Console.