private void btnAdd_Click(object sender, EventArgs e) { //判断卡号是否合法 if (string.IsNullOrEmpty(this.mtbCardNo.Text.Trim())) { MessageBox.Show("请输入合法的银行卡号!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); //让卡号输入框获得焦点 this.mtbCardNo.Focus(); return; } //构建要保存的银行卡对象 BankCardClass bkInfo = new BankCardClass(); bkInfo.Balance = (decimal)this.nudBalance.Value; bkInfo.BankName = this.cmbBank.Text; bkInfo.CardNo = this.mtbCardNo.Text.Trim(); bkInfo.Name = this.name; //保存新银行卡到数据库,根据结果提示 if (BankCardSQL.AddBankCards(bkInfo)) { MessageBox.Show("添加银行卡:" + bkInfo.CardNo + ",成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); this.DialogResult = DialogResult.OK; } else { MessageBox.Show("添加银行卡:" + bkInfo.CardNo + ",失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void btnDelUse_Click(object sender, EventArgs e) { //如果没有选中任何用途,则不删除,直接退出 if (this.lstUsage.SelectedItem == null) { return; } //获取选中的用途 UsageItem item = (UsageItem)this.lstUsage.SelectedItem; //通过BankCardAccessor删除用途 if (BankCardSQL.DeleteUsage(item.Usage)) { this.btnLoadUse_Click(null, null); //删除成功提示成功 MessageBox.Show(this, "删除用途:" + item.Usage + ",成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { //删除失败,提示失败 MessageBox.Show(this, "删除用途:" + item.Usage + ",失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnDelCard_Click(object sender, EventArgs e) { //判断是否有选中的银行卡 if (this.treeBankCard.SelectedNode == null) { MessageBox.Show(this, "请选中要删除的银行卡!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } //获取选中的银行卡 BankCardClass bk = (BankCardClass)this.treeBankCard.SelectedNode.Tag; //删除前确认 if (MessageBox.Show(this, "你真的要删除银行卡:" + bk.CardNo + "?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) { return; } if (BankCardSQL.DeleteBankCard(bk.CardNo)) { MessageBox.Show(this, "删除银行卡:" + bk.CardNo + ",成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); this.LoadBankCardList(); } else { MessageBox.Show(this, "删除银行卡:" + bk.CardNo + ",失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void btnDelType_Click(object sender, EventArgs e) { //如果没有选中任何方式,则不删除,直接退出 if (this.lstUseType.SelectedItem == null) { return; } //获取选中的支付方式 PayTypeItem item = (PayTypeItem)this.lstUseType.SelectedItem; //通过BankCardAccessor删除支付方式 if (BankCardSQL.DeletePayType(item.PayType)) { this.btnLoadType_Click(null, null); //删除成功提示成功 MessageBox.Show(this, "删除支付方式:" + item.PayType + ",成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { //删除失败,提示失败 MessageBox.Show(this, "删除支付方式:" + item.PayType + ",失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void LoadUsageList() { this.cmbUsage.Items.Add("无"); //从数据库加载 List <UsageItem> usageLst = BankCardSQL.LoadUseageList(); if (usageLst != null) { //加载成功,则逐个添加到下拉列表 foreach (UsageItem item in usageLst) { this.cmbUsage.Items.Add(item); } } }
private void LoadTypeList() { this.cmbType.Items.Add("无"); //从数据库加载 List <PayTypeItem> tyLst = BankCardSQL.LoadPayTypeList(); if (tyLst != null) { //加载成功,则逐个添加到下拉列表 foreach (PayTypeItem item in tyLst) { this.cmbType.Items.Add(item); } } }
private void LoadBankCard() { this.cmbBankCard.Items.Add("无"); //从数据库加载 List <BankCardClass> bankLst = BankCardSQL.LoadBankCardList(this.name); if (bankLst != null) { //加载成功,则逐个添加到下拉列表 foreach (BankCardClass bank in bankLst) { this.cmbBankCard.Items.Add(bank); } } }
private void btnAdd_Click(object sender, EventArgs e) { //构建要保存的银行卡对象 this.bkInfo.Balance = (decimal)this.nudBalance.Value; //保存新银行卡到数据库,根据结果提示 if (BankCardSQL.MdyBankCards(this.bkInfo)) { MessageBox.Show("修改银行卡:" + this.bkInfo.CardNo + ",成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); this.DialogResult = DialogResult.OK; } else { MessageBox.Show("修改银行卡:" + this.bkInfo.CardNo + ",失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void btnLoadUse_Click(object sender, EventArgs e) { //先清空界面 this.lstUsage.Items.Clear(); //从数据库加载现有用途列表 List <UsageItem> usageLst = BankCardSQL.LoadUseageList(); if (usageLst != null) { //加载成功,则显示到界面 foreach (UsageItem item in usageLst) { this.lstUsage.Items.Add(item); } } else { //加载失败,提示 MessageBox.Show(this, "加载用途列表失败,确保数据库可链接!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void btnAddUse_Click(object sender, EventArgs e) { //检查用途名称的合法性 if (string.IsNullOrEmpty(this.tbUsage.Text)) { MessageBox.Show(this, "请输入正确的用途名称,不能已经存在,也不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } //检查用途说明的合法性 if (string.IsNullOrEmpty(this.tbUsageDes.Text)) { MessageBox.Show(this, "请输入正确的用途说明,不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } //创建用途对象 UsageItem item = new UsageItem(); //获取新用途数据 item.Usage = this.tbUsage.Text.Trim(); item.Description = this.tbUsageDes.Text.Trim(); //添加到数据库 if (BankCardSQL.AddUsage(item)) { //重新加载用途列表 this.btnLoadUse_Click(null, null); //删除成功提示成功 MessageBox.Show(this, "添加用途:" + item.Usage + ",成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { //删除成功提示成功 MessageBox.Show(this, "添加用途:" + item.Usage + ",失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void btnAddType_Click(object sender, EventArgs e) { //检查方式名称的合法性 if (string.IsNullOrEmpty(this.tbUseType.Text)) { MessageBox.Show(this, "请输入正确的方式名称,不能已经存在,也不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } //检查方式说明的合法性 if (string.IsNullOrEmpty(this.tbUseTypeDes.Text)) { MessageBox.Show(this, "请输入正确的方式说明,不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } //创建方式对象 PayTypeItem item = new PayTypeItem(); //获取新方式数据 item.PayType = this.tbUseType.Text.Trim(); item.Description = this.tbUseTypeDes.Text.Trim(); //添加到数据库 if (BankCardSQL.AddPayType(item)) { //重新加载方式列表 this.btnLoadType_Click(null, null); //删除成功提示成功 MessageBox.Show(this, "添加支付方式:" + item.PayType + ",成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { //删除成功提示成功 MessageBox.Show(this, "添加支付方式:" + item.PayType + ",失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void LoadBankCardList() { //加载当前用户的银行卡列表 List <BankCardClass> cdLst = BankCardSQL.LoadBankCardList(this.curUser.Name); //清空原有银行卡列表 this.treeBankCard.Nodes.Clear(); if ((cdLst == null) || (cdLst.Count <= 0)) { MessageBox.Show(this, "你还没有银行卡信息,请先添加银行卡!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } //依次添加列表中所有的银行卡到界面 foreach (BankCardClass bk in cdLst) { //生成子节点,并显示到界面 TreeNode node = new TreeNode(); node.Text = bk.CardNo; node.Tag = bk; treeBankCard.Nodes.Add(node); } }