/// <summary>
/// 编辑
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public async Task <ActionResult> Edit(int id)
{
using (var db = new SqlLiteDb(HttpContext.Server.MapPath(@"~\App_Data\data.db")))
{
var model = await db.SqlLiteModel.FindAsync(id);
return(View("Create", model));
}
}
// GET: SqlLite
public async Task <ActionResult> Index()
{
using (var db = new SqlLiteDb(HttpContext.Server.MapPath(@"~\App_Data\data.db")))
{
var list = await db.SqlLiteModel.Where(item => true).ToArrayAsync();
return(View(list));
}
}
public async Task <JsonResult> Create(SqlLiteModel model)
{
model.F_Guid = Guid.NewGuid().ToString();
using (var db = new SqlLiteDb(HttpContext.Server.MapPath(@"~\App_Data\data.db")))
{
db.SqlLiteModel.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 SqlLiteDb(HttpContext.Server.MapPath(@"~\App_Data\data.db")))
{
var model = await db.SqlLiteModel.FindAsync(id);
db.SqlLiteModel.Remove(model);
await db.SaveChangesAsync();
return(Json(new { state = true, value = "删除成功" }));
}
}
public async Task <JsonResult> Edit(SqlLiteModel model)
{
if (!this.TryValidateModel(model))
{
return(Json(new { state = false, value = this.ModelState.FirstModelErrorMessage() }));
}
using (var db = new SqlLiteDb(HttpContext.Server.MapPath(@"~\App_Data\data.db")))
{
db.Entry(model).State = EntityState.Modified;
await db.SaveChangesAsync();
return(Json(new { state = true, value = "编辑成功" }));
}
}
public SaveGame(string savePath)
{
_savePath = savePath;
Pddb = new Pddb(savePath);
SqlLiteDb = new SqlLiteDb(savePath);
}