username@email.com
2021-08-27 7b9e068cfe4e295f9ee960457d848c631f0136c7
zhengcaioa/Services/AskService.cs
@@ -203,5 +203,571 @@
        }
        #endregion
        #region 用车申请
        public ResultEntity SaveAskCar(AdmAskCarDTO admAsk)
        {
            ResultEntity resultEntity = new ResultEntity();
            try
            {
                AdmAskCar ask = _mapper.Map<AdmAskCar>(admAsk);
                if (string.IsNullOrEmpty(admAsk.Id))
                {
                    ask.Id = Guid.NewGuid().ToString();
                    admAsk.Id = ask.Id;
                    _context.AdmAskCars.Add(ask);
                }
                else
                {
                    var entity = _context.AdmAskCars.Find(admAsk.Id);
                    entity.CarLaiyuan = admAsk.CarLaiyuan;
                    entity.Feiyong = admAsk.Feiyong;
                    entity.Remark = admAsk.Remark;
                    entity.ShenpiStatus = admAsk.ShenpiStatus;
                    entity.CreaterName = admAsk.CreaterName;
                    entity.Tittle = admAsk.Tittle;
                    entity.Modifier = admAsk.Modifier;
                    entity.Modifytime = DateTime.Now;
                }
                _context.SaveChanges();
                resultEntity.ReturnID = ask.Id;
                resultEntity.Result = true;
            }
            catch (Exception ex)
            {
                resultEntity.Result = false;
                resultEntity.Message = "保存失败,请联系管理员";
                ex.Message.ToString();
            }
            return resultEntity;
        }
        public AdmAskCarDTO GetAskCar(string Id)
        {
            var entity = _context.AdmAskCars.Where(e => e.RecStatus == "A" && e.Id == Id).FirstOrDefault();
            if (entity == null)
            {
                entity = new AdmAskCar();
            }
            var leaveDTO = _mapper.Map<AdmAskCarDTO>(entity);
            return leaveDTO;
        }
        #endregion
        #region 销售费用申请
        public ResultEntity SaveAskMarketingCost(AdmAskMarketingCostDTO admAsk)
        {
            ResultEntity resultEntity = new ResultEntity();
            try
            {
                AdmAskMarketingCost ask = _mapper.Map<AdmAskMarketingCost>(admAsk);
                if (string.IsNullOrEmpty(admAsk.Id))
                {
                    ask.Id = Guid.NewGuid().ToString();
                    admAsk.Id = ask.Id;
                    _context.AdmAskMarketingCosts.Add(ask);
                }
                else
                {
                    var entity = _context.AdmAskMarketingCosts.Find(admAsk.Id);
                    entity.Feiyong = admAsk.Feiyong;
                    entity.Remark = admAsk.Remark;
                    entity.ToUserId = admAsk.ToUserId;
                    entity.BreakPrecedentId = admAsk.BreakPrecedentId;
                    entity.ShenpiStatus = admAsk.ShenpiStatus;
                    entity.CreaterName = admAsk.CreaterName;
                    entity.Tittle = admAsk.Tittle;
                    entity.Modifier = admAsk.Modifier;
                    entity.Modifytime = DateTime.Now;
                }
                _context.SaveChanges();
                resultEntity.ReturnID = ask.Id;
                resultEntity.Result = true;
            }
            catch (Exception ex)
            {
                resultEntity.Result = false;
                resultEntity.Message = "保存失败,请联系管理员";
                ex.Message.ToString();
            }
            return resultEntity;
        }
        public AdmAskMarketingCostDTO GetAskMarketingCost(string Id)
        {
            var entity = _context.AdmAskMarketingCosts.Where(e => e.RecStatus == "A" && e.Id == Id).FirstOrDefault();
            if (entity == null)
            {
                entity = new AdmAskMarketingCost();
            }
            var leaveDTO = _mapper.Map<AdmAskMarketingCostDTO>(entity);
            return leaveDTO;
        }
        #endregion
        #region 优惠申请
        public ResultEntity SaveAskYouHui(AdmAskYouHuiDTO admAsk)
        {
            ResultEntity resultEntity = new ResultEntity();
            try
            {
                AdmAskYouHui ask = _mapper.Map<AdmAskYouHui>(admAsk);
                if (string.IsNullOrEmpty(admAsk.Id))
                {
                    ask.Id = Guid.NewGuid().ToString();
                    admAsk.Id = ask.Id;
                    _context.AdmAskYouHuis.Add(ask);
                }
                else
                {
                    var entity = _context.AdmAskYouHuis.Find(admAsk.Id);
                    entity.CustomerId = admAsk.CustomerId;
                    entity.OrderType = admAsk.OrderType;
                    entity.Youhuistandard = admAsk.Youhuistandard;
                    entity.YouHui = admAsk.YouHui;
                    entity.Remark = admAsk.Remark;
                    entity.ShenpiStatus = admAsk.ShenpiStatus;
                    entity.CreaterName = admAsk.CreaterName;
                    entity.Tittle = admAsk.Tittle;
                    entity.Modifier = admAsk.Modifier;
                    entity.Modifytime = DateTime.Now;
                }
                _context.SaveChanges();
                resultEntity.ReturnID = ask.Id;
                resultEntity.Result = true;
            }
            catch (Exception ex)
            {
                resultEntity.Result = false;
                resultEntity.Message = "保存失败,请联系管理员";
                ex.Message.ToString();
            }
            return resultEntity;
        }
        public AdmAskYouHuiDTO GetAskYouHui(string Id)
        {
            var entity = _context.AdmAskYouHuis.Where(e => e.RecStatus == "A" && e.Id == Id).FirstOrDefault();
            if (entity == null)
            {
                entity = new AdmAskYouHui();
            }
            var leaveDTO = _mapper.Map<AdmAskYouHuiDTO>(entity);
            return leaveDTO;
        }
        public List<AdmAskYouHuiDTO> GetAskYouHuiList(string CustomerId, string OrderType)
        {
            var entity = _context.AdmAskYouHuis.Where(e => e.RecStatus == "A" && e.ShenpiStatus == "A" && e.CustomerId == CustomerId && e.OrderType == OrderType && e.Createtime >= DateTime.Now.Date.AddDays(-8)).OrderByDescending(x=>x.Createtime).ToList();
            var leaveDTO = _mapper.Map<List<AdmAskYouHuiDTO>>(entity);
            return leaveDTO;
        }
        #endregion
        #region 访问请示
        public ResultEntity SaveAskBaiFang(AdmAskBaiFangDTO admAsk)
        {
            ResultEntity resultEntity = new ResultEntity();
            try
            {
                AdmAskBaiFang ask = _mapper.Map<AdmAskBaiFang>(admAsk);
                if (string.IsNullOrEmpty(admAsk.Id))
                {
                    ask.Id = Guid.NewGuid().ToString();
                    admAsk.Id = ask.Id;
                    _context.AdmAskBaiFangs.Add(ask);
                }
                else
                {
                    var entity = _context.AdmAskBaiFangs.Find(admAsk.Id);
                    entity.CustomerId = admAsk.CustomerId;
                    entity.VisType = admAsk.VisType;
                    entity.Jtype = admAsk.Jtype;
                    entity.BaiFangtime = admAsk.BaiFangtime;
                    entity.Remark = admAsk.Remark;
                    entity.ShenpiStatus = admAsk.ShenpiStatus;
                    entity.CreaterName = admAsk.CreaterName;
                    entity.Tittle = admAsk.Tittle;
                    entity.Modifier = admAsk.Modifier;
                    entity.Modifytime = DateTime.Now;
                }
                _context.SaveChanges();
                resultEntity.ReturnID = ask.Id;
                resultEntity.Result = true;
            }
            catch (Exception ex)
            {
                resultEntity.Result = false;
                resultEntity.Message = "保存失败,请联系管理员";
                ex.Message.ToString();
            }
            return resultEntity;
        }
        public AdmAskBaiFangDTO GetAskBaiFang(string Id)
        {
            var entity = _context.AdmAskBaiFangs.Where(e => e.RecStatus == "A" && e.Id == Id).FirstOrDefault();
            if (entity == null)
            {
                entity = new AdmAskBaiFang();
            }
            var leaveDTO = _mapper.Map<AdmAskBaiFangDTO>(entity);
            return leaveDTO;
        }
        #endregion
        #region 会员提现申请
        public ResultEntity SaveCustomerWithdrawal(AdmCustomerWithdrawalDTO admAsk)
        {
            ResultEntity resultEntity = new ResultEntity();
            try
            {
                AdmCustomerWithdrawal ask = _mapper.Map<AdmCustomerWithdrawal>(admAsk);
                if (string.IsNullOrEmpty(admAsk.Id))
                {
                    ask.Id = Guid.NewGuid().ToString();
                    admAsk.Id = ask.Id;
                    _context.AdmCustomerWithdrawals.Add(ask);
                }
                else
                {
                    var entity = _context.AdmCustomerWithdrawals.Find(admAsk.Id);
                    entity.OrderNo = admAsk.OrderNo;
                    entity.Jine = admAsk.Jine;
                    entity.HuiyuanName = admAsk.HuiyuanName;
                    entity.HuiyuanId = admAsk.HuiyuanId;
                    entity.HuiyuanPhone = admAsk.HuiyuanPhone;
                    entity.Shenqingtime = admAsk.Shenqingtime;
                    entity.BankAcount = admAsk.BankAcount;
                    entity.BankName = admAsk.BankName;
                    entity.Username = admAsk.Username;
                    entity.ShenpiStatus = admAsk.ShenpiStatus;
                    entity.CreaterName = admAsk.CreaterName;
                    entity.Tittle = admAsk.Tittle;
                    entity.Modifier = admAsk.Modifier;
                    entity.Modifytime = DateTime.Now;
                }
                _context.SaveChanges();
                resultEntity.ReturnID = ask.Id;
                resultEntity.Result = true;
            }
            catch (Exception ex)
            {
                resultEntity.Result = false;
                resultEntity.Message = "保存失败,请联系管理员";
                ex.Message.ToString();
            }
            return resultEntity;
        }
        public AdmCustomerWithdrawalDTO GetCustomerWithdrawal(string Id)
        {
            var entity = _context.AdmCustomerWithdrawals.Where(e => e.RecStatus == "A" && e.Id == Id).FirstOrDefault();
            if (entity == null)
            {
                entity = new AdmCustomerWithdrawal();
            }
            var leaveDTO = _mapper.Map<AdmCustomerWithdrawalDTO>(entity);
            return leaveDTO;
        }
        public List<AdmCustomerWithdrawalDTO> GetCustomerWithdrawalList(string OrderNo)
        {
            var entity = _context.AdmCustomerWithdrawals.Where(e => e.RecStatus == "A" && e.OrderNo == OrderNo).ToList();
            var leaveDTO = _mapper.Map<List<AdmCustomerWithdrawalDTO>>(entity);
            return leaveDTO;
        }
        #endregion
        #region 辞职申请
        public ResultEntity SaveAskCiZhi(AdmAskCiZhiDTO admAsk)
        {
            ResultEntity resultEntity = new ResultEntity();
            try
            {
                AdmAskCiZhi ask = _mapper.Map<AdmAskCiZhi>(admAsk);
                if (string.IsNullOrEmpty(admAsk.Id))
                {
                    ask.Id = Guid.NewGuid().ToString();
                    admAsk.Id = ask.Id;
                    _context.AdmAskCiZhis.Add(ask);
                }
                else
                {
                    var entity = _context.AdmAskCiZhis.Find(admAsk.Id);
                    entity.Remark = admAsk.Remark;
                    entity.DeptName = admAsk.DeptName;
                    entity.PostName = admAsk.PostName;
                    entity.CreatetimeName = admAsk.CreatetimeName;
                    entity.RuzhitimeName = admAsk.RuzhitimeName;
                    entity.Outtime = admAsk.Outtime;
                    entity.ShenpiStatus = admAsk.ShenpiStatus;
                    entity.CreaterName = admAsk.CreaterName;
                    entity.Tittle = admAsk.Tittle;
                    entity.JiaojieUser = admAsk.JiaojieUser;
                    entity.Modifier = admAsk.Modifier;
                    entity.Modifytime = DateTime.Now;
                }
                _context.SaveChanges();
                resultEntity.ReturnID = ask.Id;
                resultEntity.Result = true;
            }
            catch (Exception ex)
            {
                resultEntity.Result = false;
                resultEntity.Message = "保存失败,请联系管理员";
                ex.Message.ToString();
            }
            return resultEntity;
        }
        public AdmAskCiZhiDTO GetAskCiZhi(string Id)
        {
            var entity = _context.AdmAskCiZhis.Where(e => e.RecStatus == "A" && e.Id == Id).FirstOrDefault();
            if (entity == null)
            {
                entity = new AdmAskCiZhi();
            }
            var leaveDTO = _mapper.Map<AdmAskCiZhiDTO>(entity);
            return leaveDTO;
        }
        #endregion
        #region 工作交接
        public ResultEntity SaveAskJiaojie(AdmAskJiaojieDTO admAsk)
        {
            ResultEntity resultEntity = new ResultEntity();
            try
            {
                AdmAskJiaojie ask = _mapper.Map<AdmAskJiaojie>(admAsk);
                if (string.IsNullOrEmpty(admAsk.Id))
                {
                    ask.Id = Guid.NewGuid().ToString();
                    admAsk.Id = ask.Id;
                    _context.AdmAskJiaojies.Add(ask);
                }
                else
                {
                    var entity = _context.AdmAskJiaojies.Find(admAsk.Id);
                    entity.Remark = admAsk.Remark;
                    entity.CiZhiId = admAsk.CiZhiId;
                    entity.ShenpiStatus = admAsk.ShenpiStatus;
                    entity.CreaterName = admAsk.CreaterName;
                    entity.Tittle = admAsk.Tittle;
                    entity.Modifier = admAsk.Modifier;
                    entity.Modifytime = DateTime.Now;
                }
                _context.SaveChanges();
                resultEntity.ReturnID = admAsk.Id;
                resultEntity.Result = true;
            }
            catch (Exception ex)
            {
                resultEntity.Result = false;
                resultEntity.Message = "保存失败,请联系管理员";
                ex.Message.ToString();
            }
            return resultEntity;
        }
        public AdmAskJiaojieDTO GetAskJiaojie(string Id)
        {
            var entity = _context.AdmAskJiaojies.Where(e => e.RecStatus == "A" && e.Id == Id).FirstOrDefault();
            if (entity == null)
            {
                entity = new AdmAskJiaojie();
            }
            var leaveDTO = _mapper.Map<AdmAskJiaojieDTO>(entity);
            return leaveDTO;
        }
        public ResultEntity SaveAskJiaojieDtl(AdmAskJiaojieDtlDTO admAsk)
        {
            ResultEntity resultEntity = new ResultEntity();
            try
            {
                AdmAskJiaojieDtl ask = _mapper.Map<AdmAskJiaojieDtl>(admAsk);
                if (string.IsNullOrEmpty(admAsk.Id))
                {
                    ask.Id = Guid.NewGuid().ToString();
                    admAsk.Id = ask.Id;
                    _context.AdmAskJiaojieDtls.Add(ask);
                }
                else
                {
                    var entity = _context.AdmAskJiaojieDtls.Find(admAsk.Id);
                    entity.JiaojieId = admAsk.JiaojieId;
                    entity.Jiaojietime = admAsk.Jiaojietime;
                    entity.JiaojieType = admAsk.JiaojieType;
                    entity.Kehudanwei = admAsk.Kehudanwei;
                    entity.JiaojieNeirong = admAsk.JiaojieNeirong;
                    entity.JiaojieUserId = admAsk.JiaojieUserId;
                    entity.JieShoutime = admAsk.JieShoutime;
                    entity.JiaojieStatus = admAsk.JiaojieStatus;
                    entity.Modifier = admAsk.Modifier;
                    entity.Modifytime = DateTime.Now;
                }
                _context.SaveChanges();
                resultEntity.ReturnID = ask.Id;
                resultEntity.Result = true;
            }
            catch (Exception ex)
            {
                resultEntity.Result = false;
                resultEntity.Message = "保存失败,请联系管理员";
                ex.Message.ToString();
            }
            return resultEntity;
        }
        public List<AdmAskJiaojieDtlDTO> GetAskJiaojieDtls(string JiaojieId)
        {
            var entity = _context.AdmAskJiaojieDtls.Where(e => e.RecStatus == "A" && e.JiaojieId == JiaojieId).OrderBy(x=>x.JiaojieType).ToList();
            var leaveDTOs = _mapper.Map<List<AdmAskJiaojieDtlDTO>>(entity);
            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"
                                          && b.CodeTable == "ADM_AskJiaojieDtl"
                                          && b.CodeField == "JiaojieType"
                            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
                            }
                        ).ToList();
            var pltUsers = _context.PltUsers.Where(e => e.RecStatus == "A" && e.Zhiwustatus == "A").ToList();
            foreach (var leaveDTO in leaveDTOs)
            {
                leaveDTO.JiaojietimeName = leaveDTO.Jiaojietime.HasValue ? leaveDTO.Jiaojietime.Value.ToString("yyyy-MM-dd") : "";
                leaveDTO.JieShoutimeName = leaveDTO.JieShoutime.HasValue ? leaveDTO.JieShoutime.Value.ToString("yyyy-MM-dd") : "";
                var codeDataEntity = listCode.Where(x => x.CodeSn == leaveDTO.JiaojieType).FirstOrDefault();
                if (codeDataEntity != null)
                {
                    leaveDTO.JiaojieTypeName = codeDataEntity.Comments;
                }
                var pltUser = pltUsers.Where(x => x.Id == leaveDTO.JiaojieUserId).FirstOrDefault();
                if (pltUser != null)
                {
                    leaveDTO.JiaojieUserName = pltUser.UserName;
                }
            }
            return leaveDTOs;
        }
        public AdmAskJiaojieDtlDTO GetAskJiaojieDtl(string Id)
        {
            var entity = _context.AdmAskJiaojieDtls.Where(e => e.RecStatus == "A" && e.Id == Id).FirstOrDefault();
            if (entity == null)
            {
                entity = new AdmAskJiaojieDtl();
            }
            var leaveDTO = _mapper.Map<AdmAskJiaojieDtlDTO>(entity);
            return leaveDTO;
        }
        #endregion
    }
}