/// <summary>
/// 修改
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public int Update_Date(MemberListDTO MemberList)
{
using (MyDbContext dbc = new MyDbContext())
{
MemberSearchResult result = new MemberSearchResult();
var User = dbc.User.SingleOrDefault(u => u.ID == MemberList.ID);
if (User == null)
{
return(0);
}
User.TrueName = MemberList.TrueName;
User.IdenCode = MemberList.IdenCode;
User.PhoneNum = MemberList.PhoneNum;
if (User.Password != MemberList.Password)
{
User.Password = MemberList.Password;
}
if (User.SecondPassword != MemberList.SecondPassword)
{
User.SecondPassword = MemberList.SecondPassword;
}
if (User.ThreePassword != MemberList.ThreePassword)
{
User.ThreePassword = MemberList.ThreePassword;
}
dbc.SaveChanges();
return(2);
}
}
/// <summary>
/// 激活ID
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public int Pass(long id)
{
using (MyDbContext dbc = new MyDbContext())
{
MemberSearchResult result = new MemberSearchResult();
CommonService <UserEntity> cs = new CommonService <UserEntity>(dbc);
//先查询有没有值。
var User = cs.GetById(id);
if (User == null)
{
//没有值就返回null
result.MemberList = null;
return(0);
}
//已经开通
if (User.IsOpend == 2)
{
result.MemberList = null;
return(1);
}
else
{
User.IsOpend = 2;
User.OpenTime = DateTime.Now;
dbc.SaveChanges();
return(2);
}
}
}
/// <summary>
/// 删除ID
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public int Del(long id)
{
using (MyDbContext dbc = new MyDbContext())
{
MemberSearchResult result = new MemberSearchResult();
CommonService <UserEntity> cs = new CommonService <UserEntity>(dbc);
//先查询有没有值。
var User = cs.GetById(id);
if (User == null)
{
//没有值就返回null
result.MemberList = null;
return(0);
}
//删除
if (User.IsOpend == 2)
{
result.MemberList = null;
return(1);
}
else
{
User.IsDeleted = true;
dbc.SaveChanges();
return(2);
}
}
}
/// <summary>
/// 删除ID
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public int Del(long id)
{
using (MyDbContext dbc = new MyDbContext())
{
MemberSearchResult result = new MemberSearchResult();
//先查询有没有值。
var User = dbc.User.SingleOrDefault(u => u.ID == id);;
if (User == null)
{
//没有值就返回null
result.MemberList = null;
return(0);
}
//删除
if (User.IsOpend == 2)
{
result.MemberList = null;
return(1);
}
else
{
dbc.User.Remove(User);
dbc.SaveChanges();
return(2);
}
}
}
/// <summary>
/// 激活ID
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public int Pass(long id)
{
using (MyDbContext dbc = new MyDbContext())
{
MemberSearchResult result = new MemberSearchResult();
//先查询有没有值。
var User = dbc.User.SingleOrDefault(u => u.ID == id);
if (User == null)
{
//没有值就返回null
result.MemberList = null;
return(0);
}
//已经开通
if (User.IsOpend == 2)
{
result.MemberList = null;
return(1);
}
else
{
User.IsOpend = 2;
User.OpenTime = DateTime.Now;
dbc.SaveChanges();
return(2);
}
}
}
/// <summary>
/// 修改升级,扣款，加人流水表
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public long Update_LeveID(int GetLoginID, int LeveID, decimal Amount)
{
using (MyDbContext dbc = new MyDbContext())
{
MemberSearchResult result = new MemberSearchResult();
CommonService <UserEntity> cs = new CommonService <UserEntity>(dbc);
//先查询有没有值。
var User = cs.GetById(GetLoginID);
if (User == null)
{
//没有值就返回null
result.MemberList = null;
return(0);
}
User.LevelID = LeveID;
User.Emoney = User.Emoney - Amount;
User.RegMoney = User.RegMoney + Amount;
JournalEntity journal = new JournalEntity();
journal.UserID = GetLoginID;
journal.Remark = "会员升级";
journal.OutAmount = Amount;
journal.BalanceAmount = User.Emoney;
journal.JournalDate = DateTime.Now;
journal.JournalType = 1;
journal.Journal01 = GetLoginID;
dbc.Journal.Add(journal);
dbc.SaveChanges();
return(2);
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public int Update_Date(MemberListDTO MemberList)
{
using (MyDbContext dbc = new MyDbContext())
{
MemberSearchResult result = new MemberSearchResult();
CommonService <UserEntity> cs = new CommonService <UserEntity>(dbc);
var User = cs.GetById(MemberList.ID);
if (User == null)
{
return(0);
}
User.TrueName = MemberList.TrueName;
User.IdenCode = MemberList.IdenCode;
User.PhoneNum = MemberList.PhoneNum;
if (User.Password != MemberList.Password)
{
User.Password = MemberList.Password;
}
if (User.SecondPassword != MemberList.SecondPassword)
{
User.SecondPassword = MemberList.SecondPassword;
}
if (User.ThreePassword != MemberList.ThreePassword)
{
User.ThreePassword = MemberList.ThreePassword;
}
dbc.SaveChanges();
return(2);
}
}
public async Task <MemberSearchResult> GetModelListAsync(long?teamId, string keyword, DateTime?startTime, DateTime?endTime, int pageIndex, int pageSize)
{
using (MyDbContext dbc = new MyDbContext())
{
MemberSearchResult result = new MemberSearchResult();
var entities = dbc.GetAll <MemberEntity>().AsNoTracking();
if (teamId != null)
{
entities = entities.Where(a => a.TeamId == teamId);
}
if (!string.IsNullOrEmpty(keyword))
{
entities = entities.Where(g => g.Name.Contains(keyword) || g.Mobile.Contains(keyword));
}
if (startTime != null)
{
entities = entities.Where(a => a.CreateTime >= startTime);
}
if (endTime != null)
{
entities = entities.Where(a => SqlFunctions.DateDiff("day", endTime, a.CreateTime) <= 0);
}
result.PageCount = (int)Math.Ceiling((await entities.LongCountAsync()) * 1.0f / pageSize);
var memberResult = await entities.OrderByDescending(a => a.CreateTime).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToListAsync();
result.Member = memberResult.Select(a => ToDTO(a)).ToArray();
return(result);
}
}
/// <summary>
/// 分页
/// </summary>
/// <param name="Id"></param>
/// <param name="usercode"></param>
/// <param name="Level"></param>
/// <param name="Strat"></param>
/// <param name="End"></param>
/// <param name="i">I为0就是查询未开通</param>
/// <param name="pageIndex"></param>
/// <returns></returns>
public ActionResult MemberGetPage(string Id, int getloginid, string usercode, string Level, DateTime?Strat, DateTime?End, int i, int pageIndex = 1)
{
MemberListViewModel model = new MemberListViewModel();
MemberSearchResult result = MemberService.GetMemberList(Id, getloginid, usercode, Level, Strat, End, pageIndex, pageSize, i);
model.MemberList = result.MemberList;
//分页
Pagination pager = new Pagination();
pager.PageIndex = pageIndex;
pager.PageSize = pageSize;
pager.TotalCount = result.TotalCount;
if (result.TotalCount <= pageSize)
{
model.Page = "";
}
else
{
model.Page = pager.GetPagerHtml();
}
return(Json(new AjaxResult {
Status = "1", Data = model
}));
}
/// <summary>
/// 查询这个ID的信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>MemberListDTO
public MemberSearchResult ToUser(int id)
{
using (MyDbContext dbc = new MyDbContext())
{
var User = dbc.User.Where(u => u.ID == id);
MemberSearchResult Result = new MemberSearchResult();
Result.MemberList = User.OrderByDescending(p => p.ID).ToList().Select(a => ToDTO(a)).ToArray();
return(Result);
}
}
public MemberSearchResult GetPageList(int pageIndex, int pageSize)
{
using (MyDbContext dbc = new MyDbContext())
{
MemberSearchResult result = new MemberSearchResult();
CommonService<UserEntity> cs = new CommonService<UserEntity>(dbc);
var User = cs.GetAll();
result.TotalCount = User.LongCount();
result.MemberList = User.OrderByDescending(a => a.CreateTime).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList().Select(a => new MemberListDTO { UserCode = a.UserCode }).ToArray();
return result;
}
}
/// <summary>
/// 查询这个ID的信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>MemberListDTO
public MemberSearchResult ToUser(int id)
{
using (MyDbContext dbc = new MyDbContext())
{
CommonService <UserEntity> cs = new CommonService <UserEntity>(dbc);
var User = cs.GetAll();
User = User.Where(a => a.ID == id);
MemberSearchResult Result = new MemberSearchResult();
Result.MemberList = User.OrderByDescending(p => p.ID).ToList().Select(a => ToDTO(a)).ToArray();
return(Result);
}
}
public PartialViewResult Member_Page(string Id, string usercode, string Level_1, DateTime?Strat, DateTime?End, int i, int pageIndex = 1)
{
ViewBag.hard_value = new List <SelectListItem>()
{
new SelectListItem()
{
Value = "0", Text = "--请选择--"
},
new SelectListItem()
{
Value = "1", Text = "会员编号"
},
new SelectListItem()
{
Value = "2", Text = "推荐人编号"
},
};
if (Level_1 == null)
{
Level_1 = "0";
}
MemberListViewModel model = new MemberListViewModel();
MemberSearchResult result = MemberService.GetMemberList(Id, usercode, Level_1, Strat, End, pageIndex, pageSize, i);
Pagination pager = new Pagination();
pager.PageIndex = pageIndex;
pager.PageSize = pageSize;
pager.TotalCount = result.TotalCount;
if (result.TotalCount <= pageSize)
{
model.Page = "";
}
else
{
model.Page = pager.GetPagerHtml();
}
model.MemberList = result.MemberList;
model.BlogCategory = Level.GetAll();
string Table = "";
if (i == 0)
{
Table = "MemberPage";
}
else
{
Table = "MemberListPage";
}
return(PartialView(Table, model));
}
public MemberSearchResult GetPageList(int pageIndex, int pageSize)
{
using (MyDbContext dbc = new MyDbContext())
{
MemberSearchResult result = new MemberSearchResult();
var User = dbc.User;
result.TotalCount = User.LongCount();
result.MemberList = User.OrderByDescending(a => a).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList().Select(a => new MemberListDTO {
UserCode = a.UserCode
}).ToArray();
return(result);
}
}
/// <summary>
/// 后台查询i=0就是查询未开通会员
/// </summary>
/// <param name="Id"></param>
/// <param name="usercode"></param>
/// <param name="Level"></param>
/// <param name="Strat"></param>
/// <param name="End"></param>
/// <param name="PageIndex"></param>
/// <param name="PageSize"></param>
/// <param name="i">i=0就是查询未开通会员</param>
/// <returns></returns>
public MemberSearchResult GetMemberList(string Id, string usercode, string Level, DateTime?Strat, DateTime?End, int PageIndex, int PageSize, int i)
{
using (MyDbContext dbc = new MyDbContext())
{
//MemberDTO[] result = new MemberDTO();
CommonService <UserEntity> cs = new CommonService <UserEntity>(dbc);
var User = cs.GetAll();
if (i == 0)
{
User = User.Where(a => a.IsOpend < 2);
}
else
{
User = User.Where(a => a.IsOpend == 2);
}
MemberSearchResult MemberSearch = new MemberSearchResult();
long level = Convert.ToInt64(Level);
if (Id != "0")
{
if (usercode != "")
{
if (Id == "1")
{
User = User.Where(p => p.UserCode.Contains(usercode));
}
else if (Id == "2")
{
User = User.Where(p => p.RecommendCode.Contains(usercode));
}
}
}
if (Level != "0" && Level != "")
{
User = User.Where(p => p.LevelID == level);
}
if (Strat != null)
{
User = User.Where(p => p.CreateTime >= Strat);
}
if (End != null)
{
User = User.Where(p => p.CreateTime <= End);
}
MemberSearch.TotalCount = User.LongCount();
MemberSearch.MemberList = User.OrderByDescending(p => p.ID).ToList().Skip((PageIndex - 1) * PageSize).Take(PageSize).ToList().Select(p => ToDTO(p)).ToArray();
return(MemberSearch);
}
}
public override async Task <MemberSearchResult> SearchMembersAsync(MembersSearchCriteria criteria)
{
var result = new MemberSearchResult();
if (criteria == null || (!criteria.DeepSearch || (criteria.MemberId == null && criteria.ObjectIds.IsNullOrEmpty() && criteria.Keyword.IsNullOrEmpty())))
{
result = await base.SearchMembersAsync(criteria);
}
else
{
var orgSkip = criteria.Skip;
var orgTake = criteria.Take;
var orgMemberTypes = criteria.MemberTypes?.Select(x => x).ToArray();
//do not use index searching if concrete members are selected
if (!criteria.ObjectIds.IsNullOrEmpty())
{
criteria.Keyword = null;
}
var withoutOrganizations = criteria.MemberTypes != null && !criteria.MemberTypes.Contains(OrganizationMemberType);
criteria.Skip = 0;
criteria.Take = criteria.Keyword.IsNullOrEmpty() ? int.MaxValue : ElasticMaxTake;
if (withoutOrganizations)
{
criteria.MemberTypes = criteria.MemberTypes.Union(new[] {
OrganizationMemberType
}).ToArray();
}
var firstResult = await base.SearchMembersAsync(criteria);
var organizations = firstResult.Results.OfType <Organization>().ToArray();
result.Results = withoutOrganizations ? firstResult.Results.Where(x => orgMemberTypes.Contains(x.MemberType)).ToList() : firstResult.Results.ToList();
result.TotalCount = result.Results.Count;
if (!organizations.IsNullOrEmpty())
{
await LoadChildren(criteria, organizations, withoutOrganizations, orgMemberTypes, result);
}
//skip take as firstly
result.Results = result.Results.Skip(orgSkip).Take(orgTake).ToList();
}
return(result);
}
public int Open(long id)
{
using (MyDbContext dbc = new MyDbContext())
{
MemberSearchResult result = new MemberSearchResult();
//先查询有没有值。
var User = dbc.User.SingleOrDefault(u => u.ID == id);
if (User == null)
{
//没有值就返回null
result.MemberList = null;
return(0);
}
else
{
User.IsLock = 0;
dbc.SaveChanges();
return(2);
}
}
}
/// <summary>
/// 修改升级
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public long Update_LeveID(int GetLoginID, int LeveID)
{
using (MyDbContext dbc = new MyDbContext())
{
MemberSearchResult result = new MemberSearchResult();
//先查询有没有值。
var User = dbc.User.SingleOrDefault(u => u.ID == GetLoginID);
if (User == null)
{
//没有值就返回null
result.MemberList = null;
return(0);
}
else
{
User.LevelID = LeveID;
dbc.SaveChanges();
return(2);
}
}
}
/// <summary>
/// 修改升级
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public long Update_LeveID(int GetLoginID, int LeveID)
{
using (MyDbContext dbc = new MyDbContext())
{
MemberSearchResult result = new MemberSearchResult();
CommonService <UserEntity> cs = new CommonService <UserEntity>(dbc);
//先查询有没有值。
var User = cs.GetById(GetLoginID);
if (User == null)
{
//没有值就返回null
result.MemberList = null;
return(0);
}
else
{
User.LevelID = LeveID;
dbc.SaveChanges();
return(2);
}
}
}
/// <summary>
/// 冻结
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public int Close(long id)
{
using (MyDbContext dbc = new MyDbContext())
{
MemberSearchResult result = new MemberSearchResult();
CommonService <UserEntity> cs = new CommonService <UserEntity>(dbc);
//先查询有没有值。
var User = cs.GetById(id);
if (User == null)
{
//没有值就返回null
result.MemberList = null;
return(0);
}
else
{
User.IsLock = 1;
dbc.SaveChanges();
return(2);
}
}
}
public List <MemberSearchResult> SearchMembers(string criteria)
{
var proc = "SearchMembersByName";
var paramz = new List <SqlParameter>();
paramz.Add(new SqlParameter("criteria", criteria));
Func <SqlDataReader, MemberSearchResult> readFx = (reader) =>
{
var member = new MemberSearchResult();
member.MemberId = (int)reader["MemberId"];
member.FirstName = reader["FirstName"].ToString();
member.LastName = reader["LastName"].ToString();
member.ChurchId = (int)reader["ChurchId"];
member.ChurchName = reader["ChurchName"].ToString();
return(member);
};
var list = _executor.ExecuteSql <MemberSearchResult>(proc, CommandType.StoredProcedure, paramz, readFx);
return(list);
}
private async Task LoadChildren(MembersSearchCriteria criteria, IEnumerable <Organization> organizations, bool withoutOrganizations, string[] orgMemberTypes, MemberSearchResult result)
{
foreach (var organization in organizations)
{
var searchChildrenCriteria = new MembersSearchCriteria()
{
MemberId = organization.Id,
DeepSearch = true,
Skip = 0,
Take = int.MaxValue,
Sort = criteria.Sort,
MemberTypes = criteria.MemberTypes,
ResponseGroup = criteria.ResponseGroup
};
var searchChildrenResult = await RegularSearchMembersAsync(searchChildrenCriteria);
var childOrganizations = searchChildrenResult.Results.OfType <Organization>().ToArray();
var childResults = withoutOrganizations ? searchChildrenResult.Results.Where(x => orgMemberTypes.Contains(x.MemberType)).ToList() : searchChildrenResult.Results.ToList();
var resultIds = result.Results.Select(x => x.Id).ToArray();
childResults = childResults.Where(c => !resultIds.Contains(c.Id)).ToList();
result.Results.AddRange(childResults);
result.TotalCount += childResults.Count;
if (!childOrganizations.IsNullOrEmpty())
{
await LoadChildren(criteria, childOrganizations, withoutOrganizations, orgMemberTypes, result);
}
}
}
/// <summary>
/// 前台查询未开通会员
/// </summary>
/// <param name="Id"></param>
/// <param name="GetLoginID">GetLoginID 推荐会员</param>
/// <param name="usercode"></param>
/// <param name="Level"></param>
/// <param name="Strat"></param>
/// <param name="End"></param>
/// <param name="PageIndex"></param>
/// <param name="PageSize"></param>
/// <param name="i">i=0就是查询未开通会员 2 是开通会员 3是注册会员</param>
/// <returns></returns>
public MemberSearchResult GetMemberList(string Id, int GetLoginID, string usercode, string Level, DateTime?Strat, DateTime?End, int PageIndex, int PageSize, int i)
{
using (MyDbContext dbc = new MyDbContext())
{
//MemberDTO[] result = new MemberDTO();
var User = dbc.User.AsEnumerable();
if (i == 0 || i == 3)
{
if (i == 0)
{
User = User.Where(a => a.IsOpend < 2);
}
else
{
User = User.Where(a => a.IsOpend <= 2);
}
if (Strat != null)
{
User = User.Where(p => p.CreateTime >= Strat);
}
if (End != null)
{
User = User.Where(p => p.CreateTime <= End);
}
}
else
{
User = User.Where(a => a.IsOpend == 2);
if (Strat != null)
{
User = User.Where(p => p.OpenTime >= Strat);
}
if (End != null)
{
User = User.Where(p => p.OpenTime <= End);
}
}
MemberSearchResult MemberSearch = new MemberSearchResult();
long level = Convert.ToInt64(Level);
if (Id != "0")
{
if (usercode != "")
{
if (Id == "1")
{
User = User.Where(p => p.UserCode.Contains(usercode));
}
else if (Id == "2")
{
User = User.Where(p => p.RecommendCode.Contains(usercode));
}
}
}
if (GetLoginID > 0)//推荐人列表
{
User = User.Where(p => p.RecommendID == 9 && p.ID != 9);
}
if (Level != "0")
{
User = User.Where(p => p.LevelID == level);
}
MemberSearch.TotalCount = User.LongCount();
MemberSearch.MemberList = User.OrderByDescending(p => p.ID).ToList().Skip((PageIndex - 1) * PageSize).Take(PageSize).ToList().Select(p => ToDTO(p)).ToArray();
return(MemberSearch);
}
}
public void CopyUserData (MemberSearchResult result)
{
this.FullMemberName = result.FullName;
this.GymID = result.GymId;
this.PhoneNumber = result.Phone1;
this.ProfileID = result.ProfileId;
}
private void ExecuteItemSelectedCommand(MemberSearchResult user)
{
if (IsBusy)
return;
IsBusy = true;
SelectedUser = user;
TextChangedViaListSelection = true;
SearchMember = SelectedUser.FullName;
ButtonGroupVisibility = true;
IsListVisible = false;
IsBusy = false;
}
