public void Write(ICdlRecord row)
{
WantTransaction();
var sb = new StringBuilder();
sb.AppendFormat("insert into {0} ({1}) values (", TABLE_NAME, ColumnsText);
for (int i = 0; i < row.FieldCount; i++)
{
row.ReadValue(i);
if (i > 0)
{
sb.Append(",");
}
sb.Append((int)row.GetFieldType());
sb.Append(",");
string sqldata;
StorageTool.GetValueAsSqlLiteral(row, out sqldata);
sb.Append(sqldata);
}
sb.Append(")");
using (var inscmd = _conn.CreateCommand())
{
inscmd.Transaction = _tran;
inscmd.CommandText = sb.ToString().Replace("\0", "\\0");
inscmd.ExecuteNonQuery();
_rowCount++;
}
}
public TypeStorage GetFieldType()
{
if (m_fields[m_curField].Changed)
{
if (m_fields[m_curField].Value == null)
{
return(TypeStorage.Null);
}
return(GetDefaultStorage(m_curField));
}
if (m_original != null)
{
return(m_original.GetFieldType());
}
return(TypeStorage.Null);
}
public TypeStorage GetFieldType()
{
return(RefObject.GetFieldType());
}
public void Write(ICdlRecord row)
{
WantTransaction();
var sb = new StringBuilder();
sb.AppendFormat("insert into {0} ({1}) values (", TABLE_NAME, ColumnsText);
for (int i = 0; i < row.FieldCount; i++)
{
row.ReadValue(i);
if (i > 0) sb.Append(",");
sb.Append((int)row.GetFieldType());
sb.Append(",");
string sqldata;
StorageTool.GetValueAsSqlLiteral(row, out sqldata);
sb.Append(sqldata);
}
sb.Append(")");
using (var inscmd = _conn.CreateCommand())
{
inscmd.Transaction = _tran;
inscmd.CommandText = sb.ToString().Replace("\0", "\\0");
inscmd.ExecuteNonQuery();
_rowCount++;
}
}
public string GetDataTypeName(int i)
{
WantField(i);
return(m_record.GetFieldType().GetDotNetType(false).FullName);
}
