public async Task <bool> AddOrUpdateDatabaseDeploy(DatabaseDeploy dbDeploy)
{
var isAdd = false;
var model = await context.DatabaseDeploys.Where(p => p.id == dbDeploy.id).FirstOrDefaultAsync();
if (model == null)
{
isAdd = true;
model = new DatabaseDeploy();
}
model.name = dbDeploy.name;
model.partyID = dbDeploy.partyID;
model.serverid = dbDeploy.serverid;
model.schemaid = dbDeploy.schemaid;
model.type = dbDeploy.type;
model.remark = dbDeploy.remark;
model.sqlServerCatlog = dbDeploy.sqlServerCatlog;
model.mongoAdminDBName = dbDeploy.mongoAdminDBName;
model.mongoDBName = dbDeploy.mongoDBName;
model.orclServiceName = dbDeploy.orclServiceName;
model.username = dbDeploy.username;
model.password = dbDeploy.password;
if (isAdd)
{
context.DatabaseDeploys.Add(model);
}
return(await context.SaveChangesAsync() == 1);
}
public async Task <ActionResult> DatabaseDeployEdit(int id)
{
var model = await serverRepo.GetDatabaseDeployAsync(id);
//项目
var PartyList = new List <SelectListItem>();
var party = await partyRepo.GetPartyListAsync();
var party2 = new SelectList(party, "PartyID", "name");
PartyList.AddRange(party2);
ViewBag.PartyList = PartyList;
//数据库架构
var SchemaidList = new List <SelectListItem>();
var sehemalist = await codeRepo.GetCodesListAsync(ECodesTypeId.databaseSchema);
var sehemalist2 = new SelectList(sehemalist, "Code", "Text");
SchemaidList.AddRange(sehemalist2);
ViewBag.SchemaidList = SchemaidList;
//数据库类型
var DBTypeList = new List <SelectListItem>();
var typelist = await codeRepo.GetCodesListAsync(ECodesTypeId.databaseType);
var typelist2 = new SelectList(typelist, "Code", "Text");
DBTypeList.AddRange(typelist2);
ViewBag.DBTypeList = DBTypeList;
if (model == null)
{
model = new DatabaseDeploy();
}
return(View(model));
}
public async Task <JsonResult> SaveDatabaseDeploy(DatabaseDeploy dbDeploy)
{
var result = await serverRepo.AddOrUpdateDatabaseDeploy(dbDeploy);
return(Json(new { isOk = result }));
}
