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); }