/// <summary> /// 添加学制的方法 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnAddxue_Click(object sender, EventArgs e) { SpeYearsModel model = new SpeYearsModel(); SpeYearsBLL SpeYear = new SpeYearsBLL(); if (string.IsNullOrEmpty(this.txtXueName.Text)) { MessageBox.Show("学制名称不能为空"); return; } if (string.IsNullOrEmpty(this.txtXueTime.Text)) { MessageBox.Show("学制时间不能为空"); return; } model.SpeYears_Name = this.txtXueName.Text; try { model.SpeYears_Years = Convert.ToInt32(this.txtXueTime.Text); } catch { MessageBox.Show("学制时间只能是正整数"); this.txtXueTime.Text = null; return; } SpeYear.AddSpeYears(model); GetAllSpeYear(); }
private void btndeletexue_Click(object sender, EventArgs e) { SpeYearsModel model = new SpeYearsModel(); SpeYearsBLL SpeYear = new SpeYearsBLL(); if (this.dataxuezhi.SelectedRows.Count > 0) { int ID = Convert.ToInt32(this.dataxuezhi.SelectedRows[0].Cells["学制编号"].Value); model.SpeYears_ID = ID; try { SpeYear.DeleSpeYears(model); GetAllSpeYear(); } catch { MessageBox.Show("删除失败"); } } }
/// <summary> /// 删除学制的数据访问方法 /// </summary> /// <param name="model">学制实体对象</param> public void DeleSpeYears(SpeYearsModel model) { string sql = "delete SpeYears where SpeYears_ID=@0"; SqlHelper.ExNonQuery(sql, "删除学制", model.SpeYears_ID); }
/// <summary> /// 添加学制的数据访问方法 /// </summary> /// <param name="model">学制实体对象</param> public void AddSpeYears(SpeYearsModel model) { string sql = "insert into SpeYears values(@0,@1)"; SqlHelper.ExNonQuery(sql, "添加学制", model.SpeYears_Name, model.SpeYears_Years); }
/// <summary> /// 删除学制业务 /// </summary> /// <param name="model">学制的实体对象</param> public void DeleSpeYears(SpeYearsModel model) { SpeYearsDAL SpeYear = new SpeYearsDAL(); SpeYear.DeleSpeYears(model); }
/// <summary> /// 添加学制业务 /// </summary> /// <param name="model">学制的实体对象</param> public void AddSpeYears(SpeYearsModel model) { SpeYearsDAL SpeYear = new SpeYearsDAL(); SpeYear.AddSpeYears(model); }