private string GetModelParamCode()
{
StringBuilder result = new StringBuilder();
for (int i = 0; i < _columnsModels.Count; i++)
{
var columnModel = _columnsModels[i];
if (columnModel.IS_NULLABLE == "YES")
{
result.AppendFormat("{0}model.{1} = reader.IsDBNull ? null: reader.GetFieldValue<{2}>({3});\n",
CodeHelp.Tab5(),
CodeHelp.CamelCase(columnModel.COLUMN_NAME),
CodeHelp.GetCSharpTypeString(columnModel.DATA_TYPE, false),
i);
}
else
{
result.AppendFormat("{0}model.{1} = reader.GetFieldValue<{2}>({3});\n",
CodeHelp.Tab5(),
CodeHelp.CamelCase(columnModel.COLUMN_NAME),
CodeHelp.GetCSharpTypeString(columnModel.DATA_TYPE, false),
i);
}
}
return(result.ToString());
}
private string GetKeyParamtersCode()
{
StringBuilder result = new StringBuilder();
foreach (var columnModel in _columnsModels)
{
if (columnModel.COLUMN_KEY == "PRI")
{
result.AppendLine(CodeHelp.Tab4() + "cmd.Parameters.Add(new MySqlParameter");
result.AppendLine(CodeHelp.Tab4() + "{");
result.AppendFormat(CodeHelp.Tab5() + "ParameterName = \"@{0}\",\n",
CodeHelp.CamelCase(columnModel.COLUMN_NAME));
result.AppendFormat(CodeHelp.Tab5() + "DbType = DbType.{0},\n",
CodeHelp.GetMySqlDBTypeString(columnModel.DATA_TYPE));
result.AppendFormat(CodeHelp.Tab5() + "Value = {0},\n",
CodeHelp.FirstLower(CodeHelp.CamelCase(columnModel.COLUMN_NAME)));
result.AppendLine(CodeHelp.Tab4() + "});");
}
}
return(result.ToString());
}
