private void ImportOderClick() { string OrderListPath = @"Order/order_2020_05_16_09_52_57.csv"; string MemberListPath = @"MemberList/方氏果乾會員.csv"; #if (DEBUG) OrderListPath = Path.Combine(PathFunction.GetExecuteLevelPath(System.Environment.CurrentDirectory, 2), @"DummyFile\order_2020_05_16_09_52_57.csv"); MemberListPath = Path.Combine(PathFunction.GetExecuteLevelPath(System.Environment.CurrentDirectory, 2), @"DummyFile\mm.csv"); #endif FileProcessing.CsvTrans2Json <BaseTitle>(OrderListPath, out loadOrderViewList); FileProcessing.CsvTrans2Json <MemberListTitle>(MemberListPath, out List <MemberListTitle> MemberList); OrderViewList.Clear(); //整理格式 loadOrderViewList.ForEach(Order => { MemberList.ForEach(s => { if (Order.CustomerName == s.RealName && Order.CustomerEmail == s.Email) { Order.Membership = "V"; } }); Order.OwnerName = "方氏果乾"; Order.OwnerNumber = "F00001"; if (Order.DateCreate != null) { CultureInfo CultureInfoDateCulture = new CultureInfo("ja-JP"); //日期文化格式 DateTime d = DateTime.ParseExact(Order.DateCreate, "yyyy-MM-dd hh:mm:ss", CultureInfoDateCulture); Order.DateCreate = d.ToString("yyyy/MM/dd"); } }); //篩選統計欄位 for (int i = 0; i < loadOrderViewList.Count; i++) { bool IsValidOrderNumber = true; loadOrderViewList[i].OrderNumber.ToList().ForEach(ch => { if (!char.IsDigit(ch) && !char.IsLetter(ch))//是否为数字//是否为字母 { IsValidOrderNumber = false; } }); if (!IsValidOrderNumber) { loadOrderViewList.Remove(loadOrderViewList[i]); i--; } else { OrderViewList.Add(new OrderView(loadOrderViewList[i])); } } }