コード例 #1
1
        /// <summary>
        /// SuperGridActionList
        /// </summary>
        /// <param name="superGrid">Associated SuperGridControl</param>
        public SuperGridActionList(SuperGridControl superGrid)
            : base(superGrid)
        {
            _SuperGrid = superGrid;

            _ChangeService = Component.Site.GetService(typeof(IComponentChangeService)) as IComponentChangeService;
        }
コード例 #2
1
        /// <summary>
        /// Initializes our designer
        /// </summary>
        /// <param name="component"></param>
        public override void Initialize(IComponent component)
        {
            base.Initialize(component);

            if (component.Site.DesignMode == true)
                _SuperGrid = component as SuperGridControl;
				
#if !TRIAL
            IDesignerHost dh = this.GetService(typeof(IDesignerHost)) as IDesignerHost;
            if (dh != null)
                dh.LoadComplete += new EventHandler(DesignerLoadComplete);
#endif
        }
コード例 #3
0
 private void TotalRow(DevComponents.DotNetBar.SuperGrid.SuperGridControl gridview)
 {
     /* GridRow gr = new GridRow();
      * GridCell gc = new GridCell("合计");
      * gr.Cells.Add(gc);
      * for (int i = 0; i < 16; i++)
      * {,
      *   GridCell gc1 = new GridCell();
      *   gr.Cells.Add(gc1);
      * }
      * gr.Cells[7].Value = zysl;
      * gr.Cells[8].Value = pssl;
      * supergrid.PrimaryGrid.Rows.Add(gr);
      */
 }
コード例 #4
0
ファイル: SampleExpr.cs プロジェクト: huamanhtuyen/VNACCS
        ///<summary>
        /// SampleExpr
        ///</summary>
        public SampleExpr(SuperGridControl superGrid)
        {
            InitializeComponent();

            btnClose.Text = superGrid.FilterCloseString;

            string s = GetRtbText(superGrid);

            try
            {
                richTextBoxEx1.Rtf = s;
            }
            catch
            {
                richTextBoxEx1.Text = s;
            }
        }
コード例 #5
0
ファイル: Dblink.cs プロジェクト: Alencc2015/Myc-
        internal Boolean ShowDgvInfo(DevComponents.DotNetBar.SuperGrid.SuperGridControl gridView, bool isShowExcle)
        {
            if (gridView.PrimaryGrid.Rows.Count == 0)
            {
                return(false);
            }
            //建立Excel对象

            Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();
            excel.Application.Workbooks.Add(true);
            excel.Visible = isShowExcle;
            //生成字段名称
            for (int i = 0; i < gridView.PrimaryGrid.Columns.Count; i++)
            {
                excel.Cells[1, i + 1] = gridView.PrimaryGrid.Columns[i].HeaderText;
            }
            //填充数据
            try
            {
                GridRow gr = null;
                for (int i = 0; i < gridView.PrimaryGrid.Rows.Count; i++)
                {
                    //dr = gridView.PrimaryGrid.Rows[i];
                    gr = (GridRow)gridView.PrimaryGrid.Rows[i];
                    for (int j = 0; j < gridView.PrimaryGrid.Columns.Count; j++)
                    {
                        if (gr[j].GetType() == typeof(string))
                        {
                            excel.Cells[i + 2, j + 1] = "'" + gr[j].Value.ToString();
                        }
                        else
                        {
                            excel.Cells[i + 2, j + 1] = gr[j].Value.ToString();
                        }
                    }
                }
            }
            catch (Exception)
            {
                // MessageBox.Show(Ex.Message);
                ;
            }
            return(true);
        }
コード例 #6
0
ファイル: CellInfoWindow.cs プロジェクト: huamanhtuyen/VNACCS
        public CellInfoWindow(SuperGridControl superGrid, GridCell cell)
        {
            InitializeComponent();

            TopLevel = false;

            _SuperGrid = superGrid;
            _Cell = cell;

            _ToolTip = new System.Windows.Forms.ToolTip();

            using (GraphicsPath path = GetImageGraphicsPath())
                Region = new Region(path);

            Paint += CellInfoWindowPaint;
            MouseClick += CellInfoWindowMouseClick;
            MouseDoubleClick += CellInfoWindowMouseDoubleClick;

            MouseEnter += CellInfoWindowMouseEnter;
            MouseLeave += CellInfoWindowMouseLeave;
        }
