public bool InsertMockSemesterCheck(MockRecordInfoVO MockRecordInfo) //학년에 학기가 있는지 체크 { string sql = "SELECT COUNT(*) FROM MockRecords WHERE grade=@grade AND semester=@semester AND std_id=@std_id"; MySqlCommand cmd = new MySqlCommand(sql, conn); FillParameters_MockRecord(cmd, MockRecordInfo); if (Convert.ToInt32(cmd.ExecuteScalar()) == 1) { return(false); } else { return(true); } }
private void FillParameters_MockRecord(MySqlCommand cmd, MockRecordInfoVO MockRecordInfo) { MySqlParameter param1 = new MySqlParameter("grade", MySqlDbType.VarChar, 1); param1.Value = MockRecordInfo.grade; cmd.Parameters.Add(param1); MySqlParameter param2 = new MySqlParameter("semester", MySqlDbType.VarChar, 1); param2.Value = MockRecordInfo.semester; cmd.Parameters.Add(param2); MySqlParameter param3 = new MySqlParameter("korean", MySqlDbType.Double); param3.Value = MockRecordInfo.korean; cmd.Parameters.Add(param3); MySqlParameter param4 = new MySqlParameter("english", MySqlDbType.Double); param4.Value = MockRecordInfo.english; cmd.Parameters.Add(param4); MySqlParameter param5 = new MySqlParameter("math", MySqlDbType.Double); param5.Value = MockRecordInfo.math; cmd.Parameters.Add(param5); MySqlParameter param6 = new MySqlParameter("side_choice1", MySqlDbType.Double); param6.Value = MockRecordInfo.side_choice1; cmd.Parameters.Add(param6); MySqlParameter param7 = new MySqlParameter("side_choice2", MySqlDbType.Double); param7.Value = MockRecordInfo.side_choice2; cmd.Parameters.Add(param7); MySqlParameter param8 = new MySqlParameter("more_foreign", MySqlDbType.Double); param8.Value = MockRecordInfo.more_foreign; cmd.Parameters.Add(param8); MySqlParameter param9 = new MySqlParameter("std_id", MySqlDbType.VarChar, 10); param9.Value = MockRecordInfo.std_Id; cmd.Parameters.Add(param9); }
public void InsertMock(MockRecordInfoVO MockRecordInfo) { bool bCheck; bCheck = InsertMockGradeCheck(MockRecordInfo); if (!bCheck) { throw new Exception("해당 학년의 데이터는 이미 있습니다."); } bCheck = InsertMockSemesterCheck(MockRecordInfo); if (!bCheck) { throw new Exception("해당 학기의 데이터는 이미 있습니다."); } string sql = "INSERT INTO MockRecords(std_id, grade, semester, korean, english, math, side_choice1, side_choice2, more_foreign) " + "VALUES(@std_id, @grade, @semester, @korean, @english, @math, @side_choice1, @side_choice2, @more_foreign) "; MySqlCommand cmd = new MySqlCommand(sql, conn); FillParameters_MockRecord(cmd, MockRecordInfo); cmd.ExecuteNonQuery(); }