public async Task <IActionResult> Post(List <IFormFile> files) { long size = files.Sum(f => f.Length); // full path to file in temp location var filePath = Path.GetTempFileName(); var activies = _activityService.GetFullList(x => x.IsPublish, x => x.IsPublish, OrderingType.Descending).ToList(); if (activies.Count < 1) { base.SetMessager(MessageType.danger, "请先完善活动主题"); return(RedirectToAction("Index", "Activity")); } List <Schedule> list = new List <Schedule>(); try { foreach (var formFile in files) { if (formFile.Length > 0) { using (var stream = formFile.OpenReadStream()) { ExcelHelper excelHelper = new ExcelHelper(); string fileExtension = Path.GetExtension(formFile.FileName); DataTable table = excelHelper.ExcelImport(stream, fileExtension, 0); if (table != null) { foreach (DataRow row in table.Rows) { try { //if (row.ItemArray.Length != 6) //{ // continue; //} var rownum = row.ItemArray[0].ToString(); // 行号 var num = row["序号"].ToString(); // 序号 var accountnum = string.Empty; if (row["公司ID"] == null) { continue; } accountnum = row["公司ID"].ToString(); var controlId = string.Format("admin_{0}", accountnum.Trim());// 关联帐号 if (row["曲目"] == null) { continue; } var name = row["曲目"].ToString(); var comname = string.Empty; if (row["公司名称"] != null) { comname = row["公司名称"].ToString(); } if (row["组别"] == null) { continue; } var scheduleName = row["组别"].ToString(); if (string.IsNullOrEmpty(scheduleName)) { continue; } CompetitionProgram_EditVD cev = new CompetitionProgram_EditVD(); ///获取节目类别 var cate = cev.CateList.FirstOrDefault(x => x.Name.Equals(scheduleName)); if (cate == null) { continue; } var cateId = cate.Id; //获取指定节目 var result = _competitionProgramService.GetObject(x => name.Equals(x.Name)); var schedule = _scheduleService.GetObject(x => scheduleName.Equals(x.Name)); if (schedule == null) { continue; } CompetitionProgram competitionProgram = null; if (result == null) { competitionProgram = new CompetitionProgram() { Id = Guid.NewGuid().ToString("N"), Name = name, Company = comname, Desc = string.Empty, Flag = false, ControlId = controlId, ScheduleId = schedule.Id, BdImgUrl = string.Empty, BdImgUrlPwd = string.Empty, ImgUrl = string.Empty, Cate = cateId, UpdateTime = DateTime.Now, UpdatorId = UserName, UpdatorName = AdminUser == null ? "" : AdminUser.RealName, CreatorName = AdminUser == null ? "" : AdminUser.RealName, SignNum = string.Empty, Status = 0, Remark = string.Empty, CreateTime = DateTime.Now, CreatorId = UserName, }; } else { competitionProgram = result; competitionProgram.Name = name; competitionProgram.Desc = string.Empty; competitionProgram.ImgUrl = string.Empty; competitionProgram.Cate = cateId; competitionProgram.Remark = string.Empty; competitionProgram.ScheduleId = schedule.Id; competitionProgram.BdImgUrl = string.Empty; competitionProgram.BdImgUrlPwd = string.Empty; competitionProgram.Company = comname; competitionProgram.ControlId = controlId; competitionProgram.UpdatorId = UserName; competitionProgram.UpdatorName = AdminUser == null ? "" : AdminUser.RealName; competitionProgram.UpdateTime = DateTime.Now; competitionProgram.SignNum = string.Empty; competitionProgram.Status = 0; competitionProgram.UpdateTime = DateTime.Now; competitionProgram.UpdatorId = UserName; competitionProgram.UpdatorName = AdminUser == null ? "" : AdminUser.RealName; } await TryUpdateModelAsync(competitionProgram, "", v => v.Name , v => v.Desc , v => v.ImgUrl , v => v.Cate , v => v.Remark , v => v.Desc , v => v.BdImgUrl , v => v.BdImgUrlPwd , v => v.Company , v => v.ControlId , v => v.UpdatorId , v => v.UpdatorName , v => v.UpdateTime , v => v.SignNum , v => v.Status , v => v.UpdateTime , v => v.UpdatorId , v => v.UpdatorName); _competitionProgramService.SaveObject(competitionProgram); } catch (Exception ex) { continue; } } } await Task.Delay(10); // await formFile.CopyToAsync(stream); } } } } catch (Exception ex) { var error = ex.Message; } // process uploaded files // Don't rely on or trust the FileName property without validation. return(Ok(new { count = files.Count, size, filePath })); }
public async Task <IActionResult> Edit(CompetitionProgram_EditVD model) { bool isEdit = !string.IsNullOrEmpty(model.Id); bool iseditManger = false; if (!ModelState.IsValid) { return(View(model)); } CompetitionProgram competitionProgram = null; // CompetitionProgram ProjectMember pm = null; if (isEdit) { competitionProgram = _competitionProgramService.GetObject(z => z.Id == model.Id); if (competitionProgram == null) { base.SetMessager(MessageType.danger, "信息不存在!"); return(RedirectToAction("Index")); } pm = _projectMemberService.GetObject(x => x.ProjectId == competitionProgram.Id); if (pm != null) { // pm.Id = Guid.NewGuid().ToString("N"); pm.Company = model.LeaderCom; pm.Duty = model.LeaderDuty; pm.Email = model.LeaderEmail; //pm.CreateTime = DateTime.Now; pm.Flag = false; pm.Gender = 0; pm.Name = model.LeaderName; pm.Nation = model.LeaderNation; pm.ProjectId = competitionProgram.Id; pm.Phone = model.LeaderPhone; pm.UpdateTime = DateTime.Now; pm.IsLeader = true; pm.IdCard = model.LeaderCard; pm.Sort = 1; } competitionProgram.Name = model.Name; competitionProgram.Desc = model.Desc; competitionProgram.ImgUrl = model.ImgUrl; competitionProgram.Cate = model.Cate; competitionProgram.Remark = model.Remark; competitionProgram.ScheduleId = model.ProjectId; competitionProgram.Desc = model.Desc; competitionProgram.BdImgUrl = model.BdImgUrl; competitionProgram.BdImgUrlPwd = model.BdImgUrlPwd; competitionProgram.Company = model.Company; competitionProgram.ControlId = model.ControlId; competitionProgram.UpdatorId = UserName; competitionProgram.UpdatorName = AdminUser == null ? "" : AdminUser.RealName; competitionProgram.UpdateTime = DateTime.Now; competitionProgram.SignNum = model.SignNum; competitionProgram.Status = model.Status; competitionProgram.UpdateTime = DateTime.Now; competitionProgram.UpdatorId = UserName; competitionProgram.UpdatorName = AdminUser == null ? "" : AdminUser.RealName; } else { competitionProgram = new CompetitionProgram() { Id = Guid.NewGuid().ToString("N"), Name = model.Name, Company = model.Company, Desc = model.Desc, Flag = false, ControlId = model.ControlId, ScheduleId = model.ProjectId, BdImgUrl = model.BdImgUrl, BdImgUrlPwd = model.BdImgUrlPwd, ImgUrl = model.ImgUrl, Cate = model.Cate, UpdateTime = DateTime.Now, UpdatorId = UserName, UpdatorName = AdminUser == null ? "" : AdminUser.RealName, CreatorName = AdminUser == null ? "" : AdminUser.RealName, SignNum = model.SignNum, Status = model.Status, Remark = model.Remark, CreateTime = DateTime.Now, CreatorId = UserName, }; } try { await TryUpdateModelAsync(competitionProgram, "", v => v.Name , v => v.Desc , v => v.ImgUrl , v => v.Cate , v => v.Remark , v => v.Desc , v => v.BdImgUrl , v => v.BdImgUrlPwd , v => v.Company , v => v.ControlId , v => v.UpdatorId , v => v.UpdatorName , v => v.UpdateTime , v => v.SignNum , v => v.Status , v => v.UpdateTime , v => v.UpdatorId , v => v.UpdatorName); _competitionProgramService.SaveObject(competitionProgram); if (pm != null) { _projectMemberService.SaveObject(pm); } else { if (!string.IsNullOrEmpty(model.LeaderName)) { pm = new ProjectMember { Id = Guid.NewGuid().ToString("N"), Company = model.LeaderCom, Duty = model.LeaderDuty, Email = string.Empty, CreateTime = DateTime.Now, Flag = false, Gender = 0, Name = model.LeaderName, Nation = model.LeaderNation, ProjectId = competitionProgram.Id, Phone = model.LeaderPhone, UpdateTime = DateTime.Now, IsLeader = true, IdCard = model.LeaderCard, Sort = 1, }; _projectMemberService.SaveObject(pm); } } base.SetMessager(MessageType.success, $"{(isEdit ? "修改" : "新增")}成功!"); return(RedirectToAction("Index")); } catch (Exception ex) { base.SetMessager(MessageType.danger, $"{(isEdit ? "修改" : "新增")}失败!" + ex.Message); return(RedirectToAction("Index")); } }
private async Task <ProjectMember> SaveObj(CompetitionProgram_EditVD model, CompetitionProgram competitionProgram, ProjectMember pm) { try { await TryUpdateModelAsync(competitionProgram, "", v => v.Name , v => v.Desc , v => v.ImgUrl , v => v.Cate , v => v.Remark , v => v.Desc , v => v.BdImgUrl , v => v.BdImgUrlPwd , v => v.Company , v => v.ControlId , v => v.UpdatorId , v => v.UpdatorName , v => v.UpdateTime , v => v.SignNum , v => v.Status , v => v.UpdateTime , v => v.UpdatorId , v => v.UpdatorName); _competitionProgramService.SaveObject(competitionProgram); if (pm != null) { _projectMemberService.SaveObject(pm); } else { if (!string.IsNullOrEmpty(model.LeaderName)) { pm = new ProjectMember { Id = Guid.NewGuid().ToString("N"), Company = model.LeaderCom, Duty = model.LeaderDuty, Email = string.Empty, CreateTime = DateTime.Now, Flag = false, Gender = 0, Name = model.LeaderName, Nation = model.LeaderNation, ProjectId = competitionProgram.Id, Phone = model.LeaderPhone, UpdateTime = DateTime.Now, IsLeader = true, IdCard = model.LeaderCard, Sort = 1, }; _projectMemberService.SaveObject(pm); } } //base.SetMessager(MessageType.success, $"{(isEdit ? "修改" : "新增")}成功!"); //return RedirectToAction("Index"); } catch (Exception ex) { //base.SetMessager(MessageType.danger, $"{(isEdit ? "修改" : "新增")}失败!" + ex.Message); //return RedirectToAction("Index"); } return(pm); }
public ActionResult Edit(string id) { bool isEdit = !string.IsNullOrEmpty(id); var vd = new CompetitionProgram_EditVD(); var activies = _activityService.GetFullList(x => x.IsPublish, x => x.IsPublish, OrderingType.Descending).ToList(); if (activies.Count < 1) { base.SetMessager(MessageType.danger, "请先完善活动主题"); return(RedirectToAction("Index")); } List <Schedule> list = new List <Schedule>(); if (isEdit) { var model = _competitionProgramService.GetObject(z => z.Id == id); if (model == null) { base.SetMessager(MessageType.danger, "信息不存在!"); return(RedirectToAction("Index")); } var modellist = _competitionProgramService.GetFullList(x => !string.IsNullOrEmpty(x.SignNum) && x.ScheduleId == model.ScheduleId, x => x.CreateTime, OrderingType.Descending).Select(x => x.SignNum).ToList(); if (model.Schedule == null) { model.Schedule = _scheduleService.GetObject(s => s.Id == model.ScheduleId); } var numlist = new List <string>(); if (model.Schedule != null) { numlist = model.Schedule.SignNumber.Split(",").ToList(); } List <string> num = new List <string>(); foreach (var item in numlist) { if (!modellist.Contains(item)) { num.Add(item); } } list = _scheduleService.GetFullList(x => x.ActivityId == model.Schedule.ActivityId, x => x.StartTime, OrderingType.Ascending).ToList(); // vd.Id = model.Id; var leader = _projectMemberService.GetObject(x => x.IsLeader && x.ProjectId == model.Id); vd.AvalidSignNums = num; vd.Name = model.Name; vd.Desc = model.Desc; vd.ImgUrl = model.ImgUrl; vd.ProjectId = model.ScheduleId; vd.ActivityId = model.Schedule.ActivityId; vd.ScheduleSignNum = string.Join(",", num); vd.Cate = model.Cate; vd.Remark = model.Remark; vd.Desc = model.Desc; vd.BdImgUrl = model.BdImgUrl; vd.BdImgUrlPwd = model.BdImgUrlPwd; vd.Company = model.Company; vd.ControlId = model.ControlId; vd.UpdatorId = UserName; vd.UpdatorName = AdminUser == null ? "" : AdminUser.RealName; vd.UpdateTime = DateTime.Now; vd.SignNum = model.SignNum; vd.Status = model.Status; if (leader != null) { vd.LeaderCard = leader.IdCard; vd.LeaderCom = leader.Company; vd.LeaderDuty = leader.Duty; vd.LeaderEmail = leader.Email; vd.LeaderName = leader.Name; vd.LeaderNation = leader.Nation; vd.LeaderPhone = leader.Phone; } } else { var curactivir = activies.FirstOrDefault(); list = _scheduleService.GetFullList(x => x.ActivityId == curactivir.Id, x => x.StartTime, OrderingType.Ascending).ToList(); //vd.ScheduleSignNum = ; } if (list.Count == 0) { base.SetMessager(MessageType.danger, "请先安排好赛程"); return(RedirectToAction("Index")); } var accounts = _adminUserInfoService.GetFullList(x => !"初始化数据".Equals(x.Note), x => x.AddTime, OrderingType.Descending); vd.UserList = accounts; vd.Activities = activies; vd.Schedules = list; vd.IsEdit = isEdit; return(View(vd)); }