public BlockTraineeListViewModel(BlockTraineeBussiness bussiness)
{
_bussiness = bussiness;
_bussiness.LoadTraineesEvnet += trainees =>
{
Trainees.Clear();
if (trainees != null)
{
trainees.ForEach(t =>
{
Trainees.Add(new TraineeViewModel(t, false));
Trainees.Last().OperateTraineeEvent += OnOperateTrainee;
});
}
};
_bussiness.TraineeChangedEvent += (operation, trainee, newIndex) =>
{
switch (operation)
{
case OperationType.Add:
Trainees.Add(new TraineeViewModel(trainee, false));
Trainees.Last().OperateTraineeEvent += OnOperateTrainee;
break;
case OperationType.Update:
Trainees.Where(t => t.TraineeID == trainee.TraineeIDForShown).First().TraineeName = trainee.TraineeName;
break;
case OperationType.Delete:
Trainees.Remove(Trainees.Where(t => t.TraineeID == trainee.TraineeIDForShown).First());
break;
}
};
}
public void AddTrainee(ITrainee trainee)
{
if (!Trainees.Contains(trainee))
{
Trainees.Add(trainee);
}
}
public Trainees GetRegisteredTrainees(string training_id)
{
Trainees trainees = new Trainees();
try
{
string query = $"select dsto_questionaire.* from dsto_questionaire inner join dsto_Trainee " +
$"on dsto_questionaire.guid = dsto_trainee.yref_questionaire " +
$"where dsto_Trainee.yref_training ='{training_id}'";
var table = DbInfo.ExecuteSelectQuery(query);
if (table.Rows.Count > 0)
{
foreach (DataRow row in table.Rows)
{
Trainee trainee = trainees.Add();
trainee.Questionaire = new Questionaires().Add();
trainee.Questionaire.Key = row["guid"].ToString();
trainee.Questionaire.CreatedBy = row["created_by"].ToString();
trainee.Questionaire.OID = int.Parse(row["OID"].ToString());
trainee.Questionaire.Deleted = bool.Parse(row["deleted"].ToString());
trainee.Questionaire.Name = new SectionProvider(DbInfo).QuestionaireIdentification(row["yref_template"].ToString(), row["guid"].ToString());
}
}
}
catch (Exception ex)
{
throw ex;
}
return(trainees);
}
public Trainees GetTrainees(string training_id)
{
Trainees trainees = new Trainees();
try
{
string query = $"select * from dsto_Trainee where yref_training = '{training_id}' and Deleted=0";
var table = DbInfo.ExecuteSelectQuery(query);
if (table.Rows.Count > 0)
{
foreach (DataRow row in table.Rows)
{
Trainee trainee = trainees.Add();
trainee.Key = Convert.ToString(row["guid"]);
trainee.OID = Convert.ToInt32(row["OID"]);
trainee.FarmerKey = Convert.ToString(row["yref_questionaire"]);
trainee.Deleted = bool.Parse(row["deleted"].ToString());
trainee.CreatedBy = Convert.ToString(row["created_by"]);
trainee.TrainingId = Convert.ToString(row["yref_training"]);
}
}
return(trainees);
}
catch (Exception ex)
{
throw ex;
}
}
public RegularTraineeListViewModel(RegularTraineeBussiness bussiness) : base()
{
_bussiness = bussiness;
_bussiness.LoadTraineesEvent += trainees =>
{
Trainees.Clear();
if (trainees != null)
{
trainees.ForEach(t =>
{
Trainees.Add(new TraineeViewModel(t, true));
Trainees.Last().OperateTraineeEvent += OnOperateTrainee;
});
}
};
_bussiness.TraineeChangedEvent += (operation, trainee, newIndex) =>
{
switch (operation)
{
case OperationType.Add:
Trainees.Add(new TraineeViewModel(trainee, true));
Trainees.Last().OperateTraineeEvent += OnOperateTrainee;
break;
case OperationType.Update:
if (newIndex == -1)
{ //只是更新信息
Trainees.Where(t => t.TraineeID == trainee.TraineeIDForShown).First().TraineeName = trainee.TraineeName;
}
else
{ //删除或者恢复
Trainees.Remove(Trainees.Where(t => t.TraineeID == trainee.TraineeIDForShown).First());
Trainees.Insert(newIndex, new TraineeViewModel(trainee, true));
Trainees[newIndex].OperateTraineeEvent += OnOperateTrainee;
}
break;
case OperationType.Delete:
Trainees.Remove(Trainees.Where(t => t.TraineeID == trainee.TraineeIDForShown).First());
break;
}
};
}
