示例#1
0
        public async Task <JsonResult> Create(TDemoTable model)
        {
            model.F_Guid = Guid.NewGuid().ToString();
            using (var db = new MysqlDb())
            {
                db.TDemoTable.Add(model);
                await db.SaveChangesAsync();

                return(Json(new { state = true, value = "操作成功" }));
            }
        }
示例#2
0
        /// <summary>
        /// 删除
        /// </summary>
        /// <returns></returns>
        public async Task <JsonResult> Remove(int id)
        {
            using (var db = new MysqlDb())
            {
                await db.TDemoTable.RemoveById(id);

                await db.SaveChangesAsync();

                return(Json(new { state = true, value = "删除成功" }));
            }
        }
示例#3
0
        /// <summary>
        /// 保存数据库
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        private async Task Add(TDemoTable model)
        {
            using (var db = new MysqlDb())
            {
                db.TDemoTable.Add(model);
                await db.SaveChangesAsync();

                MessageBox.Show(JsonSerializer.Serialize(model));
                await InitializeData();
            }
        }
示例#4
0
        public async Task <JsonResult> Edit(TDemoTable model)
        {
            if (!this.TryValidateModel(model))
            {
                return(Json(new { state = false, value = this.ModelState.FirstModelErrorMessage() }));
            }

            using (var db = new MysqlDb())
            {
                db.Entry(model).State = EntityState.Modified;
                await db.SaveChangesAsync();

                return(Json(new { state = true, value = "编辑成功" }));
            }
        }
示例#5
0
        /// <summary>
        /// 菜单删除
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private async void DeleteToolStripMenuItem_Click(object sender, EventArgs e)
        {
            int a    = dataGridView1.CurrentRow.Index;
            var f_id = dataGridView1.Rows[a].Cells["Id"].Value;
            var id   = int.Parse(f_id.ToString());

            using (var db = new MysqlDb())
            {
                await db.TDemoTable.RemoveById(id);

                await db.SaveChangesAsync();
            }
            MessageBox.Show("删除id:" + id + "成功.");
            await InitializeData();
        }