private void btnDele_Click(object sender, EventArgs e) { JiangFaTypesBLL JiangFa = new JiangFaTypesBLL(); JiangFaTypesModel model = new JiangFaTypesModel(); if (this.dataGridView2.SelectedRows.Count > 0) { int ID = Convert.ToInt32(this.dataGridView2.SelectedRows[0].Cells["奖罚类型编号"].Value); model.PunishmentAwardTypes_ID = ID; JiangFa.DeleJiangFaTypes(model); GetAllJiangFaTypes(); } }
/// <summary> /// 添加奖罚类型 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnAdd_Click(object sender, EventArgs e) { JiangFaTypesModel model = new JiangFaTypesModel(); JiangFaTypesBLL JiangFa = new JiangFaTypesBLL(); string name = this.cboName.SelectedItem.ToString(); object max = JiangFa.GetMaxJiangFaTypes(); object min = JiangFa.GetMinJiangFaTypes(); int id = 0; if (name == "奖励") { if (string.IsNullOrEmpty(max.ToString())) { id = 1; } else if (Convert.ToInt32(max) < 0) { id = 1; } else { id = Convert.ToInt32(max) + 1; } } else { if (string.IsNullOrEmpty(min.ToString())) { id = -1; } else if (Convert.ToInt32(min) > 0) { id = -1; } else { id = Convert.ToInt32(min) - 1; } } model.PunishmentAwardTypes_ID = id; model.PunishmentAwardTypes_Name = this.txtName.Text; JiangFa.AddJiangFaTypes(model); GetAllJiangFaTypes(); }
/// <summary> /// 查询指定学生惩罚记录 /// </summary> /// <param name="model"></param> /// <returns></returns> public DataTable GetFaTypes(JiangFaTypesModel model) { return(JiangFa.GetFaTypes(model)); }
/// <summary> /// 删除奖罚类型的业务方法 /// </summary> /// <param name="model">奖罚类型的实体对象</param> public void DeleJiangFaTypes(JiangFaTypesModel model) { JiangFa.DeleJiangFaTypes(model); }
/// <summary> /// 添加奖罚类型的业务方法 /// </summary> /// <param name="model">奖罚类型的实体对象</param> public void AddJiangFaTypes(JiangFaTypesModel model) { JiangFa.AddJiangFaTypes(model); }
/// <summary> /// 查询指定学生奖励记录 /// </summary> /// <param name="model"></param> /// <returns></returns> public DataTable GetJiangTypes(JiangFaTypesModel model) { string sql = "select * from PunishmentAwardTypes where PunishmentAwardTypes_ID>0"; return(SqlHelper.GetDataTable(sql)); }
/// <summary> /// 删除奖罚类型的数据访问方法 /// </summary> /// <param name="model">奖罚类型的实体对象</param> public void DeleJiangFaTypes(JiangFaTypesModel model) { string sql = "delete PunishmentAwardTypes where PunishmentAwardTypes_ID=@0"; SqlHelper.ExNonQuery(sql, "删除奖罚类型", model.PunishmentAwardTypes_ID); }
/// <summary> /// 添加奖罚类型的数据访问方法 /// </summary> /// <param name="model">奖罚类型的实体对象</param> public void AddJiangFaTypes(JiangFaTypesModel model) { string sql = "insert into PunishmentAwardTypes values(@0,@1)"; SqlHelper.ExNonQuery(sql, "添加奖罚类型", model.PunishmentAwardTypes_ID, model.PunishmentAwardTypes_Name); }