private void button7_Click(object sender, EventArgs e)//借用按钮 { BorrowClassRoom borrowClassRoom = new BorrowClassRoom() { clno = jyjs.Text, uname = syzxm.Text, weekday = xq.Text, period = jysj.Text, use = ytsm.Text, usestatus = 0 }; BorrowClassRoomBLL borrowClassRoomBLL = new BorrowClassRoomBLL(); if (borrowClassRoomBLL.Add(borrowClassRoom)) { MessageBox.Show("申请成功"); syzxm.Text = ""; ytsm.Text = ""; Weekday_Period_LoadList(); } else { MessageBox.Show("申请失败"); } }
/// <summary> /// 更新教室借用数据表的一条数据 /// </summary> /// <param name="course"></param> /// <returns></returns> public int Update(BorrowClassRoom borrowClassRoom) { string sql = "UPDATE BorrowClassRoom SET usestatus=@usestatus WHERE clno=@clno AND uname=@uname AND weekday=@weekday AND period=@period AND use=@use"; SQLiteParameter[] ps = { new SQLiteParameter("@clno", borrowClassRoom.clno), new SQLiteParameter("@uname", borrowClassRoom.uname), new SQLiteParameter("@weekday", borrowClassRoom.weekday), new SQLiteParameter("@period", borrowClassRoom.period), new SQLiteParameter("@use", borrowClassRoom.use), new SQLiteParameter("@usestatus", borrowClassRoom.usestatus) }; return(SqlHelper.ExecuteNonQuery(sql, ps)); }
/// <summary> /// 插入一条借用教室数据 /// </summary> /// <param name="borrowClassRoom">BorrowClassRoom对象</param> /// <returns>受影响行数</returns> public int Insert(BorrowClassRoom borrowClassRoom) { string sql = "INSERT INTO BorrowClassRoom (clno,uname,weekday,period,use,usestatus) Values(@clno,@uname,@weekday,@period,@use,@usestatus)"; SQLiteParameter[] ps = { new SQLiteParameter("@clno", borrowClassRoom.clno), new SQLiteParameter("@uname", borrowClassRoom.uname), new SQLiteParameter("@weekday", borrowClassRoom.weekday), new SQLiteParameter("@period", borrowClassRoom.period), new SQLiteParameter("@use", borrowClassRoom.use), new SQLiteParameter("@usestatus", borrowClassRoom.usestatus) }; return(SqlHelper.ExecuteNonQuery(sql, ps)); }
private void Remove_Click(object sender, EventArgs e)//删除申请 { var rows = BorrowClassRoomList.SelectedRows; if (rows.Count > 0) { DialogResult result = MessageBox.Show("确定要删除吗?", "提示", MessageBoxButtons.OKCancel); if (result == DialogResult.Cancel) { return; } BorrowClassRoom borrowClassRoom = new BorrowClassRoom() { clno = rows[0].Cells[0].Value.ToString(), uname = rows[0].Cells[1].Value.ToString(), weekday = rows[0].Cells[2].Value.ToString(), period = rows[0].Cells[3].Value.ToString(), use = rows[0].Cells[4].Value.ToString(), usestatus = Convert.ToInt32(rows[0].Cells[5].Value) }; BorrowClassRoomBLL borrowClassRoomBLL = new BorrowClassRoomBLL(); if (borrowClassRoomBLL.RemoveOne(borrowClassRoom)) { MessageBox.Show("删除成功"); LoadBorrowClassRoomList(); } else { MessageBox.Show("删除失败"); } } else { MessageBox.Show("请选择要删除的行"); } }
private void Agree_Click(object sender, EventArgs e)//同意申请 { var rows = BorrowClassRoomList.SelectedRows; if (rows.Count > 0) { DialogResult result = MessageBox.Show("确定要同意申请吗?", "提示", MessageBoxButtons.OKCancel); if (result == DialogResult.Cancel) { return; } BorrowClassRoom borrowClassRoom = new BorrowClassRoom() { clno = rows[0].Cells[0].Value.ToString(), uname = rows[0].Cells[1].Value.ToString(), weekday = rows[0].Cells[2].Value.ToString(), period = rows[0].Cells[3].Value.ToString(), use = rows[0].Cells[4].Value.ToString(), usestatus = 1 }; BorrowClassRoomBLL borrowClassRoomBLL = new BorrowClassRoomBLL(); if (borrowClassRoomBLL.Edit(borrowClassRoom)) { MessageBox.Show("同意申请完成"); LoadBorrowClassRoomList(); } else { MessageBox.Show("通过申请失败"); } } else { MessageBox.Show("请选择要通过申请的行"); } }
public bool Edit(BorrowClassRoom borrowClassRoom) { return(miDal.Update(borrowClassRoom) > 0); }
public bool RemoveOne(BorrowClassRoom borrowClassRoom) { return(miDal.DeleteOne(borrowClassRoom) > 0); }
public bool Add(BorrowClassRoom borrowClassRoom) { return(miDal.Insert(borrowClassRoom) > 0); }