Exemplo n.º 1
0
        public void ViewSHEMADD(DataRow row)
        {
            SHEMADDSelectionListWorkItem item = this.WorkItem.Items.AddNew <SHEMADDSelectionListWorkItem>();

            item.ShowModal(false, "FillBySHEMADDOJIDORGJED", row);
            item.Terminate();
            this.WorkItem.Activate();
        }
Exemplo n.º 2
0
        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");
                }
            }
        }