/// <summary> /// 新增房源信息 /// </summary> /// <returns></returns> public async Task <IActionResult> CreateUpload(BuildingBaseInfo baseInfo) { string image = await UploadFile(baseInfo.File[0]); if (string.IsNullOrWhiteSpace(image)) { return(new BadRequestObjectResult("图片上传失败")); } var deatil = new BuildingBaseInfo(); deatil.Address = baseInfo.Address; deatil.Name = baseInfo.Name; deatil.MaxPrice = baseInfo.MaxPrice; deatil.MinPrice = baseInfo.MinPrice; deatil.Summary = baseInfo.Summary; deatil.BuiltupArea = baseInfo.BuiltupArea; deatil.Icon = image; deatil.CreateTime = DateTime.Now; deatil.UpdateTime = DateTime.Now; deatil.IsDeleted = false; _dbContext.Add(deatil); if (_dbContext.SaveChanges() > 0) { return(RedirectToAction("BuildShopView")); } return(new BadRequestResult()); }
public async Task <BuildingBaseInfo> CreateAsync(BuildingBaseInfo buildingBaseInfo, CancellationToken cancellationToken = default(CancellationToken)) { if (buildingBaseInfo == null) { throw new ArgumentNullException(nameof(buildingBaseInfo)); } Context.Add(buildingBaseInfo); await Context.SaveChangesAsync(cancellationToken); return(buildingBaseInfo); }
public async Task UpdateAsync(BuildingBaseInfo buildingBaseInfo, CancellationToken cancellationToken = default(CancellationToken)) { if (buildingBaseInfo == null) { throw new ArgumentNullException(nameof(buildingBaseInfo)); } Context.Attach(buildingBaseInfo); Context.Update(buildingBaseInfo); try { await Context.SaveChangesAsync(cancellationToken); } catch (DbUpdateConcurrencyException) { } }
public async Task SaveAsync(SimpleUser user, BuildingBaseInfo buildingBaseInfo, CancellationToken cancellationToken = default(CancellationToken)) { if (user == null) { throw new ArgumentNullException(nameof(user)); } if (buildingBaseInfo == null) { throw new ArgumentNullException(nameof(buildingBaseInfo)); } //查看楼盘是否存在 if (!Context.Buildings.Any(x => x.Id == buildingBaseInfo.Id)) { Buildings buildings = new Buildings() { Id = buildingBaseInfo.Id, CreateUser = user.Id, ResidentUser1 = user.Id, CreateTime = DateTime.Now, OrganizationId = user.OrganizationId, ExamineStatus = 0 }; Context.Add(buildings); } //基本信息 if (!Context.BuildingBaseInfos.Any(x => x.Id == buildingBaseInfo.Id)) { Context.Add(buildingBaseInfo); } else { Context.Attach(buildingBaseInfo); Context.Update(buildingBaseInfo); } try { await Context.SaveChangesAsync(cancellationToken); } catch (DbUpdateConcurrencyException) { } }
///<summary> /// 编辑房源信息 /// </summary> /// <returns></returns> public IActionResult EditUpload(BuildingBaseInfo baseInfo) { var deatil = _dbContext.buildingBaseInfos.SingleOrDefault(s => s.Id == baseInfo.Id); deatil.Address = baseInfo.Address; deatil.Name = baseInfo.Name; deatil.MaxPrice = baseInfo.MaxPrice; deatil.MinPrice = baseInfo.MinPrice; deatil.Summary = baseInfo.Summary; deatil.BuiltupArea = baseInfo.BuiltupArea; deatil.UpdateTime = DateTime.Now; _dbContext.Attach(deatil); _dbContext.Update(deatil); if (_dbContext.SaveChanges() > 0) { return(RedirectToAction("BuildShopView")); } return(new BadRequestResult()); }
public ModelInvokeResult <BuildingBaseInfoPK> Nullify(string strBuildingId) { ModelInvokeResult <BuildingBaseInfoPK> result = new ModelInvokeResult <BuildingBaseInfoPK> { Success = true }; try { List <IBatisNetBatchStatement> statements = new List <IBatisNetBatchStatement>(); Guid?_BuildingId = strBuildingId.ToGuid(); if (_BuildingId == null) { result.Success = false; result.ErrorCode = 59996; return(result); } BuildingBaseInfo buildingBaseInfo = new BuildingBaseInfo { BuildingId = _BuildingId, Status = 0 }; /***********************begin 自定义代码*******************/ buildingBaseInfo.OperatedBy = NormalSession.UserId.ToGuid(); buildingBaseInfo.OperatedOn = DateTime.Now; buildingBaseInfo.DataSource = GlobalManager.DIKey_00012_ManualEdit; /***********************end 自定义代码*********************/ statements.Add(new IBatisNetBatchStatement { StatementName = buildingBaseInfo.GetUpdateMethodName(), ParameterObject = buildingBaseInfo.ToStringObjectDictionary(false), Type = SqlExecuteType.UPDATE }); /***********************begin 自定义代码*******************/ /***********************此处添加自定义代码*****************/ /***********************end 自定义代码*********************/ BuilderFactory.DefaultBulder(GetHttpHeader("ConnectId")).ExecuteNativeSqlNoneQuery(statements); result.instance = new BuildingBaseInfoPK { BuildingId = _BuildingId }; } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
public InvokeResult NullifySelected(string strBuildingIds) { InvokeResult result = new InvokeResult { Success = true }; try { List <IBatisNetBatchStatement> statements = new List <IBatisNetBatchStatement>(); string[] arrBuildingIds = strBuildingIds.Split("|".ToCharArray(), StringSplitOptions.RemoveEmptyEntries); if (arrBuildingIds.Length == 0) { result.Success = false; result.ErrorCode = 59996; return(result); } string statementName = new BuildingBaseInfo().GetUpdateMethodName(); foreach (string strBuildingId in arrBuildingIds) { BuildingBaseInfo buildingBaseInfo = new BuildingBaseInfo { BuildingId = strBuildingId.ToGuid(), Status = 0 }; /***********************begin 自定义代码*******************/ buildingBaseInfo.OperatedBy = NormalSession.UserId.ToGuid(); buildingBaseInfo.OperatedOn = DateTime.Now; buildingBaseInfo.DataSource = GlobalManager.DIKey_00012_ManualEdit; /***********************end 自定义代码*********************/ statements.Add(new IBatisNetBatchStatement { StatementName = statementName, ParameterObject = buildingBaseInfo.ToStringObjectDictionary(false), Type = SqlExecuteType.UPDATE }); } BuilderFactory.DefaultBulder(GetHttpHeader("ConnectId")).ExecuteNativeSqlNoneQuery(statements); } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
public InvokeResult DeleteSelected(string strBuildingIds) { InvokeResult result = new InvokeResult { Success = true }; try { List <IBatisNetBatchStatement> statements = new List <IBatisNetBatchStatement>(); string[] arrBuildingIds = strBuildingIds.Split("|".ToCharArray(), StringSplitOptions.RemoveEmptyEntries); if (arrBuildingIds.Length == 0) { result.Success = false; result.ErrorCode = 59996; return(result); } string statementName = new BuildingBaseInfo().GetDeleteMethodName(); foreach (string strBuildingId in arrBuildingIds) { BuildingBaseInfoPK pk = new BuildingBaseInfoPK { BuildingId = strBuildingId.ToGuid() }; DeleteCascade(statements, pk); statements.Add(new IBatisNetBatchStatement { StatementName = statementName, ParameterObject = pk, Type = SqlExecuteType.DELETE }); } BuilderFactory.DefaultBulder(GetHttpHeader("ConnectId")).ExecuteNativeSqlNoneQuery(statements); } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }
public ModelInvokeResult <BuildingBaseInfoPK> Create(BuildingBaseInfo buildingBaseInfo) { ModelInvokeResult <BuildingBaseInfoPK> result = new ModelInvokeResult <BuildingBaseInfoPK> { Success = true }; try { List <IBatisNetBatchStatement> statements = new List <IBatisNetBatchStatement>(); if (buildingBaseInfo.BuildingId == GlobalManager.GuidAsAutoGenerate) { buildingBaseInfo.BuildingId = Guid.NewGuid(); } /***********************begin 自定义代码*******************/ buildingBaseInfo.OperatedBy = NormalSession.UserId.ToGuid(); buildingBaseInfo.OperatedOn = DateTime.Now; buildingBaseInfo.DataSource = GlobalManager.DIKey_00012_ManualEdit; /***********************end 自定义代码*********************/ statements.Add(new IBatisNetBatchStatement { StatementName = buildingBaseInfo.GetCreateMethodName(), ParameterObject = buildingBaseInfo.ToStringObjectDictionary(false), Type = SqlExecuteType.INSERT }); /***********************begin 自定义代码*******************/ /***********************此处添加自定义代码*****************/ /***********************end 自定义代码*********************/ BuilderFactory.DefaultBulder(GetHttpHeader("ConnectId")).ExecuteNativeSqlNoneQuery(statements); result.instance = new BuildingBaseInfoPK { BuildingId = buildingBaseInfo.BuildingId }; } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } return(result); }