//绑定方法
public void Bind()
        {
            string meetingID = Request.Params["MeetingCountID"];
            string sql = "select [name],[startDate],[finishDate],[applyDate],[content]," +
                                 "case when [MettingType]=1 then '所有人员' else [participator] end as participator," +
                                 "case when [startDate]<getdate() and getdate()<[finishDate] then '正在进行' else case when getdate()<[startDate] then '未开始' else '已结束' end end as estate ,[BoardroomName]," +
                                 "[EmpName],[DeptName],[BranchName],[MeetingCount].[MeetingCountID],[Boardroom].[BoardroomID],[MeetingCount].[Servers],[MeetingCount].[Nature],"+
                                 "[MeetingCount].[participatorID],cast([MeetingUser].[DepID] as varchar(5))+'*'+cast([MeetingUser].[EmpID] as varchar(5)) as [IDS],[MeetingCount].[approve],[MeetingCount].[approveDate] " +
                         "from [MeetingCount] join [Boardroom] on [MeetingCount].[BoardroomID]=[Boardroom].[BoardroomID]" +
                                 "join [MeetingUser] on [MeetingCount].[MeetingUserID]=[MeetingUser].[MeetingUserID]" + 
                         "where MeetingCount.[MeetingCountID]=" + meetingID;
            ArrayList al = (new Meeting()).GetDataOdd(sql);
            nameLab.Text = al[0].ToString();
            startDateLab.Text = al[1].ToString();
            finishDateLab.Text = al[2].ToString();
            applyDateLab.Text = al[3].ToString();
            contentLab.Text = al[4].ToString();
            participatorLab.Text = al[5].ToString();
            estateLab.Text = al[6].ToString();
            BranchNameLab.Text = al[10].ToString();
            EmpNameLab.Text = al[8].ToString();
            DeptNameLab.Text = al[9].ToString();
            boardroomLab.Text = al[7].ToString();
            Label2.Text = al[11].ToString();//会议ID
            Label1.Text = al[12].ToString();//会议室ID
            serverLab.Text = al[13].ToString();
            NatureLab.Text = al[14].ToString();
            participator2Lab.Text = al[15].ToString();
            EmpIDs.Text = al[16].ToString();
            approveLab.Text = al[17].ToString();
            approveDateLab.Text = al[18].ToString();
            al.Clear();
        }