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