/// <summary>
/// 编辑
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public async Task <ActionResult> Edit(int id)
{
using (var db = new PSqlDb())
{
var model = await db.NpgSqlTable.FindAsync(id);
return(View("Create", model));
}
}
// GET: PostgreSql
public async Task <ActionResult> Index()
{
using (var db = new PSqlDb())
{
var data = await db.NpgSqlTable.Where(item => true).ToListAsync();
return(View(data));
}
}
public async Task <JsonResult> Create(NpgSqlTable model)
{
model.F_Guid = Guid.NewGuid().ToString();
using (var db = new PSqlDb())
{
db.NpgSqlTable.Add(model);
await db.SaveChangesAsync();
return(Json(new { state = true, value = "操作成功" }));
}
}
/// <summary>
/// 删除
/// </summary>
/// <returns></returns>
public async Task <JsonResult> Remove(int id)
{
using (var db = new PSqlDb())
{
var model = await db.NpgSqlTable.FindAsync(id);
db.NpgSqlTable.Remove(model);
await db.SaveChangesAsync();
return(Json(new { state = true, value = "删除成功" }));
}
}
public async Task <JsonResult> Edit(NpgSqlTable model)
{
if (!this.TryValidateModel(model))
{
return(Json(new { state = false, value = this.ModelState.FirstModelErrorMessage() }));
}
using (var db = new PSqlDb())
{
db.Entry(model).State = EntityState.Modified;
await db.SaveChangesAsync();
return(Json(new { state = true, value = "编辑成功" }));
}
}
