silverlight 3 通过 ADO.NET ENTITY , RIA SERVICE数据库交互 在线等 急急急
查询不到记录,请问是不是我写错了?请问该怎么写?在线等,
/// <summary>
/// 初始化加载数据
/// </summary>
/// <param name="Token"></param>
private void DataInitLoad(string Token)
{
//开启动画效果
AnimationManager.SetIsAnimationEnabled(this.radExpander, true);
this.myGrid.SelectionChanged += new System.Windows.Controls.SelectionChangedEventHandler(myGrid_SelectionChanged);
SaasDS Saas = new SaasDS();
SzetcXjDS Szectxj = new SzetcXjDS();
MessageBox.Show(Token);
//获取用户ID
//var tempGuid = (from d in Saas.Common_Users_SSOs
// where d.TokenName == Token
// select d.TokenName).FirstOrDefault();
Guid Userid = Guid.Empty;
//if (tempGuid != null)
//{
// Userid = new Guid(tempGuid);
//}
if(Token!=null)
{
Userid = new Guid(Token);
}
//获取子女ID集
var StudentID = (from s in Szectxj.T_PATRIARCHBASEINFOs
where s.PATRIARCHBASEINFO_ID != Userid
select s.STUDENTBASEINFO_ID);
//将实体转换成
Guid[] StudentIDs = StudentID.ToArray();
//联合查询附件级基本信息到自定义实体
var Temp = from tempStudent in Szectxj.T_STUDENTBASEINFOs
join tempSchool in Szectxj.T_SCHOOLBASEINFOs on tempStudent.SCHOOLBASEINFO_ID equals tempSchool.SCHOOLBASEINFO_ID
join tempNj in Szectxj.T_GRADEINFOs on tempStudent.NJ equals tempNj.GRADEINFO_ID
join tempFile in Szectxj.T_FILES on tempStudent.STUDENTBASEINFO_ID equals tempFile.RECORD_ID
join tempClass in Szectxj.T_CLASSINFOs on tempStudent.CLASSINFO_ID equals tempClass.CLASSINFO_ID
where StudentIDs.Contains(tempStudent.STUDENTBASEINFO_ID)
select new SelcetStdentByPatrirch() { Student_id = tempStudent.STUDENTBASEINFO_ID, Student_Name = tempStudent.XM, Student_School = tempSchool.XXMC, Student_Nj = tempNj.GRADEINFO_NAME, Student_Class = tempClass.BJMC, Student_Photo = tempFile.FILES_CONTENT };
myGrid.ItemsSource = Temp;
}