/// <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); }