Exemplo n.º 1
0
        private void DataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            if (dataGridView1.Columns[e.ColumnIndex].Name == "colBtn_drop")
            {
                Lend model = new Lend();
                model.id = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells["id"].Value);
                if (LendHelper.Drop(model, new List <string>()
                {
                    "id"
                }))
                {
                    ShowDataGird(); MessageBox.Show("删除成功", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
            }

            if (dataGridView1.Columns[e.ColumnIndex].Name == "colBtn_alter")
            {
                Lend model = new Lend();
                model.id       = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells["Id"].Value);
                model.name     = dataGridView1.Rows[e.RowIndex].Cells["name"].Value.ToString();
                model.bookname = dataGridView1.Rows[e.RowIndex].Cells["bookname"].Value.ToString();
                model.date     = dataGridView1.Rows[e.RowIndex].Cells["date"].Value.ToString();
                if (LendHelper.AlterByPK(model, "id"))
                {
                    ShowDataGird(); MessageBox.Show("修改成功", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
            }
        }
Exemplo n.º 2
0
        /// <summary>
        /// 显示数据网格控件
        /// </summary>
        public void ShowDataGird()
        {
            this.dataGridView1.DataSource = null;
            this.dataGridView1.Columns.Clear();

            List <Lend> list = LendHelper.FindList(new Lend(), new List <string>());

            dataGridView1.DataSource = list;

            dataGridView1.Columns["name"].HeaderText     = "借阅人";
            dataGridView1.Columns["bookname"].HeaderText = "图书名";
            dataGridView1.Columns["date"].HeaderText     = "借阅日期";

            dataGridView1.Columns["id"].Visible = false;

            DataGridViewButtonColumn col_Btn_alter = new DataGridViewButtonColumn();

            col_Btn_alter.Name       = "colBtn_alter";
            col_Btn_alter.HeaderText = "";
            col_Btn_alter.DefaultCellStyle.NullValue = "修改";
            dataGridView1.Columns.Add(col_Btn_alter);

            DataGridViewButtonColumn col_Btn_Drop = new DataGridViewButtonColumn();

            col_Btn_Drop.Name       = "colBtn_drop";
            col_Btn_Drop.HeaderText = "";
            col_Btn_Drop.DefaultCellStyle.NullValue = "删除";
            dataGridView1.Columns.Add(col_Btn_Drop);
        }
Exemplo n.º 3
0
        private void Button1_Click(object sender, EventArgs e)
        {
            if (textBox1.Text == "" || textBox2.Text == "" || textBox3.Text == "")
            {
                MessageBox.Show("请填写完整的新增信息", "", MessageBoxButtons.OK, MessageBoxIcon.Warning); return;
            }
            Lend model = new Lend();

            model.name     = textBox1.Text;
            model.bookname = textBox2.Text;
            model.date     = textBox2.Text;
            if (LendHelper.Add(model))
            {
                ShowDataGird(); MessageBox.Show("添加成功", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }