营销外包网站,海淀区seo搜索优化,虚拟主机 2个网站,南京振高建设有限公司官方网站文章目录 前言一、问题描述二、解决方案三、软件开发#xff08;源码#xff09;四、项目展示五、资源链接 前言
我能抽象出整个世界#xff0c;但是我不能抽象你。 想让你成为私有常量#xff0c;这样外部函数就无法访问你。 又想让你成为全局常量#xff0c;这样在我的… 文章目录 前言一、问题描述二、解决方案三、软件开发源码四、项目展示五、资源链接 前言
我能抽象出整个世界但是我不能抽象你。 想让你成为私有常量这样外部函数就无法访问你。 又想让你成为全局常量这样在我的整个生命周期都可以调用你。 可惜世上没有这样的常量我也无法定义你因为你在我心中是那么的具体。
哈喽大家好本专栏为【项目实战】有别于【底层库】专栏我们可以发现增加 了『问题描述』、『项目展示』章节十分贴合项目开发流程让读者更加清楚本文能够解决的问题、以及产品能够达到的效果。本专栏收纳项目开发过程中的解决方案是我项目开发相对成熟、可靠方法的总结在不涉及职务作品、保密协议 的前提下我将问题的解决方案重新梳理撰写本文分享给大家大家遇到类似问题可按本文方案处理。
本专栏会持续更新不断完善专栏文章关联性较弱文章之间依赖性较弱没有阅读顺序。大家有任何问题可以私信我。如果您对本专栏感兴趣欢迎关注吧我将带你用最简洁的代码实现复杂的功能。
·提示本专栏为项目实战篇未接触项目开发的同学可能理解困难不推荐阅读。
一、问题描述
本文以通用功能开发Excel导入功能【底层库】专栏也有类似文章与之不同的是本解决方案可视化效果最佳。
二、解决方案
三、软件开发源码
创建类FrmImport.cs复制以下代码。
using App.Mes.Core.Helper.Plan;
using App.Mes.Winforms.Plan.Core.Import;
using DevExpress.Spreadsheet;
using DevExpress.XtraEditors.Controls;
using DevExpress.XtraEditors.Repository;
using DevExpress.XtraSpreadsheet;
using GlueNet.Dtos;
using GlueNet.Extensions;
using GlueNet.Localization;
using GlueNet.Winforms;
using System;
using System.Collections.Generic;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Windows.Forms;namespace App.Mes.Winforms.Plan.Core
{public partial class FrmImport : GlueForm{private SpreadsheetControl spreadsheetControl;private IImportDataHelper ImportDataHelper;private bool DownloadAddress { get; set; }private string ImportType { get; set; }public ListImportDataDto ListProperty { get; set; } new ListImportDataDto();public FuncValueDisplayItem, ImportDataDto, ComaprareLevel CustomCompare { get; set; } ((vauleDisplayIem, importDataItem){vauleDisplayIem.DisplayName string.IsNullOrEmpty(vauleDisplayIem.DisplayName) ? : vauleDisplayIem.DisplayName;if (string.IsNullOrWhiteSpace(importDataItem.Attribute.Description)){return ComaprareLevel.NotMatched();}if (vauleDisplayIem.DisplayName importDataItem.Attribute.Description){return ComaprareLevel.Matched(1);}else if (vauleDisplayIem.DisplayName.Contains(importDataItem.Attribute.Description)){return ComaprareLevel.Matched(2);}else if (importDataItem.Attribute.Description.Contains(vauleDisplayIem.DisplayName)){return ComaprareLevel.Matched(3);}return ComaprareLevel.NotMatched();});public FrmImport(IImportDataHelper helper, bool downloadAddress true, string importType 1){InitializeComponent();this.DownloadAddress downloadAddress;this.page1.AllowNext false;this.ImportType importType;this.radioGroup1.EditValue helper.IsDataConver;ImportDataHelper helper;ListProperty.Clear();ListProperty.AddRange(ImportDataHelper.GetProperty());spreadsheetControl new SpreadsheetControl();}public FrmImport(IImportDataHelper helper, FuncValueDisplayItem, ImportDataDto, ComaprareLevel customCompare) : this(helper){CustomCompare customCompare;}protected override void OnLoad(EventArgs e){base.OnLoad(e);}private Worksheet Worksheet{get{return spreadsheetControl.Document.Worksheets[cboSheet.EditValue.ToString()];}}private void buttonEdit1_Click(object sender, EventArgs e){var res openFileDialog1.ShowDialog();if (res ! DialogResult.OK){return;}using (var wait new WaitDialog(LM.L(正在加载数据...))){cboSheet.Properties.Items.Clear();this.buttonEdit1.Text openFileDialog1.FileName;spreadsheetControl.LoadDocument(openFileDialog1.FileName);foreach (var sheet in spreadsheetControl.Document.Worksheets){cboSheet.Properties.Items.Add(sheet.Name);}cboSheet.SelectedIndex 0;}this.page1.AllowNext true;}private void ToPage2(){var sheet Worksheet;var colCOunt sheet.GetUsedRange().ColumnCount;var columns new ListGlueNet.Dtos.ValueDisplayItem();for (int i 0; i colCOunt; i){var col sheet[(int)(this.spinTitleRow.Value - 1), i].Value.TextValue;columns.Add(new GlueNet.Dtos.ValueDisplayItem{DisplayName col,Value i.ToString(),Tag i});if (ImportDataHelper.IsDataTable){var importdatadto new ImportDataDto();importdatadto.Attribute new ImportDataAttribute(col);importdatadto.ColumnIndex i;importdatadto.IsRequired false;importdatadto.Attribute.Required false;ListProperty.Add(importdatadto); //ListProperty目标数据列}}foreach (var item in ListProperty){var query (from x in columnslet matchedItem CustomCompare(x, item)where matchedItem.CanMatch trueorderby matchedItem.Levelselect x);item.ColumnIndex (int?)query.FirstOrDefault()?.Tag;}this.SourceColumnIndex.ColumnEdit GetComboBox(columns);this.bindingSource1.DataSource ListProperty;this.gridView1.BestFitColumns();}public RepositoryItemImageComboBox GetComboBox(ListValueDisplayItem columns){var items columns.Select(x new ImageComboBoxItem(x.DisplayName, x.Tag)).ToArray();var repo new RepositoryItemImageComboBox();repo.Items.AddRange(items);repo.Items.Insert(0, new ImageComboBoxItem(string.Empty, string.Empty));return repo;}private void wizardControl_NextClick(object sender, DevExpress.XtraWizard.WizardCommandButtonClickEventArgs e){if (e.Page this.page1){this.ToPage2();}else if (e.Page this.page2){if (MsgBox.ShowYesNo(确认导入?) DialogResult.Yes){this.ToPage3();}else{this.wizardControl.SelectedPageIndex 1;}}else if (e.Page this.page3){}}private void ToPage3(){this.lblCurrent.Text $0/0;var sheet Worksheet;// 开始行var startRow (int)this.spinFirstRow.Value;var count sheet.Rows.LastUsedIndex - (startRow - 1) 1;this.progressBarControl1.Properties.Maximum count;this.progressBarControl1.Properties.Step 1;System.Threading.Tasks.Task.Factory.StartNew(new Action(() {using (var table new DataTable()){foreach (var item in this.ListProperty){if (ImportDataHelper.IsDataTable){if (item.Attribute.Description null){continue;}if (table.Columns.Contains(item.Attribute.Description)){int i 1;while (!table.Columns.Contains(item.Attribute.Description i.ToString())){i;}table.Columns.Add(item.Attribute.Description i.ToString());}elsetable.Columns.Add(item.Attribute.Description);}elsetable.Columns.Add(item.PropertyInfo.Name);}var count1 sheet.Rows.LastUsedIndex - (startRow - 1) 1;for (int i startRow - 1; i sheet.Rows.LastUsedIndex; i){ImportDataHelper.FillTable(Worksheet.Rows[i], table, this.ListProperty);this.Invoke(new Action(() {this.lblCurrent.Text ${(i - (startRow - 1) 1)}/{count1};this.progressBarControl1.PerformStep();}));}this.Invoke(new Action(() {this.richEditControl1.Text \r\n正在保存数据...;}));var formatter GlueNet.Serialization.GlueFormattersManager.GetFirstJsonFormatter();var str formatter.SerializeToJson(table);if (ImportDataHelper.IsDataTable){ str table.ToJsonString(true); }try{ImportDataHelper.Finish((bool)this.radioGroup1.EditValue, str);this.Invoke(new Action(() {this.richEditControl1.Text \r\n完成导入。;}));}catch (Exception ex){this.Invoke(new Action(() {this.richEditControl1.Text $\r\n导入发生错误:{ex.Message}。;}));}}}));}private void simpleButton1_Click(object sender, EventArgs e){var workSheet spreadsheetControl.ActiveWorksheet;var col 0;var row 0;foreach (var item in ListProperty){var cell workSheet[row, col];cell.Alignment.WrapText true;cell.SetValue(item.Attribute.Description);col;if (string.IsNullOrEmpty(item.Attribute.Remark) false){Comment comment workSheet.Comments.Add(cell, , ${item.Attribute.Remark});CommentRunCollection runs comment.Runs;runs.Insert(0, 备注 : \r\n);runs[0].Font.Bold true;runs[1].Font.Color Color.Red;runs[1].Font.Name $Tahoma;runs[1].Font.Size 10;runs[1].Font.Italic true;}}var columns workSheet.Columns;for (int i 0; i ListProperty.Count; i){columns[i].NumberFormat ;}var file ;if (DownloadAddress false){SaveFileDialog sfd new SaveFileDialog();sfd.Filter EXCEL文件(*.xlsx)|*.xlsx;sfd.FileName importData.xlsx;sfd.DefaultExt xlsx;sfd.AddExtension true;if (sfd.ShowDialog() DialogResult.OK){file sfd.FileName.ToString();}else{return;}}else{file Environment.GetFolderPath(Environment.SpecialFolder.Desktop) \\ImportData.xlsx;spreadsheetControl.SaveDocument(file, DocumentFormat.Xlsx);}this.buttonEdit1.Text file;System.Diagnostics.Process.Start(file);}private void simpleButton2_Click(object sender, EventArgs e){spreadsheetControl.LoadDocument(this.buttonEdit1.Text);cboSheet.Properties.Items.Clear();foreach (var sheet in spreadsheetControl.Document.Worksheets){cboSheet.Properties.Items.Add(sheet.Name);}cboSheet.SelectedIndex 0;this.page1.AllowNext true;}private void buttonEdit1_ButtonClick(object sender, ButtonPressedEventArgs e){if (e.Button.Caption Opern){buttonEdit1_Click(null, null);}if (e.Button.Caption Save){simpleButton1_Click(null, null);}if (e.Button.Caption Update){simpleButton2_Click(null, null);}}private void FrmImport_FormClosing(object sender, FormClosingEventArgs e){if (spreadsheetControl ! null){spreadsheetControl.Dispose();}}}
}
FrmImport.designer.cs
namespace App.Mes.Winforms.Plan.Core
{partial class FrmImport{/// summary/// Required designer variable./// /summaryprivate System.ComponentModel.IContainer components null;/// summary/// Clean up any resources being used./// /summary/// param namedisposingtrue if managed resources should be disposed; otherwise, false./paramprotected override void Dispose(bool disposing){if (disposing (components ! null)){components.Dispose();}base.Dispose(disposing);}#region Windows Form Designer generated code/// summary/// Required method for Designer support - do not modify/// the contents of this method with the code editor./// /summaryprivate void InitializeComponent(){this.components new System.ComponentModel.Container();DevExpress.XtraEditors.Controls.EditorButtonImageOptions editorButtonImageOptions1 new DevExpress.XtraEditors.Controls.EditorButtonImageOptions();System.ComponentModel.ComponentResourceManager resources new System.ComponentModel.ComponentResourceManager(typeof(FrmImport));DevExpress.Utils.SerializableAppearanceObject serializableAppearanceObject1 new DevExpress.Utils.SerializableAppearanceObject();DevExpress.Utils.SerializableAppearanceObject serializableAppearanceObject2 new DevExpress.Utils.SerializableAppearanceObject();DevExpress.Utils.SerializableAppearanceObject serializableAppearanceObject3 new DevExpress.Utils.SerializableAppearanceObject();DevExpress.Utils.SerializableAppearanceObject serializableAppearanceObject4 new DevExpress.Utils.SerializableAppearanceObject();DevExpress.XtraEditors.Controls.EditorButtonImageOptions editorButtonImageOptions2 new DevExpress.XtraEditors.Controls.EditorButtonImageOptions();DevExpress.Utils.SerializableAppearanceObject serializableAppearanceObject5 new DevExpress.Utils.SerializableAppearanceObject();DevExpress.Utils.SerializableAppearanceObject serializableAppearanceObject6 new DevExpress.Utils.SerializableAppearanceObject();DevExpress.Utils.SerializableAppearanceObject serializableAppearanceObject7 new DevExpress.Utils.SerializableAppearanceObject();DevExpress.Utils.SerializableAppearanceObject serializableAppearanceObject8 new DevExpress.Utils.SerializableAppearanceObject();DevExpress.XtraEditors.Controls.EditorButtonImageOptions editorButtonImageOptions3 new DevExpress.XtraEditors.Controls.EditorButtonImageOptions();DevExpress.Utils.SerializableAppearanceObject serializableAppearanceObject9 new DevExpress.Utils.SerializableAppearanceObject();DevExpress.Utils.SerializableAppearanceObject serializableAppearanceObject10 new DevExpress.Utils.SerializableAppearanceObject();DevExpress.Utils.SerializableAppearanceObject serializableAppearanceObject11 new DevExpress.Utils.SerializableAppearanceObject();DevExpress.Utils.SerializableAppearanceObject serializableAppearanceObject12 new DevExpress.Utils.SerializableAppearanceObject();DevExpress.XtraGrid.GridFormatRule gridFormatRule1 new DevExpress.XtraGrid.GridFormatRule();DevExpress.XtraEditors.FormatConditionRuleValue formatConditionRuleValue1 new DevExpress.XtraEditors.FormatConditionRuleValue();this.gridColumn1 new DevExpress.XtraGrid.Columns.GridColumn();this.wizardControl new DevExpress.XtraWizard.WizardControl();this.page1 new DevExpress.XtraWizard.WelcomeWizardPage();this.layoutControl1 new DevExpress.XtraLayout.LayoutControl();this.radioGroup1 new DevExpress.XtraEditors.RadioGroup();this.buttonEdit1 new DevExpress.XtraEditors.ButtonEdit();this.spinLastRow new DevExpress.XtraEditors.SpinEdit();this.cboSheet new DevExpress.XtraEditors.ComboBoxEdit();this.spinFirstRow new DevExpress.XtraEditors.SpinEdit();this.spinTitleRow new DevExpress.XtraEditors.SpinEdit();this.layoutControlGroup1 new DevExpress.XtraLayout.LayoutControlGroup();this.EXCEL上传 new DevExpress.XtraLayout.LayoutControlItem();this.选择页签 new DevExpress.XtraLayout.LayoutControlItem();this.标题行 new DevExpress.XtraLayout.LayoutControlItem();this.起始数据行 new DevExpress.XtraLayout.LayoutControlItem();this.最后数据行 new DevExpress.XtraLayout.LayoutControlItem();this.操作方式 new DevExpress.XtraLayout.LayoutControlItem();this.emptySpaceItem1 new DevExpress.XtraLayout.EmptySpaceItem();this.page2 new DevExpress.XtraWizard.WizardPage();this.gridControl1 new DevExpress.XtraGrid.GridControl();this.bindingSource1 new System.Windows.Forms.BindingSource(this.components);this.gridView1 new DevExpress.XtraGrid.Views.Grid.GridView();this.SourceColumnIndex new DevExpress.XtraGrid.Columns.GridColumn();this.TargetColumnIndex new DevExpress.XtraGrid.Columns.GridColumn();this.repCbxSource new DevExpress.XtraEditors.Repository.RepositoryItemImageComboBox();this.repCbxTarget new DevExpress.XtraEditors.Repository.RepositoryItemImageComboBox();this.page3 new DevExpress.XtraWizard.CompletionWizardPage();this.richEditControl1 new DevExpress.XtraRichEdit.RichEditControl();this.panelControl1 new DevExpress.XtraEditors.PanelControl();this.labelControl8 new DevExpress.XtraEditors.LabelControl();this.lblCurrent new DevExpress.XtraEditors.LabelControl();this.progressBarControl1 new DevExpress.XtraEditors.ProgressBarControl();this.openFileDialog1 new System.Windows.Forms.OpenFileDialog();((System.ComponentModel.ISupportInitialize)(this.imageList)).BeginInit();((System.ComponentModel.ISupportInitialize)(this.wizardControl)).BeginInit();this.wizardControl.SuspendLayout();this.page1.SuspendLayout();((System.ComponentModel.ISupportInitialize)(this.layoutControl1)).BeginInit();this.layoutControl1.SuspendLayout();((System.ComponentModel.ISupportInitialize)(this.radioGroup1.Properties)).BeginInit();((System.ComponentModel.ISupportInitialize)(this.buttonEdit1.Properties)).BeginInit();((System.ComponentModel.ISupportInitialize)(this.spinLastRow.Properties)).BeginInit();((System.ComponentModel.ISupportInitialize)(this.cboSheet.Properties)).BeginInit();((System.ComponentModel.ISupportInitialize)(this.spinFirstRow.Properties)).BeginInit();((System.ComponentModel.ISupportInitialize)(this.spinTitleRow.Properties)).BeginInit();((System.ComponentModel.ISupportInitialize)(this.layoutControlGroup1)).BeginInit();((System.ComponentModel.ISupportInitialize)(this.EXCEL上传)).BeginInit();((System.ComponentModel.ISupportInitialize)(this.选择页签)).BeginInit();((System.ComponentModel.ISupportInitialize)(this.标题行)).BeginInit();((System.ComponentModel.ISupportInitialize)(this.起始数据行)).BeginInit();((System.ComponentModel.ISupportInitialize)(this.最后数据行)).BeginInit();((System.ComponentModel.ISupportInitialize)(this.操作方式)).BeginInit();((System.ComponentModel.ISupportInitialize)(this.emptySpaceItem1)).BeginInit();this.page2.SuspendLayout();((System.ComponentModel.ISupportInitialize)(this.gridControl1)).BeginInit();((System.ComponentModel.ISupportInitialize)(this.bindingSource1)).BeginInit();((System.ComponentModel.ISupportInitialize)(this.gridView1)).BeginInit();((System.ComponentModel.ISupportInitialize)(this.repCbxSource)).BeginInit();((System.ComponentModel.ISupportInitialize)(this.repCbxTarget)).BeginInit();this.page3.SuspendLayout();((System.ComponentModel.ISupportInitialize)(this.panelControl1)).BeginInit();this.panelControl1.SuspendLayout();((System.ComponentModel.ISupportInitialize)(this.progressBarControl1.Properties)).BeginInit();this.SuspendLayout();// // gridColumn1// this.gridColumn1.Caption 非空验证;this.gridColumn1.FieldName Required;this.gridColumn1.MinWidth 16;this.gridColumn1.Name gridColumn1;this.gridColumn1.Visible true;this.gridColumn1.VisibleIndex 2;this.gridColumn1.Width 169;// // wizardControl// this.wizardControl.Controls.Add(this.page1);this.wizardControl.Controls.Add(this.page2);this.wizardControl.Controls.Add(this.page3);this.wizardControl.Dock System.Windows.Forms.DockStyle.Fill;this.wizardControl.Location new System.Drawing.Point(0, 0);this.wizardControl.Margin new System.Windows.Forms.Padding(3, 4, 3, 4);this.wizardControl.MinimumSize new System.Drawing.Size(134, 151);this.wizardControl.Name wizardControl;this.wizardControl.Pages.AddRange(new DevExpress.XtraWizard.BaseWizardPage[] {this.page1,this.page2,this.page3});this.wizardControl.Size new System.Drawing.Size(664, 551);this.wizardControl.Text ;this.wizardControl.WizardStyle DevExpress.XtraWizard.WizardStyle.WizardAero;this.wizardControl.NextClick new DevExpress.XtraWizard.WizardCommandButtonClickEventHandler(this.wizardControl_NextClick);// // page1// this.page1.Controls.Add(this.layoutControl1);this.page1.Margin new System.Windows.Forms.Padding(3, 4, 3, 4);this.page1.Name page1;this.page1.Size new System.Drawing.Size(604, 365);this.page1.Text 第1步 上传EXCEL;// // layoutControl1// this.layoutControl1.Controls.Add(this.radioGroup1);this.layoutControl1.Controls.Add(this.buttonEdit1);this.layoutControl1.Controls.Add(this.spinLastRow);this.layoutControl1.Controls.Add(this.cboSheet);this.layoutControl1.Controls.Add(this.spinFirstRow);this.layoutControl1.Controls.Add(this.spinTitleRow);this.layoutControl1.Dock System.Windows.Forms.DockStyle.Fill;this.layoutControl1.Location new System.Drawing.Point(0, 0);this.layoutControl1.Margin new System.Windows.Forms.Padding(3, 4, 3, 4);this.layoutControl1.Name layoutControl1;this.layoutControl1.Root this.layoutControlGroup1;this.layoutControl1.Size new System.Drawing.Size(604, 365);this.layoutControl1.TabIndex 15;this.layoutControl1.Text layoutControl1;// // radioGroup1// this.radioGroup1.EditValue true;this.radioGroup1.Location new System.Drawing.Point(87, 160);this.radioGroup1.Margin new System.Windows.Forms.Padding(3, 4, 3, 4);this.radioGroup1.Name radioGroup1;this.radioGroup1.Properties.Items.AddRange(new DevExpress.XtraEditors.Controls.RadioGroupItem[] {new DevExpress.XtraEditors.Controls.RadioGroupItem(true, 覆盖),new DevExpress.XtraEditors.Controls.RadioGroupItem(false, 追加)});this.radioGroup1.Properties.ItemsLayout DevExpress.XtraEditors.RadioGroupItemsLayout.Flow;this.radioGroup1.Size new System.Drawing.Size(507, 51);this.radioGroup1.StyleController this.layoutControl1;this.radioGroup1.TabIndex 14;// // buttonEdit1// this.buttonEdit1.Location new System.Drawing.Point(87, 10);this.buttonEdit1.Margin new System.Windows.Forms.Padding(3, 4, 3, 4);this.buttonEdit1.Name buttonEdit1;this.buttonEdit1.Properties.BorderStyle DevExpress.XtraEditors.Controls.BorderStyles.Flat;editorButtonImageOptions1.Image ((System.Drawing.Image)(resources.GetObject(editorButtonImageOptions1.Image)));editorButtonImageOptions2.Image ((System.Drawing.Image)(resources.GetObject(editorButtonImageOptions2.Image)));editorButtonImageOptions3.Image ((System.Drawing.Image)(resources.GetObject(editorButtonImageOptions3.Image)));this.buttonEdit1.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Glyph, Opern, -1, true, true, false, editorButtonImageOptions1, new DevExpress.Utils.KeyShortcut(System.Windows.Forms.Keys.None), serializableAppearanceObject1, serializableAppearanceObject2, serializableAppearanceObject3, serializableAppearanceObject4, , null, null, DevExpress.Utils.ToolTipAnchor.Default),new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Glyph, Save, -1, true, true, false, editorButtonImageOptions2, new DevExpress.Utils.KeyShortcut(System.Windows.Forms.Keys.None), serializableAppearanceObject5, serializableAppearanceObject6, serializableAppearanceObject7, serializableAppearanceObject8, , null, null, DevExpress.Utils.ToolTipAnchor.Default),new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Glyph, Update, -1, true, true, false, editorButtonImageOptions3, new DevExpress.Utils.KeyShortcut(System.Windows.Forms.Keys.None), serializableAppearanceObject9, serializableAppearanceObject10, serializableAppearanceObject11, serializableAppearanceObject12, , null, null, DevExpress.Utils.ToolTipAnchor.Default)});this.buttonEdit1.Size new System.Drawing.Size(507, 26);this.buttonEdit1.StyleController this.layoutControl1;this.buttonEdit1.TabIndex 3;this.buttonEdit1.ButtonClick new DevExpress.XtraEditors.Controls.ButtonPressedEventHandler(this.buttonEdit1_ButtonClick);// // spinLastRow// this.spinLastRow.EditValue new decimal(new int[] {0,0,0,0});this.spinLastRow.Location new System.Drawing.Point(87, 130);this.spinLastRow.Margin new System.Windows.Forms.Padding(3, 4, 3, 4);this.spinLastRow.Name spinLastRow;this.spinLastRow.Properties.BorderStyle DevExpress.XtraEditors.Controls.BorderStyles.Flat;this.spinLastRow.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});this.spinLastRow.Properties.IsFloatValue false;this.spinLastRow.Properties.Mask.EditMask N00;this.spinLastRow.Size new System.Drawing.Size(507, 26);this.spinLastRow.StyleController this.layoutControl1;this.spinLastRow.TabIndex 12;// // cboSheet// this.cboSheet.Location new System.Drawing.Point(87, 40);this.cboSheet.Margin new System.Windows.Forms.Padding(3, 4, 3, 4);this.cboSheet.Name cboSheet;this.cboSheet.Properties.BorderStyle DevExpress.XtraEditors.Controls.BorderStyles.Flat;this.cboSheet.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});this.cboSheet.Properties.TextEditStyle DevExpress.XtraEditors.Controls.TextEditStyles.DisableTextEditor;this.cboSheet.Size new System.Drawing.Size(507, 26);this.cboSheet.StyleController this.layoutControl1;this.cboSheet.TabIndex 6;// // spinFirstRow// this.spinFirstRow.EditValue new decimal(new int[] {2,0,0,0});this.spinFirstRow.Location new System.Drawing.Point(87, 100);this.spinFirstRow.Margin new System.Windows.Forms.Padding(3, 4, 3, 4);this.spinFirstRow.Name spinFirstRow;this.spinFirstRow.Properties.BorderStyle DevExpress.XtraEditors.Controls.BorderStyles.Flat;this.spinFirstRow.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});this.spinFirstRow.Size new System.Drawing.Size(507, 26);this.spinFirstRow.StyleController this.layoutControl1;this.spinFirstRow.TabIndex 10;// // spinTitleRow// this.spinTitleRow.EditValue new decimal(new int[] {1,0,0,0});this.spinTitleRow.Location new System.Drawing.Point(87, 70);this.spinTitleRow.Margin new System.Windows.Forms.Padding(3, 4, 3, 4);this.spinTitleRow.Name spinTitleRow;this.spinTitleRow.Properties.BorderStyle DevExpress.XtraEditors.Controls.BorderStyles.Flat;this.spinTitleRow.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});this.spinTitleRow.Size new System.Drawing.Size(507, 26);this.spinTitleRow.StyleController this.layoutControl1;this.spinTitleRow.TabIndex 8;// // layoutControlGroup1// this.layoutControlGroup1.EnableIndentsWithoutBorders DevExpress.Utils.DefaultBoolean.True;this.layoutControlGroup1.GroupBordersVisible false;this.layoutControlGroup1.Items.AddRange(new DevExpress.XtraLayout.BaseLayoutItem[] {this.EXCEL上传,this.选择页签,this.标题行,this.起始数据行,this.最后数据行,this.操作方式,this.emptySpaceItem1});this.layoutControlGroup1.Name layoutControlGroup1;this.layoutControlGroup1.Size new System.Drawing.Size(604, 365);this.layoutControlGroup1.TextVisible false;// // EXCEL上传// this.EXCEL上传.Control this.buttonEdit1;this.EXCEL上传.Location new System.Drawing.Point(0, 0);this.EXCEL上传.Name EXCEL上传;this.EXCEL上传.Size new System.Drawing.Size(588, 30);this.EXCEL上传.Text EXCEL;this.EXCEL上传.TextSize new System.Drawing.Size(75, 18);// // 选择页签// this.选择页签.Control this.cboSheet;this.选择页签.Location new System.Drawing.Point(0, 30);this.选择页签.Name 选择页签;this.选择页签.Size new System.Drawing.Size(588, 30);this.选择页签.TextSize new System.Drawing.Size(75, 18);// // 标题行// this.标题行.Control this.spinTitleRow;this.标题行.Location new System.Drawing.Point(0, 60);this.标题行.Name 标题行;this.标题行.Size new System.Drawing.Size(588, 30);this.标题行.TextSize new System.Drawing.Size(75, 18);// // 起始数据行// this.起始数据行.Control this.spinFirstRow;this.起始数据行.Location new System.Drawing.Point(0, 90);this.起始数据行.Name 起始数据行;this.起始数据行.Size new System.Drawing.Size(588, 30);this.起始数据行.TextSize new System.Drawing.Size(75, 18);// // 最后数据行// this.最后数据行.Control this.spinLastRow;this.最后数据行.Location new System.Drawing.Point(0, 120);this.最后数据行.Name 最后数据行;this.最后数据行.Size new System.Drawing.Size(588, 30);this.最后数据行.TextSize new System.Drawing.Size(75, 18);// // 操作方式// this.操作方式.Control this.radioGroup1;this.操作方式.Location new System.Drawing.Point(0, 150);this.操作方式.Name 操作方式;this.操作方式.Size new System.Drawing.Size(588, 55);this.操作方式.TextSize new System.Drawing.Size(75, 18);// // emptySpaceItem1// this.emptySpaceItem1.AllowHotTrack false;this.emptySpaceItem1.Location new System.Drawing.Point(0, 205);this.emptySpaceItem1.Name emptySpaceItem1;this.emptySpaceItem1.Size new System.Drawing.Size(588, 144);this.emptySpaceItem1.TextSize new System.Drawing.Size(0, 0);// // page2// this.page2.Controls.Add(this.gridControl1);this.page2.Margin new System.Windows.Forms.Padding(3, 4, 3, 4);this.page2.Name page2;this.page2.Size new System.Drawing.Size(604, 365);this.page2.Text 第2步 设置Excel列与目标数据对应关系;// // gridControl1// this.gridControl1.DataSource this.bindingSource1;this.gridControl1.Dock System.Windows.Forms.DockStyle.Fill;this.gridControl1.EmbeddedNavigator.Margin new System.Windows.Forms.Padding(3, 4, 3, 4);this.gridControl1.Location new System.Drawing.Point(0, 0);this.gridControl1.MainView this.gridView1;this.gridControl1.Margin new System.Windows.Forms.Padding(3, 4, 3, 4);this.gridControl1.Name gridControl1;this.gridControl1.RepositoryItems.AddRange(new DevExpress.XtraEditors.Repository.RepositoryItem[] {this.repCbxSource,this.repCbxTarget});this.gridControl1.Size new System.Drawing.Size(604, 365);this.gridControl1.TabIndex 1;this.gridControl1.ViewCollection.AddRange(new DevExpress.XtraGrid.Views.Base.BaseView[] {this.gridView1});// // gridView1// this.gridView1.ColumnPanelRowHeight 20;this.gridView1.Columns.AddRange(new DevExpress.XtraGrid.Columns.GridColumn[] {this.SourceColumnIndex,this.TargetColumnIndex,this.gridColumn1});this.gridView1.DetailHeight 286;gridFormatRule1.ApplyToRow true;gridFormatRule1.Column this.gridColumn1;gridFormatRule1.Name Format0;formatConditionRuleValue1.Appearance.BackColor System.Drawing.Color.Red;formatConditionRuleValue1.Appearance.Options.UseBackColor true;formatConditionRuleValue1.Condition DevExpress.XtraEditors.FormatCondition.Equal;formatConditionRuleValue1.PredefinedName Red Bold Text;formatConditionRuleValue1.Value1 true;gridFormatRule1.Rule formatConditionRuleValue1;this.gridView1.FormatRules.Add(gridFormatRule1);this.gridView1.GridControl this.gridControl1;this.gridView1.Name gridView1;this.gridView1.OptionsView.ShowGroupPanel false;// // SourceColumnIndex// this.SourceColumnIndex.Caption Excel列;this.SourceColumnIndex.FieldName ColumnIndex;this.SourceColumnIndex.MinWidth 16;this.SourceColumnIndex.Name SourceColumnIndex;this.SourceColumnIndex.Visible true;this.SourceColumnIndex.VisibleIndex 0;this.SourceColumnIndex.Width 83;// // TargetColumnIndex// this.TargetColumnIndex.Caption 目标数据列;this.TargetColumnIndex.FieldName Attribute.Description;this.TargetColumnIndex.MinWidth 16;this.TargetColumnIndex.Name TargetColumnIndex;this.TargetColumnIndex.Visible true;this.TargetColumnIndex.VisibleIndex 1;this.TargetColumnIndex.Width 108;// // repCbxSource// this.repCbxSource.AutoHeight false;this.repCbxSource.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});this.repCbxSource.Name repCbxSource;// // repCbxTarget// this.repCbxTarget.AutoHeight false;this.repCbxTarget.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});this.repCbxTarget.Name repCbxTarget;// // page3// this.page3.Controls.Add(this.richEditControl1);this.page3.Controls.Add(this.panelControl1);this.page3.Controls.Add(this.progressBarControl1);this.page3.Margin new System.Windows.Forms.Padding(3, 4, 3, 4);this.page3.Name page3;this.page3.Size new System.Drawing.Size(604, 365);this.page3.Text 第3步 数据处理及保存;// // richEditControl1// this.richEditControl1.ActiveViewType DevExpress.XtraRichEdit.RichEditViewType.Simple;this.richEditControl1.BorderStyle DevExpress.XtraEditors.Controls.BorderStyles.NoBorder;this.richEditControl1.Dock System.Windows.Forms.DockStyle.Fill;this.richEditControl1.LayoutUnit DevExpress.XtraRichEdit.DocumentLayoutUnit.Pixel;this.richEditControl1.Location new System.Drawing.Point(0, 60);this.richEditControl1.Margin new System.Windows.Forms.Padding(3, 4, 3, 4);this.richEditControl1.Name richEditControl1;this.richEditControl1.Options.HorizontalScrollbar.Visibility DevExpress.XtraRichEdit.RichEditScrollbarVisibility.Hidden;this.richEditControl1.Options.VerticalScrollbar.Visibility DevExpress.XtraRichEdit.RichEditScrollbarVisibility.Hidden;this.richEditControl1.Padding new System.Windows.Forms.Padding(0, 65, 0, 0);this.richEditControl1.ReadOnly true;this.richEditControl1.Size new System.Drawing.Size(604, 305);this.richEditControl1.TabIndex 3;this.richEditControl1.Text 正在处理数据...;// // panelControl1// this.panelControl1.Controls.Add(this.labelControl8);this.panelControl1.Controls.Add(this.lblCurrent);this.panelControl1.Dock System.Windows.Forms.DockStyle.Top;this.panelControl1.Location new System.Drawing.Point(0, 29);this.panelControl1.Margin new System.Windows.Forms.Padding(3, 4, 3, 4);this.panelControl1.Name panelControl1;this.panelControl1.Size new System.Drawing.Size(604, 31);this.panelControl1.TabIndex 4;this.panelControl1.Visible false;// // labelControl8// this.labelControl8.Location new System.Drawing.Point(315, 7);this.labelControl8.Margin new System.Windows.Forms.Padding(3, 4, 3, 4);this.labelControl8.Name labelControl8;this.labelControl8.Size new System.Drawing.Size(90, 18);this.labelControl8.TabIndex 2;this.labelControl8.Text 数据处理进度;// // lblCurrent// this.lblCurrent.Location new System.Drawing.Point(427, 7);this.lblCurrent.Margin new System.Windows.Forms.Padding(3, 4, 3, 4);this.lblCurrent.Name lblCurrent;this.lblCurrent.Size new System.Drawing.Size(102, 18);this.lblCurrent.TabIndex 1;this.lblCurrent.Text 100000/100000;// // progressBarControl1// this.progressBarControl1.Dock System.Windows.Forms.DockStyle.Top;this.progressBarControl1.Location new System.Drawing.Point(0, 0);this.progressBarControl1.Margin new System.Windows.Forms.Padding(3, 4, 3, 4);this.progressBarControl1.Name progressBarControl1;this.progressBarControl1.Properties.ShowTitle true;this.progressBarControl1.Size new System.Drawing.Size(604, 29);this.progressBarControl1.TabIndex 0;// // openFileDialog1// this.openFileDialog1.FileName openFileDialog1;// // FrmImport// this.AutoScaleDimensions new System.Drawing.SizeF(8F, 18F);this.AutoScaleMode System.Windows.Forms.AutoScaleMode.Font;this.ClientSize new System.Drawing.Size(664, 551);this.Controls.Add(this.wizardControl);this.Margin new System.Windows.Forms.Padding(3, 5, 3, 5);this.Name FrmImport;this.ShowIcon false;this.Text Excel数据导入向导;this.FormClosing new System.Windows.Forms.FormClosingEventHandler(this.FrmImport_FormClosing);((System.ComponentModel.ISupportInitialize)(this.imageList)).EndInit();((System.ComponentModel.ISupportInitialize)(this.wizardControl)).EndInit();this.wizardControl.ResumeLayout(false);this.page1.ResumeLayout(false);((System.ComponentModel.ISupportInitialize)(this.layoutControl1)).EndInit();this.layoutControl1.ResumeLayout(false);((System.ComponentModel.ISupportInitialize)(this.radioGroup1.Properties)).EndInit();((System.ComponentModel.ISupportInitialize)(this.buttonEdit1.Properties)).EndInit();((System.ComponentModel.ISupportInitialize)(this.spinLastRow.Properties)).EndInit();((System.ComponentModel.ISupportInitialize)(this.cboSheet.Properties)).EndInit();((System.ComponentModel.ISupportInitialize)(this.spinFirstRow.Properties)).EndInit();((System.ComponentModel.ISupportInitialize)(this.spinTitleRow.Properties)).EndInit();((System.ComponentModel.ISupportInitialize)(this.layoutControlGroup1)).EndInit();((System.ComponentModel.ISupportInitialize)(this.EXCEL上传)).EndInit();((System.ComponentModel.ISupportInitialize)(this.选择页签)).EndInit();((System.ComponentModel.ISupportInitialize)(this.标题行)).EndInit();((System.ComponentModel.ISupportInitialize)(this.起始数据行)).EndInit();((System.ComponentModel.ISupportInitialize)(this.最后数据行)).EndInit();((System.ComponentModel.ISupportInitialize)(this.操作方式)).EndInit();((System.ComponentModel.ISupportInitialize)(this.emptySpaceItem1)).EndInit();this.page2.ResumeLayout(false);((System.ComponentModel.ISupportInitialize)(this.gridControl1)).EndInit();((System.ComponentModel.ISupportInitialize)(this.bindingSource1)).EndInit();((System.ComponentModel.ISupportInitialize)(this.gridView1)).EndInit();((System.ComponentModel.ISupportInitialize)(this.repCbxSource)).EndInit();((System.ComponentModel.ISupportInitialize)(this.repCbxTarget)).EndInit();this.page3.ResumeLayout(false);((System.ComponentModel.ISupportInitialize)(this.panelControl1)).EndInit();this.panelControl1.ResumeLayout(false);this.panelControl1.PerformLayout();((System.ComponentModel.ISupportInitialize)(this.progressBarControl1.Properties)).EndInit();this.ResumeLayout(false);}#endregionprivate DevExpress.XtraWizard.WizardControl wizardControl;private DevExpress.XtraWizard.WelcomeWizardPage page1;private DevExpress.XtraWizard.WizardPage page2;private DevExpress.XtraWizard.CompletionWizardPage page3;private DevExpress.XtraGrid.GridControl gridControl1;private DevExpress.XtraGrid.Views.Grid.GridView gridView1;private DevExpress.XtraGrid.Columns.GridColumn SourceColumnIndex;private DevExpress.XtraGrid.Columns.GridColumn TargetColumnIndex;private DevExpress.XtraGrid.Columns.GridColumn gridColumn1;private DevExpress.XtraEditors.Repository.RepositoryItemImageComboBox repCbxSource;private DevExpress.XtraEditors.Repository.RepositoryItemImageComboBox repCbxTarget;private System.Windows.Forms.OpenFileDialog openFileDialog1;private System.Windows.Forms.BindingSource bindingSource1;private DevExpress.XtraEditors.ProgressBarControl progressBarControl1;private DevExpress.XtraEditors.LabelControl labelControl8;private DevExpress.XtraEditors.LabelControl lblCurrent;private DevExpress.XtraEditors.PanelControl panelControl1;private DevExpress.XtraRichEdit.RichEditControl richEditControl1;private DevExpress.XtraLayout.LayoutControl layoutControl1;private DevExpress.XtraEditors.RadioGroup radioGroup1;private DevExpress.XtraEditors.ButtonEdit buttonEdit1;private DevExpress.XtraEditors.SpinEdit spinLastRow;private DevExpress.XtraEditors.ComboBoxEdit cboSheet;private DevExpress.XtraEditors.SpinEdit spinFirstRow;private DevExpress.XtraEditors.SpinEdit spinTitleRow;private DevExpress.XtraLayout.LayoutControlGroup layoutControlGroup1;private DevExpress.XtraLayout.EmptySpaceItem emptySpaceItem1;private DevExpress.XtraLayout.LayoutControlItem EXCEL上传;private DevExpress.XtraLayout.LayoutControlItem 选择页签;private DevExpress.XtraLayout.LayoutControlItem 标题行;private DevExpress.XtraLayout.LayoutControlItem 起始数据行;private DevExpress.XtraLayout.LayoutControlItem 最后数据行;private DevExpress.XtraLayout.LayoutControlItem 操作方式;}
}四、项目展示 五、资源链接
