private class Insert : BaseClause
...{
private string m_strName;
private string m_strValue;
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_strName == string.Empty)
...{
this.m_strName = "[" + name + "]";
this.m_strValue = val;
}
else
...{
this.m_strName += ",[" + name + "]";
this.m_strValue += "," + val;
}
}
protected override string ToStr
...{
get ...{ return "INSERT INTO [" + base.TableName + "] ( " + this.m_strName + " ) values ( " + this.m_strValue + " )"; }
}
protected override void auxClear()
...{
this.m_strValue = string.Empty;
this.m_strName = string.Empty;
}
}
private class Delete : BaseClause
...{
public Delete()
...{
}
protected override string ToStr
...{
get ...{ return "DELETE FROM [" + base.TableName + "]"; }
}
}
...{
private string m_strName;
private string m_strValue;
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_strName == string.Empty)
...{
this.m_strName = "[" + name + "]";
this.m_strValue = val;
}
else
...{
this.m_strName += ",[" + name + "]";
this.m_strValue += "," + val;
}
}
protected override string ToStr
...{
get ...{ return "INSERT INTO [" + base.TableName + "] ( " + this.m_strName + " ) values ( " + this.m_strValue + " )"; }
}
protected override void auxClear()
...{
this.m_strValue = string.Empty;
this.m_strName = string.Empty;
}
}
private class Delete : BaseClause
...{
public Delete()
...{
}
protected override string ToStr
...{
get ...{ return "DELETE FROM [" + base.TableName + "]"; }
}
}