コード例 #7
0
ファイル: SampleExpr.cs プロジェクト: huamanhtuyen/VNACCS
        internal string GetRtbText(SuperGridControl superGrid)
        {
            using (LocalizationManager lm = new LocalizationManager(superGrid))
            {
                string s = lm.GetLocalizedString(LocalizationKeys.SuperGridFilterSampleExpr);

                if (s == "")
                {
                    using (Stream stream = typeof(SampleExpr).Assembly.GetManifestResourceStream(
                        "DevComponents.DotNetBar.SuperGrid.SampleExpr.rtf"))
                    {
                        if (stream != null)
                        {
                            using (StreamReader reader = new StreamReader(stream))
                                s = reader.ReadToEnd();
                        }
                    }
                }

                return (s);
            }
        }
コード例 #8
0
 public void llena_detalle_tratamiento(String codigo, String consultorio, SuperGridControl grid_medicos, SuperGridControl grid_mtos)
 {
     String consulta_m = consultas[G_MED]+" WHERE NUMERO_CONSULTORIO="+consultorio;
     SPG.llena_superGrid_con(consulta_m, grid_medicos);
     llena_detalle("MXTC", codigo, grid_mtos);
 }
コード例 #9
0
 public void llena_detalle(String detalle,String clave,SuperGridControl sgrid)
 {
     String consulta = "";
     if (detalle == "MXTC")
     {
         consulta = "SELECT CODIGO_TRATAMIENTO AS \"Tratamiento\",ID AS \"ID\",NOMBRE_COMPUESTO AS \"Compuesto\","
                    + "PRESENTACION AS \"Presentación\",CONTENIDO AS \"Contenido\",VIA_ADMINISTRACION AS \"Vía de administración\","
                    + "CBP AS \"c.b.p\" FROM MXTC INNER JOIN MEDICAMENTOC ON MXTC.ID_MEDICAMENTO=MEDICAMENTOC.ID WHERE CODIGO_TRATAMIENTO=" + clave;
         SPG.llena_superGrid_con(consulta, sgrid);
     }
     else if (detalle == "MXRF")
          {
              consulta = "SELECT ID AS \"ID\",NOMBRE_COMPUESTO AS \"Compuesto\",PRESENTACION AS \"Presentación\",CONTENIDO AS \"Contenido\","
                         + "VIA_ADMINISTRACION AS \"Vía de administración\",CBP AS \"c.b.p\", DOSIS AS \"Dosis\" FROM MXRF INNER JOIN MEDICAMENTOF "
                         + "ON MXRF.ID_MEDICAMENTO=MEDICAMENTOF.ID WHERE NUMERO_RECETA=" + clave;
              SO.llena_superGrid_con(consulta, sgrid);
          }
 }
コード例 #10
0
ファイル: Sitio.cs プロジェクト: jluisacosta/Clinic-Module
 public void llena_superGrid_con(String consulta, SuperGridControl super_grid)
 {
     DataSet data_set = new DataSet();
     dame_dataset_de(consulta, data_set);
     super_grid.PrimaryGrid.DataSource = data_set;
 }
