zhengcaioa/CommonToolsCore/AutoMapperConfigs.cs
@@ -220,6 +220,11 @@ CreateMap<IntentionVisitDuanxin, IntentionVisitDuanxinDTO>(); CreateMap<IntentionVisitDuanxinDTO, IntentionVisitDuanxin>(); CreateMap<DtChannelArticleNews, DtChannelArticleNewsDTO>(); CreateMap<DtChannelArticleNewsDTO, DtChannelArticleNews>(); } } } zhengcaioa/DTO/TongjiBaoBiaoDTO.cs
New file @@ -0,0 +1,28 @@ using System; using System.Collections.Generic; using System.Text; namespace DTO { public class TongjiBaoBiaoDTO { public string gongzuo { get; set; } public string benyueshuliang { get; set; } public string benyueqingkuang { get; set; } public string benrishuliang { get; set; } public string benriqingkuang { get; set; } public string dangrijixiao { get; set; } } public class TongjiDingDanDTO { public string dingdanbianhao { get; set; } public string dingdanmingcheng { get; set; } public string danjia { get; set; } public string shuliang { get; set; } public string jine { get; set; } public string benyueleijijine { get; set; } } } zhengcaioa/DTO/zcweb/DtChannelArticleNewsDTO.cs
New file @@ -0,0 +1,49 @@ using System; using System.Collections.Generic; using System.Text; namespace DTO { public class DtChannelArticleNewsDTO { public int Id { get; set; } public int SiteId { get; set; } public int ChannelId { get; set; } public int CategoryId { get; set; } public string CallIndex { get; set; } public string Title { get; set; } public string LinkUrl { get; set; } public string ImgUrl { get; set; } public string SeoTitle { get; set; } public string SeoKeywords { get; set; } public string SeoDescription { get; set; } public string Tags { get; set; } public string Zhaiyao { get; set; } public string Content { get; set; } public int SortId { get; set; } public int Click { get; set; } public int Status { get; set; } public int IsMsg { get; set; } public int IsTop { get; set; } public int IsRed { get; set; } public int IsHot { get; set; } public int IsSlide { get; set; } public int IsSys { get; set; } public string UserName { get; set; } public int LikeCount { get; set; } public DateTime AddTime { get; set; } public DateTime? UpdateTime { get; set; } public string Source { get; set; } public string Author { get; set; } } public class DtChannelArticleNewsDTOSearch : SearchEntity { public string UserName { get; set; } public DateTime? AddTime { get; set; } public DateTime? EndTime { get; set; } public int CategoryId { get; set; } } } zhengcaioa/IServices/ICooperOrderService.cs
@@ -33,5 +33,8 @@ List<CooperOrderDTO> GetList(string userid, DateTime datemin, DateTime datemax); List<CooperOrderDTO> GetListtongji(string userid, DateTime datemin, DateTime datemax); } } zhengcaioa/IServices/ICooperatecustomCustomerService.cs
@@ -22,5 +22,7 @@ List<CooperatecustomCustomerDTO> GetListsalaryqiandan(string userid, DateTime datemin, DateTime datemax); List<CooperatecustomCustomerDTO> GetListsalaryweixin(string userid, DateTime datemin, DateTime datemax); } } zhengcaioa/IServices/ICusFangwenjiluService.cs
@@ -17,5 +17,7 @@ ResultEntity ModifyStatus(string id, string userid); List<CusFangwenjiluDTO> GetList(); List<CusFangwenjiluDTO> GetListsalary(string userid, DateTime datemin, DateTime datemax); } } zhengcaioa/IServices/IIntentionCustomerService.cs
@@ -32,5 +32,10 @@ List<IntentionCustomerDTO> GetListsalary(string userid, DateTime datemin, DateTime datemax); List<IntentionCustomerDTO> GetListsalaryweixin(string userid, DateTime datemin, DateTime datemax); List<IntentionCustomerDTO> GetListsalaryyixiang(string userid, DateTime datemin, DateTime datemax); } } zhengcaioa/IServices/ILiaotianService.cs
@@ -31,5 +31,10 @@ ResultEntity saveSysUpdatetime(SysUpdatetime sysUpdatetime); List<LiaotianDTO> GetListsalary(string userid, DateTime datemin, DateTime datemax); List<LiaotianDTO> GetListsalaryshenhe(string userid, DateTime datemin, DateTime datemax); } } zhengcaioa/IServices/IProjectService.cs
@@ -36,5 +36,8 @@ List<ProjectDTO> GetList(); List<ProjectDTO> GetListsalary(string userid, DateTime datemin, DateTime datemax); } } zhengcaioa/IServices/zcweb/IDtChannelArticleNewsService.cs
New file @@ -0,0 +1,13 @@ using DTO; using System; using System.Collections.Generic; using System.Text; using zhengcaioa.Models; namespace IServices { public interface IDtChannelArticleNewsService { List<DtChannelArticleNewsDTO> GetList(DtChannelArticleNewsDTOSearch searchEntity); } } zhengcaioa/Model/zcweb/DtArticleCategory.cs
New file @@ -0,0 +1,27 @@ using System; using System.Collections.Generic; #nullable disable namespace zhengcaioa.Models { public partial class DtArticleCategory { public int Id { get; set; } public int? SiteId { get; set; } public int ChannelId { get; set; } public string Title { get; set; } public string CallIndex { get; set; } public int? ParentId { get; set; } public string ClassList { get; set; } public int? ClassLayer { get; set; } public int? SortId { get; set; } public string LinkUrl { get; set; } public string ImgUrl { get; set; } public string Content { get; set; } public string SeoTitle { get; set; } public string SeoKeywords { get; set; } public string SeoDescription { get; set; } public byte? IsLock { get; set; } } } zhengcaioa/Model/zcweb/DtChannelArticleNews.cs
New file @@ -0,0 +1,40 @@ using System; using System.Collections.Generic; #nullable disable namespace zhengcaioa.Models { public partial class DtChannelArticleNews { public int Id { get; set; } public int SiteId { get; set; } public int ChannelId { get; set; } public int CategoryId { get; set; } public string CallIndex { get; set; } public string Title { get; set; } public string LinkUrl { get; set; } public string ImgUrl { get; set; } public string SeoTitle { get; set; } public string SeoKeywords { get; set; } public string SeoDescription { get; set; } public string Tags { get; set; } public string Zhaiyao { get; set; } public string Content { get; set; } public int SortId { get; set; } public int Click { get; set; } public int Status { get; set; } public int IsMsg { get; set; } public int IsTop { get; set; } public int IsRed { get; set; } public int IsHot { get; set; } public int IsSlide { get; set; } public int IsSys { get; set; } public string UserName { get; set; } public int LikeCount { get; set; } public DateTime AddTime { get; set; } public DateTime? UpdateTime { get; set; } public string Source { get; set; } public string Author { get; set; } } } zhengcaioa/Model/zcweb/zcwebContext.cs
New file @@ -0,0 +1,228 @@ using System; using Microsoft.EntityFrameworkCore; using Microsoft.EntityFrameworkCore.Metadata; #nullable disable namespace zhengcaioa.Models { public partial class zcwebContext : DbContext { public zcwebContext() { } public zcwebContext(DbContextOptions<zcwebContext> options) : base(options) { } public virtual DbSet<DtArticleCategory> DtArticleCategories { get; set; } public virtual DbSet<DtChannelArticleNews> DtChannelArticleNews { get; set; } protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { if (!optionsBuilder.IsConfigured) { #warning To protect potentially sensitive information in your connection string, you should move it out of source code. You can avoid scaffolding the connection string by using the Name= syntax to read it from configuration - see https://go.microsoft.com/fwlink/?linkid=2131148. For more guidance on storing connection strings, see http://go.microsoft.com/fwlink/?LinkId=723263. optionsBuilder.UseSqlServer("Data Source=.;Initial Catalog=zcweb;User ID=sa;Password=123456"); } } protected override void OnModelCreating(ModelBuilder modelBuilder) { modelBuilder.HasAnnotation("Relational:Collation", "Chinese_PRC_CI_AS"); modelBuilder.Entity<DtArticleCategory>(entity => { entity.ToTable("dt_article_category"); entity.HasComment("文章类别表"); entity.Property(e => e.Id) .HasColumnName("id") .HasComment("自增ID"); entity.Property(e => e.CallIndex) .HasMaxLength(50) .HasColumnName("call_index") .HasDefaultValueSql("('')") .HasComment("调用别名"); entity.Property(e => e.ChannelId) .HasColumnName("channel_id") .HasComment("频道ID"); entity.Property(e => e.ClassLayer) .HasColumnName("class_layer") .HasDefaultValueSql("((0))") .HasComment("类别深度"); entity.Property(e => e.ClassList) .HasMaxLength(500) .HasColumnName("class_list") .HasComment("类别ID列表(逗号分隔开)"); entity.Property(e => e.Content) .HasColumnType("ntext") .HasColumnName("content") .HasComment("备注说明"); entity.Property(e => e.ImgUrl) .HasMaxLength(255) .HasColumnName("img_url") .HasDefaultValueSql("('')") .HasComment("图片地址"); entity.Property(e => e.IsLock) .HasColumnName("is_lock") .HasDefaultValueSql("((0))") .HasComment("状态0正常1禁用"); entity.Property(e => e.LinkUrl) .HasMaxLength(255) .HasColumnName("link_url") .HasDefaultValueSql("('')") .HasComment("URL跳转地址"); entity.Property(e => e.ParentId) .HasColumnName("parent_id") .HasDefaultValueSql("((0))") .HasComment("父类别ID"); entity.Property(e => e.SeoDescription) .HasMaxLength(255) .HasColumnName("seo_description") .HasDefaultValueSql("('')") .HasComment("SEO描述"); entity.Property(e => e.SeoKeywords) .HasMaxLength(255) .HasColumnName("seo_keywords") .HasDefaultValueSql("('')") .HasComment("SEO关健字"); entity.Property(e => e.SeoTitle) .HasMaxLength(255) .HasColumnName("seo_title") .HasDefaultValueSql("('')") .HasComment("SEO标题"); entity.Property(e => e.SiteId) .HasColumnName("site_id") .HasDefaultValueSql("((0))") .HasComment("站点ID"); entity.Property(e => e.SortId) .HasColumnName("sort_id") .HasDefaultValueSql("((99))") .HasComment("排序数字"); entity.Property(e => e.Title) .HasMaxLength(100) .HasColumnName("title") .HasComment("类别标题"); }); modelBuilder.Entity<DtChannelArticleNews>(entity => { entity.ToTable("dt_channel_article_news"); entity.Property(e => e.Id).HasColumnName("id"); entity.Property(e => e.AddTime) .HasColumnType("datetime") .HasColumnName("add_time") .HasDefaultValueSql("(getdate())"); entity.Property(e => e.Author) .HasMaxLength(50) .HasColumnName("author"); entity.Property(e => e.CallIndex) .HasMaxLength(50) .HasColumnName("call_index"); entity.Property(e => e.CategoryId).HasColumnName("category_id"); entity.Property(e => e.ChannelId).HasColumnName("channel_id"); entity.Property(e => e.Click).HasColumnName("click"); entity.Property(e => e.Content) .HasColumnType("ntext") .HasColumnName("content"); entity.Property(e => e.ImgUrl) .HasMaxLength(255) .HasColumnName("img_url"); entity.Property(e => e.IsHot).HasColumnName("is_hot"); entity.Property(e => e.IsMsg).HasColumnName("is_msg"); entity.Property(e => e.IsRed).HasColumnName("is_red"); entity.Property(e => e.IsSlide).HasColumnName("is_slide"); entity.Property(e => e.IsSys).HasColumnName("is_sys"); entity.Property(e => e.IsTop).HasColumnName("is_top"); entity.Property(e => e.LikeCount).HasColumnName("like_count"); entity.Property(e => e.LinkUrl) .HasMaxLength(255) .HasColumnName("link_url"); entity.Property(e => e.SeoDescription) .HasMaxLength(255) .HasColumnName("seo_description"); entity.Property(e => e.SeoKeywords) .HasMaxLength(255) .HasColumnName("seo_keywords"); entity.Property(e => e.SeoTitle) .HasMaxLength(255) .HasColumnName("seo_title"); entity.Property(e => e.SiteId).HasColumnName("site_id"); entity.Property(e => e.SortId) .HasColumnName("sort_id") .HasDefaultValueSql("((99))"); entity.Property(e => e.Source) .HasMaxLength(50) .HasColumnName("source"); entity.Property(e => e.Status).HasColumnName("status"); entity.Property(e => e.Tags) .HasMaxLength(500) .HasColumnName("tags"); entity.Property(e => e.Title) .HasMaxLength(100) .HasColumnName("title"); entity.Property(e => e.UpdateTime) .HasColumnType("datetime") .HasColumnName("update_time"); entity.Property(e => e.UserName) .HasMaxLength(100) .HasColumnName("user_name"); entity.Property(e => e.Zhaiyao) .HasMaxLength(255) .HasColumnName("zhaiyao"); }); OnModelCreatingPartial(modelBuilder); } partial void OnModelCreatingPartial(ModelBuilder modelBuilder); } } zhengcaioa/Services/CooperOrderService.cs
@@ -720,7 +720,7 @@ public List<CooperOrderDTO> GetList(string userid, DateTime datemin, DateTime datemax) { var entity = _context.CooperOrders.Where(x => x.RecStatus == "A" && x.Creater == userid && x.Shoulitime >= datemin && x.Shoulitime < datemax).ToList(); var entity = _context.CooperOrders.Where(x => x.RecStatus == "A" && x.ShouliStatus != "0" && x.Creater == userid && x.Createtime >= datemin && x.Createtime < datemax).ToList(); @@ -729,5 +729,177 @@ return result; } public List<CooperOrderDTO> GetListtongji(string userid, DateTime datemin, DateTime datemax) { 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 }); var entity = (from a in _context.CooperOrders.Where(x => x.RecStatus == "A" && x.ShouliStatus != "0" && x.Creater == userid && x.Createtime >= datemin && x.Createtime < datemax) join b in listCode.Where(x => x.CodeTable == "CooperOrder" && x.CodeField == "shouli_status") on a.ShouliStatus equals b.CodeSn into bsss from bbb in bsss.DefaultIfEmpty() join c in listCode.Where(x => x.CodeTable == "CooperOrder" && x.CodeField == "huifang_status") on a.HuifangStatus equals c.CodeSn into csss from ccc in csss.DefaultIfEmpty() join d in listCode.Where(x => x.CodeTable == "CooperOrder" && x.CodeField == "pingjia_status") on a.PingjiaStatus equals d.CodeSn into dsss from ddd in dsss.DefaultIfEmpty() join e in listCode.Where(x => x.CodeTable == "system" && x.CodeField == "shifou") on a.ChedanStatus equals e.CodeSn into esssss from eee in esssss.DefaultIfEmpty() join f in listCode.Where(x => x.CodeTable == "CooperVisit" && x.CodeField == "jtype") on a.OrderType equals f.CodeSn into fsssss from fff in fsssss.DefaultIfEmpty() join g in _context.CooperatecustomCustomers.Where(x => x.RecStatus == "A") on a.Khdw equals g.Id into gsss from ggg in gsss.DefaultIfEmpty() join h in _context.Projects.Where(x => x.RecStatus == "A") on a.OrderPro equals h.Id into hsss from hhh in hsss.DefaultIfEmpty() join i in listCode.Where(x => x.CodeTable == "system" && x.CodeField == "shifou") on a.WangongStatus equals i.CodeSn into isssss from iii in isssss.DefaultIfEmpty() join j in listCode.Where(x => x.CodeTable == "system" && x.CodeField == "shifou") on a.SonghuoStatus equals j.CodeSn into jsssss from jjj in jsssss.DefaultIfEmpty() join k in _context.Oayouhuis.Where(x => x.Recstatus == "A") on a.Id equals k.CooperOrderId into ksssss from kkk in ksssss.DefaultIfEmpty() join l in _context.FiBooks on a.OrderType1 equals l.Id into lsssss from lll in lsssss.DefaultIfEmpty() join m in _context.FiMembers on a.OrderType1 equals m.Id into msssss from mmm in msssss.DefaultIfEmpty() select new CooperOrderDTO { Id = a.Id, XdTime = a.XdTime, XdTimeName = a.XdTime.ToString("yyyy-MM-dd"), OrderNo = a.OrderNo, Khdw = a.Khdw, KhdwName = ggg.Name, OrderType = a.OrderType, OrderTypeName = fff.Comments, OrderPro = a.OrderPro, OrderProName = hhh.Name, OrderNum = a.OrderNum, Price = a.Price, Money = a.Money, Shr = a.Shr, ShrAddress = a.ShrAddress, ShrTel = a.ShrTel, Remark = a.Remark, Creater = a.Creater, Createtime = a.Createtime, RecStatus = a.RecStatus, Modifier = a.Modifier, Modifytime = a.Modifytime, ShouliStatus = a.ShouliStatus, ShouliStatusName = bbb.Comments, Shoulier = a.Shoulier, Shoulitime = a.Shoulitime, ChedanStatus = a.ChedanStatus, ChedanStatusName = eee.Comments, Chedaner = a.Chedaner, Chedantime = a.Chedantime, Chedan = a.Chedan, HuifangStatus = a.HuifangStatus, HuifangStatusName = ccc.Comments, Huifanger = a.Huifanger, Huifangtime = a.Huifangtime, Huifangremark = a.Huifangremark, PingjiaStatus = a.PingjiaStatus, PingjiaStatusName = ddd.Comments, Pingjiaer = a.Pingjiaer, Pingjiatime = a.Pingjiatime, Youhui = a.Youhui, Youhuier = a.Youhuier, Youhuitime = a.Youhuitime, SonghuoStatusName = jjj.Comments, SonghuoStatus = a.SonghuoStatus, Songhuoer = a.Songhuoer, Songhuotime = a.Songhuotime, WangongStatusName = iii.Comments, WangongStatus = a.WangongStatus, Wangonger = a.Wangonger, Wangongtime = a.Wangongtime, YouhuiStatus = kkk.Id, OrderType1 = a.OrderType1, OrderType2 = a.OrderType2, OrderType1Name = string.IsNullOrEmpty(lll.BookName) ? string.IsNullOrEmpty(mmm.MemberType) ? a.OrderType1 : mmm.MemberType : lll.BookName, SonghuoGongsi = a.SonghuoGongsi, SonghuoDanhao = a.SonghuoDanhao, SonghuoTime1 = a.SonghuoTime1, HuifangJdr = a.HuifangJdr, HuifangKehuyijian = a.HuifangKehuyijian, } ).OrderByDescending(x => x.OrderNo).ToList(); return entity; } } } zhengcaioa/Services/CooperatecustomCustomerService.cs
@@ -205,7 +205,7 @@ && (string.IsNullOrWhiteSpace(searchEntity.Sheng) || a.Sheng == searchEntity.Sheng.Trim()) && (string.IsNullOrWhiteSpace(searchEntity.City) || a.City == searchEntity.City.Trim()) && (string.IsNullOrWhiteSpace(searchEntity.AreaId) || a.AreaId == searchEntity.AreaId.Trim()) && (string.IsNullOrWhiteSpace(searchEntity.Shifouweixin) || (searchEntity.Shifouweixin == "A" && a.Weixin != null) || (searchEntity.Shifouweixin != "A" && a.Weixin == null) ) && (string.IsNullOrWhiteSpace(searchEntity.Shifouweixin) || a.Shifoutianjiaweixin == searchEntity.Shifouweixin.Trim()) && (string.IsNullOrWhiteSpace(searchEntity.HuiyuanId) || a.HuiyuanId == searchEntity.HuiyuanId.Trim()) select new CooperatecustomCustomerDTO @@ -328,7 +328,7 @@ var listPosition =( from a in _context.CooperatecustomCustomers.Where(r => r.RecStatus == "A" && r.Creater == userid) join b in _context.CooperOrders.Where(x => x.RecStatus == "A" && x.Shoulitime >= datemin && x.Shoulitime < datemax) join b in _context.CooperOrders.Where(x => x.RecStatus == "A" && x.Createtime >= datemin && x.Createtime < datemax) on a.Id equals b.Khdw select a @@ -337,5 +337,15 @@ var list = _mapper.Map<List<CooperatecustomCustomerDTO>>(listPosition); return list; } public List<CooperatecustomCustomerDTO> GetListsalaryweixin(string userid, DateTime datemin, DateTime datemax) { var listPosition = _context.CooperatecustomCustomers.Where(r => r.RecStatus == "A" && r.Weixiner == userid && r.Weixintime >= datemin && r.Weixintime < datemax).ToList(); var list = _mapper.Map<List<CooperatecustomCustomerDTO>>(listPosition); return list; } } } zhengcaioa/Services/CusFangwenjiluService.cs
@@ -110,5 +110,22 @@ var list = _mapper.Map<List<CusFangwenjiluDTO>>(listPosition); return list; } /// <summary> /// 获取所有有效角色 /// </summary> /// <returns></returns> public List<CusFangwenjiluDTO> GetListsalary(string userid, DateTime datemin, DateTime datemax) { var listPosition = _context.CusFangwenjilus.Where(r => r.RecStatus == "A" && r.Creater == userid && r.Createtime >= datemin && r.Createtime < datemax).ToList(); var list = _mapper.Map<List<CusFangwenjiluDTO>>(listPosition); return list; } } } zhengcaioa/Services/FiAccountRecordService.cs
@@ -132,7 +132,8 @@ && (string.IsNullOrWhiteSpace(searchEntity.PaymentUnit) || a.PaymentUnit.Contains(searchEntity.PaymentUnit.Trim())) && (string.IsNullOrWhiteSpace(searchEntity.CreaterName) || y.UserName.Contains(searchEntity.CreaterName.Trim())) && (string.IsNullOrWhiteSpace(searchEntity.RecordTypeId) || a.RecordTypeId == searchEntity.RecordTypeId.Trim()) && (string.IsNullOrWhiteSpace(searchEntity.RecordTypeId) || a.RecordTypeId == searchEntity.RecordTypeId.Trim()) select new FiAccountRecordDTO { Id = a.Id, zhengcaioa/Services/IntentionCustomerService.cs
@@ -232,7 +232,7 @@ && (string.IsNullOrWhiteSpace(searchEntity.Yixiangtime) || (a.Yixiangtime >= Yixiangtimestart && a.Yixiangtime <= Yixiangtimeend)) && (string.IsNullOrWhiteSpace(searchEntity.Yixiang) || ( a.Yixiang == searchEntity.Yixiang.Trim() && (a.Ywjl == null || a.Ywjl == searchEntity.YwjlYx) )) && (string.IsNullOrWhiteSpace(searchEntity.Shifouweixin) || (searchEntity.Shifouweixin == "A" && a.Weixin != null) || (searchEntity.Shifouweixin != "A" && a.Weixin == null)) //&& (string.IsNullOrWhiteSpace(searchEntity.Shifouweixin) || a.Shifoutianjiaweixin == searchEntity.Shifouweixin.Trim()) select new IntentionCustomerDTO { Id = a.Id, @@ -291,7 +291,10 @@ } ).OrderByDescending(x => x.Modifytime).ToList(); if (!string.IsNullOrWhiteSpace(searchEntity.Shifouweixin)) { query = query.Where( a=>a.Shifoutianjiaweixin == searchEntity.Shifouweixin.Trim()).ToList(); } if (searchEntity.totalrows == 0) searchEntity.totalrows = query.Count(); @@ -371,5 +374,26 @@ var list = _mapper.Map<List<IntentionCustomerDTO>>(listPosition); return list; } public List<IntentionCustomerDTO> GetListsalaryweixin(string userid, DateTime datemin, DateTime datemax) { var listPosition = _context.IntentionCustomers.Where(r => r.RecStatus == "A" && r.Weixiner == userid && r.Weixintime >= datemin && r.Weixintime < datemax).ToList(); var list = _mapper.Map<List<IntentionCustomerDTO>>(listPosition); return list; } public List<IntentionCustomerDTO> GetListsalaryyixiang(string userid, DateTime datemin, DateTime datemax) { var listPosition = _context.IntentionCustomers.Where(r => r.RecStatus == "A" && r.Dianxiaozhuanyuan == userid && r.Yixiangtime >= datemin && r.Yixiangtime < datemax).ToList(); var list = _mapper.Map<List<IntentionCustomerDTO>>(listPosition); return list; } } } zhengcaioa/Services/LiaotianService.cs
@@ -386,5 +386,26 @@ return entity; } public List<LiaotianDTO> GetListsalary(string userid, DateTime datemin, DateTime datemax) { var listPosition = _context.Liaotians.Where(r => r.RecStatus == "A" && r.Creater == userid && r.Createtime >= datemin && r.Createtime < datemax).ToList(); var list = _mapper.Map<List<LiaotianDTO>>(listPosition); return list; } public List<LiaotianDTO> GetListsalaryshenhe(string userid, DateTime datemin, DateTime datemax) { var listPosition = _context.Liaotians.Where(r => r.RecStatus == "A" && r.Shenheer == userid && r.Shenhetime >= datemin && r.Shenhetime < datemax).ToList(); var list = _mapper.Map<List<LiaotianDTO>>(listPosition); return list; } } } zhengcaioa/Services/ProjectService.cs
@@ -636,5 +636,16 @@ CacheHelperNetCore.CacheInsert("Projects", list); return list; } public List<ProjectDTO> GetListsalary(string userid, DateTime datemin, DateTime datemax) { var listPosition = _context.Projects.Where(r => r.RecStatus == "A" && r.Creater == userid && r.Createtime >= datemin && r.Createtime < datemax).ToList(); var list = _mapper.Map<List<ProjectDTO>>(listPosition); return list; } } } zhengcaioa/Services/zcweb/DtChannelArticleNewsService.cs
New file @@ -0,0 +1,48 @@ using System; using System.Collections.Generic; using System.Linq; using System.Text; using AutoMapper; using DTO; using IServices; using Microsoft.AspNetCore.Mvc.Rendering; using Microsoft.EntityFrameworkCore; using zhengcaioa.Models; namespace Services { public class DtChannelArticleNewsService: IDtChannelArticleNewsService { private readonly zcwebContext _context; private readonly IMapper _mapper; public DtChannelArticleNewsService(zcwebContext context, IMapper mapper) { _context = context; _mapper = mapper; } public List<DtChannelArticleNewsDTO> GetList(DtChannelArticleNewsDTOSearch searchEntity) { var entity = (from a in _context.DtChannelArticleNews.Where(x => x.Status == 0) join b in _context.DtArticleCategories on a.CategoryId equals b.Id where a.Status == 0 && (string.IsNullOrWhiteSpace(searchEntity.UserName) || a.UserName == searchEntity.UserName.Trim()) && ( !searchEntity.AddTime.HasValue || a.AddTime >= searchEntity.AddTime.Value.Date ) && (!searchEntity.EndTime.HasValue || a.AddTime < searchEntity.EndTime.Value.Date ) && (searchEntity.CategoryId <= 0 || b.ParentId == searchEntity.CategoryId ) select a ).ToList(); var result = _mapper.Map<List<DtChannelArticleNewsDTO>>(entity); return result; } } } zhengcaioa/zhengcaioa/Controllers/Finance/FiAccountController.cs
@@ -20,15 +20,20 @@ private readonly ILogger<FiAccountController> _logger; private readonly IFiAccountService _fiAccountService; private readonly ILiaotianService _liaotianService; private readonly IFiSubjectService _ifiSubjectService; private readonly IFiAccountRecordService _iFiAccountRecordService; public FiAccountController(ILogger<FiAccountController> logger, IFiAccountService fiAccountService, ILiaotianService liaotianService) public FiAccountController(ILogger<FiAccountController> logger, IFiAccountService fiAccountService, ILiaotianService liaotianService, IFiSubjectService ifiSubjectService , IFiAccountRecordService iFiAccountRecordService) { _logger = logger; _fiAccountService = fiAccountService; _liaotianService = liaotianService; _ifiSubjectService = ifiSubjectService; _iFiAccountRecordService = iFiAccountRecordService; } public IActionResult Index() @@ -127,8 +132,19 @@ data.RecStatus = "A"; if (String.IsNullOrEmpty(data.Id)) { data.Creater = curentuser.Id; data.Createtime = DateTime.Now; } else { var sss = _fiAccountService.Get(data.Id); data.Balance = sss.Balance; data.AllIncome = sss.AllIncome; data.AllExpenses = sss.AllExpenses; } data.Modifier = curentuser.Id; data.Modifytime = DateTime.Now; @@ -152,5 +168,36 @@ ViewData["curentuser"] = curentuser; return new JsonResult(_fiAccountService.ModifyStatus(Id, curentuser.Id)); } public IActionResult Liushuizhang(string id) { var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User")); ViewData["curentuser"] = curentuser; List<ActionEntity> actionlist = new List<ActionEntity>(); ActionEntity actionEntity = new ActionEntity(); actionEntity.OpenType = 0; actionEntity.ActionUrl = ""; actionEntity.ActionFun = "Search"; actionEntity.PageIco = "fa fa-search"; actionEntity.ActionName = "查询"; actionlist.Add(actionEntity); ViewData["ActionInfo"] = actionlist; ViewBag.FiSubject = _ifiSubjectService.GetList()/*.Where(x => x.Subjecttype == "02")*/.Select(x => new { code = x.Id, label = x.Subjectname }).ToList(); ViewBag.id = id; return View(); } public IActionResult GetListLiushuizhang(FiAccountRecordDTOSearch search) { var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User")); ViewData["curentuser"] = curentuser; //search.RecordTypeId = "2"; return new JsonResult(_iFiAccountRecordService.SearchByPaging(search)); } } } zhengcaioa/zhengcaioa/Controllers/admin/TongjiBaoBiaoController.cs
New file @@ -0,0 +1,1696 @@ using System.Collections.Generic; using System.Linq; using System.Text; using AutoMapper; using AngleSharp.Html.Parser; using DTO; using IServices; using Microsoft.AspNetCore.Http; using Microsoft.AspNetCore.Mvc; using Microsoft.Bot.Builder.Integration.AspNet.Core; using Microsoft.Extensions.Logging; using Newtonsoft.Json; using System.Net.Http; using System.Threading.Tasks; using zhengcaioa.Models; using zhengcaioa.IService; using CommonToolsCore; using Services; using System.IO; using Microsoft.AspNetCore.Hosting; using Grpc.Core; using System; using System.Transactions; namespace zhengcaioa.Controllers.Finance { [CheckLogin] public class TongjiBaoBiaoController : Controller { private readonly ILogger<TongjiBaoBiaoController> _logger; private readonly IAdmAttendanceRuleService _attendanceRuleService; private readonly IUserService _userService; private readonly IAdmSigninService _signinService; private readonly IAdmAttendanceService _admAttendanceService; private readonly IAdmAttendanceDtlService _admAttendanceDtlService; private readonly IHrSalaryService _hrSalaryService; private readonly IHrJibengongziService _JibengongziService; private readonly ISimService _simService; private readonly IDailyManagementService _DailyManageService; private readonly IAdmBreakPrecedentService _admBreakPrecedentService; private readonly IHrJixiaotichengService _hrJixiaotichengService; private readonly IFiPiecerateService _fiPiecerateService; private readonly IAdmPieceCheckService _admPieceCheckService; private readonly ICooperOrderService _cooperOrderService; private readonly ICooperatecustomCustomerService _cooperatecustomCustomerService; private readonly IGroupTopicService _groupTopicService; private readonly ICooperVisitService _cooperVisitService; private readonly IIntentionCustomerService _intentionCustomerService; private readonly IIntentionVisitService _intentionVisitService; private readonly IDtChannelArticleNewsService _dtChannelArticleNewsService; private readonly IProjectService _projectService; private readonly ICusFangwenjiluService _cusFangwenjiluService; private readonly ILiaotianService _liaotianService; public TongjiBaoBiaoController(ILogger<TongjiBaoBiaoController> logger , IAdmAttendanceRuleService attendanceRuleService , IUserService userService , IAdmSigninService signinService , IAdmAttendanceService admAttendanceService , IAdmAttendanceDtlService admAttendanceDtlService , IHrSalaryService hrSalaryService , IHrJibengongziService JibengongziService , ISimService simService , IDailyManagementService DailyManageService , IAdmBreakPrecedentService admBreakPrecedentService , IHrJixiaotichengService hrJixiaotichengService , IFiPiecerateService fiPiecerateService , IAdmPieceCheckService admPieceCheckService , ICooperOrderService cooperOrderService , ICooperatecustomCustomerService cooperatecustomCustomerService , IGroupTopicService groupTopicService , ICooperVisitService cooperVisitService , IIntentionCustomerService intentionCustomerService , IIntentionVisitService intentionVisitService , IDtChannelArticleNewsService dtChannelArticleNewsService , IProjectService projectService , ICusFangwenjiluService cusFangwenjiluService ,ILiaotianService liaotianService) { _logger = logger; _attendanceRuleService = attendanceRuleService; _userService = userService; _signinService = signinService; _admAttendanceService = admAttendanceService; _admAttendanceDtlService = admAttendanceDtlService; _hrSalaryService = hrSalaryService; _JibengongziService = JibengongziService; _simService = simService; _DailyManageService = DailyManageService; _admBreakPrecedentService = admBreakPrecedentService; _hrJixiaotichengService = hrJixiaotichengService; _fiPiecerateService = fiPiecerateService; _admPieceCheckService = admPieceCheckService; _cooperOrderService = cooperOrderService; _cooperatecustomCustomerService = cooperatecustomCustomerService; _groupTopicService = groupTopicService; _cooperVisitService = cooperVisitService; _intentionCustomerService = intentionCustomerService; _intentionVisitService = intentionVisitService; _dtChannelArticleNewsService = dtChannelArticleNewsService; _projectService = projectService; _cusFangwenjiluService = cusFangwenjiluService; _liaotianService = liaotianService; } public IActionResult Index() { var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User")); ViewData["curentuser"] = curentuser; DateTime dateminkaoqin = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); DateTime datemaxkaoqin = dateminkaoqin.AddMonths(1); int Yingchuqin = 0; int Offdays = 0; //是否上班日期 AdmAttendanceRuleDTO admAttendanceRuleDTO = _attendanceRuleService.Get(""); var admAttendanceRulesDtlDTOs = _attendanceRuleService.GetDtlList(""); var jiejiari = admAttendanceRulesDtlDTOs.Where(x => x.Name == "jiejiari").ToList(); var tiaoxiuri = admAttendanceRulesDtlDTOs.Where(x => x.Name == "tiaoxiuri").ToList(); List<FiPiecerateDTO> fiPiecerateDTOs = _fiPiecerateService.GetList(); List<HrJixiaotichengDTO> hrJixiaotichengDTOs = _hrJixiaotichengService.GetList().Where(x => x.Effecttime < datemaxkaoqin).ToList(); var hrJixiaotichengThis = hrJixiaotichengDTOs.Where(x => x.PostId == curentuser.HrPosition).ToList(); //计算每月工作日 while (dateminkaoqin < datemaxkaoqin) { _logger.LogInformation("dateminkaoqin " + dateminkaoqin); //bool iswork = false; if ((int)dateminkaoqin.DayOfWeek >= admAttendanceRuleDTO.WeekStart && (int)dateminkaoqin.DayOfWeek <= admAttendanceRuleDTO.WeekEnd) { //是否节假日 if (jiejiari.Exists(x => x.ValueStart <= dateminkaoqin && x.ValueEnd >= dateminkaoqin)) { Offdays += 1; } else { Yingchuqin += 1; //iswork = true; } } else { //是否调休日 调休日需要上班 if (tiaoxiuri.Exists(x => x.ValueStart <= dateminkaoqin.Date && x.ValueEnd >= dateminkaoqin.Date)) { Yingchuqin += 1; //iswork = true; } else { Offdays += 1; } } dateminkaoqin = dateminkaoqin.AddDays(1); } dateminkaoqin = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1); List<TongjiBaoBiaoDTO> tuiguangDTOs = new List<TongjiBaoBiaoDTO>(); #region 采购项目录入 TongjiBaoBiaoDTO xiangmuDTO = new TongjiBaoBiaoDTO(); xiangmuDTO.gongzuo = "采购项目录入"; //本月数量 var projectDTOsyue = _projectService.GetListsalary(curentuser.Id, dateminkaoqin, datemaxkaoqin); xiangmuDTO.benyueshuliang = projectDTOsyue.Count.ToString(); //本日数量 var projectDTOsri = projectDTOsyue.Where(x => x.Createtime >= DateTime.Now.Date && x.Createtime < DateTime.Now.Date.AddDays(1)).ToList(); xiangmuDTO.benrishuliang = projectDTOsri.Count.ToString(); var jijianixiangmu = fiPiecerateDTOs.Where(x => x.Project == "采购项目录入").FirstOrDefault(); if (jijianixiangmu != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianixiangmu.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { //本月规定 xiangmuDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); //本日规定 xiangmuDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = projectDTOsri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { xiangmuDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { //本月规定 xiangmuDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } tuiguangDTOs.Add(xiangmuDTO); #endregion #region 客户资料录入 TongjiBaoBiaoDTO kehuluruDTO = new TongjiBaoBiaoDTO(); kehuluruDTO.gongzuo = "客户资料录入"; //本月数量 var intentionCustomerDTOsyue = _intentionCustomerService.GetListsalary(curentuser.Id, dateminkaoqin, datemaxkaoqin); kehuluruDTO.benyueshuliang = intentionCustomerDTOsyue.Count .ToString(); //本日数量 var intentionCustomerDTOsri = intentionCustomerDTOsyue.Where(x => x.Createtime >= DateTime.Now.Date && x.Createtime < DateTime.Now.Date.AddDays(1)).ToList(); kehuluruDTO.benrishuliang = intentionCustomerDTOsri.Count.ToString(); var jijianikehuluru = fiPiecerateDTOs.Where(x => x.Project == "客户资料录入").FirstOrDefault(); if (jijianikehuluru != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianikehuluru.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { kehuluruDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); kehuluruDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = intentionCustomerDTOsri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { kehuluruDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { kehuluruDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = intentionCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } tuiguangDTOs.Add(kehuluruDTO); #endregion #region 新加群组 TongjiBaoBiaoDTO qunzuDTO = new TongjiBaoBiaoDTO(); qunzuDTO.gongzuo = "新加群组"; //本月数量 var groupTopicDTOsyue = _groupTopicService.GetListsalary(curentuser.Id, dateminkaoqin, datemaxkaoqin); qunzuDTO.benyueshuliang = groupTopicDTOsyue.Count.ToString(); //本日数量 var groupTopicDTOsri = groupTopicDTOsyue.Where(x => x.Createtime >= DateTime.Now.Date && x.Createtime < DateTime.Now.Date.AddDays(1)).ToList(); qunzuDTO.benrishuliang = groupTopicDTOsri.Count.ToString(); var jijianixianggroupTopic = fiPiecerateDTOs.Where(x => x.Project == "新加群组").FirstOrDefault(); if (jijianixianggroupTopic != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianixianggroupTopic.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { //本月规定 qunzuDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); //本日规定 qunzuDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = groupTopicDTOsri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { qunzuDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { //本月规定 qunzuDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } tuiguangDTOs.Add(qunzuDTO); #endregion #region 电话推广 TongjiBaoBiaoDTO dianhuatuiguangDTO = new TongjiBaoBiaoDTO(); dianhuatuiguangDTO.gongzuo = "电话推广"; //本月数量 var intentionVisitDTOsyue = _intentionVisitService.GetListsalary(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.VisType == "01").ToList(); dianhuatuiguangDTO.benyueshuliang = intentionVisitDTOsyue.Count.ToString(); //本日数量 var intentionVisitDTOsri = intentionVisitDTOsyue.Where(x => x.Vistime >= DateTime.Now.Date && x.Vistime < DateTime.Now.Date.AddDays(1)).ToList(); dianhuatuiguangDTO.benrishuliang = intentionVisitDTOsri.Count.ToString(); var jijianixiangdianhuatuiguang = fiPiecerateDTOs.Where(x => x.Project == "电话推广").FirstOrDefault(); if (jijianixiangdianhuatuiguang != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianixiangdianhuatuiguang.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { //本月规定 dianhuatuiguangDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); //本日规定 dianhuatuiguangDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = intentionVisitDTOsri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { dianhuatuiguangDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { //本月规定 dianhuatuiguangDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } tuiguangDTOs.Add(dianhuatuiguangDTO); #endregion #region 添加微信客户 TongjiBaoBiaoDTO weixnDTO = new TongjiBaoBiaoDTO(); weixnDTO.gongzuo = "添加微信客户"; //本月数量 var cooperweixinDTOsyue = _cooperatecustomCustomerService.GetListsalaryweixin(curentuser.Id, dateminkaoqin, datemaxkaoqin); var intentionweixinDTOsyue = _intentionCustomerService.GetListsalaryweixin(curentuser.Id, dateminkaoqin, datemaxkaoqin); weixnDTO.benyueshuliang = (cooperweixinDTOsyue.Count + intentionweixinDTOsyue.Count).ToString(); //本日数量 var cooperweixinDTOsri = cooperweixinDTOsyue.Where(x => x.Weixintime >= DateTime.Now.Date && x.Weixintime < DateTime.Now.Date.AddDays(1)).ToList(); var intentionweixinDTOsri = intentionweixinDTOsyue.Where(x => x.Weixintime >= DateTime.Now.Date && x.Weixintime < DateTime.Now.Date.AddDays(1)).ToList(); weixnDTO.benrishuliang = (cooperweixinDTOsri.Count + intentionweixinDTOsri.Count).ToString(); var jijianiweixn = fiPiecerateDTOs.Where(x => x.Project == "添加微信客户").FirstOrDefault(); if (jijianiweixn != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianiweixn.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { weixnDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); weixnDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = cooperweixinDTOsri.Count + intentionweixinDTOsyue.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { weixnDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { weixnDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } tuiguangDTOs.Add(weixnDTO); #endregion #region 群发短信 TongjiBaoBiaoDTO duanxinDTO = new TongjiBaoBiaoDTO(); duanxinDTO.gongzuo = "群发短信"; //本月数量 var duanxinsyue = _cusFangwenjiluService.GetListsalary(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.Fasongfangshi == "01").ToList(); duanxinDTO.benyueshuliang = duanxinsyue.Count.ToString(); //本日数量 var duanxinsri = duanxinsyue.Where(x => x.Createtime >= DateTime.Now.Date && x.Createtime < DateTime.Now.Date.AddDays(1)).ToList(); duanxinDTO.benrishuliang = duanxinsri.Count.ToString(); var jijianiduanxin = fiPiecerateDTOs.Where(x => x.Project == "群发短信").FirstOrDefault(); if (jijianiduanxin != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianiduanxin.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { duanxinDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); duanxinDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = duanxinsri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { duanxinDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { duanxinDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } tuiguangDTOs.Add(duanxinDTO); #endregion #region 商业信函推广 TongjiBaoBiaoDTO xinhanDTO = new TongjiBaoBiaoDTO(); xinhanDTO.gongzuo = "商业信函推广"; var jijianixinhan = fiPiecerateDTOs.Where(x => x.Project == "商业信函推广").FirstOrDefault(); if (jijianixinhan != null) { //本月数量 var xinhansyue = _admPieceCheckService.GetList(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianixinhan.Id).ToList(); xinhanDTO.benyueshuliang =(xinhansyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); //本日数量 var xinhansri = xinhansyue.Where(x => x.WorkTime >= DateTime.Now.Date && x.WorkTime < DateTime.Now.Date.AddDays(1)).ToList(); xinhanDTO.benrishuliang = (xinhansri.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); xinhanDTO.dangrijixiao = (xinhansri.Sum(x => x.Gongzi) ?? 0).ToString("0.##"); var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianixinhan.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { xinhanDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); xinhanDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = (xinhansri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value; // if (youxiaojijian > 0) // { // xinhanDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString(); // } //} } else if (jixiaotichengfangan.Renwustandard == "02") { xinhanDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } tuiguangDTOs.Add(xinhanDTO); #endregion #region 群发邮件 TongjiBaoBiaoDTO youjianDTO = new TongjiBaoBiaoDTO(); youjianDTO.gongzuo = "群发邮件"; //本月数量 var youjiansyue = _cusFangwenjiluService.GetListsalary(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.Fasongfangshi == "02").ToList(); youjianDTO.benyueshuliang = youjiansyue.Count.ToString(); //本日数量 var youjiansri = youjiansyue.Where(x => x.Createtime >= DateTime.Now.Date && x.Createtime < DateTime.Now.Date.AddDays(1)).ToList(); youjianDTO.benrishuliang = youjiansri.Count.ToString(); var jijianiyoujian = fiPiecerateDTOs.Where(x => x.Project == "群发邮件").FirstOrDefault(); if (jijianiyoujian != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianiyoujian.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { youjianDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); youjianDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = youjiansri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { youjianDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { youjianDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } tuiguangDTOs.Add(youjianDTO); #endregion #region 群组推广 TongjiBaoBiaoDTO qunzutuiguangDTO = new TongjiBaoBiaoDTO(); qunzutuiguangDTO.gongzuo = "群组推广"; var jijianiqunzutuiguang = fiPiecerateDTOs.Where(x => x.Project == "群组推广").FirstOrDefault(); if (jijianiqunzutuiguang != null) { //本月数量 var qunzutuiguangsyue = _admPieceCheckService.GetList(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianiqunzutuiguang.Id).ToList(); qunzutuiguangDTO.benyueshuliang = (qunzutuiguangsyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); //本日数量 var qunzutuiguangsri = qunzutuiguangsyue.Where(x => x.WorkTime >= DateTime.Now.Date && x.WorkTime < DateTime.Now.Date.AddDays(1)).ToList(); qunzutuiguangDTO.benrishuliang = (qunzutuiguangsri.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); qunzutuiguangDTO.dangrijixiao = (qunzutuiguangsri.Sum(x => x.Gongzi) ?? 0).ToString("0.##"); var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianiqunzutuiguang.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { qunzutuiguangDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); qunzutuiguangDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = (qunzutuiguangsri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value; // if (youxiaojijian > 0) // { // qunzutuiguangDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString(); // } //} } else if (jixiaotichengfangan.Renwustandard == "02") { qunzutuiguangDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } tuiguangDTOs.Add(qunzutuiguangDTO); #endregion #region 朋友圈原创 TongjiBaoBiaoDTO pengyouquanDTO = new TongjiBaoBiaoDTO(); pengyouquanDTO.gongzuo = "朋友圈原创"; var jijianipengyouquan = fiPiecerateDTOs.Where(x => x.Project == "朋友圈原创").FirstOrDefault(); if (jijianipengyouquan != null) { //本月数量 var pengyouquansyue = _admPieceCheckService.GetList(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianipengyouquan.Id).ToList(); pengyouquanDTO.benyueshuliang = (pengyouquansyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); //本日数量 var pengyouquansri = pengyouquansyue.Where(x => x.WorkTime >= DateTime.Now.Date && x.WorkTime < DateTime.Now.Date.AddDays(1)).ToList(); pengyouquanDTO.benrishuliang = (pengyouquansri.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); pengyouquanDTO.dangrijixiao = (pengyouquansri.Sum(x => x.Gongzi) ?? 0).ToString("0.##"); var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianipengyouquan.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { pengyouquanDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); pengyouquanDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = (pengyouquansri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value; // if (youxiaojijian > 0) // { // pengyouquanDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString(); // } //} } else if (jixiaotichengfangan.Renwustandard == "02") { pengyouquanDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } tuiguangDTOs.Add(pengyouquanDTO); #endregion #region 论坛发帖 TongjiBaoBiaoDTO luntanfatieDTO = new TongjiBaoBiaoDTO(); luntanfatieDTO.gongzuo = "论坛发帖"; var jijianiluntanfatie = fiPiecerateDTOs.Where(x => x.Project == "论坛发帖").FirstOrDefault(); if (jijianiluntanfatie != null) { //本月数量 var luntanfatiesyue = _admPieceCheckService.GetList(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianiluntanfatie.Id).ToList(); luntanfatieDTO.benyueshuliang = (luntanfatiesyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); //本日数量 var luntanfatiesri = luntanfatiesyue.Where(x => x.WorkTime >= DateTime.Now.Date && x.WorkTime < DateTime.Now.Date.AddDays(1)).ToList(); luntanfatieDTO.benrishuliang = (luntanfatiesri.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); luntanfatieDTO.dangrijixiao = (luntanfatiesri.Sum(x => x.Gongzi) ?? 0).ToString("0.##"); var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianiluntanfatie.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { luntanfatieDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); luntanfatieDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = (luntanfatiesri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value; // if (youxiaojijian > 0) // { // luntanfatieDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString(); // } //} } else if (jixiaotichengfangan.Renwustandard == "02") { luntanfatieDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } tuiguangDTOs.Add(luntanfatieDTO); #endregion #region 跟帖评论 TongjiBaoBiaoDTO gentiepinglunDTO = new TongjiBaoBiaoDTO(); gentiepinglunDTO.gongzuo = "跟帖评论"; var jijianigentiepinglun = fiPiecerateDTOs.Where(x => x.Project == "跟帖评论").FirstOrDefault(); if (jijianigentiepinglun != null) { //本月数量 var gentiepinglunsyue = _admPieceCheckService.GetList(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianigentiepinglun.Id).ToList(); gentiepinglunDTO.benyueshuliang = (gentiepinglunsyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); //本日数量 var gentiepinglunsri = gentiepinglunsyue.Where(x => x.WorkTime >= DateTime.Now.Date && x.WorkTime < DateTime.Now.Date.AddDays(1)).ToList(); gentiepinglunDTO.benrishuliang = (gentiepinglunsri.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); gentiepinglunDTO.dangrijixiao = (gentiepinglunsri.Sum(x => x.Gongzi) ?? 0).ToString("0.##"); var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianigentiepinglun.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { gentiepinglunDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); gentiepinglunDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = (gentiepinglunsri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value; // if (youxiaojijian > 0) // { // gentiepinglunDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString(); // } //} } else if (jixiaotichengfangan.Renwustandard == "02") { gentiepinglunDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } tuiguangDTOs.Add(gentiepinglunDTO); #endregion #region 转发微信微博 TongjiBaoBiaoDTO zhuanfaDTO = new TongjiBaoBiaoDTO(); zhuanfaDTO.gongzuo = "转发微信微博"; var jijianizhuanfa = fiPiecerateDTOs.Where(x => x.Project == "转发微信微博").FirstOrDefault(); if (jijianizhuanfa != null) { //本月数量 var zhuanfasyue = _admPieceCheckService.GetList(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianizhuanfa.Id).ToList(); zhuanfaDTO.benyueshuliang = (zhuanfasyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); //本日数量 var zhuanfasri = zhuanfasyue.Where(x => x.WorkTime >= DateTime.Now.Date && x.WorkTime < DateTime.Now.Date.AddDays(1)).ToList(); zhuanfaDTO.benrishuliang = (zhuanfasri.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); zhuanfaDTO.dangrijixiao = (zhuanfasri.Sum(x => x.Gongzi) ?? 0).ToString("0.##"); var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianizhuanfa.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { zhuanfaDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); zhuanfaDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = (zhuanfasri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value; // if (youxiaojijian > 0) // { // zhuanfaDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString(); // } //} } else if (jixiaotichengfangan.Renwustandard == "02") { zhuanfaDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } tuiguangDTOs.Add(zhuanfaDTO); #endregion #region 新增意向客户(订单) TongjiBaoBiaoDTO yixiangDTO = new TongjiBaoBiaoDTO(); yixiangDTO.gongzuo = "新增意向客户(订单)"; //本月数量 var yixiangsyue = _intentionCustomerService.GetListsalaryyixiang(curentuser.Id, dateminkaoqin, datemaxkaoqin).ToList(); yixiangDTO.benyueshuliang = yixiangsyue.Count.ToString(); //本日数量 var yixiangsri = yixiangsyue.Where(x => x.Yixiangtime >= DateTime.Now.Date && x.Yixiangtime < DateTime.Now.Date.AddDays(1)).ToList(); yixiangDTO.benrishuliang = yixiangsri.Count.ToString(); var jijianiyixiang = fiPiecerateDTOs.Where(x => x.Project == "新增意向客户(订单)").FirstOrDefault(); if (jijianiyixiang != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianiyixiang.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { yixiangDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); yixiangDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = yixiangsri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { yixiangDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { yixiangDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } tuiguangDTOs.Add(yixiangDTO); #endregion #region 新增注册会员 TongjiBaoBiaoDTO zhucehuiyuanDTO = new TongjiBaoBiaoDTO(); zhucehuiyuanDTO.gongzuo = "新增注册会员"; var jijianizhucehuiyuan = fiPiecerateDTOs.Where(x => x.Project == "新增注册会员").FirstOrDefault(); if (jijianizhucehuiyuan != null) { //本月数量 var zhucehuiyuansyue = _admPieceCheckService.GetList(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianizhucehuiyuan.Id).ToList(); zhucehuiyuanDTO.benyueshuliang = (zhucehuiyuansyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); //本日数量 var zhucehuiyuansri = zhucehuiyuansyue.Where(x => x.WorkTime >= DateTime.Now.Date && x.WorkTime < DateTime.Now.Date.AddDays(1)).ToList(); zhucehuiyuanDTO.benrishuliang = (zhucehuiyuansri.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); zhucehuiyuanDTO.dangrijixiao = (zhucehuiyuansri.Sum(x => x.Gongzi) ?? 0).ToString("0.##"); var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianizhucehuiyuan.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { zhucehuiyuanDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); zhucehuiyuanDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = (zhucehuiyuansri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value; // if (youxiaojijian > 0) // { // zhucehuiyuanDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString(); // } //} } else if (jixiaotichengfangan.Renwustandard == "02") { zhucehuiyuanDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } tuiguangDTOs.Add(zhucehuiyuanDTO); #endregion #region 新增签约客户 TongjiBaoBiaoDTO qianyueDTO = new TongjiBaoBiaoDTO(); qianyueDTO.gongzuo = "新增签约客户"; //本月数量 var qianyueDTOsyue = _cooperatecustomCustomerService.GetListsalary(curentuser.Id, dateminkaoqin, datemaxkaoqin); qianyueDTO.benyueshuliang = qianyueDTOsyue.Count.ToString(); //本日数量 var qianyueDTOsri = qianyueDTOsyue.Where(x => x.Createtime >= DateTime.Now.Date && x.Createtime < DateTime.Now.Date.AddDays(1)).ToList(); qianyueDTO.benrishuliang = qianyueDTOsri.Count .ToString(); var jijianiqianyue = fiPiecerateDTOs.Where(x => x.Project == "新增签约客户").FirstOrDefault(); if (jijianiqianyue != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianiqianyue.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { qianyueDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); qianyueDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = qianyueDTOsri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { qianyueDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { qianyueDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = qianyueDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } tuiguangDTOs.Add(qianyueDTO); #endregion List<TongjiBaoBiaoDTO> baifangkehuDTOs = new List<TongjiBaoBiaoDTO>(); #region 上门拜访客户 TongjiBaoBiaoDTO shangmenbanfangDTO = new TongjiBaoBiaoDTO(); shangmenbanfangDTO.gongzuo = "上门拜访客户"; //本月数量 var shangmenbanfangDTOsyue = _intentionVisitService.GetListsalary(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.VisType == "02").ToList(); var shangmenbanfangcooperDTOsyue = _cooperVisitService.GetListsalary(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.VisType == "02").ToList(); shangmenbanfangDTO.benyueshuliang = (shangmenbanfangcooperDTOsyue.Count + shangmenbanfangDTOsyue.Count).ToString(); //本日数量 var shangmenbanfangDTOsri = shangmenbanfangDTOsyue.Where(x => x.Vistime >= DateTime.Now.Date && x.Vistime < DateTime.Now.Date.AddDays(1)).ToList(); var shangmenbanfangcooperDTOsri = shangmenbanfangcooperDTOsyue.Where(x => x.Vistime >= DateTime.Now.Date && x.Vistime < DateTime.Now.Date.AddDays(1)).ToList(); shangmenbanfangDTO.benrishuliang = (shangmenbanfangcooperDTOsri.Count + shangmenbanfangDTOsri.Count).ToString(); var jijianixiangshangmenbanfang = fiPiecerateDTOs.Where(x => x.Project == "上门拜访客户").FirstOrDefault(); if (jijianixiangshangmenbanfang != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianixiangshangmenbanfang.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { //本月规定 shangmenbanfangDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); //本日规定 shangmenbanfangDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = shangmenbanfangcooperDTOsri.Count + shangmenbanfangDTOsri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { shangmenbanfangDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { //本月规定 shangmenbanfangDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } baifangkehuDTOs.Add(shangmenbanfangDTO); #endregion #region 接待来访客户 TongjiBaoBiaoDTO jiedailaifangDTO = new TongjiBaoBiaoDTO(); jiedailaifangDTO.gongzuo = "接待来访客户"; var jijianijiedailaifang = fiPiecerateDTOs.Where(x => x.Project == "接待来访客户").FirstOrDefault(); if (jijianijiedailaifang != null) { //本月数量 var jiedailaifangsyue = _admPieceCheckService.GetList(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianijiedailaifang.Id).ToList(); jiedailaifangDTO.benyueshuliang = (jiedailaifangsyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); //本日数量 var jiedailaifangsri = jiedailaifangsyue.Where(x => x.WorkTime >= DateTime.Now.Date && x.WorkTime < DateTime.Now.Date.AddDays(1)).ToList(); jiedailaifangDTO.benrishuliang = (jiedailaifangsri.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); jiedailaifangDTO.dangrijixiao = (jiedailaifangsri.Sum(x => x.Gongzi) ?? 0).ToString("0.##"); var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianijiedailaifang.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { jiedailaifangDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); jiedailaifangDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = (jiedailaifangsri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value; // if (youxiaojijian > 0) // { // jiedailaifangDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString(); // } //} } else if (jixiaotichengfangan.Renwustandard == "02") { jiedailaifangDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } baifangkehuDTOs.Add(jiedailaifangDTO); #endregion List<TongjiDingDanDTO> dingdanDTOs = new List<TongjiDingDanDTO>(); #region 新增订单 //本月数量 var dingdanDTOsyue = _cooperOrderService.GetListtongji(curentuser.Id, dateminkaoqin, datemaxkaoqin); var benyuezonge = dingdanDTOsyue.Sum(x => x.Money) ?? 0; //本日数量 var dingdanDTOsri = dingdanDTOsyue.Where(x => x.Createtime >= DateTime.Now.Date && x.Createtime < DateTime.Now.Date.AddDays(1)).ToList(); foreach (var cooperOrderDTO in dingdanDTOsri) { TongjiDingDanDTO dingdanDTO = new TongjiDingDanDTO(); dingdanDTO.dingdanbianhao = cooperOrderDTO.OrderNo; dingdanDTO.dingdanmingcheng = cooperOrderDTO.OrderTypeName+"-"+ cooperOrderDTO.OrderType1Name + (string.IsNullOrEmpty(cooperOrderDTO.OrderType2)?"":"-"+ cooperOrderDTO.OrderType2); dingdanDTO.danjia = cooperOrderDTO.Price.Value.ToString("0.##"); dingdanDTO.shuliang = cooperOrderDTO.OrderNum.Value.ToString("0.##"); dingdanDTO.jine = cooperOrderDTO.Money.Value.ToString("0.##"); dingdanDTO.benyueleijijine = benyuezonge.ToString("0.##"); dingdanDTOs.Add(dingdanDTO); } if (dingdanDTOs.Count == 0) { TongjiDingDanDTO dingdanDTO = new TongjiDingDanDTO(); dingdanDTO.benyueleijijine = benyuezonge.ToString("0.##"); dingdanDTOs.Add(dingdanDTO); } #endregion List<TongjiBaoBiaoDTO> ziliaoweihuDTOs = new List<TongjiBaoBiaoDTO>(); #region 新闻资讯 TongjiBaoBiaoDTO xinwenzixunDTO = new TongjiBaoBiaoDTO(); xinwenzixunDTO.gongzuo = "新闻资讯"; //本月数量 DtChannelArticleNewsDTOSearch searchEntity = new DtChannelArticleNewsDTOSearch(); searchEntity.EndTime = datemaxkaoqin; searchEntity.AddTime = dateminkaoqin; searchEntity.UserName = curentuser.UserSn; searchEntity.CategoryId = 3; var dtChannelArticleNewsDTOs = _dtChannelArticleNewsService.GetList(searchEntity); xinwenzixunDTO.benyueshuliang = dtChannelArticleNewsDTOs.Count.ToString(); //本日数量 var xinwenzixunsri = dtChannelArticleNewsDTOs.Where(x => x.AddTime >= DateTime.Now.Date && x.AddTime < DateTime.Now.Date.AddDays(1)).ToList(); xinwenzixunDTO.benrishuliang = xinwenzixunsri.Count.ToString(); var jijianixinwenzixun = fiPiecerateDTOs.Where(x => x.Project == "新闻资讯").FirstOrDefault(); if (jijianixinwenzixun != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianixinwenzixun.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { xinwenzixunDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); xinwenzixunDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = xinwenzixunsri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { xinwenzixunDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { xinwenzixunDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } ziliaoweihuDTOs.Add(xinwenzixunDTO); #endregion #region 典型案例 TongjiBaoBiaoDTO dianxinanliDTO = new TongjiBaoBiaoDTO(); dianxinanliDTO.gongzuo = "典型案例"; //本月数量 searchEntity = new DtChannelArticleNewsDTOSearch(); searchEntity.EndTime = datemaxkaoqin; searchEntity.AddTime = dateminkaoqin; searchEntity.UserName = curentuser.UserSn; searchEntity.CategoryId = 85; var dianxinanDTOs = _dtChannelArticleNewsService.GetList(searchEntity); dianxinanliDTO.benyueshuliang = dianxinanDTOs.Count.ToString(); //本日数量 var dianxinanlisri = dianxinanDTOs.Where(x => x.AddTime >= DateTime.Now.Date && x.AddTime < DateTime.Now.Date.AddDays(1)).ToList(); dianxinanliDTO.benrishuliang = dianxinanlisri.Count.ToString(); var jijianidianxinanli = fiPiecerateDTOs.Where(x => x.Project == "典型案例").FirstOrDefault(); if (jijianidianxinanli != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianidianxinanli.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { dianxinanliDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); dianxinanliDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = dianxinanlisri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { dianxinanliDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { dianxinanliDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } ziliaoweihuDTOs.Add(dianxinanliDTO); #endregion #region 政采知识 TongjiBaoBiaoDTO zhengcaizhishiDTO = new TongjiBaoBiaoDTO(); zhengcaizhishiDTO.gongzuo = "政采知识"; //本月数量 searchEntity = new DtChannelArticleNewsDTOSearch(); searchEntity.EndTime = datemaxkaoqin; searchEntity.AddTime = dateminkaoqin; searchEntity.UserName = curentuser.UserSn; searchEntity.CategoryId = 73; var zhengcaizhishiDTOs = _dtChannelArticleNewsService.GetList(searchEntity); zhengcaizhishiDTO.benyueshuliang = zhengcaizhishiDTOs.Count.ToString(); //本日数量 var zhengcaizhishisri = zhengcaizhishiDTOs.Where(x => x.AddTime >= DateTime.Now.Date && x.AddTime < DateTime.Now.Date.AddDays(1)).ToList(); zhengcaizhishiDTO.benrishuliang = zhengcaizhishisri.Count.ToString(); var jijianizhengcaizhishi = fiPiecerateDTOs.Where(x => x.Project == "政采知识").FirstOrDefault(); if (jijianizhengcaizhishi != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianizhengcaizhishi.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { zhengcaizhishiDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); zhengcaizhishiDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = zhengcaizhishisri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { zhengcaizhishiDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { zhengcaizhishiDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } ziliaoweihuDTOs.Add(zhengcaizhishiDTO); #endregion #region 新增公众号关注 TongjiBaoBiaoDTO gongzhonghaoDTO = new TongjiBaoBiaoDTO(); gongzhonghaoDTO.gongzuo = "新增公众号关注"; var jijianigongzhonghao = fiPiecerateDTOs.Where(x => x.Project == "新增公众号关注").FirstOrDefault(); if (jijianigongzhonghao != null) { //本月数量 var gongzhonghaosyue = _admPieceCheckService.GetList(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianigongzhonghao.Id).ToList(); gongzhonghaoDTO.benyueshuliang = (gongzhonghaosyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); //本日数量 var gongzhonghaosri = gongzhonghaosyue.Where(x => x.WorkTime >= DateTime.Now.Date && x.WorkTime < DateTime.Now.Date.AddDays(1)).ToList(); gongzhonghaoDTO.benrishuliang = (gongzhonghaosri.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); gongzhonghaoDTO.dangrijixiao = (gongzhonghaosri.Sum(x => x.Gongzi) ?? 0).ToString("0.##"); var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianigongzhonghao.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { gongzhonghaoDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); gongzhonghaoDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = (gongzhonghaosri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value; // if (youxiaojijian > 0) // { // gongzhonghaoDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString(); // } //} } else if (jixiaotichengfangan.Renwustandard == "02") { gongzhonghaoDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } ziliaoweihuDTOs.Add(gongzhonghaoDTO); #endregion #region 网页制作 TongjiBaoBiaoDTO wangyeDTO = new TongjiBaoBiaoDTO(); wangyeDTO.gongzuo = "网页制作"; var jijianiwangye = fiPiecerateDTOs.Where(x => x.Project == "网页制作").FirstOrDefault(); if (jijianiwangye != null) { //本月数量 var wangyesyue = _admPieceCheckService.GetList(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianiwangye.Id).ToList(); wangyeDTO.benyueshuliang = (wangyesyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); //本日数量 var wangyesri = wangyesyue.Where(x => x.WorkTime >= DateTime.Now.Date && x.WorkTime < DateTime.Now.Date.AddDays(1)).ToList(); wangyeDTO.benrishuliang = (wangyesri.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); wangyeDTO.dangrijixiao = (wangyesri.Sum(x => x.Gongzi) ?? 0).ToString("0.##"); var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianiwangye.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { wangyeDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); wangyeDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = (wangyesri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value; // if (youxiaojijian > 0) // { // wangyeDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString(); // } //} } else if (jixiaotichengfangan.Renwustandard == "02") { wangyeDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } ziliaoweihuDTOs.Add(wangyeDTO); #endregion #region 新增小采问题 TongjiBaoBiaoDTO xinzengwendaDTO = new TongjiBaoBiaoDTO(); xinzengwendaDTO.gongzuo = "新增小采问题"; //本月数量 var xinzengwendaDTOsyue = _liaotianService.GetListsalary(curentuser.Id, dateminkaoqin, datemaxkaoqin); xinzengwendaDTO.benyueshuliang = xinzengwendaDTOsyue.Count.ToString(); //本日数量 var xinzengwendaDTOsri = xinzengwendaDTOsyue.Where(x => x.Createtime >= DateTime.Now.Date && x.Createtime < DateTime.Now.Date.AddDays(1)).ToList(); xinzengwendaDTO.benrishuliang = xinzengwendaDTOsri.Count.ToString(); var jijianixinzengwenda = fiPiecerateDTOs.Where(x => x.Project == "新增小采问题").FirstOrDefault(); if (jijianixinzengwenda != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianixinzengwenda.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { xinzengwendaDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); xinzengwendaDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = xinzengwendaDTOsri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { xinzengwendaDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { xinzengwendaDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = xinzengwendaDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } ziliaoweihuDTOs.Add(xinzengwendaDTO); #endregion #region 审核小采答问 TongjiBaoBiaoDTO shenhewendaDTO = new TongjiBaoBiaoDTO(); shenhewendaDTO.gongzuo = "审核小采答问"; //本月数量 var shenhewendaDTOsyue = _liaotianService.GetListsalaryshenhe(curentuser.Id, dateminkaoqin, datemaxkaoqin); shenhewendaDTO.benyueshuliang = shenhewendaDTOsyue.Count.ToString(); //本日数量 var shenhewendaDTOsri = shenhewendaDTOsyue.Where(x => x.Shenhetime >= DateTime.Now.Date && x.Shenhetime < DateTime.Now.Date.AddDays(1)).ToList(); shenhewendaDTO.benrishuliang = shenhewendaDTOsri.Count.ToString(); var jijianishenhewenda = fiPiecerateDTOs.Where(x => x.Project == "审核小采答问").FirstOrDefault(); if (jijianishenhewenda != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianishenhewenda.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { shenhewendaDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); shenhewendaDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = shenhewendaDTOsri.Count - jixiaotichengfangan.Renwu.Value; if (youxiaojijian > 0) { shenhewendaDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##"); } } } else if (jixiaotichengfangan.Renwustandard == "02") { shenhewendaDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = shenhewendaDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } ziliaoweihuDTOs.Add(shenhewendaDTO); #endregion List<TongjiBaoBiaoDTO> xiangmushishiDTOs = new List<TongjiBaoBiaoDTO>(); #region 标书制作 TongjiBaoBiaoDTO biaoshuzhizuoDTO = new TongjiBaoBiaoDTO(); biaoshuzhizuoDTO.gongzuo = "标书制作"; var jijianibiaoshuzhizuo = fiPiecerateDTOs.Where(x => x.Project == "标书制作").FirstOrDefault(); if (jijianibiaoshuzhizuo != null) { //本月数量 var biaoshuzhizuosyue = _admPieceCheckService.GetList(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianibiaoshuzhizuo.Id).ToList(); biaoshuzhizuoDTO.benyueshuliang = (biaoshuzhizuosyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); //本日数量 var biaoshuzhizuosri = biaoshuzhizuosyue.Where(x => x.WorkTime >= DateTime.Now.Date && x.WorkTime < DateTime.Now.Date.AddDays(1)).ToList(); biaoshuzhizuoDTO.benrishuliang = (biaoshuzhizuosri.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); biaoshuzhizuoDTO.dangrijixiao = (biaoshuzhizuosri.Sum(x => x.Gongzi) ?? 0).ToString("0.##"); var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianibiaoshuzhizuo.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { biaoshuzhizuoDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); biaoshuzhizuoDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = (biaoshuzhizuosri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value; // if (youxiaojijian > 0) // { // biaoshuzhizuoDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString(); // } //} } else if (jixiaotichengfangan.Renwustandard == "02") { biaoshuzhizuoDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } xiangmushishiDTOs.Add(biaoshuzhizuoDTO); #endregion #region 标书检查 TongjiBaoBiaoDTO biaoshujianchaDTO = new TongjiBaoBiaoDTO(); biaoshujianchaDTO.gongzuo = "标书检查"; var jijianibiaoshujiancha = fiPiecerateDTOs.Where(x => x.Project == "标书检查").FirstOrDefault(); if (jijianibiaoshujiancha != null) { //本月数量 var biaoshujianchasyue = _admPieceCheckService.GetList(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianibiaoshujiancha.Id).ToList(); biaoshujianchaDTO.benyueshuliang = (biaoshujianchasyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); //本日数量 var biaoshujianchasri = biaoshujianchasyue.Where(x => x.WorkTime >= DateTime.Now.Date && x.WorkTime < DateTime.Now.Date.AddDays(1)).ToList(); biaoshujianchaDTO.benrishuliang = (biaoshujianchasri.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); biaoshujianchaDTO.dangrijixiao = (biaoshujianchasri.Sum(x => x.Gongzi) ?? 0).ToString("0.##"); var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianibiaoshujiancha.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { biaoshujianchaDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); biaoshujianchaDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = (biaoshujianchasri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value; // if (youxiaojijian > 0) // { // biaoshujianchaDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString(); // } //} } else if (jixiaotichengfangan.Renwustandard == "02") { biaoshujianchaDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } xiangmushishiDTOs.Add(biaoshujianchaDTO); #endregion #region 起草质疑投诉 TongjiBaoBiaoDTO zhiyiDTO = new TongjiBaoBiaoDTO(); zhiyiDTO.gongzuo = "起草质疑投诉书"; var jijianizhiyi = fiPiecerateDTOs.Where(x => x.Project == "起草质疑投诉书").FirstOrDefault(); if (jijianizhiyi != null) { //本月数量 var zhiyisyue = _admPieceCheckService.GetList(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianizhiyi.Id).ToList(); zhiyiDTO.benyueshuliang = (zhiyisyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); //本日数量 var zhiyisri = zhiyisyue.Where(x => x.WorkTime >= DateTime.Now.Date && x.WorkTime < DateTime.Now.Date.AddDays(1)).ToList(); zhiyiDTO.benrishuliang = (zhiyisri.Sum(x => x.Shuliang) ?? 0).ToString("0.##"); zhiyiDTO.dangrijixiao = (zhiyisri.Sum(x => x.Gongzi) ?? 0).ToString("0.##"); var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianizhiyi.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { zhiyiDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##"); zhiyiDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = (zhiyisri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value; // if (youxiaojijian > 0) // { // zhiyiDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString(); // } //} } else if (jixiaotichengfangan.Renwustandard == "02") { zhiyiDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ; //if (jixiaotichengfangan.Tichengstandard == "01") //{ // decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } //} } } } xiangmushishiDTOs.Add(zhiyiDTO); #endregion ViewBag.tuiguangDTOs = tuiguangDTOs; ViewBag.baifangkehuDTOs = baifangkehuDTOs; ViewBag.dingdanDTOs = dingdanDTOs; ViewBag.ziliaoweihuDTOs = ziliaoweihuDTOs; ViewBag.xiangmushishiDTOs = xiangmushishiDTOs; return View(); } } } zhengcaioa/zhengcaioa/Startup.cs
@@ -68,7 +68,12 @@ var connectionString = Configuration.GetConnectionString("DefaultConnection"); services.AddDbContext<zhengcaioaContext>(options => options.UseSqlServer(connectionString)); options.UseSqlServer(connectionString)); var connectionString1 = Configuration.GetConnectionString("zcwebConnection"); services.AddDbContext<zcwebContext>(options => options.UseSqlServer(connectionString1)); services.AddControllersWithViews(); services.AddScoped(typeof(ISimService), typeof(SimService)); @@ -139,7 +144,9 @@ services.AddScoped(typeof(IOrderBanciDtlService), typeof(OrderBanciDtlService)); services.AddScoped(typeof(IOrderBanciService), typeof(OrderBanciService)); services.AddScoped(typeof(IOrderBanciOrderService), typeof(OrderBanciOrderService)); //zcweb services.AddScoped(typeof(IDtChannelArticleNewsService), typeof(DtChannelArticleNewsService)); //定时执行 services.AddHostedService<TimedBackgroundService>(); zhengcaioa/zhengcaioa/Timer/TimedBackgroundService.cs
@@ -37,6 +37,10 @@ private readonly ICooperVisitService _cooperVisitService; private readonly IIntentionCustomerService _intentionCustomerService; private readonly IIntentionVisitService _intentionVisitService; private readonly IProjectService _projectService; private readonly ICusFangwenjiluService _cusFangwenjiluService; private readonly ILiaotianService _liaotianService; private readonly IDtChannelArticleNewsService _dtChannelArticleNewsService; private readonly decimal jiabangongzibiaozhun = new decimal(21.5); public TimedBackgroundService(ILogger<TimedBackgroundService> logger, IServiceScopeFactory factory) @@ -61,6 +65,11 @@ _cooperVisitService = factory.CreateScope().ServiceProvider.GetRequiredService<ICooperVisitService>(); _intentionCustomerService = factory.CreateScope().ServiceProvider.GetRequiredService<IIntentionCustomerService>(); _intentionVisitService = factory.CreateScope().ServiceProvider.GetRequiredService<IIntentionVisitService>(); _projectService = factory.CreateScope().ServiceProvider.GetRequiredService<IProjectService>(); _cusFangwenjiluService = factory.CreateScope().ServiceProvider.GetRequiredService<ICusFangwenjiluService>(); _liaotianService = factory.CreateScope().ServiceProvider.GetRequiredService<ILiaotianService>(); _dtChannelArticleNewsService = factory.CreateScope().ServiceProvider.GetRequiredService<IDtChannelArticleNewsService>(); } protected override async Task ExecuteAsync(CancellationToken stoppingToken) { @@ -1574,13 +1583,12 @@ //var feijijiandengji = fiPiecerateDTOs.Where(x => x.Standard == "A"); //var jijiandengji = fiPiecerateDTOs.Where(x => x.Standard == "A"); #region 上门拜访客户 #region 采购项目录入 var cooperVisitDTOs = _cooperVisitService.GetListsalary(userList[i].Id, dateminkaoqin, datemaxkaoqin); var intentionVisitDTOs = _intentionVisitService.GetListsalary(userList[i].Id, dateminkaoqin, datemaxkaoqin); if ( cooperVisitDTOs.Count > 0 || intentionVisitDTOs.Count > 0) var projectDTOsyue = _projectService.GetListsalary(userList[i].Id, dateminkaoqin, datemaxkaoqin); if (projectDTOsyue!=null && projectDTOsyue.Count > 0 ) { var jijianidddd = fiPiecerateDTOs.Where(x => x.Standard == "D" && x.Project == "上门拜访客户").FirstOrDefault(); var jijianidddd = fiPiecerateDTOs.Where(x => x.Project == "采购项目录入").FirstOrDefault(); if (jijianidddd != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianidddd.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); @@ -1591,7 +1599,7 @@ decimal renwujishu = admAttendanceDTO.Yingchuqin * jixiaotichengfangan.Renwu.Value; if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = intentionVisitDTOs.Count + cooperVisitDTOs.Count - renwujishu; decimal youxiaojijian = projectDTOsyue.Count - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); @@ -1605,51 +1613,7 @@ decimal renwujishu = jixiaotichengfangan.Renwu.Value; if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = intentionVisitDTOs.Count + cooperVisitDTOs.Count - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); } } } } } } #endregion #region 新加群组 var groupTopicDTOs = _groupTopicService.GetListsalary(userList[i].Id, dateminkaoqin, datemaxkaoqin); if (groupTopicDTOs != null && groupTopicDTOs.Count > 0) { var jijianidddd = fiPiecerateDTOs.Where(x => x.Standard == "D" && x.Project == "新加群组").FirstOrDefault(); if (jijianidddd != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianidddd.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { decimal renwujishu = admAttendanceDTO.Yingchuqin * jixiaotichengfangan.Renwu.Value; if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = groupTopicDTOs.Count - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); } } } else if (jixiaotichengfangan.Renwustandard == "02") { decimal renwujishu = jixiaotichengfangan.Renwu.Value; if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = groupTopicDTOs.Count - renwujishu; decimal youxiaojijian = projectDTOsyue.Count - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); @@ -1664,58 +1628,11 @@ #endregion #region 客户资料录入 var cooperatecustomCustomerDTOs = _cooperatecustomCustomerService.GetListsalary(userList[i].Id, dateminkaoqin, datemaxkaoqin); var _intentionCustomerDTOs = _intentionCustomerService.GetListsalary(userList[i].Id, dateminkaoqin, datemaxkaoqin); if ( cooperatecustomCustomerDTOs.Count > 0 || _intentionCustomerDTOs.Count > 0) { var jijianidddd = fiPiecerateDTOs.Where(x => x.Standard == "D" && x.Project == "客户资料录入").FirstOrDefault(); if (jijianidddd != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianidddd.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { decimal renwujishu = admAttendanceDTO.Yingchuqin * jixiaotichengfangan.Renwu.Value; if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); } } } else if (jixiaotichengfangan.Renwustandard == "02") { decimal renwujishu = jixiaotichengfangan.Renwu.Value; if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); } } } } } } #endregion #region 录入客户签单 var cooperatecustomCustomers = _cooperatecustomCustomerService.GetListsalaryqiandan(userList[i].Id, dateminkaoqin, datemaxkaoqin); if (cooperatecustomCustomers != null && cooperatecustomCustomers.Count > 0) var _intentionCustomerDTOs = _intentionCustomerService.GetListsalary(userList[i].Id, dateminkaoqin, datemaxkaoqin); if (_intentionCustomerDTOs!=null && _intentionCustomerDTOs.Count > 0) { var jijianidddd = fiPiecerateDTOs.Where(x => x.Standard == "D" && x.Project == "录入客户签单").FirstOrDefault(); var jijianidddd = fiPiecerateDTOs.Where(x => x.Project == "客户资料录入").FirstOrDefault(); if (jijianidddd != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianidddd.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); @@ -1726,7 +1643,7 @@ decimal renwujishu = admAttendanceDTO.Yingchuqin * jixiaotichengfangan.Renwu.Value; if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = cooperatecustomCustomers.Count - renwujishu; decimal youxiaojijian = _intentionCustomerDTOs.Count - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); @@ -1740,7 +1657,7 @@ decimal renwujishu = jixiaotichengfangan.Renwu.Value; if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = cooperatecustomCustomers.Count - renwujishu; decimal youxiaojijian = _intentionCustomerDTOs.Count - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); @@ -1751,6 +1668,599 @@ } } } #endregion #region 新加群组 var groupTopicDTOs = _groupTopicService.GetListsalary(userList[i].Id, dateminkaoqin, datemaxkaoqin); if (groupTopicDTOs != null && groupTopicDTOs.Count > 0) { var jijianidddd = fiPiecerateDTOs.Where(x => x.Project == "新加群组").FirstOrDefault(); if (jijianidddd != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianidddd.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { decimal renwujishu = admAttendanceDTO.Yingchuqin * jixiaotichengfangan.Renwu.Value; if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = groupTopicDTOs.Count - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); } } } else if (jixiaotichengfangan.Renwustandard == "02") { decimal renwujishu = jixiaotichengfangan.Renwu.Value; if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = groupTopicDTOs.Count - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); } } } } } } #endregion #region 电话推广 var intentionVisitDTOs = _intentionVisitService.GetListsalary(userList[i].Id, dateminkaoqin, datemaxkaoqin).Where(x => x.VisType == "01").ToList(); if (intentionVisitDTOs != null && intentionVisitDTOs.Count > 0) { var jijianidddd = fiPiecerateDTOs.Where(x => x.Project == "电话推广").FirstOrDefault(); if (jijianidddd != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianidddd.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { decimal renwujishu = admAttendanceDTO.Yingchuqin * jixiaotichengfangan.Renwu.Value; if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = intentionVisitDTOs.Count - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); } } } else if (jixiaotichengfangan.Renwustandard == "02") { decimal renwujishu = jixiaotichengfangan.Renwu.Value; if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = intentionVisitDTOs.Count - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); } } } } } } #endregion #region 群发短信 var duanxinsyue = _cusFangwenjiluService.GetListsalary(userList[i].Id, dateminkaoqin, datemaxkaoqin).Where(x => x.Fasongfangshi == "01").ToList(); if (duanxinsyue != null && duanxinsyue.Count > 0) { var jijianidddd = fiPiecerateDTOs.Where(x => x.Project == "群发短信").FirstOrDefault(); if (jijianidddd != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianidddd.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { decimal renwujishu = admAttendanceDTO.Yingchuqin * jixiaotichengfangan.Renwu.Value; if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = duanxinsyue.Count - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); } } } else if (jixiaotichengfangan.Renwustandard == "02") { decimal renwujishu = jixiaotichengfangan.Renwu.Value; if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = duanxinsyue.Count - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); } } } } } } #endregion #region 群发邮件 var youjiansyue = _cusFangwenjiluService.GetListsalary(userList[i].Id, dateminkaoqin, datemaxkaoqin).Where(x => x.Fasongfangshi == "02").ToList(); if (youjiansyue != null && youjiansyue.Count > 0) { var jijianidddd = fiPiecerateDTOs.Where(x => x.Project == "群发邮件").FirstOrDefault(); if (jijianidddd != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianidddd.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { decimal renwujishu = admAttendanceDTO.Yingchuqin * jixiaotichengfangan.Renwu.Value; if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = youjiansyue.Count - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); } } } else if (jixiaotichengfangan.Renwustandard == "02") { decimal renwujishu = jixiaotichengfangan.Renwu.Value; if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = youjiansyue.Count - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); } } } } } } #endregion #region 新增意向客户(订单) var yixiangsyue = _intentionCustomerService.GetListsalaryyixiang(userList[i].Id, dateminkaoqin, datemaxkaoqin); if (yixiangsyue != null && yixiangsyue.Count > 0) { var jijianidddd = fiPiecerateDTOs.Where(x => x.Project == "新增意向客户(订单)").FirstOrDefault(); if (jijianidddd != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianidddd.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { decimal renwujishu = admAttendanceDTO.Yingchuqin * jixiaotichengfangan.Renwu.Value; if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = yixiangsyue.Count - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); } } } else if (jixiaotichengfangan.Renwustandard == "02") { decimal renwujishu = jixiaotichengfangan.Renwu.Value; if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = yixiangsyue.Count - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); } } } } } } #endregion #region 新增签约客户 var qianyueDTOsyue = _cooperatecustomCustomerService.GetListsalary(userList[i].Id, dateminkaoqin, datemaxkaoqin); if (qianyueDTOsyue != null && qianyueDTOsyue.Count > 0) { var jijianidddd = fiPiecerateDTOs.Where(x => x.Project == "新增签约客户").FirstOrDefault(); if (jijianidddd != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianidddd.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { decimal renwujishu = admAttendanceDTO.Yingchuqin * jixiaotichengfangan.Renwu.Value; if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = qianyueDTOsyue.Count - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); } } } else if (jixiaotichengfangan.Renwustandard == "02") { decimal renwujishu = jixiaotichengfangan.Renwu.Value; if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = qianyueDTOsyue.Count - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); } } } } } } #endregion #region 上门拜访客户 var cooperVisitDTOs = _cooperVisitService.GetListsalary(userList[i].Id, dateminkaoqin, datemaxkaoqin).Where(x => x.VisType == "02").ToList(); var intentionVisitDTOsshangmen = _intentionVisitService.GetListsalary(userList[i].Id, dateminkaoqin, datemaxkaoqin).Where(x => x.VisType == "02").ToList(); if ( cooperVisitDTOs.Count > 0 || intentionVisitDTOsshangmen.Count > 0) { var jijianidddd = fiPiecerateDTOs.Where(x => x.Project == "上门拜访客户").FirstOrDefault(); if (jijianidddd != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianidddd.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { decimal renwujishu = admAttendanceDTO.Yingchuqin * jixiaotichengfangan.Renwu.Value; if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = intentionVisitDTOsshangmen.Count + cooperVisitDTOs.Count - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); } } } else if (jixiaotichengfangan.Renwustandard == "02") { decimal renwujishu = jixiaotichengfangan.Renwu.Value; if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = intentionVisitDTOsshangmen.Count + cooperVisitDTOs.Count - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); } } } } } } #endregion #region 新闻资讯 //本月数量 DtChannelArticleNewsDTOSearch searchEntity1 = new DtChannelArticleNewsDTOSearch(); searchEntity1.EndTime = datemaxkaoqin; searchEntity1.AddTime = dateminkaoqin; searchEntity1.UserName = userList[i].UserSn; searchEntity1.CategoryId = 3; var dtChannelArticleNewsDTOs = _dtChannelArticleNewsService.GetList(searchEntity1); if (dtChannelArticleNewsDTOs != null && dtChannelArticleNewsDTOs.Count > 0) { var jijianidddd = fiPiecerateDTOs.Where(x => x.Project == "新闻资讯").FirstOrDefault(); if (jijianidddd != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianidddd.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { decimal renwujishu = admAttendanceDTO.Yingchuqin * jixiaotichengfangan.Renwu.Value; if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = dtChannelArticleNewsDTOs.Count - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); } } } else if (jixiaotichengfangan.Renwustandard == "02") { decimal renwujishu = jixiaotichengfangan.Renwu.Value; if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = dtChannelArticleNewsDTOs.Count - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); } } } } } } #endregion #region 典型案例 //本月数量 searchEntity1 = new DtChannelArticleNewsDTOSearch(); searchEntity1.EndTime = datemaxkaoqin; searchEntity1.AddTime = dateminkaoqin; searchEntity1.UserName = userList[i].UserSn; searchEntity1.CategoryId = 85; var dianxinanDTOs = _dtChannelArticleNewsService.GetList(searchEntity1); if (dianxinanDTOs != null && dianxinanDTOs.Count > 0) { var jijianidddd = fiPiecerateDTOs.Where(x => x.Project == "典型案例").FirstOrDefault(); if (jijianidddd != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianidddd.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { decimal renwujishu = admAttendanceDTO.Yingchuqin * jixiaotichengfangan.Renwu.Value; if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = dianxinanDTOs.Count - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); } } } else if (jixiaotichengfangan.Renwustandard == "02") { decimal renwujishu = jixiaotichengfangan.Renwu.Value; if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = dianxinanDTOs.Count - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); } } } } } } #endregion #region 政采知识 //本月数量 searchEntity1 = new DtChannelArticleNewsDTOSearch(); searchEntity1.EndTime = datemaxkaoqin; searchEntity1.AddTime = dateminkaoqin; searchEntity1.UserName = userList[i].UserSn; searchEntity1.CategoryId = 73; var zhengcaizhishiDTOs = _dtChannelArticleNewsService.GetList(searchEntity1); if (zhengcaizhishiDTOs != null && zhengcaizhishiDTOs.Count > 0) { var jijianidddd = fiPiecerateDTOs.Where(x => x.Project == "政采知识").FirstOrDefault(); if (jijianidddd != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianidddd.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { decimal renwujishu = admAttendanceDTO.Yingchuqin * jixiaotichengfangan.Renwu.Value; if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = zhengcaizhishiDTOs.Count - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); } } } else if (jixiaotichengfangan.Renwustandard == "02") { decimal renwujishu = jixiaotichengfangan.Renwu.Value; if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = zhengcaizhishiDTOs.Count - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); } } } } } } #endregion #region 新增小采问题 var xinzengwendaDTOsyue = _liaotianService.GetListsalary(userList[i].Id, dateminkaoqin, datemaxkaoqin); if (xinzengwendaDTOsyue != null && xinzengwendaDTOsyue.Count > 0) { var jijianidddd = fiPiecerateDTOs.Where(x => x.Project == "新增小采问题").FirstOrDefault(); if (jijianidddd != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianidddd.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { decimal renwujishu = admAttendanceDTO.Yingchuqin * jixiaotichengfangan.Renwu.Value; if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = xinzengwendaDTOsyue.Count - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); } } } else if (jixiaotichengfangan.Renwustandard == "02") { decimal renwujishu = jixiaotichengfangan.Renwu.Value; if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = xinzengwendaDTOsyue.Count - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); } } } } } } #endregion #region 审核小采答问 var shenhewendaDTOsyue = _liaotianService.GetListsalaryshenhe(userList[i].Id, dateminkaoqin, datemaxkaoqin); if (shenhewendaDTOsyue != null && shenhewendaDTOsyue.Count > 0) { var jijianidddd = fiPiecerateDTOs.Where(x => x.Project == "审核小采答问").FirstOrDefault(); if (jijianidddd != null) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianidddd.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { decimal renwujishu = admAttendanceDTO.Yingchuqin * jixiaotichengfangan.Renwu.Value; if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = shenhewendaDTOsyue.Count - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); } } } else if (jixiaotichengfangan.Renwustandard == "02") { decimal renwujishu = jixiaotichengfangan.Renwu.Value; if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = shenhewendaDTOsyue.Count - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); } } } } } } #endregion #region 录入客户签单 //var cooperatecustomCustomers = _cooperatecustomCustomerService.GetListsalaryqiandan(userList[i].Id, dateminkaoqin, datemaxkaoqin); // if (cooperatecustomCustomers != null && cooperatecustomCustomers.Count > 0) // { // var jijianidddd = fiPiecerateDTOs.Where(x => x.Standard == "D" && x.Project == "录入客户签单").FirstOrDefault(); // if (jijianidddd != null) // { // var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianidddd.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); // if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) // { // if (jixiaotichengfangan.Renwustandard == "01") // { // decimal renwujishu = admAttendanceDTO.Yingchuqin * jixiaotichengfangan.Renwu.Value; // if (jixiaotichengfangan.Tichengstandard == "01") // { // decimal youxiaojijian = cooperatecustomCustomers.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } // } // } // else if (jixiaotichengfangan.Renwustandard == "02") // { // decimal renwujishu = jixiaotichengfangan.Renwu.Value; // if (jixiaotichengfangan.Tichengstandard == "01") // { // decimal youxiaojijian = cooperatecustomCustomers.Count - renwujishu; // if (youxiaojijian > 0) // { // hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); // } // } // } // } // } // } #endregion @@ -1773,7 +2283,7 @@ #region 图书销售 var cooperOrdertushu = cooperOrderDTOs.Where(x => x.OrderType == "01").ToList(); var jijianid = fiPiecerateDTOs.Where(x => x.Standard == "D" && x.Project == "图书销售").FirstOrDefault(); var jijianid = fiPiecerateDTOs.Where(x => x.Project == "图书销售").FirstOrDefault(); if (jijianid != null && cooperOrdertushu.Count>0) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianid.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); @@ -1813,10 +2323,10 @@ { var dingdanjine = cooperOrdertushu.Sum(x => x.Money); var dingdanjinezhenshi = dingdanjine.HasValue ? dingdanjine.Value : 0; var dingdanyouhui = cooperOrdertushu.Sum(x => x.Youhui); var dingdanyouhuizhenshi = dingdanyouhui.HasValue ? dingdanyouhui.Value : 0; //var dingdanyouhui = cooperOrdertushu.Sum(x => x.Youhui); //var dingdanyouhuizhenshi = dingdanyouhui.HasValue ? dingdanyouhui.Value : 0; decimal youxiaojijian = dingdanjinezhenshi - dingdanyouhuizhenshi - renwujishu; decimal youxiaojijian = dingdanjinezhenshi - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian* new decimal(0.01), 2); @@ -1831,10 +2341,10 @@ { var dingdanjine = cooperOrdertushu.Sum(x => x.Money); var dingdanjinezhenshi = dingdanjine.HasValue ? dingdanjine.Value : 0; var dingdanyouhui = cooperOrdertushu.Sum(x => x.Youhui); var dingdanyouhuizhenshi = dingdanyouhui.HasValue ? dingdanyouhui.Value : 0; //var dingdanyouhui = cooperOrdertushu.Sum(x => x.Youhui); //var dingdanyouhuizhenshi = dingdanyouhui.HasValue ? dingdanyouhui.Value : 0; decimal youxiaojijian = dingdanjinezhenshi - dingdanyouhuizhenshi - renwujishu; decimal youxiaojijian = dingdanjinezhenshi - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian * new decimal(0.01), 2); @@ -1847,7 +2357,7 @@ #region 政采咨询 cooperOrdertushu = cooperOrderDTOs.Where(x => x.OrderType == "02").ToList(); jijianid = fiPiecerateDTOs.Where(x => x.Standard == "D" && x.Project == "政采咨询").FirstOrDefault(); jijianid = fiPiecerateDTOs.Where(x => x.Project == "政采咨询").FirstOrDefault(); if (jijianid != null && cooperOrdertushu.Count > 0) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianid.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); @@ -1887,10 +2397,10 @@ { var dingdanjine = cooperOrdertushu.Sum(x => x.Money); var dingdanjinezhenshi = dingdanjine.HasValue ? dingdanjine.Value : 0; var dingdanyouhui = cooperOrdertushu.Sum(x => x.Youhui); var dingdanyouhuizhenshi = dingdanyouhui.HasValue ? dingdanyouhui.Value : 0; //var dingdanyouhui = cooperOrdertushu.Sum(x => x.Youhui); //var dingdanyouhuizhenshi = dingdanyouhui.HasValue ? dingdanyouhui.Value : 0; decimal youxiaojijian = dingdanjinezhenshi - dingdanyouhuizhenshi - renwujishu; decimal youxiaojijian = dingdanjinezhenshi - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian * new decimal(0.01), 2); @@ -1905,10 +2415,10 @@ { var dingdanjine = cooperOrdertushu.Sum(x => x.Money); var dingdanjinezhenshi = dingdanjine.HasValue ? dingdanjine.Value : 0; var dingdanyouhui = cooperOrdertushu.Sum(x => x.Youhui); var dingdanyouhuizhenshi = dingdanyouhui.HasValue ? dingdanyouhui.Value : 0; //var dingdanyouhui = cooperOrdertushu.Sum(x => x.Youhui); //var dingdanyouhuizhenshi = dingdanyouhui.HasValue ? dingdanyouhui.Value : 0; decimal youxiaojijian = dingdanjinezhenshi - dingdanyouhuizhenshi - renwujishu; decimal youxiaojijian = dingdanjinezhenshi - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian * new decimal(0.01), 2); @@ -1922,7 +2432,7 @@ #region 标书制作订单 cooperOrdertushu = cooperOrderDTOs.Where(x => x.OrderType == "03").ToList(); jijianid = fiPiecerateDTOs.Where(x => x.Standard == "D" && x.Project == "标书制作订单").FirstOrDefault(); jijianid = fiPiecerateDTOs.Where(x => x.Project == "标书制作订单").FirstOrDefault(); if (jijianid != null && cooperOrdertushu.Count > 0) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianid.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); @@ -1962,10 +2472,10 @@ { var dingdanjine = cooperOrdertushu.Sum(x => x.Money); var dingdanjinezhenshi = dingdanjine.HasValue ? dingdanjine.Value : 0; var dingdanyouhui = cooperOrdertushu.Sum(x => x.Youhui); var dingdanyouhuizhenshi = dingdanyouhui.HasValue ? dingdanyouhui.Value : 0; //var dingdanyouhui = cooperOrdertushu.Sum(x => x.Youhui); //var dingdanyouhuizhenshi = dingdanyouhui.HasValue ? dingdanyouhui.Value : 0; decimal youxiaojijian = dingdanjinezhenshi - dingdanyouhuizhenshi - renwujishu; decimal youxiaojijian = dingdanjinezhenshi - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian * new decimal(0.01), 2); @@ -1980,10 +2490,10 @@ { var dingdanjine = cooperOrdertushu.Sum(x => x.Money); var dingdanjinezhenshi = dingdanjine.HasValue ? dingdanjine.Value : 0; var dingdanyouhui = cooperOrdertushu.Sum(x => x.Youhui); var dingdanyouhuizhenshi = dingdanyouhui.HasValue ? dingdanyouhui.Value : 0; //var dingdanyouhui = cooperOrdertushu.Sum(x => x.Youhui); //var dingdanyouhuizhenshi = dingdanyouhui.HasValue ? dingdanyouhui.Value : 0; decimal youxiaojijian = dingdanjinezhenshi - dingdanyouhuizhenshi - renwujishu; decimal youxiaojijian = dingdanjinezhenshi - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian * new decimal(0.01), 2); @@ -1997,7 +2507,7 @@ #region 培训 cooperOrdertushu = cooperOrderDTOs.Where(x => x.OrderType == "04").ToList(); jijianid = fiPiecerateDTOs.Where(x => x.Standard == "D" && x.Project == "培训").FirstOrDefault(); jijianid = fiPiecerateDTOs.Where(x => x.Project == "培训").FirstOrDefault(); if (jijianid != null && cooperOrdertushu.Count > 0) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianid.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); @@ -2037,10 +2547,10 @@ { var dingdanjine = cooperOrdertushu.Sum(x => x.Money); var dingdanjinezhenshi = dingdanjine.HasValue ? dingdanjine.Value : 0; var dingdanyouhui = cooperOrdertushu.Sum(x => x.Youhui); var dingdanyouhuizhenshi = dingdanyouhui.HasValue ? dingdanyouhui.Value : 0; //var dingdanyouhui = cooperOrdertushu.Sum(x => x.Youhui); //var dingdanyouhuizhenshi = dingdanyouhui.HasValue ? dingdanyouhui.Value : 0; decimal youxiaojijian = dingdanjinezhenshi - dingdanyouhuizhenshi - renwujishu; decimal youxiaojijian = dingdanjinezhenshi - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian * new decimal(0.01), 2); @@ -2055,10 +2565,10 @@ { var dingdanjine = cooperOrdertushu.Sum(x => x.Money); var dingdanjinezhenshi = dingdanjine.HasValue ? dingdanjine.Value : 0; var dingdanyouhui = cooperOrdertushu.Sum(x => x.Youhui); var dingdanyouhuizhenshi = dingdanyouhui.HasValue ? dingdanyouhui.Value : 0; //var dingdanyouhui = cooperOrdertushu.Sum(x => x.Youhui); //var dingdanyouhuizhenshi = dingdanyouhui.HasValue ? dingdanyouhui.Value : 0; decimal youxiaojijian = dingdanjinezhenshi - dingdanyouhuizhenshi - renwujishu; decimal youxiaojijian = dingdanjinezhenshi - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian * new decimal(0.01), 2); @@ -2071,8 +2581,8 @@ #endregion #region 套餐会员 cooperOrdertushu = cooperOrderDTOs.Where(x => x.OrderType == "05").ToList(); jijianid = fiPiecerateDTOs.Where(x => x.Standard == "D" && x.Project == "套餐会员").FirstOrDefault(); cooperOrdertushu = cooperOrderDTOs.Where(x => x.OrderType == "05").OrderBy(x=>x.Createtime).ToList(); jijianid = fiPiecerateDTOs.Where(x => x.Project == "套餐会员").FirstOrDefault(); if (jijianid != null && cooperOrdertushu.Count > 0) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianid.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); @@ -2104,6 +2614,21 @@ } } else if (jixiaotichengfangan.Tichengstandard == "02") { if (cooperOrdertushu.Count > renwujishu) { List<CooperOrderDTO> cooperOrdertushuyouxiao = new List<CooperOrderDTO>(); for (int j = Convert.ToInt32(renwujishu); j < cooperOrdertushu.Count; j++) { cooperOrdertushuyouxiao.Add(cooperOrdertushu[j]); } var dingdanjine = cooperOrdertushuyouxiao.Sum(x => x.Money); var dingdanjinezhenshi = dingdanjine.HasValue ? dingdanjine.Value : 0; hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * dingdanjinezhenshi * new decimal(0.01), 2); } } } else if (jixiaotichengfangan.Renwustandard == "03") { @@ -2112,10 +2637,10 @@ { var dingdanjine = cooperOrdertushu.Sum(x => x.Money); var dingdanjinezhenshi = dingdanjine.HasValue ? dingdanjine.Value : 0; var dingdanyouhui = cooperOrdertushu.Sum(x => x.Youhui); var dingdanyouhuizhenshi = dingdanyouhui.HasValue ? dingdanyouhui.Value : 0; //var dingdanyouhui = cooperOrdertushu.Sum(x => x.Youhui); //var dingdanyouhuizhenshi = dingdanyouhui.HasValue ? dingdanyouhui.Value : 0; decimal youxiaojijian = dingdanjinezhenshi - dingdanyouhuizhenshi - renwujishu; decimal youxiaojijian = dingdanjinezhenshi - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian * new decimal(0.01), 2); @@ -2130,15 +2655,15 @@ { var dingdanjine = cooperOrdertushu.Sum(x => x.Money); var dingdanjinezhenshi = dingdanjine.HasValue ? dingdanjine.Value : 0; var dingdanyouhui = cooperOrdertushu.Sum(x => x.Youhui); var dingdanyouhuizhenshi = dingdanyouhui.HasValue ? dingdanyouhui.Value : 0; //var dingdanyouhui = cooperOrdertushu.Sum(x => x.Youhui); //var dingdanyouhuizhenshi = dingdanyouhui.HasValue ? dingdanyouhui.Value : 0; decimal youxiaojijian = dingdanjinezhenshi - dingdanyouhuizhenshi - renwujishu; decimal youxiaojijian = dingdanjinezhenshi - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian * new decimal(0.01), 2); } } } } } } @@ -2147,7 +2672,7 @@ #region 专家申请 cooperOrdertushu = cooperOrderDTOs.Where(x => x.OrderType == "06").ToList(); jijianid = fiPiecerateDTOs.Where(x => x.Standard == "D" && x.Project == "专家申请").FirstOrDefault(); jijianid = fiPiecerateDTOs.Where(x => x.Project == "专家申请").FirstOrDefault(); if (jijianid != null && cooperOrdertushu.Count > 0) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianid.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); @@ -2187,10 +2712,10 @@ { var dingdanjine = cooperOrdertushu.Sum(x => x.Money); var dingdanjinezhenshi = dingdanjine.HasValue ? dingdanjine.Value : 0; var dingdanyouhui = cooperOrdertushu.Sum(x => x.Youhui); var dingdanyouhuizhenshi = dingdanyouhui.HasValue ? dingdanyouhui.Value : 0; //var dingdanyouhui = cooperOrdertushu.Sum(x => x.Youhui); //var dingdanyouhuizhenshi = dingdanyouhui.HasValue ? dingdanyouhui.Value : 0; decimal youxiaojijian = dingdanjinezhenshi - dingdanyouhuizhenshi - renwujishu; decimal youxiaojijian = dingdanjinezhenshi - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian * new decimal(0.01), 2); @@ -2205,10 +2730,10 @@ { var dingdanjine = cooperOrdertushu.Sum(x => x.Money); var dingdanjinezhenshi = dingdanjine.HasValue ? dingdanjine.Value : 0; var dingdanyouhui = cooperOrdertushu.Sum(x => x.Youhui); var dingdanyouhuizhenshi = dingdanyouhui.HasValue ? dingdanyouhui.Value : 0; //var dingdanyouhui = cooperOrdertushu.Sum(x => x.Youhui); //var dingdanyouhuizhenshi = dingdanyouhui.HasValue ? dingdanyouhui.Value : 0; decimal youxiaojijian = dingdanjinezhenshi - dingdanyouhuizhenshi - renwujishu; decimal youxiaojijian = dingdanjinezhenshi - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian * new decimal(0.01), 2); @@ -2222,7 +2747,7 @@ #region 履约纠纷 cooperOrdertushu = cooperOrderDTOs.Where(x => x.OrderType == "07").ToList(); jijianid = fiPiecerateDTOs.Where(x => x.Standard == "D" && x.Project == "履约纠纷").FirstOrDefault(); jijianid = fiPiecerateDTOs.Where(x => x.Project == "履约纠纷").FirstOrDefault(); if (jijianid != null && cooperOrdertushu.Count > 0) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianid.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); @@ -2262,10 +2787,10 @@ { var dingdanjine = cooperOrdertushu.Sum(x => x.Money); var dingdanjinezhenshi = dingdanjine.HasValue ? dingdanjine.Value : 0; var dingdanyouhui = cooperOrdertushu.Sum(x => x.Youhui); var dingdanyouhuizhenshi = dingdanyouhui.HasValue ? dingdanyouhui.Value : 0; //var dingdanyouhui = cooperOrdertushu.Sum(x => x.Youhui); //var dingdanyouhuizhenshi = dingdanyouhui.HasValue ? dingdanyouhui.Value : 0; decimal youxiaojijian = dingdanjinezhenshi - dingdanyouhuizhenshi - renwujishu; decimal youxiaojijian = dingdanjinezhenshi - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian * new decimal(0.01), 2); @@ -2280,10 +2805,10 @@ { var dingdanjine = cooperOrdertushu.Sum(x => x.Money); var dingdanjinezhenshi = dingdanjine.HasValue ? dingdanjine.Value : 0; var dingdanyouhui = cooperOrdertushu.Sum(x => x.Youhui); var dingdanyouhuizhenshi = dingdanyouhui.HasValue ? dingdanyouhui.Value : 0; //var dingdanyouhui = cooperOrdertushu.Sum(x => x.Youhui); //var dingdanyouhuizhenshi = dingdanyouhui.HasValue ? dingdanyouhui.Value : 0; decimal youxiaojijian = dingdanjinezhenshi - dingdanyouhuizhenshi - renwujishu; decimal youxiaojijian = dingdanjinezhenshi - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian * new decimal(0.01), 2); @@ -2297,7 +2822,7 @@ #region 风险代理 cooperOrdertushu = cooperOrderDTOs.Where(x => x.OrderType == "08").ToList(); jijianid = fiPiecerateDTOs.Where(x => x.Standard == "D" && x.Project == "风险代理").FirstOrDefault(); jijianid = fiPiecerateDTOs.Where(x => x.Project == "风险代理").FirstOrDefault(); if (jijianid != null && cooperOrdertushu.Count > 0) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianid.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); @@ -2337,10 +2862,10 @@ { var dingdanjine = cooperOrdertushu.Sum(x => x.Money); var dingdanjinezhenshi = dingdanjine.HasValue ? dingdanjine.Value : 0; var dingdanyouhui = cooperOrdertushu.Sum(x => x.Youhui); var dingdanyouhuizhenshi = dingdanyouhui.HasValue ? dingdanyouhui.Value : 0; //var dingdanyouhui = cooperOrdertushu.Sum(x => x.Youhui); //var dingdanyouhuizhenshi = dingdanyouhui.HasValue ? dingdanyouhui.Value : 0; decimal youxiaojijian = dingdanjinezhenshi - dingdanyouhuizhenshi - renwujishu; decimal youxiaojijian = dingdanjinezhenshi - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian * new decimal(0.01), 2); @@ -2355,10 +2880,10 @@ { var dingdanjine = cooperOrdertushu.Sum(x => x.Money); var dingdanjinezhenshi = dingdanjine.HasValue ? dingdanjine.Value : 0; var dingdanyouhui = cooperOrdertushu.Sum(x => x.Youhui); var dingdanyouhuizhenshi = dingdanyouhui.HasValue ? dingdanyouhui.Value : 0; //var dingdanyouhui = cooperOrdertushu.Sum(x => x.Youhui); //var dingdanyouhuizhenshi = dingdanyouhui.HasValue ? dingdanyouhui.Value : 0; decimal youxiaojijian = dingdanjinezhenshi - dingdanyouhuizhenshi - renwujishu; decimal youxiaojijian = dingdanjinezhenshi - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian * new decimal(0.01), 2); @@ -2372,7 +2897,7 @@ #region 软件销售提成 cooperOrdertushu = cooperOrderDTOs.Where(x => x.OrderType == "09").ToList(); jijianid = fiPiecerateDTOs.Where(x => x.Standard == "D" && x.Project == "软件销售提成").FirstOrDefault(); jijianid = fiPiecerateDTOs.Where(x => x.Project == "软件销售提成").FirstOrDefault(); if (jijianid != null && cooperOrdertushu.Count > 0) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianid.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); @@ -2412,10 +2937,10 @@ { var dingdanjine = cooperOrdertushu.Sum(x => x.Money); var dingdanjinezhenshi = dingdanjine.HasValue ? dingdanjine.Value : 0; var dingdanyouhui = cooperOrdertushu.Sum(x => x.Youhui); var dingdanyouhuizhenshi = dingdanyouhui.HasValue ? dingdanyouhui.Value : 0; //var dingdanyouhui = cooperOrdertushu.Sum(x => x.Youhui); //var dingdanyouhuizhenshi = dingdanyouhui.HasValue ? dingdanyouhui.Value : 0; decimal youxiaojijian = dingdanjinezhenshi - dingdanyouhuizhenshi - renwujishu; decimal youxiaojijian = dingdanjinezhenshi - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian * new decimal(0.01), 2); @@ -2430,10 +2955,10 @@ { var dingdanjine = cooperOrdertushu.Sum(x => x.Money); var dingdanjinezhenshi = dingdanjine.HasValue ? dingdanjine.Value : 0; var dingdanyouhui = cooperOrdertushu.Sum(x => x.Youhui); var dingdanyouhuizhenshi = dingdanyouhui.HasValue ? dingdanyouhui.Value : 0; //var dingdanyouhui = cooperOrdertushu.Sum(x => x.Youhui); //var dingdanyouhuizhenshi = dingdanyouhui.HasValue ? dingdanyouhui.Value : 0; decimal youxiaojijian = dingdanjinezhenshi - dingdanyouhuizhenshi - renwujishu; decimal youxiaojijian = dingdanjinezhenshi - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian * new decimal(0.01), 2); @@ -2447,7 +2972,7 @@ #region 其他业务 cooperOrdertushu = cooperOrderDTOs.Where(x => x.OrderType == "10").ToList(); jijianid = fiPiecerateDTOs.Where(x => x.Standard == "D" && x.Project == "其他业务").FirstOrDefault(); jijianid = fiPiecerateDTOs.Where(x => x.Project == "其他业务").FirstOrDefault(); if (jijianid != null && cooperOrdertushu.Count > 0) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianid.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); @@ -2487,10 +3012,10 @@ { var dingdanjine = cooperOrdertushu.Sum(x => x.Money); var dingdanjinezhenshi = dingdanjine.HasValue ? dingdanjine.Value : 0; var dingdanyouhui = cooperOrdertushu.Sum(x => x.Youhui); var dingdanyouhuizhenshi = dingdanyouhui.HasValue ? dingdanyouhui.Value : 0; //var dingdanyouhui = cooperOrdertushu.Sum(x => x.Youhui); //var dingdanyouhuizhenshi = dingdanyouhui.HasValue ? dingdanyouhui.Value : 0; decimal youxiaojijian = dingdanjinezhenshi - dingdanyouhuizhenshi - renwujishu; decimal youxiaojijian = dingdanjinezhenshi - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian * new decimal(0.01), 2); @@ -2505,10 +3030,10 @@ { var dingdanjine = cooperOrdertushu.Sum(x => x.Money); var dingdanjinezhenshi = dingdanjine.HasValue ? dingdanjine.Value : 0; var dingdanyouhui = cooperOrdertushu.Sum(x => x.Youhui); var dingdanyouhuizhenshi = dingdanyouhui.HasValue ? dingdanyouhui.Value : 0; //var dingdanyouhui = cooperOrdertushu.Sum(x => x.Youhui); //var dingdanyouhuizhenshi = dingdanyouhui.HasValue ? dingdanyouhui.Value : 0; decimal youxiaojijian = dingdanjinezhenshi - dingdanyouhuizhenshi - renwujishu; decimal youxiaojijian = dingdanjinezhenshi - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian * new decimal(0.01), 2); @@ -2519,6 +3044,82 @@ } #endregion #region 数据分析 cooperOrdertushu = cooperOrderDTOs.Where(x => x.OrderType == "11").ToList(); jijianid = fiPiecerateDTOs.Where(x => x.Project == "数据分析").FirstOrDefault(); if (jijianid != null && cooperOrdertushu.Count > 0) { var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianid.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault(); if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue) { if (jixiaotichengfangan.Renwustandard == "01") { decimal renwujishu = admAttendanceDTO.Yingchuqin * jixiaotichengfangan.Renwu.Value; if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = cooperOrdertushu.Count - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); } } } else if (jixiaotichengfangan.Renwustandard == "02") { decimal renwujishu = jixiaotichengfangan.Renwu.Value; if (jixiaotichengfangan.Tichengstandard == "01") { decimal youxiaojijian = cooperOrdertushu.Count - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2); } } } else if (jixiaotichengfangan.Renwustandard == "03") { decimal renwujishu = admAttendanceDTO.Yingchuqin * jixiaotichengfangan.Renwu.Value; if (jixiaotichengfangan.Tichengstandard == "02") { var dingdanjine = cooperOrdertushu.Sum(x => x.Money); var dingdanjinezhenshi = dingdanjine.HasValue ? dingdanjine.Value : 0; //var dingdanyouhui = cooperOrdertushu.Sum(x => x.Youhui); //var dingdanyouhuizhenshi = dingdanyouhui.HasValue ? dingdanyouhui.Value : 0; decimal youxiaojijian = dingdanjinezhenshi - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian * new decimal(0.01), 2); } } } else if (jixiaotichengfangan.Renwustandard == "04") { decimal renwujishu = jixiaotichengfangan.Renwu.Value; if (jixiaotichengfangan.Tichengstandard == "02") { var dingdanjine = cooperOrdertushu.Sum(x => x.Money); var dingdanjinezhenshi = dingdanjine.HasValue ? dingdanjine.Value : 0; //var dingdanyouhui = cooperOrdertushu.Sum(x => x.Youhui); //var dingdanyouhuizhenshi = dingdanyouhui.HasValue ? dingdanyouhui.Value : 0; decimal youxiaojijian = dingdanjinezhenshi - renwujishu; if (youxiaojijian > 0) { hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian * new decimal(0.01), 2); } } } } } #endregion } zhengcaioa/zhengcaioa/Timer/TimerGetShopUsersService.cs
@@ -1,5 +1,6 @@ using DTO; using IServices; using Microsoft.EntityFrameworkCore; using Microsoft.Extensions.Configuration; using Microsoft.Extensions.DependencyInjection; using Microsoft.Extensions.Hosting; @@ -25,6 +26,7 @@ private readonly IConfiguration _configuration; private readonly ILiaotianService _liaotianService; private readonly IHttpClientFactory _clientFactory; private readonly IDtChannelArticleNewsService _dtChannelArticleNewsService; public TimerGetShopUsersService(ILogger<TimerGetShopUsersService> logger, IServiceScopeFactory factory) { @@ -32,6 +34,7 @@ _configuration = factory.CreateScope().ServiceProvider.GetRequiredService<IConfiguration>(); _liaotianService = factory.CreateScope().ServiceProvider.GetRequiredService<ILiaotianService>(); _clientFactory = factory.CreateScope().ServiceProvider.GetRequiredService<IHttpClientFactory>(); _dtChannelArticleNewsService = factory.CreateScope().ServiceProvider.GetRequiredService<IDtChannelArticleNewsService>(); } protected override async Task ExecuteAsync(CancellationToken stoppingToken) @@ -52,6 +55,7 @@ try { await this.huoquhuiyuanAsync(); } @@ -76,6 +80,17 @@ { base.Dispose(); } public void ceshi() { DtChannelArticleNewsDTOSearch searchEntity = new DtChannelArticleNewsDTOSearch(); searchEntity.EndTime = DateTime.Parse("2021-07-15 12:06:30.893"); searchEntity.AddTime = DateTime.Parse("2021-07-01 12:06:30.893"); searchEntity.UserName = "yangjiameng"; searchEntity.CategoryId = 85; var dtChannelArticleNewsDTOs = _dtChannelArticleNewsService.GetList(searchEntity); _logger.LogInformation("dtChannelArticleNewsDTOs:"+ dtChannelArticleNewsDTOs.Count); } public async Task huoquhuiyuanAsync() { zhengcaioa/zhengcaioa/Views/CooperatecustomCustomer/Index.cshtml
@@ -46,7 +46,7 @@ { label: '区县', name: 'AreaId', labtype: 'combox', hidden: false, data: JSON.parse('[]'), cwidth: '2%', cccwidth: '8%' }, { label: '客户单位', name: 'Name', labtype: 'txt', hidden: false }, { label: '建档时间', name: 'Createtime', labtype: 'datearea', hidden: false }, { label: '是否有微信', name: 'Shifouweixin', labtype: 'combox', hidden: false, data: JSON.parse(shifou), cwidth: '5%', cccwidth: '8%' }, { label: '是否加微信', name: 'Shifouweixin', labtype: 'combox', hidden: false, data: JSON.parse(shifou), cwidth: '5%', cccwidth: '8%' }, ]; var _pageAdd = function () { zhengcaioa/zhengcaioa/Views/FiAccount/Index.cshtml
@@ -21,7 +21,13 @@ { label: '总收入', name: 'AllIncome', labtype: 'txt', hidden: false }, { label: '总支出', name: 'AllExpenses', labtype: 'txt', hidden: false }, { label: '余额', name: 'Balance', labtype: 'txt', hidden: false }, { label: '备注', name: 'Remark', labtype: 'txt', hidden: false }, { label: '流水账', name: 'Remark', labtype: 'txt', hidden: false, formatter: function (cellvalue, options, rowObject) { return "<a onclick=\"OpenWindow('" + rowObject.Accountname + "','98%','100%', '/FiAccount/Liushuizhang?id=" + rowObject.Id + "')\" >流水账</a>"; } }, { label: '状态', name: 'RecStatus', labtype: 'txt', hidden: true }, { label: '创建人', name: 'Creater', labtype: 'txt', hidden: true }, { label: '创建时间', name: 'Createtimetxt', labtype: 'txt', hidden: true }, zhengcaioa/zhengcaioa/Views/FiAccount/Liushuizhang.cshtml
New file @@ -0,0 +1,80 @@ @{ ViewBag.Title = "FiAccountExpenses"; Layout = "~/Views/Shared/_Layout_Search.cshtml"; } @section headerStyle{ <script type="text/javascript"> var FiSubject = '@Html.Raw(Newtonsoft.Json.JsonConvert.SerializeObject(ViewBag.FiSubject))'; dataCol = [ { label: 'id', name: 'Id', labtype: 'txt', hidden: true, width: 60}, { label: '账户类型', name: 'AccounttypeName', labtype: 'txt', hidden: false, width: 60 }, { label: '账户名称', name: 'AccountName', labtype: 'txt', hidden: false, width: 60 }, { label: '科目名称', name: 'SubjectName', labtype: 'txt', hidden: false, width: 60 }, { label: '收入支出', name: 'RecordTypeName', labtype: 'txt', hidden: false, width: 60 }, { label: '金额', name: 'Money', labtype: 'txt', hidden: false, width: 60}, { label: '账户余额', name: 'AccountMoney', labtype: 'txt', hidden: false, width: 60 }, { label: '部门', name: 'Department', labtype: 'txt', hidden: false, width: 60 }, { label: '收付款人(单位)', name: 'PaymentUnit', labtype: 'txt', hidden: false, width: 100 }, { label: '摘要', name: 'OperationalMatters', labtype: 'txt', hidden: false, width: 200}, { label: '操作时间', name: 'CreatetimeName', labtype: 'txt', hidden: false, width: 100}, { label: '操作', name: 'RecStatus', labtype: 'txt', hidden: false , formatter: function (cellvalue, options, rowObject) { return "<a onclick=\"OpenWindow('查看','98%','100%', '/FiAccountExpenses/Check?id=" + rowObject.Id + "')\" >查看</a>"; }, width: 60 }, ]; dataUrl = "/FiAccount/GetListLiushuizhang?AccountId=@ViewBag.id"; searchCol = [ { label: '操作时间', name: 'Createtime', labtype: 'datearea', hidden: false }, { label: '科目名称', name: 'SubjectId', labtype: 'combox', hidden: false, data: JSON.parse(FiSubject) }, { label: '摘要', name: 'OperationalMatters', labtype: 'txt', hidden: false }, { label: '收付款人', name: 'PaymentUnit', labtype: 'txt', hidden: false }, { label: '操作人', name: 'CreaterName', labtype: 'txt', hidden: false }, ]; var _afterSave = function (result) { if (result) { toastr.success("保存成功"); } else { toastr.error("保存失败"); } } var _afterDel = function (result) { if (result) { toastr.success("删除成功"); } else { /**/ toastr.error("删除成功"); /**/ } } </script> } @section footerScripts{ <script type="text/javascript"> </script> } zhengcaioa/zhengcaioa/Views/IntentionCustomer/Index.cshtml
@@ -50,7 +50,7 @@ { label: '客户单位', name: 'Name', labtype: 'txt', hidden: false }, { label: '建档时间', name: 'Createtime', labtype: 'datearea', hidden: false }, { label: '录入人', name: 'Creater', labtype: 'combox', hidden: false, data: JSON.parse(Creater), cwidth: '5%', cccwidth: '8%' }, { label: '是否有微信', name: 'Shifouweixin', labtype: 'combox', hidden: false, data: JSON.parse(shifou), cwidth: '5%', cccwidth: '8%' }, { label: '是否加微信', name: 'Shifouweixin', labtype: 'combox', hidden: false, data: JSON.parse(shifou), cwidth: '5%', cccwidth: '8%' }, zhengcaioa/zhengcaioa/Views/ServiceCharge/Index.cshtml
@@ -654,7 +654,7 @@ </tbody> </table> </div> <div class=""> @*<div class=""> <h3>八、风险代理</h3> @@ -663,10 +663,10 @@ <label class="text-left col-sm-1 col-md-1 control-label">面议</label> </div> </div>*@ <div class=""> <h3>九、软件</h3> <h3>八、软件</h3> </div> <div class="clearfix layer-area" style="padding-bottom:15px;"> @@ -709,11 +709,11 @@ </table> </div> <div class=""> @*<div class=""> <h3>十、其他</h3> </div> </div>*@ zhengcaioa/zhengcaioa/Views/ServiceCharge/Print.cshtml
@@ -615,7 +615,7 @@ </tbody> </table> </div> <div class=""> @*<div class=""> <h3>八、风险代理</h3> @@ -624,10 +624,10 @@ <label class="text-left col-sm-1 col-md-1 control-label">面议</label> </div> </div>*@ <div class=""> <h3>九、软件</h3> <h3>八、软件</h3> </div> <div class="clearfix layer-area" style="padding-bottom:15px;"> @@ -670,11 +670,11 @@ </table> </div> <div class=""> @*<div class=""> <h3>十、其他</h3> </div> </div>*@ zhengcaioa/zhengcaioa/Views/TongjiBaoBiao/Index.cshtml
New file @@ -0,0 +1,524 @@ @model DTO.ServiceChargeDTO @using DTO; @{ ViewBag.Title = "ServiceCharge"; Layout = null; List<TongjiBaoBiaoDTO> tuiguangDTOs = ViewBag.tuiguangDTOs as List<TongjiBaoBiaoDTO>; List<TongjiBaoBiaoDTO> baifangkehuDTOs = ViewBag.baifangkehuDTOs as List<TongjiBaoBiaoDTO>; List<TongjiDingDanDTO> dingdanDTOs = ViewBag.dingdanDTOs as List<TongjiDingDanDTO>; List<TongjiBaoBiaoDTO> ziliaoweihuDTOs = ViewBag.ziliaoweihuDTOs as List<TongjiBaoBiaoDTO>; List<TongjiBaoBiaoDTO> xiangmushishiDTOs = ViewBag.xiangmushishiDTOs as List<TongjiBaoBiaoDTO>; int nookcount = dingdanDTOs == null ? 0 : dingdanDTOs.Count; } <!DOCTYPE html> <html> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta http-equiv="Pragma" content="no-cache"> <meta http-equiv="Cache-Control" content="no-siteapp" /> <meta http-equiv="Cache-Control" content="no-cache"> <meta http-equiv="Expires" content="0"> <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0"> <meta name="renderer" content="webkit"> <title>@SiteConfig.SiteName</title> <meta name="keywords" content="@SiteConfig.Keywords"> <meta name="description" content="@SiteConfig.Description"> <meta name="author" content="@SiteConfig.Author"> <link rel="icon" type="image/x-icon" href="@SiteConfig.ShortcutIcon"> <!-- uc强制竖屏 --> <meta name="screen-orientation" content="portrait"> <!-- QQ强制竖屏 --> <meta name="x5-orientation" content="portrait"> <!-- UC强制全屏 --> <meta name="full-screen" content="yes"> <!-- QQ强制全屏 --> <meta name="x5-fullscreen" content="true"> <!--[if lt IE 9]> <meta http-equiv="refresh" content="0;ie.html" /> <![endif]--> <script src="~/js/jquery.min.js"></script> <link href="~/css/bootstrap.min.css" rel="stylesheet"> <link href="~/css/font-awesome.min.css" rel="stylesheet"> <link href="~/css/animate.min.css" rel="stylesheet"> @*<link href="~/css/plugins/iCheck/custom.css" rel="stylesheet">*@ <link href="~/css/style.min.css" rel="stylesheet"> <link href="~/css/plugins/chosen/chosen.css" rel="stylesheet"> @*<link href="~/js/plugins/layer/skin/layer.css" rel="stylesheet">*@ @*<link href="~/css/plugins/datapicker/datepicker3.css" rel="stylesheet">*@ <link href="~/css/style.min.css" rel="stylesheet"> <link href="~/css/plugins/toastr/toastr.min.css" rel="stylesheet" /> <link href="~/css/plugins/webuploader/webuploader.css" rel="stylesheet" /> <style type="text/css"> .webuploader-pick { position: relative; display: inline-block; cursor: pointer; background: #00b7ee; padding: 8px 14px 7px 14px; color: #fff; text-align: center; border-radius: 3px; overflow: hidden; } div.clearfix > label { padding-top: 8px; } .chosen-container { border-radius: 1px; border: 1px solid #e5e6e7; } .col-md-1.control-label { padding-right: 0px; font-weight: 400; } html { font-family: sans-serif; -ms-text-size-adjust: 100%; -webkit-text-size-adjust: 100%; } body { margin: 10px; } table { border-collapse: collapse; border-spacing: 0; } td, th { padding: 0; } .pure-table { border-collapse: collapse; border-spacing: 0; empty-cells: show; border: 1px solid #cbcbcb; } .pure-table caption { color: #000; font: italic 85%/1 arial,sans-serif; padding: 1em 0; text-align: center; } .pure-table td, .pure-table th { border-left: 1px solid #cbcbcb; border-width: 0 0 0 1px; font-size: inherit; margin: 0; overflow: visible; padding: .5em 1em; } .pure-table thead { background-color: #e0e0e0 !important; color: #000; text-align: left; vertical-align: bottom; -webkit-print-color-adjust: exact; } .pure-table td { background-color: transparent; } .pure-table-bordered td { border-bottom: 1px solid #cbcbcb; } .pure-table-bordered tbody > tr:last-child > td { border-bottom-width: 0; } /* .pure-table-bordered th { border-bottom: 1px solid #cbcbcb; } .pure-table-bordered tbody > tr:last-child > th { border-bottom-width: 0; }*/ </style> <!-- jqgrid--> @*<link href="~/css/plugins/jqgrid/ui.jqgrid.css" rel="stylesheet">*@ <script language="javascript" src="~/js/jquery.min.js" type="text/javascript"></script> <script src="~/js/bootstrap.min.js"></script> @*<script src="~/js/plugins/bootstro/bootstro.js"></script>*@ <!--容器--> @*<script language="javascript" src="~/js/datehelper.js" type="text/javascript"></script>*@ @*<script language="javascript" src="~/js/plugins/query/jquery.query-object.js" type="text/javascript"></script>*@ @*<script language="javascript" src="~/js/plugins/iCheck/icheck.min.js" type="text/javascript"></script>*@ <script language="javascript" src="~/js/plugins/chosen/chosen.jquery.js" type="text/javascript"></script> @*<script language="javascript" src="~/js/plugins/datapicker/bootstrap-datepicker.js" type="text/javascript"></script>*@ <script language="javascript" src="~/js/plugins/layer/layer.js" type="text/javascript"></script> @*<script src="~/js/plugins/jqgrid/jquery.jqGrid.min.js" type="text/javascript"></script>*@ @*<script src="~/js/plugins/jqgrid/i18n/grid.locale-cn.js" type="text/javascript"></script>*@ <script src="~/js/plugins/toastr/toastr.min.js" type="text/javascript"></script> <script src="~/js/plugins/webuploader/webuploader.min.js"></script> <script language="javascript" src="~/js/common-layout.js" type="text/javascript"></script> <script src="~/js/plugins/layer/laydate/laydate.js" type="text/javascript"></script> @*<script src="~/js/plugins/iTexbox/itextbox.js" type="text/javascript"></script>*@ @*<script src="~/js/plugins/iuploader/iuploader.js"></script>*@ <script src="~/js/TUJS.js"></script> </head> <body class="gray-bg" style="overflow:auto"> <button type="button" id="printl" onclick="onprint()">打印</button> <div id="printArea"> <div class="wrapper wrapper-content" id="ibox-content" style="padding:15px;"> <div class="row"> <div class="col-sm-12"> <div class="ibox float-e-margins"> <div id="div_content" class="ibox-content" style="background-color:white;"> <div class="" style="text-align: center;"> <h1>绩效统计</h1> </div> <div class="row"> <div class=""> <h3>一、推广</h3> </div> <div class="clearfix layer-area" style="padding-bottom:15px;"> <table class="pure-table pure-table-bordered" style="width:100%;"> <thead> <tr> <th style="width:8%;"> 序号 </th> <th style="width:15%;"> 推广工作 </th> <th style="width:15%;"> 本月推广数量 </th> <th style="width:15%;"> 本月任务 </th> <th style="width:15%;"> 本日推广数量 </th> <th style="width:15%;"> 本日任务 </th> <th style="width:15%;"> 当日绩效考核 </th> </tr> </thead> <tbody> @{ if (tuiguangDTOs != null && tuiguangDTOs.Count > 0) { for (int i = 0; i < tuiguangDTOs.Count; i++) { <tr> <td>@(i+1)</td> <td>@tuiguangDTOs[i].gongzuo</td> <td>@(tuiguangDTOs[i].benyueshuliang=="0"?"":tuiguangDTOs[i].benyueshuliang)</td> <td>@(tuiguangDTOs[i].benyueqingkuang=="0"?"":tuiguangDTOs[i].benyueqingkuang)</td> <td>@(tuiguangDTOs[i].benrishuliang=="0"?"":tuiguangDTOs[i].benrishuliang)</td> <td>@(tuiguangDTOs[i].benriqingkuang=="0"?"":tuiguangDTOs[i].benriqingkuang)</td> <td>@(tuiguangDTOs[i].dangrijixiao=="0"?"":tuiguangDTOs[i].dangrijixiao)</td> </tr> } } } </tbody> </table> </div> <div class=""> <h3>二、拜访客户</h3> </div> <div class="clearfix layer-area" style="padding-bottom:15px;"> <table class="pure-table pure-table-bordered" style="width:100%;"> <thead> <tr> <th style="width:8%;"> 序号 </th> <th style="width:15%;"> 拜访类型 </th> <th style="width:15%;"> 本月拜访数量 </th> <th style="width:15%;"> 本月任务 </th> <th style="width:15%;"> 本日拜访数量 </th> <th style="width:15%;"> 本日任务 </th> <th style="width:15%;"> 当日绩效考核 </th> </tr> </thead> <tbody> @{ if (baifangkehuDTOs != null && baifangkehuDTOs.Count > 0) { for (int i = 0; i < baifangkehuDTOs.Count; i++) { <tr> <td>@(i+1)</td> <td>@baifangkehuDTOs[i].gongzuo</td> <td>@(baifangkehuDTOs[i].benyueshuliang=="0"?"": baifangkehuDTOs[i].benyueshuliang)</td> <td>@(baifangkehuDTOs[i].benyueqingkuang=="0"?"": baifangkehuDTOs[i].benyueqingkuang)</td> <td>@(baifangkehuDTOs[i].benrishuliang=="0"?"": baifangkehuDTOs[i].benrishuliang)</td> <td>@(baifangkehuDTOs[i].benriqingkuang=="0"?"": baifangkehuDTOs[i].benriqingkuang)</td> <td>@(baifangkehuDTOs[i].dangrijixiao=="0"?"": baifangkehuDTOs[i].dangrijixiao)</td> </tr> } } } </tbody> </table> </div> <div class=""> <h3>三、新增订单</h3> </div> <div class="clearfix layer-area" style="padding-bottom:15px;"> <table class="pure-table pure-table-bordered" style="width:100%;"> <thead> <tr> <th style="width:8%;"> 序号 </th> <th style="width:15%;"> 订单编号 </th> <th style="width:15%;"> 订单名称 </th> <th style="width:15%;"> 单价 </th> <th style="width:15%;"> 数量 </th> <th style="width:15%;"> 金额 </th> <th style="width:15%;"> 本月累计金额 </th> </tr> </thead> <tbody> @{ if (dingdanDTOs != null && dingdanDTOs.Count > 0) { for (int i = 0; i < dingdanDTOs.Count; i++) { <tr> <td>@(i+1)</td> <td>@dingdanDTOs[i].dingdanbianhao</td> <td>@dingdanDTOs[i].dingdanmingcheng</td> <td>@(dingdanDTOs[i].danjia == "0"?"": dingdanDTOs[i].danjia)</td> <td>@(dingdanDTOs[i].shuliang == "0"?"": dingdanDTOs[i].shuliang)</td> <td>@(dingdanDTOs[i].jine == "0"?"": dingdanDTOs[i].jine)</td> <td>@(dingdanDTOs[i].benyueleijijine == "0"?"": dingdanDTOs[i].benyueleijijine)</td> </tr> } } } </tbody> </table> </div> <div class=""> <h3>四、资料维护</h3> </div> <div class="clearfix layer-area" style="padding-bottom:15px;"> <table class="pure-table pure-table-bordered" style="width:100%;"> <thead> <tr> <th style="width:8%;"> 序号 </th> <th style="width:15%;"> 资料类别 </th> <th style="width:15%;"> 本月数量 </th> <th style="width:15%;"> 本日数量 </th> <th style="width:15%;"> 当日绩效考核 </th> </tr> </thead> <tbody> @{ if (ziliaoweihuDTOs != null && ziliaoweihuDTOs.Count > 0) { for (int i = 0; i < ziliaoweihuDTOs.Count; i++) { <tr> <td>@(i+1)</td> <td>@ziliaoweihuDTOs[i].gongzuo</td> <td>@(ziliaoweihuDTOs[i].benyueshuliang=="0"?"": ziliaoweihuDTOs[i].benyueshuliang)</td> <td>@(ziliaoweihuDTOs[i].benrishuliang=="0"?"": ziliaoweihuDTOs[i].benrishuliang)</td> <td>@(ziliaoweihuDTOs[i].dangrijixiao=="0"?"": ziliaoweihuDTOs[i].dangrijixiao)</td> </tr> } } } </tbody> </table> </div> <div class=""> <h3>五、项目实施</h3> </div> <div class="clearfix layer-area" style="padding-bottom:15px;"> <table class="pure-table pure-table-bordered" style="width:100%;"> <thead> <tr> <th style="width:8%;"> 序号 </th> <th style="width:15%;"> 实施类别 </th> <th style="width:15%;"> 本月数量 </th> <th style="width:15%;"> 本日数量 </th> <th style="width:15%;"> 当日绩效考核 </th> </tr> </thead> <tbody> @{ if (xiangmushishiDTOs != null && xiangmushishiDTOs.Count > 0) { for (int i = 0; i < xiangmushishiDTOs.Count; i++) { <tr> <td>@(i+1)</td> <td>@xiangmushishiDTOs[i].gongzuo</td> <td>@(xiangmushishiDTOs[i].benyueshuliang=="0"?"": xiangmushishiDTOs[i].benyueshuliang)</td> <td>@(xiangmushishiDTOs[i].benrishuliang=="0"?"": xiangmushishiDTOs[i].benrishuliang)</td> <td>@(xiangmushishiDTOs[i].dangrijixiao=="0"?"": xiangmushishiDTOs[i].dangrijixiao)</td> </tr> } } } </tbody> </table> </div> </div> </div> </div> </div> </div> </div> <div class="wrapper wrapper-content" style="margin-top:0px"></div> <div class="ibox-content" id="top" style="z-index:100; position:fixed; height:50px; width:100%;bottom:0; text-align: right; padding-top:8px "> </div> </div> </body> <script type="text/javascript"> var hh = document.body.clientHeight+700+(60*@nookcount);; $("#div_content").height(hh); toastr.options = { "closeButton": true, "debug": false, "progressBar": true, "positionClass": "toast-bottom-right", "onclick": null, "showDuration": "300", "hideDuration": "600", "timeOut": "4500", "extendedTimeOut": "600", "showEasing": "swing", "hideEasing": "linear", "showMethod": "fadeIn", "hideMethod": "fadeOut" }; function printHtml(html) { //var bodyHtml = document.body.innerHTML; //document.body.innerHTML = html; $("#printl").hide(); window.print(); //document.body.innerHTML = bodyHtml; $("#printl").show(); } function onprint() { var html = $("#printArea").html(); printHtml(html); } </script> </html> zhengcaioa/zhengcaioa/appsettings.Development.json
@@ -1,6 +1,7 @@ { "ConnectionStrings": { "DefaultConnection": "server=.;database=zhengcaioa;uid=sa;pwd=123456;" "DefaultConnection": "server=.;database=zhengcaioa;uid=sa;pwd=123456;", "zcwebConnection": "server=localhost;database=zcweb;uid=sa;pwd=123456;" }, "Logging": { "LogLevel": { zhengcaioa/zhengcaioa/appsettings.json
@@ -1,6 +1,7 @@ { "ConnectionStrings": { "DefaultConnection": "server=localhost;database=zhengcaioa;uid=sa;pwd=123456;" "DefaultConnection": "server=localhost;database=zhengcaioa;uid=sa;pwd=123456;", "zcwebConnection": "server=localhost;database=zcweb;uid=sa;pwd=123456;" }, "Logging": { "LogLevel": {