Beispiel #1
0
        private void btn_Save_Click(object sender, EventArgs e)
        {
            try
            {
                int           money = 0;
                List <Detial> dlist = new List <Detial>();

                for (int i = 0; i < grid_detail.Rows.Count - 1; i++)
                {
                    DataGridViewRow row = grid_detail.Rows[i];

                    if (row.Cells["Money"].Value is DBNull)
                    {
                        row.Cells["Money"].Value = 0;
                    }

                    money += Convert.ToInt32(row.Cells["Money"].Value);

                    dlist.Add(new Detial
                    {
                        Id     = Convert.ToInt32(row.Cells["Id"].Value is DBNull ? 0 : row.Cells["Id"].Value),
                        Number = Convert.ToInt32(row.Cells["Number"].Value),
                        Name   = row.Cells["detialName"].Value.ToString(),
                        Money  = Convert.ToDecimal(row.Cells["Money"].Value)
                    });
                }

                Account acc = new Account
                {
                    Remark   = txt_Remark.Text,
                    Type     = Convert.ToInt32(cbo_Type.SelectedValue),
                    DateTime = date_datetime.Value,
                    IsOut    = com_Isout.Text == "支出" ? "是" : "否",
                    Money    = Convert.ToInt32(txt_Money.Text),
                    Id       = this.Tag == null ? 0 : Convert.ToInt32(this.Tag)
                };

                AccountDAL adal = new AccountDAL();
                DetailDAL  ddal = new DetailDAL();

                if (acc.Id > 0)
                {
                    adal.UpdateAccount(acc);
                }
                else
                {
                    int aid = adal.AddAccount(acc);
                    acc.Id = aid;
                }

                ddal.AddRangeDetail(dlist, acc.Id);

                Tool.promptMessage("保存成功!");
                this.Close();
            }
            catch (Exception ex) {
                Tool.errorMessage(ex.Message);
            }
        }
Beispiel #2
0
        private void tool_del_Click(object sender, EventArgs e)
        {
            DataGridViewCell cell = grid_detail.SelectedRows[0].Cells["Id"];

            if (cell.Value != DBNull.Value)
            {
                DetailDAL ddal = new DetailDAL();
                ddal.DeleteDetail(cell.Value.ToString());
            }

            grid_detail.Rows.Remove(grid_detail.SelectedRows[0]);

            Tool.promptMessage("删除成功!");
        }
Beispiel #3
0
        private void frmDetail_Load(object sender, EventArgs e)
        {
            AccountDAL adal = new AccountDAL();
            DetailDAL  ddal = new DetailDAL();

            Account acc = adal.GetAccountById(Convert.ToInt32(this.Tag));

            txt_Money.Text  = acc.Money.ToString();
            txt_Remark.Text = acc.Remark;

            if (acc.IsOut == "否")
            {
                cbo_IsOut.Text = "收入";
            }

            grid_detail.DataSource = ddal.GetDetialList(acc.Id);
        }
Beispiel #4
0
        private void frmAddAccount_Load(object sender, EventArgs e)
        {
            TypesDAL tdal = new TypesDAL();

            cbo_Type.ValueMember   = "Id";
            cbo_Type.DisplayMember = "Name";
            cbo_Type.DataSource    = tdal.GetAllType();

            if (this.Tag != null)
            {
                AccountDAL adal = new AccountDAL();
                Account    acc  = adal.GetAccountById(Convert.ToInt32(this.Tag));

                cbo_Type.SelectedValue = acc.Type;
                txt_Money.Text         = acc.Money.ToString();
                com_Isout.Text         = acc.IsOut == "是" ? "支出" : "收入";
                date_datetime.Value    = acc.DateTime;

                DetailDAL ddal = new DetailDAL();
                grid_detail.DataSource = ddal.GetDetialList(acc.Id);
            }
        }