/// <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> <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> <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'> <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'> <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 { //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'> <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> <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'> <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'> <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);//获取分页文字 }