private void ExecuteSearchText()
{
_unitOfWork = UnityInit.UnitOfWork;
_memberCardRepository = _unitOfWork.GetRepository <MemberCardRepository>();
_memberCards.Clear();
_memberCardRepository
.Query()
.Where(x =>
x.MemberCardNo.Contains(TxtSearchBox.Text) ||
x.Name.Contains(TxtSearchBox.Text))
.ToList()
.ForEach(x => _memberCards.Add(new MemberCardModel
{
MemberCard = x,
RelateUserName = x.RelateUserId.HasValue
? x.RelateUserUser.Name
: string.Empty,
DispatchUserName = x.DispatchUserId.HasValue
? x.DispatchUserUser.Name
: string.Empty,
CanUpdate = x.MemberCardStatus == (sbyte)DataType.MemberCardStatus.NonActive &&
!x.RelateUserId.HasValue
}));
InitBlankRow();
}
public MemberCardController(
IMemberCardRepository _MemberCard
, IUserRepository _user
, ICustomerRepository customer
)
{
MemberCardRepository = _MemberCard;
userRepository = _user;
customerRepository = customer;
}
public InputPassword(int memberCardId)
{
_memberCardId = memberCardId;
_unitOfWork = UnityInit.UnitOfWork;
_userRepository = _unitOfWork.GetRepository <UserRepository>();
_memberCardRepository = _unitOfWork.GetRepository <MemberCardRepository>();
InitializeComponent();
txtPassword.Focus();
}
public MemberCardLog(int memberCardId)
{
InitializeComponent();
_unitOfWork = UnityInit.UnitOfWork;
_memberCardRepository = _unitOfWork.GetRepository <MemberCardRepository>();
DataContext = new
{
MemberCardLogs = _memberCardRepository.GetByMemberCardId(memberCardId).MemberCardlogs.OrderByDescending(x => x.DateChanged)
};
}
private void ExecuteSearchText()
{
_unitOfWork = UnityInit.UnitOfWork;
_userRepository = _unitOfWork.GetRepository <UserRepository>();
_memberCardRepository = _unitOfWork.GetRepository <MemberCardRepository>();
_saleOrderRepository = _unitOfWork.GetRepository <SaleOrderRepository>();
_memberCard =
_memberCardRepository.Query()
.FirstOrDefault(x => x.IsEnable && x.RelateUserId == _userId);
SetMemberCardInfo();
}
private void ExecuteSearchText()
{
_unitOfWork = UnityInit.UnitOfWork;
_userRepository = _unitOfWork.GetRepository <UserRepository>();
_memberCardRepository = _unitOfWork.GetRepository <MemberCardRepository>();
_saleOrderRepository = _unitOfWork.GetRepository <SaleOrderRepository>();
_memberCard =
_memberCardRepository.Query()
.FirstOrDefault(x => x.IsEnable && x.RelateUserId == _userId);
if (_memberCard != null)
{
SetMemberCardInfo();
txtMemberCardNo.IsEnabled = false;
txtFirstPassWord.Focus();
}
else
{
txtMemberCardNo.Focus();
}
}
public SaleOrderForm(SaleOrder saleOrderWindow, DataModel.Model.SaleOrder saleOrder)
{
InitializeComponent();
TxtUserNoOrPhone.Focus();
_unitOfWork = UnityInit.UnitOfWork;
_saleOrderRepository = _unitOfWork.GetRepository <SaleOrderRepository>();
_soProduceRepository = _unitOfWork.GetRepository <SOProduceRepository>();
_produceRepository = _unitOfWork.GetRepository <ProduceRepository>();
_userRepository = _unitOfWork.GetRepository <UserRepository>();
_memberCardRepository = _unitOfWork.GetRepository <IMemberCardRepository>();
SaleOrderWindow = saleOrderWindow;
if (saleOrder.SaleOrderId > 0)
{
_saleOrder = _saleOrderRepository.Query()
.Single(x => x.SaleOrderId == saleOrder.SaleOrderId);
_saleOrder.SOProduces.ForEach(x => _soProduceDomainModels.Add(new SOProduceDomainModel
{
SOProduce = x,
CostPerUnit = x.CostPerUnit,
SOProduceTotal = (x.CostPerUnit ?? 0) * x.Quantity ?? 0
}));
if (_saleOrder.PurchaseOrderUserId.HasValue)
{
_user = _userRepository.GetByUserId(_saleOrder.PurchaseOrderUserId.Value);
_memberCard =
_memberCardRepository.Query()
.FirstOrDefault(x => x.IsEnable && x.RelateUserId == _saleOrder.PurchaseOrderUserId);
if (_memberCard == null)
{
_memberCard = new DataModel.Model.MemberCard();
}
}
}
else
{
_saleOrder = saleOrder;
}
if (_saleOrder.SaleOrderStatus == (byte)DataType.SaleOrderStatus.Balanced)
{
ButSave.IsEnabled = false;
ButBalance.IsEnabled = false;
}
if (_saleOrder.HowBalance == (sbyte)DataType.SaleOrderBalancedMode.Cash)
{
TabItemCash.IsSelected = true;
RadBanlanceModeCash.IsChecked = true;
}
else if (_saleOrder.HowBalance == (sbyte)DataType.SaleOrderBalancedMode.MemberCard)
{
RadBanlanceModeCard.IsChecked = true;
TabItemCard.IsSelected = true;
}
else
{
RadBanlanceModeUnionPay.IsChecked = true;
TabItemUnionPay.IsSelected = true;
}
_balanceDomainModel = new BalanceDomainModel
{
TotalPrice = saleOrder.TotalCost ?? 0,
DiscountPrice = saleOrder.FavorableCost ?? 0,
CashTotal = _user.CashTotal,
RealPrice = saleOrder.UserRealPrice ?? 0,
ReturnedPrice = saleOrder.UserReturnedPrice ?? 0
};
DataContext = new
{
SaleOrder = _saleOrder,
SOProduceDomainModels,
ResourcesHelper.CurrentUserRolePermission,
BalanceDomainModel = _balanceDomainModel,
};
TxtDiscount.Text = _balanceDomainModel.DiscountPrice.ToString();
TxtRealPrice.Text = _balanceDomainModel.RealPrice.ToString();
_soProduceDomainModels.CollectionChanged += (sender, e) => SetTotalNameberText();
SetTotalNameberText();
SetUserInfo();
RadBanlanceModeCard.Click += (s, e) =>
{
TabItemCard.IsSelected = true;
};
RadBanlanceModeCash.Click += (s, e) =>
{
TabItemCash.IsSelected = true;
};
RadBanlanceModeUnionPay.Click += (s, e) =>
{
TabItemUnionPay.IsSelected = true;
};
}
public MemberCardService(IMemberCardRepository repository, IUnitOfWork unitOfWork) : base(repository, unitOfWork)
{
}
public MemberCardMgr(IMemberCardRepository memberCardRepository)
{
_memberCardRepository = memberCardRepository;
}
private void ExecuteSearchText()
{
_unitOfWork = UnityInit.UnitOfWork;
_memberCardRepository = _unitOfWork.GetRepository <MemberCardRepository>();
_userRepository = _unitOfWork.GetRepository <UserRepository>();
_memberCardLogRepository = _unitOfWork.GetRepository <MemberCardLogRepository>();
DateTime?startDate = DateStartDate.SelectedDate;
DateTime?endDate = DateEndDate.SelectedDate;
if (startDate.HasValue && endDate.HasValue)
{
endDate = endDate.Value.AddDays(1);
}
else if (startDate.HasValue)
{
endDate = DateTime.MaxValue;
}
else if (endDate.HasValue)
{
endDate = endDate.Value.AddDays(1);
startDate = DateTime.MinValue;
}
_memberCardDetails.Clear();
var memberCardDetails =
from user in _userRepository
.Query()
.Where(x => x.Name.Contains(TxtSearchBox.Text) ||
x.Phone.Contains(TxtSearchBox.Text))
join memberCard in _memberCardRepository
.Query()
.Where(x => x.MemberCardNo.Contains(TxtSearchBox.Text))
on user.UserId equals memberCard.RelateUserId
join memberCardLog in _memberCardLogRepository
.Query()
.Where(x => x.DateChanged >= startDate &&
x.DateChanged < endDate)
on memberCard.MemberCardId equals memberCardLog.MemberCardId
select new MemberCardDetailModel
{
MemberCardId = memberCard.MemberCardId,
DateChanged = memberCardLog.DateChanged,
ChangedBy = memberCardLog.ChangedBy,
MemberCardNo = memberCard.MemberCardNo,
RelateUser = user.Name,
PrincipalMoney = memberCardLog.PrincipalMoney,
FavorableMoney = memberCardLog.FavorableMoney,
TotalMoney = memberCardLog.PrincipalMoney + memberCardLog.FavorableMoney,
Description = memberCardLog.NewValue,
LogType = memberCardLog.LogType,
};
if (ComboTransactionType.SelectedValue != null)
{
sbyte transactionType = (sbyte)ComboTransactionType.SelectedValue;
memberCardDetails = memberCardDetails.Where(x => x.LogType == transactionType);
}
if (ComboHowBalance.SelectedValue != null)
{
memberCardDetails = memberCardDetails.Where(x => x.Description.Contains(ComboHowBalance.Text));
}
memberCardDetails
.OrderByDescending(x => x.DateChanged)
.ToList()
.ForEach(x => _memberCardDetails.Add(x));
TxtTotalInfo.Text = string.Format("共计 {0} 条记录, 交易本金: {1}, 交易赠送金额: {2}，交易总金额: {3}",
memberCardDetails.Count(),
(memberCardDetails.Sum(x => (float?)x.PrincipalMoney) ?? 0).ToString("F2"),
(memberCardDetails.Sum(x => (float?)x.FavorableMoney) ?? 0).ToString("F2"),
(memberCardDetails.Sum(x => (float?)x.FavorableMoney + (float?)x.PrincipalMoney) ?? 0).ToString("F2"));
}
