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); } }