-
Notifications
You must be signed in to change notification settings - Fork 0
/
frm_Rx.cs
104 lines (91 loc) · 3.18 KB
/
frm_Rx.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
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace AutoOffice
{
public partial class frm_Rx : Form
{
private RxUtil oRx = new RxUtil();
private ExcelUtil oExcel = new ExcelUtil();
DataTable tbl_result;
System.Windows.Forms.TabPage Tp_Result = new TabPage();
System.Windows.Forms.DataGridView Gv_Result = new DataGridView();
private string FormPath { get; set; }
private string SavePath { get; set; }
public frm_Rx()
{
InitializeComponent();
}
private void frm_Rx_Load(object sender, EventArgs e)
{
this.cbo_dg_schema_rx_div.DataSource = RxUtil.RxDivs;
Tp_Result.Text = "결과보기";
Tp_Result.Controls.Add(Gv_Result);
Gv_Result.Dock = DockStyle.Fill;
Gv_Result.AutoGenerateColumns = true;
}
void fillData()
{
var ds = oExcel.ExcelToDataSet();
foreach (DataTable tbl in ds.Tables)
{
System.Windows.Forms.TabPage tp = new TabPage();
tp.Text = tbl.TableName;
this.tab_data.TabPages.Add(tp);
System.Windows.Forms.DataGridView gv = new DataGridView();
tp.Controls.Add(gv);
gv.Dock = DockStyle.Fill;
gv.AutoGenerateColumns = true;
gv.DataSource = tbl;
//
this.cbo_sheet.Items.Add(tbl.TableName);
}
if (ds.Tables.Count > 0)
{
this.cbo_sheet.SelectedIndex = 0;
}
}
private void btn_sel_xlDataFile_Click(object sender, EventArgs e)
{
this.ofd.Filter = Helper.Filter_Excel;
var ok = this.ofd.ShowDialog();
if (ok == DialogResult.OK)
{
this.txt_xlDataFile.Text = this.ofd.FileName;
oExcel.ExcelFile = this.txt_xlDataFile.Text;
oExcel.ExcelToDataSet();
fillData();
}
}
private void cbo_sheet_SelectedIndexChanged(object sender, EventArgs e)
{
this.oRx.SetData(this.oExcel.Ds.Tables[this.cbo_sheet.SelectedItem.ToString()].Copy());
this.colBindingSource.DataSource = this.oRx.FldSchema;
//this.dg_data.DataSource = this.oForm.Tbl;
}
private void btn_find_txt_Click(object sender, EventArgs e)
{
tbl_result = oRx.FindRx();
this.Gv_Result.DataSource = tbl_result;
if (this.tab_data.TabPages.Contains(Tp_Result) == false)
{
this.tab_data.TabPages.Add(Tp_Result);
this.tab_data.SelectedTab = Tp_Result;
};
}
private void btn_save_Click(object sender, EventArgs e)
{
var ok = this.sfd.ShowDialog();
if (ok == DialogResult.OK)
{
oExcel.ExportDataTableToExcel(tbl_result, this.sfd.FileName);
}
}
}
}