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());
}
