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, "PARTNERIDPARTNER", dataList, "IDPARTNER", "PT"); UltraGridColumn column = this.DataGrid.DisplayLayout.Bands["S_FIN_KARTICEPARTNERA"].Columns["IDPARTNER"]; column.Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList; column.ValueList = this.DataGrid.DisplayLayout.ValueLists["PARTNERIDPARTNER"]; if (setColumnsWidth) { column.Width = 370; } }
public virtual void Fill() { this.PreFill(); this.dsPARTNERDataSet1 = new PARTNERDataSet(); this.m_StartRow = 0; this.Cursor = Cursors.WaitCursor; this.m_GridLoading = true; ThreadPool.QueueUserWorkItem(new WaitCallback(this.FillDataThread), Thread.CurrentPrincipal); }
public virtual int FillPage(DataSet dataSet, int startRow, int maxRows) { this.partnerabecedaSet = (PARTNERDataSet)dataSet; if (this.partnerabecedaSet != null) { return(this.FillPage(this.partnerabecedaSet, startRow, maxRows)); } this.partnerabecedaSet = new PARTNERDataSet(); this.FillPage(this.partnerabecedaSet, startRow, maxRows); dataSet.Merge(this.partnerabecedaSet); return(0); }
public virtual int Fill(DataSet dataSet) { this.partnerabecedaSet = (PARTNERDataSet)dataSet; if (this.partnerabecedaSet != null) { return(this.Fill(this.partnerabecedaSet)); } this.partnerabecedaSet = new PARTNERDataSet(); this.Fill(this.partnerabecedaSet); dataSet.Merge(this.partnerabecedaSet); return(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, "DOKUMENTURADOKIDDOKUMENT", dataList, "IDDOKUMENT", "NAZIVDOKUMENT"); UltraGridColumn column = this.DataGrid.DisplayLayout.Bands["URA"].Columns["URADOKIDDOKUMENT"]; column.Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList; column.ValueList = this.DataGrid.DisplayLayout.ValueLists["DOKUMENTURADOKIDDOKUMENT"]; if (setColumnsWidth) { column.Width = 370; } DataSet set2 = new PARTNERDataSet(); if (DataAdapterFactory.Provider != null) { DataAdapterFactory.GetPARTNERDataAdapter().Fill(set2); } System.Data.DataView view2 = new System.Data.DataView(set2.Tables["PARTNER"]) { Sort = "PT" }; CreateValueList(this.DataGrid, "PARTNERurapartnerIDPARTNER", view2, "IDPARTNER", "PT"); UltraGridColumn column2 = this.DataGrid.DisplayLayout.Bands["URA"].Columns["urapartnerIDPARTNER"]; column2.Style = Infragistics.Win.UltraWinGrid.ColumnStyle.DropDownList; column2.ValueList = this.DataGrid.DisplayLayout.ValueLists["PARTNERurapartnerIDPARTNER"]; if (setColumnsWidth) { column2.Width = 370; } }
public virtual int FillPage(PARTNERDataSet dataSet, int startRow, int maxRows) { this.Initialize(); this.connDefault = this.dsDefault.GetReadWriteConnection(this.daCurrentTransaction); this.partnerabecedaSet = dataSet; this.rowPARTNER = this.partnerabecedaSet.PARTNER.NewPARTNERRow(); this.orderString = GetOrderString(this.Order, true); this.reverseOrderString = GetOrderString(this.Order, false); try { this.executePrivate(startRow, maxRows); } finally { this.Cleanup(); } return(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; } }
public void PrebaciDOSPartnerHandler(object sender, EventArgs e) { DataSet dataSet = new DataSet(); PARTNERDataSet set2 = new PARTNERDataSet(); PARTNERDataAdapter adapter = new PARTNERDataAdapter(); dataSet.EnforceConstraints = true; 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(@"\PARTNER.DBF", ""); OleDbConnection selectConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + str2 + ";Extended Properties=dBase IV;"); OleDbDataAdapter adapter2 = new OleDbDataAdapter("select * from PARTNER", 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.PARTNER.NewRow(); if (!Information.IsDBNull(RuntimeHelpers.GetObjectValue(current["naziv"]))) { row["nazivpartner"] = DB.Ko437to852(Conversions.ToString(current["naziv"])); } if (!Information.IsDBNull(RuntimeHelpers.GetObjectValue(current["adresa"]))) { row["partnerulica"] = DB.Ko437to852(Conversions.ToString(current["adresa"])); } else { row["partnerulica"] = " "; } if (!Information.IsDBNull(RuntimeHelpers.GetObjectValue(current["grad"]))) { row["partnermjesto"] = DB.Ko437to852(Conversions.ToString(current["grad"])); } else { row["partnermjesto"] = " "; } if (!Information.IsDBNull(RuntimeHelpers.GetObjectValue(current["telefon"]))) { row["partnertelefon"] = DB.Ko437to852(Conversions.ToString(current["telefon"])); } else { row["partnertelefon"] = " "; } if (!Information.IsDBNull(RuntimeHelpers.GetObjectValue(current["fax"]))) { row["partnerfax"] = DB.Ko437to852(Conversions.ToString(current["fax"])); } else { row["partnerfax"] = " "; } if (!Information.IsDBNull(RuntimeHelpers.GetObjectValue(current["ziro"]))) { row["partnerziro1"] = DB.Ko437to852(Conversions.ToString(current["ziro"])); } else { row["partnerziro1"] = " "; } if (!Information.IsDBNull(RuntimeHelpers.GetObjectValue(current["matbroj"]))) { row["mb"] = DB.Ko437to852(Conversions.ToString(current["matbroj"])); } else { row["mb"] = " "; } row["idpartner"] = Conversions.ToInteger(current["sifra"]); row["partneroib"] = "00000000000"; try { set2.PARTNER.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(exception3.Message, MsgBoxStyle.OkOnly, null); //Interaction.MsgBox("Nije datoteka partnera", MsgBoxStyle.OkOnly, null); } } }
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; } }