public void DownContentLoadFiles(string ids) { if (!string.IsNullOrEmpty(ids)) { int l3Id = 0; List <string> strPath = new List <string>(); string[] idlist = ids.Substring(0, ids.Length - 1).Split(','); foreach (string id in idlist) { var list = accessoryService.LoadEntites(o => o.ID == Convert.ToInt32(id)); if (list != null && list.Count() > 0) { foreach (var model in list) { string strAddress = model.Data_Accessory_Address; strPath.Add(Server.MapPath(@"\Content\Files\") + strAddress); l3Id = (int)model.Data_Detail_ID; } } } ZipFileDownload(strPath.ToArray(), "资料文件.zip"); //下载计数 if (l3Id == 0) { return; } data_statisticsService dataStatisticsService = new data_statisticsService(); IQueryable <data_statistics> sSet = dataStatisticsService.LoadEntites(o => o.item_id == l3Id && o.data_catagory == 3); if (sSet.Count() != 0) { var sItem = sSet.First() as data_statistics; data_statistics nds = new data_statistics { id = sItem.id, data_catagory = sItem.data_catagory, item_id = sItem.item_id, browse_quantity = sItem.browse_quantity, download_quantity = sItem.download_quantity + 1 }; dataStatisticsService.UpdateEntity(nds); } // } }
public ActionResult DataDetailContentInfo(int ID = 0, int PageIndex = 1) { DataDetailInfoViewModel viewmodel; if (ID != 0) { if (ViewData["SearchStart"] == null) { ViewData["SearchStart"] = DateTime.Now.ToShortDateString(); } if (ViewData["SearchEnd"] == null) { ViewData["SearchEnd"] = DateTime.Now.ToShortDateString(); } var item = detailService.LoadEntites(o => o.ID == ID).First(); var IsPublish = item.Data_IsPublish; var IsOutSide = item.Data_IsOutSide; //ModelState.IsValid ViewData["IsPublish"] = IsPublish == 0 ? "未发布" : "已发布"; ViewData["IsOutSide"] = IsOutSide == 0 ? "内部资料" : "外部资料"; viewmodel = new DataDetailInfoViewModel { ID = item.ID, Data_Info_ID = item.Data_Info_ID, Data_Detail_Name = item.Data_Detail_Name, Data_Detail_Source = item.Data_Detail_Source, Data_Detail_Script = item.Data_Detail_Script, Data_Detail_Desc = item.Data_Detail_Desc, CreateDateTime = item.CreateDateTime, UpdateDateTime = item.UpdateDateTime, Data_IsOutSide = item.Data_IsOutSide, SearchColumns1 = item.SearchColumns1, SearchColumns2 = item.SearchColumns2, SearchColumns3 = item.SearchColumns3, SearchColumns4 = item.SearchColumns4, SearchColumns5 = item.SearchColumns5, SearchColumns6 = item.SearchColumns6, SearchContidion1 = item.SearchContidion1, SearchContidion2 = item.SearchContidion2, SearchContidion3 = item.SearchContidion3, SearchContidion4 = item.SearchContidion4, SearchContidion5 = item.SearchContidion5, SearchContidion6 = item.SearchContidion6 }; var dataInfoM = datainfoService.LoadEntites(u => u.ID == int.Parse(viewmodel.Data_Info_ID.ToString())).FirstOrDefault() as data_info; var dataTypeM = datatypeService.LoadEntites(u => u.ID == int.Parse(dataInfoM.Data_Type_ID.ToString())).FirstOrDefault() as data_type_info; var dataAccessory = accessoryService.LoadEntites(u => u.Data_Detail_ID == item.ID).ToList(); var ename = dataInfoM.Data_Info_Name; var yname = dataTypeM.Data_Type_Name; var dataTypeID = dataTypeM.ID; ViewData["Data_Type_Name"] = yname; ViewData["Data_Info_Name"] = ename; ViewData["Data_Type_ID"] = dataTypeID; int i = 0; if (!string.IsNullOrWhiteSpace(viewmodel.SearchColumns1)) { i++; } if (!string.IsNullOrWhiteSpace(viewmodel.SearchColumns2)) { i++; } if (!string.IsNullOrWhiteSpace(viewmodel.SearchColumns3)) { i++; } if (!string.IsNullOrWhiteSpace(viewmodel.SearchColumns4)) { i++; } if (!string.IsNullOrWhiteSpace(viewmodel.SearchColumns5)) { i++; } if (!string.IsNullOrWhiteSpace(viewmodel.SearchColumns6)) { i++; } ViewData["SearchConditionCount"] = i; ViewData["Data_Accessory"] = dataAccessory; } else { viewmodel = new DataDetailInfoViewModel(); } ViewData.Model = viewmodel; Script = viewmodel.Data_Detail_Script; Condition1 = viewmodel.SearchContidion1; Condition2 = viewmodel.SearchContidion2; Condition3 = viewmodel.SearchContidion3; Condition4 = viewmodel.SearchContidion4; Condition5 = viewmodel.SearchContidion5; Condition6 = viewmodel.SearchContidion6; //if (!string.IsNullOrEmpty(viewmodel.Data_Detail_Script)) //{ // var scriptSite = viewmodel.Data_Detail_Script;//查询外部数据的语句 // //------------------------------------- // DataSet dsfrist = commonService.QueryDataSet(scriptSite); // int RecordCount = dsfrist.Tables[0].Rows.Count; // int PageSize = 10; // int PageCount = RecordCount % PageSize == 0 ? RecordCount / PageSize : RecordCount / PageSize + 1; // if (PageIndex < 1) // { // PageIndex = 1;//当前页码必须大于1 // } // if (PageIndex >= PageCount) // { // PageIndex = PageCount;//当前页码不能大于总页码 // } // //------------------------------------- // scriptSite += @" Where time between '"+ ViewData["SearchStart"]+"' AND '"+ViewData["SearchEnd"]+"' "; // scriptSite += string.Format(@" Limit {0},{1}", (PageIndex - 1) * PageSize, PageSize); // if (scriptSite != null) // { // DataSet ds = commonService.QueryDataSet(scriptSite); // if (ds != null && RecordCount > 0) // { // ViewData["data"] = ds; // } // else // { // ViewData["data"] = null; // } // } // ViewData["ID"] = ID; // ViewData["PageIndex"] = PageIndex; // ViewData["PageCount"] = PageCount; //} //ViewData["Is_Outsite"] = viewmodel.Data_IsOutSide; //增加访问量start data_statisticsService dataStatisticsService = new data_statisticsService(); IQueryable <data_statistics> sSet = dataStatisticsService.LoadEntites(o => o.item_id == ID && o.data_catagory == 3); if (sSet.Count() != 0) { var sItem = sSet.First() as data_statistics; data_statistics nds = new data_statistics { id = sItem.id, data_catagory = sItem.data_catagory, item_id = sItem.item_id, download_quantity = sItem.download_quantity, browse_quantity = sItem.browse_quantity + 1, }; dataStatisticsService.UpdateEntity(nds); } else { data_statistics nds = new data_statistics { item_id = ID, data_catagory = 3, browse_quantity = 1, }; dataStatisticsService.AddEntity(nds); } return(View()); }