private void PreLoadFTData() { var hotelId = UserContext.CurrentUser.HotelId; if (!_ft_isLoaded) { _ft_isLoaded = true; _ft_rooms = RoomBll.GetListBy(hotelId); _ft_roomregs = RoomRegBll.GetListByHotelId(hotelId); _ft_members = MemberBll.GetList(hotelId); _ft_membersType = MemberTypeBll.GetList(hotelId); _ft_RoomRegGuestInfoCN = RoomRegGuestInfoCNBll.GetListByHotelId(hotelId); _ft_RoomRegGuestInfoEN = RoomRegGuestInfoENBll.GetListByHotelId(hotelId); _ft_MaterialLease = MaterialLeaseBll.GetListByHotel(hotelId); _ft_RoomType = RoomTypeBll.GetListByHotelId(hotelId); _ft_RoomYdRecord = RoomYdRecordBll.GetListByHotel(hotelId); _ft_GlobalFeeSet = GlobalFeeSetBll.GetByHotelId(hotelId); _ft_MaintainRoom = MaintainRoomBll.GetListByHotelId(hotelId); _ft_RoomSelfuse = RoomSelfBll.GetListByHotelId(hotelId); _ft_RoomYD = RoomYdBll.GetListByHotel(hotelId); _ft_RoomSet = RoomSetBll.GetBy(hotelId); if (_ft_RoomSet == null) { _ft_RoomSet = RoomSetBll.GetBy(0); } } }
public string GetMemberList(string searchName = "") { var list = MemberBll.GetList(searchName, UserContext.CurrentUser.HotelId); return(JsonConvert.SerializeObject(list)); }
/// <summary> /// 导出 /// </summary> /// <returns></returns> public JsonResult ToExcel() { var user = UserContext.CurrentUser; var list = MemberBll.GetList(user.HotelId); var tb = new DataTable(); tb.Columns.Add("会员卡号"); tb.Columns.Add("卡内码"); tb.Columns.Add("状态"); tb.Columns.Add("会员类型"); tb.Columns.Add("余额"); tb.Columns.Add("积分"); tb.Columns.Add("入住次数"); tb.Columns.Add("姓名"); tb.Columns.Add("性别"); tb.Columns.Add("生日"); tb.Columns.Add("手机号"); tb.Columns.Add("证件类型"); tb.Columns.Add("证件号码"); tb.Columns.Add("地址"); tb.Columns.Add("营销人员"); tb.Columns.Add("营销短信"); tb.Columns.Add("长期有效"); tb.Columns.Add("到期日期"); tb.Columns.Add("操作员"); tb.Columns.Add("发卡时间"); if (list != null && list.Count > 0) { foreach (var item in list) { tb.Rows.Add(new string[] { item.CardNO, item.CNM, item.StateName, item.MemberTypeName, item.Money.ToString(), item.Exp.ToString(), item.Times.ToString(), item.Name, item.Sex, item.Birth.ToShortDateString(), item.Tel, item.CertificateTypeName, item.CertificateTypeNO, item.Address, item.YxryName, (item.IsNotYxSms?"不接收":"接受"), (item.IsCqyx?"是":"否"), (item.IsCqyx?"":item.ExpireDate.ToShortDateString()), item.HandlerName, NIU.Forum.Common.TypeConvert.IntToDateTime(item.CDate).ToString("yyyy-MM-dd hh:mm:ss") }); } } var apiResult = new APIResult(); //try //{ ExcelHelper.ExportByWeb(tb, "会员信息表", "会员信息表.xls"); //} //catch (Exception ex) //{ // apiResult.Ret = -1; // apiResult.Msg = ex.Message; // if (!(ex is OperationExceptionFacade)) // LogFactory.GetLogger().Log(LogLevel.Error, ex); //} return(Json(apiResult)); }