Пример #1
0
        private void frmObracunPrihodaProracun_Load(object sender, EventArgs e)
        {
            IEnumerator enumerator = null;

            this.analitika = mipsed.application.framework.Application.Analitika();
            KONTODataSet dataSet = new KONTODataSet();

            new KONTODataAdapter().Fill(dataSet);
            try
            {
                enumerator = dataSet.KONTO.Rows.GetEnumerator();
                while (enumerator.MoveNext())
                {
                    DataRow current = (DataRow)enumerator.Current;
                    if (current["idkonto"].ToString().Length >= this.analitika)
                    {
                        this.KontoDataSet1.KONTO.ImportRow(current);
                    }
                }
            }
            finally
            {
                if (enumerator is IDisposable)
                {
                    (enumerator as IDisposable).Dispose();
                }
            }
            InfraCustom.InicijalizirajCombo(this.CmbDugovniKontoUltraCombo, null);
            InfraCustom.InicijalizirajCombo(this.CmbPotrazniKontoUltraCombo, null);
            this.CmbDugovniKontoUltraCombo.Value  = this.midkontoduguje;
            this.CmbPotrazniKontoUltraCombo.Value = this.midkontopotrazuje;
        }
Пример #2
0
 public virtual void Fill()
 {
     this.PreFill();
     this.dsKONTODataSet1 = new KONTODataSet();
     this.m_StartRow      = 0;
     this.Cursor          = Cursors.WaitCursor;
     this.m_GridLoading   = true;
     ThreadPool.QueueUserWorkItem(new WaitCallback(this.FillDataThread), Thread.CurrentPrincipal);
 }
