entity语法问题求解决
string[] numbersID = this.HidCIdList.Value.Split(';');
数组的形式是 123[456] 就是一个id加上[另一个id]拼起来的作为唯一标示
List<string> result = new List<string>(numbersID).ConvertAll(i => i);
var Query = (from a in adviceNoteEarnestMoneyTableEntities.AssetsInfo
join b in adviceNoteEarnestMoneyTableEntities.MgProjectBaseInfo on a.ProjectID equals b.ProjectID
join c in adviceNoteEarnestMoneyTableEntities.AssetsType.Where(c=>c.ID==6) on a.AssetsType equals c.ID
join d in adviceNoteEarnestMoneyTableEntities.MgProjectCustomers.Where(d=>d.Type==0) on a.ID equals d.AssetsID
join f in adviceNoteEarnestMoneyTableEntities.CustomerBaseInfo on d.CustomerID equals f.CustomerID
select new
{
CustomerCode = f.MainDataNO,
CustomerID = f.CustomerID,
CustomerName=f.Name,
ProjectCode = b.Code,
ProjectID = a.ProjectID,
AssetsID = a.ID,
ProjectMainNo = b.MainDataNO,
ProjectTitle = b.Title,
AssetsType=a.AssetsType,