zhengcaioa.git - Gitblit

			@@ -52,8 +52,69 @@
			updateproject.Modifier = entity.Modifier;
			updateproject.Modifytime = entity.Modifytime;
			updateproject.Mingcheng = entity.Mingcheng;
			updateproject.Renshu = entity.Renshu;
			updateproject.Renshu = entity.Renshu;
			updateproject.Hang = entity.Hang;
			updateproject.Lie = entity.Lie;
			updateproject.Fenzu = entity.Fenzu;
			updateproject.BannerId = entity.BannerId;

			}
			if(entity.Hang.HasValue && entity.Lie.HasValue)
			{
			var orderBanciZuoweis = _context.OrderBanciZuoweis.Where(x =>x.RecStatus == "A" && x.BanciId == entity.Id).ToList();



			for(int i=0;i< entity.Hang.Value; i++)
			{
			for (int j = 0; j < entity.Lie.Value; j++)
			{
			var orderBanciZuowei = orderBanciZuoweis.Where(x => x.RowNo == (i + 1) && x.ColNo == (j + 1)).FirstOrDefault();
			if(orderBanciZuowei == null)
			{
			var orderBanciZuoweisss = new OrderBanciZuowei();
			orderBanciZuoweisss.Id = Guid.NewGuid().ToString();
			orderBanciZuoweisss.BanciId = entity.Id;
			orderBanciZuoweisss.ZuoweiId = (i + 1)+"-"+ (j + 1);
			orderBanciZuoweisss.SeatNo = (i + 1) + "-" + (j + 1) + "座";
			orderBanciZuoweisss.Status = "0";
			orderBanciZuoweisss.RowNo = (i+1);
			orderBanciZuoweisss.ColNo = (j+1);
			orderBanciZuoweisss.RecStatus = "A";
			orderBanciZuoweisss.Creater = string.IsNullOrEmpty(entity.Creater)? entity.Modifier : entity.Creater;
			orderBanciZuoweisss.Createtime = DateTime.Now;
			orderBanciZuoweisss.Modifier = orderBanciZuoweisss.Creater;
			orderBanciZuoweisss.Modifytime = orderBanciZuoweisss.Createtime;
			_context.OrderBanciZuoweis.Add(orderBanciZuoweisss);
			}
			}
			}

			//删除多余的座位
			var orderBanciZuoweisdel = orderBanciZuoweis.Where(x => x.RowNo > entity.Hang.Value \|\| x.ColNo > entity.Lie.Value).ToList();
			if (orderBanciZuoweisdel != null && orderBanciZuoweisdel.Count > 0)
			{
			foreach (var orderBanciZuowei in orderBanciZuoweisdel)
			{
			orderBanciZuowei.RecStatus = "D";
			}
			}


			}
			else
			{
			//如果没有座位就删除所有座位
			var orderBanciZuoweis = _context.OrderBanciZuoweis.Where(x => x.RecStatus == "A" && x.BanciId == entity.Id).ToList();
			if(orderBanciZuoweis!=null && orderBanciZuoweis.Count > 0)
			{
			foreach ( var orderBanciZuowei in orderBanciZuoweis)
			{
			orderBanciZuowei.RecStatus = "D";
			}
			}
			}


			_context.SaveChanges();
			resultEntity.ReturnID = entity.Id;
			@@ -77,6 +138,19 @@
			{
			entity = new OrderBanci();
			}

			var result = _mapper.Map<OrderBanciDTO>(entity);


			return result;
			}

			public OrderBanciDTO GetAll(string id)
			{

			var entity = _context.OrderBancis.Find(id);



			var result = _mapper.Map<OrderBanciDTO>(entity);

			@@ -121,7 +195,7 @@
			string[] Shijians = searchEntity.Shijian.Split("\|");
			DateTime.TryParse(Shijians[0], out Shijianstart);
			DateTime.TryParse(Shijians[1], out Shijianend);
			//Shijianend = Shijianend.AddDays(1);
			Shijianend = Shijianend.AddDays(1);
			}

			var query = (from a in _context.OrderBancis
			@@ -153,6 +227,14 @@
			Mingcheng = a.Mingcheng,

			Renshu = a.Renshu??0,

			Hang = a.Hang ?? 0,

			Lie = a.Lie ?? 0,


			Fenzu = a.Fenzu,
			BannerId = a.BannerId??0,


			Creater = a.Creater,
			@@ -217,5 +299,202 @@
			var list = _mapper.Map<List<OrderBanciDTO>>(listRole);
			return list;
			}



			public List<OrderBanciDTO> GetJifenBanciList()
			{



			ResultDataEntity<OrderBanciDTO> data = new ResultDataEntity<OrderBanciDTO>();
			List<OrderBanciDTO> list = new List<OrderBanciDTO>();



			var listCode = (from a in _context.SysCodeDtls
			join b in _context.SysCodes
			on a.CodeId equals b.Id
			where a.RecStatus == "A"
			&& b.RecStatus == "A"
			select new CodeDataEntity()
			{
			CodeId = b.Id,
			CodeTable = b.CodeTable,
			CodeField = b.CodeField,
			CodeSn = a.CodeSn,
			Comments = a.Comments,
			Contents = a.Contents,
			RecStatus = a.RecStatus,
			Sort = a.Sort
			}
			);

			///OrderBancis
			///


			var query = (from a in _context.OrderBancis
			join b in _context.OrderBanciDtls on a.Id equals b.OrderBanciId

			join d in listCode.Where(x => x.CodeTable == "order_banci_order" && x.CodeField == "kechengleixing_id")
			on b.Shangxiawu equals d.CodeSn
			into dzsssss
			from dzzzzz in dzsssss.DefaultIfEmpty()

			where a.RecStatus == "A" && b.RecStatus == "A" && b.Jifen != null
			&& a.Shijianend >= DateTime.Now






			select new OrderBanciDTO
			{
			img_url ="",
			point = b.Jifen,
			sell_price = b.Jiage,
			type = "Train",
			title = a.Mingcheng+"("+ dzzzzz.Comments+")",
			Id = a.Id,
			Banci = a.Banci,
			Mingcheng = a.Mingcheng,
			Shijian = a.Shijian,
			ShijianName = a.Shijian.HasValue ? a.Shijian.Value.ToString("yyyy-MM-dd HH:mm") : "",

			Shijianend = a.Shijianend,
			ShijianendName = a.Shijianend.HasValue ? a.Shijianend.Value.ToString("yyyy-MM-dd HH:mm") : "",

			Didian = a.Didian,

			Renshu = a.Renshu ?? 0,
			Hang = a.Hang ?? 0,
			Lie = a.Lie ?? 0,

			Fenzu = a.Fenzu,
			BannerId = a.BannerId ?? 0,

			Creater = a.Creater,
			Createtime = a.Createtime,

			RecStatus = a.RecStatus,
			Modifier = a.Modifier,
			Modifytime = a.Modifytime,


			Shangxiawu = b.Shangxiawu,
			Shijiandtl = b.Shijian,
			Shixiamg = b.Shixiamg,
			Zhujiangren = b.Zhujiangren,
			Sort = b.Sort,
			ShangxiawuName = dzzzzz.Comments,
			Jiage = b.Jiage,
			Jifen = b.Jifen,
			JiageName = b.Jiage.HasValue ? b.Jiage.Value.ToString() : "",
			JifenName = b.Jifen.HasValue ? b.Jifen.Value.ToString() : "",
			id = a.Id,

			}
			).OrderByDescending(x => x.Shijian).ThenBy(x=>x.Sort).ToList();



			return query;
			}


			public ResultEntity saveZuowei(OrderBanciZuoweiDTO dto)
			{
			ResultEntity resultEntity = new ResultEntity();
			try
			{


			var entity = _mapper.Map<OrderBanciZuowei>(dto);


			if (String.IsNullOrEmpty(entity.Id))
			{
			entity.Id = Guid.NewGuid().ToString();
			dto.Id = entity.Id;
			_context.OrderBanciZuoweis.Add(entity);
			}
			else
			{
			var updateproject = _context.OrderBanciZuoweis.Find(entity.Id);

			updateproject.BanciId = entity.BanciId;
			updateproject.ZuoweiId = entity.ZuoweiId;

			updateproject.SeatNo = entity.SeatNo;
			updateproject.Status = entity.Status;

			updateproject.RowNo = entity.RowNo;
			updateproject.ColNo = entity.ColNo;

			updateproject.RecStatus = entity.RecStatus;
			updateproject.Modifier = entity.Modifier;
			updateproject.Modifytime = entity.Modifytime;

			}

			_context.SaveChanges();
			resultEntity.ReturnID = entity.Id;
			resultEntity.Result = true;
			}
			catch (Exception ex)
			{
			resultEntity.Result = false;
			resultEntity.Message = "保存失败，请联系管理员";

			}
			return resultEntity;
			}

			public List<OrderBanciZuoweiDTO> GetOrderBanciZuoweiList(string banciId)
			{
			var listRole = _context.OrderBanciZuoweis.Where(r => r.RecStatus == "A" && r.BanciId == banciId).OrderBy(x=>x.RowNo).ThenBy(x=>x.ColNo).ToList();


			var list = _mapper.Map<List<OrderBanciZuoweiDTO>>(listRole);

			return list;
			}




			public List<OrderBanci> GetDangQianBanciList(string id)
			{




			List<OrderBanci> list = new List<OrderBanci>();


			try
			{
			var orderBanci = _context.OrderBancis.Find(id);
			if (orderBanci != null)
			{
			list = _context.OrderBancis.Where(x => x.RecStatus == "A" && x.Fenzu == orderBanci.Fenzu).OrderBy(x => x.Shijian).ToList();
			}

			}
			catch (Exception ex)
			{


			}






			return list;
			}
			}
			}