/// <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)
});
}
}
public void ClassifyAndExportDefines(IList <DistributorCat> distributorCats)
{
var currentClassification = BaseConstants.LoadInfo <ClassificationDefine>(BaseConstants.ClassificationDefinePath);
foreach (var item in distributorCats)
{
if (!currentClassification.Distributors.Any(x => x.IncludeText(item.Distributor)))
{
currentClassification.Distributors.Add(item.Distributor);
}
}
BusinessFunc.ExportItemToFile(currentClassification, BaseConstants.ClassificationDefinePath);
}
private void ExportJson(IList <Film> filmInfos)
{
var list = filmInfos.SelectMany(x => x.Brackets).OrderBy(x => x.Type).ThenByDescending(x => x.Text);
var result = new Dictionary <string, Bracket>();
foreach (var item in list)
{
if (!result.ContainsKey(item.Text))
{
result.Add(item.Text, item);
}
}
BusinessFunc.ExportListToFile(result.Values, BaseConstants.BracketPath, false);
}
/// <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
});
}
}
public void ClassifyAndExportDefines(IList <Film> filmInfos, ClassificationDefine classificationDefine)
{
var list = new List <Phrases>();
foreach (var item in filmInfos)
{
var name = item.FileName;
if (!string.IsNullOrEmpty(item.Distributor))
{
name = name.Replace(item.Distributor, string.Empty);
}
if (!string.IsNullOrEmpty(item.Identification))
{
name = name.Replace(item.Identification, string.Empty);
}
var allPhrases = name.Split(' ');
foreach (var phrase in allPhrases)
{
if (list.Any(x => x.Phrase.Equals(phrase, StringComparison.CurrentCultureIgnoreCase)))
{
continue;
}
var type = PhraseType.Undefined;
if (classificationDefine.Actors.Contains(phrase))
{
type = PhraseType.Actress;
}
else if (classificationDefine.Genres.Contains(phrase))
{
type = PhraseType.Subject;
}
list.Add(new Phrases {
Phrase = phrase, PhraseType = type
});
}
}
var result = list.OrderBy(x => x.PhraseType).ThenBy(x => x.Phrase);
BusinessFunc.ExportListToFile(result, BaseConstants.PhrasePath, false);
}
private void ReDefine()
{
var src = new List <DistributorCat>();
BaseConstants.LoadInfos(BaseConstants.DistributorCatPath, src);
var dest = new List <DistributorCat>();
foreach (var item in src)
{
if (!dest.Any(x => x.Equals(item)))
{
dest.Add(item);
}
}
if (!src.Any(x => dest.Any(y => x.Equals(y))))
{
BusinessFunc.ExportListToFile(dest, BaseConstants.DistributorCatPath, false);
}
}
/// <summary>
/// 查詢單一資料
/// </summary>
public void FindSingleData()
{
var bl = BusinessFunc.CreateBusinessLogic(this.SessionGuid, "Employee");
var result = bl.Find(new GFindInputArgs());
}
public void ExportJson()
{
BusinessFunc.ExportListToFile(DistributorCats, BaseConstants.DistributorCatPath, true);
BusinessFunc.ExportListToFile(FilmInfos, BaseConstants.FilmPath, ExportAndIncludeSource);
BusinessFunc.ExportListToFile(EmptyFileDirs, BaseConstants.EmptyDirPath, ExportAndIncludeSource);
}
public void SaveItemsToJson(bool isIncludeSource = false)
{
BusinessFunc.ExportListToFile(Items, _FilePath, isIncludeSource);
}
public void SaveItemToJson()
{
BusinessFunc.ExportItemToFile(Item, _FilePath);
}
