/// <summary> /// 插入 /// 使用说明:sqlSugar.Insert(entity); /// </summary> /// <typeparam name="T"></typeparam> /// <param name="entity">插入对象</param> /// <param name="isIdentity">该属性已经作废可以不填,主键是否为自增长,true可以不填,false必填</param> /// <returns></returns> public object Insert <T>(T entity, bool isIdentity = true) where T : class { Type type = entity.GetType(); string typeName = type.Name; typeName = GetTableNameByClassType(typeName); var seqMap = OracleConfig.SequenceMapping; StringBuilder sbInsertSql = new StringBuilder(); List <OracleParameter> pars = new List <OracleParameter>(); var identities = SqlSugarTool.GetIdentitiesKeyByTableName(this, typeName); isIdentity = identities != null && identities.Where(it => it.Key.ToLower() == typeName.ToLower()).Count() > 0; //sql语句缓存 string cacheSqlKey = "db.Insert." + type.FullName; var cacheSqlManager = CacheManager <StringBuilder> .GetInstance(); //属性缓存 string cachePropertiesKey = "db." + type.FullName + ".GetProperties"; var cachePropertiesManager = CacheManager <PropertyInfo[]> .GetInstance(); PropertyInfo[] props = null; if (cachePropertiesManager.ContainsKey(cachePropertiesKey)) { props = cachePropertiesManager[cachePropertiesKey]; } else { props = type.GetProperties(); cachePropertiesManager.Add(cachePropertiesKey, props, cachePropertiesManager.Day); } var isContainCacheSqlKey = cacheSqlManager.ContainsKey(cacheSqlKey); if (isContainCacheSqlKey) { sbInsertSql = cacheSqlManager[cacheSqlKey]; } else { //2.获得实体的属性集合 //实例化一个StringBuilder做字符串的拼接 sbInsertSql.Append("insert into " + typeName + " ("); //3.遍历实体的属性集合 foreach (PropertyInfo prop in props) { if (this.IsIgnoreErrorColumns) { if (!SqlSugarTool.GetColumnsByTableName(this, typeName).Any(it => it.ToLower() == prop.Name.ToLower())) { continue; } } //4.将属性的名字加入到字符串中 sbInsertSql.Append("" + prop.Name + ","); } //**去掉最后一个逗号 sbInsertSql.Remove(sbInsertSql.Length - 1, 1); sbInsertSql.Append(" ) values("); } //5.再次遍历,形成参数列表"(@xx,@xx@xx)"的形式 foreach (PropertyInfo prop in props) { //EntityState,@EntityKey if (!isIdentity || identities.Any(it => it.Value.ToLower() != prop.Name.ToLower())) { if (this.IsIgnoreErrorColumns) { if (!SqlSugarTool.GetColumnsByTableName(this, typeName).Any(it => it.ToLower() == prop.Name.ToLower())) { continue; } } if (!cacheSqlManager.ContainsKey(cacheSqlKey)) { sbInsertSql.Append(":" + prop.Name + ","); } object val = prop.GetValue(entity, null); if (val == null) { val = DBNull.Value; } if (_serialNumber.IsValuable()) { Func <PubModel.SerialNumber, bool> serEexp = it => it.TableName.ToLower() == typeName.ToLower() && it.FieldName.ToLower() == prop.Name.ToLower(); var isAnyNum = _serialNumber.Any(serEexp); if (isAnyNum && (val == DBNull.Value || val.IsNullOrEmpty())) { if (_serialNumber.First(serEexp).GetNumFunc != null) { val = _serialNumber.First(serEexp).GetNumFunc(); } if (_serialNumber.First(serEexp).GetNumFuncWithDb != null) { val = _serialNumber.First(serEexp).GetNumFuncWithDb(this); } } } if (prop.PropertyType.IsEnum) { val = (int)(val); } var par = new OracleParameter(":" + prop.Name, val.ToOracleParValue()); OracleConfig.SetParType(typeName, prop, par, this); SqlSugarTool.SetParSize(par); pars.Add(par); } else { if (!cacheSqlManager.ContainsKey(cacheSqlKey)) { var seqList = seqMap.Where(it => it.TableName.ToLower() == typeName.ToLower() && it.ColumnName.ToLower() == prop.Name.ToLower()); if (seqList.Any()) { var seqName = seqList.First().Value; sbInsertSql.Append(seqName + ".Nextval,"); } else { sbInsertSql.Append("null,"); } } } } if (!isContainCacheSqlKey) { //**去掉最后一个逗号 sbInsertSql.Remove(sbInsertSql.Length - 1, 1); sbInsertSql.Append(")"); cacheSqlManager.Add(cacheSqlKey, sbInsertSql, cacheSqlManager.Day); } var sql = sbInsertSql.ToString(); try { var lastInsertRowId = ExecuteCommand(sql, pars.ToArray()); if (lastInsertRowId > 0) { if (isIdentity) { var seqName = seqMap.First(it => it.TableName.ToLower() == typeName.ToLower()).Value; var eqValue = GetInt("SELECT " + seqName + ".currval from dual"); lastInsertRowId = eqValue; } else { lastInsertRowId = 1; } } return(lastInsertRowId); } catch (Exception ex) { throw new Exception("sql:" + sql + "\n" + ex.Message); } }
/// <summary> /// 更新 /// 注意:rowObj为T类型将更新该实体的非主键所有列,如果rowObj类型为匿名类将更新指定列 /// 使用说明:sqlSugar.Update《T》(rowObj,whereObj); /// </summary> /// <typeparam name="T"></typeparam> /// <param name="rowObj">new T(){name="张三",sex="男"}或者new {name="张三",sex="男"}</param> /// <param name="expression">it.id=100</param> /// <returns></returns> public bool Update <T>(object rowObj, Expression <Func <T, bool> > expression) where T : class { if (rowObj == null) { throw new ArgumentNullException("SqlSugarClient.Update.rowObj"); } if (expression == null) { throw new ArgumentNullException("SqlSugarClient.Update.expression"); } Type type = typeof(T); string typeName = type.Name; typeName = GetTableNameByClassType(typeName); var rows = SqlSugarTool.GetParameters(rowObj); var isDynamic = rowObj.GetType() != type; var isClass = !isDynamic; //sql语句缓存 string cacheSqlKey = "db.update." + type.FullName + rows.Length; var cacheSqlManager = CacheManager <StringBuilder> .GetInstance(); string pkName = SqlSugarTool.GetPrimaryKeyByTableName(this, typeName); var identityNames = SqlSugarTool.GetIdentitiesKeyByTableName(this, typeName); ResolveExpress re = new ResolveExpress(); re.ResolveExpression(re, expression); StringBuilder sbSql = new StringBuilder(); if (cacheSqlManager.ContainsKey(cacheSqlKey) && isClass) { sbSql = cacheSqlManager[cacheSqlKey]; } else { sbSql = new StringBuilder(string.Format(" UPDATE {0} SET ", typeName)); foreach (var r in rows) { var name = r.ParameterName.TrimStart(':'); var isPk = pkName != null && pkName.ToLower() == name.ToLower(); var isIdentity = identityNames.Any(it => it.Value.ToLower() == name.ToLower()); var isDisableUpdateColumns = DisableUpdateColumns != null && DisableUpdateColumns.Any(it => it.ToLower() == name.ToLower()); if (this.IsIgnoreErrorColumns) { if (!SqlSugarTool.GetColumnsByTableName(this, typeName).Any(it => it.ToLower() == name.ToLower())) { continue; } } if (isPk || isIdentity || isDisableUpdateColumns) { if (isClass) { continue; } } sbSql.Append(string.Format(" {0} =:{0} ,", name)); } sbSql.Remove(sbSql.Length - 1, 1); sbSql.Append(" WHERE 1=1 "); sbSql.Append(re.SqlWhere); cacheSqlManager.Add(cacheSqlKey, sbSql, cacheSqlManager.Day); } List <OracleParameter> parsList = new List <OracleParameter>(); parsList.AddRange(re.Paras); var pars = rows; if (pars != null) { foreach (var par in pars) { SqlSugarTool.SetParSize(par); parsList.Add(par); } } try { var updateRowCount = ExecuteCommand(sbSql.ToString(), parsList.ToArray()); return(updateRowCount > 0); } catch (Exception ex) { throw new Exception("sql:" + sbSql.ToString() + "\n" + ex.Message); } }
/// <summary> /// 获取DataSet /// </summary> /// <param name="sql"></param> /// <param name="pars"></param> /// <returns></returns> public DataSet GetDataSetAll(string sql, object pars) { return(GetDataSetAll(sql, SqlSugarTool.GetParameters(pars))); }
/// <summary> /// 根据SQL语句将结果集映射到List《T》 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="sql"></param> /// <param name="whereObj"></param> /// <returns></returns> public List <T> SqlQuery <T>(string sql, object whereObj = null) { var pars = SqlSugarTool.GetParameters(whereObj).ToList(); return(SqlQuery <T>(sql, pars)); }
/// <summary> ///获取没有符号的参数名称 /// </summary> /// <param name="name"></param> /// <returns></returns> internal static string GetOracleParameterNameNoParSymbol(this string name) { return(SqlSugarTool.GetOracleParameterNameNoParSymbol(name)); }
/// <summary> /// 获取DataTable /// </summary> /// <param name="sql"></param> /// <param name="pars">匿名参数(例如:new{id=1,name="张三"})</param> /// <returns></returns> public DataTable GetDataTable(string sql, object pars) { return(GetDataTable(sql, SqlSugarTool.GetParameters(pars))); }
/// <summary> /// 根据SQL获取T的集合 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="sql"></param> /// <param name="pars">匿名参数(例如:new{id=1,name="张三"})</param> /// <returns></returns> public List <T> GetList <T>(string sql, object pars) { return(GetList <T>(sql, SqlSugarTool.GetParameters(pars))); }
/// <summary> /// 动态获取IDataRecord里面的函数 /// </summary> /// <param name="generator"></param> /// <param name="type"></param> /// <param name="isNullable"></param> /// <param name="pro"></param> /// <param name="dbTypeName"></param> /// <param name="fieldName"></param> private static void GeneratorCallMethod(ILGenerator generator, Type type, bool isNullable, PropertyInfo pro, string dbTypeName, string fieldName) { List <string> guidThrow = new List <string>() { "int32", "datetime", "decimal", "double", "byte", "string" }; //数据库为GUID有错的实体类形 List <string> intThrow = new List <string>() { "datetime" }; //数据库为int有错的实体类形 List <string> stringThrow = new List <string>() { "int32", "datetime", "decimal", "double", "byte", "guid" }; //数据库为vachar有错的实体类形 List <string> decimalThrow = new List <string>() { "datetime", "byte", "guid" }; List <string> doubleThrow = new List <string>() { "datetime", "byte", "guid" }; List <string> dateThrow = new List <string>() { "int32", "decimal", "double", "byte", "guid" }; List <string> shortThrow = new List <string>() { "datetime", "guid" }; List <string> byteThrow = new List <string>() { "datetime", "guid" }; MethodInfo method = null; var typeName = SqlSugarTool.ChangeDBTypeToCSharpType(dbTypeName); var objTypeName = type.Name.ToLower(); var isEnum = type.IsEnum; if (isEnum) { typeName = "ENUMNAME"; } else if (dbTypeName.Contains("hierarchyid") || typeName == "byte[]" || objTypeName == "object") { generator.Emit(OpCodes.Call, getValueMethod); generator.Emit(OpCodes.Unbox_Any, pro.PropertyType);//找不到类型才执行拆箱(类型转换) return; } if (isNullable) { switch (typeName) { case "int": CheckType(intThrow, objTypeName, typeName, fieldName); var isNotInt = objTypeName != "int32"; if (isNotInt) { method = getOtherNull.MakeGenericMethod(type); } else { method = getConvertInt32; } break; case "bool": if (objTypeName != "bool" && objTypeName != "boolean") { method = getOtherNull.MakeGenericMethod(type); } else { method = getConvertBoolean; } break; case "string": CheckType(stringThrow, objTypeName, typeName, fieldName); method = getString; break; case "dateTime": CheckType(dateThrow, objTypeName, typeName, fieldName); if (objTypeName != "datetime") { method = getOtherNull.MakeGenericMethod(type); } else { method = getConvertDateTime; } break; case "decimal": CheckType(decimalThrow, objTypeName, typeName, fieldName); var isNotDecimal = objTypeName != "decimal"; if (isNotDecimal) { method = getOtherNull.MakeGenericMethod(type); } else { method = getConvertDecimal; } break; case "double": CheckType(doubleThrow, objTypeName, typeName, fieldName); var isNotDouble = objTypeName != "double"; if (isNotDouble) { method = getOtherNull.MakeGenericMethod(type); } else { method = getConvertDouble; } break; case "guid": CheckType(guidThrow, objTypeName, typeName, fieldName); if (objTypeName != "guid") { method = getOtherNull.MakeGenericMethod(type); } else { method = getConvertGuid; } break; case "byte": CheckType(byteThrow, objTypeName, typeName, fieldName); if (objTypeName != "byte") { method = getOtherNull.MakeGenericMethod(type); } else { method = getConvertByte; } break; case "ENUMNAME": method = getConvertToEnum_Nullable.MakeGenericMethod(type); break; case "short": CheckType(shortThrow, objTypeName, typeName, fieldName); var isNotShort = objTypeName != "int16" && objTypeName != "short"; if (isNotShort) { method = getOtherNull.MakeGenericMethod(type); } else { method = getConvertInt16; } break; default: method = getOtherNull.MakeGenericMethod(type); break; } generator.Emit(OpCodes.Call, method); } else { switch (typeName) { case "int": CheckType(intThrow, objTypeName, typeName, fieldName); var isNotInt = objTypeName != "int32"; if (isNotInt) { method = getOther.MakeGenericMethod(type); } else { method = getInt32; } break; case "bool": if (objTypeName != "bool" && objTypeName != "boolean") { method = getOther.MakeGenericMethod(type); } else { method = getBoolean; } break; case "string": CheckType(stringThrow, objTypeName, typeName, fieldName); method = getString; break; case "dateTime": CheckType(dateThrow, objTypeName, typeName, fieldName); if (objTypeName != "datetime") { method = getOther.MakeGenericMethod(type); } else { method = getDateTime; } break; case "decimal": CheckType(decimalThrow, objTypeName, typeName, fieldName); var isNotDecimal = objTypeName != "decimal"; if (isNotDecimal) { method = getOther.MakeGenericMethod(type); } else { method = getDecimal; } break; case "double": CheckType(doubleThrow, objTypeName, typeName, fieldName); var isNotDouble = objTypeName != "double"; if (isNotDouble) { method = getOther.MakeGenericMethod(type); } else { method = getDouble; } break; case "guid": CheckType(guidThrow, objTypeName, typeName, fieldName); if (objTypeName != "guid") { method = getOther.MakeGenericMethod(type); } else { method = getGuid; } break; case "byte": CheckType(byteThrow, objTypeName, typeName, fieldName); if (objTypeName != "byte") { method = getOther.MakeGenericMethod(type); } else { method = getByte; } break; case "ENUMNAME": method = getValueMethod; break; case "short": CheckType(shortThrow, objTypeName, typeName, fieldName); var isNotShort = objTypeName != "int16" && objTypeName != "short"; if (isNotShort) { method = getOther.MakeGenericMethod(type); } else { method = getInt16; } break; default: method = getOther.MakeGenericMethod(type); break;; } generator.Emit(OpCodes.Call, method); if (method == getValueMethod) { generator.Emit(OpCodes.Unbox_Any, pro.PropertyType);//找不到类型才执行拆箱(类型转换) } } }
/// <summary> /// 执行SQL返回受影响行数 /// </summary> /// <param name="sql"></param> /// <param name="pars">匿名参数(例如:new{id=1,name="张三"})</param> /// <returns></returns> public int ExecuteCommand(string sql, object pars) { return(ExecuteCommand(sql, SqlSugarTool.GetParameters(pars))); }
/// <summary> /// 获取DataReader /// </summary> /// <param name="sql"></param> /// <param name="pars">匿名参数(例如:new{id=1,name="张三"})</param> /// <returns></returns> public OracleDataReader GetReader(string sql, object pars) { return(GetReader(sql, SqlSugarTool.GetParameters(pars))); }
/// <summary> /// 获取第一行第一列 /// </summary> /// <param name="sql"></param> /// <param name="pars">匿名参数(例如:new{id=1,name="张三"})</param> /// <returns></returns> public object GetScalar(string sql, object pars) { return(GetScalar(sql, SqlSugarTool.GetParameters(pars))); }
/// <summary> /// 获取第一行第一列 /// </summary> /// <param name="sql"></param> /// <param name="pars">匿名参数(例如:new{id=1,name="张三"})</param> /// <returns></returns> public int GetInt(string sql, object pars) { return(GetInt(sql, SqlSugarTool.GetParameters(pars))); }
/// <summary> /// 获取第一行第一列 /// </summary> /// <param name="sql"></param> /// <param name="pars">匿名参数(例如:new{id=1,name="张三"})</param> /// <returns></returns> public string GetString(string sql, object pars) { return(GetString(sql, SqlSugarTool.GetParameters(pars))); }
/// <summary> /// 更新 /// 注意:rowObj为T类型将更新该实体的非主键所有列,如果rowObj类型为匿名类将更新指定列 /// 使用说明:sqlSugar.Update《T》(rowObj,whereObj); /// </summary> /// <typeparam name="T"></typeparam> /// <param name="rowObj">new T(){name="张三",sex="男"}或者new {name="张三",sex="男"}</param> /// <param name="whereIn">new int[]{1,2,3}</param> /// <returns></returns> public bool Update <T, FiledType>(object rowObj, params FiledType[] whereIn) where T : class { if (rowObj == null) { throw new ArgumentNullException("SqlSugarClient.Update.rowObj"); } Type type = typeof(T); string typeName = type.Name; typeName = GetTableNameByClassType(typeName); StringBuilder sbSql = new StringBuilder(string.Format(" UPDATE {0} SET ", typeName)); Dictionary <string, object> rows = SqlSugarTool.GetObjectToDictionary(rowObj); string pkName = SqlSugarTool.GetPrimaryKeyByTableName(this, typeName); var identityNames = SqlSugarTool.GetIdentitiesKeyByTableName(this, typeName); foreach (var r in rows) { var isPk = pkName != null && pkName.ToLower() == r.Key.ToLower(); var isIdentity = identityNames.Any(it => it.Value.ToLower() == r.Key.ToLower()); var isDisableUpdateColumns = DisableUpdateColumns != null && DisableUpdateColumns.Any(it => it.ToLower() == r.Key.ToLower()); if (this.IsIgnoreErrorColumns) { if (!SqlSugarTool.GetColumnsByTableName(this, typeName).Any(it => it.ToLower() == r.Key.ToLower())) { continue; } } if (isPk || isIdentity || isDisableUpdateColumns) { if (rowObj.GetType() == type) { continue; } } sbSql.Append(string.Format(" {0} =:{0} ,", r.Key)); } sbSql.Remove(sbSql.Length - 1, 1); if (whereIn.Count() == 0) { var value = type.GetProperties().Cast <PropertyInfo>().Single(it => it.Name == pkName).GetValue(rowObj, null); sbSql.AppendFormat("WHERE {1} IN ('{2}')", typeName, pkName, value); } else { sbSql.AppendFormat("WHERE {1} IN ({2})", typeName, pkName, whereIn.ToJoinSqlInVal()); } List <OracleParameter> parsList = new List <OracleParameter>(); var pars = rows.Select(c => new OracleParameter(":" + c.Key, c.Value.ToOracleParValue())); if (pars != null) { foreach (var par in pars) { var isDisableUpdateColumns = DisableUpdateColumns != null && DisableUpdateColumns.Any(it => it.ToLower() == par.ParameterName.TrimStart(':').ToLower()); if (!isDisableUpdateColumns) { parsList.Add(par); } } } try { var updateRowCount = ExecuteCommand(sbSql.ToString(), parsList.ToArray()); return(updateRowCount > 0); } catch (Exception ex) { throw new Exception("sql:" + sbSql.ToString() + "\n" + ex.Message); } }
/// <summary> /// 根据SQL获取T /// </summary> /// <typeparam name="T">可以是int、string等,也可以是类或者数组、字典</typeparam> /// <param name="sql"></param> /// <param name="pars">匿名参数(例如:new{id=1,name="张三"})</param> /// <returns></returns> public T GetSingle <T>(string sql, object pars) { return(GetSingle <T>(sql, SqlSugarTool.GetParameters(pars))); }
/// <summary> /// 批量假删除 /// 使用说明:: /// FalseDelete《T》("is_del",new int[]{1,2,3})或者Delete《T》("is_del",3) /// </summary> /// <param name="field">更新删除状态字段</param> /// <param name="whereIn">delete ids</param> public bool FalseDelete <T, FiledType>(string field, params FiledType[] whereIn) { Type type = typeof(T); string typeName = type.Name; typeName = GetTableNameByClassType(typeName); //属性缓存 string cachePropertiesKey = "db." + type.FullName + ".GetProperties"; var cachePropertiesManager = CacheManager <PropertyInfo[]> .GetInstance(); PropertyInfo[] props = SqlSugarTool.GetGetPropertiesByCache(type, cachePropertiesKey, cachePropertiesManager); bool isSuccess = false; if (whereIn != null && whereIn.Length > 0) { string sql = string.Format("UPDATE {0} SET {3}=1 WHERE {1} IN ({2})", typeName, SqlSugarTool.GetPrimaryKeyByTableName(this, typeName), whereIn.ToJoinSqlInVal(), field); int deleteRowCount = ExecuteCommand(sql); isSuccess = deleteRowCount > 0; } return(isSuccess); }
/// <summary> /// 根据SQL获取T /// </summary> /// <typeparam name="T"></typeparam> /// <param name="sql"></param> /// <param name="pars"></param> /// <returns></returns> public T GetSingle <T>(string sql, params OracleParameter[] pars) { var reval = SqlSugarTool.DataReaderToList <T>(typeof(T), GetReader(sql, pars), null).Single(); return(reval); }
/// <summary> /// /// </summary> /// <param name="type"></param> /// <param name="dataRecord"></param> /// <returns></returns> public static IDataReaderEntityBuilder <T> CreateBuilder(Type type, IDataRecord dataRecord) { IDataReaderEntityBuilder <T> dynamicBuilder = new IDataReaderEntityBuilder <T>(); DynamicMethod method = new DynamicMethod("DynamicCreateEntity", type, new Type[] { typeof(IDataRecord) }, type, true); ILGenerator generator = method.GetILGenerator(); LocalBuilder result = generator.DeclareLocal(type); generator.Emit(OpCodes.Newobj, type.GetConstructor(Type.EmptyTypes)); generator.Emit(OpCodes.Stloc, result); string cacheKey = "SqlSugarClient.InitAttributes"; var cm = CacheManager <List <KeyValue> > .GetInstance(); var tFieldNames = typeof(T).GetProperties().Select(it => it.Name).ToList(); for (int i = 0; i < dataRecord.FieldCount; i++) { string dbFieldName = dataRecord.GetName(i); if (cm.ContainsKey(cacheKey) && cm[cacheKey].Any(it => it.Value.ToLower() == dbFieldName.ToLower())) { var classFieldName = cm[cacheKey].Single(it => it.Value.ToLower() == dbFieldName.ToLower()).Key; if (tFieldNames.Any(it => it.ToLower() == classFieldName.ToLower()))//T包含映射属性 { dbFieldName = classFieldName; } } else { if (tFieldNames.Any(it => it.ToLower() == dbFieldName.ToLower())) { dbFieldName = tFieldNames.Single(it => it.ToLower() == dbFieldName.ToLower()); } else { continue; } } PropertyInfo propertyInfo = type.GetProperty(dbFieldName); Label endIfLabel = generator.DefineLabel(); if (propertyInfo != null && propertyInfo.GetSetMethod() != null) { bool isNullable = false; var underType = SqlSugarTool.GetUnderType(propertyInfo, ref isNullable); generator.Emit(OpCodes.Ldarg_0); generator.Emit(OpCodes.Ldc_I4, i); generator.Emit(OpCodes.Callvirt, isDBNullMethod); generator.Emit(OpCodes.Brtrue, endIfLabel); generator.Emit(OpCodes.Ldloc, result); generator.Emit(OpCodes.Ldarg_0); generator.Emit(OpCodes.Ldc_I4, i); GeneratorCallMethod(generator, underType, isNullable, propertyInfo, dataRecord.GetDataTypeName(i), dbFieldName); generator.Emit(OpCodes.Callvirt, propertyInfo.GetSetMethod()); generator.MarkLabel(endIfLabel); } } generator.Emit(OpCodes.Ldloc, result); generator.Emit(OpCodes.Ret); dynamicBuilder.handler = (Load)method.CreateDelegate(typeof(Load)); return(dynamicBuilder); }
/// <summary> /// 获取转释后的表名和列名 /// </summary> /// <param name="tableName"></param> /// <returns></returns> public static string GetTranslationSqlName(this string tableName) { return(SqlSugarTool.GetTranslationSqlName(tableName)); }