/// <summary> /// Cli generate command. /// </summary> protected override void CommandGenerateIntegrate(GenerateIntegrateResult result) { // Navigate result.Add(Data.Query <NavigateIntegrate>().OrderBy(item => item.IdName)); result.AddKey <Navigate>(nameof(Navigate.Name)); result.AddReference <Navigate, Navigate>(nameof(Navigate.ParentId)); // LoginUser result.Add(Data.Query <LoginUserIntegrate>().Where(item => item.IsIntegrate == true).OrderBy(item => item.IdName), isApplication: true); result.AddKey <LoginUser>(nameof(LoginUser.Name)); // LoginRole result.Add(Data.Query <LoginRoleIntegrate>().OrderBy(item => item.IdName), isApplication: true); result.AddKey <LoginRole>(nameof(LoginRole.Name)); // LoginUserRole result.Add(Data.Query <LoginUserRoleIntegrate>().Where(item => item.LoginUserIsIntegrate == true).OrderBy(item => item.LoginUserIdName).ThenBy(item => item.LoginRoleIdName)); result.AddKey <LoginUserRole>(nameof(LoginUserRole.LoginUserId), nameof(LoginUserRole.LoginRoleId)); result.AddReference <LoginUserRole, LoginUser>(nameof(LoginUserRole.LoginUserId)); result.AddReference <LoginUserRole, LoginRole>(nameof(LoginUserRole.LoginRoleId)); // NavigateLoginRole result.Add(Data.Query <NavigateRoleIntegrate>().OrderBy(item => item.NavigateIdName).ThenBy(item => item.LoginRoleIdName)); result.AddKey <NavigateRole>(nameof(NavigateRole.NavigateId), nameof(NavigateRole.LoginRoleId)); result.AddReference <NavigateRole, Navigate>(nameof(NavigateRole.NavigateId)); result.AddReference <NavigateRole, LoginRole>(nameof(NavigateRole.LoginRoleId)); // StorageFile result.Add(Data.Query <StorageFileIntegrate>().OrderBy(item => item.IdName)); result.AddKey <StorageFile>(nameof(StorageFile.FileName)); result.AddBlob <StorageFileIntegrate>(nameof(StorageFile.Data), (row) => row.FileName); // Content result.Add(Data.Query <ContentIntegrate>().OrderBy(item => item.IdName)); result.AddKey <Content>(nameof(Content.Name)); result.AddBlob <ContentIntegrate>(nameof(Content.TextMd), (row) => row.IdName + ".md"); result.AddBlob <ContentIntegrate>(nameof(Content.TextHtml), (row) => row.IdName + ".html"); // Feedback result.Add(Data.Query <Feedback>().OrderBy(item => item.Name)); result.AddKey <Feedback>(nameof(Feedback.Name)); result.AddBlob <Feedback>(nameof(Feedback.AttachmentData), (row) => row.Name + "." + row.AttachmentFileName); }
/// <summary> /// Returns Integrate rows to generate CSharp code. /// </summary> /// <param name="isDeployDb">Method is called from command cli generate or cli deployDb.</param> /// <param name="tableNameCSharpApplicationFilterList">TableNameCSharp defined in method AppCli.CommandGenerateFilter();</param> internal GenerateIntegrateResult CommandGenerateIntegrateInternal(bool isDeployDb, List <string> tableNameCSharpApplicationFilterList) { var result = new GenerateIntegrateResult(AssemblyList(true, true)); result.AddKey <FrameworkTable>(nameof(FrameworkTable.TableNameCSharp)); // Do not generate CSharp code for table FrameworkTable and FrameworkField. Add reference for deoplyDb. result.AddKey <FrameworkField>(nameof(FrameworkField.TableId), nameof(FrameworkField.FieldNameCSharp)); result.AddReference <FrameworkField, FrameworkTable>(nameof(FrameworkFieldIntegrate.TableId)); var tableNameCSharpFrameworkList = UtilDalType.TableNameCSharpList(AssemblyFramework); // TableNameCSharp declared in Framework assembly. var tableNameCSharpApplicationList = UtilDalType.TableNameCSharpList(AssemblyApplication, AssemblyApplicationDatabase); // TableNameCSharp declared in Application assembly. var fieldNameCSharpFrameworkList = UtilDalType.FieldNameCSharpList(AssemblyFramework); // FieldNameCSharp declared in Framework assembly var fieldNameCSharpApplicationList = UtilDalType.FieldNameCSharpList(AssemblyApplication, AssemblyApplicationDatabase); // FieldNameCSharp declared in Framework assembly // Filter out tables defined in method AppCli.CommandGenerateFilter(); if (tableNameCSharpApplicationFilterList != null) { tableNameCSharpApplicationList = tableNameCSharpApplicationList.Where(item => tableNameCSharpApplicationFilterList.Contains(item.Value)).ToDictionary(item => item.Key, item => item.Value); fieldNameCSharpApplicationList = fieldNameCSharpApplicationList.Where(item => tableNameCSharpApplicationFilterList.Contains(item.TableNameCSharp)).ToList(); } // Prevent build error "An expression tree may not contain a tuple literal". var fieldNameCSharpFrameworkNoTupleList = fieldNameCSharpFrameworkList.Select(item => item.TableNameCSharp + "/" + item.FieldNameCSharp); var fieldNameCSharpApplicationNoTupleList = fieldNameCSharpApplicationList.Select(item => item.TableNameCSharp + "/" + item.FieldNameCSharp); // FrameworkConfigGridIntegrate { var rowList = Data.Query <FrameworkConfigGridIntegrate>(); // Framework (.\cli.cmd generate -f) { var rowFilterList = rowList.Where(item => tableNameCSharpFrameworkList.Values.ToArray().Contains(item.TableNameCSharp)); // Filter Framework. rowFilterList = rowFilterList.OrderBy(item => item.IdName); result.Add( isFrameworkDb: true, isApplication: false, typeRow: typeof(FrameworkConfigGridIntegrate), query: rowFilterList ); } // Application (.\cli.cmd generate) { var rowFilterList = rowList.Where(item => !tableNameCSharpFrameworkList.Values.ToArray().Contains(item.TableNameCSharp) && tableNameCSharpApplicationList.Values.ToArray().Contains(item.TableNameCSharp)); // Filter (not Framework and Application). rowFilterList = rowFilterList.OrderBy(item => item.IdName); result.Add( isFrameworkDb: false, isApplication: false, typeRow: typeof(FrameworkConfigGridIntegrate), query: rowFilterList ); } result.AddKey <FrameworkConfigGrid>(nameof(FrameworkConfigGrid.TableId), nameof(FrameworkConfigGrid.ConfigName)); result.AddReference <FrameworkConfigGrid, FrameworkTable>(nameof(FrameworkConfigGrid.TableId)); } // FrameworkConfigFieldIntegrate { var rowList = Data.Query <FrameworkConfigFieldIntegrate>(); // Framework (.\cli.cmd generate -f) { var rowFilterList = rowList.Where(item => tableNameCSharpFrameworkList.Values.ToArray().Contains(item.TableNameCSharp)); // Filter FrameworkDb. rowFilterList = rowList.Where(item => fieldNameCSharpFrameworkNoTupleList.Contains(item.TableNameCSharp + "/" + item.FieldNameCSharp)); // Filter FieldNameCSharp declared in Framework assembly. rowFilterList = rowFilterList.OrderBy(item => item.FieldIdName); result.Add( isFrameworkDb: true, isApplication: false, typeRow: typeof(FrameworkConfigFieldIntegrate), query: rowFilterList ); } // Application (.\cli.cmd generate) { var rowFilterList = rowList.Where(item => !tableNameCSharpFrameworkList.Values.ToArray().Contains(item.TableNameCSharp) && tableNameCSharpApplicationList.Values.ToArray().Contains(item.TableNameCSharp)); // Filter (not Framework and Application). rowFilterList = rowList.Where(item => fieldNameCSharpApplicationNoTupleList.Contains(item.TableNameCSharp + "/" + item.FieldNameCSharp)); // Filter FieldNameCSharp declared in Application assembly. rowFilterList = rowFilterList.OrderBy(item => item.FieldIdName); result.Add( isFrameworkDb: false, isApplication: false, typeRow: typeof(FrameworkConfigFieldIntegrate), query: rowFilterList ); } result.AddKey <FrameworkConfigField>(nameof(FrameworkConfigField.ConfigGridId), nameof(FrameworkConfigField.FieldId), nameof(FrameworkConfigField.InstanceName)); result.AddReference <FrameworkConfigField, FrameworkConfigGrid>(nameof(FrameworkConfigField.ConfigGridId)); result.AddReference <FrameworkConfigField, FrameworkField>(nameof(FrameworkConfigField.FieldId)); } // Application (custom) Integrate data rows to generate CSharp code from. CommandGenerateIntegrate(result); // Call method CommandGenerateIntegrate(); on external AppCli for deployDb only. Not for cli generate command. if (isDeployDb) { UtilExternal.CommandGenerateIntegrate(this, result); } return(result); }
/// <summary> /// Returns Integrate rows to generate CSharp code. /// </summary> internal GenerateIntegrateResult CommandGenerateIntegrateInternal() { var result = new GenerateIntegrateResult(AssemblyList(true, true)); result.AddKey <FrameworkTable>(nameof(FrameworkTable.TableNameCSharp)); // Do not generate CSharp code for table FrameworkTable and FrameworkField. Add reference for deoplyDb. result.AddKey <FrameworkField>(nameof(FrameworkField.TableId), nameof(FrameworkField.FieldNameCSharp)); result.AddReference <FrameworkField, FrameworkTable>(nameof(FrameworkFieldIntegrate.TableId)); var tableNameCSharpFrameworkList = UtilDalType.TableNameCSharpList(AssemblyFramework); // TableNameCSharp declared in Framework assembly. var tableNameCSharpApplicationList = UtilDalType.TableNameCSharpList(AssemblyApplication, AssemblyApplicationDatabase); // TableNameCSharp declared in Application assembly. var fieldNameCSharpFrameworkList = UtilDalType.FieldNameCSharpList(AssemblyFramework).Select(item => item.TableNameCSharp + "/" + item.FieldNameCSharp); // FieldNameCSharp declared in Framework assembly var fieldNameCSharpApplicationList = UtilDalType.FieldNameCSharpList(AssemblyApplication, AssemblyApplicationDatabase).Select(item => item.TableNameCSharp + "/" + item.FieldNameCSharp); // FieldNameCSharp declared in Framework assembly // FrameworkConfigGridIntegrate { var rowList = Data.Query <FrameworkConfigGridIntegrate>(); // Framework (.\cli.cmd generate -f) { var rowFilterList = rowList.Where(item => tableNameCSharpFrameworkList.Values.ToArray().Contains(item.TableNameCSharp)); // Filter Framework. rowFilterList = rowFilterList.OrderBy(item => item.IdName); result.Add( isFrameworkDb: true, isApplication: false, typeRow: typeof(FrameworkConfigGridIntegrate), query: rowFilterList ); } // Application (.\cli.cmd generate) { var rowFilterList = rowList.Where(item => !tableNameCSharpFrameworkList.Values.ToArray().Contains(item.TableNameCSharp) && tableNameCSharpApplicationList.Values.ToArray().Contains(item.TableNameCSharp)); // Filter (not Framework and Application). rowFilterList = rowFilterList.OrderBy(item => item.IdName); result.Add( isFrameworkDb: false, isApplication: false, typeRow: typeof(FrameworkConfigGridIntegrate), query: rowFilterList ); } result.AddKey <FrameworkConfigGrid>(nameof(FrameworkConfigGrid.TableId), nameof(FrameworkConfigGrid.ConfigName)); result.AddReference <FrameworkConfigGrid, FrameworkTable>(nameof(FrameworkConfigGrid.TableId)); } // FrameworkConfigFieldIntegrate { var rowList = Data.Query <FrameworkConfigFieldIntegrate>(); // Framework (.\cli.cmd generate -f) { var rowFilterList = rowList.Where(item => tableNameCSharpFrameworkList.Values.ToArray().Contains(item.TableNameCSharp)); // Filter FrameworkDb. rowFilterList = rowList.Where(item => fieldNameCSharpFrameworkList.Contains(item.TableNameCSharp + "/" + item.FieldNameCSharp)); // Filter FieldNameCSharp declared in Framework assembly. rowFilterList = rowFilterList.OrderBy(item => item.FieldIdName); result.Add( isFrameworkDb: true, isApplication: false, typeRow: typeof(FrameworkConfigFieldIntegrate), query: rowFilterList ); } // Application (.\cli.cmd generate) { var rowFilterList = rowList.Where(item => !tableNameCSharpFrameworkList.Values.ToArray().Contains(item.TableNameCSharp) && tableNameCSharpApplicationList.Values.ToArray().Contains(item.TableNameCSharp)); // Filter (not Framework and Application). rowFilterList = rowList.Where(item => fieldNameCSharpApplicationList.Contains(item.TableNameCSharp + "/" + item.FieldNameCSharp)); // Filter FieldNameCSharp declared in Application assembly. rowFilterList = rowFilterList.OrderBy(item => item.FieldIdName); result.Add( isFrameworkDb: false, isApplication: false, typeRow: typeof(FrameworkConfigFieldIntegrate), query: rowFilterList ); } result.AddKey <FrameworkConfigField>(nameof(FrameworkConfigField.ConfigGridId), nameof(FrameworkConfigField.FieldId), nameof(FrameworkConfigField.InstanceName)); result.AddReference <FrameworkConfigField, FrameworkConfigGrid>(nameof(FrameworkConfigField.ConfigGridId)); result.AddReference <FrameworkConfigField, FrameworkField>(nameof(FrameworkConfigField.FieldId)); } // Application (custom) Integrate data rows to generate CSharp code from. CommandGenerateIntegrate(result); return(result); }