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();
}
private void TxtMemberCardNo_OnKeyDown(object sender, KeyEventArgs e)
{
if (e.Key == Key.Enter)
{
List <DataModel.Model.MemberCard> memberCards =
_memberCardRepository
.Query()
.Where(x => x.MemberCardNo == txtMemberCardNo.Text ||
x.MemberCardNo == (ResourcesHelper.MFTMemberCard + txtMemberCardNo.Text))
.ToList();
if (memberCards.Count != 1)
{
MessageBox.Show("购物卡编号不正确, 请重新输入！", Properties.Resources.SystemName,
MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
else
{
if (memberCards[0].RelateUserId.HasValue)
{
MessageBox.Show("购物卡已经关联其他用户, 请重新输入！", Properties.Resources.SystemName,
MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
else
{
_memberCard = memberCards[0];
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);
SetMemberCardInfo();
}
private void TxtPassword_OnKeyDown(object sender, KeyEventArgs e)
{
if (e.Key == Key.Enter)
{
var memberCard = _memberCardRepository.Query()
.FirstOrDefault(x => x.MemberCardId == _memberCardId);
if (memberCard != null &&
SaltedHash.Create(memberCard.PasswordSalt, memberCard.PasswordHash).Verify(txtPassword.Password))
{
IsCheckOK = true;
Close();
}
else
{
MessageBox.Show("密码不正确!", Properties.Resources.SystemName, MessageBoxButton.OK, MessageBoxImage.Error);
txtPassword.Clear();
}
}
}
private void TxtUserNoOrPhone_OnTextChanged(object sender, TextChangedEventArgs e)
{
var barCode = (TextBox)sender;
if (barCode.IsFocused && !string.IsNullOrEmpty(barCode.Text) && barCode.Text.Length >= 3)
{
var users = _userRepository.Query()
.Where(x => x.Phone.StartsWith(barCode.Text) ||
x.UserNo.StartsWith(barCode.Text));
if (!users.Any())
{
var memberCards = _memberCardRepository.Query()
.Where(x => x.MemberCardNo.StartsWith(ResourcesHelper.MFTMemberCard + barCode.Text));
if (memberCards.Count() == 1)
{
_memberCard = memberCards.First();
if (_memberCard.RelateUserId.HasValue)
{
_user = _memberCard.RelateUserUser;
}
SetUserInfo();
}
}
else if (users.Count() == 1)
{
_user = users.First();
if (_user.MemberCardsRelateUser.Any(x => x.IsEnable &&
x.MemberCardStatus == (sbyte)DataType.MemberCardStatus.Active))
{
_memberCard = _user.MemberCardsRelateUser.First(x => x.IsEnable &&
x.MemberCardStatus == (sbyte)DataType.MemberCardStatus.Active);
}
SetUserInfo();
}
_saleOrder.PurchaseOrderUserId = _user.UserId > 0 ? _user.UserId : (int?)null;
}
}
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;
};
}
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"));
}