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