public static int insertRecord(roomBook obj)
{
string strSQL = "insert into roombook(username,roomid,begintime,endtime) values('" + obj.username + "','" + obj.roomid + "','" + obj.begintime + "','" + obj.endtime + "')";
int iRet = DBOper.execNonQueryBySQLText(strSQL);
return(iRet);
}
public static int deleteRecord(roomBook obj)
{
string strSQL = "delete from roombook where username='******' and roomid = '" + obj.roomid + "' and begintime = '" + obj.begintime + "' and endtime = '" + obj.endtime + "'";
int iRet = DBOper.execNonQueryBySQLText(strSQL);
return(iRet);
}
public static DataTable selectDataTable(roomBook obj)
{
string strSQL = "select roomid,roomnum from room where roomid in(select roomid from roombook where ( datediff(s,begintime, '" + obj.begintime + "' )<0)and(datediff(s,endtime,'" + obj.begintime + "')>0)and (datediff(s,begintime,'" + obj.endtime + "')<0) and (datediff(s,endtime,'" + obj.endtime + "')>0))";
//string strSQL = "select * from room where roomid in (select)"
//string strSQL = "select * from room where 1=1 ";
//if (obj.begintime != "" && obj.username != null)
// strSQL = strSQL + "and ='" + obj.username + "'";
//string strSQL = "select roomid,roomnum from room";
DataTable dt = DBOper.execQueryBySQLText(strSQL);
return(dt);
}
protected void gvcourse_RowCommand(object sender, GridViewCommandEventArgs e)
{
roomBook obj = new roomBook();
int i = roomBook.updateRecord(" update roombook set review='true' where bookid=" + e.CommandArgument.ToString());
int j = roomBook.updateRecord(" update roombook set adminname='管理员' where bookid=" + e.CommandArgument.ToString());
if (i == 1 & j == 1)
{
ComTool.Alert("审核成功！");
BindData1();
ComTool.Redirect("bookreview.aspx");
}
else
{
ComTool.Alert("审核失败！");
ComTool.Redirect("bookreview.aspx");
}
}
protected void add_Click(object sender, EventArgs e)
{
if (TextBox3.Text.Trim() == "")
{
ComTool.Alert("请输入用户名！");
}
else if (TextBox4.Text.Trim() == "")
{
ComTool.Alert("请输入要预约的会议室！");
}
else if (TextBox1.Text.Trim() == "")
{
ComTool.Alert("请输入会议开始时间！");
}
else if (TextBox2.Text.Trim() == "")
{
ComTool.Alert("请输入会议结束时间！");
}
else
{
roomBook obj = new roomBook();
obj.username = TextBox3.Text;
obj.roomid = TextBox4.Text;
obj.begintime = DateTime.Parse(TextBox1.Text);
obj.endtime = DateTime.Parse(TextBox2.Text);
if (roomBook.insertRecord(obj) == 1)
{
ComTool.Alert("预约成功！");
ComTool.Redirect("bookview.aspx");
}
else
{
ComTool.Alert("预约失败！");
}
}
}