public async Task <IActionResult> Put(int id, [FromBody] RetailerViewModel retailerVm)
{
if (retailerVm == null)
{
return(BadRequest());
}
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var dbItem = await _retailerRepository.GetSingleAsync(id);
if (dbItem == null)
{
return(NotFound());
}
Mapper.Map(retailerVm, dbItem);
_retailerRepository.SetPinyin(dbItem);
dbItem.SetModification(UserName);
_retailerRepository.Update(dbItem);
if (!await UnitOfWork.SaveAsync())
{
return(StatusCode(500, "保存时出错"));
}
var vm = Mapper.Map <RetailerViewModel>(dbItem);
return(Ok(vm));
}
public async Task <IActionResult> Post([FromBody] RetailerViewModel retailerVm)
{
if (retailerVm == null)
{
return(BadRequest());
}
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var newItem = Mapper.Map <Retailer>(retailerVm);
_retailerRepository.SetPinyin(newItem);
newItem.SetCreation(UserName);
_retailerRepository.Add(newItem);
if (!await UnitOfWork.SaveAsync())
{
return(StatusCode(500, "保存时出错"));
}
var vm = Mapper.Map <RetailerViewModel>(newItem);
return(CreatedAtRoute("GetRetailer", new { id = vm.Id }, vm));
}
//
// GET: /Retailer/
public ActionResult Index()
{
RetailerViewModel model = new RetailerViewModel();
model.CurrentTenant = CurrentTenant;
return(View("Index", model));
}
public UpdateCommand(RetailerViewModel retailer)
{
Retailer = retailer;
}
public AddCommand(RetailerViewModel retailer)
{
Retailer = retailer;
}
public async Task <RetailerViewModel> Get(int id)
{
RetailerViewModel result = null;
string cmd = $@"SELECT * FROM `retailer` r
LEFT JOIN `address` a ON a.id = r.address_id AND a.is_used = 1 AND a.is_deleted = 0
LEFT JOIN `contact` c ON c.id = r.contact_id AND c.is_used = 1 AND c.is_deleted = 0
LEFT JOIN `retailer_location` rl ON rl.retailer_id = r.id AND rl.is_used = 1 AND rl.is_deleted = 0
WHERE r.id = {id} and r.is_deleted = 0 AND r.is_used = 1";
if (DbConnection != null)
{
var rd = await DbConnection.QueryMultipleAsync(cmd, transaction : DbTransaction);
rd.Read <Retailer, Address, Contact, RetailerLocation, RetailerViewModel>(
(rRs, aRs, cRs, rlRs) =>
{
if (result == null)
{
result = CommonHelper.Mapper <Retailer, RetailerViewModel>(rRs);
}
if (result.Address == null)
{
result.Address = aRs;
}
if (result.Contact == null)
{
result.Contact = cRs;
}
if (rlRs != null)
{
var location = result.Locations.FirstOrDefault(l => l.Id == rlRs.Id);
if (location == null)
{
result.Locations.Add(CommonHelper.Mapper <RetailerLocation, RetailerLocationViewModel>(rlRs));
}
}
return(result);
}
);
return(result);
}
else
{
using (var conn = DALHelper.GetConnection())
{
var rd = await conn.QueryMultipleAsync(cmd);
rd.Read <Retailer, Address, Contact, RetailerLocation, RetailerViewModel>(
(rRs, aRs, cRs, rlRs) =>
{
if (result == null)
{
result = CommonHelper.Mapper <Retailer, RetailerViewModel>(rRs);
}
if (result.Address == null)
{
result.Address = aRs;
}
if (result.Contact == null)
{
result.Contact = cRs;
}
if (rlRs != null)
{
var location = result.Locations.FirstOrDefault(l => l.Id == rlRs.Id);
if (location == null)
{
result.Locations.Add(CommonHelper.Mapper <RetailerLocation, RetailerLocationViewModel>(rlRs));
}
}
return(result);
}
);
return(result);
}
}
}
