Beispiel #1
0
        public override object GetModel(string moduleId, NameValueCollection args)
        {
            if (moduleId == null)
            {
                return(null);
            }
            int            si      = moduleId.IndexOf(":");
            string         libId   = moduleId.Substring(4, si - 4);
            DataAccessType type    = ModuleManager.GetDBType(libId);
            string         connStr = ModuleManager.GetDBConn(libId);

            if (connStr == null)
            {
                return(null);
            }
            string           sqlstr = HandleArgs(moduleId.Substring(si + 1), args);
            StatisticControl ctrl   = new StatisticControl();

            ctrl.DataAccessType   = type;
            ctrl.ConnectionString = connStr;
            ctrl.SQL = sqlstr;
            ctrl.UploadFileVirtualPath = ModuleManager.UploadFileVirtualPath;
            DynamicTable dt = ctrl.GetWebDynamicTable();

            HandleArgs(dt, args);
            dt = ctrl.GetWebDynamicTable();
            HandleArgs(dt, args);
            return(ctrl);
        }
Beispiel #2
0
        protected override void Handle()
        {
            dynamicTable = StatisticControl.GetWebDynamicTable();
            StatisticControl.OnStatTableUseDynamicTable(dynamicTable);
            DataTable data     = StatisticControl.Data;
            DataView  dataView = new DataView(data);

            string[] sorts = StatisticControl.Sorts;
            if (sorts != null)
            {
                dataView.Sort = string.Join(",", sorts);
            }
            string[] groups   = StatisticControl.Groups;
            int      groupNum = 0;

            if (groups != null)
            {
                groupNum = groups.Length;
            }
            StringCollection sc = new StringCollection();

            foreach (DataColumn dc in dataView.Table.Columns)
            {
                sc.Add(dc.ColumnName);
            }
            table = StatisticControl.GetStatTable();
            StatisticRow statRow = null, lastRow = null;

            if (statRow == null)
            {
                statRow = StatisticRow.CreateTotalRow(table, groupNum, dynamicTable, StatisticControl.MaxFieldWidth, StatisticControl.BaseColor, StatisticControl.DeltaColor);
                lastRow = statRow;
            }
            for (int i = 0; i < groupNum; i++)
            {
                string field = groups[i];
                sc.Remove(field);
                lastRow = lastRow.CreateSubGroup(dataView.Table.Columns.IndexOf(field));
            }
            foreach (string field in sc)
            {
                DataColumn dc = dataView.Table.Columns[field];
                lastRow = statRow;
                while (lastRow != null)
                {
                    lastRow.AddField(dc, StatisticControl.GetStatisticFieldType(field));
                    lastRow = lastRow.SubGroup;
                }
            }
            statRow.DisplayHead(statRow, dataView);
            for (int ii = 0; ii < dataView.Count; ii++)
            {
                DataRowView drv = dataView[ii];
                statRow.ExecStatistic(drv, false);
                if (ii == dataView.Count - 1)
                {
                    statRow.ExecStatistic(drv, true);                   //结束统计
                }
            }

            Table t = new Table();

            t.Width = Unit.Percentage(100.0);
            TableRow  tr = new TableRow();
            TableCell tc = new TableCell();

            tr.Cells.Add(tc);
            t.Rows.Add(tr);

            if ((StatisticControl.DisplayButtons & DisplayButtons.EXPORT) == DisplayButtons.EXPORT)
            {
                ImageButton exportBtn = new ImageButton();
                exportBtn.ID          = "ExportBtn";
                exportBtn.ImageUrl    = ControlStateUrl.BuildResourceRequestUrl(StatisticControl.ExportIcon);
                exportBtn.ToolTip     = StatisticControl.ExportToolTip;
                exportBtn.CommandName = "Export";
                exportBtn.Click      += new ImageClickEventHandler(this.ButtonClick);

                tc.Controls.Add(exportBtn);
            }
            if ((StatisticControl.DisplayButtons & DisplayButtons.SEARCH) == DisplayButtons.SEARCH)
            {
                ImageButton searchBtn = new ImageButton();
                searchBtn.ID          = "SearchBtn";
                searchBtn.ImageUrl    = ControlStateUrl.BuildResourceRequestUrl(StatisticControl.SearchIcon);
                searchBtn.ToolTip     = "搜索数据";
                searchBtn.CommandName = "Search";
                searchBtn.Click      += new ImageClickEventHandler(this.ButtonClick);

                tc.Controls.Add(searchBtn);
            }
            tc.HorizontalAlign = HorizontalAlign.Right;

            tr = new TableRow();
            tc = new TableCell();
            tr.Cells.Add(tc);
            t.Rows.Add(tr);
            tc.Controls.Add(table);

            StatisticControl.Controls.Add(t);
            StatisticControl.OnShowStatTable(t, table);

            StatisticControl.Page.RegisterClientScriptBlock("InfoServiceCss", "<LINK href='" + StatisticControl.CssUrl + "' type='text/css' rel='stylesheet'>");
            StatisticControl.Page.RegisterClientScriptBlock("ShowControlClientScript", @"
		<script language='javascript'>
			<!--
			function openHtml(obj)
			{
				var pobj=obj.parentElement;
				if(pobj)
				{
					try
					{
						var w=window.open('about:blank','HTMLVIEW','resizable=yes,scrollbars=yes');
						w.document.write(pobj.dreamanHtml);
					}
					catch(eee)
					{
						alert('您的浏览器好象禁止了弹出窗口,无法查看HTML内容!');
					}
					event.returnValue=false;
				}
			}
			-->
		</script>
				"
                                                            );
        }
