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;
}
}
