/// <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("添加失败")); }