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));
}
