private void LoadLesson() { LessonDAO d = new LessonDAO(); DataSet set = d.GetAllLesson(); DataRow newRow; foreach (DataRow r in set.Tables[0].Rows) { newRow = tabLesson.NewRow(); newRow["Id"] = r["Id"]; newRow["Name"] = r["Name"]; newRow["Price"] = r["Price"]; newRow["Count"] = 0; newRow["PriceDiscount"] = 0; tabLesson.Rows.Add(newRow); } gridControl.DataSource = tabLesson; CustomerDAO cd = new CustomerDAO(); set = cd.GetAllCustomer(); lookUpEdit.Properties.DataSource = set.Tables[0]; }
private void simpleButtonAdd_Click(object sender, EventArgs e) { if (!CheckData()) { return; } if (tabLesson != null) { DataRow[] matchs = tabLesson.Select("Name='" + name + "'"); if (matchs.Length > 0) { MessageBox.Show("课程名称已经存在", "信息提示", MessageBoxButtons.OK); return; } } LessonBean b = new LessonBean(); b.Name = name; b.Price = price; b.TimeLength = timeLength; b.Description = description; LessonDAO d = new LessonDAO(); d.AddLesson(b); }
private void LoadData() { LessonDAO d = new LessonDAO(); DataSet set = d.GetAllLesson(); tabLesson = set.Tables[0]; gridCtrl.DataSource = tabLesson; }
public MsgBox lessonAdd(Lesson ls) { //建立主键 ls.ID = Guid.NewGuid().ToString(); //传到Dao层处理 MsgBox mb = new LessonDAO().insertLesson(ls); return(mb); }
public ControllerClass() { classDAO = new ClassDAO(); teacherDAO = new TeacherDAO(); pupilDAO = new PupilDAO(); lessonDAO = new LessonDAO(); junctionDAO = new JunctionDAO(); fullTextSearch = new FullTextSearch(); view = new ViewClass(classDAO.GetList(), lessonDAO.GetList()); //DAO<Junction>.RandomDB(classDAO, teacherDAO, lessonDAO, pupilDAO, junctionDAO); }
private void simpleButtonDelete_Click(object sender, EventArgs e) { if (id == -1) { MessageBox.Show("未选择课程", "信息提示", MessageBoxButtons.OK); return; } LessonBean b = new LessonBean(); b.Id = id; LessonDAO d = new LessonDAO(); d.DeleteLesson(b); LoadData(); }
private void LoadData() { LessonDAO d = new LessonDAO(); DataSet set = d.GetAllLesson(); DataRow newRow; foreach (DataRow r in set.Tables[0].Rows) { newRow = tabData.NewRow(); newRow["Id"] = r["Id"]; newRow["Name"] = r["Name"]; newRow["Price"] = r["Price"]; newRow["Count"] = 0; newRow["PriceDiscount"] = 0; tabData.Rows.Add(newRow); } gridCtrl.DataSource = tabData; }
public void setTopic(int lessonID) { int topicID = new LessonDAO().GetTopicID(lessonID); this.topic = new TopicDAO().GetByTopicID(topicID); }
public Lesson GetLessonById(string id) { LessonDAO dao = new LessonDAO(); return(dao.GetLessonById(id)); }
public List <Lesson> RetrieveAllLessons() { LessonDAO dao = new LessonDAO(); return(dao.RetrieveAllLessons()); }
public int GetLengthOfDB() { LessonDAO dao = new LessonDAO(); return(dao.GetLengthOfDB()); }
public LessonService() { lessonDAO = new LessonDAO(); }