private void BtnMsDelete_Click(object sender, EventArgs e)
{
if (DgvMembership.SelectedRows.Count == 1)
{
int index = DgvMembership.SelectedRows[0].Index;
Ms = mses[index];
if (EValid.效 == Ms.IsValid)
{
StringBuilder sb = new StringBuilder();
sb.Append("确定删除当前会员？\n");
sb.Append("会员编号" + Ms.MsID.ToString() + "\n");
sb.Append("会员姓名" + Ms.MsName + "\n");
sb.Append("联系方式" + Ms.MsPhone + "\n");
sb.Append("会员积分" + Ms.MsPoint);
if (DialogResult.OK == MsgBoxUtil.QuestionMsgBox(sb.ToString()))
{
MembershipDao.DeleteByMsID(Ms.MsID);
mses[index].IsValid = EValid.已删除;
DgvMembership.Rows[index].Cells["ClnMsIsValid"].Value = EValid.已删除;
Ms = null;
}
}
}
else
{
MsgBoxUtil.ErrMsgBox("请选择要删除的会员！");
}
}
/// <summary>
/// 通过登录名或邮箱获取登录信息
/// </summary>
/// <param name="mailName"></param>
/// <param name="vt">条件类别</param>
/// <returns></returns>
public List<Membership> GetMemberByMailName(string checkName, ValidType vt)
{
MembershipDao md = new MembershipDao();
Membership ms = new Membership();
if (string.IsNullOrEmpty(checkName))
return null;
switch (vt)
{
case ValidType.All:
ms.Where = string.Format("LoweredLoginName = {0} OR LoweredEmail= {0}", checkName.ToLower());
break;
case ValidType.Mail:
ms.Where = string.Format("LoweredEmail= {0}", checkName.ToLower());
break;
case ValidType.LoginName:
ms.Where = string.Format("LoweredLoginName = {0}", checkName.ToLower());
break;
default:
ms.Where = string.Format("LoweredLoginName = {0} OR LoweredEmail= {0}", checkName.ToLower());
break;
}
return md.Select(ms);
}
private void cardSearchButton_Click(object sender, EventArgs e)
{
try
{
membershipDiscountReportDataGridView.DataSource = null;
DataTable reportDataTable = new DataTable();
MembershipDao aMembershipDao = new MembershipDao();
reportDataTable = aMembershipDao.GetMembershipDiscountReport();
string cardNumber = txtCode.Text;
if (reportDataTable != null)
{
DataTable selectedTable = reportDataTable.AsEnumerable()
.Where(r => r.Field<string>("CardNumber") == cardNumber)
.CopyToDataTable();
membershipDiscountReportDataGridView.DataSource = selectedTable;
}
}
catch (Exception)
{
}
}
/// <summary>
/// 获取所有登录用户信息
/// </summary>
/// <param name="where">查询条件</param>
/// <returns></returns>
public List<Membership> GetAllMembers(string where)
{
MembershipDao md = new MembershipDao();
Membership ms = new Membership();
return md.Select(ms);
}
private void BtnSubmit_Click(object sender, EventArgs e)
{
foreach (EtMembership ms in mses)
{
MembershipDao.UpdateOrInsert(ms);
}
hasUpdated = false;
}
/// <summary>
/// 创建登录用户（注册）
/// </summary>
/// <param name="ms"></param>
/// <returns></returns>
public bool CreateMember(Membership ms)
{
MembershipDao md = new MembershipDao();
if (md.Insert(ms) > 0)
return true;
return false;
}
private void LoadMembershipDiscount()
{
try
{
DataTable reportDataTable = new DataTable();
MembershipDao aMembershipDao = new MembershipDao();
reportDataTable = aMembershipDao.GetMembershipDiscountReport();
membershipDiscountReportDataGridView.DataSource = reportDataTable;
}
catch (Exception)
{
}
}
private void BtnCancel_Click(object sender, EventArgs e)
{
DgvMembership.Rows.Clear();
mses = MembershipDao.QueryAll();
foreach (EtMembership ms in mses)
{
DgvMembership.Rows.Add(new object[] {
ms.MsID,
ms.MsName,
ms.MsPhone,
ms.MsPoint,
ms.IsValid
});
}
hasUpdated = false;
}
public FrmMemberShip(bool isCanSave = true, Guid?id = null)
{
InitializeComponent();
if (id != null)
{
membershipID = (Guid)id;
MemberShipEntity memberShipEntity = new MemberShipEntity();
memberShipEntity = MembershipDao.GetByID(id);
this.Text = this.Text + membershipID;
txtMemberShipType.Text = memberShipEntity.MembershipType;
txtDiscountValue.Text = memberShipEntity.DiscountValue.ToString();
txtDiscountText.Text = memberShipEntity.DiscountText;
txtOther.Text = memberShipEntity.Other;
}
btnSaveClose.Enabled = btnSaveNew.Enabled = isCanSave;
}
public FrmMembership()
{
InitializeComponent();
Ms = null;
hasUpdated = false;
mses = MembershipDao.QueryAll();
foreach (EtMembership ms in mses)
{
DgvMembership.Rows.Add(new object[] {
ms.MsID,
ms.MsName,
ms.MsPhone,
ms.MsPoint,
ms.IsValid
});
}
}
private void Save()
{
SaveCompleted = true;
errorProvider1.Clear();
MemberShipEntity memberShipEntity = new MemberShipEntity();
memberShipEntity.MembershipType = txtMemberShipType.Text;
memberShipEntity.DiscountValue = int.Parse(txtDiscountValue.Text);
memberShipEntity.DiscountText = txtDiscountText.Text;
memberShipEntity.Other = txtOther.Text;
if (membershipID != Guid.Empty)
{
memberShipEntity.ID = membershipID;
memberShipEntity.Update(USER.UserName);
MembershipDao.Update(memberShipEntity);
}
else
{
memberShipEntity.ID = Guid.NewGuid();
memberShipEntity.Create(USER.UserName);
MembershipDao.Insert(memberShipEntity);
}
}
private void LoadData()
{
gridList.DataSource = MembershipDao.FilterList();
}
/// <summary>
/// 更新登录信息
/// </summary>
/// <param name="ms"></param>
/// <returns></returns>
public bool UpdatePassword(Membership ms)
{
MembershipDao md = new MembershipDao();
return md.Update(ms) > 0;
}
private void SearchMembership(int searchType)
{
if (searchType == 1)
{
if (txtMembershipCardName.Text == "" || txtMembershipCardName.Text.Length < 1)
{
return;
}
}
else if (searchType == 2)
{
if (txtCode.Text == "" || txtCode.Text.Length < 1)
{
return;
}
}
else if (searchType == 3)
{
if (txtCustomerName.Text == "" || txtCustomerName.Text.Length < 1)
{
return;
}
}
else if (searchType == 4)
{
if (txtPhoneNumber.Text == "" || txtPhoneNumber.Text.Length < 1)
{
return;
}
}
IMembershipDao membershipDao = new MembershipDao();
try
{
List<Membership> membershipList = new List<Membership>();
Membership membership = new Membership();
if (searchType == 1)
{
membershipList = membershipDao.GetMembershipByMembershipCardName(txtMembershipCardName.Text);
}
else if (searchType == 2)
{
membership = membershipDao.GetMembershipByMembershipCardCode(txtCode.Text);
if (membership != null && membership.id>0)
membershipList.Add(membership);
}
else if (searchType == 2)
{
membership = membershipDao.GetMembershipByCustomerPhone(txtPhoneNumber.Text);
if (membership != null && membership.id > 0)
membershipList.Add(membership);
}
if (membershipList.Count == 1)
{
FillMembership(membershipList[0]);
}
else if (membershipList.Count > 1)
{
CMemberShipForm objMemberShipForm = new CMemberShipForm();
objMemberShipForm.btnSelect.Visible = true;
objMemberShipForm.btnSelect.Location = new Point(654, 452);
objMemberShipForm.MembershipListData = membershipList;
objMemberShipForm.ISDialogBox = true;
objMemberShipForm.AddButton.Visible = false;
objMemberShipForm.UpdateButton.Visible = false;
objMemberShipForm.DeleteButton.Visible = false;
// CFormManager.Forms.Push(this);
// this.Hide();
objMemberShipForm.ShowDialog(this);
if (objMemberShipForm.DialogResult == DialogResult.OK)
{
FillMembership(objMemberShipForm.membershipData);
}
}
//CCustomerManager tempCustomerManager = new CCustomerManager();
//CCustomerInfo tempCustomerInfo = new CCustomerInfo();
//CResult oResult = tempCustomerManager.GetCustomerInfoByName(txtMembershipCardName.Text);
//tempCustomerInfo = (CCustomerInfo)oResult.Data;
//DataTable dtCustomerList = (DataTable)tempCustomerInfo.CustomerDataTable;
//if (dtCustomerList.Rows.Count > 1)
//{
// CustomerListForm objCustomerList = new CustomerListForm(dtCustomerList);
// objCustomerList.ShowDialog(this);
//}
//else if (dtCustomerList.Rows.Count == 1)
//{
// string phoneNumber = dtCustomerList.Rows[0]["phone"].ToString();
// txtcDescription.Text = phoneNumber;
// btnSearchByPhone_Click(sender, e);
//}
//else
//{
// MessageBox.Show("No customer has been found", RMSGlobal.MessageBoxTitle,
// MessageBoxButtons.OK, MessageBoxIcon.Information);
//}
}
catch (Exception exp)
{
Console.Write(exp.Message);
}
}
private void FinishButton_Click(object sender, EventArgs e)
{
IMembershipDao membershipDao = new MembershipDao();
try
{
if (CheckEmpty())
{
return;
}
if (isModify)
{
membership = txtTitle.Tag as Membership;
}
else
{
membership = new Membership();
membership.issueDate = System.DateTime.Now;
}
if (txtCustomerName.Tag != null)
{
membership.customerID = (txtCustomerName.Tag as CCustomerInfo).CustomerID;
}
if (!isModify)
{
if (txtCustomerName.Tag == null || membership.customerID == 0)
{
MessageBox.Show("Please select the customer");
return;
}
}
membership.customerName = txtCustomerName.Text;
membership.customerPhone = txtPhoneNumber.Text;
if (txtMembershipCardName.Tag != null)
{
membership.mebershipCardID = (txtMembershipCardName.Tag as MembershipCard).id;
}
membership.membershipCardName = txtMembershipCardName.Text;
membership.membershipCardType = cmbType.Text;
membership.startDate = dtpStartDate.Value;
membership.endDate = dtpEndDate.Value;
membership.membershipCardTitle = txtTitle.Text;
membership.membershipCardCode = txtCode.Text;
membership.point = float.Parse(txtPoint.Text.ToString());
membership.discountPercentRate = float.Parse(txtDiscountPercentRate.Text.ToString());
if (rdbActive.Checked)
{
membership.isActive = rdbActive.Checked;
}
else if (rdbInActive.Checked)
{
membership.isActive = false;
}
if (isModify)
{
membershipDao.UpdateMembership(membership);
MessageBox.Show("Membership " + membership.id + " updated successfully");
}
else
{
membershipDao.AddMembership(membership);
MessageBox.Show("Membership " + membership.id + " created successfully");
}
}
catch (Exception exp)
{
MessageBox.Show(exp.Message);
//Console.Write(exp.Message);
}
}
