/// <summary>
        /// 导出到Word中
        /// </summary>
        public void ExportToDoc()
        {
            NetUserMission uMission = new NetUserMission();
            UserMission    uinfo    = new UserMission();

            DataTable     dt    = uMission.GetMissionDataSet("2", beginSearchDate, endSearchDate, KeyWord).Tables[0];
            StringBuilder sbXml = new StringBuilder();
            string        title = string.Empty;

            if (this.beginTime.Value == this.endTime.Value)
            {
                title = this.beginTime.Value + "工作任务列表";
            }
            else
            {
                title = "从" + this.beginTime.Value + "到" + this.endTime.Value + "的修改完成的列表";
            }
            sbXml.Append(title + "\t\t\t\t\n\n\n");
            sbXml.Append("编号\t\t\t\t任务内容\n\n");
            foreach (DataRow row in dt.Rows)
            {
                sbXml.Append(string.Format("{0}", "1"));

                sbXml.Append(string.Format("\t\t\t\t{0}\n\n", row["MissionDesc"]));
            }
            ExportData.ExportWebData("Word", title, sbXml);
        }
        public void ExportToDocByOffice()
        {
            NetUserMission uMission = new NetUserMission();

            string title = string.Empty;

            if (this.beginTime.Value == this.endTime.Value)
            {
                title = this.beginTime.Value + "工作任务列表";
            }
            else
            {
                title = "从" + this.beginTime.Value + "到" + this.endTime.Value + "的修改完成的列表";
            }

            DataTable dt = uMission.GetMissionDataSet("2", beginSearchDate, endSearchDate, KeyWord).Tables[0];

            NetChina.Common.ExportData.CreateWordFile(title, dt);

            string name = NetChina.Common.commonFun.uploadFile + "temp/已经完成任务列表.doc";

            NetChina.Common.ExportData.DoadLoadFile(Server.MapPath(name));
        }
        /// <summary>
        /// 获取数据集合
        /// </summary>
        /// <param name="IsSearch"></param>
        public void GetMissionList(bool IsSearch)
        {
            NetUserMission misBll  = new NetUserMission();
            UserMission    misInfo = new UserMission();

            #region 分页处理

            if (this.beginTime.Value.Trim() == "" || this.endTime.Value.Trim() == "")
            {
                this.endTime.Value   = System.DateTime.Now.ToString("yyyy-MM-dd");
                this.beginTime.Value = System.DateTime.Now.AddDays(-6).ToString("yyyy-MM-dd");
                beginSearchDate      = this.beginTime.Value;
                endSearchDate        = this.endTime.Value;
            }

            if (IsSearch)
            {
                beginSearchDate = Convert.ToDateTime(this.beginTime.Value).ToString("yyyy-MM-dd");
                endSearchDate   = Convert.ToDateTime(this.endTime.Value).ToString("yyyy-MM-dd");
                Status          = this.drop_Status.SelectedValue;
                UserId          = this.drop_UserList.SelectedValue;
                TypeMission     = this.drop_type.SelectedValue;
            }
            else
            {
                if (Request.QueryString["bd"] != null && Request.QueryString["ed"] != null)
                {
                    try
                    {
                        beginSearchDate = Convert.ToDateTime(Request.QueryString["bd"]).ToString("yyyy-MM-dd");
                        endSearchDate   = Convert.ToDateTime(Request.QueryString["ed"]).ToString("yyyy-MM-dd");
                    }
                    catch
                    {
                        beginSearchDate = System.DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd");
                        endSearchDate   = System.DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd");
                    }
                }
                else
                {
                    beginSearchDate = Convert.ToDateTime(this.beginTime.Value).ToString("yyyy-MM-dd");
                    endSearchDate   = Convert.ToDateTime(this.endTime.Value).ToString("yyyy-MM-dd");
                }
            }

            this.beginTime.Value = beginSearchDate;
            this.endTime.Value   = endSearchDate;

            int userCount   = misBll.GetMissionFYCount(UserId, Status, beginSearchDate, endSearchDate, "1", false, "", TypeMission);//获取分页总数
            int currentPage = 1;
            try
            {
                currentPage = Convert.ToInt32(Request.QueryString["page"]);
                if (currentPage > (userCount + PageSize - 1) / PageSize)
                {
                    currentPage = (userCount + PageSize - 1) / PageSize;
                }

                if (currentPage <= 0)
                {
                    currentPage = 1;
                }
            }
            catch
            {
                currentPage = 1;
            }
            #endregion
            tempTitle = "[" + this.drop_UserList.SelectedItem.Text + "]--" + this.drop_Status.SelectedItem.Text + "的任务列表";
            this.drop_Status.SelectedValue = Status;

            DataSet      ds   = misBll.GetMissionDataSet(UserId, Status, beginSearchDate, endSearchDate, PageSize, currentPage, "1", false, "", TypeMission);
            HtmlTableRow hrow = null;
            if (ds != null)
            {
                int uCount = ds.Tables[0].Rows.Count;
                if (uCount > 0)
                {
                    if (Session["userid"] != null)
                    {
                        if (Session["userid"].ToString() == UserId && Status == "0")
                        {
                            //如果是用户本人并且显示待执行的任务时

                            hrow = new HtmlTableRow();
                            //HtmlTableCell cel19 = GetHCell("人员", true);
                            //cel19.Width = "50";
                            //hrow.Cells.Add(cel19);

                            HtmlTableCell cell6 = GetHCell("待执行的任务内容", true);
                            cell6.Width = "610";

                            hrow.Cells.Add(cell6);

                            HtmlTableCell cell10 = GetHCell("<div  title='任务类型'>类型</div>", true);
                            cell10.Width = "50";
                            hrow.Cells.Add(cell10);

                            HtmlTableCell cel7 = GetHCell("<div  title='任务入库日期'>入库</div>", true);
                            cel7.Width = "40";
                            hrow.Cells.Add(cel7);
                            HtmlTableCell cel17 = GetHCell("<div  title='计划完成任务所需工时'>工时</div>", true);
                            cel17.Width = "40";
                            hrow.Cells.Add(cel17);

                            HtmlTableCell cel60 = GetHCell("操作", true);
                            cel60.Width = "80";
                            hrow.Cells.Add(cel60);

                            tbl_list.Rows.Add(hrow);


                            for (int i = 0; i < uCount; i++)
                            {
                                DataTable dt = ds.Tables[0];
                                hrow = new HtmlTableRow();
                                //string _personName = dt.Rows[i]["realName"].ToString();
                                string tempBH             = (1 + i).ToString();
                                string tempMissAttachment = string.Empty;
                                if (!string.IsNullOrEmpty(dt.Rows[i]["FilePath"].ToString()))
                                {
                                    tempMissAttachment = "<span style='padding-left:10px;'><a href='" + dt.Rows[i]["FilePath"].ToString() + "' target='_blank'><img src='/inc/images/download.jpg' border='0'/></a></span>";
                                }


                                string _content = "<div style='text-align:left;'><span id='div_mission_" + tempBH + "'>" + commonFun.replaceStr(dt.Rows[i]["MissionDesc"].ToString()) + tempMissAttachment + "</span>&nbsp;<span style='color:red;cursor:pointer;' onclick=\"setTxt('div_mission_" + tempBH + "')\">[复制]</span></div>";
                                //string _content = "<div style='text-align:left;'>" + dt.Rows[i]["MissionDesc"].ToString().Trim() + "</div>";
                                string _missionType = dt.Rows[i]["MissionType"].ToString().Trim();
                                string _workHour    = dt.Rows[i]["WorkHour"].ToString().Trim();
                                string _writedate   = dt.Rows[i]["WriteDate"].ToString().Trim();


                                string _operation = "<input  class=\"btn\" type=\"button\" value=\"开始执行\" onclick=\"doSomething('first','" + ds.Tables[0].Rows[i]["UserId"].ToString() + "','" + ds.Tables[0].Rows[i]["MissionId"].ToString() + "');\" />";



                                if (!string.IsNullOrEmpty(_writedate))
                                {
                                    _writedate = Convert.ToDateTime(_writedate).ToString("M-dd H:mm");
                                }

                                if (_missionType == "0")
                                {
                                    _missionType = "维护";
                                }
                                else if (_missionType == "1")
                                {
                                    _missionType = "开发";
                                }
                                else if (_missionType == "2")
                                {
                                    _missionType = "需求分析";
                                }
                                else if (_missionType == "3")
                                {
                                    _missionType = "系统设计";
                                }
                                string _personName = dt.Rows[i]["realName"].ToString();
                                hrow.Cells.Add(GetHCell(_content, false));     // 任务内容
                                hrow.Cells.Add(GetHCell(_missionType, false)); //任务类型
                                hrow.Cells.Add(GetHCell(_writedate, false));   //入库日期
                                hrow.Cells.Add(GetHCell(_workHour, false));    //计划工时

                                hrow.Cells.Add(GetHCell(_operation, false));   //操作


                                tbl_list.Rows.Add(hrow);
                            }
                        }
                        else
                        {
                            //所有人情况


                            hrow = new HtmlTableRow();
                            HtmlTableCell cel19 = GetHCell("人员", true);
                            cel19.Width = "50";
                            hrow.Cells.Add(cel19);

                            HtmlTableCell cell6 = GetHCell("正在执行的任务内容", true);
                            cell6.Width = "360";

                            hrow.Cells.Add(cell6);

                            HtmlTableCell cell10 = GetHCell("<div  title='任务类型'>类型</div>", true);
                            cell10.Width = "50";
                            hrow.Cells.Add(cell10);

                            HtmlTableCell cel7 = GetHCell("<div  title='任务入库日期'>入库</div>", true);
                            cel7.Width = "40";
                            hrow.Cells.Add(cel7);
                            HtmlTableCell cel17 = GetHCell("<div  title='计划完成任务所需工时'>工时</div>", true);
                            cel17.Width = "40";
                            hrow.Cells.Add(cel17);
                            HtmlTableCell cel2 = GetHCell("<div  title='任务开始执行的时间'>执行</div>", true);
                            cel2.Width = "40";
                            hrow.Cells.Add(cel2);

                            HtmlTableCell cel27 = GetHCell("<div  title='实际完成的任务进度'>实际</div>", true);
                            cel27.Width = "50";
                            hrow.Cells.Add(cel27);
                            HtmlTableCell cel3 = GetHCell("<div  title='计划完成的任务进度'>计划</div>", true);
                            cel3.Width = "50";
                            hrow.Cells.Add(cel3);
                            HtmlTableCell cel4 = GetHCell("<div  title='计划完成任务的时间'>计划</div>", true);
                            cel4.Width = "40";
                            hrow.Cells.Add(cel4);
                            HtmlTableCell cel8 = GetHCell("<div  title='实际完成任务的时间'>实际</div>", true);
                            cel3.Width = "40";
                            hrow.Cells.Add(cel8);

                            //HtmlTableCell cel6 = GetHCell("<div  title='任务目前状态'>状态</div>", true);
                            //cel6.Width = "40";
                            //hrow.Cells.Add(cel6);
                            //HtmlTableCell cel60 = GetHCell("操作", true);
                            //cel60.Width = "40";
                            //hrow.Cells.Add(cel60);

                            tbl_list.Rows.Add(hrow);


                            for (int i = 0; i < uCount; i++)
                            {
                                DataTable dt = ds.Tables[0];



                                hrow = new HtmlTableRow();
                                string _personName = dt.Rows[i]["realName"].ToString();

                                string tempBH             = (1 + i).ToString();
                                string tempMissAttachment = string.Empty;
                                if (!string.IsNullOrEmpty(dt.Rows[i]["FilePath"].ToString()))
                                {
                                    tempMissAttachment = "<span style='padding-left:10px;'><a href='" + dt.Rows[i]["FilePath"].ToString() + "' target='_blank'><img src='/inc/images/download.jpg' border='0'/></a></span>";
                                }


                                string _content = "<div style='text-align:left;'><span id='div_mission_" + tempBH + "'>" + commonFun.replaceStr(dt.Rows[i]["MissionDesc"].ToString()) + tempMissAttachment + "</span>&nbsp;<span style='color:red;cursor:pointer;' onclick=\"setTxt('div_mission_" + tempBH + "')\">[复制]</span></div>";
                                //string _content = "<div style='text-align:left;'>" + dt.Rows[i]["MissionDesc"].ToString().Trim() + "</div>";
                                string _missionType = dt.Rows[i]["MissionType"].ToString().Trim();
                                string _workHour    = dt.Rows[i]["WorkHour"].ToString().Trim();
                                string _writedate   = dt.Rows[i]["WriteDate"].ToString().Trim();

                                string _execDate          = dt.Rows[i]["ExecDate"].ToString().Trim();
                                string _realProcess       = dt.Rows[i]["RealProcess"].ToString().Trim();
                                string _planFinishProcess = dt.Rows[i]["PlanFinishProcess"].ToString().Trim();
                                string _planFinishDate    = dt.Rows[i]["PlanFinishDate"].ToString().Trim();
                                string _finishDate        = dt.Rows[i]["FinisthDate"].ToString();
                                //string _Status = dt.Rows[i]["ExecStatus"].ToString().Trim();

                                // string _realProcess = "30%";
                                //string _planFinishProcess = "50%";

                                //string _operation = "<input class=\"btn\" type=\"button\" value=\"完成\" onclick=\"doSomething('second','" + ds.Tables[0].Rows[i]["UserId"].ToString() + "','" + ds.Tables[0].Rows[i]["MissionId"].ToString() + "');\" />";


                                if (_realProcess != string.Empty && _realProcess != "0")
                                {
                                    _realProcess = " <div id='div_real1' style='width:50px; height:20px; left: 0px; top: 0px; position:relative; background-color:#EEEEEE;   border-color:#1E6BB2;  border-width:1px; border-style:solid;'> <div id='div_real2' style='width:" + _realProcess + "; height:100%;background:#4AAF4F;color:#0D00EF;text-align:center;  line-height:20px; position:absolute; z-index:-1;left:0px; '></div><div style='position:relative;font-weight:bold; z-index:2; text-align:center;padding-top:3px;'>" + _realProcess + "</div> </div>";
                                }
                                else
                                {
                                    _realProcess = string.Empty;
                                }

                                if (_planFinishProcess != string.Empty && _planFinishProcess != "0")
                                {
                                    _planFinishProcess = " <div id='div_plan1' style='width:50px; height:20px; left: 0px; top: 0px; position:relative; background-color:#EEEEEE;   border-color:#1E6BB2;  border-width:1px; border-style:solid;'><div id='div_plan2' style='width:" + _planFinishProcess + "; height:100%;background:#FF6600;color:#0D00EF;text-align:center; line-height:20px; position:absolute;left:0px; z-index:-1;'></div> <div style='position:relative; font-weight:bold; z-index:2; text-align:center;padding-top:3px;'>" + _planFinishProcess + "</div></div>";
                                }
                                else
                                {
                                    _planFinishProcess = string.Empty;
                                }

                                if (!string.IsNullOrEmpty(_execDate))
                                {
                                    _execDate = Convert.ToDateTime(_execDate).ToString("M-dd H:mm");
                                }
                                if (!string.IsNullOrEmpty(_finishDate))
                                {
                                    _finishDate = Convert.ToDateTime(_finishDate).ToString("M-dd H:mm");
                                }
                                if (!string.IsNullOrEmpty(_writedate))
                                {
                                    _writedate = Convert.ToDateTime(_writedate).ToString("M-dd H:mm");
                                }
                                if (!string.IsNullOrEmpty(_planFinishDate))
                                {
                                    _planFinishDate = Convert.ToDateTime(_planFinishDate).ToString("M-dd H:mm");
                                }
                                if (_missionType == "0")
                                {
                                    _missionType = "维护";
                                }
                                else if (_missionType == "1")
                                {
                                    _missionType = "开发";
                                }
                                else if (_missionType == "2")
                                {
                                    _missionType = "需求分析";
                                }
                                else if (_missionType == "3")
                                {
                                    _missionType = "系统设计";
                                }

                                //if (_Status == "0")
                                //{
                                //    _Status = "待执行";
                                //}
                                //else if (_Status == "1")
                                //{
                                //    _Status = "执行中";
                                //}
                                //else if (_Status == "2")
                                //{
                                //    _Status = "已完成";
                                //}
                                hrow.Cells.Add(GetHCell(_personName, false));        //人员姓名
                                hrow.Cells.Add(GetHCell(_content, false));           // 任务内容
                                hrow.Cells.Add(GetHCell(_missionType, false));       //任务类型
                                hrow.Cells.Add(GetHCell(_writedate, false));         //入库日期
                                hrow.Cells.Add(GetHCell(_workHour, false));          //计划工时
                                hrow.Cells.Add(GetHCell(_execDate, false));          //执行日期
                                hrow.Cells.Add(GetHCell(_realProcess, false));       //实际进度
                                hrow.Cells.Add(GetHCell(_planFinishProcess, false)); //计划工作进度

                                hrow.Cells.Add(GetHCell(_planFinishDate, false));    //计划结束时间
                                hrow.Cells.Add(GetHCell(_finishDate, false));        //实际结束时间
                                //hrow.Cells.Add(GetHCell(_Status, false));  //执行状态
                                //hrow.Cells.Add(GetHCell(_operation, false));//操作


                                tbl_list.Rows.Add(hrow);
                            }
                        }
                    }
                    else
                    {
                        Response.Redirect("/login.aspx");
                    }
                }
                else
                {
                    hrow = new HtmlTableRow();
                    string        tempNo = "温馨提示:没有任务信息!";
                    HtmlTableCell cell   = GetHCell(tempNo, false);
                    cell.Height = "35px;";
                    hrow.Cells.Add(cell);
                    tbl_list.Rows.Add(hrow);
                }
            }
            else
            {
            }

            string parms = "&bd=" + beginSearchDate + "&ed=" + endSearchDate + "&uid=" + UserId + "&st=" + Status + "&to=" + TypeMission;
            GetPage(userCount, PageSize, currentPage, parms);//获取分页文字
        }
        /// <summary>
        /// 获取数据集合
        /// </summary>
        /// <param name="IsSearch"></param>
        public void GetMissionList(bool IsSearch)
        {
            NetUserMission misBll  = new NetUserMission();
            UserMission    misInfo = new UserMission();


            #region 分页处理

            if (this.beginTime.Value.Trim() == "" || this.endTime.Value.Trim() == "")
            {
                this.endTime.Value   = System.DateTime.Now.ToString("yyyy-MM-dd");
                this.beginTime.Value = System.DateTime.Now.AddDays(-6).ToString("yyyy-MM-dd");
                beginSearchDate      = this.beginTime.Value;
                endSearchDate        = this.endTime.Value;
            }

            if (IsSearch)
            {
                beginSearchDate = Convert.ToDateTime(this.beginTime.Value).ToString("yyyy-MM-dd");
                endSearchDate   = Convert.ToDateTime(this.endTime.Value).ToString("yyyy-MM-dd");
                Status          = this.drop_Status.SelectedValue;
                UserId          = this.drop_UserList.SelectedValue;
                if (chk_IsAsigin.Checked)
                {
                    IsAsign = "1";
                }
                else
                {
                    IsAsign = "0";
                }
                //IsAsign = this.drop_IsAssign.SelectedValue;
                KeyWord     = this.txt_content.Value.Trim();
                TypeMission = this.drop_type.SelectedValue;
            }
            else
            {
                if (Request.QueryString["bd"] != null && Request.QueryString["ed"] != null)
                {
                    try
                    {
                        beginSearchDate = Convert.ToDateTime(Request.QueryString["bd"]).ToString("yyyy-MM-dd");
                        endSearchDate   = Convert.ToDateTime(Request.QueryString["ed"]).ToString("yyyy-MM-dd");
                    }
                    catch
                    {
                        beginSearchDate = System.DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd");
                        endSearchDate   = System.DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd");
                    }
                }
                else
                {
                    beginSearchDate = Convert.ToDateTime(this.beginTime.Value).ToString("yyyy-MM-dd");
                    endSearchDate   = Convert.ToDateTime(this.endTime.Value).ToString("yyyy-MM-dd");
                }
            }

            this.beginTime.Value = beginSearchDate;
            this.endTime.Value   = endSearchDate;

            int userCount   = misBll.GetMissionFYCount(UserId, Status, beginSearchDate, endSearchDate, IsAsign, true, KeyWord, TypeMission);//获取分页总数
            int currentPage = 1;
            try
            {
                currentPage = Convert.ToInt32(Request.QueryString["page"]);
                if (currentPage > (userCount + PageSize - 1) / PageSize)
                {
                    currentPage = (userCount + PageSize - 1) / PageSize;
                }

                if (currentPage <= 0)
                {
                    currentPage = 1;
                }
            }
            catch
            {
                currentPage = 1;
            }
            #endregion

            if (IsAsign == "1")
            {
                tempTitle = "[" + this.drop_UserList.SelectedItem.Text + "]--已经分配的任务列表";
            }
            else
            {
                tempTitle = "[" + this.drop_UserList.SelectedItem.Text + "]--未分配的任务列表";
            }
            this.drop_Status.SelectedValue = Status;
            DataSet ds = misBll.GetMissionDataSet(UserId, Status, beginSearchDate, endSearchDate, PageSize, currentPage, IsAsign, true, KeyWord, TypeMission);

            #region 重新构造数据显示格式
            if (ds == null || ds.Tables.Count == 0)
            {
                //this.Page_Load(null, null);
                HtmlTableRow  hrow  = new HtmlTableRow();
                HtmlTableCell hcell = GetHCell("温馨提示:该时间段没有任务!", false);
                //hcell.Attributes.Add("colspan", "12");

                hrow.Cells.Add(hcell);
                this.tbl_list.Rows.Add(hrow);
            }
            else
            {
                DataTableHelper dHelp = new DataTableHelper();
                DataRow[]       dv    = dHelp.SelectDistinct("result", ds.Tables[0], "userid").Select("1=1");
                if (dv.Length > 0)
                {
                    //创建表头
                    HtmlTableRow hrow = null;
                    hrow = new HtmlTableRow();

                    HtmlTableCell cel19 = GetHCell("人员", true);
                    cel19.Width = "50";
                    hrow.Cells.Add(cel19);

                    //if (Status == "0" || Status == "-1")
                    //{
                    HtmlTableCell cel5 = GetHCell("操作", true);
                    cel5.Width = "40";
                    hrow.Cells.Add(cel5);
                    //}

                    HtmlTableCell cell6 = GetHCell("任务内容", true);
                    //if (Status == "0" || Status == "-1")
                    //{
                    //    cell6.Width = "400";
                    //}
                    //else
                    //{
                    cell6.Width = "690";
                    //}
                    hrow.Cells.Add(cell6);

                    HtmlTableCell cell10 = GetHCell("类型", true);
                    cell10.Width = "70";
                    hrow.Cells.Add(cell10);

                    HtmlTableCell cel7 = GetHCell("<div  title='入库日期'>入库</div>", true);
                    cel7.Width = "40";
                    hrow.Cells.Add(cel7);
                    HtmlTableCell cel17 = GetHCell("<div  title='计划完成任务所需工时'>工时</div>", true);
                    cel17.Width = "40";
                    hrow.Cells.Add(cel17);
                    HtmlTableCell cel2 = GetHCell("<div  title='任务开始执行的时间'>执行</div>", true);
                    cel2.Width = "40";
                    hrow.Cells.Add(cel2);

                    HtmlTableCell cel27 = GetHCell("<div  title='实际完成的任务进度'>实际</div>", true);
                    cel27.Width = "50";
                    hrow.Cells.Add(cel27);
                    HtmlTableCell cel3 = GetHCell("<div  title='此刻计划应该完成的任务进度'>计划</div>", true);
                    cel3.Width = "50";
                    hrow.Cells.Add(cel3);
                    HtmlTableCell cel4 = GetHCell("<div  title='计划完成任务的时间'>计划</div>", true);
                    cel4.Width = "40";
                    hrow.Cells.Add(cel4);
                    HtmlTableCell cel8 = GetHCell("<div  title='实际完成任务的时间'>实际</div>", true);
                    cel8.Width = "40";
                    hrow.Cells.Add(cel8);

                    HtmlTableCell cel60 = GetHCell("状态", true);
                    cel60.Width = "30";
                    hrow.Cells.Add(cel60);

                    tbl_list.Rows.Add(hrow);


                    foreach (DataRow dr in dv)
                    {
                        DataTable dt      = dHelp.GetNewDataTable(ds.Tables[0], "userid=" + dr[0].ToString());
                        int       dtCount = dt.Rows.Count;
                        if (dtCount > 0)
                        {
                            int uCount = dt.Rows.Count;
                            if (uCount > 0)
                            {
                                for (int i = 0; i < uCount; i++)
                                {
                                    string tempBH        = (currentPage - 1) * PageSize + i + 1 + dr[0].ToString();
                                    string tempStatus    = string.Empty;//是否执行
                                    string tempStatusStr = string.Empty;
                                    hrow = new HtmlTableRow();
                                    //string realname = dt.Rows[i]["realName"].ToString();
                                    //if (string.IsNullOrEmpty(realname))
                                    //{
                                    //realname = "<font color=red>未分配</font>";
                                    //}
                                    //hrow.Cells.Add(GetHCell("" + realname + "", false));
                                    string personName = dt.Rows[i]["realName"].ToString();
                                    hrow.Cells.Add(GetHCell(personName, false));
                                    tempStatus = dt.Rows[i]["ExecStatus"].ToString();

                                    if (tempStatus == "0")
                                    {
                                        //if (IsAsign == "0")
                                        //{
                                        //    hrow.Cells.Add(GetHCell("<div><img onclick=\"deldata('" + dt.Rows[i]["MissionId"].ToString() + "','" + dt.Rows[i]["UserId"].ToString() + "')\" style='cursor:pointer;' alt='删除当前任务' src='../inc/images/album_del.gif' border='0'>&nbsp;<img alt='分配当前任务' style='cursor:pointer;' onclick=\"showDiv('" + dt.Rows[i]["MissionId"].ToString() + "')\" src='../inc/images/a_edit.gif' border='0'><img alt='修改当前任务' style='cursor:pointer;' onclick=\"showMission('" + dt.Rows[i]["MissionId"].ToString() + "','" + tempBH + "')\" src='../inc/images/iedit1.gif' border='0'></div>", false));
                                        //}
                                        //else
                                        //{
                                        hrow.Cells.Add(GetHCell("<div><img onclick=\"deldata('" + dt.Rows[i]["MissionId"].ToString() + "','" + dt.Rows[i]["UserId"].ToString() + "','" + dt.Rows[i]["FilePath"].ToString() + "')\" style='cursor:pointer;' alt='删除当前任务' src='../inc/images/album_del.gif' border='0'>&nbsp;<img alt='分配当前任务' style='cursor:pointer;' onclick=\"showDiv('" + dt.Rows[i]["MissionId"].ToString() + "')\" src='../inc/images/a_edit.gif' border='0'>&nbsp;<img alt='修改当前任务' style='cursor:pointer;' onclick=\"showMission('" + dt.Rows[i]["MissionId"].ToString() + "','" + tempBH + "')\" src='../inc/images/iedit1.gif' border='0'></div>", false));
                                        //}
                                    }
                                    else
                                    {
                                        //if (Status == "-1")
                                        //{
                                        if (tempStatus == "1")
                                        {
                                            hrow.Cells.Add(GetHCell("<div><img alt='变更当前任务人' style='cursor:pointer;' onclick=\"showDiv('" + dt.Rows[i]["MissionId"].ToString() + "')\" src='../inc/images/a_edit.gif' border='0'>&nbsp;<img alt='修改当前任务' style='cursor:pointer;' onclick=\"showMission('" + dt.Rows[i]["MissionId"].ToString() + "','" + tempBH + "')\" src='../inc/images/iedit1.gif' border='0'></div>", false));
                                        }
                                        else
                                        {
                                            hrow.Cells.Add(GetHCell("<div>无</div>", false));
                                        }
                                    }

                                    string tempMissAttachment = string.Empty;
                                    if (!string.IsNullOrEmpty(ds.Tables[0].Rows[i]["FilePath"].ToString()))
                                    {
                                        tempMissAttachment = "<span style='padding-left:10px;'><a href='" + dt.Rows[i]["FilePath"].ToString() + "' target='_blank'><img src='/inc/images/download.jpg' border='0'/></a></span>";
                                    }


                                    hrow.Cells.Add(GetHCell("<div style='text-align:left;'><span id='div_mission_" + tempBH + "'>" + commonFun.replaceStr(dt.Rows[i]["MissionDesc"].ToString()) + tempMissAttachment + "</span>&nbsp;<span style='color:red;cursor:pointer;' onclick=\"setTxt('div_mission_" + tempBH + "')\">[复制]</span></div>", false)); //描述

                                    if (tempStatus == "0")
                                    {
                                        tempStatusStr = "<img alt='待执行' src='../inc/images/red.gif' border='0'>";
                                    }
                                    else if (tempStatus == "1")
                                    {
                                        tempStatusStr = "<img alt='执行中' src='../inc/images/yellow.gif' border='0'>";
                                    }
                                    else if (tempStatus == "2")
                                    {
                                        tempStatusStr = "<img alt='已经完成' src='../inc/images/green.gif' border='0'>";
                                    }
                                    string writedate = dt.Rows[i]["WriteDate"].ToString();

                                    string execDate       = dt.Rows[i]["ExecDate"].ToString();
                                    string finishDate     = dt.Rows[i]["FinisthDate"].ToString();
                                    string planFinishDate = dt.Rows[i]["PlanFinishDate"].ToString();
                                    string _workHour      = dt.Rows[i]["WorkHour"].ToString();
                                    // int _realProcess = 0;
                                    // int _planFinishProcess = 0;
                                    // if (dt.Rows[i]["RealProcess"].ToString().Trim() != string.Empty)
                                    // {
                                    //     _realProcess =Convert.ToInt32( dt.Rows[i]["RealProcess"]);
                                    // }

                                    //if (dt.Rows[i]["PlanFinishProcess"].ToString().Trim()!=string.Empty)
                                    //{
                                    //    _planFinishProcess = Convert.ToInt32(dt.Rows[i]["PlanFinishProcess"]);
                                    //}

                                    string _realProcess = dt.Rows[i]["RealProcess"].ToString().Trim();

                                    string _planFinishProcess = dt.Rows[i]["PlanFinishProcess"].ToString().Trim();
                                    // string _realProcess = "30%";
                                    //string _planFinishProcess = "50%";
                                    if (_realProcess != string.Empty && _realProcess != "0")
                                    {
                                        _realProcess = " <div id='div_real1' style='width:50px; height:20px; left: 0px; top: 0px; position:relative; background-color:#EEEEEE;   border-color:#1E6BB2;  border-width:1px; border-style:solid;'> <div id='div_real2' style='width:" + _realProcess + "; height:100%;background:#4AAF4F;color:#0D00EF;text-align:center;  line-height:20px; position:absolute; z-index:-1;left:0px; '></div><div style='position:relative;font-weight:bold; z-index:2; text-align:center;padding-top:3px;'>" + _realProcess + "</div> </div>";
                                    }
                                    else
                                    {
                                        _realProcess = string.Empty;
                                    }

                                    if (_planFinishProcess != string.Empty && _planFinishProcess != "0")
                                    {
                                        _planFinishProcess = " <div id='div_plan1' style='width:50px; height:20px; left: 0px; top: 0px; position:relative; background-color:#EEEEEE;   border-color:#1E6BB2;  border-width:1px; border-style:solid;'><div id='div_plan2' style='width:" + _planFinishProcess + "; height:100%;background:#FF6600;color:#0D00EF;text-align:center; line-height:20px; position:absolute;left:0px; z-index:-1;'></div> <div style='position:relative; font-weight:bold; z-index:2; text-align:center;padding-top:3px;'>" + _planFinishProcess + "</div></div>";
                                    }
                                    else
                                    {
                                        _planFinishProcess = string.Empty;
                                    }

                                    if (!string.IsNullOrEmpty(execDate))
                                    {
                                        execDate = Convert.ToDateTime(execDate).ToString("M-dd H:mm");
                                    }
                                    if (!string.IsNullOrEmpty(finishDate))
                                    {
                                        finishDate = Convert.ToDateTime(finishDate).ToString("M-dd H:mm");
                                    }
                                    if (!string.IsNullOrEmpty(writedate))
                                    {
                                        writedate = Convert.ToDateTime(writedate).ToString("M-dd H:mm");
                                    }
                                    if (!string.IsNullOrEmpty(planFinishDate))
                                    {
                                        planFinishDate = Convert.ToDateTime(planFinishDate).ToString("M-dd H:mm");
                                    }
                                    string _missionType = string.Empty;
                                    if (dt.Rows[i]["MissionType"].ToString() == "0")
                                    {
                                        _missionType = "维护";
                                    }
                                    else if (dt.Rows[i]["MissionType"].ToString() == "1")
                                    {
                                        _missionType = "开发";
                                    }
                                    else if (dt.Rows[i]["MissionType"].ToString() == "2")
                                    {
                                        _missionType = "需求分析";
                                    }
                                    else if (dt.Rows[i]["MissionType"].ToString() == "3")
                                    {
                                        _missionType = "系统设计";
                                    }


                                    //显示数据
                                    hrow.Cells.Add(GetHCell(_missionType, false));       //任务类型
                                    hrow.Cells.Add(GetHCell(writedate, false));          //入库日期
                                    hrow.Cells.Add(GetHCell(_workHour, false));          //计划工时
                                    hrow.Cells.Add(GetHCell(execDate, false));           //执行日期
                                    hrow.Cells.Add(GetHCell(_realProcess, false));       //实际进度
                                    hrow.Cells.Add(GetHCell(_planFinishProcess, false)); //计划工作进度

                                    hrow.Cells.Add(GetHCell(planFinishDate, false));     //计划结束时间
                                    hrow.Cells.Add(GetHCell(finishDate, false));         //结束日期

                                    hrow.Cells.Add(GetHCell(tempStatusStr, false));      //执行状态


                                    tbl_list.Rows.Add(hrow);
                                }
                            }
                            else
                            {
                                hrow = new HtmlTableRow();
                                HtmlTableCell hcell = GetHCell("温馨提示:该时间段没有任何任务!", false);
                                hcell.Attributes.Add("colspan", "12");
                                hrow.Cells.Add(hcell);

                                tbl_list.Rows.Add(hrow);
                            }
                        }
                        else
                        {
                            hrow = new HtmlTableRow();
                            HtmlTableCell hcell = GetHCell("温馨提示:该时间段没有任何任务!", false);
                            hcell.Attributes.Add("colspan", "12");
                            hrow.Cells.Add(hcell);

                            tbl_list.Rows.Add(hrow);
                        }
                    }
                }
                else
                {
                    HtmlTableRow  hrow  = new HtmlTableRow();
                    HtmlTableCell hcell = GetHCell("温馨提示:该时间段没有任何任务!", false);
                    //hcell.Attributes.Add("colspan", "12");
                    hrow.Cells.Add(hcell);

                    tbl_list.Rows.Add(hrow);
                }
            }
            #endregion

            #region 数据显示方式 原来的

            //HtmlTableRow hrow = null;
            //if (ds != null)
            //{

            //    hrow = new HtmlTableRow();

            //    HtmlTableCell cel1 = GetHCell("任务人", true);
            //    cel1.Width = "60";
            //    hrow.Cells.Add(cel1);

            //    HtmlTableCell cell6 = GetHCell("任务内容", true);
            //    if (Status == "0" || Status == "-1")
            //    {
            //        cell6.Width = "560";
            //    }
            //    else
            //    {
            //        cell6.Width = "600";
            //    }
            //    hrow.Cells.Add(cell6);

            //    HtmlTableCell cel7 = GetHCell("入库日期", true);
            //    cel7.Width = "70";
            //    hrow.Cells.Add(cel7);

            //    HtmlTableCell cel2 = GetHCell("执行时间", true);
            //    cel2.Width = "70";
            //    hrow.Cells.Add(cel2);

            //    HtmlTableCell cel3 = GetHCell("结束日期", true);
            //    cel3.Width = "70";
            //    hrow.Cells.Add(cel3);



            //    HtmlTableCell cel4 = GetHCell("状态", true);
            //    cel4.Width = "40";
            //    hrow.Cells.Add(cel4);

            //    if (Status == "0" || Status == "-1")
            //    {
            //        HtmlTableCell cel5 = GetHCell("操作", true);
            //        cel5.Width = "30";
            //        hrow.Cells.Add(cel5);
            //    }

            //    tbl_list.Rows.Add(hrow);

            //    int uCount = ds.Tables[0].Rows.Count;
            //    if (uCount > 0)
            //    {
            //        for (int i = 0; i < uCount; i++)
            //        {

            //            string tempStatus = string.Empty;//是否执行
            //            string tempStatusStr = string.Empty;
            //            hrow = new HtmlTableRow();
            //            string realname = ds.Tables[0].Rows[i]["realName"].ToString();
            //            if (string.IsNullOrEmpty(realname))
            //            {
            //                realname = "<font color=red>未分配</font>";
            //            }
            //            hrow.Cells.Add(GetHCell("" + realname + "", false));
            //            hrow.Cells.Add(GetHCell("<div style='text-align:left;'>" + commonFun.replaceStr(ds.Tables[0].Rows[i]["MissionDesc"].ToString()) + "</div>", false)); //描述
            //            tempStatus = ds.Tables[0].Rows[i]["ExecStatus"].ToString();
            //            if (tempStatus == "0")
            //            {
            //                tempStatusStr = "<img alt='待执行' src='../inc/images/red.gif' border='0'>";
            //            }
            //            else if (tempStatus == "1")
            //            {
            //                tempStatusStr = "<img alt='执行中' src='../inc/images/yellow.gif' border='0'>";
            //            }
            //            else if (tempStatus == "2")
            //            {
            //                tempStatusStr = "<img alt='已经完成' src='../inc/images/green.gif' border='0'>";
            //            }
            //            string writedate = ds.Tables[0].Rows[i]["WriteDate"].ToString();
            //            string execDate=ds.Tables[0].Rows[i]["ExecDate"].ToString();
            //            string finishDate=ds.Tables[0].Rows[i]["FinisthDate"].ToString();

            //            if(!string.IsNullOrEmpty(execDate))
            //            {
            //                execDate=Convert.ToDateTime(execDate).ToString("MM-dd hh:mm");
            //            }
            //            if(!string.IsNullOrEmpty(finishDate))
            //            {
            //                finishDate=Convert.ToDateTime(finishDate).ToString("MM-dd hh:mm");
            //            }
            //            if(!string.IsNullOrEmpty(writedate))
            //            {
            //                writedate=Convert.ToDateTime(writedate).ToString("MM-dd hh:mm");
            //            }
            //            hrow.Cells.Add(GetHCell(writedate, false)); //入库日期
            //            hrow.Cells.Add(GetHCell(execDate, false)); //执行日期
            //            hrow.Cells.Add(GetHCell(finishDate, false)); //结束日期

            //            hrow.Cells.Add(GetHCell(tempStatusStr, false)); //执行状态
            //            if (tempStatus == "0")
            //            {
            //                if (IsAsign == "0")
            //                {
            //                    hrow.Cells.Add(GetHCell("<div><img onclick=\"deldata('" + ds.Tables[0].Rows[i]["MissionId"].ToString() + "','" + ds.Tables[0].Rows[i]["UserId"].ToString() + "')\" style='cursor:pointer;' alt='删除当前任务' src='../inc/images/album_del.gif' border='0'>&nbsp;<img alt='分配当前任务' onclick=\"showDiv('"+ds.Tables[0].Rows[i]["MissionId"].ToString()+"')\" src='../inc/images/a_edit.gif' border='0'></div>", false));
            //                }
            //                else
            //                {
            //                    hrow.Cells.Add(GetHCell("<div><img onclick=\"deldata('" + ds.Tables[0].Rows[i]["MissionId"].ToString() + "','" + ds.Tables[0].Rows[i]["UserId"].ToString() + "')\" style='cursor:pointer;' alt='删除当前任务' src='../inc/images/album_del.gif' border='0'>&nbsp;<img alt='修改当前任务' src='../inc/images/a_edit.gif' border='0'></div>", false));
            //                }
            //            }
            //            else
            //            {
            //                if (Status == "-1")
            //                {
            //                    hrow.Cells.Add(GetHCell("<div>无</div>", false));
            //                }
            //            }

            //            tbl_list.Rows.Add(hrow);
            //        }
            //    }
            //    else
            //    {
            //        hrow = new HtmlTableRow();
            //        HtmlTableCell hcell = null;
            //        if (Status == "0" || Status == "-1")
            //        {
            //            hcell = GetHCell("温馨提示:该时间段没有任何任务!", false);
            //            hcell.Attributes.Add("colspan", "7");
            //            hrow.Cells.Add(hcell);
            //        }
            //        else
            //        {
            //            hcell = GetHCell("温馨提示:该时间段没有任何任务!", false);
            //            hcell.Attributes.Add("colspan", "6");
            //            hrow.Cells.Add(hcell);
            //        }
            //        tbl_list.Rows.Add(hrow);
            //    }
            //}
            //else
            //{
            //    hrow = new HtmlTableRow();
            //    HtmlTableCell hcell = null;
            //    if (Status == "0" || Status == "-1")
            //    {
            //        hcell = GetHCell("温馨提示:该时间段没有任何任务!", false);
            //        hcell.Attributes.Add("colspan", "7");
            //        hrow.Cells.Add(hcell);
            //    }
            //    else
            //    {
            //        hcell = GetHCell("温馨提示:该时间段没有任何任务!", false);
            //        hcell.Attributes.Add("colspan", "6");
            //        hrow.Cells.Add(hcell);
            //    }
            //    tbl_list.Rows.Add(hrow);
            //}

            #endregion

            string parms = "&isa=" + IsAsign + "&opt=off&bd=" + beginSearchDate + "&ed=" + endSearchDate + "&uid=" + UserId + "&st=" + Status + "&tl=" + Server.UrlEncode(KeyWord) + "&to=" + TypeMission;
            GetPage(userCount, PageSize, currentPage, parms);//获取分页文字
        }