public static bool ModifySaler(SalerEntity entity)
{
int result = 0;
if (entity != null)
{
SalerRepository mr = new SalerRepository();
SalerInfo info = TranslateSalerEntity(entity);
if (entity.SID > 0)
{
result = mr.ModifySaler(info);
}
else
{
info.CreateDate = DateTime.Now;
result = mr.CreateSaler(info);
}
List <SalerInfo> miList = mr.GetSalerAll();//刷新缓存
Cache.Add("SalerALL", miList);
}
return(result > 0);
}
public async Task <ActionResult <SalerInfo> > PostSalerInfo(SalerInfo salerInfo)
{
_context.SalerInfo.Add(salerInfo);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetSalerInfo", new { id = salerInfo.Id }, salerInfo));
}
public async Task <IActionResult> PutSalerInfo(int id, SalerInfo salerInfo)
{
if (id != salerInfo.Id)
{
return(BadRequest());
}
_context.Entry(salerInfo).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!SalerInfoExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public int ModifySaler(SalerInfo saler)
{
DataCommand command = new DataCommand(ConnectionString, GetDbCommand(SalerStatement.ModifySaler, "Text"));
command.AddInputParameter("@SID", DbType.Int64, saler.SID);
command.AddInputParameter("@SCode", DbType.String, saler.SCode);
command.AddInputParameter("@Name", DbType.String, saler.Name);
command.AddInputParameter("@Sex", DbType.Int32, saler.Sex);
command.AddInputParameter("@Birthday", DbType.DateTime, (saler.Birthday == null || saler.Birthday <= DateTime.Parse("1753-01-01")) ? DateTime.Parse("1753-01-01") : saler.Birthday);
command.AddInputParameter("@CertificateType", DbType.String, saler.CertificateType);
command.AddInputParameter("@CertificateNo", DbType.String, saler.CertificateNo);
command.AddInputParameter("@WXCode", DbType.String, saler.WXCode);
command.AddInputParameter("@Mobile", DbType.String, saler.Mobile);
command.AddInputParameter("@Status", DbType.Int32, saler.Status);
command.AddInputParameter("@AttachmentIDs", DbType.String, saler.ImageURL);
return(command.ExecuteNonQuery());
}
private static SalerInfo TranslateSalerEntity(SalerEntity entity)
{
SalerInfo salerInfo = new SalerInfo();
if (entity != null)
{
salerInfo.SID = entity.SID;
salerInfo.SCode = entity.SCode;
salerInfo.Name = entity.Name;
salerInfo.Sex = entity.Sex;
salerInfo.Birthday = entity.Birthday;
salerInfo.CertificateType = entity.CertificateType;
salerInfo.CertificateNo = entity.CertificateNo;
salerInfo.WXCode = entity.WXCode;
salerInfo.Mobile = entity.Mobile;
salerInfo.Status = entity.Status;
salerInfo.ImageURL = entity.ImageURL;
salerInfo.CreateDate = entity.CreateDate;
}
return(salerInfo);
}
private static SalerEntity TranslateSalerInfo(SalerInfo salerInfo)
{
SalerEntity entity = new SalerEntity();
if (salerInfo != null)
{
entity.SID = salerInfo.SID;
entity.SCode = salerInfo.SCode;
entity.Name = salerInfo.Name;
entity.Sex = salerInfo.Sex;
entity.Birthday = salerInfo.Birthday;
entity.CertificateType = salerInfo.CertificateType;
entity.CertificateNo = salerInfo.CertificateNo;
entity.WXCode = salerInfo.WXCode;
entity.Mobile = salerInfo.Mobile;
entity.Status = salerInfo.Status;
entity.CreateDate = salerInfo.CreateDate;
entity.ImageURL = salerInfo.ImageURL;
if (!string.IsNullOrEmpty(entity.CertificateType))//证件描述
{
BaseDataEntity cardType = BaseDataService.GetBaseDataAll().First(t => t.TypeCode == entity.CertificateType) ?? new BaseDataEntity();
entity.CertificateTypeDesc = cardType.Description ?? "";
}
AttachmentEntity attachment = new AttachmentEntity();
if (!string.IsNullOrEmpty(entity.ImageURL))
{
attachment = BaseDataService.GetAttachmentInfoByKyes(entity.ImageURL).FirstOrDefault() ?? new AttachmentEntity();
}
entity.Attachment = attachment;
//todo: 处理关联的用户信息
}
return(entity);
}
