/// <summary>
/// 链接数据库并查询
/// </summary>
/// <param name="dbLink"></param>
/// <param name="dbType"></param>
/// <param name="tableName"></param>
/// <returns></returns>
public JsonResult LinkServer(string dbLink, DbType dbType, string tableName)
{
ResultInfo result = new ResultInfo();
SqlSugarClient db = GetSugarClient(dbLink, dbType);
try
{
List <DbTableInfo> list = db.DbMaintenance.GetTableInfoList(false);
if (!string.IsNullOrEmpty(tableName)) //模糊查询
{
List <DbTableInfo> tableList = list.Where <DbTableInfo>(t => t.Name.Contains(tableName) || t.Description.Contains(tableName)).ToList();
result.info = tableList;
}
else
{
result.info = list;
}
//获取客户端的Cookie对象
HttpCookie c*k = Request.Cookies["MyData"];
if (c*k != null)
{
//修改Cookie的两种方法
c*k.Values["dbLink"] = Base64Helper.Encode(dbLink);
c*k.Values["dbType"] = dbType.ToString();
Response.AppendCookie(c*k);
}
else
{
HttpCookie cookie = new HttpCookie("MyData"); //初使化并设置Cookie的名称
DateTime dt = DateTime.Now;
TimeSpan ts = new TimeSpan(2, 0, 0, 0, 0); //过期时间为1分钟
cookie.Expires = dt.Add(ts); //设置过期时间
cookie.Values.Add("dbLink", Base64Helper.Encode(dbLink));
cookie.Values.Add("dbType", dbType.ToString());
Response.AppendCookie(cookie);
}
db.Dispose();
db.Close();
result.res = true;
result.msg = "链接成功！";
}
catch (Exception ex)
{
db.Dispose();
db.Close();
result.msg = ex.Message;
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
void IDisposable.Dispose()
{
if (db != null)
{
db.Dispose();
}
}
public void Init()
{
var mstStr = "server=.;uid=sa;pwd=sasa;database=SqlSugarTest";
var conList = new List <string>()
{
"server=localhost;uid=sa;pwd=sasa;database=SqlSugarTest"
};
SqlSugarClient db = new SqlSugarClient(mstStr, conList);
var l1 = db.Queryable <Student>().ToList(); //走从
var d1 = db.Queryable <Student>().ToDataTable(); //走从
var t3 = db.Queryable <Student>().ToList(); //走从
db.Insert <Student>(new Student()
{
name = "主"
});
db.BeginTran();
var l2 = db.Queryable <Student>().ToList();//走主
db.CommitTran();
var l3 = db.Queryable <Student>().ToList();//走从
db.Dispose();
}
//关闭数据库链接
public void Dispose()
{
if (Db != null)
{
Db.Dispose();
}
}
protected void Dispose(bool disposing)
{
if (!_disposed)
{
if (disposing)
{
// 手动释放托管资源
}
// 手动释放非托管资源
if (_client != null)
{
try
{
_client.Dispose();
}
catch
{
}
finally
{
_client = null;
}
}
_disposed = true;
}
}
public void Dispose()
{
if (client != null)
{
client.Dispose();
}
}
public static void Init()
{
if (!File.Exists("data.db"))
{
SqlSugarClient conn = new SqlSugarClient(new ConnectionConfig()
{
ConnectionString = "Data Source=" + AppDomain.CurrentDomain.BaseDirectory + "\\data.db;",
DbType = SqlSugar.DbType.Sqlite,
InitKeyType = InitKeyType.Attribute,
IsAutoCloseConnection = true,
});
conn.CodeFirst.InitTables <CustomListModel>();
conn.CodeFirst.InitTables <CustomTitleModel>();
conn.CodeFirst.InitTables <DefaultListModel>();
conn.CodeFirst.InitTables <MusicInfoModel>();
conn.CodeFirst.InitTables <LocalListModel>();
conn.CodeFirst.InitTables <SearchHistoryModel>();
conn.CodeFirst.InitTables <PlatformListModel>();
conn.CodeFirst.InitTables <PlatformInfoModel>();
conn.Dispose();
}
IniConfig ini = new IniConfig("Config.ini");
ini.Load();
bool result = ini.Object["System"].TryGetValue("DownloadPath", out IValue v);
if (!result || v?.ToString() == string.Empty)
{
DownloadManager.MusicDownloadPath = AppDomain.CurrentDomain.BaseDirectory + "Download\\";
}
else
{
DownloadManager.MusicDownloadPath = v.ObjToString();
}
}
public void Dispose()
{
if (db != null)
{
db.Dispose();
}
}
public void Dispose()
{
if (dbcontext != null)
{
dbcontext.Dispose();
}
}
protected void btnCreateClassCode_Click(object sender, EventArgs e)
{
string connection = ConfigSugar.GetConfigString("connstring"); //这里可以动态根据cookies或session实现多库切换
var db = new SqlSugarClient(connection);
txtResult.Value = db.ClassGenerating.SqlToClass(db, txtSql.Text, txtClassName.Text);
db.Dispose();
}
public void Dispose()
{
if (_db != null)
{
_db.Dispose();
}
}
protected void btnCreateClassCode_Click(object sender, EventArgs e)
{
string connection = ConfigSugar.GetConfigString("connstring"); //这里可以动态根据cookies或session实现多库切换
var db = new SqlSugarClient(connection);
txtResult.Value = db.ClassGenerating.SqlToClass(db, txtSql.Text, txtClassName.Text);
db.Dispose();
}
public void Dispose()
{
if (_db != null)
{
_db.Dispose();
// LogNHelper.Exception("释放了资源");
}
}
public void BindDgv()
{
SqlSugarClient db = null;
try
{
db = SqlLiteHelper.GetInstance();
if (!File.Exists(Device.DB_FilePath))
{
MessageBox.Show("文件下载中，请稍后再试！");
return;
}
var sourceList = db.Queryable <SYS_USERROOM, SYS_MODELS>((u, m) => new object[] {
JoinType.Left, u.GUID == m.GUID
})
.Select((u, m) => new
{
u.GUID,
u.NAME,
u.CREATETIME,
m.MODELID,
m.FEATURE,
u.STARTTIME,
u.ENDTIME,
u.AREACODE,
u.AREANAME,
u.USERTYPE,
});
if (!string.IsNullOrWhiteSpace(txtName.Text))
{
sourceList = sourceList.Where(u => u.NAME.Contains(txtName.Text));
}
TotalCount = sourceList.Count();
if (PageIndex <= 1)
{
PageIndex = 1;
}
var maxPageIndex = Math.Ceiling((decimal)TotalCount / (decimal)PageSize);
if (PageIndex >= maxPageIndex)
{
PageIndex = maxPageIndex.ToInt32();
}
var skip = (PageIndex - 1) * PageSize;
sourceList = sourceList.Take(PageSize).Skip(skip)
.OrderBy(u => u.CREATETIME, OrderByType.Desc);
dataGridView1.AutoGenerateColumns = false;
dataGridView1.DataSource = sourceList.ToList();
lblTotalCount.Text = $"第{PageIndex}页，每页{PageSize}条，总数：" + TotalCount;
}
catch (Exception ex)
{
MessageBox.Show("文件下载中，请稍后再试！");
}
db.Close();
db.Dispose();
System.Data.SQLite.SQLiteConnection.ClearAllPools();
}
protected void btnCreate_Click(object sender, EventArgs e)
{
string connection = ConfigSugar.GetConfigString("connstring"); //这里可以动态根据cookies或session实现多库切换
var db = new SqlSugarClient(connection); ;
db.ClassGenerating.CreateClassFiles(db, txtPath.Text, txtNS.Text);
db.Dispose();
//还有其它方法我这边只是最简单的
//db.ClassGenerating.CreateClassFilesByTableNames
//db.ClassGenerating....
}
/// <summary>
/// 解决MSBUILD : warning CA1001: Microsoft.Design 报错提示
/// fork from https://blog.csdn.net/unopenmycode/article/details/38311797?hp.com
/// </summary>
/// <param name="disposing"></param>
protected virtual void Dispose(bool disposing)
{
if (disposing)
{
/// 释放前提交更改
Db.Ado.CommitTran();
Db.Ado.Close();
/// 释放各个对象
Db.Dispose();
}
}
protected void btnCreate_Click(object sender, EventArgs e)
{
string connection = ConfigSugar.GetConfigString("connstring"); //这里可以动态根据cookies或session实现多库切换
var db = new SqlSugarClient(connection);;
db.ClassGenerating.CreateClassFiles(db, txtPath.Text, txtNS.Text);
db.Dispose();
//还有其它方法我这边只是最简单的
//db.ClassGenerating.CreateClassFilesByTableNames
//db.ClassGenerating....
}
private void Dispose(bool disposing)
{
if (!isDisposed && disposing)
{
if (_sqlSugarClient != null)
{
_sqlSugarClient.Dispose();
}
}
isDisposed = true;
}
private bool disposedValue = false; //要检测冗余调用
protected virtual void Dispose(bool disposing)
{
if (!disposedValue)
{
if (disposing)
{
// TODO: 释放托管状态(托管对象)。
db.Dispose();
db = null;
}
// TODO: 释放未托管的资源(未托管的对象)并在以下内容中替代终结器。
// TODO: 将大型字段设置为 null。
disposedValue = true;
}
}
public void Init()
{
SqlSugarClient db = new SqlSugarClient("server=.;uid=sa;pwd=sasa;database=SqlSugarTest", "server=localhost;uid=sa;pwd=sasa;database=SqlSugarTest");
var l1= db.Queryable<Student>().ToList();//走从
var d1= db.Queryable<Student>().ToDataTable();//走从
var t3 = db.Queryable<Student>().ToList();//走从
db.Insert<Student>(new Student() { name="主" });
db.BeginTran();
var l2 = db.Queryable<Student>().ToList();//走主
db.CommitTran();
var l3 = db.Queryable<Student>().ToList();//走从
db.Dispose();
}
private static void Dispose()
{
try
{
if (SugarContext != null)
{
SugarContext.Dispose();
}
}
catch (Exception e)
{
Msg.ShowException(e, "数据库连接失败");
}
finally
{
SugarContext = null;
}
}
public static void Dispose()
{
try
{
if (SugarContext != null)
{
SugarContext.Dispose();
}
}
catch (Exception e)
{
LogNHelper.Exception(e);
}
finally
{
SugarContext = null;
}
}
// This method gets called by the runtime. Use this method to add services to the container.
public void ConfigureServices(IServiceCollection services)
{
#region SqlSugar
var defaultDbPath = Path.Combine(PathExtenstions.GetApplicationCurrentPath(), $"{Configuration["EasyLogger:DbName"]}.db");
services.AddSingleton <ISqlSugarProvider>(new SqlSugarProvider(new SqlSugarSetting()
{
Name = SqlSugarDbStorageConsts.DefaultProviderName,
ConnectionString = @$ "Data Source={defaultDbPath}",
DatabaseType = DbType.Sqlite,
LogExecuting = (sql, pars) =>
{
Console.WriteLine($"sql:{sql}");
}
}));
services.AddTransient(typeof(ISqlSugarRepository <,>), typeof(SqlSugarRepository <,>));
services.AddTransient(typeof(IDbRepository <,>), typeof(SqlSugarRepository <,>));
services.AddSingleton <ISqlSugarProviderStorage, DefaultSqlSugarProviderStorage>();
#endregion
#region 默认创建基础数据库 和 时间数据库
if (!File.Exists(defaultDbPath))
{
var db = new SqlSugarClient(new ConnectionConfig()
{
ConnectionString = @$ "Data Source={defaultDbPath}",
DbType = DbType.Sqlite,
IsAutoCloseConnection = true, // 自动释放数据务，如果存在事务，在事务结束后释放
InitKeyType = InitKeyType.Attribute // 从实体特性中读取主键自增列信息
});
db.CodeFirst.BackupTable().InitTables <EasyLoggerProject>();
db.Dispose();
}
#endregion
services.AddControllers();
}
public void Init()
{
SqlSugarClient db = new SqlSugarClient("server=.;uid=sa;pwd=sasa;database=SqlSugarTest", "server=localhost;uid=sa;pwd=sasa;database=SqlSugarTest");
var l1 = db.Queryable <Student>().ToList(); //走从
var d1 = db.Queryable <Student>().ToDataTable(); //走从
var t3 = db.Queryable <Student>().ToList(); //走从
db.Insert <Student>(new Student()
{
name = "主"
});
db.BeginTran();
var l2 = db.Queryable <Student>().ToList();//走主
db.CommitTran();
var l3 = db.Queryable <Student>().ToList();//走从
db.Dispose();
}
public void DbTableCreate(string path, bool isBaseDb)
{
var db = new SqlSugarClient(new ConnectionConfig()
{
ConnectionString = $@"Data Source={path}",
DbType = DbType.Sqlite,
IsAutoCloseConnection = true, // 自动释放数据务，如果存在事务，在事务结束后释放
InitKeyType = InitKeyType.Attribute // 从实体特性中读取主键自增列信息
});
// 生成数据库
// db.Ado.ExecuteCommand($"create dataabse {dbName}");
if (isBaseDb)
{
db.CodeFirst.BackupTable().InitTables <EasyLoggerProject>();
}
else
{
CreateLoggerTable(db);
}
db.Dispose();
}
public void Cleanup()
{
_sqlSugarClient.Dispose();
}
public void Dispose()
{
Db.Dispose();
}
public void Cleanup()
{
DB.Dispose();
}
public void Dispose()
{
_db.Dispose();
}
