void client_GetDataByRequireIDCompleted(object sender, GetDataByRequireIDCompletedEventArgs e) { model = e.Result; ObservableCollection <T_OA_REQUIREDETAIL2> detail2 = model.T_OA_REQUIREDETAIL2; if (model.T_OA_REQUIREDETAIL2 != null) { this.dgQuestion.ItemsSource = detail2; } else { this.dgQuestion.ItemsSource = null; } if (model.T_OA_REQUIRE != null) { requiremasterID = model.T_OA_REQUIREMASTER.REQUIREMASTERID; this.textTitle.Text = model.T_OA_REQUIRE.APPTITLE; this.textContent.Text = model.T_OA_REQUIRE.CONTENT; } loadbar.Stop(); }
/// <summary> /// 根据申请ID查询方案题目 /// </summary> /// <param name="requireID"></param> /// <returns></returns> public V_EmployeeSurveysModel GetDataByRequireID(string requireID) { try { V_EmployeeSurveysModel model = new V_EmployeeSurveysModel(); var ents = from t in dal.GetObjects <T_OA_REQUIRE>() //申请 where t.REQUIREID == requireID select t; // 题目 var ents1 = from t in dal.GetObjects <T_OA_REQUIRE>() join t1 in dal.GetObjects <T_OA_REQUIREDETAIL2>() on t.T_OA_REQUIREMASTER.REQUIREMASTERID equals t1.REQUIREMASTERID into t2 from t3 in t2.DefaultIfEmpty() where t.REQUIREID == requireID select t3; // 方案 var ents2 = from t in dal.GetObjects <T_OA_REQUIRE>() join t1 in dal.GetObjects <T_OA_REQUIREMASTER>() on t.T_OA_REQUIREMASTER.REQUIREMASTERID equals t1.REQUIREMASTERID into t2 from t3 in t2.DefaultIfEmpty() where t.REQUIREID == requireID select t3; model.T_OA_REQUIRE = ents.FirstOrDefault(); model.T_OA_REQUIREDETAIL2 = ents1.ToList(); model.T_OA_REQUIREMASTER = ents2.FirstOrDefault(); //model.T_OA_REQUIRERESULT = ents.FirstOrDefault().T_OA_REQUIREDISTRIBUTE; return(model); } catch (Exception ex) { Tracer.Debug("员工参与调查EmployeeSurveysBLL-GetDataByRequireID" + System.DateTime.Now.ToString() + " " + ex.ToString()); return(null); } }
void client_GetDataByRequireIDCompleted(object sender, GetDataByRequireIDCompletedEventArgs e) { model = e.Result; ObservableCollection<T_OA_REQUIREDETAIL2> detail2 = model.T_OA_REQUIREDETAIL2; if (model.T_OA_REQUIREDETAIL2 != null) { this.dgQuestion.ItemsSource = detail2; } else { this.dgQuestion.ItemsSource = null; } if(model.T_OA_REQUIRE!=null) { requiremasterID = model.T_OA_REQUIREMASTER.REQUIREMASTERID; this.textTitle.Text = model.T_OA_REQUIRE.APPTITLE; this.textContent.Text = model.T_OA_REQUIRE.CONTENT; } loadbar.Stop(); }