/// <summary>
/// 添加服务
/// </summary>
/// <param name="sqlconnect"></param>
/// <returns></returns>
public async Task <JsonResult> AddServer(SqlConnect sqlconnect)
{
PageResponse reponse = new PageResponse();
var insert = _sqliteFreeSql.Insert <SqlConnect>();
sqlconnect.Id = Guid.NewGuid().ToString();
var res = insert.AppendData(sqlconnect);
var i = insert.ExecuteAffrows();
_sqliteFreeSql.Dispose();
if (i > 0)
{
reponse.code = "200";
reponse.status = 0;
reponse.msg = "添加成功!";
reponse.data = sqlconnect;
}
else
{
reponse.code = "500";
reponse.status = -1;
reponse.msg = "添加失败!";
}
return(Json(reponse));
}
/// <summary>
/// 添加模板
/// </summary>
/// <param name="sqlconnect"></param>
/// <returns></returns>
public JsonResult AddTemp(TemplateConfig temp)
{
PageResponse reponse = new PageResponse();
var insert = _sqliteFreeSql.Insert <TemplateConfig>();
temp.Id = Guid.NewGuid().ToString();
var res = insert.AppendData(temp);
var i = insert.ExecuteAffrows();
_sqliteFreeSql.Dispose();
if (i > 0)
{
reponse.code = "200";
reponse.status = 0;
reponse.msg = "添加成功!";
reponse.data = temp;
}
else
{
reponse.code = "500";
reponse.status = -1;
reponse.msg = "添加失败!";
}
return(Json(reponse));
}
/// <summary>
/// 添加模板
/// </summary>
/// <param name="sqlconnect"></param>
/// <returns></returns>
public async Task <ActionResult> AddTemp(TemplateConfig temp)
{
var insert = _sqliteFreeSql.Insert <TemplateConfig>();
temp.Id = Guid.NewGuid().ToString();
var res = insert.AppendData(temp);
var i = insert.ExecuteAffrows();
_sqliteFreeSql.Dispose();
return(i > 0 ? Response(temp) : Response("添加失败"));
}
/// <summary>
/// 添加模板
/// </summary>
/// <param name="sqlconnect"></param>
/// <returns></returns>
public async Task <JsonResult> AddTemp(TemplateConfig temp)
{
PageResponse reponse = new PageResponse();
try
{
//判断模板是否存在
var path = AppContext.BaseDirectory + temp.TempatePath;
if (System.IO.File.Exists(path))
{
reponse.code = "500";
reponse.status = -1;
reponse.msg = "模板已存在,创建失败!";
return(Json(reponse));
}
else
{
FileHelp fileHelp = new FileHelp();
await fileHelp.WriteViewAsync(temp.TempatePath, "");
}
var insert = _sqliteFreeSql.Insert <TemplateConfig>();
temp.Id = Guid.NewGuid().ToString();
var res = insert.AppendData(temp);
var i = insert.ExecuteAffrows();
_sqliteFreeSql.Dispose();
if (i > 0)
{
reponse.code = "200";
reponse.status = 0;
reponse.msg = "添加成功!";
reponse.data = temp;
}
else
{
reponse.code = "500";
reponse.status = -1;
reponse.msg = "添加失败!";
}
return(Json(reponse));
}
catch (Exception ex)
{
reponse.code = "500";
reponse.status = -1;
reponse.msg = "添加失败!";
return(Json(reponse));
}
}
/// <summary>
/// 添加服务
/// </summary>
/// <param name="sqlconnect"></param>
/// <returns></returns>
public async Task <ActionResult> AddServer(SqlConnect sqlconnect)
{
PageResponse reponse = new PageResponse();
var insert = _sqliteFreeSql.Insert <SqlConnect>();
sqlconnect.Id = Guid.NewGuid().ToString();
string strConn = "";
if (sqlconnect.SqlType == FreeSql.DataType.MySql)
{
strConn = $"server={sqlconnect.Host}:{sqlconnect.Port};database={sqlconnect.DbName};uid={sqlconnect.Account};pwd={sqlconnect.Pwd};charset='utf8'";
}
else
{
strConn = $"data source={sqlconnect.Host},{sqlconnect.Port};initial catalog={sqlconnect.DbName};persist security info=True;user id={sqlconnect.Account};password={sqlconnect.Pwd};";
}
sqlconnect.Address = strConn;
var res = insert.AppendData(sqlconnect);
var i = insert.ExecuteAffrows();
_sqliteFreeSql.Dispose();
return(i > 0 ? Response(sqlconnect) : Response("添加失败"));
}
