public string GetExistsKeySql <T>()
{
var table = OracleCache.GetTableEntity <T>();
CommonUtil.CheckTableKey(table);
return(string.Format("SELECT COUNT(1) FROM {0} WHERE {1}=:{1}", table.TableName, table.KeyName));
}
public string GetDeleteByIdsSql <T>()
{
var table = OracleCache.GetTableEntity <T>();
CommonUtil.CheckTableKey(table);
return(table.DeleteByIdsSql);
}
public string GetBySkipTakeSql <T>(int skip, int take, string where, string returnFields, string orderBy)
{
var table = OracleCache.GetTableEntity <T>();
StringBuilder sb = new StringBuilder();
InitPage(sb, table, skip, take, where, returnFields, orderBy);
return(sb.ToString());
}
public string GetInsertReturnIdSql <T>(string sequence = null)
{
if (string.IsNullOrEmpty(sequence))
{
throw new Exception("oracle [sequence] can't no be null or empty");
}
return((OracleCache.GetTableEntity <T>().InsertReturnIdSql).Replace("```seq```", sequence));
}
public string GetByWhereSql <T>(string where, string returnFields, string orderBy)
{
var table = OracleCache.GetTableEntity <T>();
if (string.IsNullOrEmpty(returnFields))
{
returnFields = table.AllFields;
}
return(string.Format("SELECT {0} FROM {1} {2} {3}", returnFields, table.TableName, where, orderBy));
}
public string GetByIdsWithFieldSql <T>(string field, string returnFields)
{
var table = OracleCache.GetTableEntity <T>();
if (string.IsNullOrEmpty(returnFields))
{
returnFields = table.AllFields;
}
return(string.Format("SELECT {0} FROM {1} WHERE {2} IN :ids", returnFields, table.TableName, field));
}
public string GetUpdateSql <T>(string updateFields)
{
var table = OracleCache.GetTableEntity <T>();
CommonUtil.CheckTableKey(table);
if (string.IsNullOrEmpty(updateFields))
{
return(table.UpdateSql);
}
return(CommonUtil.CreateUpdateSql(table, updateFields, ":"));
}
public string GetSchemaTableSql <T>(string returnFields)
{
var table = OracleCache.GetTableEntity <T>();
if (string.IsNullOrEmpty(returnFields))
{
return(string.Format("SELECT {0} FROM {1} WHERE rownum=0", table.AllFields, table.TableName));
}
else
{
return(string.Format("SELECT {0} FROM {1} WHERE rownum=0", returnFields, table.TableName));
}
}
public string GetAllSql <T>(string returnFields, string orderBy)
{
var table = OracleCache.GetTableEntity <T>();
if (string.IsNullOrEmpty(returnFields))
{
return(table.GetAllSql + orderBy);
}
else
{
return(string.Format("SELECT {0} FROM {1} {2}", returnFields, table.TableName, orderBy));
}
}
public string GetByIdsSql <T>(string returnFields)
{
var table = OracleCache.GetTableEntity <T>();
CommonUtil.CheckTableKey(table);
if (string.IsNullOrEmpty(returnFields))
{
return(table.GetByIdsSql);
}
else
{
return(string.Format("SELECT {0} FROM {1} WHERE {2} IN :ids", returnFields, table.TableName, table.KeyName));
}
}
public string GetByWhereFirstSql <T>(string where, string returnFields)
{
var table = OracleCache.GetTableEntity <T>();
if (string.IsNullOrEmpty(returnFields))
{
returnFields = table.AllFields;
}
if (!string.IsNullOrEmpty(where))
{
where += "AND rownum=1";
}
else
{
where = "WHERE rownum=1";
}
return(string.Format("SELECT {0} FROM {1} {2}", returnFields, table.TableName, where));
}
public string GetUpdateByWhereSql <T>(string where, string updateFields)
{
var table = OracleCache.GetTableEntity <T>();
return(CommonUtil.CreateUpdateByWhereSql(table, where, updateFields, ":"));
}
public string GetInsertSql <T>()
{
return(OracleCache.GetTableEntity <T>().InsertSql);
}
public string GetTotalSql <T>(string where)
{
var table = OracleCache.GetTableEntity <T>();
return(string.Format("SELECT COUNT(1) FROM {0} {1}", table.TableName, where));
}
public string GetDeleteAllSql <T>()
{
return(OracleCache.GetTableEntity <T>().DeleteAllSql);
}
