///
/// 获取评价标准(第二版代码)
///
///
public static List GetEvaluate(List guids)
{
try
{
using (var db = new CustomContext())
{
var documentList = new List();
var classificationList = new List();
var aclassificationSelectIds = “”;
//循环组合用用于 sql 查询的字符串
foreach (var a in guids)
{
if (aclassificationSelectIds == “”)
{
aclassificationSelectIds = “’” + a + “’”;
}
else
{
aclassificationSelectIds += “,’” + a + “’”;
}
}
//查询评价标准子表数据
var aclassification = (SqlQuery(db, “select [classification_id] as id,[classification_document] as documentId, [classification_name1] as name1, [classification_name2] as name2, [classification_name3] as name3, [classification_name4] as name4, [classification_name5] as name5, [classification_name6] as name6 from [” + shareddata + “].[dbo].[classification] where [classification_id] in (” + aclassificationSelectIds + “)”)).ToList();
//将查询出的子表数据的父Id进行组合
var documentSelectIds = “”;
foreach (var a in aclassification) {
if (documentSelectIds == “”)
{
documentSelectIds = “’” + a.documentId + “’”;
}
else
{
documentSelectIds += “,’” + a.documentId + “’”;
}
}
var document = (SqlQuery(db, “select [document_id] as id,[document_title] as title,[document_name] as name from [” + shareddata + “].[dbo].[document] where [document_id] in (” + documentSelectIds + “)”)).ToList();
if (document != null)
{
documentList = document.Select(x => new documentReturn
{
id = x.id,
name = x.name,
title = x.title,
classifications = aclassification.Where(y => y.documentId == x.id).ToList()
}).ToList();
}
if (documentList.Count == 0)
{
return null;
}
return documentList;
}
}
catch (Exception ex)
{
ModController.Log("EER:" + ex.ToString());
return null;
}
}
/ <summary>
/ 获取评价标准(最初代码,需要多次访问数据库)
/ </summary>
/ <returns></returns>
//public static List<documentReturn> GetEvaluate(List<Guid> guids)
//{
// try
// {
// using (var db = new CustomContext())
// {
// var documentList = new List<documentReturn>();
// var classificationList = new List<classification>();
// foreach (var a in guids)
// {
// var aclassification=(SqlQuery<classification>(db, "select [classification_id] as id,[classification_document] as documentId, [classification_name1] as name1, [classification_name2] as name2, [classification_name3] as name3, [classification_name4] as name4, [classification_name5] as name5, [classification_name6] as name6 from [" + shareddata + "].[dbo].[classification] where [classification_id] ='"+a+"'")).FirstOrDefault();
// var document= (SqlQuery<document>(db, "select [document_id] as id,[document_title] as title,[document_name] as name from [" + shareddata + "].[dbo].[document] where [document_id] ='" + aclassification.documentId + "'")).FirstOrDefault();
// if (document != null)
// {
// var ishas = documentList.Where(x => x.id == document.id).FirstOrDefault();
// if (ishas == null)
// {
// classificationList= new List<classification>();
// var newdocumentReturn = new documentReturn();
// newdocumentReturn.id = document.id;
// newdocumentReturn.name = document.name;
// newdocumentReturn.title = document.title;
// classificationList.Add(aclassification);
// newdocumentReturn.classifications= classificationList;
// documentList.Add(newdocumentReturn);
// }
// else
// {
// classificationList = documentList.FirstOrDefault(x => x.id == document.id).classifications;
// classificationList.Add(aclassification);
// documentList.FirstOrDefault(x => x.id == document.id).classifications= classificationList;
// }
// }
// }
// if (documentList.Count == 0) {
// return null;
// }
// return documentList;
// }
// }
// catch (Exception ex)
// {
// ModController.Log("EER:" + ex.ToString());
// return null;
// }
//}