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(); } }