public static bool addLessonPlan(MyLessonPlan lessonplan) { string constr = "Data Source=magic;Initial catalog=SuperCourse;Integrated Security=True"; SqlConnection conn = new SqlConnection(constr); conn.Open(); string insertStr = "insert into lessonplan values('" + lessonplan.Name + "','" + lessonplan.Xingqi + "','" + lessonplan.Time + "')"; SqlCommand sqlcommend = new SqlCommand(insertStr, conn); sqlcommend.CommandType = System.Data.CommandType.Text; int sdr; try { sdr = sqlcommend.ExecuteNonQuery(); } catch (Exception) { return(false); } finally { conn.Close(); } return(true); }
private void button1_Click(object sender, EventArgs e) { string xingqi = ""; if (radioButton1.Checked) { xingqi = "星期一"; } else if (radioButton2.Checked) { xingqi = "星期二"; } else if (radioButton3.Checked) { xingqi = "星期三"; } else if (radioButton4.Checked) { xingqi = "星期四"; } else if (radioButton5.Checked) { xingqi = "星期五"; } else { MessageBox.Show("请选择上课星期"); return; } string time = ""; if (radioButton6.Checked) { time = "8:00-10:00"; } else if (radioButton7.Checked) { time = "10:00-12:00"; } else if (radioButton8.Checked) { time = "14:00-16:00"; } else if (radioButton9.Checked) { time = "16:00-18:00"; } else if (radioButton10.Checked) { time = "18:30-21:00"; } else { MessageBox.Show("请选择上课时间"); return; } string lesson = (string)listBox1.SelectedValue; MyLessonPlan mylessonplan = new MyLessonPlan(lesson, xingqi, time); if (MyDataBaseModel.addLessonPlan(mylessonplan)) { MessageBox.Show("添加成功!!"); } else { MessageBox.Show("添加失败,您在该时段已经有课啦!"); } }