private void insertData()
{
SqlConnection sqlconn = new SqlConnection(strConn);
try
{
//쿼리문에서 COUNT랑 A_COUNT를 0으로 시작해야 조회및 지원수 자동증가가능
sqlconn.Open();
string cmdText = "Insert Into RECRUIT (W_NUM,ID,NAME,SUBJECT,COM_NAME,FIELD, PAY, W_PLACE," +
"W_DATE, PERIOD, W_CONTENT, COUNT, A_COUNT) VALUES(NEXT VALUE FOR W_NUMBER,@id,@name,@sbj,@com_name,@field,@pay,@w_place,@time,@dead,@w_content,0,0)";
SqlCommand cmd = new SqlCommand(cmdText, sqlconn);
int intPay = Convert.ToInt32(Menu1.getPay());
cmd.Parameters.AddWithValue("@id", MainForm.getID());
cmd.Parameters.AddWithValue("@name", MainForm.getName());
cmd.Parameters.AddWithValue("@sbj", Menu1.getSbj());
cmd.Parameters.AddWithValue("@com_name", MainForm.getCom_name());
cmd.Parameters.AddWithValue("@field", Menu1.getField());
cmd.Parameters.AddWithValue("@pay", (intPay * 10000));
//cmd.Parameters.AddWithValue("@start", Menu1.getStart());
//cmd.Parameters.AddWithValue("@finish", Menu1.getFinish());
cmd.Parameters.AddWithValue("@w_place", Menu1.getPlace());
cmd.Parameters.AddWithValue("@time", DateTime.Now);
cmd.Parameters.AddWithValue("@dead", Menu1.getDead());
cmd.Parameters.AddWithValue("@w_content", Menu1.getContent());
cmd.ExecuteNonQuery();
onYesExit();
}
catch (Exception ee)
{
Log.printLog("공고 등록 오류");
MessageBox.Show(ee.Message);
MessageBox.Show(ee.StackTrace);
}
finally
{
sqlconn.Close();
}
}