Exemplo n.º 1
0
        static XElement GetSqlNode(SqlConfEntity conf)
        {
            var sqlNode = SqlCfgs[conf.area]
                          .Descendants("sqlarea").Where(e => e.Attribute("name").Value == conf.area)
                          .Descendants("sqlgroup").Where(e => e.Attribute("name").Value == conf.group)
                          .Descendants("sql").Where(e => e.Attribute("name").Value == conf.name)
                          .FirstOrDefault();

            return(sqlNode);
        }
Exemplo n.º 2
0
        public static string GetTxtSql(SqlConfEntity conf)
        {
            if (!conf.Check())
            {
                return(string.Empty);
            }

            var sqlNode = GetSqlNode(conf);

            if (sqlNode == null)
            {
                return(string.Empty);
            }

            return(sqlNode.Value.Replace("\r\n", " ").Replace("\n", " ").Replace("\t", " ").Trim());
        }
Exemplo n.º 3
0
        public static PageQuerySqlEntity GetPageQuerySql(SqlConfEntity conf)
        {
            PageQuerySqlEntity entity = null;

            if (!conf.Check())
            {
                return(entity);
            }
            var sqlNode = GetSqlNode(conf);

            if (sqlNode == null)
            {
                return(entity);
            }
            entity = new PageQuerySqlEntity
            {
                sp_name = sqlNode.Attribute("sp_name").Value,
                fields  = sqlNode.Attribute("fields").Value,
                tables  = sqlNode.Attribute("tables").Value,
                where   = new StringBuilder(sqlNode.Attribute("where").Value),
                order   = new StringBuilder(sqlNode.Attribute("order").Value),
            };
            return(entity);
        }