/// <summary>
/// 把需格式化的字符串附加到code字符串后，附加前在code字符串后加回车换行
/// </summary>
/// <param name="code">返回字符串附加后的结果</param>
/// <param name="level">左边tab层级量(空字符串)</param>
/// <param name="s">要附加的字符串</param>
/// <param name="arr">格式化{0}、{1}..字符串待的替换字符系列</param>
public void append(ref string code, LeftSpaceLevel level, string s, params string[] arr)
{
string space1 = null == StartSpace ? "" : StartSpace;
space1 += getSpace((int)level);
string s2 = null == s ? "" : s;
if (null != arr)
{
if (0 < arr.Length)
{
int n = 0;
foreach (string item in arr)
{
s2 = s2.Replace("{" + n + "}", item);
n++;
}
}
}
s2 = space1 + s2;
if (string.IsNullOrEmpty(code))
{
code = s2;
}
else
{
code += "\r\n" + s2;
}
}
void ReturnResult(MethodInformation method, LeftSpaceLevel leftSpaceLevel, DataOptType dataOptType, string funcResultVarName, string resultVarName, ref string code)
{
Type resultType = method.methodInfo.ReturnType;
if (DataOptType.insert == dataOptType || DataOptType.update == dataOptType || DataOptType.delete == dataOptType)
{
if (typeof(bool) == resultType || typeof(Boolean) == resultType)
{
method.append(ref code, leftSpaceLevel, "{0} = 0 < {1};", funcResultVarName, resultVarName);
}
else
{
method.append(ref code, leftSpaceLevel, "{0} = {1};", funcResultVarName, resultVarName);
}
}
else
{
method.append(ref code, leftSpaceLevel, "{0} = {1};", funcResultVarName, resultVarName);
}
}
void ExecuteSqlCode(MethodInformation method, LeftSpaceLevel leftSpaceLevel, DataOptType dataOptType, string sqlVarName, string paraListVarName, string dbHelperVarName, string returnVarName, ref string code)
{
if (DataOptType.select == dataOptType)
{
return;
}
//method.append(ref code, leftSpaceLevel, "");
string methodName = "";
if (DataOptType.none == method.sqlExecType)
{
switch (dataOptType)
{
case DataOptType.insert:
methodName = "insert";
break;
case DataOptType.update:
methodName = "update";
break;
case DataOptType.delete:
methodName = "delete";
break;
}
}
else
{
methodName = Enum.GetName(typeof(DataOptType), method.sqlExecType);
}
string autCall = method.AutoCallVarName;
string enabledBuffer = method.methodComponent.EnabledBuffer.ToString().ToLower();
enabledBuffer = method.methodComponent.IsAsync ? "true" : enabledBuffer;
method.append(ref code, leftSpaceLevel, "if(null != {0})", dbHelperVarName);
method.append(ref code, leftSpaceLevel, "{");
if (DataOptType.select == method.sqlExecType || (DataOptType.procedure == dataOptType && DJTools.IsBaseType(method.methodComponent.ResultType)))
{
string dbTag = DJTools.GetParaTagByDbDialect(DataAdapter.dbDialect);
method.append(ref code, leftSpaceLevel + 1, "{0} = {0}.Replace(\"{1}\", \"{2}\");", sqlVarName, procParaSign, dbTag);
method.append(ref code, leftSpaceLevel + 1, "dbHelper.query({0}, {1}, {2}, {3}, dataTable =>", autCall, sqlVarName, paraListVarName, enabledBuffer);
method.append(ref code, leftSpaceLevel + 1, "{");
#region ***** action
method.append(ref code, leftSpaceLevel + 2, "dataTable = null == dataTable ? new System.Data.DataTable() : dataTable;");
method.append(ref code, leftSpaceLevel + 2, "if(0 < dataTable.Rows.Count)");
method.append(ref code, leftSpaceLevel + 2, "{");
method.append(ref code, leftSpaceLevel + 3, "string valStr = System.DBNull.Value == dataTable.Rows[0][0] ? \"\" : dataTable.Rows[0][0].ToString();");
if (baseTypeWithResult(method))
{
method.append(ref code, leftSpaceLevel + 3, "int tempVal = 0;");
method.append(ref code, leftSpaceLevel + 3, "int.TryParse(valStr, out tempVal);");
method.append(ref code, leftSpaceLevel + 3, "{0} = tempVal;", returnVarName);
}
else if (typeof(string) == method.methodComponent.ResultType)
{
method.append(ref code, leftSpaceLevel + 3, "{0} = valStr;", returnVarName);
}
else
{
method.append(ref code, leftSpaceLevel + 3, "{0}.TryParse(valStr, out {1});", method.methodComponent.ResultType.FullName, returnVarName);
}
method.append(ref code, leftSpaceLevel + 2, "}");
method.append(ref code, leftSpaceLevel + 2, "else");
method.append(ref code, leftSpaceLevel + 2, "{");
method.append(ref code, leftSpaceLevel + 3, "{0} = 0;", returnVarName);
method.append(ref code, leftSpaceLevel + 2, "}");
if (null != method.methodComponent.ActionType)
{
method.append(ref code, leftSpaceLevel + 2, "{0}({1});", method.methodComponent.ActionParaName, returnVarName);
}
#endregion
method.append(ref code, leftSpaceLevel + 1, "}, ref err);");
}
else
{
method.append(ref code, leftSpaceLevel + 1, "{0} += dbHelper.{1}({2}, {3}, {4},{5}, resultNum =>", returnVarName, methodName, autCall, sqlVarName, paraListVarName, enabledBuffer);
method.append(ref code, leftSpaceLevel + 1, "{");
#region ***** action
method.append(ref code, leftSpaceLevel + 2, "{0} += resultNum;", returnVarName);
if (null != method.methodComponent.ActionType)
{
method.append(ref code, leftSpaceLevel + 2, "{0}(resultNum);", method.methodComponent.ActionParaName, returnVarName);
}
#endregion
method.append(ref code, leftSpaceLevel + 1, "}, ref err);");
}
method.append(ref code, leftSpaceLevel + 1, "");
method.append(ref code, leftSpaceLevel + 1, "if(!string.IsNullOrEmpty(err))");
method.append(ref code, leftSpaceLevel + 1, "{");
method.append(ref code, leftSpaceLevel + 2, "throw new Exception(err);");
method.append(ref code, leftSpaceLevel + 1, "}");
method.append(ref code, leftSpaceLevel, "}");
}
public string GetParametersBySqlParameter(string sql, string sqlVarName, MethodInformation method, DataOptType dataOptType, ref string dbParaListVarName)
{
string code = "";
string sql1 = sql;
string executeDbHelper = "{ExecuteDbHelper#}";
string leftSpace = "";
Regex rg = rgParaField;
if (string.IsNullOrEmpty(dbParaListVarName) || dbParaListVarName.ToLower().Equals("null"))
{
dbParaListVarName = "dbParaList";
method.append(ref code, LeftSpaceLevel.one, "DbList<System.Data.Common.DbParameter> {0} = new DbList<System.Data.Common.DbParameter>();", dbParaListVarName);
}
string dbHelperVarName = "dbHelper";
string resultVarName = "successVal";
string funcResultVarName = method.methodComponent.ResultVariantName;
if (baseTypeWithResult(method))
{
method.append(ref code, LeftSpaceLevel.one, "int {0} = 0;", resultVarName);
}
else
{
method.append(ref code, LeftSpaceLevel.one, "{0} {1} = default({0});", method.methodComponent.ResultType.FullName, resultVarName);
}
method.append(ref code, LeftSpaceLevel.one, "string err = \"\";");
method.append(ref code, LeftSpaceLevel.one, "IDbHelper {0} = ImplementAdapter.DbHelper;", dbHelperVarName);
if (rg.IsMatch(sql) && 0 < method.paraList.Count)
{
string LeftSign = "";
string EndSign = "";
string DbTag = "";
string FieldName = "";
string autoCallName = method.AutoCallVarName;
Match match = null;
EList <CKeyValue> sqlParaList1 = new EList <CKeyValue>();
string sqlParasVarName = "sqlParaList";
method.append(ref code, LeftSpaceLevel.one, "EList<CKeyValue> {0} = new EList<CKeyValue>();", sqlParasVarName);
int n = 0;
while (rg.IsMatch(sql1) && 200 > n)
{
match = rg.Match(sql1);
LeftSign = match.Groups["LeftSign"].Value;
EndSign = match.Groups["EndSign"].Value;
if (isEnabledField(LeftSign))
{
if (string.IsNullOrEmpty(DbTag))
{
DbTag = match.Groups["DbTag"].Value;
}
FieldName = match.Groups["FieldName"].Value;
method.append(ref code, LeftSpaceLevel.one, "{0}.Add(new CKeyValue(){ Key = \"{1}\", Value = \"{2}\", other = \"{3}\" });", sqlParasVarName, FieldName.ToLower(), FieldName, DbTag);
sqlParaList1.Add(new CKeyValue()
{
Key = FieldName.ToLower(), Value = FieldName, other = DbTag
});
}
sql1 = sql1.Replace(match.Groups[0].Value, "");
sql1 = EndSign + sql1;
n++;
}
Regex rg1 = new Regex(@"\`[0-9]+\[");
CKeyValue kv = null;
PList <Para> paraList = method.paraList;
string paraClassName = ""; //DJTools.GetParamertClassNameByDbTag(DbTag);
foreach (Para para in paraList)
{
if (para.ParaType.BaseType == typeof(System.MulticastDelegate) && rg1.IsMatch(para.ParaType.ToString()))
{
continue;
}
if (DJTools.IsBaseType(para.ParaType))
{
//方法参数为基本类型 string, int, bool 等
kv = sqlParaList1[para.ParaName.ToLower()];
if (null == kv)
{
continue;
}
method.append(ref code, LeftSpaceLevel.one, "{0}.Add(\"{2}\", {3});", dbParaListVarName, paraClassName, kv.Value.ToString(), para.ParaName);
}
else
{
LeftSpaceLevel leftSpaceLevel = LeftSpaceLevel.one;
if (null != para.ParaType.GetInterface("IEnumerable"))
{
//集合复杂类型
//ICollection collection = (ICollection)para.ParaValue;
method.append(ref code, LeftSpaceLevel.one, "");
method.append(ref code, LeftSpaceLevel.one, "System.Collections.ICollection collection = (System.Collections.ICollection){0};", para.ParaName);
method.append(ref code, LeftSpaceLevel.one, "");
if (null != para.ParaType.GetInterface("IDictionary"))
{
method.append(ref code, leftSpaceLevel, "//键值对情况");
method.append(ref code, leftSpaceLevel, "object vObj = null;");
method.append(ref code, leftSpaceLevel, "string key = \"\";");
method.append(ref code, leftSpaceLevel, "foreach (var item in collection)");
method.append(ref code, leftSpaceLevel, "{");
method.append(ref code, leftSpaceLevel + 1, "key = item.GetType().GetProperty(\"Key\").GetValue(item, null).ToString();");
method.append(ref code, leftSpaceLevel + 1, "vObj = item.GetType().GetProperty(\"Value\").GetValue(item, null);");
method.append(ref code, leftSpaceLevel + 1, "if (DJTools.IsBaseType(vObj.GetType())) break;");
method.append(ref code, leftSpaceLevel + 1, "if (null != vObj.GetType().GetInterface(\"IEnumerable\")) break;");
method.append(ref code, leftSpaceLevel + 1, "//值必须是简单类型:int, string, bool, float, double等");
method.append(ref code, leftSpaceLevel + 1, "");
//Type dataType, string dbTag, object data, string fieldName, List<DbParameter> dbParas
method.append(ref code, leftSpaceLevel + 1, "{0}.GetDbParaByBaseType(typeof(string),\"{1}\",vObj,key,{2});", autoCallName, DbTag, dbParaListVarName);
method.append(ref code, leftSpaceLevel + 1, "");
method.append(ref code, leftSpaceLevel, "}"); //foreach (var item in collection)
}
else if (null != para.ParaType.GetInterface("IList") || para.ParaType.IsArray)
{
leftSpace = method.StartSpace + method.getSpace((int)leftSpaceLevel);
method.append(ref code, leftSpaceLevel, "//List集合情况 或 数组情况");
method.append(ref code, leftSpaceLevel, "foreach (var item in collection)");
method.append(ref code, leftSpaceLevel, "{");
method.append(ref code, leftSpaceLevel + 1, "if (DJTools.IsBaseType(item.GetType())) break;");
method.append(ref code, leftSpaceLevel + 1, "if (null != item.GetType().GetInterface(\"IEnumerable\")) break;");
method.append(ref code, leftSpaceLevel + 1, "//集合元素必须是单体复杂对象(数据实体)");
//object entity, List<DbParameter> dbParas, EList<CKeyValue> paraNameList
method.append(ref code, leftSpaceLevel + 1, "{0}.GetDbParaListByEntity(item,{1},{2});", autoCallName, dbParaListVarName, sqlParasVarName);
code += "\r\n" + executeDbHelper;
method.append(ref code, leftSpaceLevel + 1, "");
method.append(ref code, leftSpaceLevel, "}"); //foreach (var item in collection)
}
}
else if (typeof(DataTable) == para.ParaType)
{
leftSpace = method.StartSpace + method.getSpace((int)leftSpaceLevel);
method.append(ref code, LeftSpaceLevel.one, "");
method.append(ref code, LeftSpaceLevel.one, "{0} = null == {0} ? new System.Data.DataTable() : {0};", para.ParaName);
method.append(ref code, LeftSpaceLevel.one, "System.Data.DataTable dtable = (System.Data.DataTable){0};", para.ParaName);
method.append(ref code, LeftSpaceLevel.one, "EList<CKeyValue> tableColumns = new EList<CKeyValue>();");
method.append(ref code, LeftSpaceLevel.one, "");
method.append(ref code, leftSpaceLevel, "foreach(System.Data.DataColumn c in dtable.Columns)");
method.append(ref code, leftSpaceLevel, "{");
method.append(ref code, leftSpaceLevel + 1, "tableColumns.Add(new CKeyValue(){ Key = c.ColumnName.ToLower(), Value = c.ColumnName, other = c.DataType });");
method.append(ref code, leftSpaceLevel, "}");
method.append(ref code, leftSpaceLevel, "");
method.append(ref code, leftSpaceLevel, "foreach(System.Data.DataRow dr in dtable.Rows)");
method.append(ref code, leftSpaceLevel, "{");
//GetDbParaByDataRow(DataRow row, List<DbParameter> dbParas, EList<CKeyValue> sqlParaNameList, EList<CKeyValue> tableColumns)
method.append(ref code, leftSpaceLevel + 1, "{0}.GetDbParaByDataRow(dr,{1},{2},tableColumns);", autoCallName, dbParaListVarName, sqlParasVarName);
code += "\r\n" + executeDbHelper;
method.append(ref code, leftSpaceLevel + 1, "");
method.append(ref code, leftSpaceLevel, "}");//foreach(var dr in dtable.Rows)
}
else
{
//单体复杂类型(数据实体)
//object entity, List<DbParameter> dbParas, EList<CKeyValue> paraNameList
method.append(ref code, LeftSpaceLevel.one, "");
method.append(ref code, LeftSpaceLevel.one, "//单体复杂类型(数据实体) ");
method.append(ref code, LeftSpaceLevel.one, "{0}.GetDbParaListByEntity({1},{2},{3});", autoCallName, para.ParaName, dbParaListVarName, sqlParasVarName);
method.append(ref code, LeftSpaceLevel.one, "");
}
}
}
}
if (string.IsNullOrEmpty(leftSpace))
{
method.append(ref code, LeftSpaceLevel.one, "");
ExecuteSqlCode(method, LeftSpaceLevel.one, dataOptType, sqlVarName, dbParaListVarName, dbHelperVarName, resultVarName, ref code);
}
else
{
string code1 = "";
ExecuteSqlCode(method, LeftSpaceLevel.two, dataOptType, sqlVarName, dbParaListVarName, dbHelperVarName, resultVarName, ref code1);
code = code.Replace(executeDbHelper, code1);
}
if (!string.IsNullOrEmpty(funcResultVarName))
{
method.append(ref code, LeftSpaceLevel.one, "");
if (null == method.methodComponent.ActionType)
{
ReturnResult(method, LeftSpaceLevel.one, dataOptType, funcResultVarName, resultVarName, ref code);
}
else
{
method.append(ref code, LeftSpaceLevel.one, "{0} = {1};", funcResultVarName, resultVarName);
}
}
return(code);
}
/// <summary>
/// 把普通字符串附加到code字符串后，附加前在code字符串后加回车换行
/// </summary>
/// <param name="code">返回字符串附加后的结果</param>
/// <param name="level">左边tab层级量(空字符串)</param>
/// <param name="s">要附加的字符串</param>
public void append(ref string code, LeftSpaceLevel level, string s)
{
append(ref code, level, s, null);
}
