//데이터그리드뷰에서 정보선택시 이력서 출력
private void RESUMEInfo_CellClick(object sender, DataGridViewCellEventArgs e)
{
int re_num = int.Parse(RESUMEInfo[0, e.RowIndex].Value.ToString());
DataSet ds = new DataSet();
SqlConnection sqlcon = new SqlConnection(strconn);
try
{
sqlcon.Open();
//글번호가 같은 데이터를 불러온 후 WriteDetail폼에 전달
SqlCommand cmd = new SqlCommand("select * from RESUME where RE_NUM = @re_num", sqlcon);
cmd.Parameters.AddWithValue("@re_num", re_num);
SqlDataAdapter adpt = new SqlDataAdapter(cmd);
adpt.Fill(ds);
Show_Resume sr = new Show_Resume(ds);
//조회수 증가
//cmd = new SqlCommand("RecruitCountPlus", sqlcon);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@re_num", ds.Tables[0].Rows[0]["RE_NUM"]);
cmd.ExecuteNonQuery();
Log.printLog($"{re_num}번 이력서 글 조회");
sr.TopLevel = false;
sr.FormBorderStyle = FormBorderStyle.None;
sr.Dock = DockStyle.Fill;
this.Controls.Add(sr);
sr.BringToFront();
sr.Show();
}
catch
{
MessageBox.Show("에러");
}
finally
{
if (sqlcon != null)
{
sqlcon.Close();
}
}
}
private void show_resume_detail()
{
if (renum != null)
{
SqlConnection sqlcon = new SqlConnection(strconn);
sqlcon.Open();
Console.WriteLine("RE_NUM = " + renum);
SqlCommand cmd = new SqlCommand();
cmd.Connection = sqlcon;
DataSet ds = new DataSet();
SqlDataAdapter adpt = new SqlDataAdapter("select * from RESUME where RE_NUM=" + renum, sqlcon);
adpt.Fill(ds);
Show_Resume sr = new Show_Resume(ds);
sr.Show();
}
else
{
MessageBox.Show("글을 선택해주세요");
}
}