Beispiel #3
0
        protected override void Handle()
        {
            Table     t  = new Table();
            TableRow  tr = new TableRow();
            TableCell tc = new TableCell();

            tr.Cells.Add(tc);
            t.Rows.Add(tr);

            dynaTable               = StatisticControl.GetWebDynamicTable();
            dynaTable.CssUrl        = ControlStateUrl.BuildResourceRequestUrl(StatisticControl.CssUrl);
            dynaTable.ScriptUrl     = ControlStateUrl.BuildResourceRequestUrl(StatisticControl.ScriptUrl);
            dynaTable.MaxFieldWidth = StatisticControl.MaxFieldWidth;
            dynaTable.UseGroups     = true;
            if (StatisticControl.Groups != null && StatisticControl.Groups.Length > 0)
            {
                foreach (string g in StatisticControl.Groups)
                {
                    dynaTable.SetFieldGroup(g, true);
                }
            }
            if (StatisticControl.Sorts != null && StatisticControl.Sorts.Length > 0)
            {
                for (int i = 1; i <= StatisticControl.Sorts.Length; i++)
                {
                    int    sort  = i;
                    string field = StatisticControl.Sorts[i - 1].Trim();
                    if (field.ToUpper().EndsWith("DESC"))
                    {
                        sort  = -sort;
                        field = field.Substring(0, field.Length - 4).Trim();
                    }
                    dynaTable.SetFieldSort(field, sort);
                }
            }
            foreach (string s in dynaTable.KeyFields)
            {
                dynaTable[s].StatMethod = StatisticControl.GetStatisticFieldType(s);
            }
            foreach (string s in dynaTable.NormalFields)
            {
                dynaTable[s].StatMethod = StatisticControl.GetStatisticFieldType(s);
            }
            dynaTable.UI = WebDynamicTableUI.QUERY;
            StatisticControl.OnShowSearch(dynaTable);
            LiteralControl lc = new LiteralControl(dynaTable.GenerateHtml());

            dynaTable.RegisterCss(StatisticControl.Page);
            dynaTable.RegisterScript(StatisticControl.Page);

            tc.Controls.Add(lc);

            tr = new TableRow();
            tc = new TableCell();
            tr.Cells.Add(tc);
            t.Rows.Add(tr);

            ImageButton okBtn = new ImageButton();

            okBtn.ID          = "OK";
            okBtn.ImageUrl    = ControlStateUrl.BuildResourceRequestUrl(StatisticControl.SearchIcon);
            okBtn.ToolTip     = "开始搜索符合条件的数据";
            okBtn.CommandName = "Ok";
            okBtn.Click      += new ImageClickEventHandler(this.ButtonClick);

            tc.Controls.Add(okBtn);

            ImageButton returnBtn = new ImageButton();

            returnBtn.ID          = "Return";
            returnBtn.ImageUrl    = ControlStateUrl.BuildResourceRequestUrl(StatisticControl.ReturnIcon);
            returnBtn.ToolTip     = "返回数据表";
            returnBtn.CommandName = "Return";
            returnBtn.Click      += new ImageClickEventHandler(this.ButtonClick);

            tc.Controls.Add(returnBtn);
            tc.HorizontalAlign = HorizontalAlign.Center;

            StatisticControl.Controls.Add(t);
        }