public ActionResult Download(FormCollection fc)
        {
            int status = CECRequest.StrToInt(fc["status"], 0);
            //会议ID
            int meetingId = CECRequest.StrToInt(CECRequest.GetQueryString("meetingid"), 0);



            switch (status)
            {
            case 1:
                //会前调查下载信息下载
            {
                #region ==
                var dtBeforeMeetingSurvey           = GetSurveyInfo(meetingId, "BeforeMeeting");
                var BeforeMeetingSurveyUserNameList = new List <string>();
                if (dtBeforeMeetingSurvey.Columns.Contains("UserName"))
                {
                    foreach (DataRow dr in dtBeforeMeetingSurvey.Rows)
                    {
                        BeforeMeetingSurveyUserNameList.Add(dr["UserName"].ToString());
                    }
                }
                if (dtBeforeMeetingSurvey != null && dtBeforeMeetingSurvey.Rows.Count > 0)
                {
                    StringBuilder strUserName = new StringBuilder();
                    foreach (string item in BeforeMeetingSurveyUserNameList)
                    {
                        if (!item.Equals("匿名"))
                        {
                            strUserName.Append("'" + item + "'");
                            strUserName.Append(",");
                        }
                    }
                    if (strUserName.Length > 0)
                    {
                        strUserName.Length -= 1;
                    }

                    DataTable dt;
                    if (dtBeforeMeetingSurvey.Columns.Contains("UserName"))
                    {
                        if (dtBeforeMeetingSurvey.Columns.Contains("Email"))
                        {
                            dtBeforeMeetingSurvey.Columns.Remove("Email");
                        }
                        if (dtBeforeMeetingSurvey.Columns.Contains("MobilePhone"))
                        {
                            dtBeforeMeetingSurvey.Columns.Remove("MobilePhone");
                        }
                        if (dtBeforeMeetingSurvey.Columns.Contains("RealName"))
                        {
                            dtBeforeMeetingSurvey.Columns.Remove("RealName");
                        }
                        dt = MergeDataTable(dtBeforeMeetingSurvey, DownLoadUserList(strUserName.ToString()), "UserName");
                    }
                    else
                    {
                        dt = dtBeforeMeetingSurvey;
                    }

                    if (dt != null)
                    {
                        if (dt.Columns.Contains("RealName"))
                        {
                            dt.Columns.Remove("RealName");
                        }
                        if (dt.Columns.Contains("地区"))
                        {
                            dt.Columns.Remove("地区");
                        }
                        if (dt.Columns.Contains("用户名"))
                        {
                            dt.Columns.Remove("用户名");
                        }
                        if (dt.Columns.Contains("邮编"))
                        {
                            dt.Columns.Remove("邮编");
                        }

                        if (dt.Columns.Contains("CreateTime"))
                        {
                            dt.Columns["CreateTime"].ColumnName = "timestamp";
                        }
                        if (dt.Columns.Contains("UserName"))
                        {
                            dt.Columns["UserName"].ColumnName = "User_id";
                        }

                        int indexColumn = dt.Columns.Count - 1;

                        if (dt.Columns.Contains("Name"))
                        {
                            dt.Columns["Name"].SetOrdinal(indexColumn);
                        }
                        if (dt.Columns.Contains("User_id"))
                        {
                            dt.Columns["User_id"].SetOrdinal(indexColumn);
                        }
                        if (dt.Columns.Contains("Email"))
                        {
                            dt.Columns["Email"].SetOrdinal(indexColumn);
                        }
                        if (dt.Columns.Contains("Position"))
                        {
                            dt.Columns["Position"].SetOrdinal(indexColumn);
                        }
                        if (dt.Columns.Contains("Department"))
                        {
                            dt.Columns["Department"].SetOrdinal(indexColumn);
                        }
                        if (dt.Columns.Contains("Company"))
                        {
                            dt.Columns["Company"].SetOrdinal(indexColumn);
                        }
                        if (dt.Columns.Contains("Province"))
                        {
                            dt.Columns["Province"].SetOrdinal(indexColumn);
                        }
                        if (dt.Columns.Contains("City"))
                        {
                            dt.Columns["City"].SetOrdinal(indexColumn);
                        }
                        if (dt.Columns.Contains("District"))
                        {
                            dt.Columns["District"].SetOrdinal(indexColumn);
                        }
                        if (dt.Columns.Contains("Address"))
                        {
                            dt.Columns["Address"].SetOrdinal(indexColumn);
                        }
                        if (dt.Columns.Contains("Tele"))
                        {
                            dt.Columns["Tele"].SetOrdinal(indexColumn);
                        }
                        if (dt.Columns.Contains("MobilePhone"))
                        {
                            dt.Columns["MobilePhone"].SetOrdinal(indexColumn);
                        }
                        if (dt.Columns.Contains("Postal_Code"))
                        {
                            dt.Columns["Postal_Code"].SetOrdinal(indexColumn);
                        }
                        if (dt.Columns.Contains("timestamp"))
                        {
                            dt.Columns["timestamp"].SetOrdinal(indexColumn);
                        }
                        if (dt.Columns.Contains("UserID"))
                        {
                            dt.Columns["UserID"].SetOrdinal(indexColumn);
                        }
                        if (dt.Columns.Contains("FamilyName"))
                        {
                            dt.Columns["FamilyName"].SetOrdinal(indexColumn);
                        }
                        if (dt.Columns.Contains("GivenName"))
                        {
                            dt.Columns["GivenName"].SetOrdinal(indexColumn);
                        }
                        if (dt.Columns.Contains("Guid"))
                        {
                            dt.Columns["Guid"].SetOrdinal(indexColumn);
                        }

                        DataTableToCSV(dt);
                    }
                }
                else
                {
                    ViewBag.Msg = "暂无任何信息可下载!";
                }
                #endregion
            }
            break;

            case 2:
                //会后调查下载信息下载
            {
                #region ==
                var dtAfterMeetingSurvey           = GetSurveyInfo(meetingId, "AfterMeeting");
                var AfterMeetingSurveyUserNameList = new List <string>();
                if (dtAfterMeetingSurvey.Columns.Contains("UserName"))
                {
                    foreach (DataRow dr in dtAfterMeetingSurvey.Rows)
                    {
                        AfterMeetingSurveyUserNameList.Add(dr["UserName"].ToString());
                    }
                }


                if (dtAfterMeetingSurvey != null && dtAfterMeetingSurvey.Rows.Count > 0)
                {
                    StringBuilder strUserName = new StringBuilder();
                    foreach (string item in AfterMeetingSurveyUserNameList)
                    {
                        if (!item.Equals("匿名"))
                        {
                            strUserName.Append("'" + item + "'");
                            strUserName.Append(",");
                        }
                    }
                    if (strUserName.Length > 0)
                    {
                        strUserName.Length -= 1;
                    }

                    DataTable dt;
                    if (dtAfterMeetingSurvey.Columns.Contains("UserName"))
                    {
                        if (dtAfterMeetingSurvey.Columns.Contains("Email"))
                        {
                            dtAfterMeetingSurvey.Columns.Remove("Email");
                        }
                        if (dtAfterMeetingSurvey.Columns.Contains("MobilePhone"))
                        {
                            dtAfterMeetingSurvey.Columns.Remove("MobilePhone");
                        }
                        if (dtAfterMeetingSurvey.Columns.Contains("RealName"))
                        {
                            dtAfterMeetingSurvey.Columns.Remove("RealName");
                        }
                        dt = MergeDataTable(dtAfterMeetingSurvey, DownLoadUserList(strUserName.ToString()), "UserName");
                    }
                    else
                    {
                        dt = dtAfterMeetingSurvey;
                    }

                    if (dt != null)
                    {
                        if (dt.Columns.Contains("RealName"))
                        {
                            dt.Columns.Remove("RealName");
                        }
                        if (dt.Columns.Contains("地区"))
                        {
                            dt.Columns.Remove("地区");
                        }
                        if (dt.Columns.Contains("用户名"))
                        {
                            dt.Columns.Remove("用户名");
                        }
                        if (dt.Columns.Contains("邮编"))
                        {
                            dt.Columns.Remove("邮编");
                        }

                        if (dt.Columns.Contains("CreateTime"))
                        {
                            dt.Columns["CreateTime"].ColumnName = "timestamp";
                        }
                        if (dt.Columns.Contains("UserName"))
                        {
                            dt.Columns["UserName"].ColumnName = "User_id";
                        }

                        int indexColumn = dt.Columns.Count - 1;

                        if (dt.Columns.Contains("Name"))
                        {
                            dt.Columns["Name"].SetOrdinal(indexColumn);
                        }
                        if (dt.Columns.Contains("User_id"))
                        {
                            dt.Columns["User_id"].SetOrdinal(indexColumn);
                        }
                        if (dt.Columns.Contains("Email"))
                        {
                            dt.Columns["Email"].SetOrdinal(indexColumn);
                        }
                        if (dt.Columns.Contains("Position"))
                        {
                            dt.Columns["Position"].SetOrdinal(indexColumn);
                        }
                        if (dt.Columns.Contains("Department"))
                        {
                            dt.Columns["Department"].SetOrdinal(indexColumn);
                        }
                        if (dt.Columns.Contains("Company"))
                        {
                            dt.Columns["Company"].SetOrdinal(indexColumn);
                        }
                        if (dt.Columns.Contains("Province"))
                        {
                            dt.Columns["Province"].SetOrdinal(indexColumn);
                        }
                        if (dt.Columns.Contains("City"))
                        {
                            dt.Columns["City"].SetOrdinal(indexColumn);
                        }
                        if (dt.Columns.Contains("District"))
                        {
                            dt.Columns["District"].SetOrdinal(indexColumn);
                        }
                        if (dt.Columns.Contains("Address"))
                        {
                            dt.Columns["Address"].SetOrdinal(indexColumn);
                        }
                        if (dt.Columns.Contains("Tele"))
                        {
                            dt.Columns["Tele"].SetOrdinal(indexColumn);
                        }
                        if (dt.Columns.Contains("MobilePhone"))
                        {
                            dt.Columns["MobilePhone"].SetOrdinal(indexColumn);
                        }
                        if (dt.Columns.Contains("Postal_Code"))
                        {
                            dt.Columns["Postal_Code"].SetOrdinal(indexColumn);
                        }
                        if (dt.Columns.Contains("timestamp"))
                        {
                            dt.Columns["timestamp"].SetOrdinal(indexColumn);
                        }
                        if (dt.Columns.Contains("UserID"))
                        {
                            dt.Columns["UserID"].SetOrdinal(indexColumn);
                        }
                        if (dt.Columns.Contains("FamilyName"))
                        {
                            dt.Columns["FamilyName"].SetOrdinal(indexColumn);
                        }
                        if (dt.Columns.Contains("GivenName"))
                        {
                            dt.Columns["GivenName"].SetOrdinal(indexColumn);
                        }
                        if (dt.Columns.Contains("Guid"))
                        {
                            dt.Columns["Guid"].SetOrdinal(indexColumn);
                        }

                        DataTableToCSV(dt);
                    }
                }
                else
                {
                    ViewBag.Msg = "暂无任何信息可下载!";
                }
                #endregion
            }
            break;

            case 3:
                //QA相关信息下载
            {
                #region ==
                var          dtQuestion = new DataTable();
                Action <int> fbQuestion = (mid) => {
                    DataSet      ds = new DataSet();
                    StringReader sr = new StringReader(
                        Goodspeed.Common.CharHelper.GetWebPage(
                            string.Format("http://webcast.planteng.cn/QuestionXmlList.aspx?MeetingID={0}", mid), false, Encoding.UTF8)
                        );
                    ds.ReadXml(sr);
                    if (ds.Tables.Count > 0)
                    {
                        dtQuestion = ds.Tables[0];
                    }
                };
                fbQuestion(meetingId);

                var QuestionUserNameList = new List <string>();
                if (dtQuestion.Columns.Contains("UserName"))
                {
                    foreach (DataRow dr in dtQuestion.Rows)
                    {
                        QuestionUserNameList.Add(dr["UserName"].ToString());
                    }
                }

                if (dtQuestion != null && dtQuestion.Rows.Count > 0)
                {
                    StringBuilder strUserName = new StringBuilder();
                    foreach (string item in QuestionUserNameList)
                    {
                        if (!item.Equals("匿名"))
                        {
                            strUserName.Append("'" + item + "'");
                            strUserName.Append(",");
                        }
                    }
                    if (strUserName.Length > 0)
                    {
                        strUserName.Length -= 1;
                    }

                    DataTable dt = new DataTable();
                    if (dtQuestion.Columns.Contains("UserName"))
                    {
                        if (dtQuestion.Columns.Contains("Email"))
                        {
                            dtQuestion.Columns.Remove("Email");
                        }
                        if (dtQuestion.Columns.Contains("MobilePhone"))
                        {
                            dtQuestion.Columns.Remove("MobilePhone");
                        }
                        if (dtQuestion.Columns.Contains("RealName"))
                        {
                            dtQuestion.Columns.Remove("RealName");
                        }
                        dt = MergeDataTable(dtQuestion, DownLoadUserList(strUserName.ToString()), "UserName");
                    }
                    else
                    {
                        dt = dtQuestion;
                    }

                    if (dt != null)
                    {
                        if (dt.Columns.Contains("RealName"))
                        {
                            dt.Columns.Remove("RealName");
                        }
                        if (dt.Columns.Contains("isDistillate"))
                        {
                            dt.Columns.Remove("isDistillate");
                        }
                        if (dt.Columns.Contains("OperationTime"))
                        {
                            dt.Columns.Remove("OperationTime");
                        }
                        if (dt.Columns.Contains("AnswerUserID"))
                        {
                            dt.Columns.Remove("AnswerUserID");
                        }
                        if (dt.Columns.Contains("StartTime"))
                        {
                            dt.Columns.Remove("StartTime");
                        }
                        if (dt.Columns.Contains("UserID"))
                        {
                            dt.Columns.Remove("UserID");
                        }
                        if (dt.Columns.Contains("IsInReply"))
                        {
                            dt.Columns.Remove("IsInReply");
                        }
                        if (dt.Columns.Contains("ReplyUserName"))
                        {
                            dt.Columns.Remove("ReplyUserName");
                        }

                        if (dt.Columns.Contains("UserName"))
                        {
                            dt.Columns["UserName"].ColumnName = "Webuser_ID";
                        }
                        if (dt.Columns.Contains("QuestionContent"))
                        {
                            dt.Columns["QuestionContent"].ColumnName = "Question_Details";
                        }
                        if (dt.Columns.Contains("QuestionTime"))
                        {
                            dt.Columns["QuestionTime"].ColumnName = "Question_Time";
                        }

                        if (dt.Columns.Contains("isReply"))
                        {
                            dt.Columns["isReply"].SetOrdinal(2);
                        }
                        if (dt.Columns.Contains("isDirect"))
                        {
                            dt.Columns["isDirect"].SetOrdinal(2);
                        }
                        if (dt.Columns.Contains("isEmcee"))
                        {
                            dt.Columns["isEmcee"].SetOrdinal(2);
                        }
                        if (dt.Columns.Contains("isPublic"))
                        {
                            dt.Columns["isPublic"].SetOrdinal(2);
                        }
                        if (dt.Columns.Contains("Question_Time"))
                        {
                            dt.Columns["Question_Time"].SetOrdinal(2);
                        }
                        if (dt.Columns.Contains("Postal_Code"))
                        {
                            dt.Columns["Postal_Code"].SetOrdinal(2);
                        }
                        if (dt.Columns.Contains("Address"))
                        {
                            dt.Columns["Address"].SetOrdinal(2);
                        }
                        if (dt.Columns.Contains("Tele"))
                        {
                            dt.Columns["Tele"].SetOrdinal(2);
                        }
                        if (dt.Columns.Contains("District"))
                        {
                            dt.Columns["District"].SetOrdinal(2);
                        }
                        if (dt.Columns.Contains("City"))
                        {
                            dt.Columns["City"].SetOrdinal(2);
                        }
                        if (dt.Columns.Contains("Province"))
                        {
                            dt.Columns["Province"].SetOrdinal(2);
                        }
                        if (dt.Columns.Contains("Company"))
                        {
                            dt.Columns["Company"].SetOrdinal(2);
                        }
                        if (dt.Columns.Contains("Department"))
                        {
                            dt.Columns["Department"].SetOrdinal(2);
                        }
                        if (dt.Columns.Contains("Position"))
                        {
                            dt.Columns["Position"].SetOrdinal(2);
                        }
                        if (dt.Columns.Contains("Question_Details"))
                        {
                            dt.Columns["Question_Details"].SetOrdinal(2);
                        }
                        if (dt.Columns.Contains("Email"))
                        {
                            dt.Columns["Email"].SetOrdinal(2);
                        }
                        if (dt.Columns.Contains("Name"))
                        {
                            dt.Columns["Name"].SetOrdinal(2);
                        }
                        if (dt.Columns.Contains("Webuser_ID"))
                        {
                            dt.Columns["Webuser_ID"].SetOrdinal(2);
                        }

                        DataTableToCSV(dt);
                    }
                }
                else
                {
                    ViewBag.Msg = "暂无任何信息可下载!";
                }
                #endregion
            }
            break;

            default:
            case 0:
                //会议相关人员信息下载
            {
                #region ==

                ///会议中的用户
                var          dtUserInMeeting = new DataTable();
                Action <int> fbUserInMeeting = (mid) =>
                {
                    DataSet      ds = new DataSet();
                    StringReader sr = new StringReader(
                        Goodspeed.Common.CharHelper.GetWebPage(
                            string.Format("http://webcast.planteng.cn/UserInMeetingXmlList.aspx?MeetingID={0}", mid),
                            false, Encoding.UTF8)
                        );
                    ds.ReadXml(sr);
                    if (ds.Tables.Count > 0)
                    {
                        dtUserInMeeting = ds.Tables[0];
                    }
                };
                fbUserInMeeting(meetingId);

                var UserInMeetingUserNameList = new List <string>();

                if (dtUserInMeeting.Columns.Contains("UserName"))
                {
                    foreach (DataRow dr in dtUserInMeeting.Rows)
                    {
                        UserInMeetingUserNameList.Add(dr["UserName"].ToString());
                    }
                }

                if (UserInMeetingUserNameList.Count > 0)
                {
                    StringBuilder strUserName = new StringBuilder();
                    foreach (string item in UserInMeetingUserNameList)
                    {
                        if (!item.Equals("匿名"))
                        {
                            strUserName.Append("'" + item + "'");
                            strUserName.Append(",");
                        }
                    }
                    if (strUserName.Length > 0)
                    {
                        strUserName.Length -= 1;
                    }

                    DataTable dt;
                    if (dtUserInMeeting.Columns.Contains("UserName"))
                    {
                        if (dtUserInMeeting.Columns.Contains("Email"))
                        {
                            dtUserInMeeting.Columns.Remove("Email");
                        }
                        if (dtUserInMeeting.Columns.Contains("MobilePhone"))
                        {
                            dtUserInMeeting.Columns.Remove("MobilePhone");
                        }
                        if (dtUserInMeeting.Columns.Contains("RealName"))
                        {
                            dtUserInMeeting.Columns.Remove("RealName");
                        }
                        dt = MergeDataTable(dtUserInMeeting, DownLoadUserList(strUserName.ToString()), "UserName");
                    }
                    else
                    {
                        dt = dtUserInMeeting;
                    }

                    if (dt != null)
                    {
                        //if (dt.Columns.Contains("RealName")) dt.Columns.Remove("RealName");
                        //if (dt.Columns.Contains("CompanyName")) dt.Columns.Remove("CompanyName");
                        if (dt.Columns.Contains("DepartmentName"))
                        {
                            dt.Columns.Remove("DepartmentName");
                        }
                        if (dt.Columns.Contains("LoginName"))
                        {
                            dt.Columns.Remove("LoginName");
                        }
                        //if (dt.Columns.Contains("Phone")) dt.Columns.Remove("Phone");
                        if (dt.Columns.Contains("PostNumber"))
                        {
                            dt.Columns.Remove("PostNumber");
                        }
                        if (dt.Columns.Contains("ProfessionalGrade"))
                        {
                            dt.Columns.Remove("ProfessionalGrade");
                        }
                        if (dt.Columns.Contains("Sex"))
                        {
                            dt.Columns.Remove("Sex");
                        }

                        if (dt.Columns.Contains("Name"))
                        {
                            dt.Columns["Name"].ColumnName = "Webuser_ID";
                        }
                        if (dt.Columns.Contains("UserName"))
                        {
                            dt.Columns["UserName"].ColumnName = "Name";
                        }
                        if (dt.Columns.Contains("SignUpTime"))
                        {
                            dt.Columns["SignUpTime"].ColumnName = "Register_Time";
                        }
                        if (dt.Columns.Contains("IsDirectOnline"))
                        {
                            dt.Columns["IsDirectOnline"].ColumnName = "直播时参会";
                        }
                        if (dt.Columns.Contains("IsSee"))
                        {
                            dt.Columns["IsSee"].ColumnName = "累计观看";
                        }
                        if (dt.Columns.Contains("hasQuestion"))
                        {
                            dt.Columns["hasQuestion"].ColumnName = "是否提问";
                        }

                        /*
                         * if (dt.Columns.Contains("GivenName")) dt.Columns["GivenName"].SetOrdinal(0);
                         * if (dt.Columns.Contains("FamilyName")) dt.Columns["FamilyName"].SetOrdinal(0);
                         * if (dt.Columns.Contains("Register_Time")) dt.Columns["Register_Time"].SetOrdinal(0);
                         * if (dt.Columns.Contains("Postal_Code")) dt.Columns["Postal_Code"].SetOrdinal(0);
                         * //if (dt.Columns.Contains("Address")) dt.Columns["Address"].SetOrdinal(0);
                         * if (dt.Columns.Contains("MobilePhone")) dt.Columns["MobilePhone"].SetOrdinal(0);
                         * if (dt.Columns.Contains("Tele")) dt.Columns["Tele"].SetOrdinal(0);
                         * if (dt.Columns.Contains("District")) dt.Columns["District"].SetOrdinal(0);
                         * //if (dt.Columns.Contains("City")) dt.Columns["City"].SetOrdinal(0);
                         * //if (dt.Columns.Contains("Province")) dt.Columns["Province"].SetOrdinal(0);
                         * if (dt.Columns.Contains("Company")) dt.Columns["Company"].SetOrdinal(0);
                         * if (dt.Columns.Contains("Department")) dt.Columns["Department"].SetOrdinal(0);
                         * //if (dt.Columns.Contains("Position")) dt.Columns["Position"].SetOrdinal(0);
                         * if (dt.Columns.Contains("是否提问")) dt.Columns["是否提问"].SetOrdinal(0);
                         * if (dt.Columns.Contains("累计观看")) dt.Columns["累计观看"].SetOrdinal(0);
                         * if (dt.Columns.Contains("直播时参会")) dt.Columns["直播时参会"].SetOrdinal(0);
                         * //if (dt.Columns.Contains("Email")) dt.Columns["Email"].SetOrdinal(0);
                         * if (dt.Columns.Contains("Name")) dt.Columns["Name"].SetOrdinal(0);
                         * if (dt.Columns.Contains("Webuser_ID")) dt.Columns["Webuser_ID"].SetOrdinal(0);
                         * if (dt.Columns.Contains("QuestionNum")) dt.Columns["QuestionNum"].SetOrdinal(0);
                         * if (dt.Columns.Contains("DirectOnlineTime")) dt.Columns["DirectOnlineTime"].SetOrdinal(0);
                         * if (dt.Columns.Contains("OnlineTime")) dt.Columns["OnlineTime"].SetOrdinal(0);
                         */
                        DataTableToCSV(dt);
                    }
                }
                else
                {
                    ViewBag.Msg = "暂无任何信息可下载!";
                }
                #endregion
            }
            break;
            }
            return(View());
        }