/// <summary>
/// 未查询到数据时返回 null
/// </summary>
public static TEarthworkBlock DbSelect(this TEarthworkBlock entity, DbSession session, params PDMDbProperty[] fields)
{
var query = session.GetDbQueryBuilder();
SelectBuilder builder = new SelectBuilder();
if (fields.Count() == 0)
{
builder.ComponentSelect.Add(TEarthworkBlockProperties.Segregation);
builder.ComponentSelect.Add(TEarthworkBlockProperties.IssueDateTime);
builder.ComponentSelect.Add(TEarthworkBlockProperties.Id);
builder.ComponentSelect.Add(TEarthworkBlockProperties.Indexer);
builder.ComponentSelect.Add(TEarthworkBlockProperties.Name);
builder.ComponentSelect.Add(TEarthworkBlockProperties.Description);
builder.ComponentSelect.Add(TEarthworkBlockProperties.CPSettings);
builder.ComponentSelect.Add(TEarthworkBlockProperties.EarthworkBlockImplementationInfo);
}
else
{
builder.ComponentSelect.Add(TEarthworkBlockProperties.Segregation);
builder.ComponentSelect.Add(TEarthworkBlockProperties.IssueDateTime);
builder.ComponentSelect.Add(TEarthworkBlockProperties.Id);
foreach (var field in fields)
{
builder.ComponentSelect.Add(field);
}
}
builder.ComponentWhere.Add(new ComponentValueOfWhere(TEarthworkBlockProperties.Segregation, entity.Segregation, LocateType.Equal));
builder.ComponentWhere.Add(new ComponentValueOfWhere(TEarthworkBlockProperties.IssueDateTime, entity.IssueDateTime, LocateType.Equal));
builder.ComponentWhere.Add(new ComponentValueOfWhere(TEarthworkBlockProperties.Id, entity.Id, LocateType.Equal));
query.SelectBuilders.Add(builder);
return(session.GetQueryOperator().Select <TEarthworkBlock>(query));
}
/// <summary>
/// 未查询到数据时返回 null
/// </summary>
public static TEarthworkBlock DbSelect(this TEarthworkBlock entity, DbSession session, SelectBuilder select)
{
var query = session.GetDbQueryBuilder();
query.SelectBuilder = select;
return(session.GetQueryOperator().Select <TEarthworkBlock>(query));
}
public static bool DbDelete(this TEarthworkBlock entity, DbSession session)
{
var query = session.GetDbQueryBuilder();
query.DeleteBuilder.ComponentWhere.Add(new ComponentValueOfWhere(TEarthworkBlockProperties.Segregation, entity.Segregation, LocateType.Equal));
query.DeleteBuilder.ComponentWhere.Add(new ComponentValueOfWhere(TEarthworkBlockProperties.IssueDateTime, entity.IssueDateTime, LocateType.Equal));
query.DeleteBuilder.ComponentWhere.Add(new ComponentValueOfWhere(TEarthworkBlockProperties.Id, entity.Id, LocateType.Equal));
return(session.GetQueryOperator().Delete <TEarthworkBlock>(query));
}
public static bool DbInsert(this TEarthworkBlock entity, DbSession session)
{
var query = session.GetDbQueryBuilder();
InsertBuilder builder = new InsertBuilder();
if (entity.Segregation == null)
{
throw new NotImplementedException("缺少必填的参数项值, 参数项: " + nameof(entity.Segregation));
}
if (entity.Segregation.Length > 36)
{
throw new NotImplementedException(string.Format("参数项:{0}长度:{1}超过额定限制:{2}", nameof(entity.Segregation), entity.Segregation.Length, 36));
}
builder.ComponentInsert.Add(new ComponentValueOfInsert(TEarthworkBlockProperties.Segregation, entity.Segregation));
builder.ComponentInsert.Add(new ComponentValueOfInsert(TEarthworkBlockProperties.IssueDateTime, entity.IssueDateTime));
builder.ComponentInsert.Add(new ComponentValueOfInsert(TEarthworkBlockProperties.Id, entity.Id));
builder.ComponentInsert.Add(new ComponentValueOfInsert(TEarthworkBlockProperties.Indexer, entity.Indexer));
if (entity.Name == null)
{
throw new NotImplementedException("缺少必填的参数项值, 参数项: " + nameof(entity.Name));
}
if (entity.Name.Length > 100)
{
throw new NotImplementedException(string.Format("参数项:{0}长度:{1}超过额定限制:{2}", nameof(entity.Name), entity.Name.Length, 100));
}
builder.ComponentInsert.Add(new ComponentValueOfInsert(TEarthworkBlockProperties.Name, entity.Name));
if (entity.Description == null)
{
throw new NotImplementedException("缺少必填的参数项值, 参数项: " + nameof(entity.Description));
}
if (entity.Description.Length > 1000)
{
throw new NotImplementedException(string.Format("参数项:{0}长度:{1}超过额定限制:{2}", nameof(entity.Description), entity.Description.Length, 1000));
}
builder.ComponentInsert.Add(new ComponentValueOfInsert(TEarthworkBlockProperties.Description, entity.Description));
if (entity.CPSettings == null)
{
throw new NotImplementedException("缺少必填的参数项值, 参数项: " + nameof(entity.CPSettings));
}
if (entity.CPSettings.Length > 1000)
{
throw new NotImplementedException(string.Format("参数项:{0}长度:{1}超过额定限制:{2}", nameof(entity.CPSettings), entity.CPSettings.Length, 1000));
}
builder.ComponentInsert.Add(new ComponentValueOfInsert(TEarthworkBlockProperties.CPSettings, entity.CPSettings));
if (entity.EarthworkBlockImplementationInfo == null)
{
throw new NotImplementedException("缺少必填的参数项值, 参数项: " + nameof(entity.EarthworkBlockImplementationInfo));
}
if (entity.EarthworkBlockImplementationInfo.Length > 1000)
{
throw new NotImplementedException(string.Format("参数项:{0}长度:{1}超过额定限制:{2}", nameof(entity.EarthworkBlockImplementationInfo), entity.EarthworkBlockImplementationInfo.Length, 1000));
}
builder.ComponentInsert.Add(new ComponentValueOfInsert(TEarthworkBlockProperties.EarthworkBlockImplementationInfo, entity.EarthworkBlockImplementationInfo));
query.InsertBuilders.Add(builder);
return(session.GetQueryOperator().Insert <TEarthworkBlock>(query));
}
public static bool FetchEarthworkBlockElements(this TEarthworkBlock tEarthworkBlock, DbSession session)
{
var query = session.GetDbQueryBuilder();
SelectBuilder builder = new SelectBuilder();
builder.ComponentWhere.Add(new ComponentValueOfWhere(TEarthworkBlockElementProperties.Segregation, tEarthworkBlock.Segregation, LocateType.Equal));
builder.ComponentWhere.Add(new ComponentValueOfWhere(TEarthworkBlockElementProperties.IssueDateTime, tEarthworkBlock.IssueDateTime, LocateType.Equal));
builder.ComponentWhere.Add(new ComponentValueOfWhere(TEarthworkBlockElementProperties.Id, tEarthworkBlock.Id, LocateType.Equal));
query.SelectBuilders.Add(builder);
tEarthworkBlock.EarthworkBlockElements = session.GetQueryOperator().SelectAll <TEarthworkBlockElement>(query);
return(tEarthworkBlock.EarthworkBlockElements.Count > 0);
}
public static bool DbUpdate(this TEarthworkBlock entity, DbSession session, params PDMDbProperty[] fields)
{
var query = session.GetDbQueryBuilder();
UpdateBuilder builder = new UpdateBuilder();
builder.ComponentWhere.Add(new ComponentValueOfWhere(TEarthworkBlockProperties.Segregation, entity.Segregation, LocateType.Equal));
builder.ComponentWhere.Add(new ComponentValueOfWhere(TEarthworkBlockProperties.IssueDateTime, entity.IssueDateTime, LocateType.Equal));
builder.ComponentWhere.Add(new ComponentValueOfWhere(TEarthworkBlockProperties.Id, entity.Id, LocateType.Equal));
if (fields == null || fields.Length == 0)
{
builder.ComponentSet.Add(new ComponentValueOfSet(TEarthworkBlockProperties.Indexer, entity.Indexer));
builder.ComponentSet.Add(new ComponentValueOfSet(TEarthworkBlockProperties.Name, entity.Name));
builder.ComponentSet.Add(new ComponentValueOfSet(TEarthworkBlockProperties.Description, entity.Description));
builder.ComponentSet.Add(new ComponentValueOfSet(TEarthworkBlockProperties.CPSettings, entity.CPSettings));
builder.ComponentSet.Add(new ComponentValueOfSet(TEarthworkBlockProperties.EarthworkBlockImplementationInfo, entity.EarthworkBlockImplementationInfo));
}
else
{
if (fields.Contains(TEarthworkBlockProperties.Indexer))
{
builder.ComponentSet.Add(new ComponentValueOfSet(TEarthworkBlockProperties.Indexer, entity.Indexer));
}
if (fields.Contains(TEarthworkBlockProperties.Name))
{
builder.ComponentSet.Add(new ComponentValueOfSet(TEarthworkBlockProperties.Name, entity.Name));
}
if (fields.Contains(TEarthworkBlockProperties.Description))
{
builder.ComponentSet.Add(new ComponentValueOfSet(TEarthworkBlockProperties.Description, entity.Description));
}
if (fields.Contains(TEarthworkBlockProperties.CPSettings))
{
builder.ComponentSet.Add(new ComponentValueOfSet(TEarthworkBlockProperties.CPSettings, entity.CPSettings));
}
if (fields.Contains(TEarthworkBlockProperties.EarthworkBlockImplementationInfo))
{
builder.ComponentSet.Add(new ComponentValueOfSet(TEarthworkBlockProperties.EarthworkBlockImplementationInfo, entity.EarthworkBlockImplementationInfo));
}
}
query.UpdateBuilders.Add(builder);
return(session.GetQueryOperator().Update <TEarthworkBlock>(query));
}
/// <summary>
/// 存在相应对象时返回true,缺少对象时返回false
/// </summary>
public static bool DbLoad(this TEarthworkBlock entity, DbSession session, params PDMDbProperty[] fields)
{
var result = entity.DbSelect(session, fields);
if (result == null)
{
return(false);
}
if (fields.Count() == 0)
{
entity.Indexer = result.Indexer;
entity.Name = result.Name;
entity.Description = result.Description;
entity.CPSettings = result.CPSettings;
entity.EarthworkBlockImplementationInfo = result.EarthworkBlockImplementationInfo;
}
else
{
if (fields.Contains(TEarthworkBlockProperties.Indexer))
{
entity.Indexer = result.Indexer;
}
if (fields.Contains(TEarthworkBlockProperties.Name))
{
entity.Name = result.Name;
}
if (fields.Contains(TEarthworkBlockProperties.Description))
{
entity.Description = result.Description;
}
if (fields.Contains(TEarthworkBlockProperties.CPSettings))
{
entity.CPSettings = result.CPSettings;
}
if (fields.Contains(TEarthworkBlockProperties.EarthworkBlockImplementationInfo))
{
entity.EarthworkBlockImplementationInfo = result.EarthworkBlockImplementationInfo;
}
}
return(true);
}