public TablicniRazmjestajSredstava() { base.Load += new EventHandler(this.IznosiNabave_Load); this.ds = new S_OS_STANJE_LOKACIJADataSet(); this.dalok = new LOKACIJEDataAdapter(); this.dslokacije = new LOKACIJEDataSet(); this.daStanje = new S_OS_STANJE_LOKACIJADataAdapter(); this.m_cmDisable = true; this.dsosnovna = new OSDataSet(); this.daosnovna = new OSDataAdapter(); this.InitializeComponent(); }
public void DosImportHandler(object sender, EventArgs e) { int num = 0; OSDataSet dataSet = new OSDataSet(); OSDataAdapter adapter2 = new OSDataAdapter(); if (Interaction.MsgBox("Ukoliko prebacujete OS pritisnite tipku <YES>", MsgBoxStyle.YesNo, "Osnovna sredstva / SI") == MsgBoxResult.Yes) { num = 1; } else { num = 2; } if (Interaction.MsgBox("Postojeća OS biti će obrisane, želite li stvarno nastaviti???", MsgBoxStyle.YesNo, "Osnovna sredstva / SI") != MsgBoxResult.No) { IEnumerator enumerator = null; try { enumerator = this.userControlDataGridOS.DataGrid.DataSet.OS.Rows.GetEnumerator(); while (enumerator.MoveNext()) { ((DataRow)enumerator.Current).Delete(); } } finally { if (enumerator is IDisposable) { (enumerator as IDisposable).Dispose(); } } AMSKUPINEDataSet set3 = new AMSKUPINEDataSet(); new AMSKUPINEDataAdapter().Fill(set3); adapter2.Update(this.userControlDataGridOS.DataGrid.DataSet); OpenFileDialog dialog = new OpenFileDialog { InitialDirectory = @"c:\", Filter = "txt files (*.dbf)|*.dbf|All files (*.*)|*.*", FilterIndex = 2, RestoreDirectory = true }; if (dialog.ShowDialog() == DialogResult.OK) { OleDbDataAdapter adapter; string str3 = dialog.FileName.ToUpper().Replace(@"\OSM.DBF", ""); string prompt = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + str3 + ";Extended Properties=dBase IV;"; Interaction.MsgBox(prompt, MsgBoxStyle.OkOnly, null); OleDbConnection selectConnection = new OleDbConnection(prompt); if (Interaction.MsgBox("Želite li prebaciti i sredstva sa količinom 0", MsgBoxStyle.YesNo, null) == MsgBoxResult.Yes) { adapter = new OleDbDataAdapter("select * FROM OSM", selectConnection); } else { adapter = new OleDbDataAdapter("select * FROM OSM where KOLU > 0", selectConnection); } DataSet set2 = new DataSet(); adapter.Fill(set2, "OSA"); if (Interaction.MsgBox("Broj pronađenih zapisa: " + Conversions.ToString(set2.Tables["OSA"].Rows.Count) + "\r\n\r\nŽelite li zadržati importirane zapise?", MsgBoxStyle.YesNo, null) == MsgBoxResult.No) { set2.RejectChanges(); } else { IEnumerator enumerator2 = null; int num2 = 1; try { enumerator2 = set2.Tables["OSA"].Rows.GetEnumerator(); while (enumerator2.MoveNext()) { DataRow current = (DataRow)enumerator2.Current; DataRow row = dataSet.OS.NewRow(); if (!Information.IsDBNull(RuntimeHelpers.GetObjectValue(current["SIFRA"]))) { DateTime now; DateTime time2; string str4 = string.Empty; string str6 = string.Empty; string str5 = string.Empty; if (!Information.IsDBNull(RuntimeHelpers.GetObjectValue(current["NAZIV"]))) { str5 = DB.Ko437to852(Conversions.ToString(current["NAZIV"])).Substring(0, DB.Ko437to852(Conversions.ToString(current["NAZIV"])).Length - 1); } else { str5 = "Nije postojao upisani naziv"; } if (!Information.IsDBNull(RuntimeHelpers.GetObjectValue(current["DATUM"]))) { now = Conversions.ToDate(Interaction.IIf(Information.IsDate(RuntimeHelpers.GetObjectValue(current["DATUM"])), Conversions.ToDate(current["DATUM"]), DateTime.Now)); } else { now = DateTime.Now; } if (!Information.IsDBNull(RuntimeHelpers.GetObjectValue(current["DATUMUP"]))) { time2 = Conversions.ToDate(Interaction.IIf(Information.IsDate(RuntimeHelpers.GetObjectValue(current["DATUMUP"])), Conversions.ToDate(current["DATUMUP"]), DateTime.Now)); } else { time2 = DateTime.Now; } if (DateTime.Compare(time2, Conversions.ToDate("01/01/1754")) < 0) { time2 = DateTime.Now; } if (DateTime.Compare(now, Conversions.ToDate("01/01/1754")) < 0) { now = DateTime.Now; } if (!Information.IsDBNull(RuntimeHelpers.GetObjectValue(current["AMORT"]))) { str6 = Conversions.ToString(current["AMORT"]); } else { str6 = ""; } if (!Information.IsDBNull(RuntimeHelpers.GetObjectValue(current["NAPOMENA"]))) { str4 = DB.Ko437to852(Conversions.ToString(current["NAPOMENA"])).Substring(0, DB.Ko437to852(Conversions.ToString(current["NAPOMENA"])).Length - 1); } else { str4 = "Nije postojala upisana napomena"; } row["invbroj"] = Conversions.ToInteger(current["SIFRA"]); row["nazivos"] = Strings.Left(str5, 0x31); row["datumnabavke"] = now; row["datumuporabe"] = time2; if (set3.AMSKUPINE.Select("kratkasifra = '" + str6 + "'").Length == 0) { row["idamskupine"] = 0x270f; } else { row["idamskupine"] = RuntimeHelpers.GetObjectValue(set3.AMSKUPINE.Select("kratkasifra = '" + str6 + "'")[0]["idamskupine"]); } row["idosvrsta"] = num; row["napomenaos"] = Strings.Left(str4, 0x31); dataSet.OS.Rows.Add(row); DataRow row4 = dataSet.OSTEMELJNICA.NewRow(); row4["invbroj"] = Conversions.ToInteger(current["SIFRA"]); row4["idosdokument"] = 1; row4["osbrojdokumenta"] = 0; row4["osdatumdok"] = time2; row4["oskolicina"] = Convert.ToInt32(DB.N20(RuntimeHelpers.GetObjectValue(current["KOLU"]))); row4["osstopa"] = 0; row4["ososnovica"] = 0; if (Convert.ToInt32(DB.N20(RuntimeHelpers.GetObjectValue(current["KOLU"]))) > 0) { row4["osduguje"] = decimal.Multiply(DB.N20(RuntimeHelpers.GetObjectValue(current["NABVRI"])), new decimal(Convert.ToInt32(DB.N20(RuntimeHelpers.GetObjectValue(current["KOLU"]))))); } else { row4["osduguje"] = DB.N20(RuntimeHelpers.GetObjectValue(current["NABVRI"])); } row4["ospotrazuje"] = 0; row4["osOPIS"] = "PS-Nabavna"; dataSet.OSTEMELJNICA.Rows.Add(row4); row4 = dataSet.OSTEMELJNICA.NewRow(); row4["invbroj"] = Conversions.ToInteger(current["SIFRA"]); row4["idosdokument"] = 2; row4["osbrojdokumenta"] = 0; row4["osdatumdok"] = time2; row4["oskolicina"] = Convert.ToInt32(DB.N20(RuntimeHelpers.GetObjectValue(current["KOLU"]))); row4["osstopa"] = 0; row4["ososnovica"] = 0; row4["osduguje"] = 0; if (Convert.ToInt32(DB.N20(RuntimeHelpers.GetObjectValue(current["KOLU"]))) > 0) { row4["ospotrazuje"] = decimal.Multiply(DB.N20(RuntimeHelpers.GetObjectValue(current["ISPVRI"])), new decimal(Convert.ToInt32(DB.N20(RuntimeHelpers.GetObjectValue(current["KOLU"]))))); } else { row4["ospotrazuje"] = DB.N20(RuntimeHelpers.GetObjectValue(current["ISPVRI"])); } row4["osOPIS"] = "PS-Ispravak"; dataSet.OSTEMELJNICA.Rows.Add(row4); num2++; try { adapter2.Update(dataSet); continue; } catch (System.Exception exception1) { throw exception1; //continue; } } } } finally { if (enumerator2 is IDisposable) { (enumerator2 as IDisposable).Dispose(); } } MessageBox.Show("Importiranje OS/SI završeno!", "Import", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); adapter2.Fill(this.userControlDataGridOS.DataGrid.DataSet); } } } }