public static SqlCommand Create(Type type, params string[] columnValue) { string[] columns = new string[columnValue.Length / 2]; string[] values = new string[columnValue.Length / 2]; int j = 0; for (int i = 0; i < columnValue.Length; i = i + 2) { columns[j] = columnValue[i]; if (columnValue[i + 1] == null) { values[j] = ""; } else { values[j] = columnValue[i + 1]; } j++; } SqlCommand result = new SqlCommand(); result.CommandText = CreateCommandText(columns, type); CommonCommandMaker <T> .AddParameters(columns, values, result); return(result); }
private static string CreateCommandText(string[] columns, Type type) { StringBuilder commandText = new StringBuilder(); var tableName = '\"' + type.Name + '\"'; var wherelike = CommonCommandMaker <T> .WhereLikeConditionCreate(columns); commandText.Append($"SELECT * FROM {tableName} {wherelike}"); return(commandText.ToString()); }
public static SqlCommand Create(T obj) { SqlCommand result = new SqlCommand(); result.CommandText = CreateCommandText(obj); CommonCommandMaker <T> .AddParameters(obj, result); return(result); }
private static string CreateCommandText(T obj) { StringBuilder commandText = new StringBuilder(); var tableName = '\"' + obj.GetType().Name + '\"'; var columns = CreateValuesString(obj); string[] columnValues = { "Id" }; var where = CommonCommandMaker <T> .WhereConditionCreate(columnValues); commandText.Append($"UPDATE {tableName} SET {columns} {where}"); return(commandText.ToString()); }