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