// GET: transfer/alterDatabase
/// <summary>
/// 修改数据库配置
/// </summary>
/// <returns></returns>
public ActionResult alterdatabase()
{
string type = Request.Params.Get("type");
string serverName = Request.Params.Get("servername");
string databaseName = Request.Params.Get("databasename");
string username = Request.Params.Get("username");
string password = Request.Params.Get("password");
//参数异常
if (serverName == null || databaseName == null || username == null || password == null ||
serverName == "" || databaseName == "" || username == "" || password == "" || (type != "target" && type != "source"))
{
return(Json(helper.DBHelper.SerializeDBReturnCode(helper.DBReturnCode.BAD_REQUEST), JsonRequestBehavior.AllowGet));
}
//init a model object
Models.DK_DB obj = new Models.DK_DB();
obj.database_type = type;
obj.database_name = databaseName;
obj.server_name = serverName;
obj.username = username;
obj.password = password;
Models.Maintain db = new Models.Maintain();
helper.DBReturnCode code = DAL.TransferDbConfigService.AlterDbConfig(db, obj);
return(Json(helper.DBHelper.SerializeDBReturnCode(code), JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 修改数据库配置表，database_type字段是不可修改的而且必须等于source或target。
/// </summary>
/// <param name="db">数据库对象</param>
/// <param name="data">需要修改的数据对象，字段database_type:转储的2个库的库类target/source</param>
/// <returns></returns>
public static helper.DBReturnCode AlterDbConfig(Models.Maintain db, Models.DK_DB data)
{
//type限定在原始库和目标库2个字段中间。
if (data.database_type != "source" || data.database_type != "target")
{
return(helper.DBReturnCode.BAD_REQUEST);
}
Models.DK_DB target = db.DK_DB.First(i => i.database_type == data.database_type);
//修改所有字段除了库类
target.server_name = data.server_name;
target.database_name = data.database_name;
target.username = data.username;
target.password = data.password;
try
{
db.SaveChanges();
return(helper.DBReturnCode.SUCCESS);
}
catch (Exception e)
{
return(helper.DBReturnCode.OP_ERROR);
}
}
