/// <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);
}
