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