using System.Collections.ObjectModel;
using System.Diagnostics;
using System.IO;
using CommunityToolkit.Mvvm.ComponentModel;
using CommunityToolkit.Mvvm.Input;
using NewLife;
using NewLife.Log;
using XCode;
using XCode.Code;
using XCode.DataAccessLayer;
using NewLife.XCoder.Services;
namespace NewLife.XCoder.ViewModels;
/// <summary>数据建模/代码生成器 ViewModel</summary>
public partial class DataModelingViewModel : ObservableObject
{
#region 属性
/// <summary>当前连接名</summary>
[ObservableProperty]
private String _connName = "";
/// <summary>是否已连接</summary>
[ObservableProperty]
private Boolean _isConnected;
/// <summary>是否包含视图</summary>
[ObservableProperty]
private Boolean _includeView = true;
/// <summary>数据表列表</summary>
public ObservableCollection<IDataTable> Tables { get; } = [];
/// <summary>选中的数据表</summary>
[ObservableProperty]
private IDataTable? _selectedTable;
/// <summary>命名空间</summary>
[ObservableProperty]
private String _nameSpace = "";
/// <summary>实体连接名</summary>
[ObservableProperty]
private String _entityConnName = "";
/// <summary>输出路径</summary>
[ObservableProperty]
private String _outputPath = "";
/// <summary>实体基类</summary>
[ObservableProperty]
private String _baseClass = "Entity";
/// <summary>使用中文文件名</summary>
[ObservableProperty]
private Boolean _useCNFileName;
/// <summary>生成泛型实体类</summary>
[ObservableProperty]
private Boolean _renderGenEntity;
/// <summary>连接按钮文本</summary>
public String ConnectButtonText => IsConnected ? LocalizationService.T("Disconnect") : LocalizationService.T("Connect");
partial void OnIsConnectedChanged(Boolean value)
{
OnPropertyChanged(nameof(ConnectButtonText));
}
/// <summary>状态文本</summary>
[ObservableProperty]
private String _status = LocalizationService.T("就绪");
/// <summary>所有可用连接</summary>
public ObservableCollection<String> Connections { get; } = [];
#endregion
#region 构造
/// <summary>实例化数据建模 ViewModel</summary>
public DataModelingViewModel()
{
LoadConnections();
if (Connections.Count > 0)
ConnName = Connections[0];
}
private void LoadConnections()
{
Connections.Clear();
foreach (var item in DAL.ConnStrs.Keys.OrderBy(e => e))
{
Connections.Add(item);
}
}
#endregion
#region 命令
/// <summary>连接/断开数据库</summary>
[RelayCommand]
private async Task Connect()
{
if (IsConnected)
{
Tables.Clear();
IsConnected = false;
Status = LocalizationService.T("已断开");
return;
}
if (ConnName.IsNullOrEmpty()) return;
try
{
Status = LocalizationService.T("正在连接...");
var dal = DAL.Create(ConnName);
_ = dal.ConnStr;
await Task.Run(() => LoadTables());
IsConnected = true;
Status = $"已连接 {ConnName},共 {Tables.Count} 个表";
if (NameSpace.IsNullOrEmpty()) NameSpace = ConnName;
if (EntityConnName.IsNullOrEmpty()) EntityConnName = ConnName;
if (OutputPath.IsNullOrEmpty()) OutputPath = ConnName;
}
catch (Exception ex)
{
Status = $"连接失败:{ex.Message}";
XTrace.WriteException(ex);
}
}
/// <summary>刷新数据表</summary>
[RelayCommand]
private async Task RefreshTables()
{
if (ConnName.IsNullOrEmpty()) return;
Status = LocalizationService.T("正在刷新表...");
await Task.Run(() => LoadTables());
Status = $"已刷新,共 {Tables.Count} 个表";
}
private void LoadTables()
{
var dal = DAL.Create(ConnName);
var list = dal.Tables;
if (!IncludeView)
list = list.Where(t => !t.IsView).ToList();
list = list.Where(t => t.Name != "dtproperties" && t.Name != "sysconstraints" && t.Name != "syssegments").ToList();
list = [.. list.OrderBy(t => t.Name)];
Avalonia.Threading.Dispatcher.UIThread.Post(() =>
{
Tables.Clear();
foreach (var table in list)
{
Tables.Add(table);
}
});
}
/// <summary>生成选中表的代码</summary>
[RelayCommand]
private async Task GenerateTable()
{
if (SelectedTable == null) return;
await Task.Run(() =>
{
try
{
var option = new EntityBuilderOption
{
BaseClass = BaseClass,
ConnName = EntityConnName,
Namespace = NameSpace,
Output = OutputPath,
};
var sw = Stopwatch.StartNew();
var rs = EntityBuilder.BuildTables([SelectedTable], option);
sw.Stop();
Avalonia.Threading.Dispatcher.UIThread.Post(() =>
{
Status = $"生成 {SelectedTable.Name} 完成!耗时:{sw.Elapsed}";
});
}
catch (Exception ex)
{
XTrace.WriteException(ex);
Avalonia.Threading.Dispatcher.UIThread.Post(() =>
{
Status = $"生成失败:{ex.Message}";
});
}
});
}
/// <summary>生成所有表的代码</summary>
[RelayCommand]
private async Task GenerateAll()
{
if (Tables.Count == 0) return;
var tables = Tables.ToList();
await Task.Run(() =>
{
try
{
var option = new EntityBuilderOption
{
BaseClass = BaseClass,
ConnName = EntityConnName,
Namespace = NameSpace,
Output = OutputPath,
};
var sw = Stopwatch.StartNew();
var rs = EntityBuilder.BuildTables(tables, option);
sw.Stop();
Avalonia.Threading.Dispatcher.UIThread.Post(() =>
{
Status = $"生成 {tables.Count} 个类完成!耗时:{sw.Elapsed}";
});
}
catch (Exception ex)
{
XTrace.WriteException(ex);
Avalonia.Threading.Dispatcher.UIThread.Post(() =>
{
Status = $"生成失败:{ex.Message}";
});
}
});
}
/// <summary>打开输出目录</summary>
[RelayCommand]
private void OpenOutputDir()
{
var dir = OutputPath.GetFullPath();
if (!Directory.Exists(dir))
dir = AppDomain.CurrentDomain.BaseDirectory;
Process.Start("explorer.exe", "\"" + dir + "\"");
}
#endregion
}
|