コード例 #1
0
ファイル: ReportDesignUI.cs プロジェクト: scaperow/-V2.0
        void SubMenuItem_Click(object sender, EventArgs e)
        {
            Object            value    = null;
            ToolStripMenuItem MenuItem = sender as ToolStripMenuItem;

            if (MenuItem != null)
            {
                switch (MenuItem.Text)
                {
                case "数据列":
                    value = new ReportCommon.DataColumn();
                    break;

                case "普通文本":
                    value = new LiteralText();
                    break;

                case "公式":
                    value = new Formula();
                    break;

                case "图表":
                    value = new ChartPainter();
                    break;

                case "图片":
                    value = new ReportCommon.Picture();
                    break;

                case "斜线":
                    value = new Slash();
                    break;

                case "变量":
                    value = new Variable();
                    break;
                }

                if (value != null)
                {
                    ActiveSheet.ActiveCell.CellType = general;

                    ReportElementEventArgs elementevent = new ReportElementEventArgs();
                    elementevent.Value = value;
                    OnReportElementAdding(elementevent);
                }
                else
                {
                    String msg = "当前版本不支持" + MenuItem.Text + "报表元素。";
                    MessageBox.Show(msg, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
            }
        }
コード例 #2
0
ファイル: DataSourceManager.cs プロジェクト: scaperow/-V2.0
        private DataTable GetFilterTable(BE_Extend paramBE_Extend, DataTable paramDataTable, GridElement Element, Boolean IsLeftParent)
        {
            if (paramBE_Extend == null)
            {
                return(new DataTable());
            }
            else
            {
                List <DataTable> ParentDataTable               = new List <DataTable>();
                List <DataTable> SubDataTable                  = new List <DataTable>();
                List <String>    ParentPrimaryColumns          = new List <string>();
                List <String>    ChildPrimaryColumns           = new List <string>();
                Dictionary <String, List <String> > RowFilters = new Dictionary <string, List <string> >();

                ReportCommon.DataColumn DataColumn = Element.Value as ReportCommon.DataColumn;

                GridElement             ChildElement = Element;
                ReportCommon.DataColumn ChildColumn  = ChildElement.Value as ReportCommon.DataColumn;
                PE paramPE = paramBE_Extend;

                while (paramPE != null)
                {
                    GridElement             ParentElement = null;
                    ReportCommon.DataColumn ParentColumn  = null;
                    if (paramPE is BE_Extend)
                    {
                        BE_Extend temp = paramPE as BE_Extend;
                        ParentElement = temp.beb.ce_from as GridElement;
                        ParentColumn  = ParentElement.Value as ReportCommon.DataColumn;
                    }
                    else if (paramPE is CE_Extend)
                    {
                        CE_Extend temp = paramPE as CE_Extend;
                        ParentElement = temp.be_from.beb.ce_from as GridElement;
                        ParentColumn  = ParentElement.Value as ReportCommon.DataColumn;
                    }

                    if (ParentElement == null || ParentColumn == null)
                    {
                        break;
                    }

                    if (IsLeftParent)
                    {
                        if (Element.ExpandOrientation.Orientation == ExpandOrientation.TopToBottom &&
                            ParentElement.ExpandOrientation.Orientation == ExpandOrientation.LeftToRight)
                        {
                            break;
                        }
                    }
                    else
                    {
                        if (Element.ExpandOrientation.Orientation == ExpandOrientation.LeftToRight &&
                            ParentElement.ExpandOrientation.Orientation == ExpandOrientation.TopToBottom)
                        {
                            break;
                        }
                    }

                    if (!RowFilters.ContainsKey(ParentColumn.TableName.ToLower()))
                    {
                        RowFilters.Add(ParentColumn.TableName.ToLower(), new List <String>());
                    }

                    DataTable ds = (ParentColumn.TableName.ToLower() == paramDataTable.TableName.ToLower() ? paramDataTable : dataSources[ParentColumn.TableName.ToLower()]);
                    ParentDataTable.Add(ds);

                    String strFilter = "";
                    if (paramPE is CE_Extend)
                    {
                        CE_Extend temp = paramPE as CE_Extend;
                        strFilter = GetField_ValueString(ds, ParentColumn.FieldName, CompareOperation.等于, temp.obj);
                    }
                    RowFilters[ParentColumn.TableName.ToLower()].Add(strFilter);

                    DataTable subds = (ChildColumn.TableName.ToLower() == paramDataTable.TableName.ToLower() ? paramDataTable : dataSources[ChildColumn.TableName.ToLower()]);
                    SubDataTable.Add(subds);

                    List <FilterCondition> FilterConditions = ChildColumn.DataFilter.FilterConditions;
                    Boolean HaveRelation = true;
                    foreach (FilterCondition FilterCondition in FilterConditions)
                    {
                        String str;
                        Item   Item = FilterCondition.RightItem;
                        switch (Item.Style)
                        {
                        case FilterStyle.DataColumn:
                            ChildPrimaryColumns.Add(FilterCondition.LeftItem.FieldName);
                            ParentPrimaryColumns.Add(FilterCondition.RightItem.FieldName);
                            break;

                        case FilterStyle.Value:
                            str = GetField_ValueString(subds, FilterCondition.LeftItem.FieldName, FilterCondition.CompareOperation, Item.Value);
                            RowFilters[ChildColumn.TableName.ToLower()].Add(str);
                            break;

                        case FilterStyle.Parameter:
                            ReportParameter param = parameterList[Item.ParameterName] as ReportParameter;
                            str = GetField_ValueString(subds, FilterCondition.LeftItem.FieldName, FilterCondition.CompareOperation, param.Value);
                            RowFilters[ChildColumn.TableName.ToLower()].Add(str);
                            break;
                        }

                        HaveRelation = HaveRelation && Item.Style == FilterStyle.DataColumn;
                    }

                    if (!HaveRelation || ChildColumn.DataFilter.FilterConditions.Count == 0)
                    {
                        ChildPrimaryColumns.Add("");
                        ParentPrimaryColumns.Add("");
                    }

                    ChildElement = ParentElement;
                    ChildColumn  = ChildElement.Value as ReportCommon.DataColumn;

                    if (paramPE is BE_Extend)
                    {
                        BE_Extend temp = paramPE as BE_Extend;
                        paramPE = (IsLeftParent ? temp.left : temp.up);
                    }
                    else if (paramPE is CE_Extend)
                    {
                        CE_Extend temp = paramPE as CE_Extend;
                        paramPE = (IsLeftParent ? temp.be_from.left : temp.be_from.up);
                    }
                }

                if (ParentDataTable.Count > 0)
                {
                    DataTable TemTable = ParentDataTable[ParentDataTable.Count - 1];
                    for (int i = ParentDataTable.Count - 1; i >= 0; i--)
                    {
                        List <String> Filters = RowFilters[TemTable.TableName.ToLower()];
                        List <String> temp    = new List <string>();
                        foreach (String str in Filters)
                        {
                            if (str != "")
                            {
                                temp.Add(str);
                            }
                        }
                        String strFilters = "";
                        if (temp.Count > 0)
                        {
                            strFilters = string.Join(" and ", temp.ToArray());
                        }

                        TemTable = GetRelationTable(TemTable, SubDataTable[i], ParentPrimaryColumns[i], ChildPrimaryColumns[i], strFilters);
                    }

                    DataTable Result = TemTable.DefaultView.ToTable();
                    return(Result);
                }
                else
                {
                    DataTable Result = dataSources[DataColumn.TableName.ToLower()].DefaultView.ToTable();
                    return(Result);
                }
            }
        }