Пример #3
0
        private void SetComboBoxColumnProperties(bool setColumnsWidth)
        {
            if (DataAdapterFactory.Provider == null)
            {
                DataAdapterFactory.Provider = new SimpleDataAdapterFactory();
            }
            DataSet dataSet = new ORGJEDDataSet();

            if (DataAdapterFactory.Provider != null)
            {
                DataAdapterFactory.GetORGJEDDataAdapter().Fill(dataSet);
            }
            System.Data.DataView dataList = new System.Data.DataView(dataSet.Tables["ORGJED"])
            {
                Sort = "oj"
            };
            CreateValueList(this.DataGrid, "ORGJEDSHEMAPLOJIDORGJED", dataList, "IDORGJED", "oj");
            UltraGridColumn column10 = this.DataGrid.DisplayLayout.Bands["SHEMAPLACA"].Columns["SHEMAPLOJIDORGJED"];

            column10.Style     = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            column10.ValueList = this.DataGrid.DisplayLayout.ValueLists["ORGJEDSHEMAPLOJIDORGJED"];
            if (setColumnsWidth)
            {
                column10.Width = 370;
            }
            DataSet set = new KONTODataSet();

            if (DataAdapterFactory.Provider != null)
            {
                DataAdapterFactory.GetKONTODataAdapter().Fill(set);
            }
            System.Data.DataView view = new System.Data.DataView(set.Tables["KONTO"])
            {
                Sort = "KONT"
            };
            CreateValueList(this.DataGrid, "KONTOKONTODOPIDKONTO", view, "IDKONTO", "KONT");
            UltraGridColumn column = this.DataGrid.DisplayLayout.Bands["SHEMAPLACA_SHEMAPLACASHEMAPLACADOP"].Columns["KONTODOPIDKONTO"];

            column.Style     = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            column.ValueList = this.DataGrid.DisplayLayout.ValueLists["KONTOKONTODOPIDKONTO"];
            if (setColumnsWidth)
            {
                column.Width = 370;
            }
            DataSet set2 = new MJESTOTROSKADataSet();

            if (DataAdapterFactory.Provider != null)
            {
                DataAdapterFactory.GetMJESTOTROSKADataAdapter().Fill(set2);
            }
            System.Data.DataView view2 = new System.Data.DataView(set2.Tables["MJESTOTROSKA"])
            {
                Sort = "mt"
            };
            CreateValueList(this.DataGrid, "MJESTOTROSKAMTDOPIDMJESTOTROSKA", view2, "IDMJESTOTROSKA", "mt");
            UltraGridColumn column2 = this.DataGrid.DisplayLayout.Bands["SHEMAPLACA_SHEMAPLACASHEMAPLACADOP"].Columns["MTDOPIDMJESTOTROSKA"];

            column2.Style     = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            column2.ValueList = this.DataGrid.DisplayLayout.ValueLists["MJESTOTROSKAMTDOPIDMJESTOTROSKA"];
            if (setColumnsWidth)
            {
                column2.Width = 370;
            }
            DataSet set3 = new STRANEKNJIZENJADataSet();

            if (DataAdapterFactory.Provider != null)
            {
                DataAdapterFactory.GetSTRANEKNJIZENJADataAdapter().Fill(set3);
            }
            System.Data.DataView view3 = new System.Data.DataView(set3.Tables["STRANEKNJIZENJA"])
            {
                Sort = "NAZIVSTRANEKNJIZENJA"
            };
            CreateValueList(this.DataGrid, "STRANEKNJIZENJASTRANEDOPIDSTRANEKNJIZENJA", view3, "IDSTRANEKNJIZENJA", "NAZIVSTRANEKNJIZENJA");
            UltraGridColumn column3 = this.DataGrid.DisplayLayout.Bands["SHEMAPLACA_SHEMAPLACASHEMAPLACADOP"].Columns["STRANEDOPIDSTRANEKNJIZENJA"];

            column3.Style     = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            column3.ValueList = this.DataGrid.DisplayLayout.ValueLists["STRANEKNJIZENJASTRANEDOPIDSTRANEKNJIZENJA"];
            if (setColumnsWidth)
            {
                column3.Width = 280;
            }
            DataSet set4 = new KONTODataSet();

            if (DataAdapterFactory.Provider != null)
            {
                DataAdapterFactory.GetKONTODataAdapter().Fill(set4);
            }
            System.Data.DataView view4 = new System.Data.DataView(set4.Tables["KONTO"])
            {
                Sort = "KONT"
            };
            CreateValueList(this.DataGrid, "KONTOKONTOELEMENTIDKONTO", view4, "IDKONTO", "KONT");
            UltraGridColumn column4 = this.DataGrid.DisplayLayout.Bands["SHEMAPLACA_SHEMAPLACASHEMAPLACAELEMENT"].Columns["KONTOELEMENTIDKONTO"];

            column4.Style     = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            column4.ValueList = this.DataGrid.DisplayLayout.ValueLists["KONTOKONTOELEMENTIDKONTO"];
            if (setColumnsWidth)
            {
                column4.Width = 370;
            }
            DataSet set6 = new STRANEKNJIZENJADataSet();

            if (DataAdapterFactory.Provider != null)
            {
                DataAdapterFactory.GetSTRANEKNJIZENJADataAdapter().Fill(set6);
            }
            System.Data.DataView view6 = new System.Data.DataView(set6.Tables["STRANEKNJIZENJA"])
            {
                Sort = "NAZIVSTRANEKNJIZENJA"
            };
            CreateValueList(this.DataGrid, "STRANEKNJIZENJASTRANEELEMENTIDSTRANEKNJIZENJA", view6, "IDSTRANEKNJIZENJA", "NAZIVSTRANEKNJIZENJA");
            UltraGridColumn column6 = this.DataGrid.DisplayLayout.Bands["SHEMAPLACA_SHEMAPLACASHEMAPLACAELEMENT"].Columns["STRANEELEMENTIDSTRANEKNJIZENJA"];

            column6.Style     = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            column6.ValueList = this.DataGrid.DisplayLayout.ValueLists["STRANEKNJIZENJASTRANEELEMENTIDSTRANEKNJIZENJA"];
            if (setColumnsWidth)
            {
                column6.Width = 280;
            }
            DataSet set5 = new MJESTOTROSKADataSet();

            if (DataAdapterFactory.Provider != null)
            {
                DataAdapterFactory.GetMJESTOTROSKADataAdapter().Fill(set5);
            }
            System.Data.DataView view5 = new System.Data.DataView(set5.Tables["MJESTOTROSKA"])
            {
                Sort = "mt"
            };
            CreateValueList(this.DataGrid, "MJESTOTROSKAMTELEMENTIDMJESTOTROSKA", view5, "IDMJESTOTROSKA", "mt");
            UltraGridColumn column5 = this.DataGrid.DisplayLayout.Bands["SHEMAPLACA_SHEMAPLACASHEMAPLACAELEMENT"].Columns["MTELEMENTIDMJESTOTROSKA"];

            column5.Style     = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            column5.ValueList = this.DataGrid.DisplayLayout.ValueLists["MJESTOTROSKAMTELEMENTIDMJESTOTROSKA"];
            if (setColumnsWidth)
            {
                column5.Width = 370;
            }
            DataSet set7 = new KONTODataSet();

            if (DataAdapterFactory.Provider != null)
            {
                DataAdapterFactory.GetKONTODataAdapter().Fill(set7);
            }
            System.Data.DataView view7 = new System.Data.DataView(set7.Tables["KONTO"])
            {
                Sort = "KONT"
            };
            CreateValueList(this.DataGrid, "KONTOKONTOPLACAVRSTAIZNOSAIDKONTO", view7, "IDKONTO", "KONT");
            UltraGridColumn column7 = this.DataGrid.DisplayLayout.Bands["SHEMAPLACA_SHEMAPLACASHEMAPLACASTANDARD"].Columns["KONTOPLACAVRSTAIZNOSAIDKONTO"];

            column7.Style     = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            column7.ValueList = this.DataGrid.DisplayLayout.ValueLists["KONTOKONTOPLACAVRSTAIZNOSAIDKONTO"];
            if (setColumnsWidth)
            {
                column7.Width = 370;
            }
            DataSet set8 = new MJESTOTROSKADataSet();

            if (DataAdapterFactory.Provider != null)
            {
                DataAdapterFactory.GetMJESTOTROSKADataAdapter().Fill(set8);
            }
            System.Data.DataView view8 = new System.Data.DataView(set8.Tables["MJESTOTROSKA"])
            {
                Sort = "mt"
            };
            CreateValueList(this.DataGrid, "MJESTOTROSKAMTPLACAVRSTAIZNOSAIDMJESTOTROSKA", view8, "IDMJESTOTROSKA", "mt");
            UltraGridColumn column8 = this.DataGrid.DisplayLayout.Bands["SHEMAPLACA_SHEMAPLACASHEMAPLACASTANDARD"].Columns["MTPLACAVRSTAIZNOSAIDMJESTOTROSKA"];

            column8.Style     = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            column8.ValueList = this.DataGrid.DisplayLayout.ValueLists["MJESTOTROSKAMTPLACAVRSTAIZNOSAIDMJESTOTROSKA"];
            if (setColumnsWidth)
            {
                column8.Width = 370;
            }
            DataSet set9 = new STRANEKNJIZENJADataSet();

            if (DataAdapterFactory.Provider != null)
            {
                DataAdapterFactory.GetSTRANEKNJIZENJADataAdapter().Fill(set9);
            }
            System.Data.DataView view9 = new System.Data.DataView(set9.Tables["STRANEKNJIZENJA"])
            {
                Sort = "NAZIVSTRANEKNJIZENJA"
            };
            CreateValueList(this.DataGrid, "STRANEKNJIZENJASTRANEVRSTEIZNOSAIDSTRANEKNJIZENJA", view9, "IDSTRANEKNJIZENJA", "NAZIVSTRANEKNJIZENJA");
            UltraGridColumn column9 = this.DataGrid.DisplayLayout.Bands["SHEMAPLACA_SHEMAPLACASHEMAPLACASTANDARD"].Columns["STRANEVRSTEIZNOSAIDSTRANEKNJIZENJA"];

            column9.Style     = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            column9.ValueList = this.DataGrid.DisplayLayout.ValueLists["STRANEKNJIZENJASTRANEVRSTEIZNOSAIDSTRANEKNJIZENJA"];
            if (setColumnsWidth)
            {
                column9.Width = 280;
            }
        }
