Esempio n. 1
0
        public string GetDeleteByIdSql <T>()
        {
            var table = OracleCache.GetTableEntity <T>();

            CommonUtil.CheckTableKey(table);
            return(table.DeleteByIdSql);
        }
Esempio n. 2
0
        public string GetInsertIdentitySql <T>()
        {
            var table = OracleCache.GetTableEntity <T>();

            CommonUtil.CheckTableKey(table);
            return(table.InsertIdentitySql);
        }
Esempio n. 3
0
        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));
        }
Esempio n. 4
0
        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());
        }
Esempio n. 5
0
 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));
 }
Esempio n. 6
0
        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));
        }
Esempio n. 7
0
        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));
        }
Esempio n. 8
0
        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, "\"", "\"", ":"));
        }
Esempio n. 9
0
        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));
            }
        }
Esempio n. 10
0
        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));
            }
        }
Esempio n. 11
0
        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));
            }
        }
Esempio n. 12
0
        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));
        }
Esempio n. 13
0
        public string GetUpdateByWhereSql <T>(string where, string updateFields)
        {
            var table = OracleCache.GetTableEntity <T>();

            return(CommonUtil.CreateUpdateByWhereSql(table, where, updateFields, "\"", "\"", ":"));
        }
Esempio n. 14
0
 public string GetInsertSql <T>()
 {
     return(OracleCache.GetTableEntity <T>().InsertSql);
 }
Esempio n. 15
0
        public string GetTotalSql <T>(string where)
        {
            var table = OracleCache.GetTableEntity <T>();

            return(string.Format("SELECT COUNT(1) FROM \"{0}\" {1}", table.TableName, where));
        }
Esempio n. 16
0
 public string GetDeleteAllSql <T>()
 {
     return(OracleCache.GetTableEntity <T>().DeleteAllSql);
 }