private void Export_GetConditionString(MySqlDataReader rdr, MySqlTable table, StringBuilder sb) { bool isFirst = true; for (int i = 0; i < rdr.FieldCount; i++) { string colName = rdr.GetName(i); var col = table.Columns[colName]; if (col.IsPrimaryKey) { if (isFirst) { isFirst = false; } else { sb.Append(" and "); } sb.Append("`"); sb.Append(colName); sb.Append("`="); sb.Append(QueryExpress.ConvertToSqlFormat(rdr, i, true, true, col)); } } }
private string Export_GetValueString(MySqlDataReader rdr, MySqlTable table) { StringBuilder sb = new StringBuilder(); for (int i = 0; i < rdr.FieldCount; i++) { if (sb.Length == 0) { sb.AppendFormat("("); } else { sb.AppendFormat(","); } string columnName = rdr.GetName(i); object ob = rdr[i]; var col = table.Columns[columnName]; sb.Append(QueryExpress.ConvertToSqlFormat(rdr, i, true, true, col)); } sb.AppendFormat(")"); return(sb.ToString()); }
private static void Export_GetUpdateString(MySqlDataReader rdr, MySqlTable table, StringBuilder sb) { var isFirst = true; for (var i = 0; i < rdr.FieldCount; i++) { var colName = rdr.GetName(i); var col = table.Columns[colName]; if (!col.IsPrimaryKey) { if (isFirst) { isFirst = false; } else { sb.Append(","); } sb.Append("`"); sb.Append(colName); sb.Append("`="); sb.Append(QueryExpress.ConvertToSqlFormat(rdr, i, true, true, col)); } } }
private string Export_GetValueString(MySqlDataReader rdr, MySqlTable table) { StringBuilder sb = new StringBuilder(); for (int i = 0; i < rdr.FieldCount; i++) { string columnName = rdr.GetName(i); if (table.Columns[columnName].IsGeneratedColumn) { continue; } if (sb.Length == 0) { sb.AppendFormat("("); } else { sb.AppendFormat(","); } object ob = rdr[i]; var col = table.Columns[columnName]; //sb.Append(QueryExpress.ConvertToSqlFormat(rdr, i, true, true, col)); sb.Append(QueryExpress.ConvertToSqlFormat(ob, true, true, col, ExportInfo.BlobExportMode)); } sb.AppendFormat(")"); return(sb.ToString()); }
private static string Export_GetValueString(MySqlDataReader rdr, MySqlTable table) { var sb = new StringBuilder(); for (var i = 0; i < rdr.FieldCount; i++) { sb.AppendFormat(sb.Length == 0 ? "(" : ","); var columnName = rdr.GetName(i); var col = table.Columns[columnName]; sb.Append(QueryExpress.ConvertToSqlFormat(rdr, i, true, true, col)); } sb.AppendFormat(")"); return(sb.ToString()); }