public ActionResult Detail(int id, int? pageNo, string parm, OpenBidProjectQuery query) { Dictionary<string, string> sitemaster = GetSiteMaster(); ViewData["SiteMaster"] = sitemaster; ReviewProjectDao mDOpenProjectDao = new ReviewProjectDao(); ReviewProject mDOpenProject = mDOpenProjectDao.Find(id); int interval = 0; if (EnterPriseMemberInfo.Memberlevel == 201) interval = 6; if (EnterPriseMemberInfo.Memberlevel == 301) interval = 12; DateTime limitedate = DateTime.Now.AddMonths(interval); if ((EnterPriseMemberInfo.Memberlevel == 201 || EnterPriseMemberInfo.Memberlevel == 301) && mDOpenProject.OpenDate > limitedate) { return RedirectToAction("MemberLevelError", "Base"); } ViewData["ProjectDescription"] = mDOpenProject.NewProjectDescription; ViewData["Summary"] = mDOpenProject.Summary; ViewData["OID"] = mDOpenProject.OID; //如果有参数 if (query.IsHaveProperty()) { parm = query.GetParameter(); ViewData["Query"] = query; return RedirectToAction("Detail", new { id = id, pageNo = 1, parm = parm }); } else { int PageNo = pageNo ?? 1; //表明第一次进来 if (query.CommonName != null) { query.LoadProperties(parm); } if (string.IsNullOrEmpty(query.CommonName) && string.IsNullOrEmpty(query.ProductEnterpriseName) && string.IsNullOrEmpty(query.TenderEnterpriseName) && query.CommonName.Length < 3) { pageNo = 1; } else { query.IsSearched = "1"; } //页码与记录数 int count = 0; //是否竞品条件 bool compete = false; //取数据与记录数 List<string> th = new List<string>(); ReviewMedicineDao m = new ReviewMedicineDao(); DataTable data = m.GetData(id, PageNo, PageSizeDetail, query, out count, ref compete, ref th); #region 数据处理 if (data == null) { data = new DataTable(); } if (!data.Columns.Contains("ID")) { DataColumn dc = new DataColumn(); dc.ColumnName = "ID"; data.Columns.Add(dc); } int beginNo = 0; if (!compete) { beginNo = (PageNo - 1) * PageSizeDetail; } for (int i = 1; i <= data.Rows.Count; i++) { data.Rows[i - 1]["ID"] = (beginNo + i).ToString(); } if (data.Columns.Contains("ROWID")) { data.Columns.Remove("ROWID"); } if (data.Columns.Contains("ID")) { data.Columns.Remove("ID"); } List<DataRow> listRow = new List<DataRow>(); foreach (DataRow dr in data.Rows) { listRow.Add(dr); } PagedList<DataRow> list; if (compete) { list = new PagedList<DataRow>(listRow, PageNo, PageSizeDetail); } else { list = new PagedList<DataRow>(listRow, PageNo, PageSizeDetail, count); } ViewData["Compete"] = compete; ViewData["Query"] = query; ViewData["Count"] = count; ViewData["Th"] = th; #endregion #region excel if (query.Excel == "1") { ExcelExport mx = new ExcelExport(); mx.InitTh(); if (query.CommonName != null) mx._fileName = query.CommonName + DateTime.Now.ToShortDateString() + ".xls"; else { if(query.ProductEnterpriseName!=null) mx._fileName = query.ProductEnterpriseName + DateTime.Now.Year+DateTime.Now.Month+DateTime.Now.Day + ".xls"; else mx._fileName = query.TenderEnterpriseName + DateTime.Now.ToShortDateString() + ".xls"; } //项目名称 TableItemStyle tiName = new TableItemStyle(); tiName.Font.Size = 14; tiName.ForeColor = System.Drawing.Color.Red; tiName.HorizontalAlign = HorizontalAlign.Center; mx.HeadExtrInfo.Add(mDOpenProject.NewProjectName, tiName); //项目备注 TableItemStyle tiRemark = new TableItemStyle(); tiRemark.Font.Size = 13; tiRemark.ForeColor = System.Drawing.Color.Red; tiRemark.HorizontalAlign = HorizontalAlign.Left; mx.HeadExtrInfo.Add("项目备注说明:", tiRemark); //项目备注 TableItemStyle tiRemarkContent = new TableItemStyle(); tiRemarkContent.Font.Size = 12; tiRemarkContent.HorizontalAlign = HorizontalAlign.Left; mx.HeadExtrInfo.Add(mDOpenProject.NewProjectDescription, tiRemarkContent); TableItemStyle tiCount = new TableItemStyle(); tiCount.Font.Size = 12; tiCount.HorizontalAlign = HorizontalAlign.Left; mx.HeadExtrInfo.Add("共有" + count.ToString() + "条", tiCount); if (data.Columns.Contains("ID")) { data.Columns.Remove("ID"); } //20111019修改按显示表头导出,去掉多余列 if (data.Columns.Contains("Mine")) { data.Columns.Remove("Mine"); } mx._thName = th.ToArray();//20111019修改按显示表头导出 mx.DataTableToExcel(data); } #endregion return View(list); } }
/// <summary> /// 对TEMPLIST进行处理,如果是第一页新增加最新数据 /// </summary> /// <param name="tempList"></param> /// <returns></returns> /*private IList<DOpenProject> GetNewAdd(IList<DOpenProject> tempList) { IList<DOpenProject> newlist = mDao.GetNew(); foreach (DOpenProject bp in newlist) { foreach (DOpenProject bd in tempList) { if (bd.OID == bp.OID) { tempList.Remove(bd); break; } } } foreach (DOpenProject bd in tempList) { newlist.Add(bd); } return newlist; } */ /// <summary> /// 查询生产企业,最多20个 /// </summary> /// <param name="Name">输入名称</param> /// <returns></returns> public JsonResult GetEnterpriseName(string Name, string projectoid, string category) { int len = 20; if (String.IsNullOrEmpty(Name)) { return Json(new List<string>()); } Dictionary<string, string> dict = new Dictionary<string, string>(); if (category == "0") { dict.Add("productenterprise", Name.Trim()); } else { dict.Add("tenderenterprise", Name.Trim()); } dict.Add("projectoid", projectoid); ReviewMedicineDao mDOpenMedicineDao = new ReviewMedicineDao(); IList<ReviewMedicine> list = mDOpenMedicineDao.GetEnterprise(dict); List<string> enterpriseList = new List<string>(); foreach (ReviewMedicine m in list) { if (category == "0") { if (!enterpriseList.Contains(m.ProductEnterprise)) { enterpriseList.Add(m.ProductEnterprise); len--; } } else { if (!enterpriseList.Contains(m.TenderEnterprise)) { enterpriseList.Add(m.TenderEnterprise); len--; } } } if (list.Count > 0) { return Json(enterpriseList); } else { return Json(enterpriseList); } }