Step by step introduction to WPF application development based on CommunityToolkit.Mvvm and HandyControl (4) — Implementing the import and export operations of DataGrid data

Step by step introduction to WPF application development based on CommunityToolkit.Mvvm and HandyControl (4) — Implementing the import and export operations of DataGrid data

In many places in our design software, we see the need to import and export table data, mainly to facilitate customers to quickly process and share data. This essay introduces the import and export operations of DataGrid data based on WPF. .

In many places in our design software, we see the need to import and export table data, mainly to facilitate customers to quickly process and share data. This essay introduces the import of DataGrid data based on WPF and export operations.

1. System interface design

Before we implement the data import and export function, we need to provide customers with relevant operation buttons on the main interface. As shown in the following interface, import Excel, export PDF, and export Excel are provided at the top of the list.

Since these operation functions are basically used in every page module, they should be abstracted to base classes as much as possible and provide common processing operations. If there are differences, they can also be overridden by some attributes or event methods. way to achieve it.

So when we define buttons in Xaml, we basically call the view model method for generalized processing, as shown in the following code.

<Button
     Margin="5  "
     hc:IconElement.Geometry="{StaticResource t_import}"
     Command="{  Binding ImportExcelCommand}"
     Content="Import Excel"
     Style="{  StaticResource ButtonWarning}"   />
 <Button
     Margin="5  "
     hc:IconElement.Geometry="{StaticResource SaveGeometry}"
     Command="{  Binding ViewModel.ExportPdfCommand}"
     CommandParameter="User information list"
     Content="Export PDF"
     Style="{  StaticResource ButtonSuccess}"   />
 <Button
     Margin="5  "
     hc:IconElement.Geometry="{StaticResource SaveGeometry}"
     Command="{  Binding ViewModel.ExportExcelCommand}"
     CommandParameter="User information list"
     Content="Export Excel"</span}

             try
             {
                 var myDs = new   DataSet();

                 string error = "  ";
                 AsposeExcelTools.ExcelFileToDataSet(this.txtFilePath.Text, out myDs, out error);
                 this.ViewModel.Items = myDs.Tables[0];
             }
             catch (Exception ex  )
             {
                 LogTextHelper.Error(ex);
                 MessageDxUtil.ShowError(ex.Message);
             }
         }

The operation code for import processing is as follows.

/// 

 /// Save data to the database in batches
 /// 
 /// 
 [RelayCommand]
 private async  span> Task SaveData()
 {
     if (ViewModel.Items == null || ViewModel.Items?.Rows?.Count == 0)
         return new  span> CommonResult(false);

     if (MessageDxUtil.ShowYesNoAndWarning("This operation will import data into the system database. Are you sure you want to continue?") == System.Windows.MessageBoxResult.Yes)
     {
         var dt = this  .ViewModel.Items;
         foreach (DataRow dr   in dt.Rows)
         {
             try
             {
                 await OnDataSave(dr);
             }
             catch (Exception ex  )
             {
                 LogTextHelper.Error(ex);
                 MessageDxUtil.ShowError(ex.Message);
             }
         }
         return new  span> CommonResult(true, "Operation successful");
     }
     return new  span> CommonResult(false);
 }

Note that we use event processing here and leave the data conversion logic to subclasses.

 /// 

         /// Data saving event
         /// 
         public event SaveDataHandler OnDataSave;

In this way, the code in UserListPage.xaml.cs, the import page of user information, can implement events according to the actual situation.

 /// 

     /// Export content to Excel
     /// 
  [RelayCommand]
     private void  span> ImportExcel()
     {
         var page = App.GetService();
         page!.ViewModel.Items?.Clear();
         page!.ViewModel.TemplateFile = $"System user information-template.xls";
         page!.OnDataSave -= ExcelData_OnDataSave;
         page!.OnDataSave += ExcelData_OnDataSave;

         //Navigate to  Specify page
         ViewModel.Navigate(typeof(ImportExcelData)  );
     }

The implementation of this event is mainly to convert personalized user information (fields defined in the user information template) into DataTable row information, as shown in the following code. It can be modified specifically according to the template design.

I won’t go into details one by one. The main thing is to separate the base class logic from the specific implementation and implement different business function processing.

The above is an introduction to the common import and export operations that are often needed in one of our common list pages. I hope it can inspire and reference readers in developing WPF application functions.

Link Notes:

If you are interested in our code generation tool, you can download and use the “Code Generation Tool Database2Sharp” from the official website.

If you want to know about the introduction of “SqlSugar Development Framework” on our official website, you can refer to “SqlSugar Development Framework”.

If you want to read our introduction to the article “SqlSugar Development Framework”, you can refer to the essay tag “SqlSugar Essay, WPF Essay” in the blog park to learn more.

Focus on code generation tools, .Net/.NetCore framework architecture and software development, as well as various Vue.js front-end technology applications. He is the author of Winform development framework/hybrid development framework, WeChat development framework, Bootstrap development framework, ABP development framework, SqlSugar development framework and other framework products.

Please indicate the source for reprinting: Writer: Wu Huacong http://www.iqidi.com
span style=”color: rgba(0, 128, 0, 1)”> Data saving event
///

public event SaveDataHandler OnDataSave;

In this way, the code in UserListPage.xaml.cs, the import page of user information, can implement events according to the actual situation.

 /// 

     /// Export content to Excel
     /// 
  [RelayCommand]
     private void  span> ImportExcel()
     {
         var page = App.GetService();
         page!.ViewModel.Items?.Clear();
         page!.ViewModel.TemplateFile = $"System user information-template.xls";
         page!.OnDataSave -= ExcelData_OnDataSave;
         page!.OnDataSave += ExcelData_OnDataSave;

         //Navigate to  Specify page
         ViewModel.Navigate(typeof(ImportExcelData)  );
     }

The implementation of this event is mainly to convert personalized user information (fields defined in the user information template) into DataTable row information, as shown in the following code. It can be modified specifically according to the template design.

I won’t go into details one by one. The main thing is to separate the base class logic from the specific implementation and implement different business function processing.

The above is an introduction to the common import and export operations that are often needed in one of our common list pages. I hope it can inspire and reference readers in developing WPF application functions.

Link Notes:

If you are interested in our code generation tool, you can download and use the “Code Generation Tool Database2Sharp” from the official website.

If you want to know about the introduction of “SqlSugar Development Framework” on our official website, you can refer to “SqlSugar Development Framework”.

If you want to read our introduction to the article “SqlSugar Development Framework”, you can refer to the essay tag “SqlSugar Essay, WPF Essay” in the blog park to learn more.

Focus on code generation tools, .Net/.NetCore framework architecture and software development, as well as various Vue.js front-end technology applications. He is the author of Winform development framework/hybrid development framework, WeChat development framework, Bootstrap development framework, ABP development framework, SqlSugar development framework and other framework products.

Please indicate the source for reprinting: Writer: Wu Huacong http://www.iqidi.com