public static string MybatisUpdate(CodeMakerGeneratCodeOut inModel)
{
var className = inModel.CodeMakerGeneratCodeIn.ClassName;
var tableName = inModel.CodeMakerGeneratCodeIn.Table;
var result = new StringBuilder();
var field_UpdateParams = new StringBuilder();
var field_UpdateParamsSelective = new StringBuilder();
if (!inModel.FieldDescriptions.Any())
{
return(string.Empty);
}
inModel.FieldDescriptions.Where(f => f.ColumnKey != "PRI").ToList().ForEach(f =>
{
field_UpdateParams.Append(string.Format("{2} = #{{{0},jdbcType={1}}}, ", JlString.ToLowerFirst(f.SimpleName), JlDbTypeMap.Map4Mybatis_PostgreSql(f.DbType).ToUpper(), f.Name));
if (field_UpdateParams.ToString().Split(new string[] { "\r\n" }, StringSplitOptions.None).Last().Length > 100)
{
field_UpdateParams.Append("\r\n ");
}
field_UpdateParamsSelective.AppendLine(string.Format(
@" <if test=""{0} != null"">
{1} = #{{{0},jdbcType={2}}},
</if>", JlString.ToLowerFirst(f.SimpleName), f.Name, JlDbTypeMap.Map4Mybatis_PostgreSql(f.DbType).ToUpper()));
});
var field = new JlFieldDescription();
if (inModel.FieldDescriptions.Count(f => f.ColumnKey == "PRI") == 1)
{
field = inModel.FieldDescriptions.First(f => f.ColumnKey == "PRI");
}
else
{
field = inModel.FieldDescriptions.FirstOrDefault();
}
result.AppendLine(string.Format(
@" <update id=""updateBy{7}"" parameterType=""{4}"">
update {0}
set {6}
where {1} = #{{{2},jdbcType={3}}}
</update>
<update id=""updateBy{7}Selective"" parameterType=""{4}"">
update {0}
<set>
{5} </set>
where {1} = #{{{2},jdbcType={3}}}
</update>", tableName, field.Name, JlString.ToLowerFirst(field.SimpleName), JlDbTypeMap.Map4Mybatis_PostgreSql(field.DbType).ToUpper(), string.Format(inModel.CodeMakerGeneratCodeIn.Package, "model") + "." + className,
field_UpdateParamsSelective, field_UpdateParams.ToString().TrimEnd().Substring(0, field_UpdateParams.ToString().TrimEnd().Length - 1), JlString.ToUpperFirst(field.SimpleName)));
return(result.ToString());
}
public string RefMybatisMapperXml(CodeMakerGeneratCodeOut inModel)
{
var className = inModel.CodeMakerGeneratCodeIn.ClassName;
var tableName = inModel.CodeMakerGeneratCodeIn.Table;
var field_Basic = new StringBuilder();
var field_Add = new StringBuilder();
var fieldValue = new StringBuilder();
var fieldParams = new StringBuilder();
var fieldWhereParams = new StringBuilder();
var field_SqlContent = new StringBuilder();
var codeStr = new StringBuilder();
codeStr.AppendLine(
@"<!DOCTYPE mapper PUBLIC "" -//mybatis.org//DTD Mapper 3.0//EN"" ""http://mybatis.org/dtd/mybatis-3-mapper.dtd"">
<mapper namespace=""" + string.Format(inModel.CodeMakerGeneratCodeIn.Package, "dao") + ".I" + JlString.ToUpperFirst(className) + "Dao\">");
inModel.FieldDescriptions.ToList().ForEach(f =>
{
field_Basic.AppendLine(string.Format(" <{0} column=\"" + f.Name + "\" property=\"" + JlString.ToLowerFirst(f.SimpleName) + "\" jdbcType=\"" + JlDbTypeMap.Map4Mybatis_PostgreSql(f.DbType).ToUpper() + "\" />",
f.ColumnKey == "PRI" ? "id" : "result"));
if (fieldParams.ToString().Split(new string[] { "\r\n" }, StringSplitOptions.None).Last().Length > 100)
{
fieldParams.Append("\r\n ");
}
fieldParams.Append(f.Name + ", ");
fieldWhereParams.AppendFormat(@"
<if test=""{0} != null"">
AND {1} = #{{{0},jdbcType={2}}}
</if>", f.SimpleName, f.Name, JlDbTypeMap.Map4Mybatis_PostgreSql(f.DbType).ToUpper());
});
field_SqlContent.Append(GenerateCode_Java.MybatisSelect(inModel));
field_SqlContent.Append(GenerateCode_Java.MybatisDelete(inModel));
field_SqlContent.Append(GenerateCode_Java.MybatisInsert(inModel));
field_SqlContent.Append(GenerateCode_Java.MybatisUpdate(inModel));
codeStr.AppendLine(string.Format(
@" <resultMap id=""BaseResultMap"" type=""{0}"">
{1} </resultMap>
<sql id=""Base_Column_List"">
{2}
</sql>
<sql id=""Where_Column_List"">{4}
</sql>
{3}</mapper>", string.Format(inModel.CodeMakerGeneratCodeIn.Package, "model") + "." + className, field_Basic, fieldParams.ToString().Substring(0, fieldParams.Length - 2), field_SqlContent
, fieldWhereParams.ToString()));
return(codeStr.ToString());
}
public static string DaoUpdate(CodeMakerGeneratCodeOut inModel)
{
var className = inModel.CodeMakerGeneratCodeIn.ClassName;
var tableName = inModel.CodeMakerGeneratCodeIn.Table;
var codeStr = new StringBuilder();
inModel.FieldDescriptions.ForEach(f =>
{
var field = new StringBuilder();
var fieldParameter = new StringBuilder();
inModel.FieldDescriptions.ForEach(ff =>
{
if (!ff.IsIdentity)
{
field.AppendLine(" + \"[" + ff.Name + "] = @" + ff.Name + ", \"");
}
fieldParameter.AppendLine(JlDbTypeMap.Map4J(ff.DbType, false, inModel.databaseType) == "Date"
? string.Format(" parameters.put(\"{0}\", new java.sql.Date({1}.get{0}().getTime()));", ff.Name, JlString.ToLowerFirst(className))
: string.Format(" parameters.put(\"{0}\", {1}.get{0}());", ff.Name, JlString.ToLowerFirst(className)));
});
codeStr.AppendLine(string.Format(@"
/**
* 通过{3}修改实体
*
* @param connectionString 连接字符串
* @param {1} 修改实体
*
* @return 修改成功与否
*/
public static boolean UpdateBy{6}(String connectionString, {0} {1}) throws Exception {{
String sql = ""UPDATE [{5}] SET ""
{2}
+ ""WHERE [{3}] = @{3}"";
HashMap<String, Object> parameters = new HashMap<String, Object>();
{4}
int i = SlDatabase.executeNonQuery(connectionString, sql, parameters);
return i > 0;
}}", className,
JlString.ToLowerFirst(className),
field.ToString().Substring(0, field.Length - 5) + " \"",
f.Name,
fieldParameter,
tableName,
JlString.ToUpperFirst(f.Name)));
});
return(codeStr.ToString());
}
public static string DaoAdd(CodeMakerGeneratCodeOut inModel)
{
var className = inModel.CodeMakerGeneratCodeIn.ClassName;
var tableName = inModel.CodeMakerGeneratCodeIn.Table;
var field = new StringBuilder();
var fieldValue = new StringBuilder();
var fieldParameter = new StringBuilder();
inModel.FieldDescriptions.Where(f => !f.IsIdentity).ToList().ForEach(f =>
{
field.AppendLine(" + \"[" + f.Name + "], \"");
fieldValue.AppendLine(" + \"@" + f.Name + ", \"");
if (JlDbTypeMap.Map4J(f.DbType, true, inModel.databaseType) == "Date")
{
fieldParameter.AppendLine(string.Format(" parameters.put(\"{0}\", new java.sql.Date({1}.get{0}().getTime()));", f.Name, JlString.ToLowerFirst(className)));
}
else
{
fieldParameter.AppendLine(string.Format(" parameters.put(\"{0}\", {1}.get{0}());", f.Name, JlString.ToLowerFirst(className)));
}
});
var codeStr = string.Format(@"
/**
* 添加实体
*
* @param connectionString 连接字符串
* @param {1} 添加实体
*
* @return 添加成功与否
*/
public static boolean Add(String connectionString, {0} {1}) throws Exception {{
String sql = ""INSERT INTO [{5}]( ""
{2}
+ "") VALUES ( ""
{3})"";
HashMap<String, Object> parameters = new HashMap<String, Object>();
{4}
int i = SlDatabase.executeNonQuery(connectionString, sql, parameters);
return i > 0;
}}", className, JlString.ToLowerFirst(className), field.ToString().Substring(0, field.Length - 5) + "\"", fieldValue.ToString().Substring(0, fieldValue.Length - 5), fieldParameter, tableName);
return(codeStr.ToString());
}
public static string DaoDelete(CodeMakerGeneratCodeOut inModel)
{
var className = inModel.CodeMakerGeneratCodeIn.ClassName;
var tableName = inModel.CodeMakerGeneratCodeIn.Table;
var codeStr = new StringBuilder();
inModel.FieldDescriptions.ForEach(f =>
{
var field = new StringBuilder();
var fieldParameter = new StringBuilder();
fieldParameter.AppendLine();
codeStr.AppendLine(string.Format(@"
/// <summary>
/// 通过{3}删除实体
/// </summary>
/// <param name=""connectionString"">连接字符串</param>
/// <param name=""wherePart"">删除属性</param>
/// <returns>删除成功与否</returns>
public static bool DeleteBy{4}(string connectionString, {0} {1}) {{
var sql = ""DELETE FROM [{2}] WHERE [{3}] = @{3}"";
var parameters = new List<SqlParameter>();
{5}
var i = JlDatabase.ExecuteNonQuery(connectionString, sql, parameters.ToArray());
return i > 0;
}}", JlDbTypeMap.Map4CSharp(f.DbType),
JlString.ToLowerFirst(f.Name),
tableName,
f.Name,
JlString.ToUpperFirst(f.Name),
string.Format(" parameters.Add(new SqlParameter() {{ ParameterName = \"{0}\", Value = {1} }});", f.Name, JlString.ToLowerFirst(f.Name))));
});
return(@"
#region 删除
" + codeStr.ToString() + @"
#endregion");
}
public static string DaoDelete(CodeMakerGeneratCodeOut inModel)
{
var className = inModel.CodeMakerGeneratCodeIn.ClassName;
var tableName = inModel.CodeMakerGeneratCodeIn.Table;
var codeStr = new StringBuilder();
inModel.FieldDescriptions.ForEach(f =>
{
var field = new StringBuilder();
var fieldParameter = new StringBuilder();
fieldParameter.AppendLine();
codeStr.AppendLine(string.Format(@"
/**
* 通过{3}删除实体
*
* @param connectionString 连接字符串
* @param {1} 删除属性
*
* @return 修改成功与否
*/
public static boolean DeleteBy{4}(String connectionString, {0} {1}) throws Exception {{
String sql = ""DELETE FROM [{2}] WHERE [{3}] = @{3}"";
HashMap<String, Object> parameters = new HashMap<String, Object>();
{5}
int i = SlDatabase.executeNonQuery(connectionString, sql, parameters);
return i > 0;
}}", JlDbTypeMap.Map4J(f.DbType, true, inModel.databaseType),
JlString.ToLowerFirst(f.Name),
tableName,
f.Name,
JlString.ToUpperFirst(f.Name),
JlDbTypeMap.Map4J(f.DbType, false, inModel.databaseType) == "Date"
? string.Format(" parameters.put(\"{0}\", new java.sql.Date({1}));", f.Name, JlString.ToLowerFirst(f.Name))
: string.Format(" parameters.put(\"{0}\", {1});", f.Name, JlString.ToLowerFirst(f.Name))));
});
return(codeStr.ToString());
}
public string RefEntity(CodeMakerGeneratCodeOut inModel)
{
var result = new StringBuilder();
var getterAndSetter = new StringBuilder();
result.AppendLine(string.Format(@"package {0};
import java.util.*;
import java.math.*;
public class {1} {{
", string.Format(inModel.CodeMakerGeneratCodeIn.Package, "model"), JlString.ToUpperFirst(JlString.ReplaceUnderline(inModel.CodeMakerGeneratCodeIn.ClassNameResult))));
foreach (var f in inModel.FieldDescriptions)
{
if (!string.IsNullOrEmpty(f.Description))
{
result.AppendLine(
@" /**
* " + f.Description.Replace("\n", " ") + @"
*/");
}
result.AppendLine(@" private " + JlDbTypeMap.Map4J(f.DbType, true, inModel.databaseType) + " " + JlString.ToLowerFirst(f.SimpleName) + @";
");
getterAndSetter.AppendLine(string.Format(@" public {2} get{1}() {{
return {0};
}}
public void set{1}({2} {0}) {{
this.{0} = {0};
}}
", JlString.ToLowerFirst(f.SimpleName), JlString.ToUpperFirst(f.SimpleName), JlDbTypeMap.Map4J(f.DbType, true, inModel.databaseType)));
}
result.Append(getterAndSetter);
result.AppendLine("}");
return(result.ToString());
}
public string RefEntity(CodeMakerGeneratCodeOut inModel)
{
var result = new StringBuilder();
result.AppendLine(string.Format(@"using System;
namespace {0}
{{
public class {1} {{", string.Format(inModel.CodeMakerGeneratCodeIn.Package, "Entity"), inModel.CodeMakerGeneratCodeIn.ClassName));
inModel.FieldDescriptions.ForEach(f =>
{
result.AppendLine(@"
/// <summary>
/// " + (string.IsNullOrWhiteSpace(f.Description) ? f.Name : f.Description.Replace("\n", " ")) + @"
/// </summary>
public " + JlDbTypeMap.Map4CSharp(f.DbType, f.IsNullable) + " " + f.Name + " { get; set; }");
});
result.AppendLine(@"
}
}");
return(result.ToString());
}
public static string MybatisDelete(CodeMakerGeneratCodeOut inModel)
{
var tableName = inModel.CodeMakerGeneratCodeIn.Table;
var result = new StringBuilder();
if (!inModel.FieldDescriptions.Any())
{
return(string.Empty);
}
var field = new JlFieldDescription();
if (inModel.FieldDescriptions.Count(f => f.ColumnKey == "PRI") == 1)
{
field = inModel.FieldDescriptions.First(f => f.ColumnKey == "PRI");
}
else
{
field = inModel.FieldDescriptions.FirstOrDefault();
}
result.AppendLine(string.Format(
@" <delete id=""deleteBy{1}"" parameterType=""{4}"">
delete from {0}
where {5} = #{{{2},jdbcType={3}}}
</delete>", tableName, JlString.ToUpperFirst(field.Name), JlString.ToLowerFirst(field.SimpleName), JlDbTypeMap.Map4Mybatis_PostgreSql(field.DbType).ToUpper(), JlDbTypeMap.Map4J(field.DbType, true, inModel.databaseType), field.Name));
return(result.ToString());
}
public static string DaoGet(CodeMakerGeneratCodeOut inModel)
{
var className = inModel.CodeMakerGeneratCodeIn.ClassName;
var tableName = inModel.CodeMakerGeneratCodeIn.Table;
var codeStr = new StringBuilder();
var field = new StringBuilder();
var fieldSetModel = new StringBuilder();
inModel.FieldDescriptions.ForEach(ff =>
{
field.AppendLine(" [" + ff.Name + "],");
if (JlDbTypeMap.Map4CSharp(ff.DbType) == "string")
{
fieldSetModel.AppendLine(string.Format(" {0} = row[\"{0}\"].ToString(),", ff.Name, JlString.ToLowerFirst(className)));
}
else
{
fieldSetModel.AppendLine(string.Format(" {0} = JlConvert.TryTo{1}(row[\"{0}\"]),", ff.Name, JlString.ToUpperFirst(JlDbTypeMap.Map4CSharp(ff.DbType))));
}
});
inModel.FieldDescriptions.ForEach(f =>
{
var fieldParameter = new StringBuilder();
fieldParameter.AppendLine(string.Format(" parameters.Add(new SqlParameter() {{ ParameterName = \"{0}\", Value = wherePart.{0} }});", f.Name, JlString.ToLowerFirst(className)));
codeStr.AppendLine(string.Format(@"
/// <summary>
/// 通过{1}查询实体
/// </summary>
/// <param name=""connectionString"">连接字符串</param>
/// <param name=""wherePart"">删除属性</param>
/// <returns>查询结果</returns>
public static En.{4} GetBy{6}(string connectionString, dynamic wherePart) {{
var sql = @""SELECT
{2}
FROM [{0}] WITH (NOLOCK)
WHERE [{1}] = @{1}"";
var parameters = new List<SqlParameter>();
{3}
var dataTable = new DataTable();
SlDatabase.Fill(connectionString, sql, dataTable, parameters.ToArray());
if (dataTable.Rows.Count > 0)
{{
var row = dataTable.Rows[0];
return new En.{4}()
{{
{5}
}};
}}
else
{{
return null;
}}
}}
", tableName, f.Name,
field.ToString().Substring(0, field.Length - 3),
fieldParameter, className, fieldSetModel, JlString.ToUpperFirst(f.Name)));
});
return(@"
#region 查询
" + codeStr.ToString() + @"
#endregion");
}
public static string MybatisInsert(CodeMakerGeneratCodeOut inModel)
{
var className = inModel.CodeMakerGeneratCodeIn.ClassName;
var tableName = inModel.CodeMakerGeneratCodeIn.Table;
var result = new StringBuilder();
var field_Params = new StringBuilder();
var field_InsertParams = new StringBuilder();
var field_InsertParams_Batch = new StringBuilder();
var field_InsertSelectiveParams = new StringBuilder();
var field_InsertSelectiveValues = new StringBuilder();
if (!inModel.FieldDescriptions.Any())
{
return(string.Empty);
}
inModel.FieldDescriptions.Where(f => !f.IsIdentity).ToList().ForEach(f =>
{
if (field_Params.ToString().Split(new string[] { "\r\n" }, StringSplitOptions.None).Last().Length > 100)
{
field_Params.Append("\r\n ");
}
field_Params.Append(f.Name + ", ");
if (field_InsertParams.ToString().Split(new string[] { "\r\n" }, StringSplitOptions.None).Last().Length > 100)
{
field_InsertParams.Append("\r\n ");
}
field_InsertParams.AppendLine(string.Format(" #{{{0},jdbcType={1}}}, ", JlString.ToLowerFirst(f.SimpleName), JlDbTypeMap.Map4Mybatis_PostgreSql(f.DbType).ToUpper()));
if (field_InsertParams_Batch.ToString().Split(new string[] { "\r\n" }, StringSplitOptions.None).Last().Length > 100)
{
field_InsertParams_Batch.Append("\r\n ");
}
field_InsertParams_Batch.AppendLine(string.Format(" #{{item.{0},jdbcType={1}}}, ", JlString.ToLowerFirst(f.SimpleName), JlDbTypeMap.Map4Mybatis_PostgreSql(f.DbType).ToUpper()));
field_InsertSelectiveParams.AppendFormat(
@" <if test=""{0} != null"">
{1},
</if>
", JlString.ToLowerFirst(f.SimpleName), f.Name);
field_InsertSelectiveValues.AppendFormat(
@" <if test=""{0} != null"">
#{{{0},jdbcType={1}}},
</if>
", JlString.ToLowerFirst(f.SimpleName), JlDbTypeMap.Map4Mybatis_PostgreSql(f.DbType).ToUpper());
});
result.AppendLine(string.Format(
@" <insert id=""insert"" parameterType=""{3}"" useGeneratedKeys=""true"" keyProperty=""id"">
insert into {0}(
{1}
) values (
{2})
</insert>",
tableName,
field_Params.ToString().Substring(0, field_Params.Length - 2),
field_InsertParams.ToString().TrimEnd().Substring(0, field_InsertParams.ToString().TrimEnd().Length - 1),
string.Format(inModel.CodeMakerGeneratCodeIn.Package, "model") + "." + className));
result.AppendLine(string.Format(
@" <insert id=""insertSelective"" parameterType=""{3}"" useGeneratedKeys=""true"" keyProperty=""id"">
insert into {0}
<trim prefix=""("" suffix="")"" suffixOverrides="","">
{1} </trim>
<trim prefix=""values("" suffix="")"" suffixOverrides="","">
{2} </trim>
</insert>",
tableName,
field_InsertSelectiveParams.ToString(),
field_InsertSelectiveValues.ToString(),
string.Format(inModel.CodeMakerGeneratCodeIn.Package, "model") + "." + className));
result.AppendLine(string.Format(
@" <insert id=""batchInsert"" parameterType=""java.util.List"">
insert into {0}(
{1}
) values
<foreach collection=""list"" item=""item"" index=""index"" separator="","">
({2})
</foreach>
</insert>",
tableName,
field_Params.ToString().Substring(0, field_Params.Length - 2),
field_InsertParams_Batch.ToString().TrimEnd().Substring(0, field_InsertParams_Batch.ToString().TrimEnd().Length - 1).Trim(),
string.Format(inModel.CodeMakerGeneratCodeIn.Package, "model") + "." + className));
return(result.ToString());
}
public static string DaoGetPageList(CodeMakerGeneratCodeOut inModel)
{
var className = inModel.CodeMakerGeneratCodeIn.ClassName;
var tableName = inModel.CodeMakerGeneratCodeIn.Table;
var codeStr = new StringBuilder();
var field = new StringBuilder();
var fieldSetModel = new StringBuilder();
inModel.FieldDescriptions.ForEach(f =>
{
field.AppendLine(" \"[" + f.Name + "], \" +");
fieldSetModel.AppendLine(JlDbTypeMap.Map4J(f.DbType, false, inModel.databaseType) == "Date"
? string.Format(" model.set" + JlString.ToUpperFirst(f.Name) + "(new Date(crs.get" + JlString.ToUpperFirst(JlDbTypeMap.Map4J(f.DbType, false, inModel.databaseType)) + "(\"" + f.Name + "\").getTime()));")
: string.Format(" model.set" + JlString.ToUpperFirst(f.Name) + "(crs.get" + JlString.ToUpperFirst(JlDbTypeMap.Map4J(f.DbType, false, inModel.databaseType)) + "(\"" + f.Name + "\"));"));
});
Func <string, string, string> getSelectSql = (data, where) =>
{
return(string.Format(@"
""WITH Virtual_T AS(""+
""SELECT ""+
{0} ""ROW_NUMBER() OVER (%s) AS [RowNumber] "" +
""FROM [{1}] WITH (NOLOCK)%s) "" +
""SELECT * FROM Virtual_T "" +
""WHERE @PageSize * (@CurrentPage - 1) < RowNumber AND RowNumber <= @PageSize * @CurrentPage""",
field,
tableName));
};
var fieldDataAccess = string.Format(@"
List<{0}> list = new ArrayList<{0}>();
CachedRowSet crs = SlDatabase.fill(connectionString, sql);
while (crs.next()) {{
{0} model = new {0}();
{1}
list.add(model);
}}
return list;", className, fieldSetModel.ToString().Substring(0, fieldSetModel.Length - 2));
codeStr.AppendLine(string.Format(@"
/**
* 通过ConditionAndOrder查询一页实体列表（不存在时，返回null）
*
* @param connectionString 连接字符串
* @param pageSize 每页行数
* @param currentPage 当前页码
* @param sqlWhere 判断条件语句
* @param sqlOrder 排序语句
*
* @return 查询结果集
*/
public static List<{1}> GetPageListByConditionAndOrder(String connectionString, int pageSize, int currentPage,
String sqlWhere, String sqlOrder) throws Exception {{
String sql = {0};
// 条件查询部分
sql = String.format(sql, sqlOrder, sqlWhere.isEmpty() ? """" : "" WHERE ("" + sqlWhere.substring(0, sqlWhere.length() - 4) + "")"");
HashMap<String, Object> parameters = new HashMap<String, Object>();
parameters.put(""PageSize"", pageSize);
parameters.put(""CurrentPage"", currentPage);
{2}
}}", getSelectSql(field.ToString(), null), className, fieldDataAccess));
return(codeStr.ToString());
}
public static string MybatisSelect(CodeMakerGeneratCodeOut inModel)
{
var tableName = inModel.CodeMakerGeneratCodeIn.Table;
var result = new StringBuilder();
if (inModel.FieldDescriptions.Any())
{
var field = new JlFieldDescription();
if (inModel.FieldDescriptions.Any(f => f.ColumnKey == "PRI"))
{
field = inModel.FieldDescriptions.First(f => f.ColumnKey == "PRI");
}
else
{
field = inModel.FieldDescriptions.FirstOrDefault();
}
result.AppendLine(string.Format(
@" <select id=""{6}By{1}"" parameterType=""{4}"" resultMap=""BaseResultMap"">
select
<include refid=""Base_Column_List"" />
from {0}
where {5} = #{{{2},jdbcType={3}}}
</select>
<select id=""selectAll"" resultMap=""BaseResultMap"">
select
<include refid=""Base_Column_List"" />
from {0}
</select>
<select id=""selectByPage"" parameterType=""{7}"" resultMap=""BaseResultMap"">
select
<include refid=""Base_Column_List"" />
from {0}
<trim prefix=""where"" prefixOverrides=""and | or"">
<include refid = ""Where_Column_List""></include>
</trim>
LIMIT #{{length}} OFFSET #{{start}}
</select>
<select id=""selectByWhere"" parameterType=""{7}"" resultMap=""BaseResultMap"">
select
<include refid=""Base_Column_List"" />
from {0}
<trim prefix=""where"" prefixOverrides=""and | or"">
<include refid = ""Where_Column_List""></include>
</trim>
LIMIT 1
</select>
<select id=""selectListByWhere"" parameterType=""{7}"" resultMap=""BaseResultMap"">
select
<include refid=""Base_Column_List"" />
from {0}
<trim prefix=""where"" prefixOverrides=""and | or"">
<include refid = ""Where_Column_List""></include>
</trim>
</select>
<select id=""count"" parameterType=""{7}"" resultType=""Integer"">
select count(1)
from {0}
<trim prefix=""where"" prefixOverrides=""and | or"">
<include refid = ""Where_Column_List""></include>
</trim>
</select>", tableName, JlString.ToUpperFirst(field.Name), JlString.ToLowerFirst(field.SimpleName), JlDbTypeMap.Map4Mybatis_PostgreSql(field.DbType).ToUpper(),
JlDbTypeMap.Map4J(field.DbType, true, inModel.databaseType), field.Name,
inModel.FieldDescriptions.Any(f => f.ColumnKey == "PRI") ? "select" : "selectList",
string.Format(inModel.CodeMakerGeneratCodeIn.Package, "model") + "." + inModel.CodeMakerGeneratCodeIn.ClassName));
}
return(result.ToString());
}
public static string DaoGetList(CodeMakerGeneratCodeOut inModel)
{
var className = inModel.CodeMakerGeneratCodeIn.ClassName;
var tableName = inModel.CodeMakerGeneratCodeIn.Table;
var codeStr = new StringBuilder();
var field = new StringBuilder();
var fieldSetModel = new StringBuilder();
inModel.FieldDescriptions.ForEach(f =>
{
field.AppendLine(" \"[" + f.Name + "], \" +");
fieldSetModel.AppendLine(JlDbTypeMap.Map4J(f.DbType, false, inModel.databaseType) == "Date"
? string.Format(" model.set" + JlString.ToUpperFirst(f.Name) + "(new Date(crs.get" + JlString.ToUpperFirst(JlDbTypeMap.Map4J(f.DbType, false, inModel.databaseType)) + "(\"" + f.Name + "\").getTime()));")
: string.Format(" model.set" + JlString.ToUpperFirst(f.Name) + "(crs.get" + JlString.ToUpperFirst(JlDbTypeMap.Map4J(f.DbType, false, inModel.databaseType)) + "(\"" + f.Name + "\"));"));
});
Func <string, string, string> getSelectSql = (data, where) =>
{
return(string.Format(@"""SELECT ""+
{0}
""FROM [{1}] WITH (NOLOCK){2}""",
field.ToString().Substring(0, field.Length - 7) + " \" +",
tableName,
string.IsNullOrEmpty(where) ? "" : " " + where));
};
var fieldDataAccess = string.Format(@"
List<{0}> list = new ArrayList<{0}>();
CachedRowSet crs = SlDatabase.fill(connectionString, sql);
while (crs.next()) {{
{0} model = new {0}();
{1}
list.add(model);
}}
return list;", className, fieldSetModel.ToString().Substring(0, fieldSetModel.Length - 2));
codeStr.AppendLine(string.Format(@"
/**
* 查询所有实体列表（不存在时，返回null）
*
* @param connectionString 连接字符串
*
* @return 查询结果集
*/
public static List<{1}> GetAll(String connectionString) throws Exception {{
String sql = {0};
{2}
}}", getSelectSql(field.ToString(), null), className, fieldDataAccess));
inModel.FieldDescriptions.ForEach(f =>
{
var fieldParameter = JlDbTypeMap.Map4J(f.DbType, false, inModel.databaseType) == "Date"
? string.Format(" parameters.put(\"{0}\", new java.sql.Date(wherePart.get{1}().getTime()));", f.Name, JlString.ToUpperFirst(f.Name))
: string.Format(" parameters.put(\"{0}\", wherePart.get{1}());", f.Name, JlString.ToUpperFirst(f.Name));
var sqlWhere = string.Format("WHERE [{0}] = @{0}", f.Name);
codeStr.AppendLine(string.Format(@"
/**
* 通过{3}查询实体列表（不存在时，返回null）
*
* @param connectionString 连接字符串
* @param wherePart 条件部分
*
* @return 查询结果集
*/
public static List<{1}> GetListBy{5}(String connectionString, {1} wherePart) throws Exception {{
String sql = {0};
HashMap<String, Object> parameters = new HashMap<String, Object>();
{2}
{4}
}}", getSelectSql(field.ToString(), sqlWhere), className, fieldParameter, f.Name, fieldDataAccess, JlString.ToUpperFirst(f.Name)));
});
return(codeStr.ToString());
}
public static string DaoGet(CodeMakerGeneratCodeOut inModel)
{
var className = inModel.CodeMakerGeneratCodeIn.ClassName;
var tableName = inModel.CodeMakerGeneratCodeIn.Table;
var codeStr = new StringBuilder();
var field = new StringBuilder();
var fieldSetModel = new StringBuilder();
inModel.FieldDescriptions.ForEach(f =>
{
field.AppendLine(" + \"[" + f.Name + "], \"");
fieldSetModel.AppendLine(JlDbTypeMap.Map4J(f.DbType, false, inModel.databaseType) == "Date"
? string.Format(" model.set" + JlString.ToUpperFirst(f.Name) + "(new Date(crs.get" + JlString.ToUpperFirst(JlDbTypeMap.Map4J(f.DbType, false, inModel.databaseType)) + "(\"" + f.Name + "\").getTime()));")
: string.Format(" model.set" + JlString.ToUpperFirst(f.Name) + "(crs.get" + JlString.ToUpperFirst(JlDbTypeMap.Map4J(f.DbType, false, inModel.databaseType)) + "(\"" + f.Name + "\"));"));
});
inModel.FieldDescriptions.ForEach(f =>
{
var fieldParameter = new StringBuilder();
fieldParameter.AppendLine(JlDbTypeMap.Map4J(f.DbType, false, inModel.databaseType) == "Date"
? string.Format(" parameters.put(\"{0}\", new java.sql.Date({1}.getTime()));", f.Name, JlString.ToLowerFirst(f.Name))
: string.Format(" parameters.put(\"{0}\", {1});", f.Name, JlString.ToLowerFirst(f.Name)));
codeStr.AppendLine(string.Format(@"
/**
* 通过{1}查询实体
*
* @param connectionString 连接字符串
* @param {6} {4}
*
* @return 查询结果
*/
public static {5} GetBy{10}(String connectionString, {9} {8}) throws Exception {{
String sql = ""SELECT ""
{2}
+ ""FROM [{0}] WITH (NOLOCK) ""
+ ""WHERE [{1}] = @{1}"";
HashMap<String, Object> parameters = new HashMap<String, Object>();
{3}
CachedRowSet crs = SlDatabase.fill(connectionString, sql, parameters);
while (crs.next()) {{
{5} model = new {5}();
{7}
return model;
}}
return null;
}}", tableName, f.Name,
field.ToString().Substring(0, field.Length - 5) + " \"",
fieldParameter,
f.Description,
className,
JlString.ToLowerFirst(className),
fieldSetModel,
JlString.ToLowerFirst(f.Name),
JlDbTypeMap.Map4J(f.DbType, true, inModel.databaseType),
JlString.ToUpperFirst(f.Name)));
});
return(codeStr.ToString());
}
public static string DaoGetList(CodeMakerGeneratCodeOut inModel)
{
var className = inModel.CodeMakerGeneratCodeIn.ClassName;
var tableName = inModel.CodeMakerGeneratCodeIn.Table;
var codeStr = new StringBuilder();
var field = new StringBuilder();
var fieldSetModel = new StringBuilder();
inModel.FieldDescriptions.ForEach(f =>
{
field.AppendLine(" [" + f.Name + "],");
if (JlDbTypeMap.Map4CSharp(f.DbType) == "string")
{
fieldSetModel.AppendLine(string.Format(" {0} = row[\"{0}\"].ToString(),", f.Name, JlString.ToLowerFirst(className)));
}
else
{
fieldSetModel.AppendLine(string.Format(" {0} = JlConvert.TryTo{1}(row[\"{0}\"]),", f.Name, JlString.ToUpperFirst(JlDbTypeMap.Map4CSharp(f.DbType))));
}
});
Func <string, string, string> getSelectSql = (data, where) =>
{
return(string.Format(@"@""SELECT
{0}
FROM [{1}] WITH (NOLOCK){2}""",
field.ToString().Substring(0, field.Length - 3),
tableName,
string.IsNullOrEmpty(where) ? "" : " " + where));
};
var fieldDataAccess = string.Format(@"
var list = new List<En.{0}>();
var dataTable = new DataTable();
JlDatabase.Fill(connectionString, sql, dataTable);
if (dataTable.Rows.Count > 0)
{{
list = dataTable.AsEnumerable().Select(row => new En.{0}()
{{
{1}
}}).ToList();
}}
return list;", className, fieldSetModel.ToString().Substring(0, fieldSetModel.Length - 2));
codeStr.AppendLine(string.Format(@"
/// <summary>
/// 查询所有实体列表（不存在时，返回null）
/// </summary>
/// <param name=""connectionString"">连接字符串</param>
/// <returns>查询结果集</returns>
public static List<En.{1}> GetAll(string connectionString) {{
string sql = {0};
{2}
}}", getSelectSql(field.ToString(), null), className, fieldDataAccess));
inModel.FieldDescriptions.ForEach(f =>
{
var fieldParameter = string.Format(" parameters.Add(new SqlParameter() {{ ParameterName = \"{0}\", Value = wherePart.{0} }});", f.Name, JlString.ToLowerFirst(className));
var sqlWhere = string.Format("WHERE [{0}] = @{0}", f.Name);
codeStr.AppendLine(string.Format(@"
/// <summary>
/// 查询实体列表（不存在时，返回null）
/// </summary>
/// <param name=""connectionString"">连接字符串</param>
/// <param name=""wherePart"">查询实体</param>
/// <returns>查询结果集</returns>
public static List<En.{1}> GetListBy{5}(string connectionString, dynamic wherePart) {{
string sql = {0};
var parameters = new List<SqlParameter>();
{2}
{4}
}}", getSelectSql(field.ToString(), sqlWhere), className, fieldParameter, f.Name, fieldDataAccess, JlString.ToUpperFirst(f.Name)));
});
return(@"
#region 查询
" + codeStr.ToString() + @"
#endregion");
}
public static string DaoGetPageList(CodeMakerGeneratCodeOut inModel)
{
var className = inModel.CodeMakerGeneratCodeIn.ClassName;
var tableName = inModel.CodeMakerGeneratCodeIn.Table;
var codeStr = new StringBuilder();
var field = new StringBuilder();
var fieldSetModel = new StringBuilder();
inModel.FieldDescriptions.ForEach(f =>
{
field.AppendLine(" [" + f.Name + "],");
if (JlDbTypeMap.Map4CSharp(f.DbType) == "string")
{
fieldSetModel.AppendLine(string.Format(" {0} = row[\"{0}\"].ToString(),", f.Name, JlString.ToLowerFirst(className)));
}
else
{
fieldSetModel.AppendLine(string.Format(" {0} = JlConvert.TryTo{1}(row[\"{0}\"]),", f.Name, JlString.ToUpperFirst(JlDbTypeMap.Map4CSharp(f.DbType))));
}
});
Func <string, string, string> getSelectSql = (data, where) =>
{
return(string.Format(@"
@""WITH Virtual_T AS(
SELECT
{0}
ROW_NUMBER() OVER ({{0}}) AS [RowNumber]
FROM [{1}] WITH (NOLOCK){{1}})
SELECT * FROM Virtual_T
WHERE @PageSize * (@CurrentPage - 1) < RowNumber AND RowNumber <= @PageSize * @CurrentPage""",
field.ToString().Substring(0, field.Length - 1),
tableName));
};
var fieldDataAccess = string.Format(@"
var list = new List<En.{0}>();
var dataTable = new DataTable();
JlDatabase.Fill(connectionString, sql, dataTable, parameters.ToArray());
if (dataTable.Rows.Count > 0)
{{
list = dataTable.AsEnumerable().Select(row => new En.{0}()
{{
{1}
}}).ToList();
}}
return list;", className, fieldSetModel.ToString().Substring(0, fieldSetModel.Length - 3));
var fieldDataAccess_Count = string.Format(@"
var list = new List<En.{0}>();
var dataTable = new DataTable();
JlDatabase.Fill(connectionString, sql, dataTable, parameters.ToArray());
//记录总数计算
var sqlCount = string.Format(""SELECT COUNT(*) CNT FROM [{2}] {{0}} "", string.IsNullOrEmpty(sqlWhere) ? """"
: "" WHERE("" + sqlWhere.Remove(sqlWhere.Length - 4) + "")"");
totalCount = SlConvert.TryToInt32(JlDatabase.ExecuteScalar(connectionString, sqlCount));
if (dataTable.Rows.Count > 0)
{{
list = dataTable.AsEnumerable().Select(row => new En.{0}()
{{
{1}
}}).ToList();
}}
return list;", className, fieldSetModel.ToString().Substring(0, fieldSetModel.Length - 3), tableName);
codeStr.AppendLine(string.Format(@"
#region 查询结果集
/// <summary>
/// 查询所有实体列表（不存在时，返回null）
/// </summary>
/// <param name=""connectionString"">连接字符串</param>
/// <param name=""pageSize"">每页行数</param>
/// <param name=""currentPage"">当前页码</param>
/// <param name=""sqlWhere"">判断条件语句</param>
/// <param name=""sqlOrder"">排序语句</param>
/// <returns>查询结果集</returns>
public static List<En.{1}> GetPageListByConditionAndOrder(string connectionString, int pageSize, int currentPage,
string sqlWhere, string sqlOrder) {{
string sql = {0};
// 条件查询部分
sql = string.Format(sql, sqlOrder, string.IsNullOrEmpty(sqlWhere) ? """" : "" WHERE ("" + sqlWhere.Substring(0, sqlWhere.Length - 4) + "")"");
var parameters = new List<SqlParameter>();
parameters.Add(new SqlParameter() {{ ParameterName = ""PageSize"", Value = pageSize }});
parameters.Add(new SqlParameter() {{ ParameterName = ""CurrentPage"", Value = currentPage }});
{2}
}}", getSelectSql(field.ToString(), null), className, fieldDataAccess));
codeStr.AppendLine(string.Format(@"
/// <summary>
/// 查询所有实体列表（不存在时，返回null）
/// </summary>
/// <param name=""connectionString"">连接字符串</param>
/// <param name=""pageSize"">每页行数</param>
/// <param name=""currentPage"">当前页码</param>
/// <param name=""sqlWhere"">判断条件语句</param>
/// <param name=""sqlOrder"">排序语句</param>
/// <returns>查询结果集</returns>
public static List<En.{1}> GetPageListByConditionAndOrder(string connectionString, int pageSize, int currentPage,
string sqlWhere, string sqlOrder, out int totalCount) {{
string sql = {0};
// 条件查询部分
sql = string.Format(sql, sqlOrder, string.IsNullOrEmpty(sqlWhere) ? """" : "" WHERE ("" + sqlWhere.Substring(0, sqlWhere.Length - 4) + "")"");
var parameters = new List<SqlParameter>();
parameters.Add(new SqlParameter() {{ ParameterName = ""PageSize"", Value = pageSize }});
parameters.Add(new SqlParameter() {{ ParameterName = ""CurrentPage"", Value = currentPage }});
{2}
}}
#endregion
", getSelectSql(field.ToString(), null), className, fieldDataAccess_Count));
return(codeStr.ToString());
}
public string RefMybatisMapper(CodeMakerGeneratCodeOut inModel)
{
var className = inModel.CodeMakerGeneratCodeIn.ClassName;
var tableName = inModel.CodeMakerGeneratCodeIn.Table;
var field_Basic = new StringBuilder();
var field_Add = new StringBuilder();
var fieldValue = new StringBuilder();
var fieldParams = new StringBuilder();
var field_SqlContent = new StringBuilder();
var field = new JlFieldDescription();
if (inModel.FieldDescriptions.Any(f => f.ColumnKey == "PRI"))
{
field = inModel.FieldDescriptions.First(f => f.ColumnKey == "PRI");
}
else
{
field = inModel.FieldDescriptions.FirstOrDefault();
}
var codeStr = new StringBuilder();
codeStr.AppendLine(string.Format(
@"package {0};
import {1};
import java.util.List;
public interface I{2}Dao{{
{7}By{3}({4} {5});
List<{2}> selectAll();
List<{2}> selectByPage({2} {6});
{2} selectByWhere({2} {6});
List<{2}> selectListByWhere({2} {6});
int count({2} {6});
int deleteBy{3}({4} {5});
int updateBy{3}({2} {6});
int updateBy{3}Selective({2} {6});
int insert({2} {6});
int insertSelective({2} {6});
void batchInsert(List<{2}> {6}List);
}}",
string.Format(inModel.CodeMakerGeneratCodeIn.Package, "dao"),
string.Format(inModel.CodeMakerGeneratCodeIn.Package, "model") + "." + className,
className,
JlString.ToUpperFirst(field.SimpleName),
JlDbTypeMap.Map4J(field.DbType, true, inModel.databaseType),
JlString.ToLowerFirst(field.SimpleName),
JlString.ToLowerFirst(className),
inModel.FieldDescriptions.Any(f => f.ColumnKey == "PRI") ? className + " select" : "List<" + className + "> selectList"));
return(codeStr.ToString());
}