From 78b0883ddf8329fa8693d78b01e1e0a7f5b6972e Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期四, 14 十二月 2023 13:10:02 +0800
Subject: [PATCH] 班次分组和横幅ID
---
zhengcaioa/Services/OrderBanciService.cs | 285 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 282 insertions(+), 3 deletions(-)
diff --git a/zhengcaioa/Services/OrderBanciService.cs b/zhengcaioa/Services/OrderBanciService.cs
index ce15e69..241a18d 100644
--- a/zhengcaioa/Services/OrderBanciService.cs
+++ b/zhengcaioa/Services/OrderBanciService.cs
@@ -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
@@ -154,6 +228,14 @@
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,
@@ -167,7 +249,7 @@
- if (searchEntity.totalrows == 0)
+ //if (searchEntity.totalrows == 0)
searchEntity.totalrows = query.Count();
var lianlist = query.Skip((searchEntity.page - 1) * searchEntity.rows).Take(searchEntity.rows).ToList();
data.LoadData(searchEntity, lianlist);
@@ -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;
+ }
}
}
--
Gitblit v1.9.1