public static void DbLoad(this TMSAlgorithm entity, DbSession session, params PDMDbProperty[] fields)
{
var result = entity.DbSelect(session, fields);
if (fields.Contains(TMSAlgorithmProperties.Name))
{
entity.Name = result.Name;
}
if (fields.Contains(TMSAlgorithmProperties.Type))
{
entity.Type = result.Type;
}
if (fields.Contains(TMSAlgorithmProperties.DZWeight))
{
entity.DZWeight = result.DZWeight;
}
if (fields.Contains(TMSAlgorithmProperties.JCWeight))
{
entity.JCWeight = result.JCWeight;
}
if (fields.Contains(TMSAlgorithmProperties.PLWeight))
{
entity.PLWeight = result.PLWeight;
}
}
public static TMSAlgorithm DbSelect(this TMSAlgorithm entity, DbSession session, params PDMDbProperty[] fields)
{
var query = IORMProvider.GetDbQueryBuilder(session);
SelectBuilder builder = new SelectBuilder();
if (fields.Count() == 0)
{
builder.ComponentSelect.Add(TMSAlgorithmProperties.AlgorithmId);
builder.ComponentSelect.Add(TMSAlgorithmProperties.Name);
builder.ComponentSelect.Add(TMSAlgorithmProperties.Type);
builder.ComponentSelect.Add(TMSAlgorithmProperties.DZWeight);
builder.ComponentSelect.Add(TMSAlgorithmProperties.JCWeight);
builder.ComponentSelect.Add(TMSAlgorithmProperties.PLWeight);
}
else
{
builder.ComponentSelect.Add(TMSAlgorithmProperties.AlgorithmId);
foreach (var field in fields)
{
builder.ComponentSelect.Add(field);
}
}
builder.ComponentWhere.Add(new ComponentValueOfWhere(TMSAlgorithmProperties.AlgorithmId, entity.AlgorithmId, LocateType.Equal));
query.SelectBuilders.Add(builder);
return(IORMProvider.GetQueryOperator(session).Select <TMSAlgorithm>(session, query));
}
public static bool DbDelete(this TMSAlgorithm entity, DbSession session)
{
var query = IORMProvider.GetDbQueryBuilder(session);
query.DeleteBuilder.ComponentWhere.Add(new ComponentValueOfWhere(TMSAlgorithmProperties.AlgorithmId, entity.AlgorithmId, LocateType.Equal));
return(IORMProvider.GetQueryOperator(session).Delete <TMSAlgorithm>(session, query));
}
public static bool FetchMSAlgorithmSettings(this TMSAlgorithm tMSAlgorithm, DbSession session)
{
var query = IORMProvider.GetDbQueryBuilder(session);
SelectBuilder builder = new SelectBuilder();
builder.ComponentWhere.Add(new ComponentValueOfWhere(TMSAlgorithmSettingsProperties.AlgorithmId, tMSAlgorithm.AlgorithmId, LocateType.Equal));
query.SelectBuilders.Add(builder);
tMSAlgorithm.MSAlgorithmSettings = IORMProvider.GetQueryOperator(session).SelectAll <TMSAlgorithmSettings>(session, query);
return(tMSAlgorithm.MSAlgorithmSettings.Count > 0);
}
public static bool DbInsert(this TMSAlgorithm entity, DbSession session)
{
var query = IORMProvider.GetDbQueryBuilder(session);
InsertBuilder builder = new InsertBuilder();
builder.ComponentInsert.Add(new ComponentValueOfInsert(TMSAlgorithmProperties.AlgorithmId, entity.AlgorithmId));
if (entity.Name == null)
{
throw new NotImplementedException("缺少必填的参数项值, 参数项: " + nameof(entity.Name));
}
builder.ComponentInsert.Add(new ComponentValueOfInsert(TMSAlgorithmProperties.Name, entity.Name));
builder.ComponentInsert.Add(new ComponentValueOfInsert(TMSAlgorithmProperties.Type, entity.Type));
builder.ComponentInsert.Add(new ComponentValueOfInsert(TMSAlgorithmProperties.DZWeight, entity.DZWeight));
builder.ComponentInsert.Add(new ComponentValueOfInsert(TMSAlgorithmProperties.JCWeight, entity.JCWeight));
builder.ComponentInsert.Add(new ComponentValueOfInsert(TMSAlgorithmProperties.PLWeight, entity.PLWeight));
query.InsertBuilders.Add(builder);
return(IORMProvider.GetQueryOperator(session).Insert <TMSAlgorithm>(session, query));
}
public static bool DbUpdate(this TMSAlgorithm entity, DbSession session, params PDMDbProperty[] fields)
{
var query = IORMProvider.GetDbQueryBuilder(session);
UpdateBuilder builder = new UpdateBuilder();
builder.ComponentWhere.Add(new ComponentValueOfWhere(TMSAlgorithmProperties.AlgorithmId, entity.AlgorithmId, LocateType.Equal));
if (fields == null || fields.Length == 0)
{
builder.ComponentSet.Add(new ComponentValueOfSet(TMSAlgorithmProperties.AlgorithmId, entity.AlgorithmId));
builder.ComponentSet.Add(new ComponentValueOfSet(TMSAlgorithmProperties.Name, entity.Name));
builder.ComponentSet.Add(new ComponentValueOfSet(TMSAlgorithmProperties.Type, entity.Type));
builder.ComponentSet.Add(new ComponentValueOfSet(TMSAlgorithmProperties.DZWeight, entity.DZWeight));
builder.ComponentSet.Add(new ComponentValueOfSet(TMSAlgorithmProperties.JCWeight, entity.JCWeight));
builder.ComponentSet.Add(new ComponentValueOfSet(TMSAlgorithmProperties.PLWeight, entity.PLWeight));
}
else
{
if (fields.Contains(TMSAlgorithmProperties.Name))
{
builder.ComponentSet.Add(new ComponentValueOfSet(TMSAlgorithmProperties.Name, entity.Name));
}
if (fields.Contains(TMSAlgorithmProperties.Type))
{
builder.ComponentSet.Add(new ComponentValueOfSet(TMSAlgorithmProperties.Type, entity.Type));
}
if (fields.Contains(TMSAlgorithmProperties.DZWeight))
{
builder.ComponentSet.Add(new ComponentValueOfSet(TMSAlgorithmProperties.DZWeight, entity.DZWeight));
}
if (fields.Contains(TMSAlgorithmProperties.JCWeight))
{
builder.ComponentSet.Add(new ComponentValueOfSet(TMSAlgorithmProperties.JCWeight, entity.JCWeight));
}
if (fields.Contains(TMSAlgorithmProperties.PLWeight))
{
builder.ComponentSet.Add(new ComponentValueOfSet(TMSAlgorithmProperties.PLWeight, entity.PLWeight));
}
}
query.UpdateBuilders.Add(builder);
return(IORMProvider.GetQueryOperator(session).Update <TMSAlgorithm>(session, query));
}