public SwiftpassPayController(ICommunityService communityService
//, IOptions<SwiftpassPayOptions> options
, FinanceDbContext db
, IOptions <ShopConglomerationOrderOptions> shopConglomerationOrderServer
, PayProxyFactory proxyFactory
, WechatCoreDbContext wechatCoreDb
, PrintDbContext printDbContext
, ShopDbContext shopdb
, MemberDbContext memberDbContext
, ILoggerFactory loggerFactory
, IOptions <WechatTemplateSendOptions> woptions
, IOptions <ThirdConfig> toptions
, IHostingEnvironment hostingEnvironment)
{
this.hostingEnvironment = hostingEnvironment;
this.woptions = woptions.Value;
//this.options = options.Value;
// this.db = ZRui.Web.BLL.DbContextFactory.FinanceDbContext;
this.db = db;
this.shopdb = shopdb;
this.printDbContext = printDbContext;
this.wechatCoreDb = wechatCoreDb;
this.proxyFactory = proxyFactory;
this._memberDbContext = memberDbContext;
_shopConglomerationOrderServer = shopConglomerationOrderServer.Value;
_logger = loggerFactory.CreateLogger <SwiftpassPayController>();
this.thirdConfig = toptions.Value;
}
public int Insert(MemberViewModel fromUI, string userId)
{
var result = 0;
fromUI.CreateDateTime = this.TimeNow.Value;
fromUI.CreateUserId = userId;
var memberTodB = new Member();
var memberLogToDb = new MemberLog();
var identityToDb = new Identity();
var roleToDb = new Role();
Mapper.Map(fromUI, memberTodB);
Mapper.Map(fromUI, memberLogToDb);
Mapper.Map(fromUI, identityToDb);
roleToDb = MapperRole(fromUI);
memberLogToDb.Member_Id = memberTodB.Id;
identityToDb.Member_Id = memberTodB.Id;
using (var dbContext = MemberDbContext.CreateContext())
{
dbContext.Member.Add(memberTodB);
dbContext.MemberLog.Add(memberLogToDb);
dbContext.Role.Add(roleToDb);
dbContext.Identity.Add(identityToDb);
result = dbContext.SaveChanges();
}
return(result);
}
public ShopBrandCommodityCategorySetAPIController(ICommunityService communityService
, IOptions <MemberAPIOptions> options
, MemberDbContext memberDb
, ShopDbContext db)
: base(options, db, memberDb)
{
}
public ShopManagerApiControllerBase(IOptions <MemberAPIOptions> options
, ShopDbContext db, MemberDbContext memberDb)
{
_options = _options = options.Value;
this.db = db;
this.memberDb = memberDb;
}
public static void BeforeTestRun()
{
var instance = SqlProviderServices.Instance;
Mapper.Initialize(p => p.AddProfile(new DefaultMappingProfile()));
using (var dbContext = MemberDbContext.CreateContext())
{
if (dbContext.Database.Exists())
{
dbContext.Database.Delete();
}
dbContext.Database.Initialize(true);
var CompanyConfing = dbContext.CompanyConfing.Where(p => p.CompanyId == "DDMC").ToList();
if (CompanyConfing.Count == 0)
{
var CompanyData = new CompanyConfing();
CompanyData.CompanyId = "DDMC";
CompanyData.Name = "鼎鼎企業管理股份有限公司";
dbContext.CompanyConfing.Add(CompanyData);
dbContext.SaveChanges();
}
}
}
public int Delete(MemberViewModel fromUI, string userId)
{
var result = 0;
var memberToDb = new Member();
var memberLogToDb = new MemberLog();
Mapper.Map(fromUI, memberToDb);
Mapper.Map(fromUI, memberLogToDb);
memberLogToDb.CreateUserId = null;
memberLogToDb.CreateDateTime = null;
memberLogToDb.LastModifyUserId = null;
memberLogToDb.LastModifyDateTime = null;
memberLogToDb.DeleteUserId = userId;
memberLogToDb.DeleteDateTime = this.TimeNow.Value;
memberLogToDb.Id = Guid.NewGuid();
memberLogToDb.Member_Id = fromUI.Id;
using (var dbContext = MemberDbContext.CreateContext())
{
dbContext.Member.Attach(memberToDb);
var memberEntry = dbContext.Entry(memberToDb);
memberEntry.State = EntityState.Deleted;
dbContext.MemberLog.Add(memberLogToDb);
result = dbContext.SaveChanges();
}
return(result);
}
public MemberController(ICommunityService communityService
, IOptions <MemberAPIOptions> options
, MemberDbContext memberDb
, ILoggerFactory loggerFactory)
: base(communityService, options, memberDb)
{
}
public ShopBrandCommodityCategorySetController(ICommunityService communityService
, IOptions <MemberAPIOptions> options
, MemberDbContext memberDb
, IHostingEnvironment hostingEnvironment)
: base(communityService, options, memberDb)
{
this.hostingEnvironment = hostingEnvironment;
}
public MainWindow(MemberDbContext dbContext)
{
this.dbContext = dbContext;
InitializeComponent();
GetMembers();
}
public ShopCallingQueueProductSetController(ICommunityService communityService
, IOptions <MemberAPIOptions> options
, MemberDbContext memberDb
, IHostingEnvironment hostingEnvironment)
: base(communityService, options, memberDb)
{
this.hostingEnvironment = hostingEnvironment;
}
public CommercialDistrictShopSetController(ICommunityService communityService
, IOptions <MemberAPIOptions> options
, MemberDbContext memberDb
, IHostingEnvironment hostingEnvironment)
: base(communityService, options, memberDb)
{
this.hostingEnvironment = hostingEnvironment;
}
public MemberSetController(ICommunityService communityService
, IOptions <MemberAPIOptions> options
, MemberDbContext memberDb
, ILoggerFactory loggerFactory)
: base(communityService, options, memberDb)
{
_logger = loggerFactory.CreateLogger <MemberSetController>();
}
public CommunityApiControllerBase(ICommunityService communityService
, IOptions <MemberAPIOptions> options
, MemberDbContext memberDb)
{
_communityService = communityService;
_options = _options = options.Value;
this.memberDb = memberDb;
}
public ShopBrandSetAPIController(ICommunityService communityService
, IOptions <MemberAPIOptions> options
, ShopDbContext db
, MemberDbContext memberDb
, IHostingEnvironment hostingEnvironment)
: base(options, db, memberDb)
{
this.hostingEnvironment = hostingEnvironment;
}
public WechatApiControllerBase(IOptions <MemberAPIOptions> options
, MemberDbContext memberDb
, WechatCoreDbContext wechatCoreDb
)
{
_options = options.Value;
this.memberDb = memberDb;
this.wechatCoreDb = wechatCoreDb;
}
public int NewMembersToday()
{
using (var dbContext = new MemberDbContext())
{
var startTime = DateTime.Now.DayZero();
var endTime = DateTime.Now.DayEnd();
return(dbContext.Members.Count(m => m.CreateTime >= startTime && m.CreateTime <= endTime));
}
}
public static Guid TestComapnyData()
{
using (var dbContext = MemberDbContext.CreateContext())
{
var compnayConfig = dbContext.CompanyConfing.Where(p => p.CompanyId == "DDMC").FirstOrDefault().Id;
return(compnayConfig);
}
}
/// <summary>
///
/// </summary>
/// <param name="wechatOptions"></param>
/// <param name="wechatCoreDb"></param>
/// <param name="communityService"></param>
/// <param name="options"></param>
/// <param name="context"></param>
/// <param name="loggerFactory"></param>
public WechatCoreController(IOptions <WechatOptions> wechatOptions, WechatCoreDbContext wechatCoreDb, ICommunityService communityService, IOptions <MemberAPIOptions> options, MemberDbContext context, ILoggerFactory loggerFactory)
{
this.wechatCoreDb = wechatCoreDb;
_logger = loggerFactory.CreateLogger <CommunityAPIController>();
_communityService = communityService;
_context = context;
this.wechatOptions = wechatOptions.Value;
}
public ShopIntegralRechargeServer(
IOptions <MemberAPIOptions> options
, ShopDbContext db
, ILoggerFactory loggerFactory
, MemberDbContext memberDb
)
{
this.db = db;
_logger = loggerFactory.CreateLogger <ShopIntegralRechargeServer>();
}
public SettingBaseSetAPIControllerBase(ICommunityService communityService
, IOptions <MemberAPIOptions> options
, MemberDbContext memberDb
, IDbContextFactory dbFactory
, IHostingEnvironment hostingEnvironment)
: base(communityService, options, memberDb)
{
this.hostingEnvironment = hostingEnvironment;
this.dbFactory = dbFactory;
}
public MemberAPIController(ICommunityService communityService
, MemberDbContext memberDb
, IOptions <MemberAPIOptions> options
, IHostingEnvironment hostingEnvironment
, ILoggerFactory loggerFactory)
: base(communityService, options, memberDb)
{
_logger = loggerFactory.CreateLogger <MemberAPIController>();
this.hostingEnvironment = hostingEnvironment;
}
public RobotMessageSetAPIController(ICommunityService communityService
, IOptions <MemberAPIOptions> options
, WechatCoreDbContext wechatCoreDb
, MemberDbContext memberDb
, ILoggerFactory loggerFactory)
: base(communityService, options, memberDb)
{
this.wechatCoreDb = wechatCoreDb;
_logger = loggerFactory.CreateLogger <RobotMessageSetAPIController>();
}
public ShopBookingSetAPIController(ICommunityService communityService
, IOptions <MemberAPIOptions> options
, MemberDbContext memberDb
, ShopDbContext db
, IHostingEnvironment hostingEnvironment)
: base(communityService, options, memberDb)
{
this.db = db;
this.hostingEnvironment = hostingEnvironment;
}
public static void AfterTestRun()
{
using (var dbContext = MemberDbContext.CreateContext())
{
if (dbContext.Database.Exists())
{
dbContext.Database.Delete();
}
}
}
public int Update(MemberViewModel fromUI, string userId)
{
var result = 0;
fromUI.LastModifyDateTime = this.TimeNow.Value;
fromUI.LastModifyUserId = userId;
var memberToDb = new Member();
var memberLogToDb = new MemberLog();
var identityToDb = new Identity();
var roleToDb = new Role();
Mapper.Map(fromUI, memberToDb);
Mapper.Map(fromUI, identityToDb);
Mapper.Map(fromUI, memberLogToDb);
roleToDb = MapperRole(fromUI);
roleToDb.LastModifyDateTime = this.TimeNow.Value;
roleToDb.LastModifyUserId = userId;
memberLogToDb.Member_Id = memberToDb.Id;
identityToDb.Member_Id = memberToDb.Id;
memberLogToDb.Id = Guid.NewGuid();
memberLogToDb.CreateUserId = null;
memberLogToDb.CreateDateTime = null;
using (var dbContext = MemberDbContext.CreateContext())
{
/* dbContext.Member.Attach(memberToDb);
* dbContext.Identity.Attach(identityToDb);
* dbContext.Role.Attach(roleToDb);*/
var memberEntry = dbContext.Entry(memberToDb);
memberEntry.State = EntityState.Modified;
memberEntry.Property(p => p.CreateUserId).IsModified = false;
memberEntry.Property(p => p.CreateDateTime).IsModified = false;
var identityEntry = dbContext.Entry(identityToDb);
identityEntry.State = EntityState.Modified;
identityEntry.Property(p => p.CreateUserId).IsModified = false;
identityEntry.Property(p => p.CreateDateTime).IsModified = false;
var roleEntry = dbContext.Entry(roleToDb);
roleEntry.State = EntityState.Modified;
roleEntry.Property(p => p.CreateUserId).IsModified = false;
roleEntry.Property(p => p.CreateDateTime).IsModified = false;
dbContext.MemberLog.Add(memberLogToDb);
result = dbContext.SaveChanges();
}
return(result);
}
public MemberAmountCacheForWechatAPIController(
IOptions <MemberAPIOptions> options
, FinanceDbContext db
, MemberDbContext memberDb
, WechatCoreDbContext wechatCoreDb
, IHostingEnvironment hostingEnvironment)
: base(options, memberDb, wechatCoreDb)
{
this.db = db;
this.hostingEnvironment = hostingEnvironment;
}
public ShopMemberSetAPIController(ICommunityService communityService
, IOptions <MemberAPIOptions> options
, MemberDbContext memberDb
, ShopDbContext db
, IMapper mapper
, IHostingEnvironment hostingEnvironment)
: base(options, db, memberDb)
{
this.hostingEnvironment = hostingEnvironment;
_mapper = mapper;
}
public ShopCommentAPIController(ICommunityService communityService
, IOptions <MemberAPIOptions> memberOptions
, ShopDbContext db
, WechatCoreDbContext wechatCoreDb
, MemberDbContext memberDb
, IHostingEnvironment hostingEnvironment)
: base(memberOptions, memberDb, wechatCoreDb)
{
this.db = db;
this.hostingEnvironment = hostingEnvironment;
}
/// <summary>
/// 会员后台管理获取用户信息
/// </summary>
/// <typeparam name="TKey"></typeparam>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="expression"></param>
/// <param name="orderByExpression"></param>
/// <param name="isDesc"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public List <MemberFull> GetMemberFullListPaged <TKey>(int pageIndex, int pageSize, Expression <Func <MemberFull, bool> > expression, Expression <Func <MemberFull, TKey> > orderByExpression, bool isDesc, out int totalCount)
{
using (var dbContext = new MemberDbContext())
{
totalCount = dbContext.MembersFull.AsExpandable().Where(expression).Count(); //获取总数
//需要增加AsExpandable(),否则查询的是所有数据到内存，然后再排序 AsExpandable是linqkit.dll中的方法
var data = dbContext.MembersFull.AsExpandable().Where(expression);
var orderedData = isDesc ? data.OrderByDescending(orderByExpression) : data.OrderBy(orderByExpression);
return(orderedData.Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList());
}
}
public ShopWechatOpenSetController(IOptions <MemberAPIOptions> options
, ShopDbContext db
, MemberDbContext memberDb
, IOptions <WechatOpenOptions> wechatOpenOptions
, ILoggerFactory loggerFactory
, IHostingEnvironment hostingEnvironment)
: base(options, db, memberDb)
{
this.hostingEnvironment = hostingEnvironment;
this.wechatOpenOptions = wechatOpenOptions.Value;
logger = loggerFactory.CreateLogger <ShopWechatOpenSetController>();
}
