private void SetValueForMemberTypeData(MemberTypeData member)
{
if (member.KeyType != null)
{
// dictionary;
var value = new Dictionary <object, object>();
for (int i = 0; i < GeneratedArrayLength; i++)
{
value.Add(GenerateValue(member.KeyType.MemberType), GenerateValue(member.ItemType.MemberType));
}
member.Value = value;
}
else if (member.Value != null)
{
var value = new List <object>();
for (int i = 0; i < GeneratedArrayLength; i++)
{
value.Add(GenerateValue(member.ItemType.MemberType));
}
member.Value = value;
}
else if (member.Children.Any())
{
member.Children.ForEach(child => SetValueForMemberTypeData(child));
}
else
{
member.Value = GenerateValue(member.MemberType);
}
}
/**
* 查询数据库中所有的会员类型
* */
public static List <MemberTypeData> GetMemberTypeDatas()
{
String connectStr = ConnectorInfo.connectStr;
MySqlConnection conn = new MySqlConnection(connectStr);
conn.Open();
List <MemberTypeData> memberTypeDatas = new List <MemberTypeData>();
String sql = "select * from membertypeinfo";
MySqlCommand mySqlCommand = new MySqlCommand(sql, conn);
MySqlDataReader mySqlDataReader = mySqlCommand.ExecuteReader();
while (mySqlDataReader.Read())
{
//int mtId, string mTitle, double mDiscount
MemberTypeData memberTypeData = new MemberTypeData(
mySqlDataReader.GetInt32("MtId"),
mySqlDataReader.GetString("MTitle"),
mySqlDataReader.GetDouble("MDiscount")
);
memberTypeDatas.Add(memberTypeData);
}
return(memberTypeDatas);
}
/**
* 对VIP账号信息进行模糊查询
* */
private void LoadVIP()
{
if (MemberPhone.Text == "" && MemberName.Text == "")
{
return;
}
String MbPhone = MemberPhone.Text;
String MbName = MemberName.Text;
List <MemberInfoData> memberInfoDatas = MemberInfoConnector.GetMembers(MbPhone, MbName);
if (memberInfoDatas.Count > 1)
{
return;
}
else if (memberInfoDatas.Count == 0)
{
return;
}
else
{
MemberInfo = memberInfoDatas[0];
MemberMoney.Content = "￥" + MemberInfo.MbMoney; //加载账户余额
MemberType = MemberInfoConnector.GetMemberType(MemberInfo.MbId); //获得账户会员类型
MemberTypeLabel.Content = MemberType.MTitle;
MemberDiscountLabel.Content = MemberType.MDiscount; //折扣
shouldPayLabel.Content = summaryMoney * MemberType.MDiscount;
shouldPay = summaryMoney * MemberType.MDiscount;
leftMoney = MemberInfo.MbMoney;
}
}
/**
* 加载所有会员的方法
* */
private void LoadAllMember()
{
if(memberInfoDatas != null)
for (int i = 0; i < memberInfoDatas.Count; i++)
MemberList.Items.RemoveAt(0);
memberInfoDatas = MemberInfoConnector.GetMembers();
foreach (MemberInfoData infoData in memberInfoDatas)
{
/*
* 没有给它写专门的控件，把买单的拿来用了
* 对应关系：
* DName --会员类型
* DPrice --姓名
* DNumber --余额
* DSum --手机号
* */
MemberTypeData memberTypeData = MemberInfoConnector.GetMemberType(infoData.MtId);
ListBoxItem listBoxItem = new ListBoxItem();
PayInfo info = new PayInfo();
info.DName.Text = memberTypeData.MTitle;
info.DPrice.Text = infoData.MbName;
info.DNumber.Text = infoData.MbMoney.ToString();
info.DSum.Text = infoData.MbPhone;
listBoxItem.Content = info;
MemberList.Items.Add(listBoxItem);
}
}
private void CheckBox_Checked(object sender, RoutedEventArgs e)
{
if (IsVIP.IsChecked == true)
{
VIPGroup.IsEnabled = true;
}
else
{
VIPGroup.IsEnabled = false;
shouldPayLabel.Content = summaryMoney;
shouldPay = summaryMoney;
MemberInfo = null;
MemberType = null;
}
}
/**
* 删除会员类型
* */
public static int DeleteMemberType(String MTitle)
{
if (GetMemberType(MTitle) == null)
{
return(-1);
}
String connectStr = ConnectorInfo.connectStr;
MySqlConnection conn = new MySqlConnection(connectStr);
conn.Open();
MemberTypeData memberTypeData = GetMemberType(MTitle);
String sql = "update memberinfo set MtId=5 where MtId=" + memberTypeData.MtId;
MySqlCommand mySqlCommand = new MySqlCommand(sql, conn);
mySqlCommand.ExecuteNonQuery();
sql = "delete from membertypeinfo where MTitle='" + MTitle + "'";
mySqlCommand = new MySqlCommand(sql, conn);
return(mySqlCommand.ExecuteNonQuery());
}
/**
* 实现模糊查询，通过手机号和姓名
* */
private void LoadMember()
{
if(SearchName.Text == ""&&SearchPhone.Text == "")
return;
for (int i = 0; i < memberInfoDatas.Count; i++)
MemberList.Items.RemoveAt(0);
String MbPhone = SearchPhone.Text;
String MbName = SearchName.Text;
memberInfoDatas = MemberInfoConnector.GetMembers(MbPhone, MbName);
foreach (MemberInfoData infoData in memberInfoDatas)
{
ListBoxItem listBoxItem = new ListBoxItem();
PayInfo info = new PayInfo();
MemberTypeData memberTypeData = MemberInfoConnector.GetMemberType(infoData.MtId);
info.DName.Text = memberTypeData.MTitle;
info.DPrice.Text = infoData.MbName;
info.DNumber.Text = infoData.MbMoney.ToString();
info.DSum.Text = infoData.MbPhone;
listBoxItem.Content = info;
MemberList.Items.Add(listBoxItem);
}
}
/**
* 通过MtId获取会员类型
* */
public static MemberTypeData GetMemberType(int MtId)
{
String connectStr = ConnectorInfo.connectStr;
MySqlConnection conn = new MySqlConnection(connectStr);
conn.Open();
String sql = "select * from membertypeinfo where MtId=" + MtId;
MySqlCommand mySqlCommand = new MySqlCommand(sql, conn);
MySqlDataReader mySqlDataReader = mySqlCommand.ExecuteReader();
MemberTypeData memberTypeData = null;
if (mySqlDataReader.Read())
{
//int mtId, string mTitle, double mDiscount
memberTypeData = new MemberTypeData(
mySqlDataReader.GetInt32("MtId"),
mySqlDataReader.GetString("MTitle"),
mySqlDataReader.GetDouble("MDiscount")
);
}
return(memberTypeData);
}
public InfomationTable(MemberTypeData memberTypeData)
{
InitializeComponent();
Left_TB.Text = memberTypeData.MTitle;
Right_TB.Text = memberTypeData.MDiscount.ToString();
}
