public SearchDeptForm(Insa01BaseInfo frm2)
{
InitializeComponent();
frm1 = frm2;
this.FormBorderStyle = FormBorderStyle.FixedSingle;
dataGridView1.RowHeadersVisible = false;
pgOraConn = new OracleConnection($"Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST={dbIp})(PORT=1522)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME={dbName})));User ID={dbId};Password={dbPw};Connection Timeout=30;");
pgOraConn.Open();
}
//수정 및 connection 필요함
#region 사번테이블 EVENT CellMouseDoubleClick -- 통합
//인사기본 데이터 테이블 정보 더블클릭시 데이터 가져가기
private void sabunDataGridView_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
Insa01BaseInfo Insa01BaseInfo = new Insa01BaseInfo();
if (e.RowIndex >= 0)
{
DataGridViewRow row = this.sabunDataGridView.Rows[e.RowIndex];
getData = row.Cells["bas_empno"].Value.ToString();
IForm form = (IForm)tabControl1.SelectedTab.Controls[0];
form.InsaManagement = this;
form.DataGridView_Double_clicked();
}
////가족사항
//if (tabControl1.SelectedTab.TabIndex == 1)
//{
// DataGridViewRow row = this.sabunDataGridView.Rows[e.RowIndex];
// bas_empno_fam.Text = row.Cells["bas_empno"].Value.ToString();
// bas_name_fam.Text = row.Cells["bas_name"].Value.ToString();
// bas_pos_fam.Text = row.Cells["cd_codnms"].Value.ToString(); ;
// bas_dept_fam.Text = row.Cells["dept_name"].Value.ToString();
// famDataGridView.Rows.Clear();
// string searchsql = " select fam_codnms as fam_rel, fam_name, fam_bth, fam_ltg" +
// " from thrm_bas_psy, " +
// " thrm_fam_psy," +
// " (select cd_grpcd, cd_code, cd_codnms as fam_codnms " +
// " from tieas_cd_psy where cd_grpcd = 'REL') " +
// " where bas_empno = fam_empno(+) and fam_rel = cd_code" +
// " and bas_empno = '" + bas_empno_fam.Text + "'";
// try
// {
// OracleCommand cmd = new OracleCommand();
// cmd.Connection = pgOraConn;
// cmd.CommandText = searchsql;
// OracleDataReader rd2 = cmd.ExecuteReader();
// int cnt = 0;
// while (rd2.Read())
// {
// famDataGridView.Rows.Add(rd2["fam_rel"].ToString(), rd2["fam_name"].ToString(), rd2["fam_bth"].ToString(), rd2["fam_ltg"].ToString());
// cnt++;
// }
// }
// catch (Exception ex)
// {
// MessageBox.Show(ex.ToString());
// }
//}
////학력사항
//else if (tabControl1.SelectedTab.TabIndex == 2)
//{
// DataGridViewRow row = this.sabunDataGridView.Rows[e.RowIndex];
// bas_empno_edu.Text = row.Cells["bas_empno"].Value.ToString();
// bas_name_edu.Text = row.Cells["bas_name"].Value.ToString();
// bas_pos_edu.Text = row.Cells["cd_codnms"].Value.ToString(); ;
// bas_dept_edu.Text = row.Cells["dept_name"].Value.ToString();
// DateTimePicker dtp = new DateTimePicker();//해결필요함
// eduDataGridView.Rows.Clear();
// string searchsql = " select edu_empno, edu_loe, edu_endate, edu_gradate, edu_schnm, edu_dept, edu_degree, edu_grade, edu_gra, edu_last" +
// " from thrm_bas_psy," +
// " thrm_edu_psy" +
// " where bas_empno = edu_empno(+) " +
// " and bas_empno = '" + bas_empno_edu.Text + "'";
// MessageBox.Show("123123");
// try
// {
// OracleCommand cmd = new OracleCommand();
// cmd.Connection = pgOraConn;
// cmd.CommandText = searchsql;
// OracleDataReader rd3 = cmd.ExecuteReader();
// int cnt = 0;
// while (rd3.Read())
// {
// eduDataGridView.Rows.Add(rd3["edu_loe"].ToString(), rd3["edu_endate"].ToString(), rd3["edu_gradate"].ToString(), rd3["edu_schrm"].ToString(), rd3["edu_dept"].ToString(), rd3["edu_degree"].ToString(), rd3["edu_grade"].ToString(), rd3["edu_gra"].ToString());
// cnt++;
// }
// }
// catch (Exception ex)
// {
// MessageBox.Show(ex.ToString());
// }
//}
////상벌이력
//else if (tabControl1.SelectedTab.TabIndex == 3)
//{
//}
////경력사항
//else if (tabControl1.SelectedTab.TabIndex == 4)
//{
//}
////자격면허
//else if (tabControl1.SelectedTab.TabIndex == 5)
//{
//}
////외국어
//else if (tabControl1.SelectedTab.TabIndex == 6)
//{
//}
}
public search_address(Insa01BaseInfo fm)
{
InitializeComponent();
ff = fm;
}
