public PagedList <District> GetAllDistricts(District district, string orderBy, string orderAs, int page)
{
try
{
using (IDbContextBase context = DbContextFactory.GetDbContext())
{
string name = district == null ? "" : district.Name + "";
PagedList <District> listDistrict = context.FindAllByPage <District>(obj => obj.Name.Contains(name), orderBy, orderAs, page);
return(listDistrict);
}
}
catch
{
throw;
}
}
//IDbContextBase context = DbContextFactory.GetDbContext();
public PagedList <Property> GetAllProperties(Property property, string orderBy, string orderAs, int page)
{
try
{
using (IDbContextBase context = DbContextFactory.GetDbContext())
{
string name = property == null ? "" : property.Name + "";
Expression <Func <Property, bool> > conditions = obj => obj.Name.Contains(name);
PagedList <Property> listProperty = context.FindAllByPage <Property>(conditions, orderBy, orderAs, page);
return(listProperty);
}
}
catch
{
throw;
}
}
public bool DeleteRole(Guid roleId)
{
try
{
using (IDbContextBase context = DbContextFactory.GetDbContext())
{
context.Delete <Role>(roleId, false);
context.Delete <User_Role>(obj => obj.RoleId == roleId, false);
context.Delete <Permission>(obj => obj.RoleId == roleId, false);
return(context.SaveChanges());
}
}
catch
{
throw;
}
}
public List <Resource> GetAllResource()
{
try
{
using (IDbContextBase context = DbContextFactory.GetDbContext())
{
SqlService sqlService = SqlServiceFactory.GetSQLService();
string sql = "select * from Resource where Id!='0'";
List <Resource> listResource = sqlService.GetEntities <Resource>(sql);
return(listResource);
}
}
catch
{
throw;
}
}
public List <string> GetResourceIdByRoleId(Guid roleId)
{
try
{
using (IDbContextBase context = DbContextFactory.GetDbContext())
{
SqlService sqlService = SqlServiceFactory.GetSQLService();
string sql = "select ResourceId from Permission where RoleId=@RoleId";
List <SqlParameter> listPar = new List <SqlParameter>();
listPar.Add(new SqlParameter("RoleId", roleId));
return(sqlService.QueryOneColumn(sql, listPar));
}
}
catch
{
throw;
}
}
public void WriteLog(string userName, string moduleName, string tableName, string eventType, object newValues)
{
using (IDbContextBase context = DbContextFactory.GetDbContext())
{
context.CloseLog();
AuditLog audiLog = new AuditLog();
audiLog.Id = Guid.NewGuid();
audiLog.UserName = userName;
audiLog.ModuleName = moduleName;
audiLog.TableName = tableName;
audiLog.EventType = eventType;
audiLog.NewValues = JsonConvert.SerializeObject(newValues, new JsonSerializerSettings()
{
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});
audiLog.Time = DateTime.Now;
context.Insert(audiLog);
}
}
/// <summary>
/// Return the ObjectQuery directly or convert the DbQuery to ObjectQuery.
/// </summary>
public static ObjectQuery GetObjectQuery <TEntity>(IDbContextBase context, IQueryable query)
where TEntity : class
{
if (query is ObjectQuery)
{
return(query as ObjectQuery);
}
if (context == null)
{
throw new ArgumentException("Paramter cannot be null", "context");
}
// Use the DbContext to create the ObjectContext
ObjectContext objectContext = ((IObjectContextAdapter)context).ObjectContext;
// Use the DbSet to create the ObjectSet and get the appropriate provider.
IQueryable iqueryable = objectContext.CreateObjectSet <TEntity>() as IQueryable;
IQueryProvider provider = iqueryable.Provider;
// Use the provider and expression to create the ObjectQuery.
return(provider.CreateQuery(query.Expression) as ObjectQuery);
}
private void Init(IDbContextBase context, IQueryable query, int delayForRetryOnError, CacheInfo cacheInfo)
{
try
{
StartMonitor(context);
this.iquery = query;
// Get the ObjectQuery directly or convert the DbQuery to ObjectQuery.
Core.Cmn.Extensions.QueryableExt.GetSqlCommand <TEntity>(context, query, ref connection, ref command);
RegisterSqlDependency();
}
catch (Exception ex)
{
try
{
using (var trace = new Trace.TraceDto())
{
trace.TraceKey = "CacheSqlDependency";
trace.Data["CacheName"] = cacheInfo.Name;
trace.Data["DateTime"] = DateTime.Now.ToString();
trace.Data["Exception"] = ex.ToString();
trace.Message = $"CacheSql Dependency {cacheInfo.Name} has faced with an exception at {DateTime.Now.ToString()} ...";
trace.Data["State"] = "initialize";
Core.Cmn.AppBase.TraceWriter.SubmitData(trace);
}
Core.Cmn.AppBase.LogService.Handle(ex, $"Exception on initialize ImmediateNotificationRegister for cache on SqlDependency, the query is {iquery}...");
}
catch
{
}
Task.Delay(delayForRetryOnError).Wait();
Init(context, query, delayForRetryOnError + 1000, cacheInfo);
}
}
public LogRepository(IDbContextBase dc)
: base(dc)
{
_dc = dc;
dc.DisableExceptionLogger = true;
}
public CacheManagementRepository(IDbContextBase dbContextBase)
: base(dbContextBase)
{
// _dbContext = dbContextBase;
}
//private CompanyChartRoleRepository _companyChartRoleRepository;
public CompanyChartRoleService(IDbContextBase dbContextBase)
: base(dbContextBase)
{
_repositoryBase = new CompanyChartRoleRepository(dbContextBase);
}
public List <string> GetKeyColumnNames <T>(IDbContextBase context) where T : ObjectBase
{
return((context as DbContext).Db(typeof(T)).Pks.Select(p => p.ColumnName).ToList());
}
public RouteMapConfigRepository(IDbContextBase dbContext)
: base(dbContext)
{
}
public ReportRepository(IDbContextBase dbContextBase)
: base(dbContextBase)
{
_dbContext = dbContextBase;
}
/// <summary>
/// 获取求和值。
/// </summary>
/// <typeparam name="TModel">当前模型类型。</typeparam>
/// <typeparam name="TValue">返回值。</typeparam>
/// <param name="db">数据库实例。</param>
/// <param name="column">当前列。</param>
/// <param name="expression">条件表达式。</param>
/// <param name="convert">转换函数。</param>
/// <returns>返回当前值。</returns>
public static TValue Sum <TModel, TValue>(this IDbContextBase <TModel> db,
Expression <Func <TModel, object> > column, Expression <Predicate <TModel> > expression = null,
Func <object, TValue> convert = null)
{
return(db.GetScalar("SUM", column, expression, convert));
}
public ReportService(IDbContextBase dbContextBase)
: base(dbContextBase)
{
//_userLog = userLog;
_repositoryBase = new ReportRepository(ContextBase);
}
/// <summary>
/// 获取最小值。
/// </summary>
/// <typeparam name="TModel">当前模型类型。</typeparam>
/// <param name="db">数据库实例。</param>
/// <param name="column">当前列。</param>
/// <param name="expression">条件表达式。</param>
/// <returns>返回当前值。</returns>
public static int Min <TModel>(this IDbContextBase <TModel> db,
Expression <Func <TModel, object> > column, Expression <Predicate <TModel> > expression = null)
{
return(db.Min(column, expression, Convert.ToInt32));
}
public CompanyChartRoleRepository(IDbContextBase dbContext)
: base(dbContext)
{
}
//...
public BaseRepository(IDbContextBase context)
{
Context = context;
Set = Context.Set <TEntity>();
}
public ViewElementRoleRepository(IDbContextBase dbContext)
: base(dbContext)
{
_dbContext = dbContext;
viewElementRepository = new ViewElementRepository(dbContext);
}
public UserProfileService(IDbContextBase dbContextBase, IDomainAuthenticationService domainAuthenticationService)
: base(dbContextBase)
{
_repositoryBase = new UserProfileRepository(dbContextBase);
_domainAuthenticationService = domainAuthenticationService;
}
public CharacteristicValueDbSetManager(DbSet <BaseCharacteristicValue> entities, IDbContextBase dbContext)
: base(entities, dbContext, "CharacteristicValues")
{
}
public TenantInformationUnitOfWork(ITenantInformationRepository tenantInformationRepository, IDbContextBase dbContextBase) : base(dbContextBase)
{
_tenantInformationRepository = tenantInformationRepository;
}
public UserRepository(IDbContextBase dBContext) : base(dBContext)
{
}
public DomainAuthenticationService(IDbContextBase context) : base(context)
{
}
public static void GetSqlCommand <TEntity>(IDbContextBase context, IQueryable query, ref SqlConnection connection, ref SqlCommand command) where TEntity : class
{
QueryExtensions.GetSqlCommand <TEntity>(context, query, ref connection, ref command);
}
protected BaseRepository(IDbContextBase context, IValidator <TEntity> validator = null)
{
_validator = validator;
Context = context;
UnitOfWork = context;
}
public List <string> GetKeyColumnNames <T>(IDbContextBase context) where T : ObjectBase
{
return(new List <string> {
"test"
});
}
protected override IConstantCategoryService ConstructService()
{
IDbContextBase ctx = Mock.MockHelperBase.BuildMockContext();
return(new ConstantCategoryService(ctx));
}
public CompanyViewElementService(IDbContextBase appContextBase)
: base(appContextBase)
{
_repositoryBase = new CompanyViewElementRepository(appContextBase);
_dbcontcontext = appContextBase;
}
