示例#1
0
        public static string GetChildTableData(MDModel_QueryModel model, MDModel_Table childTable, string MainKey, SinoRequestUser RequestUser)
        {
            StringBuilder _sql = new StringBuilder();

            _sql.Append("select ");
            _sql.Append(childTable.TableName);
            _sql.Append(".");
            _sql.Append(childTable.MainKey);
            _sql.Append(" MAINKEY");
            foreach (MDModel_Table_Column _tc in childTable.Columns)
            {
                if (_tc.CanDisplay && _tc.CanResultShow)
                {
                    _sql.Append(",");
                    _sql.Append(OraResultItemBuilder.BuildItem(_tc, RequestUser));
                }
            }
            _sql.Append(" from ");
            _sql.Append(string.Format(" {0},{1} ", model.MainTable.TableName, childTable.TableName));
            _sql.Append(" where ");
            _sql.Append(string.Format(" {0}.{1} ", model.MainTable.TableName, model.MainTable.MainKey));
            _sql.Append(" = '");
            _sql.Append(MainKey);
            _sql.Append("'  and ");
            _sql.Append(childTable.TableRelation);
            _sql.Append(string.Format("  order by {0}.{1} ", childTable.TableName, childTable.MainKey));
            return(_sql.ToString());
        }
示例#2
0
        private static string CreateDisplayString(MDModel_QueryModel _qv, MDQuery_ResultTable _ResultTable, SinoRequestUser RequestUser)
        {
            StringBuilder _sql = new StringBuilder();

            _sql.Append(string.Format("{0}.{1} MAINID", _qv.MainTable.TableName, _qv.MainTable.MainKey));
            foreach (MDQuery_TableColumn _rc in _ResultTable.Columns)
            {
                _sql.Append(OraResultItemBuilder.BuildItem(_rc, _qv, RequestUser));
            }
            return(_sql.ToString());
        }
示例#3
0
        public static string GetMainTableData(MDModel_Table maintable, string mainKey, SinoRequestUser requestUser)
        {
            StringBuilder sql = new StringBuilder();

            sql.Append("select ");
            sql.Append(maintable.MainKey);
            sql.Append(" MAINKEY");
            foreach (MDModel_Table_Column _tc in maintable.Columns)
            {
                if (_tc.CanDisplay && _tc.CanResultShow)
                {
                    sql.Append(",");
                    sql.Append(OraResultItemBuilder.BuildItem(_tc, requestUser));
                }
            }
            sql.Append(" from ");
            sql.Append(maintable.TableName);
            sql.Append(" where ");
            sql.Append(maintable.MainKey);
            sql.Append(" = '");
            sql.Append(mainKey);
            sql.Append("' ");
            return(sql.ToString());
        }