仓库管理系统25--数据导出

原创不易，打字不易，截图不易，多多点赞，送人玫瑰，留有余香，财务自由明日实现 

1、添加用户控件

 

<UserControl x:Class="West.StoreMgr.View.DataExportView"
             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" 
             xmlns:local="clr-namespace:West.StoreMgr.View"
             xmlns:i="http://schemas.microsoft.com/expression/2010/interactivity"
             mc:Ignorable="d" 
             DataContext="{Binding Source={StaticResource Locator},Path=DataExport}"
             d:DesignHeight="450" d:DesignWidth="800">
    <i:Interaction.Triggers>
        <i:EventTrigger EventName="Loaded">
            <i:InvokeCommandAction Command="{Binding LoadCommand}"/>
        </i:EventTrigger>
    </i:Interaction.Triggers>
    <Grid>
        <Grid.RowDefinitions>
            <RowDefinition Height="50"/>
            <RowDefinition />
            <RowDefinition Height="auto"/>
        </Grid.RowDefinitions>
        <!--标题-->
        <StackPanel Background="#EDF0F6" Orientation="Horizontal">
            <TextBlock Margin="10 0 0 0" Text="&#xf015;" FontSize="20" FontFamily="/Fonts/#FontAwesome" HorizontalAlignment="Left" VerticalAlignment="Center" Foreground="#797672"/>
            <TextBlock Margin="10 0 0 0" Text="首页 > 数据导出" FontSize="20" FontFamily="/Fonts/#FontAwesome" HorizontalAlignment="Left" VerticalAlignment="Center" Foreground="#797672"/>
        </StackPanel>

        <!--Tabcontrol-->
        <Grid Grid.Row="1" Margin="20">
            <TabControl ItemsSource="{Binding TabItems}"/>
        </Grid>

        <!--button-->
        <Grid Grid.Row="2" Margin="10 10 10 10">
            <Button  Height="36" Width="120" Grid.Row="3" 
                     HorizontalAlignment="Right"
                        Content="一键导出" Style="{StaticResource ButtonStyle}" 
                        CommandParameter="{Binding RelativeSource={RelativeSource Mode=FindAncestor,AncestorType=local:DataExportView}}"
                        Command="{Binding BackupCommand}"/>
        </Grid>
    </Grid>
</UserControl>

 2、添加viewmodel

using GalaSoft.MvvmLight;
using System;
using System.Collections.Generic;
using System.Collections.ObjectModel;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Controls;
using System.Windows;
using System.IO;
using GalaSoft.MvvmLight.Command;
using West.StoreMgr.Service;
using West.StoreMgr.Control;
using West.StoreMgr.Helper;
using West.StoreMgr.Model;

namespace West.StoreMgr.ViewModel
{
    /// <summary>
    /// 数据导出viewmodel
    /// </summary>
    public class DataExportViewModel : ViewModelBase
    {
        private List<Customer> customers = new List<Customer>();
        private List<Goods> goods = new List<Goods>();
        private List<GoodsType> goodsTypes = new List<GoodsType>();
        private List<InStore> inStores = new List<InStore>();
        private List<Inventory> inventories = new List<Inventory>();
        private List<OutStore> outStores = new List<OutStore>();
        private List<OutStore_temp> outStoresTemp = new List<OutStore_temp>();
        private List<Spec> specs = new List<Spec>();
        private List<Store> stores = new List<Store>();
        private List<Supplier> suppliers = new List<Supplier>();
        private List<UserInfo> userInfos = new List<UserInfo>();


        private ObservableCollection<TabItem> tabItems = new ObservableCollection<TabItem>();
        /// <summary>
        /// tab选项集合
        /// </summary>
        public ObservableCollection<TabItem> TabItems
        {
            get { return tabItems; }
            set { tabItems = value; RaisePropertyChanged(); }
        }

