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 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); } }
public static bool AddBankCards(BankCardClass bkInfo) { string connString = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=""E:\c++练习\MyMoneyAgent - 副本 (2) - 副本\MyMoneyAgent\MyMoney.mdf"";Integrated Security=True"; SqlConnection conn = new SqlConnection(connString); try { conn.Open(); //执行删除命令 string cmdTxt = string.Format("INSERT INTO [银行卡] VALUES('{0}','{1}','{2}',{3})", bkInfo.CardNo, bkInfo.Name, bkInfo.BankName, bkInfo.Balance); SqlCommand comm = new SqlCommand(cmdTxt, conn); comm.ExecuteNonQuery(); return(true); } catch (Exception) { return(false); } finally { //关闭连接 conn.Close(); } }
public static bool MdyBankCards(BankCardClass bkInfo) { string connString = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=""E:\c++练习\MyMoneyAgent - 副本 (2) - 副本\MyMoneyAgent\MyMoney.mdf"";Integrated Security=True"; SqlConnection conn = new SqlConnection(connString); try { conn.Open(); //执行删除命令 string cmdTxt = string.Format("UPDATE [银行卡] SET [余额]={0} WHERE [卡号]='{1}'", bkInfo.Balance, bkInfo.CardNo); SqlCommand comm = new SqlCommand(cmdTxt, conn); comm.ExecuteNonQuery(); return(true); } catch (Exception) { return(false); } finally { //关闭连接 conn.Close(); } }
private void treeBankCard_AfterSelect(object sender, TreeViewEventArgs e) { //获取选中银行卡 BankCardClass bkInfo = (BankCardClass)e.Node.Tag; //清除原有内容 this.dgvCardOps.Rows.Clear(); //显示银行卡记录 int newRowIndex = this.dgvCardOps.Rows.Add(); this.dgvCardOps["colBankNo", newRowIndex].Value = bkInfo.CardNo; this.dgvCardOps["colBankName", newRowIndex].Value = bkInfo.BankName; this.dgvCardOps["colBankBanlance", newRowIndex].Value = bkInfo.Balance.ToString("f2") + "¥"; }
private void btnMdyBanlance_Click(object sender, EventArgs e) { //判断是否有选中的银行卡 if (this.treeBankCard.SelectedNode == null) { MessageBox.Show(this, "请先选中要修改的银行卡!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } //获取被选中的银行卡 BankCardClass bkInfo = (BankCardClass)this.treeBankCard.SelectedNode.Tag; //创建修改对话框 ModifyBankCardForm dlg = new ModifyBankCardForm(bkInfo); //显示修改银行卡余额界面,成功则重新加载银行卡列表 if (dlg.ShowDialog(this) == DialogResult.OK) { this.LoadBankCardList(); } }
public static List <BankCardClass> LoadBankCardList(string name) { string connString = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=""E:\c++练习\MyMoneyAgent - 副本 (2) - 副本\MyMoneyAgent\MyMoney.mdf"";Integrated Security=True"; SqlConnection conn = new SqlConnection(connString);//创建链接对象 try { conn.Open(); List <BankCardClass> bkLst = new List <BankCardClass>(); string cmdTxt = "SELECT [卡号], [开户银行], [余额] FROM [银行卡] WHERE [姓名]='" + name + "'"; SqlCommand comm = new SqlCommand(cmdTxt, conn); SqlDataReader dr = comm.ExecuteReader(); while (dr.Read()) { string id = dr.GetString(0); string bk = dr.GetString(1); decimal balance = dr.GetDecimal(2); BankCardClass bkinfo = new BankCardClass(); bkinfo.Balance = balance; bkinfo.BankName = bk; bkinfo.CardNo = id; bkinfo.Name = name; bkLst.Add(bkinfo); } return(bkLst); } catch (Exception) { return(null); } finally { //关闭连接 conn.Close(); } }
public ModifyBankCardForm(BankCardClass bkInfo) { InitializeComponent(); this.bkInfo = bkInfo; }