public void DoCreateProgramDefine()
{
var helper = new InitDataHelper();
var progDefine = new GProgramDefine();
Console.WriteLine("ProgID：");
progDefine.ProgID = Console.ReadLine();
Console.WriteLine("DisplayName：");
progDefine.DisplayName = Console.ReadLine();
Console.WriteLine("Start Create Table");
var tableDefine = new GTableDefine();
tableDefine.PrimaryKey = progDefine.ProgID + "Id";
progDefine.Tables.Add(tableDefine);
Console.WriteLine("TableName：");
tableDefine.TableName = Console.ReadLine();
Console.WriteLine("DbTableName：");
tableDefine.DbTableName = Console.ReadLine();
Console.WriteLine("Table DisplayName：");
tableDefine.DisplayName = Console.ReadLine();
var createField = true;
while (createField)
{
Console.WriteLine("Start Create Field Define");
var fieldDefine = new GFieldDefine();
tableDefine.Fields.Add(fieldDefine);
Console.WriteLine("FieldName：");
fieldDefine.FieldName = Console.ReadLine();
Console.WriteLine("DisplayName：");
fieldDefine.DisplayName = Console.ReadLine();
Console.WriteLine("DbType：");
Console.WriteLine("(0：String, 1：Text, 2：Boolean, 3：Integer, 4：Double, 5：Currency, 6：DateTime, 7：GUID, 8：Binary)");
var dbType = int.Parse(Console.ReadLine());
fieldDefine.DbType = BaseFunc.CEnum <EFieldDbType>(dbType, 0);
Console.WriteLine("MaxLength：");
fieldDefine.MaxLength = int.Parse(Console.ReadLine());
Console.WriteLine("AllowNull：(0: false, 1: true)");
fieldDefine.AllowNull = BaseFunc.CBool(Console.ReadLine());
Console.WriteLine("LinkFieldName：");
fieldDefine.LinkFieldName = Console.ReadLine();
Console.WriteLine("LinkProgID：");
fieldDefine.LinkProgID = Console.ReadLine();
Console.WriteLine("Continue Create Field Define? 1：Yes? 0：No?");
var ans = Console.ReadLine();
if (ans.SameTextOr("No", "0"))
{
createField = false;
}
Console.WriteLine("================================================");
}
helper.ProgDefineToJson(progDefine);
Console.WriteLine($"已產生程式定義檔案：{progDefine.ProgID}/{progDefine.DisplayName}");
Console.ReadKey();
}
private static void ReSaveProgramDefine()
{
var helper = new InitDataHelper();
var pd = CacheFunc.GetProgramDefine("SalaryAccount");
helper.ProgDefineToJson(pd);
pd = CacheFunc.GetProgramDefine("SalaryAccountCategory");
helper.ProgDefineToJson(pd);
pd = CacheFunc.GetProgramDefine("SalaryAccountForSalaryRange");
helper.ProgDefineToJson(pd);
pd = CacheFunc.GetProgramDefine("SalaryRange");
helper.ProgDefineToJson(pd);
}
/// <summary>
/// 機制Demo
/// </summary>
private static void MechanismDemo()
{
var helper = new InitDataHelper();
Console.WriteLine("定義匯入");
Console.ReadKey();
helper.InitData();
Console.WriteLine("定義匯入完成");
Console.WriteLine("==================================");
Console.WriteLine("資料表升級");
Console.ReadKey();
helper.CreateDbTable();
Console.WriteLine("資料表完成");
Console.WriteLine("==================================");
Console.WriteLine("新增資料");
Console.ReadKey();
helper.AddData();
Console.WriteLine("新增資料完成");
Console.WriteLine("==================================");
Console.WriteLine("查詢資料");
Console.ReadKey();
helper.FindData();
Console.WriteLine("查詢資料完成");
Console.WriteLine("==================================");
Console.WriteLine("修改資料");
Console.ReadKey();
helper.EditData();
Console.WriteLine("修改資料完成");
Console.WriteLine("==================================");
Console.WriteLine("刪除資料");
Console.ReadKey();
helper.DeleteData();
Console.WriteLine("刪除資料完成");
Console.WriteLine("==================================");
Console.WriteLine("離開");
Console.ReadKey();
}
