예제 #1
0
        private void checkPost()
        {
            while (true)
            {
                if (String.IsNullOrEmpty(Menu1.getSbj()) || String.IsNullOrWhiteSpace(Menu1.getSbj()) ||
                    String.IsNullOrEmpty(Menu1.getField()) || String.IsNullOrWhiteSpace(Menu1.getField()) ||
                    String.IsNullOrEmpty(Menu1.getPay()) || String.IsNullOrWhiteSpace(Menu1.getPay()) ||
                    String.IsNullOrEmpty(Menu1.getPlace()) || String.IsNullOrWhiteSpace(Menu1.getPlace()))
                {
                    MessageBox.Show("텍스트 박스에 문자를 삽입하여 주세요");
                    break;
                }

                /*
                 * if (Menu1.getStart().Date == Menu1.getFinish().Date || Menu1.getStart().Date == Menu1.getDead().Date)
                 * {
                 *    MessageBox.Show("날짜를 입력하세요");
                 *    break;
                 * }*/
                else
                {
                    insertData();
                    break;
                }
            }
        }
예제 #2
0
        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();
            }
        }