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