...{
private string m_strUpdate; public override void Add(string name, object val)
...{ if (val == null) ...{ this.Add(name, "null", false);
} else ...{ this.Add(name, val.ToString(), val is string || val is DateTime); } } private void Add(string name, string val, bool isref) ...{ if (isref) ...{ val = "'" + val + "'"; } if (this.m_strUpdate == string.Empty) ...{ this.m_strUpdate = "[" + name + "]=" + val; } else ...{ this.m_strUpdate += ",[" + name + "]=" + val; } } protected override string ToStr ...{ get ...{ return "UPDATE [" + base.TableName + "] SET " + this.m_strUpdate; } } protected override void auxClear() ...{ this.m_strUpdate = string.Empty; }
}
private class Select : BaseClause ...{ private string m_strSelect; public override void Add(string name, object alis) ...{ if (alis == null) ...{ this.Add(name, name, false); } else ...{ this.Add(name, alis.ToString(), false); } } private void Add(string name, string alis, bool isref) ...{ if (this.m_strSelect == string.Empty) ...{ this.m_strSelect = "[" + name + "] as [" + alis + "]"; } else ...{ this.m_strSelect += ",[" + name + "] as [" + alis + "]"; } } protected override string ToStr ...{ get ...{ if (this.m_strSelect == string.Empty) ...{ this.m_strSelect = "*"; } return "SELECT " + this.m_strSelect + " FROM [" + base.TableName + "]"; } } protected override void auxClear() ...{ this.m_strSelect = string.Empty; } }
