public string getdetailList(long id) { var models = PosConsumeDetailBll.GetList(id); models = models.Where(a => a.ToRoomRegId == 0).ToList(); return(JsonConvert.SerializeObject(models)); }
public ActionResult _PosPrintContent(long id) { var info = PosConsumeBll.GetById(id); var now = DateTime.Now; ViewBag.CurrentTime = now.ToString("yyyy-MM-dd HH:mm"); ViewBag.HotelId = UserContext.CurrentUser.HotelId; ViewBag.PosId = info.PosId; ViewBag.CurrentUserName = UserContext.CurrentUser.Name; var hotel = HotelBll.GetById(UserContext.CurrentUser.HotelId); if (hotel != null) { ViewBag.HotelName = hotel.Name; } var models = PosConsumeDetailBll.GetList(id); models = models.Where(a => a.ToRoomRegId == 0 && a.SourceRoomRegId == 0).ToList(); //没有入账房间 而且没有部分转入账房间 ViewBag.DetailPrice = models.Select(a => a.Price).Sum(); ViewBag.DetailDiscountPrice = models.Select(a => a.DiscountPrice).Sum(); ViewBag.DetailAmount = models.Select(a => a.Amount).Sum(); ViewBag.Detail = models; var pos = PosDefineBll.GetById(info.PosId); ViewBag.Pos = pos; ViewBag.PosName = pos.MenuName; return(View(info)); }
public string GetZZListForZzCancel(long id) { var models = PosConsumeDetailBll.GetList(id); models = models.Where(a => a.ToRoomRegId != 0).ToList(); models = models.Where(a => a.IsFree == false).ToList(); //非免单项目才显示在转账里面 return(JsonConvert.SerializeObject(models)); }
public string getEditPageDetailList(long id) { var info = PosConsumeBll.GetById(id); var models = PosConsumeDetailBll.GetList(id); models = models.Where(a => a.ToRoomRegId == 0 && a.SourceRoomRegId == 0).ToList(); //没有入账房间 而且没有部分转入账房间 return(JsonConvert.SerializeObject(models)); }
/// <summary> /// 房间财务里面显示的消费明细数据 /// </summary> /// <param name="id"></param> /// <returns></returns> public string GetDetailListForRoomDetail(long id, long roomRegId) { var models = PosConsumeDetailBll.GetList(id); models = models.Where(a => a.ToRoomRegId == roomRegId || a.SourceRoomRegId == roomRegId).ToList(); var info = PosConsumeBll.GetById(id); return(JsonConvert.SerializeObject(models)); }
public string GetListByIds(long[] Ids) { var data = PosConsumeBll.GetListByIds(Ids); var user = UserContext.CurrentUser; var payTypeList = PayTypeBll.GetList(user.HotelId, true, true); if (payTypeList == null) { payTypeList = new List <PayType>(); } var outdata = new List <Dictionary <string, object> >(); foreach (var item in data) { var outitem = new Dictionary <string, object>(); outitem["Id"] = item.Id; outitem["PosId"] = item.PosId; if (item.RoomRegId != 0) { var roomReg = RoomRegBll.GetById(item.RoomRegId); outitem["RoomNo"] = roomReg.RoomNO; outitem["RoomRegIdStr"] = item.RoomRegId.ToString(); outitem["RoomRegDanJuNum"] = roomReg.DanJuNum; } else { } var details = PosConsumeDetailBll.GetList(item.Id); var sk_list = PosConsumeSkBll.GetList(item.Id); var tk_list = PosConsumeTkBll.GetList(item.Id); decimal roomAmount = 0; if (item.RoomRegId == 0) { foreach (var detail in details) { if (!detail.IsFree && detail.ToRoomRegId != 0) { roomAmount += detail.Amount; } } outitem["RoomAmount"] = roomAmount; } else { outitem["RoomAmount"] = item.AmountSum; } foreach (var o in sk_list) { foreach (var payType in payTypeList) { if (o.PayTypeId == payType.Id) { var key = "Amount" + o.PayTypeName; if (!outitem.ContainsKey(key)) { outitem[key] = o.Money; } else { outitem[key] = Convert.ToDecimal(outitem[key]) + o.Money; } } } } outitem["NightDate"] = item.NightDate; outitem["OrderNo"] = item.OrderNo; outitem["OrderDate"] = item.OrderDate; outitem["OutTime"] = item.OutTime; outitem["Amount"] = item.Amount; outitem["JzskMoney"] = item.JzskMoney; outdata.Add(outitem); } return(JsonConvert.SerializeObject(outdata)); }
public string getZZDetailList(long id) { var models = PosConsumeDetailBll.GetZZDetailList(id); return(JsonConvert.SerializeObject(models)); }
public string GetJJList(long posId, string isToday, PosConsumeSearchInfo search) { var user = UserContext.CurrentUser; List <PosConsume> data = new List <PosConsume>(); if (search.hasValue()) { data = PosConsumeBll.GetListByPos(posId, search); } else if (isToday == "Y") { data = PosConsumeBll.GetTodayListByPos(posId); } else { data = PosConsumeBll.GetListByPos(posId); } data = data.Where(a => a.PosShiftId == 0 && a.CwState == 1).ToList(); var payTypeList = PayTypeBll.GetList(user.HotelId, true, true); if (payTypeList == null) { payTypeList = new List <PayType>(); } var outdata = new List <Dictionary <string, object> >(); foreach (var item in data) { var outitem = new Dictionary <string, object>(); outitem["Id"] = item.Id; outitem["PosId"] = item.PosId; if (item.RoomRegId != 0) { var roomReg = RoomRegBll.GetById(item.RoomRegId); outitem["RoomNo"] = roomReg.RoomNO; outitem["RoomRegIdStr"] = item.RoomRegId.ToString(); outitem["RoomRegDanJuNum"] = roomReg.DanJuNum; } else { } var details = PosConsumeDetailBll.GetList(item.Id); var sk_list = PosConsumeSkBll.GetList(item.Id); var tk_list = PosConsumeTkBll.GetList(item.Id); decimal roomAmount = 0; if (item.RoomRegId == 0) { foreach (var detail in details) { if (!detail.IsFree && detail.ToRoomRegId != 0) { roomAmount += detail.Amount; } } outitem["RoomAmount"] = roomAmount; } else { outitem["RoomAmount"] = item.AmountSum; } foreach (var o in sk_list) { foreach (var payType in payTypeList) { if (o.PayTypeId == payType.Id) { var key = "Amount" + o.PayTypeName; if (!outitem.ContainsKey(key)) { outitem[key] = o.Money; } else { outitem[key] = Convert.ToDecimal(outitem[key]) + o.Money; } } } } outitem["NightDate"] = item.NightDate; outitem["OrderNo"] = item.OrderNo; outitem["OrderDate"] = item.OrderDate; outitem["OutTime"] = item.OutTime; outitem["Amount"] = item.Amount; outitem["JzskMoney"] = item.JzskMoney; outdata.Add(outitem); } return(Newtonsoft.Json.JsonConvert.SerializeObject(outdata)); }
public string GetShiftHistoryList(long posId, PosConsumeSearchInfo search) { var shift_list = PosShiftBll.GetList(posId, search); var outdata = new List <Dictionary <string, object> >(); var user = UserContext.CurrentUser; var payTypeList = PayTypeBll.GetList(user.HotelId, true, true); if (payTypeList == null) { payTypeList = new List <PayType>(); } foreach (var item in shift_list) { var outitem = new Dictionary <string, object>(); outitem["Id"] = item.Id; outitem["PosId"] = item.PosId; outitem["DjNum"] = item.DjNum; outitem["ShiftId"] = item.ShiftId; outitem["ShiftName"] = ShiftBll.GetById(item.ShiftId).Name; outitem["NightDate"] = item.NightDate; List <PosConsume> data = PosConsumeBll.GetListByPosShift(item.Id); outitem["childrenIds"] = string.Join(",", data.Select(a => a.Id).Distinct().ToArray()); decimal roomAmount = 0; foreach (var consume in data) { var details = PosConsumeDetailBll.GetList(consume.Id); var sk_list = PosConsumeSkBll.GetList(consume.Id); if (consume.RoomRegId == 0) //计算转房间账 { foreach (var detail in details) { if (!detail.IsFree && detail.ToRoomRegId != 0) { roomAmount += detail.Amount; } } if (!outitem.ContainsKey("RoomAmount")) { outitem["RoomAmount"] = roomAmount; } else { outitem["RoomAmount"] = Convert.ToDecimal(outitem["RoomAmount"]) + roomAmount; } } else { if (!outitem.ContainsKey("RoomAmount")) { outitem["RoomAmount"] = consume.AmountSum; } else { outitem["RoomAmount"] = Convert.ToDecimal(outitem["RoomAmount"]) + consume.AmountSum; } } if (!outitem.ContainsKey("Amount")) { outitem["Amount"] = consume.AmountSum; } else { outitem["Amount"] = Convert.ToDecimal(outitem["Amount"]) + consume.AmountSum; } if (!outitem.ContainsKey("JzskMoney")) { outitem["JzskMoney"] = consume.JzskMoney; } else { outitem["JzskMoney"] = Convert.ToDecimal(outitem["JzskMoney"]) + consume.JzskMoney; } foreach (var o in sk_list) { foreach (var payType in payTypeList) { if (o.PayTypeId == payType.Id) { var key = "Amount" + o.PayTypeName; if (!outitem.ContainsKey(key)) { outitem[key] = o.Money; } else { outitem[key] = Convert.ToDecimal(outitem[key]) + o.Money; } } } } } outdata.Add(outitem); } return(Newtonsoft.Json.JsonConvert.SerializeObject(outdata)); }
public ActionResult _Jz(long consumeId, int jstype) { var user = UserContext.CurrentUser; var consume = PosConsumeBll.GetById(consumeId); var details_list = PosConsumeDetailBll.GetList(consumeId); details_list = details_list.Where(a => a.ToRoomRegId == 0 && a.SourceRoomRegId == 0).ToList(); ViewBag.WjsmxList = details_list; var roomRegId = consume.RoomRegId; var roomReg = new Model.RoomReg() { Id = consume.RoomRegId, HotelId = user.HotelId }; if (consume.RoomRegId != 0) { roomReg = RoomRegBll.GetById(consume.RoomRegId); if (roomReg == null) { roomReg = new Model.RoomReg() { Id = consume.RoomRegId, HotelId = user.HotelId } } ; } if (roomReg.CustomerType == 2) { //如果是连房成员,则需要获取主房登记id var zf = RoomRegBll.GetById(roomReg.ZfDjId); if (zf.CustomerType == 3) { //主房如果是酒店会员 var member = MemberBll.GetById(long.Parse(zf.MemCompId)); if (member == null) { member = new Member(); } ViewBag.CustomerType = new CustomerTypeHelp { Type = 3, Data = JsonConvert.SerializeObject(member) }; } else if (zf.CustomerType == 4) { //主房如果是协议单位 var comAgree = AgreeCompanyBll.GetById(zf.MemCompId); if (comAgree == null) { comAgree = new AgreeCompany(); } ViewBag.CustomerType = new CustomerTypeHelp { Type = 4, Data = JsonConvert.SerializeObject(comAgree) }; } else { ViewBag.CustomerType = new CustomerTypeHelp { Type = 1 }; } } else if (roomReg.CustomerType == 3) { //如果是酒店会员 var member = MemberBll.GetById(long.Parse(roomReg.MemCompId)); if (member == null) { member = new Member(); } ViewBag.CustomerType = new CustomerTypeHelp { Type = 3, Data = JsonConvert.SerializeObject(member) }; } else if (roomReg.CustomerType == 4) { //如果是协议单位 var comAgree = AgreeCompanyBll.GetById(roomReg.MemCompId); if (comAgree == null) { comAgree = new AgreeCompany(); } ViewBag.CustomerType = new CustomerTypeHelp { Type = 4, Data = JsonConvert.SerializeObject(comAgree) }; } else { ViewBag.CustomerType = new CustomerTypeHelp { Type = 1 }; } //获取支付方式列表 var payTypeList = PayTypeBll.GetList(user.HotelId, true, true); if (payTypeList == null) { payTypeList = new List <PayType>(); } var payList = new List <RoomRegZwPaytypeHelp>(); foreach (var item in payTypeList) { payList.Add(new RoomRegZwPaytypeHelp() { Id = item.Id.ToString(), PayId = item.Id.ToString(), PayName = item.Name, Money = 0, }); } ViewBag.PayList = payList; //获取卡类型 var cardTypeList = CardTypeBll.GetList(UserContext.CurrentUser.HotelId); ViewBag.CardTypeList = cardTypeList; //ViewBag.WjsmxList = wjsmxList; //获取信用卡预授权 var xykysqList = RoomRegXykBll.GetYsq(roomRegId); if (xykysqList == null || xykysqList.Count == 0) { xykysqList = new List <RoomRegXyk>(); } ViewBag.Xykysq = xykysqList; ViewBag.jstype = jstype; return(View(consume)); }