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));
}
