Ejemplo n.º 1
0
        public override void FormatGrid()
        {
            try
            {
                if (Memory.IsDesignMode)
                {
                    return;
                }

                base.FormatGrid();

                GridEXColumn col = null;
                col                = new GridEXColumn(MergeData.MaGiaoDanMoi, Janus.Windows.GridEX.ColumnType.Text);
                col.Width          = 60;
                col.BoundMode      = ColumnBoundMode.Bound;
                col.DataMember     = MergeData.MaGiaoDanMoi;
                col.Caption        = "Mã giáo dân mới";
                col.FilterEditType = FilterEditType.Combo;
                this.RootTable.Columns.Insert(0, col);

                col                = new GridEXColumn(MergeData.KetQua, Janus.Windows.GridEX.ColumnType.Text);
                col.Width          = 200;
                col.BoundMode      = ColumnBoundMode.Bound;
                col.DataMember     = MergeData.KetQua;
                col.Caption        = "Kết quả";
                col.FilterEditType = FilterEditType.Combo;
                this.RootTable.Columns.Insert(0, col);

                SetGridColumnWidth();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Lỗi Exception (GxGiaoDanList, FormatGrid)", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
        private void UpdateGroup()
        {
            if (!Utility.isValidGrid(grdLuotkham))
            {
                return;
            }
            var counts = ((DataView)grdLuotkham.DataSource).Table.AsEnumerable()
                         .GroupBy(x => x.Field <string>("ma_doituong_kcb"))
                         .Select(g => new { g.Key, Count = g.Count() });

            if (counts.Count() >= 2)
            {
                if (grdLuotkham.RootTable.Groups.Count <= 0)
                {
                    GridEXColumn gridExColumn = grdList.RootTable.Columns["ma_doituong_kcb"];
                    var          gridExGroup  = new GridEXGroup(gridExColumn)
                    {
                        GroupPrefix = "Nhóm đối tượng KCB: "
                    };
                    grdLuotkham.RootTable.Groups.Add(gridExGroup);
                }
            }
            else
            {
                GridEXColumn gridExColumn = grdLuotkham.RootTable.Columns["ma_doituong_kcb"];
                var          gridExGroup  = new GridEXGroup(gridExColumn);
                grdLuotkham.RootTable.Groups.Clear();
            }
            grdLuotkham.UpdateData();
            grdLuotkham.Refresh();
        }
Ejemplo n.º 3
0
 void UpdateGroup()
 {
     try
     {
         if (m_dtReport == null || m_dtReport.Columns.Count <= 0)
         {
             return;
         }
         var counts = m_dtReport.AsEnumerable().GroupBy(x => x.Field <string>("tennhom"))
                      .Select(g => new { g.Key, Count = g.Count() });
         if (chkTheoNhomThuoc.Checked)
         {
             if (grdList.RootTable.Groups.Count <= 0)
             {
                 GridEXColumn gridExColumn = grdList.RootTable.Columns["tennhom"];
                 var          gridExGroup  = new GridEXGroup(gridExColumn);
                 grdList.RootTable.Groups.Add(gridExGroup);
             }
         }
         else
         {
             GridEXColumn gridExColumn = grdList.RootTable.Columns["tennhom"];
             var          gridExGroup  = new GridEXGroup(gridExColumn);
             grdList.RootTable.Groups.Clear();
         }
         grdList.UpdateData();
         grdList.Refresh();
     }
     catch
     {
     }
 }
Ejemplo n.º 4
0
 void UpdateGroup()
 {
     try
     {
         var counts = m_dtData.AsEnumerable().GroupBy(x => x.Field <string>("ten_loainhom"))
                      .Select(g => new { g.Key, Count = g.Count() });
         if (counts.Count() >= 2)
         {
             if (grdList.RootTable.Groups.Count <= 0)
             {
                 GridEXColumn gridExColumn = grdList.RootTable.Columns["ten_loainhom"];
                 var          gridExGroup  = new GridEXGroup(gridExColumn);
                 gridExGroup.GroupPrefix = "";
                 grdList.RootTable.Groups.Add(gridExGroup);
             }
         }
         else
         {
             GridEXColumn gridExColumn = grdList.RootTable.Columns["ten_loainhom"];
             var          gridExGroup  = new GridEXGroup(gridExColumn);
             grdList.RootTable.Groups.Clear();
         }
         grdList.UpdateData();
         grdList.Refresh();
     }
     catch
     {
     }
 }
 private void UpdateSumOfChiDinh()
 {
     GridEXColumn gridExColumn       = grdDetail.RootTable.Columns["TT"];
     GridEXColumn gridExColumnPhuThu = grdDetail.RootTable.Columns[KcbChidinhclsChitiet.Columns.PhuThu];
     decimal      Thanhtien          = Utility.DecimaltoDbnull(grdDetail.GetTotal(gridExColumn, AggregateFunction.Sum));
     decimal      phuthu             = Utility.DecimaltoDbnull(grdDetail.GetTotal(gridExColumnPhuThu, AggregateFunction.Sum));
 }
        private void btnExportExcel_Click(object sender, EventArgs e)
        {
            string pFromBarcode = dtpDatePrintFrom.Value.ToString("yyMMdd") + txtFromBarcode.Text.Trim().PadLeft(4, '0') +
                                  ".NB";
            string pToDate = dtpDatePrintFrom.Value.ToString("yyMMdd") + txtToBarcode.Text.Trim().PadLeft(4, '0') +
                             ".NB";
            int testTypeID = Utility.Int32Dbnull(Utility.GetPropertyValue(cboTestType, "SelectedValue"), -1);
            dtRawResult =
                SPs.GtvtBaoCaoLuuNoBarCode(Utility.sDbnull(pFromBarcode),
                                           Utility.sDbnull(pToDate),
                                           testTypeID).
                    GetDataSet().Tables[0];
            var dataTable = new DataTable();
            dataTable = lablinkhelper.Utilities.GetInversedDataTable(dtRawResult, "Para_Name", "Barcode", "Test_Result", "", false);
            if (dataTable.Rows.Count <= 0)
            {
                Utility.ShowMsg("Không tìm thấy kết quả !");
                return;
            }

            for (int i = 0; i < dataTable.Columns.Count; i++)
            {
                GridEXColumn grdCol = new GridEXColumn(dataTable.Columns[i].ColumnName);
                grdAllPatientInfoAndResult.RootTable.Columns.Add(grdCol);
                //grdAllPatientInfoAndResult.RootTable.Columns[grdCol.Key].AggregateFunction = AggregateFunction.Count;
            }
            // grdAllPatientInfoAndResult.RootTable.Columns["Patient_ID"].Visible = false;
            //SetPropertiesCol("Barcode", "Barcode");
            // SetPropertiesCol("Test_Date", "Ngày Xét Nghiệm");
            // SetPropertiesCol("TestType_Name", "Loại XN");
            grdAllPatientInfoAndResult.DataSource = dataTable;
            grdAllPatientInfoAndResult.AutoSizeColumns();
            ExcelReport.ExportGridEx(grdAllPatientInfoAndResult);
        }
Ejemplo n.º 7
0
        /// <summary>
        /// tạo grid janus
        /// </summary>
        private void CreateGrid()
        {
            gridEX1.RootTable.Columns.Clear();
            GridEXColumn col1 = new GridEXColumn();

            col1.DataMember    = "SoHieuXe";
            col1.Key           = "SoHieuXe";
            col1.Caption       = " Số hiệu xe";
            col1.TextAlignment = TextAlignment.Center;
            col1.Width         = 90;
            gridEX1.RootTable.Columns.Add(col1);

            for (int iGio = 0; iGio <= 23; iGio++)
            {
                GridEXColumn col = new GridEXColumn();
                col.DataMember    = "Gio_" + iGio.ToString();
                col.Key           = "Gio_" + iGio.ToString();
                col.Caption       = " " + iGio.ToString() + " h";
                col.TextAlignment = TextAlignment.Center;
                col.Width         = 50;
                GridEXFormatStyle headerStyle = new GridEXFormatStyle();
                headerStyle.TextAlignment = TextAlignment.Center;
                col.HeaderStyle           = headerStyle;
                gridEX1.RootTable.Columns.Add(col);
            }

            GridEXColumn col2 = new GridEXColumn();

            col2.DataMember    = "Tong";
            col2.Key           = "Tong";
            col2.Caption       = "  Tổng ";
            col2.TextAlignment = TextAlignment.Center;
            col2.Width         = 90;
            gridEX1.RootTable.Columns.Add(col2);
        }
Ejemplo n.º 8
0
        private void InitializeItemContextMenu()
        {
            RowContextMenu = new ContextMenuStrip();
            ToolStripMenuItem copyMenu        = (ToolStripMenuItem)RowContextMenu.Items.Add("Copy to clipboard");
            ToolStripMenuItem displayTextMenu = (ToolStripMenuItem)RowContextMenu.Items.Add("Display text...");

            for (int index = 0; index < RootTable.Columns.Count; index++)
            {
                GridEXColumn columnHeader = RootTable.Columns[index];

                ToolStripItem copyChildMenu = copyMenu.DropDownItems.Add(columnHeader.Caption);
                copyChildMenu.Click += new EventHandler(copyMenu_Click);
                copyChildMenu.Tag    = columnHeader;

                ToolStripItem displayTextChildMenu = displayTextMenu.DropDownItems.Add(columnHeader.Caption);
                displayTextChildMenu.Click += new EventHandler(displayTextMenu_Click);
                displayTextChildMenu.Tag    = columnHeader;
            }

            if (RootTable.Columns.Count > 1)
            {
                copyMenu.DropDownItems.Add("-");
                displayTextMenu.DropDownItems.Add("-");

                ToolStripItem copyFullRowMenu = copyMenu.DropDownItems.Add("Full row");
                copyFullRowMenu.Click += new EventHandler(copyMenu_Click);

                ToolStripItem displayTextFullRowMenu = displayTextMenu.DropDownItems.Add("Full row");
                displayTextFullRowMenu.Click += new EventHandler(displayTextMenu_Click);
            }
        }
Ejemplo n.º 9
0
        private void GetDataPresDetail()
        {
            int stock_id = -1;

            stock_id           = Utility.Int32Dbnull(id_khoXuat);
            m_dtDataPresDetail = SPs.DuocLaythongtinDonthuocLinhthuoc(Pres_ID, stock_id).GetDataSet().Tables[0];
            if (!m_dtDataPresDetail.Columns.Contains("CHON"))
            {
                m_dtDataPresDetail.Columns.Add("CHON", typeof(int));
            }
            foreach (DataRow dr in m_dtDataPresDetail.Rows)
            {
                dr["CHON"] = 0;
            }
            m_dtDataPresDetail.AcceptChanges();
            string _rowFilter = string.Format("Pres_ID={0}", Pres_ID);

            Utility.SetDataSourceForDataGridEx(grdPresDetail, m_dtDataPresDetail, false, true, "1=1",
                                               KcbDonthuocChitiet.Columns.ThuTuIn);
            GridEXColumn gridExColumn =
                grdPresDetail.RootTable.Columns[KcbDonthuocChitiet.Columns.ThuTuIn];
            var gridExSortKey = new GridEXSortKey(gridExColumn, SortOrder.Ascending);

            grdPresDetail.RootTable.SortKeys.Add(gridExSortKey);
            // grdPresDetail.DataSource = p_dtPresDetail.DefaultView;

            ///thực hiện việc thay đổi khi load thông tin của thành tiền
            UpdateDataWhenChanged();
            //ModifyCommnad();
        }
 void UpdateGroup()
 {
     try
     {
         var counts = m_dtPatient.AsEnumerable().GroupBy(x => x.Field <string>("ma_doituong_kcb"))
                      .Select(g => new { g.Key, Count = g.Count() });
         if (counts.Count() >= 2)
         {
             if (grdList.RootTable.Groups.Count <= 0)
             {
                 GridEXColumn gridExColumn = grdList.RootTable.Columns["ma_doituong_kcb"];
                 var          gridExGroup  = new GridEXGroup(gridExColumn);
                 gridExGroup.GroupPrefix = "Nhóm đối tượng KCB: ";
                 grdList.RootTable.Groups.Add(gridExGroup);
             }
         }
         else
         {
             GridEXColumn gridExColumn = grdList.RootTable.Columns["ma_doituong_kcb"];
             var          gridExGroup  = new GridEXGroup(gridExColumn);
             grdList.RootTable.Groups.Clear();
         }
         grdList.UpdateData();
         grdList.Refresh();
     }
     catch
     {
     }
 }
Ejemplo n.º 11
0
		public DialogResult ShowDialog(Janus.Windows.GridEX.GridEX grid, Form parent)
		{
			GridEXColumn column = null;
			int i = 0;
			this.lbAvail.DisplayMember = "Caption";
			this.lbVisible.DisplayMember = "Caption";

            for (i = 0; i < grid.RootTable.Columns.Count; i++)
			{
				column = grid.RootTable.Columns.GetColumnInPosition(i);
				if (column.ShowInFieldChooser)
				{
					if (column.Visible)
					{
						AddVisibleField(column, false);
					}
					else
					{
						AddAvailableField(column, false);
					}
				}
			}
			FillAvailableList();
			FillVisibleList();
			return this.ShowDialog(parent);
		}
Ejemplo n.º 12
0
        public override void FormatGrid()
        {
            if (Memory.IsDesignMode)
            {
                return;
            }

            if (this.RootTable == null)
            {
                this.RootTable = new GridEXTable();
            }
            base.FormatGrid();

            this.RootTable.Columns.Clear();
            this.ColumnAutoResize = false;
            //this.AllowEdit = InheritableBoolean.True;

            GridEXColumn col1 = this.RootTable.Columns.Add("MaLop", ColumnType.Text);

            col1.Width          = 50;
            col1.BoundMode      = ColumnBoundMode.Bound;
            col1.DataMember     = "MaLop";
            col1.Caption        = "Mã Lớp";
            col1.FilterEditType = FilterEditType.Combo;



            GridEXColumn col2 = this.RootTable.Columns.Add("TenLop", ColumnType.Text);

            col2.Width          = 200;
            col2.BoundMode      = ColumnBoundMode.Bound;
            col2.DataMember     = "TenLop";
            col2.Caption        = "Tên lớp";
            col2.FilterEditType = FilterEditType.Combo;

            //Khoan add start
            col2                = this.RootTable.Columns.Add("PhongHoc", ColumnType.Text);
            col2.Width          = 80;
            col2.BoundMode      = ColumnBoundMode.Bound;
            col2.DataMember     = "PhongHoc";
            col2.Caption        = "Phòng học";
            col2.FilterEditType = FilterEditType.Combo;
            //Khoan add end

            GridEXColumn col3 = this.RootTable.Columns.Add("GiaoLyVien", ColumnType.Text);

            col3.Width          = 250;
            col3.BoundMode      = ColumnBoundMode.Bound;
            col3.DataMember     = "GiaoLyVien";
            col3.Caption        = "Giáo lý viên";
            col3.FilterEditType = FilterEditType.Combo;

            GridEXColumn col4 = this.RootTable.Columns.Add("GhiChu", ColumnType.Text);

            col4.Width          = 200;
            col4.BoundMode      = ColumnBoundMode.Bound;
            col4.DataMember     = "GhiChu";
            col4.Caption        = "Ghi chú";
            col4.FilterEditType = FilterEditType.Combo;
        }
Ejemplo n.º 13
0
		private void CreateGridsTable()
		{
			this.grdColumnList.BoundMode = BoundMode.Unbound;
			this.grdColumnList.RootTable = new GridEXTable();

			GridEXColumn textColumn = new GridEXColumn();
			textColumn.Selectable = false;
			textColumn.DataMember = "Text";
			textColumn.Key = "Text";
			GridEXColumn valueColumn = new GridEXColumn();
			valueColumn.DataMember = "Value";
			valueColumn.Key = "Value";
			valueColumn.Visible = false;

			this.grdColumnList.RootTable.Columns.Add(textColumn);
			this.grdColumnList.RootTable.Columns.Add(valueColumn);

			this.grdCompositeColumns.BoundMode = BoundMode.Unbound;
			this.grdCompositeColumns.RootTable = new GridEXTable();

			textColumn = new GridEXColumn();
			textColumn.DataMember = "Text";
			textColumn.Key = "Text";
			textColumn.Selectable = false;
			valueColumn = new GridEXColumn();
			valueColumn.DataMember = "Value";
			valueColumn.Key = "Value";
			valueColumn.Visible = false;
			this.grdCompositeColumns.RootTable.Columns.Add(textColumn);
			this.grdCompositeColumns.RootTable.Columns.Add(valueColumn);

			this.grdColumnList.ColumnAutoResize = true;
			this.grdCompositeColumns.ColumnAutoResize = true;
		}
Ejemplo n.º 14
0
        private void ApplyFilters()
        {
            GridEXFilterCondition condition = new GridEXFilterCondition();
            GridEXColumn          column    = new GridEXColumn();

            gridExAgreementsListGrouped.RemoveFilters();

            if (rdbKTM.Checked)
            {
                column    = gridExAgreementsListGrouped.RootTable.Columns["KTM"];
                condition = new GridEXFilterCondition(column, ConditionOperator.Equal, gridExProductsAndArticles.CurrentRow.Cells["KTM"].Text);
            }
            else if (rdbDescriptor.Checked)
            {
                column    = gridExAgreementsListGrouped.RootTable.Columns["Deskryptor"];
                condition = new GridEXFilterCondition(column, ConditionOperator.Equal, gridExProductsAndArticles.CurrentRow.Cells["Deskryptor"].Text);
            }
            else if (rdbTitle.Checked)
            {
                column    = gridExAgreementsListGrouped.RootTable.Columns["Tytul"];
                condition = new GridEXFilterCondition(column, ConditionOperator.Equal, gridExProductsAndArticles.CurrentRow.Cells["Tytuł"].Text);
            }

            gridExAgreementsListGrouped.RootTable.ApplyFilter(condition);
        }
Ejemplo n.º 15
0
        public override void FormatGrid()
        {
            if (Memory.IsDesignMode)
            {
                return;
            }

            base.FormatGrid();

            GridEXColumn col = null;

            col                = new GridEXColumn(MergeData.MaGiaDinhMoi, Janus.Windows.GridEX.ColumnType.Text);
            col.Width          = 60;
            col.BoundMode      = ColumnBoundMode.Bound;
            col.DataMember     = MergeData.MaGiaDinhMoi;
            col.Caption        = "Mã gia đình mới";
            col.FilterEditType = FilterEditType.Combo;
            this.RootTable.Columns.Insert(0, col);

            col                = new GridEXColumn(MergeData.KetQua, Janus.Windows.GridEX.ColumnType.Text);
            col.Width          = 200;
            col.BoundMode      = ColumnBoundMode.Bound;
            col.DataMember     = MergeData.KetQua;
            col.Caption        = "Kết quả";
            col.FilterEditType = FilterEditType.Combo;
            this.RootTable.Columns.Insert(0, col);

            SetGridColumnWidth();
        }
Ejemplo n.º 16
0
 private void SetSortKey(GridEXColumn column, bool ascending, ComboBox combo, RadioButton optAscending, RadioButton optDescending)
 {
     if (column == null)
     {
         combo.SelectedIndex = 0;
     }
     else
     {
         foreach (object item in combo.Items)
         {
             object[] a = item as object[];
             if (a.Length == 2)
                 if (a[1] == column)//item._Value
                 {
                     combo.SelectedItem = item;
                     break;
                 }
         }
     }
     if (ascending)
     {
         optAscending.Checked = true;
     }
     else
     {
         optDescending.Checked = true;
     }
 }
Ejemplo n.º 17
0
        void cboHoadon_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (Utility.Int32Dbnull(cboHoadon.SelectedValue, -1) == 0)
            {
                grdList.RootTable.Groups.Clear();
                chkMaQuyen.Enabled = false;
                pnlQuyen.Enabled   = false;
            }
            else
            {
                chkMaQuyen.Enabled = true;
                chkMaQuyen_CheckedChanged(chkMaQuyen, e);
                grdList.RootTable.Groups.Clear();

                GridEXColumn gridExColumn = grdList.RootTable.Columns["mau_hoadon"];
                var          gridExGroup  = new GridEXGroup(gridExColumn);
                gridExGroup.GroupPrefix = "Mẫu hóa đơn: ";
                grdList.RootTable.Groups.Add(gridExGroup);

                gridExColumn            = grdList.RootTable.Columns["ma_quyen"];
                gridExGroup             = new GridEXGroup(gridExColumn);
                gridExGroup.GroupPrefix = "Mã quyển: ";
                grdList.RootTable.Groups.Add(gridExGroup);
            }
        }
        public void filterapply(GridEX grid, string filtername, CreateFilterForm hiddeninstanceinitialized)
        {
            foreach (string item in hiddeninstanceinitialized.comboBox7.Items)
            {
                if (item == filtername)
                {
                    hiddeninstanceinitialized.comboBox7.SelectedItem = filtername;
                    hiddeninstanceinitialized.comboBox7_SelectedIndexChanged(this, new EventArgs());

                    List <string> stacknames = new List <string>();
                    hiddeninstanceinitialized.processList(ref grid, false, 1, stacknames);
                }
            }
            foreach (string item in hiddeninstanceinitialized.comboBox1.Items)
            {
                if (item == filtername)
                {
                    hiddeninstanceinitialized.comboBox1.SelectedItem = filtername;
                    //hiddeninstanceinitialized.comboBox1_SelectedIndexChanged(this, new EventArgs());
                    GridEXColumn column = grid.RootTable.Columns[hiddeninstanceinitialized.comboBox5.SelectedValue.ToString()];


                    GridEXFilterCondition singlefiltercondtion = hiddenInstance.CreateSinglefilter(hiddenInstance.textBox6.Text, hiddenInstance.textBox7.Text, hiddenInstance.comboBox6.SelectedValue.ToString(), column);


                    grid.RootTable.FilterCondition = singlefiltercondtion;
                    grid.RootTable.ApplyFilter(singlefiltercondtion);
                    break;
                }
            }
            grid.Refetch();
            grid.Select();
        }
        private void SetGridSettings()
        {
            this.gridEX1.SetDataBinding(dataSet, "Contacts");
            this.gridEX1.RetrieveStructure();
            this.gridEX1.VisualStyle = VisualStyle.Office2003;

            //Create multiplevalues column

            //When using a many-to-manyn relation, the DataMember of the MultipleValues
            //column must be the name of the relation between the parent table and the
            //relation table.

            GridEXColumn col = new GridEXColumn();

            col.Key            = "Categories";
            col.MultipleValues = true;
            col.DataMember     = "Contacts_ContactCategories";
            col.EditType       = EditType.Combo;
            col.Caption        = "Categories";
            col.Width          = 200;
            //Since the column will be bound to a list containing DataRowView objects, we must specify which
            //field in the DataRowView will be used as value
            col.MultipleValueDataMember = "CategoryId";

            //Fill the ValueList with the categories table
            col.HasValueList = true;
            col.ValueList.PopulateValueList(dataSet.Tables["Categories"].DefaultView, "CategoryId", "CategoryName");
            col.DefaultGroupInterval = GroupInterval.Text;
            col.CompareTarget        = ColumnCompareTarget.Text;
            gridEX1.RootTable.Columns.Add(col);
        }
Ejemplo n.º 20
0
        public override void FormatGrid()
        {
            if (Memory.IsDesignMode)
            {
                return;
            }

            if (this.RootTable == null)
            {
                this.RootTable = new GridEXTable();
            }
            base.FormatGrid();

            this.RootTable.Columns.Clear();
            //GridEXColumn col1 = this.RootTable.Columns.Add(GiaoHoConst.MaGiaoHo, ColumnType.Text);
            //col1.Width = 80;
            //col1.BoundMode = ColumnBoundMode.Bound;
            //col1.DataMember = GiaoHoConst.MaGiaoHo;
            //col1.Caption = "Mã giáo họ";

            GridEXColumn col2 = this.RootTable.Columns.Add(GiaoHoConst.TenGiaoHo, ColumnType.Text);

            col2.Width          = 200;
            col2.BoundMode      = ColumnBoundMode.Bound;
            col2.DataMember     = GiaoHoConst.TenGiaoHo;
            col2.FilterEditType = FilterEditType.Combo;
            col2.Caption        = "Tên giáo họ";

            RootTable.RowHeight   = 20;
            this.ColumnHeaders    = InheritableBoolean.True;
            this.RowHeaderContent = RowHeaderContent.RowHeaderText;
            this.RowHeaders       = InheritableBoolean.True;
            this.FilterMode       = FilterMode.None;
        }
        private void CreateExceptionGrid(TableLayoutPanel panel)
        {
            ExceptionsGrid = new NuGenCustomDataGridView();
            ExceptionsGrid.GroupByBoxVisible = false;
            ExceptionsGrid.VisualStyle       = VisualStyle.Office2007;
            ExceptionsGrid.Dock      = DockStyle.Fill;
            ExceptionsGrid.RootTable = new GridEXTable();

            GridEXColumn skipColumn = new GridEXColumn();

            skipColumn.ColumnType = ColumnType.CheckBox;
            skipColumn.DataMember = "Skip";
            skipColumn.Caption    = "Skip";
            ExceptionsGrid.RootTable.Columns.Add(skipColumn);

            GridEXColumn assemblyPathColumn = new GridEXColumn();

            assemblyPathColumn.DataMember = "AssemblyPath";
            assemblyPathColumn.Caption    = "Assembly";
            ExceptionsGrid.RootTable.Columns.Add(assemblyPathColumn);

            GridEXColumn tokenColumn = new GridEXColumn();

            tokenColumn.DataMember = "ExceptionClassTokenString";
            tokenColumn.Caption    = "Exception Token";
            ExceptionsGrid.RootTable.Columns.Add(tokenColumn);

            GridEXColumn classNameColumn = new GridEXColumn();

            classNameColumn.DataMember = "ExceptionClassName";
            classNameColumn.Caption    = "Exception Class";
            ExceptionsGrid.RootTable.Columns.Add(classNameColumn);

            GridEXColumn methodTokenColumn = new GridEXColumn();

            methodTokenColumn.DataMember = "ThrowingMethodTokenString";
            ExceptionsGrid.RootTable.Columns.Add(methodTokenColumn);

            GridEXColumn methodNameColumn = new GridEXColumn();

            methodNameColumn.DataMember = "ThrowingMethodName";
            methodNameColumn.Caption    = "Method Name";
            ExceptionsGrid.RootTable.Columns.Add(methodNameColumn);

            GridEXColumn ipColumn = new GridEXColumn();

            ipColumn.DataMember = "IPAsString";
            ipColumn.Caption    = "IP";
            ExceptionsGrid.RootTable.Columns.Add(ipColumn);

            BindingSource bindingSource = new BindingSource(NuGenProject.Instance.Exceptions, string.Empty);

            ExceptionsGrid.DataSource = bindingSource;

            panel.Controls.Add(ExceptionsGrid);

            ExceptionsGrid.Initialize();
        }
Ejemplo n.º 22
0
        private bool GetConditionValues()
        {
            if (mActiveCondition != null)
            {
                if (this.cboFields.SelectedItem == null)
                {
                    MessageBox.Show("Select the field for the condition", MainQD.MessageCaption);
                    this.cboFields.Focus();
                    return false;
                }
                GridEXColumn column = ((ComboboxItem)this.cboFields.SelectedItem).Value;
                try
                {
                    object value1 = Convert.ChangeType(txtValue1.Text, column.Type);
                    mActiveCondition.Value1 = value1;
                }
                catch
                {
                    MessageBox.Show("Value 1 is not valid", MainQD.MessageCaption);
                    txtValue1.Focus();
                    txtValue1.SelectionStart = txtValue1.Text.Length;
                    return false;
                }

                if (mTwoValues)
                {

                    try
                    {
                        object value2 = Convert.ChangeType(txtValue2.Text, column.Type);
                        mActiveCondition.Value2 = value2;
                    }
                    catch
                    {
                        MessageBox.Show("Value 2 is not valid", MainQD.MessageCaption);
                        txtValue2.SelectionStart = 0;
                        return false;

                    }
                }
                else
                {

                    mActiveCondition.Value2 = null;
                }
                mActiveCondition.Key = txtConditionName.Text;
                mActiveCondition.Column = column;
                mActiveCondition.ConditionOperator = ((ComboboxConditionItem)this.cboCondition.SelectedItem).Value;
                mActiveCondition.FormatStyle.BackColor = this.btnBackColor.BackColor;
                mActiveCondition.FormatStyle.ForeColor = this.btnForeColor.BackColor;
                mActiveCondition.FormatStyle.FontBold = this.chkBold.Checked ? TriState.True : TriState.False;
                mActiveCondition.FormatStyle.FontItalic = this.chkItalic.Checked ? TriState.True : TriState.False;
                mActiveCondition.FormatStyle.FontUnderline = this.chkUnderline.Checked ? TriState.True : TriState.False;
                mActiveCondition.FormatStyle.FontStrikeout = this.chkStrikeout.Checked ? TriState.True : TriState.False;
            }
            return true;
        }
Ejemplo n.º 23
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="column"></param>
        /// <param name="text"></param>
        /// <param name="width"></param>
        public static void SetToButtonColumn(this GridEXColumn column, string text, int width)
        {
            column.Width     = width;
            column.AllowSize = false;

            column.ButtonDisplayMode = Janus.Windows.GridEX.CellButtonDisplayMode.Always;
            column.ButtonStyle       = Janus.Windows.GridEX.ButtonStyle.TextButton;
            column.ButtonText        = text;
        }
Ejemplo n.º 24
0
 private VillageFields GetVillageColumnType(GridEXColumn column)
 {
     VillageFields type;
     if (Enum.TryParse(column.Key, out type))
     {
         return type;
     }
     throw new Exception("Column should be in VillageFields enum!");
 }
Ejemplo n.º 25
0
 private GridEXSortKey CreateSortKey(GridEXColumn column, bool ascending)
 {
     GridEXSortKey sortKey = new GridEXSortKey();
     sortKey.Column = column;
     if (!ascending)
     {
         sortKey.SortOrder = Janus.Windows.GridEX.SortOrder.Descending;
     }
     return sortKey;
 }
Ejemplo n.º 26
0
        public static void GridFormatConditionSetting(GridEX jg, GridEXColumn gcName, object gcValue, ConditionOperator co)
        {
            GridEXFormatCondition fc = new GridEXFormatCondition();

            fc.Column                = gcName;
            fc.ConditionOperator     = co;
            fc.Value1                = gcValue;
            fc.FormatStyle.BackColor = Color.GreenYellow;
            jg.RootTable.FormatConditions.Add(fc);
        }
Ejemplo n.º 27
0
        private VillageFields GetVillageColumnType(GridEXColumn column)
        {
            VillageFields type;

            if (Enum.TryParse(column.Key, out type))
            {
                return(type);
            }
            throw new Exception("Column should be in VillageFields enum!");
        }
Ejemplo n.º 28
0
		private void btnDown_Click(object sender, System.EventArgs e)
		{
			GridEXColumn column = null;
			int selIndex = lbVisible.SelectedIndex;
			column = (GridEXColumn)(this.mVisibleFields[selIndex]);
			mVisibleFields.Remove(column);
			mVisibleFields.Insert(selIndex + 1, column);
			FillVisibleList();
			lbVisible.SelectedIndex = selIndex + 1;
		}
Ejemplo n.º 29
0
        private void InitializeGridColumns()
        {
            GridEXColumn newColumn = null;

            this.grdColumns.DataSource = grid.RootTable.Columns;
            this.grdColumns.RetrieveStructure();
            this.grdColumns.RootTable.Columns.Clear();
            newColumn          = this.grdColumns.RootTable.Columns.Add("Caption", ColumnType.Text);
            newColumn.EditType = EditType.NoEdit;
            newColumn          = this.grdColumns.RootTable.Columns.Add("Visible", ColumnType.CheckBox);
            newColumn.EditType = EditType.CheckBox;
        }
        private void button2_Click_1(object sender, EventArgs e)
        {
            //FilterLog.WriteToLog("Debug Level 1:applying filter (saved filters)");
            this.pushedonce = true;
            if (this.listBox1.Text == "")
            {
                return;
            }
            myFilter = "Επιλογη βάση φίλτρου:" + this.listBox1.Text;



            prefix = "";



            string simpleoscomposite = (this.listBox1.SelectedIndex > lastsimpleidx) ? "ΣΥΝΘΕΤΟ" : "ΑΠΛΟ";


            if (simpleoscomposite == "ΣΥΝΘΕΤΟ")
            {
                hiddenInstance.comboBox7.Text = this.listBox1.Text;

                //hiddenInstance.updatecombos();
                // Dictionary<string, double> overridepercssstoreit = new Dictionary<string, double>();


                hiddenInstance.comboBox7.SelectedItem = this.listBox1.SelectedItem;
                hiddenInstance.comboBox7_SelectedIndexChanged(this, new EventArgs());

                List <string> stacknames = new List <string>();
                hiddenInstance.processList(ref this.gridEX2, false, 1, stacknames);

                this.textBox1.Text = gridEX2.RowCount.ToString() + " εγγραφές";
            }
            if (simpleoscomposite == "ΑΠΛΟ")
            {
                hiddenInstance.comboBox1.SelectedItem = this.listBox1.SelectedItem;


                GridEXColumn column = this.gridEX2.RootTable.Columns[this.arrayofcolumns[hiddenInstance.comboBox5.SelectedIndex].ToString()];


                GridEXFilterCondition singlefiltercondtion = hiddenInstance.CreateSinglefilter(hiddenInstance.textBox6.Text, hiddenInstance.textBox7.Text, hiddenInstance.comboBox6.SelectedValue.ToString(), column);


                this.gridEX2.RootTable.FilterCondition = singlefiltercondtion;
                this.gridEX2.RootTable.ApplyFilter(singlefiltercondtion);
            }
            this.gridEX2.Refetch();
            this.gridEX2.Select();
            selectfiltered(this.gridEX2);
        }
Ejemplo n.º 31
0
        private void PreparePermissionsGrid()
        {
            GridEXColumn colLevel = gridExUserPermissions.RootTable.Columns["Poziom"];

            colLevel.HasValueList = true;

            GridEXValueListItemCollection valuesCboLevel = colLevel.ValueList;

            valuesCboLevel.Add(0, "Brak");
            valuesCboLevel.Add(1, "Tylko odczyt");
            valuesCboLevel.Add(2, "Pełne");
        }
Ejemplo n.º 32
0
		private void btnMoveDown_Click(object sender, System.EventArgs e)
		{

			int index = this.grdCompositeColumns.Row;
			GridEXColumn col = this.CompositeColumns[index];

			this.mCompositeColumns.RemoveAt(index);

			this.mCompositeColumns.Insert(index + 1, col);
			this.FillControls(false, true);
			this.grdCompositeColumns.MoveTo(index + 1);
		}
        private void cmdINPHIEU_Click(object sender, EventArgs e)
        {
            try
            {
                grdAllPatientInfoAndResult.RootTable.Columns.Clear();

                dtResult =
                    SPs.SpRptAllPatientInfoAndResultXayDung(dtpFromDate.Value.Date,
                                                        dtpToDate.Value.Date.AddDays(1).AddMilliseconds(-5),
                                                        Utility.Int32Dbnull(cboTestType.SelectedValue),
                                                        Utility.Int16Dbnull(cboObjectType.SelectedValue),
                                                        Utility.Int16Dbnull(cboDepartment.SelectedValue),
                                                        Utility.sDbnull(cboAddress.Text),
                                                        Utility.Int16Dbnull(cboDevices.SelectedValue)).
                        GetDataSet().Tables[0];

                if (dtResult.Rows.Count <= 0 | dtResult.Columns.Count <= 1)
                {
                    Utility.ShowMsg("Không tìm thấy kết quả !");
                    return;
                }

                for (int i = 0; i < dtResult.Columns.Count; i++)
                {
                    GridEXColumn grdCol = new GridEXColumn(dtResult.Columns[i].ColumnName);
                    grdAllPatientInfoAndResult.RootTable.Columns.Add(grdCol);
                    grdAllPatientInfoAndResult.RootTable.Columns[grdCol.Key].AggregateFunction = AggregateFunction.ValueCount;
                }
                grdAllPatientInfoAndResult.RootTable.Columns["Patient_ID"].Visible = false;

                SetPropertiesCol("Barcode", "Barcode");
                SetPropertiesCol("Patient_Name", "Tên BN");
                SetPropertiesCol("SexName", "Giới Tính");
                SetPropertiesCol("Year_Birth", "Năm Sinh");
                SetPropertiesCol("PID", "PID");
                SetPropertiesCol("Address", "Địa Chỉ");
                SetPropertiesCol("Year_Birth", "Năm sinh");
                SetPropertiesCol("Insurance_Num", "Số thẻ BHYT");
                SetPropertiesCol("Baroce", "Barcode");
                SetPropertiesCol("ObjectType_Name", "Đối tượng");
                SetPropertiesCol("Department_Name", "Khoa");
                SetPropertiesCol("Age", "Tuổi");

                grdAllPatientInfoAndResult.DataSource = dtResult;
                grdAllPatientInfoAndResult.AutoSizeColumns();

            }
            catch (Exception ex)
            {
                Utility.ShowMsg(ex.Message);
            }
        }
		private void CreateExceptionGrid(TableLayoutPanel panel)
		{
			ExceptionsGrid = new NuGenCustomDataGridView();
            ExceptionsGrid.GroupByBoxVisible = false;
            ExceptionsGrid.VisualStyle = VisualStyle.Office2007;
			ExceptionsGrid.Dock = DockStyle.Fill;
            ExceptionsGrid.RootTable = new GridEXTable();

            GridEXColumn skipColumn = new GridEXColumn();
            skipColumn.ColumnType = ColumnType.CheckBox;
			skipColumn.DataMember = "Skip";
			skipColumn.Caption = "Skip";
			ExceptionsGrid.RootTable.Columns.Add(skipColumn);

            GridEXColumn assemblyPathColumn = new GridEXColumn();
            assemblyPathColumn.DataMember = "AssemblyPath";
			assemblyPathColumn.Caption = "Assembly";			
			ExceptionsGrid.RootTable.Columns.Add(assemblyPathColumn);

            GridEXColumn tokenColumn = new GridEXColumn();
            tokenColumn.DataMember = "ExceptionClassTokenString";
			tokenColumn.Caption = "Exception Token";			
			ExceptionsGrid.RootTable.Columns.Add(tokenColumn);

            GridEXColumn classNameColumn = new GridEXColumn();
			classNameColumn.DataMember = "ExceptionClassName";
			classNameColumn.Caption = "Exception Class";			
			ExceptionsGrid.RootTable.Columns.Add(classNameColumn);

			GridEXColumn methodTokenColumn = new GridEXColumn();
			methodTokenColumn.DataMember = "ThrowingMethodTokenString";
			ExceptionsGrid.RootTable.Columns.Add(methodTokenColumn);

			GridEXColumn methodNameColumn = new GridEXColumn();
			methodNameColumn.DataMember = "ThrowingMethodName";
			methodNameColumn.Caption = "Method Name";
			ExceptionsGrid.RootTable.Columns.Add(methodNameColumn);

			GridEXColumn ipColumn = new GridEXColumn();
			ipColumn.DataMember = "IPAsString";
			ipColumn.Caption = "IP";
			ExceptionsGrid.RootTable.Columns.Add(ipColumn);

			BindingSource bindingSource = new BindingSource(NuGenProject.Instance.Exceptions, string.Empty);
			ExceptionsGrid.DataSource = bindingSource;

			panel.Controls.Add(ExceptionsGrid);

			ExceptionsGrid.Initialize();
		}
        private void cmdExportExcel_Click(object sender, EventArgs e)
        {
            var ds =
                        SPs.SpBaoCaoXoaKetQua(dtpFromDate.Value.ToString("yyyy/MM/dd"),
                                              dtpToDate.Value.ToString("yyyy/MM/dd"),
                                              Utility.Int32Dbnull(cboTestType.SelectedValue, -1),
                                              Utility.sDbnull(cboUserName.SelectedValue, "")).GetDataSet();
            var dataTable = new DataTable();
            //Tổng hợp
            if (cboReportType.SelectedIndex == 1)
            {
                dt = ds.Tables[0];
                //dataTable = Utilities.GetInversedDataTable(dt, "Para_Name", "Barcode", "Test_Result", "", false);
            }
            //Chi tiết
            else
            {
                dt = ds.Tables[1];
                dataTable = Utilities.GetInversedDataTable(dt, "TestType_Name", "Barcode", "Delete_Date", "", false);
            }

            if (dataTable.Rows.Count <= 0)
            {
                Utility.ShowMsg("Không có dữ liệu để báo cáo");
                return;
            }

            for (int i = 0; i < dataTable.Columns.Count; i++)
            {
                GridEXColumn grdCol = new GridEXColumn(dataTable.Columns[i].ColumnName);
                grdAllPatientInfoAndResult.RootTable.Columns.Add(grdCol);
                //grdAllPatientInfoAndResult.RootTable.Columns[grdCol.Key].AggregateFunction = AggregateFunction.Count;
            }
            // grdAllPatientInfoAndResult.RootTable.Columns["Patient_ID"].Visible = false;
            //SetPropertiesCol("Barcode", "Barcode");
            // SetPropertiesCol("Test_Date", "Ngày Xét Nghiệm");
            // SetPropertiesCol("TestType_Name", "Loại XN");
            grdAllPatientInfoAndResult.DataSource = dataTable;
            grdAllPatientInfoAndResult.AutoSizeColumns();
            ExcelReport.ExportGridEx(grdAllPatientInfoAndResult);
        }
        private void SetGridSettings()
        {
            this.gridEX1.SetDataBinding(dataSet, "Contacts");
            this.gridEX1.RetrieveStructure();
            this.gridEX1.VisualStyle = VisualStyle.Office2003;

            //Create multiplevalues column

            //When using a many-to-manyn relation, the DataMember of the MultipleValues
            //column must be the name of the relation between the parent table and the
            //relation table.

            GridEXColumn col = new GridEXColumn();
            col.Key = "Categories";
            col.MultipleValues = true;
            col.DataMember = "Contacts_ContactCategories";
            col.EditType = EditType.Combo;
            col.Caption = "Categories";
            col.Width = 200;
            //Since the column will be bound to a list containing DataRowView objects, we must specify which
            //field in the DataRowView will be used as value
            col.MultipleValueDataMember = "CategoryId";

            //Fill the ValueList with the categories table
            col.HasValueList = true;
            col.ValueList.PopulateValueList(dataSet.Tables["Categories"].DefaultView, "CategoryId", "CategoryName");
            col.DefaultGroupInterval = GroupInterval.Text;
            col.CompareTarget = ColumnCompareTarget.Text;
            gridEX1.RootTable.Columns.Add(col);
        }