// 불러오기 버튼 - data 불러옴
private void Load_Data_Button_Click(object sender, EventArgs e)
{
load_clicked = true;
Linelist_WCF.Service1Client client = new Linelist_WCF.Service1Client();
// combo box 값 선택 되었는지
string selected_item = load_data_select_combobox.SelectedItem as String;
if (selected_item != null)
{
string searchText = " ";
selected_setNumber = selected_item.Substring(0, selected_item.IndexOf(searchText));
}
else
{
selected_setNumber = "";
}
Debug.WriteLine("Selected Number: " + selected_setNumber);
if (selected_setNumber == "" || selected_setNumber == null)
{
load_clicked = false; Close();
} // combo box 값 선택되지 않음
else // combo box 값 선택 되었다면
{
int arrSize = client.Load_data_from_DB(selected_setNumber).Length;
int col = 19;
int row = arrSize / col;
string[][] dataArr = new string[arrSize][];
dataArr = client.Load_data_from_DB(selected_setNumber);
string[,] data = new string[row, col];
//int index = 0;
for (int r = 0; r < row; r++)
{
for (int c = 0; c < col; c++)
{
data[r, c] = dataArr[r][c];
//index++;
}
}
LineListForm.table.Clear();
DataRow dataRow = null;
for (int r = 0; r < row; r++)
{
dataRow = LineListForm.table.Rows.Add();
for (int c = 0; c < col; c++)
{
dataRow[c] = data[r, c];
}
}
}
Close();
}
private void comp_data1_combobox_SelectionChangeCommitted(object sender, EventArgs e)
{
dataGridView1.Rows.Clear();
Linelist_WCF.Service1Client client = new Linelist_WCF.Service1Client();
this.dataGridView1.VirtualMode = true;
click1 = true;
string setNumber1 = comp_data1_combobox.SelectedItem as string;
int count1 = comp_data1_combobox.Items.Count;
string[] set1 = new string[count1];
set1 = setNumber1.Split('/');
strarr1 = client.Load_data_from_DB(set1[0]);
this.dataGridView1.RowCount = strarr1.GetLength(0) + 1;
if (click2 == true && click1 == true)
{
foreach (DataGridViewRow row in dataGridView2.Rows)
{
foreach (DataGridViewColumn col in dataGridView2.Columns)
{
dataGridView2.Rows[row.Index].Cells[col.Index].Style.BackColor = Color.White;
}
}
compare(strarr1, strarr2, 0, dataGridView1, dataGridView2);
compare(strarr1, strarr2, 1, dataGridView2, dataGridView1);
//dataGridView2.Refresh();
}
client.Close();
}
//데이터 넣기
private void store(string item = "", DataTable dt = null, DataGridView dgv = null)
{
dt.Clear();
Linelist_WCF.Service1Client client = new Linelist_WCF.Service1Client();
int columnCounts = client.Load_data_from_DB(item).Length;
string[] dataArr = new string[columnCounts];
dataArr = client.Load_data_from_DB(item);
int col = client.Load_column_name().Length - 1;
int row = columnCounts / col;
string[,] data = new string[row, col];
for (int r = 0, index = 0; r < row; r++)
{
for (int c = 0; c < col; c++)
{
data[r, c] = dataArr[index];
index++;
}
}
DataRow dr = null;
for (int r = 0; r < row; r++)
{
dr = dt.Rows.Add();
for (int c = 0; c < col; c++)
{
dr[c + 1] = data[r, c];
}
}
client.Close();
}
