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