public override SqlStatement GetDeleteStatement(Condition iwc)
{
var sb = new UpdateStatementBuilder(Context.Info.From);
sb.Values.Add(new KeyOpValue(_columnName, true, KvOpertation.None));
sb.Where.Conditions = iwc && _colExp;
return sb.ToSqlStatement(Context);
}
public override void AddColumn(ModelContext ctx, string columnName, object o)
{
base.AddColumn(ctx, columnName, null);
if(o != null)
{
var stm = new UpdateStatementBuilder(ctx.Info.From);
stm.Values.Add(new KeyOpValue(columnName, o, KvOpertation.None));
var sql = stm.ToSqlStatement(ctx);
ctx.Provider.ExecuteNonQuery(sql);
}
}
private int ProcessHasManyAndHasOne(IDbObject obj)
{
var result = 0;
foreach (var member in Info.RelationMembers)
{
if (member.Is.HasMany || member.Is.HasOne)
{
var t = member.MemberInfo.MemberType.GetGenericArguments()[0];
var ctx0 = ModelContext.GetInstance(t);
ctx0.Operator.Fixer.TryFix();
var sb = new UpdateStatementBuilder(ctx0.Info.From);
var key = ctx0.Info.GetBelongsTo(Info.HandleType).Name;
sb.Values.Add(new KeyOpValue(key, null, KvOpertation.None));
sb.Where.Conditions = CK.K[key] == Handler.GetKeyValue(obj);
var sql = sb.ToSqlStatement(ctx0);
result += ctx0.Provider.ExecuteNonQuery(sql);
}
}
return result;
}
public override SqlStatement GetUpdateStatement(object obj, Condition iwc)
{
var sb = new UpdateStatementBuilder(Context.Info.From);
Context.Handler.SetValuesForUpdate(sb, obj);
var lv = (int)Context.Info.LockVersion.GetValue(obj);
sb.Where.Conditions = iwc && (CK.K[Context.Info.LockVersion.Name] == lv);
bool find = false;
foreach (var kv in sb.Values)
{
if (kv.Key == Context.Info.LockVersion.Name)
{
kv.Value = lv + 1;
find = true;
break;
}
}
if (!find)
{
sb.Values.Add(new KeyOpValue(Context.Info.LockVersion.Name, lv + 1, KvOpertation.None));
}
return sb.ToSqlStatement(Context);
}
public virtual SqlStatement GetUpdateStatement(Condition iwc, object obj)
{
var isv = new UpdateStatementBuilder(this.Context.Info.From);
foreach(var property in obj.GetType().GetProperties())
{
isv.Values.Add(new KeyOpValue(property.Name, property.GetValue(obj, null), KvOpertation.None));
}
isv.Where.Conditions = iwc;
return isv.ToSqlStatement(this.Context);
}
public virtual SqlStatement GetUpdateStatement(object obj, Condition iwc)
{
var isv = new UpdateStatementBuilder(this.Context.Info.From);
var o = obj as DbObjectSmartUpdate;
if (o != null) {
if (!o.FindUpdateColumns (isv)) {
return null;
}
} else {
this.Context.Handler.SetValuesForUpdate(isv, obj);
}
isv.Where.Conditions = iwc;
return isv.ToSqlStatement(this.Context);
}
