/// <summary>
/// 历史入住搜索
/// </summary>
/// <param name="page"></param>
/// <param name="rows"></param>
/// <param name="key"></param>
/// <param name="value"></param>
/// <param name="type">GuestInfoCN,GuestInfoEN</param>
/// <returns></returns>
public string Search(int page, int rows, string key, string value, string type)
{
var hotelId = UserContext.CurrentUser.HotelId;
//倒推-->guest_info_cn.ID-->Room_Reg_Guest_Info_CN.GuestInfoID---->RoomReg
var datas = RoomRegBll.Page(page, rows, RoomRegBll.GetCommonSql(type, hotelId.ToString(), "GuestInfoId", value));
List <Model.RoomReg> items = new List <Model.RoomReg>();
if (datas != null && datas.Items != null)
{
if (type == nameof(GuestInfoCN))
{
GuestInfoCN info = GuestInfoCNBll.SingleOrDefault($" where Id = '{value}'");
foreach (var item in datas.Items)
{
item.Name = info.Name;
item.Sex = info.Sex;
item.CertificateTypeName = info.CertificateTypeName;
item.CertificateNO = info.CertificateNO;
items.Add(item);
}
}
else
{
GuestInfoEN info = GuestInfoENBll.SingleOrDefault($" where Id = '{value}'");
foreach (var item in datas.Items)
{
item.Name = info.FirstName + ' ' + info.LastName;
item.Sex = info.Sex;
item.CertificateTypeName = info.CertificateTypeName;
item.CertificateNO = info.CertificateNO;
items.Add(item);
}
}
}
return(JsonConvert.SerializeObject(new Pager <Model.RoomReg>()
{
total = datas.TotalItems, rows = items
}));
//if (type == nameof(GuestInfoCN))
//{
// var datas = GuestInfoCNRzRecordBll.Page(page, rows, $"where LskrId = {value} ");
// var pager = new Pager<Hotel.Model.GuestInfoCNRzRecord>() { total = datas.TotalItems, rows = datas.Items };
// return JsonConvert.SerializeObject(pager);
//}
//else
//{
// var datas = GuestInfoENRzRecordBll.Page(page, rows, $"where LskrId = {value} ");
// var pager = new Pager<Hotel.Model.GuestInfoENRzRecord>() { total = datas.TotalItems, rows = datas.Items };
// return JsonConvert.SerializeObject(pager);
//}
}