-
Notifications
You must be signed in to change notification settings - Fork 0
/
AddDataFrm.cs
71 lines (63 loc) · 2.31 KB
/
AddDataFrm.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
namespace CHXQ.XMManager
{
public partial class AddDataFrm : Form
{
public AddDataFrm()
{
InitializeComponent();
}
public WorkArgument pWorkArgument;
private void BtnStart_Click(object sender, EventArgs e)
{
/* if (txbExcelPath.Text == string.Empty)
{
MessageBox.Show("请选择普查数据表格");
return;
}
if (TxbCoordFile.Text == string.Empty)
{
MessageBox.Show("请选择坐标数据表格");
return;
}
*/
pWorkArgument = new WorkArgument();
pWorkArgument.ExcelPath = txbExcelPath.Text;
pWorkArgument.CoordExcelpath = TxbCoordFile.Text;
this.DialogResult = System.Windows.Forms.DialogResult.OK;
}
private void BtnOpenExcel_Click(object sender, EventArgs e)
{
OpenFileDialog pDialog = new OpenFileDialog();
pDialog.Filter = "Excel文件|*.xls;*.xlsx|所有文件(*.*)|*.*";
pDialog.Title = "选择入库文件";
if (pDialog.ShowDialog() == DialogResult.OK)
{
txbExcelPath.Text = pDialog.FileName;
DataTable CurTable = ExcelClass.ReadExcelFile(pDialog.FileName, 0, 0, 0, true, 1);
if (!CurTable.Columns.Contains("起点点号") || !CurTable.Columns.Contains("终点点号"))
{
MessageBox.Show("选择的表格不符合格式要求", "错误", MessageBoxButtons.OK, MessageBoxIcon.Stop);
txbExcelPath.Clear();
}
}
}
private void BtnOpenCoordExcel_Click(object sender, EventArgs e)
{
OpenFileDialog pDialog = new OpenFileDialog();
pDialog.Filter = "Excel文件|*.xls;*.xlsx|所有文件(*.*)|*.*";
pDialog.Title = "选择入库文件";
if (pDialog.ShowDialog() == DialogResult.OK)
{
TxbCoordFile.Text = pDialog.FileName;
}
}
}
}