Пример #4
0
        private void SetComboBoxColumnProperties(bool setColumnsWidth)
        {
            if (DataAdapterFactory.Provider == null)
            {
                DataAdapterFactory.Provider = new SimpleDataAdapterFactory();
            }
            DataSet dataSet = new PARTNERDataSet();

            if (DataAdapterFactory.Provider != null)
            {
                DataAdapterFactory.GetPARTNERDataAdapter().Fill(dataSet);
            }
            System.Data.DataView dataList = new System.Data.DataView(dataSet.Tables["PARTNER"])
            {
                Sort = "PT"
            };
            CreateValueList(this.DataGrid, "PARTNERPARTNERSHEMAURAIDPARTNER", dataList, "IDPARTNER", "PT");
            UltraGridColumn column = this.DataGrid.DisplayLayout.Bands["SHEMAURA"].Columns["PARTNERSHEMAURAIDPARTNER"];

            column.Style     = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            column.ValueList = this.DataGrid.DisplayLayout.ValueLists["PARTNERPARTNERSHEMAURAIDPARTNER"];
            if (setColumnsWidth)
            {
                column.Width = 370;
            }
            DataSet set3 = new KONTODataSet();

            if (DataAdapterFactory.Provider != null)
            {
                DataAdapterFactory.GetKONTODataAdapter().Fill(set3);
            }
            System.Data.DataView view3 = new System.Data.DataView(set3.Tables["KONTO"])
            {
                Sort = "KONT"
            };
            CreateValueList(this.DataGrid, "KONTOSHEMAURAKONTOIDKONTO", view3, "IDKONTO", "KONT");
            UltraGridColumn column3 = this.DataGrid.DisplayLayout.Bands["SHEMAURA_SHEMAURASHEMAURAKONTIRANJE"].Columns["SHEMAURAKONTOIDKONTO"];

            column3.Style     = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            column3.ValueList = this.DataGrid.DisplayLayout.ValueLists["KONTOSHEMAURAKONTOIDKONTO"];
            if (setColumnsWidth)
            {
                column3.Width = 370;
            }
            DataSet set6 = new STRANEKNJIZENJADataSet();

            if (DataAdapterFactory.Provider != null)
            {
                DataAdapterFactory.GetSTRANEKNJIZENJADataAdapter().Fill(set6);
            }
            System.Data.DataView view6 = new System.Data.DataView(set6.Tables["STRANEKNJIZENJA"])
            {
                Sort = "NAZIVSTRANEKNJIZENJA"
            };
            CreateValueList(this.DataGrid, "STRANEKNJIZENJASHEMAURASTRANEIDSTRANEKNJIZENJA", view6, "IDSTRANEKNJIZENJA", "NAZIVSTRANEKNJIZENJA");
            UltraGridColumn column6 = this.DataGrid.DisplayLayout.Bands["SHEMAURA_SHEMAURASHEMAURAKONTIRANJE"].Columns["SHEMAURASTRANEIDSTRANEKNJIZENJA"];

            column6.Style     = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            column6.ValueList = this.DataGrid.DisplayLayout.ValueLists["STRANEKNJIZENJASHEMAURASTRANEIDSTRANEKNJIZENJA"];
            if (setColumnsWidth)
            {
                column6.Width = 280;
            }
            DataSet set2 = new URAVRSTAIZNOSADataSet();

            if (DataAdapterFactory.Provider != null)
            {
                DataAdapterFactory.GetURAVRSTAIZNOSADataAdapter().Fill(set2);
            }
            System.Data.DataView view2 = new System.Data.DataView(set2.Tables["URAVRSTAIZNOSA"])
            {
                Sort = "URAVRSTAIZNOSANAZIV"
            };
            CreateValueList(this.DataGrid, "URAVRSTAIZNOSAIDURAVRSTAIZNOSA", view2, "IDURAVRSTAIZNOSA", "URAVRSTAIZNOSANAZIV");
            UltraGridColumn column2 = this.DataGrid.DisplayLayout.Bands["SHEMAURA_SHEMAURASHEMAURAKONTIRANJE"].Columns["IDURAVRSTAIZNOSA"];

            column2.Style     = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            column2.ValueList = this.DataGrid.DisplayLayout.ValueLists["URAVRSTAIZNOSAIDURAVRSTAIZNOSA"];
            if (setColumnsWidth)
            {
                column2.Width = 280;
            }
            DataSet set4 = new MJESTOTROSKADataSet();

            if (DataAdapterFactory.Provider != null)
            {
                DataAdapterFactory.GetMJESTOTROSKADataAdapter().Fill(set4);
            }
            System.Data.DataView view4 = new System.Data.DataView(set4.Tables["MJESTOTROSKA"])
            {
                Sort = "mt"
            };
            CreateValueList(this.DataGrid, "MJESTOTROSKASHEMAURAMTIDMJESTOTROSKA", view4, "IDMJESTOTROSKA", "mt");
            UltraGridColumn column4 = this.DataGrid.DisplayLayout.Bands["SHEMAURA_SHEMAURASHEMAURAKONTIRANJE"].Columns["SHEMAURAMTIDMJESTOTROSKA"];

            column4.Style     = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            column4.ValueList = this.DataGrid.DisplayLayout.ValueLists["MJESTOTROSKASHEMAURAMTIDMJESTOTROSKA"];
            if (setColumnsWidth)
            {
                column4.Width = 370;
            }
            DataSet set5 = new ORGJEDDataSet();

            if (DataAdapterFactory.Provider != null)
            {
                DataAdapterFactory.GetORGJEDDataAdapter().Fill(set5);
            }
            System.Data.DataView view5 = new System.Data.DataView(set5.Tables["ORGJED"])
            {
                Sort = "oj"
            };
            CreateValueList(this.DataGrid, "ORGJEDSHEMAURAOJIDORGJED", view5, "IDORGJED", "oj");
            UltraGridColumn column5 = this.DataGrid.DisplayLayout.Bands["SHEMAURA_SHEMAURASHEMAURAKONTIRANJE"].Columns["SHEMAURAOJIDORGJED"];

            column5.Style     = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            column5.ValueList = this.DataGrid.DisplayLayout.ValueLists["ORGJEDSHEMAURAOJIDORGJED"];
            if (setColumnsWidth)
            {
                column5.Width = 370;
            }
        }
