public static bool DbUpdate(this TAreaEvent entity, DbSession session, params PDMDbProperty[] fields)
{
var query = IORMProvider.GetDbQueryBuilder(session);
UpdateBuilder builder = new UpdateBuilder();
builder.ComponentWhere.Add(new ComponentValueOfWhere(TAreaEventProperties.AreaId, entity.AreaId, LocateType.Equal));
builder.ComponentWhere.Add(new ComponentValueOfWhere(TAreaEventProperties.EventId, entity.EventId, LocateType.Equal));
builder.ComponentWhere.Add(new ComponentValueOfWhere(TAreaEventProperties.RoundNum, entity.RoundNum, LocateType.Equal));
if (fields == null || fields.Length == 0)
{
builder.ComponentSet.Add(new ComponentValueOfSet(TAreaEventProperties.AreaId, entity.AreaId));
builder.ComponentSet.Add(new ComponentValueOfSet(TAreaEventProperties.EventId, entity.EventId));
builder.ComponentSet.Add(new ComponentValueOfSet(TAreaEventProperties.RoundNum, entity.RoundNum));
}
else
{
}
query.UpdateBuilders.Add(builder);
return(IORMProvider.GetQueryOperator(session).Update <TAreaEvent>(session, query));
}
public static bool DbUpdate(this TCreature entity, DbSession session, params PDMDbProperty[] fields)
{
var query = IORMProvider.GetDbQueryBuilder(session);
UpdateBuilder builder = new UpdateBuilder();
builder.ComponentWhere.Add(new ComponentValueOfWhere(TCreatureProperties.CreatureId, entity.CreatureId, LocateType.Equal));
if (fields == null || fields.Length == 0)
{
builder.ComponentSet.Add(new ComponentValueOfSet(TCreatureProperties.CreatureId, entity.CreatureId));
builder.ComponentSet.Add(new ComponentValueOfSet(TCreatureProperties.CreatureType, entity.CreatureType));
builder.ComponentSet.Add(new ComponentValueOfSet(TCreatureProperties.Name, entity.Name));
builder.ComponentSet.Add(new ComponentValueOfSet(TCreatureProperties.Experience, entity.Experience));
builder.ComponentSet.Add(new ComponentValueOfSet(TCreatureProperties.Level, entity.Level));
builder.ComponentSet.Add(new ComponentValueOfSet(TCreatureProperties.Profession, entity.Profession));
}
else
{
if (fields.Contains(TCreatureProperties.CreatureType))
{
builder.ComponentSet.Add(new ComponentValueOfSet(TCreatureProperties.CreatureType, entity.CreatureType));
}
if (fields.Contains(TCreatureProperties.Name))
{
builder.ComponentSet.Add(new ComponentValueOfSet(TCreatureProperties.Name, entity.Name));
}
if (fields.Contains(TCreatureProperties.Experience))
{
builder.ComponentSet.Add(new ComponentValueOfSet(TCreatureProperties.Experience, entity.Experience));
}
if (fields.Contains(TCreatureProperties.Level))
{
builder.ComponentSet.Add(new ComponentValueOfSet(TCreatureProperties.Level, entity.Level));
}
if (fields.Contains(TCreatureProperties.Profession))
{
builder.ComponentSet.Add(new ComponentValueOfSet(TCreatureProperties.Profession, entity.Profession));
}
}
query.UpdateBuilders.Add(builder);
return(IORMProvider.GetQueryOperator(session).Update <TCreature>(session, query));
}
public static bool DbUpdate(this TUserBasicInfo entity, DbSession session, params PDMDbProperty[] fields)
{
var query = IORMProvider.GetDbQueryBuilder(session);
UpdateBuilder builder = new UpdateBuilder();
builder.ComponentWhere.Add(new ComponentValueOfWhere(TUserBasicInfoProperties.UserId, entity.UserId, LocateType.Equal));
if (fields == null || fields.Length == 0)
{
builder.ComponentSet.Add(new ComponentValueOfSet(TUserBasicInfoProperties.UserId, entity.UserId));
builder.ComponentSet.Add(new ComponentValueOfSet(TUserBasicInfoProperties.Gender, entity.Gender));
builder.ComponentSet.Add(new ComponentValueOfSet(TUserBasicInfoProperties.Birthday, entity.Birthday));
builder.ComponentSet.Add(new ComponentValueOfSet(TUserBasicInfoProperties.Mobile, entity.Mobile));
builder.ComponentSet.Add(new ComponentValueOfSet(TUserBasicInfoProperties.Email, entity.Email));
builder.ComponentSet.Add(new ComponentValueOfSet(TUserBasicInfoProperties.IdCardNumber, entity.IdCardNumber));
}
else
{
if (fields.Contains(TUserBasicInfoProperties.Gender))
{
builder.ComponentSet.Add(new ComponentValueOfSet(TUserBasicInfoProperties.Gender, entity.Gender));
}
if (fields.Contains(TUserBasicInfoProperties.Birthday))
{
builder.ComponentSet.Add(new ComponentValueOfSet(TUserBasicInfoProperties.Birthday, entity.Birthday));
}
if (fields.Contains(TUserBasicInfoProperties.Mobile))
{
builder.ComponentSet.Add(new ComponentValueOfSet(TUserBasicInfoProperties.Mobile, entity.Mobile));
}
if (fields.Contains(TUserBasicInfoProperties.Email))
{
builder.ComponentSet.Add(new ComponentValueOfSet(TUserBasicInfoProperties.Email, entity.Email));
}
if (fields.Contains(TUserBasicInfoProperties.IdCardNumber))
{
builder.ComponentSet.Add(new ComponentValueOfSet(TUserBasicInfoProperties.IdCardNumber, entity.IdCardNumber));
}
}
query.UpdateBuilders.Add(builder);
return(IORMProvider.GetQueryOperator(session).Update <TUserBasicInfo>(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));
}
public static bool DbUpdate(this TArea entity, DbSession session, params PDMDbProperty[] fields)
{
var query = IORMProvider.GetDbQueryBuilder(session);
UpdateBuilder builder = new UpdateBuilder();
builder.ComponentWhere.Add(new ComponentValueOfWhere(TAreaProperties.AreaId, entity.AreaId, LocateType.Equal));
if (fields == null || fields.Length == 0)
{
builder.ComponentSet.Add(new ComponentValueOfSet(TAreaProperties.AreaId, entity.AreaId));
builder.ComponentSet.Add(new ComponentValueOfSet(TAreaProperties.AreaName, entity.AreaName));
builder.ComponentSet.Add(new ComponentValueOfSet(TAreaProperties.AreaLevel, entity.AreaLevel));
builder.ComponentSet.Add(new ComponentValueOfSet(TAreaProperties.AreaType, entity.AreaType));
builder.ComponentSet.Add(new ComponentValueOfSet(TAreaProperties.Description, entity.Description));
builder.ComponentSet.Add(new ComponentValueOfSet(TAreaProperties.DescriptionEx, entity.DescriptionEx));
}
else
{
if (fields.Contains(TAreaProperties.AreaName))
{
builder.ComponentSet.Add(new ComponentValueOfSet(TAreaProperties.AreaName, entity.AreaName));
}
if (fields.Contains(TAreaProperties.AreaLevel))
{
builder.ComponentSet.Add(new ComponentValueOfSet(TAreaProperties.AreaLevel, entity.AreaLevel));
}
if (fields.Contains(TAreaProperties.AreaType))
{
builder.ComponentSet.Add(new ComponentValueOfSet(TAreaProperties.AreaType, entity.AreaType));
}
if (fields.Contains(TAreaProperties.Description))
{
builder.ComponentSet.Add(new ComponentValueOfSet(TAreaProperties.Description, entity.Description));
}
if (fields.Contains(TAreaProperties.DescriptionEx))
{
builder.ComponentSet.Add(new ComponentValueOfSet(TAreaProperties.DescriptionEx, entity.DescriptionEx));
}
}
query.UpdateBuilders.Add(builder);
return(IORMProvider.GetQueryOperator(session).Update <TArea>(session, query));
}
public static bool DbInsert(this List <TCreature> entities, DbSession session)
{
var query = IORMProvider.GetDbQueryBuilder(session);
foreach (var entity in entities)
{
InsertBuilder builder = new InsertBuilder();
builder.ComponentInsert.Add(new ComponentValueOfInsert(TCreatureProperties.CreatureId, entity.CreatureId));
builder.ComponentInsert.Add(new ComponentValueOfInsert(TCreatureProperties.CreatureType, entity.CreatureType));
if (entity.Name == null)
{
throw new NotImplementedException("缺少必填的参数项值, 参数项: " + nameof(entity.Name));
}
builder.ComponentInsert.Add(new ComponentValueOfInsert(TCreatureProperties.Name, entity.Name));
builder.ComponentInsert.Add(new ComponentValueOfInsert(TCreatureProperties.Experience, entity.Experience));
builder.ComponentInsert.Add(new ComponentValueOfInsert(TCreatureProperties.Level, entity.Level));
builder.ComponentInsert.Add(new ComponentValueOfInsert(TCreatureProperties.Profession, entity.Profession));
query.InsertBuilders.Add(builder);
}
return(IORMProvider.GetQueryOperator(session).InsertAll <TCreature>(session, query));
}
public static bool DbInsert(this List <TMSAlgorithm> entities, DbSession session)
{
var query = IORMProvider.GetDbQueryBuilder(session);
foreach (var entity in entities)
{
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).InsertAll <TMSAlgorithm>(session, query));
}
public static bool DbUpdate(this List <TTeamCreature> entities, DbSession session, params PDMDbProperty[] fields)
{
var query = IORMProvider.GetDbQueryBuilder(session);
foreach (var entity in entities)
{
UpdateBuilder builder = new UpdateBuilder();
builder.ComponentWhere.Add(new ComponentValueOfWhere(TTeamCreatureProperties.TeamId, entity.TeamId, LocateType.Equal));
builder.ComponentWhere.Add(new ComponentValueOfWhere(TTeamCreatureProperties.CreatureId, entity.CreatureId, LocateType.Equal));
if (fields == null || fields.Length == 0)
{
builder.ComponentSet.Add(new ComponentValueOfSet(TTeamCreatureProperties.TeamId, entity.TeamId));
builder.ComponentSet.Add(new ComponentValueOfSet(TTeamCreatureProperties.CreatureId, entity.CreatureId));
}
else
{
}
query.UpdateBuilders.Add(builder);
}
return(IORMProvider.GetQueryOperator(session).UpdateAll <TTeamCreature>(session, query));
}
public static bool DbUpdate(this TGrabRequest entity, DbSession session, params PDMDbProperty[] fields)
{
var query = IORMProvider.GetDbQueryBuilder(session);
UpdateBuilder builder = new UpdateBuilder();
builder.ComponentWhere.Add(new ComponentValueOfWhere(TGrabRequestProperties.SpiderId, entity.SpiderId, LocateType.Equal));
builder.ComponentWhere.Add(new ComponentValueOfWhere(TGrabRequestProperties.GrabType, entity.GrabType, LocateType.Equal));
builder.ComponentWhere.Add(new ComponentValueOfWhere(TGrabRequestProperties.IssueName, entity.IssueName, LocateType.Equal));
if (fields == null || fields.Length == 0)
{
builder.ComponentSet.Add(new ComponentValueOfSet(TGrabRequestProperties.RequestId, entity.RequestId));
builder.ComponentSet.Add(new ComponentValueOfSet(TGrabRequestProperties.SpiderId, entity.SpiderId));
builder.ComponentSet.Add(new ComponentValueOfSet(TGrabRequestProperties.GrabType, entity.GrabType));
builder.ComponentSet.Add(new ComponentValueOfSet(TGrabRequestProperties.IssueName, entity.IssueName));
builder.ComponentSet.Add(new ComponentValueOfSet(TGrabRequestProperties.SpiderName, entity.SpiderName));
builder.ComponentSet.Add(new ComponentValueOfSet(TGrabRequestProperties.ProcessStatus, entity.ProcessStatus));
builder.ComponentSet.Add(new ComponentValueOfSet(TGrabRequestProperties.Message, entity.Message));
}
else
{
if (fields.Contains(TGrabRequestProperties.RequestId))
{
builder.ComponentSet.Add(new ComponentValueOfSet(TGrabRequestProperties.RequestId, entity.RequestId));
}
if (fields.Contains(TGrabRequestProperties.SpiderName))
{
builder.ComponentSet.Add(new ComponentValueOfSet(TGrabRequestProperties.SpiderName, entity.SpiderName));
}
if (fields.Contains(TGrabRequestProperties.ProcessStatus))
{
builder.ComponentSet.Add(new ComponentValueOfSet(TGrabRequestProperties.ProcessStatus, entity.ProcessStatus));
}
if (fields.Contains(TGrabRequestProperties.Message))
{
builder.ComponentSet.Add(new ComponentValueOfSet(TGrabRequestProperties.Message, entity.Message));
}
}
query.UpdateBuilders.Add(builder);
return(IORMProvider.GetQueryOperator(session).Update <TGrabRequest>(session, query));
}
public static bool DbInsert(this List <TGrabList> entities, DbSession session)
{
var query = IORMProvider.GetDbQueryBuilder(session);
foreach (var entity in entities)
{
InsertBuilder builder = new InsertBuilder();
builder.ComponentInsert.Add(new ComponentValueOfInsert(TGrabListProperties.ListItemId, entity.ListItemId));
builder.ComponentInsert.Add(new ComponentValueOfInsert(TGrabListProperties.SpiderId, entity.SpiderId));
if (entity.IssueName == null)
{
throw new NotImplementedException("缺少必填的参数项值, 参数项: " + nameof(entity.IssueName));
}
builder.ComponentInsert.Add(new ComponentValueOfInsert(TGrabListProperties.IssueName, entity.IssueName));
builder.ComponentInsert.Add(new ComponentValueOfInsert(TGrabListProperties.OrderNumber, entity.OrderNumber));
if (entity.Title == null)
{
throw new NotImplementedException("缺少必填的参数项值, 参数项: " + nameof(entity.Title));
}
builder.ComponentInsert.Add(new ComponentValueOfInsert(TGrabListProperties.Title, entity.Title));
if (entity.URL == null)
{
throw new NotImplementedException("缺少必填的参数项值, 参数项: " + nameof(entity.URL));
}
builder.ComponentInsert.Add(new ComponentValueOfInsert(TGrabListProperties.URL, entity.URL));
if (entity.Remark == null)
{
throw new NotImplementedException("缺少必填的参数项值, 参数项: " + nameof(entity.Remark));
}
builder.ComponentInsert.Add(new ComponentValueOfInsert(TGrabListProperties.Remark, entity.Remark));
if (entity.DetailFilePath == null)
{
throw new NotImplementedException("缺少必填的参数项值, 参数项: " + nameof(entity.DetailFilePath));
}
builder.ComponentInsert.Add(new ComponentValueOfInsert(TGrabListProperties.DetailFilePath, entity.DetailFilePath));
query.InsertBuilders.Add(builder);
}
return(IORMProvider.GetQueryOperator(session).InsertAll <TGrabList>(session, query));
}
public static TTeam DbSelect(this TTeam entity, DbSession session, params PDMDbProperty[] fields)
{
var query = IORMProvider.GetDbQueryBuilder(session);
SelectBuilder builder = new SelectBuilder();
if (fields.Count() == 0)
{
builder.ComponentSelect.Add(TTeamProperties.TeamId);
builder.ComponentSelect.Add(TTeamProperties.Name);
}
else
{
builder.ComponentSelect.Add(TTeamProperties.TeamId);
foreach (var field in fields)
{
builder.ComponentSelect.Add(field);
}
}
builder.ComponentWhere.Add(new ComponentValueOfWhere(TTeamProperties.TeamId, entity.TeamId, LocateType.Equal));
query.SelectBuilders.Add(builder);
return(IORMProvider.GetQueryOperator(session).Select <TTeam>(session, query));
}
public static bool DbInsert(this List <TUser> entities, DbSession session)
{
var query = IORMProvider.GetDbQueryBuilder(session);
foreach (var entity in entities)
{
InsertBuilder builder = new InsertBuilder();
if (entity.UserName == null)
{
throw new NotImplementedException("缺少必填的参数项值, 参数项: " + nameof(entity.UserName));
}
builder.ComponentInsert.Add(new ComponentValueOfInsert(TUserProperties.UserName, entity.UserName));
if (entity.Password == null)
{
throw new NotImplementedException("缺少必填的参数项值, 参数项: " + nameof(entity.Password));
}
builder.ComponentInsert.Add(new ComponentValueOfInsert(TUserProperties.Password, entity.Password));
builder.ComponentInsert.Add(new ComponentValueOfInsert(TUserProperties.CreateTime, entity.CreateTime));
query.InsertBuilders.Add(builder);
}
return(IORMProvider.GetQueryOperator(session).InsertAll <TUser>(session, query));
}
public static TCreatureQuality DbSelect(this TCreatureQuality entity, DbSession session, params PDMDbProperty[] fields)
{
var query = IORMProvider.GetDbQueryBuilder(session);
SelectBuilder builder = new SelectBuilder();
if (fields.Count() == 0)
{
builder.ComponentSelect.Add(TCreatureQualityProperties.CreatureId);
builder.ComponentSelect.Add(TCreatureQualityProperties.FirstLevelQuality);
builder.ComponentSelect.Add(TCreatureQualityProperties.SecondLevelQuality);
builder.ComponentSelect.Add(TCreatureQualityProperties.ThirdLevelQuality);
}
else
{
builder.ComponentSelect.Add(TCreatureQualityProperties.CreatureId);
foreach (var field in fields)
{
builder.ComponentSelect.Add(field);
}
}
builder.ComponentWhere.Add(new ComponentValueOfWhere(TCreatureQualityProperties.CreatureId, entity.CreatureId, LocateType.Equal));
query.SelectBuilders.Add(builder);
return(IORMProvider.GetQueryOperator(session).Select <TCreatureQuality>(session, query));
}
