示例#1
0
 private void dgvInRec_CellContentClick(object sender, DataGridViewCellEventArgs e)
 {
     //如果双击的记录,则显示详细信息
     if (e.RowIndex >= 0)
     {
         //获取要显示详细信息的记录
         IncomeRecord rec;
         rec = (IncomeRecord)this.dgvInRec.Rows[e.RowIndex].Tag;
         //创建只读的记录查看对话框
         IncomeReForm dlg;
         dlg = new IncomeReForm(this.curUser.Name, rec, true);
         //显示对话框
         dlg.ShowDialog(this);
     }
 }
示例#2
0
        private void btnAddNewIncomRec_Click(object sender, EventArgs e)
        {
            //创建用来保存新记录的对象
            int newId = IncomeSQL.GetUsableIncomID(this.curUser.Name);

            if (newId == 0)
            {
                MessageBox.Show(this, "无法获取可用的收入记录编号,请确保数据库连接正确!", "提示",
                                MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            IncomeRecord rec = new IncomeRecord();

            rec.ID         = newId;
            rec.IncomeTime = DateTime.Now;
            rec.RecordTime = DateTime.Now;
            //创建收入记录编辑对话框
            IncomeReForm dlg = new IncomeReForm(this.curUser.Name, rec, false);

            if (dlg.ShowDialog(this) == DialogResult.OK)
            {
                //添加记录成功,则添加到界面
                if (IncomeSQL.AddIncomRec(this.curUser.Name, rec))
                {
                    //添加一行到界面
                    int newRowIndex = this.dgvInRec.Rows.Add();
                    this.dgvInRec.Rows[newRowIndex].Tag = rec;
                    //显示信息到新添加的行
                    this.dgvInRec.Rows[newRowIndex].Cells["colInID"].Value      = rec.ID;
                    this.dgvInRec.Rows[newRowIndex].Cells["colInInTime"].Value  = rec.IncomeTime;
                    this.dgvInRec.Rows[newRowIndex].Cells["colInType"].Value    = rec.IncomeType;
                    this.dgvInRec.Rows[newRowIndex].Cells["colInUsage"].Value   = rec.IncomUsage;
                    this.dgvInRec.Rows[newRowIndex].Cells["colInRecTime"].Value = rec.RecordTime;
                    this.dgvInRec.Rows[newRowIndex].Cells["colInDes"].Value     = rec.Description;
                    this.dgvInRec.Rows[newRowIndex].Cells["colInBank"].Value    = rec.BankCard;
                    this.dgvInRec.Rows[newRowIndex].Cells["colInAmount"].Value  = rec.Amount;
                }
                else
                {
                    MessageBox.Show(this, "添加记录失败!", "提示",
                                    MessageBoxButtons.OK, MessageBoxIcon.Warning);
                }
            }
        }
示例#3
0
        private void btnModifyIncomRec_Click(object sender, EventArgs e)
        {
            //判断是否有选中的记录
            if (this.dgvInRec.SelectedRows.Count == 0)
            {
                MessageBox.Show(this, "没有选中任何记录!", "提示",
                                MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }
            //获取选中记录的数据
            IncomeRecord rec;

            rec = (IncomeRecord)this.dgvInRec.SelectedRows[0].Tag;
            //创建可修改对话框
            IncomeReForm dlg = new IncomeReForm(this.curUser.Name, rec, false);

            //显示对话框,进行编辑操作
            if (dlg.ShowDialog(this) == DialogResult.OK)
            {
                //修改记录成功,则更新指定记录
                if (IncomeSQL.ModifyIncomrec(this.curUser.Name, rec))
                {
                    this.dgvInRec.SelectedRows[0].Cells["colInID"].Value      = rec.ID;
                    this.dgvInRec.SelectedRows[0].Cells["colInInTime"].Value  = rec.IncomeTime;
                    this.dgvInRec.SelectedRows[0].Cells["colInType"].Value    = rec.IncomeType;
                    this.dgvInRec.SelectedRows[0].Cells["colInUsage"].Value   = rec.IncomUsage;
                    this.dgvInRec.SelectedRows[0].Cells["colInRecTime"].Value = rec.RecordTime;
                    this.dgvInRec.SelectedRows[0].Cells["colInDes"].Value     = rec.Description;
                    this.dgvInRec.SelectedRows[0].Cells["colInBank"].Value    = rec.BankCard;
                    this.dgvInRec.SelectedRows[0].Cells["colInAmount"].Value  = rec.Amount;
                }
                else
                {
                    MessageBox.Show(this, "修改记录失败!", "提示",
                                    MessageBoxButtons.OK, MessageBoxIcon.Warning);
                }
            }
        }