public override string GetTableName(PocoData pd, TableNameManger tn)
{
var ti = pd.TableInfo;
if (ti.TableName.Contains("."))
{
return(ti.TableName);
}
var tag = ti.FixTag;
var tableName = ti.TableName;
var name = tn.Get(tag);
if (name != null)
{
tableName = name.TablePrefix + tableName + name.TableSuffix;
}
var schemaName = ti.SchemaName;
if (string.IsNullOrEmpty(schemaName))
{
return(this.EscapeSqlIdentifier(tableName));
}
return(string.Format("[{0}_{1}]", schemaName, tableName));
}
internal T Run <T>(string sql, object[] args, Func <T> func, params string[] methodtags)
{
if (_usedCacheService == false && _usedCacheServiceOnce == false)
{
return(func());
}
_usedCacheServiceOnce = false;//记录一次
StringBuilder sb = new StringBuilder();
if (_usedCacheServiceOnce)
{
sb.Append(_cacheTag);
sb.Append("|");
}
sb.Append(sql);
sb.Append("|");
sb.Append(typeof(T).FullName);
for (int i = 0; i < args.Length; i++)
{
sb.Append("|");
sb.Append(args[i].ToString());
}
for (int i = 0; i < methodtags.Length; i++)
{
sb.Append("|");
sb.Append(methodtags[i]);
}
var t = _tableNameManger.Get <T>();
if (t != null)
{
sb.Append("|");
sb.Append(t.ToString());
}
string tag = sb.ToString();// getMd5String(sb.ToString());
if (_usedCacheServiceOnce)
{
return(_cacheService.Get(tag, func, _cacheTimeOnce, _cacheTag));
}
return(_cacheService.Get(tag, func, _cacheTime, null));
}
public virtual string EscapeTableName(PocoData pd, TableNameManger tn)
{
var ti = pd.TableInfo;
var index = ti.TableName.IndexOf('.');
if (index > -1)
{
return(ti.TableName.Substring(index));
}
var tag = ti.FixTag;
var tableName = ti.TableName;
var name = tn.Get(tag);
if (name != null)
{
tableName = name.TablePrefix + tableName + name.TableSuffix;
}
return(EscapeSqlIdentifier(tableName));
}
public virtual string GetTableName(Table ti, TableNameManger _tableNameManger)
{
if (ti.TableName.Contains("."))
{
return(ti.TableName);
}
var tag = ti.FixTag;
var tableName = ti.TableName;
var name = _tableNameManger.Get(tag);
if (name != null)
{
tableName = name.TablePrefix + tableName + name.TableSuffix;
}
var schemaName = ti.SchemaName;
if (string.IsNullOrEmpty(schemaName))
{
return(provider.EscapeSqlIdentifier(tableName));
}
return(string.Format("{0}.{1}", provider.EscapeSqlIdentifier(schemaName), provider.EscapeSqlIdentifier(tableName)));
}