コード例 #11
0
        /// <summary>
        /// 将supergrid导出为Excel(OleDb 方式操作)
        /// </summary>
        /// <param name="gridView"></param>
        /// <param name="isShowExcle"></param>
        /// <returns></returns>
        public static void superGridToExcel(DevComponents.DotNetBar.SuperGrid.SuperGridControl gridView, string fileName)
        {
            SaveFileDialog saveFileDialog = new SaveFileDialog();

            saveFileDialog.Filter   = "xls files (*.xls)|*.xls";
            saveFileDialog.FileName = fileName;
            if (saveFileDialog.ShowDialog() == DialogResult.OK)
            {
                fileName = saveFileDialog.FileName;
                if (File.Exists(fileName))
                {
                    try
                    {
                        File.Delete(fileName);
                    }
                    catch
                    {
                        MessageBox.Show("该文件正在使用中,关闭文件或重新命名导出文件再试!");
                        return;
                    }
                }
                OleDbConnection oleDbConn = new OleDbConnection();
                OleDbCommand    oleDbCmd  = new OleDbCommand();
                string          sSql      = "";
                try
                {
                    //Microsoft.Jet.OleDb.4.0
                    oleDbConn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileName + @";Extended ProPerties=""Excel 12.0;HDR=Yes;""";
                    oleDbConn.Open();
                    oleDbCmd.CommandType = CommandType.Text;
                    oleDbCmd.Connection  = oleDbConn;
                    sSql = "CREATE TABLE sheet1 (";
                    for (int i = 0; i < gridView.PrimaryGrid.Columns.Count; i++)
                    {
                        // 字段名称出现关键字会导致错误。
                        if (i < gridView.PrimaryGrid.Columns.Count - 1)
                        {
                            sSql += "[" + gridView.PrimaryGrid.Columns[i].HeaderText + Convert.ToString(i) + "] TEXT(100) ,";
                        }
                        else
                        {
                            sSql += "[" + gridView.PrimaryGrid.Columns[i].HeaderText + Convert.ToString(i) + "] TEXT(200) )";
                        }
                    }
                    oleDbCmd.CommandText = sSql;
                    oleDbCmd.ExecuteNonQuery();
                    GridRow gr = null;
                    for (int i = 0; i < gridView.PrimaryGrid.Rows.Count; i++)
                    {
                        //dr = gridView.PrimaryGrid.Rows[i];
                        gr   = (GridRow)gridView.PrimaryGrid.Rows[i];
                        sSql = "INSERT INTO sheet1 VALUES('";
                        for (int j = 0; j < gridView.PrimaryGrid.Columns.Count; j++)
                        {
                            GridCell   gcl = gr[j];
                            GridColumn gc  = gridView.PrimaryGrid.Columns[j];
                            //瓷质
                            if (gr[j].FormattedValue != "")// gc.DataPropertyName == "FMaterial")
                            {
                                if (j < gridView.PrimaryGrid.Columns.Count - 1)
                                {
                                    sSql += gr[j].FormattedValue.ToString() + " ','";
                                }
                                else
                                {
                                    sSql += gr[j].FormattedValue.ToString() + " ')";
                                }
                            }
                            else
                            {
                                if (j < gridView.PrimaryGrid.Columns.Count - 1)
                                {
                                    sSql += gr[j].Value.ToString() + " ','";
                                }
                                else
                                {
                                    sSql += gr[j].Value.ToString() + " ')";
                                }
                            }
                        }
                        oleDbCmd.CommandText = sSql;
                        oleDbCmd.ExecuteNonQuery();
                    }
                    MessageBox.Show("导出EXCEL成功");
                }
                catch (Exception ex)
                {
                    MessageBox.Show("导出EXCEL失败:" + ex.Message);
                }
                finally
                {
                    oleDbCmd.Dispose();
                    oleDbConn.Close();
                    oleDbConn.Dispose();
                }
            }
        }
コード例 #12
0
        private void LoadLocalizedStrings(SuperGridControl sg)
        {
            if (_localizedStringsLoaded == false)
            {
                using (LocalizationManager lm = new LocalizationManager(sg))
                {
                    string s;

                    if ((s = lm.GetLocalizedString(LocalizationKeys.SuperGridFilterByRelativeDate)) != "")
                        _filterByRelativeDateString = s;

                    if ((s = lm.GetLocalizedString(LocalizationKeys.SuperGridFilterBySpecificDate)) != "")
                        _filterBySpecificDateString = s;

                    if ((s = lm.GetLocalizedString(LocalizationKeys.SuperGridFilterByDateRange)) != "")
                        _filterByDateRangeString = s;

                    if ((s = lm.GetLocalizedString(LocalizationKeys.SuperGridFilterCurrentMonth)) != "")
                        _currentMonth = s;

                    if ((s = lm.GetLocalizedString(LocalizationKeys.SuperGridFilterCurrentYear)) != "")
                        _currentYear = s;

                    if ((s = lm.GetLocalizedString(LocalizationKeys.SuperGridFilterLastMonthPeriod)) != "")
                        _lastMonthPeriod = s;

                    if ((s = lm.GetLocalizedString(LocalizationKeys.SuperGridFilterLast3MonthPeriod)) != "")
                        _last3MonthPeriod = s;

                    if ((s = lm.GetLocalizedString(LocalizationKeys.SuperGridFilterLast6MonthPeriod)) != "")
                        _last6MonthPeriod = s;

                    if ((s = lm.GetLocalizedString(LocalizationKeys.SuperGridFilterLast9MonthPeriod)) != "")
                        _last9MonthPeriod = s;

                    if ((s = lm.GetLocalizedString(LocalizationKeys.SuperGridFilterLastYear)) != "")
                        _lastYear = s;

                    if ((s = lm.GetLocalizedString(LocalizationKeys.SuperGridFilterLast5YearPeriod)) != "")
                        _last5YearPeriod = s;

                    if ((s = lm.GetLocalizedString(LocalizationKeys.SuperGridFilterLast10YearPeriod)) != "")
                        _last10YearPeriod = s;
                }

                _localizedStringsLoaded = true;
            }
        }