        public RelayCommand LoadCommand
        {
            get
            {
                return new RelayCommand(() =>
                {
                    customers = new CustomerService().Select();
                    goods = new GoodsService().Select();
                    goodsTypes = new GoodsTypeService().Select();
                    inStores = new InStoreService().Select();
                    inventories = new InventoryService().Select();
                    outStores = new OutStoreService().Select();
                    outStoresTemp = BuildList(outStores);
                    specs = new SpecService().Select();
                    stores = new StoreService().Select();
                    suppliers = new SupplierService().Select();
                    userInfos = new UserInfoService().Select();

                    tabItems.Add(new TabItem { Header = "客户表", Content = new TableControl { DataContext = customers } });
                    tabItems.Add(new TabItem { Header = "物资表", Content = new TableControl { DataContext = goods } });
                    tabItems.Add(new TabItem { Header = "物资类别表", Content = new TableControl { DataContext = goodsTypes } });
                    tabItems.Add(new TabItem { Header = "入库表", Content = new TableControl { DataContext = inStores } });
                    tabItems.Add(new TabItem { Header = "盘存表", Content = new TableControl { DataContext = inventories } });
                    tabItems.Add(new TabItem { Header = "出库表", Content = new TableControl { DataContext = outStoresTemp } });
                    tabItems.Add(new TabItem { Header = "规格表", Content = new TableControl { DataContext = specs } });
                    tabItems.Add(new TabItem { Header = "仓库表", Content = new TableControl { DataContext = stores } });
                    tabItems.Add(new TabItem { Header = "供应商表", Content = new TableControl { DataContext = suppliers } });
                    tabItems.Add(new TabItem { Header = "用户表", Content = new TableControl { DataContext = userInfos } });
                });
            }
        }

        /// <summary>
        /// 构建新的出库实体（原实体具有扩展属性，这是不必要的）
        /// </summary>
        /// <param name="outStores"></param>
        /// <returns></returns>
        List<OutStore_temp> BuildList(List<OutStore> outStores)
        {
            List<OutStore_temp> list = new List<OutStore_temp>();
            foreach(OutStore item in outStores)
            {
                OutStore_temp temp = new OutStore_temp();
                temp.Id = item.Id;
                temp.GoodsSerial = item.GoodsSerial;
                temp.Name = item.Name;
                temp.StoreId = item.StoreId;
                temp.StoreName = item.StoreName;
                temp.CustomerId = item.CustomerId;
                temp.CustomerName = item.CustomerName;
                temp.Unit = item.Unit;
                temp.Number = item.Number;
                temp.Price = item.Price;
                temp.InsertDate = item.InsertDate;
                temp.GoodsTypeId = item.GoodsTypeId;
                temp.UserInfoId = item.UserInfoId;
                temp.UserInfoName = item.UserInfoName;
                temp.Tag = item.Tag;
                temp.IsInventory = item.IsInventory; 
                list.Add(temp); 
            }
            return list;
        }


        /// <summary>
        /// 导出命令
        /// </summary>
        public RelayCommand BackupCommand
        {
            get
            {
                return new RelayCommand(() =>
                {
                    Backup(customers, "customers");
                    Backup(goods, "goods");
                    Backup(goodsTypes, "goodsTypes");
                    Backup(inStores, "inStores");
                    Backup(inventories, "inventories");
                    Backup(outStoresTemp, "outStores");
                    Backup(specs, "specs");
                    Backup(stores, "stores");
                    Backup(suppliers, "suppliers");
                    Backup(userInfos, "userInfos");
                });
            }
        }

        /// <summary>
        /// 导出数据
        /// </summary>
        /// <param name="array">列表对象</param>
        /// <param name="filename">文件名称</param>
        /// <exception cref="NotImplementedException"></exception>
        private void Backup<T>(List<T> array, string name)
        {
            var t = typeof(T);
            var properties = t.GetProperties(System.Reflection.BindingFlags.Instance | System.Reflection.BindingFlags.Public);
            var contents = new StringBuilder();

            //标题
            foreach (var item in properties)
            {
                //得到第一个自定义属性的参数的值，即属性描述
                var desc = item.CustomAttributes.ToList()[0].ConstructorArguments[0].Value.ToString();  
                contents.Append(desc);
                contents.Append(",");
            } 
            contents.Append("\r\n");//换行

            //内容
            foreach (var model in array)
            {
                var row = new StringBuilder();
                foreach (var property in properties)
                {
                    var val = property.GetValue(model);
                    row.Append(val);
                    row.Append(",");
                }
                contents.Append(row.ToString());
                contents.Append("\r\n");
            }

            //finename -> 表格+日期
            var date = $"{DateTime.Now.Year}-{DateTime.Now.Month}-{DateTime.Now.Day}";
            var filename = $"c:\\{name}{date}.csv";

            //保存
            File.WriteAllText(filename, contents.ToString(),Encoding.UTF8);//以utf-8的格式保存成csv格式
            MsgWinHelper.ShowMessage("数据导出完成");
        }
    }
}

3、运行效果