public static void Run()
{
DemoTable demo = new DemoTable
{
Name = "My demo table",
ListVector = new List <InnerTable>
{
new InnerTable {
Fruit = "Apple"
},
new InnerTable {
Fruit = "Banana"
},
new InnerTable {
Fruit = "Pear"
}
}
};
// In order of greediness
LazyDeserialization(demo);
ProgressiveDeserialization(demo);
GreedyDeserialization(demo);
GreedyMutableDeserialization(demo);
}
public ActionResult DeleteConfirmed(int id)
{
DemoTable demoTable = db.DemoTable.Find(id);
db.DemoTable.Remove(demoTable);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public JsonResult Delete(int ID)
{
DemoTable dt = DC.DemoTables.Single(m => m.Id == ID);
DC.DemoTables.Remove(dt);
DC.SaveChanges();
return(Json("Deleted", JsonRequestBehavior.AllowGet));
}
public ActionResult Edit([Bind(Include = "StepID,StepName,Description,IsActive,LastUpdated,LastUpdatedBy")] DemoTable demoTable)
{
if (ModelState.IsValid)
{
db.Entry(demoTable).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(demoTable));
}
public ActionResult Edit([Bind(Include = "Id,Name,City,Age")] DemoTable demoTable)
{
if (ModelState.IsValid)
{
db.Entry(demoTable).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(demoTable));
}
/// <summary>
/// In lazy deserialization, FlatSharp reads from the underlying buffer each time. No caching is done. This will be
/// the fastest option if your access patterns are sparse and you touch each element only once.
/// </summary>
public static void LazyDeserialization(DemoTable demo)
{
var serializer = new FlatBufferSerializer(new FlatBufferSerializerOptions(FlatBufferDeserializationOption.Lazy));
byte[] buffer = new byte[1024];
serializer.Serialize(demo, buffer);
var parsed = serializer.Parse <DemoTable>(buffer);
// Lazy deserialization reads objects from vectors each time you ask for them.
InnerTable index0_1 = parsed.ListVector ![0];
public ActionResult Create([Bind(Include = "Id,Name,City,Age")] DemoTable demoTable)
{
if (ModelState.IsValid)
{
db.DemoTables.Add(demoTable);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(demoTable));
}
public ActionResult Create([Bind(Include = "StepID,StepName,Description,IsActive,LastUpdated,LastUpdatedBy")] DemoTable demoTable)
{
if (ModelState.IsValid)
{
db.DemoTable.Add(demoTable);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(demoTable));
}
/// <summary>
/// 刪除
/// </summary>
public void Delete(DemoTable Data)
{
try
{
this.DemoTableDao.Delete(Data);
}
catch (Exception ex)
{
throw ex;
}
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
DemoTable dt = new DemoTable();
dt.DemoTitle = TextBox1.Text;
dt.DemoSource = TextBox2.Text;
dl.da.DemoTables.InsertOnSubmit(dt);
dl.da.SubmitChanges();
TextBox1.Text = TextBox2.Text = "";
Response.Write("<script>alert('Success')</script>");
}
/// <summary>
/// 閱讀
/// </summary>
public DemoTable Read(DemoTable Data)
{
try
{
return(this.DemoTableDao.Read(Data));
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult Detail(DemoTable fdata)
{
if (fdata.id > 0)
{
_demo.Update(fdata);
}
else
{
_demo.Add(fdata);
}
return(RedirectToAction("Index", "Demo"));
}
// GET: DemoTables/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DemoTable demoTable = db.DemoTable.Find(id);
if (demoTable == null)
{
return(HttpNotFound());
}
return(View(demoTable));
}
/// <summary>
/// 閱讀
/// </summary>
public DemoTable Read(DemoTable Data)
{
var sql = @"SELECT * FROM DemoTable(NOLOCK) WHERE Id=@Id";
using (var connection = new SqlConnection(ConfigTool.GetDbConnectionStrings()))
{
try
{
var result = connection.Query <DemoTable>(sql, Data).ToList();
return(result.Count > 0 ? result.First() : null);
}
catch (Exception ex)
{
throw ex;
}
}
}
/// <summary>
/// 建立
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public JsonResult Create(DemoTable model)
{
var result = new ResultModel()
{
ExecuteResult = "執行成功",
QueryResult = ""
};
try
{
this.DemoService.Create(model);
}
catch (Exception ex)
{
result.ExecuteResult = string.Format("執行失敗(錯誤原因：{0})", ex.Message);
}
return(Json(result));
}
/// <summary>
/// 查詢
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public JsonResult Read(DemoTable model)
{
var result = new ResultModel()
{
ExecuteResult = "執行成功",
QueryResult = ""
};
try
{
var queryResult = this.DemoService.Read(model);
result.QueryResult = queryResult != null ? new JavaScriptSerializer().Serialize(queryResult) : "查無資料";
}
catch (Exception ex)
{
result.ExecuteResult = string.Format("執行失敗(錯誤原因：{0})", ex.Message);
}
return(Json(result));
}
/// <summary>
/// 刪除
/// </summary>
public void Delete(DemoTable Data)
{
var sql = @"DELETE FROM DemoTable WHERE Id=@Id";
using (var connection = new SqlConnection(ConfigTool.GetDbConnectionStrings()))
{
connection.Open();
var transaction = connection.BeginTransaction();
try
{
connection.Execute(sql, Data, transaction);
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
/// <summary>
/// 新增
/// </summary>
public void Create(DemoTable Data)
{
var sql = @"INSERT INTO DemoTable Values(@Id,@Name,@Gender)";
using (var connection = new SqlConnection(ConfigTool.GetDbConnectionStrings()))
{
connection.Open();
var transaction = connection.BeginTransaction();
try
{
connection.Execute(sql, Data, transaction);
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
public void Refresh()
{
if (csv == null)
{
return;
}
DemoTable table = new DemoTable();
table.Load(csv.text);
// names
AddItem("Year", Color.gray);
AddItem("Make", Color.gray);
AddItem("Model", Color.gray);
AddItem("Desc", Color.gray);
AddItem("Price", Color.gray);
// types
DemoTable.Row row = table.GetAt(0);
AddItem(row.Year.GetType().ToString(), Color.gray);
AddItem(row.Make.GetType().ToString(), Color.gray);
AddItem(row.Model.GetType().ToString(), Color.gray);
AddItem(row.Description.GetType().ToString(), Color.gray);
AddItem(row.Price.GetType().ToString(), Color.gray);
// datas
int numRows = table.NumRows();
for (int i = 0; i < numRows; i++)
{
AddItem(table.GetAt(i).Year.ToString());
AddItem(table.GetAt(i).Make);
AddItem(table.GetAt(i).Model);
AddItem(table.GetAt(i).Description);
AddItem(table.GetAt(i).Price.ToString());
}
}
/// <summary>
/// 更新
/// </summary>
public void Update(DemoTable Data)
{
var sql = @"
UPDATE DemoTable
SET Id=@Id,Name=@Name,Gender=@Gender
WHERE Id=@Id";
using (var connection = new SqlConnection(ConfigTool.GetDbConnectionStrings()))
{
connection.Open();
var transaction = connection.BeginTransaction();
try
{
connection.Execute(sql, Data, transaction);
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
public ActionResult Index(DemoTable dt)
{
DC.DemoTables.Add(dt);
DC.SaveChanges();
return(Json("Ok", JsonRequestBehavior.AllowGet));
}
partial void DeleteDemoTable(DemoTable instance);
partial void UpdateDemoTable(DemoTable instance);
partial void InsertDemoTable(DemoTable instance);
public JsonResult Update(DemoTable emp)
{
DC.Entry(emp).State = System.Data.Entity.EntityState.Modified;
DC.SaveChanges();
return(Json("Ok", JsonRequestBehavior.AllowGet));
}
