public ActionResult questionMomBaby() { MemberSearchModle memberSearch = new MemberSearchModle(); List <SEMemberMoudle> member = SEMemberHelper.GetData(memberSearch); List <SEBabyMoudle> baby = SEBabyHelper.GetData(); List <MBMoudle> data = (from M in member join B in baby on M.strMemberID equals B.strMemberID where B.strBabyName != "" select new MBMoudle { momoName = M.strName, babyName = B.strBabyName }).ToList(); return(View(data)); }
public ActionResult questionStrCity() { MemberSearchModle search = new MemberSearchModle(); List <SEMemberMoudle> Data = SEMemberHelper.GetData(search); Data = (from S in Data select new SEMemberMoudle { strCity = S.strCity }).ToList(); var comparer = new IgnoreCaseSensitive(); //可以先把資料倒出來到List Data = Data.Distinct(comparer).ToList(); return(View(Data)); }
public ActionResult MemberList(MemberSearchModle memberSearchModle, int?page) { try { logger.Info("進入首頁,接到參數strName={0}, strContactID = {1}, strMobile = {2}, strPhone = {3}, strEMail = {4}", memberSearchModle.strName, memberSearchModle.strContactID, memberSearchModle.strMobile, memberSearchModle.strPhone, memberSearchModle.strEMail); List <SEMemberMoudle> Data = SEMemberHelper.GetData(memberSearchModle); int currentPageIndex = page.HasValue ? page.Value - 1 : 0; int pageSize = 20; ViewBag.currentPage = currentPageIndex + 1; ViewBag.CommentPage = pageSize; return(View(Data.ToPagedList(currentPageIndex, pageSize))); // return View(Data); } catch (Exception e) { logger.Error("{0 {1}", MethodInfo.GetCurrentMethod().Name, e.Message); throw e; } }
//end comparer public ActionResult getMemberCity(string city, int?page) { try { MemberSearchModle search = new MemberSearchModle(); List <SEMemberMoudle> Data = SEMemberHelper.GetData(search); Data = (from d in Data where d.strCity == (city ?? "") orderby d.dtmBirth ascending select new SEMemberMoudle { strCity = d.strCity, strName = d.strName, dtmBirth = d.dtmBirth }).ToList(); /*Data = Data.Where(x => x.strCity == (city ?? "")) * .OrderByDescending(x => x.dtmBirth) * .Select(x => new SEMemberMoudle * { strCity = x.strCity, * strName = x.strName, * dtmBirth = x.dtmBirth * }) * .ToList();*/ int currentPageIndex = page.HasValue ? page.Value - 1 : 0; int pageSize = 20; ViewBag.currentPage = currentPageIndex + 1; ViewBag.CommentPage = pageSize; return(View(Data.ToPagedList(currentPageIndex, pageSize))); // return View(Data); } catch (Exception e) { logger.Error("{0 {1}", MethodInfo.GetCurrentMethod().Name, e.Message); throw e; } }
public ActionResult Export(MemberSearchModle search) { List <SEMemberMoudle> Data = SEMemberHelper.GetData(search); MemoryStream ms = new MemoryStream(); try { //創建Excel文件 NPOI.HSSF.UserModel.HSSFWorkbook book = new NPOI.HSSF.UserModel.HSSFWorkbook(); //添加一個sheet NPOI.SS.UserModel.ISheet sheet1 = book.CreateSheet("Sheet1"); //序號 客戶代碼 會籍 會員姓名 手機號碼 市話號碼 E-mail 重寄驗證信 //給Sheet1添加第一行的表頭 NPOI.SS.UserModel.IRow row1 = sheet1.CreateRow(0); row1.CreateCell(0).SetCellValue("序號"); row1.CreateCell(1).SetCellValue("客戶代碼"); row1.CreateCell(2).SetCellValue("會籍"); row1.CreateCell(3).SetCellValue("會員姓名"); row1.CreateCell(4).SetCellValue("手機號碼"); row1.CreateCell(5).SetCellValue("市話號碼"); row1.CreateCell(6).SetCellValue(" E-mail信箱"); row1.CreateCell(7).SetCellValue("重寄驗證信"); //將Data逐步寫入sheet1各欄 for (int i = 0; i < Data.Count; i++) { NPOI.SS.UserModel.IRow rowtemp = sheet1.CreateRow(i + 1); rowtemp.CreateCell(0).SetCellValue(Data[i].ROWID.ToString()); rowtemp.CreateCell(1).SetCellValue(Data[i].strContactID.ToString()); rowtemp.CreateCell(2).SetCellValue(Data[i].strMemberTypeName.ToString()); rowtemp.CreateCell(3).SetCellValue(Data[i].strName.ToString()); rowtemp.CreateCell(4).SetCellValue(Data[i].strMobile.ToString()); rowtemp.CreateCell(5).SetCellValue(Data[i].strPhone.ToString()); rowtemp.CreateCell(6).SetCellValue(Data[i].strEMail.ToString()); rowtemp.CreateCell(7).SetCellValue((Data[i].ysnActivate.ToString() != "False" ? "" : "重寄驗證信")); } sheet1.AutoSizeColumn(0); sheet1.AutoSizeColumn(1); sheet1.AutoSizeColumn(2); sheet1.AutoSizeColumn(3); sheet1.AutoSizeColumn(4); sheet1.AutoSizeColumn(5); sheet1.AutoSizeColumn(6); sheet1.AutoSizeColumn(7); using (FileStream fileStream = new FileStream(@"c:\test.xls", FileMode.Create, FileAccess.Write)) { book.Write(fileStream); fileStream.Close(); } return(Json(new { status = "True" })); } catch (Exception e) { Console.WriteLine(e.ToString()); return(Json(new { status = "False" })); } }