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; }
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); }
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; } }
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; } }
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; } }
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; } }
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); } } }
public void ChangeBinding() { this.bindingSourceKONTO.DataSource = this.KONTOController.DataSet; this.dsKONTODataSet1 = this.KONTOController.DataSet; }
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(); }
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; } }