基礎(chǔ)資料是ERP中一個模塊这敬。主要功能是相當于一個數(shù)據(jù)字典铅鲤。最近在搭建一個簡單的ERP的框架。需要將基礎(chǔ)資料與單據(jù)的模板抽象出來万牺，做成通用模板罗珍，以后需要新增基礎(chǔ)資料和單據(jù)時，只需要繼承相應的模板脚粟，增刪改查覆旱，審核、棄審核无、打印等都不需要再寫扣唱。
這篇文章主要介紹基礎(chǔ)資料的模板搭建。
我們先建一個ViewModelBase团南，添加一些常用的工具欄命令噪沙。
public partial class ViewModelBase : INotifyPropertyChanged
{
public ViewModelBase()
{
CloseCommand = new DelegateCommand<T_DATAFLOWSUBOPER>(ExecuteClose);
PrintCommand = new DelegateCommand<T_DATAFLOWSUBOPER>(ExecutePrint, CanExecutePrint);
SaveCommand = new DelegateCommand<T_DATAFLOWSUBOPER>(ExecuteSave, CanExecuteSave);
DeleteCommand = new DelegateCommand<T_DATAFLOWSUBOPER>(ExecuteDelete, CanExecuteDelete);
DetailCommand = new DelegateCommand(ExecuteDetail);
NavigateCommand = new DelegateCommand<string>(ExecuteNavigate);
ShowHandInputCommand = new DelegateCommand(ExecuteShowHandInput);
AddCommand = new DelegateCommand<T_DATAFLOWSUBOPER>(ExecuteAdd);
ModifyCommand = new DelegateCommand<T_DATAFLOWSUBOPER>(ExecuteModify);
ListCommand = new DelegateCommand<T_DATAFLOWSUBOPER>(ExecuteList);
MouseDoubleClickCommand = new DelegateCommand(ExecuteMouseDoubleClick);
ReferBDCommand = new DelegateCommand(ExecuteReferBD);
ExitCommand = new DelegateCommand(ExecuteExit);
AuditCommand = new DelegateCommand<T_DATAFLOWSUBOPER>(ExecuteAudit, CanExecuteAudit);
UnAuditCommand = new DelegateCommand<T_DATAFLOWSUBOPER>(ExecuteUnAudit, CanExecuteUnAduti);
} #region 【命令】
public DelegateCommand<T_DATAFLOWSUBOPER> AddCommand { get; set; }
/// <summary>
/// 保存命令
/// </summary>
public DelegateCommand<T_DATAFLOWSUBOPER> SaveCommand { get; set; }
/// <summary>
/// 審核
/// </summary>
public DelegateCommand<T_DATAFLOWSUBOPER> AuditCommand { get; set; }
/// <summary>
/// 反審核
/// </summary>
public DelegateCommand<T_DATAFLOWSUBOPER> UnAuditCommand { get; set; }
/// <summary>
/// 打印命令
/// </summary>
public DelegateCommand<T_DATAFLOWSUBOPER> PrintCommand { get; set; }
/// <summary>
/// 關(guān)閉命令
/// </summary>
public DelegateCommand<T_DATAFLOWSUBOPER> CloseCommand { get; set; }
/// <summary>
/// 詳情命令
/// </summary>
public DelegateCommand DetailCommand { get; set; }
/// <summary>
/// 刪除命令
/// </summary>
public DelegateCommand<T_DATAFLOWSUBOPER> DeleteCommand { get; set; }
/// <summary>
/// 導航命令
/// </summary>
public DelegateCommand<string> NavigateCommand { get; set; }
/// <summary>
/// 手寫命令
/// </summary>
public DelegateCommand ShowHandInputCommand { get; set; }
public DelegateCommand<T_DATAFLOWSUBOPER> ModifyCommand { get; set; }
public DelegateCommand<T_DATAFLOWSUBOPER> ListCommand { get; set; }
public DelegateCommand MouseDoubleClickCommand { get; set; }
public DelegateCommand ReferBDCommand { get; set; }
public DelegateCommand ExitCommand { get; set; }
#endregion
#region 【執(zhí)行命令】
public virtual void ExecuteSave(T_DATAFLOWSUBOPER para)
{
MessageService.Show("Save");
}
public virtual void ExecutePrint(T_DATAFLOWSUBOPER para)
{
MessageService.Show("Print");
}
public virtual void ExecuteClose(T_DATAFLOWSUBOPER para)
{
Messager.Messager.Default.Send("CloseChildWindow");
}
public virtual void ExecuteDetail()
{
throw new NotImplementedException();
}
public virtual void ExecuteDelete(T_DATAFLOWSUBOPER para)
{
MessageService.Show("Delete");
}
public virtual void ExecuteNavigate(string obj)
{
throw new NotImplementedException();
}
public virtual void ExecuteShowHandInput()
{
GlobalMethod.CallHandWriting();
}
public virtual void ExecuteAdd(T_DATAFLOWSUBOPER para)
{
MessageService.Show("Add");
}
public virtual void ExecuteModify(T_DATAFLOWSUBOPER para)
{
}
public virtual void ExecuteList(T_DATAFLOWSUBOPER para)
{
}
public virtual void ExecuteMouseDoubleClick()
{
}
public virtual void ExecuteReferBD()
{
GlobalVariableBusiness.BaseData.ReferBaseData();
}
public virtual void ExecuteExit()
{
GlobalMethod.ApplicationExit();
}
public virtual void ExecuteAudit(T_DATAFLOWSUBOPER para)
{
}
public virtual void ExecuteUnAudit(T_DATAFLOWSUBOPER para)
{
}
#endregion
#region 【命令邏輯】
public virtual bool CanExecuteSave(T_DATAFLOWSUBOPER para)
{
return true;
}
public virtual bool CanExecutePrint(T_DATAFLOWSUBOPER para)
{
return true;
}
protected virtual bool CanExecuteUnAduti(T_DATAFLOWSUBOPER arg)
{
return true;
}
protected virtual bool CanExecuteAudit(T_DATAFLOWSUBOPER arg)
{
return true;
}
protected virtual bool CanExecuteDelete(T_DATAFLOWSUBOPER arg)
{
return true;
}
#endregion
#region 【實現(xiàn)接口】
public event PropertyChangedEventHandler PropertyChanged;
public void RaisePropertyChanged(string name)
{
if (PropertyChanged != null)
{
PropertyChanged(this, new PropertyChangedEventArgs(name));
}
}
#endregion
}
現(xiàn)在我們增加基礎(chǔ)資料的通用ViewModel，繼承自ViewModelBase吐根，并重載命令的具體實現(xiàn)正歼。
public class BDViewModelBase<T>:ViewModelBase
{
private T _Master;
public T Master
{
get { return _Master; }
set
{
_Master = value;
RaisePropertyChanged("Master");
if (Master != null)
{
SetAuditImageShowStatus(Master.GetPropValue("FSTATUS"));
}
}
}
private List<T> _Detail;
public List<T> Detail
{
get { return _Detail; }
set { _Detail = value; RaisePropertyChanged("Detail"); }
}
private T _SelectedData;
public T SelectedData
{
get { return _SelectedData; }
set
{
_SelectedData = value;
RaisePropertyChanged("SelectedData");
if (value != null)
{
Master = GlobalMethod.Clone(SelectedData);
}
}
}
#region 重載
public override bool CanExecuteSave(T_DATAFLOWSUBOPER para)
{
if (BillState != NFMES.Core.Type.BillStateType.Complete)
{
return true;
}
else
{
return false;
}
}
public override NFMES.Core.MVVM.ViewModelBase ReferData()
{
ReLoadData();
return base.ReferData();
}
public override void ReLoadData()
{
Master = Activator.CreateInstance<T>();
Detail = BaseData.GetBaseDataList<T>();
}
#region 工具欄操作
public override void ExecuteAdd(T_DATAFLOWSUBOPER para)
{
CanEdit = true;
Master = Activator.CreateInstance<T>();
BillState = NFMES.Core.Type.BillStateType.newbill;
}
public override void ExecuteModify(T_DATAFLOWSUBOPER para)
{
CanEdit = true;
BillState = NFMES.Core.Type.BillStateType.modifybill;
}
public override void ExecuteSave(T_DATAFLOWSUBOPER para)
{
if (GlobalVariableBusiness.VaridateObj.CheckBaseDataNumberOnly(Master.GetTypeName(), Master.GetPropValue("FNUMBER").ToString())>0)
{
MessageService.Show("編號不可重復！");
return;
}
int result = -1;
switch (BillState)
{
case NFMES.Core.Type.BillStateType.newbill:
result = BaseData.SaveBaseData<T>(Master);
MessageService.Show(NFMES.Core.Type.OperateType.save, result);
break;
case NFMES.Core.Type.BillStateType.modifybill:
result = BaseData.UpdateBaseData<T>(Master);
MessageService.Show(NFMES.Core.Type.OperateType.update, result);
break;
}
if (result >= 0)
{
Detail = new List<T>(BaseData.GetBaseDataList<T>());
CanEdit = false;
BillState = NFMES.Core.Type.BillStateType.Complete;
}
}
public override void ExecuteDelete(T_DATAFLOWSUBOPER para)
{
if (GlobalVariableBusiness.VaridateObj.CheckBaseDataUsed(SubClass.FAddInKey, Convert.ToInt32(Master.GetPropValue("FID"))) == -1)
{
MessageService.Show("此條數(shù)據(jù)已被使用拷橘，不可刪除局义！");
return;
}
int result = BaseData.DeleteBaseData<T>(Master);
MessageService.Show(NFMES.Core.Type.OperateType.delete, result);
if (result >= 0)
{
Master = Activator.CreateInstance<T>();
Detail = new List<T>(BaseData.GetBaseDataList<T>());
}
}
#endregion
#endregion
}
可以看到，我們的BDViewModelBase需要傳遞一個泛型冗疮，我們的模板類里旭咽，都是基于這個泛型來做增刪改查的。
類中有三個屬性赌厅，Master，Detail轿塔，SelectedData特愿。MVVM模式，VM中的數(shù)據(jù)需要綁定到View中的勾缭。所以這三個數(shù)據(jù)揍障，就是我們基礎(chǔ)資料的數(shù)據(jù)源。后面加的所有基礎(chǔ)資料View俩由，綁定的數(shù)據(jù)源名稱都是相同的毒嫡。
Master是錄入部分，Detail是列表部分幻梯，SelectedData是選中的列表行數(shù)據(jù)兜畸。
數(shù)據(jù)的DAL層用的Dapper框架努释，這個這邊就不討論了。我前面的文章有個對Dapper的封裝的分享咬摇，也用在這個項目中了伐蒂。
下面，我們基礎(chǔ)資料的模板有了肛鹏。以后變動的就是基礎(chǔ)資料界面逸邦。如果基礎(chǔ)資料的界面上的字段都一樣，也可以做成通用的在扰，不過很少缕减。最常用的就是編碼、名稱字段芒珠。不過有時會關(guān)聯(lián)其它基礎(chǔ)資料桥狡。比如員工就需要關(guān)聯(lián)角色。
下面我們看看一個標準的基礎(chǔ)資料的View的寫法妓局。以部門資料為例：
<UserControl
xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid" xmlns:dxe="http://schemas.devexpress.com/winfx/2008/xaml/editors" xmlns:dxlc="http://schemas.devexpress.com/winfx/2008/xaml/layoutcontrol" x:Class="MESClient.Unit.Depart.Depart"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
mc:Ignorable="d"
d:DesignHeight="300" d:DesignWidth="300">
<Grid>
<Grid.RowDefinitions>
<RowDefinition Height="auto"/>
<RowDefinition Height="*"/>
</Grid.RowDefinitions>
<dxlc:LayoutControl VerticalAlignment="Top">
<dxlc:LayoutGroup Orientation="Vertical">
<dxlc:LayoutGroup>
<dxlc:LayoutItem Label="編號" Height="36" >
<dxe:TextEdit IsEnabled="{Binding CanEdit}" Style="{StaticResource TextEditNoBorderStyle}" Text="{Binding Master.FNUMBER,UpdateSourceTrigger=PropertyChanged}" />
</dxlc:LayoutItem>
<dxlc:LayoutItem Label="名稱" Height="36" >
<dxe:TextEdit IsEnabled="{Binding CanEdit}" Style="{StaticResource TextEditNoBorderStyle}" Text="{Binding Master.FNAME,UpdateSourceTrigger=PropertyChanged}" />
</dxlc:LayoutItem>
</dxlc:LayoutGroup>
</dxlc:LayoutGroup>
</dxlc:LayoutControl>
<GridSplitter Style="{DynamicResource GridSplitterHStyle}"/>
<dxg:GridControl Style="{DynamicResource GridControlStyle}" Grid.Row="1" ItemsSource="{Binding Detail}" SelectedItem="{Binding SelectedData}">
<dxg:GridControl.Columns>
<dxg:GridColumn FieldName="FNUMBER" Header="編碼"/>
<dxg:GridColumn FieldName="FNAME" Header="名稱"/>
<dxg:GridColumn FieldName="FSTATUS" Header="單據(jù)狀態(tài)">
<dxg:GridColumn.EditSettings>
<dxe:ComboBoxEditSettings ItemsSource="{Binding StatusTypeData.BillStatusList,Mode=OneWay}" ValueMember="Id" DisplayMember="Description"/>
</dxg:GridColumn.EditSettings>
</dxg:GridColumn>
</dxg:GridControl.Columns>
<dxg:GridControl.View>
<dxg:TableView AllowEditing="False" ShowGroupPanel="False"/>
</dxg:GridControl.View>
</dxg:GridControl>
</Grid>
</UserControl>
現(xiàn)在总放，我們不需要再為部門單獨做ViewModel了，我們直接用通用的BDViewModelBase好爬。
public partial class Depart : UserControl
{
public Depart()
: this(null)
{
}
public Depart(object para)
{
InitializeComponent();
this.DataContext = new BDViewModelBase<T_Department>(）;
}
}
T_Department是一個Model局雄，與數(shù)據(jù)表的結(jié)構(gòu)相同。
如果嫌寫一個與表結(jié)構(gòu)相同的Model麻煩存炮，可以參考我前面的一篇文章炬搭，利用tt模板，自動將表結(jié)構(gòu)生成Model實體。
如果我們需要增加一個職員的檔案凉驻，界面如果和部門一樣的話佩研，那我們只需要改下this.DataContext的那行代碼
this.DataContext = new BDViewModelBase<T_Employee>(）;
只需要換一下實體。
抽象單據(jù)的方法與此類似灼芭，只是數(shù)據(jù)源和保存刪除，數(shù)據(jù)刷新會有不同般又。
