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