public string GetDeleteByIdSql <T>()
{
var table = PostgreCache.GetTableEntity <T>();
CommonUtil.CheckTableKey(table);
return(table.DeleteByIdSql);
}
public string GetInsertIdentitySql <T>()
{
var table = PostgreCache.GetTableEntity <T>();
CommonUtil.CheckTableKey(table);
return(table.InsertIdentitySql);
}
public string GetExistsKeySql <T>()
{
var table = PostgreCache.GetTableEntity <T>();
CommonUtil.CheckTableKey(table);
return(string.Format("SELECT COUNT(1) FROM \"{0}\" WHERE \"{1}\"=@{1}", table.TableName, table.KeyName));
}
public string GetBySkipTakeSql <T>(int skip, int take, string where, string returnFields, string orderBy)
{
var table = PostgreCache.GetTableEntity <T>();
StringBuilder sb = new StringBuilder();
InitPage(sb, table, skip, take, where, returnFields, orderBy);
return(sb.ToString());
}
public string GetByWhereFirstSql <T>(string where, string returnFields)
{
var table = PostgreCache.GetTableEntity <T>();
if (string.IsNullOrEmpty(returnFields))
{
returnFields = table.AllFields;
}
return(string.Format("SELECT {0} FROM \"{1}\" {2} LIMIT 1", returnFields, table.TableName, where));
}
public string GetByIdsWithFieldSql <T>(string field, string returnFields)
{
var table = PostgreCache.GetTableEntity <T>();
if (string.IsNullOrEmpty(returnFields))
{
returnFields = table.AllFields;
}
return(string.Format("SELECT {0} FROM \"{1}\" WHERE \"{2}\"=ANY(@ids)", returnFields, table.TableName, field));
}
public string GetUpdateSql <T>(string updateFields)
{
var table = PostgreCache.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 = PostgreCache.GetTableEntity <T>();
if (string.IsNullOrEmpty(returnFields))
{
return(string.Format("SELECT {0} FROM \"{1}\" LIMIT 0", table.AllFields, table.TableName));
}
else
{
return(string.Format("SELECT {0} FROM \"{1}\" LIMIT 0", returnFields, table.TableName));
}
}
public string GetAllSql <T>(string returnFields, string orderBy)
{
var table = PostgreCache.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 = PostgreCache.GetTableEntity <T>();
CommonUtil.CheckTableKey(table);
if (string.IsNullOrEmpty(returnFields))
{
return(table.GetByIdsSql);
}
else
{
return(string.Format("SELECT {0} FROM \"{1}\" WHERE \"{2}\"=ANY(@ids)", returnFields, table.TableName, table.KeyName));
}
}
public string GetPageSql <T>(int pageIndex, int pageSize, string where, string returnFields, string orderBy)
{
int skip = 0;
if (pageIndex > 0)
{
skip = (pageIndex - 1) * pageSize;
}
var table = PostgreCache.GetTableEntity <T>();
StringBuilder sb = new StringBuilder();
sb.AppendFormat("SELECT COUNT(1) FROM \"{0}\" {1};", table.TableName, where);
InitPage(sb, table, skip, pageSize, where, returnFields, orderBy);
return(sb.ToString());
}
public string GetUpdateByWhereSql <T>(string where, string updateFields)
{
var table = PostgreCache.GetTableEntity <T>();
return(CommonUtil.CreateUpdateByWhereSql(table, where, updateFields, "\"", "\""));
}
public string GetInsertReturnIdSql <T>(string sequence = null)
{
return(PostgreCache.GetTableEntity <T>().InsertReturnIdSql);
}
public string GetInsertSql <T>()
{
return(PostgreCache.GetTableEntity <T>().InsertSql);
}
public string GetTotalSql <T>(string where)
{
var table = PostgreCache.GetTableEntity <T>();
return(string.Format("SELECT COUNT(1) FROM \"{0}\" {1}", table.TableName, where));
}
public string GetDeleteAllSql <T>()
{
return(PostgreCache.GetTableEntity <T>().DeleteAllSql);
}
