public static SqlSugarClient GetInstance()
{
string connection = SugarDao.ConnectionString; //这里可以动态根据cookies或session实现多库切换
var db = new SqlSugarClient(connection);
//支持sqlable和queryable
db.SetFilterItems(_filterRos);
//列过滤只支持queryable
db.SetFilterItems(_filterColumns);
db.IsEnableLogEvent = true;//启用日志事件
db.LogEventStarting = (sql, par) => { Console.WriteLine(sql + " " + par + "\r\n"); };
return(db);
}
public static SqlSugarClient GetInstance()
{
string connection = SugarDao.ConnectionString; //这里可以动态根据cookies或session实现多库切换
var db = new SqlSugarClient(connection);
//支持sqlable和queryable
db.SetFilterItems(_filterRos);
//列过滤只支持queryable
db.SetFilterItems(_filterColumns);
db.IsEnableLogEvent = true;//启用日志事件
db.LogEventStarting = (sql, par) => { Console.WriteLine(sql + " " + par + "\r\n"); };
return db;
}
public void SetFilterItems(Dictionary <string, Func <KeyValueObj> > filterRows)
{
Dictionary <string, Func <SqlSugar.KeyValueObj> > values = new Dictionary <string, Func <SqlSugar.KeyValueObj> >();
foreach (var item in filterRows)
{
values.Add(item.Key, () =>
{
var value = item.Value();
return(new SqlSugar.KeyValueObj()
{
Key = value.Key,
Value = value.Value
});
});
}
_db.SetFilterItems(values);
}
public static SqlSugarClient GetDbInstance()
{
try
{
var reval = new SqlSugarClient(ConnectionString);
reval.SetFilterItems(DefaultFilter); //给查询添加默认过滤器 （所有查询加上 isdeleted=0 or null）
reval.AddDisableUpdateColumns("CreateTime", "Creator"); //添加禁止更新列
reval.CurrentFilterKey = "FalseDelte";
reval.IsEnableLogEvent = true;
reval.LogEventStarting = (sql, pars) =>
{//在这儿打段点可以查看生成的SQL语句
};
return(reval);
}
catch (Exception ex)
{
throw new Exception("连接数据库出错，请检查您的连接字符串，和网络。 ex:".AppendString(ex.Message));
}
}