Пример #5
0
        private void SetComboBoxColumnProperties(bool setColumnsWidth)
        {
            if (DataAdapterFactory.Provider == null)
            {
                DataAdapterFactory.Provider = new SimpleDataAdapterFactory();
            }
            DataSet dataSet = new ORGJEDDataSet();

            if (DataAdapterFactory.Provider != null)
            {
                DataAdapterFactory.GetORGJEDDataAdapter().Fill(dataSet);
            }
            System.Data.DataView dataList = new System.Data.DataView(dataSet.Tables["ORGJED"])
            {
                Sort = "oj"
            };
            CreateValueList(this.DataGrid, "ORGJEDPLANOJIDORGJED", dataList, "IDORGJED", "oj");
            UltraGridColumn column3 = this.DataGrid.DisplayLayout.Bands["PLAN_PLANORG"].Columns["PLANOJIDORGJED"];

            column3.Style     = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            column3.ValueList = this.DataGrid.DisplayLayout.ValueLists["ORGJEDPLANOJIDORGJED"];
            if (setColumnsWidth)
            {
                column3.Width = 370;
            }
            DataSet set2 = new ORGJEDDataSet();

            if (DataAdapterFactory.Provider != null)
            {
                DataAdapterFactory.GetORGJEDDataAdapter().Fill(set2);
            }
            System.Data.DataView view2 = new System.Data.DataView(set2.Tables["ORGJED"])
            {
                Sort = "oj"
            };
            CreateValueList(this.DataGrid, "ORGJEDPLANOJIDORGJED", view2, "IDORGJED", "oj");
            UltraGridColumn column2 = this.DataGrid.DisplayLayout.Bands["PLANORG_PLANORGKON"].Columns["PLANOJIDORGJED"];

            column2.Style     = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            column2.ValueList = this.DataGrid.DisplayLayout.ValueLists["ORGJEDPLANOJIDORGJED"];
            if (setColumnsWidth)
            {
                column2.Width = 370;
            }
            DataSet set = new KONTODataSet();

            if (DataAdapterFactory.Provider != null)
            {
                DataAdapterFactory.GetKONTODataAdapter().Fill(set);
            }
            System.Data.DataView view = new System.Data.DataView(set.Tables["KONTO"])
            {
                Sort = "KONT"
            };
            CreateValueList(this.DataGrid, "KONTOPLANKONTOIDKONTO", view, "IDKONTO", "KONT");
            UltraGridColumn column = this.DataGrid.DisplayLayout.Bands["PLANORG_PLANORGKON"].Columns["PLANKONTOIDKONTO"];

            column.Style     = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            column.ValueList = this.DataGrid.DisplayLayout.ValueLists["KONTOPLANKONTOIDKONTO"];
            if (setColumnsWidth)
            {
                column.Width = 370;
            }
        }
Пример #6
0
        private void SetComboBoxColumnProperties(bool setColumnsWidth)
        {
            if (DataAdapterFactory.Provider == null)
            {
                DataAdapterFactory.Provider = new SimpleDataAdapterFactory();
            }
            DataSet dataSet = new DOKUMENTDataSet();

            if (DataAdapterFactory.Provider != null)
            {
                DataAdapterFactory.GetDOKUMENTDataAdapter().Fill(dataSet);
            }
            System.Data.DataView dataList = new System.Data.DataView(dataSet.Tables["DOKUMENT"])
            {
                Sort = "NAZIVDOKUMENT"
            };
            CreateValueList(this.DataGrid, "DOKUMENTBLGDOKIDDOKUMENT", dataList, "IDDOKUMENT", "NAZIVDOKUMENT");
            UltraGridColumn column = this.DataGrid.DisplayLayout.Bands["BLAGAJNA"].Columns["BLGDOKIDDOKUMENT"];

            column.Style     = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            column.ValueList = this.DataGrid.DisplayLayout.ValueLists["DOKUMENTBLGDOKIDDOKUMENT"];
            if (setColumnsWidth)
            {
                column.Width = 370;
            }
            DataSet set2 = new KONTODataSet();

            if (DataAdapterFactory.Provider != null)
            {
                DataAdapterFactory.GetKONTODataAdapter().Fill(set2);
            }
            System.Data.DataView view2 = new System.Data.DataView(set2.Tables["KONTO"])
            {
                Sort = "KONT"
            };
            CreateValueList(this.DataGrid, "KONTOBLGKONTOIDKONTO", view2, "IDKONTO", "KONT");
            UltraGridColumn column2 = this.DataGrid.DisplayLayout.Bands["BLAGAJNA"].Columns["BLGKONTOIDKONTO"];

            column2.Style     = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            column2.ValueList = this.DataGrid.DisplayLayout.ValueLists["KONTOBLGKONTOIDKONTO"];
            if (setColumnsWidth)
            {
                column2.Width = 370;
            }
            DataSet set3 = new DOKUMENTDataSet();

            if (DataAdapterFactory.Provider != null)
            {
                DataAdapterFactory.GetDOKUMENTDataAdapter().Fill(set3);
            }
            System.Data.DataView view3 = new System.Data.DataView(set3.Tables["DOKUMENT"])
            {
                Sort = "NAZIVDOKUMENT"
            };
            CreateValueList(this.DataGrid, "DOKUMENTBLGDOKIDDOKUMENT", view3, "IDDOKUMENT", "NAZIVDOKUMENT");
            UltraGridColumn column3 = this.DataGrid.DisplayLayout.Bands["BLAGAJNA_BLAGAJNAStavkeBlagajne"].Columns["BLGDOKIDDOKUMENT"];

            column3.Style     = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            column3.ValueList = this.DataGrid.DisplayLayout.ValueLists["DOKUMENTBLGDOKIDDOKUMENT"];
            if (setColumnsWidth)
            {
                column3.Width = 370;
            }
            DataSet set4 = new DOKUMENTDataSet();

            if (DataAdapterFactory.Provider != null)
            {
                DataAdapterFactory.GetDOKUMENTDataAdapter().Fill(set4);
            }
            System.Data.DataView view4 = new System.Data.DataView(set4.Tables["DOKUMENT"])
            {
                Sort = "NAZIVDOKUMENT"
            };
            CreateValueList(this.DataGrid, "DOKUMENTBLGDOKIDDOKUMENT", view4, "IDDOKUMENT", "NAZIVDOKUMENT");
            UltraGridColumn column4 = this.DataGrid.DisplayLayout.Bands["BLAGAJNAStavkeBlagajne_BLAGAJNAStavkeBlagajneStavkeBlagajneKontiranje"].Columns["BLGDOKIDDOKUMENT"];

            column4.Style     = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            column4.ValueList = this.DataGrid.DisplayLayout.ValueLists["DOKUMENTBLGDOKIDDOKUMENT"];
            if (setColumnsWidth)
            {
                column4.Width = 370;
            }
            DataSet set7 = new KONTODataSet();

            if (DataAdapterFactory.Provider != null)
            {
                DataAdapterFactory.GetKONTODataAdapter().Fill(set7);
            }
            System.Data.DataView view7 = new System.Data.DataView(set7.Tables["KONTO"])
            {
                Sort = "KONT"
            };
            CreateValueList(this.DataGrid, "KONTOBLGSTAVKEBLAGAJNEKONTOIDKONTO", view7, "IDKONTO", "KONT");
            UltraGridColumn column7 = this.DataGrid.DisplayLayout.Bands["BLAGAJNAStavkeBlagajne_BLAGAJNAStavkeBlagajneStavkeBlagajneKontiranje"].Columns["BLGSTAVKEBLAGAJNEKONTOIDKONTO"];

            column7.Style     = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            column7.ValueList = this.DataGrid.DisplayLayout.ValueLists["KONTOBLGSTAVKEBLAGAJNEKONTOIDKONTO"];
            if (setColumnsWidth)
            {
                column7.Width = 370;
            }
            DataSet set5 = new MJESTOTROSKADataSet();

            if (DataAdapterFactory.Provider != null)
            {
                DataAdapterFactory.GetMJESTOTROSKADataAdapter().Fill(set5);
            }
            System.Data.DataView view5 = new System.Data.DataView(set5.Tables["MJESTOTROSKA"])
            {
                Sort = "mt"
            };
            CreateValueList(this.DataGrid, "MJESTOTROSKABLGMTIDMJESTOTROSKA", view5, "IDMJESTOTROSKA", "mt");
            UltraGridColumn column5 = this.DataGrid.DisplayLayout.Bands["BLAGAJNAStavkeBlagajne_BLAGAJNAStavkeBlagajneStavkeBlagajneKontiranje"].Columns["BLGMTIDMJESTOTROSKA"];

            column5.Style     = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            column5.ValueList = this.DataGrid.DisplayLayout.ValueLists["MJESTOTROSKABLGMTIDMJESTOTROSKA"];
            if (setColumnsWidth)
            {
                column5.Width = 370;
            }
            DataSet set6 = new ORGJEDDataSet();

            if (DataAdapterFactory.Provider != null)
            {
                DataAdapterFactory.GetORGJEDDataAdapter().Fill(set6);
            }
            System.Data.DataView view6 = new System.Data.DataView(set6.Tables["ORGJED"])
            {
                Sort = "oj"
            };
            CreateValueList(this.DataGrid, "ORGJEDBLGORGJEDIDORGJED", view6, "IDORGJED", "oj");
            UltraGridColumn column6 = this.DataGrid.DisplayLayout.Bands["BLAGAJNAStavkeBlagajne_BLAGAJNAStavkeBlagajneStavkeBlagajneKontiranje"].Columns["BLGORGJEDIDORGJED"];

            column6.Style     = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            column6.ValueList = this.DataGrid.DisplayLayout.ValueLists["ORGJEDBLGORGJEDIDORGJED"];
            if (setColumnsWidth)
            {
                column6.Width = 370;
            }
        }
