zhengcaioa/CommonToolsCore/AutoMapperConfigs.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
zhengcaioa/DTO/TongjiBaoBiaoDTO.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
zhengcaioa/IServices/ICooperatecustomCustomerService.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
zhengcaioa/Services/CooperatecustomCustomerService.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
zhengcaioa/zhengcaioa/Controllers/admin/TongjiBaoBiaoController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
zhengcaioa/zhengcaioa/Timer/TimerGetShopUsersService.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
zhengcaioa/zhengcaioa/Views/TongjiBaoBiao/Index.cshtml | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
zhengcaioa/zhengcaioa/Views/TongjiBaoBiao/IndexSuoyou.cshtml | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
zhengcaioa/CommonToolsCore/AutoMapperConfigs.cs
@@ -225,6 +225,9 @@ CreateMap<DtChannelArticleNews, DtChannelArticleNewsDTO>(); CreateMap<DtChannelArticleNewsDTO, DtChannelArticleNews>(); CreateMap<AdmEvaluate, AdmEvaluateDTO>(); CreateMap<AdmEvaluateDTO, AdmEvaluate>(); } } } zhengcaioa/DTO/TongjiBaoBiaoDTO.cs
@@ -25,4 +25,16 @@ public string jine { get; set; } public string benyueleijijine { get; set; } } public class TongjibaobiaobaobiaoDTO { public List<TongjiBaoBiaoDTO> tuiguangDTOs { get; set; } public List<TongjiBaoBiaoDTO> baifangkehuDTOs { get; set; } public List<TongjiDingDanDTO> dingdanDTOs { get; set; } public List<TongjiBaoBiaoDTO> ziliaoweihuDTOs { get; set; } public List<TongjiBaoBiaoDTO> xiangmushishiDTOs { get; set; } public int dingdanDTOsCount { get; set; } public string UserName { get; set; } } } zhengcaioa/IServices/ICooperatecustomCustomerService.cs
@@ -17,7 +17,7 @@ ResultEntity ModifyStatus(string id, string userid); List<CooperatecustomCustomerDTO> GetList(); List<CooperatecustomCustomerDTO> GetList(string HuiyuanId = "",string Name=""); List<CooperatecustomCustomerDTO> GetListsalary(string userid, DateTime datemin, DateTime datemax); zhengcaioa/Services/CooperatecustomCustomerService.cs
@@ -173,14 +173,26 @@ var query = (from a in _context.CooperatecustomCustomers join b in listCode.Where(x => x.CodeTable == "CooperatecustomCustomer" && x.CodeField == "khly") on a.Khly equals b.CodeSn into bsss from bbb in bsss.DefaultIfEmpty() join c in listCode.Where(x => x.CodeTable == "CooperatecustomCustomer" && x.CodeField == "hyfl") on a.Hyfl equals c.CodeSn into csss from ccc in csss.DefaultIfEmpty() join d in listCode.Where(x => x.CodeTable == "CooperatecustomCustomer" && x.CodeField == "khlx") on a.Khlx equals d.CodeSn into dsss from ddd in dsss.DefaultIfEmpty() join e in _context.PltUsers.Where(x => x.RecStatus == "A" && x.Zhiwustatus == "A" && x.IsYwjl == "A") on a.Ywjl equals e.Id into esss from abi in esss.DefaultIfEmpty() join i in _context.CooperOrders.Where(x => x.RecStatus == "A" && x.ChedanStatus !="A" ).GroupBy(q => new { q.Khdw }).Select(q => new { Khdw = q.Key.Khdw, @@ -191,9 +203,24 @@ on a.Id equals i.Khdw into isss from iii in isss.DefaultIfEmpty() join f in _context.Areas on a.Sheng equals f.CodeId into fsss from fff in fsss.DefaultIfEmpty() join g in _context.Areas on a.City equals g.CodeId into gsss from ggg in gsss.DefaultIfEmpty() join h in _context.Areas on a.AreaId equals h.CodeId into hsss from hhh in hsss.DefaultIfEmpty() where a.RecStatus == "A" && (string.IsNullOrWhiteSpace(searchEntity.Createtime) || (a.Createtime >= Createtimestart && a.Createtime <= Createtimeend)) @@ -218,12 +245,12 @@ Hyfl = a.Hyfl, Khlx = a.Khlx, Ywjl = a.Ywjl, ShengName = f.Name + "-" + g.Name+ "-" + h.Name, CityName = g.Name, AreaIdName = h.Name, KhlyName = b.Comments, HyflName = c.Comments, KhlxName = d.Comments, ShengName = fff.Name + "-" + ggg.Name+ "-" + hhh.Name, CityName = ggg.Name, AreaIdName = hhh.Name, KhlyName = bbb.Comments, HyflName = ccc.Comments, KhlxName = ddd.Comments, YwjlName = abi.UserName, Name = a.Name, Postal = a.Postal, @@ -303,12 +330,22 @@ /// 获取所有有效合作客户 /// </summary> /// <returns></returns> public List<CooperatecustomCustomerDTO> GetList() public List<CooperatecustomCustomerDTO> GetList(string HuiyuanId = "", string Name = "") { var listPosition = _context.CooperatecustomCustomers.Where(r => r.RecStatus == "A").ToList(); if (!string.IsNullOrEmpty(HuiyuanId)) { listPosition = listPosition.Where(x => x.HuiyuanId == HuiyuanId).ToList(); } if (!string.IsNullOrEmpty(Name)) { listPosition = listPosition.Where(x => x.Name == Name).ToList(); } var list = _mapper.Map<List<CooperatecustomCustomerDTO>>(listPosition); return list; } zhengcaioa/zhengcaioa/Controllers/admin/TongjiBaoBiaoController.cs
@@ -1159,6 +1159,12 @@ dingdanDTOs.Add(dingdanDTO); } int dingdanDTOsCount = 1; if (dingdanDTOs.Count == 0 && benyuezonge == 0) { dingdanDTOsCount = 0; } if (dingdanDTOs.Count == 0) { TongjiDingDanDTO dingdanDTO = new TongjiDingDanDTO(); @@ -1720,6 +1726,10 @@ ViewBag.dingdanDTOs = dingdanDTOs; ViewBag.ziliaoweihuDTOs = ziliaoweihuDTOs; ViewBag.xiangmushishiDTOs = xiangmushishiDTOs; ViewBag.dingdanDTOsCount = dingdanDTOsCount; ViewBag.UserName = curentuser.UserName; ViewBag.Tongjitime = chauxnshijian.ToString("yyyy-MM-dd"); @@ -1738,17 +1748,23 @@ { DateTime.TryParse(Tongjitime, out chauxnshijian); } string position = curentuser.HrPosition; string Userid = curentuser.Id; if (!string.IsNullOrEmpty(userid)) var userDTOs = _userService.GetList(); string[] Userids = null; if (!string.IsNullOrEmpty(userid) && userid!= "null") { Userid = userid; position = _userService.GetPltUserEntity(Userid).HrPosition; Userids = userid.Split(','); ; } else { Userids = userDTOs.OrderBy(x => x.UserSn).Select(x => x.Id).ToArray(); } List<TongjibaobiaobaobiaoDTO> tongjibaobiaobaobiaoDTOs = new List<TongjibaobiaobaobiaoDTO>(); if (Userids!=null&& Userids.Length > 0) { DateTime dateminkaoqin = new DateTime(chauxnshijian.Year, chauxnshijian.Month, 1); DateTime datemaxkaoqin = dateminkaoqin.AddMonths(1); int Yingchuqin = 0; @@ -1761,7 +1777,7 @@ 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 == position).ToList(); //计算每月工作日 @@ -1801,6 +1817,14 @@ dateminkaoqin = dateminkaoqin.AddDays(1); } dateminkaoqin = new DateTime(chauxnshijian.Year, chauxnshijian.Month, 1); foreach (var Userid in Userids) { var userDTO = userDTOs.Where(x=>x.Id == Userid).FirstOrDefault(); string position = userDTO.HrPosition; var hrJixiaotichengThis = hrJixiaotichengDTOs.Where(x => x.PostId == position).ToList(); List<TongjiBaoBiaoDTO> tuiguangDTOs = new List<TongjiBaoBiaoDTO>(); @@ -2788,6 +2812,12 @@ dingdanDTOs.Add(dingdanDTO); } int dingdanDTOsCount = 1; if (dingdanDTOs.Count == 0 && benyuezonge == 0) { dingdanDTOsCount = 0; } if (dingdanDTOs.Count == 0) { TongjiDingDanDTO dingdanDTO = new TongjiDingDanDTO(); @@ -3344,15 +3374,36 @@ xiangmushishiDTOs.Add(zhiyiDTO); #endregion ViewBag.tuiguangDTOs = tuiguangDTOs; ViewBag.baifangkehuDTOs = baifangkehuDTOs; ViewBag.dingdanDTOs = dingdanDTOs; ViewBag.ziliaoweihuDTOs = ziliaoweihuDTOs; ViewBag.xiangmushishiDTOs = xiangmushishiDTOs; TongjibaobiaobaobiaoDTO tongjibaobiaobaobiaoDTO = new TongjibaobiaobaobiaoDTO(); tongjibaobiaobaobiaoDTO.tuiguangDTOs = tuiguangDTOs; tongjibaobiaobaobiaoDTO.baifangkehuDTOs = baifangkehuDTOs; tongjibaobiaobaobiaoDTO.dingdanDTOs = dingdanDTOs; tongjibaobiaobaobiaoDTO.ziliaoweihuDTOs = ziliaoweihuDTOs; tongjibaobiaobaobiaoDTO.xiangmushishiDTOs = xiangmushishiDTOs; tongjibaobiaobaobiaoDTO.dingdanDTOsCount = dingdanDTOsCount; tongjibaobiaobaobiaoDTO.UserName = userDTO.UserName; tongjibaobiaobaobiaoDTOs.Add(tongjibaobiaobaobiaoDTO); } } ViewBag.tongjibaobiaobaobiaoDTOs = tongjibaobiaobaobiaoDTOs; ViewBag.Userid = Userids; ViewBag.Tongjitime = chauxnshijian.ToString("yyyy-MM-dd"); ViewBag.Userid = Userid; ViewData["UserIds"] = _userService.GetList(); ViewData["UserIds"] = userDTOs; return View(); } zhengcaioa/zhengcaioa/Timer/TimerGetShopUsersService.cs
@@ -5,6 +5,7 @@ using Microsoft.Extensions.DependencyInjection; using Microsoft.Extensions.Hosting; using Microsoft.Extensions.Logging; using Newtonsoft.Json; using Newtonsoft.Json.Linq; using System; using System.Collections.Generic; @@ -26,7 +27,8 @@ private readonly IConfiguration _configuration; private readonly ILiaotianService _liaotianService; private readonly IHttpClientFactory _clientFactory; private readonly IDtChannelArticleNewsService _dtChannelArticleNewsService; private readonly ICooperatecustomCustomerService _cooperatecustomCustomerService; public TimerGetShopUsersService(ILogger<TimerGetShopUsersService> logger, IServiceScopeFactory factory) { @@ -34,7 +36,9 @@ _configuration = factory.CreateScope().ServiceProvider.GetRequiredService<IConfiguration>(); _liaotianService = factory.CreateScope().ServiceProvider.GetRequiredService<ILiaotianService>(); _clientFactory = factory.CreateScope().ServiceProvider.GetRequiredService<IHttpClientFactory>(); _dtChannelArticleNewsService = factory.CreateScope().ServiceProvider.GetRequiredService<IDtChannelArticleNewsService>(); _cooperatecustomCustomerService = factory.CreateScope().ServiceProvider.GetRequiredService<ICooperatecustomCustomerService>(); } protected override async Task ExecuteAsync(CancellationToken stoppingToken) @@ -49,7 +53,7 @@ _logger.LogInformation("TimerGetShopUsersService 开始执行"); _logger.LogInformation(datenow.ToString("yyyy-MM-dd HH:mm:ss")); //每个小时计算一次 if (datenow.Hour <= DateTime.Now.Hour) if (datenow.Hour == DateTime.Now.Hour) //if (true) { @@ -80,17 +84,7 @@ { 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() { @@ -106,68 +100,17 @@ resultEntity.Result = false; //书城 string result = string.Empty; Uri getUrl = new Uri(Shuchengurl+ GetShopUsers+ "?start=2021-07-1&end=2021-07-12"); var httpClient = _clientFactory.CreateClient(); httpClient.Timeout = new TimeSpan(0, 0, 60); var Result = await httpClient.GetAsync(getUrl); result = Result.Content.ReadAsStringAsync().Result; _logger.LogInformation("result:" + result); //会员 string result1 = string.Empty; Uri postUrl = new Uri(huiyuanurl + GetDateFirstOrderUser); JObject questions = new JObject(); questions.Add("start", "2021-07-12 12:36:30"); questions.Add("end", "2021-07-14 12:36:30"); string requestJson = questions.ToString(); using (HttpContent httpContent = new StringContent(requestJson)) { httpContent.Headers.ContentType = new MediaTypeHeaderValue("application/json"); var httpClient1 = _clientFactory.CreateClient(); httpClient1.Timeout = new TimeSpan(0, 0, 60); var Result1 = await httpClient1.PostAsync(postUrl, httpContent); result1 = Result1.Content.ReadAsStringAsync().Result; } _logger.LogInformation("result1:" + result1); string result2 = string.Empty; Uri postUrl2 = new Uri(huiyuanurl + GetUserinfoAndRule); JObject questions2 = new JObject(); questions2.Add("UserID", "248768ac-d083-462a-5bb4-08d940e7bc81"); string requestJson2 = questions2.ToString(); using (HttpContent httpContent = new StringContent(requestJson2)) { httpContent.Headers.ContentType = new MediaTypeHeaderValue("application/json"); var httpClient2 = _clientFactory.CreateClient(); httpClient2.Timeout = new TimeSpan(0, 0, 60); var Result2 = await httpClient2.PostAsync(postUrl2, httpContent); result2 = Result2.Content.ReadAsStringAsync().Result; } _logger.LogInformation("result2:" + result2); using (TransactionScope scope = new TransactionScope()) { //using (TransactionScope scope = new TransactionScope()) //{ //获取最后更新时间 DateTime start = DateTime.Now.AddYears(-10); DateTime end = DateTime.Now; @@ -184,7 +127,214 @@ //获取客户并且保存到合作客户 #region 书城 string result = string.Empty; Uri getUrl = new Uri(Shuchengurl + GetShopUsers + "?start="+ start.ToString("yyyy-MM-dd HH:mm:ss") + "&end="+ end.ToString("yyyy-MM-dd HH:mm:ss")); var httpClient = _clientFactory.CreateClient(); httpClient.Timeout = new TimeSpan(0, 0, 60); var Result = await httpClient.GetAsync(getUrl); result = Result.Content.ReadAsStringAsync().Result; _logger.LogInformation("result:" + result); JObject jobjectresult = (JObject)JsonConvert.DeserializeObject(result); if (jobjectresult["code"] != null && jobjectresult["code"].ToString() == "1") { if(jobjectresult["returnObj"] != null && jobjectresult["returnObj"].ToString() != "") { JArray hits = (JArray)jobjectresult["returnObj"]; foreach (var hit in hits) { string id = hit["id"].ToString().ToLower(); CooperatecustomCustomerDTO cooperatecustomCustomerDTO = _cooperatecustomCustomerService.GetList(id).FirstOrDefault(); //如果不存在关联客户 if (cooperatecustomCustomerDTO == null) { string result2 = string.Empty; Uri postUrl2 = new Uri(huiyuanurl + GetUserinfoAndRule); JObject questions2 = new JObject(); questions2.Add("UserID", id); string requestJson2 = questions2.ToString(); using (HttpContent httpContent = new StringContent(requestJson2)) { httpContent.Headers.ContentType = new MediaTypeHeaderValue("application/json"); var httpClient2 = _clientFactory.CreateClient(); httpClient2.Timeout = new TimeSpan(0, 0, 60); var Result2 = await httpClient2.PostAsync(postUrl2, httpContent); result2 = Result2.Content.ReadAsStringAsync().Result; } _logger.LogInformation("result2:" + result2); JObject jobjectresult2 = (JObject)JsonConvert.DeserializeObject(result2); if (jobjectresult2["code"] == null && jobjectresult2["code"].ToString() != "1") { throw new Exception(jobjectresult2["msg"].ToString()); } JObject jobjectkehu = (JObject)jobjectresult2["data"]; if (jobjectkehu["Name"] == null || jobjectkehu["Name"].ToString() == "") { throw new Exception("未找到对应的会员!"); } cooperatecustomCustomerDTO = _cooperatecustomCustomerService.GetList("", jobjectkehu["Name"].ToString()).FirstOrDefault(); //如果不存在当前名字的客户 if (cooperatecustomCustomerDTO == null) { cooperatecustomCustomerDTO = new CooperatecustomCustomerDTO(); cooperatecustomCustomerDTO.Name = jobjectkehu["Name"].ToString(); cooperatecustomCustomerDTO.Tel = jobjectkehu["phonecode"].ToString(); cooperatecustomCustomerDTO.Phone = jobjectkehu["phonecode"].ToString(); cooperatecustomCustomerDTO.HuiyuanId = id; //cooperatecustomCustomerDTO.Remark = hit["personal"].ToString() + "下单时间" + hit["Firsttime"].ToString(); cooperatecustomCustomerDTO.Khly = "01"; cooperatecustomCustomerDTO.Creater = "1"; cooperatecustomCustomerDTO.Createtime = DateTime.Now; cooperatecustomCustomerDTO.Modifier = cooperatecustomCustomerDTO.Creater; cooperatecustomCustomerDTO.Modifytime = cooperatecustomCustomerDTO.Createtime; cooperatecustomCustomerDTO.ShrName = hit["accept_name"].ToString(); cooperatecustomCustomerDTO.ShrTel = hit["mobile"].ToString(); cooperatecustomCustomerDTO.ShrAddress = hit["area"].ToString() + hit["address"].ToString(); resultEntity = _cooperatecustomCustomerService.save(cooperatecustomCustomerDTO); if (!resultEntity.Result) { throw new Exception("保存合作客户:" + cooperatecustomCustomerDTO.Name + "出错!"); } } else { cooperatecustomCustomerDTO.HuiyuanId = id; cooperatecustomCustomerDTO.ShrName = hit["accept_name"].ToString(); cooperatecustomCustomerDTO.ShrTel = hit["mobile"].ToString(); cooperatecustomCustomerDTO.ShrAddress = hit["area"].ToString() + hit["address"].ToString(); resultEntity = _cooperatecustomCustomerService.save(cooperatecustomCustomerDTO); if (!resultEntity.Result) { throw new Exception("保存合作客户:" + cooperatecustomCustomerDTO.Name + "出错!"); } } } else { cooperatecustomCustomerDTO.HuiyuanId = id; cooperatecustomCustomerDTO.ShrName = hit["accept_name"].ToString(); cooperatecustomCustomerDTO.ShrTel = hit["mobile"].ToString(); cooperatecustomCustomerDTO.ShrAddress = hit["area"].ToString() + hit["address"].ToString(); resultEntity = _cooperatecustomCustomerService.save(cooperatecustomCustomerDTO); if (!resultEntity.Result) { throw new Exception("保存合作客户:" + cooperatecustomCustomerDTO.Name + "出错!"); } } } } } else { throw new Exception(jobjectresult["error"].ToString()); } #endregion #region 会员 string result1 = string.Empty; Uri postUrl = new Uri(huiyuanurl + GetDateFirstOrderUser); JObject questions = new JObject(); questions.Add("start", start.ToString("yyyy-MM-dd HH:mm:ss")); questions.Add("end", end.ToString("yyyy-MM-dd HH:mm:ss")); string requestJson = questions.ToString(); using (HttpContent httpContent = new StringContent(requestJson)) { httpContent.Headers.ContentType = new MediaTypeHeaderValue("application/json"); var httpClient1 = _clientFactory.CreateClient(); httpClient1.Timeout = new TimeSpan(0, 0, 60); var Result1 = await httpClient1.PostAsync(postUrl, httpContent); result1 = Result1.Content.ReadAsStringAsync().Result; } _logger.LogInformation("result1:" + result1); JObject jobject = (JObject)JsonConvert.DeserializeObject(result1); if (jobject["code"] != null && jobject["code"].ToString() == "1") { if (jobject["data"] != null && jobject["data"].ToString() != "") { JArray hits = (JArray)jobject["data"]; foreach (var hit in hits) { CooperatecustomCustomerDTO cooperatecustomCustomerDTO = _cooperatecustomCustomerService.GetList(hit["ID"].ToString()).FirstOrDefault(); //如果不存在关联客户 if (cooperatecustomCustomerDTO == null) { cooperatecustomCustomerDTO = _cooperatecustomCustomerService.GetList("", hit["Name"].ToString()).FirstOrDefault(); //如果不存在当前名字的客户 if (cooperatecustomCustomerDTO == null) { cooperatecustomCustomerDTO = new CooperatecustomCustomerDTO(); cooperatecustomCustomerDTO.Name = hit["Name"].ToString(); cooperatecustomCustomerDTO.Tel = hit["PhoneCode"].ToString(); cooperatecustomCustomerDTO.Phone = hit["PhoneCode"].ToString(); cooperatecustomCustomerDTO.HuiyuanId = hit["ID"].ToString(); cooperatecustomCustomerDTO.Remark = hit["personal"].ToString() + "下单时间" + hit["Firsttime"].ToString(); cooperatecustomCustomerDTO.Khly = "01"; cooperatecustomCustomerDTO.Creater = "1"; cooperatecustomCustomerDTO.Createtime = DateTime.Now; cooperatecustomCustomerDTO.Modifier = cooperatecustomCustomerDTO.Creater; cooperatecustomCustomerDTO.Modifytime = cooperatecustomCustomerDTO.Createtime; resultEntity = _cooperatecustomCustomerService.save(cooperatecustomCustomerDTO); if (!resultEntity.Result) { throw new Exception("保存合作客户:" + cooperatecustomCustomerDTO.Name + "出错!"); } } else { cooperatecustomCustomerDTO.HuiyuanId = hit["ID"].ToString(); resultEntity = _cooperatecustomCustomerService.save(cooperatecustomCustomerDTO); if (!resultEntity.Result) { throw new Exception("保存合作客户:" + cooperatecustomCustomerDTO.Name + "出错!"); } } } } } } else { throw new Exception(jobject["msg"].ToString()); } #endregion //保存最后更新时间 @@ -204,8 +354,8 @@ throw new Exception("保存更新时间出错!"); } scope.Complete(); } // scope.Complete(); //} zhengcaioa/zhengcaioa/Views/TongjiBaoBiao/Index.cshtml
@@ -12,7 +12,16 @@ string Tongjitime = ViewBag.Tongjitime as string; string UserName = ViewBag.UserName as string; int nookcount = dingdanDTOs == null ? 0 : dingdanDTOs.Count; int dingdanDTOsCount = ViewBag.dingdanDTOsCount; int tuiguangDTOsCount = tuiguangDTOs.Count; int baifangkehuDTOsCount = baifangkehuDTOs.Count; int ziliaoweihuDTOsCount = ziliaoweihuDTOs.Count; int xiangmushishiDTOsCount = xiangmushishiDTOs.Count; int aaa = 1; } <!DOCTYPE html> @@ -180,7 +189,7 @@ </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"> @@ -193,7 +202,7 @@ </div>*@ <div class="row"> <div class="clearfix layer-area" style="padding-bottom:15px;"> <div class="clearfix layer-area" style="padding-bottom:15px;" id="chaxunxiashi"> <label class="text-right col-sm-1 col-md-1 control-label">统计时间</label> <div class="col-sm-2 col-md-2"> @@ -206,9 +215,18 @@ </a> </div> </div> <div id="printArea"> <div class=""> <h3>一、推广</h3> <h3> @UserName </h3> </div> @if (tuiguangDTOsCount > 0) { <div class=""> <h3>@aaa 、推广</h3> </div> @@ -260,14 +278,18 @@ </tr> } } aaa = aaa + 1; } </tbody> </table> </div> } @if (baifangkehuDTOsCount > 0) { <div class=""> <h3>二、拜访客户</h3> <h3>@aaa 、拜访客户</h3> </div> @@ -319,14 +341,18 @@ </tr> } } aaa = aaa + 1; } </tbody> </table> </div> } @if (dingdanDTOsCount > 0) { <div class=""> <h3>三、新增订单</h3> <h3>@aaa 、新增订单</h3> </div> @@ -379,13 +405,17 @@ </tr> } } aaa = aaa + 1; } </tbody> </table> </div> } @if (ziliaoweihuDTOsCount > 0) { <div class=""> <h3>四、资料维护</h3> <h3>@aaa 、资料维护</h3> </div> @@ -430,16 +460,20 @@ </tr> } } aaa = aaa + 1; } </tbody> </table> </div> } @if (xiangmushishiDTOsCount > 0) { <div class=""> <h3>五、项目实施</h3> <h3>@aaa 、项目实施</h3> </div> @@ -484,10 +518,15 @@ </tr> } } aaa = aaa + 1; } </tbody> </table> </div> } </div> </div> @@ -500,12 +539,9 @@ <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, @@ -536,13 +572,17 @@ //var bodyHtml = document.body.innerHTML; //document.body.innerHTML = html; $("#printl").hide(); $("#chaxunxiashi").hide(); window.print(); //document.body.innerHTML = bodyHtml; $("#printl").show(); $("#chaxunxiashi").show(); } function onprint() { var html = $("#printArea").html(); printHtml(html); } </script> </html> zhengcaioa/zhengcaioa/Views/TongjiBaoBiao/IndexSuoyou.cshtml
@@ -3,17 +3,36 @@ @{ 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>; List<PltUserDTO> UserIds = ViewData["UserIds"] as List<PltUserDTO>; //员工 string Tongjitime = ViewBag.Tongjitime as string; string Userid = ViewBag.Userid as string; int nookcount = dingdanDTOs == null ? 0 : dingdanDTOs.Count; string[] Userid = ViewBag.Userid as string[]; List<TongjibaobiaobaobiaoDTO> tongjibaobiaobaobiaoDTOs = ViewBag.tongjibaobiaobaobiaoDTOs as List<TongjibaobiaobaobiaoDTO>; //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 dingdanDTOsCount = ViewBag.dingdanDTOsCount; //int tuiguangDTOsCount = tuiguangDTOs.Count; //int baifangkehuDTOsCount = baifangkehuDTOs.Count; //int ziliaoweihuDTOsCount = ziliaoweihuDTOs.Count; //int xiangmushishiDTOsCount = xiangmushishiDTOs.Count; //int aaa = 1; } <!DOCTYPE html> @@ -194,7 +213,7 @@ </div>*@ <div class="row"> <div class="clearfix layer-area" style="padding-bottom:15px;"> <div class="clearfix layer-area" style="padding-bottom:15px;" id="chaxunxiashi"> <label class="text-right col-sm-1 col-md-1 control-label">统计时间</label> <div class="col-sm-2 col-md-2"> @@ -204,25 +223,25 @@ <label class="text-right col-sm-1 col-md-1 control-label">员工</label> <div class="col-sm-2 col-md-2"> <select id="UserId" class="form-control" name="UserId" data-placeholder="选择 序列 ..." style="font-weight:normal;"> <select id="UserId" class="form-control" name="UserId" data-placeholder="选择 序列 ..." style="font-weight:normal;" multiple> <option value="" hassubinfo="true">请选择</option> @foreach (var item in UserIds) { @if (!item.Id.Equals(Userid)) { <option value="@item.Id" hassubinfo="true"> @item.UserName </option> } else @if (Userid.Contains(item.Id)) { <option value="@item.Id" hassubinfo="true" selected="selected"> @item.UserName </option> } else { <option value="@item.Id" hassubinfo="true"> @item.UserName </option> } } } </select> @@ -234,9 +253,22 @@ </a> </div> </div> @foreach (var tongjibaobiaobaobiaoDTO in tongjibaobiaobaobiaoDTOs) { int aaa = 1; <div class=""> <h3>一、推广</h3> <h3> @tongjibaobiaobaobiaoDTO.UserName </h3> </div> @if (tongjibaobiaobaobiaoDTO.tuiguangDTOs.Count > 0) { <div class=""> <h3>@aaa 、推广</h3> </div> @@ -273,29 +305,35 @@ </thead> <tbody> @{ if (tuiguangDTOs != null && tuiguangDTOs.Count > 0) if (tongjibaobiaobaobiaoDTO.tuiguangDTOs != null && tongjibaobiaobaobiaoDTO.tuiguangDTOs.Count > 0) { for (int i = 0; i < tuiguangDTOs.Count; i++) for (int i = 0; i < tongjibaobiaobaobiaoDTO.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> <td>@tongjibaobiaobaobiaoDTO.tuiguangDTOs[i].gongzuo</td> <td>@(tongjibaobiaobaobiaoDTO.tuiguangDTOs[i].benyueshuliang=="0"?"": tongjibaobiaobaobiaoDTO.tuiguangDTOs[i].benyueshuliang)</td> <td>@(tongjibaobiaobaobiaoDTO.tuiguangDTOs[i].benyueqingkuang=="0"?"": tongjibaobiaobaobiaoDTO.tuiguangDTOs[i].benyueqingkuang)</td> <td>@(tongjibaobiaobaobiaoDTO.tuiguangDTOs[i].benrishuliang=="0"?"": tongjibaobiaobaobiaoDTO.tuiguangDTOs[i].benrishuliang)</td> <td>@(tongjibaobiaobaobiaoDTO.tuiguangDTOs[i].benriqingkuang=="0"?"": tongjibaobiaobaobiaoDTO.tuiguangDTOs[i].benriqingkuang)</td> <td>@(tongjibaobiaobaobiaoDTO.tuiguangDTOs[i].dangrijixiao=="0"?"": tongjibaobiaobaobiaoDTO.tuiguangDTOs[i].dangrijixiao)</td> </tr> } } aaa = aaa + 1; } </tbody> </table> </div> } @if (tongjibaobiaobaobiaoDTO.baifangkehuDTOs.Count > 0) { <div class=""> <h3>二、拜访客户</h3> <h3>@aaa 、拜访客户</h3> </div> @@ -332,29 +370,33 @@ </thead> <tbody> @{ if (baifangkehuDTOs != null && baifangkehuDTOs.Count > 0) if (tongjibaobiaobaobiaoDTO.baifangkehuDTOs != null && tongjibaobiaobaobiaoDTO.baifangkehuDTOs.Count > 0) { for (int i = 0; i < baifangkehuDTOs.Count; i++) for (int i = 0; i < tongjibaobiaobaobiaoDTO.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> <td>@tongjibaobiaobaobiaoDTO.baifangkehuDTOs[i].gongzuo</td> <td>@(tongjibaobiaobaobiaoDTO.baifangkehuDTOs[i].benyueshuliang=="0"?"": tongjibaobiaobaobiaoDTO.baifangkehuDTOs[i].benyueshuliang)</td> <td>@(tongjibaobiaobaobiaoDTO.baifangkehuDTOs[i].benyueqingkuang=="0"?"": tongjibaobiaobaobiaoDTO.baifangkehuDTOs[i].benyueqingkuang)</td> <td>@(tongjibaobiaobaobiaoDTO.baifangkehuDTOs[i].benrishuliang=="0"?"": tongjibaobiaobaobiaoDTO.baifangkehuDTOs[i].benrishuliang)</td> <td>@(tongjibaobiaobaobiaoDTO.baifangkehuDTOs[i].benriqingkuang=="0"?"": tongjibaobiaobaobiaoDTO.baifangkehuDTOs[i].benriqingkuang)</td> <td>@(tongjibaobiaobaobiaoDTO.baifangkehuDTOs[i].dangrijixiao=="0"?"": tongjibaobiaobaobiaoDTO.baifangkehuDTOs[i].dangrijixiao)</td> </tr> } } aaa = aaa + 1; } </tbody> </table> </div> } @if (tongjibaobiaobaobiaoDTO.dingdanDTOsCount > 0) { <div class=""> <h3>三、新增订单</h3> <h3>@aaa 、新增订单</h3> </div> @@ -392,28 +434,32 @@ </thead> <tbody> @{ if (dingdanDTOs != null && dingdanDTOs.Count > 0) if (tongjibaobiaobaobiaoDTO.dingdanDTOs != null && tongjibaobiaobaobiaoDTO.dingdanDTOs.Count > 0) { for (int i = 0; i < dingdanDTOs.Count; i++) for (int i = 0; i < tongjibaobiaobaobiaoDTO.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> <td>@tongjibaobiaobaobiaoDTO.dingdanDTOs[i].dingdanbianhao</td> <td>@tongjibaobiaobaobiaoDTO.dingdanDTOs[i].dingdanmingcheng</td> <td>@(tongjibaobiaobaobiaoDTO.dingdanDTOs[i].danjia == "0"?"": tongjibaobiaobaobiaoDTO.dingdanDTOs[i].danjia)</td> <td>@(tongjibaobiaobaobiaoDTO.dingdanDTOs[i].shuliang == "0"?"": tongjibaobiaobaobiaoDTO.dingdanDTOs[i].shuliang)</td> <td>@(tongjibaobiaobaobiaoDTO.dingdanDTOs[i].jine == "0"?"": tongjibaobiaobaobiaoDTO.dingdanDTOs[i].jine)</td> <td>@(tongjibaobiaobaobiaoDTO.dingdanDTOs[i].benyueleijijine == "0"?"": tongjibaobiaobaobiaoDTO.dingdanDTOs[i].benyueleijijine)</td> </tr> } } aaa = aaa + 1; } </tbody> </table> </div> } @if (tongjibaobiaobaobiaoDTO.ziliaoweihuDTOs.Count > 0) { <div class=""> <h3>四、资料维护</h3> <h3>@aaa 、资料维护</h3> </div> @@ -445,29 +491,33 @@ </thead> <tbody> @{ if (ziliaoweihuDTOs != null && ziliaoweihuDTOs.Count > 0) if (tongjibaobiaobaobiaoDTO.ziliaoweihuDTOs != null && tongjibaobiaobaobiaoDTO.ziliaoweihuDTOs.Count > 0) { for (int i = 0; i < ziliaoweihuDTOs.Count; i++) for (int i = 0; i < tongjibaobiaobaobiaoDTO.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> <td>@tongjibaobiaobaobiaoDTO.ziliaoweihuDTOs[i].gongzuo</td> <td>@(tongjibaobiaobaobiaoDTO.ziliaoweihuDTOs[i].benyueshuliang=="0"?"": tongjibaobiaobaobiaoDTO.ziliaoweihuDTOs[i].benyueshuliang)</td> <td>@(tongjibaobiaobaobiaoDTO.ziliaoweihuDTOs[i].benrishuliang=="0"?"": tongjibaobiaobaobiaoDTO.ziliaoweihuDTOs[i].benrishuliang)</td> <td>@(tongjibaobiaobaobiaoDTO.ziliaoweihuDTOs[i].dangrijixiao=="0"?"": tongjibaobiaobaobiaoDTO.ziliaoweihuDTOs[i].dangrijixiao)</td> </tr> } } aaa = aaa + 1; } </tbody> </table> </div> } @if (tongjibaobiaobaobiaoDTO.xiangmushishiDTOs.Count > 0) { <div class=""> <h3>五、项目实施</h3> <h3>@aaa 、项目实施</h3> </div> @@ -499,24 +549,39 @@ </thead> <tbody> @{ if (xiangmushishiDTOs != null && xiangmushishiDTOs.Count > 0) if (tongjibaobiaobaobiaoDTO.xiangmushishiDTOs != null && tongjibaobiaobaobiaoDTO.xiangmushishiDTOs.Count > 0) { for (int i = 0; i < xiangmushishiDTOs.Count; i++) for (int i = 0; i < tongjibaobiaobaobiaoDTO.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> <td>@tongjibaobiaobaobiaoDTO.xiangmushishiDTOs[i].gongzuo</td> <td>@(tongjibaobiaobaobiaoDTO.xiangmushishiDTOs[i].benyueshuliang=="0"?"": tongjibaobiaobaobiaoDTO.xiangmushishiDTOs[i].benyueshuliang)</td> <td>@(tongjibaobiaobaobiaoDTO.xiangmushishiDTOs[i].benrishuliang=="0"?"": tongjibaobiaobaobiaoDTO.xiangmushishiDTOs[i].benrishuliang)</td> <td>@(tongjibaobiaobaobiaoDTO.xiangmushishiDTOs[i].dangrijixiao=="0"?"": tongjibaobiaobaobiaoDTO.xiangmushishiDTOs[i].dangrijixiao)</td> </tr> } } aaa = aaa + 1; } </tbody> </table> </div> } } <div class="clearfix layer-area" style="padding-bottom:15px;"> </div> </div> </div> @@ -532,8 +597,8 @@ </body> <script type="text/javascript"> var hh = document.body.clientHeight+700+(60*@nookcount);; $("#div_content").height(hh); //var hh = document.body.clientHeight+700; // $("#div_content").height(hh); toastr.options = { "closeButton": true, @@ -556,7 +621,6 @@ // 保存岗位信息 var chaxun = function () { window.location = "/TongjiBaoBiao/IndexSuoyou?Tongjitime=" + $("#Tongjitime").val() + "&userid=" + $("#UserId").val(); } @@ -564,9 +628,11 @@ //var bodyHtml = document.body.innerHTML; //document.body.innerHTML = html; $("#printl").hide(); $("#chaxunxiashi").hide(); window.print(); //document.body.innerHTML = bodyHtml; $("#printl").show(); $("#chaxunxiashi").show(); } function onprint() { var html = $("#printArea").html();