/// <summary>
/// 测试一个连接是否正常
/// </summary>
/// <param name="dbConnection"></param>
/// <returns>返回字符串1为正常，其它为错误信息</returns>
public string TesetConnection(Model.DbConnection dbConnection)
{
using (var db = new DataContext(dbConnection.ConnType, dbConnection.ConnString))
{
return(db.TestConnection());
}
}
/// <summary>
/// 得到一个表所有字段
/// </summary>
/// <param name="dbConnection"></param>
/// <param name="table">表名</param>
/// <param name="dbName">数据库名(MYSQL时需要,防止同一个连接中不同的数据库中有相同的表名的情况。其它数据库为空)</param>
/// <returns>返回datatable 列:f_name,t_name,length,is_null,cdefault,isidentity,defaultvalue,comments</returns>
public DataTable GetTableFields(Model.DbConnection dbConnection, string table, string dbName)
{
using (var db = new DataContext(dbConnection.ConnType, dbConnection.ConnString))
{
return(db.GetDataTable(new DbconnnectionSql(dbConnection).SqlInstance.GetTableFieldsSql(table, dbName)));
}
}
/// <summary>
/// 查询一个连接所有表
/// </summary>
/// <param name="dbConnection"></param>
/// <returns>表名，表说明</returns>
public DataTable GetTables(Model.DbConnection dbConnection)
{
using (var db = new DataContext(dbConnection.ConnType, dbConnection.ConnString))
{
return(db.GetDataTable(new DbconnnectionSql(dbConnection).SqlInstance.GetDbTablesSql()));
}
}
public SqlServer(Model.DbConnection dbConnection, string dataBaseType)
{
dbType = dataBaseType.ToLower();
if (null != dbConnection)
{
connStr = dbConnection.ConnString;
dbConnectionModel = dbConnection;
}
}
/// <summary>
/// 更新连接
/// </summary>
/// <param name="dictionary">连接实体</param>
public int Update(Model.DbConnection dbConnection)
{
ClearCache();
using (var db = new DataContext())
{
db.Update(dbConnection);
return(db.SaveChanges());
}
}
public MirSqlSugarClient(Model.DbConnection config) : base(new SqlSugar.ConnectionConfig()
{
ConnectionString = config.ConnectionString,
DbType = config.DbType,
IsAutoCloseConnection = config.IsAutoCloseConnection
})
{
DbName = config.Name;
Default = config.IsDefault;
}
public string SaveEdit(Model.DbConnection dbConnectionModel)
{
if (!ModelState.IsValid)
{
return(Tools.GetValidateErrorMessag(ModelState));
}
Business.DbConnection dbConnection = new Business.DbConnection();
if (Request.Querys("connid").IsGuid(out Guid guid))
{
var oldModel = dbConnection.Get(guid);
string oldJSON = null == oldModel ? "" : oldModel.ToString();
dbConnection.Update(dbConnectionModel);
Business.Log.Add("修改了数据连接-" + dbConnectionModel.Name, type: Business.Log.Type.系统管理, oldContents: oldJSON, newContents: dbConnectionModel.ToString());
}
else
{
dbConnection.Add(dbConnectionModel);
Business.Log.Add("添加了数据连接-" + dbConnectionModel.Name, dbConnectionModel.ToString(), Business.Log.Type.系统管理);
}
return("保存成功!");
}
public IActionResult Edit()
{
string connId = Request.Querys("connid");
Business.DbConnection dbConnection = new Business.DbConnection();
Model.DbConnection dbConnectionModel = null;
if (connId.IsGuid(out Guid cId))
{
dbConnectionModel = dbConnection.Get(cId);
}
if (null == dbConnectionModel)
{
dbConnectionModel = new Model.DbConnection
{
Id = Guid.NewGuid(),
Sort = dbConnection.GetMaxSort()
};
}
ViewData["connTypeOptions"] = dbConnection.GetConnTypeOptions(dbConnectionModel.ConnType);
ViewData["queryString"] = Request.UrlQuery();
return(View(dbConnectionModel));
}
/// <summary>
/// 得到一个表所有字段
/// </summary>
/// <param name="id"></param>
/// <param name="tableName"></param>
/// <returns></returns>
public List <Model.TableField> GetTableFields(Model.DbConnection conn, string tableName)
{
List <Model.TableField> tableFields = new List <Model.TableField>();
string dbName = string.Empty;
if (conn.ConnType.EqualsIgnoreCase("mysql"))
{
string[] connStringArray = conn.ConnString.Split(';');
foreach (string connString in connStringArray)
{
string[] connArray = connString.Split('=');
if (connArray.Length > 1 && (connArray[0].Trim().Equals("database") || connArray[0].Trim().Equals("db") || connArray[0].Trim().Equals("Initial Catalog")))
{
dbName = connArray[1].Trim();
}
}
}
var dt = dbConnectionData.GetTableFields(conn, tableName, dbName);
foreach (DataRow dr in dt.Rows)
{
Model.TableField tableField = new Model.TableField()
{
FieldName = dr["f_name"].ToString(),
Type = dr["t_name"].ToString(),
Size = dr["length"].ToString().ToInt(),
IsNull = "1".Equals(dr["is_null"].ToString()),
IsDefault = dr["cdefault"].ToString().ToInt() != 0,
IsIdentity = dr["isidentity"].ToString().ToInt() == 1,
DefaultValue = dr["defaultvalue"].ToString(),
Comment = dr["comments"].ToString()
};
tableFields.Add(tableField);
}
return(tableFields);
}
/// <summary>
/// 更新连接
/// </summary>
/// <param name="dictionary">连接实体</param>
public int Update(Model.DbConnection dbConnection)
{
return(dbConnectionData.Update(dbConnection));
}
/// <summary>
/// 添加一个连接
/// </summary>
/// <param name="dbConnection">连接实体</param>
/// <returns></returns>
public int Add(Model.DbConnection dbConnection)
{
return(dbConnectionData.Add(dbConnection));
}
public DbconnnectionSql(Model.DbConnection dbConnection)
{
dbType = dbConnection.ConnType.ToLower();
connStr = dbConnection.ConnString;
dbConnectionModel = dbConnection;
}
public DbconnnectionSql(string dataBaseType)
{
dbType = dataBaseType.ToLower();
connStr = string.Empty;
dbConnectionModel = null;
}
/// <summary> /// 执行多条SQL /// </summary> /// <param name="dbConnection">连接实体</param> /// <param name="tuples">sql语句, sql参数</param> /// <returns>返回数字表示成功（数字是受影响的行数），其它为错误信息</returns> public string ExecuteSQL(Model.DbConnection dbConnection, List <(string sql, DbParameter[] parameters)> tuples)
