/// <summary> /// 准备Where的子句,填写了VersionStartTime。在插入操作时,VST应该是MinValue。否则应该是最后一条记录的时间 /// </summary> /// <param name="obj"></param> /// <param name="mapping"></param> /// <param name="builder"></param> /// <returns></returns> private IConnectiveSqlClause ModifyTimeFieldsInWhereBuilder(T obj, ORMappingItemCollection mapping, WhereSqlClauseBuilder builder) { string startTimeFieldName = GetPropertyFieldName("VersionStartTime", mapping); string endTimeFieldName = GetPropertyFieldName("VersionEndTime", mapping); if (builder.Exists(item => ((SqlClauseBuilderItemIUW)item).DataField == startTimeFieldName) == false) { builder.AppendItem(startTimeFieldName, obj.VersionStartTime); } builder.Remove(b => ((SqlClauseBuilderItemIUW)b).DataField == endTimeFieldName); builder.AppendItem(endTimeFieldName, DBTimePointActionContext.MaxVersionEndTime); return(builder); }
private static WhereSqlClauseBuilder GetExistedKeysBuilder(IConnectiveSqlClause ownerKeyBuilder, T obj, ORMappingItemCollection mapping) { WhereSqlClauseBuilder keyBuilder = ORMapping.GetWhereSqlClauseBuilderByPrimaryKey(obj, mapping); if (obj.VersionStartTime == DateTime.MinValue) { keyBuilder.IfExists(GetPropertyFieldName("VersionStartTime", mapping), item => { item.IsExpression = true; item.Data = DBTimePointActionContext.CurrentTimeTSqlVarName; }); } foreach (string ownerKey in ownerKeyBuilder.GetFields()) { keyBuilder.Remove(item => ((SqlClauseBuilderItemUW)item).DataField == ownerKey); } return(keyBuilder); }