123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213 |
- using AutoMapper;
- using OASystem.Domain;
- using OASystem.Domain.Dtos.Groups;
- using OASystem.Domain.Entities.Groups;
- using OASystem.Domain.ViewModels.Groups;
- using SqlSugar;
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Text;
- using System.Threading.Tasks;
- namespace OASystem.Infrastructure.Repositories.Groups
- {
- public class HotelPriceRepository : BaseRepository<Grp_HotelReservations, Grp_HotelReservations>
- {
- private readonly IMapper _mapper;
- public HotelPriceRepository(SqlSugarClient sqlSugar, IMapper mapper) :
- base(sqlSugar)
- {
- this._mapper = mapper;
- }
- public async Task<Result> HotelReservationsByDiId(HotelReservationsByDiIdDto dto)
- {
- Result result = new Result() { Code = -2, Msg = "未知错误" };
- try
- {
- string UserId = "";
- List<Grp_GroupsTaskAssignment> gtaUIdList = _sqlSugar.Queryable<Grp_GroupsTaskAssignment>().Where(a => a.DIId == dto.DiId && a.IsDel == 0 && a.CTId == 76).ToList();
- foreach (Grp_GroupsTaskAssignment gta in gtaUIdList)
- UserId += gta.UId + ",";
- if (!string.IsNullOrWhiteSpace(UserId))
- {
- UserId = UserId.Substring(0, UserId.Length - 1);
- }
- else
- {
- UserId = "0";
- }
- string sqlWhere = string.Format(@"Where h.DiId={0} and h.IsDel={1} And h.CreateUserId in ({2})", dto.DiId, 0,UserId);
-
- int startIndex = (dto.PageIndex - 1) * dto.PageSize + 1;
- int endIndex = startIndex + dto.PageSize - 1;
- if (dto.PortType == 1)
- {
- string sql = string.Format(@"select h.Id,s1.Name as GuestType,h.ReservationsNo,h.HotelName,h.CheckInDate,
- h.CheckOutDate,c.PayMoney,s.Name as PaymentCurrency,u.CnName as CreateUserName,c.IsAuditGM,h.CreateTime,h.Attachment
- From Grp_HotelReservations h
- Join Grp_CreditCardPayment c on h.Id=c.CId and c.CTable=76 and c.IsDel=0
- left Join Sys_SetData s on c.PaymentCurrency=s.Id and s.IsDel=0
- left Join Sys_SetData s1 on h.GTId=s1.Id and s1.IsDel=0
- left Join Sys_Users u on u.Id=h.CreateUserId and u.isdel=0 {0}", sqlWhere);
- List<HotelReservationsByDiIdView> hotelDataList = _sqlSugar.SqlQueryable<HotelReservationsByDiIdView>(sql).ToList();
- foreach (var item in hotelDataList)
- {
- if (item.IsAuditGM == 0) item.IsAuditGMStr = "未审核";
- else if (item.IsAuditGM == 1) item.IsAuditGMStr = "已通过";
- else if (item.IsAuditGM == 2) item.IsAuditGMStr = "未通过";
- else if (item.IsAuditGM == 3) item.IsAuditGMStr = "自动审核";
- }
- return result = new Result() { Code = 0, Msg = "查询成功!", Data = hotelDataList };
- }
- else if (dto.PortType == 2 || dto.PortType == 3)
- {
- string sql = string.Format(@"Select * From (
- Select row_number() over (order by h.Id Desc) as RowNumber,h.Id,s1.Name as GuestType,h.ReservationsNo,h.HotelName,h.CheckInDate,
- h.CheckOutDate,c.PayMoney,s.Name as PaymentCurrency,u.CnName as CreateUserName,c.IsAuditGM,h.CreateTime,h.Attachment
- From Grp_HotelReservations h
- Join Grp_CreditCardPayment c on h.Id=c.CId and c.CTable=76 and c.IsDel=0
- left Join Sys_SetData s on c.PaymentCurrency=s.Id and s.IsDel=0
- left Join Sys_SetData s1 on h.GTId=s1.Id and s1.IsDel=0
- left Join Sys_Users u on u.Id=h.CreateUserId and u.isdel=0 {0}
- ) temp Where RowNumber Between {1} and {2}", sqlWhere, startIndex, endIndex);
- List<HotelReservationsByDiIdView> hotelDataList = _sqlSugar.SqlQueryable<HotelReservationsByDiIdView>(sql).ToList();
- foreach (var item in hotelDataList)
- {
- if (item.IsAuditGM == 0) item.IsAuditGMStr = "未审核";
- else if (item.IsAuditGM == 1) item.IsAuditGMStr = "已通过";
- else if (item.IsAuditGM == 2) item.IsAuditGMStr = "未通过";
- else if (item.IsAuditGM == 3) item.IsAuditGMStr = "自动审核";
- }
- string CountSql = string.Format(@"Select COUNT(1) as Count From (
- Select h.Id,s1.Name as GuestType,h.ReservationsNo,h.HotelName,h.CheckInDate,
- h.CheckOutDate,c.PayMoney,s.Name as PaymentCurrency,u.CnName as CreateUserName,c.IsAuditGM,h.CreateTime,h.Attachment
- From Grp_HotelReservations h
- Join Grp_CreditCardPayment c on h.Id=c.CId and c.CTable=76 and c.IsDel=0
- left Join Sys_SetData s on c.PaymentCurrency=s.Id and s.IsDel=0
- left Join Sys_SetData s1 on h.GTId=s1.Id and s1.IsDel=0
- left Join Sys_Users u on u.Id=h.CreateUserId and u.isdel=0 {0}
- ) temp", sqlWhere);
- DataCount dataCount = _sqlSugar.SqlQueryable<DataCount>(CountSql).First();
-
- int count = dataCount.Count;
- float totalPage = (float)count / dto.PageSize;//总页数
- if (totalPage == 0) totalPage = 1;
- else totalPage = (int)Math.Ceiling((double)totalPage);
- ListViewBase<HotelReservationsByDiIdView> rst = new ListViewBase<HotelReservationsByDiIdView>();
- rst.DataList = hotelDataList;
- rst.DataCount = count;
- rst.CurrPageIndex = dto.PageIndex;
- rst.CurrPageSize = dto.PageSize;
- return result = new Result() { Code = 0, Msg = "查询成功!", Data = rst };
-
- }
- else
- {
- return result = new Result() { Code = -2, Msg = "请传入PortType参数,1 Web 2 Android 3 IOS" };
- }
- }
- catch (Exception ex)
- {
- return result = new Result() { Code = -2, Msg = "未知错误" };
- throw;
- }
- }
- public async Task<Result> HotelReservationsById(HotelReservationsByIdDto dto)
- {
- Result result = new Result() { Code = -2, Msg = "未知错误" };
- try
- {
- Grp_HotelReservations hotelReservationsById = _sqlSugar.Queryable<Grp_HotelReservations>().First(a => a.IsDel == 0 && a.Id == dto.Id);
- HotelReservationsByIdView _hotelReservations = _mapper.Map<HotelReservationsByIdView>(hotelReservationsById);
- Grp_CreditCardPayment _CreditCardPayment = _sqlSugar.Queryable<Grp_CreditCardPayment>().First(a => a.CId == dto.Id && a.IsDel == 0 && a.CTable == 76);
- var data = new
- {
- hotelReservations = _hotelReservations,
- creditCardPayment = _CreditCardPayment,
- };
- return result = new Result() { Code = 0, Msg = "查询成功",Data= data };
- }
- catch (Exception ex)
- {
- return result = new Result() { Code = -2, Msg = "未知错误" };
- throw;
- }
- }
- public async Task<Result> HotelReservationsInitialize(HotelReservationsDto dto)
- {
- Result result = new Result() { Code = -2, Msg = "未知错误" };
- try
- {
- List<Grp_GroupsTaskAssignment> grp_GroupsTaskAssignment = Query<Grp_GroupsTaskAssignment>(a => a.IsDel == 0 && a.UId == dto.UserId && a.CTId == 76).ToList();
- string DiId = "0";
- foreach (var item in grp_GroupsTaskAssignment)
- {
- DiId += item.DIId + ",";
- }
- if (DiId != "0")
- {
- DiId = DiId.Substring(0, DiId.Length - 1);
- }
- string sql = string.Format(@"select * from Grp_DelegationInfo where Id in({0}) and IsDel={1}", DiId, 0);
- //团组下拉框
- List<Grp_DelegationInfo> Delegations = _sqlSugar.SqlQueryable<Grp_DelegationInfo>(sql).ToList();
- List<ShareGroupInfoIIView> grp_Delegations = _mapper.Map<List<ShareGroupInfoIIView>>(Delegations);
- for (int i = 0;i< grp_Delegations.Count; i++)
- {
- grp_Delegations[i].VisitDate = Delegations[i].VisitStartDate.ToString("yyyy-MM-dd")+"至"+ Delegations[i].VisitEndDate.ToString("yyyy-MM-dd");
- }
- //客人类型
- List<Sys_SetData> GuestType = _sqlSugar.Queryable<Sys_SetData>().Where(a=>a.IsDel==0 && a.STid==11).ToList();
- List<SetDataInfoView> _GuestType = _mapper.Map<List<SetDataInfoView>>(GuestType);
- //支付方式
- List<Sys_SetData> Payment = _sqlSugar.Queryable<Sys_SetData>().Where(a => a.STid == 14 && a.IsDel == 0).ToList();
- List<SetDataInfoView> _Payment = _mapper.Map<List<SetDataInfoView>>(Payment);
- //币种
- List<Sys_SetData> CurrencyList = _sqlSugar.Queryable<Sys_SetData>().Where(a => a.STid == 66 && a.IsDel == 0).ToList();
- List<SetDataInfoView> _CurrencyList = _mapper.Map<List<SetDataInfoView>>(CurrencyList);
- //卡类型
- List<Sys_SetData> BankCard = _sqlSugar.Queryable<Sys_SetData>().Where(a => a.STid == 15 && a.IsDel == 0).ToList();
- List<SetDataInfoView> _BankCard = _mapper.Map<List<SetDataInfoView>>(BankCard);
- //预订网站
- List<Sys_SetData> BookingWebsite = _sqlSugar.Queryable<Sys_SetData>().Where(a => a.STid == 12 && a.IsDel == 0).ToList();
- List<SetDataInfoView> _BookingWebsite = _mapper.Map<List<SetDataInfoView>>(BookingWebsite);
- var data = new
- {
- Delegations = grp_Delegations,
- GuestType = _GuestType,
- Payment = _Payment,
- CurrencyList = _CurrencyList,
- BankCard = _BankCard,
- BookingWebsite = _BookingWebsite,
- };
- return result = new Result() { Code = 0, Msg = "查询成功",Data=data };
- }
- catch (Exception ex)
- {
- return result = new Result() { Code = -2, Msg = "未知错误" };
- throw;
- }
- }
- public Task<Result> OpHotelReservations(OpHotelReservationsData dto)
- {
- throw new NotImplementedException();
- }
- }
- }
|