public static List<Export> Get_Export(VolunteersModel datas) { /*-------------------匯出宣告-------------------*/ s26webDataContext db = new s26webDataContext(); Export export = new Export(); List<Export> exp = new List<Export>(); List<string> bir = new List<string> { "", "", "" }; var newdata = datas.Get().OrderByDescending(o => o.Id); /*-------------------匯出宣告End-------------------*/ foreach (var d in newdata) { export.Phone = d.Mobile; export.Name = d.Name; //export.BabyBirthday = d.BabyBirthday.Value.Date.ToString(); if (d.NowBrand == 1) export.NowBrand = "懷孕中"; else if (d.NowBrand == 2) export.NowBrand = "使用S-26產品"; else if (d.NowBrand == 3) export.NowBrand = "全母乳餵哺"; else if (d.NowBrand == 4) export.NowBrand = "其他"; export.BrandName = d.BrandName; export.Email = d.Email; if (d.Status == 1) export.Status = "審核中"; else if (d.Status == 2) export.Status = "通過"; else if (d.Status == 3) export.Status = "未通過"; export.FBConnect = d.FBConnect ? "是" : "否"; export.FBFriend = d.FBFriend ? "是" : "否"; export.CreateTime = d.CreateTime.AddHours(8).ToString("yyyy/MM/dd HH:mm"); export.UpdateTime = d.UpdateTime.AddHours(8).ToString("yyyy/MM/dd HH:mm"); export.Memo = d.Memo; export.FailReason = d.FailReason; exp.Add(export); export = new Export(); } db.Connection.Close(); return exp; }