西安培华学院本科毕业论文 基于.net开放实验室预约系统设计与实现
}
this.btYes.Click += new System.EventHandler(this.btYes_Click); this.btNo.Click += new System.EventHandler(this.btNo_Click); this.Load += new System.EventHandler(this.Page_Load);
#endregion
private void btSelect_Click(object sender, System.EventArgs e) { } Private
void
DataGrid2_SortCommand(object
source,
string condition = \
condition = \
condition += \condition += \DataView dv = new DataView(BookOperate.selectAllBook()); dv.RowFilter = condition; this.DataGrid2.DataSource = dv; this.DataGrid2.DataBind();
System.Web.UI.WebControls.DataGridSortCommandEventArgs e)
{
if(ViewState[\{ } else {
if(ViewState[\{ }
31
ViewState[\
ViewState[\
西安培华学院本科毕业论文 基于.net开放实验室预约系统设计与实现
}
else { }
ViewState[\
SqlConnection con = DB.creatConnection(); SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = new SqlCommand(\* from BookingDetail AS a JOIN
TeacherInfo AS b ON a.cTeacherID=b.cTeacherID\
DataSet ds = new DataSet(); sda.Fill(ds,\
ds.Tables[\
=
e.SortExpression+\
\
} private
void
DataGrid2_ItemDataBound(object
sender,
this.DataGrid2.DataKeyField = \
this.DataGrid2.DataSource = ds.Tables[\this.DataGrid2.Columns[7].Visible = false; this.DataGrid2.DataBind();
System.Web.UI.WebControls.DataGridItemEventArgs e)
{
if(e.Item.ItemType
==
ListItemType.Item||e.Item.ItemType
==
ListItemType.AlternatingItem)
{
e.Item.Attributes.Add(\
undColor='#99cc33'\
}
32
}
e.Item.Attributes.Add(\
西安培华学院本科毕业论文 基于.net开放实验室预约系统设计与实现
private void DataGrid2_PageIndexChanged(object source,
System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
private void btYes_Click(object sender, System.EventArgs e) {
foreach(System.Web.UI.WebControls.DataGridItem dl in this.DataGrid2.Items) {
CheckBox chk = (CheckBox)dl.FindControl(\if(chk.Checked) {
Book b = new Book();
b.labID = dl.Cells[0].Text.Trim(); b.week = dl.Cells[1].Text.Trim(); b.day = dl.Cells[2].Text.Trim(); b.lesson = dl.Cells[3].Text.Trim(); b.teaID = dl.Cells[7].Text.Trim(); b.admID = Session[\b.bookTeaState = \已通过\b.bookStuState = \已预约\b.bookAdmState = \已受理\if(BookOperate.chooseOperate(b)) {
Note n = new Note(); n.title = \预约成功\
n.text = b.labID+\您的预约
33
{ }
this.DataGrid2.CurrentPageIndex = e.NewPageIndex; this.BindToDataGrid();
西安培华学院本科毕业论文 基于.net开放实验室预约系统设计与实现
已经成功\
n.who = b.teaID;
if(NoteOperate.insertOperate(n)) {
this.lbMessage.Text = \受理成功\this.lbMessage.Visible = true;
Response.Write(\lanauage='javascript'>alert('受理成功
')\
private void btNo_Click(object sender, System.EventArgs e) {
foreach(System.Web.UI.WebControls.DataGridItem dl in this.DataGrid2.Items) {
CheckBox chk = (CheckBox)dl.FindControl(\if(chk.Checked) {
Book b = new Book();
b.labID = dl.Cells[0].Text.Trim();
34
}
}
}
}
}
else { }
this.lbMessage.Text = \受理失败\this.lbMessage.Visible = true;
this.BindToDataGrid();
西安培华学院本科毕业论文 基于.net开放实验室预约系统设计与实现
思，您的预约失败\
功')\
}
b.week = dl.Cells[1].Text.Trim(); b.day = dl.Cells[2].Text.Trim(); b.lesson = dl.Cells[3].Text.Trim(); b.teaID = dl.Cells[7].Text.Trim(); b.admID = Session[\b.bookTeaState = \未通过\b.bookStuState = \预约失败\b.bookAdmState = \未受理\if(BookOperate.chooseOperate(b)) { Note n = new Note(); n.title = \预约失败\
n.text = b.labID+\不好意
n.who = b.teaID;
if(NoteOperate.insertOperate(n)) { this.lbMessage.Text = \不受理成功\ this.lbMessage.Visible = true;
Response.Write(\lanauage='javascript'>alert('不受理成
}
}
else { this.lbMessage.Text = \不受理失败\ this.lbMessage.Visible = true;
}
35