Пример #7
0
        public void PrebaciDOSKontoHandler(object sender, EventArgs e)
        {
            DataSet          dataSet = new DataSet();
            KONTODataSet     set2    = new KONTODataSet();
            KONTODataAdapter adapter = new KONTODataAdapter();

            dataSet.EnforceConstraints = false;
            OpenFileDialog dialog = new OpenFileDialog {
                InitialDirectory = @"c:\",
                Filter           = "txt files (*.dbf)|*.dbf|All files (*.*)|*.*",
                FilterIndex      = 2,
                RestoreDirectory = true
            };

            if (dialog.ShowDialog() == DialogResult.OK)
            {
                string str2   = dialog.FileName.ToUpper().Replace(@"\KONTO.DBF", "");
                string prompt = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + str2 + ";Extended Properties=dBase IV;";
                Interaction.MsgBox(prompt, MsgBoxStyle.OkOnly, null);
                OleDbConnection  selectConnection = new OleDbConnection(prompt);
                OleDbDataAdapter adapter2         = new OleDbDataAdapter("select * from KONTO ORDER BY SIFRA", selectConnection);
                try
                {
                    IEnumerator enumerator = null;
                    adapter2.Fill(dataSet, "POMOCNI");
                    try
                    {
                        enumerator = dataSet.Tables["pomocni"].Rows.GetEnumerator();
                        while (enumerator.MoveNext())
                        {
                            DataRow current = (DataRow)enumerator.Current;
                            DataRow row     = set2.KONTO.NewRow();
                            if (!Information.IsDBNull(RuntimeHelpers.GetObjectValue(current["SIFRA"])))
                            {
                                row["idKONTO"] = DB.Ko437to852(Conversions.ToString(current["SIFRA"]));
                            }
                            if (!Information.IsDBNull(RuntimeHelpers.GetObjectValue(current["NAZIV"])))
                            {
                                row["NAZIVkonto"] = DB.Ko437to852(Conversions.ToString(current["NAZIV"]));
                            }
                            row["idaktivnost"] = 1;
                            try
                            {
                                set2.KONTO.Rows.Add(row);
                                continue;
                            }
                            catch (System.Exception exception1)
                            {
                                throw exception1;
                                //continue;
                            }
                        }
                    }
                    finally
                    {
                        if (enumerator is IDisposable)
                        {
                            (enumerator as IDisposable).Dispose();
                        }
                    }
                    Interaction.MsgBox("Broj importiranih slogova: " + Conversions.ToString(dataSet.Tables["POMOCNI"].Rows.Count), MsgBoxStyle.OkOnly, null);
                    if (Interaction.MsgBox("Želite li zadržati importirane slogove", MsgBoxStyle.OkCancel, null) == MsgBoxResult.Cancel)
                    {
                        dataSet.RejectChanges();
                    }
                    else
                    {
                        try
                        {
                            adapter.Update(set2);
                        }
                        catch (System.Exception exception4)
                        {
                            throw exception4;
                            //System.Exception exception2 = exception4;
                            //Interaction.MsgBox(exception2.Message, MsgBoxStyle.OkOnly, null);
                        }
                    }
                }
                catch (OleDbException exception5)
                {
                    throw exception5;
                    //OleDbException exception3 = exception5;
                    //Interaction.MsgBox("Nije datoteka kontnog plana", MsgBoxStyle.OkOnly, null);
                }
            }
        }
Пример #8
0
 public void ChangeBinding()
 {
     this.bindingSourceKONTO.DataSource = this.KONTOController.DataSet;
     this.dsKONTODataSet1 = this.KONTOController.DataSet;
 }
