/// <summary>
/// 清單查詢
/// </summary>
public void FindData()
{
var bl = BusinessFunc.CreateBusinessLogic(this.SessionGuid, "Employee");
var result = bl.Find(new GFindInputArgs());
var table = result.EntityTable;
var json = JsonConvert.SerializeObject(table, Formatting.Indented);
FileFunc.FileWriteAllText($@"{CurrentPath}\DemoData\FindData", "Employee.json", json);
}
/// <summary>
/// 刪除資料
/// </summary>
public void DeleteData()
{
var bl = BusinessFunc.CreateBusinessLogic(this.SessionGuid, "Employee");
var result = bl.Find(new GFindInputArgs());
var table = result.EntityTable;
foreach (GEntityRow row in result.EntityTable.Rows)
{
bl.Delete(new GDeleteInputArgs {
FormID = row.ValueAsString(SysFields.ID)
});
}
}
/// <summary>
/// 修改資料
/// </summary>
public void EditData()
{
var bl = BusinessFunc.CreateBusinessLogic(this.SessionGuid, "Employee");
var result = bl.Find(new GFindInputArgs());
var table = result.EntityTable;
foreach (GEntityRow row in result.EntityTable.Rows)
{
row.SetValue(SysFields.ViewID, row.ValueAsString(SysFields.ViewID) + "_2");
}
var dataSet = new GEntitySet(table.TableName);
dataSet.Tables.Add(table);
var saveResult = bl.Save(new GSaveInputArgs {
EntitySet = dataSet, SaveMode = ESaveMode.Edit
});
}
/// <summary>
/// 新增資料
/// </summary>
public void AddData()
{
var files = from f in Directory.EnumerateFiles($@"{this.CurrentPath}\DemoData\ImportData", "*.json", SearchOption.TopDirectoryOnly)
select new { FileName = FileFunc.GetFileName(f).Replace(".json", ""), Text = FileFunc.FileReadAllText(f) };
foreach (var file in files)
{
var dt = JsonConvert.DeserializeObject <DataTable>(file.Text);
dt.TableName = file.FileName;
var table = new GEntityTable(dt);
var dataSet = new GEntitySet(file.FileName);
dataSet.Tables.Add(table);
var bl = BusinessFunc.CreateBusinessLogic(this.SessionGuid, file.FileName);
var result = bl.Save(new GSaveInputArgs {
EntitySet = dataSet, SaveMode = ESaveMode.Add
});
}
}
/// <summary>
/// 查詢單一資料
/// </summary>
public void FindSingleData()
{
var bl = BusinessFunc.CreateBusinessLogic(this.SessionGuid, "Employee");
var result = bl.Find(new GFindInputArgs());
}