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