Пример #9
0
        private void InitializeComponent()
        {
            this.components = new Container();
            ResourceManager manager = new ResourceManager(typeof(KONTOFormUserControl));

            this.contextMenu1            = new ContextMenu();
            this.SetNullItem             = new MenuItem();
            this.toolTip1                = new System.Windows.Forms.ToolTip(this.components);
            this.errorProvider1          = new ErrorProvider();
            this.errorProviderValidator1 = new ErrorProviderValidator(this.components);
            this.bindingSourceKONTO      = new BindingSource(this.components);
            ((ISupportInitialize)this.bindingSourceKONTO).BeginInit();
            this.layoutManagerformKONTO = new TableLayoutPanel();
            this.layoutManagerformKONTO.SuspendLayout();
            this.layoutManagerformKONTO.AutoSize     = true;
            this.layoutManagerformKONTO.Dock         = DockStyle.Fill;
            this.layoutManagerformKONTO.AutoSizeMode = AutoSizeMode.GrowAndShrink;
            this.layoutManagerformKONTO.AutoScroll   = false;
            System.Drawing.Point point = new System.Drawing.Point(0, 0);
            this.layoutManagerformKONTO.Location = point;
            Size size = new System.Drawing.Size(0, 0);

            this.layoutManagerformKONTO.Size        = size;
            this.layoutManagerformKONTO.ColumnCount = 2;
            this.layoutManagerformKONTO.RowCount    = 4;
            this.layoutManagerformKONTO.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle());
            this.layoutManagerformKONTO.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle());
            this.layoutManagerformKONTO.RowStyles.Add(new RowStyle());
            this.layoutManagerformKONTO.RowStyles.Add(new RowStyle());
            this.layoutManagerformKONTO.RowStyles.Add(new RowStyle());
            this.layoutManagerformKONTO.RowStyles.Add(new RowStyle());
            this.label1IDKONTO     = new UltraLabel();
            this.textIDKONTO       = new UltraTextEditor();
            this.label1NAZIVKONTO  = new UltraLabel();
            this.textNAZIVKONTO    = new UltraTextEditor();
            this.label1IDAKTIVNOST = new UltraLabel();
            this.comboIDAKTIVNOST  = new AKTIVNOSTComboBox();
            this.label1KONT        = new UltraLabel();
            this.labelKONT         = new UltraLabel();
            ((ISupportInitialize)this.textIDKONTO).BeginInit();
            ((ISupportInitialize)this.textNAZIVKONTO).BeginInit();
            this.dsKONTODataSet1 = new KONTODataSet();
            this.dsKONTODataSet1.BeginInit();
            this.SuspendLayout();
            this.dsKONTODataSet1.DataSetName   = "dsKONTO";
            this.dsKONTODataSet1.Locale        = new CultureInfo("hr-HR");
            this.bindingSourceKONTO.DataSource = this.dsKONTODataSet1;
            this.bindingSourceKONTO.DataMember = "KONTO";
            ((ISupportInitialize)this.bindingSourceKONTO).BeginInit();
            point = new System.Drawing.Point(0, 0);
            this.label1IDKONTO.Location               = point;
            this.label1IDKONTO.Name                   = "label1IDKONTO";
            this.label1IDKONTO.TabIndex               = 1;
            this.label1IDKONTO.Tag                    = "labelIDKONTO";
            this.label1IDKONTO.Text                   = "Konto:";
            this.label1IDKONTO.StyleSetName           = "FieldUltraLabel";
            this.label1IDKONTO.AutoSize               = true;
            this.label1IDKONTO.Anchor                 = AnchorStyles.Left;
            this.label1IDKONTO.Appearance.TextVAlign  = VAlign.Middle;
            this.label1IDKONTO.Appearance.Image       = RuntimeHelpers.GetObjectValue(manager.GetObject("pictureBoxKey.Image"));
            this.label1IDKONTO.Appearance.ImageHAlign = HAlign.Right;
            size = new System.Drawing.Size(7, 10);
            this.label1IDKONTO.ImageSize            = size;
            this.label1IDKONTO.Appearance.ForeColor = Color.Black;
            this.label1IDKONTO.BackColor            = Color.Transparent;
            this.layoutManagerformKONTO.Controls.Add(this.label1IDKONTO, 0, 0);
            this.layoutManagerformKONTO.SetColumnSpan(this.label1IDKONTO, 1);
            this.layoutManagerformKONTO.SetRowSpan(this.label1IDKONTO, 1);
            Padding padding = new Padding(3, 1, 5, 2);

            this.label1IDKONTO.Margin = padding;
            size = new System.Drawing.Size(0, 0);
            this.label1IDKONTO.MinimumSize = size;
            size = new System.Drawing.Size(0x35, 0x17);
            this.label1IDKONTO.Size = size;
            point = new System.Drawing.Point(0, 0);
            this.textIDKONTO.Location    = point;
            this.textIDKONTO.Name        = "textIDKONTO";
            this.textIDKONTO.Tag         = "IDKONTO";
            this.textIDKONTO.TabIndex    = 0;
            this.textIDKONTO.Anchor      = AnchorStyles.Left;
            this.textIDKONTO.MouseEnter += new EventHandler(this.mouseEnter_Text);
            this.textIDKONTO.ReadOnly    = false;
            this.textIDKONTO.DataBindings.Add(new Binding("Text", this.bindingSourceKONTO, "IDKONTO"));
            this.textIDKONTO.MaxLength = 14;
            this.layoutManagerformKONTO.Controls.Add(this.textIDKONTO, 1, 0);
            this.layoutManagerformKONTO.SetColumnSpan(this.textIDKONTO, 1);
            this.layoutManagerformKONTO.SetRowSpan(this.textIDKONTO, 1);
            padding = new Padding(0, 1, 3, 2);
            this.textIDKONTO.Margin = padding;
            size = new System.Drawing.Size(0x72, 0x16);
            this.textIDKONTO.MinimumSize = size;
            size = new System.Drawing.Size(0x72, 0x16);
            this.textIDKONTO.Size = size;
            point = new System.Drawing.Point(0, 0);
            this.label1NAZIVKONTO.Location              = point;
            this.label1NAZIVKONTO.Name                  = "label1NAZIVKONTO";
            this.label1NAZIVKONTO.TabIndex              = 1;
            this.label1NAZIVKONTO.Tag                   = "labelNAZIVKONTO";
            this.label1NAZIVKONTO.Text                  = "Naziv konta:";
            this.label1NAZIVKONTO.StyleSetName          = "FieldUltraLabel";
            this.label1NAZIVKONTO.AutoSize              = true;
            this.label1NAZIVKONTO.Anchor                = AnchorStyles.Left | AnchorStyles.Top;
            this.label1NAZIVKONTO.Appearance.TextVAlign = VAlign.Middle;
            this.label1NAZIVKONTO.Appearance.ForeColor  = Color.Black;
            this.label1NAZIVKONTO.BackColor             = Color.Transparent;
            this.layoutManagerformKONTO.Controls.Add(this.label1NAZIVKONTO, 0, 1);
            this.layoutManagerformKONTO.SetColumnSpan(this.label1NAZIVKONTO, 1);
            this.layoutManagerformKONTO.SetRowSpan(this.label1NAZIVKONTO, 1);
            padding = new Padding(3, 1, 5, 2);
            this.label1NAZIVKONTO.Margin = padding;
            size = new System.Drawing.Size(0, 0);
            this.label1NAZIVKONTO.MinimumSize = size;
            size = new System.Drawing.Size(0x5c, 0x17);
            this.label1NAZIVKONTO.Size = size;
            point = new System.Drawing.Point(0, 0);
            this.textNAZIVKONTO.Location    = point;
            this.textNAZIVKONTO.Name        = "textNAZIVKONTO";
            this.textNAZIVKONTO.Tag         = "NAZIVKONTO";
            this.textNAZIVKONTO.TabIndex    = 0;
            this.textNAZIVKONTO.Anchor      = AnchorStyles.Left;
            this.textNAZIVKONTO.MouseEnter += new EventHandler(this.mouseEnter_Text);
            this.textNAZIVKONTO.ReadOnly    = false;
            this.textNAZIVKONTO.DataBindings.Add(new Binding("Text", this.bindingSourceKONTO, "NAZIVKONTO"));
            this.textNAZIVKONTO.Multiline = true;
            this.textNAZIVKONTO.MaxLength = 150;
            this.layoutManagerformKONTO.Controls.Add(this.textNAZIVKONTO, 1, 1);
            this.layoutManagerformKONTO.SetColumnSpan(this.textNAZIVKONTO, 1);
            this.layoutManagerformKONTO.SetRowSpan(this.textNAZIVKONTO, 1);
            padding = new Padding(0, 1, 3, 2);
            this.textNAZIVKONTO.Margin = padding;
            size = new System.Drawing.Size(0x240, 0x2c);
            this.textNAZIVKONTO.MinimumSize = size;
            size = new System.Drawing.Size(0x240, 0x2c);
            this.textNAZIVKONTO.Size = size;
            this.textNAZIVKONTO.Dock = DockStyle.Fill;
            point = new System.Drawing.Point(0, 0);
            this.label1IDAKTIVNOST.Location              = point;
            this.label1IDAKTIVNOST.Name                  = "label1IDAKTIVNOST";
            this.label1IDAKTIVNOST.TabIndex              = 1;
            this.label1IDAKTIVNOST.Tag                   = "labelIDAKTIVNOST";
            this.label1IDAKTIVNOST.Text                  = "Šifra aktivnosti:";
            this.label1IDAKTIVNOST.StyleSetName          = "FieldUltraLabel";
            this.label1IDAKTIVNOST.AutoSize              = true;
            this.label1IDAKTIVNOST.Anchor                = AnchorStyles.Left;
            this.label1IDAKTIVNOST.Appearance.TextVAlign = VAlign.Middle;
            this.label1IDAKTIVNOST.Appearance.ForeColor  = Color.Black;
            this.label1IDAKTIVNOST.BackColor             = Color.Transparent;
            this.layoutManagerformKONTO.Controls.Add(this.label1IDAKTIVNOST, 0, 2);
            this.layoutManagerformKONTO.SetColumnSpan(this.label1IDAKTIVNOST, 1);
            this.layoutManagerformKONTO.SetRowSpan(this.label1IDAKTIVNOST, 1);
            padding = new Padding(3, 1, 5, 2);
            this.label1IDAKTIVNOST.Margin = padding;
            size = new System.Drawing.Size(0, 0);
            this.label1IDAKTIVNOST.MinimumSize = size;
            size = new System.Drawing.Size(0x71, 0x17);
            this.label1IDAKTIVNOST.Size = size;
            point = new System.Drawing.Point(0, 0);
            this.comboIDAKTIVNOST.Location                  = point;
            this.comboIDAKTIVNOST.Name                      = "comboIDAKTIVNOST";
            this.comboIDAKTIVNOST.Tag                       = "IDAKTIVNOST";
            this.comboIDAKTIVNOST.TabIndex                  = 0;
            this.comboIDAKTIVNOST.Anchor                    = AnchorStyles.Left;
            this.comboIDAKTIVNOST.MouseEnter               += new EventHandler(this.mouseEnter_Text);
            this.comboIDAKTIVNOST.DropDownStyle             = DropDownStyle.DropDown;
            this.comboIDAKTIVNOST.ComboBox.DropDownStyle    = DropDownStyle.DropDown;
            this.comboIDAKTIVNOST.ComboBox.AutoCompleteMode = Infragistics.Win.AutoCompleteMode.Suggest;
            this.comboIDAKTIVNOST.Enabled                   = true;
            this.comboIDAKTIVNOST.DataBindings.Add(new Binding("Value", this.bindingSourceKONTO, "IDAKTIVNOST"));
            this.comboIDAKTIVNOST.ValueMember       = "IDAKTIVNOST";
            this.comboIDAKTIVNOST.SelectionChanged += new EventHandler(this.SelectedIndexChangedIDAKTIVNOST);
            this.layoutManagerformKONTO.Controls.Add(this.comboIDAKTIVNOST, 1, 2);
            this.layoutManagerformKONTO.SetColumnSpan(this.comboIDAKTIVNOST, 1);
            this.layoutManagerformKONTO.SetRowSpan(this.comboIDAKTIVNOST, 1);
            padding = new Padding(0, 1, 3, 2);
            this.comboIDAKTIVNOST.Margin = padding;
            size = new System.Drawing.Size(0x196, 0x17);
            this.comboIDAKTIVNOST.MinimumSize = size;
            size = new System.Drawing.Size(0x196, 0x17);
            this.comboIDAKTIVNOST.Size = size;
            point = new System.Drawing.Point(0, 0);
            this.label1KONT.Location              = point;
            this.label1KONT.Name                  = "label1KONT";
            this.label1KONT.TabIndex              = 1;
            this.label1KONT.Tag                   = "labelKONT";
            this.label1KONT.Text                  = "KONT:";
            this.label1KONT.StyleSetName          = "FieldUltraLabel";
            this.label1KONT.AutoSize              = true;
            this.label1KONT.Anchor                = AnchorStyles.Left | AnchorStyles.Top;
            this.label1KONT.Appearance.TextVAlign = VAlign.Middle;
            this.label1KONT.Appearance.ForeColor  = Color.Black;
            this.label1KONT.BackColor             = Color.Transparent;
            this.layoutManagerformKONTO.Controls.Add(this.label1KONT, 0, 3);
            this.layoutManagerformKONTO.SetColumnSpan(this.label1KONT, 1);
            this.layoutManagerformKONTO.SetRowSpan(this.label1KONT, 1);
            padding = new Padding(3, 1, 5, 2);
            this.label1KONT.Margin = padding;
            size = new System.Drawing.Size(0, 0);
            this.label1KONT.MinimumSize = size;
            size = new System.Drawing.Size(0x36, 0x17);
            this.label1KONT.Size = size;
            point = new System.Drawing.Point(0, 0);
            this.labelKONT.Location  = point;
            this.labelKONT.Name      = "labelKONT";
            this.labelKONT.Tag       = "KONT";
            this.labelKONT.TabIndex  = 0;
            this.labelKONT.Anchor    = AnchorStyles.Left;
            this.labelKONT.BackColor = Color.Transparent;
            this.labelKONT.DataBindings.Add(new Binding("Text", this.bindingSourceKONTO, "KONT"));
            this.labelKONT.Appearance.TextVAlign = VAlign.Middle;
            this.layoutManagerformKONTO.Controls.Add(this.labelKONT, 1, 3);
            this.layoutManagerformKONTO.SetColumnSpan(this.labelKONT, 1);
            this.layoutManagerformKONTO.SetRowSpan(this.labelKONT, 1);
            padding = new Padding(0, 1, 3, 2);
            this.labelKONT.Margin = padding;
            size = new System.Drawing.Size(0x240, 0x2c);
            this.labelKONT.MinimumSize = size;
            size = new System.Drawing.Size(0x240, 0x2c);
            this.labelKONT.Size = size;
            this.labelKONT.Dock = DockStyle.Fill;
            this.Controls.Add(this.layoutManagerformKONTO);
            this.SetNullItem.Index   = 0;
            this.SetNullItem.Text    = "Set Null";
            this.SetNullItem.Click  += new EventHandler(this.SetNullItem_Click);
            this.contextMenu1.Popup += new EventHandler(this.contextMenu1_Popup);
            this.contextMenu1.MenuItems.AddRange(new MenuItem[] { this.SetNullItem });
            this.errorProvider1.DataSource             = this.bindingSourceKONTO;
            this.errorProviderValidator1.ErrorProvider = this.errorProvider1;
            this.Name       = "KONTOFormUserControl";
            this.Text       = "Kontni plan";
            this.AutoSize   = true;
            this.AutoScroll = true;
            this.Load      += new EventHandler(this.KONTOFormUserControl_Load);
            this.layoutManagerformKONTO.ResumeLayout(false);
            this.layoutManagerformKONTO.PerformLayout();
            ((ISupportInitialize)this.bindingSourceKONTO).EndInit();
            ((ISupportInitialize)this.textIDKONTO).EndInit();
            ((ISupportInitialize)this.textNAZIVKONTO).EndInit();
            this.dsKONTODataSet1.EndInit();
            this.ResumeLayout(false);
            this.PerformLayout();
        }