コード例 #13
0
ファイル: CustomFilterEx.cs プロジェクト: huamanhtuyen/VNACCS
        private void LoadLocalizedStrings(SuperGridControl sg)
        {
            if (_localizedStringsLoaded == false)
            {
                using (LocalizationManager lm = new LocalizationManager(sg))
                {
                    string s;

                    if ((s = lm.GetLocalizedString(LocalizationKeys.SuperGridFilterCustomHelp)) != "")
                        _filterHelpString = s;

                    if ((s = lm.GetLocalizedString(LocalizationKeys.SuperGridFilterEnterExpr)) != "")
                        _filterEnterExprString = s;

                    if ((s = lm.GetLocalizedString(LocalizationKeys.SuperGridFilterClear)) != "")
                        _filterClearString = s;

                    if ((s = lm.GetLocalizedString(LocalizationKeys.SuperGridFilterReset)) != "")
                        _filterResetString = s;

                    if ((s = lm.GetLocalizedString(LocalizationKeys.SuperGridFilterCustomFilter)) != "")
                        _filterCustomFilterString = s;

                    if ((s = lm.GetLocalizedString(LocalizationKeys.SuperGridNewFilterExpr)) != "")
                        _newFilterExprString = s;

                    if ((s = lm.GetLocalizedString(LocalizationKeys.SuperGridNewFilter)) != "")
                        _newFilterString = s;

                    if ((s = lm.GetLocalizedString(LocalizationKeys.SuperGridDeleteFilter)) != "")
                        _deleteFilterString = s;

                    if ((s = lm.GetLocalizedString(LocalizationKeys.SuperGridFilterName)) != "")
                        _filterNameString = s;

                    if ((s = lm.GetLocalizedString(LocalizationKeys.SuperGridFilterDescription)) != "")
                        _filterDescriptionString = s;

                    if ((s = lm.GetLocalizedString(LocalizationKeys.SuperGridShowInFilterPopup)) != "")
                        _showInFilterPopupString = s;

                    if ((s = lm.GetLocalizedString(LocalizationKeys.SuperGridFilterHelpTitle)) != "")
                        _filterHelpTitle = s;
                }

                _localizedStringsLoaded = true;
            }
        }
コード例 #14
0
ファイル: CustomFilterEx.cs プロジェクト: huamanhtuyen/VNACCS
        private void PositionWindow(SuperGridControl superGrid)
        {
            if (_size != Size.Empty)
                Size = _size;

            Form form = superGrid.FindForm();

            if (form != null)
            {
                Point pt = form.Location;

                if (_offset != Point.Empty)
                {
                    pt.Offset(_offset);

                    Location = pt;
                }
                else
                {
                    Screen screen = Screen.FromControl(form);

                    int boundWidth = screen.Bounds.Width;
                    int boundHeight = screen.Bounds.Height;

                    int x = boundWidth - Width;
                    int y = boundHeight - Height;

                    Location = new Point(screen.Bounds.X + x / 2, screen.Bounds.Y + y / 2);
                }
            }

            _LockedResize = false;
        }
コード例 #15
0
ファイル: GridElement.cs プロジェクト: huamanhtuyen/VNACCS
        private SuperGridControl GetParentSuperGrid()
        {
            if (_SuperGrid != null)
                return (_SuperGrid);

            GridElement parent = _Parent;

            while (parent != null)
            {
                if (parent.SuperGrid != null)
                    return (_SuperGrid = parent.SuperGrid);

                parent = parent.Parent;
            }

            return (null);
        }
コード例 #16
0
ファイル: CustomFilter.cs プロジェクト: huamanhtuyen/VNACCS
        private void LoadLocalizedStrings(SuperGridControl sg)
        {
            if (_localizedStringsLoaded == false)
            {
                using (LocalizationManager lm = new LocalizationManager(sg))
                {
                    string s;

                    if ((s = lm.GetLocalizedString(LocalizationKeys.SuperGridFilterCustomHelp)) != "")
                        _filterHelpString = s;

                    if ((s = lm.GetLocalizedString(LocalizationKeys.SuperGridFilterEnterExpr)) != "")
                        _filterEnterExprString = s;

                    if ((s = lm.GetLocalizedString(LocalizationKeys.SuperGridFilterClear)) != "")
                        _filterClearString = s;

                    if ((s = lm.GetLocalizedString(LocalizationKeys.SuperGridFilterCustomFilter)) != "")
                        _filterCustomFilterString = s;

                    if ((s = lm.GetLocalizedString(LocalizationKeys.SuperGridFilterHelpTitle)) != "")
                        _filterHelpTitle = s;
                }

                _localizedStringsLoaded = true;
            }
        }