public void PretraziHandler(object sender, EventArgs e) { System.Drawing.Point point = new System.Drawing.Point(Cursor.Position.X, Cursor.Position.Y); UltraGrid dataGrid = new UltraGrid(); dataGrid = this.userControlDataGridKONTO.DataGrid; ExtendedWindowSmartPartInfo smartPartInfo = new ExtendedWindowSmartPartInfo { StartPosition = FormStartPosition.CenterParent, Modal = true, ControlBox = false, Title = "Unesite tekst za pretraživanje", Icon = ImageResourcesNew.mbs }; ExtendedWindowWorkspace workspace = new ExtendedWindowWorkspace(); UnosPojma smartPart = this.Controller.WorkItem.Items.AddNew <UnosPojma>(); workspace.Show(smartPart, smartPartInfo); if (smartPart.ParentForm.DialogResult == DialogResult.OK) { ColumnEnumerator enumerator = dataGrid.DisplayLayout.Bands[0].Columns.GetEnumerator(); while (enumerator.MoveNext()) { if (enumerator.Current.DataType.ToString() == "System.String") { dataGrid.DisplayLayout.Bands[0].ColumnFilters["IDKONTO"].FilterConditions.Add(FilterComparisionOperator.Contains, smartPart.UneseniString); } } } }
public void KontirajHandler(object sender, EventArgs e) { SHEMADDDataAdapter adapter = new SHEMADDDataAdapter(); SHEMADDDataSet dataSet = new SHEMADDDataSet(); GKSTAVKADataSet set2 = new GKSTAVKADataSet(); GKSTAVKADataAdapter adapter3 = new GKSTAVKADataAdapter(); int num = Conversions.ToInteger(Operators.AddObject(this.NUMERACIJA(), 1)); SHEMADDSelectionListWorkItem item = this.Controller.WorkItem.Items.AddNew <SHEMADDSelectionListWorkItem>("test"); DataRow row3 = item.ShowModal(true, "", null); item.Terminate(); if (row3 != null) { DataRow row2; DataRow current; IEnumerator enumerator = null; this.OPIS = "test"; this.OPIS = this.m_opisobracuna + " " + this.MJESECOBRACUNA + "/" + this.GODINAOBRACUNA + " šifra obr. " + this.m_idobracun; adapter.FillByIDSHEMADD(dataSet, Conversions.ToInteger(row3["idshemadd"])); decimal num2 = Conversions.ToDecimal(this.DsTotaliUstanove1.Tables[1].Rows[0]["uKUPNOBRUTO"]); if (dataSet.SHEMADDSHEMADDSTANDARD.Select("idddvrsteiznosa=8").Length > 0) { row2 = set2.GKSTAVKA.NewRow(); row2["datumdokumenta"] = DateAndTime.Today; row2["brojdokumenta"] = num; row2["brojstavke"] = 1; row2["iddokument"] = 0x3e6; row2["OPIS"] = this.OPIS; row2["zatvoreniiznos"] = 0; row2["statusgk"] = 0; row2["IDKONTO"] = RuntimeHelpers.GetObjectValue(dataSet.SHEMADDSHEMADDSTANDARD.Select("idddvrsteiznosa=8")[0]["KONTODDVRSTAIZNOSAIDKONTO"]); row2["IDMJESTOTROSKA"] = RuntimeHelpers.GetObjectValue(dataSet.SHEMADDSHEMADDSTANDARD.Select("idddvrsteiznosa=8")[0]["MTDDVRSTAIZNOSAIDMJESTOTROSKA"]); row2["IDORGJED"] = RuntimeHelpers.GetObjectValue(dataSet.SHEMADD.Rows[0]["SHEMADDOJIDORGJED"]); row2["GKGODIDGODINE"] = mipsed.application.framework.Application.ActiveYear; if (Operators.ConditionalCompareObjectEqual(dataSet.SHEMADDSHEMADDSTANDARD.Select("idddvrsteiznosa=8")[0]["STRANEDDVRSTEIZNOSAIDSTRANEKNJIZENJA"], 1, false)) { row2["duguje"] = RuntimeHelpers.GetObjectValue(this.DsTotaliUstanove1.Tables[1].Rows[0]["uKUPNOBRUTO"]); row2["potrazuje"] = 0; } else { row2["potrazuje"] = RuntimeHelpers.GetObjectValue(this.DsTotaliUstanove1.Tables[1].Rows[0]["uKUPNOBRUTO"]); row2["duguje"] = 0; } set2.GKSTAVKA.Rows.Add(row2); } S_DD_REKAP_DOPRINOSDataAdapter adapter2 = new S_DD_REKAP_DOPRINOSDataAdapter(); S_DD_REKAP_DOPRINOSDataSet set3 = new S_DD_REKAP_DOPRINOSDataSet(); adapter2.Fill(set3, this.m_idobracun); try { enumerator = dataSet.SHEMADDSHEMADDDOPRINOS.Rows.GetEnumerator(); while (enumerator.MoveNext()) { current = (DataRow)enumerator.Current; if (set3.S_DD_REKAP_DOPRINOS.Select(Conversions.ToString(Operators.ConcatenateObject("sifra = ", current["SHEMADDDOPRINOSIDDOPRINOS"]))).Length > 0) { row2 = set2.GKSTAVKA.NewRow(); row2["datumdokumenta"] = DateAndTime.Today; row2["brojdokumenta"] = num; row2["brojstavke"] = 1; row2["iddokument"] = 0x3e6; row2["OPIS"] = this.OPIS; row2["zatvoreniiznos"] = 0; row2["statusgk"] = 0; row2["IDKONTO"] = RuntimeHelpers.GetObjectValue(current["KONTODOPIDKONTO"]); row2["IDMJESTOTROSKA"] = RuntimeHelpers.GetObjectValue(current["MTDOPIDMJESTOTROSKA"]); row2["IDORGJED"] = RuntimeHelpers.GetObjectValue(dataSet.SHEMADD.Rows[0]["SHEMADDOJIDORGJED"]); row2["GKGODIDGODINE"] = mipsed.application.framework.Application.ActiveYear; if (Operators.ConditionalCompareObjectEqual(current["STRANEDOPIDSTRANEKNJIZENJA"], 1, false)) { row2["duguje"] = RuntimeHelpers.GetObjectValue(set3.S_DD_REKAP_DOPRINOS.Select(Conversions.ToString(Operators.ConcatenateObject("sifra = ", current["SHEMADDDOPRINOSIDDOPRINOS"])))[0]["iznos"]); row2["potrazuje"] = 0; } else { row2["potrazuje"] = RuntimeHelpers.GetObjectValue(set3.S_DD_REKAP_DOPRINOS.Select(Conversions.ToString(Operators.ConcatenateObject("sifra = ", current["SHEMADDDOPRINOSIDDOPRINOS"])))[0]["iznos"]); row2["duguje"] = 0; } set2.GKSTAVKA.Rows.Add(row2); } } } finally { if (enumerator is IDisposable) { (enumerator as IDisposable).Dispose(); } } foreach (DataRow row in dataSet.SHEMADDSHEMADDSTANDARD.Select("idddvrsteiznosa=9")) { row2 = set2.GKSTAVKA.NewRow(); row2["datumdokumenta"] = DateAndTime.Today; row2["brojdokumenta"] = num; row2["brojstavke"] = 1; row2["iddokument"] = 0x3e6; row2["OPIS"] = this.OPIS; row2["zatvoreniiznos"] = 0; row2["statusgk"] = 0; row2["IDKONTO"] = RuntimeHelpers.GetObjectValue(row["KONTODDVRSTAIZNOSAIDKONTO"]); row2["IDMJESTOTROSKA"] = RuntimeHelpers.GetObjectValue(row["MTDDVRSTAIZNOSAIDMJESTOTROSKA"]); row2["IDORGJED"] = RuntimeHelpers.GetObjectValue(dataSet.SHEMADD.Rows[0]["SHEMADDOJIDORGJED"]); row2["GKGODIDGODINE"] = mipsed.application.framework.Application.ActiveYear; if (Operators.ConditionalCompareObjectEqual(row["STRANEDDVRSTEIZNOSAIDSTRANEKNJIZENJA"], 1, false)) { row2["duguje"] = RuntimeHelpers.GetObjectValue(this.DsTotaliUstanove1.Tables[1].Rows[0]["ukupnoporez"]); row2["potrazuje"] = 0; } else { row2["potrazuje"] = RuntimeHelpers.GetObjectValue(this.DsTotaliUstanove1.Tables[1].Rows[0]["ukupnoporez"]); row2["duguje"] = 0; } set2.GKSTAVKA.Rows.Add(row2); } foreach (DataRow row in dataSet.SHEMADDSHEMADDSTANDARD.Select("idddvrsteiznosa=10")) { row2 = set2.GKSTAVKA.NewRow(); row2["datumdokumenta"] = DateAndTime.Today; row2["brojdokumenta"] = num; row2["brojstavke"] = 1; row2["iddokument"] = 0x3e6; row2["OPIS"] = this.OPIS; row2["zatvoreniiznos"] = 0; row2["statusgk"] = 0; row2["IDKONTO"] = RuntimeHelpers.GetObjectValue(row["KONTODDVRSTAIZNOSAIDKONTO"]); row2["IDMJESTOTROSKA"] = RuntimeHelpers.GetObjectValue(row["MTDDVRSTAIZNOSAIDMJESTOTROSKA"]); row2["IDORGJED"] = RuntimeHelpers.GetObjectValue(dataSet.SHEMADD.Rows[0]["SHEMADDOJIDORGJED"]); row2["GKGODIDGODINE"] = mipsed.application.framework.Application.ActiveYear; if (Operators.ConditionalCompareObjectEqual(row["STRANEDDVRSTEIZNOSAIDSTRANEKNJIZENJA"], 1, false)) { row2["duguje"] = RuntimeHelpers.GetObjectValue(this.DsTotaliUstanove1.Tables[1].Rows[0]["ukupnoprirez"]); row2["potrazuje"] = 0; } else { row2["potrazuje"] = RuntimeHelpers.GetObjectValue(this.DsTotaliUstanove1.Tables[1].Rows[0]["ukupnoprirez"]); row2["duguje"] = 0; } set2.GKSTAVKA.Rows.Add(row2); } foreach (DataRow row in dataSet.SHEMADDSHEMADDSTANDARD.Select("idddvrsteiznosa=11")) { row2 = set2.GKSTAVKA.NewRow(); row2["datumdokumenta"] = DateAndTime.Today; row2["brojdokumenta"] = num; row2["brojstavke"] = 1; row2["iddokument"] = 0x3e6; row2["OPIS"] = this.OPIS; row2["zatvoreniiznos"] = 0; row2["statusgk"] = 0; row2["IDKONTO"] = RuntimeHelpers.GetObjectValue(row["KONTODDVRSTAIZNOSAIDKONTO"]); row2["IDMJESTOTROSKA"] = RuntimeHelpers.GetObjectValue(row["MTDDVRSTAIZNOSAIDMJESTOTROSKA"]); row2["IDORGJED"] = RuntimeHelpers.GetObjectValue(dataSet.SHEMADD.Rows[0]["SHEMADDOJIDORGJED"]); row2["GKGODIDGODINE"] = mipsed.application.framework.Application.ActiveYear; if (Operators.ConditionalCompareObjectEqual(row["STRANEDDVRSTEIZNOSAIDSTRANEKNJIZENJA"], 1, false)) { row2["duguje"] = RuntimeHelpers.GetObjectValue(this.DsTotaliUstanove1.Tables[1].Rows[0]["porezkrizni"]); row2["potrazuje"] = 0; } else { row2["potrazuje"] = RuntimeHelpers.GetObjectValue(this.DsTotaliUstanove1.Tables[1].Rows[0]["porezkrizni"]); row2["duguje"] = 0; } set2.GKSTAVKA.Rows.Add(row2); } foreach (DataRow row in dataSet.SHEMADDSHEMADDSTANDARD.Select("idddvrsteiznosa=12")) { row2 = set2.GKSTAVKA.NewRow(); row2["datumdokumenta"] = DateAndTime.Today; row2["brojdokumenta"] = num; row2["brojstavke"] = 1; row2["iddokument"] = 0x3e6; row2["OPIS"] = this.OPIS; row2["zatvoreniiznos"] = 0; row2["statusgk"] = 0; row2["IDKONTO"] = RuntimeHelpers.GetObjectValue(row["KONTODDVRSTAIZNOSAIDKONTO"]); row2["IDMJESTOTROSKA"] = RuntimeHelpers.GetObjectValue(row["MTDDVRSTAIZNOSAIDMJESTOTROSKA"]); row2["IDORGJED"] = RuntimeHelpers.GetObjectValue(dataSet.SHEMADD.Rows[0]["SHEMADDOJIDORGJED"]); row2["GKGODIDGODINE"] = mipsed.application.framework.Application.ActiveYear; if (Operators.ConditionalCompareObjectEqual(row["STRANEDDVRSTEIZNOSAIDSTRANEKNJIZENJA"], 1, false)) { row2["duguje"] = Operators.SubtractObject(this.DsTotaliUstanove1.Tables[1].Rows[0]["netoplaca"], this.DsTotaliUstanove1.Tables[1].Rows[0]["porezkrizni"]); row2["potrazuje"] = 0; } else { row2["potrazuje"] = Operators.SubtractObject(this.DsTotaliUstanove1.Tables[1].Rows[0]["netoplaca"], this.DsTotaliUstanove1.Tables[1].Rows[0]["porezkrizni"]); row2["duguje"] = 0; } set2.GKSTAVKA.Rows.Add(row2); } foreach (DataRow row in dataSet.SHEMADDSHEMADDSTANDARD.Select("idddvrsteiznosa=14")) { row2 = set2.GKSTAVKA.NewRow(); row2["datumdokumenta"] = DateAndTime.Today; row2["brojdokumenta"] = num; row2["brojstavke"] = 1; row2["iddokument"] = 0x3e6; row2["OPIS"] = this.OPIS; row2["zatvoreniiznos"] = 0; row2["statusgk"] = 0; row2["IDKONTO"] = RuntimeHelpers.GetObjectValue(row["KONTODDVRSTAIZNOSAIDKONTO"]); row2["IDMJESTOTROSKA"] = RuntimeHelpers.GetObjectValue(row["MTDDVRSTAIZNOSAIDMJESTOTROSKA"]); row2["IDORGJED"] = RuntimeHelpers.GetObjectValue(dataSet.SHEMADD.Rows[0]["SHEMADDOJIDORGJED"]); row2["GKGODIDGODINE"] = mipsed.application.framework.Application.ActiveYear; if (Operators.ConditionalCompareObjectEqual(row["STRANEDDVRSTEIZNOSAIDSTRANEKNJIZENJA"], 1, false)) { row2["duguje"] = Operators.AddObject(this.DsTotaliUstanove1.Tables[1].Rows[0]["uKUPNOBRUTO"], this.DsTotaliUstanove1.Tables[1].Rows[0]["ukupnodoprinosina"]); row2["potrazuje"] = 0; } else { row2["potrazuje"] = Operators.AddObject(this.DsTotaliUstanove1.Tables[1].Rows[0]["uKUPNOBRUTO"], this.DsTotaliUstanove1.Tables[1].Rows[0]["ukupnodoprinosina"]); row2["duguje"] = 0; } set2.GKSTAVKA.Rows.Add(row2); } ExtendedWindowSmartPartInfo smartPartInfo = new ExtendedWindowSmartPartInfo { StartPosition = FormStartPosition.CenterParent, Modal = true, ControlBox = false, Title = "Pretpregled temeljnice prije knjiženja", Icon = ImageResourcesNew.mbs }; ExtendedWindowWorkspace workspace = new ExtendedWindowWorkspace(); PregledTemeljnice smartPart = this.Controller.WorkItem.Items.AddNew <PregledTemeljnice>(); smartPart.GkstavkaDataSet1.Merge(set2); workspace.Show(smartPart, smartPartInfo); if (smartPart.ParentForm.DialogResult == DialogResult.OK) { IEnumerator enumerator2 = null; try { enumerator2 = set2.GKSTAVKA.GetEnumerator(); while (enumerator2.MoveNext()) { current = (DataRow)enumerator2.Current; current.BeginEdit(); current["datumdokumenta"] = RuntimeHelpers.GetObjectValue(smartPart.datumdok.Value); current.EndEdit(); } } finally { if (enumerator2 is IDisposable) { (enumerator2 as IDisposable).Dispose(); } } adapter3.Update(set2); Interaction.MsgBox("Knjiženje uspješno izvršeno. Kreiran je broj dokumenta: " + Conversions.ToString(num), MsgBoxStyle.Information, "MBS.Complete"); } } }