Пример #10
0
        private void SetComboBoxColumnProperties(bool setColumnsWidth)
        {
            if (DataAdapterFactory.Provider == null)
            {
                DataAdapterFactory.Provider = new SimpleDataAdapterFactory();
            }
            DataSet dataSet = new DOKUMENTDataSet();

            if (DataAdapterFactory.Provider != null)
            {
                DataAdapterFactory.GetDOKUMENTDataAdapter().Fill(dataSet);
            }
            System.Data.DataView dataList = new System.Data.DataView(dataSet.Tables["DOKUMENT"])
            {
                Sort = "NAZIVDOKUMENT"
            };
            CreateValueList(this.DataGrid, "DOKUMENTIDDOKUMENT", dataList, "IDDOKUMENT", "NAZIVDOKUMENT");
            UltraGridColumn column = this.DataGrid.DisplayLayout.Bands["GKSTAVKA"].Columns["IDDOKUMENT"];

            column.Style     = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            column.ValueList = this.DataGrid.DisplayLayout.ValueLists["DOKUMENTIDDOKUMENT"];
            if (setColumnsWidth)
            {
                column.Width = 370;
            }
            DataSet set3 = new MJESTOTROSKADataSet();

            if (DataAdapterFactory.Provider != null)
            {
                DataAdapterFactory.GetMJESTOTROSKADataAdapter().Fill(set3);
            }
            System.Data.DataView view3 = new System.Data.DataView(set3.Tables["MJESTOTROSKA"])
            {
                Sort = "mt"
            };
            CreateValueList(this.DataGrid, "MJESTOTROSKAIDMJESTOTROSKA", view3, "IDMJESTOTROSKA", "mt");
            UltraGridColumn column3 = this.DataGrid.DisplayLayout.Bands["GKSTAVKA"].Columns["IDMJESTOTROSKA"];

            column3.Style     = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            column3.ValueList = this.DataGrid.DisplayLayout.ValueLists["MJESTOTROSKAIDMJESTOTROSKA"];
            if (setColumnsWidth)
            {
                column3.Width = 370;
            }
            DataSet set4 = new ORGJEDDataSet();

            if (DataAdapterFactory.Provider != null)
            {
                DataAdapterFactory.GetORGJEDDataAdapter().Fill(set4);
            }
            System.Data.DataView view4 = new System.Data.DataView(set4.Tables["ORGJED"])
            {
                Sort = "oj"
            };
            CreateValueList(this.DataGrid, "ORGJEDIDORGJED", view4, "IDORGJED", "oj");
            UltraGridColumn column4 = this.DataGrid.DisplayLayout.Bands["GKSTAVKA"].Columns["IDORGJED"];

            column4.Style     = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            column4.ValueList = this.DataGrid.DisplayLayout.ValueLists["ORGJEDIDORGJED"];
            if (setColumnsWidth)
            {
                column4.Width = 370;
            }
            DataSet set2 = new KONTODataSet();

            if (DataAdapterFactory.Provider != null)
            {
                DataAdapterFactory.GetKONTODataAdapter().Fill(set2);
            }
            System.Data.DataView view2 = new System.Data.DataView(set2.Tables["KONTO"])
            {
                Sort = "KONT"
            };
            CreateValueList(this.DataGrid, "KONTOIDKONTO", view2, "IDKONTO", "KONT");
            UltraGridColumn column2 = this.DataGrid.DisplayLayout.Bands["GKSTAVKA"].Columns["IDKONTO"];

            column2.Style     = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            column2.ValueList = this.DataGrid.DisplayLayout.ValueLists["KONTOIDKONTO"];
            if (setColumnsWidth)
            {
                column2.Width = 370;
            }
            DataSet set5 = new PARTNERDataSet();

            if (DataAdapterFactory.Provider != null)
            {
                DataAdapterFactory.GetPARTNERDataAdapter().Fill(set5);
            }
            System.Data.DataView view5 = new System.Data.DataView(set5.Tables["PARTNER"])
            {
                Sort = "PT"
            };
            CreateValueList(this.DataGrid, "PARTNERIDPARTNER", view5, "IDPARTNER", "PT");
            UltraGridColumn column5 = this.DataGrid.DisplayLayout.Bands["GKSTAVKA"].Columns["IDPARTNER"];

            column5.Style     = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList;
            column5.ValueList = this.DataGrid.DisplayLayout.ValueLists["PARTNERIDPARTNER"];
            if (setColumnsWidth)
            {
                column5.Width = 370;
            }
        }