public ActionResult Detail(int id, int? pageNo, string parm, OpenBidProjectQuery query) { Dictionary<string, string> sitemaster = GetSiteMaster(); ViewData["SiteMaster"] = sitemaster; if (sitemaster["istest"] == "1") { int uid = Int32.Parse(sitemaster["userid"]); IList<int> openprojectlist = CRMMapper.Get().QueryForList<int>("OpenBidNumForTest.myselectopen", uid); //先检查一共看的数目 if (openprojectlist.Count > 0) { //如果有看得记录,先检查是否是看过的 Hashtable htt = new Hashtable(); htt["pid"] = id; htt["uid"] = uid; IList<int> sawid = CRMMapper.Get().QueryForList<int>("OpenBidNumForTest.myselectopenpid", htt); //如果没看过,就检查是否超过最大值 if (sawid.Count == 0) { if (openprojectlist.Count < 5) { //没超过就写入记录 OpenBidNumForTest ob = new OpenBidNumForTest(); ob.OpenprojectNum = id; ob.UserID = uid; new OpenBidNumForTestDao().Insert(ob); } else { //超过了 return RedirectToAction("List"); } } } else { //之前没有看过也写入记录 OpenBidNumForTest ob = new OpenBidNumForTest(); ob.OpenprojectNum = id; ob.UserID = uid; new OpenBidNumForTestDao().Insert(ob); } } DOpenProjectDao mDOpenProjectDao = new DOpenProjectDao(); DOpenProject 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>(); DOpenMedicineDao m = new DOpenMedicineDao(); 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("OID")) { data.Columns.Remove("OID"); } 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 (sitemaster["istest"] == "0" && 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.ToShortDateString() + ".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); } }
public ActionResult Detail(int id, int? pageNo, string parm, OpenBidProjectQuery query) { Dictionary<string, string> sitemaster = GetSiteMaster(); ViewData["SiteMaster"] = sitemaster; //SingleProjectDao mDOpenProjectDao = new SingleProjectDao(); SingleProject mDOpenProject = EmedDataCenterMapper.Get().QueryForObject<SingleProject>("SingleProject.Find", id); 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>(); SingleMedicineDao m = new SingleMedicineDao(); 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("OID")) { data.Columns.Remove("OID"); } List<DataRow> listRow = new List<DataRow>(); foreach (DataRow dr in data.Rows) { listRow.Add(dr); } foreach (DataRow dr in listRow) { if (dr.Table.Columns.Contains("FirstToLimit")) { string strFirstToLimit = dr["FirstToLimit"].ToString(); if (strFirstToLimit.Length > 0) { string subFirstToLimit = strFirstToLimit.Substring(0, strFirstToLimit.Length - 1); decimal fFirstToLimit = decimal.Parse(subFirstToLimit); string resultFirstToLimit = Math.Round(fFirstToLimit, 2).ToString() + "%"; dr["FirstToLimit"] = resultFirstToLimit; } } if (dr.Table.Columns.Contains("SecondToLimit")) { string strSecondToLimit = dr["SecondToLimit"].ToString(); if (strSecondToLimit.Length > 0) { string subSecondToLimit = strSecondToLimit.Substring(0, strSecondToLimit.Length - 1); decimal fSecondToLimit = decimal.Parse(subSecondToLimit); string resultSecondToLimit = Math.Round(fSecondToLimit, 2).ToString() + "%"; dr["SecondToLimit"] = resultSecondToLimit; } } if (dr.Table.Columns.Contains("SSecondToFirst")) { string strSSecondToFirst = dr["SSecondToFirst"].ToString(); if (strSSecondToFirst.Length > 0) { string subSSecondToFirst = strSSecondToFirst.Substring(0, strSSecondToFirst.Length - 1); decimal fSSecondToFirst = decimal.Parse(subSSecondToFirst); string resultSSecondToFirst = Math.Round(fSSecondToFirst, 2).ToString() + "%"; dr["SSecondToFirst"] = resultSSecondToFirst; } } if (dr.Table.Columns.Contains("SBidToFinal")) { string strSBidToFinal = dr["SBidToFinal"].ToString(); if (strSBidToFinal.Length > 0) { string subSBidToFinal = strSBidToFinal.Substring(0, strSBidToFinal.Length - 1); decimal fSBidToFinal = decimal.Parse(subSBidToFinal); string resultSBidToFinal = Math.Round(fSBidToFinal, 2).ToString() + "%"; dr["SBidToFinal"] = resultSBidToFinal; } } if (dr.Table.Columns.Contains("SBidToLimit")) { string strSBidToLimit = dr["SBidToLimit"].ToString(); if (strSBidToLimit.Length > 0) { string subSBidToLimit = strSBidToLimit.Substring(0, strSBidToLimit.Length - 1); decimal fSBidToLimit = decimal.Parse(subSBidToLimit); string resultSBidToLimit = Math.Round(fSBidToLimit, 2).ToString() + "%"; dr["SBidToLimit"] = resultSBidToLimit; } } if (dr.Table.Columns.Contains("STBidToTender")) { string strSTBidToTender = dr["STBidToTender"].ToString(); if (strSTBidToTender.Length > 0) { string subSTBidToTender = strSTBidToTender.Substring(0, strSTBidToTender.Length - 1); decimal fSBidToTender = decimal.Parse(subSTBidToTender); string resultSfSBidToTender = Math.Round(fSBidToTender, 2).ToString() + "%"; dr["STBidToTender"] = resultSfSBidToTender; } } } 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 (sitemaster["istest"]=="0" && query.Excel == "1") { ExcelExport mx = new ExcelExport(); mx.InitTh(); mx._fileName = "Emed-KB-" + 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"); } mx.DataTableToExcel(data); } #endregion return View(list); } }
//导出表格 public ActionResult Export(int? projectid, string itemid, FormCollection collection) { int IsStandard = new ProjectDao().Find(projectid.Value).IsStandard; Hashtable ht = new Hashtable(); ht["pid"] = projectid.Value; ht["itemid"] = itemid; IDictionary medicineinfo = (IsStandard == 1) ? StandardDataMapper.Get().QueryForObject<IDictionary>("CompareData.ListSingleName", itemid) : EmedEvaluationProjectMapper.Get().QueryForObject<IDictionary>("CompareDataProject.ListSingleName", ht); if (collection.Count != 0 && collection["excel"] == "1") { ExcelExport mx = new ExcelExport(); mx.InitTh(); mx._fileName = medicineinfo["ChineseProductName"].ToString() + 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("评价药品:" + medicineinfo["ChineseProductName"] + medicineinfo["Formulation"] + medicineinfo["ChineseSpecification"] + medicineinfo["ChineseManufactureName"], tiName); //得到第二行表头名称 TableItemStyle tiSecondName = new TableItemStyle(); tiSecondName.Font.Size = 14; tiSecondName.ForeColor = System.Drawing.Color.Black; tiSecondName.HorizontalAlign = HorizontalAlign.Center; mx.SecondExtrInfo.Add(collection["secondhead"], tiSecondName); string[] spanlist = collection["spanlist"].Split(','); string[] header = collection["header"].Split(','); string[] bodycontent = collection["content"].Split('|'); List<Dictionary<string, string>> list = new List<Dictionary<string, string>>(); foreach (string bc in bodycontent) { string[] each = bc.Split('^'); Dictionary<string, string> contentdict = new Dictionary<string, string>(); int count = 0; foreach (string e in each) { contentdict.Add(header[count], e); count++; } list.Add(contentdict); } DataTable data = new DataTable(); data = ConvertTo(header, list); mx.DataTableToExcelForSimulate(data, spanlist); } return View(); }
public ActionResult Detail(int id, int? pageNo, string parm, FormCollection query) { Dictionary<string, string> sitemaster = GetSiteMaster(); ViewData["SiteMaster"] = sitemaster; int uid = Int32.Parse(sitemaster["userid"]); if (sitemaster["istest"] == "1") { IList<int> openprojectlist = CRMMapper.Get().QueryForList<int>("OpenBidNumForTest.myselectopen", uid); //先检查一共看的数目 if (openprojectlist.Count > 0) { //如果有看得记录,先检查是否是看过的 Hashtable htt = new Hashtable(); htt["pid"] = id; htt["uid"] = uid; IList<int> sawid = CRMMapper.Get().QueryForList<int>("OpenBidNumForTest.myselectopenpid", htt); //如果没看过,就检查是否超过最大值 if (sawid.Count == 0) { if (openprojectlist.Count < 5) { //没超过就写入记录 OpenBidNumForTest ob = new OpenBidNumForTest(); ob.OpenprojectNum = id; ob.UserID = uid; new OpenBidNumForTestDao().Insert(ob); } else { //超过了 return RedirectToAction("List"); } } } else { //之前没有看过也写入记录 OpenBidNumForTest ob = new OpenBidNumForTest(); ob.OpenprojectNum = id; ob.UserID = uid; new OpenBidNumForTestDao().Insert(ob); } } DOpenProjectDao mDOpenProjectDao = new DOpenProjectDao(); DOpenProject 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; Dictionary<string, string> dict = ParmHelper.Analysis(query); //如果有参数 if (dict.Count != 0) { string parmeter = ParmHelper.BuildParm(dict); return RedirectToAction("Detail", new { id = id, pageNo = 1, parm = parmeter }); } else { Hashtable memberkeys = new Hashtable(); int PageNo = pageNo ?? 1; if (parm != null) { dict = ParmHelper.AnalysisParm(parm); Hashtable ht = new Hashtable(); ht.Add("ID", dict["CommonName"]); ht.Add("UserID", uid); memberkeys = CRMMapper.Get().QueryForObject<Hashtable>("MemberMedicineKey.FindByID", ht); dict["IsSearched"] = "1"; } else { memberkeys.Add("KeyList", ""); dict.Add("excel", ""); } string commonnames = memberkeys["KeyList"].ToString().Replace(" ", "").Replace(" ", ""); //页码与记录数 int count = 0; //是否竞品条件 bool compete = false; //取数据与记录数 List<string> th = new List<string>(); DOpenMedicineDao m = new DOpenMedicineDao(); DataTable data = m.GetExportData(id, PageNo, PageSizeDetail, commonnames, out count, ref th, dict["excel"]); #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("OID")) { data.Columns.Remove("OID"); } 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); } #endregion bool isExcel = dict["excel"] == "1" ? true : false; ViewData["Query"] = dict; ViewData["Count"] = count; ViewData["Th"] = th; ViewData["KeyList"] = memberkeys["KeyList"]; IList<IDictionary> ownkeys = CRMMapper.Get().QueryForList<IDictionary>("MemberMedicineKey.FindByUserID", uid); ViewData["OwnKeys"] = ownkeys; #region excel if (sitemaster["istest"] == "0" && isExcel) { ExcelExport mx = new ExcelExport(); mx.InitTh(); mx._fileName = memberkeys["ListName"] + DateTime.Now.ToShortDateString() + ".xls"; //if (query.CommonName != null) // mx._fileName = query.CommonName + DateTime.Now.ToShortDateString() + ".xls"; //else //{ // if (query.ProductEnterpriseName != null) // mx._fileName = query.ProductEnterpriseName + DateTime.Now.ToShortDateString() + ".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); } }
// // GET: /BiddingExcute/ public ActionResult Detail(int? pageNo, string parm, FormCollection collection) { Dictionary<string, string> sitemaster = GetSiteMaster(); ViewData["SiteMaster"] = sitemaster; Dictionary<string, string> dict = ParmHelper.Analysis(collection); if (dict.Count != 0) { string parmeter = ParmHelper.BuildParm(dict); return RedirectToAction("Detail", new { pageNo = 1, parm = parmeter }); } if (pageNo == null) { return View(); } int pageIndex = pageNo ?? 1; int size = 20;//每页条数 Dictionary<string, string> use = ParmHelper.AnalysisParm(parm); int count = 0; IList<IDictionary> list = null;//分页数据 DataTable excelData = null;//excel数据 Dictionary<string, string> ht;//查询条件 if (use.ContainsKey("competeCommonName") || use.ContainsKey("competeFormulation") || use.ContainsKey("competeSpecification") || use.ContainsKey("competeQualityLevel")) { //得到本品和竞品列表 ht = use; ht["start"] = (size * (pageIndex - 1) + 1).ToString(); //记录开始数 ht["end"] = (pageIndex * size).ToString(); //记录结束数 list = DBiddingMedicineDao.GetCompeteMedicine(ht, out count); } else { //得到本品列表 ht = new Dictionary<string, string>(); ht["productcode"] = use["productcode"]; ht["province"] = use["province"]; ht["start"] = (size * (pageIndex - 1) + 1).ToString(); //记录开始数 ht["end"] = (pageIndex * size).ToString(); //记录结束数 count = BiddingExcuteMapper.Get().QueryForObject<int>("DBiddingMedicine.GetMedicineCount", ht); list = BiddingExcuteMapper.Get().QueryForList<IDictionary>("DBiddingMedicine.GetMedicine", ht); } //是否导出excel if (use.ContainsKey("excel") && use["excel"] == "1") { if (use.ContainsKey("competeCommonName") || use.ContainsKey("competeFormulation") || use.ContainsKey("competeSpecification") || use.ContainsKey("competeQualityLevel")) { excelData = DBiddingMedicineDao.GetAllCompeteMedicine(ht, "top(1000)"); } else { excelData = DBiddingMedicineDao.GetAllMedicine(ht); } ExcelExport mx = new ExcelExport(); mx.InitTh(); mx._fileName = "Emed-ZB-" + DateTime.Now.ToShortDateString() + ".xls"; if (excelData.Columns.Contains("OID")) { excelData.Columns.Remove("OID"); } mx.DataTableToExcel(excelData); } ViewData["Province"] = BaseMapper.Get().QueryForObject<string>("CityCode.GetProvinceNameByValue", use["province"]); ViewData["Count"] = count; ViewData["Query"] = use; //ViewData["Query"] = new BiddingQuery() //{ // Province = use.ContainsKey("province") ? use["province"] : null, // ProductEnterprise = use.ContainsKey("productEnterprise") ? use["productEnterprise"] : null, // CommonName = use.ContainsKey("commonName") ? use["commonName"] : null, // ChineseSpecification = use.ContainsKey("chinesespecification") ? use["chinesespecification"] : null, // Formulation = use.ContainsKey("formulation") ? use["formulation"] : null, // Excel = use.ContainsKey("excel") ? use["excel"] : null, // CompeteCommonName = use.ContainsKey("competeCommonName") ? "checked=checked" : null, // CompeteFormulation = use.ContainsKey("competeFormulation") ? "checked=checked" : null, // CompeteSpecification = use.ContainsKey("competeSpecification") ? "checked=checked" : null, // CompeteQualityLevel = use.ContainsKey("competeQualityLevel") ? "checked=checked" : null //}; PagedList<IDictionary> model = new PagedList<IDictionary>(list, pageIndex, size, count); //ViewData["Start"] = use["start"]; return View(model); }