public bool Add(Sys_Role obj, List <Sys_RoleAuthorize> list, bool isadd)
{
using (SqlSugarClient db = SqlSugarDao.GetInstance())//开启数据库连接
{
bool i = false;
db.CommandTimeOut = 30000;//设置超时时间
try
{
db.BeginTran();//开启事务
if (!isadd)
{
db.Delete <Sys_RoleAuthorize>("F_ObjectId=@F_id", new { F_id = obj.F_Id });
string[] notstr = { "F_CreatorUserId", "F_CreatorTime", "F_Category" };
db.AddDisableUpdateColumns(notstr);//添加禁止更新列
db.Update(obj);
}
else
{
db.Insert(obj);
}
db.InsertRange(list);
i = true;
db.CommitTran();//提交事务
}
catch (Exception ex)
{
db.RollbackTran();//回滚事务
i = false;
}
return(i);
}
}
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));
}
}
public void AddDisableUpdateColumns(params string[] columns)
{
_db.AddDisableUpdateColumns(columns);
}