public Rtn <bool> next([FromBody] ResetPartnerInput input) { var partner = this.dataContext.partners.Find(input.partnerId); if (partner != null) { var nextPartners = (from p in this.dataContext.partners where p.sort >= partner.sort select p).ToList(); var nextFirsetPartner = (from p in nextPartners orderby p.sort select p).FirstOrDefault(); if (nextFirsetPartner != null) { Console.WriteLine("current:" + partner.sort + " next:" + nextFirsetPartner.sort); if (nextFirsetPartner.sort == partner.sort) { partner.sort += 1; this.dataContext.SaveChanges(); } else { var currentSort = partner.sort; partner.sort = nextFirsetPartner.sort; nextFirsetPartner.sort = currentSort; this.dataContext.SaveChanges(); } return(Rtn <bool> .Success(true, "后置成功")); } else { return(Rtn <bool> .Error("伙伴已置底")); } } else { return(Rtn <bool> .Error("伙伴不存在")); } }
public Rtn <List <Project> > listCompanayProjects() { var tokenUser = this.userService.getUserFromAuthcationHeader(); var projects = (from p in this.oaContext.projects where p.companyId == tokenUser.companyId select p).ToList(); return(Rtn <List <Project> > .Success(projects)); }
public Rtn <bool> pre([FromBody] ResetPartnerInput input) { var partner = this.dataContext.partners.Find(input.partnerId); if (partner != null) { var prePartners = (from p in this.dataContext.partners where p.sort <= partner.sort select p).ToList(); var preFirstPartner = (from p in prePartners orderby p.sort descending select p).FirstOrDefault(); if (preFirstPartner != null) { if (preFirstPartner.sort == partner.sort) { partner.sort -= 1; this.dataContext.SaveChanges(); return(Rtn <bool> .Success(true, "前置成功")); } else { var currentSort = partner.sort; partner.sort = preFirstPartner.sort; preFirstPartner.sort = currentSort; this.dataContext.SaveChanges(); return(Rtn <bool> .Success(true, "前置成功")); } } else { return(Rtn <bool> .Error("已经顶部了")); } } else { return(Rtn <bool> .Error("信息不存")); } }
public Rtn <WorkReport> addOaWorkReportInfo([FromForm] CreateWorkReportInput input) { var tokenUser = this.userService.getUserFromAuthcationHeader(); var newWorkreport = new WorkReport { type = input.type, title = input.title, subTime = DateUtil.getNowSeconds(), subPersonId = tokenUser.id, noticePersonIds = input.noticePersonIds, workorderDetailedId = input.workorderDetailedId, content = input.content, ccPersonIds = input.ccPersonIds }; if (input.enclosure != null) { var enclosures = input.enclosure.Split(";"); foreach (var enclosureId in enclosures) { var enclusure = this.oaContext.enclosures.Find(enclosureId); if (enclusure != null) { enclusure.fjId = newWorkreport.id; } } this.oaContext.SaveChanges(); } this.oaContext.workreports.Add(newWorkreport); this.oaContext.SaveChanges(); return(Rtn <WorkReport> .Success(newWorkreport)); }
public Rtn <Article> createComment([FromBody] CommentCreateInput input) { var article = this.db.articles.Find(input.articleId); if (article != null) { var newComment = new Comment { articleId = input.articleId, content = input.content }; this.db.comments.Add(newComment); if (article.commentNum != null) { article.commentNum++; } else { article.commentNum = 1; } this.db.SaveChanges(); return(Rtn <Article> .Success(article)); } else { return(Rtn <Article> .Error("文章不存在")); } }
public Rtn <object> jssdk(string origin) { #region v13.6.4之前的写法 ////获取时间戳 //var timestamp = JSSDKHelper.GetTimestamp(); ////获取随机码 //var nonceStr = JSSDKHelper.GetNoncestr(); //string ticket = JsApiTicketContainer.TryGetJsApiTicket(appId, secret); ////获取签名 //var signature = JSSDKHelper.GetSignature(ticket, nonceStr, timestamp, Request.Url.AbsoluteUri); //ViewData["AppId"] = appId; //ViewData["Timestamp"] = timestamp; //ViewData["NonceStr"] = nonceStr; //ViewData["Signature"] = signature; #endregion // var url = "http://" + HttpContext.Request.Host + HttpContext.Request.Path + HttpContext.Request.QueryString; Console.WriteLine("url:" + origin); System.Text.Encoding.RegisterProvider(System.Text.CodePagesEncodingProvider.Instance); var jssdkUiPackage = JSSDKHelper.GetJsSdkUiPackage(WechatConfig.AppId, WechatConfig.secret, origin); //ViewData["JsSdkUiPackage"] = jssdkUiPackage; //ViewData["AppId"] = appId; //ViewData["Timestamp"] = jssdkUiPackage.Timestamp; //ViewData["NonceStr"] = jssdkUiPackage.NonceStr; //ViewData["Signature"] = jssdkUiPackage.Signature; Console.WriteLine("生成测试参数", jssdkUiPackage.Signature); return(Rtn <object> .Success(jssdkUiPackage)); }
public object uploadMaterial([FromForm] UploadMarialInput input) { var newMaterial = new Material(); var filename = DateTime.Now.Subtract(new DateTime(1970, 1, 1, 0, 0, 0, 0)).TotalSeconds + input.name; //将源文件 读取成文件流 Stream fromFile = input.file.OpenReadStream(); var response = OSSService.uploadFile(fromFile, filename); var url = "http://image.fubang.airuanjian.vip/" + filename; Console.WriteLine(response); newMaterial.url = url; newMaterial.filename = filename; newMaterial.name = input.filename; newMaterial.size = input.size; var ext = input.filename.Split(".").Last(); switch (ext.ToLower()) { case "mp4": newMaterial.type = MaterialType.Video; break; case "jpg": case "png": newMaterial.type = MaterialType.Image; break; } newMaterial.ext = ext; this.dataContext.materials.Add(newMaterial); this.dataContext.SaveChanges(); return(Rtn <Material> .Success(newMaterial)); }
public Rtn <System.Collections.IEnumerable> searchWorkReport([FromForm] SearchWorkReportInput input) { var options = new DataSourceLoadOptions(); var tokenUser = this.userService.getUserFromAuthcationHeader(); options.Skip = input.pageSize * input.page; options.Take = input.pageSize; if (input.workReportType == Cucr.CucrSaas.App.DTO.WorkReportObjectType.MySubmitted) { var query = (from workreport in this.oaContext.workreports where workreport.subPersonId == tokenUser.id select workreport); var data = DataSourceLoader.Load(query, options).data; return(Rtn <System.Collections.IEnumerable> .Success(data)); } else if (input.workReportType == Cucr.CucrSaas.App.DTO.WorkReportObjectType.MyRecive) { var query = (from workreport in this.oaContext.workreports where workreport.ccPersonIds == tokenUser.id select workreport); var data = DataSourceLoader.Load(query, options).data; return(Rtn <System.Collections.IEnumerable> .Success(data)); } else { var query = (from workreport in this.oaContext.workreports where ("," + workreport.noticePersonIds + ",").Contains("," + tokenUser.id + ",") select workreport); var data = DataSourceLoader.Load(query, options).data; return(Rtn <System.Collections.IEnumerable> .Success(data)); } }
public Rtn <ChatRoom> createChatRoom([FromForm] CreateChatRoomInput input) { var tokenUser = this.userService.getUserFromAuthcationHeader(); var companyFrameworkIds = input.companyFrameworkIds.Split(";"); // 待加入的用户列表 var userList = new List <User> (); foreach (var cId in companyFrameworkIds) { var users = (from u in this.sysContext.users where u.companyFrameworkId == cId select u).ToList(); foreach (var u in users) { userList.Add(u); } } var joinUserIds = String.Join(";", (from u in userList select u.id).ToArray()) + ";" + input.userIds; var joinUserNum = joinUserIds.Trim().Split(";").Length; var newChatRoom = new ChatRoom { userId = tokenUser.id, status = ChatRoomStatus.Active, joinUserIds = joinUserIds, joinUserNum = joinUserNum, name = input.name, }; // new ChatMsg{content} return(Rtn <ChatRoom> .Success(newChatRoom)); }
public Rtn <Notice> noticeInfo([FromForm(Name = "noticeId")] string noticeId) { var notice = this.oaContext.notices.Find(noticeId); if (notice != null) { notice.user = this.sysContext.users.Find(notice.PersonId); if (notice.noticePerson != null) { var noticePersonStrArray = notice.noticePerson.Split(";").ToArray(); notice.noticePersonList = (from u in this.sysContext.users where noticePersonStrArray.Contains(u.id) select u).ToList(); } if (notice.noticeCompanyFrameworkIds != null) { var noticeCompanyFrameworkIdArr = notice.noticeCompanyFrameworkIds.Split(";").ToArray(); notice.noticeCompanyFrameworkList = (from c in this.sysContext.companyFrameworks where noticeCompanyFrameworkIdArr.Contains(c.id) select c).ToList(); } var enclusures = (from e in this.oaContext.enclosures where e.fjId == notice.id select e).ToList(); notice.imageList = (from e in enclusures where e.fjType == "image" select e).ToList(); notice.enclusureList = (from e in enclusures where e.fjType != "image" select e).ToList(); return(Rtn <Notice> .Success(notice)); } else { return(Rtn <Notice> .Error("公告不存在")); } }
public object insert([FromBody] CreateArticleInput input) { var article = new Article { html = input.html, title = input.title, markdown = input.markdown, author = input.author, sourceType = input.sourceType, bannerImageUrl = input.bannerImageUrl, summary = input.summary, }; var tokenUser = this.userService.getUserFromAuthcationHeader(); if (tokenUser != null) { article.userId = tokenUser.id; article.charNum = input.markdown.Length; this.db.articles.Add(article); this.db.SaveChanges(); } return(Rtn <Article> .Success(article)); }
public Rtn <User> login([FromBody] LoginBean input) { Console.WriteLine(input.username); var user = (from u in this.dataContext.users where u.username == input.username select u).FirstOrDefault(); if (user != null) { if (user.password == input.password) { user.roles = (from r in this.dataContext.roles where user.roleIds.Contains("," + r.id + ",") select r).ToList(); var menuIdList = new List <string>(); foreach (var r in user.roles) { var ids = r.menuIds.Split(","); foreach (var id in ids) { menuIdList.Add(id); } } user.menus = (from m in this.dataContext.menus where menuIdList.Distinct().Contains(m.id.ToString()) select m).ToList(); return(Rtn <User> .Success(user, "登录成功")); } else { return(Rtn <User> .Error("密码错误")); } } else { return(Rtn <User> .Error("用户不存在")); } }
public Rtn <DevExtreme.AspNet.Data.ResponseModel.LoadResult> loadTop([FromQuery] DataSourceLoadOptions options) { var query = (from a in this.dataContext.articles where a.isTop == true select a).ToList(); var data = DataSourceLoader.Load(query, options); return(Rtn <DevExtreme.AspNet.Data.ResponseModel.LoadResult> .Success(data)); }
public Rtn <Outcard> createOutcard([FromForm] CreateOutcardInput input) { var tokenUser = this.userService.getUserFromAuthcationHeader(); var newOutcard = new Outcard { companyId = tokenUser.companyId, userId = tokenUser.id, noticePerson = input.noticePersonIds, content = input.content, kqType = KqType.Field, title = input.title, time = DateTime.Now.Subtract(new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 0, 0, 0, 0)), cardType = CardType.CheckIn, inputTime = DateUtil.getNowSeconds() }; var encluserIds = input.encluserIds.Split(";"); var enclusers = (from e in this.oaContext.enclosures where encluserIds.Contains(e.id) select e).ToList(); foreach (var e in enclusers) { e.fjId = newOutcard.id; } this.oaContext.Add(newOutcard); this.oaContext.SaveChanges(); return(Rtn <Outcard> .Success(newOutcard)); }
public Rtn <WorkOrder> createWorkOrder([FromForm] CreateWorkOrderInput input) { var tokenUser = this.userService.getUserFromAuthcationHeader(); var workOrderType = WorkOrderStatus.Wait; if (input.assignId == null || input.assignId == String.Empty) { workOrderType = WorkOrderStatus.UnSubmiited; } var newWorkOrder = new WorkOrder { title = input.title, userId = tokenUser.id, assignId = input.assignId, projectId = input.projectId, wctype = workOrderType, cycle = input.cycle, companyId = tokenUser.companyId, useworkingHours = 0, timeout = false, noticePerson = input.noticePerson, name = tokenUser.name, beoverdueTime = input.beoverdueTime, explain = input.explain, enclosure = input.enclosure }; this.oaContext.workOrders.Add(newWorkOrder); return(Rtn <WorkOrder> .Success(newWorkOrder)); }
public Rtn <WorkOrder> getWorkOrderInfo([FromForm(Name = "workOrderId")] string workkorderId) { var workOrder = this.oaContext.workOrders.Find(workkorderId); if (workOrder != null) { if (workOrder.enclosure != null) { var enIds = workOrder.enclosure.Split(";"); var enclosures = (from e in this.oaContext.enclosures where enIds.Contains(e.id) select e).ToList(); workOrder.enclosures = (from e in workOrder.enclosures where e.fjType != "image" select e).ToList(); workOrder.images = (from e in workOrder.enclosures where e.fjType == "image" select e).ToList(); } workOrder.assign = this.sysContext.users.Find(workOrder.assignId); workOrder.user = this.sysContext.users.Find(workOrder.userId); if (workOrder.noticePerson != null) { var noticePersonIds = workOrder.noticePerson.Split(";"); workOrder.noticePersons = (from user in this.sysContext.users where noticePersonIds.Contains(user.id) select user).ToList(); } return(Rtn <WorkOrder> .Success(workOrder)); } else { return(Rtn <WorkOrder> .Error("不存在的工单")); } }
public Rtn <IncardInfoOutput> incardInfo() { var tokenUser = this.userService.getUserFromAuthcationHeader(); var company = this.sysContext.companys.Find(tokenUser.companyId); return(Rtn <IncardInfoOutput> .Success(new IncardInfoOutput { distance = company.distance, lng = company.lng, lat = company.lat })); }
public Rtn <IncardDayOutput> somedayIncardStatus([FromForm(Name = "daySeconds")] DateTime daySeconds) { var tokenUser = this.userService.getUserFromAuthcationHeader(); var todaySeconds = daySeconds.Subtract(new DateTime(1970, 1, 1, 0, 0, 0)).TotalSeconds; var tomorrowSeconds = todaySeconds + 24 * 60 * 60; var data = (from d in this.oaContext.incards where d.userId == tokenUser.id && d.inputTime >= todaySeconds && d.inputTime <= tomorrowSeconds select d).ToList(); foreach (var item in data) { item.daliySegment = item.time.Value.TotalSeconds >= 12 * 60 * 60 ? IncardDaliySegment.Afternoon : IncardDaliySegment.Monring; } var result = new IncardDayOutput(); var morning = (from item in data where item.daliySegment == IncardDaliySegment.Monring select item).FirstOrDefault(); var afternoon = (from item in data where item.daliySegment == IncardDaliySegment.Afternoon select item).FirstOrDefault(); if (morning != null) { result.morning = morning; } if (afternoon != null) { result.afternoon = afternoon; } return(Rtn <IncardDayOutput> .Success(result)); }
public Rtn <object> loadChildrenAll(string name) { var dict = (from d in this.dataContext.dicts where d.name == name select d).FirstOrDefault(); if (dict != null) { var chilrenDicts = (from d in this.dataContext.dicts where d.parentId == dict.id select d).ToList(); foreach (var d in chilrenDicts) { d.children = (from subDict in this.dataContext.dicts where subDict.parentId == d.id select subDict).ToList(); foreach (var subDict in dict.children) { subDict.children = (from thirdDict in this.dataContext.dicts where thirdDict.parentId == subDict.id select thirdDict).ToList(); } } dict.children = chilrenDicts; return(Rtn <object> .Success(dict)); } else { return(Rtn <object> .Error("字典不存在")); } }
public Rtn <List <Notice> > listNotices([FromForm] ListNoticesInput input) { var tokenUser = this.userService.getUserFromAuthcationHeader(); var notices = this.getUserCanShowNotice(tokenUser); notices = (from n in notices select new Notice { id = n.id, title = n.title, noticePerson = n.noticePerson, noticePersonName = n.noticePersonName, user = (from u in this.sysContext.users where u.id == n.PersonId select u).FirstOrDefault(), inputTime = n.inputTime, type = n.type, datetime = n.datetime, }).Skip(input.page * input.pageSize).Take(input.pageSize).ToList(); foreach (var n in notices) { n.resetTime(); } return(Rtn <List <Notice> > .Success(notices)); }
public Rtn <List <WorkOrder> > listWorkOrdersGiveMe([FromForm(Name = "page")] int page = 0, [FromForm(Name = "pageSize")] int pageSize = 10, [FromForm(Name = "status")] int status = -1) { var tokenUser = this.userService.getUserFromAuthcationHeader(); var workOrders = (from workOrder in this.oaContext.workOrders where workOrder.assignId == tokenUser.id select workOrder).Skip(page * pageSize).Take(pageSize).ToList(); return(Rtn <List <WorkOrder> > .Success(workOrders)); }
public object upload([FromForm(Name = "file")] IFormFile file, string filename) { filename = DateTime.Now.Subtract(new DateTime(1970, 1, 1, 0, 0, 0, 0)).TotalSeconds + filename; //将源文件 读取成文件流 Stream fromFile = file.OpenReadStream(); OSSService.uploadFile(fromFile, filename); return(Rtn <UploadOutput> .Success(new UploadOutput { url = "http://tpjs.95t92.cn/" + filename, filename = filename }, "上传成功")); }
public Rtn <List <ChatRoom> > listChatRoom([FromForm] ListChatRoomInput input) { var tokenUser = this.userService.getUserFromAuthcationHeader(); var rooms = (from r in this.oaContext.chatRooms where r.userId == tokenUser.id || r.joinUserIds.Contains(tokenUser.id) && r.status == ChatRoomStatus.Active orderby r.lastMsgTime descending select r) .Skip(input.page * input.pageSize) .Take(input.pageSize) .ToList(); return(Rtn <List <ChatRoom> > .Success(rooms)); }
public Rtn <bool> clock([FromForm] ClockInput input) { var tokenUser = this.userService.getUserFromAuthcationHeader(); var company = this.sysContext.companys.Find(tokenUser.companyId); if (company != null) { if (company.lat != null && company.lng != null) { var max = new Decimal(100); Console.WriteLine((int)(company.lat * max) + ":" + ((int)(input.lat * max))); if ((int)(company.lat * max) == ((int)(input.lat * max)) && (int)(company.lng * max) == ((int)(input.lng * max))) { // 今日零点 var ruleCopy = this.incardService.getUserCompanyCommuteCopy(tokenUser); // 添加打卡流水 var now = DateTime.Now; var nowSeconds = DateTime.Now.Subtract(new DateTime(now.Year, now.Month, now.Day, 0, 0, 0, 0)).TotalSeconds; var incardSeri = new IncardSerialNumber { UserId = tokenUser.id, type = IncardSerialNumberType.Normal, timeSlot = InCardTimeType.First, time = DateTime.Now.Subtract(new DateTime(now.Year, now.Month, now.Day, 0, 0, 0, 0)), inputTime = (int)DateTime.Now.Subtract(new DateTime(1970, 1, 1, 0, 0, 0, 0)).TotalSeconds }; // 进入打卡流水 this.oaContext.incardSerialNumbers.Add(incardSeri); this.oaContext.SaveChanges(); if (ruleCopy != null) { this.incardService.refershIncard(ruleCopy, tokenUser); return(Rtn <bool> .Success(true, "打卡成功")); } else { return(Rtn <bool> .Error("尚未添加公司打卡规则")); } } else { return(Rtn <bool> .Error("距离过远")); } } else { return(Rtn <bool> .Error("距离过远")); } } else { return(Rtn <bool> .Error("公司尚未设置经纬度,请快去设置吧")); } }
/// <summary> /// 列出工单评论 /// </summary> /// <returns></returns> public Rtn <List <Comment> > listWorkOrderComment([FromForm(Name = "workOrderId")] string workOrderId) { var comments = (from c in this.oaContext.comments where c.dyId == workOrderId select c).ToList(); foreach (var c in comments) { var enclusers = (from e in this.oaContext.enclosures where e.fjId == c.id select e).ToList(); c.enclusures = (from e in enclusers where e.fjType != "image" select e).ToList(); c.images = (from e in enclusers where e.fjType == "image" select e).ToList(); } return(Rtn <List <Comment> > .Success(comments)); }
public Rtn <Article> info(int id) { var article = this.db.articles.Find(id); if (article != null) { return(Rtn <Article> .Success(article)); } else { return(Rtn <Article> .Error("文章已经删除")); } }
public Rtn <List <Comment> > getWorkreportComments([FromForm(Name = "workReportId")] string workReportId) { var tokenUser = this.userService.getUserFromAuthcationHeader(); var comments = (from c in this.oaContext.comments where c.dyId == workReportId select c).ToList(); foreach (var c in comments) { var enclusers = (from e in this.oaContext.enclosures where e.fjId == c.id select e).ToList(); c.enclusures = (from e in enclusers where e.fjType != "image" select e).ToList(); c.images = (from e in enclusers where e.fjType == "image" select e).ToList(); } return(Rtn <List <Comment> > .Success(comments)); }
public Rtn <List <WorkOrder> > searchWorkOrders([FromForm] WorkOrderQueryInput input) { var tokenUser = this.userService.getUserFromAuthcationHeader(); var workOrders = (from workOrder in this.oaContext.workOrders where (workOrder.userId == tokenUser.id || workOrder.assignId == tokenUser.id) && workOrder.title.Contains(input.keyword) select workOrder) .Skip(input.page * input.pageSize).Take(input.pageSize).ToList(); return(Rtn <List <WorkOrder> > .Success(workOrders)); }
public object uploadVideo([FromForm] UploadVideoInput input) { var filename = "upload/" + DateTime.Now.Second + input.filename; //将源文件 读取成文件流 Stream fromFile = input.file.OpenReadStream(); var res = OSSService.uploadFile(fromFile, filename); return(Rtn <UploadOutput> .Success(new UploadOutput { url = "http://tpjs.95t92.cn/" + filename, filename = filename, res = res })); }
public Rtn <List <Incard> > incardMonth([FromForm(Name = "year")] int year = 2019, [FromForm(Name = "month")] int month = 1) { var tokenUser = this.userService.getUserFromAuthcationHeader(); var startTime = (int)new DateTime(year, month, 1, 0, 0, 0, 0, 0).Subtract(new DateTime(1970, 1, 1, 0, 0, 0, 0)).TotalSeconds; int endTime; if (month != 12) { endTime = (int)new DateTime(year, month + 1, 1, 0, 0, 0, 0, 0).Subtract(new DateTime(1970, 1, 1, 0, 0, 0, 0)).TotalSeconds; } else { endTime = (int)new DateTime(year + 1, 1, 1, 0, 0, 0, 0, 0).Subtract(new DateTime(1970, 1, 1, 0, 0, 0, 0)).TotalSeconds; } var data = (from i in this.oaContext.incards where i.inputTime >= startTime && i.inputTime <= endTime select i).ToList(); foreach (var item in data) { item.daliySegment = item.time.Value.TotalSeconds >= 12 * 60 * 60 ? IncardDaliySegment.Afternoon : IncardDaliySegment.Monring; } foreach (var item in data) { item.getInputTime(); } // 外勤记录 var outCards = (from c in this.oaContext.outcards where c.userId == tokenUser.id && c.inputTime >= startTime && c.inputTime <= c.inputTime select c).ToList(); // 外勤记录 foreach (var o in outCards) { var day = o.getInputTime().Day; foreach (var d in outCards) { if (d.getInputTime().Day != day) { var newIncard = new Incard { result = IncardTimeResult.OutCard, time = d.time, inputTime = d.inputTime, userId = d.userId, daliySegment = d.time.Value.TotalSeconds >= 12 * 60 * 60 ? IncardDaliySegment.Afternoon : IncardDaliySegment.Monring }; // output.outCard.Add(newIncard); } } } return(Rtn <List <Incard> > .Success(data)); }