public ActionResult EditDataAccessory(int ID = 0) { DataDetailInfoViewModel viewmodel; if (ID != 0) { var item = detailService.LoadEntites(o => o.ID == ID).First(); 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, Data_IsPublish = item.Data_IsPublish }; } else { viewmodel = new DataDetailInfoViewModel(); } ViewData.Model = viewmodel; return(View()); }
public JsonResult CreateDataAccessory(DataDetailInfoViewModel item, string postCon, string postStr) { var jsonData = postStr.fromJson <tmpData>(); string state = "NotAllow"; try { data_detail_info dinfo = new data_detail_info { Data_Detail_Name = item.Data_Detail_Name, Data_Detail_Source = item.Data_Detail_Source, Data_Info_ID = item.Data_Info_ID, Data_Detail_Script = item.Data_Detail_Script, Data_Detail_Desc = postCon, ID = item.ID, CreateDateTime = DateTime.Now, UpdateDateTime = DateTime.Now, Data_IsOutSide = item.Data_IsOutSide, Data_IsPublish = item.Data_IsPublish }; if (isAllowTogget(dinfo.Data_Info_ID, dinfo.Data_IsOutSide)) { if (dinfo.ID > 0) { detailService.UpdateEntity(dinfo); } else { detailService.AddEntity(dinfo); } for (int i = 0; i < jsonData.files.Count(); i++) { if (jsonData.files[i].CreateDateTime != null && Convert.ToInt32(jsonData.files[i].ID) == 0) { data_accessory_info dainfo = new data_accessory_info() { ID = Convert.ToInt32(jsonData.files[i].ID), Data_Detail_ID = dinfo.ID, Data_Accessory_Address = jsonData.files[i].Data_Accessory_Address, CreateDateTime = jsonData.files[i].CreateDateTime, UpdateDateTime = DateTime.Now, }; accessoryService.AddEntity(dainfo); } } state = "Success"; } var result = new { State = state }; return(Json(result, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { var result = new { State = "Exception", Message = ex.Message }; return(Json(result, JsonRequestBehavior.AllowGet)); } }
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()); }