public async Task <IActionResult> PutPersonMasterLabel([FromRoute] int id, [FromBody] PersonMasterLabel personMasterLabel)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != personMasterLabel.PersonID)
{
return(BadRequest());
}
_context.Entry(personMasterLabel).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!PersonMasterLabelExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <IActionResult> PostPersonMasterLabel([FromBody] PersonMasterLabel personMasterLabel)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_context.PersonMasterLabel.Add(personMasterLabel);
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateException)
{
if (PersonMasterLabelExists(personMasterLabel.PersonID))
{
return(new StatusCodeResult(StatusCodes.Status409Conflict));
}
else
{
throw;
}
}
return(CreatedAtAction("GetPersonMasterLabel", new { id = personMasterLabel.PersonID }, personMasterLabel));
}
public async Task <IActionResult> Create([Bind("PersonID,LabelID")] PersonMasterLabel personMasterLabel)
{
if (ModelState.IsValid)
{
_context.Add(personMasterLabel);
await _context.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewData["LabelID"] = new SelectList(_context.Lable, "Id", "Name", personMasterLabel.LabelID);
ViewData["PersonID"] = new SelectList(_context.Person, "Id", "Name", personMasterLabel.PersonID);
return(View(personMasterLabel));
}
//[ValidateAntiForgeryToken]
public async Task <IActionResult> Details([FromBody] PersonMasterLabel personMasterLabel)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_context.PersonMasterLabel.Add(personMasterLabel);
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateException)
{
if (PersonMasterLabelExists(personMasterLabel.PersonID))
{
return(new StatusCodeResult(StatusCodes.Status409Conflict));
}
else
{
return(BadRequest(ModelState));
}
}
//查询标签的使用以及次数
var label = from pm in _context.PersonMasterLabel
join pu in _context.PersonUseLabel on pm.PersonID equals pu.PersonID
join c in _context.Lable on pm.LabelID equals c.Id
group pu by new { wna = pu.PersonID, sa = pm.LabelID, cname = c.Name } into g
select new
{
cname = g.Key.cname,
PersonID = g.Key.wna,
LabelID = g.Key.sa
};
List <Label> labelList = new List <Label>();
foreach (var item in label)
{
Label l = new Label();
l.Id = item.LabelID;
l.Name = item.cname;
labelList.Add(l);
}
ViewData["LabelList"] = labelList;
ViewData["Personid"] = personMasterLabel.PersonID;
return(PartialView("_PartialPage", ViewData["Personid"]));
}
